56: <> ben_lpl_shd.g_old_rec.ler_per_info_cs_ler_id) then
57: --
58: -- raise error as PK has changed
59: --
60: ben_lpl_shd.constraint_error('BEN_LER_PER_INFO_CS_LER_F_PK');
61: --
62: elsif not l_api_updating then
63: --
64: -- check if PK is null
66: if p_ler_per_info_cs_ler_id is not null then
67: --
68: -- raise error as PK is not null
69: --
70: ben_lpl_shd.constraint_error('BEN_LER_PER_INFO_CS_LER_F_PK');
71: --
72: end if;
73: --
74: end if;
131: ,p_business_group_id number
132: ,p_validation_start_date date
133: ,p_validation_end_date date) IS
134: SELECT 'x'
135: FROM ben_ler_per_info_cs_ler_f
136: WHERE ler_per_info_cs_ler_id <> nvl(p_ler_per_info_cs_ler_id, hr_api.g_number)
137: AND per_info_chg_cs_ler_id = p_per_info_chg_cs_ler_id
138: AND ler_id = p_ler_id
139: AND business_group_id + 0 = p_business_group_id
167: if c1%notfound then
168: close c1;
169: -- raise error as FK does not relate to PK in ben_per_info_chg_cs_ler
170: -- table.
171: ben_lpl_shd.constraint_error('BEN_LER_PER_INFO_CS_LER_FK2');
172: end if;
173: close c1;
174: --
175: -- check if per_info_chg_cs_ler_id is unique for this ler.
517: l_source_table varchar2(30);
518: --
519: cursor c_check_multiple(p_source_table varchar2) is
520: select null
521: from ben_ler_per_info_cs_ler_f lpl,
522: ben_per_info_chg_cs_ler_f psl
523: where lpl.ler_per_info_cs_ler_id <> nvl(p_ler_per_info_cs_ler_id,-1)
524: and lpl.ler_id = p_ler_id
525: and p_effective_date
937: --
938: cursor csr_leg_code is
939: select a.legislation_code
940: from per_business_groups a,
941: ben_ler_per_info_cs_ler_f b
942: where b.ler_per_info_cs_ler_id = p_ler_per_info_cs_ler_id
943: and a.business_group_id = b.business_group_id;
944: --
945: -- Declare local variables