DBA Data[Home] [Help]

APPS.SSP_DEL_ORPHANED_ROWS dependencies on HR_UTILITY

Line 10: hr_utility.set_location('ssp_del_orphaned_rows',1);

6: if hr_general.g_data_migrator_mode <> 'Y' then
7: --
8: if :old.maternity_id is null then
9: --
10: hr_utility.set_location('ssp_del_orphaned_rows',1);
11: delete from ssp_stoppages
12: where absence_attendance_id = :old.absence_attendance_id;
13: --
14: hr_utility.set_location('ssp_del_orphaned_rows',2);

Line 14: hr_utility.set_location('ssp_del_orphaned_rows',2);

10: hr_utility.set_location('ssp_del_orphaned_rows',1);
11: delete from ssp_stoppages
12: where absence_attendance_id = :old.absence_attendance_id;
13: --
14: hr_utility.set_location('ssp_del_orphaned_rows',2);
15: delete from ssp_medicals
16: where absence_attendance_id = :old.absence_attendance_id;
17: --
18: hr_utility.set_location('ssp_del_orphaned_rows',3);

Line 18: hr_utility.set_location('ssp_del_orphaned_rows',3);

14: hr_utility.set_location('ssp_del_orphaned_rows',2);
15: delete from ssp_medicals
16: where absence_attendance_id = :old.absence_attendance_id;
17: --
18: hr_utility.set_location('ssp_del_orphaned_rows',3);
19: end if;
20: end if;
21: end ssp_del_orphaned_rows;
22: