DBA Data[Home] [Help]

APPS.HR_PERSON_DELETE dependencies on PER_ADDRESSES

Line 2163: delete from per_addresses a

2159: --
2160: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 25);
2161: --
2162: begin
2163: delete from per_addresses a
2164: where a.person_id = P_PERSON_ID;
2165: exception
2166: when NO_DATA_FOUND then
2167: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 2501);

Line 2824: delete from per_addresses a

2820: --
2821: hr_utility.set_location('HR_PERSON_DELETE.PEOPLE_DEFAULT_DELETES', 7);
2822: --
2823: begin
2824: delete from per_addresses a
2825: where a.person_id = P_PERSON_ID;
2826: exception
2827: when NO_DATA_FOUND then null;
2828: end;

Line 3013: delete from per_addresses a

3009: --
3010: hr_utility.set_location('HR_PERSON_DELETE.APPLICANT_DEFAULT_DELETES', 6);
3011: --
3012: begin
3013: delete from per_addresses a
3014: where a.person_id = P_PERSON_ID;
3015: exception
3016: when NO_DATA_FOUND then null;
3017: end;