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_DPNT_EDC_SHD dependencies on BEN_DPNT_ELIGY_CRIT_VALUES_F

Line 36: If (p_constraint_name = 'BEN_DPNT_ELIGY_CRIT_VALUES_F_FK1'

32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_DPNT_ELIGY_CRIT_VALUES_F_FK1'
37: OR p_constraint_name = 'BEN_DPNT_ELIGY_CRIT_VALUES_F_FK2'
38: OR p_constraint_name = 'BEN_DPNT_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_DPNT_ELIGY_CRIT_VALUES_F_FK2'

33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_DPNT_ELIGY_CRIT_VALUES_F_FK1'
37: OR p_constraint_name = 'BEN_DPNT_ELIGY_CRIT_VALUES_F_FK2'
38: OR p_constraint_name = 'BEN_DPNT_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_DPNT_ELIGY_CRIT_VALUES_F_FK3') Then

34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_DPNT_ELIGY_CRIT_VALUES_F_FK1'
37: OR p_constraint_name = 'BEN_DPNT_ELIGY_CRIT_VALUES_F_FK2'
38: OR p_constraint_name = 'BEN_DPNT_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_dpnt_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_dpnt_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 124: from ben_dpnt_eligy_crit_values_f

120: Number_value3,
121: Number_value4,
122: Date_value3,
123: Date_value4
124: from ben_dpnt_eligy_crit_values_f
125: where dpnt_eligy_crit_values_id = p_dpnt_eligy_crit_values_id
126: and p_effective_date
127: between effective_start_date
128: and effective_end_date;

Line 199: from ben_dpnt_eligy_crit_values_f t

195: l_parent_key_value2 number;
196: --
197: Cursor C_Sel1 Is
198: select t.eligy_criteria_dpnt_id, t.dpnt_cvg_eligy_prfl_id
199: from ben_dpnt_eligy_crit_values_f t
200: where t.dpnt_eligy_crit_values_id = p_base_key_value
201: and p_effective_date
202: between t.effective_start_date and t.effective_end_date;
203: --

Line 221: p_base_table_name => 'ben_dpnt_eligy_crit_values_f',

217: -- Call the corresponding datetrack api
218: --
219: dt_api.find_dt_del_modes
220: (p_effective_date => p_effective_date,
221: p_base_table_name => 'ben_dpnt_eligy_crit_values_f',
222: p_base_key_column => 'dpnt_eligy_crit_values_id',
223: p_base_key_value => p_base_key_value,
224: -- p_parent_table_name1 => 'ben_eligy_criteria',
225: -- p_parent_key_column1 => 'eligy_criteria_dpnt_id',

Line 258: p_base_table_name => 'ben_dpnt_eligy_crit_values_f',

254: -- Call the corresponding datetrack api
255: --
256: dt_api.find_dt_upd_modes
257: (p_effective_date => p_effective_date,
258: p_base_table_name => 'ben_dpnt_eligy_crit_values_f',
259: p_base_key_column => 'dpnt_eligy_crit_values_id',
260: p_base_key_value => p_base_key_value,
261: p_correction => p_correction,
262: p_update => p_update,

Line 291: (p_base_table_name => 'ben_dpnt_eligy_crit_values_f',

287: -- version number.
288: --
289: l_object_version_number :=
290: dt_api.get_object_version_number
291: (p_base_table_name => 'ben_dpnt_eligy_crit_values_f',
292: p_base_key_column => 'dpnt_eligy_crit_values_id',
293: p_base_key_value => p_base_key_value);
294: --
295: hr_utility.set_location(l_proc, 10);

Line 301: update ben_dpnt_eligy_crit_values_f t

297: --
298: -- Update the specified datetrack row setting the effective
299: -- end date to the specified new effective end date.
300: --
301: update ben_dpnt_eligy_crit_values_f t
302: set t.effective_end_date = p_new_effective_end_date,
303: t.object_version_number = l_object_version_number
304: where t.dpnt_eligy_crit_values_id = p_base_key_value
305: and p_effective_date

Line 392: from ben_dpnt_eligy_crit_values_f

388: Number_value3,
389: Number_value4,
390: Date_value3,
391: Date_value4
392: from ben_dpnt_eligy_crit_values_f
393: where dpnt_eligy_crit_values_id = p_dpnt_eligy_crit_values_id
394: and p_effective_date
395: between effective_start_date
396: and effective_end_date

Line 452: p_base_table_name => 'ben_dpnt_eligy_crit_values_f',

448: --
449: dt_api.validate_dt_mode
450: (p_effective_date => p_effective_date,
451: p_datetrack_mode => p_datetrack_mode,
452: p_base_table_name => 'ben_dpnt_eligy_crit_values_f',
453: p_base_key_column => 'dpnt_eligy_crit_values_id',
454: p_base_key_value => p_dpnt_eligy_crit_values_id,
455: -- p_parent_table_name1 => 'ben_eligy_criteria',
456: -- p_parent_key_column1 => 'eligy_criteria_dpnt_id',

Line 492: hr_utility.set_message_token('TABLE_NAME', 'ben_dpnt_eligy_crit_values_f');

488: -- The object is locked therefore we need to supply a meaningful
489: -- error message.
490: --
491: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
492: hr_utility.set_message_token('TABLE_NAME', 'ben_dpnt_eligy_crit_values_f');
493: hr_utility.raise_error;
494: When l_object_invalid then
495: --
496: -- The object doesn't exist or is invalid

Line 499: hr_utility.set_message_token('TABLE_NAME', 'ben_dpnt_eligy_crit_values_f');

495: --
496: -- The object doesn't exist or is invalid
497: --
498: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
499: hr_utility.set_message_token('TABLE_NAME', 'ben_dpnt_eligy_crit_values_f');
500: hr_utility.raise_error;
501: End lck;
502: --
503: -- ----------------------------------------------------------------------------