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_PBN_SHD dependencies on BEN_PL_BNF_F

Line 41: elsif (p_constraint_name = 'BEN_PL_BNF_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;
41: elsif (p_constraint_name = 'BEN_PL_BNF_FK1') 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_PL_BNF_FK2') 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_PL_BNF_FK2') 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 51: elsif (p_constraint_name = 'BEN_PL_BNF_FK3') 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;
51: elsif (p_constraint_name = 'BEN_PL_BNF_FK3') Then
52: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
53: fnd_message.set_token('PROCEDURE', l_proc);
54: fnd_message.set_token('STEP','20');
55: fnd_message.raise_error;

Line 132: from ben_pl_bnf_f

128: program_id,
129: program_update_date,
130: object_version_number,
131: per_in_ler_id
132: from ben_pl_bnf_f
133: where pl_bnf_id = p_pl_bnf_id
134: and p_effective_date
135: between effective_start_date and effective_end_date;
136: --

Line 207: from ben_pl_bnf_f t

203: --
204: Cursor C_Sel1 Is
205: select t.per_in_ler_id,
206: t.prtt_enrt_rslt_id
207: from ben_pl_bnf_f t
208: where t.pl_bnf_id = p_base_key_value
209: and p_effective_date
210: between t.effective_start_date and t.effective_end_date;
211: --

Line 220: -- p_base_table_name => 'ben_pl_bnf_f',

216: -- Call the corresponding datetrack api
217: --
218: -- dt_api.find_dt_del_modes
219: -- (p_effective_date => p_effective_date,
220: -- p_base_table_name => 'ben_pl_bnf_f',
221: -- p_base_key_column => 'pl_bnf_id',
222: -- p_base_key_value => p_base_key_value,
223: -- p_zap => p_zap,
224: -- p_delete => p_delete,

Line 243: p_base_table_name => 'ben_pl_bnf_f',

239: -- Call the corresponding datetrack api
240: --
241: dt_api.find_dt_del_modes
242: (p_effective_date => p_effective_date,
243: p_base_table_name => 'ben_pl_bnf_f',
244: p_base_key_column => 'pl_bnf_id',
245: p_base_key_value => p_base_key_value,
246: p_parent_table_name1 => 'ben_prtt_enrt_rslt_f',
247: p_parent_key_column1 => 'prtt_enrt_rslt_id',

Line 278: p_base_table_name => 'ben_pl_bnf_f',

274: -- Call the corresponding datetrack api
275: --
276: dt_api.find_dt_upd_modes
277: (p_effective_date => p_effective_date,
278: p_base_table_name => 'ben_pl_bnf_f',
279: p_base_key_column => 'pl_bnf_id',
280: p_base_key_value => p_base_key_value,
281: p_correction => p_correction,
282: p_update => p_update,

Line 311: (p_base_table_name => 'ben_pl_bnf_f',

307: -- version number.
308: --
309: l_object_version_number :=
310: dt_api.get_object_version_number
311: (p_base_table_name => 'ben_pl_bnf_f',
312: p_base_key_column => 'pl_bnf_id',
313: p_base_key_value => p_base_key_value);
314: --
315: hr_utility.set_location(l_proc, 10);

Line 321: update ben_pl_bnf_f t

317: --
318: -- Update the specified datetrack row setting the effective
319: -- end date to the specified new effective end date.
320: --
321: update ben_pl_bnf_f t
322: set t.effective_end_date = p_new_effective_end_date,
323: t.object_version_number = l_object_version_number
324: where t.pl_bnf_id = p_base_key_value
325: and p_effective_date

Line 412: from ben_pl_bnf_f

408: program_id,
409: program_update_date,
410: object_version_number,
411: per_in_ler_id
412: from ben_pl_bnf_f
413: where pl_bnf_id = p_pl_bnf_id
414: and p_effective_date
415: between effective_start_date and effective_end_date
416: for update nowait;

Line 471: -- p_base_table_name => 'ben_pl_bnf_f',

467: --
468: -- dt_api.validate_dt_mode
469: -- (p_effective_date => p_effective_date,
470: -- p_datetrack_mode => p_datetrack_mode,
471: -- p_base_table_name => 'ben_pl_bnf_f',
472: -- p_base_key_column => 'pl_bnf_id',
473: -- p_base_key_value => p_pl_bnf_id,
474: -- p_child_table_name1 => 'ben_pl_bnf_ctfn_prvdd_f',
475: -- p_child_key_column1 => 'pl_bnf_ctfn_prvdd_id',

Line 485: p_base_table_name => 'ben_pl_bnf_f',

481: --
482: dt_api.validate_dt_mode
483: (p_effective_date => p_effective_date,
484: p_datetrack_mode => p_datetrack_mode,
485: p_base_table_name => 'ben_pl_bnf_f',
486: p_base_key_column => 'pl_bnf_id',
487: p_base_key_value => p_pl_bnf_id,
488: p_parent_table_name1 => 'ben_prtt_enrt_rslt_f',
489: p_parent_key_column1 => 'prtt_enrt_rslt_id',

Line 527: fnd_message.set_token('TABLE_NAME', 'ben_pl_bnf_f');

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

Line 534: fnd_message.set_token('TABLE_NAME', 'ben_pl_bnf_f');

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