[Home] [Help]
55: <> ben_ptp_shd.g_old_rec.pl_typ_id) then
56: --
57: -- raise error as PK has changed
58: --
59: ben_ptp_shd.constraint_error('BEN_PL_TYP_F_PK');
60: --
61: elsif not l_api_updating then
62: --
63: -- check if PK is null
65: if p_pl_typ_id is not null then
66: --
67: -- raise error as PK is not null
68: --
69: ben_ptp_shd.constraint_error('BEN_PL_TYP_F_PK');
70: --
71: end if;
72: --
73: end if;
300: -- In Parameters
301: -- pl_typ_id PK of record being inserted or updated.
302: -- opt_typ_cd Value of lookup code.
303: -- effective_date effective date
304: -- business_group_id Business group of the plan (null allowed in ben_pl_typ_f)
305: -- object_version_number Object version number of record being
306: -- inserted or updated.
307: --
308: -- Post Success
662: --
663: --
664: cursor csr_name is
665: select null
666: from BEN_PL_TYP_F
667: where name = p_name
668: and pl_typ_id <> nvl(p_pl_typ_id, hr_api.g_number)
669: and business_group_id + 0 = p_business_group_id
670: and p_validation_start_date <= effective_end_date
695: -- raise error as UK1 is violated
696: --
697: fnd_message.set_name('BEN', 'BEN_91009_NAME_NOT_UNIQUE');
698: fnd_message.raise_error;
699: -- ben_reg_shd.constraint_error('BEN_PL_TYP_F_UK1');
700: --
701: end if;
702: --
703: close csr_name;
838: --
839:
840: cursor c_opt_typ_cd is
841: select 1
842: from ben_pl_typ_f
843: where opt_typ_cd = 'GSP'
844: and pl_typ_id <> nvl(p_pl_typ_id, hr_api.g_number)
845: and p_effective_date between effective_start_date and effective_end_date
846: and business_group_id = p_business_group_id
1352: --
1353: cursor csr_leg_code is
1354: select a.legislation_code
1355: from per_business_groups a,
1356: ben_pl_typ_f b
1357: where b.pl_typ_id = p_pl_typ_id
1358: and a.business_group_id = b.business_group_id;
1359: --
1360: -- Declare local variables