[Home] [Help]
55: <> ben_brc_shd.g_old_rec.bnft_rstrn_ctfn_id) then
56: --
57: -- raise error as PK has changed
58: --
59: ben_brc_shd.constraint_error('BEN_BNFT_RSTRN_CTFN_F_PK');
60: --
61: elsif not l_api_updating then
62: --
63: -- check if PK is null
65: if p_bnft_rstrn_ctfn_id is not null then
66: --
67: -- raise error as PK is not null
68: --
69: ben_brc_shd.constraint_error('BEN_BNFT_RSTRN_CTFN_F_PK');
70: --
71: end if;
72: --
73: end if;
232: -- None.
233: --
234: -- In Parameters
235: -- p_pl_id plan id
236: -- p_bnft_rstrn_ctfn_id Primary Key for BEN_BNFT_RSTRN_CTFN_F
237: -- p_validation_start_date
238: -- p_validation_end_date
239: -- p_enrt_ctfn_typ_cd Enrollment Certification Type Code
240: -- p_ctfn_rqd_when_rl Certification Required When Rule
261: is
262: l_proc varchar2(72) := g_package||'chk_cd_and_rl_unique';
263: l_dummy char(1);
264: cursor c1 is select null
265: from ben_bnft_rstrn_ctfn_f
266: Where bnft_rstrn_ctfn_id <> nvl(p_bnft_rstrn_ctfn_id,-1)
267: and enrt_ctfn_typ_cd || to_char(ctfn_rqd_when_rl) ||
268: to_char(pl_id) = p_enrt_ctfn_typ_cd ||
269: to_char(p_ctfn_rqd_when_rl) || to_char(p_pl_id)
715: --
716: cursor csr_leg_code is
717: select a.legislation_code
718: from per_business_groups a,
719: ben_bnft_rstrn_ctfn_f b
720: where b.bnft_rstrn_ctfn_id = p_bnft_rstrn_ctfn_id
721: and a.business_group_id = b.business_group_id;
722: --
723: -- Declare local variables