APPS.BEN_PST_SHD dependencies on BEN_PSTN_RT_F

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

32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_PSTN_RT_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 41: ElsIf (p_constraint_name = 'BEN_PSTN_RT_F_PK') 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;
41: ElsIf (p_constraint_name = 'BEN_PSTN_RT_F_PK') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','10');
45: fnd_message.raise_error;

Line 110: from ben_pstn_rt_f

106: pst_attribute28,
107: pst_attribute29,
108: pst_attribute30,
109: object_version_number
110: from ben_pstn_rt_f
111: where pstn_rt_id = p_pstn_rt_id
112: and p_effective_date
113: between effective_start_date and effective_end_date;
114: --

Line 190: p_base_table_name => 'ben_pstn_rt_f',

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

Line 221: p_base_table_name => 'ben_pstn_rt_f',

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

Line 254: (p_base_table_name => 'ben_pstn_rt_f',

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

Line 264: update ben_pstn_rt_f t

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

Line 343: from ben_pstn_rt_f

339: pst_attribute28,
340: pst_attribute29,
341: pst_attribute30,
342: object_version_number
343: from ben_pstn_rt_f
344: where pstn_rt_id = p_pstn_rt_id
345: and p_effective_date
346: between effective_start_date and effective_end_date
347: for update nowait;

Line 402: p_base_table_name => 'ben_pstn_rt_f',

398: --
399: dt_api.validate_dt_mode
400: (p_effective_date => p_effective_date,
401: p_datetrack_mode => p_datetrack_mode,
402: p_base_table_name => 'ben_pstn_rt_f',
403: p_base_key_column => 'pstn_rt_id',
404: p_base_key_value => p_pstn_rt_id,
405:
406: p_enforce_foreign_locking => false, --true,

Line 437: fnd_message.set_token('TABLE_NAME', 'ben_pstn_rt_f');

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

Line 444: fnd_message.set_token('TABLE_NAME', 'ben_pstn_rt_f');

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