[Home] [Help]
50: -- Internal Row Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy ben_clf_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin
61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
64: --
65: ben_clf_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the ben_comp_lvl_fctr Row
68: --
69: update ben_comp_lvl_fctr
124: object_version_number = p_rec.object_version_number,
125: sttd_sal_prdcty_cd = p_rec.sttd_sal_prdcty_cd
126: where comp_lvl_fctr_id = p_rec.comp_lvl_fctr_id;
127: --
128: ben_clf_shd.g_api_dml := false; -- Unset the api dml status
129: --
130: hr_utility.set_location(' Leaving:'||l_proc, 10);
131: --
132: Exception
131: --
132: Exception
133: When hr_api.check_integrity_violated Then
134: -- A check constraint has been violated
135: ben_clf_shd.g_api_dml := false; -- Unset the api dml status
136: ben_clf_shd.constraint_error
137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When hr_api.parent_integrity_violated Then
139: -- Parent integrity has been violated
132: Exception
133: When hr_api.check_integrity_violated Then
134: -- A check constraint has been violated
135: ben_clf_shd.g_api_dml := false; -- Unset the api dml status
136: ben_clf_shd.constraint_error
137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When hr_api.parent_integrity_violated Then
139: -- Parent integrity has been violated
140: ben_clf_shd.g_api_dml := false; -- Unset the api dml status
136: ben_clf_shd.constraint_error
137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When hr_api.parent_integrity_violated Then
139: -- Parent integrity has been violated
140: ben_clf_shd.g_api_dml := false; -- Unset the api dml status
141: ben_clf_shd.constraint_error
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When hr_api.unique_integrity_violated Then
144: -- Unique integrity has been violated
137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When hr_api.parent_integrity_violated Then
139: -- Parent integrity has been violated
140: ben_clf_shd.g_api_dml := false; -- Unset the api dml status
141: ben_clf_shd.constraint_error
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When hr_api.unique_integrity_violated Then
144: -- Unique integrity has been violated
145: ben_clf_shd.g_api_dml := false; -- Unset the api dml status
141: ben_clf_shd.constraint_error
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When hr_api.unique_integrity_violated Then
144: -- Unique integrity has been violated
145: ben_clf_shd.g_api_dml := false; -- Unset the api dml status
146: ben_clf_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When Others Then
149: ben_clf_shd.g_api_dml := false; -- Unset the api dml status
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When hr_api.unique_integrity_violated Then
144: -- Unique integrity has been violated
145: ben_clf_shd.g_api_dml := false; -- Unset the api dml status
146: ben_clf_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When Others Then
149: ben_clf_shd.g_api_dml := false; -- Unset the api dml status
150: Raise;
145: ben_clf_shd.g_api_dml := false; -- Unset the api dml status
146: ben_clf_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When Others Then
149: ben_clf_shd.g_api_dml := false; -- Unset the api dml status
150: Raise;
151: End update_dml;
152: --
153: -- ----------------------------------------------------------------------------
181: -- Internal Row Handler Use Only.
182: --
183: -- {End Of Comments}
184: -- ----------------------------------------------------------------------------
185: Procedure pre_update(p_rec in ben_clf_shd.g_rec_type) is
186: --
187: l_proc varchar2(72) := g_package||'pre_update';
188: --
189: Begin
224: --
225: -- {End Of Comments}
226: -- ----------------------------------------------------------------------------
227: Procedure post_update(
228: p_effective_date in date,p_rec in ben_clf_shd.g_rec_type) is
229: --
230: l_proc varchar2(72) := g_package||'post_update';
231: --
232: Begin
294: ,p_clf_attribute30 =>p_rec.clf_attribute30
295: ,p_object_version_number =>p_rec.object_version_number
296: ,p_effective_date =>p_effective_date
297: ,p_sttd_sal_prdcty_cd =>p_rec.sttd_sal_prdcty_cd
298: ,p_business_group_id_o =>ben_clf_shd.g_old_rec.business_group_id
299: ,p_name_o =>ben_clf_shd.g_old_rec.name
300: ,p_comp_lvl_det_cd_o =>ben_clf_shd.g_old_rec.comp_lvl_det_cd
301: ,p_comp_lvl_det_rl_o =>ben_clf_shd.g_old_rec.comp_lvl_det_rl
302: ,p_comp_lvl_uom_o =>ben_clf_shd.g_old_rec.comp_lvl_uom
295: ,p_object_version_number =>p_rec.object_version_number
296: ,p_effective_date =>p_effective_date
297: ,p_sttd_sal_prdcty_cd =>p_rec.sttd_sal_prdcty_cd
298: ,p_business_group_id_o =>ben_clf_shd.g_old_rec.business_group_id
299: ,p_name_o =>ben_clf_shd.g_old_rec.name
300: ,p_comp_lvl_det_cd_o =>ben_clf_shd.g_old_rec.comp_lvl_det_cd
301: ,p_comp_lvl_det_rl_o =>ben_clf_shd.g_old_rec.comp_lvl_det_rl
302: ,p_comp_lvl_uom_o =>ben_clf_shd.g_old_rec.comp_lvl_uom
303: ,p_comp_src_cd_o =>ben_clf_shd.g_old_rec.comp_src_cd
296: ,p_effective_date =>p_effective_date
297: ,p_sttd_sal_prdcty_cd =>p_rec.sttd_sal_prdcty_cd
298: ,p_business_group_id_o =>ben_clf_shd.g_old_rec.business_group_id
299: ,p_name_o =>ben_clf_shd.g_old_rec.name
300: ,p_comp_lvl_det_cd_o =>ben_clf_shd.g_old_rec.comp_lvl_det_cd
301: ,p_comp_lvl_det_rl_o =>ben_clf_shd.g_old_rec.comp_lvl_det_rl
302: ,p_comp_lvl_uom_o =>ben_clf_shd.g_old_rec.comp_lvl_uom
303: ,p_comp_src_cd_o =>ben_clf_shd.g_old_rec.comp_src_cd
304: ,p_defined_balance_id_o =>ben_clf_shd.g_old_rec.defined_balance_id
297: ,p_sttd_sal_prdcty_cd =>p_rec.sttd_sal_prdcty_cd
298: ,p_business_group_id_o =>ben_clf_shd.g_old_rec.business_group_id
299: ,p_name_o =>ben_clf_shd.g_old_rec.name
300: ,p_comp_lvl_det_cd_o =>ben_clf_shd.g_old_rec.comp_lvl_det_cd
301: ,p_comp_lvl_det_rl_o =>ben_clf_shd.g_old_rec.comp_lvl_det_rl
302: ,p_comp_lvl_uom_o =>ben_clf_shd.g_old_rec.comp_lvl_uom
303: ,p_comp_src_cd_o =>ben_clf_shd.g_old_rec.comp_src_cd
304: ,p_defined_balance_id_o =>ben_clf_shd.g_old_rec.defined_balance_id
305: ,p_no_mn_comp_flag_o =>ben_clf_shd.g_old_rec.no_mn_comp_flag
298: ,p_business_group_id_o =>ben_clf_shd.g_old_rec.business_group_id
299: ,p_name_o =>ben_clf_shd.g_old_rec.name
300: ,p_comp_lvl_det_cd_o =>ben_clf_shd.g_old_rec.comp_lvl_det_cd
301: ,p_comp_lvl_det_rl_o =>ben_clf_shd.g_old_rec.comp_lvl_det_rl
302: ,p_comp_lvl_uom_o =>ben_clf_shd.g_old_rec.comp_lvl_uom
303: ,p_comp_src_cd_o =>ben_clf_shd.g_old_rec.comp_src_cd
304: ,p_defined_balance_id_o =>ben_clf_shd.g_old_rec.defined_balance_id
305: ,p_no_mn_comp_flag_o =>ben_clf_shd.g_old_rec.no_mn_comp_flag
306: ,p_no_mx_comp_flag_o =>ben_clf_shd.g_old_rec.no_mx_comp_flag
299: ,p_name_o =>ben_clf_shd.g_old_rec.name
300: ,p_comp_lvl_det_cd_o =>ben_clf_shd.g_old_rec.comp_lvl_det_cd
301: ,p_comp_lvl_det_rl_o =>ben_clf_shd.g_old_rec.comp_lvl_det_rl
302: ,p_comp_lvl_uom_o =>ben_clf_shd.g_old_rec.comp_lvl_uom
303: ,p_comp_src_cd_o =>ben_clf_shd.g_old_rec.comp_src_cd
304: ,p_defined_balance_id_o =>ben_clf_shd.g_old_rec.defined_balance_id
305: ,p_no_mn_comp_flag_o =>ben_clf_shd.g_old_rec.no_mn_comp_flag
306: ,p_no_mx_comp_flag_o =>ben_clf_shd.g_old_rec.no_mx_comp_flag
307: ,p_mx_comp_val_o =>ben_clf_shd.g_old_rec.mx_comp_val
300: ,p_comp_lvl_det_cd_o =>ben_clf_shd.g_old_rec.comp_lvl_det_cd
301: ,p_comp_lvl_det_rl_o =>ben_clf_shd.g_old_rec.comp_lvl_det_rl
302: ,p_comp_lvl_uom_o =>ben_clf_shd.g_old_rec.comp_lvl_uom
303: ,p_comp_src_cd_o =>ben_clf_shd.g_old_rec.comp_src_cd
304: ,p_defined_balance_id_o =>ben_clf_shd.g_old_rec.defined_balance_id
305: ,p_no_mn_comp_flag_o =>ben_clf_shd.g_old_rec.no_mn_comp_flag
306: ,p_no_mx_comp_flag_o =>ben_clf_shd.g_old_rec.no_mx_comp_flag
307: ,p_mx_comp_val_o =>ben_clf_shd.g_old_rec.mx_comp_val
308: ,p_mn_comp_val_o =>ben_clf_shd.g_old_rec.mn_comp_val
301: ,p_comp_lvl_det_rl_o =>ben_clf_shd.g_old_rec.comp_lvl_det_rl
302: ,p_comp_lvl_uom_o =>ben_clf_shd.g_old_rec.comp_lvl_uom
303: ,p_comp_src_cd_o =>ben_clf_shd.g_old_rec.comp_src_cd
304: ,p_defined_balance_id_o =>ben_clf_shd.g_old_rec.defined_balance_id
305: ,p_no_mn_comp_flag_o =>ben_clf_shd.g_old_rec.no_mn_comp_flag
306: ,p_no_mx_comp_flag_o =>ben_clf_shd.g_old_rec.no_mx_comp_flag
307: ,p_mx_comp_val_o =>ben_clf_shd.g_old_rec.mx_comp_val
308: ,p_mn_comp_val_o =>ben_clf_shd.g_old_rec.mn_comp_val
309: ,p_rndg_cd_o =>ben_clf_shd.g_old_rec.rndg_cd
302: ,p_comp_lvl_uom_o =>ben_clf_shd.g_old_rec.comp_lvl_uom
303: ,p_comp_src_cd_o =>ben_clf_shd.g_old_rec.comp_src_cd
304: ,p_defined_balance_id_o =>ben_clf_shd.g_old_rec.defined_balance_id
305: ,p_no_mn_comp_flag_o =>ben_clf_shd.g_old_rec.no_mn_comp_flag
306: ,p_no_mx_comp_flag_o =>ben_clf_shd.g_old_rec.no_mx_comp_flag
307: ,p_mx_comp_val_o =>ben_clf_shd.g_old_rec.mx_comp_val
308: ,p_mn_comp_val_o =>ben_clf_shd.g_old_rec.mn_comp_val
309: ,p_rndg_cd_o =>ben_clf_shd.g_old_rec.rndg_cd
310: ,p_rndg_rl_o =>ben_clf_shd.g_old_rec.rndg_rl
303: ,p_comp_src_cd_o =>ben_clf_shd.g_old_rec.comp_src_cd
304: ,p_defined_balance_id_o =>ben_clf_shd.g_old_rec.defined_balance_id
305: ,p_no_mn_comp_flag_o =>ben_clf_shd.g_old_rec.no_mn_comp_flag
306: ,p_no_mx_comp_flag_o =>ben_clf_shd.g_old_rec.no_mx_comp_flag
307: ,p_mx_comp_val_o =>ben_clf_shd.g_old_rec.mx_comp_val
308: ,p_mn_comp_val_o =>ben_clf_shd.g_old_rec.mn_comp_val
309: ,p_rndg_cd_o =>ben_clf_shd.g_old_rec.rndg_cd
310: ,p_rndg_rl_o =>ben_clf_shd.g_old_rec.rndg_rl
311: ,p_bnfts_bal_id_o =>ben_clf_shd.g_old_rec.bnfts_bal_id
304: ,p_defined_balance_id_o =>ben_clf_shd.g_old_rec.defined_balance_id
305: ,p_no_mn_comp_flag_o =>ben_clf_shd.g_old_rec.no_mn_comp_flag
306: ,p_no_mx_comp_flag_o =>ben_clf_shd.g_old_rec.no_mx_comp_flag
307: ,p_mx_comp_val_o =>ben_clf_shd.g_old_rec.mx_comp_val
308: ,p_mn_comp_val_o =>ben_clf_shd.g_old_rec.mn_comp_val
309: ,p_rndg_cd_o =>ben_clf_shd.g_old_rec.rndg_cd
310: ,p_rndg_rl_o =>ben_clf_shd.g_old_rec.rndg_rl
311: ,p_bnfts_bal_id_o =>ben_clf_shd.g_old_rec.bnfts_bal_id
312: ,p_comp_alt_val_to_use_cd_o =>ben_clf_shd.g_old_rec.comp_alt_val_to_use_cd
305: ,p_no_mn_comp_flag_o =>ben_clf_shd.g_old_rec.no_mn_comp_flag
306: ,p_no_mx_comp_flag_o =>ben_clf_shd.g_old_rec.no_mx_comp_flag
307: ,p_mx_comp_val_o =>ben_clf_shd.g_old_rec.mx_comp_val
308: ,p_mn_comp_val_o =>ben_clf_shd.g_old_rec.mn_comp_val
309: ,p_rndg_cd_o =>ben_clf_shd.g_old_rec.rndg_cd
310: ,p_rndg_rl_o =>ben_clf_shd.g_old_rec.rndg_rl
311: ,p_bnfts_bal_id_o =>ben_clf_shd.g_old_rec.bnfts_bal_id
312: ,p_comp_alt_val_to_use_cd_o =>ben_clf_shd.g_old_rec.comp_alt_val_to_use_cd
313: ,p_comp_calc_rl_o =>ben_clf_shd.g_old_rec.comp_calc_rl
306: ,p_no_mx_comp_flag_o =>ben_clf_shd.g_old_rec.no_mx_comp_flag
307: ,p_mx_comp_val_o =>ben_clf_shd.g_old_rec.mx_comp_val
308: ,p_mn_comp_val_o =>ben_clf_shd.g_old_rec.mn_comp_val
309: ,p_rndg_cd_o =>ben_clf_shd.g_old_rec.rndg_cd
310: ,p_rndg_rl_o =>ben_clf_shd.g_old_rec.rndg_rl
311: ,p_bnfts_bal_id_o =>ben_clf_shd.g_old_rec.bnfts_bal_id
312: ,p_comp_alt_val_to_use_cd_o =>ben_clf_shd.g_old_rec.comp_alt_val_to_use_cd
313: ,p_comp_calc_rl_o =>ben_clf_shd.g_old_rec.comp_calc_rl
314: , p_proration_flag_o =>ben_clf_shd.g_old_rec.proration_flag
307: ,p_mx_comp_val_o =>ben_clf_shd.g_old_rec.mx_comp_val
308: ,p_mn_comp_val_o =>ben_clf_shd.g_old_rec.mn_comp_val
309: ,p_rndg_cd_o =>ben_clf_shd.g_old_rec.rndg_cd
310: ,p_rndg_rl_o =>ben_clf_shd.g_old_rec.rndg_rl
311: ,p_bnfts_bal_id_o =>ben_clf_shd.g_old_rec.bnfts_bal_id
312: ,p_comp_alt_val_to_use_cd_o =>ben_clf_shd.g_old_rec.comp_alt_val_to_use_cd
313: ,p_comp_calc_rl_o =>ben_clf_shd.g_old_rec.comp_calc_rl
314: , p_proration_flag_o =>ben_clf_shd.g_old_rec.proration_flag
315: , p_start_day_mo_o =>ben_clf_shd.g_old_rec.start_day_mo
308: ,p_mn_comp_val_o =>ben_clf_shd.g_old_rec.mn_comp_val
309: ,p_rndg_cd_o =>ben_clf_shd.g_old_rec.rndg_cd
310: ,p_rndg_rl_o =>ben_clf_shd.g_old_rec.rndg_rl
311: ,p_bnfts_bal_id_o =>ben_clf_shd.g_old_rec.bnfts_bal_id
312: ,p_comp_alt_val_to_use_cd_o =>ben_clf_shd.g_old_rec.comp_alt_val_to_use_cd
313: ,p_comp_calc_rl_o =>ben_clf_shd.g_old_rec.comp_calc_rl
314: , p_proration_flag_o =>ben_clf_shd.g_old_rec.proration_flag
315: , p_start_day_mo_o =>ben_clf_shd.g_old_rec.start_day_mo
316: , p_end_day_mo_o =>ben_clf_shd.g_old_rec.end_day_mo
309: ,p_rndg_cd_o =>ben_clf_shd.g_old_rec.rndg_cd
310: ,p_rndg_rl_o =>ben_clf_shd.g_old_rec.rndg_rl
311: ,p_bnfts_bal_id_o =>ben_clf_shd.g_old_rec.bnfts_bal_id
312: ,p_comp_alt_val_to_use_cd_o =>ben_clf_shd.g_old_rec.comp_alt_val_to_use_cd
313: ,p_comp_calc_rl_o =>ben_clf_shd.g_old_rec.comp_calc_rl
314: , p_proration_flag_o =>ben_clf_shd.g_old_rec.proration_flag
315: , p_start_day_mo_o =>ben_clf_shd.g_old_rec.start_day_mo
316: , p_end_day_mo_o =>ben_clf_shd.g_old_rec.end_day_mo
317: , p_start_year_o =>ben_clf_shd.g_old_rec.start_year
310: ,p_rndg_rl_o =>ben_clf_shd.g_old_rec.rndg_rl
311: ,p_bnfts_bal_id_o =>ben_clf_shd.g_old_rec.bnfts_bal_id
312: ,p_comp_alt_val_to_use_cd_o =>ben_clf_shd.g_old_rec.comp_alt_val_to_use_cd
313: ,p_comp_calc_rl_o =>ben_clf_shd.g_old_rec.comp_calc_rl
314: , p_proration_flag_o =>ben_clf_shd.g_old_rec.proration_flag
315: , p_start_day_mo_o =>ben_clf_shd.g_old_rec.start_day_mo
316: , p_end_day_mo_o =>ben_clf_shd.g_old_rec.end_day_mo
317: , p_start_year_o =>ben_clf_shd.g_old_rec.start_year
318: , p_end_year_o =>ben_clf_shd.g_old_rec.end_year
311: ,p_bnfts_bal_id_o =>ben_clf_shd.g_old_rec.bnfts_bal_id
312: ,p_comp_alt_val_to_use_cd_o =>ben_clf_shd.g_old_rec.comp_alt_val_to_use_cd
313: ,p_comp_calc_rl_o =>ben_clf_shd.g_old_rec.comp_calc_rl
314: , p_proration_flag_o =>ben_clf_shd.g_old_rec.proration_flag
315: , p_start_day_mo_o =>ben_clf_shd.g_old_rec.start_day_mo
316: , p_end_day_mo_o =>ben_clf_shd.g_old_rec.end_day_mo
317: , p_start_year_o =>ben_clf_shd.g_old_rec.start_year
318: , p_end_year_o =>ben_clf_shd.g_old_rec.end_year
319: ,p_clf_attribute_category_o =>ben_clf_shd.g_old_rec.clf_attribute_category
312: ,p_comp_alt_val_to_use_cd_o =>ben_clf_shd.g_old_rec.comp_alt_val_to_use_cd
313: ,p_comp_calc_rl_o =>ben_clf_shd.g_old_rec.comp_calc_rl
314: , p_proration_flag_o =>ben_clf_shd.g_old_rec.proration_flag
315: , p_start_day_mo_o =>ben_clf_shd.g_old_rec.start_day_mo
316: , p_end_day_mo_o =>ben_clf_shd.g_old_rec.end_day_mo
317: , p_start_year_o =>ben_clf_shd.g_old_rec.start_year
318: , p_end_year_o =>ben_clf_shd.g_old_rec.end_year
319: ,p_clf_attribute_category_o =>ben_clf_shd.g_old_rec.clf_attribute_category
320: ,p_clf_attribute1_o =>ben_clf_shd.g_old_rec.clf_attribute1
313: ,p_comp_calc_rl_o =>ben_clf_shd.g_old_rec.comp_calc_rl
314: , p_proration_flag_o =>ben_clf_shd.g_old_rec.proration_flag
315: , p_start_day_mo_o =>ben_clf_shd.g_old_rec.start_day_mo
316: , p_end_day_mo_o =>ben_clf_shd.g_old_rec.end_day_mo
317: , p_start_year_o =>ben_clf_shd.g_old_rec.start_year
318: , p_end_year_o =>ben_clf_shd.g_old_rec.end_year
319: ,p_clf_attribute_category_o =>ben_clf_shd.g_old_rec.clf_attribute_category
320: ,p_clf_attribute1_o =>ben_clf_shd.g_old_rec.clf_attribute1
321: ,p_clf_attribute2_o =>ben_clf_shd.g_old_rec.clf_attribute2
314: , p_proration_flag_o =>ben_clf_shd.g_old_rec.proration_flag
315: , p_start_day_mo_o =>ben_clf_shd.g_old_rec.start_day_mo
316: , p_end_day_mo_o =>ben_clf_shd.g_old_rec.end_day_mo
317: , p_start_year_o =>ben_clf_shd.g_old_rec.start_year
318: , p_end_year_o =>ben_clf_shd.g_old_rec.end_year
319: ,p_clf_attribute_category_o =>ben_clf_shd.g_old_rec.clf_attribute_category
320: ,p_clf_attribute1_o =>ben_clf_shd.g_old_rec.clf_attribute1
321: ,p_clf_attribute2_o =>ben_clf_shd.g_old_rec.clf_attribute2
322: ,p_clf_attribute3_o =>ben_clf_shd.g_old_rec.clf_attribute3
315: , p_start_day_mo_o =>ben_clf_shd.g_old_rec.start_day_mo
316: , p_end_day_mo_o =>ben_clf_shd.g_old_rec.end_day_mo
317: , p_start_year_o =>ben_clf_shd.g_old_rec.start_year
318: , p_end_year_o =>ben_clf_shd.g_old_rec.end_year
319: ,p_clf_attribute_category_o =>ben_clf_shd.g_old_rec.clf_attribute_category
320: ,p_clf_attribute1_o =>ben_clf_shd.g_old_rec.clf_attribute1
321: ,p_clf_attribute2_o =>ben_clf_shd.g_old_rec.clf_attribute2
322: ,p_clf_attribute3_o =>ben_clf_shd.g_old_rec.clf_attribute3
323: ,p_clf_attribute4_o =>ben_clf_shd.g_old_rec.clf_attribute4
316: , p_end_day_mo_o =>ben_clf_shd.g_old_rec.end_day_mo
317: , p_start_year_o =>ben_clf_shd.g_old_rec.start_year
318: , p_end_year_o =>ben_clf_shd.g_old_rec.end_year
319: ,p_clf_attribute_category_o =>ben_clf_shd.g_old_rec.clf_attribute_category
320: ,p_clf_attribute1_o =>ben_clf_shd.g_old_rec.clf_attribute1
321: ,p_clf_attribute2_o =>ben_clf_shd.g_old_rec.clf_attribute2
322: ,p_clf_attribute3_o =>ben_clf_shd.g_old_rec.clf_attribute3
323: ,p_clf_attribute4_o =>ben_clf_shd.g_old_rec.clf_attribute4
324: ,p_clf_attribute5_o =>ben_clf_shd.g_old_rec.clf_attribute5
317: , p_start_year_o =>ben_clf_shd.g_old_rec.start_year
318: , p_end_year_o =>ben_clf_shd.g_old_rec.end_year
319: ,p_clf_attribute_category_o =>ben_clf_shd.g_old_rec.clf_attribute_category
320: ,p_clf_attribute1_o =>ben_clf_shd.g_old_rec.clf_attribute1
321: ,p_clf_attribute2_o =>ben_clf_shd.g_old_rec.clf_attribute2
322: ,p_clf_attribute3_o =>ben_clf_shd.g_old_rec.clf_attribute3
323: ,p_clf_attribute4_o =>ben_clf_shd.g_old_rec.clf_attribute4
324: ,p_clf_attribute5_o =>ben_clf_shd.g_old_rec.clf_attribute5
325: ,p_clf_attribute6_o =>ben_clf_shd.g_old_rec.clf_attribute6
318: , p_end_year_o =>ben_clf_shd.g_old_rec.end_year
319: ,p_clf_attribute_category_o =>ben_clf_shd.g_old_rec.clf_attribute_category
320: ,p_clf_attribute1_o =>ben_clf_shd.g_old_rec.clf_attribute1
321: ,p_clf_attribute2_o =>ben_clf_shd.g_old_rec.clf_attribute2
322: ,p_clf_attribute3_o =>ben_clf_shd.g_old_rec.clf_attribute3
323: ,p_clf_attribute4_o =>ben_clf_shd.g_old_rec.clf_attribute4
324: ,p_clf_attribute5_o =>ben_clf_shd.g_old_rec.clf_attribute5
325: ,p_clf_attribute6_o =>ben_clf_shd.g_old_rec.clf_attribute6
326: ,p_clf_attribute7_o =>ben_clf_shd.g_old_rec.clf_attribute7
319: ,p_clf_attribute_category_o =>ben_clf_shd.g_old_rec.clf_attribute_category
320: ,p_clf_attribute1_o =>ben_clf_shd.g_old_rec.clf_attribute1
321: ,p_clf_attribute2_o =>ben_clf_shd.g_old_rec.clf_attribute2
322: ,p_clf_attribute3_o =>ben_clf_shd.g_old_rec.clf_attribute3
323: ,p_clf_attribute4_o =>ben_clf_shd.g_old_rec.clf_attribute4
324: ,p_clf_attribute5_o =>ben_clf_shd.g_old_rec.clf_attribute5
325: ,p_clf_attribute6_o =>ben_clf_shd.g_old_rec.clf_attribute6
326: ,p_clf_attribute7_o =>ben_clf_shd.g_old_rec.clf_attribute7
327: ,p_clf_attribute8_o =>ben_clf_shd.g_old_rec.clf_attribute8
320: ,p_clf_attribute1_o =>ben_clf_shd.g_old_rec.clf_attribute1
321: ,p_clf_attribute2_o =>ben_clf_shd.g_old_rec.clf_attribute2
322: ,p_clf_attribute3_o =>ben_clf_shd.g_old_rec.clf_attribute3
323: ,p_clf_attribute4_o =>ben_clf_shd.g_old_rec.clf_attribute4
324: ,p_clf_attribute5_o =>ben_clf_shd.g_old_rec.clf_attribute5
325: ,p_clf_attribute6_o =>ben_clf_shd.g_old_rec.clf_attribute6
326: ,p_clf_attribute7_o =>ben_clf_shd.g_old_rec.clf_attribute7
327: ,p_clf_attribute8_o =>ben_clf_shd.g_old_rec.clf_attribute8
328: ,p_clf_attribute9_o =>ben_clf_shd.g_old_rec.clf_attribute9
321: ,p_clf_attribute2_o =>ben_clf_shd.g_old_rec.clf_attribute2
322: ,p_clf_attribute3_o =>ben_clf_shd.g_old_rec.clf_attribute3
323: ,p_clf_attribute4_o =>ben_clf_shd.g_old_rec.clf_attribute4
324: ,p_clf_attribute5_o =>ben_clf_shd.g_old_rec.clf_attribute5
325: ,p_clf_attribute6_o =>ben_clf_shd.g_old_rec.clf_attribute6
326: ,p_clf_attribute7_o =>ben_clf_shd.g_old_rec.clf_attribute7
327: ,p_clf_attribute8_o =>ben_clf_shd.g_old_rec.clf_attribute8
328: ,p_clf_attribute9_o =>ben_clf_shd.g_old_rec.clf_attribute9
329: ,p_clf_attribute10_o =>ben_clf_shd.g_old_rec.clf_attribute10
322: ,p_clf_attribute3_o =>ben_clf_shd.g_old_rec.clf_attribute3
323: ,p_clf_attribute4_o =>ben_clf_shd.g_old_rec.clf_attribute4
324: ,p_clf_attribute5_o =>ben_clf_shd.g_old_rec.clf_attribute5
325: ,p_clf_attribute6_o =>ben_clf_shd.g_old_rec.clf_attribute6
326: ,p_clf_attribute7_o =>ben_clf_shd.g_old_rec.clf_attribute7
327: ,p_clf_attribute8_o =>ben_clf_shd.g_old_rec.clf_attribute8
328: ,p_clf_attribute9_o =>ben_clf_shd.g_old_rec.clf_attribute9
329: ,p_clf_attribute10_o =>ben_clf_shd.g_old_rec.clf_attribute10
330: ,p_clf_attribute11_o =>ben_clf_shd.g_old_rec.clf_attribute11
323: ,p_clf_attribute4_o =>ben_clf_shd.g_old_rec.clf_attribute4
324: ,p_clf_attribute5_o =>ben_clf_shd.g_old_rec.clf_attribute5
325: ,p_clf_attribute6_o =>ben_clf_shd.g_old_rec.clf_attribute6
326: ,p_clf_attribute7_o =>ben_clf_shd.g_old_rec.clf_attribute7
327: ,p_clf_attribute8_o =>ben_clf_shd.g_old_rec.clf_attribute8
328: ,p_clf_attribute9_o =>ben_clf_shd.g_old_rec.clf_attribute9
329: ,p_clf_attribute10_o =>ben_clf_shd.g_old_rec.clf_attribute10
330: ,p_clf_attribute11_o =>ben_clf_shd.g_old_rec.clf_attribute11
331: ,p_clf_attribute12_o =>ben_clf_shd.g_old_rec.clf_attribute12
324: ,p_clf_attribute5_o =>ben_clf_shd.g_old_rec.clf_attribute5
325: ,p_clf_attribute6_o =>ben_clf_shd.g_old_rec.clf_attribute6
326: ,p_clf_attribute7_o =>ben_clf_shd.g_old_rec.clf_attribute7
327: ,p_clf_attribute8_o =>ben_clf_shd.g_old_rec.clf_attribute8
328: ,p_clf_attribute9_o =>ben_clf_shd.g_old_rec.clf_attribute9
329: ,p_clf_attribute10_o =>ben_clf_shd.g_old_rec.clf_attribute10
330: ,p_clf_attribute11_o =>ben_clf_shd.g_old_rec.clf_attribute11
331: ,p_clf_attribute12_o =>ben_clf_shd.g_old_rec.clf_attribute12
332: ,p_clf_attribute13_o =>ben_clf_shd.g_old_rec.clf_attribute13
325: ,p_clf_attribute6_o =>ben_clf_shd.g_old_rec.clf_attribute6
326: ,p_clf_attribute7_o =>ben_clf_shd.g_old_rec.clf_attribute7
327: ,p_clf_attribute8_o =>ben_clf_shd.g_old_rec.clf_attribute8
328: ,p_clf_attribute9_o =>ben_clf_shd.g_old_rec.clf_attribute9
329: ,p_clf_attribute10_o =>ben_clf_shd.g_old_rec.clf_attribute10
330: ,p_clf_attribute11_o =>ben_clf_shd.g_old_rec.clf_attribute11
331: ,p_clf_attribute12_o =>ben_clf_shd.g_old_rec.clf_attribute12
332: ,p_clf_attribute13_o =>ben_clf_shd.g_old_rec.clf_attribute13
333: ,p_clf_attribute14_o =>ben_clf_shd.g_old_rec.clf_attribute14
326: ,p_clf_attribute7_o =>ben_clf_shd.g_old_rec.clf_attribute7
327: ,p_clf_attribute8_o =>ben_clf_shd.g_old_rec.clf_attribute8
328: ,p_clf_attribute9_o =>ben_clf_shd.g_old_rec.clf_attribute9
329: ,p_clf_attribute10_o =>ben_clf_shd.g_old_rec.clf_attribute10
330: ,p_clf_attribute11_o =>ben_clf_shd.g_old_rec.clf_attribute11
331: ,p_clf_attribute12_o =>ben_clf_shd.g_old_rec.clf_attribute12
332: ,p_clf_attribute13_o =>ben_clf_shd.g_old_rec.clf_attribute13
333: ,p_clf_attribute14_o =>ben_clf_shd.g_old_rec.clf_attribute14
334: ,p_clf_attribute15_o =>ben_clf_shd.g_old_rec.clf_attribute15
327: ,p_clf_attribute8_o =>ben_clf_shd.g_old_rec.clf_attribute8
328: ,p_clf_attribute9_o =>ben_clf_shd.g_old_rec.clf_attribute9
329: ,p_clf_attribute10_o =>ben_clf_shd.g_old_rec.clf_attribute10
330: ,p_clf_attribute11_o =>ben_clf_shd.g_old_rec.clf_attribute11
331: ,p_clf_attribute12_o =>ben_clf_shd.g_old_rec.clf_attribute12
332: ,p_clf_attribute13_o =>ben_clf_shd.g_old_rec.clf_attribute13
333: ,p_clf_attribute14_o =>ben_clf_shd.g_old_rec.clf_attribute14
334: ,p_clf_attribute15_o =>ben_clf_shd.g_old_rec.clf_attribute15
335: ,p_clf_attribute16_o =>ben_clf_shd.g_old_rec.clf_attribute16
328: ,p_clf_attribute9_o =>ben_clf_shd.g_old_rec.clf_attribute9
329: ,p_clf_attribute10_o =>ben_clf_shd.g_old_rec.clf_attribute10
330: ,p_clf_attribute11_o =>ben_clf_shd.g_old_rec.clf_attribute11
331: ,p_clf_attribute12_o =>ben_clf_shd.g_old_rec.clf_attribute12
332: ,p_clf_attribute13_o =>ben_clf_shd.g_old_rec.clf_attribute13
333: ,p_clf_attribute14_o =>ben_clf_shd.g_old_rec.clf_attribute14
334: ,p_clf_attribute15_o =>ben_clf_shd.g_old_rec.clf_attribute15
335: ,p_clf_attribute16_o =>ben_clf_shd.g_old_rec.clf_attribute16
336: ,p_clf_attribute17_o =>ben_clf_shd.g_old_rec.clf_attribute17
329: ,p_clf_attribute10_o =>ben_clf_shd.g_old_rec.clf_attribute10
330: ,p_clf_attribute11_o =>ben_clf_shd.g_old_rec.clf_attribute11
331: ,p_clf_attribute12_o =>ben_clf_shd.g_old_rec.clf_attribute12
332: ,p_clf_attribute13_o =>ben_clf_shd.g_old_rec.clf_attribute13
333: ,p_clf_attribute14_o =>ben_clf_shd.g_old_rec.clf_attribute14
334: ,p_clf_attribute15_o =>ben_clf_shd.g_old_rec.clf_attribute15
335: ,p_clf_attribute16_o =>ben_clf_shd.g_old_rec.clf_attribute16
336: ,p_clf_attribute17_o =>ben_clf_shd.g_old_rec.clf_attribute17
337: ,p_clf_attribute18_o =>ben_clf_shd.g_old_rec.clf_attribute18
330: ,p_clf_attribute11_o =>ben_clf_shd.g_old_rec.clf_attribute11
331: ,p_clf_attribute12_o =>ben_clf_shd.g_old_rec.clf_attribute12
332: ,p_clf_attribute13_o =>ben_clf_shd.g_old_rec.clf_attribute13
333: ,p_clf_attribute14_o =>ben_clf_shd.g_old_rec.clf_attribute14
334: ,p_clf_attribute15_o =>ben_clf_shd.g_old_rec.clf_attribute15
335: ,p_clf_attribute16_o =>ben_clf_shd.g_old_rec.clf_attribute16
336: ,p_clf_attribute17_o =>ben_clf_shd.g_old_rec.clf_attribute17
337: ,p_clf_attribute18_o =>ben_clf_shd.g_old_rec.clf_attribute18
338: ,p_clf_attribute19_o =>ben_clf_shd.g_old_rec.clf_attribute19
331: ,p_clf_attribute12_o =>ben_clf_shd.g_old_rec.clf_attribute12
332: ,p_clf_attribute13_o =>ben_clf_shd.g_old_rec.clf_attribute13
333: ,p_clf_attribute14_o =>ben_clf_shd.g_old_rec.clf_attribute14
334: ,p_clf_attribute15_o =>ben_clf_shd.g_old_rec.clf_attribute15
335: ,p_clf_attribute16_o =>ben_clf_shd.g_old_rec.clf_attribute16
336: ,p_clf_attribute17_o =>ben_clf_shd.g_old_rec.clf_attribute17
337: ,p_clf_attribute18_o =>ben_clf_shd.g_old_rec.clf_attribute18
338: ,p_clf_attribute19_o =>ben_clf_shd.g_old_rec.clf_attribute19
339: ,p_clf_attribute20_o =>ben_clf_shd.g_old_rec.clf_attribute20
332: ,p_clf_attribute13_o =>ben_clf_shd.g_old_rec.clf_attribute13
333: ,p_clf_attribute14_o =>ben_clf_shd.g_old_rec.clf_attribute14
334: ,p_clf_attribute15_o =>ben_clf_shd.g_old_rec.clf_attribute15
335: ,p_clf_attribute16_o =>ben_clf_shd.g_old_rec.clf_attribute16
336: ,p_clf_attribute17_o =>ben_clf_shd.g_old_rec.clf_attribute17
337: ,p_clf_attribute18_o =>ben_clf_shd.g_old_rec.clf_attribute18
338: ,p_clf_attribute19_o =>ben_clf_shd.g_old_rec.clf_attribute19
339: ,p_clf_attribute20_o =>ben_clf_shd.g_old_rec.clf_attribute20
340: ,p_clf_attribute21_o =>ben_clf_shd.g_old_rec.clf_attribute21
333: ,p_clf_attribute14_o =>ben_clf_shd.g_old_rec.clf_attribute14
334: ,p_clf_attribute15_o =>ben_clf_shd.g_old_rec.clf_attribute15
335: ,p_clf_attribute16_o =>ben_clf_shd.g_old_rec.clf_attribute16
336: ,p_clf_attribute17_o =>ben_clf_shd.g_old_rec.clf_attribute17
337: ,p_clf_attribute18_o =>ben_clf_shd.g_old_rec.clf_attribute18
338: ,p_clf_attribute19_o =>ben_clf_shd.g_old_rec.clf_attribute19
339: ,p_clf_attribute20_o =>ben_clf_shd.g_old_rec.clf_attribute20
340: ,p_clf_attribute21_o =>ben_clf_shd.g_old_rec.clf_attribute21
341: ,p_clf_attribute22_o =>ben_clf_shd.g_old_rec.clf_attribute22
334: ,p_clf_attribute15_o =>ben_clf_shd.g_old_rec.clf_attribute15
335: ,p_clf_attribute16_o =>ben_clf_shd.g_old_rec.clf_attribute16
336: ,p_clf_attribute17_o =>ben_clf_shd.g_old_rec.clf_attribute17
337: ,p_clf_attribute18_o =>ben_clf_shd.g_old_rec.clf_attribute18
338: ,p_clf_attribute19_o =>ben_clf_shd.g_old_rec.clf_attribute19
339: ,p_clf_attribute20_o =>ben_clf_shd.g_old_rec.clf_attribute20
340: ,p_clf_attribute21_o =>ben_clf_shd.g_old_rec.clf_attribute21
341: ,p_clf_attribute22_o =>ben_clf_shd.g_old_rec.clf_attribute22
342: ,p_clf_attribute23_o =>ben_clf_shd.g_old_rec.clf_attribute23
335: ,p_clf_attribute16_o =>ben_clf_shd.g_old_rec.clf_attribute16
336: ,p_clf_attribute17_o =>ben_clf_shd.g_old_rec.clf_attribute17
337: ,p_clf_attribute18_o =>ben_clf_shd.g_old_rec.clf_attribute18
338: ,p_clf_attribute19_o =>ben_clf_shd.g_old_rec.clf_attribute19
339: ,p_clf_attribute20_o =>ben_clf_shd.g_old_rec.clf_attribute20
340: ,p_clf_attribute21_o =>ben_clf_shd.g_old_rec.clf_attribute21
341: ,p_clf_attribute22_o =>ben_clf_shd.g_old_rec.clf_attribute22
342: ,p_clf_attribute23_o =>ben_clf_shd.g_old_rec.clf_attribute23
343: ,p_clf_attribute24_o =>ben_clf_shd.g_old_rec.clf_attribute24
336: ,p_clf_attribute17_o =>ben_clf_shd.g_old_rec.clf_attribute17
337: ,p_clf_attribute18_o =>ben_clf_shd.g_old_rec.clf_attribute18
338: ,p_clf_attribute19_o =>ben_clf_shd.g_old_rec.clf_attribute19
339: ,p_clf_attribute20_o =>ben_clf_shd.g_old_rec.clf_attribute20
340: ,p_clf_attribute21_o =>ben_clf_shd.g_old_rec.clf_attribute21
341: ,p_clf_attribute22_o =>ben_clf_shd.g_old_rec.clf_attribute22
342: ,p_clf_attribute23_o =>ben_clf_shd.g_old_rec.clf_attribute23
343: ,p_clf_attribute24_o =>ben_clf_shd.g_old_rec.clf_attribute24
344: ,p_clf_attribute25_o =>ben_clf_shd.g_old_rec.clf_attribute25
337: ,p_clf_attribute18_o =>ben_clf_shd.g_old_rec.clf_attribute18
338: ,p_clf_attribute19_o =>ben_clf_shd.g_old_rec.clf_attribute19
339: ,p_clf_attribute20_o =>ben_clf_shd.g_old_rec.clf_attribute20
340: ,p_clf_attribute21_o =>ben_clf_shd.g_old_rec.clf_attribute21
341: ,p_clf_attribute22_o =>ben_clf_shd.g_old_rec.clf_attribute22
342: ,p_clf_attribute23_o =>ben_clf_shd.g_old_rec.clf_attribute23
343: ,p_clf_attribute24_o =>ben_clf_shd.g_old_rec.clf_attribute24
344: ,p_clf_attribute25_o =>ben_clf_shd.g_old_rec.clf_attribute25
345: ,p_clf_attribute26_o =>ben_clf_shd.g_old_rec.clf_attribute26
338: ,p_clf_attribute19_o =>ben_clf_shd.g_old_rec.clf_attribute19
339: ,p_clf_attribute20_o =>ben_clf_shd.g_old_rec.clf_attribute20
340: ,p_clf_attribute21_o =>ben_clf_shd.g_old_rec.clf_attribute21
341: ,p_clf_attribute22_o =>ben_clf_shd.g_old_rec.clf_attribute22
342: ,p_clf_attribute23_o =>ben_clf_shd.g_old_rec.clf_attribute23
343: ,p_clf_attribute24_o =>ben_clf_shd.g_old_rec.clf_attribute24
344: ,p_clf_attribute25_o =>ben_clf_shd.g_old_rec.clf_attribute25
345: ,p_clf_attribute26_o =>ben_clf_shd.g_old_rec.clf_attribute26
346: ,p_clf_attribute27_o =>ben_clf_shd.g_old_rec.clf_attribute27
339: ,p_clf_attribute20_o =>ben_clf_shd.g_old_rec.clf_attribute20
340: ,p_clf_attribute21_o =>ben_clf_shd.g_old_rec.clf_attribute21
341: ,p_clf_attribute22_o =>ben_clf_shd.g_old_rec.clf_attribute22
342: ,p_clf_attribute23_o =>ben_clf_shd.g_old_rec.clf_attribute23
343: ,p_clf_attribute24_o =>ben_clf_shd.g_old_rec.clf_attribute24
344: ,p_clf_attribute25_o =>ben_clf_shd.g_old_rec.clf_attribute25
345: ,p_clf_attribute26_o =>ben_clf_shd.g_old_rec.clf_attribute26
346: ,p_clf_attribute27_o =>ben_clf_shd.g_old_rec.clf_attribute27
347: ,p_clf_attribute28_o =>ben_clf_shd.g_old_rec.clf_attribute28
340: ,p_clf_attribute21_o =>ben_clf_shd.g_old_rec.clf_attribute21
341: ,p_clf_attribute22_o =>ben_clf_shd.g_old_rec.clf_attribute22
342: ,p_clf_attribute23_o =>ben_clf_shd.g_old_rec.clf_attribute23
343: ,p_clf_attribute24_o =>ben_clf_shd.g_old_rec.clf_attribute24
344: ,p_clf_attribute25_o =>ben_clf_shd.g_old_rec.clf_attribute25
345: ,p_clf_attribute26_o =>ben_clf_shd.g_old_rec.clf_attribute26
346: ,p_clf_attribute27_o =>ben_clf_shd.g_old_rec.clf_attribute27
347: ,p_clf_attribute28_o =>ben_clf_shd.g_old_rec.clf_attribute28
348: ,p_clf_attribute29_o =>ben_clf_shd.g_old_rec.clf_attribute29
341: ,p_clf_attribute22_o =>ben_clf_shd.g_old_rec.clf_attribute22
342: ,p_clf_attribute23_o =>ben_clf_shd.g_old_rec.clf_attribute23
343: ,p_clf_attribute24_o =>ben_clf_shd.g_old_rec.clf_attribute24
344: ,p_clf_attribute25_o =>ben_clf_shd.g_old_rec.clf_attribute25
345: ,p_clf_attribute26_o =>ben_clf_shd.g_old_rec.clf_attribute26
346: ,p_clf_attribute27_o =>ben_clf_shd.g_old_rec.clf_attribute27
347: ,p_clf_attribute28_o =>ben_clf_shd.g_old_rec.clf_attribute28
348: ,p_clf_attribute29_o =>ben_clf_shd.g_old_rec.clf_attribute29
349: ,p_clf_attribute30_o =>ben_clf_shd.g_old_rec.clf_attribute30
342: ,p_clf_attribute23_o =>ben_clf_shd.g_old_rec.clf_attribute23
343: ,p_clf_attribute24_o =>ben_clf_shd.g_old_rec.clf_attribute24
344: ,p_clf_attribute25_o =>ben_clf_shd.g_old_rec.clf_attribute25
345: ,p_clf_attribute26_o =>ben_clf_shd.g_old_rec.clf_attribute26
346: ,p_clf_attribute27_o =>ben_clf_shd.g_old_rec.clf_attribute27
347: ,p_clf_attribute28_o =>ben_clf_shd.g_old_rec.clf_attribute28
348: ,p_clf_attribute29_o =>ben_clf_shd.g_old_rec.clf_attribute29
349: ,p_clf_attribute30_o =>ben_clf_shd.g_old_rec.clf_attribute30
350: ,p_object_version_number_o =>ben_clf_shd.g_old_rec.object_version_number
343: ,p_clf_attribute24_o =>ben_clf_shd.g_old_rec.clf_attribute24
344: ,p_clf_attribute25_o =>ben_clf_shd.g_old_rec.clf_attribute25
345: ,p_clf_attribute26_o =>ben_clf_shd.g_old_rec.clf_attribute26
346: ,p_clf_attribute27_o =>ben_clf_shd.g_old_rec.clf_attribute27
347: ,p_clf_attribute28_o =>ben_clf_shd.g_old_rec.clf_attribute28
348: ,p_clf_attribute29_o =>ben_clf_shd.g_old_rec.clf_attribute29
349: ,p_clf_attribute30_o =>ben_clf_shd.g_old_rec.clf_attribute30
350: ,p_object_version_number_o =>ben_clf_shd.g_old_rec.object_version_number
351: ,p_sttd_sal_prdcty_cd_o =>ben_clf_shd.g_old_rec.sttd_sal_prdcty_cd
344: ,p_clf_attribute25_o =>ben_clf_shd.g_old_rec.clf_attribute25
345: ,p_clf_attribute26_o =>ben_clf_shd.g_old_rec.clf_attribute26
346: ,p_clf_attribute27_o =>ben_clf_shd.g_old_rec.clf_attribute27
347: ,p_clf_attribute28_o =>ben_clf_shd.g_old_rec.clf_attribute28
348: ,p_clf_attribute29_o =>ben_clf_shd.g_old_rec.clf_attribute29
349: ,p_clf_attribute30_o =>ben_clf_shd.g_old_rec.clf_attribute30
350: ,p_object_version_number_o =>ben_clf_shd.g_old_rec.object_version_number
351: ,p_sttd_sal_prdcty_cd_o =>ben_clf_shd.g_old_rec.sttd_sal_prdcty_cd
352: );
345: ,p_clf_attribute26_o =>ben_clf_shd.g_old_rec.clf_attribute26
346: ,p_clf_attribute27_o =>ben_clf_shd.g_old_rec.clf_attribute27
347: ,p_clf_attribute28_o =>ben_clf_shd.g_old_rec.clf_attribute28
348: ,p_clf_attribute29_o =>ben_clf_shd.g_old_rec.clf_attribute29
349: ,p_clf_attribute30_o =>ben_clf_shd.g_old_rec.clf_attribute30
350: ,p_object_version_number_o =>ben_clf_shd.g_old_rec.object_version_number
351: ,p_sttd_sal_prdcty_cd_o =>ben_clf_shd.g_old_rec.sttd_sal_prdcty_cd
352: );
353: --
346: ,p_clf_attribute27_o =>ben_clf_shd.g_old_rec.clf_attribute27
347: ,p_clf_attribute28_o =>ben_clf_shd.g_old_rec.clf_attribute28
348: ,p_clf_attribute29_o =>ben_clf_shd.g_old_rec.clf_attribute29
349: ,p_clf_attribute30_o =>ben_clf_shd.g_old_rec.clf_attribute30
350: ,p_object_version_number_o =>ben_clf_shd.g_old_rec.object_version_number
351: ,p_sttd_sal_prdcty_cd_o =>ben_clf_shd.g_old_rec.sttd_sal_prdcty_cd
352: );
353: --
354: exception
347: ,p_clf_attribute28_o =>ben_clf_shd.g_old_rec.clf_attribute28
348: ,p_clf_attribute29_o =>ben_clf_shd.g_old_rec.clf_attribute29
349: ,p_clf_attribute30_o =>ben_clf_shd.g_old_rec.clf_attribute30
350: ,p_object_version_number_o =>ben_clf_shd.g_old_rec.object_version_number
351: ,p_sttd_sal_prdcty_cd_o =>ben_clf_shd.g_old_rec.sttd_sal_prdcty_cd
352: );
353: --
354: exception
355: --
409: -- Internal Row Handler Use Only.
410: --
411: -- {End Of Comments}
412: -- ----------------------------------------------------------------------------
413: Procedure convert_defs(p_rec in out nocopy ben_clf_shd.g_rec_type) is
414: --
415: l_proc varchar2(72) := g_package||'convert_defs';
416: --
417: Begin
424: -- is being used then we must set to the 'current' argument value.
425: --
426: If (p_rec.business_group_id = hr_api.g_number) then
427: p_rec.business_group_id :=
428: ben_clf_shd.g_old_rec.business_group_id;
429: End If;
430: If (p_rec.name = hr_api.g_varchar2) then
431: p_rec.name :=
432: ben_clf_shd.g_old_rec.name;
428: ben_clf_shd.g_old_rec.business_group_id;
429: End If;
430: If (p_rec.name = hr_api.g_varchar2) then
431: p_rec.name :=
432: ben_clf_shd.g_old_rec.name;
433: End If;
434: If (p_rec.comp_lvl_det_cd = hr_api.g_varchar2) then
435: p_rec.comp_lvl_det_cd :=
436: ben_clf_shd.g_old_rec.comp_lvl_det_cd;
432: ben_clf_shd.g_old_rec.name;
433: End If;
434: If (p_rec.comp_lvl_det_cd = hr_api.g_varchar2) then
435: p_rec.comp_lvl_det_cd :=
436: ben_clf_shd.g_old_rec.comp_lvl_det_cd;
437: End If;
438: If (p_rec.comp_lvl_det_rl = hr_api.g_number) then
439: p_rec.comp_lvl_det_rl :=
440: ben_clf_shd.g_old_rec.comp_lvl_det_rl;
436: ben_clf_shd.g_old_rec.comp_lvl_det_cd;
437: End If;
438: If (p_rec.comp_lvl_det_rl = hr_api.g_number) then
439: p_rec.comp_lvl_det_rl :=
440: ben_clf_shd.g_old_rec.comp_lvl_det_rl;
441: End If;
442: If (p_rec.comp_lvl_uom = hr_api.g_varchar2) then
443: p_rec.comp_lvl_uom :=
444: ben_clf_shd.g_old_rec.comp_lvl_uom;
440: ben_clf_shd.g_old_rec.comp_lvl_det_rl;
441: End If;
442: If (p_rec.comp_lvl_uom = hr_api.g_varchar2) then
443: p_rec.comp_lvl_uom :=
444: ben_clf_shd.g_old_rec.comp_lvl_uom;
445: End If;
446: If (p_rec.comp_src_cd = hr_api.g_varchar2) then
447: p_rec.comp_src_cd :=
448: ben_clf_shd.g_old_rec.comp_src_cd;
444: ben_clf_shd.g_old_rec.comp_lvl_uom;
445: End If;
446: If (p_rec.comp_src_cd = hr_api.g_varchar2) then
447: p_rec.comp_src_cd :=
448: ben_clf_shd.g_old_rec.comp_src_cd;
449: End If;
450: If (p_rec.defined_balance_id = hr_api.g_number) then
451: p_rec.defined_balance_id :=
452: ben_clf_shd.g_old_rec.defined_balance_id;
448: ben_clf_shd.g_old_rec.comp_src_cd;
449: End If;
450: If (p_rec.defined_balance_id = hr_api.g_number) then
451: p_rec.defined_balance_id :=
452: ben_clf_shd.g_old_rec.defined_balance_id;
453: End If;
454: If (p_rec.no_mn_comp_flag = hr_api.g_varchar2) then
455: p_rec.no_mn_comp_flag :=
456: ben_clf_shd.g_old_rec.no_mn_comp_flag;
452: ben_clf_shd.g_old_rec.defined_balance_id;
453: End If;
454: If (p_rec.no_mn_comp_flag = hr_api.g_varchar2) then
455: p_rec.no_mn_comp_flag :=
456: ben_clf_shd.g_old_rec.no_mn_comp_flag;
457: End If;
458: If (p_rec.no_mx_comp_flag = hr_api.g_varchar2) then
459: p_rec.no_mx_comp_flag :=
460: ben_clf_shd.g_old_rec.no_mx_comp_flag;
456: ben_clf_shd.g_old_rec.no_mn_comp_flag;
457: End If;
458: If (p_rec.no_mx_comp_flag = hr_api.g_varchar2) then
459: p_rec.no_mx_comp_flag :=
460: ben_clf_shd.g_old_rec.no_mx_comp_flag;
461: End If;
462: If (p_rec.mx_comp_val = hr_api.g_number) then
463: p_rec.mx_comp_val :=
464: ben_clf_shd.g_old_rec.mx_comp_val;
460: ben_clf_shd.g_old_rec.no_mx_comp_flag;
461: End If;
462: If (p_rec.mx_comp_val = hr_api.g_number) then
463: p_rec.mx_comp_val :=
464: ben_clf_shd.g_old_rec.mx_comp_val;
465: End If;
466: If (p_rec.mn_comp_val = hr_api.g_number) then
467: p_rec.mn_comp_val :=
468: ben_clf_shd.g_old_rec.mn_comp_val;
464: ben_clf_shd.g_old_rec.mx_comp_val;
465: End If;
466: If (p_rec.mn_comp_val = hr_api.g_number) then
467: p_rec.mn_comp_val :=
468: ben_clf_shd.g_old_rec.mn_comp_val;
469: End If;
470: If (p_rec.rndg_cd = hr_api.g_varchar2) then
471: p_rec.rndg_cd :=
472: ben_clf_shd.g_old_rec.rndg_cd;
468: ben_clf_shd.g_old_rec.mn_comp_val;
469: End If;
470: If (p_rec.rndg_cd = hr_api.g_varchar2) then
471: p_rec.rndg_cd :=
472: ben_clf_shd.g_old_rec.rndg_cd;
473: End If;
474: If (p_rec.rndg_rl = hr_api.g_number) then
475: p_rec.rndg_rl :=
476: ben_clf_shd.g_old_rec.rndg_rl;
472: ben_clf_shd.g_old_rec.rndg_cd;
473: End If;
474: If (p_rec.rndg_rl = hr_api.g_number) then
475: p_rec.rndg_rl :=
476: ben_clf_shd.g_old_rec.rndg_rl;
477: End If;
478: If (p_rec.bnfts_bal_id = hr_api.g_number) then
479: p_rec.bnfts_bal_id :=
480: ben_clf_shd.g_old_rec.bnfts_bal_id;
476: ben_clf_shd.g_old_rec.rndg_rl;
477: End If;
478: If (p_rec.bnfts_bal_id = hr_api.g_number) then
479: p_rec.bnfts_bal_id :=
480: ben_clf_shd.g_old_rec.bnfts_bal_id;
481: End If;
482: If (p_rec.comp_alt_val_to_use_cd = hr_api.g_varchar2) then
483: p_rec.comp_alt_val_to_use_cd :=
484: ben_clf_shd.g_old_rec.comp_alt_val_to_use_cd;
480: ben_clf_shd.g_old_rec.bnfts_bal_id;
481: End If;
482: If (p_rec.comp_alt_val_to_use_cd = hr_api.g_varchar2) then
483: p_rec.comp_alt_val_to_use_cd :=
484: ben_clf_shd.g_old_rec.comp_alt_val_to_use_cd;
485: End If;
486: If (p_rec.comp_calc_rl = hr_api.g_number) then
487: p_rec.comp_calc_rl :=
488: ben_clf_shd.g_old_rec.comp_calc_rl;
484: ben_clf_shd.g_old_rec.comp_alt_val_to_use_cd;
485: End If;
486: If (p_rec.comp_calc_rl = hr_api.g_number) then
487: p_rec.comp_calc_rl :=
488: ben_clf_shd.g_old_rec.comp_calc_rl;
489: End If;
490:
491: If (p_rec.proration_flag = hr_api.g_varchar2) then
492: p_rec.proration_flag :=
489: End If;
490:
491: If (p_rec.proration_flag = hr_api.g_varchar2) then
492: p_rec.proration_flag :=
493: ben_clf_shd.g_old_rec.proration_flag;
494: End If;
495: If (p_rec.start_day_mo = hr_api.g_varchar2) then
496: p_rec.start_day_mo :=
497: ben_clf_shd.g_old_rec.start_day_mo;
493: ben_clf_shd.g_old_rec.proration_flag;
494: End If;
495: If (p_rec.start_day_mo = hr_api.g_varchar2) then
496: p_rec.start_day_mo :=
497: ben_clf_shd.g_old_rec.start_day_mo;
498: End If;
499: If (p_rec.end_day_mo = hr_api.g_varchar2) then
500: p_rec.end_day_mo :=
501: ben_clf_shd.g_old_rec.end_day_mo;
497: ben_clf_shd.g_old_rec.start_day_mo;
498: End If;
499: If (p_rec.end_day_mo = hr_api.g_varchar2) then
500: p_rec.end_day_mo :=
501: ben_clf_shd.g_old_rec.end_day_mo;
502: End If;
503: If (p_rec.start_year = hr_api.g_varchar2) then
504: p_rec.start_year :=
505: ben_clf_shd.g_old_rec.start_year;
501: ben_clf_shd.g_old_rec.end_day_mo;
502: End If;
503: If (p_rec.start_year = hr_api.g_varchar2) then
504: p_rec.start_year :=
505: ben_clf_shd.g_old_rec.start_year;
506: End If;
507: If (p_rec.end_year = hr_api.g_varchar2) then
508: p_rec.end_year :=
509: ben_clf_shd.g_old_rec.end_year;
505: ben_clf_shd.g_old_rec.start_year;
506: End If;
507: If (p_rec.end_year = hr_api.g_varchar2) then
508: p_rec.end_year :=
509: ben_clf_shd.g_old_rec.end_year;
510: End If;
511:
512: If (p_rec.clf_attribute_category = hr_api.g_varchar2) then
513: p_rec.clf_attribute_category :=
510: End If;
511:
512: If (p_rec.clf_attribute_category = hr_api.g_varchar2) then
513: p_rec.clf_attribute_category :=
514: ben_clf_shd.g_old_rec.clf_attribute_category;
515: End If;
516: If (p_rec.clf_attribute1 = hr_api.g_varchar2) then
517: p_rec.clf_attribute1 :=
518: ben_clf_shd.g_old_rec.clf_attribute1;
514: ben_clf_shd.g_old_rec.clf_attribute_category;
515: End If;
516: If (p_rec.clf_attribute1 = hr_api.g_varchar2) then
517: p_rec.clf_attribute1 :=
518: ben_clf_shd.g_old_rec.clf_attribute1;
519: End If;
520: If (p_rec.clf_attribute2 = hr_api.g_varchar2) then
521: p_rec.clf_attribute2 :=
522: ben_clf_shd.g_old_rec.clf_attribute2;
518: ben_clf_shd.g_old_rec.clf_attribute1;
519: End If;
520: If (p_rec.clf_attribute2 = hr_api.g_varchar2) then
521: p_rec.clf_attribute2 :=
522: ben_clf_shd.g_old_rec.clf_attribute2;
523: End If;
524: If (p_rec.clf_attribute3 = hr_api.g_varchar2) then
525: p_rec.clf_attribute3 :=
526: ben_clf_shd.g_old_rec.clf_attribute3;
522: ben_clf_shd.g_old_rec.clf_attribute2;
523: End If;
524: If (p_rec.clf_attribute3 = hr_api.g_varchar2) then
525: p_rec.clf_attribute3 :=
526: ben_clf_shd.g_old_rec.clf_attribute3;
527: End If;
528: If (p_rec.clf_attribute4 = hr_api.g_varchar2) then
529: p_rec.clf_attribute4 :=
530: ben_clf_shd.g_old_rec.clf_attribute4;
526: ben_clf_shd.g_old_rec.clf_attribute3;
527: End If;
528: If (p_rec.clf_attribute4 = hr_api.g_varchar2) then
529: p_rec.clf_attribute4 :=
530: ben_clf_shd.g_old_rec.clf_attribute4;
531: End If;
532: If (p_rec.clf_attribute5 = hr_api.g_varchar2) then
533: p_rec.clf_attribute5 :=
534: ben_clf_shd.g_old_rec.clf_attribute5;
530: ben_clf_shd.g_old_rec.clf_attribute4;
531: End If;
532: If (p_rec.clf_attribute5 = hr_api.g_varchar2) then
533: p_rec.clf_attribute5 :=
534: ben_clf_shd.g_old_rec.clf_attribute5;
535: End If;
536: If (p_rec.clf_attribute6 = hr_api.g_varchar2) then
537: p_rec.clf_attribute6 :=
538: ben_clf_shd.g_old_rec.clf_attribute6;
534: ben_clf_shd.g_old_rec.clf_attribute5;
535: End If;
536: If (p_rec.clf_attribute6 = hr_api.g_varchar2) then
537: p_rec.clf_attribute6 :=
538: ben_clf_shd.g_old_rec.clf_attribute6;
539: End If;
540: If (p_rec.clf_attribute7 = hr_api.g_varchar2) then
541: p_rec.clf_attribute7 :=
542: ben_clf_shd.g_old_rec.clf_attribute7;
538: ben_clf_shd.g_old_rec.clf_attribute6;
539: End If;
540: If (p_rec.clf_attribute7 = hr_api.g_varchar2) then
541: p_rec.clf_attribute7 :=
542: ben_clf_shd.g_old_rec.clf_attribute7;
543: End If;
544: If (p_rec.clf_attribute8 = hr_api.g_varchar2) then
545: p_rec.clf_attribute8 :=
546: ben_clf_shd.g_old_rec.clf_attribute8;
542: ben_clf_shd.g_old_rec.clf_attribute7;
543: End If;
544: If (p_rec.clf_attribute8 = hr_api.g_varchar2) then
545: p_rec.clf_attribute8 :=
546: ben_clf_shd.g_old_rec.clf_attribute8;
547: End If;
548: If (p_rec.clf_attribute9 = hr_api.g_varchar2) then
549: p_rec.clf_attribute9 :=
550: ben_clf_shd.g_old_rec.clf_attribute9;
546: ben_clf_shd.g_old_rec.clf_attribute8;
547: End If;
548: If (p_rec.clf_attribute9 = hr_api.g_varchar2) then
549: p_rec.clf_attribute9 :=
550: ben_clf_shd.g_old_rec.clf_attribute9;
551: End If;
552: If (p_rec.clf_attribute10 = hr_api.g_varchar2) then
553: p_rec.clf_attribute10 :=
554: ben_clf_shd.g_old_rec.clf_attribute10;
550: ben_clf_shd.g_old_rec.clf_attribute9;
551: End If;
552: If (p_rec.clf_attribute10 = hr_api.g_varchar2) then
553: p_rec.clf_attribute10 :=
554: ben_clf_shd.g_old_rec.clf_attribute10;
555: End If;
556: If (p_rec.clf_attribute11 = hr_api.g_varchar2) then
557: p_rec.clf_attribute11 :=
558: ben_clf_shd.g_old_rec.clf_attribute11;
554: ben_clf_shd.g_old_rec.clf_attribute10;
555: End If;
556: If (p_rec.clf_attribute11 = hr_api.g_varchar2) then
557: p_rec.clf_attribute11 :=
558: ben_clf_shd.g_old_rec.clf_attribute11;
559: End If;
560: If (p_rec.clf_attribute12 = hr_api.g_varchar2) then
561: p_rec.clf_attribute12 :=
562: ben_clf_shd.g_old_rec.clf_attribute12;
558: ben_clf_shd.g_old_rec.clf_attribute11;
559: End If;
560: If (p_rec.clf_attribute12 = hr_api.g_varchar2) then
561: p_rec.clf_attribute12 :=
562: ben_clf_shd.g_old_rec.clf_attribute12;
563: End If;
564: If (p_rec.clf_attribute13 = hr_api.g_varchar2) then
565: p_rec.clf_attribute13 :=
566: ben_clf_shd.g_old_rec.clf_attribute13;
562: ben_clf_shd.g_old_rec.clf_attribute12;
563: End If;
564: If (p_rec.clf_attribute13 = hr_api.g_varchar2) then
565: p_rec.clf_attribute13 :=
566: ben_clf_shd.g_old_rec.clf_attribute13;
567: End If;
568: If (p_rec.clf_attribute14 = hr_api.g_varchar2) then
569: p_rec.clf_attribute14 :=
570: ben_clf_shd.g_old_rec.clf_attribute14;
566: ben_clf_shd.g_old_rec.clf_attribute13;
567: End If;
568: If (p_rec.clf_attribute14 = hr_api.g_varchar2) then
569: p_rec.clf_attribute14 :=
570: ben_clf_shd.g_old_rec.clf_attribute14;
571: End If;
572: If (p_rec.clf_attribute15 = hr_api.g_varchar2) then
573: p_rec.clf_attribute15 :=
574: ben_clf_shd.g_old_rec.clf_attribute15;
570: ben_clf_shd.g_old_rec.clf_attribute14;
571: End If;
572: If (p_rec.clf_attribute15 = hr_api.g_varchar2) then
573: p_rec.clf_attribute15 :=
574: ben_clf_shd.g_old_rec.clf_attribute15;
575: End If;
576: If (p_rec.clf_attribute16 = hr_api.g_varchar2) then
577: p_rec.clf_attribute16 :=
578: ben_clf_shd.g_old_rec.clf_attribute16;
574: ben_clf_shd.g_old_rec.clf_attribute15;
575: End If;
576: If (p_rec.clf_attribute16 = hr_api.g_varchar2) then
577: p_rec.clf_attribute16 :=
578: ben_clf_shd.g_old_rec.clf_attribute16;
579: End If;
580: If (p_rec.clf_attribute17 = hr_api.g_varchar2) then
581: p_rec.clf_attribute17 :=
582: ben_clf_shd.g_old_rec.clf_attribute17;
578: ben_clf_shd.g_old_rec.clf_attribute16;
579: End If;
580: If (p_rec.clf_attribute17 = hr_api.g_varchar2) then
581: p_rec.clf_attribute17 :=
582: ben_clf_shd.g_old_rec.clf_attribute17;
583: End If;
584: If (p_rec.clf_attribute18 = hr_api.g_varchar2) then
585: p_rec.clf_attribute18 :=
586: ben_clf_shd.g_old_rec.clf_attribute18;
582: ben_clf_shd.g_old_rec.clf_attribute17;
583: End If;
584: If (p_rec.clf_attribute18 = hr_api.g_varchar2) then
585: p_rec.clf_attribute18 :=
586: ben_clf_shd.g_old_rec.clf_attribute18;
587: End If;
588: If (p_rec.clf_attribute19 = hr_api.g_varchar2) then
589: p_rec.clf_attribute19 :=
590: ben_clf_shd.g_old_rec.clf_attribute19;
586: ben_clf_shd.g_old_rec.clf_attribute18;
587: End If;
588: If (p_rec.clf_attribute19 = hr_api.g_varchar2) then
589: p_rec.clf_attribute19 :=
590: ben_clf_shd.g_old_rec.clf_attribute19;
591: End If;
592: If (p_rec.clf_attribute20 = hr_api.g_varchar2) then
593: p_rec.clf_attribute20 :=
594: ben_clf_shd.g_old_rec.clf_attribute20;
590: ben_clf_shd.g_old_rec.clf_attribute19;
591: End If;
592: If (p_rec.clf_attribute20 = hr_api.g_varchar2) then
593: p_rec.clf_attribute20 :=
594: ben_clf_shd.g_old_rec.clf_attribute20;
595: End If;
596: If (p_rec.clf_attribute21 = hr_api.g_varchar2) then
597: p_rec.clf_attribute21 :=
598: ben_clf_shd.g_old_rec.clf_attribute21;
594: ben_clf_shd.g_old_rec.clf_attribute20;
595: End If;
596: If (p_rec.clf_attribute21 = hr_api.g_varchar2) then
597: p_rec.clf_attribute21 :=
598: ben_clf_shd.g_old_rec.clf_attribute21;
599: End If;
600: If (p_rec.clf_attribute22 = hr_api.g_varchar2) then
601: p_rec.clf_attribute22 :=
602: ben_clf_shd.g_old_rec.clf_attribute22;
598: ben_clf_shd.g_old_rec.clf_attribute21;
599: End If;
600: If (p_rec.clf_attribute22 = hr_api.g_varchar2) then
601: p_rec.clf_attribute22 :=
602: ben_clf_shd.g_old_rec.clf_attribute22;
603: End If;
604: If (p_rec.clf_attribute23 = hr_api.g_varchar2) then
605: p_rec.clf_attribute23 :=
606: ben_clf_shd.g_old_rec.clf_attribute23;
602: ben_clf_shd.g_old_rec.clf_attribute22;
603: End If;
604: If (p_rec.clf_attribute23 = hr_api.g_varchar2) then
605: p_rec.clf_attribute23 :=
606: ben_clf_shd.g_old_rec.clf_attribute23;
607: End If;
608: If (p_rec.clf_attribute24 = hr_api.g_varchar2) then
609: p_rec.clf_attribute24 :=
610: ben_clf_shd.g_old_rec.clf_attribute24;
606: ben_clf_shd.g_old_rec.clf_attribute23;
607: End If;
608: If (p_rec.clf_attribute24 = hr_api.g_varchar2) then
609: p_rec.clf_attribute24 :=
610: ben_clf_shd.g_old_rec.clf_attribute24;
611: End If;
612: If (p_rec.clf_attribute25 = hr_api.g_varchar2) then
613: p_rec.clf_attribute25 :=
614: ben_clf_shd.g_old_rec.clf_attribute25;
610: ben_clf_shd.g_old_rec.clf_attribute24;
611: End If;
612: If (p_rec.clf_attribute25 = hr_api.g_varchar2) then
613: p_rec.clf_attribute25 :=
614: ben_clf_shd.g_old_rec.clf_attribute25;
615: End If;
616: If (p_rec.clf_attribute26 = hr_api.g_varchar2) then
617: p_rec.clf_attribute26 :=
618: ben_clf_shd.g_old_rec.clf_attribute26;
614: ben_clf_shd.g_old_rec.clf_attribute25;
615: End If;
616: If (p_rec.clf_attribute26 = hr_api.g_varchar2) then
617: p_rec.clf_attribute26 :=
618: ben_clf_shd.g_old_rec.clf_attribute26;
619: End If;
620: If (p_rec.clf_attribute27 = hr_api.g_varchar2) then
621: p_rec.clf_attribute27 :=
622: ben_clf_shd.g_old_rec.clf_attribute27;
618: ben_clf_shd.g_old_rec.clf_attribute26;
619: End If;
620: If (p_rec.clf_attribute27 = hr_api.g_varchar2) then
621: p_rec.clf_attribute27 :=
622: ben_clf_shd.g_old_rec.clf_attribute27;
623: End If;
624: If (p_rec.clf_attribute28 = hr_api.g_varchar2) then
625: p_rec.clf_attribute28 :=
626: ben_clf_shd.g_old_rec.clf_attribute28;
622: ben_clf_shd.g_old_rec.clf_attribute27;
623: End If;
624: If (p_rec.clf_attribute28 = hr_api.g_varchar2) then
625: p_rec.clf_attribute28 :=
626: ben_clf_shd.g_old_rec.clf_attribute28;
627: End If;
628: If (p_rec.clf_attribute29 = hr_api.g_varchar2) then
629: p_rec.clf_attribute29 :=
630: ben_clf_shd.g_old_rec.clf_attribute29;
626: ben_clf_shd.g_old_rec.clf_attribute28;
627: End If;
628: If (p_rec.clf_attribute29 = hr_api.g_varchar2) then
629: p_rec.clf_attribute29 :=
630: ben_clf_shd.g_old_rec.clf_attribute29;
631: End If;
632: If (p_rec.clf_attribute30 = hr_api.g_varchar2) then
633: p_rec.clf_attribute30 :=
634: ben_clf_shd.g_old_rec.clf_attribute30;
630: ben_clf_shd.g_old_rec.clf_attribute29;
631: End If;
632: If (p_rec.clf_attribute30 = hr_api.g_varchar2) then
633: p_rec.clf_attribute30 :=
634: ben_clf_shd.g_old_rec.clf_attribute30;
635: End If;
636: If (p_rec.sttd_sal_prdcty_cd = hr_api.g_varchar2) then
637: p_rec.sttd_sal_prdcty_cd :=
638: ben_clf_shd.g_old_rec.sttd_sal_prdcty_cd;
634: ben_clf_shd.g_old_rec.clf_attribute30;
635: End If;
636: If (p_rec.sttd_sal_prdcty_cd = hr_api.g_varchar2) then
637: p_rec.sttd_sal_prdcty_cd :=
638: ben_clf_shd.g_old_rec.sttd_sal_prdcty_cd;
639: End If;
640: --
641: hr_utility.set_location(' Leaving:'||l_proc, 10);
642: --
647: -- ----------------------------------------------------------------------------
648: Procedure upd
649: (
650: p_effective_date in date,
651: p_rec in out nocopy ben_clf_shd.g_rec_type
652: ) is
653: --
654: l_proc varchar2(72) := g_package||'upd';
655: --
657: hr_utility.set_location('Entering:'||l_proc, 5);
658: --
659: -- We must lock the row which we need to update.
660: --
661: ben_clf_shd.lck
662: (
663: p_rec.comp_lvl_fctr_id,
664: p_rec.object_version_number
665: );
751: p_sttd_sal_prdcty_cd in varchar2 default hr_api.g_varchar2
752:
753: ) is
754: --
755: l_rec ben_clf_shd.g_rec_type;
756: l_proc varchar2(72) := g_package||'upd';
757: --
758: Begin
759: hr_utility.set_location('Entering:'||l_proc, 5);
761: -- Call conversion function to turn arguments into the
762: -- l_rec structure.
763: --
764: l_rec :=
765: ben_clf_shd.convert_args
766: (
767: p_comp_lvl_fctr_id,
768: p_business_group_id,
769: p_name,