APPS.BEN_XDD_BUS dependencies on BEN_EXT_DATA_ELMT

Line 23: , ben_ext_data_elmt_decd xdd

19: --
20: cursor csr_sec_grp is
21: select pbg.security_group_id
22: from per_business_groups pbg
23: , ben_ext_data_elmt_decd xdd
24: where xdd.ext_data_elmt_decd_id = p_ext_data_elmt_decd_id
25: and pbg.business_group_id = xdd.business_group_id;
26: --
27: -- Declare local variables

Line 116: ben_xdd_shd.constraint_error('BEN_EXT_DATA_ELMT_DECD_PK');

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

Line 126: ben_xdd_shd.constraint_error('BEN_EXT_DATA_ELMT_DECD_PK');

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

Line 171: from ben_ext_data_elmt a

167: l_dummy varchar2(1);
168: --
169: cursor c1 is
170: select null
171: from ben_ext_data_elmt a
172: where a.ext_data_elmt_id = p_ext_data_elmt_id;
173: --
174: Begin
175: --

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

183: and nvl(p_ext_data_elmt_id,hr_api.g_number)
184: <> nvl(ben_xdd_shd.g_old_rec.ext_data_elmt_id,hr_api.g_number)
185: or not l_api_updating) then
186: --
187: -- check if ext_data_elmt_id value exists in ben_ext_data_elmt table
188: --
189: open c1;
190: --
191: fetch c1 into l_dummy;

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

192: if c1%notfound then
193: --
194: close c1;
195: --
196: -- raise error as FK does not relate to PK in ben_ext_data_elmt
197: -- table.
198: --
199: ben_xdd_shd.constraint_error('BEN_EXT_DATA_ELMT_DECD_FK1');
200: --

Line 199: ben_xdd_shd.constraint_error('BEN_EXT_DATA_ELMT_DECD_FK1');

195: --
196: -- raise error as FK does not relate to PK in ben_ext_data_elmt
197: -- table.
198: --
199: ben_xdd_shd.constraint_error('BEN_EXT_DATA_ELMT_DECD_FK1');
200: --
201: end if;
202: --
203: close c1;

Line 247: from ben_ext_data_elmt_decd

243: is
244: l_proc varchar2(72) := g_package||'chk_val_unique';
245: l_dummy char(1);
246: cursor c1 is select null
247: from ben_ext_data_elmt_decd
248: Where ext_data_elmt_id = p_ext_data_elmt_id
249: and ext_data_elmt_decd_id <> nvl(p_ext_data_elmt_decd_id,-1)
250: and val = p_val
251: -- and business_group_id = p_business_group_id

Line 535: ben_ext_data_elmt_decd b

531: --
532: cursor csr_leg_code is
533: select a.legislation_code
534: from per_business_groups a,
535: ben_ext_data_elmt_decd b
536: where b.ext_data_elmt_decd_id = p_ext_data_elmt_decd_id
537: and a.business_group_id(+) = b.business_group_id;
538: --
539: -- Declare local variables