eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_ECV_SHD dependencies on BEN_ELIGY_CRIT_VALUES_F

Line 36: If (p_constraint_name = 'BEN_ELIGY_CRIT_VALUES_F_FK1'

32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_ELIGY_CRIT_VALUES_F_FK1'
37: OR p_constraint_name = 'BEN_ELIGY_CRIT_VALUES_F_FK2'
38: OR p_constraint_name = 'BEN_ELIGY_CRIT_VALUES_F_FK3') Then
39: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
40: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 37: OR p_constraint_name = 'BEN_ELIGY_CRIT_VALUES_F_FK2'

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

Line 38: OR p_constraint_name = 'BEN_ELIGY_CRIT_VALUES_F_FK3') Then

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

Line 43: ElsIf (p_constraint_name = 'BEN_ELIGY_CRIT_VALUES_F_PK') Then

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

Line 127: from ben_eligy_crit_values_f

123: Number_value3,
124: Number_value4,
125: Date_value3,
126: Date_value4
127: from ben_eligy_crit_values_f
128: where eligy_crit_values_id = p_eligy_crit_values_id
129: and p_effective_date
130: between effective_start_date
131: and effective_end_date;

Line 202: from ben_eligy_crit_values_f t

198: l_parent_key_value2 number;
199: --
200: Cursor C_Sel1 Is
201: select t.eligy_criteria_id, t.eligy_prfl_id
202: from ben_eligy_crit_values_f t
203: where t.eligy_crit_values_id = p_base_key_value
204: and p_effective_date
205: between t.effective_start_date and t.effective_end_date;
206: --

Line 224: p_base_table_name => 'ben_eligy_crit_values_f',

220: -- Call the corresponding datetrack api
221: --
222: dt_api.find_dt_del_modes
223: (p_effective_date => p_effective_date,
224: p_base_table_name => 'ben_eligy_crit_values_f',
225: p_base_key_column => 'eligy_crit_values_id',
226: p_base_key_value => p_base_key_value,
227: -- p_parent_table_name1 => 'ben_eligy_criteria',
228: -- p_parent_key_column1 => 'eligy_criteria_id',

Line 261: p_base_table_name => 'ben_eligy_crit_values_f',

257: -- Call the corresponding datetrack api
258: --
259: dt_api.find_dt_upd_modes
260: (p_effective_date => p_effective_date,
261: p_base_table_name => 'ben_eligy_crit_values_f',
262: p_base_key_column => 'eligy_crit_values_id',
263: p_base_key_value => p_base_key_value,
264: p_correction => p_correction,
265: p_update => p_update,

Line 294: (p_base_table_name => 'ben_eligy_crit_values_f',

290: -- version number.
291: --
292: l_object_version_number :=
293: dt_api.get_object_version_number
294: (p_base_table_name => 'ben_eligy_crit_values_f',
295: p_base_key_column => 'eligy_crit_values_id',
296: p_base_key_value => p_base_key_value);
297: --
298: hr_utility.set_location(l_proc, 10);

Line 304: update ben_eligy_crit_values_f t

300: --
301: -- Update the specified datetrack row setting the effective
302: -- end date to the specified new effective end date.
303: --
304: update ben_eligy_crit_values_f t
305: set t.effective_end_date = p_new_effective_end_date,
306: t.object_version_number = l_object_version_number
307: where t.eligy_crit_values_id = p_base_key_value
308: and p_effective_date

Line 398: from ben_eligy_crit_values_f

394: Number_value3,
395: Number_value4,
396: Date_value3,
397: Date_value4
398: from ben_eligy_crit_values_f
399: where eligy_crit_values_id = p_eligy_crit_values_id
400: and p_effective_date
401: between effective_start_date
402: and effective_end_date

Line 458: p_base_table_name => 'ben_eligy_crit_values_f',

454: --
455: dt_api.validate_dt_mode
456: (p_effective_date => p_effective_date,
457: p_datetrack_mode => p_datetrack_mode,
458: p_base_table_name => 'ben_eligy_crit_values_f',
459: p_base_key_column => 'eligy_crit_values_id',
460: p_base_key_value => p_eligy_crit_values_id,
461: -- p_parent_table_name1 => 'ben_eligy_criteria',
462: -- p_parent_key_column1 => 'eligy_criteria_id',

Line 498: hr_utility.set_message_token('TABLE_NAME', 'ben_eligy_crit_values_f');

494: -- The object is locked therefore we need to supply a meaningful
495: -- error message.
496: --
497: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
498: hr_utility.set_message_token('TABLE_NAME', 'ben_eligy_crit_values_f');
499: hr_utility.raise_error;
500: When l_object_invalid then
501: --
502: -- The object doesn't exist or is invalid

Line 505: hr_utility.set_message_token('TABLE_NAME', 'ben_eligy_crit_values_f');

501: --
502: -- The object doesn't exist or is invalid
503: --
504: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
505: hr_utility.set_message_token('TABLE_NAME', 'ben_eligy_crit_values_f');
506: hr_utility.raise_error;
507: End lck;
508: --
509: -- ----------------------------------------------------------------------------