APPS.BEN_LOP_SHD dependencies on BEN_LER_CHG_OIPL_ENRT_F

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

32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_LER_CHG_OIPL_ENRT_FK2') 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 117: from ben_ler_chg_oipl_enrt_f

113: lop_attribute28,
114: lop_attribute29,
115: lop_attribute30,
116: object_version_number
117: from ben_ler_chg_oipl_enrt_f
118: where ler_chg_oipl_enrt_id = p_ler_chg_oipl_enrt_id
119: and p_effective_date
120: between effective_start_date and effective_end_date;
121: --

Line 192: from ben_ler_chg_oipl_enrt_f t

188: --
189: Cursor C_Sel1 Is
190: select t.ler_id,
191: t.oipl_id
192: from ben_ler_chg_oipl_enrt_f t
193: where t.ler_chg_oipl_enrt_id = p_base_key_value
194: and p_effective_date
195: between t.effective_start_date and t.effective_end_date;
196: --

Line 215: p_base_table_name => 'ben_ler_chg_oipl_enrt_f',

211: -- Call the corresponding datetrack api
212: --
213: dt_api.find_dt_del_modes
214: (p_effective_date => p_effective_date,
215: p_base_table_name => 'ben_ler_chg_oipl_enrt_f',
216: p_base_key_column => 'ler_chg_oipl_enrt_id',
217: p_base_key_value => p_base_key_value,
218: p_parent_table_name1 => 'ben_ler_f',
219: p_parent_key_column1 => 'ler_id',

Line 252: p_base_table_name => 'ben_ler_chg_oipl_enrt_f',

248: -- Call the corresponding datetrack api
249: --
250: dt_api.find_dt_upd_modes
251: (p_effective_date => p_effective_date,
252: p_base_table_name => 'ben_ler_chg_oipl_enrt_f',
253: p_base_key_column => 'ler_chg_oipl_enrt_id',
254: p_base_key_value => p_base_key_value,
255: p_correction => p_correction,
256: p_update => p_update,

Line 285: (p_base_table_name => 'ben_ler_chg_oipl_enrt_f',

281: -- version number.
282: --
283: l_object_version_number :=
284: dt_api.get_object_version_number
285: (p_base_table_name => 'ben_ler_chg_oipl_enrt_f',
286: p_base_key_column => 'ler_chg_oipl_enrt_id',
287: p_base_key_value => p_base_key_value);
288: --
289: hr_utility.set_location(l_proc, 10);

Line 295: update ben_ler_chg_oipl_enrt_f t

291: --
292: -- Update the specified datetrack row setting the effective
293: -- end date to the specified new effective end date.
294: --
295: update ben_ler_chg_oipl_enrt_f t
296: set t.effective_end_date = p_new_effective_end_date,
297: t.object_version_number = l_object_version_number
298: where t.ler_chg_oipl_enrt_id = p_base_key_value
299: and p_effective_date

Line 381: from ben_ler_chg_oipl_enrt_f

377: lop_attribute28,
378: lop_attribute29,
379: lop_attribute30,
380: object_version_number
381: from ben_ler_chg_oipl_enrt_f
382: where ler_chg_oipl_enrt_id = p_ler_chg_oipl_enrt_id
383: and p_effective_date
384: between effective_start_date and effective_end_date
385: for update nowait;

Line 440: p_base_table_name => 'ben_ler_chg_oipl_enrt_f',

436: --
437: dt_api.validate_dt_mode
438: (p_effective_date => p_effective_date,
439: p_datetrack_mode => p_datetrack_mode,
440: p_base_table_name => 'ben_ler_chg_oipl_enrt_f',
441: p_base_key_column => 'ler_chg_oipl_enrt_id',
442: p_base_key_value => p_ler_chg_oipl_enrt_id,
443: p_parent_table_name1 => 'ben_ler_f',
444: p_parent_key_column1 => 'ler_id',

Line 482: fnd_message.set_token('TABLE_NAME', 'ben_ler_chg_oipl_enrt_f');

478: -- The object is locked therefore we need to supply a meaningful
479: -- error message.
480: --
481: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
482: fnd_message.set_token('TABLE_NAME', 'ben_ler_chg_oipl_enrt_f');
483: fnd_message.raise_error;
484: When l_object_invalid then
485: --
486: -- The object doesn't exist or is invalid

Line 489: fnd_message.set_token('TABLE_NAME', 'ben_ler_chg_oipl_enrt_f');

485: --
486: -- The object doesn't exist or is invalid
487: --
488: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
489: fnd_message.set_token('TABLE_NAME', 'ben_ler_chg_oipl_enrt_f');
490: fnd_message.raise_error;
491: End lck;
492: --
493: -- ----------------------------------------------------------------------------