[Home] [Help]
170: 115.27 16-JUL-2003 jpthomas 3026024 Added delete from ben_covered_dependents_f.
171: Delete the entry in the above table for the
172: contact person whom is getting deleted.
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
184: 115.32 07-Jun-2004 sbuche 3598568 Modified delete_a_person and people_default_deletes
185: procedures to call hr_security.delete_per_from_list
186: procedure for deleting a record in static list
187: instead of deleting it directly from unsecured
188: table per_person_list.
189: 115.33 24-Jun-2004 smparame 3732129 Modified delete_a_person procedure. Assignment ids
190: forthe person_id passed fetched into a pl/sql table
191: to improve performance.
192: 115.35 10-Aug-2004 jpthomas 3524713 Modified the procedure moderate_predel_validation in the
1233: 'E' check for employees
1234: 'O' check for other types
1235:
1236: NOTE
1237: No validation is required for security (PER_PERSON_LIST* tables) as
1238: this is implicit for the person via assignment criteria. The
1239: rows in these tables can just be deleted.
1240: */
1241: PROCEDURE strong_predel_validation (p_person_id IN number,
3059: --
3060: hr_utility.set_location('HR_PERSON_DELETE.APPLICANT_DEFAULT_DELETES', 3);
3061: --
3062: begin
3063: delete from per_person_list l
3064: where l.person_id = P_PERSON_ID;
3065: exception
3066: when NO_DATA_FOUND then null;
3067: end;