APPS.BEN_BVR_SHD dependencies on BEN_BNFT_VRBL_RT_F

Line 104: from ben_bnft_vrbl_rt_f

100: bvr_attribute29,
101: bvr_attribute30,
102: object_version_number,
103: ordr_num
104: from ben_bnft_vrbl_rt_f
105: where bnft_vrbl_rt_id = p_bnft_vrbl_rt_id
106: and p_effective_date
107: between effective_start_date and effective_end_date;
108: --

Line 179: from ben_bnft_vrbl_rt_f t

175: --
176: Cursor C_Sel1 Is
177: select t.vrbl_rt_prfl_id,
178: t.cvg_amt_calc_mthd_id
179: from ben_bnft_vrbl_rt_f t
180: where t.bnft_vrbl_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_bnft_vrbl_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_bnft_vrbl_rt_f',
203: p_base_key_column => 'bnft_vrbl_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 239: p_base_table_name => 'ben_bnft_vrbl_rt_f',

235: -- Call the corresponding datetrack api
236: --
237: dt_api.find_dt_upd_modes
238: (p_effective_date => p_effective_date,
239: p_base_table_name => 'ben_bnft_vrbl_rt_f',
240: p_base_key_column => 'bnft_vrbl_rt_id',
241: p_base_key_value => p_base_key_value,
242: p_correction => p_correction,
243: p_update => p_update,

Line 272: (p_base_table_name => 'ben_bnft_vrbl_rt_f',

268: -- version number.
269: --
270: l_object_version_number :=
271: dt_api.get_object_version_number
272: (p_base_table_name => 'ben_bnft_vrbl_rt_f',
273: p_base_key_column => 'bnft_vrbl_rt_id',
274: p_base_key_value => p_base_key_value);
275: --
276: hr_utility.set_location(l_proc, 10);

Line 282: update ben_bnft_vrbl_rt_f t

278: --
279: -- Update the specified datetrack row setting the effective
280: -- end date to the specified new effective end date.
281: --
282: update ben_bnft_vrbl_rt_f t
283: set t.effective_end_date = p_new_effective_end_date,
284: t.object_version_number = l_object_version_number
285: where t.bnft_vrbl_rt_id = p_base_key_value
286: and p_effective_date

Line 360: from ben_bnft_vrbl_rt_f

356: bvr_attribute29,
357: bvr_attribute30,
358: object_version_number,
359: ordr_num
360: from ben_bnft_vrbl_rt_f
361: where bnft_vrbl_rt_id = p_bnft_vrbl_rt_id
362: and p_effective_date
363: between effective_start_date and effective_end_date
364: for update nowait;

Line 419: p_base_table_name => 'ben_bnft_vrbl_rt_f',

415: --
416: dt_api.validate_dt_mode
417: (p_effective_date => p_effective_date,
418: p_datetrack_mode => p_datetrack_mode,
419: p_base_table_name => 'ben_bnft_vrbl_rt_f',
420: p_base_key_column => 'bnft_vrbl_rt_id',
421: p_base_key_value => p_bnft_vrbl_rt_id,
422: p_parent_table_name1 => 'ben_vrbl_rt_prfl_f',
423: p_parent_key_column1 => 'vrbl_rt_prfl_id',

Line 459: hr_utility.set_message_token('TABLE_NAME', 'ben_bnft_vrbl_rt_f');

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

Line 466: hr_utility.set_message_token('TABLE_NAME', 'ben_bnft_vrbl_rt_f');

462: --
463: -- The object doesn't exist or is invalid
464: --
465: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
466: hr_utility.set_message_token('TABLE_NAME', 'ben_bnft_vrbl_rt_f');
467: hr_utility.raise_error;
468: End lck;
469: --
470: -- ----------------------------------------------------------------------------