eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_VMR_DEL dependencies on BEN_VMR_SHD

Line 54: (p_rec in out nocopy ben_vmr_shd.g_rec_type,

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy ben_vmr_shd.g_rec_type,
55: p_effective_date in date,
56: p_datetrack_mode in varchar2,
57: p_validation_start_date in date,
58: p_validation_end_date in date) is

Line 66: ben_vmr_shd.g_api_dml := true; -- Set the api dml status

62: Begin
63: hr_utility.set_location('Entering:'||l_proc, 5);
64: If (p_datetrack_mode = 'DELETE_NEXT_CHANGE') then
65: hr_utility.set_location(l_proc, 10);
66: ben_vmr_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Delete the where the effective start date is equal
69: -- to the validation end date.
70: --

Line 75: ben_vmr_shd.g_api_dml := false; -- Unset the api dml status

71: delete from ben_vrbl_mtchg_rt_f
72: where vrbl_mtchg_rt_id = p_rec.vrbl_mtchg_rt_id
73: and effective_start_date = p_validation_start_date;
74: --
75: ben_vmr_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: hr_utility.set_location(l_proc, 15);
78: ben_vmr_shd.g_api_dml := true; -- Set the api dml status
79: --

Line 78: ben_vmr_shd.g_api_dml := true; -- Set the api dml status

74: --
75: ben_vmr_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: hr_utility.set_location(l_proc, 15);
78: ben_vmr_shd.g_api_dml := true; -- Set the api dml status
79: --
80: -- Delete the row(s) where the effective start date is greater than
81: -- or equal to the validation start date.
82: --

Line 87: ben_vmr_shd.g_api_dml := false; -- Unset the api dml status

83: delete from ben_vrbl_mtchg_rt_f
84: where vrbl_mtchg_rt_id = p_rec.vrbl_mtchg_rt_id
85: and effective_start_date >= p_validation_start_date;
86: --
87: ben_vmr_shd.g_api_dml := false; -- Unset the api dml status
88: End If;
89: --
90: hr_utility.set_location(' Leaving:'||l_proc, 20);
91: --

Line 94: ben_vmr_shd.g_api_dml := false; -- Unset the api dml status

90: hr_utility.set_location(' Leaving:'||l_proc, 20);
91: --
92: Exception
93: When Others Then
94: ben_vmr_shd.g_api_dml := false; -- Unset the api dml status
95: Raise;
96: End dt_delete_dml;
97: --
98: -- ----------------------------------------------------------------------------

