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_PLN_SHD dependencies on BEN_PL_F

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

32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_PL_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_PL_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;
41: ElsIf (p_constraint_name = 'BEN_PL_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;

Line 264: from ben_pl_f

260: ,mapping_table_pk_id
261: ,function_code
262: ,pl_yr_not_applcbl_flag
263: ,use_csd_rsd_prccng_cd
264: from ben_pl_f
265: where pl_id = p_pl_id
266: and p_effective_date
267: between effective_start_date and effective_end_date;
268: --

Line 376: from ben_pl_f t

372: t.rt_end_dt_rl,
373: t.rt_strt_dt_rl,
374: t.pl_typ_id,
375: t.actl_prem_id
376: from ben_pl_f t
377: where t.pl_id = p_base_key_value
378: and p_effective_date
379: between t.effective_start_date and t.effective_end_date;
380: --

Line 413: p_base_table_name => 'ben_pl_f',

409: -- Call the corresponding datetrack api
410: --
411: dt_api.find_dt_del_modes
412: (p_effective_date => p_effective_date,
413: p_base_table_name => 'ben_pl_f',
414: p_base_key_column => 'pl_id',
415: p_base_key_value => p_base_key_value,
416: p_parent_table_name1 => 'ff_formulas_f',
417: p_parent_key_column1 => 'formula_id',

Line 453: p_base_table_name => 'ben_pl_f',

449: p_delete_next_change => l_delete_next_change);
450: --
451: dt_api.find_dt_del_modes
452: (p_effective_date => p_effective_date,
453: p_base_table_name => 'ben_pl_f',
454: p_base_key_column => 'pl_id',
455: p_base_key_value => p_base_key_value,
456: p_parent_table_name1 => 'ff_formulas_f',
457: p_parent_key_column1 => 'formula_id',

Line 546: p_base_table_name => 'ben_pl_f',

542: -- Call the corresponding datetrack api
543: --
544: dt_api.find_dt_upd_modes
545: (p_effective_date => p_effective_date,
546: p_base_table_name => 'ben_pl_f',
547: p_base_key_column => 'pl_id',
548: p_base_key_value => p_base_key_value,
549: p_correction => p_correction,
550: p_update => p_update,

Line 580: (p_base_table_name => 'ben_pl_f',

576: -- version number.
577: --
578: l_object_version_number :=
579: dt_api.get_object_version_number
580: (p_base_table_name => 'ben_pl_f',
581: p_base_key_column => 'pl_id',
582: p_base_key_value => p_base_key_value);
583: --
584: hr_utility.set_location(l_proc, 10);

Line 590: update ben_pl_f t

586: --
587: -- Update the specified datetrack row setting the effective
588: -- end date to the specified new effective end date.
589: --
590: update ben_pl_f t
591: set t.effective_end_date = p_new_effective_end_date,
592: t.object_version_number = l_object_version_number
593: where t.pl_id = p_base_key_value
594: and p_effective_date

Line 828: from ben_pl_f

824: ,mapping_table_pk_id
825: ,function_code
826: ,pl_yr_not_applcbl_flag
827: ,use_csd_rsd_prccng_cd
828: from ben_pl_f
829: where pl_id = p_pl_id
830: and p_effective_date
831: between effective_start_date and effective_end_date ;
832: -- for update nowait;

Line 887: p_base_table_name => 'ben_pl_f',

883: --
884: dt_api.validate_dt_mode
885: (p_effective_date => p_effective_date,
886: p_datetrack_mode => p_datetrack_mode,
887: p_base_table_name => 'ben_pl_f',
888: p_base_key_column => 'pl_id',
889: p_base_key_value => p_pl_id,
890: p_parent_table_name1 => 'ff_formulas_f',
891: p_parent_key_column1 => 'formula_id',

Line 944: p_base_table_name => 'ben_pl_f',

940: --
941: dt_api.validate_dt_mode
942: (p_effective_date => p_effective_date,
943: p_datetrack_mode => p_datetrack_mode,
944: p_base_table_name => 'ben_pl_f',
945: p_base_key_column => 'pl_id',
946: p_base_key_value => p_pl_id,
947: p_parent_table_name1 => 'ff_formulas_f',
948: p_parent_key_column1 => 'formula_id',

Line 992: p_base_table_name => 'ben_pl_f',

988: --
989: dt_api.validate_dt_mode
990: (p_effective_date => p_effective_date,
991: p_datetrack_mode => p_datetrack_mode,
992: p_base_table_name => 'ben_pl_f',
993: p_base_key_column => 'pl_id',
994: p_base_key_value => p_pl_id,
995: -- p_child_table_name1 => 'ben_acty_base_rt_f',
996: -- p_child_key_column1 => 'acty_base_rt_id',

Line 1094: fnd_message.set_token('TABLE_NAME', 'ben_pl_f');

1090: -- The object is locked therefore we need to supply a meaningful
1091: -- error message.
1092: --
1093: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
1094: fnd_message.set_token('TABLE_NAME', 'ben_pl_f');
1095: fnd_message.raise_error;
1096: When l_object_invalid then
1097: --
1098: -- The object doesn't exist or is invalid

Line 1101: fnd_message.set_token('TABLE_NAME', 'ben_pl_f');

1097: --
1098: -- The object doesn't exist or is invalid
1099: --
1100: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
1101: fnd_message.set_token('TABLE_NAME', 'ben_pl_f');
1102: fnd_message.raise_error;
1103: End lck;
1104: -- ----------------------------------------------------------------------------
1105: -- |-----------------------------< convert_args >-----------------------------|