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_APR_SHD dependencies on BEN_ACTL_PREM_F

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

32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_ACTL_PREM_FK1') 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_ACTL_PREM_FK3') 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_ACTL_PREM_FK3') 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_ACTL_PREM_F_PK') 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_ACTL_PREM_F_PK') 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 143: from ben_actl_prem_f

139: apr_attribute28,
140: apr_attribute29,
141: apr_attribute30,
142: object_version_number
143: from ben_actl_prem_f
144: where actl_prem_id = p_actl_prem_id
145: and p_effective_date
146: between effective_start_date and effective_end_date;
147: --

Line 216: from ben_actl_prem_f t

212: l_parent_key_value1 number;
213: --
214: Cursor C_Sel1 Is
215: select t.comp_lvl_fctr_id
216: from ben_actl_prem_f t
217: where t.actl_prem_id = p_base_key_value
218: and p_effective_date
219: between t.effective_start_date and t.effective_end_date;
220: --

Line 238: p_base_table_name => 'ben_actl_prem_f',

234: -- Call the corresponding datetrack api
235: --
236: dt_api.find_dt_del_modes
237: (p_effective_date => p_effective_date,
238: p_base_table_name => 'ben_actl_prem_f',
239: p_base_key_column => 'actl_prem_id',
240: p_base_key_value => p_base_key_value,
241: -- p_parent_table_name1 => 'ben_comp_lvl_fctr',
242: -- p_parent_key_column1 => 'comp_lvl_fctr_id',

Line 272: p_base_table_name => 'ben_actl_prem_f',

268: -- Call the corresponding datetrack api
269: --
270: dt_api.find_dt_upd_modes
271: (p_effective_date => p_effective_date,
272: p_base_table_name => 'ben_actl_prem_f',
273: p_base_key_column => 'actl_prem_id',
274: p_base_key_value => p_base_key_value,
275: p_correction => p_correction,
276: p_update => p_update,

Line 305: (p_base_table_name => 'ben_actl_prem_f',

301: -- version number.
302: --
303: l_object_version_number :=
304: dt_api.get_object_version_number
305: (p_base_table_name => 'ben_actl_prem_f',
306: p_base_key_column => 'actl_prem_id',
307: p_base_key_value => p_base_key_value);
308: --
309: hr_utility.set_location(l_proc, 10);

Line 315: update ben_actl_prem_f t

311: --
312: -- Update the specified datetrack row setting the effective
313: -- end date to the specified new effective end date.
314: --
315: update ben_actl_prem_f t
316: set t.effective_end_date = p_new_effective_end_date,
317: t.object_version_number = l_object_version_number
318: where t.actl_prem_id = p_base_key_value
319: and p_effective_date

Line 422: from ben_actl_prem_f

418: apr_attribute28,
419: apr_attribute29,
420: apr_attribute30,
421: object_version_number
422: from ben_actl_prem_f
423: where actl_prem_id = p_actl_prem_id
424: and p_effective_date
425: between effective_start_date and effective_end_date
426: for update nowait;

Line 481: p_base_table_name => 'ben_actl_prem_f',

477: --
478: dt_api.validate_dt_mode
479: (p_effective_date => p_effective_date,
480: p_datetrack_mode => p_datetrack_mode,
481: p_base_table_name => 'ben_actl_prem_f',
482: p_base_key_column => 'actl_prem_id',
483: p_base_key_value => p_actl_prem_id,
484: -- p_parent_table_name1 => 'ben_comp_lvl_fctr',
485: -- p_parent_key_column1 => 'comp_lvl_fctr_id',

Line 526: fnd_message.set_token('TABLE_NAME', 'ben_actl_prem_f');

522: -- The object is locked therefore we need to supply a meaningful
523: -- error message.
524: --
525: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
526: fnd_message.set_token('TABLE_NAME', 'ben_actl_prem_f');
527: fnd_message.raise_error;
528: When l_object_invalid then
529: --
530: -- The object doesn't exist or is invalid

Line 533: fnd_message.set_token('TABLE_NAME', 'ben_actl_prem_f');

529: --
530: -- The object doesn't exist or is invalid
531: --
532: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
533: fnd_message.set_token('TABLE_NAME', 'ben_actl_prem_f');
534: fnd_message.raise_error;
535: End lck;
536: --
537: -- ----------------------------------------------------------------------------