APPS.BEN_XEL_BUS dependencies on BEN_EXT_DATA_ELMT

Line 23: , ben_ext_data_elmt xel

19: --
20: cursor csr_sec_grp is
21: select pbg.security_group_id
22: from per_business_groups pbg
23: , ben_ext_data_elmt xel
24: where xel.ext_data_elmt_id = p_ext_data_elmt_id
25: and pbg.business_group_id = xel.business_group_id;
26: --
27: -- Declare local variables

Line 116: ben_xel_shd.constraint_error('BEN_EXT_DATA_ELMT_PK');

112: <> ben_xel_shd.g_old_rec.ext_data_elmt_id) then
113: --
114: -- raise error as PK has changed
115: --
116: ben_xel_shd.constraint_error('BEN_EXT_DATA_ELMT_PK');
117: --
118: elsif not l_api_updating then
119: --
120: -- check if PK is null

Line 126: ben_xel_shd.constraint_error('BEN_EXT_DATA_ELMT_PK');

122: if p_ext_data_elmt_id is not null then
123: --
124: -- raise error as PK is not null
125: --
126: ben_xel_shd.constraint_error('BEN_EXT_DATA_ELMT_PK');
127: --
128: end if;
129: --
130: end if;

Line 401: from ben_ext_data_elmt_in_rcd bed

397: l_dummy varchar2(1);
398: --
399: cursor c1 is
400: select null
401: from ben_ext_data_elmt_in_rcd bed
402: where bed.ext_data_elmt_id = p_ext_data_elmt_id;
403: --
404: Begin
405: --

Line 539: (p_lookup_type => 'BEN_EXT_DATA_ELMT_TYP',

535: --
536: hr_utility.set_location('update mode :' || p_string_val ||' '|| ben_xel_shd.g_old_rec.string_val, 5);
537: if p_business_group_id is not null then
538: if hr_api.not_exists_in_hr_lookups
539: (p_lookup_type => 'BEN_EXT_DATA_ELMT_TYP',
540: p_lookup_code => p_data_elmt_typ_cd,
541: p_effective_date => p_effective_date) then
542: --
543: -- raise error as does not exist as lookup

Line 547: fnd_message.set_token('TYPE','BEN_EXT_DATA_ELMT_TYP');

543: -- raise error as does not exist as lookup
544: --
545: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
546: fnd_message.set_token('FIELD','p_data_elmt_typ_cd');
547: fnd_message.set_token('TYPE','BEN_EXT_DATA_ELMT_TYP');
548: fnd_message.raise_error;
549: --
550: end if;
551: --

Line 554: (p_lookup_type => 'BEN_EXT_DATA_ELMT_TYP',

550: end if;
551: --
552: else
553: if hr_api.not_exists_in_hrstanlookups
554: (p_lookup_type => 'BEN_EXT_DATA_ELMT_TYP',
555: p_lookup_code => p_data_elmt_typ_cd,
556: p_effective_date => p_effective_date) then
557: --
558: -- raise error as does not exist as lookup

Line 562: fnd_message.set_token('TYPE','BEN_EXT_DATA_ELMT_TYP');

558: -- raise error as does not exist as lookup
559: --
560: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
561: fnd_message.set_token('FIELD','p_data_elmt_typ_cd');
562: fnd_message.set_token('TYPE','BEN_EXT_DATA_ELMT_TYP');
563: fnd_message.raise_error;
564: --
565: end if;
566: --

Line 840: from ben_ext_data_elmt

836: is
837: l_proc varchar2(72) := g_package||'chk_name_unique';
838: l_dummy char(1);
839: cursor c1 is select null
840: from ben_ext_data_elmt
841: Where ext_data_elmt_id <> nvl(p_ext_data_elmt_id,-1)
842: and name = p_name
843: -- and business_group_id = p_business_group_id
844: and ( (business_group_id is null -- is unique globally

Line 1325: ben_ext_data_elmt b

1321: --
1322: cursor csr_leg_code is
1323: select a.legislation_code
1324: from per_business_groups a,
1325: ben_ext_data_elmt b
1326: where b.ext_data_elmt_id = p_ext_data_elmt_id
1327: and a.business_group_id(+) = b.business_group_id;
1328: --
1329: -- Declare local variables