eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_XER_BUS dependencies on BEN_EXT_DATA_ELMT

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 247: from ben_ext_data_elmt a

243: l_dummy varchar2(1);
244: --
245: cursor c1 is
246: select null
247: from ben_ext_data_elmt a
248: where a.ext_data_elmt_id = p_ext_data_elmt_id;
249: --
250: Begin
251: --

Line 263: -- check if ext_data_elmt_id value exists in ben_ext_data_elmt table

259: and nvl(p_ext_data_elmt_id,hr_api.g_number)
260: <> nvl(ben_xer_shd.g_old_rec.ext_data_elmt_id,hr_api.g_number)
261: or not l_api_updating) then
262: --
263: -- check if ext_data_elmt_id value exists in ben_ext_data_elmt table
264: --
265: open c1;
266: --
267: fetch c1 into l_dummy;

Line 272: -- raise error as FK does not relate to PK in ben_ext_data_elmt

268: if c1%notfound then
269: --
270: close c1;
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: --

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 888: from ben_ext_data_elmt a, ben_ext_fld b

884: from ben_ext_rcd
885: where ext_rcd_id = p_ext_rcd_id;
886:
887: cursor c2 is select data_elmt_typ_cd, alwd_in_rcd_cd
888: from ben_ext_data_elmt a, ben_ext_fld b
889: where a.ext_data_elmt_id = p_ext_data_elmt_id
890: and a.ext_fld_id = b.ext_fld_id;
891:
892: typ_cd ben_ext_rcd.rcd_type_cd%type;

Line 893: data_typ_cd ben_ext_data_elmt.data_elmt_typ_cd%type;

889: where a.ext_data_elmt_id = p_ext_data_elmt_id
890: and a.ext_fld_id = b.ext_fld_id;
891:
892: typ_cd ben_ext_rcd.rcd_type_cd%type;
893: data_typ_cd ben_ext_data_elmt.data_elmt_typ_cd%type;
894: alwd_cd ben_ext_fld.alwd_in_rcd_cd%type;
895: --
896: Begin
897: --

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