APPS.HR_PERSON_DELETE dependencies on PER_ALL_PEOPLE_F

Line 100: PER_PEOPLE_F to PER_ALL_PEOPLE_F

96: 70.19 14-Nov-96 BSanders 410245 Reinstate 70.17
97: 110.01 25-Aug-97 mswanson Remove and aol.person_type = 'E' from
98: aol_predel_validation.
99: 110.2 13-Oct-97 rfine 563034 Changed parent table name from
100: PER_PEOPLE_F to PER_ALL_PEOPLE_F
101: 110.3 06-Nov-97 mmillmor 593864 Added pa validation to moderate delete
102:
103: 110.4 18-Mar-98 fychu 642566 Added code to delete_a_person procedure
104: to delete per_people_extra_info records.

Line 126: per_all_people_f and per_all_assignments_f

122: 115.5 08-SEP-98 smcmilla Disallow delete if orws exist in
123: PER_APPRAISALS or PER_PARTICIPANTS.
124: Change made to moderate_predel...
125: 115.6 17-MAR-1999 mmillmor 814301 Altered DELETE_A_PERSON to delete from
126: per_all_people_f and per_all_assignments_f
127: 115.7 18-MAR-98 CColeman Added WIP pre-del validation.
128: 115.8 13-APR-99 CCarter 800050 Added pre-del validation for the
129: following products ENG, AP, FA, PO
130: and RCV.

Line 282: from per_all_people_f p

278: --
279: BEGIN
280: select count(*)
281: into v_dummy
282: from per_all_people_f p
283: where p.person_id = P_PERSON_ID;
284: exception
285: when NO_DATA_FOUND then
286: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');

Line 2246: and a.parent_table = 'PER_ALL_PEOPLE_F';

2242: --
2243: begin
2244: delete from per_phones a
2245: where a.parent_id = P_PERSON_ID
2246: and a.parent_table = 'PER_ALL_PEOPLE_F';
2247: exception
2248: when NO_DATA_FOUND then
2249: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 25501);
2250: end;

Line 2727: delete from per_all_people_f

2723: --
2724: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 99);
2725: --
2726: begin
2727: delete from per_all_people_f
2728: where person_id = P_PERSON_ID;
2729: exception
2730: when NO_DATA_FOUND then
2731: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 4401);

Line 2907: and a.parent_table = 'PER_ALL_PEOPLE_F';

2903: --
2904: begin
2905: delete from per_phones a
2906: where a.parent_id = P_PERSON_ID
2907: and a.parent_table = 'PER_ALL_PEOPLE_F';
2908: exception
2909: when NO_DATA_FOUND then null;
2910: end;
2911: --

Line 3096: and a.parent_table = 'PER_ALL_PEOPLE_F';

3092: --
3093: begin
3094: delete from per_phones a
3095: where a.parent_id = P_PERSON_ID
3096: and a.parent_table = 'PER_ALL_PEOPLE_F';
3097: exception
3098: when NO_DATA_FOUND then null;
3099: end;
3100: --