[Home] [Help]
366: l_parent_end_date date;
367: --
368: cursor csr_chk_job_id_exists is
369: select j.business_group_id, date_from, nvl(date_to,hr_api.g_eot)
370: from per_jobs j
371: where j.job_id = p_parent_id;
372: --
373: -- Changed 13-Oct-99 SCNair (per_positions to hr_positions_f) Date tracked position req
374: --
441: Else
442: --
443: hr_utility.set_location(l_proc,25);
444: --
445: If p_parent_table_name = 'PER_JOBS' then
446: --
447: hr_utility.set_location(l_proc,30);
448: --
449: open csr_chk_job_id_exists;
453: hr_utility.set_location(l_proc,35);
454: --
455: close csr_chk_job_id_exists;
456: --
457: -- raise error as FK does not relate to PK in per_jobs
458: -- table.
459: --
460: fnd_message.set_name('PER','PER_52483_SSM_INVL_JOB_ID');
461: fnd_message.raise_error;
492: hr_utility.set_location(l_proc,55);
493: --
494: close csr_chk_position_id_exists;
495: --
496: -- raise error as FK does not relate to PK in per_jobs
497: -- table.
498: --
499: fnd_message.set_name('PER','PER_52486_SSM_INVL_POS_ID');
500: fnd_message.raise_error;
536: hr_utility.set_location(l_proc,55);
537: --
538: close csr_chk_assignment_id_exists;
539: --
540: -- raise error as FK does not relate to PK in per_jobs
541: -- table.
542: --
543: fnd_message.set_name('PER','PER_SSM_INVL_ASG_ID');
544: fnd_message.raise_error;