DBA Data[Home] [Help]

APPS.HR_PERSON_DELETE dependencies on PER_PERIODS_OF_PLACEMENT

Line 177: 115.30 10-OCT-2003 njaladi 3183868 Removed the per_periods_of_placement

173: 115.29 Sep-2003 mbocutt ex-person security enhancements.
174: Remove refs to per_person_list_changes.
175: This file is now dependent on other
176: security changes delivered in Nov 2003 FP.
177: 115.30 10-OCT-2003 njaladi 3183868 Removed the per_periods_of_placement
178: validation Code in procedure
179: moderate_pre_del_validation as this check
180: is not required for CWK.
181: 115.31 12-May-2004 bdivvela 3619599 Modified delete queries on tables

Line 2723: delete from per_periods_of_placement p

2719: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 150);
2720: --
2721: --
2722: begin
2723: delete from per_periods_of_placement p
2724: where p.person_id = P_PERSON_ID;
2725: exception
2726: when NO_DATA_FOUND then
2727: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 4501);

Line 2939: delete from per_periods_of_placement p

2935: when NO_DATA_FOUND then null;
2936: end;
2937: --
2938: begin
2939: delete from per_periods_of_placement p
2940: where p.person_id = P_PERSON_ID;
2941: exception
2942: when NO_DATA_FOUND then null;
2943: end;