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_CQR_SHD dependencies on BEN_CBR_QUALD_BNF_RT_F

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

32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_CBR_QUALD_BNF_RT_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_CBR_QUALD_BNF_RT_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_CBR_QUALD_BNF_RT_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_CBR_QUALD_BNF_RT_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_CBR_QUALD_BNF_RT_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 116: from ben_cbr_quald_bnf_rt_f

112: cqr_attribute28,
113: cqr_attribute29,
114: cqr_attribute30,
115: object_version_number
116: from ben_cbr_quald_bnf_rt_f
117: where cbr_quald_bnf_rt_id = p_cbr_quald_bnf_rt_id
118: and p_effective_date
119: between effective_start_date and effective_end_date;
120: --

Line 193: from ben_cbr_quald_bnf_rt_f t

189: Cursor C_Sel1 Is
190: select t.vrbl_rt_prfl_id,
191: t.pgm_id,
192: t.ptip_id
193: from ben_cbr_quald_bnf_rt_f t
194: where t.cbr_quald_bnf_rt_id = p_base_key_value
195: and p_effective_date
196: between t.effective_start_date and t.effective_end_date;
197: --

Line 217: p_base_table_name => 'ben_cbr_quald_bnf_rt_f',

213: -- Call the corresponding datetrack api
214: --
215: dt_api.find_dt_del_modes
216: (p_effective_date => p_effective_date,
217: p_base_table_name => 'ben_cbr_quald_bnf_rt_f',
218: p_base_key_column => 'cbr_quald_bnf_rt_id',
219: p_base_key_value => p_base_key_value,
220: p_parent_table_name1 => 'BEN_VRBL_RT_PRFL_F',
221: p_parent_key_column1 => 'VRBL_RT_PRFL_ID',

Line 257: p_base_table_name => 'ben_cbr_quald_bnf_rt_f',

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

Line 290: (p_base_table_name => 'ben_cbr_quald_bnf_rt_f',

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

Line 300: update ben_cbr_quald_bnf_rt_f t

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

Line 380: from ben_cbr_quald_bnf_rt_f

376: cqr_attribute28,
377: cqr_attribute29,
378: cqr_attribute30,
379: object_version_number
380: from ben_cbr_quald_bnf_rt_f
381: where cbr_quald_bnf_rt_id = p_cbr_quald_bnf_rt_id
382: and p_effective_date
383: between effective_start_date and effective_end_date
384: for update nowait;

Line 439: p_base_table_name => 'ben_cbr_quald_bnf_rt_f',

435: --
436: dt_api.validate_dt_mode
437: (p_effective_date => p_effective_date,
438: p_datetrack_mode => p_datetrack_mode,
439: p_base_table_name => 'ben_cbr_quald_bnf_rt_f',
440: p_base_key_column => 'cbr_quald_bnf_rt_id',
441: p_base_key_value => p_cbr_quald_bnf_rt_id,
442: p_parent_table_name1 => 'ben_vrbl_rt_prfl_f',
443: p_parent_key_column1 => 'vrbl_rt_prfl_id',

Line 482: fnd_message.set_token('TABLE_NAME', 'ben_cbr_quald_bnf_rt_f');

478: -- The object is locked therefore we need to supply a meaningful
479: -- error message.
480: --
481: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
482: fnd_message.set_token('TABLE_NAME', 'ben_cbr_quald_bnf_rt_f');
483: fnd_message.raise_error;
484: When l_object_invalid then
485: --
486: -- The object doesn't exist or is invalid

Line 489: fnd_message.set_token('TABLE_NAME', 'BEN_CBR_QUALD_BNF_RT_F');

485: --
486: -- The object doesn't exist or is invalid
487: --
488: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
489: fnd_message.set_token('TABLE_NAME', 'BEN_CBR_QUALD_BNF_RT_F');
490: fnd_message.raise_error;
491: End lck;
492: --
493: -- ----------------------------------------------------------------------------