DBA Data[Home] [Help]

APPS.HR_PERSON_DELETE dependencies on PER_VACANCIES

Line 956: from per_vacancies v

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

Line 1875: update per_vacancies v

1871: --
1872: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 14);
1873: --
1874: begin
1875: update per_vacancies v
1876: set v.recruiter_id = null
1877: where v.recruiter_id = P_PERSON_ID;
1878: exception
1879: when NO_DATA_FOUND then