[Home] [Help]
52: <> ben_enp_shd.g_old_rec.enrt_perd_id) then
53: --
54: -- raise error as PK has changed
55: --
56: ben_enp_shd.constraint_error('BEN_ENRT_PERD_PK');
57: --
58: elsif not l_api_updating then
59: --
60: -- check if PK is null
62: if p_enrt_perd_id is not null then
63: --
64: -- raise error as PK is not null
65: --
66: ben_enp_shd.constraint_error('BEN_ENRT_PERD_PK');
67: --
68: end if;
69: --
70: end if;
140: --
141: -- raise error as FK does not relate to PK in ben_popl_enrt_typ_cycl_f
142: -- table.
143: --
144: ben_enp_shd.constraint_error('BEN_ENRT_PERD_DT1');
145: --
146: end if;
147: --
148: close c1;
197: --
198: /*
199: cursor chk_unique is
200: select null
201: from ben_enrt_perd
202: where yr_perd_id = p_yr_perd_id
203: and enrt_perd_id <> nvl(p_enrt_perd_id, hr_api.g_number)
204: and popl_enrt_typ_cycl_id = p_popl_enrt_typ_cycl_id
205: and business_group_id + 0 = p_business_group_id;
231: --
232: -- raise error as FK does not relate to PK in ben_yr_perd
233: -- table.
234: --
235: ben_enp_shd.constraint_error('BEN_ENRT_PERD_FK1');
236: --
237: end if;
238: --
239: close c1;
384: l_dummy char;
385: --
386: cursor c_dup_enp is
387: select null
388: from ben_enrt_perd enp
389: where enp.popl_enrt_typ_cycl_id = p_popl_enrt_typ_cycl_id
390: and enp.enrt_perd_id <> nvl(p_enrt_perd_id, hr_api.g_number)
391: and enp.asnd_lf_evt_dt = p_asnd_lf_evt_dt
392: and enp.business_group_id = p_business_group_id ;
2262: cursor c_pl_cd is
2263: select pln.pl_cd
2264: from ben_pl_f pln
2265: ,ben_popl_enrt_typ_cycl_f pet
2266: ,ben_enrt_perd enp
2267: where pet.popl_enrt_typ_cycl_id = p_popl_enrt_typ_cycl_id
2268: and pet.pl_id = pln.pl_id
2269: and pln.business_group_id = p_business_group_id
2270: and pet.business_group_id = pln.business_group_id
2826: --
2827: cursor csr_leg_code is
2828: select a.legislation_code
2829: from per_business_groups a,
2830: ben_enrt_perd b
2831: where b.enrt_perd_id = p_enrt_perd_id
2832: and a.business_group_id = b.business_group_id;
2833: --
2834: -- Declare local variables