DBA Data[Home] [Help]

APPS.HR_PERSON_DELETE dependencies on PER_PHONES

Line 2173: delete from per_phones a

2169: --
2170: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 25.5);
2171: --
2172: begin
2173: delete from per_phones a
2174: where a.parent_id = P_PERSON_ID
2175: and a.parent_table = 'PER_ALL_PEOPLE_F';
2176: exception
2177: when NO_DATA_FOUND then

Line 2833: delete from per_phones a

2829: --
2830: hr_utility.set_location('HR_PERSON_DELETE.DELETE_DEFAULT_DELETES', 7.5);
2831: --
2832: begin
2833: delete from per_phones a
2834: where a.parent_id = P_PERSON_ID
2835: and a.parent_table = 'PER_ALL_PEOPLE_F';
2836: exception
2837: when NO_DATA_FOUND then null;

Line 3022: delete from per_phones a

3018: --
3019: hr_utility.set_location('HR_PERSON_DELETE.APPLICANT_DEFAULT_DELETES', 6.5);
3020: --
3021: begin
3022: delete from per_phones a
3023: where a.parent_id = P_PERSON_ID
3024: and a.parent_table = 'PER_ALL_PEOPLE_F';
3025: exception
3026: when NO_DATA_FOUND then null;