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_ECQ_SHD dependencies on BEN_ELIG_CBR_QUALD_BNF_F

Line 36: If (p_constraint_name = 'BEN_ELIG_CBR_QUALD_BNF_F_PK') Then

32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_ELIG_CBR_QUALD_BNF_F_PK') Then
37: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;

Line 41: ElsIf (p_constraint_name = 'BEN_ELIG_CBR_QUALD_BNF_F_DT2') Then

37: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'BEN_ELIG_CBR_QUALD_BNF_F_DT2') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','10');
45: fnd_message.raise_error;

Line 46: ElsIf (p_constraint_name = 'BEN_ELIG_CBR_QUALD_BNF_F_DT3') Then

42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','10');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'BEN_ELIG_CBR_QUALD_BNF_F_DT3') Then
47: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('STEP','15');
50: fnd_message.raise_error;

Line 118: from ben_elig_cbr_quald_bnf_f

114: ecq_attribute30,
115: object_version_number,
116: criteria_score,
117: criteria_weight
118: from ben_elig_cbr_quald_bnf_f
119: where elig_cbr_quald_bnf_id = p_elig_cbr_quald_bnf_id
120: and p_effective_date
121: between effective_start_date and effective_end_date;
122: --

Line 195: from ben_elig_cbr_quald_bnf_f t

191: Cursor C_Sel1 Is
192: select t.eligy_prfl_id,
193: t.pgm_id,
194: t.ptip_id
195: from ben_elig_cbr_quald_bnf_f t
196: where t.elig_cbr_quald_bnf_id = p_base_key_value
197: and p_effective_date
198: between t.effective_start_date and t.effective_end_date;
199: --

Line 219: p_base_table_name => 'ben_elig_cbr_quald_bnf_f',

215: -- Call the corresponding datetrack api
216: --
217: dt_api.find_dt_del_modes
218: (p_effective_date => p_effective_date,
219: p_base_table_name => 'ben_elig_cbr_quald_bnf_f',
220: p_base_key_column => 'elig_cbr_quald_bnf_id',
221: p_base_key_value => p_base_key_value,
222: p_parent_table_name1 => 'ben_eligy_prfl_f',
223: p_parent_key_column1 => 'eligy_prfl_id',

Line 259: p_base_table_name => 'ben_elig_cbr_quald_bnf_f',

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

Line 292: (p_base_table_name => 'ben_elig_cbr_quald_bnf_f',

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

Line 302: update ben_elig_cbr_quald_bnf_f t

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

Line 385: from ben_elig_cbr_quald_bnf_f

381: object_version_number,
382: criteria_score,
383: criteria_weight
384:
385: from ben_elig_cbr_quald_bnf_f
386: where elig_cbr_quald_bnf_id = p_elig_cbr_quald_bnf_id
387: and p_effective_date
388: between effective_start_date and effective_end_date
389: for update nowait;

Line 444: p_base_table_name => 'ben_elig_cbr_quald_bnf_f',

440: --
441: dt_api.validate_dt_mode
442: (p_effective_date => p_effective_date,
443: p_datetrack_mode => p_datetrack_mode,
444: p_base_table_name => 'ben_elig_cbr_quald_bnf_f',
445: p_base_key_column => 'elig_cbr_quald_bnf_id',
446: p_base_key_value => p_elig_cbr_quald_bnf_id,
447: p_parent_table_name1 => 'ben_eligy_prfl_f',
448: p_parent_key_column1 => 'eligy_prfl_id',

Line 487: fnd_message.set_token('TABLE_NAME', 'ben_elig_cbr_quald_bnf_f');

483: -- The object is locked therefore we need to supply a meaningful
484: -- error message.
485: --
486: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
487: fnd_message.set_token('TABLE_NAME', 'ben_elig_cbr_quald_bnf_f');
488: fnd_message.raise_error;
489: When l_object_invalid then
490: --
491: -- The object doesn't exist or is invalid

Line 494: fnd_message.set_token('TABLE_NAME', 'ben_elig_cbr_quald_bnf_f');

490: --
491: -- The object doesn't exist or is invalid
492: --
493: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
494: fnd_message.set_token('TABLE_NAME', 'ben_elig_cbr_quald_bnf_f');
495: fnd_message.raise_error;
496: End lck;
497: --
498: -- ----------------------------------------------------------------------------