47: -- Internal Row Handler Use Only.
48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml(p_rec in ben_hwf_shd.g_rec_type) is
52: --
53: l_proc varchar2(72) := g_package||'delete_dml';
54: --
55: Begin
54: --
55: Begin
56: hr_utility.set_location('Entering:'||l_proc, 5);
57: --
58: ben_hwf_shd.g_api_dml := true; -- Set the api dml status
59: --
60: -- Delete the ben_hrs_wkd_in_perd_fctr row.
61: --
62: delete from ben_hrs_wkd_in_perd_fctr
61: --
62: delete from ben_hrs_wkd_in_perd_fctr
63: where hrs_wkd_in_perd_fctr_id = p_rec.hrs_wkd_in_perd_fctr_id;
64: --
65: ben_hwf_shd.g_api_dml := false; -- Unset the api dml status
66: --
67: hr_utility.set_location(' Leaving:'||l_proc, 10);
68: --
69: Exception
68: --
69: Exception
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated
72: ben_hwf_shd.g_api_dml := false; -- Unset the api dml status
73: ben_hwf_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_hwf_shd.g_api_dml := false; -- Unset the api dml status
69: Exception
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated
72: ben_hwf_shd.g_api_dml := false; -- Unset the api dml status
73: ben_hwf_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_hwf_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;
72: ben_hwf_shd.g_api_dml := false; -- Unset the api dml status
73: ben_hwf_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_hwf_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;
78: End delete_dml;
79: --
80: -- ----------------------------------------------------------------------------
108: -- Internal Row Handler Use Only.
109: --
110: -- {End Of Comments}
111: -- ----------------------------------------------------------------------------
112: Procedure pre_delete(p_rec in ben_hwf_shd.g_rec_type) is
113: --
114: l_proc varchar2(72) := g_package||'pre_delete';
115: --
116: Begin
151: --
152: -- {End Of Comments}
153: -- ----------------------------------------------------------------------------
154: Procedure post_delete(
155: p_effective_date in date,p_rec in ben_hwf_shd.g_rec_type) is
156: --
157: l_proc varchar2(72) := g_package||'post_delete';
158: --
159: Begin
166: --
167: ben_hwf_rkd.after_delete
168: (
169: p_hrs_wkd_in_perd_fctr_id =>p_rec.hrs_wkd_in_perd_fctr_id
170: ,p_name_o =>ben_hwf_shd.g_old_rec.name
171: ,p_business_group_id_o =>ben_hwf_shd.g_old_rec.business_group_id
172: ,p_hrs_src_cd_o =>ben_hwf_shd.g_old_rec.hrs_src_cd
173: ,p_rndg_cd_o =>ben_hwf_shd.g_old_rec.rndg_cd
174: ,p_rndg_rl_o =>ben_hwf_shd.g_old_rec.rndg_rl
167: ben_hwf_rkd.after_delete
168: (
169: p_hrs_wkd_in_perd_fctr_id =>p_rec.hrs_wkd_in_perd_fctr_id
170: ,p_name_o =>ben_hwf_shd.g_old_rec.name
171: ,p_business_group_id_o =>ben_hwf_shd.g_old_rec.business_group_id
172: ,p_hrs_src_cd_o =>ben_hwf_shd.g_old_rec.hrs_src_cd
173: ,p_rndg_cd_o =>ben_hwf_shd.g_old_rec.rndg_cd
174: ,p_rndg_rl_o =>ben_hwf_shd.g_old_rec.rndg_rl
175: ,p_hrs_wkd_det_cd_o =>ben_hwf_shd.g_old_rec.hrs_wkd_det_cd
168: (
169: p_hrs_wkd_in_perd_fctr_id =>p_rec.hrs_wkd_in_perd_fctr_id
170: ,p_name_o =>ben_hwf_shd.g_old_rec.name
171: ,p_business_group_id_o =>ben_hwf_shd.g_old_rec.business_group_id
172: ,p_hrs_src_cd_o =>ben_hwf_shd.g_old_rec.hrs_src_cd
173: ,p_rndg_cd_o =>ben_hwf_shd.g_old_rec.rndg_cd
174: ,p_rndg_rl_o =>ben_hwf_shd.g_old_rec.rndg_rl
175: ,p_hrs_wkd_det_cd_o =>ben_hwf_shd.g_old_rec.hrs_wkd_det_cd
176: ,p_hrs_wkd_det_rl_o =>ben_hwf_shd.g_old_rec.hrs_wkd_det_rl
169: p_hrs_wkd_in_perd_fctr_id =>p_rec.hrs_wkd_in_perd_fctr_id
170: ,p_name_o =>ben_hwf_shd.g_old_rec.name
171: ,p_business_group_id_o =>ben_hwf_shd.g_old_rec.business_group_id
172: ,p_hrs_src_cd_o =>ben_hwf_shd.g_old_rec.hrs_src_cd
173: ,p_rndg_cd_o =>ben_hwf_shd.g_old_rec.rndg_cd
174: ,p_rndg_rl_o =>ben_hwf_shd.g_old_rec.rndg_rl
175: ,p_hrs_wkd_det_cd_o =>ben_hwf_shd.g_old_rec.hrs_wkd_det_cd
176: ,p_hrs_wkd_det_rl_o =>ben_hwf_shd.g_old_rec.hrs_wkd_det_rl
177: ,p_no_mn_hrs_wkd_flag_o =>ben_hwf_shd.g_old_rec.no_mn_hrs_wkd_flag
170: ,p_name_o =>ben_hwf_shd.g_old_rec.name
171: ,p_business_group_id_o =>ben_hwf_shd.g_old_rec.business_group_id
172: ,p_hrs_src_cd_o =>ben_hwf_shd.g_old_rec.hrs_src_cd
173: ,p_rndg_cd_o =>ben_hwf_shd.g_old_rec.rndg_cd
174: ,p_rndg_rl_o =>ben_hwf_shd.g_old_rec.rndg_rl
175: ,p_hrs_wkd_det_cd_o =>ben_hwf_shd.g_old_rec.hrs_wkd_det_cd
176: ,p_hrs_wkd_det_rl_o =>ben_hwf_shd.g_old_rec.hrs_wkd_det_rl
177: ,p_no_mn_hrs_wkd_flag_o =>ben_hwf_shd.g_old_rec.no_mn_hrs_wkd_flag
178: ,p_mx_hrs_num_o =>ben_hwf_shd.g_old_rec.mx_hrs_num
171: ,p_business_group_id_o =>ben_hwf_shd.g_old_rec.business_group_id
172: ,p_hrs_src_cd_o =>ben_hwf_shd.g_old_rec.hrs_src_cd
173: ,p_rndg_cd_o =>ben_hwf_shd.g_old_rec.rndg_cd
174: ,p_rndg_rl_o =>ben_hwf_shd.g_old_rec.rndg_rl
175: ,p_hrs_wkd_det_cd_o =>ben_hwf_shd.g_old_rec.hrs_wkd_det_cd
176: ,p_hrs_wkd_det_rl_o =>ben_hwf_shd.g_old_rec.hrs_wkd_det_rl
177: ,p_no_mn_hrs_wkd_flag_o =>ben_hwf_shd.g_old_rec.no_mn_hrs_wkd_flag
178: ,p_mx_hrs_num_o =>ben_hwf_shd.g_old_rec.mx_hrs_num
179: ,p_no_mx_hrs_wkd_flag_o =>ben_hwf_shd.g_old_rec.no_mx_hrs_wkd_flag
172: ,p_hrs_src_cd_o =>ben_hwf_shd.g_old_rec.hrs_src_cd
173: ,p_rndg_cd_o =>ben_hwf_shd.g_old_rec.rndg_cd
174: ,p_rndg_rl_o =>ben_hwf_shd.g_old_rec.rndg_rl
175: ,p_hrs_wkd_det_cd_o =>ben_hwf_shd.g_old_rec.hrs_wkd_det_cd
176: ,p_hrs_wkd_det_rl_o =>ben_hwf_shd.g_old_rec.hrs_wkd_det_rl
177: ,p_no_mn_hrs_wkd_flag_o =>ben_hwf_shd.g_old_rec.no_mn_hrs_wkd_flag
178: ,p_mx_hrs_num_o =>ben_hwf_shd.g_old_rec.mx_hrs_num
179: ,p_no_mx_hrs_wkd_flag_o =>ben_hwf_shd.g_old_rec.no_mx_hrs_wkd_flag
180: ,p_once_r_cntug_cd_o =>ben_hwf_shd.g_old_rec.once_r_cntug_cd
173: ,p_rndg_cd_o =>ben_hwf_shd.g_old_rec.rndg_cd
174: ,p_rndg_rl_o =>ben_hwf_shd.g_old_rec.rndg_rl
175: ,p_hrs_wkd_det_cd_o =>ben_hwf_shd.g_old_rec.hrs_wkd_det_cd
176: ,p_hrs_wkd_det_rl_o =>ben_hwf_shd.g_old_rec.hrs_wkd_det_rl
177: ,p_no_mn_hrs_wkd_flag_o =>ben_hwf_shd.g_old_rec.no_mn_hrs_wkd_flag
178: ,p_mx_hrs_num_o =>ben_hwf_shd.g_old_rec.mx_hrs_num
179: ,p_no_mx_hrs_wkd_flag_o =>ben_hwf_shd.g_old_rec.no_mx_hrs_wkd_flag
180: ,p_once_r_cntug_cd_o =>ben_hwf_shd.g_old_rec.once_r_cntug_cd
181: ,p_mn_hrs_num_o =>ben_hwf_shd.g_old_rec.mn_hrs_num
174: ,p_rndg_rl_o =>ben_hwf_shd.g_old_rec.rndg_rl
175: ,p_hrs_wkd_det_cd_o =>ben_hwf_shd.g_old_rec.hrs_wkd_det_cd
176: ,p_hrs_wkd_det_rl_o =>ben_hwf_shd.g_old_rec.hrs_wkd_det_rl
177: ,p_no_mn_hrs_wkd_flag_o =>ben_hwf_shd.g_old_rec.no_mn_hrs_wkd_flag
178: ,p_mx_hrs_num_o =>ben_hwf_shd.g_old_rec.mx_hrs_num
179: ,p_no_mx_hrs_wkd_flag_o =>ben_hwf_shd.g_old_rec.no_mx_hrs_wkd_flag
180: ,p_once_r_cntug_cd_o =>ben_hwf_shd.g_old_rec.once_r_cntug_cd
181: ,p_mn_hrs_num_o =>ben_hwf_shd.g_old_rec.mn_hrs_num
182: ,p_hrs_alt_val_to_use_cd_o =>ben_hwf_shd.g_old_rec.hrs_alt_val_to_use_cd
175: ,p_hrs_wkd_det_cd_o =>ben_hwf_shd.g_old_rec.hrs_wkd_det_cd
176: ,p_hrs_wkd_det_rl_o =>ben_hwf_shd.g_old_rec.hrs_wkd_det_rl
177: ,p_no_mn_hrs_wkd_flag_o =>ben_hwf_shd.g_old_rec.no_mn_hrs_wkd_flag
178: ,p_mx_hrs_num_o =>ben_hwf_shd.g_old_rec.mx_hrs_num
179: ,p_no_mx_hrs_wkd_flag_o =>ben_hwf_shd.g_old_rec.no_mx_hrs_wkd_flag
180: ,p_once_r_cntug_cd_o =>ben_hwf_shd.g_old_rec.once_r_cntug_cd
181: ,p_mn_hrs_num_o =>ben_hwf_shd.g_old_rec.mn_hrs_num
182: ,p_hrs_alt_val_to_use_cd_o =>ben_hwf_shd.g_old_rec.hrs_alt_val_to_use_cd
183: ,p_pyrl_freq_cd_o =>ben_hwf_shd.g_old_rec.pyrl_freq_cd
176: ,p_hrs_wkd_det_rl_o =>ben_hwf_shd.g_old_rec.hrs_wkd_det_rl
177: ,p_no_mn_hrs_wkd_flag_o =>ben_hwf_shd.g_old_rec.no_mn_hrs_wkd_flag
178: ,p_mx_hrs_num_o =>ben_hwf_shd.g_old_rec.mx_hrs_num
179: ,p_no_mx_hrs_wkd_flag_o =>ben_hwf_shd.g_old_rec.no_mx_hrs_wkd_flag
180: ,p_once_r_cntug_cd_o =>ben_hwf_shd.g_old_rec.once_r_cntug_cd
181: ,p_mn_hrs_num_o =>ben_hwf_shd.g_old_rec.mn_hrs_num
182: ,p_hrs_alt_val_to_use_cd_o =>ben_hwf_shd.g_old_rec.hrs_alt_val_to_use_cd
183: ,p_pyrl_freq_cd_o =>ben_hwf_shd.g_old_rec.pyrl_freq_cd
184: ,p_hrs_wkd_calc_rl_o =>ben_hwf_shd.g_old_rec.hrs_wkd_calc_rl
177: ,p_no_mn_hrs_wkd_flag_o =>ben_hwf_shd.g_old_rec.no_mn_hrs_wkd_flag
178: ,p_mx_hrs_num_o =>ben_hwf_shd.g_old_rec.mx_hrs_num
179: ,p_no_mx_hrs_wkd_flag_o =>ben_hwf_shd.g_old_rec.no_mx_hrs_wkd_flag
180: ,p_once_r_cntug_cd_o =>ben_hwf_shd.g_old_rec.once_r_cntug_cd
181: ,p_mn_hrs_num_o =>ben_hwf_shd.g_old_rec.mn_hrs_num
182: ,p_hrs_alt_val_to_use_cd_o =>ben_hwf_shd.g_old_rec.hrs_alt_val_to_use_cd
183: ,p_pyrl_freq_cd_o =>ben_hwf_shd.g_old_rec.pyrl_freq_cd
184: ,p_hrs_wkd_calc_rl_o =>ben_hwf_shd.g_old_rec.hrs_wkd_calc_rl
185: ,p_defined_balance_id_o =>ben_hwf_shd.g_old_rec.defined_balance_id
178: ,p_mx_hrs_num_o =>ben_hwf_shd.g_old_rec.mx_hrs_num
179: ,p_no_mx_hrs_wkd_flag_o =>ben_hwf_shd.g_old_rec.no_mx_hrs_wkd_flag
180: ,p_once_r_cntug_cd_o =>ben_hwf_shd.g_old_rec.once_r_cntug_cd
181: ,p_mn_hrs_num_o =>ben_hwf_shd.g_old_rec.mn_hrs_num
182: ,p_hrs_alt_val_to_use_cd_o =>ben_hwf_shd.g_old_rec.hrs_alt_val_to_use_cd
183: ,p_pyrl_freq_cd_o =>ben_hwf_shd.g_old_rec.pyrl_freq_cd
184: ,p_hrs_wkd_calc_rl_o =>ben_hwf_shd.g_old_rec.hrs_wkd_calc_rl
185: ,p_defined_balance_id_o =>ben_hwf_shd.g_old_rec.defined_balance_id
186: ,p_bnfts_bal_id_o =>ben_hwf_shd.g_old_rec.bnfts_bal_id
179: ,p_no_mx_hrs_wkd_flag_o =>ben_hwf_shd.g_old_rec.no_mx_hrs_wkd_flag
180: ,p_once_r_cntug_cd_o =>ben_hwf_shd.g_old_rec.once_r_cntug_cd
181: ,p_mn_hrs_num_o =>ben_hwf_shd.g_old_rec.mn_hrs_num
182: ,p_hrs_alt_val_to_use_cd_o =>ben_hwf_shd.g_old_rec.hrs_alt_val_to_use_cd
183: ,p_pyrl_freq_cd_o =>ben_hwf_shd.g_old_rec.pyrl_freq_cd
184: ,p_hrs_wkd_calc_rl_o =>ben_hwf_shd.g_old_rec.hrs_wkd_calc_rl
185: ,p_defined_balance_id_o =>ben_hwf_shd.g_old_rec.defined_balance_id
186: ,p_bnfts_bal_id_o =>ben_hwf_shd.g_old_rec.bnfts_bal_id
187: ,p_hwf_attribute_category_o =>ben_hwf_shd.g_old_rec.hwf_attribute_category
180: ,p_once_r_cntug_cd_o =>ben_hwf_shd.g_old_rec.once_r_cntug_cd
181: ,p_mn_hrs_num_o =>ben_hwf_shd.g_old_rec.mn_hrs_num
182: ,p_hrs_alt_val_to_use_cd_o =>ben_hwf_shd.g_old_rec.hrs_alt_val_to_use_cd
183: ,p_pyrl_freq_cd_o =>ben_hwf_shd.g_old_rec.pyrl_freq_cd
184: ,p_hrs_wkd_calc_rl_o =>ben_hwf_shd.g_old_rec.hrs_wkd_calc_rl
185: ,p_defined_balance_id_o =>ben_hwf_shd.g_old_rec.defined_balance_id
186: ,p_bnfts_bal_id_o =>ben_hwf_shd.g_old_rec.bnfts_bal_id
187: ,p_hwf_attribute_category_o =>ben_hwf_shd.g_old_rec.hwf_attribute_category
188: ,p_hwf_attribute1_o =>ben_hwf_shd.g_old_rec.hwf_attribute1
181: ,p_mn_hrs_num_o =>ben_hwf_shd.g_old_rec.mn_hrs_num
182: ,p_hrs_alt_val_to_use_cd_o =>ben_hwf_shd.g_old_rec.hrs_alt_val_to_use_cd
183: ,p_pyrl_freq_cd_o =>ben_hwf_shd.g_old_rec.pyrl_freq_cd
184: ,p_hrs_wkd_calc_rl_o =>ben_hwf_shd.g_old_rec.hrs_wkd_calc_rl
185: ,p_defined_balance_id_o =>ben_hwf_shd.g_old_rec.defined_balance_id
186: ,p_bnfts_bal_id_o =>ben_hwf_shd.g_old_rec.bnfts_bal_id
187: ,p_hwf_attribute_category_o =>ben_hwf_shd.g_old_rec.hwf_attribute_category
188: ,p_hwf_attribute1_o =>ben_hwf_shd.g_old_rec.hwf_attribute1
189: ,p_hwf_attribute2_o =>ben_hwf_shd.g_old_rec.hwf_attribute2
182: ,p_hrs_alt_val_to_use_cd_o =>ben_hwf_shd.g_old_rec.hrs_alt_val_to_use_cd
183: ,p_pyrl_freq_cd_o =>ben_hwf_shd.g_old_rec.pyrl_freq_cd
184: ,p_hrs_wkd_calc_rl_o =>ben_hwf_shd.g_old_rec.hrs_wkd_calc_rl
185: ,p_defined_balance_id_o =>ben_hwf_shd.g_old_rec.defined_balance_id
186: ,p_bnfts_bal_id_o =>ben_hwf_shd.g_old_rec.bnfts_bal_id
187: ,p_hwf_attribute_category_o =>ben_hwf_shd.g_old_rec.hwf_attribute_category
188: ,p_hwf_attribute1_o =>ben_hwf_shd.g_old_rec.hwf_attribute1
189: ,p_hwf_attribute2_o =>ben_hwf_shd.g_old_rec.hwf_attribute2
190: ,p_hwf_attribute3_o =>ben_hwf_shd.g_old_rec.hwf_attribute3
183: ,p_pyrl_freq_cd_o =>ben_hwf_shd.g_old_rec.pyrl_freq_cd
184: ,p_hrs_wkd_calc_rl_o =>ben_hwf_shd.g_old_rec.hrs_wkd_calc_rl
185: ,p_defined_balance_id_o =>ben_hwf_shd.g_old_rec.defined_balance_id
186: ,p_bnfts_bal_id_o =>ben_hwf_shd.g_old_rec.bnfts_bal_id
187: ,p_hwf_attribute_category_o =>ben_hwf_shd.g_old_rec.hwf_attribute_category
188: ,p_hwf_attribute1_o =>ben_hwf_shd.g_old_rec.hwf_attribute1
189: ,p_hwf_attribute2_o =>ben_hwf_shd.g_old_rec.hwf_attribute2
190: ,p_hwf_attribute3_o =>ben_hwf_shd.g_old_rec.hwf_attribute3
191: ,p_hwf_attribute4_o =>ben_hwf_shd.g_old_rec.hwf_attribute4
184: ,p_hrs_wkd_calc_rl_o =>ben_hwf_shd.g_old_rec.hrs_wkd_calc_rl
185: ,p_defined_balance_id_o =>ben_hwf_shd.g_old_rec.defined_balance_id
186: ,p_bnfts_bal_id_o =>ben_hwf_shd.g_old_rec.bnfts_bal_id
187: ,p_hwf_attribute_category_o =>ben_hwf_shd.g_old_rec.hwf_attribute_category
188: ,p_hwf_attribute1_o =>ben_hwf_shd.g_old_rec.hwf_attribute1
189: ,p_hwf_attribute2_o =>ben_hwf_shd.g_old_rec.hwf_attribute2
190: ,p_hwf_attribute3_o =>ben_hwf_shd.g_old_rec.hwf_attribute3
191: ,p_hwf_attribute4_o =>ben_hwf_shd.g_old_rec.hwf_attribute4
192: ,p_hwf_attribute5_o =>ben_hwf_shd.g_old_rec.hwf_attribute5
185: ,p_defined_balance_id_o =>ben_hwf_shd.g_old_rec.defined_balance_id
186: ,p_bnfts_bal_id_o =>ben_hwf_shd.g_old_rec.bnfts_bal_id
187: ,p_hwf_attribute_category_o =>ben_hwf_shd.g_old_rec.hwf_attribute_category
188: ,p_hwf_attribute1_o =>ben_hwf_shd.g_old_rec.hwf_attribute1
189: ,p_hwf_attribute2_o =>ben_hwf_shd.g_old_rec.hwf_attribute2
190: ,p_hwf_attribute3_o =>ben_hwf_shd.g_old_rec.hwf_attribute3
191: ,p_hwf_attribute4_o =>ben_hwf_shd.g_old_rec.hwf_attribute4
192: ,p_hwf_attribute5_o =>ben_hwf_shd.g_old_rec.hwf_attribute5
193: ,p_hwf_attribute6_o =>ben_hwf_shd.g_old_rec.hwf_attribute6
186: ,p_bnfts_bal_id_o =>ben_hwf_shd.g_old_rec.bnfts_bal_id
187: ,p_hwf_attribute_category_o =>ben_hwf_shd.g_old_rec.hwf_attribute_category
188: ,p_hwf_attribute1_o =>ben_hwf_shd.g_old_rec.hwf_attribute1
189: ,p_hwf_attribute2_o =>ben_hwf_shd.g_old_rec.hwf_attribute2
190: ,p_hwf_attribute3_o =>ben_hwf_shd.g_old_rec.hwf_attribute3
191: ,p_hwf_attribute4_o =>ben_hwf_shd.g_old_rec.hwf_attribute4
192: ,p_hwf_attribute5_o =>ben_hwf_shd.g_old_rec.hwf_attribute5
193: ,p_hwf_attribute6_o =>ben_hwf_shd.g_old_rec.hwf_attribute6
194: ,p_hwf_attribute7_o =>ben_hwf_shd.g_old_rec.hwf_attribute7
187: ,p_hwf_attribute_category_o =>ben_hwf_shd.g_old_rec.hwf_attribute_category
188: ,p_hwf_attribute1_o =>ben_hwf_shd.g_old_rec.hwf_attribute1
189: ,p_hwf_attribute2_o =>ben_hwf_shd.g_old_rec.hwf_attribute2
190: ,p_hwf_attribute3_o =>ben_hwf_shd.g_old_rec.hwf_attribute3
191: ,p_hwf_attribute4_o =>ben_hwf_shd.g_old_rec.hwf_attribute4
192: ,p_hwf_attribute5_o =>ben_hwf_shd.g_old_rec.hwf_attribute5
193: ,p_hwf_attribute6_o =>ben_hwf_shd.g_old_rec.hwf_attribute6
194: ,p_hwf_attribute7_o =>ben_hwf_shd.g_old_rec.hwf_attribute7
195: ,p_hwf_attribute8_o =>ben_hwf_shd.g_old_rec.hwf_attribute8
188: ,p_hwf_attribute1_o =>ben_hwf_shd.g_old_rec.hwf_attribute1
189: ,p_hwf_attribute2_o =>ben_hwf_shd.g_old_rec.hwf_attribute2
190: ,p_hwf_attribute3_o =>ben_hwf_shd.g_old_rec.hwf_attribute3
191: ,p_hwf_attribute4_o =>ben_hwf_shd.g_old_rec.hwf_attribute4
192: ,p_hwf_attribute5_o =>ben_hwf_shd.g_old_rec.hwf_attribute5
193: ,p_hwf_attribute6_o =>ben_hwf_shd.g_old_rec.hwf_attribute6
194: ,p_hwf_attribute7_o =>ben_hwf_shd.g_old_rec.hwf_attribute7
195: ,p_hwf_attribute8_o =>ben_hwf_shd.g_old_rec.hwf_attribute8
196: ,p_hwf_attribute9_o =>ben_hwf_shd.g_old_rec.hwf_attribute9
189: ,p_hwf_attribute2_o =>ben_hwf_shd.g_old_rec.hwf_attribute2
190: ,p_hwf_attribute3_o =>ben_hwf_shd.g_old_rec.hwf_attribute3
191: ,p_hwf_attribute4_o =>ben_hwf_shd.g_old_rec.hwf_attribute4
192: ,p_hwf_attribute5_o =>ben_hwf_shd.g_old_rec.hwf_attribute5
193: ,p_hwf_attribute6_o =>ben_hwf_shd.g_old_rec.hwf_attribute6
194: ,p_hwf_attribute7_o =>ben_hwf_shd.g_old_rec.hwf_attribute7
195: ,p_hwf_attribute8_o =>ben_hwf_shd.g_old_rec.hwf_attribute8
196: ,p_hwf_attribute9_o =>ben_hwf_shd.g_old_rec.hwf_attribute9
197: ,p_hwf_attribute10_o =>ben_hwf_shd.g_old_rec.hwf_attribute10
190: ,p_hwf_attribute3_o =>ben_hwf_shd.g_old_rec.hwf_attribute3
191: ,p_hwf_attribute4_o =>ben_hwf_shd.g_old_rec.hwf_attribute4
192: ,p_hwf_attribute5_o =>ben_hwf_shd.g_old_rec.hwf_attribute5
193: ,p_hwf_attribute6_o =>ben_hwf_shd.g_old_rec.hwf_attribute6
194: ,p_hwf_attribute7_o =>ben_hwf_shd.g_old_rec.hwf_attribute7
195: ,p_hwf_attribute8_o =>ben_hwf_shd.g_old_rec.hwf_attribute8
196: ,p_hwf_attribute9_o =>ben_hwf_shd.g_old_rec.hwf_attribute9
197: ,p_hwf_attribute10_o =>ben_hwf_shd.g_old_rec.hwf_attribute10
198: ,p_hwf_attribute11_o =>ben_hwf_shd.g_old_rec.hwf_attribute11
191: ,p_hwf_attribute4_o =>ben_hwf_shd.g_old_rec.hwf_attribute4
192: ,p_hwf_attribute5_o =>ben_hwf_shd.g_old_rec.hwf_attribute5
193: ,p_hwf_attribute6_o =>ben_hwf_shd.g_old_rec.hwf_attribute6
194: ,p_hwf_attribute7_o =>ben_hwf_shd.g_old_rec.hwf_attribute7
195: ,p_hwf_attribute8_o =>ben_hwf_shd.g_old_rec.hwf_attribute8
196: ,p_hwf_attribute9_o =>ben_hwf_shd.g_old_rec.hwf_attribute9
197: ,p_hwf_attribute10_o =>ben_hwf_shd.g_old_rec.hwf_attribute10
198: ,p_hwf_attribute11_o =>ben_hwf_shd.g_old_rec.hwf_attribute11
199: ,p_hwf_attribute12_o =>ben_hwf_shd.g_old_rec.hwf_attribute12
192: ,p_hwf_attribute5_o =>ben_hwf_shd.g_old_rec.hwf_attribute5
193: ,p_hwf_attribute6_o =>ben_hwf_shd.g_old_rec.hwf_attribute6
194: ,p_hwf_attribute7_o =>ben_hwf_shd.g_old_rec.hwf_attribute7
195: ,p_hwf_attribute8_o =>ben_hwf_shd.g_old_rec.hwf_attribute8
196: ,p_hwf_attribute9_o =>ben_hwf_shd.g_old_rec.hwf_attribute9
197: ,p_hwf_attribute10_o =>ben_hwf_shd.g_old_rec.hwf_attribute10
198: ,p_hwf_attribute11_o =>ben_hwf_shd.g_old_rec.hwf_attribute11
199: ,p_hwf_attribute12_o =>ben_hwf_shd.g_old_rec.hwf_attribute12
200: ,p_hwf_attribute13_o =>ben_hwf_shd.g_old_rec.hwf_attribute13
193: ,p_hwf_attribute6_o =>ben_hwf_shd.g_old_rec.hwf_attribute6
194: ,p_hwf_attribute7_o =>ben_hwf_shd.g_old_rec.hwf_attribute7
195: ,p_hwf_attribute8_o =>ben_hwf_shd.g_old_rec.hwf_attribute8
196: ,p_hwf_attribute9_o =>ben_hwf_shd.g_old_rec.hwf_attribute9
197: ,p_hwf_attribute10_o =>ben_hwf_shd.g_old_rec.hwf_attribute10
198: ,p_hwf_attribute11_o =>ben_hwf_shd.g_old_rec.hwf_attribute11
199: ,p_hwf_attribute12_o =>ben_hwf_shd.g_old_rec.hwf_attribute12
200: ,p_hwf_attribute13_o =>ben_hwf_shd.g_old_rec.hwf_attribute13
201: ,p_hwf_attribute14_o =>ben_hwf_shd.g_old_rec.hwf_attribute14
194: ,p_hwf_attribute7_o =>ben_hwf_shd.g_old_rec.hwf_attribute7
195: ,p_hwf_attribute8_o =>ben_hwf_shd.g_old_rec.hwf_attribute8
196: ,p_hwf_attribute9_o =>ben_hwf_shd.g_old_rec.hwf_attribute9
197: ,p_hwf_attribute10_o =>ben_hwf_shd.g_old_rec.hwf_attribute10
198: ,p_hwf_attribute11_o =>ben_hwf_shd.g_old_rec.hwf_attribute11
199: ,p_hwf_attribute12_o =>ben_hwf_shd.g_old_rec.hwf_attribute12
200: ,p_hwf_attribute13_o =>ben_hwf_shd.g_old_rec.hwf_attribute13
201: ,p_hwf_attribute14_o =>ben_hwf_shd.g_old_rec.hwf_attribute14
202: ,p_hwf_attribute15_o =>ben_hwf_shd.g_old_rec.hwf_attribute15
195: ,p_hwf_attribute8_o =>ben_hwf_shd.g_old_rec.hwf_attribute8
196: ,p_hwf_attribute9_o =>ben_hwf_shd.g_old_rec.hwf_attribute9
197: ,p_hwf_attribute10_o =>ben_hwf_shd.g_old_rec.hwf_attribute10
198: ,p_hwf_attribute11_o =>ben_hwf_shd.g_old_rec.hwf_attribute11
199: ,p_hwf_attribute12_o =>ben_hwf_shd.g_old_rec.hwf_attribute12
200: ,p_hwf_attribute13_o =>ben_hwf_shd.g_old_rec.hwf_attribute13
201: ,p_hwf_attribute14_o =>ben_hwf_shd.g_old_rec.hwf_attribute14
202: ,p_hwf_attribute15_o =>ben_hwf_shd.g_old_rec.hwf_attribute15
203: ,p_hwf_attribute16_o =>ben_hwf_shd.g_old_rec.hwf_attribute16
196: ,p_hwf_attribute9_o =>ben_hwf_shd.g_old_rec.hwf_attribute9
197: ,p_hwf_attribute10_o =>ben_hwf_shd.g_old_rec.hwf_attribute10
198: ,p_hwf_attribute11_o =>ben_hwf_shd.g_old_rec.hwf_attribute11
199: ,p_hwf_attribute12_o =>ben_hwf_shd.g_old_rec.hwf_attribute12
200: ,p_hwf_attribute13_o =>ben_hwf_shd.g_old_rec.hwf_attribute13
201: ,p_hwf_attribute14_o =>ben_hwf_shd.g_old_rec.hwf_attribute14
202: ,p_hwf_attribute15_o =>ben_hwf_shd.g_old_rec.hwf_attribute15
203: ,p_hwf_attribute16_o =>ben_hwf_shd.g_old_rec.hwf_attribute16
204: ,p_hwf_attribute17_o =>ben_hwf_shd.g_old_rec.hwf_attribute17
197: ,p_hwf_attribute10_o =>ben_hwf_shd.g_old_rec.hwf_attribute10
198: ,p_hwf_attribute11_o =>ben_hwf_shd.g_old_rec.hwf_attribute11
199: ,p_hwf_attribute12_o =>ben_hwf_shd.g_old_rec.hwf_attribute12
200: ,p_hwf_attribute13_o =>ben_hwf_shd.g_old_rec.hwf_attribute13
201: ,p_hwf_attribute14_o =>ben_hwf_shd.g_old_rec.hwf_attribute14
202: ,p_hwf_attribute15_o =>ben_hwf_shd.g_old_rec.hwf_attribute15
203: ,p_hwf_attribute16_o =>ben_hwf_shd.g_old_rec.hwf_attribute16
204: ,p_hwf_attribute17_o =>ben_hwf_shd.g_old_rec.hwf_attribute17
205: ,p_hwf_attribute18_o =>ben_hwf_shd.g_old_rec.hwf_attribute18
198: ,p_hwf_attribute11_o =>ben_hwf_shd.g_old_rec.hwf_attribute11
199: ,p_hwf_attribute12_o =>ben_hwf_shd.g_old_rec.hwf_attribute12
200: ,p_hwf_attribute13_o =>ben_hwf_shd.g_old_rec.hwf_attribute13
201: ,p_hwf_attribute14_o =>ben_hwf_shd.g_old_rec.hwf_attribute14
202: ,p_hwf_attribute15_o =>ben_hwf_shd.g_old_rec.hwf_attribute15
203: ,p_hwf_attribute16_o =>ben_hwf_shd.g_old_rec.hwf_attribute16
204: ,p_hwf_attribute17_o =>ben_hwf_shd.g_old_rec.hwf_attribute17
205: ,p_hwf_attribute18_o =>ben_hwf_shd.g_old_rec.hwf_attribute18
206: ,p_hwf_attribute19_o =>ben_hwf_shd.g_old_rec.hwf_attribute19
199: ,p_hwf_attribute12_o =>ben_hwf_shd.g_old_rec.hwf_attribute12
200: ,p_hwf_attribute13_o =>ben_hwf_shd.g_old_rec.hwf_attribute13
201: ,p_hwf_attribute14_o =>ben_hwf_shd.g_old_rec.hwf_attribute14
202: ,p_hwf_attribute15_o =>ben_hwf_shd.g_old_rec.hwf_attribute15
203: ,p_hwf_attribute16_o =>ben_hwf_shd.g_old_rec.hwf_attribute16
204: ,p_hwf_attribute17_o =>ben_hwf_shd.g_old_rec.hwf_attribute17
205: ,p_hwf_attribute18_o =>ben_hwf_shd.g_old_rec.hwf_attribute18
206: ,p_hwf_attribute19_o =>ben_hwf_shd.g_old_rec.hwf_attribute19
207: ,p_hwf_attribute20_o =>ben_hwf_shd.g_old_rec.hwf_attribute20
200: ,p_hwf_attribute13_o =>ben_hwf_shd.g_old_rec.hwf_attribute13
201: ,p_hwf_attribute14_o =>ben_hwf_shd.g_old_rec.hwf_attribute14
202: ,p_hwf_attribute15_o =>ben_hwf_shd.g_old_rec.hwf_attribute15
203: ,p_hwf_attribute16_o =>ben_hwf_shd.g_old_rec.hwf_attribute16
204: ,p_hwf_attribute17_o =>ben_hwf_shd.g_old_rec.hwf_attribute17
205: ,p_hwf_attribute18_o =>ben_hwf_shd.g_old_rec.hwf_attribute18
206: ,p_hwf_attribute19_o =>ben_hwf_shd.g_old_rec.hwf_attribute19
207: ,p_hwf_attribute20_o =>ben_hwf_shd.g_old_rec.hwf_attribute20
208: ,p_hwf_attribute21_o =>ben_hwf_shd.g_old_rec.hwf_attribute21
201: ,p_hwf_attribute14_o =>ben_hwf_shd.g_old_rec.hwf_attribute14
202: ,p_hwf_attribute15_o =>ben_hwf_shd.g_old_rec.hwf_attribute15
203: ,p_hwf_attribute16_o =>ben_hwf_shd.g_old_rec.hwf_attribute16
204: ,p_hwf_attribute17_o =>ben_hwf_shd.g_old_rec.hwf_attribute17
205: ,p_hwf_attribute18_o =>ben_hwf_shd.g_old_rec.hwf_attribute18
206: ,p_hwf_attribute19_o =>ben_hwf_shd.g_old_rec.hwf_attribute19
207: ,p_hwf_attribute20_o =>ben_hwf_shd.g_old_rec.hwf_attribute20
208: ,p_hwf_attribute21_o =>ben_hwf_shd.g_old_rec.hwf_attribute21
209: ,p_hwf_attribute22_o =>ben_hwf_shd.g_old_rec.hwf_attribute22
202: ,p_hwf_attribute15_o =>ben_hwf_shd.g_old_rec.hwf_attribute15
203: ,p_hwf_attribute16_o =>ben_hwf_shd.g_old_rec.hwf_attribute16
204: ,p_hwf_attribute17_o =>ben_hwf_shd.g_old_rec.hwf_attribute17
205: ,p_hwf_attribute18_o =>ben_hwf_shd.g_old_rec.hwf_attribute18
206: ,p_hwf_attribute19_o =>ben_hwf_shd.g_old_rec.hwf_attribute19
207: ,p_hwf_attribute20_o =>ben_hwf_shd.g_old_rec.hwf_attribute20
208: ,p_hwf_attribute21_o =>ben_hwf_shd.g_old_rec.hwf_attribute21
209: ,p_hwf_attribute22_o =>ben_hwf_shd.g_old_rec.hwf_attribute22
210: ,p_hwf_attribute23_o =>ben_hwf_shd.g_old_rec.hwf_attribute23
203: ,p_hwf_attribute16_o =>ben_hwf_shd.g_old_rec.hwf_attribute16
204: ,p_hwf_attribute17_o =>ben_hwf_shd.g_old_rec.hwf_attribute17
205: ,p_hwf_attribute18_o =>ben_hwf_shd.g_old_rec.hwf_attribute18
206: ,p_hwf_attribute19_o =>ben_hwf_shd.g_old_rec.hwf_attribute19
207: ,p_hwf_attribute20_o =>ben_hwf_shd.g_old_rec.hwf_attribute20
208: ,p_hwf_attribute21_o =>ben_hwf_shd.g_old_rec.hwf_attribute21
209: ,p_hwf_attribute22_o =>ben_hwf_shd.g_old_rec.hwf_attribute22
210: ,p_hwf_attribute23_o =>ben_hwf_shd.g_old_rec.hwf_attribute23
211: ,p_hwf_attribute24_o =>ben_hwf_shd.g_old_rec.hwf_attribute24
204: ,p_hwf_attribute17_o =>ben_hwf_shd.g_old_rec.hwf_attribute17
205: ,p_hwf_attribute18_o =>ben_hwf_shd.g_old_rec.hwf_attribute18
206: ,p_hwf_attribute19_o =>ben_hwf_shd.g_old_rec.hwf_attribute19
207: ,p_hwf_attribute20_o =>ben_hwf_shd.g_old_rec.hwf_attribute20
208: ,p_hwf_attribute21_o =>ben_hwf_shd.g_old_rec.hwf_attribute21
209: ,p_hwf_attribute22_o =>ben_hwf_shd.g_old_rec.hwf_attribute22
210: ,p_hwf_attribute23_o =>ben_hwf_shd.g_old_rec.hwf_attribute23
211: ,p_hwf_attribute24_o =>ben_hwf_shd.g_old_rec.hwf_attribute24
212: ,p_hwf_attribute25_o =>ben_hwf_shd.g_old_rec.hwf_attribute25
205: ,p_hwf_attribute18_o =>ben_hwf_shd.g_old_rec.hwf_attribute18
206: ,p_hwf_attribute19_o =>ben_hwf_shd.g_old_rec.hwf_attribute19
207: ,p_hwf_attribute20_o =>ben_hwf_shd.g_old_rec.hwf_attribute20
208: ,p_hwf_attribute21_o =>ben_hwf_shd.g_old_rec.hwf_attribute21
209: ,p_hwf_attribute22_o =>ben_hwf_shd.g_old_rec.hwf_attribute22
210: ,p_hwf_attribute23_o =>ben_hwf_shd.g_old_rec.hwf_attribute23
211: ,p_hwf_attribute24_o =>ben_hwf_shd.g_old_rec.hwf_attribute24
212: ,p_hwf_attribute25_o =>ben_hwf_shd.g_old_rec.hwf_attribute25
213: ,p_hwf_attribute26_o =>ben_hwf_shd.g_old_rec.hwf_attribute26
206: ,p_hwf_attribute19_o =>ben_hwf_shd.g_old_rec.hwf_attribute19
207: ,p_hwf_attribute20_o =>ben_hwf_shd.g_old_rec.hwf_attribute20
208: ,p_hwf_attribute21_o =>ben_hwf_shd.g_old_rec.hwf_attribute21
209: ,p_hwf_attribute22_o =>ben_hwf_shd.g_old_rec.hwf_attribute22
210: ,p_hwf_attribute23_o =>ben_hwf_shd.g_old_rec.hwf_attribute23
211: ,p_hwf_attribute24_o =>ben_hwf_shd.g_old_rec.hwf_attribute24
212: ,p_hwf_attribute25_o =>ben_hwf_shd.g_old_rec.hwf_attribute25
213: ,p_hwf_attribute26_o =>ben_hwf_shd.g_old_rec.hwf_attribute26
214: ,p_hwf_attribute27_o =>ben_hwf_shd.g_old_rec.hwf_attribute27
207: ,p_hwf_attribute20_o =>ben_hwf_shd.g_old_rec.hwf_attribute20
208: ,p_hwf_attribute21_o =>ben_hwf_shd.g_old_rec.hwf_attribute21
209: ,p_hwf_attribute22_o =>ben_hwf_shd.g_old_rec.hwf_attribute22
210: ,p_hwf_attribute23_o =>ben_hwf_shd.g_old_rec.hwf_attribute23
211: ,p_hwf_attribute24_o =>ben_hwf_shd.g_old_rec.hwf_attribute24
212: ,p_hwf_attribute25_o =>ben_hwf_shd.g_old_rec.hwf_attribute25
213: ,p_hwf_attribute26_o =>ben_hwf_shd.g_old_rec.hwf_attribute26
214: ,p_hwf_attribute27_o =>ben_hwf_shd.g_old_rec.hwf_attribute27
215: ,p_hwf_attribute28_o =>ben_hwf_shd.g_old_rec.hwf_attribute28
208: ,p_hwf_attribute21_o =>ben_hwf_shd.g_old_rec.hwf_attribute21
209: ,p_hwf_attribute22_o =>ben_hwf_shd.g_old_rec.hwf_attribute22
210: ,p_hwf_attribute23_o =>ben_hwf_shd.g_old_rec.hwf_attribute23
211: ,p_hwf_attribute24_o =>ben_hwf_shd.g_old_rec.hwf_attribute24
212: ,p_hwf_attribute25_o =>ben_hwf_shd.g_old_rec.hwf_attribute25
213: ,p_hwf_attribute26_o =>ben_hwf_shd.g_old_rec.hwf_attribute26
214: ,p_hwf_attribute27_o =>ben_hwf_shd.g_old_rec.hwf_attribute27
215: ,p_hwf_attribute28_o =>ben_hwf_shd.g_old_rec.hwf_attribute28
216: ,p_hwf_attribute29_o =>ben_hwf_shd.g_old_rec.hwf_attribute29
209: ,p_hwf_attribute22_o =>ben_hwf_shd.g_old_rec.hwf_attribute22
210: ,p_hwf_attribute23_o =>ben_hwf_shd.g_old_rec.hwf_attribute23
211: ,p_hwf_attribute24_o =>ben_hwf_shd.g_old_rec.hwf_attribute24
212: ,p_hwf_attribute25_o =>ben_hwf_shd.g_old_rec.hwf_attribute25
213: ,p_hwf_attribute26_o =>ben_hwf_shd.g_old_rec.hwf_attribute26
214: ,p_hwf_attribute27_o =>ben_hwf_shd.g_old_rec.hwf_attribute27
215: ,p_hwf_attribute28_o =>ben_hwf_shd.g_old_rec.hwf_attribute28
216: ,p_hwf_attribute29_o =>ben_hwf_shd.g_old_rec.hwf_attribute29
217: ,p_hwf_attribute30_o =>ben_hwf_shd.g_old_rec.hwf_attribute30
210: ,p_hwf_attribute23_o =>ben_hwf_shd.g_old_rec.hwf_attribute23
211: ,p_hwf_attribute24_o =>ben_hwf_shd.g_old_rec.hwf_attribute24
212: ,p_hwf_attribute25_o =>ben_hwf_shd.g_old_rec.hwf_attribute25
213: ,p_hwf_attribute26_o =>ben_hwf_shd.g_old_rec.hwf_attribute26
214: ,p_hwf_attribute27_o =>ben_hwf_shd.g_old_rec.hwf_attribute27
215: ,p_hwf_attribute28_o =>ben_hwf_shd.g_old_rec.hwf_attribute28
216: ,p_hwf_attribute29_o =>ben_hwf_shd.g_old_rec.hwf_attribute29
217: ,p_hwf_attribute30_o =>ben_hwf_shd.g_old_rec.hwf_attribute30
218: ,p_object_version_number_o =>ben_hwf_shd.g_old_rec.object_version_number
211: ,p_hwf_attribute24_o =>ben_hwf_shd.g_old_rec.hwf_attribute24
212: ,p_hwf_attribute25_o =>ben_hwf_shd.g_old_rec.hwf_attribute25
213: ,p_hwf_attribute26_o =>ben_hwf_shd.g_old_rec.hwf_attribute26
214: ,p_hwf_attribute27_o =>ben_hwf_shd.g_old_rec.hwf_attribute27
215: ,p_hwf_attribute28_o =>ben_hwf_shd.g_old_rec.hwf_attribute28
216: ,p_hwf_attribute29_o =>ben_hwf_shd.g_old_rec.hwf_attribute29
217: ,p_hwf_attribute30_o =>ben_hwf_shd.g_old_rec.hwf_attribute30
218: ,p_object_version_number_o =>ben_hwf_shd.g_old_rec.object_version_number
219: );
212: ,p_hwf_attribute25_o =>ben_hwf_shd.g_old_rec.hwf_attribute25
213: ,p_hwf_attribute26_o =>ben_hwf_shd.g_old_rec.hwf_attribute26
214: ,p_hwf_attribute27_o =>ben_hwf_shd.g_old_rec.hwf_attribute27
215: ,p_hwf_attribute28_o =>ben_hwf_shd.g_old_rec.hwf_attribute28
216: ,p_hwf_attribute29_o =>ben_hwf_shd.g_old_rec.hwf_attribute29
217: ,p_hwf_attribute30_o =>ben_hwf_shd.g_old_rec.hwf_attribute30
218: ,p_object_version_number_o =>ben_hwf_shd.g_old_rec.object_version_number
219: );
220: --
213: ,p_hwf_attribute26_o =>ben_hwf_shd.g_old_rec.hwf_attribute26
214: ,p_hwf_attribute27_o =>ben_hwf_shd.g_old_rec.hwf_attribute27
215: ,p_hwf_attribute28_o =>ben_hwf_shd.g_old_rec.hwf_attribute28
216: ,p_hwf_attribute29_o =>ben_hwf_shd.g_old_rec.hwf_attribute29
217: ,p_hwf_attribute30_o =>ben_hwf_shd.g_old_rec.hwf_attribute30
218: ,p_object_version_number_o =>ben_hwf_shd.g_old_rec.object_version_number
219: );
220: --
221: exception
214: ,p_hwf_attribute27_o =>ben_hwf_shd.g_old_rec.hwf_attribute27
215: ,p_hwf_attribute28_o =>ben_hwf_shd.g_old_rec.hwf_attribute28
216: ,p_hwf_attribute29_o =>ben_hwf_shd.g_old_rec.hwf_attribute29
217: ,p_hwf_attribute30_o =>ben_hwf_shd.g_old_rec.hwf_attribute30
218: ,p_object_version_number_o =>ben_hwf_shd.g_old_rec.object_version_number
219: );
220: --
221: exception
222: --
239: -- ----------------------------------------------------------------------------
240: Procedure del
241: (
242: p_effective_date in date,
243: p_rec in ben_hwf_shd.g_rec_type
244: ) is
245: --
246: l_proc varchar2(72) := g_package||'del';
247: --
249: hr_utility.set_location('Entering:'||l_proc, 5);
250: --
251: -- We must lock the row which we need to delete.
252: --
253: ben_hwf_shd.lck
254: (
255: p_rec.hrs_wkd_in_perd_fctr_id,
256: p_rec.object_version_number
257: );
284: p_hrs_wkd_in_perd_fctr_id in number,
285: p_object_version_number in number
286: ) is
287: --
288: l_rec ben_hwf_shd.g_rec_type;
289: l_proc varchar2(72) := g_package||'del';
290: --
291: Begin
292: hr_utility.set_location('Entering:'||l_proc, 5);