47: -- Internal Row Handler Use Only.
48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml(p_rec in ben_lsf_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_lsf_shd.g_api_dml := true; -- Set the api dml status
59: --
60: -- Delete the ben_los_fctr row.
61: --
62: delete from ben_los_fctr
61: --
62: delete from ben_los_fctr
63: where los_fctr_id = p_rec.los_fctr_id;
64: --
65: ben_lsf_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_lsf_shd.g_api_dml := false; -- Unset the api dml status
73: ben_lsf_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_lsf_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_lsf_shd.g_api_dml := false; -- Unset the api dml status
73: ben_lsf_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_lsf_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;
72: ben_lsf_shd.g_api_dml := false; -- Unset the api dml status
73: ben_lsf_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_lsf_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_lsf_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_lsf_shd.g_rec_type) is
156: --
157: l_proc varchar2(72) := g_package||'post_delete';
158: --
159: Begin
166: --
167: ben_lsf_rkd.after_delete
168: (
169: p_los_fctr_id =>p_rec.los_fctr_id
170: ,p_name_o =>ben_lsf_shd.g_old_rec.name
171: ,p_business_group_id_o =>ben_lsf_shd.g_old_rec.business_group_id
172: ,p_los_det_cd_o =>ben_lsf_shd.g_old_rec.los_det_cd
173: ,p_los_det_rl_o =>ben_lsf_shd.g_old_rec.los_det_rl
174: ,p_mn_los_num_o =>ben_lsf_shd.g_old_rec.mn_los_num
167: ben_lsf_rkd.after_delete
168: (
169: p_los_fctr_id =>p_rec.los_fctr_id
170: ,p_name_o =>ben_lsf_shd.g_old_rec.name
171: ,p_business_group_id_o =>ben_lsf_shd.g_old_rec.business_group_id
172: ,p_los_det_cd_o =>ben_lsf_shd.g_old_rec.los_det_cd
173: ,p_los_det_rl_o =>ben_lsf_shd.g_old_rec.los_det_rl
174: ,p_mn_los_num_o =>ben_lsf_shd.g_old_rec.mn_los_num
175: ,p_mx_los_num_o =>ben_lsf_shd.g_old_rec.mx_los_num
168: (
169: p_los_fctr_id =>p_rec.los_fctr_id
170: ,p_name_o =>ben_lsf_shd.g_old_rec.name
171: ,p_business_group_id_o =>ben_lsf_shd.g_old_rec.business_group_id
172: ,p_los_det_cd_o =>ben_lsf_shd.g_old_rec.los_det_cd
173: ,p_los_det_rl_o =>ben_lsf_shd.g_old_rec.los_det_rl
174: ,p_mn_los_num_o =>ben_lsf_shd.g_old_rec.mn_los_num
175: ,p_mx_los_num_o =>ben_lsf_shd.g_old_rec.mx_los_num
176: ,p_no_mx_los_num_apls_flag_o =>ben_lsf_shd.g_old_rec.no_mx_los_num_apls_flag
169: p_los_fctr_id =>p_rec.los_fctr_id
170: ,p_name_o =>ben_lsf_shd.g_old_rec.name
171: ,p_business_group_id_o =>ben_lsf_shd.g_old_rec.business_group_id
172: ,p_los_det_cd_o =>ben_lsf_shd.g_old_rec.los_det_cd
173: ,p_los_det_rl_o =>ben_lsf_shd.g_old_rec.los_det_rl
174: ,p_mn_los_num_o =>ben_lsf_shd.g_old_rec.mn_los_num
175: ,p_mx_los_num_o =>ben_lsf_shd.g_old_rec.mx_los_num
176: ,p_no_mx_los_num_apls_flag_o =>ben_lsf_shd.g_old_rec.no_mx_los_num_apls_flag
177: ,p_no_mn_los_num_apls_flag_o =>ben_lsf_shd.g_old_rec.no_mn_los_num_apls_flag
170: ,p_name_o =>ben_lsf_shd.g_old_rec.name
171: ,p_business_group_id_o =>ben_lsf_shd.g_old_rec.business_group_id
172: ,p_los_det_cd_o =>ben_lsf_shd.g_old_rec.los_det_cd
173: ,p_los_det_rl_o =>ben_lsf_shd.g_old_rec.los_det_rl
174: ,p_mn_los_num_o =>ben_lsf_shd.g_old_rec.mn_los_num
175: ,p_mx_los_num_o =>ben_lsf_shd.g_old_rec.mx_los_num
176: ,p_no_mx_los_num_apls_flag_o =>ben_lsf_shd.g_old_rec.no_mx_los_num_apls_flag
177: ,p_no_mn_los_num_apls_flag_o =>ben_lsf_shd.g_old_rec.no_mn_los_num_apls_flag
178: ,p_rndg_cd_o =>ben_lsf_shd.g_old_rec.rndg_cd
171: ,p_business_group_id_o =>ben_lsf_shd.g_old_rec.business_group_id
172: ,p_los_det_cd_o =>ben_lsf_shd.g_old_rec.los_det_cd
173: ,p_los_det_rl_o =>ben_lsf_shd.g_old_rec.los_det_rl
174: ,p_mn_los_num_o =>ben_lsf_shd.g_old_rec.mn_los_num
175: ,p_mx_los_num_o =>ben_lsf_shd.g_old_rec.mx_los_num
176: ,p_no_mx_los_num_apls_flag_o =>ben_lsf_shd.g_old_rec.no_mx_los_num_apls_flag
177: ,p_no_mn_los_num_apls_flag_o =>ben_lsf_shd.g_old_rec.no_mn_los_num_apls_flag
178: ,p_rndg_cd_o =>ben_lsf_shd.g_old_rec.rndg_cd
179: ,p_rndg_rl_o =>ben_lsf_shd.g_old_rec.rndg_rl
172: ,p_los_det_cd_o =>ben_lsf_shd.g_old_rec.los_det_cd
173: ,p_los_det_rl_o =>ben_lsf_shd.g_old_rec.los_det_rl
174: ,p_mn_los_num_o =>ben_lsf_shd.g_old_rec.mn_los_num
175: ,p_mx_los_num_o =>ben_lsf_shd.g_old_rec.mx_los_num
176: ,p_no_mx_los_num_apls_flag_o =>ben_lsf_shd.g_old_rec.no_mx_los_num_apls_flag
177: ,p_no_mn_los_num_apls_flag_o =>ben_lsf_shd.g_old_rec.no_mn_los_num_apls_flag
178: ,p_rndg_cd_o =>ben_lsf_shd.g_old_rec.rndg_cd
179: ,p_rndg_rl_o =>ben_lsf_shd.g_old_rec.rndg_rl
180: ,p_los_dt_to_use_cd_o =>ben_lsf_shd.g_old_rec.los_dt_to_use_cd
173: ,p_los_det_rl_o =>ben_lsf_shd.g_old_rec.los_det_rl
174: ,p_mn_los_num_o =>ben_lsf_shd.g_old_rec.mn_los_num
175: ,p_mx_los_num_o =>ben_lsf_shd.g_old_rec.mx_los_num
176: ,p_no_mx_los_num_apls_flag_o =>ben_lsf_shd.g_old_rec.no_mx_los_num_apls_flag
177: ,p_no_mn_los_num_apls_flag_o =>ben_lsf_shd.g_old_rec.no_mn_los_num_apls_flag
178: ,p_rndg_cd_o =>ben_lsf_shd.g_old_rec.rndg_cd
179: ,p_rndg_rl_o =>ben_lsf_shd.g_old_rec.rndg_rl
180: ,p_los_dt_to_use_cd_o =>ben_lsf_shd.g_old_rec.los_dt_to_use_cd
181: ,p_los_dt_to_use_rl_o =>ben_lsf_shd.g_old_rec.los_dt_to_use_rl
174: ,p_mn_los_num_o =>ben_lsf_shd.g_old_rec.mn_los_num
175: ,p_mx_los_num_o =>ben_lsf_shd.g_old_rec.mx_los_num
176: ,p_no_mx_los_num_apls_flag_o =>ben_lsf_shd.g_old_rec.no_mx_los_num_apls_flag
177: ,p_no_mn_los_num_apls_flag_o =>ben_lsf_shd.g_old_rec.no_mn_los_num_apls_flag
178: ,p_rndg_cd_o =>ben_lsf_shd.g_old_rec.rndg_cd
179: ,p_rndg_rl_o =>ben_lsf_shd.g_old_rec.rndg_rl
180: ,p_los_dt_to_use_cd_o =>ben_lsf_shd.g_old_rec.los_dt_to_use_cd
181: ,p_los_dt_to_use_rl_o =>ben_lsf_shd.g_old_rec.los_dt_to_use_rl
182: ,p_los_uom_o =>ben_lsf_shd.g_old_rec.los_uom
175: ,p_mx_los_num_o =>ben_lsf_shd.g_old_rec.mx_los_num
176: ,p_no_mx_los_num_apls_flag_o =>ben_lsf_shd.g_old_rec.no_mx_los_num_apls_flag
177: ,p_no_mn_los_num_apls_flag_o =>ben_lsf_shd.g_old_rec.no_mn_los_num_apls_flag
178: ,p_rndg_cd_o =>ben_lsf_shd.g_old_rec.rndg_cd
179: ,p_rndg_rl_o =>ben_lsf_shd.g_old_rec.rndg_rl
180: ,p_los_dt_to_use_cd_o =>ben_lsf_shd.g_old_rec.los_dt_to_use_cd
181: ,p_los_dt_to_use_rl_o =>ben_lsf_shd.g_old_rec.los_dt_to_use_rl
182: ,p_los_uom_o =>ben_lsf_shd.g_old_rec.los_uom
183: ,p_los_calc_rl_o =>ben_lsf_shd.g_old_rec.los_calc_rl
176: ,p_no_mx_los_num_apls_flag_o =>ben_lsf_shd.g_old_rec.no_mx_los_num_apls_flag
177: ,p_no_mn_los_num_apls_flag_o =>ben_lsf_shd.g_old_rec.no_mn_los_num_apls_flag
178: ,p_rndg_cd_o =>ben_lsf_shd.g_old_rec.rndg_cd
179: ,p_rndg_rl_o =>ben_lsf_shd.g_old_rec.rndg_rl
180: ,p_los_dt_to_use_cd_o =>ben_lsf_shd.g_old_rec.los_dt_to_use_cd
181: ,p_los_dt_to_use_rl_o =>ben_lsf_shd.g_old_rec.los_dt_to_use_rl
182: ,p_los_uom_o =>ben_lsf_shd.g_old_rec.los_uom
183: ,p_los_calc_rl_o =>ben_lsf_shd.g_old_rec.los_calc_rl
184: ,p_los_alt_val_to_use_cd_o =>ben_lsf_shd.g_old_rec.los_alt_val_to_use_cd
177: ,p_no_mn_los_num_apls_flag_o =>ben_lsf_shd.g_old_rec.no_mn_los_num_apls_flag
178: ,p_rndg_cd_o =>ben_lsf_shd.g_old_rec.rndg_cd
179: ,p_rndg_rl_o =>ben_lsf_shd.g_old_rec.rndg_rl
180: ,p_los_dt_to_use_cd_o =>ben_lsf_shd.g_old_rec.los_dt_to_use_cd
181: ,p_los_dt_to_use_rl_o =>ben_lsf_shd.g_old_rec.los_dt_to_use_rl
182: ,p_los_uom_o =>ben_lsf_shd.g_old_rec.los_uom
183: ,p_los_calc_rl_o =>ben_lsf_shd.g_old_rec.los_calc_rl
184: ,p_los_alt_val_to_use_cd_o =>ben_lsf_shd.g_old_rec.los_alt_val_to_use_cd
185: ,p_lsf_attribute_category_o =>ben_lsf_shd.g_old_rec.lsf_attribute_category
178: ,p_rndg_cd_o =>ben_lsf_shd.g_old_rec.rndg_cd
179: ,p_rndg_rl_o =>ben_lsf_shd.g_old_rec.rndg_rl
180: ,p_los_dt_to_use_cd_o =>ben_lsf_shd.g_old_rec.los_dt_to_use_cd
181: ,p_los_dt_to_use_rl_o =>ben_lsf_shd.g_old_rec.los_dt_to_use_rl
182: ,p_los_uom_o =>ben_lsf_shd.g_old_rec.los_uom
183: ,p_los_calc_rl_o =>ben_lsf_shd.g_old_rec.los_calc_rl
184: ,p_los_alt_val_to_use_cd_o =>ben_lsf_shd.g_old_rec.los_alt_val_to_use_cd
185: ,p_lsf_attribute_category_o =>ben_lsf_shd.g_old_rec.lsf_attribute_category
186: ,p_lsf_attribute1_o =>ben_lsf_shd.g_old_rec.lsf_attribute1
179: ,p_rndg_rl_o =>ben_lsf_shd.g_old_rec.rndg_rl
180: ,p_los_dt_to_use_cd_o =>ben_lsf_shd.g_old_rec.los_dt_to_use_cd
181: ,p_los_dt_to_use_rl_o =>ben_lsf_shd.g_old_rec.los_dt_to_use_rl
182: ,p_los_uom_o =>ben_lsf_shd.g_old_rec.los_uom
183: ,p_los_calc_rl_o =>ben_lsf_shd.g_old_rec.los_calc_rl
184: ,p_los_alt_val_to_use_cd_o =>ben_lsf_shd.g_old_rec.los_alt_val_to_use_cd
185: ,p_lsf_attribute_category_o =>ben_lsf_shd.g_old_rec.lsf_attribute_category
186: ,p_lsf_attribute1_o =>ben_lsf_shd.g_old_rec.lsf_attribute1
187: ,p_lsf_attribute2_o =>ben_lsf_shd.g_old_rec.lsf_attribute2
180: ,p_los_dt_to_use_cd_o =>ben_lsf_shd.g_old_rec.los_dt_to_use_cd
181: ,p_los_dt_to_use_rl_o =>ben_lsf_shd.g_old_rec.los_dt_to_use_rl
182: ,p_los_uom_o =>ben_lsf_shd.g_old_rec.los_uom
183: ,p_los_calc_rl_o =>ben_lsf_shd.g_old_rec.los_calc_rl
184: ,p_los_alt_val_to_use_cd_o =>ben_lsf_shd.g_old_rec.los_alt_val_to_use_cd
185: ,p_lsf_attribute_category_o =>ben_lsf_shd.g_old_rec.lsf_attribute_category
186: ,p_lsf_attribute1_o =>ben_lsf_shd.g_old_rec.lsf_attribute1
187: ,p_lsf_attribute2_o =>ben_lsf_shd.g_old_rec.lsf_attribute2
188: ,p_lsf_attribute3_o =>ben_lsf_shd.g_old_rec.lsf_attribute3
181: ,p_los_dt_to_use_rl_o =>ben_lsf_shd.g_old_rec.los_dt_to_use_rl
182: ,p_los_uom_o =>ben_lsf_shd.g_old_rec.los_uom
183: ,p_los_calc_rl_o =>ben_lsf_shd.g_old_rec.los_calc_rl
184: ,p_los_alt_val_to_use_cd_o =>ben_lsf_shd.g_old_rec.los_alt_val_to_use_cd
185: ,p_lsf_attribute_category_o =>ben_lsf_shd.g_old_rec.lsf_attribute_category
186: ,p_lsf_attribute1_o =>ben_lsf_shd.g_old_rec.lsf_attribute1
187: ,p_lsf_attribute2_o =>ben_lsf_shd.g_old_rec.lsf_attribute2
188: ,p_lsf_attribute3_o =>ben_lsf_shd.g_old_rec.lsf_attribute3
189: ,p_lsf_attribute4_o =>ben_lsf_shd.g_old_rec.lsf_attribute4
182: ,p_los_uom_o =>ben_lsf_shd.g_old_rec.los_uom
183: ,p_los_calc_rl_o =>ben_lsf_shd.g_old_rec.los_calc_rl
184: ,p_los_alt_val_to_use_cd_o =>ben_lsf_shd.g_old_rec.los_alt_val_to_use_cd
185: ,p_lsf_attribute_category_o =>ben_lsf_shd.g_old_rec.lsf_attribute_category
186: ,p_lsf_attribute1_o =>ben_lsf_shd.g_old_rec.lsf_attribute1
187: ,p_lsf_attribute2_o =>ben_lsf_shd.g_old_rec.lsf_attribute2
188: ,p_lsf_attribute3_o =>ben_lsf_shd.g_old_rec.lsf_attribute3
189: ,p_lsf_attribute4_o =>ben_lsf_shd.g_old_rec.lsf_attribute4
190: ,p_lsf_attribute5_o =>ben_lsf_shd.g_old_rec.lsf_attribute5
183: ,p_los_calc_rl_o =>ben_lsf_shd.g_old_rec.los_calc_rl
184: ,p_los_alt_val_to_use_cd_o =>ben_lsf_shd.g_old_rec.los_alt_val_to_use_cd
185: ,p_lsf_attribute_category_o =>ben_lsf_shd.g_old_rec.lsf_attribute_category
186: ,p_lsf_attribute1_o =>ben_lsf_shd.g_old_rec.lsf_attribute1
187: ,p_lsf_attribute2_o =>ben_lsf_shd.g_old_rec.lsf_attribute2
188: ,p_lsf_attribute3_o =>ben_lsf_shd.g_old_rec.lsf_attribute3
189: ,p_lsf_attribute4_o =>ben_lsf_shd.g_old_rec.lsf_attribute4
190: ,p_lsf_attribute5_o =>ben_lsf_shd.g_old_rec.lsf_attribute5
191: ,p_lsf_attribute6_o =>ben_lsf_shd.g_old_rec.lsf_attribute6
184: ,p_los_alt_val_to_use_cd_o =>ben_lsf_shd.g_old_rec.los_alt_val_to_use_cd
185: ,p_lsf_attribute_category_o =>ben_lsf_shd.g_old_rec.lsf_attribute_category
186: ,p_lsf_attribute1_o =>ben_lsf_shd.g_old_rec.lsf_attribute1
187: ,p_lsf_attribute2_o =>ben_lsf_shd.g_old_rec.lsf_attribute2
188: ,p_lsf_attribute3_o =>ben_lsf_shd.g_old_rec.lsf_attribute3
189: ,p_lsf_attribute4_o =>ben_lsf_shd.g_old_rec.lsf_attribute4
190: ,p_lsf_attribute5_o =>ben_lsf_shd.g_old_rec.lsf_attribute5
191: ,p_lsf_attribute6_o =>ben_lsf_shd.g_old_rec.lsf_attribute6
192: ,p_lsf_attribute7_o =>ben_lsf_shd.g_old_rec.lsf_attribute7
185: ,p_lsf_attribute_category_o =>ben_lsf_shd.g_old_rec.lsf_attribute_category
186: ,p_lsf_attribute1_o =>ben_lsf_shd.g_old_rec.lsf_attribute1
187: ,p_lsf_attribute2_o =>ben_lsf_shd.g_old_rec.lsf_attribute2
188: ,p_lsf_attribute3_o =>ben_lsf_shd.g_old_rec.lsf_attribute3
189: ,p_lsf_attribute4_o =>ben_lsf_shd.g_old_rec.lsf_attribute4
190: ,p_lsf_attribute5_o =>ben_lsf_shd.g_old_rec.lsf_attribute5
191: ,p_lsf_attribute6_o =>ben_lsf_shd.g_old_rec.lsf_attribute6
192: ,p_lsf_attribute7_o =>ben_lsf_shd.g_old_rec.lsf_attribute7
193: ,p_lsf_attribute8_o =>ben_lsf_shd.g_old_rec.lsf_attribute8
186: ,p_lsf_attribute1_o =>ben_lsf_shd.g_old_rec.lsf_attribute1
187: ,p_lsf_attribute2_o =>ben_lsf_shd.g_old_rec.lsf_attribute2
188: ,p_lsf_attribute3_o =>ben_lsf_shd.g_old_rec.lsf_attribute3
189: ,p_lsf_attribute4_o =>ben_lsf_shd.g_old_rec.lsf_attribute4
190: ,p_lsf_attribute5_o =>ben_lsf_shd.g_old_rec.lsf_attribute5
191: ,p_lsf_attribute6_o =>ben_lsf_shd.g_old_rec.lsf_attribute6
192: ,p_lsf_attribute7_o =>ben_lsf_shd.g_old_rec.lsf_attribute7
193: ,p_lsf_attribute8_o =>ben_lsf_shd.g_old_rec.lsf_attribute8
194: ,p_lsf_attribute9_o =>ben_lsf_shd.g_old_rec.lsf_attribute9
187: ,p_lsf_attribute2_o =>ben_lsf_shd.g_old_rec.lsf_attribute2
188: ,p_lsf_attribute3_o =>ben_lsf_shd.g_old_rec.lsf_attribute3
189: ,p_lsf_attribute4_o =>ben_lsf_shd.g_old_rec.lsf_attribute4
190: ,p_lsf_attribute5_o =>ben_lsf_shd.g_old_rec.lsf_attribute5
191: ,p_lsf_attribute6_o =>ben_lsf_shd.g_old_rec.lsf_attribute6
192: ,p_lsf_attribute7_o =>ben_lsf_shd.g_old_rec.lsf_attribute7
193: ,p_lsf_attribute8_o =>ben_lsf_shd.g_old_rec.lsf_attribute8
194: ,p_lsf_attribute9_o =>ben_lsf_shd.g_old_rec.lsf_attribute9
195: ,p_lsf_attribute10_o =>ben_lsf_shd.g_old_rec.lsf_attribute10
188: ,p_lsf_attribute3_o =>ben_lsf_shd.g_old_rec.lsf_attribute3
189: ,p_lsf_attribute4_o =>ben_lsf_shd.g_old_rec.lsf_attribute4
190: ,p_lsf_attribute5_o =>ben_lsf_shd.g_old_rec.lsf_attribute5
191: ,p_lsf_attribute6_o =>ben_lsf_shd.g_old_rec.lsf_attribute6
192: ,p_lsf_attribute7_o =>ben_lsf_shd.g_old_rec.lsf_attribute7
193: ,p_lsf_attribute8_o =>ben_lsf_shd.g_old_rec.lsf_attribute8
194: ,p_lsf_attribute9_o =>ben_lsf_shd.g_old_rec.lsf_attribute9
195: ,p_lsf_attribute10_o =>ben_lsf_shd.g_old_rec.lsf_attribute10
196: ,p_lsf_attribute11_o =>ben_lsf_shd.g_old_rec.lsf_attribute11
189: ,p_lsf_attribute4_o =>ben_lsf_shd.g_old_rec.lsf_attribute4
190: ,p_lsf_attribute5_o =>ben_lsf_shd.g_old_rec.lsf_attribute5
191: ,p_lsf_attribute6_o =>ben_lsf_shd.g_old_rec.lsf_attribute6
192: ,p_lsf_attribute7_o =>ben_lsf_shd.g_old_rec.lsf_attribute7
193: ,p_lsf_attribute8_o =>ben_lsf_shd.g_old_rec.lsf_attribute8
194: ,p_lsf_attribute9_o =>ben_lsf_shd.g_old_rec.lsf_attribute9
195: ,p_lsf_attribute10_o =>ben_lsf_shd.g_old_rec.lsf_attribute10
196: ,p_lsf_attribute11_o =>ben_lsf_shd.g_old_rec.lsf_attribute11
197: ,p_lsf_attribute12_o =>ben_lsf_shd.g_old_rec.lsf_attribute12
190: ,p_lsf_attribute5_o =>ben_lsf_shd.g_old_rec.lsf_attribute5
191: ,p_lsf_attribute6_o =>ben_lsf_shd.g_old_rec.lsf_attribute6
192: ,p_lsf_attribute7_o =>ben_lsf_shd.g_old_rec.lsf_attribute7
193: ,p_lsf_attribute8_o =>ben_lsf_shd.g_old_rec.lsf_attribute8
194: ,p_lsf_attribute9_o =>ben_lsf_shd.g_old_rec.lsf_attribute9
195: ,p_lsf_attribute10_o =>ben_lsf_shd.g_old_rec.lsf_attribute10
196: ,p_lsf_attribute11_o =>ben_lsf_shd.g_old_rec.lsf_attribute11
197: ,p_lsf_attribute12_o =>ben_lsf_shd.g_old_rec.lsf_attribute12
198: ,p_lsf_attribute13_o =>ben_lsf_shd.g_old_rec.lsf_attribute13
191: ,p_lsf_attribute6_o =>ben_lsf_shd.g_old_rec.lsf_attribute6
192: ,p_lsf_attribute7_o =>ben_lsf_shd.g_old_rec.lsf_attribute7
193: ,p_lsf_attribute8_o =>ben_lsf_shd.g_old_rec.lsf_attribute8
194: ,p_lsf_attribute9_o =>ben_lsf_shd.g_old_rec.lsf_attribute9
195: ,p_lsf_attribute10_o =>ben_lsf_shd.g_old_rec.lsf_attribute10
196: ,p_lsf_attribute11_o =>ben_lsf_shd.g_old_rec.lsf_attribute11
197: ,p_lsf_attribute12_o =>ben_lsf_shd.g_old_rec.lsf_attribute12
198: ,p_lsf_attribute13_o =>ben_lsf_shd.g_old_rec.lsf_attribute13
199: ,p_lsf_attribute14_o =>ben_lsf_shd.g_old_rec.lsf_attribute14
192: ,p_lsf_attribute7_o =>ben_lsf_shd.g_old_rec.lsf_attribute7
193: ,p_lsf_attribute8_o =>ben_lsf_shd.g_old_rec.lsf_attribute8
194: ,p_lsf_attribute9_o =>ben_lsf_shd.g_old_rec.lsf_attribute9
195: ,p_lsf_attribute10_o =>ben_lsf_shd.g_old_rec.lsf_attribute10
196: ,p_lsf_attribute11_o =>ben_lsf_shd.g_old_rec.lsf_attribute11
197: ,p_lsf_attribute12_o =>ben_lsf_shd.g_old_rec.lsf_attribute12
198: ,p_lsf_attribute13_o =>ben_lsf_shd.g_old_rec.lsf_attribute13
199: ,p_lsf_attribute14_o =>ben_lsf_shd.g_old_rec.lsf_attribute14
200: ,p_lsf_attribute15_o =>ben_lsf_shd.g_old_rec.lsf_attribute15
193: ,p_lsf_attribute8_o =>ben_lsf_shd.g_old_rec.lsf_attribute8
194: ,p_lsf_attribute9_o =>ben_lsf_shd.g_old_rec.lsf_attribute9
195: ,p_lsf_attribute10_o =>ben_lsf_shd.g_old_rec.lsf_attribute10
196: ,p_lsf_attribute11_o =>ben_lsf_shd.g_old_rec.lsf_attribute11
197: ,p_lsf_attribute12_o =>ben_lsf_shd.g_old_rec.lsf_attribute12
198: ,p_lsf_attribute13_o =>ben_lsf_shd.g_old_rec.lsf_attribute13
199: ,p_lsf_attribute14_o =>ben_lsf_shd.g_old_rec.lsf_attribute14
200: ,p_lsf_attribute15_o =>ben_lsf_shd.g_old_rec.lsf_attribute15
201: ,p_lsf_attribute16_o =>ben_lsf_shd.g_old_rec.lsf_attribute16
194: ,p_lsf_attribute9_o =>ben_lsf_shd.g_old_rec.lsf_attribute9
195: ,p_lsf_attribute10_o =>ben_lsf_shd.g_old_rec.lsf_attribute10
196: ,p_lsf_attribute11_o =>ben_lsf_shd.g_old_rec.lsf_attribute11
197: ,p_lsf_attribute12_o =>ben_lsf_shd.g_old_rec.lsf_attribute12
198: ,p_lsf_attribute13_o =>ben_lsf_shd.g_old_rec.lsf_attribute13
199: ,p_lsf_attribute14_o =>ben_lsf_shd.g_old_rec.lsf_attribute14
200: ,p_lsf_attribute15_o =>ben_lsf_shd.g_old_rec.lsf_attribute15
201: ,p_lsf_attribute16_o =>ben_lsf_shd.g_old_rec.lsf_attribute16
202: ,p_lsf_attribute17_o =>ben_lsf_shd.g_old_rec.lsf_attribute17
195: ,p_lsf_attribute10_o =>ben_lsf_shd.g_old_rec.lsf_attribute10
196: ,p_lsf_attribute11_o =>ben_lsf_shd.g_old_rec.lsf_attribute11
197: ,p_lsf_attribute12_o =>ben_lsf_shd.g_old_rec.lsf_attribute12
198: ,p_lsf_attribute13_o =>ben_lsf_shd.g_old_rec.lsf_attribute13
199: ,p_lsf_attribute14_o =>ben_lsf_shd.g_old_rec.lsf_attribute14
200: ,p_lsf_attribute15_o =>ben_lsf_shd.g_old_rec.lsf_attribute15
201: ,p_lsf_attribute16_o =>ben_lsf_shd.g_old_rec.lsf_attribute16
202: ,p_lsf_attribute17_o =>ben_lsf_shd.g_old_rec.lsf_attribute17
203: ,p_lsf_attribute18_o =>ben_lsf_shd.g_old_rec.lsf_attribute18
196: ,p_lsf_attribute11_o =>ben_lsf_shd.g_old_rec.lsf_attribute11
197: ,p_lsf_attribute12_o =>ben_lsf_shd.g_old_rec.lsf_attribute12
198: ,p_lsf_attribute13_o =>ben_lsf_shd.g_old_rec.lsf_attribute13
199: ,p_lsf_attribute14_o =>ben_lsf_shd.g_old_rec.lsf_attribute14
200: ,p_lsf_attribute15_o =>ben_lsf_shd.g_old_rec.lsf_attribute15
201: ,p_lsf_attribute16_o =>ben_lsf_shd.g_old_rec.lsf_attribute16
202: ,p_lsf_attribute17_o =>ben_lsf_shd.g_old_rec.lsf_attribute17
203: ,p_lsf_attribute18_o =>ben_lsf_shd.g_old_rec.lsf_attribute18
204: ,p_lsf_attribute19_o =>ben_lsf_shd.g_old_rec.lsf_attribute19
197: ,p_lsf_attribute12_o =>ben_lsf_shd.g_old_rec.lsf_attribute12
198: ,p_lsf_attribute13_o =>ben_lsf_shd.g_old_rec.lsf_attribute13
199: ,p_lsf_attribute14_o =>ben_lsf_shd.g_old_rec.lsf_attribute14
200: ,p_lsf_attribute15_o =>ben_lsf_shd.g_old_rec.lsf_attribute15
201: ,p_lsf_attribute16_o =>ben_lsf_shd.g_old_rec.lsf_attribute16
202: ,p_lsf_attribute17_o =>ben_lsf_shd.g_old_rec.lsf_attribute17
203: ,p_lsf_attribute18_o =>ben_lsf_shd.g_old_rec.lsf_attribute18
204: ,p_lsf_attribute19_o =>ben_lsf_shd.g_old_rec.lsf_attribute19
205: ,p_lsf_attribute20_o =>ben_lsf_shd.g_old_rec.lsf_attribute20
198: ,p_lsf_attribute13_o =>ben_lsf_shd.g_old_rec.lsf_attribute13
199: ,p_lsf_attribute14_o =>ben_lsf_shd.g_old_rec.lsf_attribute14
200: ,p_lsf_attribute15_o =>ben_lsf_shd.g_old_rec.lsf_attribute15
201: ,p_lsf_attribute16_o =>ben_lsf_shd.g_old_rec.lsf_attribute16
202: ,p_lsf_attribute17_o =>ben_lsf_shd.g_old_rec.lsf_attribute17
203: ,p_lsf_attribute18_o =>ben_lsf_shd.g_old_rec.lsf_attribute18
204: ,p_lsf_attribute19_o =>ben_lsf_shd.g_old_rec.lsf_attribute19
205: ,p_lsf_attribute20_o =>ben_lsf_shd.g_old_rec.lsf_attribute20
206: ,p_lsf_attribute21_o =>ben_lsf_shd.g_old_rec.lsf_attribute21
199: ,p_lsf_attribute14_o =>ben_lsf_shd.g_old_rec.lsf_attribute14
200: ,p_lsf_attribute15_o =>ben_lsf_shd.g_old_rec.lsf_attribute15
201: ,p_lsf_attribute16_o =>ben_lsf_shd.g_old_rec.lsf_attribute16
202: ,p_lsf_attribute17_o =>ben_lsf_shd.g_old_rec.lsf_attribute17
203: ,p_lsf_attribute18_o =>ben_lsf_shd.g_old_rec.lsf_attribute18
204: ,p_lsf_attribute19_o =>ben_lsf_shd.g_old_rec.lsf_attribute19
205: ,p_lsf_attribute20_o =>ben_lsf_shd.g_old_rec.lsf_attribute20
206: ,p_lsf_attribute21_o =>ben_lsf_shd.g_old_rec.lsf_attribute21
207: ,p_lsf_attribute22_o =>ben_lsf_shd.g_old_rec.lsf_attribute22
200: ,p_lsf_attribute15_o =>ben_lsf_shd.g_old_rec.lsf_attribute15
201: ,p_lsf_attribute16_o =>ben_lsf_shd.g_old_rec.lsf_attribute16
202: ,p_lsf_attribute17_o =>ben_lsf_shd.g_old_rec.lsf_attribute17
203: ,p_lsf_attribute18_o =>ben_lsf_shd.g_old_rec.lsf_attribute18
204: ,p_lsf_attribute19_o =>ben_lsf_shd.g_old_rec.lsf_attribute19
205: ,p_lsf_attribute20_o =>ben_lsf_shd.g_old_rec.lsf_attribute20
206: ,p_lsf_attribute21_o =>ben_lsf_shd.g_old_rec.lsf_attribute21
207: ,p_lsf_attribute22_o =>ben_lsf_shd.g_old_rec.lsf_attribute22
208: ,p_lsf_attribute23_o =>ben_lsf_shd.g_old_rec.lsf_attribute23
201: ,p_lsf_attribute16_o =>ben_lsf_shd.g_old_rec.lsf_attribute16
202: ,p_lsf_attribute17_o =>ben_lsf_shd.g_old_rec.lsf_attribute17
203: ,p_lsf_attribute18_o =>ben_lsf_shd.g_old_rec.lsf_attribute18
204: ,p_lsf_attribute19_o =>ben_lsf_shd.g_old_rec.lsf_attribute19
205: ,p_lsf_attribute20_o =>ben_lsf_shd.g_old_rec.lsf_attribute20
206: ,p_lsf_attribute21_o =>ben_lsf_shd.g_old_rec.lsf_attribute21
207: ,p_lsf_attribute22_o =>ben_lsf_shd.g_old_rec.lsf_attribute22
208: ,p_lsf_attribute23_o =>ben_lsf_shd.g_old_rec.lsf_attribute23
209: ,p_lsf_attribute24_o =>ben_lsf_shd.g_old_rec.lsf_attribute24
202: ,p_lsf_attribute17_o =>ben_lsf_shd.g_old_rec.lsf_attribute17
203: ,p_lsf_attribute18_o =>ben_lsf_shd.g_old_rec.lsf_attribute18
204: ,p_lsf_attribute19_o =>ben_lsf_shd.g_old_rec.lsf_attribute19
205: ,p_lsf_attribute20_o =>ben_lsf_shd.g_old_rec.lsf_attribute20
206: ,p_lsf_attribute21_o =>ben_lsf_shd.g_old_rec.lsf_attribute21
207: ,p_lsf_attribute22_o =>ben_lsf_shd.g_old_rec.lsf_attribute22
208: ,p_lsf_attribute23_o =>ben_lsf_shd.g_old_rec.lsf_attribute23
209: ,p_lsf_attribute24_o =>ben_lsf_shd.g_old_rec.lsf_attribute24
210: ,p_lsf_attribute25_o =>ben_lsf_shd.g_old_rec.lsf_attribute25
203: ,p_lsf_attribute18_o =>ben_lsf_shd.g_old_rec.lsf_attribute18
204: ,p_lsf_attribute19_o =>ben_lsf_shd.g_old_rec.lsf_attribute19
205: ,p_lsf_attribute20_o =>ben_lsf_shd.g_old_rec.lsf_attribute20
206: ,p_lsf_attribute21_o =>ben_lsf_shd.g_old_rec.lsf_attribute21
207: ,p_lsf_attribute22_o =>ben_lsf_shd.g_old_rec.lsf_attribute22
208: ,p_lsf_attribute23_o =>ben_lsf_shd.g_old_rec.lsf_attribute23
209: ,p_lsf_attribute24_o =>ben_lsf_shd.g_old_rec.lsf_attribute24
210: ,p_lsf_attribute25_o =>ben_lsf_shd.g_old_rec.lsf_attribute25
211: ,p_lsf_attribute26_o =>ben_lsf_shd.g_old_rec.lsf_attribute26
204: ,p_lsf_attribute19_o =>ben_lsf_shd.g_old_rec.lsf_attribute19
205: ,p_lsf_attribute20_o =>ben_lsf_shd.g_old_rec.lsf_attribute20
206: ,p_lsf_attribute21_o =>ben_lsf_shd.g_old_rec.lsf_attribute21
207: ,p_lsf_attribute22_o =>ben_lsf_shd.g_old_rec.lsf_attribute22
208: ,p_lsf_attribute23_o =>ben_lsf_shd.g_old_rec.lsf_attribute23
209: ,p_lsf_attribute24_o =>ben_lsf_shd.g_old_rec.lsf_attribute24
210: ,p_lsf_attribute25_o =>ben_lsf_shd.g_old_rec.lsf_attribute25
211: ,p_lsf_attribute26_o =>ben_lsf_shd.g_old_rec.lsf_attribute26
212: ,p_lsf_attribute27_o =>ben_lsf_shd.g_old_rec.lsf_attribute27
205: ,p_lsf_attribute20_o =>ben_lsf_shd.g_old_rec.lsf_attribute20
206: ,p_lsf_attribute21_o =>ben_lsf_shd.g_old_rec.lsf_attribute21
207: ,p_lsf_attribute22_o =>ben_lsf_shd.g_old_rec.lsf_attribute22
208: ,p_lsf_attribute23_o =>ben_lsf_shd.g_old_rec.lsf_attribute23
209: ,p_lsf_attribute24_o =>ben_lsf_shd.g_old_rec.lsf_attribute24
210: ,p_lsf_attribute25_o =>ben_lsf_shd.g_old_rec.lsf_attribute25
211: ,p_lsf_attribute26_o =>ben_lsf_shd.g_old_rec.lsf_attribute26
212: ,p_lsf_attribute27_o =>ben_lsf_shd.g_old_rec.lsf_attribute27
213: ,p_lsf_attribute28_o =>ben_lsf_shd.g_old_rec.lsf_attribute28
206: ,p_lsf_attribute21_o =>ben_lsf_shd.g_old_rec.lsf_attribute21
207: ,p_lsf_attribute22_o =>ben_lsf_shd.g_old_rec.lsf_attribute22
208: ,p_lsf_attribute23_o =>ben_lsf_shd.g_old_rec.lsf_attribute23
209: ,p_lsf_attribute24_o =>ben_lsf_shd.g_old_rec.lsf_attribute24
210: ,p_lsf_attribute25_o =>ben_lsf_shd.g_old_rec.lsf_attribute25
211: ,p_lsf_attribute26_o =>ben_lsf_shd.g_old_rec.lsf_attribute26
212: ,p_lsf_attribute27_o =>ben_lsf_shd.g_old_rec.lsf_attribute27
213: ,p_lsf_attribute28_o =>ben_lsf_shd.g_old_rec.lsf_attribute28
214: ,p_lsf_attribute29_o =>ben_lsf_shd.g_old_rec.lsf_attribute29
207: ,p_lsf_attribute22_o =>ben_lsf_shd.g_old_rec.lsf_attribute22
208: ,p_lsf_attribute23_o =>ben_lsf_shd.g_old_rec.lsf_attribute23
209: ,p_lsf_attribute24_o =>ben_lsf_shd.g_old_rec.lsf_attribute24
210: ,p_lsf_attribute25_o =>ben_lsf_shd.g_old_rec.lsf_attribute25
211: ,p_lsf_attribute26_o =>ben_lsf_shd.g_old_rec.lsf_attribute26
212: ,p_lsf_attribute27_o =>ben_lsf_shd.g_old_rec.lsf_attribute27
213: ,p_lsf_attribute28_o =>ben_lsf_shd.g_old_rec.lsf_attribute28
214: ,p_lsf_attribute29_o =>ben_lsf_shd.g_old_rec.lsf_attribute29
215: ,p_lsf_attribute30_o =>ben_lsf_shd.g_old_rec.lsf_attribute30
208: ,p_lsf_attribute23_o =>ben_lsf_shd.g_old_rec.lsf_attribute23
209: ,p_lsf_attribute24_o =>ben_lsf_shd.g_old_rec.lsf_attribute24
210: ,p_lsf_attribute25_o =>ben_lsf_shd.g_old_rec.lsf_attribute25
211: ,p_lsf_attribute26_o =>ben_lsf_shd.g_old_rec.lsf_attribute26
212: ,p_lsf_attribute27_o =>ben_lsf_shd.g_old_rec.lsf_attribute27
213: ,p_lsf_attribute28_o =>ben_lsf_shd.g_old_rec.lsf_attribute28
214: ,p_lsf_attribute29_o =>ben_lsf_shd.g_old_rec.lsf_attribute29
215: ,p_lsf_attribute30_o =>ben_lsf_shd.g_old_rec.lsf_attribute30
216: ,p_object_version_number_o =>ben_lsf_shd.g_old_rec.object_version_number
209: ,p_lsf_attribute24_o =>ben_lsf_shd.g_old_rec.lsf_attribute24
210: ,p_lsf_attribute25_o =>ben_lsf_shd.g_old_rec.lsf_attribute25
211: ,p_lsf_attribute26_o =>ben_lsf_shd.g_old_rec.lsf_attribute26
212: ,p_lsf_attribute27_o =>ben_lsf_shd.g_old_rec.lsf_attribute27
213: ,p_lsf_attribute28_o =>ben_lsf_shd.g_old_rec.lsf_attribute28
214: ,p_lsf_attribute29_o =>ben_lsf_shd.g_old_rec.lsf_attribute29
215: ,p_lsf_attribute30_o =>ben_lsf_shd.g_old_rec.lsf_attribute30
216: ,p_object_version_number_o =>ben_lsf_shd.g_old_rec.object_version_number
217: ,p_use_overid_svc_dt_flag_o =>ben_lsf_shd.g_old_rec.use_overid_svc_dt_flag
210: ,p_lsf_attribute25_o =>ben_lsf_shd.g_old_rec.lsf_attribute25
211: ,p_lsf_attribute26_o =>ben_lsf_shd.g_old_rec.lsf_attribute26
212: ,p_lsf_attribute27_o =>ben_lsf_shd.g_old_rec.lsf_attribute27
213: ,p_lsf_attribute28_o =>ben_lsf_shd.g_old_rec.lsf_attribute28
214: ,p_lsf_attribute29_o =>ben_lsf_shd.g_old_rec.lsf_attribute29
215: ,p_lsf_attribute30_o =>ben_lsf_shd.g_old_rec.lsf_attribute30
216: ,p_object_version_number_o =>ben_lsf_shd.g_old_rec.object_version_number
217: ,p_use_overid_svc_dt_flag_o =>ben_lsf_shd.g_old_rec.use_overid_svc_dt_flag
218: );
211: ,p_lsf_attribute26_o =>ben_lsf_shd.g_old_rec.lsf_attribute26
212: ,p_lsf_attribute27_o =>ben_lsf_shd.g_old_rec.lsf_attribute27
213: ,p_lsf_attribute28_o =>ben_lsf_shd.g_old_rec.lsf_attribute28
214: ,p_lsf_attribute29_o =>ben_lsf_shd.g_old_rec.lsf_attribute29
215: ,p_lsf_attribute30_o =>ben_lsf_shd.g_old_rec.lsf_attribute30
216: ,p_object_version_number_o =>ben_lsf_shd.g_old_rec.object_version_number
217: ,p_use_overid_svc_dt_flag_o =>ben_lsf_shd.g_old_rec.use_overid_svc_dt_flag
218: );
219: --
212: ,p_lsf_attribute27_o =>ben_lsf_shd.g_old_rec.lsf_attribute27
213: ,p_lsf_attribute28_o =>ben_lsf_shd.g_old_rec.lsf_attribute28
214: ,p_lsf_attribute29_o =>ben_lsf_shd.g_old_rec.lsf_attribute29
215: ,p_lsf_attribute30_o =>ben_lsf_shd.g_old_rec.lsf_attribute30
216: ,p_object_version_number_o =>ben_lsf_shd.g_old_rec.object_version_number
217: ,p_use_overid_svc_dt_flag_o =>ben_lsf_shd.g_old_rec.use_overid_svc_dt_flag
218: );
219: --
220: exception
213: ,p_lsf_attribute28_o =>ben_lsf_shd.g_old_rec.lsf_attribute28
214: ,p_lsf_attribute29_o =>ben_lsf_shd.g_old_rec.lsf_attribute29
215: ,p_lsf_attribute30_o =>ben_lsf_shd.g_old_rec.lsf_attribute30
216: ,p_object_version_number_o =>ben_lsf_shd.g_old_rec.object_version_number
217: ,p_use_overid_svc_dt_flag_o =>ben_lsf_shd.g_old_rec.use_overid_svc_dt_flag
218: );
219: --
220: exception
221: --
238: -- ----------------------------------------------------------------------------
239: Procedure del
240: (
241: p_effective_date in date,
242: p_rec in ben_lsf_shd.g_rec_type
243: ) is
244: --
245: l_proc varchar2(72) := g_package||'del';
246: --
248: hr_utility.set_location('Entering:'||l_proc, 5);
249: --
250: -- We must lock the row which we need to delete.
251: --
252: ben_lsf_shd.lck
253: (
254: p_rec.los_fctr_id,
255: p_rec.object_version_number
256: );
283: p_los_fctr_id in number,
284: p_object_version_number in number
285: ) is
286: --
287: l_rec ben_lsf_shd.g_rec_type;
288: l_proc varchar2(72) := g_package||'del';
289: --
290: Begin
291: hr_utility.set_location('Entering:'||l_proc, 5);