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 281: from per_all_people_f p

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

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

2171: --
2172: begin
2173: delete from per_phones a
2174: where a.parent_id = P_PERSON_ID
2175: and a.parent_table = 'PER_ALL_PEOPLE_F';
2176: exception
2177: when NO_DATA_FOUND then
2178: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 25501);
2179: end;

Line 2656: delete from per_all_people_f

2652: --
2653: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 99);
2654: --
2655: begin
2656: delete from per_all_people_f
2657: where person_id = P_PERSON_ID;
2658: exception
2659: when NO_DATA_FOUND then
2660: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 4401);

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

2831: --
2832: begin
2833: delete from per_phones a
2834: where a.parent_id = P_PERSON_ID
2835: and a.parent_table = 'PER_ALL_PEOPLE_F';
2836: exception
2837: when NO_DATA_FOUND then null;
2838: end;
2839: --

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

3020: --
3021: begin
3022: delete from per_phones a
3023: where a.parent_id = P_PERSON_ID
3024: and a.parent_table = 'PER_ALL_PEOPLE_F';
3025: exception
3026: when NO_DATA_FOUND then null;
3027: end;
3028: --