APPS.IRC_RTM_BUS dependencies on PER_ALL_VACANCIES

Line 280: -- If the vacancy id is not found in per_all_vacancies an error is generated.

276: -- {Start Of Comments}
277: --
278: -- Description:
279: -- This procedure is used to ensure that mandatory parameters have been set.
280: -- If the vacancy id is not found in per_all_vacancies an error is generated.
281: --
282: -- Pre Conditions:
283: -- g_old_rec has been populated with details of the values currently in
284: -- the database.

Line 308: -- Cursor to check that the vacancy_id exists in PER_ALL_VACANCIES

304: l_proc varchar2(72) := g_package || 'chk_vacancy_id';
305: l_vacancy_id irc_rec_team_members.vacancy_id%type;
306: --
307: --
308: -- Cursor to check that the vacancy_id exists in PER_ALL_VACANCIES
309: -- and is current at the p_start_date.
310: --
311: cursor csr_vacancy_id is
312: select vacancy_id

Line 313: from per_all_vacancies

309: -- and is current at the p_start_date.
310: --
311: cursor csr_vacancy_id is
312: select vacancy_id
313: from per_all_vacancies
314: where vacancy_id = p_vacancy_id;
315: --
316: Begin
317: --

Line 326: -- Check if the vacancy_id exists in PER_ALL_VACANCIES

322: ,p_argument => 'vacancy_id'
323: ,p_argument_value => p_vacancy_id
324: );
325: --
326: -- Check if the vacancy_id exists in PER_ALL_VACANCIES
327: -- and is current at the p_start_date.
328: --
329: open csr_vacancy_id;
330: fetch csr_vacancy_id into l_vacancy_id;

Line 398: per_jobs job, per_all_vacancies vac

394: -- Cursor to check that the job_id exists in PER_JOBS
395: --
396: cursor csr_job_id is
397: select null from
398: per_jobs job, per_all_vacancies vac
399: where job.job_id = p_job_id
400: and vac.vacancy_id = p_vacancy_id
401: and vac.business_group_id = job.business_group_id
402: and p_start_date between job.date_from and nvl(job.date_to,hr_api.g_eot);