APPS.BEN_COP_SHD dependencies on BEN_OIPL_F

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

32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_OIPL_FK1') Then
37: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
38: hr_utility.set_message_token('PROCEDURE', l_proc);
39: hr_utility.set_message_token('STEP','5');
40: hr_utility.raise_error;

Line 144: from ben_oipl_f

140: cop_attribute29,
141: cop_attribute30,
142: all_inelig,
143: object_version_number
144: from ben_oipl_f
145: where oipl_id = p_oipl_id
146: and p_effective_date
147: between effective_start_date and effective_end_date;
148: --

Line 229: from ben_oipl_f t

225: t.vrfy_fmly_mmbr_rl,
226: t.actl_prem_id,
227: t.pl_id,
228: t.opt_id
229: from ben_oipl_f t
230: where t.oipl_id = p_base_key_value
231: and p_effective_date
232: between t.effective_start_date and t.effective_end_date;
233: --

Line 257: p_base_table_name => 'ben_oipl_f',

253: -- Call the corresponding datetrack api
254: --
255: dt_api.find_dt_del_modes
256: (p_effective_date => p_effective_date,
257: p_base_table_name => 'ben_oipl_f',
258: p_base_key_column => 'oipl_id',
259: p_base_key_value => p_base_key_value,
260: p_parent_table_name1 => 'ff_formulas_f',
261: p_parent_key_column1 => 'formula_id',

Line 309: p_base_table_name => 'ben_oipl_f',

305: -- Call the corresponding datetrack api
306: --
307: dt_api.find_dt_upd_modes
308: (p_effective_date => p_effective_date,
309: p_base_table_name => 'ben_oipl_f',
310: p_base_key_column => 'oipl_id',
311: p_base_key_value => p_base_key_value,
312: p_correction => p_correction,
313: p_update => p_update,

Line 342: (p_base_table_name => 'ben_oipl_f',

338: -- version number.
339: --
340: l_object_version_number :=
341: dt_api.get_object_version_number
342: (p_base_table_name => 'ben_oipl_f',
343: p_base_key_column => 'oipl_id',
344: p_base_key_value => p_base_key_value);
345: --
346: hr_utility.set_location(l_proc, 10);

Line 352: update ben_oipl_f t

348: --
349: -- Update the specified datetrack row setting the effective
350: -- end date to the specified new effective end date.
351: --
352: update ben_oipl_f t
353: set t.effective_end_date = p_new_effective_end_date,
354: t.object_version_number = l_object_version_number
355: where t.oipl_id = p_base_key_value
356: and p_effective_date

Line 465: from ben_oipl_f

461: cop_attribute29,
462: cop_attribute30,
463: all_inelig,
464: object_version_number
465: from ben_oipl_f
466: where oipl_id = p_oipl_id
467: and p_effective_date
468: between effective_start_date and effective_end_date
469: for update nowait;

Line 524: p_base_table_name => 'ben_oipl_f',

520: --
521: dt_api.validate_dt_mode
522: (p_effective_date => p_effective_date,
523: p_datetrack_mode => p_datetrack_mode,
524: p_base_table_name => 'ben_oipl_f',
525: p_base_key_column => 'oipl_id',
526: p_base_key_value => p_oipl_id,
527: p_parent_table_name1 => 'ff_formulas_f',
528: p_parent_key_column1 => 'formula_id',

Line 589: hr_utility.set_message_token('TABLE_NAME', 'ben_oipl_f');

585: -- The object is locked therefore we need to supply a meaningful
586: -- error message.
587: --
588: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
589: hr_utility.set_message_token('TABLE_NAME', 'ben_oipl_f');
590: hr_utility.raise_error;
591: When l_object_invalid then
592: --
593: -- The object doesn't exist or is invalid

Line 596: hr_utility.set_message_token('TABLE_NAME', 'ben_oipl_f');

592: --
593: -- The object doesn't exist or is invalid
594: --
595: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
596: hr_utility.set_message_token('TABLE_NAME', 'ben_oipl_f');
597: hr_utility.raise_error;
598: End lck;
599: --
600: -- ----------------------------------------------------------------------------