APPS.BEN_CPP_SHD dependencies on BEN_PLIP_F

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

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

160: cpp_attribute28,
161: cpp_attribute29,
162: cpp_attribute30,
163: object_version_number
164: from ben_plip_f
165: where plip_id = p_plip_id
166: and p_effective_date
167: between effective_start_date and effective_end_date;
168: --

Line 243: from ben_plip_f t

239: select t.dflt_enrt_det_rl,
240: t.pl_id,
241: t.pgm_id,
242: t.cmbn_plip_id
243: from ben_plip_f t
244: where t.plip_id = p_base_key_value
245: and p_effective_date
246: between t.effective_start_date and t.effective_end_date;
247: --

Line 268: p_base_table_name => 'ben_plip_f',

264: -- Call the corresponding datetrack api
265: --
266: dt_api.find_dt_del_modes
267: (p_effective_date => p_effective_date,
268: p_base_table_name => 'ben_plip_f',
269: p_base_key_column => 'plip_id',
270: p_base_key_value => p_base_key_value,
271: p_parent_table_name1 => 'ff_formulas_f',
272: p_parent_key_column1 => 'formula_id',

Line 311: p_base_table_name => 'ben_plip_f',

307: -- Call the corresponding datetrack api
308: --
309: dt_api.find_dt_upd_modes
310: (p_effective_date => p_effective_date,
311: p_base_table_name => 'ben_plip_f',
312: p_base_key_column => 'plip_id',
313: p_base_key_value => p_base_key_value,
314: p_correction => p_correction,
315: p_update => p_update,

Line 344: (p_base_table_name => 'ben_plip_f',

340: -- version number.
341: --
342: l_object_version_number :=
343: dt_api.get_object_version_number
344: (p_base_table_name => 'ben_plip_f',
345: p_base_key_column => 'plip_id',
346: p_base_key_value => p_base_key_value);
347: --
348: hr_utility.set_location(l_proc, 10);

Line 354: update ben_plip_f t

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

Line 487: from ben_plip_f

483: cpp_attribute28,
484: cpp_attribute29,
485: cpp_attribute30,
486: object_version_number
487: from ben_plip_f
488: where plip_id = p_plip_id
489: and p_effective_date
490: between effective_start_date and effective_end_date
491: for update nowait;

Line 546: p_base_table_name => 'ben_plip_f',

542: --
543: dt_api.validate_dt_mode
544: (p_effective_date => p_effective_date,
545: p_datetrack_mode => p_datetrack_mode,
546: p_base_table_name => 'ben_plip_f',
547: p_base_key_column => 'plip_id',
548: p_base_key_value => p_plip_id,
549: p_parent_table_name1 => 'ff_formulas_f',
550: p_parent_key_column1 => 'formula_id',

Line 594: fnd_message.set_token('TABLE_NAME', 'ben_plip_f');

590: -- The object is locked therefore we need to supply a meaningful
591: -- error message.
592: --
593: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
594: fnd_message.set_token('TABLE_NAME', 'ben_plip_f');
595: fnd_message.raise_error;
596: When l_object_invalid then
597: --
598: -- The object doesn't exist or is invalid

Line 601: fnd_message.set_token('TABLE_NAME', 'ben_plip_f');

597: --
598: -- The object doesn't exist or is invalid
599: --
600: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
601: fnd_message.set_token('TABLE_NAME', 'ben_plip_f');
602: fnd_message.raise_error;
603: End lck;
604: --
605: -- ----------------------------------------------------------------------------