APPS.BEN_ECF_BUS dependencies on BEN_ENRT_CTFN_F

Line 59: ben_ecf_shd.constraint_error('BEN_ENRT_CTFN_F_PK');

55: <> ben_ecf_shd.g_old_rec.enrt_ctfn_id) then
56: --
57: -- raise error as PK has changed
58: --
59: ben_ecf_shd.constraint_error('BEN_ENRT_CTFN_F_PK');
60: --
61: elsif not l_api_updating then
62: --
63: -- check if PK is null

Line 69: ben_ecf_shd.constraint_error('BEN_ENRT_CTFN_F_PK');

65: if p_enrt_ctfn_id is not null then
66: --
67: -- raise error as PK is not null
68: --
69: ben_ecf_shd.constraint_error('BEN_ENRT_CTFN_F_PK');
70: --
71: end if;
72: --
73: end if;

Line 162: -- p_enrt_ctfn_id is primary key for ben_enrt_ctfn_f

158: -- None.
159: --
160: -- In Parameters
161: -- p_enrt_ctfn_typ_cd is dependent certification type code
162: -- p_enrt_ctfn_id is primary key for ben_enrt_ctfn_f
163: -- p_pl_id
164: -- p_oipl_id
165: -- p_business_group_id
166: -- p_validation_start_date

Line 192: from ben_enrt_ctfn_f

188: l_proc varchar2(72) := g_package||'chk_enrt_ctfn_typ_cd_unique';
189: l_dummy char(1);
190: --
191: cursor c1 is select null
192: from ben_enrt_ctfn_f
193: Where enrt_ctfn_id <> nvl(p_enrt_ctfn_id,-1)
194: and nvl(enrt_ctfn_typ_cd,0) = nvl(p_enrt_ctfn_typ_cd,0)
195: and (pl_id = p_pl_id
196: or oipl_id = p_oipl_id)

Line 736: ben_enrt_ctfn_f b

732: --
733: cursor csr_leg_code is
734: select a.legislation_code
735: from per_business_groups a,
736: ben_enrt_ctfn_f b
737: where b.enrt_ctfn_id = p_enrt_ctfn_id
738: and a.business_group_id = b.business_group_id;
739: --
740: -- Declare local variables