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 2794: delete from per_periods_of_placement p

2790: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 150);
2791: --
2792: --
2793: begin
2794: delete from per_periods_of_placement p
2795: where p.person_id = P_PERSON_ID;
2796: exception
2797: when NO_DATA_FOUND then
2798: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 4501);

Line 3011: delete from per_periods_of_placement p

3007: when NO_DATA_FOUND then null;
3008: end;
3009: --
3010: begin
3011: delete from per_periods_of_placement p
3012: where p.person_id = P_PERSON_ID;
3013: exception
3014: when NO_DATA_FOUND then null;
3015: end;