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;