[Home] [Help]
50: -- Internal Row Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy ben_lsf_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_lsf_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the ben_los_fctr Row
68: --
69: update ben_los_fctr
118: object_version_number = p_rec.object_version_number,
119: use_overid_svc_dt_flag = p_rec.use_overid_svc_dt_flag
120: where los_fctr_id = p_rec.los_fctr_id;
121: --
122: ben_lsf_shd.g_api_dml := false; -- Unset the api dml status
123: --
124: hr_utility.set_location(' Leaving:'||l_proc, 10);
125: --
126: Exception
125: --
126: Exception
127: When hr_api.check_integrity_violated Then
128: -- A check constraint has been violated
129: ben_lsf_shd.g_api_dml := false; -- Unset the api dml status
130: ben_lsf_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.parent_integrity_violated Then
133: -- Parent integrity has been violated
126: Exception
127: When hr_api.check_integrity_violated Then
128: -- A check constraint has been violated
129: ben_lsf_shd.g_api_dml := false; -- Unset the api dml status
130: ben_lsf_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.parent_integrity_violated Then
133: -- Parent integrity has been violated
134: ben_lsf_shd.g_api_dml := false; -- Unset the api dml status
130: ben_lsf_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.parent_integrity_violated Then
133: -- Parent integrity has been violated
134: ben_lsf_shd.g_api_dml := false; -- Unset the api dml status
135: ben_lsf_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.unique_integrity_violated Then
138: -- Unique integrity has been violated
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.parent_integrity_violated Then
133: -- Parent integrity has been violated
134: ben_lsf_shd.g_api_dml := false; -- Unset the api dml status
135: ben_lsf_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.unique_integrity_violated Then
138: -- Unique integrity has been violated
139: ben_lsf_shd.g_api_dml := false; -- Unset the api dml status
135: ben_lsf_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.unique_integrity_violated Then
138: -- Unique integrity has been violated
139: ben_lsf_shd.g_api_dml := false; -- Unset the api dml status
140: ben_lsf_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When Others Then
143: ben_lsf_shd.g_api_dml := false; -- Unset the api dml status
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.unique_integrity_violated Then
138: -- Unique integrity has been violated
139: ben_lsf_shd.g_api_dml := false; -- Unset the api dml status
140: ben_lsf_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When Others Then
143: ben_lsf_shd.g_api_dml := false; -- Unset the api dml status
144: Raise;
139: ben_lsf_shd.g_api_dml := false; -- Unset the api dml status
140: ben_lsf_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When Others Then
143: ben_lsf_shd.g_api_dml := false; -- Unset the api dml status
144: Raise;
145: End update_dml;
146: --
147: -- ----------------------------------------------------------------------------
175: -- Internal Row Handler Use Only.
176: --
177: -- {End Of Comments}
178: -- ----------------------------------------------------------------------------
179: Procedure pre_update(p_rec in ben_lsf_shd.g_rec_type) is
180: --
181: l_proc varchar2(72) := g_package||'pre_update';
182: --
183: Begin
218: --
219: -- {End Of Comments}
220: -- ----------------------------------------------------------------------------
221: Procedure post_update(
222: p_effective_date in date,p_rec in ben_lsf_shd.g_rec_type) is
223: --
224: l_proc varchar2(72) := g_package||'post_update';
225: --
226: Begin
282: ,p_lsf_attribute30 =>p_rec.lsf_attribute30
283: ,p_object_version_number =>p_rec.object_version_number
284: ,p_use_overid_svc_dt_flag =>p_rec.use_overid_svc_dt_flag
285: ,p_effective_date =>p_effective_date
286: ,p_name_o =>ben_lsf_shd.g_old_rec.name
287: ,p_business_group_id_o =>ben_lsf_shd.g_old_rec.business_group_id
288: ,p_los_det_cd_o =>ben_lsf_shd.g_old_rec.los_det_cd
289: ,p_los_det_rl_o =>ben_lsf_shd.g_old_rec.los_det_rl
290: ,p_mn_los_num_o =>ben_lsf_shd.g_old_rec.mn_los_num
283: ,p_object_version_number =>p_rec.object_version_number
284: ,p_use_overid_svc_dt_flag =>p_rec.use_overid_svc_dt_flag
285: ,p_effective_date =>p_effective_date
286: ,p_name_o =>ben_lsf_shd.g_old_rec.name
287: ,p_business_group_id_o =>ben_lsf_shd.g_old_rec.business_group_id
288: ,p_los_det_cd_o =>ben_lsf_shd.g_old_rec.los_det_cd
289: ,p_los_det_rl_o =>ben_lsf_shd.g_old_rec.los_det_rl
290: ,p_mn_los_num_o =>ben_lsf_shd.g_old_rec.mn_los_num
291: ,p_mx_los_num_o =>ben_lsf_shd.g_old_rec.mx_los_num
284: ,p_use_overid_svc_dt_flag =>p_rec.use_overid_svc_dt_flag
285: ,p_effective_date =>p_effective_date
286: ,p_name_o =>ben_lsf_shd.g_old_rec.name
287: ,p_business_group_id_o =>ben_lsf_shd.g_old_rec.business_group_id
288: ,p_los_det_cd_o =>ben_lsf_shd.g_old_rec.los_det_cd
289: ,p_los_det_rl_o =>ben_lsf_shd.g_old_rec.los_det_rl
290: ,p_mn_los_num_o =>ben_lsf_shd.g_old_rec.mn_los_num
291: ,p_mx_los_num_o =>ben_lsf_shd.g_old_rec.mx_los_num
292: ,p_no_mx_los_num_apls_flag_o =>ben_lsf_shd.g_old_rec.no_mx_los_num_apls_flag
285: ,p_effective_date =>p_effective_date
286: ,p_name_o =>ben_lsf_shd.g_old_rec.name
287: ,p_business_group_id_o =>ben_lsf_shd.g_old_rec.business_group_id
288: ,p_los_det_cd_o =>ben_lsf_shd.g_old_rec.los_det_cd
289: ,p_los_det_rl_o =>ben_lsf_shd.g_old_rec.los_det_rl
290: ,p_mn_los_num_o =>ben_lsf_shd.g_old_rec.mn_los_num
291: ,p_mx_los_num_o =>ben_lsf_shd.g_old_rec.mx_los_num
292: ,p_no_mx_los_num_apls_flag_o =>ben_lsf_shd.g_old_rec.no_mx_los_num_apls_flag
293: ,p_no_mn_los_num_apls_flag_o =>ben_lsf_shd.g_old_rec.no_mn_los_num_apls_flag
286: ,p_name_o =>ben_lsf_shd.g_old_rec.name
287: ,p_business_group_id_o =>ben_lsf_shd.g_old_rec.business_group_id
288: ,p_los_det_cd_o =>ben_lsf_shd.g_old_rec.los_det_cd
289: ,p_los_det_rl_o =>ben_lsf_shd.g_old_rec.los_det_rl
290: ,p_mn_los_num_o =>ben_lsf_shd.g_old_rec.mn_los_num
291: ,p_mx_los_num_o =>ben_lsf_shd.g_old_rec.mx_los_num
292: ,p_no_mx_los_num_apls_flag_o =>ben_lsf_shd.g_old_rec.no_mx_los_num_apls_flag
293: ,p_no_mn_los_num_apls_flag_o =>ben_lsf_shd.g_old_rec.no_mn_los_num_apls_flag
294: ,p_rndg_cd_o =>ben_lsf_shd.g_old_rec.rndg_cd
287: ,p_business_group_id_o =>ben_lsf_shd.g_old_rec.business_group_id
288: ,p_los_det_cd_o =>ben_lsf_shd.g_old_rec.los_det_cd
289: ,p_los_det_rl_o =>ben_lsf_shd.g_old_rec.los_det_rl
290: ,p_mn_los_num_o =>ben_lsf_shd.g_old_rec.mn_los_num
291: ,p_mx_los_num_o =>ben_lsf_shd.g_old_rec.mx_los_num
292: ,p_no_mx_los_num_apls_flag_o =>ben_lsf_shd.g_old_rec.no_mx_los_num_apls_flag
293: ,p_no_mn_los_num_apls_flag_o =>ben_lsf_shd.g_old_rec.no_mn_los_num_apls_flag
294: ,p_rndg_cd_o =>ben_lsf_shd.g_old_rec.rndg_cd
295: ,p_rndg_rl_o =>ben_lsf_shd.g_old_rec.rndg_rl
288: ,p_los_det_cd_o =>ben_lsf_shd.g_old_rec.los_det_cd
289: ,p_los_det_rl_o =>ben_lsf_shd.g_old_rec.los_det_rl
290: ,p_mn_los_num_o =>ben_lsf_shd.g_old_rec.mn_los_num
291: ,p_mx_los_num_o =>ben_lsf_shd.g_old_rec.mx_los_num
292: ,p_no_mx_los_num_apls_flag_o =>ben_lsf_shd.g_old_rec.no_mx_los_num_apls_flag
293: ,p_no_mn_los_num_apls_flag_o =>ben_lsf_shd.g_old_rec.no_mn_los_num_apls_flag
294: ,p_rndg_cd_o =>ben_lsf_shd.g_old_rec.rndg_cd
295: ,p_rndg_rl_o =>ben_lsf_shd.g_old_rec.rndg_rl
296: ,p_los_dt_to_use_cd_o =>ben_lsf_shd.g_old_rec.los_dt_to_use_cd
289: ,p_los_det_rl_o =>ben_lsf_shd.g_old_rec.los_det_rl
290: ,p_mn_los_num_o =>ben_lsf_shd.g_old_rec.mn_los_num
291: ,p_mx_los_num_o =>ben_lsf_shd.g_old_rec.mx_los_num
292: ,p_no_mx_los_num_apls_flag_o =>ben_lsf_shd.g_old_rec.no_mx_los_num_apls_flag
293: ,p_no_mn_los_num_apls_flag_o =>ben_lsf_shd.g_old_rec.no_mn_los_num_apls_flag
294: ,p_rndg_cd_o =>ben_lsf_shd.g_old_rec.rndg_cd
295: ,p_rndg_rl_o =>ben_lsf_shd.g_old_rec.rndg_rl
296: ,p_los_dt_to_use_cd_o =>ben_lsf_shd.g_old_rec.los_dt_to_use_cd
297: ,p_los_dt_to_use_rl_o =>ben_lsf_shd.g_old_rec.los_dt_to_use_rl
290: ,p_mn_los_num_o =>ben_lsf_shd.g_old_rec.mn_los_num
291: ,p_mx_los_num_o =>ben_lsf_shd.g_old_rec.mx_los_num
292: ,p_no_mx_los_num_apls_flag_o =>ben_lsf_shd.g_old_rec.no_mx_los_num_apls_flag
293: ,p_no_mn_los_num_apls_flag_o =>ben_lsf_shd.g_old_rec.no_mn_los_num_apls_flag
294: ,p_rndg_cd_o =>ben_lsf_shd.g_old_rec.rndg_cd
295: ,p_rndg_rl_o =>ben_lsf_shd.g_old_rec.rndg_rl
296: ,p_los_dt_to_use_cd_o =>ben_lsf_shd.g_old_rec.los_dt_to_use_cd
297: ,p_los_dt_to_use_rl_o =>ben_lsf_shd.g_old_rec.los_dt_to_use_rl
298: ,p_los_uom_o =>ben_lsf_shd.g_old_rec.los_uom
291: ,p_mx_los_num_o =>ben_lsf_shd.g_old_rec.mx_los_num
292: ,p_no_mx_los_num_apls_flag_o =>ben_lsf_shd.g_old_rec.no_mx_los_num_apls_flag
293: ,p_no_mn_los_num_apls_flag_o =>ben_lsf_shd.g_old_rec.no_mn_los_num_apls_flag
294: ,p_rndg_cd_o =>ben_lsf_shd.g_old_rec.rndg_cd
295: ,p_rndg_rl_o =>ben_lsf_shd.g_old_rec.rndg_rl
296: ,p_los_dt_to_use_cd_o =>ben_lsf_shd.g_old_rec.los_dt_to_use_cd
297: ,p_los_dt_to_use_rl_o =>ben_lsf_shd.g_old_rec.los_dt_to_use_rl
298: ,p_los_uom_o =>ben_lsf_shd.g_old_rec.los_uom
299: ,p_los_calc_rl_o =>ben_lsf_shd.g_old_rec.los_calc_rl
292: ,p_no_mx_los_num_apls_flag_o =>ben_lsf_shd.g_old_rec.no_mx_los_num_apls_flag
293: ,p_no_mn_los_num_apls_flag_o =>ben_lsf_shd.g_old_rec.no_mn_los_num_apls_flag
294: ,p_rndg_cd_o =>ben_lsf_shd.g_old_rec.rndg_cd
295: ,p_rndg_rl_o =>ben_lsf_shd.g_old_rec.rndg_rl
296: ,p_los_dt_to_use_cd_o =>ben_lsf_shd.g_old_rec.los_dt_to_use_cd
297: ,p_los_dt_to_use_rl_o =>ben_lsf_shd.g_old_rec.los_dt_to_use_rl
298: ,p_los_uom_o =>ben_lsf_shd.g_old_rec.los_uom
299: ,p_los_calc_rl_o =>ben_lsf_shd.g_old_rec.los_calc_rl
300: ,p_los_alt_val_to_use_cd_o =>ben_lsf_shd.g_old_rec.los_alt_val_to_use_cd
293: ,p_no_mn_los_num_apls_flag_o =>ben_lsf_shd.g_old_rec.no_mn_los_num_apls_flag
294: ,p_rndg_cd_o =>ben_lsf_shd.g_old_rec.rndg_cd
295: ,p_rndg_rl_o =>ben_lsf_shd.g_old_rec.rndg_rl
296: ,p_los_dt_to_use_cd_o =>ben_lsf_shd.g_old_rec.los_dt_to_use_cd
297: ,p_los_dt_to_use_rl_o =>ben_lsf_shd.g_old_rec.los_dt_to_use_rl
298: ,p_los_uom_o =>ben_lsf_shd.g_old_rec.los_uom
299: ,p_los_calc_rl_o =>ben_lsf_shd.g_old_rec.los_calc_rl
300: ,p_los_alt_val_to_use_cd_o =>ben_lsf_shd.g_old_rec.los_alt_val_to_use_cd
301: ,p_lsf_attribute_category_o =>ben_lsf_shd.g_old_rec.lsf_attribute_category
294: ,p_rndg_cd_o =>ben_lsf_shd.g_old_rec.rndg_cd
295: ,p_rndg_rl_o =>ben_lsf_shd.g_old_rec.rndg_rl
296: ,p_los_dt_to_use_cd_o =>ben_lsf_shd.g_old_rec.los_dt_to_use_cd
297: ,p_los_dt_to_use_rl_o =>ben_lsf_shd.g_old_rec.los_dt_to_use_rl
298: ,p_los_uom_o =>ben_lsf_shd.g_old_rec.los_uom
299: ,p_los_calc_rl_o =>ben_lsf_shd.g_old_rec.los_calc_rl
300: ,p_los_alt_val_to_use_cd_o =>ben_lsf_shd.g_old_rec.los_alt_val_to_use_cd
301: ,p_lsf_attribute_category_o =>ben_lsf_shd.g_old_rec.lsf_attribute_category
302: ,p_lsf_attribute1_o =>ben_lsf_shd.g_old_rec.lsf_attribute1
295: ,p_rndg_rl_o =>ben_lsf_shd.g_old_rec.rndg_rl
296: ,p_los_dt_to_use_cd_o =>ben_lsf_shd.g_old_rec.los_dt_to_use_cd
297: ,p_los_dt_to_use_rl_o =>ben_lsf_shd.g_old_rec.los_dt_to_use_rl
298: ,p_los_uom_o =>ben_lsf_shd.g_old_rec.los_uom
299: ,p_los_calc_rl_o =>ben_lsf_shd.g_old_rec.los_calc_rl
300: ,p_los_alt_val_to_use_cd_o =>ben_lsf_shd.g_old_rec.los_alt_val_to_use_cd
301: ,p_lsf_attribute_category_o =>ben_lsf_shd.g_old_rec.lsf_attribute_category
302: ,p_lsf_attribute1_o =>ben_lsf_shd.g_old_rec.lsf_attribute1
303: ,p_lsf_attribute2_o =>ben_lsf_shd.g_old_rec.lsf_attribute2
296: ,p_los_dt_to_use_cd_o =>ben_lsf_shd.g_old_rec.los_dt_to_use_cd
297: ,p_los_dt_to_use_rl_o =>ben_lsf_shd.g_old_rec.los_dt_to_use_rl
298: ,p_los_uom_o =>ben_lsf_shd.g_old_rec.los_uom
299: ,p_los_calc_rl_o =>ben_lsf_shd.g_old_rec.los_calc_rl
300: ,p_los_alt_val_to_use_cd_o =>ben_lsf_shd.g_old_rec.los_alt_val_to_use_cd
301: ,p_lsf_attribute_category_o =>ben_lsf_shd.g_old_rec.lsf_attribute_category
302: ,p_lsf_attribute1_o =>ben_lsf_shd.g_old_rec.lsf_attribute1
303: ,p_lsf_attribute2_o =>ben_lsf_shd.g_old_rec.lsf_attribute2
304: ,p_lsf_attribute3_o =>ben_lsf_shd.g_old_rec.lsf_attribute3
297: ,p_los_dt_to_use_rl_o =>ben_lsf_shd.g_old_rec.los_dt_to_use_rl
298: ,p_los_uom_o =>ben_lsf_shd.g_old_rec.los_uom
299: ,p_los_calc_rl_o =>ben_lsf_shd.g_old_rec.los_calc_rl
300: ,p_los_alt_val_to_use_cd_o =>ben_lsf_shd.g_old_rec.los_alt_val_to_use_cd
301: ,p_lsf_attribute_category_o =>ben_lsf_shd.g_old_rec.lsf_attribute_category
302: ,p_lsf_attribute1_o =>ben_lsf_shd.g_old_rec.lsf_attribute1
303: ,p_lsf_attribute2_o =>ben_lsf_shd.g_old_rec.lsf_attribute2
304: ,p_lsf_attribute3_o =>ben_lsf_shd.g_old_rec.lsf_attribute3
305: ,p_lsf_attribute4_o =>ben_lsf_shd.g_old_rec.lsf_attribute4
298: ,p_los_uom_o =>ben_lsf_shd.g_old_rec.los_uom
299: ,p_los_calc_rl_o =>ben_lsf_shd.g_old_rec.los_calc_rl
300: ,p_los_alt_val_to_use_cd_o =>ben_lsf_shd.g_old_rec.los_alt_val_to_use_cd
301: ,p_lsf_attribute_category_o =>ben_lsf_shd.g_old_rec.lsf_attribute_category
302: ,p_lsf_attribute1_o =>ben_lsf_shd.g_old_rec.lsf_attribute1
303: ,p_lsf_attribute2_o =>ben_lsf_shd.g_old_rec.lsf_attribute2
304: ,p_lsf_attribute3_o =>ben_lsf_shd.g_old_rec.lsf_attribute3
305: ,p_lsf_attribute4_o =>ben_lsf_shd.g_old_rec.lsf_attribute4
306: ,p_lsf_attribute5_o =>ben_lsf_shd.g_old_rec.lsf_attribute5
299: ,p_los_calc_rl_o =>ben_lsf_shd.g_old_rec.los_calc_rl
300: ,p_los_alt_val_to_use_cd_o =>ben_lsf_shd.g_old_rec.los_alt_val_to_use_cd
301: ,p_lsf_attribute_category_o =>ben_lsf_shd.g_old_rec.lsf_attribute_category
302: ,p_lsf_attribute1_o =>ben_lsf_shd.g_old_rec.lsf_attribute1
303: ,p_lsf_attribute2_o =>ben_lsf_shd.g_old_rec.lsf_attribute2
304: ,p_lsf_attribute3_o =>ben_lsf_shd.g_old_rec.lsf_attribute3
305: ,p_lsf_attribute4_o =>ben_lsf_shd.g_old_rec.lsf_attribute4
306: ,p_lsf_attribute5_o =>ben_lsf_shd.g_old_rec.lsf_attribute5
307: ,p_lsf_attribute6_o =>ben_lsf_shd.g_old_rec.lsf_attribute6
300: ,p_los_alt_val_to_use_cd_o =>ben_lsf_shd.g_old_rec.los_alt_val_to_use_cd
301: ,p_lsf_attribute_category_o =>ben_lsf_shd.g_old_rec.lsf_attribute_category
302: ,p_lsf_attribute1_o =>ben_lsf_shd.g_old_rec.lsf_attribute1
303: ,p_lsf_attribute2_o =>ben_lsf_shd.g_old_rec.lsf_attribute2
304: ,p_lsf_attribute3_o =>ben_lsf_shd.g_old_rec.lsf_attribute3
305: ,p_lsf_attribute4_o =>ben_lsf_shd.g_old_rec.lsf_attribute4
306: ,p_lsf_attribute5_o =>ben_lsf_shd.g_old_rec.lsf_attribute5
307: ,p_lsf_attribute6_o =>ben_lsf_shd.g_old_rec.lsf_attribute6
308: ,p_lsf_attribute7_o =>ben_lsf_shd.g_old_rec.lsf_attribute7
301: ,p_lsf_attribute_category_o =>ben_lsf_shd.g_old_rec.lsf_attribute_category
302: ,p_lsf_attribute1_o =>ben_lsf_shd.g_old_rec.lsf_attribute1
303: ,p_lsf_attribute2_o =>ben_lsf_shd.g_old_rec.lsf_attribute2
304: ,p_lsf_attribute3_o =>ben_lsf_shd.g_old_rec.lsf_attribute3
305: ,p_lsf_attribute4_o =>ben_lsf_shd.g_old_rec.lsf_attribute4
306: ,p_lsf_attribute5_o =>ben_lsf_shd.g_old_rec.lsf_attribute5
307: ,p_lsf_attribute6_o =>ben_lsf_shd.g_old_rec.lsf_attribute6
308: ,p_lsf_attribute7_o =>ben_lsf_shd.g_old_rec.lsf_attribute7
309: ,p_lsf_attribute8_o =>ben_lsf_shd.g_old_rec.lsf_attribute8
302: ,p_lsf_attribute1_o =>ben_lsf_shd.g_old_rec.lsf_attribute1
303: ,p_lsf_attribute2_o =>ben_lsf_shd.g_old_rec.lsf_attribute2
304: ,p_lsf_attribute3_o =>ben_lsf_shd.g_old_rec.lsf_attribute3
305: ,p_lsf_attribute4_o =>ben_lsf_shd.g_old_rec.lsf_attribute4
306: ,p_lsf_attribute5_o =>ben_lsf_shd.g_old_rec.lsf_attribute5
307: ,p_lsf_attribute6_o =>ben_lsf_shd.g_old_rec.lsf_attribute6
308: ,p_lsf_attribute7_o =>ben_lsf_shd.g_old_rec.lsf_attribute7
309: ,p_lsf_attribute8_o =>ben_lsf_shd.g_old_rec.lsf_attribute8
310: ,p_lsf_attribute9_o =>ben_lsf_shd.g_old_rec.lsf_attribute9
303: ,p_lsf_attribute2_o =>ben_lsf_shd.g_old_rec.lsf_attribute2
304: ,p_lsf_attribute3_o =>ben_lsf_shd.g_old_rec.lsf_attribute3
305: ,p_lsf_attribute4_o =>ben_lsf_shd.g_old_rec.lsf_attribute4
306: ,p_lsf_attribute5_o =>ben_lsf_shd.g_old_rec.lsf_attribute5
307: ,p_lsf_attribute6_o =>ben_lsf_shd.g_old_rec.lsf_attribute6
308: ,p_lsf_attribute7_o =>ben_lsf_shd.g_old_rec.lsf_attribute7
309: ,p_lsf_attribute8_o =>ben_lsf_shd.g_old_rec.lsf_attribute8
310: ,p_lsf_attribute9_o =>ben_lsf_shd.g_old_rec.lsf_attribute9
311: ,p_lsf_attribute10_o =>ben_lsf_shd.g_old_rec.lsf_attribute10
304: ,p_lsf_attribute3_o =>ben_lsf_shd.g_old_rec.lsf_attribute3
305: ,p_lsf_attribute4_o =>ben_lsf_shd.g_old_rec.lsf_attribute4
306: ,p_lsf_attribute5_o =>ben_lsf_shd.g_old_rec.lsf_attribute5
307: ,p_lsf_attribute6_o =>ben_lsf_shd.g_old_rec.lsf_attribute6
308: ,p_lsf_attribute7_o =>ben_lsf_shd.g_old_rec.lsf_attribute7
309: ,p_lsf_attribute8_o =>ben_lsf_shd.g_old_rec.lsf_attribute8
310: ,p_lsf_attribute9_o =>ben_lsf_shd.g_old_rec.lsf_attribute9
311: ,p_lsf_attribute10_o =>ben_lsf_shd.g_old_rec.lsf_attribute10
312: ,p_lsf_attribute11_o =>ben_lsf_shd.g_old_rec.lsf_attribute11
305: ,p_lsf_attribute4_o =>ben_lsf_shd.g_old_rec.lsf_attribute4
306: ,p_lsf_attribute5_o =>ben_lsf_shd.g_old_rec.lsf_attribute5
307: ,p_lsf_attribute6_o =>ben_lsf_shd.g_old_rec.lsf_attribute6
308: ,p_lsf_attribute7_o =>ben_lsf_shd.g_old_rec.lsf_attribute7
309: ,p_lsf_attribute8_o =>ben_lsf_shd.g_old_rec.lsf_attribute8
310: ,p_lsf_attribute9_o =>ben_lsf_shd.g_old_rec.lsf_attribute9
311: ,p_lsf_attribute10_o =>ben_lsf_shd.g_old_rec.lsf_attribute10
312: ,p_lsf_attribute11_o =>ben_lsf_shd.g_old_rec.lsf_attribute11
313: ,p_lsf_attribute12_o =>ben_lsf_shd.g_old_rec.lsf_attribute12
306: ,p_lsf_attribute5_o =>ben_lsf_shd.g_old_rec.lsf_attribute5
307: ,p_lsf_attribute6_o =>ben_lsf_shd.g_old_rec.lsf_attribute6
308: ,p_lsf_attribute7_o =>ben_lsf_shd.g_old_rec.lsf_attribute7
309: ,p_lsf_attribute8_o =>ben_lsf_shd.g_old_rec.lsf_attribute8
310: ,p_lsf_attribute9_o =>ben_lsf_shd.g_old_rec.lsf_attribute9
311: ,p_lsf_attribute10_o =>ben_lsf_shd.g_old_rec.lsf_attribute10
312: ,p_lsf_attribute11_o =>ben_lsf_shd.g_old_rec.lsf_attribute11
313: ,p_lsf_attribute12_o =>ben_lsf_shd.g_old_rec.lsf_attribute12
314: ,p_lsf_attribute13_o =>ben_lsf_shd.g_old_rec.lsf_attribute13
307: ,p_lsf_attribute6_o =>ben_lsf_shd.g_old_rec.lsf_attribute6
308: ,p_lsf_attribute7_o =>ben_lsf_shd.g_old_rec.lsf_attribute7
309: ,p_lsf_attribute8_o =>ben_lsf_shd.g_old_rec.lsf_attribute8
310: ,p_lsf_attribute9_o =>ben_lsf_shd.g_old_rec.lsf_attribute9
311: ,p_lsf_attribute10_o =>ben_lsf_shd.g_old_rec.lsf_attribute10
312: ,p_lsf_attribute11_o =>ben_lsf_shd.g_old_rec.lsf_attribute11
313: ,p_lsf_attribute12_o =>ben_lsf_shd.g_old_rec.lsf_attribute12
314: ,p_lsf_attribute13_o =>ben_lsf_shd.g_old_rec.lsf_attribute13
315: ,p_lsf_attribute14_o =>ben_lsf_shd.g_old_rec.lsf_attribute14
308: ,p_lsf_attribute7_o =>ben_lsf_shd.g_old_rec.lsf_attribute7
309: ,p_lsf_attribute8_o =>ben_lsf_shd.g_old_rec.lsf_attribute8
310: ,p_lsf_attribute9_o =>ben_lsf_shd.g_old_rec.lsf_attribute9
311: ,p_lsf_attribute10_o =>ben_lsf_shd.g_old_rec.lsf_attribute10
312: ,p_lsf_attribute11_o =>ben_lsf_shd.g_old_rec.lsf_attribute11
313: ,p_lsf_attribute12_o =>ben_lsf_shd.g_old_rec.lsf_attribute12
314: ,p_lsf_attribute13_o =>ben_lsf_shd.g_old_rec.lsf_attribute13
315: ,p_lsf_attribute14_o =>ben_lsf_shd.g_old_rec.lsf_attribute14
316: ,p_lsf_attribute15_o =>ben_lsf_shd.g_old_rec.lsf_attribute15
309: ,p_lsf_attribute8_o =>ben_lsf_shd.g_old_rec.lsf_attribute8
310: ,p_lsf_attribute9_o =>ben_lsf_shd.g_old_rec.lsf_attribute9
311: ,p_lsf_attribute10_o =>ben_lsf_shd.g_old_rec.lsf_attribute10
312: ,p_lsf_attribute11_o =>ben_lsf_shd.g_old_rec.lsf_attribute11
313: ,p_lsf_attribute12_o =>ben_lsf_shd.g_old_rec.lsf_attribute12
314: ,p_lsf_attribute13_o =>ben_lsf_shd.g_old_rec.lsf_attribute13
315: ,p_lsf_attribute14_o =>ben_lsf_shd.g_old_rec.lsf_attribute14
316: ,p_lsf_attribute15_o =>ben_lsf_shd.g_old_rec.lsf_attribute15
317: ,p_lsf_attribute16_o =>ben_lsf_shd.g_old_rec.lsf_attribute16
310: ,p_lsf_attribute9_o =>ben_lsf_shd.g_old_rec.lsf_attribute9
311: ,p_lsf_attribute10_o =>ben_lsf_shd.g_old_rec.lsf_attribute10
312: ,p_lsf_attribute11_o =>ben_lsf_shd.g_old_rec.lsf_attribute11
313: ,p_lsf_attribute12_o =>ben_lsf_shd.g_old_rec.lsf_attribute12
314: ,p_lsf_attribute13_o =>ben_lsf_shd.g_old_rec.lsf_attribute13
315: ,p_lsf_attribute14_o =>ben_lsf_shd.g_old_rec.lsf_attribute14
316: ,p_lsf_attribute15_o =>ben_lsf_shd.g_old_rec.lsf_attribute15
317: ,p_lsf_attribute16_o =>ben_lsf_shd.g_old_rec.lsf_attribute16
318: ,p_lsf_attribute17_o =>ben_lsf_shd.g_old_rec.lsf_attribute17
311: ,p_lsf_attribute10_o =>ben_lsf_shd.g_old_rec.lsf_attribute10
312: ,p_lsf_attribute11_o =>ben_lsf_shd.g_old_rec.lsf_attribute11
313: ,p_lsf_attribute12_o =>ben_lsf_shd.g_old_rec.lsf_attribute12
314: ,p_lsf_attribute13_o =>ben_lsf_shd.g_old_rec.lsf_attribute13
315: ,p_lsf_attribute14_o =>ben_lsf_shd.g_old_rec.lsf_attribute14
316: ,p_lsf_attribute15_o =>ben_lsf_shd.g_old_rec.lsf_attribute15
317: ,p_lsf_attribute16_o =>ben_lsf_shd.g_old_rec.lsf_attribute16
318: ,p_lsf_attribute17_o =>ben_lsf_shd.g_old_rec.lsf_attribute17
319: ,p_lsf_attribute18_o =>ben_lsf_shd.g_old_rec.lsf_attribute18
312: ,p_lsf_attribute11_o =>ben_lsf_shd.g_old_rec.lsf_attribute11
313: ,p_lsf_attribute12_o =>ben_lsf_shd.g_old_rec.lsf_attribute12
314: ,p_lsf_attribute13_o =>ben_lsf_shd.g_old_rec.lsf_attribute13
315: ,p_lsf_attribute14_o =>ben_lsf_shd.g_old_rec.lsf_attribute14
316: ,p_lsf_attribute15_o =>ben_lsf_shd.g_old_rec.lsf_attribute15
317: ,p_lsf_attribute16_o =>ben_lsf_shd.g_old_rec.lsf_attribute16
318: ,p_lsf_attribute17_o =>ben_lsf_shd.g_old_rec.lsf_attribute17
319: ,p_lsf_attribute18_o =>ben_lsf_shd.g_old_rec.lsf_attribute18
320: ,p_lsf_attribute19_o =>ben_lsf_shd.g_old_rec.lsf_attribute19
313: ,p_lsf_attribute12_o =>ben_lsf_shd.g_old_rec.lsf_attribute12
314: ,p_lsf_attribute13_o =>ben_lsf_shd.g_old_rec.lsf_attribute13
315: ,p_lsf_attribute14_o =>ben_lsf_shd.g_old_rec.lsf_attribute14
316: ,p_lsf_attribute15_o =>ben_lsf_shd.g_old_rec.lsf_attribute15
317: ,p_lsf_attribute16_o =>ben_lsf_shd.g_old_rec.lsf_attribute16
318: ,p_lsf_attribute17_o =>ben_lsf_shd.g_old_rec.lsf_attribute17
319: ,p_lsf_attribute18_o =>ben_lsf_shd.g_old_rec.lsf_attribute18
320: ,p_lsf_attribute19_o =>ben_lsf_shd.g_old_rec.lsf_attribute19
321: ,p_lsf_attribute20_o =>ben_lsf_shd.g_old_rec.lsf_attribute20
314: ,p_lsf_attribute13_o =>ben_lsf_shd.g_old_rec.lsf_attribute13
315: ,p_lsf_attribute14_o =>ben_lsf_shd.g_old_rec.lsf_attribute14
316: ,p_lsf_attribute15_o =>ben_lsf_shd.g_old_rec.lsf_attribute15
317: ,p_lsf_attribute16_o =>ben_lsf_shd.g_old_rec.lsf_attribute16
318: ,p_lsf_attribute17_o =>ben_lsf_shd.g_old_rec.lsf_attribute17
319: ,p_lsf_attribute18_o =>ben_lsf_shd.g_old_rec.lsf_attribute18
320: ,p_lsf_attribute19_o =>ben_lsf_shd.g_old_rec.lsf_attribute19
321: ,p_lsf_attribute20_o =>ben_lsf_shd.g_old_rec.lsf_attribute20
322: ,p_lsf_attribute21_o =>ben_lsf_shd.g_old_rec.lsf_attribute21
315: ,p_lsf_attribute14_o =>ben_lsf_shd.g_old_rec.lsf_attribute14
316: ,p_lsf_attribute15_o =>ben_lsf_shd.g_old_rec.lsf_attribute15
317: ,p_lsf_attribute16_o =>ben_lsf_shd.g_old_rec.lsf_attribute16
318: ,p_lsf_attribute17_o =>ben_lsf_shd.g_old_rec.lsf_attribute17
319: ,p_lsf_attribute18_o =>ben_lsf_shd.g_old_rec.lsf_attribute18
320: ,p_lsf_attribute19_o =>ben_lsf_shd.g_old_rec.lsf_attribute19
321: ,p_lsf_attribute20_o =>ben_lsf_shd.g_old_rec.lsf_attribute20
322: ,p_lsf_attribute21_o =>ben_lsf_shd.g_old_rec.lsf_attribute21
323: ,p_lsf_attribute22_o =>ben_lsf_shd.g_old_rec.lsf_attribute22
316: ,p_lsf_attribute15_o =>ben_lsf_shd.g_old_rec.lsf_attribute15
317: ,p_lsf_attribute16_o =>ben_lsf_shd.g_old_rec.lsf_attribute16
318: ,p_lsf_attribute17_o =>ben_lsf_shd.g_old_rec.lsf_attribute17
319: ,p_lsf_attribute18_o =>ben_lsf_shd.g_old_rec.lsf_attribute18
320: ,p_lsf_attribute19_o =>ben_lsf_shd.g_old_rec.lsf_attribute19
321: ,p_lsf_attribute20_o =>ben_lsf_shd.g_old_rec.lsf_attribute20
322: ,p_lsf_attribute21_o =>ben_lsf_shd.g_old_rec.lsf_attribute21
323: ,p_lsf_attribute22_o =>ben_lsf_shd.g_old_rec.lsf_attribute22
324: ,p_lsf_attribute23_o =>ben_lsf_shd.g_old_rec.lsf_attribute23
317: ,p_lsf_attribute16_o =>ben_lsf_shd.g_old_rec.lsf_attribute16
318: ,p_lsf_attribute17_o =>ben_lsf_shd.g_old_rec.lsf_attribute17
319: ,p_lsf_attribute18_o =>ben_lsf_shd.g_old_rec.lsf_attribute18
320: ,p_lsf_attribute19_o =>ben_lsf_shd.g_old_rec.lsf_attribute19
321: ,p_lsf_attribute20_o =>ben_lsf_shd.g_old_rec.lsf_attribute20
322: ,p_lsf_attribute21_o =>ben_lsf_shd.g_old_rec.lsf_attribute21
323: ,p_lsf_attribute22_o =>ben_lsf_shd.g_old_rec.lsf_attribute22
324: ,p_lsf_attribute23_o =>ben_lsf_shd.g_old_rec.lsf_attribute23
325: ,p_lsf_attribute24_o =>ben_lsf_shd.g_old_rec.lsf_attribute24
318: ,p_lsf_attribute17_o =>ben_lsf_shd.g_old_rec.lsf_attribute17
319: ,p_lsf_attribute18_o =>ben_lsf_shd.g_old_rec.lsf_attribute18
320: ,p_lsf_attribute19_o =>ben_lsf_shd.g_old_rec.lsf_attribute19
321: ,p_lsf_attribute20_o =>ben_lsf_shd.g_old_rec.lsf_attribute20
322: ,p_lsf_attribute21_o =>ben_lsf_shd.g_old_rec.lsf_attribute21
323: ,p_lsf_attribute22_o =>ben_lsf_shd.g_old_rec.lsf_attribute22
324: ,p_lsf_attribute23_o =>ben_lsf_shd.g_old_rec.lsf_attribute23
325: ,p_lsf_attribute24_o =>ben_lsf_shd.g_old_rec.lsf_attribute24
326: ,p_lsf_attribute25_o =>ben_lsf_shd.g_old_rec.lsf_attribute25
319: ,p_lsf_attribute18_o =>ben_lsf_shd.g_old_rec.lsf_attribute18
320: ,p_lsf_attribute19_o =>ben_lsf_shd.g_old_rec.lsf_attribute19
321: ,p_lsf_attribute20_o =>ben_lsf_shd.g_old_rec.lsf_attribute20
322: ,p_lsf_attribute21_o =>ben_lsf_shd.g_old_rec.lsf_attribute21
323: ,p_lsf_attribute22_o =>ben_lsf_shd.g_old_rec.lsf_attribute22
324: ,p_lsf_attribute23_o =>ben_lsf_shd.g_old_rec.lsf_attribute23
325: ,p_lsf_attribute24_o =>ben_lsf_shd.g_old_rec.lsf_attribute24
326: ,p_lsf_attribute25_o =>ben_lsf_shd.g_old_rec.lsf_attribute25
327: ,p_lsf_attribute26_o =>ben_lsf_shd.g_old_rec.lsf_attribute26
320: ,p_lsf_attribute19_o =>ben_lsf_shd.g_old_rec.lsf_attribute19
321: ,p_lsf_attribute20_o =>ben_lsf_shd.g_old_rec.lsf_attribute20
322: ,p_lsf_attribute21_o =>ben_lsf_shd.g_old_rec.lsf_attribute21
323: ,p_lsf_attribute22_o =>ben_lsf_shd.g_old_rec.lsf_attribute22
324: ,p_lsf_attribute23_o =>ben_lsf_shd.g_old_rec.lsf_attribute23
325: ,p_lsf_attribute24_o =>ben_lsf_shd.g_old_rec.lsf_attribute24
326: ,p_lsf_attribute25_o =>ben_lsf_shd.g_old_rec.lsf_attribute25
327: ,p_lsf_attribute26_o =>ben_lsf_shd.g_old_rec.lsf_attribute26
328: ,p_lsf_attribute27_o =>ben_lsf_shd.g_old_rec.lsf_attribute27
321: ,p_lsf_attribute20_o =>ben_lsf_shd.g_old_rec.lsf_attribute20
322: ,p_lsf_attribute21_o =>ben_lsf_shd.g_old_rec.lsf_attribute21
323: ,p_lsf_attribute22_o =>ben_lsf_shd.g_old_rec.lsf_attribute22
324: ,p_lsf_attribute23_o =>ben_lsf_shd.g_old_rec.lsf_attribute23
325: ,p_lsf_attribute24_o =>ben_lsf_shd.g_old_rec.lsf_attribute24
326: ,p_lsf_attribute25_o =>ben_lsf_shd.g_old_rec.lsf_attribute25
327: ,p_lsf_attribute26_o =>ben_lsf_shd.g_old_rec.lsf_attribute26
328: ,p_lsf_attribute27_o =>ben_lsf_shd.g_old_rec.lsf_attribute27
329: ,p_lsf_attribute28_o =>ben_lsf_shd.g_old_rec.lsf_attribute28
322: ,p_lsf_attribute21_o =>ben_lsf_shd.g_old_rec.lsf_attribute21
323: ,p_lsf_attribute22_o =>ben_lsf_shd.g_old_rec.lsf_attribute22
324: ,p_lsf_attribute23_o =>ben_lsf_shd.g_old_rec.lsf_attribute23
325: ,p_lsf_attribute24_o =>ben_lsf_shd.g_old_rec.lsf_attribute24
326: ,p_lsf_attribute25_o =>ben_lsf_shd.g_old_rec.lsf_attribute25
327: ,p_lsf_attribute26_o =>ben_lsf_shd.g_old_rec.lsf_attribute26
328: ,p_lsf_attribute27_o =>ben_lsf_shd.g_old_rec.lsf_attribute27
329: ,p_lsf_attribute28_o =>ben_lsf_shd.g_old_rec.lsf_attribute28
330: ,p_lsf_attribute29_o =>ben_lsf_shd.g_old_rec.lsf_attribute29
323: ,p_lsf_attribute22_o =>ben_lsf_shd.g_old_rec.lsf_attribute22
324: ,p_lsf_attribute23_o =>ben_lsf_shd.g_old_rec.lsf_attribute23
325: ,p_lsf_attribute24_o =>ben_lsf_shd.g_old_rec.lsf_attribute24
326: ,p_lsf_attribute25_o =>ben_lsf_shd.g_old_rec.lsf_attribute25
327: ,p_lsf_attribute26_o =>ben_lsf_shd.g_old_rec.lsf_attribute26
328: ,p_lsf_attribute27_o =>ben_lsf_shd.g_old_rec.lsf_attribute27
329: ,p_lsf_attribute28_o =>ben_lsf_shd.g_old_rec.lsf_attribute28
330: ,p_lsf_attribute29_o =>ben_lsf_shd.g_old_rec.lsf_attribute29
331: ,p_lsf_attribute30_o =>ben_lsf_shd.g_old_rec.lsf_attribute30
324: ,p_lsf_attribute23_o =>ben_lsf_shd.g_old_rec.lsf_attribute23
325: ,p_lsf_attribute24_o =>ben_lsf_shd.g_old_rec.lsf_attribute24
326: ,p_lsf_attribute25_o =>ben_lsf_shd.g_old_rec.lsf_attribute25
327: ,p_lsf_attribute26_o =>ben_lsf_shd.g_old_rec.lsf_attribute26
328: ,p_lsf_attribute27_o =>ben_lsf_shd.g_old_rec.lsf_attribute27
329: ,p_lsf_attribute28_o =>ben_lsf_shd.g_old_rec.lsf_attribute28
330: ,p_lsf_attribute29_o =>ben_lsf_shd.g_old_rec.lsf_attribute29
331: ,p_lsf_attribute30_o =>ben_lsf_shd.g_old_rec.lsf_attribute30
332: ,p_object_version_number_o =>ben_lsf_shd.g_old_rec.object_version_number
325: ,p_lsf_attribute24_o =>ben_lsf_shd.g_old_rec.lsf_attribute24
326: ,p_lsf_attribute25_o =>ben_lsf_shd.g_old_rec.lsf_attribute25
327: ,p_lsf_attribute26_o =>ben_lsf_shd.g_old_rec.lsf_attribute26
328: ,p_lsf_attribute27_o =>ben_lsf_shd.g_old_rec.lsf_attribute27
329: ,p_lsf_attribute28_o =>ben_lsf_shd.g_old_rec.lsf_attribute28
330: ,p_lsf_attribute29_o =>ben_lsf_shd.g_old_rec.lsf_attribute29
331: ,p_lsf_attribute30_o =>ben_lsf_shd.g_old_rec.lsf_attribute30
332: ,p_object_version_number_o =>ben_lsf_shd.g_old_rec.object_version_number
333: ,p_use_overid_svc_dt_flag_o =>ben_lsf_shd.g_old_rec.use_overid_svc_dt_flag
326: ,p_lsf_attribute25_o =>ben_lsf_shd.g_old_rec.lsf_attribute25
327: ,p_lsf_attribute26_o =>ben_lsf_shd.g_old_rec.lsf_attribute26
328: ,p_lsf_attribute27_o =>ben_lsf_shd.g_old_rec.lsf_attribute27
329: ,p_lsf_attribute28_o =>ben_lsf_shd.g_old_rec.lsf_attribute28
330: ,p_lsf_attribute29_o =>ben_lsf_shd.g_old_rec.lsf_attribute29
331: ,p_lsf_attribute30_o =>ben_lsf_shd.g_old_rec.lsf_attribute30
332: ,p_object_version_number_o =>ben_lsf_shd.g_old_rec.object_version_number
333: ,p_use_overid_svc_dt_flag_o =>ben_lsf_shd.g_old_rec.use_overid_svc_dt_flag
334: );
327: ,p_lsf_attribute26_o =>ben_lsf_shd.g_old_rec.lsf_attribute26
328: ,p_lsf_attribute27_o =>ben_lsf_shd.g_old_rec.lsf_attribute27
329: ,p_lsf_attribute28_o =>ben_lsf_shd.g_old_rec.lsf_attribute28
330: ,p_lsf_attribute29_o =>ben_lsf_shd.g_old_rec.lsf_attribute29
331: ,p_lsf_attribute30_o =>ben_lsf_shd.g_old_rec.lsf_attribute30
332: ,p_object_version_number_o =>ben_lsf_shd.g_old_rec.object_version_number
333: ,p_use_overid_svc_dt_flag_o =>ben_lsf_shd.g_old_rec.use_overid_svc_dt_flag
334: );
335: --
328: ,p_lsf_attribute27_o =>ben_lsf_shd.g_old_rec.lsf_attribute27
329: ,p_lsf_attribute28_o =>ben_lsf_shd.g_old_rec.lsf_attribute28
330: ,p_lsf_attribute29_o =>ben_lsf_shd.g_old_rec.lsf_attribute29
331: ,p_lsf_attribute30_o =>ben_lsf_shd.g_old_rec.lsf_attribute30
332: ,p_object_version_number_o =>ben_lsf_shd.g_old_rec.object_version_number
333: ,p_use_overid_svc_dt_flag_o =>ben_lsf_shd.g_old_rec.use_overid_svc_dt_flag
334: );
335: --
336: exception
329: ,p_lsf_attribute28_o =>ben_lsf_shd.g_old_rec.lsf_attribute28
330: ,p_lsf_attribute29_o =>ben_lsf_shd.g_old_rec.lsf_attribute29
331: ,p_lsf_attribute30_o =>ben_lsf_shd.g_old_rec.lsf_attribute30
332: ,p_object_version_number_o =>ben_lsf_shd.g_old_rec.object_version_number
333: ,p_use_overid_svc_dt_flag_o =>ben_lsf_shd.g_old_rec.use_overid_svc_dt_flag
334: );
335: --
336: exception
337: --
391: -- Internal Row Handler Use Only.
392: --
393: -- {End Of Comments}
394: -- ----------------------------------------------------------------------------
395: Procedure convert_defs(p_rec in out nocopy ben_lsf_shd.g_rec_type) is
396: --
397: l_proc varchar2(72) := g_package||'convert_defs';
398: --
399: Begin
406: -- is being used then we must set to the 'current' argument value.
407: --
408: If (p_rec.name = hr_api.g_varchar2) then
409: p_rec.name :=
410: ben_lsf_shd.g_old_rec.name;
411: End If;
412: If (p_rec.business_group_id = hr_api.g_number) then
413: p_rec.business_group_id :=
414: ben_lsf_shd.g_old_rec.business_group_id;
410: ben_lsf_shd.g_old_rec.name;
411: End If;
412: If (p_rec.business_group_id = hr_api.g_number) then
413: p_rec.business_group_id :=
414: ben_lsf_shd.g_old_rec.business_group_id;
415: End If;
416: If (p_rec.los_det_cd = hr_api.g_varchar2) then
417: p_rec.los_det_cd :=
418: ben_lsf_shd.g_old_rec.los_det_cd;
414: ben_lsf_shd.g_old_rec.business_group_id;
415: End If;
416: If (p_rec.los_det_cd = hr_api.g_varchar2) then
417: p_rec.los_det_cd :=
418: ben_lsf_shd.g_old_rec.los_det_cd;
419: End If;
420: If (p_rec.los_det_rl = hr_api.g_number) then
421: p_rec.los_det_rl :=
422: ben_lsf_shd.g_old_rec.los_det_rl;
418: ben_lsf_shd.g_old_rec.los_det_cd;
419: End If;
420: If (p_rec.los_det_rl = hr_api.g_number) then
421: p_rec.los_det_rl :=
422: ben_lsf_shd.g_old_rec.los_det_rl;
423: End If;
424: If (p_rec.mn_los_num = hr_api.g_number) then
425: p_rec.mn_los_num :=
426: ben_lsf_shd.g_old_rec.mn_los_num;
422: ben_lsf_shd.g_old_rec.los_det_rl;
423: End If;
424: If (p_rec.mn_los_num = hr_api.g_number) then
425: p_rec.mn_los_num :=
426: ben_lsf_shd.g_old_rec.mn_los_num;
427: End If;
428: If (p_rec.mx_los_num = hr_api.g_number) then
429: p_rec.mx_los_num :=
430: ben_lsf_shd.g_old_rec.mx_los_num;
426: ben_lsf_shd.g_old_rec.mn_los_num;
427: End If;
428: If (p_rec.mx_los_num = hr_api.g_number) then
429: p_rec.mx_los_num :=
430: ben_lsf_shd.g_old_rec.mx_los_num;
431: End If;
432: If (p_rec.no_mx_los_num_apls_flag = hr_api.g_varchar2) then
433: p_rec.no_mx_los_num_apls_flag :=
434: ben_lsf_shd.g_old_rec.no_mx_los_num_apls_flag;
430: ben_lsf_shd.g_old_rec.mx_los_num;
431: End If;
432: If (p_rec.no_mx_los_num_apls_flag = hr_api.g_varchar2) then
433: p_rec.no_mx_los_num_apls_flag :=
434: ben_lsf_shd.g_old_rec.no_mx_los_num_apls_flag;
435: End If;
436: If (p_rec.no_mn_los_num_apls_flag = hr_api.g_varchar2) then
437: p_rec.no_mn_los_num_apls_flag :=
438: ben_lsf_shd.g_old_rec.no_mn_los_num_apls_flag;
434: ben_lsf_shd.g_old_rec.no_mx_los_num_apls_flag;
435: End If;
436: If (p_rec.no_mn_los_num_apls_flag = hr_api.g_varchar2) then
437: p_rec.no_mn_los_num_apls_flag :=
438: ben_lsf_shd.g_old_rec.no_mn_los_num_apls_flag;
439: End If;
440: If (p_rec.rndg_cd = hr_api.g_varchar2) then
441: p_rec.rndg_cd :=
442: ben_lsf_shd.g_old_rec.rndg_cd;
438: ben_lsf_shd.g_old_rec.no_mn_los_num_apls_flag;
439: End If;
440: If (p_rec.rndg_cd = hr_api.g_varchar2) then
441: p_rec.rndg_cd :=
442: ben_lsf_shd.g_old_rec.rndg_cd;
443: End If;
444: If (p_rec.rndg_rl = hr_api.g_number) then
445: p_rec.rndg_rl :=
446: ben_lsf_shd.g_old_rec.rndg_rl;
442: ben_lsf_shd.g_old_rec.rndg_cd;
443: End If;
444: If (p_rec.rndg_rl = hr_api.g_number) then
445: p_rec.rndg_rl :=
446: ben_lsf_shd.g_old_rec.rndg_rl;
447: End If;
448: If (p_rec.los_dt_to_use_cd = hr_api.g_varchar2) then
449: p_rec.los_dt_to_use_cd :=
450: ben_lsf_shd.g_old_rec.los_dt_to_use_cd;
446: ben_lsf_shd.g_old_rec.rndg_rl;
447: End If;
448: If (p_rec.los_dt_to_use_cd = hr_api.g_varchar2) then
449: p_rec.los_dt_to_use_cd :=
450: ben_lsf_shd.g_old_rec.los_dt_to_use_cd;
451: End If;
452: If (p_rec.los_dt_to_use_rl = hr_api.g_number) then
453: p_rec.los_dt_to_use_rl :=
454: ben_lsf_shd.g_old_rec.los_dt_to_use_rl;
450: ben_lsf_shd.g_old_rec.los_dt_to_use_cd;
451: End If;
452: If (p_rec.los_dt_to_use_rl = hr_api.g_number) then
453: p_rec.los_dt_to_use_rl :=
454: ben_lsf_shd.g_old_rec.los_dt_to_use_rl;
455: End If;
456: If (p_rec.los_uom = hr_api.g_varchar2) then
457: p_rec.los_uom :=
458: ben_lsf_shd.g_old_rec.los_uom;
454: ben_lsf_shd.g_old_rec.los_dt_to_use_rl;
455: End If;
456: If (p_rec.los_uom = hr_api.g_varchar2) then
457: p_rec.los_uom :=
458: ben_lsf_shd.g_old_rec.los_uom;
459: End If;
460: If (p_rec.los_calc_rl = hr_api.g_number) then
461: p_rec.los_calc_rl :=
462: ben_lsf_shd.g_old_rec.los_calc_rl;
458: ben_lsf_shd.g_old_rec.los_uom;
459: End If;
460: If (p_rec.los_calc_rl = hr_api.g_number) then
461: p_rec.los_calc_rl :=
462: ben_lsf_shd.g_old_rec.los_calc_rl;
463: End If;
464: If (p_rec.los_alt_val_to_use_cd = hr_api.g_varchar2) then
465: p_rec.los_alt_val_to_use_cd :=
466: ben_lsf_shd.g_old_rec.los_alt_val_to_use_cd;
462: ben_lsf_shd.g_old_rec.los_calc_rl;
463: End If;
464: If (p_rec.los_alt_val_to_use_cd = hr_api.g_varchar2) then
465: p_rec.los_alt_val_to_use_cd :=
466: ben_lsf_shd.g_old_rec.los_alt_val_to_use_cd;
467: End If;
468: If (p_rec.lsf_attribute_category = hr_api.g_varchar2) then
469: p_rec.lsf_attribute_category :=
470: ben_lsf_shd.g_old_rec.lsf_attribute_category;
466: ben_lsf_shd.g_old_rec.los_alt_val_to_use_cd;
467: End If;
468: If (p_rec.lsf_attribute_category = hr_api.g_varchar2) then
469: p_rec.lsf_attribute_category :=
470: ben_lsf_shd.g_old_rec.lsf_attribute_category;
471: End If;
472: If (p_rec.lsf_attribute1 = hr_api.g_varchar2) then
473: p_rec.lsf_attribute1 :=
474: ben_lsf_shd.g_old_rec.lsf_attribute1;
470: ben_lsf_shd.g_old_rec.lsf_attribute_category;
471: End If;
472: If (p_rec.lsf_attribute1 = hr_api.g_varchar2) then
473: p_rec.lsf_attribute1 :=
474: ben_lsf_shd.g_old_rec.lsf_attribute1;
475: End If;
476: If (p_rec.lsf_attribute2 = hr_api.g_varchar2) then
477: p_rec.lsf_attribute2 :=
478: ben_lsf_shd.g_old_rec.lsf_attribute2;
474: ben_lsf_shd.g_old_rec.lsf_attribute1;
475: End If;
476: If (p_rec.lsf_attribute2 = hr_api.g_varchar2) then
477: p_rec.lsf_attribute2 :=
478: ben_lsf_shd.g_old_rec.lsf_attribute2;
479: End If;
480: If (p_rec.lsf_attribute3 = hr_api.g_varchar2) then
481: p_rec.lsf_attribute3 :=
482: ben_lsf_shd.g_old_rec.lsf_attribute3;
478: ben_lsf_shd.g_old_rec.lsf_attribute2;
479: End If;
480: If (p_rec.lsf_attribute3 = hr_api.g_varchar2) then
481: p_rec.lsf_attribute3 :=
482: ben_lsf_shd.g_old_rec.lsf_attribute3;
483: End If;
484: If (p_rec.lsf_attribute4 = hr_api.g_varchar2) then
485: p_rec.lsf_attribute4 :=
486: ben_lsf_shd.g_old_rec.lsf_attribute4;
482: ben_lsf_shd.g_old_rec.lsf_attribute3;
483: End If;
484: If (p_rec.lsf_attribute4 = hr_api.g_varchar2) then
485: p_rec.lsf_attribute4 :=
486: ben_lsf_shd.g_old_rec.lsf_attribute4;
487: End If;
488: If (p_rec.lsf_attribute5 = hr_api.g_varchar2) then
489: p_rec.lsf_attribute5 :=
490: ben_lsf_shd.g_old_rec.lsf_attribute5;
486: ben_lsf_shd.g_old_rec.lsf_attribute4;
487: End If;
488: If (p_rec.lsf_attribute5 = hr_api.g_varchar2) then
489: p_rec.lsf_attribute5 :=
490: ben_lsf_shd.g_old_rec.lsf_attribute5;
491: End If;
492: If (p_rec.lsf_attribute6 = hr_api.g_varchar2) then
493: p_rec.lsf_attribute6 :=
494: ben_lsf_shd.g_old_rec.lsf_attribute6;
490: ben_lsf_shd.g_old_rec.lsf_attribute5;
491: End If;
492: If (p_rec.lsf_attribute6 = hr_api.g_varchar2) then
493: p_rec.lsf_attribute6 :=
494: ben_lsf_shd.g_old_rec.lsf_attribute6;
495: End If;
496: If (p_rec.lsf_attribute7 = hr_api.g_varchar2) then
497: p_rec.lsf_attribute7 :=
498: ben_lsf_shd.g_old_rec.lsf_attribute7;
494: ben_lsf_shd.g_old_rec.lsf_attribute6;
495: End If;
496: If (p_rec.lsf_attribute7 = hr_api.g_varchar2) then
497: p_rec.lsf_attribute7 :=
498: ben_lsf_shd.g_old_rec.lsf_attribute7;
499: End If;
500: If (p_rec.lsf_attribute8 = hr_api.g_varchar2) then
501: p_rec.lsf_attribute8 :=
502: ben_lsf_shd.g_old_rec.lsf_attribute8;
498: ben_lsf_shd.g_old_rec.lsf_attribute7;
499: End If;
500: If (p_rec.lsf_attribute8 = hr_api.g_varchar2) then
501: p_rec.lsf_attribute8 :=
502: ben_lsf_shd.g_old_rec.lsf_attribute8;
503: End If;
504: If (p_rec.lsf_attribute9 = hr_api.g_varchar2) then
505: p_rec.lsf_attribute9 :=
506: ben_lsf_shd.g_old_rec.lsf_attribute9;
502: ben_lsf_shd.g_old_rec.lsf_attribute8;
503: End If;
504: If (p_rec.lsf_attribute9 = hr_api.g_varchar2) then
505: p_rec.lsf_attribute9 :=
506: ben_lsf_shd.g_old_rec.lsf_attribute9;
507: End If;
508: If (p_rec.lsf_attribute10 = hr_api.g_varchar2) then
509: p_rec.lsf_attribute10 :=
510: ben_lsf_shd.g_old_rec.lsf_attribute10;
506: ben_lsf_shd.g_old_rec.lsf_attribute9;
507: End If;
508: If (p_rec.lsf_attribute10 = hr_api.g_varchar2) then
509: p_rec.lsf_attribute10 :=
510: ben_lsf_shd.g_old_rec.lsf_attribute10;
511: End If;
512: If (p_rec.lsf_attribute11 = hr_api.g_varchar2) then
513: p_rec.lsf_attribute11 :=
514: ben_lsf_shd.g_old_rec.lsf_attribute11;
510: ben_lsf_shd.g_old_rec.lsf_attribute10;
511: End If;
512: If (p_rec.lsf_attribute11 = hr_api.g_varchar2) then
513: p_rec.lsf_attribute11 :=
514: ben_lsf_shd.g_old_rec.lsf_attribute11;
515: End If;
516: If (p_rec.lsf_attribute12 = hr_api.g_varchar2) then
517: p_rec.lsf_attribute12 :=
518: ben_lsf_shd.g_old_rec.lsf_attribute12;
514: ben_lsf_shd.g_old_rec.lsf_attribute11;
515: End If;
516: If (p_rec.lsf_attribute12 = hr_api.g_varchar2) then
517: p_rec.lsf_attribute12 :=
518: ben_lsf_shd.g_old_rec.lsf_attribute12;
519: End If;
520: If (p_rec.lsf_attribute13 = hr_api.g_varchar2) then
521: p_rec.lsf_attribute13 :=
522: ben_lsf_shd.g_old_rec.lsf_attribute13;
518: ben_lsf_shd.g_old_rec.lsf_attribute12;
519: End If;
520: If (p_rec.lsf_attribute13 = hr_api.g_varchar2) then
521: p_rec.lsf_attribute13 :=
522: ben_lsf_shd.g_old_rec.lsf_attribute13;
523: End If;
524: If (p_rec.lsf_attribute14 = hr_api.g_varchar2) then
525: p_rec.lsf_attribute14 :=
526: ben_lsf_shd.g_old_rec.lsf_attribute14;
522: ben_lsf_shd.g_old_rec.lsf_attribute13;
523: End If;
524: If (p_rec.lsf_attribute14 = hr_api.g_varchar2) then
525: p_rec.lsf_attribute14 :=
526: ben_lsf_shd.g_old_rec.lsf_attribute14;
527: End If;
528: If (p_rec.lsf_attribute15 = hr_api.g_varchar2) then
529: p_rec.lsf_attribute15 :=
530: ben_lsf_shd.g_old_rec.lsf_attribute15;
526: ben_lsf_shd.g_old_rec.lsf_attribute14;
527: End If;
528: If (p_rec.lsf_attribute15 = hr_api.g_varchar2) then
529: p_rec.lsf_attribute15 :=
530: ben_lsf_shd.g_old_rec.lsf_attribute15;
531: End If;
532: If (p_rec.lsf_attribute16 = hr_api.g_varchar2) then
533: p_rec.lsf_attribute16 :=
534: ben_lsf_shd.g_old_rec.lsf_attribute16;
530: ben_lsf_shd.g_old_rec.lsf_attribute15;
531: End If;
532: If (p_rec.lsf_attribute16 = hr_api.g_varchar2) then
533: p_rec.lsf_attribute16 :=
534: ben_lsf_shd.g_old_rec.lsf_attribute16;
535: End If;
536: If (p_rec.lsf_attribute17 = hr_api.g_varchar2) then
537: p_rec.lsf_attribute17 :=
538: ben_lsf_shd.g_old_rec.lsf_attribute17;
534: ben_lsf_shd.g_old_rec.lsf_attribute16;
535: End If;
536: If (p_rec.lsf_attribute17 = hr_api.g_varchar2) then
537: p_rec.lsf_attribute17 :=
538: ben_lsf_shd.g_old_rec.lsf_attribute17;
539: End If;
540: If (p_rec.lsf_attribute18 = hr_api.g_varchar2) then
541: p_rec.lsf_attribute18 :=
542: ben_lsf_shd.g_old_rec.lsf_attribute18;
538: ben_lsf_shd.g_old_rec.lsf_attribute17;
539: End If;
540: If (p_rec.lsf_attribute18 = hr_api.g_varchar2) then
541: p_rec.lsf_attribute18 :=
542: ben_lsf_shd.g_old_rec.lsf_attribute18;
543: End If;
544: If (p_rec.lsf_attribute19 = hr_api.g_varchar2) then
545: p_rec.lsf_attribute19 :=
546: ben_lsf_shd.g_old_rec.lsf_attribute19;
542: ben_lsf_shd.g_old_rec.lsf_attribute18;
543: End If;
544: If (p_rec.lsf_attribute19 = hr_api.g_varchar2) then
545: p_rec.lsf_attribute19 :=
546: ben_lsf_shd.g_old_rec.lsf_attribute19;
547: End If;
548: If (p_rec.lsf_attribute20 = hr_api.g_varchar2) then
549: p_rec.lsf_attribute20 :=
550: ben_lsf_shd.g_old_rec.lsf_attribute20;
546: ben_lsf_shd.g_old_rec.lsf_attribute19;
547: End If;
548: If (p_rec.lsf_attribute20 = hr_api.g_varchar2) then
549: p_rec.lsf_attribute20 :=
550: ben_lsf_shd.g_old_rec.lsf_attribute20;
551: End If;
552: If (p_rec.lsf_attribute21 = hr_api.g_varchar2) then
553: p_rec.lsf_attribute21 :=
554: ben_lsf_shd.g_old_rec.lsf_attribute21;
550: ben_lsf_shd.g_old_rec.lsf_attribute20;
551: End If;
552: If (p_rec.lsf_attribute21 = hr_api.g_varchar2) then
553: p_rec.lsf_attribute21 :=
554: ben_lsf_shd.g_old_rec.lsf_attribute21;
555: End If;
556: If (p_rec.lsf_attribute22 = hr_api.g_varchar2) then
557: p_rec.lsf_attribute22 :=
558: ben_lsf_shd.g_old_rec.lsf_attribute22;
554: ben_lsf_shd.g_old_rec.lsf_attribute21;
555: End If;
556: If (p_rec.lsf_attribute22 = hr_api.g_varchar2) then
557: p_rec.lsf_attribute22 :=
558: ben_lsf_shd.g_old_rec.lsf_attribute22;
559: End If;
560: If (p_rec.lsf_attribute23 = hr_api.g_varchar2) then
561: p_rec.lsf_attribute23 :=
562: ben_lsf_shd.g_old_rec.lsf_attribute23;
558: ben_lsf_shd.g_old_rec.lsf_attribute22;
559: End If;
560: If (p_rec.lsf_attribute23 = hr_api.g_varchar2) then
561: p_rec.lsf_attribute23 :=
562: ben_lsf_shd.g_old_rec.lsf_attribute23;
563: End If;
564: If (p_rec.lsf_attribute24 = hr_api.g_varchar2) then
565: p_rec.lsf_attribute24 :=
566: ben_lsf_shd.g_old_rec.lsf_attribute24;
562: ben_lsf_shd.g_old_rec.lsf_attribute23;
563: End If;
564: If (p_rec.lsf_attribute24 = hr_api.g_varchar2) then
565: p_rec.lsf_attribute24 :=
566: ben_lsf_shd.g_old_rec.lsf_attribute24;
567: End If;
568: If (p_rec.lsf_attribute25 = hr_api.g_varchar2) then
569: p_rec.lsf_attribute25 :=
570: ben_lsf_shd.g_old_rec.lsf_attribute25;
566: ben_lsf_shd.g_old_rec.lsf_attribute24;
567: End If;
568: If (p_rec.lsf_attribute25 = hr_api.g_varchar2) then
569: p_rec.lsf_attribute25 :=
570: ben_lsf_shd.g_old_rec.lsf_attribute25;
571: End If;
572: If (p_rec.lsf_attribute26 = hr_api.g_varchar2) then
573: p_rec.lsf_attribute26 :=
574: ben_lsf_shd.g_old_rec.lsf_attribute26;
570: ben_lsf_shd.g_old_rec.lsf_attribute25;
571: End If;
572: If (p_rec.lsf_attribute26 = hr_api.g_varchar2) then
573: p_rec.lsf_attribute26 :=
574: ben_lsf_shd.g_old_rec.lsf_attribute26;
575: End If;
576: If (p_rec.lsf_attribute27 = hr_api.g_varchar2) then
577: p_rec.lsf_attribute27 :=
578: ben_lsf_shd.g_old_rec.lsf_attribute27;
574: ben_lsf_shd.g_old_rec.lsf_attribute26;
575: End If;
576: If (p_rec.lsf_attribute27 = hr_api.g_varchar2) then
577: p_rec.lsf_attribute27 :=
578: ben_lsf_shd.g_old_rec.lsf_attribute27;
579: End If;
580: If (p_rec.lsf_attribute28 = hr_api.g_varchar2) then
581: p_rec.lsf_attribute28 :=
582: ben_lsf_shd.g_old_rec.lsf_attribute28;
578: ben_lsf_shd.g_old_rec.lsf_attribute27;
579: End If;
580: If (p_rec.lsf_attribute28 = hr_api.g_varchar2) then
581: p_rec.lsf_attribute28 :=
582: ben_lsf_shd.g_old_rec.lsf_attribute28;
583: End If;
584: If (p_rec.lsf_attribute29 = hr_api.g_varchar2) then
585: p_rec.lsf_attribute29 :=
586: ben_lsf_shd.g_old_rec.lsf_attribute29;
582: ben_lsf_shd.g_old_rec.lsf_attribute28;
583: End If;
584: If (p_rec.lsf_attribute29 = hr_api.g_varchar2) then
585: p_rec.lsf_attribute29 :=
586: ben_lsf_shd.g_old_rec.lsf_attribute29;
587: End If;
588: If (p_rec.lsf_attribute30 = hr_api.g_varchar2) then
589: p_rec.lsf_attribute30 :=
590: ben_lsf_shd.g_old_rec.lsf_attribute30;
586: ben_lsf_shd.g_old_rec.lsf_attribute29;
587: End If;
588: If (p_rec.lsf_attribute30 = hr_api.g_varchar2) then
589: p_rec.lsf_attribute30 :=
590: ben_lsf_shd.g_old_rec.lsf_attribute30;
591: End If;
592: If (p_rec.use_overid_svc_dt_flag = hr_api.g_varchar2) then
593: p_rec.use_overid_svc_dt_flag :=
594: ben_lsf_shd.g_old_rec.use_overid_svc_dt_flag;
590: ben_lsf_shd.g_old_rec.lsf_attribute30;
591: End If;
592: If (p_rec.use_overid_svc_dt_flag = hr_api.g_varchar2) then
593: p_rec.use_overid_svc_dt_flag :=
594: ben_lsf_shd.g_old_rec.use_overid_svc_dt_flag;
595: End If;
596: --
597: hr_utility.set_location(' Leaving:'||l_proc, 10);
598: --
603: -- ----------------------------------------------------------------------------
604: Procedure upd
605: (
606: p_effective_date in date,
607: p_rec in out nocopy ben_lsf_shd.g_rec_type
608: ) is
609: --
610: l_proc varchar2(72) := g_package||'upd';
611: --
613: hr_utility.set_location('Entering:'||l_proc, 5);
614: --
615: -- We must lock the row which we need to update.
616: --
617: ben_lsf_shd.lck
618: (
619: p_rec.los_fctr_id,
620: p_rec.object_version_number
621: );
700: p_object_version_number in out nocopy number,
701: p_use_overid_svc_dt_flag in varchar2 default hr_api.g_varchar2
702: ) is
703: --
704: l_rec ben_lsf_shd.g_rec_type;
705: l_proc varchar2(72) := g_package||'upd';
706: --
707: Begin
708: hr_utility.set_location('Entering:'||l_proc, 5);
710: -- Call conversion function to turn arguments into the
711: -- l_rec structure.
712: --
713: l_rec :=
714: ben_lsf_shd.convert_args
715: (
716: p_los_fctr_id,
717: p_name,
718: p_business_group_id,