APPS.BEN_XWC_BUS dependencies on BEN_EXT_DATA_ELMT

Line 220: from ben_ext_data_elmt_in_rcd a

216: l_dummy varchar2(1);
217: --
218: cursor c1 is
219: select null
220: from ben_ext_data_elmt_in_rcd a
221: where a.ext_data_elmt_in_rcd_id = p_cond_ext_data_elmt_in_rcd_id;
222: --
223: Begin
224: --

Line 237: -- check if cond_ext_data_elmt_in_rcd_id value exists in ben_ext_data_elmt_in_rcd table

233: <> nvl(ben_xwc_shd.g_old_rec.cond_ext_data_elmt_in_rcd_id,hr_api.g_number)
234: or not l_api_updating) and
235: p_cond_ext_data_elmt_in_rcd_id is not null then
236: --
237: -- check if cond_ext_data_elmt_in_rcd_id value exists in ben_ext_data_elmt_in_rcd table
238: --
239: open c1;
240: --
241: fetch c1 into l_dummy;

Line 246: -- raise error as FK does not relate to PK in ben_ext_data_elmt_in_rcd

242: if c1%notfound then
243: --
244: close c1;
245: --
246: -- raise error as FK does not relate to PK in ben_ext_data_elmt_in_rcd
247: -- table.
248: --
249: ben_xwc_shd.constraint_error('BEN_EXT_WHERE_CLAUSE_FK6');
250: --

Line 372: from ben_ext_data_elmt_in_rcd a

368: l_dummy varchar2(1);
369: --
370: cursor c1 is
371: select null
372: from ben_ext_data_elmt_in_rcd a
373: where a.ext_data_elmt_in_rcd_id = p_ext_data_elmt_in_rcd_id;
374: --
375: Begin
376: --

Line 389: -- check if ext_data_elmt_in_rcd_id value exists in ben_ext_data_elmt_in_rcd table

385: <> nvl(ben_xwc_shd.g_old_rec.ext_data_elmt_in_rcd_id,hr_api.g_number)
386: or not l_api_updating) and
387: p_ext_data_elmt_in_rcd_id is not null then
388: --
389: -- check if ext_data_elmt_in_rcd_id value exists in ben_ext_data_elmt_in_rcd table
390: --
391: open c1;
392: --
393: fetch c1 into l_dummy;

Line 398: -- raise error as FK does not relate to PK in ben_ext_data_elmt_in_rcd

394: if c1%notfound then
395: --
396: close c1;
397: --
398: -- raise error as FK does not relate to PK in ben_ext_data_elmt_in_rcd
399: -- table.
400: --
401: ben_xwc_shd.constraint_error('BEN_EXT_WHERE_CLAUSE_FK3');
402: --

Line 448: from ben_ext_data_elmt a

444: l_dummy varchar2(1);
445: --
446: cursor c1 is
447: select null
448: from ben_ext_data_elmt a
449: where a.ext_data_elmt_id = p_cond_ext_data_elmt_id;
450: --
451: Begin
452: --

Line 465: -- check if cond_ext_data_elmt_id value exists in ben_ext_data_elmt table

461: <> nvl(ben_xwc_shd.g_old_rec.cond_ext_data_elmt_id,hr_api.g_number)
462: or not l_api_updating) and
463: p_cond_ext_data_elmt_id is not null then
464: --
465: -- check if cond_ext_data_elmt_id value exists in ben_ext_data_elmt table
466: --
467: open c1;
468: --
469: fetch c1 into l_dummy;

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

470: if c1%notfound then
471: --
472: close c1;
473: --
474: -- raise error as FK does not relate to PK in ben_ext_data_elmt
475: -- table.
476: --
477: ben_xwc_shd.constraint_error('BEN_EXT_WHERE_CLAUSE_FK2');
478: --

Line 524: from ben_ext_data_elmt a

520: l_dummy varchar2(1);
521: --
522: cursor c1 is
523: select null
524: from ben_ext_data_elmt a
525: where a.ext_data_elmt_id = p_ext_data_elmt_id;
526: --
527: Begin
528: --

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

537: <> nvl(ben_xwc_shd.g_old_rec.ext_data_elmt_id,hr_api.g_number)
538: or not l_api_updating) and
539: p_ext_data_elmt_id is not null then
540: --
541: -- check if ext_data_elmt_id value exists in ben_ext_data_elmt table
542: --
543: open c1;
544: --
545: fetch c1 into l_dummy;

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

546: if c1%notfound then
547: --
548: close c1;
549: --
550: -- raise error as FK does not relate to PK in ben_ext_data_elmt
551: -- table.
552: --
553: ben_xwc_shd.constraint_error('BEN_EXT_WHERE_CLAUSE_FK1');
554: --