Line 102: (p_rec in out nocopy ben_vmr_shd.g_rec_type,

98: -- ----------------------------------------------------------------------------
99: -- |------------------------------< delete_dml >------------------------------|
100: -- ----------------------------------------------------------------------------
101: Procedure delete_dml
102: (p_rec in out nocopy ben_vmr_shd.g_rec_type,
103: p_effective_date in date,
104: p_datetrack_mode in varchar2,
105: p_validation_start_date in date,
106: p_validation_end_date in date) is

Line 156: (p_rec in out nocopy ben_vmr_shd.g_rec_type,

152: --
153: -- {End Of Comments}
154: -- ----------------------------------------------------------------------------
155: Procedure dt_pre_delete
156: (p_rec in out nocopy ben_vmr_shd.g_rec_type,
157: p_effective_date in date,
158: p_datetrack_mode in varchar2,
159: p_validation_start_date in date,
160: p_validation_end_date in date) is

Line 169: p_rec.effective_start_date := ben_vmr_shd.g_old_rec.effective_start_date;

165: hr_utility.set_location('Entering:'||l_proc, 5);
166: --
167: If (p_datetrack_mode <> 'ZAP') then
168: --
169: p_rec.effective_start_date := ben_vmr_shd.g_old_rec.effective_start_date;
170: --
171: If (p_datetrack_mode = 'DELETE') then
172: p_rec.effective_end_date := p_validation_start_date - 1;
173: Else

Line 179: ben_vmr_shd.upd_effective_end_date

175: End If;
176: --
177: -- Update the current effective end date record
178: --
179: ben_vmr_shd.upd_effective_end_date
180: (p_effective_date => p_effective_date,
181: p_base_key_value => p_rec.vrbl_mtchg_rt_id,
182: p_new_effective_end_date => p_rec.effective_end_date,
183: p_validation_start_date => p_validation_start_date,

Line 227: (p_rec in out nocopy ben_vmr_shd.g_rec_type,

223: --
224: -- {End Of Comments}
225: -- ----------------------------------------------------------------------------
226: Procedure pre_delete
227: (p_rec in out nocopy ben_vmr_shd.g_rec_type,
228: p_effective_date in date,
229: p_datetrack_mode in varchar2,
230: p_validation_start_date in date,
231: p_validation_end_date in date) is

Line 285: (p_rec in ben_vmr_shd.g_rec_type,

281: --
282: -- {End Of Comments}
283: -- ----------------------------------------------------------------------------
284: Procedure post_delete
285: (p_rec in ben_vmr_shd.g_rec_type,
286: p_effective_date in date,
287: p_datetrack_mode in varchar2,
288: p_validation_start_date in date,
289: p_validation_end_date in date) is

Line 309: ,p_effective_end_date_o =>ben_vmr_shd.g_old_rec.effective_end_date

305: ,p_validation_start_date =>p_validation_start_date
306: ,p_validation_end_date =>p_validation_end_date
307: ,p_effective_start_date =>p_rec.effective_start_date
308: ,p_effective_end_date =>p_rec.effective_end_date
309: ,p_effective_end_date_o =>ben_vmr_shd.g_old_rec.effective_end_date
310: ,p_effective_start_date_o =>ben_vmr_shd.g_old_rec.effective_start_date
311: ,p_no_mx_pct_of_py_num_flag_o =>ben_vmr_shd.g_old_rec.no_mx_pct_of_py_num_flag
312: ,p_to_pct_val_o =>ben_vmr_shd.g_old_rec.to_pct_val
313: ,p_no_mx_amt_of_py_num_flag_o =>ben_vmr_shd.g_old_rec.no_mx_amt_of_py_num_flag

Line 310: ,p_effective_start_date_o =>ben_vmr_shd.g_old_rec.effective_start_date

306: ,p_validation_end_date =>p_validation_end_date
307: ,p_effective_start_date =>p_rec.effective_start_date
308: ,p_effective_end_date =>p_rec.effective_end_date
309: ,p_effective_end_date_o =>ben_vmr_shd.g_old_rec.effective_end_date
310: ,p_effective_start_date_o =>ben_vmr_shd.g_old_rec.effective_start_date
311: ,p_no_mx_pct_of_py_num_flag_o =>ben_vmr_shd.g_old_rec.no_mx_pct_of_py_num_flag
312: ,p_to_pct_val_o =>ben_vmr_shd.g_old_rec.to_pct_val
313: ,p_no_mx_amt_of_py_num_flag_o =>ben_vmr_shd.g_old_rec.no_mx_amt_of_py_num_flag
314: ,p_mx_pct_of_py_num_o =>ben_vmr_shd.g_old_rec.mx_pct_of_py_num

Line 311: ,p_no_mx_pct_of_py_num_flag_o =>ben_vmr_shd.g_old_rec.no_mx_pct_of_py_num_flag

307: ,p_effective_start_date =>p_rec.effective_start_date
308: ,p_effective_end_date =>p_rec.effective_end_date
309: ,p_effective_end_date_o =>ben_vmr_shd.g_old_rec.effective_end_date
310: ,p_effective_start_date_o =>ben_vmr_shd.g_old_rec.effective_start_date
311: ,p_no_mx_pct_of_py_num_flag_o =>ben_vmr_shd.g_old_rec.no_mx_pct_of_py_num_flag
312: ,p_to_pct_val_o =>ben_vmr_shd.g_old_rec.to_pct_val
313: ,p_no_mx_amt_of_py_num_flag_o =>ben_vmr_shd.g_old_rec.no_mx_amt_of_py_num_flag
314: ,p_mx_pct_of_py_num_o =>ben_vmr_shd.g_old_rec.mx_pct_of_py_num
315: ,p_no_mx_mtch_amt_flag_o =>ben_vmr_shd.g_old_rec.no_mx_mtch_amt_flag

Line 312: ,p_to_pct_val_o =>ben_vmr_shd.g_old_rec.to_pct_val

308: ,p_effective_end_date =>p_rec.effective_end_date
309: ,p_effective_end_date_o =>ben_vmr_shd.g_old_rec.effective_end_date
310: ,p_effective_start_date_o =>ben_vmr_shd.g_old_rec.effective_start_date
311: ,p_no_mx_pct_of_py_num_flag_o =>ben_vmr_shd.g_old_rec.no_mx_pct_of_py_num_flag
312: ,p_to_pct_val_o =>ben_vmr_shd.g_old_rec.to_pct_val
313: ,p_no_mx_amt_of_py_num_flag_o =>ben_vmr_shd.g_old_rec.no_mx_amt_of_py_num_flag
314: ,p_mx_pct_of_py_num_o =>ben_vmr_shd.g_old_rec.mx_pct_of_py_num
315: ,p_no_mx_mtch_amt_flag_o =>ben_vmr_shd.g_old_rec.no_mx_mtch_amt_flag
316: ,p_ordr_num_o =>ben_vmr_shd.g_old_rec.ordr_num

Line 313: ,p_no_mx_amt_of_py_num_flag_o =>ben_vmr_shd.g_old_rec.no_mx_amt_of_py_num_flag

309: ,p_effective_end_date_o =>ben_vmr_shd.g_old_rec.effective_end_date
310: ,p_effective_start_date_o =>ben_vmr_shd.g_old_rec.effective_start_date
311: ,p_no_mx_pct_of_py_num_flag_o =>ben_vmr_shd.g_old_rec.no_mx_pct_of_py_num_flag
312: ,p_to_pct_val_o =>ben_vmr_shd.g_old_rec.to_pct_val
313: ,p_no_mx_amt_of_py_num_flag_o =>ben_vmr_shd.g_old_rec.no_mx_amt_of_py_num_flag
314: ,p_mx_pct_of_py_num_o =>ben_vmr_shd.g_old_rec.mx_pct_of_py_num
315: ,p_no_mx_mtch_amt_flag_o =>ben_vmr_shd.g_old_rec.no_mx_mtch_amt_flag
316: ,p_ordr_num_o =>ben_vmr_shd.g_old_rec.ordr_num
317: ,p_pct_val_o =>ben_vmr_shd.g_old_rec.pct_val

Line 314: ,p_mx_pct_of_py_num_o =>ben_vmr_shd.g_old_rec.mx_pct_of_py_num

310: ,p_effective_start_date_o =>ben_vmr_shd.g_old_rec.effective_start_date
311: ,p_no_mx_pct_of_py_num_flag_o =>ben_vmr_shd.g_old_rec.no_mx_pct_of_py_num_flag
312: ,p_to_pct_val_o =>ben_vmr_shd.g_old_rec.to_pct_val
313: ,p_no_mx_amt_of_py_num_flag_o =>ben_vmr_shd.g_old_rec.no_mx_amt_of_py_num_flag
314: ,p_mx_pct_of_py_num_o =>ben_vmr_shd.g_old_rec.mx_pct_of_py_num
315: ,p_no_mx_mtch_amt_flag_o =>ben_vmr_shd.g_old_rec.no_mx_mtch_amt_flag
316: ,p_ordr_num_o =>ben_vmr_shd.g_old_rec.ordr_num
317: ,p_pct_val_o =>ben_vmr_shd.g_old_rec.pct_val
318: ,p_mx_mtch_amt_o =>ben_vmr_shd.g_old_rec.mx_mtch_amt

Line 315: ,p_no_mx_mtch_amt_flag_o =>ben_vmr_shd.g_old_rec.no_mx_mtch_amt_flag

311: ,p_no_mx_pct_of_py_num_flag_o =>ben_vmr_shd.g_old_rec.no_mx_pct_of_py_num_flag
312: ,p_to_pct_val_o =>ben_vmr_shd.g_old_rec.to_pct_val
313: ,p_no_mx_amt_of_py_num_flag_o =>ben_vmr_shd.g_old_rec.no_mx_amt_of_py_num_flag
314: ,p_mx_pct_of_py_num_o =>ben_vmr_shd.g_old_rec.mx_pct_of_py_num
315: ,p_no_mx_mtch_amt_flag_o =>ben_vmr_shd.g_old_rec.no_mx_mtch_amt_flag
316: ,p_ordr_num_o =>ben_vmr_shd.g_old_rec.ordr_num
317: ,p_pct_val_o =>ben_vmr_shd.g_old_rec.pct_val
318: ,p_mx_mtch_amt_o =>ben_vmr_shd.g_old_rec.mx_mtch_amt
319: ,p_mx_amt_of_py_num_o =>ben_vmr_shd.g_old_rec.mx_amt_of_py_num

Line 316: ,p_ordr_num_o =>ben_vmr_shd.g_old_rec.ordr_num

312: ,p_to_pct_val_o =>ben_vmr_shd.g_old_rec.to_pct_val
313: ,p_no_mx_amt_of_py_num_flag_o =>ben_vmr_shd.g_old_rec.no_mx_amt_of_py_num_flag
314: ,p_mx_pct_of_py_num_o =>ben_vmr_shd.g_old_rec.mx_pct_of_py_num
315: ,p_no_mx_mtch_amt_flag_o =>ben_vmr_shd.g_old_rec.no_mx_mtch_amt_flag
316: ,p_ordr_num_o =>ben_vmr_shd.g_old_rec.ordr_num
317: ,p_pct_val_o =>ben_vmr_shd.g_old_rec.pct_val
318: ,p_mx_mtch_amt_o =>ben_vmr_shd.g_old_rec.mx_mtch_amt
319: ,p_mx_amt_of_py_num_o =>ben_vmr_shd.g_old_rec.mx_amt_of_py_num
320: ,p_mn_mtch_amt_o =>ben_vmr_shd.g_old_rec.mn_mtch_amt

Line 317: ,p_pct_val_o =>ben_vmr_shd.g_old_rec.pct_val

313: ,p_no_mx_amt_of_py_num_flag_o =>ben_vmr_shd.g_old_rec.no_mx_amt_of_py_num_flag
314: ,p_mx_pct_of_py_num_o =>ben_vmr_shd.g_old_rec.mx_pct_of_py_num
315: ,p_no_mx_mtch_amt_flag_o =>ben_vmr_shd.g_old_rec.no_mx_mtch_amt_flag
316: ,p_ordr_num_o =>ben_vmr_shd.g_old_rec.ordr_num
317: ,p_pct_val_o =>ben_vmr_shd.g_old_rec.pct_val
318: ,p_mx_mtch_amt_o =>ben_vmr_shd.g_old_rec.mx_mtch_amt
319: ,p_mx_amt_of_py_num_o =>ben_vmr_shd.g_old_rec.mx_amt_of_py_num
320: ,p_mn_mtch_amt_o =>ben_vmr_shd.g_old_rec.mn_mtch_amt
321: ,p_mtchg_rt_calc_rl_o =>ben_vmr_shd.g_old_rec.mtchg_rt_calc_rl

Line 318: ,p_mx_mtch_amt_o =>ben_vmr_shd.g_old_rec.mx_mtch_amt

314: ,p_mx_pct_of_py_num_o =>ben_vmr_shd.g_old_rec.mx_pct_of_py_num
315: ,p_no_mx_mtch_amt_flag_o =>ben_vmr_shd.g_old_rec.no_mx_mtch_amt_flag
316: ,p_ordr_num_o =>ben_vmr_shd.g_old_rec.ordr_num
317: ,p_pct_val_o =>ben_vmr_shd.g_old_rec.pct_val
318: ,p_mx_mtch_amt_o =>ben_vmr_shd.g_old_rec.mx_mtch_amt
319: ,p_mx_amt_of_py_num_o =>ben_vmr_shd.g_old_rec.mx_amt_of_py_num
320: ,p_mn_mtch_amt_o =>ben_vmr_shd.g_old_rec.mn_mtch_amt
321: ,p_mtchg_rt_calc_rl_o =>ben_vmr_shd.g_old_rec.mtchg_rt_calc_rl
322: ,p_cntnu_mtch_aftr_max_rl_fla_o =>ben_vmr_shd.g_old_rec.cntnu_mtch_aftr_max_rl_flag

Line 319: ,p_mx_amt_of_py_num_o =>ben_vmr_shd.g_old_rec.mx_amt_of_py_num

315: ,p_no_mx_mtch_amt_flag_o =>ben_vmr_shd.g_old_rec.no_mx_mtch_amt_flag
316: ,p_ordr_num_o =>ben_vmr_shd.g_old_rec.ordr_num
317: ,p_pct_val_o =>ben_vmr_shd.g_old_rec.pct_val
318: ,p_mx_mtch_amt_o =>ben_vmr_shd.g_old_rec.mx_mtch_amt
319: ,p_mx_amt_of_py_num_o =>ben_vmr_shd.g_old_rec.mx_amt_of_py_num
320: ,p_mn_mtch_amt_o =>ben_vmr_shd.g_old_rec.mn_mtch_amt
321: ,p_mtchg_rt_calc_rl_o =>ben_vmr_shd.g_old_rec.mtchg_rt_calc_rl
322: ,p_cntnu_mtch_aftr_max_rl_fla_o =>ben_vmr_shd.g_old_rec.cntnu_mtch_aftr_max_rl_flag
323: ,p_from_pct_val_o =>ben_vmr_shd.g_old_rec.from_pct_val

Line 320: ,p_mn_mtch_amt_o =>ben_vmr_shd.g_old_rec.mn_mtch_amt

316: ,p_ordr_num_o =>ben_vmr_shd.g_old_rec.ordr_num
317: ,p_pct_val_o =>ben_vmr_shd.g_old_rec.pct_val
318: ,p_mx_mtch_amt_o =>ben_vmr_shd.g_old_rec.mx_mtch_amt
319: ,p_mx_amt_of_py_num_o =>ben_vmr_shd.g_old_rec.mx_amt_of_py_num
320: ,p_mn_mtch_amt_o =>ben_vmr_shd.g_old_rec.mn_mtch_amt
321: ,p_mtchg_rt_calc_rl_o =>ben_vmr_shd.g_old_rec.mtchg_rt_calc_rl
322: ,p_cntnu_mtch_aftr_max_rl_fla_o =>ben_vmr_shd.g_old_rec.cntnu_mtch_aftr_max_rl_flag
323: ,p_from_pct_val_o =>ben_vmr_shd.g_old_rec.from_pct_val
324: ,p_vrbl_rt_prfl_id_o =>ben_vmr_shd.g_old_rec.vrbl_rt_prfl_id

Line 321: ,p_mtchg_rt_calc_rl_o =>ben_vmr_shd.g_old_rec.mtchg_rt_calc_rl

317: ,p_pct_val_o =>ben_vmr_shd.g_old_rec.pct_val
318: ,p_mx_mtch_amt_o =>ben_vmr_shd.g_old_rec.mx_mtch_amt
319: ,p_mx_amt_of_py_num_o =>ben_vmr_shd.g_old_rec.mx_amt_of_py_num
320: ,p_mn_mtch_amt_o =>ben_vmr_shd.g_old_rec.mn_mtch_amt
321: ,p_mtchg_rt_calc_rl_o =>ben_vmr_shd.g_old_rec.mtchg_rt_calc_rl
322: ,p_cntnu_mtch_aftr_max_rl_fla_o =>ben_vmr_shd.g_old_rec.cntnu_mtch_aftr_max_rl_flag
323: ,p_from_pct_val_o =>ben_vmr_shd.g_old_rec.from_pct_val
324: ,p_vrbl_rt_prfl_id_o =>ben_vmr_shd.g_old_rec.vrbl_rt_prfl_id
325: ,p_business_group_id_o =>ben_vmr_shd.g_old_rec.business_group_id

Line 322: ,p_cntnu_mtch_aftr_max_rl_fla_o =>ben_vmr_shd.g_old_rec.cntnu_mtch_aftr_max_rl_flag

318: ,p_mx_mtch_amt_o =>ben_vmr_shd.g_old_rec.mx_mtch_amt
319: ,p_mx_amt_of_py_num_o =>ben_vmr_shd.g_old_rec.mx_amt_of_py_num
320: ,p_mn_mtch_amt_o =>ben_vmr_shd.g_old_rec.mn_mtch_amt
321: ,p_mtchg_rt_calc_rl_o =>ben_vmr_shd.g_old_rec.mtchg_rt_calc_rl
322: ,p_cntnu_mtch_aftr_max_rl_fla_o =>ben_vmr_shd.g_old_rec.cntnu_mtch_aftr_max_rl_flag
323: ,p_from_pct_val_o =>ben_vmr_shd.g_old_rec.from_pct_val
324: ,p_vrbl_rt_prfl_id_o =>ben_vmr_shd.g_old_rec.vrbl_rt_prfl_id
325: ,p_business_group_id_o =>ben_vmr_shd.g_old_rec.business_group_id
326: ,p_vmr_attribute_category_o =>ben_vmr_shd.g_old_rec.vmr_attribute_category

Line 323: ,p_from_pct_val_o =>ben_vmr_shd.g_old_rec.from_pct_val

319: ,p_mx_amt_of_py_num_o =>ben_vmr_shd.g_old_rec.mx_amt_of_py_num
320: ,p_mn_mtch_amt_o =>ben_vmr_shd.g_old_rec.mn_mtch_amt
321: ,p_mtchg_rt_calc_rl_o =>ben_vmr_shd.g_old_rec.mtchg_rt_calc_rl
322: ,p_cntnu_mtch_aftr_max_rl_fla_o =>ben_vmr_shd.g_old_rec.cntnu_mtch_aftr_max_rl_flag
323: ,p_from_pct_val_o =>ben_vmr_shd.g_old_rec.from_pct_val
324: ,p_vrbl_rt_prfl_id_o =>ben_vmr_shd.g_old_rec.vrbl_rt_prfl_id
325: ,p_business_group_id_o =>ben_vmr_shd.g_old_rec.business_group_id
326: ,p_vmr_attribute_category_o =>ben_vmr_shd.g_old_rec.vmr_attribute_category
327: ,p_vmr_attribute1_o =>ben_vmr_shd.g_old_rec.vmr_attribute1

Line 324: ,p_vrbl_rt_prfl_id_o =>ben_vmr_shd.g_old_rec.vrbl_rt_prfl_id

320: ,p_mn_mtch_amt_o =>ben_vmr_shd.g_old_rec.mn_mtch_amt
321: ,p_mtchg_rt_calc_rl_o =>ben_vmr_shd.g_old_rec.mtchg_rt_calc_rl
322: ,p_cntnu_mtch_aftr_max_rl_fla_o =>ben_vmr_shd.g_old_rec.cntnu_mtch_aftr_max_rl_flag
323: ,p_from_pct_val_o =>ben_vmr_shd.g_old_rec.from_pct_val
324: ,p_vrbl_rt_prfl_id_o =>ben_vmr_shd.g_old_rec.vrbl_rt_prfl_id
325: ,p_business_group_id_o =>ben_vmr_shd.g_old_rec.business_group_id
326: ,p_vmr_attribute_category_o =>ben_vmr_shd.g_old_rec.vmr_attribute_category
327: ,p_vmr_attribute1_o =>ben_vmr_shd.g_old_rec.vmr_attribute1
328: ,p_vmr_attribute2_o =>ben_vmr_shd.g_old_rec.vmr_attribute2

Line 325: ,p_business_group_id_o =>ben_vmr_shd.g_old_rec.business_group_id

321: ,p_mtchg_rt_calc_rl_o =>ben_vmr_shd.g_old_rec.mtchg_rt_calc_rl
322: ,p_cntnu_mtch_aftr_max_rl_fla_o =>ben_vmr_shd.g_old_rec.cntnu_mtch_aftr_max_rl_flag
323: ,p_from_pct_val_o =>ben_vmr_shd.g_old_rec.from_pct_val
324: ,p_vrbl_rt_prfl_id_o =>ben_vmr_shd.g_old_rec.vrbl_rt_prfl_id
325: ,p_business_group_id_o =>ben_vmr_shd.g_old_rec.business_group_id
326: ,p_vmr_attribute_category_o =>ben_vmr_shd.g_old_rec.vmr_attribute_category
327: ,p_vmr_attribute1_o =>ben_vmr_shd.g_old_rec.vmr_attribute1
328: ,p_vmr_attribute2_o =>ben_vmr_shd.g_old_rec.vmr_attribute2
329: ,p_vmr_attribute3_o =>ben_vmr_shd.g_old_rec.vmr_attribute3

Line 326: ,p_vmr_attribute_category_o =>ben_vmr_shd.g_old_rec.vmr_attribute_category

322: ,p_cntnu_mtch_aftr_max_rl_fla_o =>ben_vmr_shd.g_old_rec.cntnu_mtch_aftr_max_rl_flag
323: ,p_from_pct_val_o =>ben_vmr_shd.g_old_rec.from_pct_val
324: ,p_vrbl_rt_prfl_id_o =>ben_vmr_shd.g_old_rec.vrbl_rt_prfl_id
325: ,p_business_group_id_o =>ben_vmr_shd.g_old_rec.business_group_id
326: ,p_vmr_attribute_category_o =>ben_vmr_shd.g_old_rec.vmr_attribute_category
327: ,p_vmr_attribute1_o =>ben_vmr_shd.g_old_rec.vmr_attribute1
328: ,p_vmr_attribute2_o =>ben_vmr_shd.g_old_rec.vmr_attribute2
329: ,p_vmr_attribute3_o =>ben_vmr_shd.g_old_rec.vmr_attribute3
330: ,p_vmr_attribute4_o =>ben_vmr_shd.g_old_rec.vmr_attribute4

Line 327: ,p_vmr_attribute1_o =>ben_vmr_shd.g_old_rec.vmr_attribute1

323: ,p_from_pct_val_o =>ben_vmr_shd.g_old_rec.from_pct_val
324: ,p_vrbl_rt_prfl_id_o =>ben_vmr_shd.g_old_rec.vrbl_rt_prfl_id
325: ,p_business_group_id_o =>ben_vmr_shd.g_old_rec.business_group_id
326: ,p_vmr_attribute_category_o =>ben_vmr_shd.g_old_rec.vmr_attribute_category
327: ,p_vmr_attribute1_o =>ben_vmr_shd.g_old_rec.vmr_attribute1
328: ,p_vmr_attribute2_o =>ben_vmr_shd.g_old_rec.vmr_attribute2
329: ,p_vmr_attribute3_o =>ben_vmr_shd.g_old_rec.vmr_attribute3
330: ,p_vmr_attribute4_o =>ben_vmr_shd.g_old_rec.vmr_attribute4
331: ,p_vmr_attribute5_o =>ben_vmr_shd.g_old_rec.vmr_attribute5

Line 328: ,p_vmr_attribute2_o =>ben_vmr_shd.g_old_rec.vmr_attribute2

324: ,p_vrbl_rt_prfl_id_o =>ben_vmr_shd.g_old_rec.vrbl_rt_prfl_id
325: ,p_business_group_id_o =>ben_vmr_shd.g_old_rec.business_group_id
326: ,p_vmr_attribute_category_o =>ben_vmr_shd.g_old_rec.vmr_attribute_category
327: ,p_vmr_attribute1_o =>ben_vmr_shd.g_old_rec.vmr_attribute1
328: ,p_vmr_attribute2_o =>ben_vmr_shd.g_old_rec.vmr_attribute2
329: ,p_vmr_attribute3_o =>ben_vmr_shd.g_old_rec.vmr_attribute3
330: ,p_vmr_attribute4_o =>ben_vmr_shd.g_old_rec.vmr_attribute4
331: ,p_vmr_attribute5_o =>ben_vmr_shd.g_old_rec.vmr_attribute5
332: ,p_vmr_attribute6_o =>ben_vmr_shd.g_old_rec.vmr_attribute6

Line 329: ,p_vmr_attribute3_o =>ben_vmr_shd.g_old_rec.vmr_attribute3

325: ,p_business_group_id_o =>ben_vmr_shd.g_old_rec.business_group_id
326: ,p_vmr_attribute_category_o =>ben_vmr_shd.g_old_rec.vmr_attribute_category
327: ,p_vmr_attribute1_o =>ben_vmr_shd.g_old_rec.vmr_attribute1
328: ,p_vmr_attribute2_o =>ben_vmr_shd.g_old_rec.vmr_attribute2
329: ,p_vmr_attribute3_o =>ben_vmr_shd.g_old_rec.vmr_attribute3
330: ,p_vmr_attribute4_o =>ben_vmr_shd.g_old_rec.vmr_attribute4
331: ,p_vmr_attribute5_o =>ben_vmr_shd.g_old_rec.vmr_attribute5
332: ,p_vmr_attribute6_o =>ben_vmr_shd.g_old_rec.vmr_attribute6
333: ,p_vmr_attribute7_o =>ben_vmr_shd.g_old_rec.vmr_attribute7

Line 330: ,p_vmr_attribute4_o =>ben_vmr_shd.g_old_rec.vmr_attribute4

326: ,p_vmr_attribute_category_o =>ben_vmr_shd.g_old_rec.vmr_attribute_category
327: ,p_vmr_attribute1_o =>ben_vmr_shd.g_old_rec.vmr_attribute1
328: ,p_vmr_attribute2_o =>ben_vmr_shd.g_old_rec.vmr_attribute2
329: ,p_vmr_attribute3_o =>ben_vmr_shd.g_old_rec.vmr_attribute3
330: ,p_vmr_attribute4_o =>ben_vmr_shd.g_old_rec.vmr_attribute4
331: ,p_vmr_attribute5_o =>ben_vmr_shd.g_old_rec.vmr_attribute5
332: ,p_vmr_attribute6_o =>ben_vmr_shd.g_old_rec.vmr_attribute6
333: ,p_vmr_attribute7_o =>ben_vmr_shd.g_old_rec.vmr_attribute7
334: ,p_vmr_attribute8_o =>ben_vmr_shd.g_old_rec.vmr_attribute8

Line 331: ,p_vmr_attribute5_o =>ben_vmr_shd.g_old_rec.vmr_attribute5

327: ,p_vmr_attribute1_o =>ben_vmr_shd.g_old_rec.vmr_attribute1
328: ,p_vmr_attribute2_o =>ben_vmr_shd.g_old_rec.vmr_attribute2
329: ,p_vmr_attribute3_o =>ben_vmr_shd.g_old_rec.vmr_attribute3
330: ,p_vmr_attribute4_o =>ben_vmr_shd.g_old_rec.vmr_attribute4
331: ,p_vmr_attribute5_o =>ben_vmr_shd.g_old_rec.vmr_attribute5
332: ,p_vmr_attribute6_o =>ben_vmr_shd.g_old_rec.vmr_attribute6
333: ,p_vmr_attribute7_o =>ben_vmr_shd.g_old_rec.vmr_attribute7
334: ,p_vmr_attribute8_o =>ben_vmr_shd.g_old_rec.vmr_attribute8
335: ,p_vmr_attribute9_o =>ben_vmr_shd.g_old_rec.vmr_attribute9

Line 332: ,p_vmr_attribute6_o =>ben_vmr_shd.g_old_rec.vmr_attribute6

328: ,p_vmr_attribute2_o =>ben_vmr_shd.g_old_rec.vmr_attribute2
329: ,p_vmr_attribute3_o =>ben_vmr_shd.g_old_rec.vmr_attribute3
330: ,p_vmr_attribute4_o =>ben_vmr_shd.g_old_rec.vmr_attribute4
331: ,p_vmr_attribute5_o =>ben_vmr_shd.g_old_rec.vmr_attribute5
332: ,p_vmr_attribute6_o =>ben_vmr_shd.g_old_rec.vmr_attribute6
333: ,p_vmr_attribute7_o =>ben_vmr_shd.g_old_rec.vmr_attribute7
334: ,p_vmr_attribute8_o =>ben_vmr_shd.g_old_rec.vmr_attribute8
335: ,p_vmr_attribute9_o =>ben_vmr_shd.g_old_rec.vmr_attribute9
336: ,p_vmr_attribute10_o =>ben_vmr_shd.g_old_rec.vmr_attribute10

Line 333: ,p_vmr_attribute7_o =>ben_vmr_shd.g_old_rec.vmr_attribute7

329: ,p_vmr_attribute3_o =>ben_vmr_shd.g_old_rec.vmr_attribute3
330: ,p_vmr_attribute4_o =>ben_vmr_shd.g_old_rec.vmr_attribute4
331: ,p_vmr_attribute5_o =>ben_vmr_shd.g_old_rec.vmr_attribute5
332: ,p_vmr_attribute6_o =>ben_vmr_shd.g_old_rec.vmr_attribute6
333: ,p_vmr_attribute7_o =>ben_vmr_shd.g_old_rec.vmr_attribute7
334: ,p_vmr_attribute8_o =>ben_vmr_shd.g_old_rec.vmr_attribute8
335: ,p_vmr_attribute9_o =>ben_vmr_shd.g_old_rec.vmr_attribute9
336: ,p_vmr_attribute10_o =>ben_vmr_shd.g_old_rec.vmr_attribute10
337: ,p_vmr_attribute11_o =>ben_vmr_shd.g_old_rec.vmr_attribute11

Line 334: ,p_vmr_attribute8_o =>ben_vmr_shd.g_old_rec.vmr_attribute8

330: ,p_vmr_attribute4_o =>ben_vmr_shd.g_old_rec.vmr_attribute4
331: ,p_vmr_attribute5_o =>ben_vmr_shd.g_old_rec.vmr_attribute5
332: ,p_vmr_attribute6_o =>ben_vmr_shd.g_old_rec.vmr_attribute6
333: ,p_vmr_attribute7_o =>ben_vmr_shd.g_old_rec.vmr_attribute7
334: ,p_vmr_attribute8_o =>ben_vmr_shd.g_old_rec.vmr_attribute8
335: ,p_vmr_attribute9_o =>ben_vmr_shd.g_old_rec.vmr_attribute9
336: ,p_vmr_attribute10_o =>ben_vmr_shd.g_old_rec.vmr_attribute10
337: ,p_vmr_attribute11_o =>ben_vmr_shd.g_old_rec.vmr_attribute11
338: ,p_vmr_attribute12_o =>ben_vmr_shd.g_old_rec.vmr_attribute12

Line 335: ,p_vmr_attribute9_o =>ben_vmr_shd.g_old_rec.vmr_attribute9

331: ,p_vmr_attribute5_o =>ben_vmr_shd.g_old_rec.vmr_attribute5
332: ,p_vmr_attribute6_o =>ben_vmr_shd.g_old_rec.vmr_attribute6
333: ,p_vmr_attribute7_o =>ben_vmr_shd.g_old_rec.vmr_attribute7
334: ,p_vmr_attribute8_o =>ben_vmr_shd.g_old_rec.vmr_attribute8
335: ,p_vmr_attribute9_o =>ben_vmr_shd.g_old_rec.vmr_attribute9
336: ,p_vmr_attribute10_o =>ben_vmr_shd.g_old_rec.vmr_attribute10
337: ,p_vmr_attribute11_o =>ben_vmr_shd.g_old_rec.vmr_attribute11
338: ,p_vmr_attribute12_o =>ben_vmr_shd.g_old_rec.vmr_attribute12
339: ,p_vmr_attribute13_o =>ben_vmr_shd.g_old_rec.vmr_attribute13

Line 336: ,p_vmr_attribute10_o =>ben_vmr_shd.g_old_rec.vmr_attribute10

332: ,p_vmr_attribute6_o =>ben_vmr_shd.g_old_rec.vmr_attribute6
333: ,p_vmr_attribute7_o =>ben_vmr_shd.g_old_rec.vmr_attribute7
334: ,p_vmr_attribute8_o =>ben_vmr_shd.g_old_rec.vmr_attribute8
335: ,p_vmr_attribute9_o =>ben_vmr_shd.g_old_rec.vmr_attribute9
336: ,p_vmr_attribute10_o =>ben_vmr_shd.g_old_rec.vmr_attribute10
337: ,p_vmr_attribute11_o =>ben_vmr_shd.g_old_rec.vmr_attribute11
338: ,p_vmr_attribute12_o =>ben_vmr_shd.g_old_rec.vmr_attribute12
339: ,p_vmr_attribute13_o =>ben_vmr_shd.g_old_rec.vmr_attribute13
340: ,p_vmr_attribute14_o =>ben_vmr_shd.g_old_rec.vmr_attribute14

Line 337: ,p_vmr_attribute11_o =>ben_vmr_shd.g_old_rec.vmr_attribute11

333: ,p_vmr_attribute7_o =>ben_vmr_shd.g_old_rec.vmr_attribute7
334: ,p_vmr_attribute8_o =>ben_vmr_shd.g_old_rec.vmr_attribute8
335: ,p_vmr_attribute9_o =>ben_vmr_shd.g_old_rec.vmr_attribute9
336: ,p_vmr_attribute10_o =>ben_vmr_shd.g_old_rec.vmr_attribute10
337: ,p_vmr_attribute11_o =>ben_vmr_shd.g_old_rec.vmr_attribute11
338: ,p_vmr_attribute12_o =>ben_vmr_shd.g_old_rec.vmr_attribute12
339: ,p_vmr_attribute13_o =>ben_vmr_shd.g_old_rec.vmr_attribute13
340: ,p_vmr_attribute14_o =>ben_vmr_shd.g_old_rec.vmr_attribute14
341: ,p_vmr_attribute15_o =>ben_vmr_shd.g_old_rec.vmr_attribute15

Line 338: ,p_vmr_attribute12_o =>ben_vmr_shd.g_old_rec.vmr_attribute12

334: ,p_vmr_attribute8_o =>ben_vmr_shd.g_old_rec.vmr_attribute8
335: ,p_vmr_attribute9_o =>ben_vmr_shd.g_old_rec.vmr_attribute9
336: ,p_vmr_attribute10_o =>ben_vmr_shd.g_old_rec.vmr_attribute10
337: ,p_vmr_attribute11_o =>ben_vmr_shd.g_old_rec.vmr_attribute11
338: ,p_vmr_attribute12_o =>ben_vmr_shd.g_old_rec.vmr_attribute12
339: ,p_vmr_attribute13_o =>ben_vmr_shd.g_old_rec.vmr_attribute13
340: ,p_vmr_attribute14_o =>ben_vmr_shd.g_old_rec.vmr_attribute14
341: ,p_vmr_attribute15_o =>ben_vmr_shd.g_old_rec.vmr_attribute15
342: ,p_vmr_attribute16_o =>ben_vmr_shd.g_old_rec.vmr_attribute16

Line 339: ,p_vmr_attribute13_o =>ben_vmr_shd.g_old_rec.vmr_attribute13

335: ,p_vmr_attribute9_o =>ben_vmr_shd.g_old_rec.vmr_attribute9
336: ,p_vmr_attribute10_o =>ben_vmr_shd.g_old_rec.vmr_attribute10
337: ,p_vmr_attribute11_o =>ben_vmr_shd.g_old_rec.vmr_attribute11
338: ,p_vmr_attribute12_o =>ben_vmr_shd.g_old_rec.vmr_attribute12
339: ,p_vmr_attribute13_o =>ben_vmr_shd.g_old_rec.vmr_attribute13
340: ,p_vmr_attribute14_o =>ben_vmr_shd.g_old_rec.vmr_attribute14
341: ,p_vmr_attribute15_o =>ben_vmr_shd.g_old_rec.vmr_attribute15
342: ,p_vmr_attribute16_o =>ben_vmr_shd.g_old_rec.vmr_attribute16
343: ,p_vmr_attribute17_o =>ben_vmr_shd.g_old_rec.vmr_attribute17

Line 340: ,p_vmr_attribute14_o =>ben_vmr_shd.g_old_rec.vmr_attribute14

336: ,p_vmr_attribute10_o =>ben_vmr_shd.g_old_rec.vmr_attribute10
337: ,p_vmr_attribute11_o =>ben_vmr_shd.g_old_rec.vmr_attribute11
338: ,p_vmr_attribute12_o =>ben_vmr_shd.g_old_rec.vmr_attribute12
339: ,p_vmr_attribute13_o =>ben_vmr_shd.g_old_rec.vmr_attribute13
340: ,p_vmr_attribute14_o =>ben_vmr_shd.g_old_rec.vmr_attribute14
341: ,p_vmr_attribute15_o =>ben_vmr_shd.g_old_rec.vmr_attribute15
342: ,p_vmr_attribute16_o =>ben_vmr_shd.g_old_rec.vmr_attribute16
343: ,p_vmr_attribute17_o =>ben_vmr_shd.g_old_rec.vmr_attribute17
344: ,p_vmr_attribute18_o =>ben_vmr_shd.g_old_rec.vmr_attribute18

Line 341: ,p_vmr_attribute15_o =>ben_vmr_shd.g_old_rec.vmr_attribute15

337: ,p_vmr_attribute11_o =>ben_vmr_shd.g_old_rec.vmr_attribute11
338: ,p_vmr_attribute12_o =>ben_vmr_shd.g_old_rec.vmr_attribute12
339: ,p_vmr_attribute13_o =>ben_vmr_shd.g_old_rec.vmr_attribute13
340: ,p_vmr_attribute14_o =>ben_vmr_shd.g_old_rec.vmr_attribute14
341: ,p_vmr_attribute15_o =>ben_vmr_shd.g_old_rec.vmr_attribute15
342: ,p_vmr_attribute16_o =>ben_vmr_shd.g_old_rec.vmr_attribute16
343: ,p_vmr_attribute17_o =>ben_vmr_shd.g_old_rec.vmr_attribute17
344: ,p_vmr_attribute18_o =>ben_vmr_shd.g_old_rec.vmr_attribute18
345: ,p_vmr_attribute19_o =>ben_vmr_shd.g_old_rec.vmr_attribute19

Line 342: ,p_vmr_attribute16_o =>ben_vmr_shd.g_old_rec.vmr_attribute16

338: ,p_vmr_attribute12_o =>ben_vmr_shd.g_old_rec.vmr_attribute12
339: ,p_vmr_attribute13_o =>ben_vmr_shd.g_old_rec.vmr_attribute13
340: ,p_vmr_attribute14_o =>ben_vmr_shd.g_old_rec.vmr_attribute14
341: ,p_vmr_attribute15_o =>ben_vmr_shd.g_old_rec.vmr_attribute15
342: ,p_vmr_attribute16_o =>ben_vmr_shd.g_old_rec.vmr_attribute16
343: ,p_vmr_attribute17_o =>ben_vmr_shd.g_old_rec.vmr_attribute17
344: ,p_vmr_attribute18_o =>ben_vmr_shd.g_old_rec.vmr_attribute18
345: ,p_vmr_attribute19_o =>ben_vmr_shd.g_old_rec.vmr_attribute19
346: ,p_vmr_attribute20_o =>ben_vmr_shd.g_old_rec.vmr_attribute20

Line 343: ,p_vmr_attribute17_o =>ben_vmr_shd.g_old_rec.vmr_attribute17

339: ,p_vmr_attribute13_o =>ben_vmr_shd.g_old_rec.vmr_attribute13
340: ,p_vmr_attribute14_o =>ben_vmr_shd.g_old_rec.vmr_attribute14
341: ,p_vmr_attribute15_o =>ben_vmr_shd.g_old_rec.vmr_attribute15
342: ,p_vmr_attribute16_o =>ben_vmr_shd.g_old_rec.vmr_attribute16
343: ,p_vmr_attribute17_o =>ben_vmr_shd.g_old_rec.vmr_attribute17
344: ,p_vmr_attribute18_o =>ben_vmr_shd.g_old_rec.vmr_attribute18
345: ,p_vmr_attribute19_o =>ben_vmr_shd.g_old_rec.vmr_attribute19
346: ,p_vmr_attribute20_o =>ben_vmr_shd.g_old_rec.vmr_attribute20
347: ,p_vmr_attribute21_o =>ben_vmr_shd.g_old_rec.vmr_attribute21

Line 344: ,p_vmr_attribute18_o =>ben_vmr_shd.g_old_rec.vmr_attribute18

340: ,p_vmr_attribute14_o =>ben_vmr_shd.g_old_rec.vmr_attribute14
341: ,p_vmr_attribute15_o =>ben_vmr_shd.g_old_rec.vmr_attribute15
342: ,p_vmr_attribute16_o =>ben_vmr_shd.g_old_rec.vmr_attribute16
343: ,p_vmr_attribute17_o =>ben_vmr_shd.g_old_rec.vmr_attribute17
344: ,p_vmr_attribute18_o =>ben_vmr_shd.g_old_rec.vmr_attribute18
345: ,p_vmr_attribute19_o =>ben_vmr_shd.g_old_rec.vmr_attribute19
346: ,p_vmr_attribute20_o =>ben_vmr_shd.g_old_rec.vmr_attribute20
347: ,p_vmr_attribute21_o =>ben_vmr_shd.g_old_rec.vmr_attribute21
348: ,p_vmr_attribute22_o =>ben_vmr_shd.g_old_rec.vmr_attribute22

Line 345: ,p_vmr_attribute19_o =>ben_vmr_shd.g_old_rec.vmr_attribute19

341: ,p_vmr_attribute15_o =>ben_vmr_shd.g_old_rec.vmr_attribute15
342: ,p_vmr_attribute16_o =>ben_vmr_shd.g_old_rec.vmr_attribute16
343: ,p_vmr_attribute17_o =>ben_vmr_shd.g_old_rec.vmr_attribute17
344: ,p_vmr_attribute18_o =>ben_vmr_shd.g_old_rec.vmr_attribute18
345: ,p_vmr_attribute19_o =>ben_vmr_shd.g_old_rec.vmr_attribute19
346: ,p_vmr_attribute20_o =>ben_vmr_shd.g_old_rec.vmr_attribute20
347: ,p_vmr_attribute21_o =>ben_vmr_shd.g_old_rec.vmr_attribute21
348: ,p_vmr_attribute22_o =>ben_vmr_shd.g_old_rec.vmr_attribute22
349: ,p_vmr_attribute23_o =>ben_vmr_shd.g_old_rec.vmr_attribute23

Line 346: ,p_vmr_attribute20_o =>ben_vmr_shd.g_old_rec.vmr_attribute20

342: ,p_vmr_attribute16_o =>ben_vmr_shd.g_old_rec.vmr_attribute16
343: ,p_vmr_attribute17_o =>ben_vmr_shd.g_old_rec.vmr_attribute17
344: ,p_vmr_attribute18_o =>ben_vmr_shd.g_old_rec.vmr_attribute18
345: ,p_vmr_attribute19_o =>ben_vmr_shd.g_old_rec.vmr_attribute19
346: ,p_vmr_attribute20_o =>ben_vmr_shd.g_old_rec.vmr_attribute20
347: ,p_vmr_attribute21_o =>ben_vmr_shd.g_old_rec.vmr_attribute21
348: ,p_vmr_attribute22_o =>ben_vmr_shd.g_old_rec.vmr_attribute22
349: ,p_vmr_attribute23_o =>ben_vmr_shd.g_old_rec.vmr_attribute23
350: ,p_vmr_attribute24_o =>ben_vmr_shd.g_old_rec.vmr_attribute24

Line 347: ,p_vmr_attribute21_o =>ben_vmr_shd.g_old_rec.vmr_attribute21

343: ,p_vmr_attribute17_o =>ben_vmr_shd.g_old_rec.vmr_attribute17
344: ,p_vmr_attribute18_o =>ben_vmr_shd.g_old_rec.vmr_attribute18
345: ,p_vmr_attribute19_o =>ben_vmr_shd.g_old_rec.vmr_attribute19
346: ,p_vmr_attribute20_o =>ben_vmr_shd.g_old_rec.vmr_attribute20
347: ,p_vmr_attribute21_o =>ben_vmr_shd.g_old_rec.vmr_attribute21
348: ,p_vmr_attribute22_o =>ben_vmr_shd.g_old_rec.vmr_attribute22
349: ,p_vmr_attribute23_o =>ben_vmr_shd.g_old_rec.vmr_attribute23
350: ,p_vmr_attribute24_o =>ben_vmr_shd.g_old_rec.vmr_attribute24
351: ,p_vmr_attribute25_o =>ben_vmr_shd.g_old_rec.vmr_attribute25

Line 348: ,p_vmr_attribute22_o =>ben_vmr_shd.g_old_rec.vmr_attribute22

344: ,p_vmr_attribute18_o =>ben_vmr_shd.g_old_rec.vmr_attribute18
345: ,p_vmr_attribute19_o =>ben_vmr_shd.g_old_rec.vmr_attribute19
346: ,p_vmr_attribute20_o =>ben_vmr_shd.g_old_rec.vmr_attribute20
347: ,p_vmr_attribute21_o =>ben_vmr_shd.g_old_rec.vmr_attribute21
348: ,p_vmr_attribute22_o =>ben_vmr_shd.g_old_rec.vmr_attribute22
349: ,p_vmr_attribute23_o =>ben_vmr_shd.g_old_rec.vmr_attribute23
350: ,p_vmr_attribute24_o =>ben_vmr_shd.g_old_rec.vmr_attribute24
351: ,p_vmr_attribute25_o =>ben_vmr_shd.g_old_rec.vmr_attribute25
352: ,p_vmr_attribute26_o =>ben_vmr_shd.g_old_rec.vmr_attribute26

Line 349: ,p_vmr_attribute23_o =>ben_vmr_shd.g_old_rec.vmr_attribute23

345: ,p_vmr_attribute19_o =>ben_vmr_shd.g_old_rec.vmr_attribute19
346: ,p_vmr_attribute20_o =>ben_vmr_shd.g_old_rec.vmr_attribute20
347: ,p_vmr_attribute21_o =>ben_vmr_shd.g_old_rec.vmr_attribute21
348: ,p_vmr_attribute22_o =>ben_vmr_shd.g_old_rec.vmr_attribute22
349: ,p_vmr_attribute23_o =>ben_vmr_shd.g_old_rec.vmr_attribute23
350: ,p_vmr_attribute24_o =>ben_vmr_shd.g_old_rec.vmr_attribute24
351: ,p_vmr_attribute25_o =>ben_vmr_shd.g_old_rec.vmr_attribute25
352: ,p_vmr_attribute26_o =>ben_vmr_shd.g_old_rec.vmr_attribute26
353: ,p_vmr_attribute27_o =>ben_vmr_shd.g_old_rec.vmr_attribute27

Line 350: ,p_vmr_attribute24_o =>ben_vmr_shd.g_old_rec.vmr_attribute24

346: ,p_vmr_attribute20_o =>ben_vmr_shd.g_old_rec.vmr_attribute20
347: ,p_vmr_attribute21_o =>ben_vmr_shd.g_old_rec.vmr_attribute21
348: ,p_vmr_attribute22_o =>ben_vmr_shd.g_old_rec.vmr_attribute22
349: ,p_vmr_attribute23_o =>ben_vmr_shd.g_old_rec.vmr_attribute23
350: ,p_vmr_attribute24_o =>ben_vmr_shd.g_old_rec.vmr_attribute24
351: ,p_vmr_attribute25_o =>ben_vmr_shd.g_old_rec.vmr_attribute25
352: ,p_vmr_attribute26_o =>ben_vmr_shd.g_old_rec.vmr_attribute26
353: ,p_vmr_attribute27_o =>ben_vmr_shd.g_old_rec.vmr_attribute27
354: ,p_vmr_attribute28_o =>ben_vmr_shd.g_old_rec.vmr_attribute28

Line 351: ,p_vmr_attribute25_o =>ben_vmr_shd.g_old_rec.vmr_attribute25

347: ,p_vmr_attribute21_o =>ben_vmr_shd.g_old_rec.vmr_attribute21
348: ,p_vmr_attribute22_o =>ben_vmr_shd.g_old_rec.vmr_attribute22
349: ,p_vmr_attribute23_o =>ben_vmr_shd.g_old_rec.vmr_attribute23
350: ,p_vmr_attribute24_o =>ben_vmr_shd.g_old_rec.vmr_attribute24
351: ,p_vmr_attribute25_o =>ben_vmr_shd.g_old_rec.vmr_attribute25
352: ,p_vmr_attribute26_o =>ben_vmr_shd.g_old_rec.vmr_attribute26
353: ,p_vmr_attribute27_o =>ben_vmr_shd.g_old_rec.vmr_attribute27
354: ,p_vmr_attribute28_o =>ben_vmr_shd.g_old_rec.vmr_attribute28
355: ,p_vmr_attribute29_o =>ben_vmr_shd.g_old_rec.vmr_attribute29

Line 352: ,p_vmr_attribute26_o =>ben_vmr_shd.g_old_rec.vmr_attribute26

348: ,p_vmr_attribute22_o =>ben_vmr_shd.g_old_rec.vmr_attribute22
349: ,p_vmr_attribute23_o =>ben_vmr_shd.g_old_rec.vmr_attribute23
350: ,p_vmr_attribute24_o =>ben_vmr_shd.g_old_rec.vmr_attribute24
351: ,p_vmr_attribute25_o =>ben_vmr_shd.g_old_rec.vmr_attribute25
352: ,p_vmr_attribute26_o =>ben_vmr_shd.g_old_rec.vmr_attribute26
353: ,p_vmr_attribute27_o =>ben_vmr_shd.g_old_rec.vmr_attribute27
354: ,p_vmr_attribute28_o =>ben_vmr_shd.g_old_rec.vmr_attribute28
355: ,p_vmr_attribute29_o =>ben_vmr_shd.g_old_rec.vmr_attribute29
356: ,p_vmr_attribute30_o =>ben_vmr_shd.g_old_rec.vmr_attribute30

Line 353: ,p_vmr_attribute27_o =>ben_vmr_shd.g_old_rec.vmr_attribute27

349: ,p_vmr_attribute23_o =>ben_vmr_shd.g_old_rec.vmr_attribute23
350: ,p_vmr_attribute24_o =>ben_vmr_shd.g_old_rec.vmr_attribute24
351: ,p_vmr_attribute25_o =>ben_vmr_shd.g_old_rec.vmr_attribute25
352: ,p_vmr_attribute26_o =>ben_vmr_shd.g_old_rec.vmr_attribute26
353: ,p_vmr_attribute27_o =>ben_vmr_shd.g_old_rec.vmr_attribute27
354: ,p_vmr_attribute28_o =>ben_vmr_shd.g_old_rec.vmr_attribute28
355: ,p_vmr_attribute29_o =>ben_vmr_shd.g_old_rec.vmr_attribute29
356: ,p_vmr_attribute30_o =>ben_vmr_shd.g_old_rec.vmr_attribute30
357: ,p_object_version_number_o =>ben_vmr_shd.g_old_rec.object_version_number

Line 354: ,p_vmr_attribute28_o =>ben_vmr_shd.g_old_rec.vmr_attribute28

350: ,p_vmr_attribute24_o =>ben_vmr_shd.g_old_rec.vmr_attribute24
351: ,p_vmr_attribute25_o =>ben_vmr_shd.g_old_rec.vmr_attribute25
352: ,p_vmr_attribute26_o =>ben_vmr_shd.g_old_rec.vmr_attribute26
353: ,p_vmr_attribute27_o =>ben_vmr_shd.g_old_rec.vmr_attribute27
354: ,p_vmr_attribute28_o =>ben_vmr_shd.g_old_rec.vmr_attribute28
355: ,p_vmr_attribute29_o =>ben_vmr_shd.g_old_rec.vmr_attribute29
356: ,p_vmr_attribute30_o =>ben_vmr_shd.g_old_rec.vmr_attribute30
357: ,p_object_version_number_o =>ben_vmr_shd.g_old_rec.object_version_number
358: );

Line 355: ,p_vmr_attribute29_o =>ben_vmr_shd.g_old_rec.vmr_attribute29

351: ,p_vmr_attribute25_o =>ben_vmr_shd.g_old_rec.vmr_attribute25
352: ,p_vmr_attribute26_o =>ben_vmr_shd.g_old_rec.vmr_attribute26
353: ,p_vmr_attribute27_o =>ben_vmr_shd.g_old_rec.vmr_attribute27
354: ,p_vmr_attribute28_o =>ben_vmr_shd.g_old_rec.vmr_attribute28
355: ,p_vmr_attribute29_o =>ben_vmr_shd.g_old_rec.vmr_attribute29
356: ,p_vmr_attribute30_o =>ben_vmr_shd.g_old_rec.vmr_attribute30
357: ,p_object_version_number_o =>ben_vmr_shd.g_old_rec.object_version_number
358: );
359: --

Line 356: ,p_vmr_attribute30_o =>ben_vmr_shd.g_old_rec.vmr_attribute30

352: ,p_vmr_attribute26_o =>ben_vmr_shd.g_old_rec.vmr_attribute26
353: ,p_vmr_attribute27_o =>ben_vmr_shd.g_old_rec.vmr_attribute27
354: ,p_vmr_attribute28_o =>ben_vmr_shd.g_old_rec.vmr_attribute28
355: ,p_vmr_attribute29_o =>ben_vmr_shd.g_old_rec.vmr_attribute29
356: ,p_vmr_attribute30_o =>ben_vmr_shd.g_old_rec.vmr_attribute30
357: ,p_object_version_number_o =>ben_vmr_shd.g_old_rec.object_version_number
358: );
359: --
360: exception

Line 357: ,p_object_version_number_o =>ben_vmr_shd.g_old_rec.object_version_number

353: ,p_vmr_attribute27_o =>ben_vmr_shd.g_old_rec.vmr_attribute27
354: ,p_vmr_attribute28_o =>ben_vmr_shd.g_old_rec.vmr_attribute28
355: ,p_vmr_attribute29_o =>ben_vmr_shd.g_old_rec.vmr_attribute29
356: ,p_vmr_attribute30_o =>ben_vmr_shd.g_old_rec.vmr_attribute30
357: ,p_object_version_number_o =>ben_vmr_shd.g_old_rec.object_version_number
358: );
359: --
360: exception
361: --

Line 381: p_rec in out nocopy ben_vmr_shd.g_rec_type,

377: -- |---------------------------------< del >----------------------------------|
378: -- ----------------------------------------------------------------------------
379: Procedure del
380: (
381: p_rec in out nocopy ben_vmr_shd.g_rec_type,
382: p_effective_date in date,
383: p_datetrack_mode in varchar2
384: ) is
385: --

Line 399: ben_vmr_shd.lck

395: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
396: --
397: -- We must lock the row which we need to delete.
398: --
399: ben_vmr_shd.lck
400: (p_effective_date => p_effective_date,
401: p_datetrack_mode => p_datetrack_mode,
402: p_vrbl_mtchg_rt_id => p_rec.vrbl_mtchg_rt_id,
403: p_object_version_number => p_rec.object_version_number,

Line 457: l_rec ben_vmr_shd.g_rec_type;

453: p_effective_date in date,
454: p_datetrack_mode in varchar2
455: ) is
456: --
457: l_rec ben_vmr_shd.g_rec_type;
458: l_proc varchar2(72) := g_package||'del';
459: --
460: Begin
461: hr_utility.set_location('Entering:'||l_proc, 5);