APPS.BEN_PTY_BUS dependencies on BEN_PL_PCP

Line 62: ben_pty_shd.constraint_error('BEN_PL_PCP_TYP_PK');

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

Line 72: ben_pty_shd.constraint_error('BEN_PL_PCP_TYP_PK');

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

Line 117: from ben_pl_pcp a

113: l_dummy varchar2(1);
114: --
115: cursor c1 is
116: select null
117: from ben_pl_pcp a
118: where a.pl_pcp_id = p_pl_pcp_id;
119: --
120: Begin
121: --

Line 133: -- check if pl_pcp_id value exists in ben_pl_pcp table

129: and nvl(p_pl_pcp_id,hr_api.g_number)
130: <> nvl(ben_pty_shd.g_old_rec.pl_pcp_id,hr_api.g_number)
131: or not l_api_updating) then
132: --
133: -- check if pl_pcp_id value exists in ben_pl_pcp table
134: --
135: open c1;
136: --
137: fetch c1 into l_dummy;

Line 142: -- raise error as FK does not relate to PK in ben_pl_pcp

138: if c1%notfound then
139: --
140: close c1;
141: --
142: -- raise error as FK does not relate to PK in ben_pl_pcp
143: -- table.
144: --
145: ben_pty_shd.constraint_error('BEN_PL_PCP_TYP_FK2');
146: --

Line 145: ben_pty_shd.constraint_error('BEN_PL_PCP_TYP_FK2');

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

Line 315: -- This procedure is used to check that the ben_pl_pcp_type record could not be created

311: -- |------< chk_pl_pcp_typ_record >------|
312: -- ----------------------------------------------------------------------------
313: --
314: -- Description
315: -- This procedure is used to check that the ben_pl_pcp_type record could not be created
316: -- unless the pcp_rpstry_flag = 'Y'
317: --
318: -- Pre Conditions
319: -- None.

Line 343: from ben_pl_pcp

339: --l_name ben_acty_base_rt_f.name%type ;
340:
341: --cursor to check the pcp_rpstry_flag
342: cursor c1 is select pcp_rpstry_flag
343: from ben_pl_pcp
344: Where pl_pcp_id = p_pl_pcp_id;
345:
346: --
347: Begin

Line 375: , ben_pl_pcp_typ pty

371: --
372: cursor csr_sec_grp is
373: select pbg.security_group_id
374: from per_business_groups pbg
375: , ben_pl_pcp_typ pty
376: where pty.pl_pcp_typ_id = p_pl_pcp_typ_id
377: and pbg.business_group_id = pty.business_group_id;
378: --
379: -- Declare local variables

Line 435: , ben_pl_pcp_typ pty

431: --
432: cursor csr_leg_code is
433: select pbg.legislation_code
434: from per_business_groups pbg
435: , ben_pl_pcp_typ pty
436: where pty.pl_pcp_typ_id = p_pl_pcp_typ_id
437: and pbg.business_group_id = pty.business_group_id;
438: --
439: -- Declare local variables