APPS.BEN_XER_BUS dependencies on BEN_EXT_DATA_ELMT_IN_RCD

Line 24: , ben_ext_data_elmt_in_rcd bde

20: --
21: cursor csr_sec_grp is
22: select pbg.security_group_id
23: from per_business_groups pbg
24: , ben_ext_data_elmt_in_rcd bde
25: where bde.ext_data_elmt_in_rcd_id = p_ext_data_elmt_in_rcd_id
26: and pbg.business_group_id = bde.business_group_id;
27: --
28: -- Declare local variables

Line 117: ben_xer_shd.constraint_error('BEN_EXT_DATA_ELMT_IN_RCD_PK');

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

Line 127: ben_xer_shd.constraint_error('BEN_EXT_DATA_ELMT_IN_RCD_PK');

123: if p_ext_data_elmt_in_rcd_id is not null then
124: --
125: -- raise error as PK is not null
126: --
127: ben_xer_shd.constraint_error('BEN_EXT_DATA_ELMT_IN_RCD_PK');
128: --
129: end if;
130: --
131: end if;

Line 200: ben_xer_shd.constraint_error('BEN_EXT_DATA_ELMT_IN_RCD_FK2');

196: --
197: -- raise error as FK does not relate to PK in ben_ext_rcd
198: -- table.
199: --
200: ben_xer_shd.constraint_error('BEN_EXT_DATA_ELMT_IN_RCD_FK2');
201: --
202: end if;
203: --
204: close c1;

Line 275: ben_xer_shd.constraint_error('BEN_EXT_DATA_ELMT_IN_RCD_FK1');

271: --
272: -- raise error as FK does not relate to PK in ben_ext_data_elmt
273: -- table.
274: --
275: ben_xer_shd.constraint_error('BEN_EXT_DATA_ELMT_IN_RCD_FK1');
276: --
277: end if;
278: --
279: close c1;

Line 317: from ben_ext_data_elmt_in_rcd

313: --
314: l_proc varchar2(72) := g_package||'chk_seq_num';
315: l_dummy char(1);
316: cursor c1 is select 1
317: from ben_ext_data_elmt_in_rcd
318: Where ext_rcd_id = p_ext_rcd_id
319: and seq_num = p_seq_num
320: -- and business_group_id = p_business_group_id
321: and ( (business_group_id is null -- is global

Line 379: from ben_ext_data_elmt_in_rcd

375: --
376: l_proc varchar2(72) := g_package||'chk_seq_num_unq';
377: l_dummy char(1);
378: cursor c1 is select null
379: from ben_ext_data_elmt_in_rcd
380: Where ext_rcd_id = p_ext_rcd_id
381: and ext_data_elmt_in_rcd_id <> nvl(p_ext_data_elmt_in_rcd_id,-1)
382: and seq_num = p_seq_num
383: -- and business_group_id = p_business_group_id

Line 1319: ben_ext_data_elmt_in_rcd b

1315: --
1316: cursor csr_leg_code is
1317: select a.legislation_code
1318: from per_business_groups a,
1319: ben_ext_data_elmt_in_rcd b
1320: where b.ext_data_elmt_in_rcd_id = p_ext_data_elmt_in_rcd_id
1321: and a.business_group_id(+) = b.business_group_id;
1322: --
1323: -- Declare local variables