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 143: from ben_oipl_f

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

Line 228: from ben_oipl_f t

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

Line 256: p_base_table_name => 'ben_oipl_f',

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

Line 308: p_base_table_name => 'ben_oipl_f',

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

Line 341: (p_base_table_name => 'ben_oipl_f',

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

Line 351: update ben_oipl_f t

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

Line 463: from ben_oipl_f

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

Line 522: p_base_table_name => 'ben_oipl_f',

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

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

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

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

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