APPS.BEN_APC_SHD dependencies on BEN_ACRS_PTIP_CVG_F

Line 105: from ben_acrs_ptip_cvg_f

101: apc_attribute28,
102: apc_attribute29,
103: apc_attribute30,
104: object_version_number
105: from ben_acrs_ptip_cvg_f
106: where acrs_ptip_cvg_id = p_acrs_ptip_cvg_id
107: and p_effective_date
108: between effective_start_date and effective_end_date;
109: --

Line 185: p_base_table_name => 'ben_acrs_ptip_cvg_f',

181: -- Call the corresponding datetrack api
182: --
183: dt_api.find_dt_del_modes
184: (p_effective_date => p_effective_date,
185: p_base_table_name => 'ben_acrs_ptip_cvg_f',
186: p_base_key_column => 'acrs_ptip_cvg_id',
187: p_base_key_value => p_base_key_value,
188: p_zap => p_zap,
189: p_delete => p_delete,

Line 216: p_base_table_name => 'ben_acrs_ptip_cvg_f',

212: -- Call the corresponding datetrack api
213: --
214: dt_api.find_dt_upd_modes
215: (p_effective_date => p_effective_date,
216: p_base_table_name => 'ben_acrs_ptip_cvg_f',
217: p_base_key_column => 'acrs_ptip_cvg_id',
218: p_base_key_value => p_base_key_value,
219: p_correction => p_correction,
220: p_update => p_update,

Line 249: (p_base_table_name => 'ben_acrs_ptip_cvg_f',

245: -- version number.
246: --
247: l_object_version_number :=
248: dt_api.get_object_version_number
249: (p_base_table_name => 'ben_acrs_ptip_cvg_f',
250: p_base_key_column => 'acrs_ptip_cvg_id',
251: p_base_key_value => p_base_key_value);
252: --
253: hr_utility.set_location(l_proc, 10);

Line 259: update ben_acrs_ptip_cvg_f t

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

Line 338: from ben_acrs_ptip_cvg_f

334: apc_attribute28,
335: apc_attribute29,
336: apc_attribute30,
337: object_version_number
338: from ben_acrs_ptip_cvg_f
339: where acrs_ptip_cvg_id = p_acrs_ptip_cvg_id
340: and p_effective_date
341: between effective_start_date and effective_end_date
342: for update nowait;

Line 397: p_base_table_name => 'ben_acrs_ptip_cvg_f',

393: --
394: dt_api.validate_dt_mode
395: (p_effective_date => p_effective_date,
396: p_datetrack_mode => p_datetrack_mode,
397: p_base_table_name => 'ben_acrs_ptip_cvg_f',
398: p_base_key_column => 'acrs_ptip_cvg_id',
399: p_base_key_value => p_acrs_ptip_cvg_id,
400:
401: p_enforce_foreign_locking => false , --true,

Line 432: fnd_message.set_token('TABLE_NAME', 'ben_acrs_ptip_cvg_f');

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

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

435: --
436: -- The object doesn't exist or is invalid
437: --
438: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
439: fnd_message.set_token('TABLE_NAME', 'ben_acrs_ptip_cvg_f');
440: fnd_message.raise_error;
441: End lck;
442: --
443: -- ----------------------------------------------------------------------------