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 266: from ben_pl_f

262: ,pl_yr_not_applcbl_flag
263: ,use_csd_rsd_prccng_cd
264: ,all_inelig
265: ,bnf_exl_participant_flag --Enh 16043887
266: from ben_pl_f
267: where pl_id = p_pl_id
268: and p_effective_date
269: between effective_start_date and effective_end_date;
270: --

Line 378: from ben_pl_f t

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

Line 415: p_base_table_name => 'ben_pl_f',

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

Line 455: p_base_table_name => 'ben_pl_f',

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

Line 548: p_base_table_name => 'ben_pl_f',

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

Line 582: (p_base_table_name => 'ben_pl_f',

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

Line 592: update ben_pl_f t

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

Line 832: from ben_pl_f

828: ,pl_yr_not_applcbl_flag
829: ,use_csd_rsd_prccng_cd
830: ,all_inelig
831: ,bnf_exl_participant_flag --Enh 16043887
832: from ben_pl_f
833: where pl_id = p_pl_id
834: and p_effective_date
835: between effective_start_date and effective_end_date ;
836: -- for update nowait;

Line 891: p_base_table_name => 'ben_pl_f',

887: --
888: dt_api.validate_dt_mode
889: (p_effective_date => p_effective_date,
890: p_datetrack_mode => p_datetrack_mode,
891: p_base_table_name => 'ben_pl_f',
892: p_base_key_column => 'pl_id',
893: p_base_key_value => p_pl_id,
894: p_parent_table_name1 => 'ff_formulas_f',
895: p_parent_key_column1 => 'formula_id',

Line 948: p_base_table_name => 'ben_pl_f',

944: --
945: dt_api.validate_dt_mode
946: (p_effective_date => p_effective_date,
947: p_datetrack_mode => p_datetrack_mode,
948: p_base_table_name => 'ben_pl_f',
949: p_base_key_column => 'pl_id',
950: p_base_key_value => p_pl_id,
951: p_parent_table_name1 => 'ff_formulas_f',
952: p_parent_key_column1 => 'formula_id',

Line 996: p_base_table_name => 'ben_pl_f',

992: --
993: dt_api.validate_dt_mode
994: (p_effective_date => p_effective_date,
995: p_datetrack_mode => p_datetrack_mode,
996: p_base_table_name => 'ben_pl_f',
997: p_base_key_column => 'pl_id',
998: p_base_key_value => p_pl_id,
999: -- p_child_table_name1 => 'ben_acty_base_rt_f',
1000: -- p_child_key_column1 => 'acty_base_rt_id',

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

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

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

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