APPS.HR_PERSON_DELETE dependencies on PER_CHECKLIST_ITEMS

Line 132: 115.10 22-Nov-99 Rvydyana Added delete of per_checklist_items

128: 115.8 13-APR-99 CCarter 800050 Added pre-del validation for the
129: following products ENG, AP, FA, PO
130: and RCV.
131: 115.9 23-JUL-99 Asahay 941591 Modified v_dummy definition to number(3)
132: 115.10 22-Nov-99 Rvydyana Added delete of per_checklist_items
133: 115.11 10-Mar-00 I Harding Added contracts_check and called it
134: from weak_predel and moderate_predel.
135: Added callto hr_contract_api.maintain_contracts
136: in delete_a_person to remove contracts.

Line 2601: delete from per_checklist_items

2597: -- Added this delete for quickhire checklists
2598: --
2599: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 49);
2600: begin
2601: delete from per_checklist_items
2602: where person_id = P_PERSON_ID;
2603: exception
2604: when NO_DATA_FOUND then null;
2605: end;

Line 2916: delete from per_checklist_items

2912: -- Added this delete for quickhire checklists
2913: --
2914: hr_utility.set_location('HR_PERSON_DELETE.PEOPLE_DEFAULT_DELETES', 17);
2915: begin
2916: delete from per_checklist_items
2917: where person_id = P_PERSON_ID;
2918: exception
2919: when NO_DATA_FOUND then null;
2920: end;

Line 3049: delete from per_checklist_items

3045: -- Added this delete for quickhire checklists
3046: --
3047: hr_utility.set_location('HR_PERSON_DELETE.APPLICANT_DEFAULT_DELETES', 15);
3048: begin
3049: delete from per_checklist_items
3050: where person_id = P_PERSON_ID;
3051: exception
3052: when NO_DATA_FOUND then null;
3053: end;