APPS.BEN_EPS_SHD dependencies on BEN_ELIG_PSTN_PRTE_F

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

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

108: eps_attribute30,
109: object_version_number ,
110: criteria_score,
111: criteria_weight
112: from ben_elig_pstn_prte_f
113: where elig_pstn_prte_id = p_elig_pstn_prte_id
114: and p_effective_date
115: between effective_start_date and effective_end_date;
116: --

Line 192: p_base_table_name => 'ben_elig_pstn_prte_f',

188: -- Call the corresponding datetrack api
189: --
190: dt_api.find_dt_del_modes
191: (p_effective_date => p_effective_date,
192: p_base_table_name => 'ben_elig_pstn_prte_f',
193: p_base_key_column => 'elig_pstn_prte_id',
194: p_base_key_value => p_base_key_value,
195: p_zap => p_zap,
196: p_delete => p_delete,

Line 223: p_base_table_name => 'ben_elig_pstn_prte_f',

219: -- Call the corresponding datetrack api
220: --
221: dt_api.find_dt_upd_modes
222: (p_effective_date => p_effective_date,
223: p_base_table_name => 'ben_elig_pstn_prte_f',
224: p_base_key_column => 'elig_pstn_prte_id',
225: p_base_key_value => p_base_key_value,
226: p_correction => p_correction,
227: p_update => p_update,

Line 256: (p_base_table_name => 'ben_elig_pstn_prte_f',

252: -- version number.
253: --
254: l_object_version_number :=
255: dt_api.get_object_version_number
256: (p_base_table_name => 'ben_elig_pstn_prte_f',
257: p_base_key_column => 'elig_pstn_prte_id',
258: p_base_key_value => p_base_key_value);
259: --
260: hr_utility.set_location(l_proc, 10);

Line 266: update ben_elig_pstn_prte_f t

262: --
263: -- Update the specified datetrack row setting the effective
264: -- end date to the specified new effective end date.
265: --
266: update ben_elig_pstn_prte_f t
267: set t.effective_end_date = p_new_effective_end_date,
268: t.object_version_number = l_object_version_number
269: where t.elig_pstn_prte_id = p_base_key_value
270: and p_effective_date

Line 347: from ben_elig_pstn_prte_f

343: eps_attribute30,
344: object_version_number,
345: criteria_score,
346: criteria_weight
347: from ben_elig_pstn_prte_f
348: where elig_pstn_prte_id = p_elig_pstn_prte_id
349: and p_effective_date
350: between effective_start_date and effective_end_date
351: for update nowait;

Line 406: p_base_table_name => 'ben_elig_pstn_prte_f',

402: --
403: dt_api.validate_dt_mode
404: (p_effective_date => p_effective_date,
405: p_datetrack_mode => p_datetrack_mode,
406: p_base_table_name => 'ben_elig_pstn_prte_f',
407: p_base_key_column => 'elig_pstn_prte_id',
408: p_base_key_value => p_elig_pstn_prte_id,
409:
410: p_enforce_foreign_locking => true,

Line 441: fnd_message.set_token('TABLE_NAME', 'ben_elig_pstn_prte_f');

437: -- The object is locked therefore we need to supply a meaningful
438: -- error message.
439: --
440: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
441: fnd_message.set_token('TABLE_NAME', 'ben_elig_pstn_prte_f');
442: fnd_message.raise_error;
443: When l_object_invalid then
444: --
445: -- The object doesn't exist or is invalid

Line 448: fnd_message.set_token('TABLE_NAME', 'ben_elig_pstn_prte_f');

444: --
445: -- The object doesn't exist or is invalid
446: --
447: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
448: fnd_message.set_token('TABLE_NAME', 'ben_elig_pstn_prte_f');
449: fnd_message.raise_error;
450: End lck;
451: --
452: -- ----------------------------------------------------------------------------