APPS.HR_PERSON_DELETE dependencies on PER_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 1257: from per_people_f p,

1253: --
1254: -- VT 1403481 09/19/00
1255: select count(*)
1256: into v_person_types
1257: from per_people_f p,
1258: per_person_types ppt
1259: where p.person_id = P_PERSON_ID
1260: and p.effective_end_date >= P_SESSION_DATE
1261: and p.person_type_id = ppt.person_type_id

Line 1264: from per_people_f p2,

1260: and p.effective_end_date >= P_SESSION_DATE
1261: and p.person_type_id = ppt.person_type_id
1262: and exists
1263: (select null
1264: from per_people_f p2,
1265: per_person_types ppt2
1266: where p2.person_id = p.person_id
1267: and p2.effective_end_date >= P_SESSION_DATE
1268: and p2.person_type_id = ppt2.person_type_id

Line 1349: from per_people_f p

1345: into v_other_only
1346: from sys.dual
1347: where not exists
1348: (select null
1349: from per_people_f p
1350: where p.person_id = P_CONTACT_PERSON_ID
1351: and p.current_emp_or_apl_flag = 'Y');
1352: exception
1353: when NO_DATA_FOUND then return;

Line 1395: row therefore may not exist in per_people_f (for this person_id).

1391: Cascades are all performed according to the locking ladder.
1392: NOTE
1393: P_FORM_CALL is set to 'Y' if this procedure is called from a forms
1394: module. In this case, the deletes are performed post-delete and a
1395: row therefore may not exist in per_people_f (for this person_id).
1396: For this reason the existance check will be ignored.
1397: */
1398: --
1399: PROCEDURE delete_a_person (p_person_id IN number,

Line 1412: from per_people_f

1408: where person_id = P_PERSON_ID;
1409: --
1410: cursor LOCK_PERSON_ROWS is
1411: select person_id
1412: from per_people_f
1413: where person_id = P_PERSON_ID
1414: FOR UPDATE;
1415: --
1416: cursor LOCK_ASSIGNMENT_ROWS is

Line 2757: from per_people_f

2753: v_assignment_id number(15);
2754: --
2755: cursor LOCK_PERSON_ROWS is
2756: select person_id
2757: from per_people_f
2758: where person_id = P_PERSON_ID
2759: FOR UPDATE;
2760: --
2761: BEGIN

Line 2932: delete from per_people_f

2928: --
2929: hr_utility.set_location('HR_PERSON_DELETE.PEOPLE_DEFAULT_DELETES', 16);
2930: --
2931: begin
2932: delete from per_people_f
2933: where person_id = P_PERSON_ID;
2934: exception
2935: when NO_DATA_FOUND then null;
2936: end;

Line 2971: from per_people_f

2967: v_assignment_id number(15);
2968: --
2969: cursor LOCK_PERSON_ROWS is
2970: select person_id
2971: from per_people_f
2972: where person_id = P_PERSON_ID
2973: FOR UPDATE;
2974: --
2975: BEGIN

Line 3081: delete from per_people_f

3077: --
3078: hr_utility.set_location('HR_PERSON_DELETE.APPLICANT_DEFAULT_DELETES', 10);
3079: --
3080: begin
3081: delete from per_people_f
3082: where person_id = P_PERSON_ID;
3083: exception
3084: when NO_DATA_FOUND then null;
3085: end;