APPS.BEN_EMP_SHD dependencies on BEN_ELIG_MRTL_STS_PRTE_F

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

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

107: emp_attribute30,
108: object_version_number ,
109: criteria_score,
110: criteria_weight
111: from ben_ELIG_MRTL_STS_PRTE_f
112: where ELIG_MRTL_STS_PRTE_id = p_ELIG_MRTL_STS_PRTE_id
113: and p_effective_date
114: between effective_start_date and effective_end_date;
115: --

Line 191: p_base_table_name => 'ben_ELIG_MRTL_STS_PRTE_f',

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

Line 222: p_base_table_name => 'ben_ELIG_MRTL_STS_PRTE_f',

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

Line 255: (p_base_table_name => 'ben_ELIG_MRTL_STS_PRTE_f',

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

Line 265: update ben_ELIG_MRTL_STS_PRTE_f t

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

Line 345: from ben_ELIG_MRTL_STS_PRTE_f

341: emp_attribute30,
342: object_version_number ,
343: criteria_score,
344: criteria_weight
345: from ben_ELIG_MRTL_STS_PRTE_f
346: where ELIG_MRTL_STS_PRTE_id = p_ELIG_MRTL_STS_PRTE_id
347: and p_effective_date
348: between effective_start_date and effective_end_date
349: for update nowait;

Line 404: p_base_table_name => 'ben_ELIG_MRTL_STS_PRTE_f',

400: --
401: dt_api.validate_dt_mode
402: (p_effective_date => p_effective_date,
403: p_datetrack_mode => p_datetrack_mode,
404: p_base_table_name => 'ben_ELIG_MRTL_STS_PRTE_f',
405: p_base_key_column => 'ELIG_MRTL_STS_PRTE_id',
406: p_base_key_value => p_ELIG_MRTL_STS_PRTE_id,
407:
408: p_enforce_foreign_locking => true,

Line 439: fnd_message.set_token('TABLE_NAME', 'ben_ELIG_MRTL_STS_PRTE_f');

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

Line 446: fnd_message.set_token('TABLE_NAME', 'ben_ELIG_MRTL_STS_PRTE_f');

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