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 165: from ben_plip_f

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

Line 244: from ben_plip_f t

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

Line 269: p_base_table_name => 'ben_plip_f',

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

Line 312: p_base_table_name => 'ben_plip_f',

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

Line 345: (p_base_table_name => 'ben_plip_f',

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

Line 355: update ben_plip_f t

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

Line 489: from ben_plip_f

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

Line 548: p_base_table_name => 'ben_plip_f',

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

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

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

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

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