82: -- Internal Row Handler Use Only.
83: --
84: -- {End Of Comments}
85: -- ----------------------------------------------------------------------------
86: Procedure delete_dml(p_rec in ben_xel_shd.g_rec_type) is
87: --
88: l_proc varchar2(72) := g_package||'delete_dml';
89: --
90: Begin
89: --
90: Begin
91: hr_utility.set_location('Entering:'||l_proc, 5);
92: --
93: ben_xel_shd.g_api_dml := true; -- Set the api dml status
94: --
95: -- Delete the ben_ext_data_elmt row.
96: --
97: delete from ben_ext_data_elmt
96: --
97: delete from ben_ext_data_elmt
98: where ext_data_elmt_id = p_rec.ext_data_elmt_id;
99: --
100: ben_xel_shd.g_api_dml := false; -- Unset the api dml status
101: --
102: hr_utility.set_location(' Leaving:'||l_proc, 10);
103: --
104: Exception
103: --
104: Exception
105: When hr_api.child_integrity_violated then
106: -- Child integrity has been violated
107: ben_xel_shd.g_api_dml := false; -- Unset the api dml status
108: ben_xel_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When Others Then
111: ben_xel_shd.g_api_dml := false; -- Unset the api dml status
104: Exception
105: When hr_api.child_integrity_violated then
106: -- Child integrity has been violated
107: ben_xel_shd.g_api_dml := false; -- Unset the api dml status
108: ben_xel_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When Others Then
111: ben_xel_shd.g_api_dml := false; -- Unset the api dml status
112: Raise;
107: ben_xel_shd.g_api_dml := false; -- Unset the api dml status
108: ben_xel_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When Others Then
111: ben_xel_shd.g_api_dml := false; -- Unset the api dml status
112: Raise;
113: End delete_dml;
114: --
115: -- ----------------------------------------------------------------------------
143: -- Internal Row Handler Use Only.
144: --
145: -- {End Of Comments}
146: -- ----------------------------------------------------------------------------
147: Procedure pre_delete(p_rec in ben_xel_shd.g_rec_type) is
148: --
149: l_proc varchar2(72) := g_package||'pre_delete';
150: --
151: Begin
186: --
187: -- {End Of Comments}
188: -- ----------------------------------------------------------------------------
189: Procedure post_delete(
190: p_effective_date in date,p_rec in ben_xel_shd.g_rec_type) is
191: --
192: l_proc varchar2(72) := g_package||'post_delete';
193: --
194: Begin
206: --
207: ben_xel_rkd.after_delete
208: (
209: p_ext_data_elmt_id =>p_rec.ext_data_elmt_id
210: ,p_name_o =>ben_xel_shd.g_old_rec.name
211: ,p_xml_tag_name_o =>ben_xel_shd.g_old_rec.name
212: ,p_data_elmt_typ_cd_o =>ben_xel_shd.g_old_rec.data_elmt_typ_cd
213: ,p_data_elmt_rl_o =>ben_xel_shd.g_old_rec.data_elmt_rl
214: ,p_frmt_mask_cd_o =>ben_xel_shd.g_old_rec.frmt_mask_cd
207: ben_xel_rkd.after_delete
208: (
209: p_ext_data_elmt_id =>p_rec.ext_data_elmt_id
210: ,p_name_o =>ben_xel_shd.g_old_rec.name
211: ,p_xml_tag_name_o =>ben_xel_shd.g_old_rec.name
212: ,p_data_elmt_typ_cd_o =>ben_xel_shd.g_old_rec.data_elmt_typ_cd
213: ,p_data_elmt_rl_o =>ben_xel_shd.g_old_rec.data_elmt_rl
214: ,p_frmt_mask_cd_o =>ben_xel_shd.g_old_rec.frmt_mask_cd
215: ,p_string_val_o =>ben_xel_shd.g_old_rec.string_val
208: (
209: p_ext_data_elmt_id =>p_rec.ext_data_elmt_id
210: ,p_name_o =>ben_xel_shd.g_old_rec.name
211: ,p_xml_tag_name_o =>ben_xel_shd.g_old_rec.name
212: ,p_data_elmt_typ_cd_o =>ben_xel_shd.g_old_rec.data_elmt_typ_cd
213: ,p_data_elmt_rl_o =>ben_xel_shd.g_old_rec.data_elmt_rl
214: ,p_frmt_mask_cd_o =>ben_xel_shd.g_old_rec.frmt_mask_cd
215: ,p_string_val_o =>ben_xel_shd.g_old_rec.string_val
216: ,p_dflt_val_o =>ben_xel_shd.g_old_rec.dflt_val
209: p_ext_data_elmt_id =>p_rec.ext_data_elmt_id
210: ,p_name_o =>ben_xel_shd.g_old_rec.name
211: ,p_xml_tag_name_o =>ben_xel_shd.g_old_rec.name
212: ,p_data_elmt_typ_cd_o =>ben_xel_shd.g_old_rec.data_elmt_typ_cd
213: ,p_data_elmt_rl_o =>ben_xel_shd.g_old_rec.data_elmt_rl
214: ,p_frmt_mask_cd_o =>ben_xel_shd.g_old_rec.frmt_mask_cd
215: ,p_string_val_o =>ben_xel_shd.g_old_rec.string_val
216: ,p_dflt_val_o =>ben_xel_shd.g_old_rec.dflt_val
217: ,p_max_length_num_o =>ben_xel_shd.g_old_rec.max_length_num
210: ,p_name_o =>ben_xel_shd.g_old_rec.name
211: ,p_xml_tag_name_o =>ben_xel_shd.g_old_rec.name
212: ,p_data_elmt_typ_cd_o =>ben_xel_shd.g_old_rec.data_elmt_typ_cd
213: ,p_data_elmt_rl_o =>ben_xel_shd.g_old_rec.data_elmt_rl
214: ,p_frmt_mask_cd_o =>ben_xel_shd.g_old_rec.frmt_mask_cd
215: ,p_string_val_o =>ben_xel_shd.g_old_rec.string_val
216: ,p_dflt_val_o =>ben_xel_shd.g_old_rec.dflt_val
217: ,p_max_length_num_o =>ben_xel_shd.g_old_rec.max_length_num
218: ,p_just_cd_o =>ben_xel_shd.g_old_rec.just_cd
211: ,p_xml_tag_name_o =>ben_xel_shd.g_old_rec.name
212: ,p_data_elmt_typ_cd_o =>ben_xel_shd.g_old_rec.data_elmt_typ_cd
213: ,p_data_elmt_rl_o =>ben_xel_shd.g_old_rec.data_elmt_rl
214: ,p_frmt_mask_cd_o =>ben_xel_shd.g_old_rec.frmt_mask_cd
215: ,p_string_val_o =>ben_xel_shd.g_old_rec.string_val
216: ,p_dflt_val_o =>ben_xel_shd.g_old_rec.dflt_val
217: ,p_max_length_num_o =>ben_xel_shd.g_old_rec.max_length_num
218: ,p_just_cd_o =>ben_xel_shd.g_old_rec.just_cd
219: ,p_ttl_fnctn_cd_o =>ben_xel_shd.g_old_rec.ttl_fnctn_cd,
212: ,p_data_elmt_typ_cd_o =>ben_xel_shd.g_old_rec.data_elmt_typ_cd
213: ,p_data_elmt_rl_o =>ben_xel_shd.g_old_rec.data_elmt_rl
214: ,p_frmt_mask_cd_o =>ben_xel_shd.g_old_rec.frmt_mask_cd
215: ,p_string_val_o =>ben_xel_shd.g_old_rec.string_val
216: ,p_dflt_val_o =>ben_xel_shd.g_old_rec.dflt_val
217: ,p_max_length_num_o =>ben_xel_shd.g_old_rec.max_length_num
218: ,p_just_cd_o =>ben_xel_shd.g_old_rec.just_cd
219: ,p_ttl_fnctn_cd_o =>ben_xel_shd.g_old_rec.ttl_fnctn_cd,
220: p_ttl_cond_oper_cd_o =>ben_xel_shd.g_old_rec.ttl_cond_oper_cd,
213: ,p_data_elmt_rl_o =>ben_xel_shd.g_old_rec.data_elmt_rl
214: ,p_frmt_mask_cd_o =>ben_xel_shd.g_old_rec.frmt_mask_cd
215: ,p_string_val_o =>ben_xel_shd.g_old_rec.string_val
216: ,p_dflt_val_o =>ben_xel_shd.g_old_rec.dflt_val
217: ,p_max_length_num_o =>ben_xel_shd.g_old_rec.max_length_num
218: ,p_just_cd_o =>ben_xel_shd.g_old_rec.just_cd
219: ,p_ttl_fnctn_cd_o =>ben_xel_shd.g_old_rec.ttl_fnctn_cd,
220: p_ttl_cond_oper_cd_o =>ben_xel_shd.g_old_rec.ttl_cond_oper_cd,
221: p_ttl_cond_val_o =>ben_xel_shd.g_old_rec.ttl_cond_val,
214: ,p_frmt_mask_cd_o =>ben_xel_shd.g_old_rec.frmt_mask_cd
215: ,p_string_val_o =>ben_xel_shd.g_old_rec.string_val
216: ,p_dflt_val_o =>ben_xel_shd.g_old_rec.dflt_val
217: ,p_max_length_num_o =>ben_xel_shd.g_old_rec.max_length_num
218: ,p_just_cd_o =>ben_xel_shd.g_old_rec.just_cd
219: ,p_ttl_fnctn_cd_o =>ben_xel_shd.g_old_rec.ttl_fnctn_cd,
220: p_ttl_cond_oper_cd_o =>ben_xel_shd.g_old_rec.ttl_cond_oper_cd,
221: p_ttl_cond_val_o =>ben_xel_shd.g_old_rec.ttl_cond_val,
222: p_ttl_sum_ext_data_elmt_id_o =>ben_xel_shd.g_old_rec.ttl_sum_ext_data_elmt_id,
215: ,p_string_val_o =>ben_xel_shd.g_old_rec.string_val
216: ,p_dflt_val_o =>ben_xel_shd.g_old_rec.dflt_val
217: ,p_max_length_num_o =>ben_xel_shd.g_old_rec.max_length_num
218: ,p_just_cd_o =>ben_xel_shd.g_old_rec.just_cd
219: ,p_ttl_fnctn_cd_o =>ben_xel_shd.g_old_rec.ttl_fnctn_cd,
220: p_ttl_cond_oper_cd_o =>ben_xel_shd.g_old_rec.ttl_cond_oper_cd,
221: p_ttl_cond_val_o =>ben_xel_shd.g_old_rec.ttl_cond_val,
222: p_ttl_sum_ext_data_elmt_id_o =>ben_xel_shd.g_old_rec.ttl_sum_ext_data_elmt_id,
223: p_ttl_cond_ext_data_elmt_id_o =>ben_xel_shd.g_old_rec.ttl_cond_ext_data_elmt_id ,
216: ,p_dflt_val_o =>ben_xel_shd.g_old_rec.dflt_val
217: ,p_max_length_num_o =>ben_xel_shd.g_old_rec.max_length_num
218: ,p_just_cd_o =>ben_xel_shd.g_old_rec.just_cd
219: ,p_ttl_fnctn_cd_o =>ben_xel_shd.g_old_rec.ttl_fnctn_cd,
220: p_ttl_cond_oper_cd_o =>ben_xel_shd.g_old_rec.ttl_cond_oper_cd,
221: p_ttl_cond_val_o =>ben_xel_shd.g_old_rec.ttl_cond_val,
222: p_ttl_sum_ext_data_elmt_id_o =>ben_xel_shd.g_old_rec.ttl_sum_ext_data_elmt_id,
223: p_ttl_cond_ext_data_elmt_id_o =>ben_xel_shd.g_old_rec.ttl_cond_ext_data_elmt_id ,
224: p_ext_fld_id_o =>ben_xel_shd.g_old_rec.ext_fld_id
217: ,p_max_length_num_o =>ben_xel_shd.g_old_rec.max_length_num
218: ,p_just_cd_o =>ben_xel_shd.g_old_rec.just_cd
219: ,p_ttl_fnctn_cd_o =>ben_xel_shd.g_old_rec.ttl_fnctn_cd,
220: p_ttl_cond_oper_cd_o =>ben_xel_shd.g_old_rec.ttl_cond_oper_cd,
221: p_ttl_cond_val_o =>ben_xel_shd.g_old_rec.ttl_cond_val,
222: p_ttl_sum_ext_data_elmt_id_o =>ben_xel_shd.g_old_rec.ttl_sum_ext_data_elmt_id,
223: p_ttl_cond_ext_data_elmt_id_o =>ben_xel_shd.g_old_rec.ttl_cond_ext_data_elmt_id ,
224: p_ext_fld_id_o =>ben_xel_shd.g_old_rec.ext_fld_id
225: ,p_business_group_id_o =>ben_xel_shd.g_old_rec.business_group_id
218: ,p_just_cd_o =>ben_xel_shd.g_old_rec.just_cd
219: ,p_ttl_fnctn_cd_o =>ben_xel_shd.g_old_rec.ttl_fnctn_cd,
220: p_ttl_cond_oper_cd_o =>ben_xel_shd.g_old_rec.ttl_cond_oper_cd,
221: p_ttl_cond_val_o =>ben_xel_shd.g_old_rec.ttl_cond_val,
222: p_ttl_sum_ext_data_elmt_id_o =>ben_xel_shd.g_old_rec.ttl_sum_ext_data_elmt_id,
223: p_ttl_cond_ext_data_elmt_id_o =>ben_xel_shd.g_old_rec.ttl_cond_ext_data_elmt_id ,
224: p_ext_fld_id_o =>ben_xel_shd.g_old_rec.ext_fld_id
225: ,p_business_group_id_o =>ben_xel_shd.g_old_rec.business_group_id
226: ,p_legislation_code_o =>ben_xel_shd.g_old_rec.legislation_code
219: ,p_ttl_fnctn_cd_o =>ben_xel_shd.g_old_rec.ttl_fnctn_cd,
220: p_ttl_cond_oper_cd_o =>ben_xel_shd.g_old_rec.ttl_cond_oper_cd,
221: p_ttl_cond_val_o =>ben_xel_shd.g_old_rec.ttl_cond_val,
222: p_ttl_sum_ext_data_elmt_id_o =>ben_xel_shd.g_old_rec.ttl_sum_ext_data_elmt_id,
223: p_ttl_cond_ext_data_elmt_id_o =>ben_xel_shd.g_old_rec.ttl_cond_ext_data_elmt_id ,
224: p_ext_fld_id_o =>ben_xel_shd.g_old_rec.ext_fld_id
225: ,p_business_group_id_o =>ben_xel_shd.g_old_rec.business_group_id
226: ,p_legislation_code_o =>ben_xel_shd.g_old_rec.legislation_code
227: ,p_xel_attribute_category_o =>ben_xel_shd.g_old_rec.xel_attribute_category
220: p_ttl_cond_oper_cd_o =>ben_xel_shd.g_old_rec.ttl_cond_oper_cd,
221: p_ttl_cond_val_o =>ben_xel_shd.g_old_rec.ttl_cond_val,
222: p_ttl_sum_ext_data_elmt_id_o =>ben_xel_shd.g_old_rec.ttl_sum_ext_data_elmt_id,
223: p_ttl_cond_ext_data_elmt_id_o =>ben_xel_shd.g_old_rec.ttl_cond_ext_data_elmt_id ,
224: p_ext_fld_id_o =>ben_xel_shd.g_old_rec.ext_fld_id
225: ,p_business_group_id_o =>ben_xel_shd.g_old_rec.business_group_id
226: ,p_legislation_code_o =>ben_xel_shd.g_old_rec.legislation_code
227: ,p_xel_attribute_category_o =>ben_xel_shd.g_old_rec.xel_attribute_category
228: ,p_xel_attribute1_o =>ben_xel_shd.g_old_rec.xel_attribute1
221: p_ttl_cond_val_o =>ben_xel_shd.g_old_rec.ttl_cond_val,
222: p_ttl_sum_ext_data_elmt_id_o =>ben_xel_shd.g_old_rec.ttl_sum_ext_data_elmt_id,
223: p_ttl_cond_ext_data_elmt_id_o =>ben_xel_shd.g_old_rec.ttl_cond_ext_data_elmt_id ,
224: p_ext_fld_id_o =>ben_xel_shd.g_old_rec.ext_fld_id
225: ,p_business_group_id_o =>ben_xel_shd.g_old_rec.business_group_id
226: ,p_legislation_code_o =>ben_xel_shd.g_old_rec.legislation_code
227: ,p_xel_attribute_category_o =>ben_xel_shd.g_old_rec.xel_attribute_category
228: ,p_xel_attribute1_o =>ben_xel_shd.g_old_rec.xel_attribute1
229: ,p_xel_attribute2_o =>ben_xel_shd.g_old_rec.xel_attribute2
222: p_ttl_sum_ext_data_elmt_id_o =>ben_xel_shd.g_old_rec.ttl_sum_ext_data_elmt_id,
223: p_ttl_cond_ext_data_elmt_id_o =>ben_xel_shd.g_old_rec.ttl_cond_ext_data_elmt_id ,
224: p_ext_fld_id_o =>ben_xel_shd.g_old_rec.ext_fld_id
225: ,p_business_group_id_o =>ben_xel_shd.g_old_rec.business_group_id
226: ,p_legislation_code_o =>ben_xel_shd.g_old_rec.legislation_code
227: ,p_xel_attribute_category_o =>ben_xel_shd.g_old_rec.xel_attribute_category
228: ,p_xel_attribute1_o =>ben_xel_shd.g_old_rec.xel_attribute1
229: ,p_xel_attribute2_o =>ben_xel_shd.g_old_rec.xel_attribute2
230: ,p_xel_attribute3_o =>ben_xel_shd.g_old_rec.xel_attribute3
223: p_ttl_cond_ext_data_elmt_id_o =>ben_xel_shd.g_old_rec.ttl_cond_ext_data_elmt_id ,
224: p_ext_fld_id_o =>ben_xel_shd.g_old_rec.ext_fld_id
225: ,p_business_group_id_o =>ben_xel_shd.g_old_rec.business_group_id
226: ,p_legislation_code_o =>ben_xel_shd.g_old_rec.legislation_code
227: ,p_xel_attribute_category_o =>ben_xel_shd.g_old_rec.xel_attribute_category
228: ,p_xel_attribute1_o =>ben_xel_shd.g_old_rec.xel_attribute1
229: ,p_xel_attribute2_o =>ben_xel_shd.g_old_rec.xel_attribute2
230: ,p_xel_attribute3_o =>ben_xel_shd.g_old_rec.xel_attribute3
231: ,p_xel_attribute4_o =>ben_xel_shd.g_old_rec.xel_attribute4
224: p_ext_fld_id_o =>ben_xel_shd.g_old_rec.ext_fld_id
225: ,p_business_group_id_o =>ben_xel_shd.g_old_rec.business_group_id
226: ,p_legislation_code_o =>ben_xel_shd.g_old_rec.legislation_code
227: ,p_xel_attribute_category_o =>ben_xel_shd.g_old_rec.xel_attribute_category
228: ,p_xel_attribute1_o =>ben_xel_shd.g_old_rec.xel_attribute1
229: ,p_xel_attribute2_o =>ben_xel_shd.g_old_rec.xel_attribute2
230: ,p_xel_attribute3_o =>ben_xel_shd.g_old_rec.xel_attribute3
231: ,p_xel_attribute4_o =>ben_xel_shd.g_old_rec.xel_attribute4
232: ,p_xel_attribute5_o =>ben_xel_shd.g_old_rec.xel_attribute5
225: ,p_business_group_id_o =>ben_xel_shd.g_old_rec.business_group_id
226: ,p_legislation_code_o =>ben_xel_shd.g_old_rec.legislation_code
227: ,p_xel_attribute_category_o =>ben_xel_shd.g_old_rec.xel_attribute_category
228: ,p_xel_attribute1_o =>ben_xel_shd.g_old_rec.xel_attribute1
229: ,p_xel_attribute2_o =>ben_xel_shd.g_old_rec.xel_attribute2
230: ,p_xel_attribute3_o =>ben_xel_shd.g_old_rec.xel_attribute3
231: ,p_xel_attribute4_o =>ben_xel_shd.g_old_rec.xel_attribute4
232: ,p_xel_attribute5_o =>ben_xel_shd.g_old_rec.xel_attribute5
233: ,p_xel_attribute6_o =>ben_xel_shd.g_old_rec.xel_attribute6
226: ,p_legislation_code_o =>ben_xel_shd.g_old_rec.legislation_code
227: ,p_xel_attribute_category_o =>ben_xel_shd.g_old_rec.xel_attribute_category
228: ,p_xel_attribute1_o =>ben_xel_shd.g_old_rec.xel_attribute1
229: ,p_xel_attribute2_o =>ben_xel_shd.g_old_rec.xel_attribute2
230: ,p_xel_attribute3_o =>ben_xel_shd.g_old_rec.xel_attribute3
231: ,p_xel_attribute4_o =>ben_xel_shd.g_old_rec.xel_attribute4
232: ,p_xel_attribute5_o =>ben_xel_shd.g_old_rec.xel_attribute5
233: ,p_xel_attribute6_o =>ben_xel_shd.g_old_rec.xel_attribute6
234: ,p_xel_attribute7_o =>ben_xel_shd.g_old_rec.xel_attribute7
227: ,p_xel_attribute_category_o =>ben_xel_shd.g_old_rec.xel_attribute_category
228: ,p_xel_attribute1_o =>ben_xel_shd.g_old_rec.xel_attribute1
229: ,p_xel_attribute2_o =>ben_xel_shd.g_old_rec.xel_attribute2
230: ,p_xel_attribute3_o =>ben_xel_shd.g_old_rec.xel_attribute3
231: ,p_xel_attribute4_o =>ben_xel_shd.g_old_rec.xel_attribute4
232: ,p_xel_attribute5_o =>ben_xel_shd.g_old_rec.xel_attribute5
233: ,p_xel_attribute6_o =>ben_xel_shd.g_old_rec.xel_attribute6
234: ,p_xel_attribute7_o =>ben_xel_shd.g_old_rec.xel_attribute7
235: ,p_xel_attribute8_o =>ben_xel_shd.g_old_rec.xel_attribute8
228: ,p_xel_attribute1_o =>ben_xel_shd.g_old_rec.xel_attribute1
229: ,p_xel_attribute2_o =>ben_xel_shd.g_old_rec.xel_attribute2
230: ,p_xel_attribute3_o =>ben_xel_shd.g_old_rec.xel_attribute3
231: ,p_xel_attribute4_o =>ben_xel_shd.g_old_rec.xel_attribute4
232: ,p_xel_attribute5_o =>ben_xel_shd.g_old_rec.xel_attribute5
233: ,p_xel_attribute6_o =>ben_xel_shd.g_old_rec.xel_attribute6
234: ,p_xel_attribute7_o =>ben_xel_shd.g_old_rec.xel_attribute7
235: ,p_xel_attribute8_o =>ben_xel_shd.g_old_rec.xel_attribute8
236: ,p_xel_attribute9_o =>ben_xel_shd.g_old_rec.xel_attribute9
229: ,p_xel_attribute2_o =>ben_xel_shd.g_old_rec.xel_attribute2
230: ,p_xel_attribute3_o =>ben_xel_shd.g_old_rec.xel_attribute3
231: ,p_xel_attribute4_o =>ben_xel_shd.g_old_rec.xel_attribute4
232: ,p_xel_attribute5_o =>ben_xel_shd.g_old_rec.xel_attribute5
233: ,p_xel_attribute6_o =>ben_xel_shd.g_old_rec.xel_attribute6
234: ,p_xel_attribute7_o =>ben_xel_shd.g_old_rec.xel_attribute7
235: ,p_xel_attribute8_o =>ben_xel_shd.g_old_rec.xel_attribute8
236: ,p_xel_attribute9_o =>ben_xel_shd.g_old_rec.xel_attribute9
237: ,p_xel_attribute10_o =>ben_xel_shd.g_old_rec.xel_attribute10
230: ,p_xel_attribute3_o =>ben_xel_shd.g_old_rec.xel_attribute3
231: ,p_xel_attribute4_o =>ben_xel_shd.g_old_rec.xel_attribute4
232: ,p_xel_attribute5_o =>ben_xel_shd.g_old_rec.xel_attribute5
233: ,p_xel_attribute6_o =>ben_xel_shd.g_old_rec.xel_attribute6
234: ,p_xel_attribute7_o =>ben_xel_shd.g_old_rec.xel_attribute7
235: ,p_xel_attribute8_o =>ben_xel_shd.g_old_rec.xel_attribute8
236: ,p_xel_attribute9_o =>ben_xel_shd.g_old_rec.xel_attribute9
237: ,p_xel_attribute10_o =>ben_xel_shd.g_old_rec.xel_attribute10
238: ,p_xel_attribute11_o =>ben_xel_shd.g_old_rec.xel_attribute11
231: ,p_xel_attribute4_o =>ben_xel_shd.g_old_rec.xel_attribute4
232: ,p_xel_attribute5_o =>ben_xel_shd.g_old_rec.xel_attribute5
233: ,p_xel_attribute6_o =>ben_xel_shd.g_old_rec.xel_attribute6
234: ,p_xel_attribute7_o =>ben_xel_shd.g_old_rec.xel_attribute7
235: ,p_xel_attribute8_o =>ben_xel_shd.g_old_rec.xel_attribute8
236: ,p_xel_attribute9_o =>ben_xel_shd.g_old_rec.xel_attribute9
237: ,p_xel_attribute10_o =>ben_xel_shd.g_old_rec.xel_attribute10
238: ,p_xel_attribute11_o =>ben_xel_shd.g_old_rec.xel_attribute11
239: ,p_xel_attribute12_o =>ben_xel_shd.g_old_rec.xel_attribute12
232: ,p_xel_attribute5_o =>ben_xel_shd.g_old_rec.xel_attribute5
233: ,p_xel_attribute6_o =>ben_xel_shd.g_old_rec.xel_attribute6
234: ,p_xel_attribute7_o =>ben_xel_shd.g_old_rec.xel_attribute7
235: ,p_xel_attribute8_o =>ben_xel_shd.g_old_rec.xel_attribute8
236: ,p_xel_attribute9_o =>ben_xel_shd.g_old_rec.xel_attribute9
237: ,p_xel_attribute10_o =>ben_xel_shd.g_old_rec.xel_attribute10
238: ,p_xel_attribute11_o =>ben_xel_shd.g_old_rec.xel_attribute11
239: ,p_xel_attribute12_o =>ben_xel_shd.g_old_rec.xel_attribute12
240: ,p_xel_attribute13_o =>ben_xel_shd.g_old_rec.xel_attribute13
233: ,p_xel_attribute6_o =>ben_xel_shd.g_old_rec.xel_attribute6
234: ,p_xel_attribute7_o =>ben_xel_shd.g_old_rec.xel_attribute7
235: ,p_xel_attribute8_o =>ben_xel_shd.g_old_rec.xel_attribute8
236: ,p_xel_attribute9_o =>ben_xel_shd.g_old_rec.xel_attribute9
237: ,p_xel_attribute10_o =>ben_xel_shd.g_old_rec.xel_attribute10
238: ,p_xel_attribute11_o =>ben_xel_shd.g_old_rec.xel_attribute11
239: ,p_xel_attribute12_o =>ben_xel_shd.g_old_rec.xel_attribute12
240: ,p_xel_attribute13_o =>ben_xel_shd.g_old_rec.xel_attribute13
241: ,p_xel_attribute14_o =>ben_xel_shd.g_old_rec.xel_attribute14
234: ,p_xel_attribute7_o =>ben_xel_shd.g_old_rec.xel_attribute7
235: ,p_xel_attribute8_o =>ben_xel_shd.g_old_rec.xel_attribute8
236: ,p_xel_attribute9_o =>ben_xel_shd.g_old_rec.xel_attribute9
237: ,p_xel_attribute10_o =>ben_xel_shd.g_old_rec.xel_attribute10
238: ,p_xel_attribute11_o =>ben_xel_shd.g_old_rec.xel_attribute11
239: ,p_xel_attribute12_o =>ben_xel_shd.g_old_rec.xel_attribute12
240: ,p_xel_attribute13_o =>ben_xel_shd.g_old_rec.xel_attribute13
241: ,p_xel_attribute14_o =>ben_xel_shd.g_old_rec.xel_attribute14
242: ,p_xel_attribute15_o =>ben_xel_shd.g_old_rec.xel_attribute15
235: ,p_xel_attribute8_o =>ben_xel_shd.g_old_rec.xel_attribute8
236: ,p_xel_attribute9_o =>ben_xel_shd.g_old_rec.xel_attribute9
237: ,p_xel_attribute10_o =>ben_xel_shd.g_old_rec.xel_attribute10
238: ,p_xel_attribute11_o =>ben_xel_shd.g_old_rec.xel_attribute11
239: ,p_xel_attribute12_o =>ben_xel_shd.g_old_rec.xel_attribute12
240: ,p_xel_attribute13_o =>ben_xel_shd.g_old_rec.xel_attribute13
241: ,p_xel_attribute14_o =>ben_xel_shd.g_old_rec.xel_attribute14
242: ,p_xel_attribute15_o =>ben_xel_shd.g_old_rec.xel_attribute15
243: ,p_xel_attribute16_o =>ben_xel_shd.g_old_rec.xel_attribute16
236: ,p_xel_attribute9_o =>ben_xel_shd.g_old_rec.xel_attribute9
237: ,p_xel_attribute10_o =>ben_xel_shd.g_old_rec.xel_attribute10
238: ,p_xel_attribute11_o =>ben_xel_shd.g_old_rec.xel_attribute11
239: ,p_xel_attribute12_o =>ben_xel_shd.g_old_rec.xel_attribute12
240: ,p_xel_attribute13_o =>ben_xel_shd.g_old_rec.xel_attribute13
241: ,p_xel_attribute14_o =>ben_xel_shd.g_old_rec.xel_attribute14
242: ,p_xel_attribute15_o =>ben_xel_shd.g_old_rec.xel_attribute15
243: ,p_xel_attribute16_o =>ben_xel_shd.g_old_rec.xel_attribute16
244: ,p_xel_attribute17_o =>ben_xel_shd.g_old_rec.xel_attribute17
237: ,p_xel_attribute10_o =>ben_xel_shd.g_old_rec.xel_attribute10
238: ,p_xel_attribute11_o =>ben_xel_shd.g_old_rec.xel_attribute11
239: ,p_xel_attribute12_o =>ben_xel_shd.g_old_rec.xel_attribute12
240: ,p_xel_attribute13_o =>ben_xel_shd.g_old_rec.xel_attribute13
241: ,p_xel_attribute14_o =>ben_xel_shd.g_old_rec.xel_attribute14
242: ,p_xel_attribute15_o =>ben_xel_shd.g_old_rec.xel_attribute15
243: ,p_xel_attribute16_o =>ben_xel_shd.g_old_rec.xel_attribute16
244: ,p_xel_attribute17_o =>ben_xel_shd.g_old_rec.xel_attribute17
245: ,p_xel_attribute18_o =>ben_xel_shd.g_old_rec.xel_attribute18
238: ,p_xel_attribute11_o =>ben_xel_shd.g_old_rec.xel_attribute11
239: ,p_xel_attribute12_o =>ben_xel_shd.g_old_rec.xel_attribute12
240: ,p_xel_attribute13_o =>ben_xel_shd.g_old_rec.xel_attribute13
241: ,p_xel_attribute14_o =>ben_xel_shd.g_old_rec.xel_attribute14
242: ,p_xel_attribute15_o =>ben_xel_shd.g_old_rec.xel_attribute15
243: ,p_xel_attribute16_o =>ben_xel_shd.g_old_rec.xel_attribute16
244: ,p_xel_attribute17_o =>ben_xel_shd.g_old_rec.xel_attribute17
245: ,p_xel_attribute18_o =>ben_xel_shd.g_old_rec.xel_attribute18
246: ,p_xel_attribute19_o =>ben_xel_shd.g_old_rec.xel_attribute19
239: ,p_xel_attribute12_o =>ben_xel_shd.g_old_rec.xel_attribute12
240: ,p_xel_attribute13_o =>ben_xel_shd.g_old_rec.xel_attribute13
241: ,p_xel_attribute14_o =>ben_xel_shd.g_old_rec.xel_attribute14
242: ,p_xel_attribute15_o =>ben_xel_shd.g_old_rec.xel_attribute15
243: ,p_xel_attribute16_o =>ben_xel_shd.g_old_rec.xel_attribute16
244: ,p_xel_attribute17_o =>ben_xel_shd.g_old_rec.xel_attribute17
245: ,p_xel_attribute18_o =>ben_xel_shd.g_old_rec.xel_attribute18
246: ,p_xel_attribute19_o =>ben_xel_shd.g_old_rec.xel_attribute19
247: ,p_xel_attribute20_o =>ben_xel_shd.g_old_rec.xel_attribute20
240: ,p_xel_attribute13_o =>ben_xel_shd.g_old_rec.xel_attribute13
241: ,p_xel_attribute14_o =>ben_xel_shd.g_old_rec.xel_attribute14
242: ,p_xel_attribute15_o =>ben_xel_shd.g_old_rec.xel_attribute15
243: ,p_xel_attribute16_o =>ben_xel_shd.g_old_rec.xel_attribute16
244: ,p_xel_attribute17_o =>ben_xel_shd.g_old_rec.xel_attribute17
245: ,p_xel_attribute18_o =>ben_xel_shd.g_old_rec.xel_attribute18
246: ,p_xel_attribute19_o =>ben_xel_shd.g_old_rec.xel_attribute19
247: ,p_xel_attribute20_o =>ben_xel_shd.g_old_rec.xel_attribute20
248: ,p_xel_attribute21_o =>ben_xel_shd.g_old_rec.xel_attribute21
241: ,p_xel_attribute14_o =>ben_xel_shd.g_old_rec.xel_attribute14
242: ,p_xel_attribute15_o =>ben_xel_shd.g_old_rec.xel_attribute15
243: ,p_xel_attribute16_o =>ben_xel_shd.g_old_rec.xel_attribute16
244: ,p_xel_attribute17_o =>ben_xel_shd.g_old_rec.xel_attribute17
245: ,p_xel_attribute18_o =>ben_xel_shd.g_old_rec.xel_attribute18
246: ,p_xel_attribute19_o =>ben_xel_shd.g_old_rec.xel_attribute19
247: ,p_xel_attribute20_o =>ben_xel_shd.g_old_rec.xel_attribute20
248: ,p_xel_attribute21_o =>ben_xel_shd.g_old_rec.xel_attribute21
249: ,p_xel_attribute22_o =>ben_xel_shd.g_old_rec.xel_attribute22
242: ,p_xel_attribute15_o =>ben_xel_shd.g_old_rec.xel_attribute15
243: ,p_xel_attribute16_o =>ben_xel_shd.g_old_rec.xel_attribute16
244: ,p_xel_attribute17_o =>ben_xel_shd.g_old_rec.xel_attribute17
245: ,p_xel_attribute18_o =>ben_xel_shd.g_old_rec.xel_attribute18
246: ,p_xel_attribute19_o =>ben_xel_shd.g_old_rec.xel_attribute19
247: ,p_xel_attribute20_o =>ben_xel_shd.g_old_rec.xel_attribute20
248: ,p_xel_attribute21_o =>ben_xel_shd.g_old_rec.xel_attribute21
249: ,p_xel_attribute22_o =>ben_xel_shd.g_old_rec.xel_attribute22
250: ,p_xel_attribute23_o =>ben_xel_shd.g_old_rec.xel_attribute23
243: ,p_xel_attribute16_o =>ben_xel_shd.g_old_rec.xel_attribute16
244: ,p_xel_attribute17_o =>ben_xel_shd.g_old_rec.xel_attribute17
245: ,p_xel_attribute18_o =>ben_xel_shd.g_old_rec.xel_attribute18
246: ,p_xel_attribute19_o =>ben_xel_shd.g_old_rec.xel_attribute19
247: ,p_xel_attribute20_o =>ben_xel_shd.g_old_rec.xel_attribute20
248: ,p_xel_attribute21_o =>ben_xel_shd.g_old_rec.xel_attribute21
249: ,p_xel_attribute22_o =>ben_xel_shd.g_old_rec.xel_attribute22
250: ,p_xel_attribute23_o =>ben_xel_shd.g_old_rec.xel_attribute23
251: ,p_xel_attribute24_o =>ben_xel_shd.g_old_rec.xel_attribute24
244: ,p_xel_attribute17_o =>ben_xel_shd.g_old_rec.xel_attribute17
245: ,p_xel_attribute18_o =>ben_xel_shd.g_old_rec.xel_attribute18
246: ,p_xel_attribute19_o =>ben_xel_shd.g_old_rec.xel_attribute19
247: ,p_xel_attribute20_o =>ben_xel_shd.g_old_rec.xel_attribute20
248: ,p_xel_attribute21_o =>ben_xel_shd.g_old_rec.xel_attribute21
249: ,p_xel_attribute22_o =>ben_xel_shd.g_old_rec.xel_attribute22
250: ,p_xel_attribute23_o =>ben_xel_shd.g_old_rec.xel_attribute23
251: ,p_xel_attribute24_o =>ben_xel_shd.g_old_rec.xel_attribute24
252: ,p_xel_attribute25_o =>ben_xel_shd.g_old_rec.xel_attribute25
245: ,p_xel_attribute18_o =>ben_xel_shd.g_old_rec.xel_attribute18
246: ,p_xel_attribute19_o =>ben_xel_shd.g_old_rec.xel_attribute19
247: ,p_xel_attribute20_o =>ben_xel_shd.g_old_rec.xel_attribute20
248: ,p_xel_attribute21_o =>ben_xel_shd.g_old_rec.xel_attribute21
249: ,p_xel_attribute22_o =>ben_xel_shd.g_old_rec.xel_attribute22
250: ,p_xel_attribute23_o =>ben_xel_shd.g_old_rec.xel_attribute23
251: ,p_xel_attribute24_o =>ben_xel_shd.g_old_rec.xel_attribute24
252: ,p_xel_attribute25_o =>ben_xel_shd.g_old_rec.xel_attribute25
253: ,p_xel_attribute26_o =>ben_xel_shd.g_old_rec.xel_attribute26
246: ,p_xel_attribute19_o =>ben_xel_shd.g_old_rec.xel_attribute19
247: ,p_xel_attribute20_o =>ben_xel_shd.g_old_rec.xel_attribute20
248: ,p_xel_attribute21_o =>ben_xel_shd.g_old_rec.xel_attribute21
249: ,p_xel_attribute22_o =>ben_xel_shd.g_old_rec.xel_attribute22
250: ,p_xel_attribute23_o =>ben_xel_shd.g_old_rec.xel_attribute23
251: ,p_xel_attribute24_o =>ben_xel_shd.g_old_rec.xel_attribute24
252: ,p_xel_attribute25_o =>ben_xel_shd.g_old_rec.xel_attribute25
253: ,p_xel_attribute26_o =>ben_xel_shd.g_old_rec.xel_attribute26
254: ,p_xel_attribute27_o =>ben_xel_shd.g_old_rec.xel_attribute27
247: ,p_xel_attribute20_o =>ben_xel_shd.g_old_rec.xel_attribute20
248: ,p_xel_attribute21_o =>ben_xel_shd.g_old_rec.xel_attribute21
249: ,p_xel_attribute22_o =>ben_xel_shd.g_old_rec.xel_attribute22
250: ,p_xel_attribute23_o =>ben_xel_shd.g_old_rec.xel_attribute23
251: ,p_xel_attribute24_o =>ben_xel_shd.g_old_rec.xel_attribute24
252: ,p_xel_attribute25_o =>ben_xel_shd.g_old_rec.xel_attribute25
253: ,p_xel_attribute26_o =>ben_xel_shd.g_old_rec.xel_attribute26
254: ,p_xel_attribute27_o =>ben_xel_shd.g_old_rec.xel_attribute27
255: ,p_xel_attribute28_o =>ben_xel_shd.g_old_rec.xel_attribute28
248: ,p_xel_attribute21_o =>ben_xel_shd.g_old_rec.xel_attribute21
249: ,p_xel_attribute22_o =>ben_xel_shd.g_old_rec.xel_attribute22
250: ,p_xel_attribute23_o =>ben_xel_shd.g_old_rec.xel_attribute23
251: ,p_xel_attribute24_o =>ben_xel_shd.g_old_rec.xel_attribute24
252: ,p_xel_attribute25_o =>ben_xel_shd.g_old_rec.xel_attribute25
253: ,p_xel_attribute26_o =>ben_xel_shd.g_old_rec.xel_attribute26
254: ,p_xel_attribute27_o =>ben_xel_shd.g_old_rec.xel_attribute27
255: ,p_xel_attribute28_o =>ben_xel_shd.g_old_rec.xel_attribute28
256: ,p_xel_attribute29_o =>ben_xel_shd.g_old_rec.xel_attribute29
249: ,p_xel_attribute22_o =>ben_xel_shd.g_old_rec.xel_attribute22
250: ,p_xel_attribute23_o =>ben_xel_shd.g_old_rec.xel_attribute23
251: ,p_xel_attribute24_o =>ben_xel_shd.g_old_rec.xel_attribute24
252: ,p_xel_attribute25_o =>ben_xel_shd.g_old_rec.xel_attribute25
253: ,p_xel_attribute26_o =>ben_xel_shd.g_old_rec.xel_attribute26
254: ,p_xel_attribute27_o =>ben_xel_shd.g_old_rec.xel_attribute27
255: ,p_xel_attribute28_o =>ben_xel_shd.g_old_rec.xel_attribute28
256: ,p_xel_attribute29_o =>ben_xel_shd.g_old_rec.xel_attribute29
257: ,p_xel_attribute30_o =>ben_xel_shd.g_old_rec.xel_attribute30
250: ,p_xel_attribute23_o =>ben_xel_shd.g_old_rec.xel_attribute23
251: ,p_xel_attribute24_o =>ben_xel_shd.g_old_rec.xel_attribute24
252: ,p_xel_attribute25_o =>ben_xel_shd.g_old_rec.xel_attribute25
253: ,p_xel_attribute26_o =>ben_xel_shd.g_old_rec.xel_attribute26
254: ,p_xel_attribute27_o =>ben_xel_shd.g_old_rec.xel_attribute27
255: ,p_xel_attribute28_o =>ben_xel_shd.g_old_rec.xel_attribute28
256: ,p_xel_attribute29_o =>ben_xel_shd.g_old_rec.xel_attribute29
257: ,p_xel_attribute30_o =>ben_xel_shd.g_old_rec.xel_attribute30
258: ,p_defined_balance_id_o =>ben_xel_shd.g_old_rec.defined_balance_id
251: ,p_xel_attribute24_o =>ben_xel_shd.g_old_rec.xel_attribute24
252: ,p_xel_attribute25_o =>ben_xel_shd.g_old_rec.xel_attribute25
253: ,p_xel_attribute26_o =>ben_xel_shd.g_old_rec.xel_attribute26
254: ,p_xel_attribute27_o =>ben_xel_shd.g_old_rec.xel_attribute27
255: ,p_xel_attribute28_o =>ben_xel_shd.g_old_rec.xel_attribute28
256: ,p_xel_attribute29_o =>ben_xel_shd.g_old_rec.xel_attribute29
257: ,p_xel_attribute30_o =>ben_xel_shd.g_old_rec.xel_attribute30
258: ,p_defined_balance_id_o =>ben_xel_shd.g_old_rec.defined_balance_id
259: ,p_object_version_number_o =>ben_xel_shd.g_old_rec.object_version_number
252: ,p_xel_attribute25_o =>ben_xel_shd.g_old_rec.xel_attribute25
253: ,p_xel_attribute26_o =>ben_xel_shd.g_old_rec.xel_attribute26
254: ,p_xel_attribute27_o =>ben_xel_shd.g_old_rec.xel_attribute27
255: ,p_xel_attribute28_o =>ben_xel_shd.g_old_rec.xel_attribute28
256: ,p_xel_attribute29_o =>ben_xel_shd.g_old_rec.xel_attribute29
257: ,p_xel_attribute30_o =>ben_xel_shd.g_old_rec.xel_attribute30
258: ,p_defined_balance_id_o =>ben_xel_shd.g_old_rec.defined_balance_id
259: ,p_object_version_number_o =>ben_xel_shd.g_old_rec.object_version_number
260: );
253: ,p_xel_attribute26_o =>ben_xel_shd.g_old_rec.xel_attribute26
254: ,p_xel_attribute27_o =>ben_xel_shd.g_old_rec.xel_attribute27
255: ,p_xel_attribute28_o =>ben_xel_shd.g_old_rec.xel_attribute28
256: ,p_xel_attribute29_o =>ben_xel_shd.g_old_rec.xel_attribute29
257: ,p_xel_attribute30_o =>ben_xel_shd.g_old_rec.xel_attribute30
258: ,p_defined_balance_id_o =>ben_xel_shd.g_old_rec.defined_balance_id
259: ,p_object_version_number_o =>ben_xel_shd.g_old_rec.object_version_number
260: );
261: --
254: ,p_xel_attribute27_o =>ben_xel_shd.g_old_rec.xel_attribute27
255: ,p_xel_attribute28_o =>ben_xel_shd.g_old_rec.xel_attribute28
256: ,p_xel_attribute29_o =>ben_xel_shd.g_old_rec.xel_attribute29
257: ,p_xel_attribute30_o =>ben_xel_shd.g_old_rec.xel_attribute30
258: ,p_defined_balance_id_o =>ben_xel_shd.g_old_rec.defined_balance_id
259: ,p_object_version_number_o =>ben_xel_shd.g_old_rec.object_version_number
260: );
261: --
262: exception
255: ,p_xel_attribute28_o =>ben_xel_shd.g_old_rec.xel_attribute28
256: ,p_xel_attribute29_o =>ben_xel_shd.g_old_rec.xel_attribute29
257: ,p_xel_attribute30_o =>ben_xel_shd.g_old_rec.xel_attribute30
258: ,p_defined_balance_id_o =>ben_xel_shd.g_old_rec.defined_balance_id
259: ,p_object_version_number_o =>ben_xel_shd.g_old_rec.object_version_number
260: );
261: --
262: exception
263: --
280: -- ----------------------------------------------------------------------------
281: Procedure del
282: (
283: p_effective_date in date,
284: p_rec in ben_xel_shd.g_rec_type
285: ) is
286: --
287: l_proc varchar2(72) := g_package||'del';
288: --
290: hr_utility.set_location('Entering:'||l_proc, 5);
291: --
292: -- We must lock the row which we need to delete.
293: --
294: ben_xel_shd.lck
295: (
296: p_rec.ext_data_elmt_id,
297: p_rec.object_version_number
298: );
326: p_legislation_code in varchar2 default null,
327: p_object_version_number in number
328: ) is
329: --
330: l_rec ben_xel_shd.g_rec_type;
331: l_proc varchar2(72) := g_package||'del';
332: --
333: Begin
334: hr_utility.set_location('Entering:'||l_proc, 5);