[Home] [Help]
50: -- Internal Row Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy ben_xel_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin
61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
64: --
65: ben_xel_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the ben_ext_data_elmt Row
68: --
69: update ben_ext_data_elmt
123: last_update_login = p_rec.last_update_login,
124: object_version_number = p_rec.object_version_number
125: where ext_data_elmt_id = p_rec.ext_data_elmt_id;
126: --
127: ben_xel_shd.g_api_dml := false; -- Unset the api dml status
128: --
129: hr_utility.set_location(' Leaving:'||l_proc, 10);
130: --
131: Exception
130: --
131: Exception
132: When hr_api.check_integrity_violated Then
133: -- A check constraint has been violated
134: ben_xel_shd.g_api_dml := false; -- Unset the api dml status
135: ben_xel_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.parent_integrity_violated Then
138: -- Parent integrity has been violated
131: Exception
132: When hr_api.check_integrity_violated Then
133: -- A check constraint has been violated
134: ben_xel_shd.g_api_dml := false; -- Unset the api dml status
135: ben_xel_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.parent_integrity_violated Then
138: -- Parent integrity has been violated
139: ben_xel_shd.g_api_dml := false; -- Unset the api dml status
135: ben_xel_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.parent_integrity_violated Then
138: -- Parent integrity has been violated
139: ben_xel_shd.g_api_dml := false; -- Unset the api dml status
140: ben_xel_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When hr_api.unique_integrity_violated Then
143: -- Unique integrity has been violated
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.parent_integrity_violated Then
138: -- Parent integrity has been violated
139: ben_xel_shd.g_api_dml := false; -- Unset the api dml status
140: ben_xel_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When hr_api.unique_integrity_violated Then
143: -- Unique integrity has been violated
144: ben_xel_shd.g_api_dml := false; -- Unset the api dml status
140: ben_xel_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When hr_api.unique_integrity_violated Then
143: -- Unique integrity has been violated
144: ben_xel_shd.g_api_dml := false; -- Unset the api dml status
145: ben_xel_shd.constraint_error
146: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
147: When Others Then
148: ben_xel_shd.g_api_dml := false; -- Unset the api dml status
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When hr_api.unique_integrity_violated Then
143: -- Unique integrity has been violated
144: ben_xel_shd.g_api_dml := false; -- Unset the api dml status
145: ben_xel_shd.constraint_error
146: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
147: When Others Then
148: ben_xel_shd.g_api_dml := false; -- Unset the api dml status
149: Raise;
144: ben_xel_shd.g_api_dml := false; -- Unset the api dml status
145: ben_xel_shd.constraint_error
146: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
147: When Others Then
148: ben_xel_shd.g_api_dml := false; -- Unset the api dml status
149: Raise;
150: End update_dml;
151: --
152: -- ----------------------------------------------------------------------------
180: -- Internal Row Handler Use Only.
181: --
182: -- {End Of Comments}
183: -- ----------------------------------------------------------------------------
184: Procedure pre_update(p_rec in ben_xel_shd.g_rec_type) is
185: --
186: l_proc varchar2(72) := g_package||'pre_update';
187: --
188: Begin
223: --
224: -- {End Of Comments}
225: -- ----------------------------------------------------------------------------
226: Procedure post_update(
227: p_effective_date in date,p_rec in ben_xel_shd.g_rec_type) is
228: --
229: l_proc varchar2(72) := g_package||'post_update';
230: --
231: Begin
289: ,p_xel_attribute30 =>p_rec.xel_attribute30
290: ,p_defined_balance_id =>p_rec.defined_balance_id
291: ,p_object_version_number =>p_rec.object_version_number
292: ,p_effective_date =>p_effective_date
293: ,p_name_o =>ben_xel_shd.g_old_rec.name
294: ,p_xml_tag_name_o =>ben_xel_shd.g_old_rec.xml_tag_name
295: ,p_data_elmt_typ_cd_o =>ben_xel_shd.g_old_rec.data_elmt_typ_cd
296: ,p_data_elmt_rl_o =>ben_xel_shd.g_old_rec.data_elmt_rl
297: ,p_frmt_mask_cd_o =>ben_xel_shd.g_old_rec.frmt_mask_cd
290: ,p_defined_balance_id =>p_rec.defined_balance_id
291: ,p_object_version_number =>p_rec.object_version_number
292: ,p_effective_date =>p_effective_date
293: ,p_name_o =>ben_xel_shd.g_old_rec.name
294: ,p_xml_tag_name_o =>ben_xel_shd.g_old_rec.xml_tag_name
295: ,p_data_elmt_typ_cd_o =>ben_xel_shd.g_old_rec.data_elmt_typ_cd
296: ,p_data_elmt_rl_o =>ben_xel_shd.g_old_rec.data_elmt_rl
297: ,p_frmt_mask_cd_o =>ben_xel_shd.g_old_rec.frmt_mask_cd
298: ,p_string_val_o =>ben_xel_shd.g_old_rec.string_val
291: ,p_object_version_number =>p_rec.object_version_number
292: ,p_effective_date =>p_effective_date
293: ,p_name_o =>ben_xel_shd.g_old_rec.name
294: ,p_xml_tag_name_o =>ben_xel_shd.g_old_rec.xml_tag_name
295: ,p_data_elmt_typ_cd_o =>ben_xel_shd.g_old_rec.data_elmt_typ_cd
296: ,p_data_elmt_rl_o =>ben_xel_shd.g_old_rec.data_elmt_rl
297: ,p_frmt_mask_cd_o =>ben_xel_shd.g_old_rec.frmt_mask_cd
298: ,p_string_val_o =>ben_xel_shd.g_old_rec.string_val
299: ,p_dflt_val_o =>ben_xel_shd.g_old_rec.dflt_val
292: ,p_effective_date =>p_effective_date
293: ,p_name_o =>ben_xel_shd.g_old_rec.name
294: ,p_xml_tag_name_o =>ben_xel_shd.g_old_rec.xml_tag_name
295: ,p_data_elmt_typ_cd_o =>ben_xel_shd.g_old_rec.data_elmt_typ_cd
296: ,p_data_elmt_rl_o =>ben_xel_shd.g_old_rec.data_elmt_rl
297: ,p_frmt_mask_cd_o =>ben_xel_shd.g_old_rec.frmt_mask_cd
298: ,p_string_val_o =>ben_xel_shd.g_old_rec.string_val
299: ,p_dflt_val_o =>ben_xel_shd.g_old_rec.dflt_val
300: ,p_max_length_num_o =>ben_xel_shd.g_old_rec.max_length_num
293: ,p_name_o =>ben_xel_shd.g_old_rec.name
294: ,p_xml_tag_name_o =>ben_xel_shd.g_old_rec.xml_tag_name
295: ,p_data_elmt_typ_cd_o =>ben_xel_shd.g_old_rec.data_elmt_typ_cd
296: ,p_data_elmt_rl_o =>ben_xel_shd.g_old_rec.data_elmt_rl
297: ,p_frmt_mask_cd_o =>ben_xel_shd.g_old_rec.frmt_mask_cd
298: ,p_string_val_o =>ben_xel_shd.g_old_rec.string_val
299: ,p_dflt_val_o =>ben_xel_shd.g_old_rec.dflt_val
300: ,p_max_length_num_o =>ben_xel_shd.g_old_rec.max_length_num
301: ,p_just_cd_o =>ben_xel_shd.g_old_rec.just_cd
294: ,p_xml_tag_name_o =>ben_xel_shd.g_old_rec.xml_tag_name
295: ,p_data_elmt_typ_cd_o =>ben_xel_shd.g_old_rec.data_elmt_typ_cd
296: ,p_data_elmt_rl_o =>ben_xel_shd.g_old_rec.data_elmt_rl
297: ,p_frmt_mask_cd_o =>ben_xel_shd.g_old_rec.frmt_mask_cd
298: ,p_string_val_o =>ben_xel_shd.g_old_rec.string_val
299: ,p_dflt_val_o =>ben_xel_shd.g_old_rec.dflt_val
300: ,p_max_length_num_o =>ben_xel_shd.g_old_rec.max_length_num
301: ,p_just_cd_o =>ben_xel_shd.g_old_rec.just_cd
302: ,p_ttl_fnctn_cd_o =>ben_xel_shd.g_old_rec.ttl_fnctn_cd,
295: ,p_data_elmt_typ_cd_o =>ben_xel_shd.g_old_rec.data_elmt_typ_cd
296: ,p_data_elmt_rl_o =>ben_xel_shd.g_old_rec.data_elmt_rl
297: ,p_frmt_mask_cd_o =>ben_xel_shd.g_old_rec.frmt_mask_cd
298: ,p_string_val_o =>ben_xel_shd.g_old_rec.string_val
299: ,p_dflt_val_o =>ben_xel_shd.g_old_rec.dflt_val
300: ,p_max_length_num_o =>ben_xel_shd.g_old_rec.max_length_num
301: ,p_just_cd_o =>ben_xel_shd.g_old_rec.just_cd
302: ,p_ttl_fnctn_cd_o =>ben_xel_shd.g_old_rec.ttl_fnctn_cd,
303: p_ttl_cond_oper_cd_o =>ben_xel_shd.g_old_rec.ttl_cond_oper_cd,
296: ,p_data_elmt_rl_o =>ben_xel_shd.g_old_rec.data_elmt_rl
297: ,p_frmt_mask_cd_o =>ben_xel_shd.g_old_rec.frmt_mask_cd
298: ,p_string_val_o =>ben_xel_shd.g_old_rec.string_val
299: ,p_dflt_val_o =>ben_xel_shd.g_old_rec.dflt_val
300: ,p_max_length_num_o =>ben_xel_shd.g_old_rec.max_length_num
301: ,p_just_cd_o =>ben_xel_shd.g_old_rec.just_cd
302: ,p_ttl_fnctn_cd_o =>ben_xel_shd.g_old_rec.ttl_fnctn_cd,
303: p_ttl_cond_oper_cd_o =>ben_xel_shd.g_old_rec.ttl_cond_oper_cd,
304: p_ttl_cond_val_o =>ben_xel_shd.g_old_rec.ttl_cond_val,
297: ,p_frmt_mask_cd_o =>ben_xel_shd.g_old_rec.frmt_mask_cd
298: ,p_string_val_o =>ben_xel_shd.g_old_rec.string_val
299: ,p_dflt_val_o =>ben_xel_shd.g_old_rec.dflt_val
300: ,p_max_length_num_o =>ben_xel_shd.g_old_rec.max_length_num
301: ,p_just_cd_o =>ben_xel_shd.g_old_rec.just_cd
302: ,p_ttl_fnctn_cd_o =>ben_xel_shd.g_old_rec.ttl_fnctn_cd,
303: p_ttl_cond_oper_cd_o =>ben_xel_shd.g_old_rec.ttl_cond_oper_cd,
304: p_ttl_cond_val_o =>ben_xel_shd.g_old_rec.ttl_cond_val,
305: p_ttl_sum_ext_data_elmt_id_o =>ben_xel_shd.g_old_rec.ttl_sum_ext_data_elmt_id,
298: ,p_string_val_o =>ben_xel_shd.g_old_rec.string_val
299: ,p_dflt_val_o =>ben_xel_shd.g_old_rec.dflt_val
300: ,p_max_length_num_o =>ben_xel_shd.g_old_rec.max_length_num
301: ,p_just_cd_o =>ben_xel_shd.g_old_rec.just_cd
302: ,p_ttl_fnctn_cd_o =>ben_xel_shd.g_old_rec.ttl_fnctn_cd,
303: p_ttl_cond_oper_cd_o =>ben_xel_shd.g_old_rec.ttl_cond_oper_cd,
304: p_ttl_cond_val_o =>ben_xel_shd.g_old_rec.ttl_cond_val,
305: p_ttl_sum_ext_data_elmt_id_o =>ben_xel_shd.g_old_rec.ttl_sum_ext_data_elmt_id,
306: p_ttl_cond_ext_data_elmt_id_o =>ben_xel_shd.g_old_rec.ttl_cond_ext_data_elmt_id ,
299: ,p_dflt_val_o =>ben_xel_shd.g_old_rec.dflt_val
300: ,p_max_length_num_o =>ben_xel_shd.g_old_rec.max_length_num
301: ,p_just_cd_o =>ben_xel_shd.g_old_rec.just_cd
302: ,p_ttl_fnctn_cd_o =>ben_xel_shd.g_old_rec.ttl_fnctn_cd,
303: p_ttl_cond_oper_cd_o =>ben_xel_shd.g_old_rec.ttl_cond_oper_cd,
304: p_ttl_cond_val_o =>ben_xel_shd.g_old_rec.ttl_cond_val,
305: p_ttl_sum_ext_data_elmt_id_o =>ben_xel_shd.g_old_rec.ttl_sum_ext_data_elmt_id,
306: p_ttl_cond_ext_data_elmt_id_o =>ben_xel_shd.g_old_rec.ttl_cond_ext_data_elmt_id ,
307: p_ext_fld_id_o =>ben_xel_shd.g_old_rec.ext_fld_id
300: ,p_max_length_num_o =>ben_xel_shd.g_old_rec.max_length_num
301: ,p_just_cd_o =>ben_xel_shd.g_old_rec.just_cd
302: ,p_ttl_fnctn_cd_o =>ben_xel_shd.g_old_rec.ttl_fnctn_cd,
303: p_ttl_cond_oper_cd_o =>ben_xel_shd.g_old_rec.ttl_cond_oper_cd,
304: p_ttl_cond_val_o =>ben_xel_shd.g_old_rec.ttl_cond_val,
305: p_ttl_sum_ext_data_elmt_id_o =>ben_xel_shd.g_old_rec.ttl_sum_ext_data_elmt_id,
306: p_ttl_cond_ext_data_elmt_id_o =>ben_xel_shd.g_old_rec.ttl_cond_ext_data_elmt_id ,
307: p_ext_fld_id_o =>ben_xel_shd.g_old_rec.ext_fld_id
308: ,p_business_group_id_o => ben_xel_shd.g_old_rec.business_group_id
301: ,p_just_cd_o =>ben_xel_shd.g_old_rec.just_cd
302: ,p_ttl_fnctn_cd_o =>ben_xel_shd.g_old_rec.ttl_fnctn_cd,
303: p_ttl_cond_oper_cd_o =>ben_xel_shd.g_old_rec.ttl_cond_oper_cd,
304: p_ttl_cond_val_o =>ben_xel_shd.g_old_rec.ttl_cond_val,
305: p_ttl_sum_ext_data_elmt_id_o =>ben_xel_shd.g_old_rec.ttl_sum_ext_data_elmt_id,
306: p_ttl_cond_ext_data_elmt_id_o =>ben_xel_shd.g_old_rec.ttl_cond_ext_data_elmt_id ,
307: p_ext_fld_id_o =>ben_xel_shd.g_old_rec.ext_fld_id
308: ,p_business_group_id_o => ben_xel_shd.g_old_rec.business_group_id
309: ,p_legislation_code_o => ben_xel_shd.g_old_rec.legislation_code
302: ,p_ttl_fnctn_cd_o =>ben_xel_shd.g_old_rec.ttl_fnctn_cd,
303: p_ttl_cond_oper_cd_o =>ben_xel_shd.g_old_rec.ttl_cond_oper_cd,
304: p_ttl_cond_val_o =>ben_xel_shd.g_old_rec.ttl_cond_val,
305: p_ttl_sum_ext_data_elmt_id_o =>ben_xel_shd.g_old_rec.ttl_sum_ext_data_elmt_id,
306: p_ttl_cond_ext_data_elmt_id_o =>ben_xel_shd.g_old_rec.ttl_cond_ext_data_elmt_id ,
307: p_ext_fld_id_o =>ben_xel_shd.g_old_rec.ext_fld_id
308: ,p_business_group_id_o => ben_xel_shd.g_old_rec.business_group_id
309: ,p_legislation_code_o => ben_xel_shd.g_old_rec.legislation_code
310: ,p_xel_attribute_category_o =>ben_xel_shd.g_old_rec.xel_attribute_category
303: p_ttl_cond_oper_cd_o =>ben_xel_shd.g_old_rec.ttl_cond_oper_cd,
304: p_ttl_cond_val_o =>ben_xel_shd.g_old_rec.ttl_cond_val,
305: p_ttl_sum_ext_data_elmt_id_o =>ben_xel_shd.g_old_rec.ttl_sum_ext_data_elmt_id,
306: p_ttl_cond_ext_data_elmt_id_o =>ben_xel_shd.g_old_rec.ttl_cond_ext_data_elmt_id ,
307: p_ext_fld_id_o =>ben_xel_shd.g_old_rec.ext_fld_id
308: ,p_business_group_id_o => ben_xel_shd.g_old_rec.business_group_id
309: ,p_legislation_code_o => ben_xel_shd.g_old_rec.legislation_code
310: ,p_xel_attribute_category_o =>ben_xel_shd.g_old_rec.xel_attribute_category
311: ,p_xel_attribute1_o =>ben_xel_shd.g_old_rec.xel_attribute1
304: p_ttl_cond_val_o =>ben_xel_shd.g_old_rec.ttl_cond_val,
305: p_ttl_sum_ext_data_elmt_id_o =>ben_xel_shd.g_old_rec.ttl_sum_ext_data_elmt_id,
306: p_ttl_cond_ext_data_elmt_id_o =>ben_xel_shd.g_old_rec.ttl_cond_ext_data_elmt_id ,
307: p_ext_fld_id_o =>ben_xel_shd.g_old_rec.ext_fld_id
308: ,p_business_group_id_o => ben_xel_shd.g_old_rec.business_group_id
309: ,p_legislation_code_o => ben_xel_shd.g_old_rec.legislation_code
310: ,p_xel_attribute_category_o =>ben_xel_shd.g_old_rec.xel_attribute_category
311: ,p_xel_attribute1_o =>ben_xel_shd.g_old_rec.xel_attribute1
312: ,p_xel_attribute2_o =>ben_xel_shd.g_old_rec.xel_attribute2
305: p_ttl_sum_ext_data_elmt_id_o =>ben_xel_shd.g_old_rec.ttl_sum_ext_data_elmt_id,
306: p_ttl_cond_ext_data_elmt_id_o =>ben_xel_shd.g_old_rec.ttl_cond_ext_data_elmt_id ,
307: p_ext_fld_id_o =>ben_xel_shd.g_old_rec.ext_fld_id
308: ,p_business_group_id_o => ben_xel_shd.g_old_rec.business_group_id
309: ,p_legislation_code_o => ben_xel_shd.g_old_rec.legislation_code
310: ,p_xel_attribute_category_o =>ben_xel_shd.g_old_rec.xel_attribute_category
311: ,p_xel_attribute1_o =>ben_xel_shd.g_old_rec.xel_attribute1
312: ,p_xel_attribute2_o =>ben_xel_shd.g_old_rec.xel_attribute2
313: ,p_xel_attribute3_o =>ben_xel_shd.g_old_rec.xel_attribute3
306: p_ttl_cond_ext_data_elmt_id_o =>ben_xel_shd.g_old_rec.ttl_cond_ext_data_elmt_id ,
307: p_ext_fld_id_o =>ben_xel_shd.g_old_rec.ext_fld_id
308: ,p_business_group_id_o => ben_xel_shd.g_old_rec.business_group_id
309: ,p_legislation_code_o => ben_xel_shd.g_old_rec.legislation_code
310: ,p_xel_attribute_category_o =>ben_xel_shd.g_old_rec.xel_attribute_category
311: ,p_xel_attribute1_o =>ben_xel_shd.g_old_rec.xel_attribute1
312: ,p_xel_attribute2_o =>ben_xel_shd.g_old_rec.xel_attribute2
313: ,p_xel_attribute3_o =>ben_xel_shd.g_old_rec.xel_attribute3
314: ,p_xel_attribute4_o =>ben_xel_shd.g_old_rec.xel_attribute4
307: p_ext_fld_id_o =>ben_xel_shd.g_old_rec.ext_fld_id
308: ,p_business_group_id_o => ben_xel_shd.g_old_rec.business_group_id
309: ,p_legislation_code_o => ben_xel_shd.g_old_rec.legislation_code
310: ,p_xel_attribute_category_o =>ben_xel_shd.g_old_rec.xel_attribute_category
311: ,p_xel_attribute1_o =>ben_xel_shd.g_old_rec.xel_attribute1
312: ,p_xel_attribute2_o =>ben_xel_shd.g_old_rec.xel_attribute2
313: ,p_xel_attribute3_o =>ben_xel_shd.g_old_rec.xel_attribute3
314: ,p_xel_attribute4_o =>ben_xel_shd.g_old_rec.xel_attribute4
315: ,p_xel_attribute5_o =>ben_xel_shd.g_old_rec.xel_attribute5
308: ,p_business_group_id_o => ben_xel_shd.g_old_rec.business_group_id
309: ,p_legislation_code_o => ben_xel_shd.g_old_rec.legislation_code
310: ,p_xel_attribute_category_o =>ben_xel_shd.g_old_rec.xel_attribute_category
311: ,p_xel_attribute1_o =>ben_xel_shd.g_old_rec.xel_attribute1
312: ,p_xel_attribute2_o =>ben_xel_shd.g_old_rec.xel_attribute2
313: ,p_xel_attribute3_o =>ben_xel_shd.g_old_rec.xel_attribute3
314: ,p_xel_attribute4_o =>ben_xel_shd.g_old_rec.xel_attribute4
315: ,p_xel_attribute5_o =>ben_xel_shd.g_old_rec.xel_attribute5
316: ,p_xel_attribute6_o =>ben_xel_shd.g_old_rec.xel_attribute6
309: ,p_legislation_code_o => ben_xel_shd.g_old_rec.legislation_code
310: ,p_xel_attribute_category_o =>ben_xel_shd.g_old_rec.xel_attribute_category
311: ,p_xel_attribute1_o =>ben_xel_shd.g_old_rec.xel_attribute1
312: ,p_xel_attribute2_o =>ben_xel_shd.g_old_rec.xel_attribute2
313: ,p_xel_attribute3_o =>ben_xel_shd.g_old_rec.xel_attribute3
314: ,p_xel_attribute4_o =>ben_xel_shd.g_old_rec.xel_attribute4
315: ,p_xel_attribute5_o =>ben_xel_shd.g_old_rec.xel_attribute5
316: ,p_xel_attribute6_o =>ben_xel_shd.g_old_rec.xel_attribute6
317: ,p_xel_attribute7_o =>ben_xel_shd.g_old_rec.xel_attribute7
310: ,p_xel_attribute_category_o =>ben_xel_shd.g_old_rec.xel_attribute_category
311: ,p_xel_attribute1_o =>ben_xel_shd.g_old_rec.xel_attribute1
312: ,p_xel_attribute2_o =>ben_xel_shd.g_old_rec.xel_attribute2
313: ,p_xel_attribute3_o =>ben_xel_shd.g_old_rec.xel_attribute3
314: ,p_xel_attribute4_o =>ben_xel_shd.g_old_rec.xel_attribute4
315: ,p_xel_attribute5_o =>ben_xel_shd.g_old_rec.xel_attribute5
316: ,p_xel_attribute6_o =>ben_xel_shd.g_old_rec.xel_attribute6
317: ,p_xel_attribute7_o =>ben_xel_shd.g_old_rec.xel_attribute7
318: ,p_xel_attribute8_o =>ben_xel_shd.g_old_rec.xel_attribute8
311: ,p_xel_attribute1_o =>ben_xel_shd.g_old_rec.xel_attribute1
312: ,p_xel_attribute2_o =>ben_xel_shd.g_old_rec.xel_attribute2
313: ,p_xel_attribute3_o =>ben_xel_shd.g_old_rec.xel_attribute3
314: ,p_xel_attribute4_o =>ben_xel_shd.g_old_rec.xel_attribute4
315: ,p_xel_attribute5_o =>ben_xel_shd.g_old_rec.xel_attribute5
316: ,p_xel_attribute6_o =>ben_xel_shd.g_old_rec.xel_attribute6
317: ,p_xel_attribute7_o =>ben_xel_shd.g_old_rec.xel_attribute7
318: ,p_xel_attribute8_o =>ben_xel_shd.g_old_rec.xel_attribute8
319: ,p_xel_attribute9_o =>ben_xel_shd.g_old_rec.xel_attribute9
312: ,p_xel_attribute2_o =>ben_xel_shd.g_old_rec.xel_attribute2
313: ,p_xel_attribute3_o =>ben_xel_shd.g_old_rec.xel_attribute3
314: ,p_xel_attribute4_o =>ben_xel_shd.g_old_rec.xel_attribute4
315: ,p_xel_attribute5_o =>ben_xel_shd.g_old_rec.xel_attribute5
316: ,p_xel_attribute6_o =>ben_xel_shd.g_old_rec.xel_attribute6
317: ,p_xel_attribute7_o =>ben_xel_shd.g_old_rec.xel_attribute7
318: ,p_xel_attribute8_o =>ben_xel_shd.g_old_rec.xel_attribute8
319: ,p_xel_attribute9_o =>ben_xel_shd.g_old_rec.xel_attribute9
320: ,p_xel_attribute10_o =>ben_xel_shd.g_old_rec.xel_attribute10
313: ,p_xel_attribute3_o =>ben_xel_shd.g_old_rec.xel_attribute3
314: ,p_xel_attribute4_o =>ben_xel_shd.g_old_rec.xel_attribute4
315: ,p_xel_attribute5_o =>ben_xel_shd.g_old_rec.xel_attribute5
316: ,p_xel_attribute6_o =>ben_xel_shd.g_old_rec.xel_attribute6
317: ,p_xel_attribute7_o =>ben_xel_shd.g_old_rec.xel_attribute7
318: ,p_xel_attribute8_o =>ben_xel_shd.g_old_rec.xel_attribute8
319: ,p_xel_attribute9_o =>ben_xel_shd.g_old_rec.xel_attribute9
320: ,p_xel_attribute10_o =>ben_xel_shd.g_old_rec.xel_attribute10
321: ,p_xel_attribute11_o =>ben_xel_shd.g_old_rec.xel_attribute11
314: ,p_xel_attribute4_o =>ben_xel_shd.g_old_rec.xel_attribute4
315: ,p_xel_attribute5_o =>ben_xel_shd.g_old_rec.xel_attribute5
316: ,p_xel_attribute6_o =>ben_xel_shd.g_old_rec.xel_attribute6
317: ,p_xel_attribute7_o =>ben_xel_shd.g_old_rec.xel_attribute7
318: ,p_xel_attribute8_o =>ben_xel_shd.g_old_rec.xel_attribute8
319: ,p_xel_attribute9_o =>ben_xel_shd.g_old_rec.xel_attribute9
320: ,p_xel_attribute10_o =>ben_xel_shd.g_old_rec.xel_attribute10
321: ,p_xel_attribute11_o =>ben_xel_shd.g_old_rec.xel_attribute11
322: ,p_xel_attribute12_o =>ben_xel_shd.g_old_rec.xel_attribute12
315: ,p_xel_attribute5_o =>ben_xel_shd.g_old_rec.xel_attribute5
316: ,p_xel_attribute6_o =>ben_xel_shd.g_old_rec.xel_attribute6
317: ,p_xel_attribute7_o =>ben_xel_shd.g_old_rec.xel_attribute7
318: ,p_xel_attribute8_o =>ben_xel_shd.g_old_rec.xel_attribute8
319: ,p_xel_attribute9_o =>ben_xel_shd.g_old_rec.xel_attribute9
320: ,p_xel_attribute10_o =>ben_xel_shd.g_old_rec.xel_attribute10
321: ,p_xel_attribute11_o =>ben_xel_shd.g_old_rec.xel_attribute11
322: ,p_xel_attribute12_o =>ben_xel_shd.g_old_rec.xel_attribute12
323: ,p_xel_attribute13_o =>ben_xel_shd.g_old_rec.xel_attribute13
316: ,p_xel_attribute6_o =>ben_xel_shd.g_old_rec.xel_attribute6
317: ,p_xel_attribute7_o =>ben_xel_shd.g_old_rec.xel_attribute7
318: ,p_xel_attribute8_o =>ben_xel_shd.g_old_rec.xel_attribute8
319: ,p_xel_attribute9_o =>ben_xel_shd.g_old_rec.xel_attribute9
320: ,p_xel_attribute10_o =>ben_xel_shd.g_old_rec.xel_attribute10
321: ,p_xel_attribute11_o =>ben_xel_shd.g_old_rec.xel_attribute11
322: ,p_xel_attribute12_o =>ben_xel_shd.g_old_rec.xel_attribute12
323: ,p_xel_attribute13_o =>ben_xel_shd.g_old_rec.xel_attribute13
324: ,p_xel_attribute14_o =>ben_xel_shd.g_old_rec.xel_attribute14
317: ,p_xel_attribute7_o =>ben_xel_shd.g_old_rec.xel_attribute7
318: ,p_xel_attribute8_o =>ben_xel_shd.g_old_rec.xel_attribute8
319: ,p_xel_attribute9_o =>ben_xel_shd.g_old_rec.xel_attribute9
320: ,p_xel_attribute10_o =>ben_xel_shd.g_old_rec.xel_attribute10
321: ,p_xel_attribute11_o =>ben_xel_shd.g_old_rec.xel_attribute11
322: ,p_xel_attribute12_o =>ben_xel_shd.g_old_rec.xel_attribute12
323: ,p_xel_attribute13_o =>ben_xel_shd.g_old_rec.xel_attribute13
324: ,p_xel_attribute14_o =>ben_xel_shd.g_old_rec.xel_attribute14
325: ,p_xel_attribute15_o =>ben_xel_shd.g_old_rec.xel_attribute15
318: ,p_xel_attribute8_o =>ben_xel_shd.g_old_rec.xel_attribute8
319: ,p_xel_attribute9_o =>ben_xel_shd.g_old_rec.xel_attribute9
320: ,p_xel_attribute10_o =>ben_xel_shd.g_old_rec.xel_attribute10
321: ,p_xel_attribute11_o =>ben_xel_shd.g_old_rec.xel_attribute11
322: ,p_xel_attribute12_o =>ben_xel_shd.g_old_rec.xel_attribute12
323: ,p_xel_attribute13_o =>ben_xel_shd.g_old_rec.xel_attribute13
324: ,p_xel_attribute14_o =>ben_xel_shd.g_old_rec.xel_attribute14
325: ,p_xel_attribute15_o =>ben_xel_shd.g_old_rec.xel_attribute15
326: ,p_xel_attribute16_o =>ben_xel_shd.g_old_rec.xel_attribute16
319: ,p_xel_attribute9_o =>ben_xel_shd.g_old_rec.xel_attribute9
320: ,p_xel_attribute10_o =>ben_xel_shd.g_old_rec.xel_attribute10
321: ,p_xel_attribute11_o =>ben_xel_shd.g_old_rec.xel_attribute11
322: ,p_xel_attribute12_o =>ben_xel_shd.g_old_rec.xel_attribute12
323: ,p_xel_attribute13_o =>ben_xel_shd.g_old_rec.xel_attribute13
324: ,p_xel_attribute14_o =>ben_xel_shd.g_old_rec.xel_attribute14
325: ,p_xel_attribute15_o =>ben_xel_shd.g_old_rec.xel_attribute15
326: ,p_xel_attribute16_o =>ben_xel_shd.g_old_rec.xel_attribute16
327: ,p_xel_attribute17_o =>ben_xel_shd.g_old_rec.xel_attribute17
320: ,p_xel_attribute10_o =>ben_xel_shd.g_old_rec.xel_attribute10
321: ,p_xel_attribute11_o =>ben_xel_shd.g_old_rec.xel_attribute11
322: ,p_xel_attribute12_o =>ben_xel_shd.g_old_rec.xel_attribute12
323: ,p_xel_attribute13_o =>ben_xel_shd.g_old_rec.xel_attribute13
324: ,p_xel_attribute14_o =>ben_xel_shd.g_old_rec.xel_attribute14
325: ,p_xel_attribute15_o =>ben_xel_shd.g_old_rec.xel_attribute15
326: ,p_xel_attribute16_o =>ben_xel_shd.g_old_rec.xel_attribute16
327: ,p_xel_attribute17_o =>ben_xel_shd.g_old_rec.xel_attribute17
328: ,p_xel_attribute18_o =>ben_xel_shd.g_old_rec.xel_attribute18
321: ,p_xel_attribute11_o =>ben_xel_shd.g_old_rec.xel_attribute11
322: ,p_xel_attribute12_o =>ben_xel_shd.g_old_rec.xel_attribute12
323: ,p_xel_attribute13_o =>ben_xel_shd.g_old_rec.xel_attribute13
324: ,p_xel_attribute14_o =>ben_xel_shd.g_old_rec.xel_attribute14
325: ,p_xel_attribute15_o =>ben_xel_shd.g_old_rec.xel_attribute15
326: ,p_xel_attribute16_o =>ben_xel_shd.g_old_rec.xel_attribute16
327: ,p_xel_attribute17_o =>ben_xel_shd.g_old_rec.xel_attribute17
328: ,p_xel_attribute18_o =>ben_xel_shd.g_old_rec.xel_attribute18
329: ,p_xel_attribute19_o =>ben_xel_shd.g_old_rec.xel_attribute19
322: ,p_xel_attribute12_o =>ben_xel_shd.g_old_rec.xel_attribute12
323: ,p_xel_attribute13_o =>ben_xel_shd.g_old_rec.xel_attribute13
324: ,p_xel_attribute14_o =>ben_xel_shd.g_old_rec.xel_attribute14
325: ,p_xel_attribute15_o =>ben_xel_shd.g_old_rec.xel_attribute15
326: ,p_xel_attribute16_o =>ben_xel_shd.g_old_rec.xel_attribute16
327: ,p_xel_attribute17_o =>ben_xel_shd.g_old_rec.xel_attribute17
328: ,p_xel_attribute18_o =>ben_xel_shd.g_old_rec.xel_attribute18
329: ,p_xel_attribute19_o =>ben_xel_shd.g_old_rec.xel_attribute19
330: ,p_xel_attribute20_o =>ben_xel_shd.g_old_rec.xel_attribute20
323: ,p_xel_attribute13_o =>ben_xel_shd.g_old_rec.xel_attribute13
324: ,p_xel_attribute14_o =>ben_xel_shd.g_old_rec.xel_attribute14
325: ,p_xel_attribute15_o =>ben_xel_shd.g_old_rec.xel_attribute15
326: ,p_xel_attribute16_o =>ben_xel_shd.g_old_rec.xel_attribute16
327: ,p_xel_attribute17_o =>ben_xel_shd.g_old_rec.xel_attribute17
328: ,p_xel_attribute18_o =>ben_xel_shd.g_old_rec.xel_attribute18
329: ,p_xel_attribute19_o =>ben_xel_shd.g_old_rec.xel_attribute19
330: ,p_xel_attribute20_o =>ben_xel_shd.g_old_rec.xel_attribute20
331: ,p_xel_attribute21_o =>ben_xel_shd.g_old_rec.xel_attribute21
324: ,p_xel_attribute14_o =>ben_xel_shd.g_old_rec.xel_attribute14
325: ,p_xel_attribute15_o =>ben_xel_shd.g_old_rec.xel_attribute15
326: ,p_xel_attribute16_o =>ben_xel_shd.g_old_rec.xel_attribute16
327: ,p_xel_attribute17_o =>ben_xel_shd.g_old_rec.xel_attribute17
328: ,p_xel_attribute18_o =>ben_xel_shd.g_old_rec.xel_attribute18
329: ,p_xel_attribute19_o =>ben_xel_shd.g_old_rec.xel_attribute19
330: ,p_xel_attribute20_o =>ben_xel_shd.g_old_rec.xel_attribute20
331: ,p_xel_attribute21_o =>ben_xel_shd.g_old_rec.xel_attribute21
332: ,p_xel_attribute22_o =>ben_xel_shd.g_old_rec.xel_attribute22
325: ,p_xel_attribute15_o =>ben_xel_shd.g_old_rec.xel_attribute15
326: ,p_xel_attribute16_o =>ben_xel_shd.g_old_rec.xel_attribute16
327: ,p_xel_attribute17_o =>ben_xel_shd.g_old_rec.xel_attribute17
328: ,p_xel_attribute18_o =>ben_xel_shd.g_old_rec.xel_attribute18
329: ,p_xel_attribute19_o =>ben_xel_shd.g_old_rec.xel_attribute19
330: ,p_xel_attribute20_o =>ben_xel_shd.g_old_rec.xel_attribute20
331: ,p_xel_attribute21_o =>ben_xel_shd.g_old_rec.xel_attribute21
332: ,p_xel_attribute22_o =>ben_xel_shd.g_old_rec.xel_attribute22
333: ,p_xel_attribute23_o =>ben_xel_shd.g_old_rec.xel_attribute23
326: ,p_xel_attribute16_o =>ben_xel_shd.g_old_rec.xel_attribute16
327: ,p_xel_attribute17_o =>ben_xel_shd.g_old_rec.xel_attribute17
328: ,p_xel_attribute18_o =>ben_xel_shd.g_old_rec.xel_attribute18
329: ,p_xel_attribute19_o =>ben_xel_shd.g_old_rec.xel_attribute19
330: ,p_xel_attribute20_o =>ben_xel_shd.g_old_rec.xel_attribute20
331: ,p_xel_attribute21_o =>ben_xel_shd.g_old_rec.xel_attribute21
332: ,p_xel_attribute22_o =>ben_xel_shd.g_old_rec.xel_attribute22
333: ,p_xel_attribute23_o =>ben_xel_shd.g_old_rec.xel_attribute23
334: ,p_xel_attribute24_o =>ben_xel_shd.g_old_rec.xel_attribute24
327: ,p_xel_attribute17_o =>ben_xel_shd.g_old_rec.xel_attribute17
328: ,p_xel_attribute18_o =>ben_xel_shd.g_old_rec.xel_attribute18
329: ,p_xel_attribute19_o =>ben_xel_shd.g_old_rec.xel_attribute19
330: ,p_xel_attribute20_o =>ben_xel_shd.g_old_rec.xel_attribute20
331: ,p_xel_attribute21_o =>ben_xel_shd.g_old_rec.xel_attribute21
332: ,p_xel_attribute22_o =>ben_xel_shd.g_old_rec.xel_attribute22
333: ,p_xel_attribute23_o =>ben_xel_shd.g_old_rec.xel_attribute23
334: ,p_xel_attribute24_o =>ben_xel_shd.g_old_rec.xel_attribute24
335: ,p_xel_attribute25_o =>ben_xel_shd.g_old_rec.xel_attribute25
328: ,p_xel_attribute18_o =>ben_xel_shd.g_old_rec.xel_attribute18
329: ,p_xel_attribute19_o =>ben_xel_shd.g_old_rec.xel_attribute19
330: ,p_xel_attribute20_o =>ben_xel_shd.g_old_rec.xel_attribute20
331: ,p_xel_attribute21_o =>ben_xel_shd.g_old_rec.xel_attribute21
332: ,p_xel_attribute22_o =>ben_xel_shd.g_old_rec.xel_attribute22
333: ,p_xel_attribute23_o =>ben_xel_shd.g_old_rec.xel_attribute23
334: ,p_xel_attribute24_o =>ben_xel_shd.g_old_rec.xel_attribute24
335: ,p_xel_attribute25_o =>ben_xel_shd.g_old_rec.xel_attribute25
336: ,p_xel_attribute26_o =>ben_xel_shd.g_old_rec.xel_attribute26
329: ,p_xel_attribute19_o =>ben_xel_shd.g_old_rec.xel_attribute19
330: ,p_xel_attribute20_o =>ben_xel_shd.g_old_rec.xel_attribute20
331: ,p_xel_attribute21_o =>ben_xel_shd.g_old_rec.xel_attribute21
332: ,p_xel_attribute22_o =>ben_xel_shd.g_old_rec.xel_attribute22
333: ,p_xel_attribute23_o =>ben_xel_shd.g_old_rec.xel_attribute23
334: ,p_xel_attribute24_o =>ben_xel_shd.g_old_rec.xel_attribute24
335: ,p_xel_attribute25_o =>ben_xel_shd.g_old_rec.xel_attribute25
336: ,p_xel_attribute26_o =>ben_xel_shd.g_old_rec.xel_attribute26
337: ,p_xel_attribute27_o =>ben_xel_shd.g_old_rec.xel_attribute27
330: ,p_xel_attribute20_o =>ben_xel_shd.g_old_rec.xel_attribute20
331: ,p_xel_attribute21_o =>ben_xel_shd.g_old_rec.xel_attribute21
332: ,p_xel_attribute22_o =>ben_xel_shd.g_old_rec.xel_attribute22
333: ,p_xel_attribute23_o =>ben_xel_shd.g_old_rec.xel_attribute23
334: ,p_xel_attribute24_o =>ben_xel_shd.g_old_rec.xel_attribute24
335: ,p_xel_attribute25_o =>ben_xel_shd.g_old_rec.xel_attribute25
336: ,p_xel_attribute26_o =>ben_xel_shd.g_old_rec.xel_attribute26
337: ,p_xel_attribute27_o =>ben_xel_shd.g_old_rec.xel_attribute27
338: ,p_xel_attribute28_o =>ben_xel_shd.g_old_rec.xel_attribute28
331: ,p_xel_attribute21_o =>ben_xel_shd.g_old_rec.xel_attribute21
332: ,p_xel_attribute22_o =>ben_xel_shd.g_old_rec.xel_attribute22
333: ,p_xel_attribute23_o =>ben_xel_shd.g_old_rec.xel_attribute23
334: ,p_xel_attribute24_o =>ben_xel_shd.g_old_rec.xel_attribute24
335: ,p_xel_attribute25_o =>ben_xel_shd.g_old_rec.xel_attribute25
336: ,p_xel_attribute26_o =>ben_xel_shd.g_old_rec.xel_attribute26
337: ,p_xel_attribute27_o =>ben_xel_shd.g_old_rec.xel_attribute27
338: ,p_xel_attribute28_o =>ben_xel_shd.g_old_rec.xel_attribute28
339: ,p_xel_attribute29_o =>ben_xel_shd.g_old_rec.xel_attribute29
332: ,p_xel_attribute22_o =>ben_xel_shd.g_old_rec.xel_attribute22
333: ,p_xel_attribute23_o =>ben_xel_shd.g_old_rec.xel_attribute23
334: ,p_xel_attribute24_o =>ben_xel_shd.g_old_rec.xel_attribute24
335: ,p_xel_attribute25_o =>ben_xel_shd.g_old_rec.xel_attribute25
336: ,p_xel_attribute26_o =>ben_xel_shd.g_old_rec.xel_attribute26
337: ,p_xel_attribute27_o =>ben_xel_shd.g_old_rec.xel_attribute27
338: ,p_xel_attribute28_o =>ben_xel_shd.g_old_rec.xel_attribute28
339: ,p_xel_attribute29_o =>ben_xel_shd.g_old_rec.xel_attribute29
340: ,p_xel_attribute30_o =>ben_xel_shd.g_old_rec.xel_attribute30
333: ,p_xel_attribute23_o =>ben_xel_shd.g_old_rec.xel_attribute23
334: ,p_xel_attribute24_o =>ben_xel_shd.g_old_rec.xel_attribute24
335: ,p_xel_attribute25_o =>ben_xel_shd.g_old_rec.xel_attribute25
336: ,p_xel_attribute26_o =>ben_xel_shd.g_old_rec.xel_attribute26
337: ,p_xel_attribute27_o =>ben_xel_shd.g_old_rec.xel_attribute27
338: ,p_xel_attribute28_o =>ben_xel_shd.g_old_rec.xel_attribute28
339: ,p_xel_attribute29_o =>ben_xel_shd.g_old_rec.xel_attribute29
340: ,p_xel_attribute30_o =>ben_xel_shd.g_old_rec.xel_attribute30
341: ,p_defined_balance_id_o =>ben_xel_shd.g_old_rec.defined_balance_id
334: ,p_xel_attribute24_o =>ben_xel_shd.g_old_rec.xel_attribute24
335: ,p_xel_attribute25_o =>ben_xel_shd.g_old_rec.xel_attribute25
336: ,p_xel_attribute26_o =>ben_xel_shd.g_old_rec.xel_attribute26
337: ,p_xel_attribute27_o =>ben_xel_shd.g_old_rec.xel_attribute27
338: ,p_xel_attribute28_o =>ben_xel_shd.g_old_rec.xel_attribute28
339: ,p_xel_attribute29_o =>ben_xel_shd.g_old_rec.xel_attribute29
340: ,p_xel_attribute30_o =>ben_xel_shd.g_old_rec.xel_attribute30
341: ,p_defined_balance_id_o =>ben_xel_shd.g_old_rec.defined_balance_id
342: ,p_object_version_number_o =>ben_xel_shd.g_old_rec.object_version_number
335: ,p_xel_attribute25_o =>ben_xel_shd.g_old_rec.xel_attribute25
336: ,p_xel_attribute26_o =>ben_xel_shd.g_old_rec.xel_attribute26
337: ,p_xel_attribute27_o =>ben_xel_shd.g_old_rec.xel_attribute27
338: ,p_xel_attribute28_o =>ben_xel_shd.g_old_rec.xel_attribute28
339: ,p_xel_attribute29_o =>ben_xel_shd.g_old_rec.xel_attribute29
340: ,p_xel_attribute30_o =>ben_xel_shd.g_old_rec.xel_attribute30
341: ,p_defined_balance_id_o =>ben_xel_shd.g_old_rec.defined_balance_id
342: ,p_object_version_number_o =>ben_xel_shd.g_old_rec.object_version_number
343: );
336: ,p_xel_attribute26_o =>ben_xel_shd.g_old_rec.xel_attribute26
337: ,p_xel_attribute27_o =>ben_xel_shd.g_old_rec.xel_attribute27
338: ,p_xel_attribute28_o =>ben_xel_shd.g_old_rec.xel_attribute28
339: ,p_xel_attribute29_o =>ben_xel_shd.g_old_rec.xel_attribute29
340: ,p_xel_attribute30_o =>ben_xel_shd.g_old_rec.xel_attribute30
341: ,p_defined_balance_id_o =>ben_xel_shd.g_old_rec.defined_balance_id
342: ,p_object_version_number_o =>ben_xel_shd.g_old_rec.object_version_number
343: );
344: --
337: ,p_xel_attribute27_o =>ben_xel_shd.g_old_rec.xel_attribute27
338: ,p_xel_attribute28_o =>ben_xel_shd.g_old_rec.xel_attribute28
339: ,p_xel_attribute29_o =>ben_xel_shd.g_old_rec.xel_attribute29
340: ,p_xel_attribute30_o =>ben_xel_shd.g_old_rec.xel_attribute30
341: ,p_defined_balance_id_o =>ben_xel_shd.g_old_rec.defined_balance_id
342: ,p_object_version_number_o =>ben_xel_shd.g_old_rec.object_version_number
343: );
344: --
345: exception
338: ,p_xel_attribute28_o =>ben_xel_shd.g_old_rec.xel_attribute28
339: ,p_xel_attribute29_o =>ben_xel_shd.g_old_rec.xel_attribute29
340: ,p_xel_attribute30_o =>ben_xel_shd.g_old_rec.xel_attribute30
341: ,p_defined_balance_id_o =>ben_xel_shd.g_old_rec.defined_balance_id
342: ,p_object_version_number_o =>ben_xel_shd.g_old_rec.object_version_number
343: );
344: --
345: exception
346: --
400: -- Internal Row Handler Use Only.
401: --
402: -- {End Of Comments}
403: -- ----------------------------------------------------------------------------
404: Procedure convert_defs(p_rec in out nocopy ben_xel_shd.g_rec_type) is
405: --
406: l_proc varchar2(72) := g_package||'convert_defs';
407: --
408: Begin
415: -- is being used then we must set to the 'current' argument value.
416: --
417: If (p_rec.name = hr_api.g_varchar2) then
418: p_rec.name :=
419: ben_xel_shd.g_old_rec.name;
420: End If;
421: If (p_rec.xml_tag_name = hr_api.g_varchar2) then
422: p_rec.xml_tag_name :=
423: ben_xel_shd.g_old_rec.xml_tag_name;
419: ben_xel_shd.g_old_rec.name;
420: End If;
421: If (p_rec.xml_tag_name = hr_api.g_varchar2) then
422: p_rec.xml_tag_name :=
423: ben_xel_shd.g_old_rec.xml_tag_name;
424: End If;
425: If (p_rec.data_elmt_typ_cd = hr_api.g_varchar2) then
426: p_rec.data_elmt_typ_cd :=
427: ben_xel_shd.g_old_rec.data_elmt_typ_cd;
423: ben_xel_shd.g_old_rec.xml_tag_name;
424: End If;
425: If (p_rec.data_elmt_typ_cd = hr_api.g_varchar2) then
426: p_rec.data_elmt_typ_cd :=
427: ben_xel_shd.g_old_rec.data_elmt_typ_cd;
428: End If;
429: If (p_rec.data_elmt_rl = hr_api.g_number) then
430: p_rec.data_elmt_rl :=
431: ben_xel_shd.g_old_rec.data_elmt_rl;
427: ben_xel_shd.g_old_rec.data_elmt_typ_cd;
428: End If;
429: If (p_rec.data_elmt_rl = hr_api.g_number) then
430: p_rec.data_elmt_rl :=
431: ben_xel_shd.g_old_rec.data_elmt_rl;
432: End If;
433: If (p_rec.frmt_mask_cd = hr_api.g_varchar2) then
434: p_rec.frmt_mask_cd :=
435: ben_xel_shd.g_old_rec.frmt_mask_cd;
431: ben_xel_shd.g_old_rec.data_elmt_rl;
432: End If;
433: If (p_rec.frmt_mask_cd = hr_api.g_varchar2) then
434: p_rec.frmt_mask_cd :=
435: ben_xel_shd.g_old_rec.frmt_mask_cd;
436: End If;
437: If (p_rec.string_val = hr_api.g_varchar2) then
438: p_rec.string_val :=
439: ben_xel_shd.g_old_rec.string_val;
435: ben_xel_shd.g_old_rec.frmt_mask_cd;
436: End If;
437: If (p_rec.string_val = hr_api.g_varchar2) then
438: p_rec.string_val :=
439: ben_xel_shd.g_old_rec.string_val;
440: End If;
441: If (p_rec.dflt_val = hr_api.g_varchar2) then
442: p_rec.dflt_val :=
443: ben_xel_shd.g_old_rec.dflt_val;
439: ben_xel_shd.g_old_rec.string_val;
440: End If;
441: If (p_rec.dflt_val = hr_api.g_varchar2) then
442: p_rec.dflt_val :=
443: ben_xel_shd.g_old_rec.dflt_val;
444: End If;
445: If (p_rec.max_length_num = hr_api.g_number) then
446: p_rec.max_length_num :=
447: ben_xel_shd.g_old_rec.max_length_num;
443: ben_xel_shd.g_old_rec.dflt_val;
444: End If;
445: If (p_rec.max_length_num = hr_api.g_number) then
446: p_rec.max_length_num :=
447: ben_xel_shd.g_old_rec.max_length_num;
448: End If;
449: if (p_rec.just_cd = hr_api.g_varchar2) then
450: p_rec.just_cd :=
451: ben_xel_shd.g_old_rec.just_cd;
447: ben_xel_shd.g_old_rec.max_length_num;
448: End If;
449: if (p_rec.just_cd = hr_api.g_varchar2) then
450: p_rec.just_cd :=
451: ben_xel_shd.g_old_rec.just_cd;
452: End If;
453: if (p_rec.ttl_fnctn_cd = hr_api.g_varchar2) then
454: p_rec.ttl_fnctn_cd :=
455: ben_xel_shd.g_old_rec.ttl_fnctn_cd;
451: ben_xel_shd.g_old_rec.just_cd;
452: End If;
453: if (p_rec.ttl_fnctn_cd = hr_api.g_varchar2) then
454: p_rec.ttl_fnctn_cd :=
455: ben_xel_shd.g_old_rec.ttl_fnctn_cd;
456: End If;
457: if (p_rec.ttl_cond_oper_cd = hr_api.g_varchar2) then
458: p_rec.ttl_cond_oper_cd :=
459: ben_xel_shd.g_old_rec.ttl_cond_oper_cd;
455: ben_xel_shd.g_old_rec.ttl_fnctn_cd;
456: End If;
457: if (p_rec.ttl_cond_oper_cd = hr_api.g_varchar2) then
458: p_rec.ttl_cond_oper_cd :=
459: ben_xel_shd.g_old_rec.ttl_cond_oper_cd;
460: End If;
461: if (p_rec.ttl_cond_val = hr_api.g_varchar2) then
462: p_rec.ttl_cond_val :=
463: ben_xel_shd.g_old_rec.ttl_cond_val;
459: ben_xel_shd.g_old_rec.ttl_cond_oper_cd;
460: End If;
461: if (p_rec.ttl_cond_val = hr_api.g_varchar2) then
462: p_rec.ttl_cond_val :=
463: ben_xel_shd.g_old_rec.ttl_cond_val;
464: End If;
465: If (p_rec.ttl_sum_ext_data_elmt_id = hr_api.g_number) then
466: p_rec.ttl_sum_ext_data_elmt_id :=
467: ben_xel_shd.g_old_rec.ttl_sum_ext_data_elmt_id;
463: ben_xel_shd.g_old_rec.ttl_cond_val;
464: End If;
465: If (p_rec.ttl_sum_ext_data_elmt_id = hr_api.g_number) then
466: p_rec.ttl_sum_ext_data_elmt_id :=
467: ben_xel_shd.g_old_rec.ttl_sum_ext_data_elmt_id;
468: End If;
469: If (p_rec.ttl_cond_ext_data_elmt_id = hr_api.g_number) then
470: p_rec.ttl_cond_ext_data_elmt_id :=
471: ben_xel_shd.g_old_rec.ttl_cond_ext_data_elmt_id;
467: ben_xel_shd.g_old_rec.ttl_sum_ext_data_elmt_id;
468: End If;
469: If (p_rec.ttl_cond_ext_data_elmt_id = hr_api.g_number) then
470: p_rec.ttl_cond_ext_data_elmt_id :=
471: ben_xel_shd.g_old_rec.ttl_cond_ext_data_elmt_id;
472: End If;
473: If (p_rec.ext_fld_id = hr_api.g_number) then
474: p_rec.ext_fld_id :=
475: ben_xel_shd.g_old_rec.ext_fld_id;
471: ben_xel_shd.g_old_rec.ttl_cond_ext_data_elmt_id;
472: End If;
473: If (p_rec.ext_fld_id = hr_api.g_number) then
474: p_rec.ext_fld_id :=
475: ben_xel_shd.g_old_rec.ext_fld_id;
476: End If;
477: If (p_rec.business_group_id = hr_api.g_number) then
478: p_rec.business_group_id :=
479: ben_xel_shd.g_old_rec.business_group_id;
475: ben_xel_shd.g_old_rec.ext_fld_id;
476: End If;
477: If (p_rec.business_group_id = hr_api.g_number) then
478: p_rec.business_group_id :=
479: ben_xel_shd.g_old_rec.business_group_id;
480: End If;
481: If (p_rec.legislation_code = hr_api.g_varchar2) then
482: p_rec.legislation_code :=
483: ben_xel_shd.g_old_rec.legislation_code;
479: ben_xel_shd.g_old_rec.business_group_id;
480: End If;
481: If (p_rec.legislation_code = hr_api.g_varchar2) then
482: p_rec.legislation_code :=
483: ben_xel_shd.g_old_rec.legislation_code;
484: End If;
485: If (p_rec.xel_attribute_category = hr_api.g_varchar2) then
486: p_rec.xel_attribute_category :=
487: ben_xel_shd.g_old_rec.xel_attribute_category;
483: ben_xel_shd.g_old_rec.legislation_code;
484: End If;
485: If (p_rec.xel_attribute_category = hr_api.g_varchar2) then
486: p_rec.xel_attribute_category :=
487: ben_xel_shd.g_old_rec.xel_attribute_category;
488: End If;
489: If (p_rec.xel_attribute1 = hr_api.g_varchar2) then
490: p_rec.xel_attribute1 :=
491: ben_xel_shd.g_old_rec.xel_attribute1;
487: ben_xel_shd.g_old_rec.xel_attribute_category;
488: End If;
489: If (p_rec.xel_attribute1 = hr_api.g_varchar2) then
490: p_rec.xel_attribute1 :=
491: ben_xel_shd.g_old_rec.xel_attribute1;
492: End If;
493: If (p_rec.xel_attribute2 = hr_api.g_varchar2) then
494: p_rec.xel_attribute2 :=
495: ben_xel_shd.g_old_rec.xel_attribute2;
491: ben_xel_shd.g_old_rec.xel_attribute1;
492: End If;
493: If (p_rec.xel_attribute2 = hr_api.g_varchar2) then
494: p_rec.xel_attribute2 :=
495: ben_xel_shd.g_old_rec.xel_attribute2;
496: End If;
497: If (p_rec.xel_attribute3 = hr_api.g_varchar2) then
498: p_rec.xel_attribute3 :=
499: ben_xel_shd.g_old_rec.xel_attribute3;
495: ben_xel_shd.g_old_rec.xel_attribute2;
496: End If;
497: If (p_rec.xel_attribute3 = hr_api.g_varchar2) then
498: p_rec.xel_attribute3 :=
499: ben_xel_shd.g_old_rec.xel_attribute3;
500: End If;
501: If (p_rec.xel_attribute4 = hr_api.g_varchar2) then
502: p_rec.xel_attribute4 :=
503: ben_xel_shd.g_old_rec.xel_attribute4;
499: ben_xel_shd.g_old_rec.xel_attribute3;
500: End If;
501: If (p_rec.xel_attribute4 = hr_api.g_varchar2) then
502: p_rec.xel_attribute4 :=
503: ben_xel_shd.g_old_rec.xel_attribute4;
504: End If;
505: If (p_rec.xel_attribute5 = hr_api.g_varchar2) then
506: p_rec.xel_attribute5 :=
507: ben_xel_shd.g_old_rec.xel_attribute5;
503: ben_xel_shd.g_old_rec.xel_attribute4;
504: End If;
505: If (p_rec.xel_attribute5 = hr_api.g_varchar2) then
506: p_rec.xel_attribute5 :=
507: ben_xel_shd.g_old_rec.xel_attribute5;
508: End If;
509: If (p_rec.xel_attribute6 = hr_api.g_varchar2) then
510: p_rec.xel_attribute6 :=
511: ben_xel_shd.g_old_rec.xel_attribute6;
507: ben_xel_shd.g_old_rec.xel_attribute5;
508: End If;
509: If (p_rec.xel_attribute6 = hr_api.g_varchar2) then
510: p_rec.xel_attribute6 :=
511: ben_xel_shd.g_old_rec.xel_attribute6;
512: End If;
513: If (p_rec.xel_attribute7 = hr_api.g_varchar2) then
514: p_rec.xel_attribute7 :=
515: ben_xel_shd.g_old_rec.xel_attribute7;
511: ben_xel_shd.g_old_rec.xel_attribute6;
512: End If;
513: If (p_rec.xel_attribute7 = hr_api.g_varchar2) then
514: p_rec.xel_attribute7 :=
515: ben_xel_shd.g_old_rec.xel_attribute7;
516: End If;
517: If (p_rec.xel_attribute8 = hr_api.g_varchar2) then
518: p_rec.xel_attribute8 :=
519: ben_xel_shd.g_old_rec.xel_attribute8;
515: ben_xel_shd.g_old_rec.xel_attribute7;
516: End If;
517: If (p_rec.xel_attribute8 = hr_api.g_varchar2) then
518: p_rec.xel_attribute8 :=
519: ben_xel_shd.g_old_rec.xel_attribute8;
520: End If;
521: If (p_rec.xel_attribute9 = hr_api.g_varchar2) then
522: p_rec.xel_attribute9 :=
523: ben_xel_shd.g_old_rec.xel_attribute9;
519: ben_xel_shd.g_old_rec.xel_attribute8;
520: End If;
521: If (p_rec.xel_attribute9 = hr_api.g_varchar2) then
522: p_rec.xel_attribute9 :=
523: ben_xel_shd.g_old_rec.xel_attribute9;
524: End If;
525: If (p_rec.xel_attribute10 = hr_api.g_varchar2) then
526: p_rec.xel_attribute10 :=
527: ben_xel_shd.g_old_rec.xel_attribute10;
523: ben_xel_shd.g_old_rec.xel_attribute9;
524: End If;
525: If (p_rec.xel_attribute10 = hr_api.g_varchar2) then
526: p_rec.xel_attribute10 :=
527: ben_xel_shd.g_old_rec.xel_attribute10;
528: End If;
529: If (p_rec.xel_attribute11 = hr_api.g_varchar2) then
530: p_rec.xel_attribute11 :=
531: ben_xel_shd.g_old_rec.xel_attribute11;
527: ben_xel_shd.g_old_rec.xel_attribute10;
528: End If;
529: If (p_rec.xel_attribute11 = hr_api.g_varchar2) then
530: p_rec.xel_attribute11 :=
531: ben_xel_shd.g_old_rec.xel_attribute11;
532: End If;
533: If (p_rec.xel_attribute12 = hr_api.g_varchar2) then
534: p_rec.xel_attribute12 :=
535: ben_xel_shd.g_old_rec.xel_attribute12;
531: ben_xel_shd.g_old_rec.xel_attribute11;
532: End If;
533: If (p_rec.xel_attribute12 = hr_api.g_varchar2) then
534: p_rec.xel_attribute12 :=
535: ben_xel_shd.g_old_rec.xel_attribute12;
536: End If;
537: If (p_rec.xel_attribute13 = hr_api.g_varchar2) then
538: p_rec.xel_attribute13 :=
539: ben_xel_shd.g_old_rec.xel_attribute13;
535: ben_xel_shd.g_old_rec.xel_attribute12;
536: End If;
537: If (p_rec.xel_attribute13 = hr_api.g_varchar2) then
538: p_rec.xel_attribute13 :=
539: ben_xel_shd.g_old_rec.xel_attribute13;
540: End If;
541: If (p_rec.xel_attribute14 = hr_api.g_varchar2) then
542: p_rec.xel_attribute14 :=
543: ben_xel_shd.g_old_rec.xel_attribute14;
539: ben_xel_shd.g_old_rec.xel_attribute13;
540: End If;
541: If (p_rec.xel_attribute14 = hr_api.g_varchar2) then
542: p_rec.xel_attribute14 :=
543: ben_xel_shd.g_old_rec.xel_attribute14;
544: End If;
545: If (p_rec.xel_attribute15 = hr_api.g_varchar2) then
546: p_rec.xel_attribute15 :=
547: ben_xel_shd.g_old_rec.xel_attribute15;
543: ben_xel_shd.g_old_rec.xel_attribute14;
544: End If;
545: If (p_rec.xel_attribute15 = hr_api.g_varchar2) then
546: p_rec.xel_attribute15 :=
547: ben_xel_shd.g_old_rec.xel_attribute15;
548: End If;
549: If (p_rec.xel_attribute16 = hr_api.g_varchar2) then
550: p_rec.xel_attribute16 :=
551: ben_xel_shd.g_old_rec.xel_attribute16;
547: ben_xel_shd.g_old_rec.xel_attribute15;
548: End If;
549: If (p_rec.xel_attribute16 = hr_api.g_varchar2) then
550: p_rec.xel_attribute16 :=
551: ben_xel_shd.g_old_rec.xel_attribute16;
552: End If;
553: If (p_rec.xel_attribute17 = hr_api.g_varchar2) then
554: p_rec.xel_attribute17 :=
555: ben_xel_shd.g_old_rec.xel_attribute17;
551: ben_xel_shd.g_old_rec.xel_attribute16;
552: End If;
553: If (p_rec.xel_attribute17 = hr_api.g_varchar2) then
554: p_rec.xel_attribute17 :=
555: ben_xel_shd.g_old_rec.xel_attribute17;
556: End If;
557: If (p_rec.xel_attribute18 = hr_api.g_varchar2) then
558: p_rec.xel_attribute18 :=
559: ben_xel_shd.g_old_rec.xel_attribute18;
555: ben_xel_shd.g_old_rec.xel_attribute17;
556: End If;
557: If (p_rec.xel_attribute18 = hr_api.g_varchar2) then
558: p_rec.xel_attribute18 :=
559: ben_xel_shd.g_old_rec.xel_attribute18;
560: End If;
561: If (p_rec.xel_attribute19 = hr_api.g_varchar2) then
562: p_rec.xel_attribute19 :=
563: ben_xel_shd.g_old_rec.xel_attribute19;
559: ben_xel_shd.g_old_rec.xel_attribute18;
560: End If;
561: If (p_rec.xel_attribute19 = hr_api.g_varchar2) then
562: p_rec.xel_attribute19 :=
563: ben_xel_shd.g_old_rec.xel_attribute19;
564: End If;
565: If (p_rec.xel_attribute20 = hr_api.g_varchar2) then
566: p_rec.xel_attribute20 :=
567: ben_xel_shd.g_old_rec.xel_attribute20;
563: ben_xel_shd.g_old_rec.xel_attribute19;
564: End If;
565: If (p_rec.xel_attribute20 = hr_api.g_varchar2) then
566: p_rec.xel_attribute20 :=
567: ben_xel_shd.g_old_rec.xel_attribute20;
568: End If;
569: If (p_rec.xel_attribute21 = hr_api.g_varchar2) then
570: p_rec.xel_attribute21 :=
571: ben_xel_shd.g_old_rec.xel_attribute21;
567: ben_xel_shd.g_old_rec.xel_attribute20;
568: End If;
569: If (p_rec.xel_attribute21 = hr_api.g_varchar2) then
570: p_rec.xel_attribute21 :=
571: ben_xel_shd.g_old_rec.xel_attribute21;
572: End If;
573: If (p_rec.xel_attribute22 = hr_api.g_varchar2) then
574: p_rec.xel_attribute22 :=
575: ben_xel_shd.g_old_rec.xel_attribute22;
571: ben_xel_shd.g_old_rec.xel_attribute21;
572: End If;
573: If (p_rec.xel_attribute22 = hr_api.g_varchar2) then
574: p_rec.xel_attribute22 :=
575: ben_xel_shd.g_old_rec.xel_attribute22;
576: End If;
577: If (p_rec.xel_attribute23 = hr_api.g_varchar2) then
578: p_rec.xel_attribute23 :=
579: ben_xel_shd.g_old_rec.xel_attribute23;
575: ben_xel_shd.g_old_rec.xel_attribute22;
576: End If;
577: If (p_rec.xel_attribute23 = hr_api.g_varchar2) then
578: p_rec.xel_attribute23 :=
579: ben_xel_shd.g_old_rec.xel_attribute23;
580: End If;
581: If (p_rec.xel_attribute24 = hr_api.g_varchar2) then
582: p_rec.xel_attribute24 :=
583: ben_xel_shd.g_old_rec.xel_attribute24;
579: ben_xel_shd.g_old_rec.xel_attribute23;
580: End If;
581: If (p_rec.xel_attribute24 = hr_api.g_varchar2) then
582: p_rec.xel_attribute24 :=
583: ben_xel_shd.g_old_rec.xel_attribute24;
584: End If;
585: If (p_rec.xel_attribute25 = hr_api.g_varchar2) then
586: p_rec.xel_attribute25 :=
587: ben_xel_shd.g_old_rec.xel_attribute25;
583: ben_xel_shd.g_old_rec.xel_attribute24;
584: End If;
585: If (p_rec.xel_attribute25 = hr_api.g_varchar2) then
586: p_rec.xel_attribute25 :=
587: ben_xel_shd.g_old_rec.xel_attribute25;
588: End If;
589: If (p_rec.xel_attribute26 = hr_api.g_varchar2) then
590: p_rec.xel_attribute26 :=
591: ben_xel_shd.g_old_rec.xel_attribute26;
587: ben_xel_shd.g_old_rec.xel_attribute25;
588: End If;
589: If (p_rec.xel_attribute26 = hr_api.g_varchar2) then
590: p_rec.xel_attribute26 :=
591: ben_xel_shd.g_old_rec.xel_attribute26;
592: End If;
593: If (p_rec.xel_attribute27 = hr_api.g_varchar2) then
594: p_rec.xel_attribute27 :=
595: ben_xel_shd.g_old_rec.xel_attribute27;
591: ben_xel_shd.g_old_rec.xel_attribute26;
592: End If;
593: If (p_rec.xel_attribute27 = hr_api.g_varchar2) then
594: p_rec.xel_attribute27 :=
595: ben_xel_shd.g_old_rec.xel_attribute27;
596: End If;
597: If (p_rec.xel_attribute28 = hr_api.g_varchar2) then
598: p_rec.xel_attribute28 :=
599: ben_xel_shd.g_old_rec.xel_attribute28;
595: ben_xel_shd.g_old_rec.xel_attribute27;
596: End If;
597: If (p_rec.xel_attribute28 = hr_api.g_varchar2) then
598: p_rec.xel_attribute28 :=
599: ben_xel_shd.g_old_rec.xel_attribute28;
600: End If;
601: If (p_rec.xel_attribute29 = hr_api.g_varchar2) then
602: p_rec.xel_attribute29 :=
603: ben_xel_shd.g_old_rec.xel_attribute29;
599: ben_xel_shd.g_old_rec.xel_attribute28;
600: End If;
601: If (p_rec.xel_attribute29 = hr_api.g_varchar2) then
602: p_rec.xel_attribute29 :=
603: ben_xel_shd.g_old_rec.xel_attribute29;
604: End If;
605: If (p_rec.xel_attribute30 = hr_api.g_varchar2) then
606: p_rec.xel_attribute30 :=
607: ben_xel_shd.g_old_rec.xel_attribute30;
603: ben_xel_shd.g_old_rec.xel_attribute29;
604: End If;
605: If (p_rec.xel_attribute30 = hr_api.g_varchar2) then
606: p_rec.xel_attribute30 :=
607: ben_xel_shd.g_old_rec.xel_attribute30;
608: End If;
609:
610:
611: If (p_rec.defined_balance_id = hr_api.g_number) then
609:
610:
611: If (p_rec.defined_balance_id = hr_api.g_number) then
612: p_rec.defined_balance_id :=
613: ben_xel_shd.g_old_rec.defined_balance_id;
614: End If;
615:
616: --
617: hr_utility.set_location(' Leaving:'||l_proc, 10);
623: -- ----------------------------------------------------------------------------
624: Procedure upd
625: (
626: p_effective_date in date,
627: p_rec in out nocopy ben_xel_shd.g_rec_type
628: ) is
629: --
630: l_proc varchar2(72) := g_package||'upd';
631: --
633: hr_utility.set_location('Entering:'||l_proc, 5);
634: --
635: -- We must lock the row which we need to update.
636: --
637: ben_xel_shd.lck
638: (
639: p_rec.ext_data_elmt_id,
640: p_rec.object_version_number
641: );
731: p_created_by in number default hr_api.g_number,
732: p_object_version_number in out nocopy number
733: ) is
734: --
735: l_rec ben_xel_shd.g_rec_type;
736: l_proc varchar2(72) := g_package||'upd';
737: --
738: Begin
739: hr_utility.set_location('Entering:'||l_proc, 5);
741: -- Call conversion function to turn arguments into the
742: -- l_rec structure.
743: --
744: l_rec :=
745: ben_xel_shd.convert_args
746: (
747: p_ext_data_elmt_id,
748: p_name,
749: p_xml_tag_name,