HRMS Delete Employee’s Absence
HRMS Delete Employee’s Absence
Declare p_validate boolean default false ; p_absence_attendance_id number ; p_object_version_number number ; CURSOR c1 IS SELECT * FROM PER_ABSENCE_ATTENDANCES_V ; -- where person_id = 938 ; BEGIN FOR c1_rec IN c1 LOOP p_validate := false; p_absence_attendance_id := c1_rec.absence_attendance_id ; p_object_version_number := c1_rec.object_version_number; BEGIN apps.hr_person_absence_api.delete_person_absence ( p_validate ,p_absence_attendance_id ,p_object_version_number ); COMMIT; EXCEPTION WHEN OTHERS THEN null; END; END LOOP; END;