APPS.HR_PERSON_DELETE dependencies on PER_PERIODS_OF_SERVICE

Line 827: from per_periods_of_service p

823: into v_delete_permitted
824: from sys.dual
825: where not exists (
826: select null
827: from per_periods_of_service p
828: where p.termination_accepted_person_id = P_PERSON_ID);
829: exception
830: when NO_DATA_FOUND then
831: hr_utility.set_message (801,'HR_6332_ALL_PER_TERM_NO_DEL');

Line 1605: -- Delete of per_periods_of_service at end after delete of

1601: end;
1602: --
1603: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 8);
1604: --
1605: -- Delete of per_periods_of_service at end after delete of
1606: -- per_assignments_f.
1607: --
1608: begin
1609: update per_periods_of_service p

Line 1609: update per_periods_of_service p

1605: -- Delete of per_periods_of_service at end after delete of
1606: -- per_assignments_f.
1607: --
1608: begin
1609: update per_periods_of_service p
1610: set p.termination_accepted_person_id = null
1611: where p.termination_accepted_person_id = P_PERSON_ID;
1612: exception
1613: when NO_DATA_FOUND then

Line 2580: delete from per_periods_of_service p

2576: --
2577: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 44);
2578: --
2579: begin
2580: delete from per_periods_of_service p
2581: where p.person_id = P_PERSON_ID;
2582: exception
2583: when NO_DATA_FOUND then
2584: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 4101);

Line 2969: delete from per_periods_of_service p

2965: --
2966: hr_utility.set_location('HR_PERSON_DELETE.PEOPLE_DEFAULT_DELETES', 13);
2967: --
2968: begin
2969: delete from per_periods_of_service p
2970: where p.person_id = P_PERSON_ID;
2971: exception
2972: when NO_DATA_FOUND then null;
2973: end;