APPS.PER_CANCEL_HIRE_OR_APL_PKG dependencies on PER_ALL_VACANCIES

Line 2494: update per_all_vacancies pv

2490: hr_utility.set_location('cancel_hire_or_apl.do_cancel_hire',130);
2491: fetch vacancies into p_rowid;
2492: exit when vacancies%NOTFOUND;
2493: --
2494: update per_all_vacancies pv
2495: set pv.recruiter_id = NULL
2496: where pv.rowid = p_rowid;
2497: if sql%notfound then
2498: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

Line 4851: UPDATE per_all_vacancies pv

4847: FOR vacancies_rec IN csr_vacancies LOOP
4848: --
4849: hr_utility.set_location(l_proc,100);
4850: --
4851: UPDATE per_all_vacancies pv
4852: SET pv.recruiter_id = NULL
4853: WHERE pv.rowid = vacancies_rec.rowid;
4854: --
4855: IF SQL%NOTFOUND THEN