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_PCP_BUS dependencies on BEN_PL_PCP

Line 62: ben_pcp_shd.constraint_error('BEN_PL_PCP_PK');

58: <> ben_pcp_shd.g_old_rec.pl_pcp_id) then
59: --
60: -- raise error as PK has changed
61: --
62: ben_pcp_shd.constraint_error('BEN_PL_PCP_PK');
63: --
64: elsif not l_api_updating then
65: --
66: -- check if PK is null

Line 72: ben_pcp_shd.constraint_error('BEN_PL_PCP_PK');

68: if p_pl_pcp_id is not null then
69: --
70: -- raise error as PK is not null
71: --
72: ben_pcp_shd.constraint_error('BEN_PL_PCP_PK');
73: --
74: end if;
75: --
76: end if;

Line 116: from ben_pl_pcp pcp

112: --cursor to check the row exists in the database or not
113:
114: cursor c1 is
115: select pcp.pl_pcp_id
116: from ben_pl_pcp pcp
117: Where pcp.pl_id = p_pl_id
118: and pcp.pl_pcp_id <> nvl(p_pl_pcp_id,-1)
119: ;
120:

Line 639: -- This procedure is used to check that the ben_pl_pcp record for plans that are

635: -- |------< 3 chk_pl_pcp_record >------|
636: -- ----------------------------------------------------------------------------
637: --
638: -- Description
639: -- This procedure is used to check that the ben_pl_pcp record for plans that are
640: -- savings, inputed icome nor flex-plans could not be created
641: --
642: -- Pre Conditions
643: -- None.

Line 750: -- This procedure is used to check that the plan cannot have a ben_pl_pcp row

746: -- |------< 5 chk_pl_pcp_rpstry >------|
747: -- ----------------------------------------------------------------------------
748: --
749: -- Description
750: -- This procedure is used to check that the plan cannot have a ben_pl_pcp row
751: -- with pcp_rpstry_flag = 'Y' until it has a ben_popl_org_f/ben_popl_org_role_f
752: --
753: -- Pre Conditions
754: -- None.

Line 810: , ben_pl_pcp pcp

806: --
807: cursor csr_sec_grp is
808: select pbg.security_group_id
809: from per_business_groups pbg
810: , ben_pl_pcp pcp
811: where pcp.pl_pcp_id = p_pl_pcp_id
812: and pbg.business_group_id = pcp.business_group_id;
813: --
814: -- Declare local variables

Line 870: , ben_pl_pcp pcp

866: --
867: cursor csr_leg_code is
868: select pbg.legislation_code
869: from per_business_groups pbg
870: , ben_pl_pcp pcp
871: where pcp.pl_pcp_id = p_pl_pcp_id
872: and pbg.business_group_id = pcp.business_group_id;
873: --
874: -- Declare local variables