APPS.BEN_XCT_BUS dependencies on BEN_EXT_CRIT_TYP

Line 24: , ben_ext_crit_typ xct

20: --
21: cursor csr_sec_grp is
22: select pbg.security_group_id
23: from per_business_groups pbg
24: , ben_ext_crit_typ xct
25: where xct.ext_crit_typ_id = p_ext_crit_typ_id
26: and pbg.business_group_id = xct.business_group_id;
27: --
28: -- Declare local variables

Line 165: ben_xct_shd.constraint_error('BEN_EXT_CRIT_TYP_PK');

161: <> ben_xct_shd.g_old_rec.ext_crit_typ_id) then
162: --
163: -- raise error as PK has changed
164: --
165: ben_xct_shd.constraint_error('BEN_EXT_CRIT_TYP_PK');
166: --
167: elsif not l_api_updating then
168: --
169: -- check if PK is null

Line 175: ben_xct_shd.constraint_error('BEN_EXT_CRIT_TYP_PK');

171: if p_ext_crit_typ_id is not null then
172: --
173: -- raise error as PK is not null
174: --
175: ben_xct_shd.constraint_error('BEN_EXT_CRIT_TYP_PK');
176: --
177: end if;
178: --
179: end if;

Line 248: ben_xct_shd.constraint_error('BEN_EXT_CRIT_TYP_FK1');

244: --
245: -- raise error as FK does not relate to PK in ben_ext_crit_prfl
246: -- table.
247: --
248: ben_xct_shd.constraint_error('BEN_EXT_CRIT_TYP_FK1');
249: --
250: end if;
251: --
252: close c1;

Line 319: (p_lookup_type => 'BEN_EXT_CRIT_TYP',

315: --
316: if p_business_group_id is not null then
317: /* BG is set, so use the existing call, with no modifications*/
318: if hr_api.not_exists_in_hr_lookups
319: (p_lookup_type => 'BEN_EXT_CRIT_TYP',
320: p_lookup_code => p_crit_typ_cd,
321: p_effective_date => p_effective_date) then
322: --
323: -- raise error as does not exist as lookup

Line 327: fnd_message.set_name('TYPE','BEN_EXT_CRIT_TYP');

323: -- raise error as does not exist as lookup
324: --
325: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
326: fnd_message.set_token('FIELD','p_crit_typ_cd');
327: fnd_message.set_name('TYPE','BEN_EXT_CRIT_TYP');
328: fnd_message.raise_error;
329: --
330: end if;
331: else

Line 334: (p_lookup_type => 'BEN_EXT_CRIT_TYP',

330: end if;
331: else
332: /* BG is null, so alternative call is required */
333: if hr_api.not_exists_in_hrstanlookups
334: (p_lookup_type => 'BEN_EXT_CRIT_TYP',
335: p_lookup_code => p_crit_typ_cd,
336: p_effective_date => p_effective_date) then
337: --
338: -- raise error as does not exist as lookup

Line 342: fnd_message.set_name('TYPE','BEN_EXT_CRIT_TYP');

338: -- raise error as does not exist as lookup
339: --
340: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
341: fnd_message.set_token('FIELD','p_crit_typ_cd');
342: fnd_message.set_name('TYPE','BEN_EXT_CRIT_TYP');
343: fnd_message.raise_error;
344: --
345: end if;
346: --

Line 390: from ben_ext_crit_typ xct,

386: p_effective_date in date,
387: p_object_version_number in number) is
388: --
389: cursor c1 is select null
390: from ben_ext_crit_typ xct,
391: ben_ext_crit_val xcv
392: where xct.ext_crit_typ_id = p_ext_crit_typ_id
393: and xcv.ext_crit_typ_id = xct.ext_crit_typ_id;
394: --

Line 463: from ben_ext_crit_typ

459: is
460: l_proc varchar2(72) := g_package||'chk_crit_cd_unique';
461: l_dummy char(1);
462: cursor c1 is select null
463: from ben_ext_crit_typ
464: Where ext_crit_prfl_id = p_ext_crit_prfl_id
465: and ext_crit_typ_id <> nvl(p_ext_crit_typ_id,-1)
466: and crit_typ_cd = p_crit_typ_cd
467: and ((business_group_id is null and legislation_code is null)

Line 732: ben_ext_crit_typ b

728: --
729: cursor csr_leg_code is
730: select a.legislation_code
731: from per_business_groups a,
732: ben_ext_crit_typ b
733: where b.ext_crit_typ_id = p_ext_crit_typ_id
734: and a.business_group_id(+) = b.business_group_id;
735: --
736: -- Declare local variables