APPS.PER_RCF_BUS dependencies on PER_ALL_VACANCIES

Line 235: -- id matches with that in the PER_ALL_VACANCIES table.

231: -- p_business_group_id.
232: --
233: -- Post Success:
234: -- Processing continues if the vacancy id is valid and the business group
235: -- id matches with that in the PER_ALL_VACANCIES table.
236: --
237: -- Post Failure:
238: -- An application error is raised if the vacancy id is null or is not valid
239: -- or if the business group id is not valid.

Line 259: -- PER_ALL_VACANCIES.

255: l_vacancy_id per_recruitment_activity_for.vacancy_id%type;
256: l_api_updating boolean;
257: --
258: -- Cursor to check that the vacancy id exists in the reference table
259: -- PER_ALL_VACANCIES.
260: --
261: cursor csr_vacancy_id is
262: select l_vacancy_id,l_business_group_id
263: from per_all_vacancies

Line 263: from per_all_vacancies

259: -- PER_ALL_VACANCIES.
260: --
261: cursor csr_vacancy_id is
262: select l_vacancy_id,l_business_group_id
263: from per_all_vacancies
264: where vacancy_id = p_vacancy_id;
265: --
266: Begin
267: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 291: -- Check that the vacancy id exists in the PER_ALL_VACANCIES table.

287: ,p_argument_value => p_vacancy_id
288: );
289: end if;
290: --
291: -- Check that the vacancy id exists in the PER_ALL_VACANCIES table.
292: --
293: open csr_vacancy_id;
294: fetch csr_vacancy_id into l_vacancy_id,l_business_group_id;
295: hr_utility.set_location(l_proc, 40);

Line 306: -- PER_ALL_VACANCIES table for this vacancy_id.

302: );
303: else
304: --
305: -- Check that the business group id is the same as that in the
306: -- PER_ALL_VACANCIES table for this vacancy_id.
307: --
308: hr_utility.set_location(l_proc, 50);
309: if(l_business_group_id <> p_business_group_id) then
310: hr_utility.set_location(l_proc, 51);