APPS.BEN_EGL_SHD dependencies on BEN_ELIGY_CRITERIA

Line 37: If (p_constraint_name = 'BEN_eligy_criteria_FK1') Then

33: --
34: Begin
35: hr_utility.set_location('Entering:'||l_proc, 5);
36: --
37: If (p_constraint_name = 'BEN_eligy_criteria_FK1') Then
38: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
39: hr_utility.set_message_token('PROCEDURE', l_proc);
40: hr_utility.set_message_token('STEP','5');
41: hr_utility.raise_error;

Line 42: ElsIf (p_constraint_name = 'BEN_eligy_criteria_PK') Then

38: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
39: hr_utility.set_message_token('PROCEDURE', l_proc);
40: hr_utility.set_message_token('STEP','5');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'BEN_eligy_criteria_PK') Then
43: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP','10');
46: hr_utility.raise_error;

Line 134: from ben_eligy_criteria

130: allow_range_validation_flag2,
131: access_calc_rule2,
132: time_access_calc_rule1,
133: time_access_calc_rule2
134: from ben_eligy_criteria
135: where eligy_criteria_id = p_eligy_criteria_id;
136: --
137: l_proc varchar2(72) := g_package||'api_updating';
138: l_fct_ret boolean;

Line 266: from ben_eligy_criteria

262: allow_range_validation_flag2,
263: access_calc_rule2,
264: time_access_calc_rule1,
265: time_access_calc_rule2
266: from ben_eligy_criteria
267: where eligy_criteria_id = p_eligy_criteria_id
268: for update nowait;
269: --
270: l_proc varchar2(72) := g_package||'lck';

Line 313: hr_utility.set_message_token('TABLE_NAME', 'ben_eligy_criteria');

309: -- The object is locked therefore we need to supply a meaningful
310: -- error message.
311: --
312: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
313: hr_utility.set_message_token('TABLE_NAME', 'ben_eligy_criteria');
314: hr_utility.raise_error;
315: End lck;
316: --
317: -- ----------------------------------------------------------------------------