APPS.BEN_JRT_BUS dependencies on BEN_JOB_RT_F

Line 65: ben_jrt_shd.constraint_error('BEN_JOB_RT_F_PK');

61: <> ben_jrt_shd.g_old_rec.job_rt_id) then
62: --
63: -- raise error as PK has changed
64: --
65: ben_jrt_shd.constraint_error('BEN_JOB_RT_F_PK');
66: --
67: elsif not l_api_updating then
68: --
69: -- check if PK is null

Line 75: ben_jrt_shd.constraint_error('BEN_JOB_RT_F_PK');

71: if p_job_rt_id is not null then
72: --
73: -- raise error as PK is not null
74: --
75: ben_jrt_shd.constraint_error('BEN_JOB_RT_F_PK');
76: --
77: end if;
78: --
79: end if;

Line 137: from ben_job_rt_f

133: nvl(a.date_to, p_effective_date);
134: --
135: cursor c3 is
136: select null
137: from ben_job_rt_f
138: where job_id = p_job_id
139: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
140: and vrbl_rt_prfl_id <> nvl(p_job_rt_id,hr_api.g_number)
141: and business_group_id + 0 = p_business_group_id

Line 172: ben_jrt_shd.constraint_error('BEN_JOB_RT_FK2');

168: --
169: -- raise error as FK does not relate to PK in per_jobs
170: -- table.
171: --
172: ben_jrt_shd.constraint_error('BEN_JOB_RT_FK2');
173: --
174: end if;
175: --
176: close c1;

Line 283: , ben_job_rt_f jrt

279: --
280: cursor csr_sec_grp is
281: select pbg.security_group_id
282: from per_business_groups pbg
283: , ben_job_rt_f jrt
284: where jrt.job_rt_id = p_job_rt_id
285: and pbg.business_group_id = jrt.business_group_id;
286: --
287: -- Declare local variables

Line 347: , ben_job_rt_f jrt

343: --
344: cursor csr_leg_code is
345: select pbg.legislation_code
346: from per_business_groups pbg
347: , ben_job_rt_f jrt
348: where jrt.job_rt_id = p_job_rt_id
349: and pbg.business_group_id = jrt.business_group_id;
350: --
351: -- Declare local variables

Line 515: ,p_descflex_name => 'BEN_JOB_RT_F'

511: -- b) During insert.
512: --
513: hr_dflex_utility.ins_or_upd_descflex_attribs
514: (p_appl_short_name => 'BEN'
515: ,p_descflex_name => 'BEN_JOB_RT_F'
516: ,p_attribute_category => 'JRT_ATTRIBUTE_CATEGORY'
517: ,p_attribute1_name => 'JRT_ATTRIBUTE1'
518: ,p_attribute1_value => p_rec.jrt_attribute1
519: ,p_attribute2_name => 'JRT_ATTRIBUTE2'

Line 677: from ben_job_rt_f

673: is
674: l_proc varchar2(72) := g_package||' chk_duplicate_ordr_num ';
675: l_dummy char(1);
676: cursor c1 is select null
677: from ben_job_rt_f
678: where vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
679: -- changed against bug: 5113011
680: and job_rt_id <> nvl(p_job_rt_id ,-1)
681: --and job_id <> nvl(p_job_id ,-1)