APPS.IRC_IDP_BUS dependencies on PER_JOBS

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

377: -- |-----------------------------< chk_job_id >-----------------------------|
378: -- ---------------------------------------------------------------------------
379: --
380: -- Description:
381: -- - Validates that a job id exists in table per_jobs.
382: --
383: -- Pre-conditions:
384: -- None.
385: --

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

386: -- In Arguments:
387: -- p_job_id
388: --
389: -- Post Success:
390: -- If a row does exist in per_jobs for the given job id then
391: -- processing continues.
392: --
393: -- Post Failure:
394: -- If a row does not exist in per_jobs for the given job id then

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

390: -- If a row does exist in per_jobs for the given job id then
391: -- processing continues.
392: --
393: -- Post Failure:
394: -- If a row does not exist in per_jobs for the given job id then
395: -- an application error will be raised and processing is terminated.
396: --
397: -- Access Status:
398: -- Internal Table Handler Use Only.

Line 411: from per_jobs pj

407: l_proc varchar2(72) := g_package||'chk_job_id';
408: l_job varchar2(1);
409: cursor csr_job is
410: select null
411: from per_jobs pj
412: where pj.job_id = p_job_id;
413: --
414: begin
415: hr_utility.set_location('Entering:'|| l_proc, 10);