APPS.BEN_XRC_BUS dependencies on BEN_EXT_RCD

Line 72: , ben_ext_rcd xrc

68: --
69: cursor csr_sec_grp is
70: select pbg.security_group_id
71: from per_business_groups pbg
72: , ben_ext_rcd xrc
73: where xrc.ext_rcd_id = p_ext_rcd_id
74: and pbg.business_group_id = xrc.business_group_id;
75: --
76: -- Declare local variables

Line 165: ben_xrc_shd.constraint_error('BEN_EXT_RCD_PK');

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

Line 175: ben_xrc_shd.constraint_error('BEN_EXT_RCD_PK');

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

Line 220: from ben_ext_rcd

216: is
217: l_proc varchar2(72) := g_package||'chk_name_unique';
218: l_dummy char(1);
219: cursor c1 is select null
220: from ben_ext_rcd
221: Where ext_rcd_id <> nvl(p_ext_rcd_id,-1)
222: and name = p_name
223: and ((business_group_id is null and legislation_code is null)
224: or (legislation_code is not null

Line 303: (p_lookup_type => 'BEN_EXT_RCD_TYP',

299: --
300: if p_business_group_id is not null then
301: /* BG is set, so use the existing call, with no modifications*/
302: if hr_api.not_exists_in_hr_lookups
303: (p_lookup_type => 'BEN_EXT_RCD_TYP',
304: p_lookup_code => p_rcd_type_cd,
305: p_effective_date => p_effective_date) then
306: --
307: -- raise error as does not exist as lookup

Line 312: fnd_message.set_token('TYPE','BEN_EXT_RCD_TYP');

308: --
309: --
310: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
311: fnd_message.set_token('FIELD','p_rcd_type_cd');
312: fnd_message.set_token('TYPE','BEN_EXT_RCD_TYP');
313: fnd_message.raise_error;
314: --
315: end if;
316: else

Line 319: (p_lookup_type => 'BEN_EXT_RCD_TYP',

315: end if;
316: else
317: /* BG is null, so alternative call is required */
318: if hr_api.not_exists_in_hrstanlookups
319: (p_lookup_type => 'BEN_EXT_RCD_TYP',
320: p_lookup_code => p_rcd_type_cd,
321: p_effective_date => p_effective_date) then
322: --
323: -- raise error as does not exist as lookup

Line 328: fnd_message.set_token('TYPE','BEN_EXT_RCD_TYP');

324: --
325: --
326: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
327: fnd_message.set_token('FIELD','p_rcd_type_cd');
328: fnd_message.set_token('TYPE','BEN_EXT_RCD_TYP');
329: fnd_message.raise_error;
330: --
331: end if;
332: end if;

Line 652: ben_ext_rcd b

648: --
649: cursor csr_leg_code is
650: select a.legislation_code
651: from per_business_groups a,
652: ben_ext_rcd b
653: where b.ext_rcd_id = p_ext_rcd_id
654: and a.business_group_id(+) = b.business_group_id;
655: --
656: -- Declare local variables