DBA Data[Home] [Help]

APPS.HR_PERSON_DELETE dependencies on PER_VACANCIES

Line 955: from per_vacancies v

951: into v_delete_permitted
952: from sys.dual
953: where not exists (
954: select null
955: from per_vacancies v
956: where v.recruiter_id = P_PERSON_ID);
957: exception
958: when NO_DATA_FOUND then
959: hr_utility.set_message (801,'HR_6339_ALL_PER_VAC_NO_DEL');

Line 1804: update per_vacancies v

1800: --
1801: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 14);
1802: --
1803: begin
1804: update per_vacancies v
1805: set v.recruiter_id = null
1806: where v.recruiter_id = P_PERSON_ID;
1807: exception
1808: when NO_DATA_FOUND then