APPS.BEN_DEC_SHD dependencies on BEN_DSGNTR_ENRLD_CVG_F

Line 103: from ben_dsgntr_enrld_cvg_f

99: dec_attribute28,
100: dec_attribute29,
101: dec_attribute30,
102: object_version_number
103: from ben_dsgntr_enrld_cvg_f
104: where dsgntr_enrld_cvg_id = p_dsgntr_enrld_cvg_id
105: and p_effective_date
106: between effective_start_date and effective_end_date;
107: --

Line 183: p_base_table_name => 'ben_dsgntr_enrld_cvg_f',

179: -- Call the corresponding datetrack api
180: --
181: dt_api.find_dt_del_modes
182: (p_effective_date => p_effective_date,
183: p_base_table_name => 'ben_dsgntr_enrld_cvg_f',
184: p_base_key_column => 'dsgntr_enrld_cvg_id',
185: p_base_key_value => p_base_key_value,
186: p_zap => p_zap,
187: p_delete => p_delete,

Line 214: p_base_table_name => 'ben_dsgntr_enrld_cvg_f',

210: -- Call the corresponding datetrack api
211: --
212: dt_api.find_dt_upd_modes
213: (p_effective_date => p_effective_date,
214: p_base_table_name => 'ben_dsgntr_enrld_cvg_f',
215: p_base_key_column => 'dsgntr_enrld_cvg_id',
216: p_base_key_value => p_base_key_value,
217: p_correction => p_correction,
218: p_update => p_update,

Line 247: (p_base_table_name => 'ben_dsgntr_enrld_cvg_f',

243: -- version number.
244: --
245: l_object_version_number :=
246: dt_api.get_object_version_number
247: (p_base_table_name => 'ben_dsgntr_enrld_cvg_f',
248: p_base_key_column => 'dsgntr_enrld_cvg_id',
249: p_base_key_value => p_base_key_value);
250: --
251: hr_utility.set_location(l_proc, 10);

Line 257: update ben_dsgntr_enrld_cvg_f t

253: --
254: -- Update the specified datetrack row setting the effective
255: -- end date to the specified new effective end date.
256: --
257: update ben_dsgntr_enrld_cvg_f t
258: set t.effective_end_date = p_new_effective_end_date,
259: t.object_version_number = l_object_version_number
260: where t.dsgntr_enrld_cvg_id = p_base_key_value
261: and p_effective_date

Line 334: from ben_dsgntr_enrld_cvg_f

330: dec_attribute28,
331: dec_attribute29,
332: dec_attribute30,
333: object_version_number
334: from ben_dsgntr_enrld_cvg_f
335: where dsgntr_enrld_cvg_id = p_dsgntr_enrld_cvg_id
336: and p_effective_date
337: between effective_start_date and effective_end_date
338: for update nowait;

Line 393: p_base_table_name => 'ben_dsgntr_enrld_cvg_f',

389: --
390: dt_api.validate_dt_mode
391: (p_effective_date => p_effective_date,
392: p_datetrack_mode => p_datetrack_mode,
393: p_base_table_name => 'ben_dsgntr_enrld_cvg_f',
394: p_base_key_column => 'dsgntr_enrld_cvg_id',
395: p_base_key_value => p_dsgntr_enrld_cvg_id,
396:
397: p_enforce_foreign_locking => true,

Line 428: fnd_message.set_token('TABLE_NAME', 'ben_dsgntr_enrld_cvg_f');

424: -- The object is locked therefore we need to supply a meaningful
425: -- error message.
426: --
427: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
428: fnd_message.set_token('TABLE_NAME', 'ben_dsgntr_enrld_cvg_f');
429: fnd_message.raise_error;
430: When l_object_invalid then
431: --
432: -- The object doesn't exist or is invalid

Line 435: fnd_message.set_token('TABLE_NAME', 'ben_dsgntr_enrld_cvg_f');

431: --
432: -- The object doesn't exist or is invalid
433: --
434: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
435: fnd_message.set_token('TABLE_NAME', 'ben_dsgntr_enrld_cvg_f');
436: fnd_message.raise_error;
437: End lck;
438: --
439: -- ----------------------------------------------------------------------------