APPS.BEN_EGN_SHD dependencies on BEN_ELIG_GNDR_PRTE_F

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

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

108: ordr_num,
109: object_version_number,
110: criteria_score,
111: criteria_weight
112: from ben_elig_gndr_prte_f
113: where elig_gndr_prte_id = p_elig_gndr_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_GNDR_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_GNDR_PRTE_f',
193: p_base_key_column => 'ELIG_GNDR_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_GNDR_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_GNDR_PRTE_f',
224: p_base_key_column => 'ELIG_GNDR_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_GNDR_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_GNDR_PRTE_f',
257: p_base_key_column => 'ELIG_GNDR_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_GNDR_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_GNDR_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_GNDR_PRTE_id = p_base_key_value
270: and p_effective_date

Line 348: from ben_ELIG_GNDR_PRTE_f

344: object_version_number,
345: criteria_score,
346: criteria_weight
347:
348: from ben_ELIG_GNDR_PRTE_f
349: where ELIG_GNDR_PRTE_id = p_ELIG_GNDR_PRTE_id
350: and p_effective_date
351: between effective_start_date and effective_end_date
352: for update nowait;

Line 407: p_base_table_name => 'ben_ELIG_GNDR_PRTE_f',

403: --
404: dt_api.validate_dt_mode
405: (p_effective_date => p_effective_date,
406: p_datetrack_mode => p_datetrack_mode,
407: p_base_table_name => 'ben_ELIG_GNDR_PRTE_f',
408: p_base_key_column => 'ELIG_GNDR_PRTE_id',
409: p_base_key_value => p_ELIG_GNDR_PRTE_id,
410:
411: p_enforce_foreign_locking => true,

Line 442: fnd_message.set_token('TABLE_NAME', 'ben_ELIG_GNDR_PRTE_f');

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

Line 449: fnd_message.set_token('TABLE_NAME', 'ben_ELIG_GNDR_PRTE_f');

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