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_ITA_BUS dependencies on PER_JOBS

Line 420: -- - Validates that a job id exists in table per_jobs.

416: -- |-----------------------------< chk_job_id >-----------------------------|
417: -- ---------------------------------------------------------------------------
418: --
419: -- Description:
420: -- - Validates that a job id exists in table per_jobs.
421: --
422: -- Pre-conditions:
423: -- None.
424: --

Line 429: -- If a row does exist in per_jobs for the given job id then

425: -- In Arguments:
426: -- p_job_id
427: --
428: -- Post Success:
429: -- If a row does exist in per_jobs for the given job id then
430: -- processing continues.
431: --
432: -- Post Failure:
433: -- If a row does not exist in per_jobs for the given job id then

Line 433: -- If a row does not exist in per_jobs for the given job id then

429: -- If a row does exist in per_jobs for the given job id then
430: -- processing continues.
431: --
432: -- Post Failure:
433: -- If a row does not exist in per_jobs for the given job id then
434: -- an application error will be raised and processing is terminated.
435: --
436: -- Access Status:
437: -- Internal Table Handler Use Only.

Line 450: from per_jobs pj

446: l_proc varchar2(72) := g_package||'chk_job_id';
447: l_job varchar2(1);
448: cursor csr_job is
449: select null
450: from per_jobs pj
451: where pj.job_id = p_job_id;
452: --
453: begin
454: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 469: -- valid job on per_jobs

465: --
466: hr_utility.set_location(l_proc, 20);
467: --
468: -- Check that the job ID is linked to a
469: -- valid job on per_jobs
470: --
471: open csr_job;
472: fetch csr_job into l_job;
473: --