[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
1232: 'E' check for employees
1233: 'O' check for other types
1234:
1235: NOTE
1236: No validation is required for security (PER_PERSON_LIST* tables) as
1237: this is implicit for the person via assignment criteria. The
1238: rows in these tables can just be deleted.
1239: */
1240: PROCEDURE strong_predel_validation (p_person_id IN number,
2987: --
2988: hr_utility.set_location('HR_PERSON_DELETE.APPLICANT_DEFAULT_DELETES', 3);
2989: --
2990: begin
2991: delete from per_person_list l
2992: where l.person_id = P_PERSON_ID;
2993: exception
2994: when NO_DATA_FOUND then null;
2995: end;