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 2672: delete from per_checklist_items

2668: -- Added this delete for quickhire checklists
2669: --
2670: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 49);
2671: begin
2672: delete from per_checklist_items
2673: where person_id = P_PERSON_ID;
2674: exception
2675: when NO_DATA_FOUND then null;
2676: end;

Line 2988: delete from per_checklist_items

2984: -- Added this delete for quickhire checklists
2985: --
2986: hr_utility.set_location('HR_PERSON_DELETE.PEOPLE_DEFAULT_DELETES', 17);
2987: begin
2988: delete from per_checklist_items
2989: where person_id = P_PERSON_ID;
2990: exception
2991: when NO_DATA_FOUND then null;
2992: end;

Line 3121: delete from per_checklist_items

3117: -- Added this delete for quickhire checklists
3118: --
3119: hr_utility.set_location('HR_PERSON_DELETE.APPLICANT_DEFAULT_DELETES', 15);
3120: begin
3121: delete from per_checklist_items
3122: where person_id = P_PERSON_ID;
3123: exception
3124: when NO_DATA_FOUND then null;
3125: end;