APPS.PER_CANCEL_HIRE_OR_APL_PKG dependencies on PER_ALL_VACANCIES

Line 1574: update per_all_vacancies pv

1570: hr_utility.set_location('cancel_hire_or_apl.do_cancel_hire',130);
1571: fetch vacancies into p_rowid;
1572: exit when vacancies%NOTFOUND;
1573: --
1574: update per_all_vacancies pv
1575: set pv.recruiter_id = NULL
1576: where pv.rowid = p_rowid;
1577: if sql%notfound then
1578: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

Line 3577: UPDATE per_all_vacancies pv

3573: FOR vacancies_rec IN csr_vacancies LOOP
3574: --
3575: hr_utility.set_location(l_proc,100);
3576: --
3577: UPDATE per_all_vacancies pv
3578: SET pv.recruiter_id = NULL
3579: WHERE pv.rowid = vacancies_rec.rowid;
3580: --
3581: IF SQL%NOTFOUND THEN