eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_RTM_BUS dependencies on PER_JOB_GROUPS

Line 455: -- If the job group id is not found in per_job_groups an error is generated.

451: -- {Start Of Comments}
452: --
453: -- Description:
454: -- This procedure is used to ensure that the job group of the job is valid.
455: -- If the job group id is not found in per_job_groups an error is generated.
456: --
457: -- Pre Conditions:
458: -- g_old_rec has been populated with details of the values currently in
459: -- the database.

Line 487: -- Cursor to check that the job_group_id exists in PER_JOB_GROUPS and

483: l_job_id_job_group_id varchar2(1);
484: l_api_updating boolean;
485: --
486: --
487: -- Cursor to check that the job_group_id exists in PER_JOB_GROUPS and
488: -- is valid.
489: --
490: cursor csr_job_id_job_group_id is
491: select null from

Line 493: ,per_job_groups jgr

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
497: and jgr.internal_name <> 'HR_'||to_char(jgr.business_group_id);

Line 512: -- Check if the job_group_id exists in PER_JOB_GROUPS and is valid.

508: and (irc_rtm_shd.g_old_rec.job_id <> p_job_id))
509: or (NOT l_api_updating)) then
510: hr_utility.set_location(l_proc, 20);
511: --
512: -- Check if the job_group_id exists in PER_JOB_GROUPS and is valid.
513: --
514: if hr_multi_message.no_exclusive_error
515: (p_check_column1 => 'IRC_REC_TEAM_MEMBERS.JOB_ID'
516: ,p_check_column2 => 'IRC_REC_TEAM_MEMBERS.VACANCY_ID'