59: <> ben_ecv_shd.g_old_rec.eligy_crit_values_id) then
60: --
61: -- raise error as PK has changed
62: --
63: ben_ecv_shd.constraint_error('BEN_ELIGY_CRIT_VALUES_F_PK');
64: --
65: elsif not l_api_updating then
66: --
67: --check if PK is NULL
69: if p_eligy_crit_values_id is not null then
70: --
71: -- raise error as PK is not null
72: --
73: ben_ecv_shd.constraint_error('BEN_ELIGY_CRIT_VALUES_F_PK');
74: --
75: end if;
76: --
77: end if;
144: close csr_eligy_criteria_id;
145: --
146: --Raise an error
147: --
148: ben_ecv_shd.constraint_error('BEN_ELIGY_CRIT_VALUES_FK1');
149: --
150: end if;
151: --
152: close csr_eligy_criteria_id;
220: --
221: close csr_eligy_prfl_id;
222: --Raise an error
223: --
224: ben_ecv_shd.constraint_error('BEN_ELIGY_CRIT_VALUES_FK1');
225: --
226: end if;
227: --
228: close csr_eligy_prfl_id;
265: l_dummy varchar2(1);
266: --
267: cursor c_eligy_prfl is
268: select null
269: from ben_eligy_crit_values_f ecv
270: where ecv.eligy_prfl_id = p_eligy_prfl_id
271: and ecv.eligy_criteria_id = p_eligy_criteria_id
272: and ecv.eligy_crit_values_id <> nvl ( p_eligy_crit_values_id, -1)
273: and nvl(ecv.number_value1,hr_api.g_number) = nvl(p_number_value1,hr_api.g_number)
352: l_dummy char(1);
353: --
354: cursor c1 is
355: select null
356: from ben_eligy_crit_values_f
357: where eligy_crit_values_id <> nvl( p_eligy_crit_values_id, -1 )
358: and eligy_prfl_id = p_eligy_prfl_id
359: and ordr_num = p_ordr_num
360: and business_group_id = p_business_group_id
1284: --
1285: cursor csr_leg_code is
1286: select a.legislation_code
1287: from per_business_groups a,
1288: ben_eligy_crit_values_f b
1289: where b.eligy_crit_values_id = p_eligy_crit_values_id
1290: and a.business_group_id = b.business_group_id;
1291: --
1292: -- Declare local variables