APPS.HR_PERSON_DELETE dependencies on PER_PERIODS_OF_SERVICE

Line 826: from per_periods_of_service p

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

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

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

Line 1608: update per_periods_of_service p

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

Line 2509: delete from per_periods_of_service p

2505: --
2506: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 44);
2507: --
2508: begin
2509: delete from per_periods_of_service p
2510: where p.person_id = P_PERSON_ID;
2511: exception
2512: when NO_DATA_FOUND then
2513: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 4101);

Line 2897: delete from per_periods_of_service p

2893: --
2894: hr_utility.set_location('HR_PERSON_DELETE.PEOPLE_DEFAULT_DELETES', 13);
2895: --
2896: begin
2897: delete from per_periods_of_service p
2898: where p.person_id = P_PERSON_ID;
2899: exception
2900: when NO_DATA_FOUND then null;
2901: end;