[Home] [Help]
356: -- {Start Of Comments}
357: --
358: -- Description:
359: -- This procedure is used to ensure that mandatory parameters have been set.
360: -- If the job id is not found in per_jobs an error is generated.
361: --
362: -- Pre Conditions:
363: -- g_old_rec has been populated with details of the values currently in
364: -- the database.
390: l_job_id varchar2(1);
391: l_api_updating boolean;
392: --
393: --
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
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);
413: if ((l_api_updating
414: and (irc_rtm_shd.g_old_rec.job_id <> p_job_id))
415: or (NOT l_api_updating)) then
416: --
417: -- Check if the job_id exists in PER_JOBS
418: --
419: if hr_multi_message.no_exclusive_error
420: (p_check_column1 => 'IRC_REC_TEAM_MEMBERS.VACANCY_ID'
421: ) then
488: -- is valid.
489: --
490: cursor csr_job_id_job_group_id is
491: select null from
492: per_jobs job
493: ,per_job_groups jgr
494: where job.job_id = p_job_id
495: and job.job_group_id = jgr.job_group_id
496: and job.business_group_id = jgr.business_group_id