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_LRC_SHD dependencies on BEN_LER_RLTD_PER_CS_LER_F

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

32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_LER_RLTD_PER_CS_LER_FK3') Then
37: fnd_message.set_name('BEN', 'BEN_91000_INVALID_BUS_GROUP');
38: fnd_message.raise_error;
39: ElsIf (p_constraint_name = 'BEN_LER_RLTD_PER_CS_LER_F_FK2') Then
40: fnd_message.set_name('BEN', 'BEN_91015_INV_PERSON_CHANGE');

Line 39: ElsIf (p_constraint_name = 'BEN_LER_RLTD_PER_CS_LER_F_FK2') Then

35: --
36: If (p_constraint_name = 'BEN_LER_RLTD_PER_CS_LER_FK3') Then
37: fnd_message.set_name('BEN', 'BEN_91000_INVALID_BUS_GROUP');
38: fnd_message.raise_error;
39: ElsIf (p_constraint_name = 'BEN_LER_RLTD_PER_CS_LER_F_FK2') Then
40: fnd_message.set_name('BEN', 'BEN_91015_INV_PERSON_CHANGE');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'BEN_LER_RTLD_PER_CS_LER_F_PK') Then
43: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 111: from ben_ler_rltd_per_cs_ler_f

107: lrc_attribute29,
108: lrc_attribute30,
109: chg_mandatory_cd,
110: object_version_number
111: from ben_ler_rltd_per_cs_ler_f
112: where ler_rltd_per_cs_ler_id = p_ler_rltd_per_cs_ler_id
113: and p_effective_date
114: between effective_start_date and effective_end_date;
115: --

Line 184: from ben_ler_rltd_per_cs_ler_f t

180: l_parent_key_value1 number;
181: --
182: Cursor C_Sel1 Is
183: select t.ler_rltd_per_cs_chg_rl
184: from ben_ler_rltd_per_cs_ler_f t
185: where t.ler_rltd_per_cs_ler_id = p_base_key_value
186: and p_effective_date
187: between t.effective_start_date and t.effective_end_date;
188: --

Line 206: p_base_table_name => 'ben_ler_rltd_per_cs_ler_f',

202: -- Call the corresponding datetrack api
203: --
204: dt_api.find_dt_del_modes
205: (p_effective_date => p_effective_date,
206: p_base_table_name => 'ben_ler_rltd_per_cs_ler_f',
207: p_base_key_column => 'ler_rltd_per_cs_ler_id',
208: p_base_key_value => p_base_key_value,
209: p_parent_table_name1 => 'ff_formulas_f',
210: p_parent_key_column1 => 'formula_id',

Line 240: p_base_table_name => 'ben_ler_rltd_per_cs_ler_f',

236: -- Call the corresponding datetrack api
237: --
238: dt_api.find_dt_upd_modes
239: (p_effective_date => p_effective_date,
240: p_base_table_name => 'ben_ler_rltd_per_cs_ler_f',
241: p_base_key_column => 'ler_rltd_per_cs_ler_id',
242: p_base_key_value => p_base_key_value,
243: p_correction => p_correction,
244: p_update => p_update,

Line 273: (p_base_table_name => 'ben_ler_rltd_per_cs_ler_f',

269: -- version number.
270: --
271: l_object_version_number :=
272: dt_api.get_object_version_number
273: (p_base_table_name => 'ben_ler_rltd_per_cs_ler_f',
274: p_base_key_column => 'ler_rltd_per_cs_ler_id',
275: p_base_key_value => p_base_key_value);
276: --
277: hr_utility.set_location(l_proc, 10);

Line 283: update ben_ler_rltd_per_cs_ler_f t

279: --
280: -- Update the specified datetrack row setting the effective
281: -- end date to the specified new effective end date.
282: --
283: update ben_ler_rltd_per_cs_ler_f t
284: set t.effective_end_date = p_new_effective_end_date,
285: t.object_version_number = l_object_version_number
286: where t.ler_rltd_per_cs_ler_id = p_base_key_value
287: and p_effective_date

Line 362: from ben_ler_rltd_per_cs_ler_f

358: lrc_attribute29,
359: lrc_attribute30,
360: chg_mandatory_cd,
361: object_version_number
362: from ben_ler_rltd_per_cs_ler_f
363: where ler_rltd_per_cs_ler_id = p_ler_rltd_per_cs_ler_id
364: and p_effective_date
365: between effective_start_date and effective_end_date
366: for update nowait;

Line 421: p_base_table_name => 'ben_ler_rltd_per_cs_ler_f',

417: --
418: dt_api.validate_dt_mode
419: (p_effective_date => p_effective_date,
420: p_datetrack_mode => p_datetrack_mode,
421: p_base_table_name => 'ben_ler_rltd_per_cs_ler_f',
422: p_base_key_column => 'ler_rltd_per_cs_ler_id',
423: p_base_key_value => p_ler_rltd_per_cs_ler_id,
424: p_parent_table_name1 => 'ff_formulas_f',
425: p_parent_key_column1 => 'formula_id',

Line 458: fnd_message.set_token('TABLE_NAME', 'ben_ler_rltd_per_cs_ler_f');

454: -- The object is locked therefore we need to supply a meaningful
455: -- error message.
456: --
457: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
458: fnd_message.set_token('TABLE_NAME', 'ben_ler_rltd_per_cs_ler_f');
459: fnd_message.raise_error;
460: When l_object_invalid then
461: --
462: -- The object doesn't exist or is invalid

Line 465: fnd_message.set_token('TABLE_NAME', 'ben_ler_rltd_per_cs_ler_f');

461: --
462: -- The object doesn't exist or is invalid
463: --
464: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
465: fnd_message.set_token('TABLE_NAME', 'ben_ler_rltd_per_cs_ler_f');
466: fnd_message.raise_error;
467: End lck;
468: --
469: -- ----------------------------------------------------------------------------