APPS.BEN_ECV_BUS dependencies on BEN_ELIGY_CRIT_VALUES_F

Line 63: ben_ecv_shd.constraint_error('BEN_ELIGY_CRIT_VALUES_F_PK');

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

Line 73: ben_ecv_shd.constraint_error('BEN_ELIGY_CRIT_VALUES_F_PK');

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;

Line 148: ben_ecv_shd.constraint_error('BEN_ELIGY_CRIT_VALUES_FK1');

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;

Line 224: ben_ecv_shd.constraint_error('BEN_ELIGY_CRIT_VALUES_FK1');

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;

Line 269: from ben_eligy_crit_values_f ecv

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)

Line 356: from ben_eligy_crit_values_f

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

Line 1288: ben_eligy_crit_values_f b

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