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.PER_JOB_BUS dependencies on PER_JOBS

Line 69: from per_jobs

65: where job_definition_id = p_job_definition_id;
66: --
67: cursor csr_unique_job_def is
68: select 'x'
69: from per_jobs
70: where job_definition_id = p_job_definition_id
71: and business_group_id + 0 = p_business_group_id;
72: --
73: begin

Line 102: per_job_shd.constraint_error(p_constraint_name => 'PER_JOBS_FK2');

98: open csr_job_def;
99: fetch csr_job_def into l_exists;
100: if csr_job_def%notfound then
101: close csr_job_def;
102: per_job_shd.constraint_error(p_constraint_name => 'PER_JOBS_FK2');
103: end if;
104: close csr_job_def;
105: --
106: hr_utility.set_location(l_proc, 5);

Line 295: ,p_descflex_name => 'PER_JOBS'

291: -- b) During insert.
292: --
293: hr_dflex_utility.ins_or_upd_descflex_attribs
294: (p_appl_short_name => 'PER'
295: ,p_descflex_name => 'PER_JOBS'
296: ,p_attribute_category => p_rec.attribute_category
297: ,p_attribute1_name => 'ATTRIBUTE1'
298: ,p_attribute1_value => p_rec.attribute1
299: ,p_attribute2_name => 'ATTRIBUTE2'

Line 668: cursor csr_bg is select business_group_id from per_jobs

664: -- |---------------------------< delete_validate >----------------------------|
665: -- ----------------------------------------------------------------------------
666: Procedure delete_validate(p_rec in per_job_shd.g_rec_type) is
667: --
668: cursor csr_bg is select business_group_id from per_jobs
669: where job_id = p_rec.job_id;
670: l_business_group_id number;
671: l_proc varchar2(72) := g_package||'delete_validate';
672: --

Line 702: , per_jobs job

698: --
699: cursor csr_leg_code is
700: select pbg.legislation_code
701: from per_business_groups pbg
702: , per_jobs job
703: where job.job_id = p_job_id
704: and pbg.business_group_id = job.business_group_id;
705: --
706: -- Declare local variables

Line 813: (p_emp_rights_flag in per_jobs.emp_rights_flag%TYPE

809: -- -------------------------------------------------------------------------+
810: -- |------------------------< chk_emp_rights_flag >-------------------------|
811: -- -------------------------------------------------------------------------+
812: procedure chk_emp_rights_flag
813: (p_emp_rights_flag in per_jobs.emp_rights_flag%TYPE
814: ,p_rec in per_job_shd.g_rec_type) is
815:
816: l_proc varchar2(72) := g_package||'chk_emp_rights_flag';
817: l_api_updating boolean;

Line 846: (p_job_group_id in per_jobs.job_group_id%TYPE

842: -- -------------------------------------------------------------------------+
843: -- |--------------------------< chk_job_group_id >--------------------------|
844: -- -------------------------------------------------------------------------+
845: procedure chk_job_group_id
846: (p_job_group_id in per_jobs.job_group_id%TYPE
847: ,p_business_group_id in per_jobs.business_group_id%TYPE
848: ) is
849: -- Bug 3177195 Changed the where clause for the cursor
850: cursor csr_job_group_id is

Line 847: ,p_business_group_id in per_jobs.business_group_id%TYPE

843: -- |--------------------------< chk_job_group_id >--------------------------|
844: -- -------------------------------------------------------------------------+
845: procedure chk_job_group_id
846: (p_job_group_id in per_jobs.job_group_id%TYPE
847: ,p_business_group_id in per_jobs.business_group_id%TYPE
848: ) is
849: -- Bug 3177195 Changed the where clause for the cursor
850: cursor csr_job_group_id is
851: select job_group_id

Line 857: l_job_group_id per_jobs.job_group_id%TYPE;

853: where job_group_id = p_job_group_id
854: and (business_group_id is null
855: or business_group_id = p_business_group_id);
856:
857: l_job_group_id per_jobs.job_group_id%TYPE;
858: l_proc varchar2(72) := g_package||'chk_job_group_id';
859:
860: begin
861: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 880: (p_approval_authority in per_jobs.approval_authority%TYPE

876: -- -------------------------------------------------------------------------+
877: -- |-----------------------< chk_approval_authority >-----------------------|
878: -- -------------------------------------------------------------------------+
879: procedure chk_approval_authority
880: (p_approval_authority in per_jobs.approval_authority%TYPE
881: ,p_rec in per_job_shd.g_rec_type) is
882:
883: l_proc varchar2(72) := g_package||'chk_approval_authority';
884: l_approval_authority number := p_approval_authority;

Line 915: (p_benchmark_job_flag in per_jobs.benchmark_job_flag%TYPE

911: -- -------------------------------------------------------------------------+
912: -- |-----------------------< chk_benchmark_job_flag >-----------------------|
913: -- -------------------------------------------------------------------------+
914: procedure chk_benchmark_job_flag
915: (p_benchmark_job_flag in per_jobs.benchmark_job_flag%TYPE
916: ,p_benchmark_job_id in per_jobs.benchmark_job_id%TYPE
917: ,p_rec in per_job_shd.g_rec_type) is
918:
919: l_proc varchar2(72) := g_package||'chk_benchmark_job_flag';

Line 916: ,p_benchmark_job_id in per_jobs.benchmark_job_id%TYPE

912: -- |-----------------------< chk_benchmark_job_flag >-----------------------|
913: -- -------------------------------------------------------------------------+
914: procedure chk_benchmark_job_flag
915: (p_benchmark_job_flag in per_jobs.benchmark_job_flag%TYPE
916: ,p_benchmark_job_id in per_jobs.benchmark_job_id%TYPE
917: ,p_rec in per_job_shd.g_rec_type) is
918:
919: l_proc varchar2(72) := g_package||'chk_benchmark_job_flag';
920: l_api_updating boolean;

Line 951: (p_benchmark_job_id in per_jobs.benchmark_job_id%TYPE

947: -- --------------------------------------------------------------------------+
948: -- |------------------------< chk_benchmark_job_id >-------------------------|
949: -- --------------------------------------------------------------------------+
950: procedure chk_benchmark_job_id
951: (p_benchmark_job_id in per_jobs.benchmark_job_id%TYPE
952: ,p_job_id in per_jobs.job_id%TYPE
953: ,p_business_group_id in per_jobs.business_group_id%TYPE
954: ,p_rec in per_job_shd.g_rec_type) is
955:

Line 952: ,p_job_id in per_jobs.job_id%TYPE

948: -- |------------------------< chk_benchmark_job_id >-------------------------|
949: -- --------------------------------------------------------------------------+
950: procedure chk_benchmark_job_id
951: (p_benchmark_job_id in per_jobs.benchmark_job_id%TYPE
952: ,p_job_id in per_jobs.job_id%TYPE
953: ,p_business_group_id in per_jobs.business_group_id%TYPE
954: ,p_rec in per_job_shd.g_rec_type) is
955:
956: cursor csr_benchmark_job_id is

Line 953: ,p_business_group_id in per_jobs.business_group_id%TYPE

949: -- --------------------------------------------------------------------------+
950: procedure chk_benchmark_job_id
951: (p_benchmark_job_id in per_jobs.benchmark_job_id%TYPE
952: ,p_job_id in per_jobs.job_id%TYPE
953: ,p_business_group_id in per_jobs.business_group_id%TYPE
954: ,p_rec in per_job_shd.g_rec_type) is
955:
956: cursor csr_benchmark_job_id is
957: select 1

Line 958: from per_jobs

954: ,p_rec in per_job_shd.g_rec_type) is
955:
956: cursor csr_benchmark_job_id is
957: select 1
958: from per_jobs
959: --
960: -- Bug 3213738
961: -- Changed where clause to filter based on benchmark_job_id
962: -- and relaxed check on business group.

Line 968: l_benchmark_job_id per_jobs.benchmark_job_id%TYPE;

964: where job_id = p_benchmark_job_id
965: and p_benchmark_job_id <> nvl(p_job_id,hr_api.g_number)
966: and benchmark_job_flag = 'Y';
967:
968: l_benchmark_job_id per_jobs.benchmark_job_id%TYPE;
969: l_proc varchar2(72) := g_package||'chk_benchmark_job_id';
970: l_api_updating boolean;
971:
972: begin

Line 1012: from per_jobs j

1008: p_business_group_id in number,
1009: p_name in varchar2) is
1010: --
1011: cursor csr_name is select null
1012: from per_jobs j
1013: where ((p_job_id is not null
1014: and j.job_id <> p_job_id)
1015: or p_job_id is null)
1016: and j.business_group_id + 0 = p_business_group_id