54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy ben_vmr_shd.g_rec_type,
59: p_effective_date in date,
60: p_datetrack_mode in varchar2,
61: p_validation_start_date in date,
62: p_validation_end_date in date) is
77: (p_base_table_name => 'ben_vrbl_mtchg_rt_f',
78: p_base_key_column => 'vrbl_mtchg_rt_id',
79: p_base_key_value => p_rec.vrbl_mtchg_rt_id);
80: --
81: ben_vmr_shd.g_api_dml := true; -- Set the api dml status
82: --
83: -- Update the ben_vrbl_mtchg_rt_f Row
84: --
85: update ben_vrbl_mtchg_rt_f
135: where vrbl_mtchg_rt_id = p_rec.vrbl_mtchg_rt_id
136: and effective_start_date = p_validation_start_date
137: and effective_end_date = p_validation_end_date;
138: --
139: ben_vmr_shd.g_api_dml := false; -- Unset the api dml status
140: --
141: -- Set the effective start and end dates
142: --
143: p_rec.effective_start_date := p_validation_start_date;
147: hr_utility.set_location(' Leaving:'||l_proc, 15);
148: Exception
149: When hr_api.check_integrity_violated Then
150: -- A check constraint has been violated
151: ben_vmr_shd.g_api_dml := false; -- Unset the api dml status
152: ben_vmr_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When hr_api.unique_integrity_violated Then
155: -- Unique integrity has been violated
148: Exception
149: When hr_api.check_integrity_violated Then
150: -- A check constraint has been violated
151: ben_vmr_shd.g_api_dml := false; -- Unset the api dml status
152: ben_vmr_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When hr_api.unique_integrity_violated Then
155: -- Unique integrity has been violated
156: ben_vmr_shd.g_api_dml := false; -- Unset the api dml status
152: ben_vmr_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When hr_api.unique_integrity_violated Then
155: -- Unique integrity has been violated
156: ben_vmr_shd.g_api_dml := false; -- Unset the api dml status
157: ben_vmr_shd.constraint_error
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When Others Then
160: ben_vmr_shd.g_api_dml := false; -- Unset the api dml status
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When hr_api.unique_integrity_violated Then
155: -- Unique integrity has been violated
156: ben_vmr_shd.g_api_dml := false; -- Unset the api dml status
157: ben_vmr_shd.constraint_error
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When Others Then
160: ben_vmr_shd.g_api_dml := false; -- Unset the api dml status
161: Raise;
156: ben_vmr_shd.g_api_dml := false; -- Unset the api dml status
157: ben_vmr_shd.constraint_error
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When Others Then
160: ben_vmr_shd.g_api_dml := false; -- Unset the api dml status
161: Raise;
162: End dt_update_dml;
163: --
164: -- ----------------------------------------------------------------------------
192: --
193: -- {End Of Comments}
194: -- ----------------------------------------------------------------------------
195: Procedure update_dml
196: (p_rec in out nocopy ben_vmr_shd.g_rec_type,
197: p_effective_date in date,
198: p_datetrack_mode in varchar2,
199: p_validation_start_date in date,
200: p_validation_end_date in date) is
256: --
257: -- {End Of Comments}
258: -- ----------------------------------------------------------------------------
259: Procedure dt_pre_update
260: (p_rec in out nocopy ben_vmr_shd.g_rec_type,
261: p_effective_date in date,
262: p_datetrack_mode in varchar2,
263: p_validation_start_date in date,
264: p_validation_end_date in date) is
272: hr_utility.set_location(l_proc, 10);
273: --
274: -- Update the current effective end date
275: --
276: ben_vmr_shd.upd_effective_end_date
277: (p_effective_date => p_effective_date,
278: p_base_key_value => p_rec.vrbl_mtchg_rt_id,
279: p_new_effective_end_date => (p_validation_start_date - 1),
280: p_validation_start_date => p_validation_start_date,
341: --
342: -- {End Of Comments}
343: -- ----------------------------------------------------------------------------
344: Procedure pre_update
345: (p_rec in out nocopy ben_vmr_shd.g_rec_type,
346: p_effective_date in date,
347: p_datetrack_mode in varchar2,
348: p_validation_start_date in date,
349: p_validation_end_date in date) is
397: --
398: -- {End Of Comments}
399: -- ----------------------------------------------------------------------------
400: Procedure post_update
401: (p_rec in ben_vmr_shd.g_rec_type,
402: p_effective_date in date,
403: p_datetrack_mode in varchar2,
404: p_validation_start_date in date,
405: p_validation_end_date in date) is
469: ,p_effective_date =>p_effective_date
470: ,p_datetrack_mode =>p_datetrack_mode
471: ,p_validation_start_date =>p_validation_start_date
472: ,p_validation_end_date =>p_validation_end_date
473: ,p_effective_end_date_o =>ben_vmr_shd.g_old_rec.effective_end_date
474: ,p_effective_start_date_o =>ben_vmr_shd.g_old_rec.effective_start_date
475: ,p_no_mx_pct_of_py_num_flag_o =>ben_vmr_shd.g_old_rec.no_mx_pct_of_py_num_flag
476: ,p_to_pct_val_o =>ben_vmr_shd.g_old_rec.to_pct_val
477: ,p_no_mx_amt_of_py_num_flag_o =>ben_vmr_shd.g_old_rec.no_mx_amt_of_py_num_flag
470: ,p_datetrack_mode =>p_datetrack_mode
471: ,p_validation_start_date =>p_validation_start_date
472: ,p_validation_end_date =>p_validation_end_date
473: ,p_effective_end_date_o =>ben_vmr_shd.g_old_rec.effective_end_date
474: ,p_effective_start_date_o =>ben_vmr_shd.g_old_rec.effective_start_date
475: ,p_no_mx_pct_of_py_num_flag_o =>ben_vmr_shd.g_old_rec.no_mx_pct_of_py_num_flag
476: ,p_to_pct_val_o =>ben_vmr_shd.g_old_rec.to_pct_val
477: ,p_no_mx_amt_of_py_num_flag_o =>ben_vmr_shd.g_old_rec.no_mx_amt_of_py_num_flag
478: ,p_mx_pct_of_py_num_o =>ben_vmr_shd.g_old_rec.mx_pct_of_py_num
471: ,p_validation_start_date =>p_validation_start_date
472: ,p_validation_end_date =>p_validation_end_date
473: ,p_effective_end_date_o =>ben_vmr_shd.g_old_rec.effective_end_date
474: ,p_effective_start_date_o =>ben_vmr_shd.g_old_rec.effective_start_date
475: ,p_no_mx_pct_of_py_num_flag_o =>ben_vmr_shd.g_old_rec.no_mx_pct_of_py_num_flag
476: ,p_to_pct_val_o =>ben_vmr_shd.g_old_rec.to_pct_val
477: ,p_no_mx_amt_of_py_num_flag_o =>ben_vmr_shd.g_old_rec.no_mx_amt_of_py_num_flag
478: ,p_mx_pct_of_py_num_o =>ben_vmr_shd.g_old_rec.mx_pct_of_py_num
479: ,p_no_mx_mtch_amt_flag_o =>ben_vmr_shd.g_old_rec.no_mx_mtch_amt_flag
472: ,p_validation_end_date =>p_validation_end_date
473: ,p_effective_end_date_o =>ben_vmr_shd.g_old_rec.effective_end_date
474: ,p_effective_start_date_o =>ben_vmr_shd.g_old_rec.effective_start_date
475: ,p_no_mx_pct_of_py_num_flag_o =>ben_vmr_shd.g_old_rec.no_mx_pct_of_py_num_flag
476: ,p_to_pct_val_o =>ben_vmr_shd.g_old_rec.to_pct_val
477: ,p_no_mx_amt_of_py_num_flag_o =>ben_vmr_shd.g_old_rec.no_mx_amt_of_py_num_flag
478: ,p_mx_pct_of_py_num_o =>ben_vmr_shd.g_old_rec.mx_pct_of_py_num
479: ,p_no_mx_mtch_amt_flag_o =>ben_vmr_shd.g_old_rec.no_mx_mtch_amt_flag
480: ,p_ordr_num_o =>ben_vmr_shd.g_old_rec.ordr_num
473: ,p_effective_end_date_o =>ben_vmr_shd.g_old_rec.effective_end_date
474: ,p_effective_start_date_o =>ben_vmr_shd.g_old_rec.effective_start_date
475: ,p_no_mx_pct_of_py_num_flag_o =>ben_vmr_shd.g_old_rec.no_mx_pct_of_py_num_flag
476: ,p_to_pct_val_o =>ben_vmr_shd.g_old_rec.to_pct_val
477: ,p_no_mx_amt_of_py_num_flag_o =>ben_vmr_shd.g_old_rec.no_mx_amt_of_py_num_flag
478: ,p_mx_pct_of_py_num_o =>ben_vmr_shd.g_old_rec.mx_pct_of_py_num
479: ,p_no_mx_mtch_amt_flag_o =>ben_vmr_shd.g_old_rec.no_mx_mtch_amt_flag
480: ,p_ordr_num_o =>ben_vmr_shd.g_old_rec.ordr_num
481: ,p_pct_val_o =>ben_vmr_shd.g_old_rec.pct_val
474: ,p_effective_start_date_o =>ben_vmr_shd.g_old_rec.effective_start_date
475: ,p_no_mx_pct_of_py_num_flag_o =>ben_vmr_shd.g_old_rec.no_mx_pct_of_py_num_flag
476: ,p_to_pct_val_o =>ben_vmr_shd.g_old_rec.to_pct_val
477: ,p_no_mx_amt_of_py_num_flag_o =>ben_vmr_shd.g_old_rec.no_mx_amt_of_py_num_flag
478: ,p_mx_pct_of_py_num_o =>ben_vmr_shd.g_old_rec.mx_pct_of_py_num
479: ,p_no_mx_mtch_amt_flag_o =>ben_vmr_shd.g_old_rec.no_mx_mtch_amt_flag
480: ,p_ordr_num_o =>ben_vmr_shd.g_old_rec.ordr_num
481: ,p_pct_val_o =>ben_vmr_shd.g_old_rec.pct_val
482: ,p_mx_mtch_amt_o =>ben_vmr_shd.g_old_rec.mx_mtch_amt
475: ,p_no_mx_pct_of_py_num_flag_o =>ben_vmr_shd.g_old_rec.no_mx_pct_of_py_num_flag
476: ,p_to_pct_val_o =>ben_vmr_shd.g_old_rec.to_pct_val
477: ,p_no_mx_amt_of_py_num_flag_o =>ben_vmr_shd.g_old_rec.no_mx_amt_of_py_num_flag
478: ,p_mx_pct_of_py_num_o =>ben_vmr_shd.g_old_rec.mx_pct_of_py_num
479: ,p_no_mx_mtch_amt_flag_o =>ben_vmr_shd.g_old_rec.no_mx_mtch_amt_flag
480: ,p_ordr_num_o =>ben_vmr_shd.g_old_rec.ordr_num
481: ,p_pct_val_o =>ben_vmr_shd.g_old_rec.pct_val
482: ,p_mx_mtch_amt_o =>ben_vmr_shd.g_old_rec.mx_mtch_amt
483: ,p_mx_amt_of_py_num_o =>ben_vmr_shd.g_old_rec.mx_amt_of_py_num
476: ,p_to_pct_val_o =>ben_vmr_shd.g_old_rec.to_pct_val
477: ,p_no_mx_amt_of_py_num_flag_o =>ben_vmr_shd.g_old_rec.no_mx_amt_of_py_num_flag
478: ,p_mx_pct_of_py_num_o =>ben_vmr_shd.g_old_rec.mx_pct_of_py_num
479: ,p_no_mx_mtch_amt_flag_o =>ben_vmr_shd.g_old_rec.no_mx_mtch_amt_flag
480: ,p_ordr_num_o =>ben_vmr_shd.g_old_rec.ordr_num
481: ,p_pct_val_o =>ben_vmr_shd.g_old_rec.pct_val
482: ,p_mx_mtch_amt_o =>ben_vmr_shd.g_old_rec.mx_mtch_amt
483: ,p_mx_amt_of_py_num_o =>ben_vmr_shd.g_old_rec.mx_amt_of_py_num
484: ,p_mn_mtch_amt_o =>ben_vmr_shd.g_old_rec.mn_mtch_amt
477: ,p_no_mx_amt_of_py_num_flag_o =>ben_vmr_shd.g_old_rec.no_mx_amt_of_py_num_flag
478: ,p_mx_pct_of_py_num_o =>ben_vmr_shd.g_old_rec.mx_pct_of_py_num
479: ,p_no_mx_mtch_amt_flag_o =>ben_vmr_shd.g_old_rec.no_mx_mtch_amt_flag
480: ,p_ordr_num_o =>ben_vmr_shd.g_old_rec.ordr_num
481: ,p_pct_val_o =>ben_vmr_shd.g_old_rec.pct_val
482: ,p_mx_mtch_amt_o =>ben_vmr_shd.g_old_rec.mx_mtch_amt
483: ,p_mx_amt_of_py_num_o =>ben_vmr_shd.g_old_rec.mx_amt_of_py_num
484: ,p_mn_mtch_amt_o =>ben_vmr_shd.g_old_rec.mn_mtch_amt
485: ,p_mtchg_rt_calc_rl_o =>ben_vmr_shd.g_old_rec.mtchg_rt_calc_rl
478: ,p_mx_pct_of_py_num_o =>ben_vmr_shd.g_old_rec.mx_pct_of_py_num
479: ,p_no_mx_mtch_amt_flag_o =>ben_vmr_shd.g_old_rec.no_mx_mtch_amt_flag
480: ,p_ordr_num_o =>ben_vmr_shd.g_old_rec.ordr_num
481: ,p_pct_val_o =>ben_vmr_shd.g_old_rec.pct_val
482: ,p_mx_mtch_amt_o =>ben_vmr_shd.g_old_rec.mx_mtch_amt
483: ,p_mx_amt_of_py_num_o =>ben_vmr_shd.g_old_rec.mx_amt_of_py_num
484: ,p_mn_mtch_amt_o =>ben_vmr_shd.g_old_rec.mn_mtch_amt
485: ,p_mtchg_rt_calc_rl_o =>ben_vmr_shd.g_old_rec.mtchg_rt_calc_rl
486: ,p_cntnu_mtch_aftr_max_rl_fla_o =>ben_vmr_shd.g_old_rec.cntnu_mtch_aftr_max_rl_flag
479: ,p_no_mx_mtch_amt_flag_o =>ben_vmr_shd.g_old_rec.no_mx_mtch_amt_flag
480: ,p_ordr_num_o =>ben_vmr_shd.g_old_rec.ordr_num
481: ,p_pct_val_o =>ben_vmr_shd.g_old_rec.pct_val
482: ,p_mx_mtch_amt_o =>ben_vmr_shd.g_old_rec.mx_mtch_amt
483: ,p_mx_amt_of_py_num_o =>ben_vmr_shd.g_old_rec.mx_amt_of_py_num
484: ,p_mn_mtch_amt_o =>ben_vmr_shd.g_old_rec.mn_mtch_amt
485: ,p_mtchg_rt_calc_rl_o =>ben_vmr_shd.g_old_rec.mtchg_rt_calc_rl
486: ,p_cntnu_mtch_aftr_max_rl_fla_o =>ben_vmr_shd.g_old_rec.cntnu_mtch_aftr_max_rl_flag
487: ,p_from_pct_val_o =>ben_vmr_shd.g_old_rec.from_pct_val
480: ,p_ordr_num_o =>ben_vmr_shd.g_old_rec.ordr_num
481: ,p_pct_val_o =>ben_vmr_shd.g_old_rec.pct_val
482: ,p_mx_mtch_amt_o =>ben_vmr_shd.g_old_rec.mx_mtch_amt
483: ,p_mx_amt_of_py_num_o =>ben_vmr_shd.g_old_rec.mx_amt_of_py_num
484: ,p_mn_mtch_amt_o =>ben_vmr_shd.g_old_rec.mn_mtch_amt
485: ,p_mtchg_rt_calc_rl_o =>ben_vmr_shd.g_old_rec.mtchg_rt_calc_rl
486: ,p_cntnu_mtch_aftr_max_rl_fla_o =>ben_vmr_shd.g_old_rec.cntnu_mtch_aftr_max_rl_flag
487: ,p_from_pct_val_o =>ben_vmr_shd.g_old_rec.from_pct_val
488: ,p_vrbl_rt_prfl_id_o =>ben_vmr_shd.g_old_rec.vrbl_rt_prfl_id
481: ,p_pct_val_o =>ben_vmr_shd.g_old_rec.pct_val
482: ,p_mx_mtch_amt_o =>ben_vmr_shd.g_old_rec.mx_mtch_amt
483: ,p_mx_amt_of_py_num_o =>ben_vmr_shd.g_old_rec.mx_amt_of_py_num
484: ,p_mn_mtch_amt_o =>ben_vmr_shd.g_old_rec.mn_mtch_amt
485: ,p_mtchg_rt_calc_rl_o =>ben_vmr_shd.g_old_rec.mtchg_rt_calc_rl
486: ,p_cntnu_mtch_aftr_max_rl_fla_o =>ben_vmr_shd.g_old_rec.cntnu_mtch_aftr_max_rl_flag
487: ,p_from_pct_val_o =>ben_vmr_shd.g_old_rec.from_pct_val
488: ,p_vrbl_rt_prfl_id_o =>ben_vmr_shd.g_old_rec.vrbl_rt_prfl_id
489: ,p_business_group_id_o =>ben_vmr_shd.g_old_rec.business_group_id
482: ,p_mx_mtch_amt_o =>ben_vmr_shd.g_old_rec.mx_mtch_amt
483: ,p_mx_amt_of_py_num_o =>ben_vmr_shd.g_old_rec.mx_amt_of_py_num
484: ,p_mn_mtch_amt_o =>ben_vmr_shd.g_old_rec.mn_mtch_amt
485: ,p_mtchg_rt_calc_rl_o =>ben_vmr_shd.g_old_rec.mtchg_rt_calc_rl
486: ,p_cntnu_mtch_aftr_max_rl_fla_o =>ben_vmr_shd.g_old_rec.cntnu_mtch_aftr_max_rl_flag
487: ,p_from_pct_val_o =>ben_vmr_shd.g_old_rec.from_pct_val
488: ,p_vrbl_rt_prfl_id_o =>ben_vmr_shd.g_old_rec.vrbl_rt_prfl_id
489: ,p_business_group_id_o =>ben_vmr_shd.g_old_rec.business_group_id
490: ,p_vmr_attribute_category_o =>ben_vmr_shd.g_old_rec.vmr_attribute_category
483: ,p_mx_amt_of_py_num_o =>ben_vmr_shd.g_old_rec.mx_amt_of_py_num
484: ,p_mn_mtch_amt_o =>ben_vmr_shd.g_old_rec.mn_mtch_amt
485: ,p_mtchg_rt_calc_rl_o =>ben_vmr_shd.g_old_rec.mtchg_rt_calc_rl
486: ,p_cntnu_mtch_aftr_max_rl_fla_o =>ben_vmr_shd.g_old_rec.cntnu_mtch_aftr_max_rl_flag
487: ,p_from_pct_val_o =>ben_vmr_shd.g_old_rec.from_pct_val
488: ,p_vrbl_rt_prfl_id_o =>ben_vmr_shd.g_old_rec.vrbl_rt_prfl_id
489: ,p_business_group_id_o =>ben_vmr_shd.g_old_rec.business_group_id
490: ,p_vmr_attribute_category_o =>ben_vmr_shd.g_old_rec.vmr_attribute_category
491: ,p_vmr_attribute1_o =>ben_vmr_shd.g_old_rec.vmr_attribute1
484: ,p_mn_mtch_amt_o =>ben_vmr_shd.g_old_rec.mn_mtch_amt
485: ,p_mtchg_rt_calc_rl_o =>ben_vmr_shd.g_old_rec.mtchg_rt_calc_rl
486: ,p_cntnu_mtch_aftr_max_rl_fla_o =>ben_vmr_shd.g_old_rec.cntnu_mtch_aftr_max_rl_flag
487: ,p_from_pct_val_o =>ben_vmr_shd.g_old_rec.from_pct_val
488: ,p_vrbl_rt_prfl_id_o =>ben_vmr_shd.g_old_rec.vrbl_rt_prfl_id
489: ,p_business_group_id_o =>ben_vmr_shd.g_old_rec.business_group_id
490: ,p_vmr_attribute_category_o =>ben_vmr_shd.g_old_rec.vmr_attribute_category
491: ,p_vmr_attribute1_o =>ben_vmr_shd.g_old_rec.vmr_attribute1
492: ,p_vmr_attribute2_o =>ben_vmr_shd.g_old_rec.vmr_attribute2
485: ,p_mtchg_rt_calc_rl_o =>ben_vmr_shd.g_old_rec.mtchg_rt_calc_rl
486: ,p_cntnu_mtch_aftr_max_rl_fla_o =>ben_vmr_shd.g_old_rec.cntnu_mtch_aftr_max_rl_flag
487: ,p_from_pct_val_o =>ben_vmr_shd.g_old_rec.from_pct_val
488: ,p_vrbl_rt_prfl_id_o =>ben_vmr_shd.g_old_rec.vrbl_rt_prfl_id
489: ,p_business_group_id_o =>ben_vmr_shd.g_old_rec.business_group_id
490: ,p_vmr_attribute_category_o =>ben_vmr_shd.g_old_rec.vmr_attribute_category
491: ,p_vmr_attribute1_o =>ben_vmr_shd.g_old_rec.vmr_attribute1
492: ,p_vmr_attribute2_o =>ben_vmr_shd.g_old_rec.vmr_attribute2
493: ,p_vmr_attribute3_o =>ben_vmr_shd.g_old_rec.vmr_attribute3
486: ,p_cntnu_mtch_aftr_max_rl_fla_o =>ben_vmr_shd.g_old_rec.cntnu_mtch_aftr_max_rl_flag
487: ,p_from_pct_val_o =>ben_vmr_shd.g_old_rec.from_pct_val
488: ,p_vrbl_rt_prfl_id_o =>ben_vmr_shd.g_old_rec.vrbl_rt_prfl_id
489: ,p_business_group_id_o =>ben_vmr_shd.g_old_rec.business_group_id
490: ,p_vmr_attribute_category_o =>ben_vmr_shd.g_old_rec.vmr_attribute_category
491: ,p_vmr_attribute1_o =>ben_vmr_shd.g_old_rec.vmr_attribute1
492: ,p_vmr_attribute2_o =>ben_vmr_shd.g_old_rec.vmr_attribute2
493: ,p_vmr_attribute3_o =>ben_vmr_shd.g_old_rec.vmr_attribute3
494: ,p_vmr_attribute4_o =>ben_vmr_shd.g_old_rec.vmr_attribute4
487: ,p_from_pct_val_o =>ben_vmr_shd.g_old_rec.from_pct_val
488: ,p_vrbl_rt_prfl_id_o =>ben_vmr_shd.g_old_rec.vrbl_rt_prfl_id
489: ,p_business_group_id_o =>ben_vmr_shd.g_old_rec.business_group_id
490: ,p_vmr_attribute_category_o =>ben_vmr_shd.g_old_rec.vmr_attribute_category
491: ,p_vmr_attribute1_o =>ben_vmr_shd.g_old_rec.vmr_attribute1
492: ,p_vmr_attribute2_o =>ben_vmr_shd.g_old_rec.vmr_attribute2
493: ,p_vmr_attribute3_o =>ben_vmr_shd.g_old_rec.vmr_attribute3
494: ,p_vmr_attribute4_o =>ben_vmr_shd.g_old_rec.vmr_attribute4
495: ,p_vmr_attribute5_o =>ben_vmr_shd.g_old_rec.vmr_attribute5
488: ,p_vrbl_rt_prfl_id_o =>ben_vmr_shd.g_old_rec.vrbl_rt_prfl_id
489: ,p_business_group_id_o =>ben_vmr_shd.g_old_rec.business_group_id
490: ,p_vmr_attribute_category_o =>ben_vmr_shd.g_old_rec.vmr_attribute_category
491: ,p_vmr_attribute1_o =>ben_vmr_shd.g_old_rec.vmr_attribute1
492: ,p_vmr_attribute2_o =>ben_vmr_shd.g_old_rec.vmr_attribute2
493: ,p_vmr_attribute3_o =>ben_vmr_shd.g_old_rec.vmr_attribute3
494: ,p_vmr_attribute4_o =>ben_vmr_shd.g_old_rec.vmr_attribute4
495: ,p_vmr_attribute5_o =>ben_vmr_shd.g_old_rec.vmr_attribute5
496: ,p_vmr_attribute6_o =>ben_vmr_shd.g_old_rec.vmr_attribute6
489: ,p_business_group_id_o =>ben_vmr_shd.g_old_rec.business_group_id
490: ,p_vmr_attribute_category_o =>ben_vmr_shd.g_old_rec.vmr_attribute_category
491: ,p_vmr_attribute1_o =>ben_vmr_shd.g_old_rec.vmr_attribute1
492: ,p_vmr_attribute2_o =>ben_vmr_shd.g_old_rec.vmr_attribute2
493: ,p_vmr_attribute3_o =>ben_vmr_shd.g_old_rec.vmr_attribute3
494: ,p_vmr_attribute4_o =>ben_vmr_shd.g_old_rec.vmr_attribute4
495: ,p_vmr_attribute5_o =>ben_vmr_shd.g_old_rec.vmr_attribute5
496: ,p_vmr_attribute6_o =>ben_vmr_shd.g_old_rec.vmr_attribute6
497: ,p_vmr_attribute7_o =>ben_vmr_shd.g_old_rec.vmr_attribute7
490: ,p_vmr_attribute_category_o =>ben_vmr_shd.g_old_rec.vmr_attribute_category
491: ,p_vmr_attribute1_o =>ben_vmr_shd.g_old_rec.vmr_attribute1
492: ,p_vmr_attribute2_o =>ben_vmr_shd.g_old_rec.vmr_attribute2
493: ,p_vmr_attribute3_o =>ben_vmr_shd.g_old_rec.vmr_attribute3
494: ,p_vmr_attribute4_o =>ben_vmr_shd.g_old_rec.vmr_attribute4
495: ,p_vmr_attribute5_o =>ben_vmr_shd.g_old_rec.vmr_attribute5
496: ,p_vmr_attribute6_o =>ben_vmr_shd.g_old_rec.vmr_attribute6
497: ,p_vmr_attribute7_o =>ben_vmr_shd.g_old_rec.vmr_attribute7
498: ,p_vmr_attribute8_o =>ben_vmr_shd.g_old_rec.vmr_attribute8
491: ,p_vmr_attribute1_o =>ben_vmr_shd.g_old_rec.vmr_attribute1
492: ,p_vmr_attribute2_o =>ben_vmr_shd.g_old_rec.vmr_attribute2
493: ,p_vmr_attribute3_o =>ben_vmr_shd.g_old_rec.vmr_attribute3
494: ,p_vmr_attribute4_o =>ben_vmr_shd.g_old_rec.vmr_attribute4
495: ,p_vmr_attribute5_o =>ben_vmr_shd.g_old_rec.vmr_attribute5
496: ,p_vmr_attribute6_o =>ben_vmr_shd.g_old_rec.vmr_attribute6
497: ,p_vmr_attribute7_o =>ben_vmr_shd.g_old_rec.vmr_attribute7
498: ,p_vmr_attribute8_o =>ben_vmr_shd.g_old_rec.vmr_attribute8
499: ,p_vmr_attribute9_o =>ben_vmr_shd.g_old_rec.vmr_attribute9
492: ,p_vmr_attribute2_o =>ben_vmr_shd.g_old_rec.vmr_attribute2
493: ,p_vmr_attribute3_o =>ben_vmr_shd.g_old_rec.vmr_attribute3
494: ,p_vmr_attribute4_o =>ben_vmr_shd.g_old_rec.vmr_attribute4
495: ,p_vmr_attribute5_o =>ben_vmr_shd.g_old_rec.vmr_attribute5
496: ,p_vmr_attribute6_o =>ben_vmr_shd.g_old_rec.vmr_attribute6
497: ,p_vmr_attribute7_o =>ben_vmr_shd.g_old_rec.vmr_attribute7
498: ,p_vmr_attribute8_o =>ben_vmr_shd.g_old_rec.vmr_attribute8
499: ,p_vmr_attribute9_o =>ben_vmr_shd.g_old_rec.vmr_attribute9
500: ,p_vmr_attribute10_o =>ben_vmr_shd.g_old_rec.vmr_attribute10
493: ,p_vmr_attribute3_o =>ben_vmr_shd.g_old_rec.vmr_attribute3
494: ,p_vmr_attribute4_o =>ben_vmr_shd.g_old_rec.vmr_attribute4
495: ,p_vmr_attribute5_o =>ben_vmr_shd.g_old_rec.vmr_attribute5
496: ,p_vmr_attribute6_o =>ben_vmr_shd.g_old_rec.vmr_attribute6
497: ,p_vmr_attribute7_o =>ben_vmr_shd.g_old_rec.vmr_attribute7
498: ,p_vmr_attribute8_o =>ben_vmr_shd.g_old_rec.vmr_attribute8
499: ,p_vmr_attribute9_o =>ben_vmr_shd.g_old_rec.vmr_attribute9
500: ,p_vmr_attribute10_o =>ben_vmr_shd.g_old_rec.vmr_attribute10
501: ,p_vmr_attribute11_o =>ben_vmr_shd.g_old_rec.vmr_attribute11
494: ,p_vmr_attribute4_o =>ben_vmr_shd.g_old_rec.vmr_attribute4
495: ,p_vmr_attribute5_o =>ben_vmr_shd.g_old_rec.vmr_attribute5
496: ,p_vmr_attribute6_o =>ben_vmr_shd.g_old_rec.vmr_attribute6
497: ,p_vmr_attribute7_o =>ben_vmr_shd.g_old_rec.vmr_attribute7
498: ,p_vmr_attribute8_o =>ben_vmr_shd.g_old_rec.vmr_attribute8
499: ,p_vmr_attribute9_o =>ben_vmr_shd.g_old_rec.vmr_attribute9
500: ,p_vmr_attribute10_o =>ben_vmr_shd.g_old_rec.vmr_attribute10
501: ,p_vmr_attribute11_o =>ben_vmr_shd.g_old_rec.vmr_attribute11
502: ,p_vmr_attribute12_o =>ben_vmr_shd.g_old_rec.vmr_attribute12
495: ,p_vmr_attribute5_o =>ben_vmr_shd.g_old_rec.vmr_attribute5
496: ,p_vmr_attribute6_o =>ben_vmr_shd.g_old_rec.vmr_attribute6
497: ,p_vmr_attribute7_o =>ben_vmr_shd.g_old_rec.vmr_attribute7
498: ,p_vmr_attribute8_o =>ben_vmr_shd.g_old_rec.vmr_attribute8
499: ,p_vmr_attribute9_o =>ben_vmr_shd.g_old_rec.vmr_attribute9
500: ,p_vmr_attribute10_o =>ben_vmr_shd.g_old_rec.vmr_attribute10
501: ,p_vmr_attribute11_o =>ben_vmr_shd.g_old_rec.vmr_attribute11
502: ,p_vmr_attribute12_o =>ben_vmr_shd.g_old_rec.vmr_attribute12
503: ,p_vmr_attribute13_o =>ben_vmr_shd.g_old_rec.vmr_attribute13
496: ,p_vmr_attribute6_o =>ben_vmr_shd.g_old_rec.vmr_attribute6
497: ,p_vmr_attribute7_o =>ben_vmr_shd.g_old_rec.vmr_attribute7
498: ,p_vmr_attribute8_o =>ben_vmr_shd.g_old_rec.vmr_attribute8
499: ,p_vmr_attribute9_o =>ben_vmr_shd.g_old_rec.vmr_attribute9
500: ,p_vmr_attribute10_o =>ben_vmr_shd.g_old_rec.vmr_attribute10
501: ,p_vmr_attribute11_o =>ben_vmr_shd.g_old_rec.vmr_attribute11
502: ,p_vmr_attribute12_o =>ben_vmr_shd.g_old_rec.vmr_attribute12
503: ,p_vmr_attribute13_o =>ben_vmr_shd.g_old_rec.vmr_attribute13
504: ,p_vmr_attribute14_o =>ben_vmr_shd.g_old_rec.vmr_attribute14
497: ,p_vmr_attribute7_o =>ben_vmr_shd.g_old_rec.vmr_attribute7
498: ,p_vmr_attribute8_o =>ben_vmr_shd.g_old_rec.vmr_attribute8
499: ,p_vmr_attribute9_o =>ben_vmr_shd.g_old_rec.vmr_attribute9
500: ,p_vmr_attribute10_o =>ben_vmr_shd.g_old_rec.vmr_attribute10
501: ,p_vmr_attribute11_o =>ben_vmr_shd.g_old_rec.vmr_attribute11
502: ,p_vmr_attribute12_o =>ben_vmr_shd.g_old_rec.vmr_attribute12
503: ,p_vmr_attribute13_o =>ben_vmr_shd.g_old_rec.vmr_attribute13
504: ,p_vmr_attribute14_o =>ben_vmr_shd.g_old_rec.vmr_attribute14
505: ,p_vmr_attribute15_o =>ben_vmr_shd.g_old_rec.vmr_attribute15
498: ,p_vmr_attribute8_o =>ben_vmr_shd.g_old_rec.vmr_attribute8
499: ,p_vmr_attribute9_o =>ben_vmr_shd.g_old_rec.vmr_attribute9
500: ,p_vmr_attribute10_o =>ben_vmr_shd.g_old_rec.vmr_attribute10
501: ,p_vmr_attribute11_o =>ben_vmr_shd.g_old_rec.vmr_attribute11
502: ,p_vmr_attribute12_o =>ben_vmr_shd.g_old_rec.vmr_attribute12
503: ,p_vmr_attribute13_o =>ben_vmr_shd.g_old_rec.vmr_attribute13
504: ,p_vmr_attribute14_o =>ben_vmr_shd.g_old_rec.vmr_attribute14
505: ,p_vmr_attribute15_o =>ben_vmr_shd.g_old_rec.vmr_attribute15
506: ,p_vmr_attribute16_o =>ben_vmr_shd.g_old_rec.vmr_attribute16
499: ,p_vmr_attribute9_o =>ben_vmr_shd.g_old_rec.vmr_attribute9
500: ,p_vmr_attribute10_o =>ben_vmr_shd.g_old_rec.vmr_attribute10
501: ,p_vmr_attribute11_o =>ben_vmr_shd.g_old_rec.vmr_attribute11
502: ,p_vmr_attribute12_o =>ben_vmr_shd.g_old_rec.vmr_attribute12
503: ,p_vmr_attribute13_o =>ben_vmr_shd.g_old_rec.vmr_attribute13
504: ,p_vmr_attribute14_o =>ben_vmr_shd.g_old_rec.vmr_attribute14
505: ,p_vmr_attribute15_o =>ben_vmr_shd.g_old_rec.vmr_attribute15
506: ,p_vmr_attribute16_o =>ben_vmr_shd.g_old_rec.vmr_attribute16
507: ,p_vmr_attribute17_o =>ben_vmr_shd.g_old_rec.vmr_attribute17
500: ,p_vmr_attribute10_o =>ben_vmr_shd.g_old_rec.vmr_attribute10
501: ,p_vmr_attribute11_o =>ben_vmr_shd.g_old_rec.vmr_attribute11
502: ,p_vmr_attribute12_o =>ben_vmr_shd.g_old_rec.vmr_attribute12
503: ,p_vmr_attribute13_o =>ben_vmr_shd.g_old_rec.vmr_attribute13
504: ,p_vmr_attribute14_o =>ben_vmr_shd.g_old_rec.vmr_attribute14
505: ,p_vmr_attribute15_o =>ben_vmr_shd.g_old_rec.vmr_attribute15
506: ,p_vmr_attribute16_o =>ben_vmr_shd.g_old_rec.vmr_attribute16
507: ,p_vmr_attribute17_o =>ben_vmr_shd.g_old_rec.vmr_attribute17
508: ,p_vmr_attribute18_o =>ben_vmr_shd.g_old_rec.vmr_attribute18
501: ,p_vmr_attribute11_o =>ben_vmr_shd.g_old_rec.vmr_attribute11
502: ,p_vmr_attribute12_o =>ben_vmr_shd.g_old_rec.vmr_attribute12
503: ,p_vmr_attribute13_o =>ben_vmr_shd.g_old_rec.vmr_attribute13
504: ,p_vmr_attribute14_o =>ben_vmr_shd.g_old_rec.vmr_attribute14
505: ,p_vmr_attribute15_o =>ben_vmr_shd.g_old_rec.vmr_attribute15
506: ,p_vmr_attribute16_o =>ben_vmr_shd.g_old_rec.vmr_attribute16
507: ,p_vmr_attribute17_o =>ben_vmr_shd.g_old_rec.vmr_attribute17
508: ,p_vmr_attribute18_o =>ben_vmr_shd.g_old_rec.vmr_attribute18
509: ,p_vmr_attribute19_o =>ben_vmr_shd.g_old_rec.vmr_attribute19
502: ,p_vmr_attribute12_o =>ben_vmr_shd.g_old_rec.vmr_attribute12
503: ,p_vmr_attribute13_o =>ben_vmr_shd.g_old_rec.vmr_attribute13
504: ,p_vmr_attribute14_o =>ben_vmr_shd.g_old_rec.vmr_attribute14
505: ,p_vmr_attribute15_o =>ben_vmr_shd.g_old_rec.vmr_attribute15
506: ,p_vmr_attribute16_o =>ben_vmr_shd.g_old_rec.vmr_attribute16
507: ,p_vmr_attribute17_o =>ben_vmr_shd.g_old_rec.vmr_attribute17
508: ,p_vmr_attribute18_o =>ben_vmr_shd.g_old_rec.vmr_attribute18
509: ,p_vmr_attribute19_o =>ben_vmr_shd.g_old_rec.vmr_attribute19
510: ,p_vmr_attribute20_o =>ben_vmr_shd.g_old_rec.vmr_attribute20
503: ,p_vmr_attribute13_o =>ben_vmr_shd.g_old_rec.vmr_attribute13
504: ,p_vmr_attribute14_o =>ben_vmr_shd.g_old_rec.vmr_attribute14
505: ,p_vmr_attribute15_o =>ben_vmr_shd.g_old_rec.vmr_attribute15
506: ,p_vmr_attribute16_o =>ben_vmr_shd.g_old_rec.vmr_attribute16
507: ,p_vmr_attribute17_o =>ben_vmr_shd.g_old_rec.vmr_attribute17
508: ,p_vmr_attribute18_o =>ben_vmr_shd.g_old_rec.vmr_attribute18
509: ,p_vmr_attribute19_o =>ben_vmr_shd.g_old_rec.vmr_attribute19
510: ,p_vmr_attribute20_o =>ben_vmr_shd.g_old_rec.vmr_attribute20
511: ,p_vmr_attribute21_o =>ben_vmr_shd.g_old_rec.vmr_attribute21
504: ,p_vmr_attribute14_o =>ben_vmr_shd.g_old_rec.vmr_attribute14
505: ,p_vmr_attribute15_o =>ben_vmr_shd.g_old_rec.vmr_attribute15
506: ,p_vmr_attribute16_o =>ben_vmr_shd.g_old_rec.vmr_attribute16
507: ,p_vmr_attribute17_o =>ben_vmr_shd.g_old_rec.vmr_attribute17
508: ,p_vmr_attribute18_o =>ben_vmr_shd.g_old_rec.vmr_attribute18
509: ,p_vmr_attribute19_o =>ben_vmr_shd.g_old_rec.vmr_attribute19
510: ,p_vmr_attribute20_o =>ben_vmr_shd.g_old_rec.vmr_attribute20
511: ,p_vmr_attribute21_o =>ben_vmr_shd.g_old_rec.vmr_attribute21
512: ,p_vmr_attribute22_o =>ben_vmr_shd.g_old_rec.vmr_attribute22
505: ,p_vmr_attribute15_o =>ben_vmr_shd.g_old_rec.vmr_attribute15
506: ,p_vmr_attribute16_o =>ben_vmr_shd.g_old_rec.vmr_attribute16
507: ,p_vmr_attribute17_o =>ben_vmr_shd.g_old_rec.vmr_attribute17
508: ,p_vmr_attribute18_o =>ben_vmr_shd.g_old_rec.vmr_attribute18
509: ,p_vmr_attribute19_o =>ben_vmr_shd.g_old_rec.vmr_attribute19
510: ,p_vmr_attribute20_o =>ben_vmr_shd.g_old_rec.vmr_attribute20
511: ,p_vmr_attribute21_o =>ben_vmr_shd.g_old_rec.vmr_attribute21
512: ,p_vmr_attribute22_o =>ben_vmr_shd.g_old_rec.vmr_attribute22
513: ,p_vmr_attribute23_o =>ben_vmr_shd.g_old_rec.vmr_attribute23
506: ,p_vmr_attribute16_o =>ben_vmr_shd.g_old_rec.vmr_attribute16
507: ,p_vmr_attribute17_o =>ben_vmr_shd.g_old_rec.vmr_attribute17
508: ,p_vmr_attribute18_o =>ben_vmr_shd.g_old_rec.vmr_attribute18
509: ,p_vmr_attribute19_o =>ben_vmr_shd.g_old_rec.vmr_attribute19
510: ,p_vmr_attribute20_o =>ben_vmr_shd.g_old_rec.vmr_attribute20
511: ,p_vmr_attribute21_o =>ben_vmr_shd.g_old_rec.vmr_attribute21
512: ,p_vmr_attribute22_o =>ben_vmr_shd.g_old_rec.vmr_attribute22
513: ,p_vmr_attribute23_o =>ben_vmr_shd.g_old_rec.vmr_attribute23
514: ,p_vmr_attribute24_o =>ben_vmr_shd.g_old_rec.vmr_attribute24
507: ,p_vmr_attribute17_o =>ben_vmr_shd.g_old_rec.vmr_attribute17
508: ,p_vmr_attribute18_o =>ben_vmr_shd.g_old_rec.vmr_attribute18
509: ,p_vmr_attribute19_o =>ben_vmr_shd.g_old_rec.vmr_attribute19
510: ,p_vmr_attribute20_o =>ben_vmr_shd.g_old_rec.vmr_attribute20
511: ,p_vmr_attribute21_o =>ben_vmr_shd.g_old_rec.vmr_attribute21
512: ,p_vmr_attribute22_o =>ben_vmr_shd.g_old_rec.vmr_attribute22
513: ,p_vmr_attribute23_o =>ben_vmr_shd.g_old_rec.vmr_attribute23
514: ,p_vmr_attribute24_o =>ben_vmr_shd.g_old_rec.vmr_attribute24
515: ,p_vmr_attribute25_o =>ben_vmr_shd.g_old_rec.vmr_attribute25
508: ,p_vmr_attribute18_o =>ben_vmr_shd.g_old_rec.vmr_attribute18
509: ,p_vmr_attribute19_o =>ben_vmr_shd.g_old_rec.vmr_attribute19
510: ,p_vmr_attribute20_o =>ben_vmr_shd.g_old_rec.vmr_attribute20
511: ,p_vmr_attribute21_o =>ben_vmr_shd.g_old_rec.vmr_attribute21
512: ,p_vmr_attribute22_o =>ben_vmr_shd.g_old_rec.vmr_attribute22
513: ,p_vmr_attribute23_o =>ben_vmr_shd.g_old_rec.vmr_attribute23
514: ,p_vmr_attribute24_o =>ben_vmr_shd.g_old_rec.vmr_attribute24
515: ,p_vmr_attribute25_o =>ben_vmr_shd.g_old_rec.vmr_attribute25
516: ,p_vmr_attribute26_o =>ben_vmr_shd.g_old_rec.vmr_attribute26
509: ,p_vmr_attribute19_o =>ben_vmr_shd.g_old_rec.vmr_attribute19
510: ,p_vmr_attribute20_o =>ben_vmr_shd.g_old_rec.vmr_attribute20
511: ,p_vmr_attribute21_o =>ben_vmr_shd.g_old_rec.vmr_attribute21
512: ,p_vmr_attribute22_o =>ben_vmr_shd.g_old_rec.vmr_attribute22
513: ,p_vmr_attribute23_o =>ben_vmr_shd.g_old_rec.vmr_attribute23
514: ,p_vmr_attribute24_o =>ben_vmr_shd.g_old_rec.vmr_attribute24
515: ,p_vmr_attribute25_o =>ben_vmr_shd.g_old_rec.vmr_attribute25
516: ,p_vmr_attribute26_o =>ben_vmr_shd.g_old_rec.vmr_attribute26
517: ,p_vmr_attribute27_o =>ben_vmr_shd.g_old_rec.vmr_attribute27
510: ,p_vmr_attribute20_o =>ben_vmr_shd.g_old_rec.vmr_attribute20
511: ,p_vmr_attribute21_o =>ben_vmr_shd.g_old_rec.vmr_attribute21
512: ,p_vmr_attribute22_o =>ben_vmr_shd.g_old_rec.vmr_attribute22
513: ,p_vmr_attribute23_o =>ben_vmr_shd.g_old_rec.vmr_attribute23
514: ,p_vmr_attribute24_o =>ben_vmr_shd.g_old_rec.vmr_attribute24
515: ,p_vmr_attribute25_o =>ben_vmr_shd.g_old_rec.vmr_attribute25
516: ,p_vmr_attribute26_o =>ben_vmr_shd.g_old_rec.vmr_attribute26
517: ,p_vmr_attribute27_o =>ben_vmr_shd.g_old_rec.vmr_attribute27
518: ,p_vmr_attribute28_o =>ben_vmr_shd.g_old_rec.vmr_attribute28
511: ,p_vmr_attribute21_o =>ben_vmr_shd.g_old_rec.vmr_attribute21
512: ,p_vmr_attribute22_o =>ben_vmr_shd.g_old_rec.vmr_attribute22
513: ,p_vmr_attribute23_o =>ben_vmr_shd.g_old_rec.vmr_attribute23
514: ,p_vmr_attribute24_o =>ben_vmr_shd.g_old_rec.vmr_attribute24
515: ,p_vmr_attribute25_o =>ben_vmr_shd.g_old_rec.vmr_attribute25
516: ,p_vmr_attribute26_o =>ben_vmr_shd.g_old_rec.vmr_attribute26
517: ,p_vmr_attribute27_o =>ben_vmr_shd.g_old_rec.vmr_attribute27
518: ,p_vmr_attribute28_o =>ben_vmr_shd.g_old_rec.vmr_attribute28
519: ,p_vmr_attribute29_o =>ben_vmr_shd.g_old_rec.vmr_attribute29
512: ,p_vmr_attribute22_o =>ben_vmr_shd.g_old_rec.vmr_attribute22
513: ,p_vmr_attribute23_o =>ben_vmr_shd.g_old_rec.vmr_attribute23
514: ,p_vmr_attribute24_o =>ben_vmr_shd.g_old_rec.vmr_attribute24
515: ,p_vmr_attribute25_o =>ben_vmr_shd.g_old_rec.vmr_attribute25
516: ,p_vmr_attribute26_o =>ben_vmr_shd.g_old_rec.vmr_attribute26
517: ,p_vmr_attribute27_o =>ben_vmr_shd.g_old_rec.vmr_attribute27
518: ,p_vmr_attribute28_o =>ben_vmr_shd.g_old_rec.vmr_attribute28
519: ,p_vmr_attribute29_o =>ben_vmr_shd.g_old_rec.vmr_attribute29
520: ,p_vmr_attribute30_o =>ben_vmr_shd.g_old_rec.vmr_attribute30
513: ,p_vmr_attribute23_o =>ben_vmr_shd.g_old_rec.vmr_attribute23
514: ,p_vmr_attribute24_o =>ben_vmr_shd.g_old_rec.vmr_attribute24
515: ,p_vmr_attribute25_o =>ben_vmr_shd.g_old_rec.vmr_attribute25
516: ,p_vmr_attribute26_o =>ben_vmr_shd.g_old_rec.vmr_attribute26
517: ,p_vmr_attribute27_o =>ben_vmr_shd.g_old_rec.vmr_attribute27
518: ,p_vmr_attribute28_o =>ben_vmr_shd.g_old_rec.vmr_attribute28
519: ,p_vmr_attribute29_o =>ben_vmr_shd.g_old_rec.vmr_attribute29
520: ,p_vmr_attribute30_o =>ben_vmr_shd.g_old_rec.vmr_attribute30
521: ,p_object_version_number_o =>ben_vmr_shd.g_old_rec.object_version_number
514: ,p_vmr_attribute24_o =>ben_vmr_shd.g_old_rec.vmr_attribute24
515: ,p_vmr_attribute25_o =>ben_vmr_shd.g_old_rec.vmr_attribute25
516: ,p_vmr_attribute26_o =>ben_vmr_shd.g_old_rec.vmr_attribute26
517: ,p_vmr_attribute27_o =>ben_vmr_shd.g_old_rec.vmr_attribute27
518: ,p_vmr_attribute28_o =>ben_vmr_shd.g_old_rec.vmr_attribute28
519: ,p_vmr_attribute29_o =>ben_vmr_shd.g_old_rec.vmr_attribute29
520: ,p_vmr_attribute30_o =>ben_vmr_shd.g_old_rec.vmr_attribute30
521: ,p_object_version_number_o =>ben_vmr_shd.g_old_rec.object_version_number
522: );
515: ,p_vmr_attribute25_o =>ben_vmr_shd.g_old_rec.vmr_attribute25
516: ,p_vmr_attribute26_o =>ben_vmr_shd.g_old_rec.vmr_attribute26
517: ,p_vmr_attribute27_o =>ben_vmr_shd.g_old_rec.vmr_attribute27
518: ,p_vmr_attribute28_o =>ben_vmr_shd.g_old_rec.vmr_attribute28
519: ,p_vmr_attribute29_o =>ben_vmr_shd.g_old_rec.vmr_attribute29
520: ,p_vmr_attribute30_o =>ben_vmr_shd.g_old_rec.vmr_attribute30
521: ,p_object_version_number_o =>ben_vmr_shd.g_old_rec.object_version_number
522: );
523: --
516: ,p_vmr_attribute26_o =>ben_vmr_shd.g_old_rec.vmr_attribute26
517: ,p_vmr_attribute27_o =>ben_vmr_shd.g_old_rec.vmr_attribute27
518: ,p_vmr_attribute28_o =>ben_vmr_shd.g_old_rec.vmr_attribute28
519: ,p_vmr_attribute29_o =>ben_vmr_shd.g_old_rec.vmr_attribute29
520: ,p_vmr_attribute30_o =>ben_vmr_shd.g_old_rec.vmr_attribute30
521: ,p_object_version_number_o =>ben_vmr_shd.g_old_rec.object_version_number
522: );
523: --
524: exception
517: ,p_vmr_attribute27_o =>ben_vmr_shd.g_old_rec.vmr_attribute27
518: ,p_vmr_attribute28_o =>ben_vmr_shd.g_old_rec.vmr_attribute28
519: ,p_vmr_attribute29_o =>ben_vmr_shd.g_old_rec.vmr_attribute29
520: ,p_vmr_attribute30_o =>ben_vmr_shd.g_old_rec.vmr_attribute30
521: ,p_object_version_number_o =>ben_vmr_shd.g_old_rec.object_version_number
522: );
523: --
524: exception
525: --
579: -- Internal Row Handler Use Only.
580: --
581: -- {End Of Comments}
582: -- ----------------------------------------------------------------------------
583: Procedure convert_defs(p_rec in out nocopy ben_vmr_shd.g_rec_type) is
584: --
585: l_proc varchar2(72) := g_package||'convert_defs';
586: --
587: Begin
594: -- is being used then we must set to the 'current' argument value.
595: --
596: If (p_rec.no_mx_pct_of_py_num_flag = hr_api.g_varchar2) then
597: p_rec.no_mx_pct_of_py_num_flag :=
598: ben_vmr_shd.g_old_rec.no_mx_pct_of_py_num_flag;
599: End If;
600: If (p_rec.to_pct_val = hr_api.g_number) then
601: p_rec.to_pct_val :=
602: ben_vmr_shd.g_old_rec.to_pct_val;
598: ben_vmr_shd.g_old_rec.no_mx_pct_of_py_num_flag;
599: End If;
600: If (p_rec.to_pct_val = hr_api.g_number) then
601: p_rec.to_pct_val :=
602: ben_vmr_shd.g_old_rec.to_pct_val;
603: End If;
604: If (p_rec.no_mx_amt_of_py_num_flag = hr_api.g_varchar2) then
605: p_rec.no_mx_amt_of_py_num_flag :=
606: ben_vmr_shd.g_old_rec.no_mx_amt_of_py_num_flag;
602: ben_vmr_shd.g_old_rec.to_pct_val;
603: End If;
604: If (p_rec.no_mx_amt_of_py_num_flag = hr_api.g_varchar2) then
605: p_rec.no_mx_amt_of_py_num_flag :=
606: ben_vmr_shd.g_old_rec.no_mx_amt_of_py_num_flag;
607: End If;
608: If (p_rec.mx_pct_of_py_num = hr_api.g_number) then
609: p_rec.mx_pct_of_py_num :=
610: ben_vmr_shd.g_old_rec.mx_pct_of_py_num;
606: ben_vmr_shd.g_old_rec.no_mx_amt_of_py_num_flag;
607: End If;
608: If (p_rec.mx_pct_of_py_num = hr_api.g_number) then
609: p_rec.mx_pct_of_py_num :=
610: ben_vmr_shd.g_old_rec.mx_pct_of_py_num;
611: End If;
612: If (p_rec.no_mx_mtch_amt_flag = hr_api.g_varchar2) then
613: p_rec.no_mx_mtch_amt_flag :=
614: ben_vmr_shd.g_old_rec.no_mx_mtch_amt_flag;
610: ben_vmr_shd.g_old_rec.mx_pct_of_py_num;
611: End If;
612: If (p_rec.no_mx_mtch_amt_flag = hr_api.g_varchar2) then
613: p_rec.no_mx_mtch_amt_flag :=
614: ben_vmr_shd.g_old_rec.no_mx_mtch_amt_flag;
615: End If;
616: If (p_rec.ordr_num = hr_api.g_number) then
617: p_rec.ordr_num :=
618: ben_vmr_shd.g_old_rec.ordr_num;
614: ben_vmr_shd.g_old_rec.no_mx_mtch_amt_flag;
615: End If;
616: If (p_rec.ordr_num = hr_api.g_number) then
617: p_rec.ordr_num :=
618: ben_vmr_shd.g_old_rec.ordr_num;
619: End If;
620: If (p_rec.pct_val = hr_api.g_number) then
621: p_rec.pct_val :=
622: ben_vmr_shd.g_old_rec.pct_val;
618: ben_vmr_shd.g_old_rec.ordr_num;
619: End If;
620: If (p_rec.pct_val = hr_api.g_number) then
621: p_rec.pct_val :=
622: ben_vmr_shd.g_old_rec.pct_val;
623: End If;
624: If (p_rec.mx_mtch_amt = hr_api.g_number) then
625: p_rec.mx_mtch_amt :=
626: ben_vmr_shd.g_old_rec.mx_mtch_amt;
622: ben_vmr_shd.g_old_rec.pct_val;
623: End If;
624: If (p_rec.mx_mtch_amt = hr_api.g_number) then
625: p_rec.mx_mtch_amt :=
626: ben_vmr_shd.g_old_rec.mx_mtch_amt;
627: End If;
628: If (p_rec.mx_amt_of_py_num = hr_api.g_number) then
629: p_rec.mx_amt_of_py_num :=
630: ben_vmr_shd.g_old_rec.mx_amt_of_py_num;
626: ben_vmr_shd.g_old_rec.mx_mtch_amt;
627: End If;
628: If (p_rec.mx_amt_of_py_num = hr_api.g_number) then
629: p_rec.mx_amt_of_py_num :=
630: ben_vmr_shd.g_old_rec.mx_amt_of_py_num;
631: End If;
632: If (p_rec.mn_mtch_amt = hr_api.g_number) then
633: p_rec.mn_mtch_amt :=
634: ben_vmr_shd.g_old_rec.mn_mtch_amt;
630: ben_vmr_shd.g_old_rec.mx_amt_of_py_num;
631: End If;
632: If (p_rec.mn_mtch_amt = hr_api.g_number) then
633: p_rec.mn_mtch_amt :=
634: ben_vmr_shd.g_old_rec.mn_mtch_amt;
635: End If;
636: If (p_rec.mtchg_rt_calc_rl = hr_api.g_number) then
637: p_rec.mtchg_rt_calc_rl :=
638: ben_vmr_shd.g_old_rec.mtchg_rt_calc_rl;
634: ben_vmr_shd.g_old_rec.mn_mtch_amt;
635: End If;
636: If (p_rec.mtchg_rt_calc_rl = hr_api.g_number) then
637: p_rec.mtchg_rt_calc_rl :=
638: ben_vmr_shd.g_old_rec.mtchg_rt_calc_rl;
639: End If;
640: If (p_rec.cntnu_mtch_aftr_max_rl_flag = hr_api.g_varchar2) then
641: p_rec.cntnu_mtch_aftr_max_rl_flag :=
642: ben_vmr_shd.g_old_rec.cntnu_mtch_aftr_max_rl_flag;
638: ben_vmr_shd.g_old_rec.mtchg_rt_calc_rl;
639: End If;
640: If (p_rec.cntnu_mtch_aftr_max_rl_flag = hr_api.g_varchar2) then
641: p_rec.cntnu_mtch_aftr_max_rl_flag :=
642: ben_vmr_shd.g_old_rec.cntnu_mtch_aftr_max_rl_flag;
643: End If;
644: If (p_rec.from_pct_val = hr_api.g_number) then
645: p_rec.from_pct_val :=
646: ben_vmr_shd.g_old_rec.from_pct_val;
642: ben_vmr_shd.g_old_rec.cntnu_mtch_aftr_max_rl_flag;
643: End If;
644: If (p_rec.from_pct_val = hr_api.g_number) then
645: p_rec.from_pct_val :=
646: ben_vmr_shd.g_old_rec.from_pct_val;
647: End If;
648: If (p_rec.vrbl_rt_prfl_id = hr_api.g_number) then
649: p_rec.vrbl_rt_prfl_id :=
650: ben_vmr_shd.g_old_rec.vrbl_rt_prfl_id;
646: ben_vmr_shd.g_old_rec.from_pct_val;
647: End If;
648: If (p_rec.vrbl_rt_prfl_id = hr_api.g_number) then
649: p_rec.vrbl_rt_prfl_id :=
650: ben_vmr_shd.g_old_rec.vrbl_rt_prfl_id;
651: End If;
652: If (p_rec.business_group_id = hr_api.g_number) then
653: p_rec.business_group_id :=
654: ben_vmr_shd.g_old_rec.business_group_id;
650: ben_vmr_shd.g_old_rec.vrbl_rt_prfl_id;
651: End If;
652: If (p_rec.business_group_id = hr_api.g_number) then
653: p_rec.business_group_id :=
654: ben_vmr_shd.g_old_rec.business_group_id;
655: End If;
656: If (p_rec.vmr_attribute_category = hr_api.g_varchar2) then
657: p_rec.vmr_attribute_category :=
658: ben_vmr_shd.g_old_rec.vmr_attribute_category;
654: ben_vmr_shd.g_old_rec.business_group_id;
655: End If;
656: If (p_rec.vmr_attribute_category = hr_api.g_varchar2) then
657: p_rec.vmr_attribute_category :=
658: ben_vmr_shd.g_old_rec.vmr_attribute_category;
659: End If;
660: If (p_rec.vmr_attribute1 = hr_api.g_varchar2) then
661: p_rec.vmr_attribute1 :=
662: ben_vmr_shd.g_old_rec.vmr_attribute1;
658: ben_vmr_shd.g_old_rec.vmr_attribute_category;
659: End If;
660: If (p_rec.vmr_attribute1 = hr_api.g_varchar2) then
661: p_rec.vmr_attribute1 :=
662: ben_vmr_shd.g_old_rec.vmr_attribute1;
663: End If;
664: If (p_rec.vmr_attribute2 = hr_api.g_varchar2) then
665: p_rec.vmr_attribute2 :=
666: ben_vmr_shd.g_old_rec.vmr_attribute2;
662: ben_vmr_shd.g_old_rec.vmr_attribute1;
663: End If;
664: If (p_rec.vmr_attribute2 = hr_api.g_varchar2) then
665: p_rec.vmr_attribute2 :=
666: ben_vmr_shd.g_old_rec.vmr_attribute2;
667: End If;
668: If (p_rec.vmr_attribute3 = hr_api.g_varchar2) then
669: p_rec.vmr_attribute3 :=
670: ben_vmr_shd.g_old_rec.vmr_attribute3;
666: ben_vmr_shd.g_old_rec.vmr_attribute2;
667: End If;
668: If (p_rec.vmr_attribute3 = hr_api.g_varchar2) then
669: p_rec.vmr_attribute3 :=
670: ben_vmr_shd.g_old_rec.vmr_attribute3;
671: End If;
672: If (p_rec.vmr_attribute4 = hr_api.g_varchar2) then
673: p_rec.vmr_attribute4 :=
674: ben_vmr_shd.g_old_rec.vmr_attribute4;
670: ben_vmr_shd.g_old_rec.vmr_attribute3;
671: End If;
672: If (p_rec.vmr_attribute4 = hr_api.g_varchar2) then
673: p_rec.vmr_attribute4 :=
674: ben_vmr_shd.g_old_rec.vmr_attribute4;
675: End If;
676: If (p_rec.vmr_attribute5 = hr_api.g_varchar2) then
677: p_rec.vmr_attribute5 :=
678: ben_vmr_shd.g_old_rec.vmr_attribute5;
674: ben_vmr_shd.g_old_rec.vmr_attribute4;
675: End If;
676: If (p_rec.vmr_attribute5 = hr_api.g_varchar2) then
677: p_rec.vmr_attribute5 :=
678: ben_vmr_shd.g_old_rec.vmr_attribute5;
679: End If;
680: If (p_rec.vmr_attribute6 = hr_api.g_varchar2) then
681: p_rec.vmr_attribute6 :=
682: ben_vmr_shd.g_old_rec.vmr_attribute6;
678: ben_vmr_shd.g_old_rec.vmr_attribute5;
679: End If;
680: If (p_rec.vmr_attribute6 = hr_api.g_varchar2) then
681: p_rec.vmr_attribute6 :=
682: ben_vmr_shd.g_old_rec.vmr_attribute6;
683: End If;
684: If (p_rec.vmr_attribute7 = hr_api.g_varchar2) then
685: p_rec.vmr_attribute7 :=
686: ben_vmr_shd.g_old_rec.vmr_attribute7;
682: ben_vmr_shd.g_old_rec.vmr_attribute6;
683: End If;
684: If (p_rec.vmr_attribute7 = hr_api.g_varchar2) then
685: p_rec.vmr_attribute7 :=
686: ben_vmr_shd.g_old_rec.vmr_attribute7;
687: End If;
688: If (p_rec.vmr_attribute8 = hr_api.g_varchar2) then
689: p_rec.vmr_attribute8 :=
690: ben_vmr_shd.g_old_rec.vmr_attribute8;
686: ben_vmr_shd.g_old_rec.vmr_attribute7;
687: End If;
688: If (p_rec.vmr_attribute8 = hr_api.g_varchar2) then
689: p_rec.vmr_attribute8 :=
690: ben_vmr_shd.g_old_rec.vmr_attribute8;
691: End If;
692: If (p_rec.vmr_attribute9 = hr_api.g_varchar2) then
693: p_rec.vmr_attribute9 :=
694: ben_vmr_shd.g_old_rec.vmr_attribute9;
690: ben_vmr_shd.g_old_rec.vmr_attribute8;
691: End If;
692: If (p_rec.vmr_attribute9 = hr_api.g_varchar2) then
693: p_rec.vmr_attribute9 :=
694: ben_vmr_shd.g_old_rec.vmr_attribute9;
695: End If;
696: If (p_rec.vmr_attribute10 = hr_api.g_varchar2) then
697: p_rec.vmr_attribute10 :=
698: ben_vmr_shd.g_old_rec.vmr_attribute10;
694: ben_vmr_shd.g_old_rec.vmr_attribute9;
695: End If;
696: If (p_rec.vmr_attribute10 = hr_api.g_varchar2) then
697: p_rec.vmr_attribute10 :=
698: ben_vmr_shd.g_old_rec.vmr_attribute10;
699: End If;
700: If (p_rec.vmr_attribute11 = hr_api.g_varchar2) then
701: p_rec.vmr_attribute11 :=
702: ben_vmr_shd.g_old_rec.vmr_attribute11;
698: ben_vmr_shd.g_old_rec.vmr_attribute10;
699: End If;
700: If (p_rec.vmr_attribute11 = hr_api.g_varchar2) then
701: p_rec.vmr_attribute11 :=
702: ben_vmr_shd.g_old_rec.vmr_attribute11;
703: End If;
704: If (p_rec.vmr_attribute12 = hr_api.g_varchar2) then
705: p_rec.vmr_attribute12 :=
706: ben_vmr_shd.g_old_rec.vmr_attribute12;
702: ben_vmr_shd.g_old_rec.vmr_attribute11;
703: End If;
704: If (p_rec.vmr_attribute12 = hr_api.g_varchar2) then
705: p_rec.vmr_attribute12 :=
706: ben_vmr_shd.g_old_rec.vmr_attribute12;
707: End If;
708: If (p_rec.vmr_attribute13 = hr_api.g_varchar2) then
709: p_rec.vmr_attribute13 :=
710: ben_vmr_shd.g_old_rec.vmr_attribute13;
706: ben_vmr_shd.g_old_rec.vmr_attribute12;
707: End If;
708: If (p_rec.vmr_attribute13 = hr_api.g_varchar2) then
709: p_rec.vmr_attribute13 :=
710: ben_vmr_shd.g_old_rec.vmr_attribute13;
711: End If;
712: If (p_rec.vmr_attribute14 = hr_api.g_varchar2) then
713: p_rec.vmr_attribute14 :=
714: ben_vmr_shd.g_old_rec.vmr_attribute14;
710: ben_vmr_shd.g_old_rec.vmr_attribute13;
711: End If;
712: If (p_rec.vmr_attribute14 = hr_api.g_varchar2) then
713: p_rec.vmr_attribute14 :=
714: ben_vmr_shd.g_old_rec.vmr_attribute14;
715: End If;
716: If (p_rec.vmr_attribute15 = hr_api.g_varchar2) then
717: p_rec.vmr_attribute15 :=
718: ben_vmr_shd.g_old_rec.vmr_attribute15;
714: ben_vmr_shd.g_old_rec.vmr_attribute14;
715: End If;
716: If (p_rec.vmr_attribute15 = hr_api.g_varchar2) then
717: p_rec.vmr_attribute15 :=
718: ben_vmr_shd.g_old_rec.vmr_attribute15;
719: End If;
720: If (p_rec.vmr_attribute16 = hr_api.g_varchar2) then
721: p_rec.vmr_attribute16 :=
722: ben_vmr_shd.g_old_rec.vmr_attribute16;
718: ben_vmr_shd.g_old_rec.vmr_attribute15;
719: End If;
720: If (p_rec.vmr_attribute16 = hr_api.g_varchar2) then
721: p_rec.vmr_attribute16 :=
722: ben_vmr_shd.g_old_rec.vmr_attribute16;
723: End If;
724: If (p_rec.vmr_attribute17 = hr_api.g_varchar2) then
725: p_rec.vmr_attribute17 :=
726: ben_vmr_shd.g_old_rec.vmr_attribute17;
722: ben_vmr_shd.g_old_rec.vmr_attribute16;
723: End If;
724: If (p_rec.vmr_attribute17 = hr_api.g_varchar2) then
725: p_rec.vmr_attribute17 :=
726: ben_vmr_shd.g_old_rec.vmr_attribute17;
727: End If;
728: If (p_rec.vmr_attribute18 = hr_api.g_varchar2) then
729: p_rec.vmr_attribute18 :=
730: ben_vmr_shd.g_old_rec.vmr_attribute18;
726: ben_vmr_shd.g_old_rec.vmr_attribute17;
727: End If;
728: If (p_rec.vmr_attribute18 = hr_api.g_varchar2) then
729: p_rec.vmr_attribute18 :=
730: ben_vmr_shd.g_old_rec.vmr_attribute18;
731: End If;
732: If (p_rec.vmr_attribute19 = hr_api.g_varchar2) then
733: p_rec.vmr_attribute19 :=
734: ben_vmr_shd.g_old_rec.vmr_attribute19;
730: ben_vmr_shd.g_old_rec.vmr_attribute18;
731: End If;
732: If (p_rec.vmr_attribute19 = hr_api.g_varchar2) then
733: p_rec.vmr_attribute19 :=
734: ben_vmr_shd.g_old_rec.vmr_attribute19;
735: End If;
736: If (p_rec.vmr_attribute20 = hr_api.g_varchar2) then
737: p_rec.vmr_attribute20 :=
738: ben_vmr_shd.g_old_rec.vmr_attribute20;
734: ben_vmr_shd.g_old_rec.vmr_attribute19;
735: End If;
736: If (p_rec.vmr_attribute20 = hr_api.g_varchar2) then
737: p_rec.vmr_attribute20 :=
738: ben_vmr_shd.g_old_rec.vmr_attribute20;
739: End If;
740: If (p_rec.vmr_attribute21 = hr_api.g_varchar2) then
741: p_rec.vmr_attribute21 :=
742: ben_vmr_shd.g_old_rec.vmr_attribute21;
738: ben_vmr_shd.g_old_rec.vmr_attribute20;
739: End If;
740: If (p_rec.vmr_attribute21 = hr_api.g_varchar2) then
741: p_rec.vmr_attribute21 :=
742: ben_vmr_shd.g_old_rec.vmr_attribute21;
743: End If;
744: If (p_rec.vmr_attribute22 = hr_api.g_varchar2) then
745: p_rec.vmr_attribute22 :=
746: ben_vmr_shd.g_old_rec.vmr_attribute22;
742: ben_vmr_shd.g_old_rec.vmr_attribute21;
743: End If;
744: If (p_rec.vmr_attribute22 = hr_api.g_varchar2) then
745: p_rec.vmr_attribute22 :=
746: ben_vmr_shd.g_old_rec.vmr_attribute22;
747: End If;
748: If (p_rec.vmr_attribute23 = hr_api.g_varchar2) then
749: p_rec.vmr_attribute23 :=
750: ben_vmr_shd.g_old_rec.vmr_attribute23;
746: ben_vmr_shd.g_old_rec.vmr_attribute22;
747: End If;
748: If (p_rec.vmr_attribute23 = hr_api.g_varchar2) then
749: p_rec.vmr_attribute23 :=
750: ben_vmr_shd.g_old_rec.vmr_attribute23;
751: End If;
752: If (p_rec.vmr_attribute24 = hr_api.g_varchar2) then
753: p_rec.vmr_attribute24 :=
754: ben_vmr_shd.g_old_rec.vmr_attribute24;
750: ben_vmr_shd.g_old_rec.vmr_attribute23;
751: End If;
752: If (p_rec.vmr_attribute24 = hr_api.g_varchar2) then
753: p_rec.vmr_attribute24 :=
754: ben_vmr_shd.g_old_rec.vmr_attribute24;
755: End If;
756: If (p_rec.vmr_attribute25 = hr_api.g_varchar2) then
757: p_rec.vmr_attribute25 :=
758: ben_vmr_shd.g_old_rec.vmr_attribute25;
754: ben_vmr_shd.g_old_rec.vmr_attribute24;
755: End If;
756: If (p_rec.vmr_attribute25 = hr_api.g_varchar2) then
757: p_rec.vmr_attribute25 :=
758: ben_vmr_shd.g_old_rec.vmr_attribute25;
759: End If;
760: If (p_rec.vmr_attribute26 = hr_api.g_varchar2) then
761: p_rec.vmr_attribute26 :=
762: ben_vmr_shd.g_old_rec.vmr_attribute26;
758: ben_vmr_shd.g_old_rec.vmr_attribute25;
759: End If;
760: If (p_rec.vmr_attribute26 = hr_api.g_varchar2) then
761: p_rec.vmr_attribute26 :=
762: ben_vmr_shd.g_old_rec.vmr_attribute26;
763: End If;
764: If (p_rec.vmr_attribute27 = hr_api.g_varchar2) then
765: p_rec.vmr_attribute27 :=
766: ben_vmr_shd.g_old_rec.vmr_attribute27;
762: ben_vmr_shd.g_old_rec.vmr_attribute26;
763: End If;
764: If (p_rec.vmr_attribute27 = hr_api.g_varchar2) then
765: p_rec.vmr_attribute27 :=
766: ben_vmr_shd.g_old_rec.vmr_attribute27;
767: End If;
768: If (p_rec.vmr_attribute28 = hr_api.g_varchar2) then
769: p_rec.vmr_attribute28 :=
770: ben_vmr_shd.g_old_rec.vmr_attribute28;
766: ben_vmr_shd.g_old_rec.vmr_attribute27;
767: End If;
768: If (p_rec.vmr_attribute28 = hr_api.g_varchar2) then
769: p_rec.vmr_attribute28 :=
770: ben_vmr_shd.g_old_rec.vmr_attribute28;
771: End If;
772: If (p_rec.vmr_attribute29 = hr_api.g_varchar2) then
773: p_rec.vmr_attribute29 :=
774: ben_vmr_shd.g_old_rec.vmr_attribute29;
770: ben_vmr_shd.g_old_rec.vmr_attribute28;
771: End If;
772: If (p_rec.vmr_attribute29 = hr_api.g_varchar2) then
773: p_rec.vmr_attribute29 :=
774: ben_vmr_shd.g_old_rec.vmr_attribute29;
775: End If;
776: If (p_rec.vmr_attribute30 = hr_api.g_varchar2) then
777: p_rec.vmr_attribute30 :=
778: ben_vmr_shd.g_old_rec.vmr_attribute30;
774: ben_vmr_shd.g_old_rec.vmr_attribute29;
775: End If;
776: If (p_rec.vmr_attribute30 = hr_api.g_varchar2) then
777: p_rec.vmr_attribute30 :=
778: ben_vmr_shd.g_old_rec.vmr_attribute30;
779: End If;
780:
781: --
782: hr_utility.set_location(' Leaving:'||l_proc, 10);
787: -- |---------------------------------< upd >----------------------------------|
788: -- ----------------------------------------------------------------------------
789: Procedure upd
790: (
791: p_rec in out nocopy ben_vmr_shd.g_rec_type,
792: p_effective_date in date,
793: p_datetrack_mode in varchar2
794: ) is
795: --
805: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
806: --
807: -- We must lock the row which we need to update.
808: --
809: ben_vmr_shd.lck
810: (p_effective_date => p_effective_date,
811: p_datetrack_mode => p_datetrack_mode,
812: p_vrbl_mtchg_rt_id => p_rec.vrbl_mtchg_rt_id,
813: p_object_version_number => p_rec.object_version_number,
914: p_effective_date in date,
915: p_datetrack_mode in varchar2
916: ) is
917: --
918: l_rec ben_vmr_shd.g_rec_type;
919: l_proc varchar2(72) := g_package||'upd';
920: --
921: Begin
922: hr_utility.set_location('Entering:'||l_proc, 5);
924: -- Call conversion function to turn arguments into the
925: -- l_rec structure.
926: --
927: l_rec :=
928: ben_vmr_shd.convert_args
929: (
930: p_vrbl_mtchg_rt_id,
931: null,
932: null,