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_DRR_BUS dependencies on BEN_DSGN_RQMT_RLSHP_TYP

Line 57: ben_drr_shd.constraint_error('BEN_DSGN_RQMT_RLSHP_TYP_PK');

53: <> ben_drr_shd.g_old_rec.dsgn_rqmt_rlshp_typ_id) then
54: --
55: -- raise error as PK has changed
56: --
57: ben_drr_shd.constraint_error('BEN_DSGN_RQMT_RLSHP_TYP_PK');
58: --
59: elsif not l_api_updating then
60: --
61: -- check if PK is null

Line 67: ben_drr_shd.constraint_error('BEN_DSGN_RQMT_RLSHP_TYP_PK');

63: if p_dsgn_rqmt_rlshp_typ_id is not null then
64: --
65: -- raise error as PK is not null
66: --
67: ben_drr_shd.constraint_error('BEN_DSGN_RQMT_RLSHP_TYP_PK');
68: --
69: end if;
70: --
71: end if;

Line 145: ben_drr_shd.constraint_error('BEN_DSGN_RQMT_RLSHP_TYP_DT1');

141: --
142: -- raise error as FK does not relate to PK in ben_dsgn_rqmt_f
143: -- table.
144: --
145: ben_drr_shd.constraint_error('BEN_DSGN_RQMT_RLSHP_TYP_DT1');
146: --
147: end if;
148: --
149: close c1;

Line 321: from ben_dsgn_rqmt_rlshp_typ

317: l_dummy varchar2(1);
318: --
319: cursor c_chk_uniq_dsgn_rqmt is
320: select 'X'
321: from ben_dsgn_rqmt_rlshp_typ
322: where dsgn_rqmt_id = p_dsgn_rqmt_id
323: and rlshp_typ_cd = p_rlshp_typ_cd
324: and business_group_id = p_business_group_id
325: and dsgn_rqmt_rlshp_typ_id <> nvl(p_dsgn_rqmt_rlshp_typ_id, -999);

Line 461: ben_dsgn_rqmt_rlshp_typ b

457: --
458: cursor csr_leg_code is
459: select a.legislation_code
460: from per_business_groups a,
461: ben_dsgn_rqmt_rlshp_typ b
462: where b.dsgn_rqmt_rlshp_typ_id = p_dsgn_rqmt_rlshp_typ_id
463: and a.business_group_id = b.business_group_id;
464: --
465: -- Declare local variables