DECLARE
CURSOR c1
IS
SELECT PERSON_ANALYSIS_ID, OBJECT_VERSION_NUMBER
FROM PER_PERSON_ANALYSES
WHERE TRUNC (CREATION_DATE) = TRUNC (SYSDATE);
BEGIN
FOR r1 IN c1
LOOP
hr_sit_api.delete_sit (
p_person_analysis_id => r1.PERSON_ANALYSIS_ID,
p_pea_object_version_number => r1.OBJECT_VERSION_NUMBER,
p_validate => FALSE
);
END LOOP;
COMMIT;
END;
CURSOR c1
IS
SELECT PERSON_ANALYSIS_ID, OBJECT_VERSION_NUMBER
FROM PER_PERSON_ANALYSES
WHERE TRUNC (CREATION_DATE) = TRUNC (SYSDATE);
BEGIN
FOR r1 IN c1
LOOP
hr_sit_api.delete_sit (
p_person_analysis_id => r1.PERSON_ANALYSIS_ID,
p_pea_object_version_number => r1.OBJECT_VERSION_NUMBER,
p_validate => FALSE
);
END LOOP;
COMMIT;
END;
0 comments: