APPS.BEN_PTR_SHD dependencies on BEN_PER_TYP_RT_F

Line 106: from ben_per_typ_rt_f

102: ptr_attribute28,
103: ptr_attribute29,
104: ptr_attribute30,
105: object_version_number
106: from ben_per_typ_rt_f
107: where per_typ_rt_id = p_per_typ_rt_id
108: and p_effective_date
109: between effective_start_date and effective_end_date;
110: --

Line 179: from ben_per_typ_rt_f t

175: l_parent_key_value1 number;
176: --
177: Cursor C_Sel1 Is
178: select t.vrbl_rt_prfl_id
179: from ben_per_typ_rt_f t
180: where t.per_typ_rt_id = p_base_key_value
181: and p_effective_date
182: between t.effective_start_date and t.effective_end_date;
183: --

Line 202: p_base_table_name => 'ben_per_typ_rt_f',

198: -- Call the corresponding datetrack api
199: --
200: dt_api.find_dt_del_modes
201: (p_effective_date => p_effective_date,
202: p_base_table_name => 'ben_per_typ_rt_f',
203: p_base_key_column => 'per_typ_rt_id',
204: p_base_key_value => p_base_key_value,
205: p_parent_table_name1 => 'ben_vrbl_rt_prfl_f',
206: p_parent_key_column1 => 'vrbl_rt_prfl_id',

Line 236: p_base_table_name => 'ben_per_typ_rt_f',

232: -- Call the corresponding datetrack api
233: --
234: dt_api.find_dt_upd_modes
235: (p_effective_date => p_effective_date,
236: p_base_table_name => 'ben_per_typ_rt_f',
237: p_base_key_column => 'per_typ_rt_id',
238: p_base_key_value => p_base_key_value,
239: p_correction => p_correction,
240: p_update => p_update,

Line 269: (p_base_table_name => 'ben_per_typ_rt_f',

265: -- version number.
266: --
267: l_object_version_number :=
268: dt_api.get_object_version_number
269: (p_base_table_name => 'ben_per_typ_rt_f',
270: p_base_key_column => 'per_typ_rt_id',
271: p_base_key_value => p_base_key_value);
272: --
273: hr_utility.set_location(l_proc, 10);

Line 279: update ben_per_typ_rt_f t

275: --
276: -- Update the specified datetrack row setting the effective
277: -- end date to the specified new effective end date.
278: --
279: update ben_per_typ_rt_f t
280: set t.effective_end_date = p_new_effective_end_date,
281: t.object_version_number = l_object_version_number
282: where t.per_typ_rt_id = p_base_key_value
283: and p_effective_date

Line 359: from ben_per_typ_rt_f

355: ptr_attribute28,
356: ptr_attribute29,
357: ptr_attribute30,
358: object_version_number
359: from ben_per_typ_rt_f
360: where per_typ_rt_id = p_per_typ_rt_id
361: and p_effective_date
362: between effective_start_date and effective_end_date
363: for update nowait;

Line 418: p_base_table_name => 'ben_per_typ_rt_f',

414: --
415: dt_api.validate_dt_mode
416: (p_effective_date => p_effective_date,
417: p_datetrack_mode => p_datetrack_mode,
418: p_base_table_name => 'ben_per_typ_rt_f',
419: p_base_key_column => 'per_typ_rt_id',
420: p_base_key_value => p_per_typ_rt_id,
421: p_parent_table_name1 => 'ben_vrbl_rt_prfl_f',
422: p_parent_key_column1 => 'vrbl_rt_prfl_id',

Line 455: hr_utility.set_message_token('TABLE_NAME', 'ben_per_typ_rt_f');

451: -- The object is locked therefore we need to supply a meaningful
452: -- error message.
453: --
454: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
455: hr_utility.set_message_token('TABLE_NAME', 'ben_per_typ_rt_f');
456: hr_utility.raise_error;
457: When l_object_invalid then
458: --
459: -- The object doesn't exist or is invalid

Line 462: hr_utility.set_message_token('TABLE_NAME', 'ben_per_typ_rt_f');

458: --
459: -- The object doesn't exist or is invalid
460: --
461: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
462: hr_utility.set_message_token('TABLE_NAME', 'ben_per_typ_rt_f');
463: hr_utility.raise_error;
464: End lck;
465: --
466: -- ----------------------------------------------------------------------------