47: -- Internal Row Handler Use Only.
48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml(p_rec in ben_agf_shd.g_rec_type) is
52: --
53: l_proc varchar2(72) := g_package||'delete_dml';
54: --
55: Begin
54: --
55: Begin
56: hr_utility.set_location('Entering:'||l_proc, 5);
57: --
58: ben_agf_shd.g_api_dml := true; -- Set the api dml status
59: --
60: -- Delete the ben_age_fctr row.
61: --
62: delete from ben_age_fctr
61: --
62: delete from ben_age_fctr
63: where age_fctr_id = p_rec.age_fctr_id;
64: --
65: ben_agf_shd.g_api_dml := false; -- Unset the api dml status
66: --
67: hr_utility.set_location(' Leaving:'||l_proc, 10);
68: --
69: Exception
68: --
69: Exception
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated
72: ben_agf_shd.g_api_dml := false; -- Unset the api dml status
73: ben_agf_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_agf_shd.g_api_dml := false; -- Unset the api dml status
69: Exception
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated
72: ben_agf_shd.g_api_dml := false; -- Unset the api dml status
73: ben_agf_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_agf_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;
72: ben_agf_shd.g_api_dml := false; -- Unset the api dml status
73: ben_agf_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_agf_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;
78: End delete_dml;
79: --
80: -- ----------------------------------------------------------------------------
108: -- Internal Row Handler Use Only.
109: --
110: -- {End Of Comments}
111: -- ----------------------------------------------------------------------------
112: Procedure pre_delete(p_rec in ben_agf_shd.g_rec_type) is
113: --
114: l_proc varchar2(72) := g_package||'pre_delete';
115: --
116: Begin
151: --
152: -- {End Of Comments}
153: -- ----------------------------------------------------------------------------
154: Procedure post_delete(
155: p_effective_date in date,p_rec in ben_agf_shd.g_rec_type) is
156: --
157: l_proc varchar2(72) := g_package||'post_delete';
158: --
159: Begin
166: --
167: ben_agf_rkd.after_delete
168: (
169: p_age_fctr_id =>p_rec.age_fctr_id
170: ,p_name_o =>ben_agf_shd.g_old_rec.name
171: ,p_mx_age_num_o =>ben_agf_shd.g_old_rec.mx_age_num
172: ,p_mn_age_num_o =>ben_agf_shd.g_old_rec.mn_age_num
173: ,p_age_uom_o =>ben_agf_shd.g_old_rec.age_uom
174: ,p_no_mn_age_flag_o =>ben_agf_shd.g_old_rec.no_mn_age_flag
167: ben_agf_rkd.after_delete
168: (
169: p_age_fctr_id =>p_rec.age_fctr_id
170: ,p_name_o =>ben_agf_shd.g_old_rec.name
171: ,p_mx_age_num_o =>ben_agf_shd.g_old_rec.mx_age_num
172: ,p_mn_age_num_o =>ben_agf_shd.g_old_rec.mn_age_num
173: ,p_age_uom_o =>ben_agf_shd.g_old_rec.age_uom
174: ,p_no_mn_age_flag_o =>ben_agf_shd.g_old_rec.no_mn_age_flag
175: ,p_no_mx_age_flag_o =>ben_agf_shd.g_old_rec.no_mx_age_flag
168: (
169: p_age_fctr_id =>p_rec.age_fctr_id
170: ,p_name_o =>ben_agf_shd.g_old_rec.name
171: ,p_mx_age_num_o =>ben_agf_shd.g_old_rec.mx_age_num
172: ,p_mn_age_num_o =>ben_agf_shd.g_old_rec.mn_age_num
173: ,p_age_uom_o =>ben_agf_shd.g_old_rec.age_uom
174: ,p_no_mn_age_flag_o =>ben_agf_shd.g_old_rec.no_mn_age_flag
175: ,p_no_mx_age_flag_o =>ben_agf_shd.g_old_rec.no_mx_age_flag
176: ,p_age_to_use_cd_o =>ben_agf_shd.g_old_rec.age_to_use_cd
169: p_age_fctr_id =>p_rec.age_fctr_id
170: ,p_name_o =>ben_agf_shd.g_old_rec.name
171: ,p_mx_age_num_o =>ben_agf_shd.g_old_rec.mx_age_num
172: ,p_mn_age_num_o =>ben_agf_shd.g_old_rec.mn_age_num
173: ,p_age_uom_o =>ben_agf_shd.g_old_rec.age_uom
174: ,p_no_mn_age_flag_o =>ben_agf_shd.g_old_rec.no_mn_age_flag
175: ,p_no_mx_age_flag_o =>ben_agf_shd.g_old_rec.no_mx_age_flag
176: ,p_age_to_use_cd_o =>ben_agf_shd.g_old_rec.age_to_use_cd
177: ,p_age_det_cd_o =>ben_agf_shd.g_old_rec.age_det_cd
170: ,p_name_o =>ben_agf_shd.g_old_rec.name
171: ,p_mx_age_num_o =>ben_agf_shd.g_old_rec.mx_age_num
172: ,p_mn_age_num_o =>ben_agf_shd.g_old_rec.mn_age_num
173: ,p_age_uom_o =>ben_agf_shd.g_old_rec.age_uom
174: ,p_no_mn_age_flag_o =>ben_agf_shd.g_old_rec.no_mn_age_flag
175: ,p_no_mx_age_flag_o =>ben_agf_shd.g_old_rec.no_mx_age_flag
176: ,p_age_to_use_cd_o =>ben_agf_shd.g_old_rec.age_to_use_cd
177: ,p_age_det_cd_o =>ben_agf_shd.g_old_rec.age_det_cd
178: ,p_age_det_rl_o =>ben_agf_shd.g_old_rec.age_det_rl
171: ,p_mx_age_num_o =>ben_agf_shd.g_old_rec.mx_age_num
172: ,p_mn_age_num_o =>ben_agf_shd.g_old_rec.mn_age_num
173: ,p_age_uom_o =>ben_agf_shd.g_old_rec.age_uom
174: ,p_no_mn_age_flag_o =>ben_agf_shd.g_old_rec.no_mn_age_flag
175: ,p_no_mx_age_flag_o =>ben_agf_shd.g_old_rec.no_mx_age_flag
176: ,p_age_to_use_cd_o =>ben_agf_shd.g_old_rec.age_to_use_cd
177: ,p_age_det_cd_o =>ben_agf_shd.g_old_rec.age_det_cd
178: ,p_age_det_rl_o =>ben_agf_shd.g_old_rec.age_det_rl
179: ,p_rndg_cd_o =>ben_agf_shd.g_old_rec.rndg_cd
172: ,p_mn_age_num_o =>ben_agf_shd.g_old_rec.mn_age_num
173: ,p_age_uom_o =>ben_agf_shd.g_old_rec.age_uom
174: ,p_no_mn_age_flag_o =>ben_agf_shd.g_old_rec.no_mn_age_flag
175: ,p_no_mx_age_flag_o =>ben_agf_shd.g_old_rec.no_mx_age_flag
176: ,p_age_to_use_cd_o =>ben_agf_shd.g_old_rec.age_to_use_cd
177: ,p_age_det_cd_o =>ben_agf_shd.g_old_rec.age_det_cd
178: ,p_age_det_rl_o =>ben_agf_shd.g_old_rec.age_det_rl
179: ,p_rndg_cd_o =>ben_agf_shd.g_old_rec.rndg_cd
180: ,p_rndg_rl_o =>ben_agf_shd.g_old_rec.rndg_rl
173: ,p_age_uom_o =>ben_agf_shd.g_old_rec.age_uom
174: ,p_no_mn_age_flag_o =>ben_agf_shd.g_old_rec.no_mn_age_flag
175: ,p_no_mx_age_flag_o =>ben_agf_shd.g_old_rec.no_mx_age_flag
176: ,p_age_to_use_cd_o =>ben_agf_shd.g_old_rec.age_to_use_cd
177: ,p_age_det_cd_o =>ben_agf_shd.g_old_rec.age_det_cd
178: ,p_age_det_rl_o =>ben_agf_shd.g_old_rec.age_det_rl
179: ,p_rndg_cd_o =>ben_agf_shd.g_old_rec.rndg_cd
180: ,p_rndg_rl_o =>ben_agf_shd.g_old_rec.rndg_rl
181: ,p_age_calc_rl_o =>ben_agf_shd.g_old_rec.age_calc_rl
174: ,p_no_mn_age_flag_o =>ben_agf_shd.g_old_rec.no_mn_age_flag
175: ,p_no_mx_age_flag_o =>ben_agf_shd.g_old_rec.no_mx_age_flag
176: ,p_age_to_use_cd_o =>ben_agf_shd.g_old_rec.age_to_use_cd
177: ,p_age_det_cd_o =>ben_agf_shd.g_old_rec.age_det_cd
178: ,p_age_det_rl_o =>ben_agf_shd.g_old_rec.age_det_rl
179: ,p_rndg_cd_o =>ben_agf_shd.g_old_rec.rndg_cd
180: ,p_rndg_rl_o =>ben_agf_shd.g_old_rec.rndg_rl
181: ,p_age_calc_rl_o =>ben_agf_shd.g_old_rec.age_calc_rl
182: ,p_business_group_id_o =>ben_agf_shd.g_old_rec.business_group_id
175: ,p_no_mx_age_flag_o =>ben_agf_shd.g_old_rec.no_mx_age_flag
176: ,p_age_to_use_cd_o =>ben_agf_shd.g_old_rec.age_to_use_cd
177: ,p_age_det_cd_o =>ben_agf_shd.g_old_rec.age_det_cd
178: ,p_age_det_rl_o =>ben_agf_shd.g_old_rec.age_det_rl
179: ,p_rndg_cd_o =>ben_agf_shd.g_old_rec.rndg_cd
180: ,p_rndg_rl_o =>ben_agf_shd.g_old_rec.rndg_rl
181: ,p_age_calc_rl_o =>ben_agf_shd.g_old_rec.age_calc_rl
182: ,p_business_group_id_o =>ben_agf_shd.g_old_rec.business_group_id
183: ,p_agf_attribute_category_o =>ben_agf_shd.g_old_rec.agf_attribute_category
176: ,p_age_to_use_cd_o =>ben_agf_shd.g_old_rec.age_to_use_cd
177: ,p_age_det_cd_o =>ben_agf_shd.g_old_rec.age_det_cd
178: ,p_age_det_rl_o =>ben_agf_shd.g_old_rec.age_det_rl
179: ,p_rndg_cd_o =>ben_agf_shd.g_old_rec.rndg_cd
180: ,p_rndg_rl_o =>ben_agf_shd.g_old_rec.rndg_rl
181: ,p_age_calc_rl_o =>ben_agf_shd.g_old_rec.age_calc_rl
182: ,p_business_group_id_o =>ben_agf_shd.g_old_rec.business_group_id
183: ,p_agf_attribute_category_o =>ben_agf_shd.g_old_rec.agf_attribute_category
184: ,p_agf_attribute1_o =>ben_agf_shd.g_old_rec.agf_attribute1
177: ,p_age_det_cd_o =>ben_agf_shd.g_old_rec.age_det_cd
178: ,p_age_det_rl_o =>ben_agf_shd.g_old_rec.age_det_rl
179: ,p_rndg_cd_o =>ben_agf_shd.g_old_rec.rndg_cd
180: ,p_rndg_rl_o =>ben_agf_shd.g_old_rec.rndg_rl
181: ,p_age_calc_rl_o =>ben_agf_shd.g_old_rec.age_calc_rl
182: ,p_business_group_id_o =>ben_agf_shd.g_old_rec.business_group_id
183: ,p_agf_attribute_category_o =>ben_agf_shd.g_old_rec.agf_attribute_category
184: ,p_agf_attribute1_o =>ben_agf_shd.g_old_rec.agf_attribute1
185: ,p_agf_attribute2_o =>ben_agf_shd.g_old_rec.agf_attribute2
178: ,p_age_det_rl_o =>ben_agf_shd.g_old_rec.age_det_rl
179: ,p_rndg_cd_o =>ben_agf_shd.g_old_rec.rndg_cd
180: ,p_rndg_rl_o =>ben_agf_shd.g_old_rec.rndg_rl
181: ,p_age_calc_rl_o =>ben_agf_shd.g_old_rec.age_calc_rl
182: ,p_business_group_id_o =>ben_agf_shd.g_old_rec.business_group_id
183: ,p_agf_attribute_category_o =>ben_agf_shd.g_old_rec.agf_attribute_category
184: ,p_agf_attribute1_o =>ben_agf_shd.g_old_rec.agf_attribute1
185: ,p_agf_attribute2_o =>ben_agf_shd.g_old_rec.agf_attribute2
186: ,p_agf_attribute3_o =>ben_agf_shd.g_old_rec.agf_attribute3
179: ,p_rndg_cd_o =>ben_agf_shd.g_old_rec.rndg_cd
180: ,p_rndg_rl_o =>ben_agf_shd.g_old_rec.rndg_rl
181: ,p_age_calc_rl_o =>ben_agf_shd.g_old_rec.age_calc_rl
182: ,p_business_group_id_o =>ben_agf_shd.g_old_rec.business_group_id
183: ,p_agf_attribute_category_o =>ben_agf_shd.g_old_rec.agf_attribute_category
184: ,p_agf_attribute1_o =>ben_agf_shd.g_old_rec.agf_attribute1
185: ,p_agf_attribute2_o =>ben_agf_shd.g_old_rec.agf_attribute2
186: ,p_agf_attribute3_o =>ben_agf_shd.g_old_rec.agf_attribute3
187: ,p_agf_attribute4_o =>ben_agf_shd.g_old_rec.agf_attribute4
180: ,p_rndg_rl_o =>ben_agf_shd.g_old_rec.rndg_rl
181: ,p_age_calc_rl_o =>ben_agf_shd.g_old_rec.age_calc_rl
182: ,p_business_group_id_o =>ben_agf_shd.g_old_rec.business_group_id
183: ,p_agf_attribute_category_o =>ben_agf_shd.g_old_rec.agf_attribute_category
184: ,p_agf_attribute1_o =>ben_agf_shd.g_old_rec.agf_attribute1
185: ,p_agf_attribute2_o =>ben_agf_shd.g_old_rec.agf_attribute2
186: ,p_agf_attribute3_o =>ben_agf_shd.g_old_rec.agf_attribute3
187: ,p_agf_attribute4_o =>ben_agf_shd.g_old_rec.agf_attribute4
188: ,p_agf_attribute5_o =>ben_agf_shd.g_old_rec.agf_attribute5
181: ,p_age_calc_rl_o =>ben_agf_shd.g_old_rec.age_calc_rl
182: ,p_business_group_id_o =>ben_agf_shd.g_old_rec.business_group_id
183: ,p_agf_attribute_category_o =>ben_agf_shd.g_old_rec.agf_attribute_category
184: ,p_agf_attribute1_o =>ben_agf_shd.g_old_rec.agf_attribute1
185: ,p_agf_attribute2_o =>ben_agf_shd.g_old_rec.agf_attribute2
186: ,p_agf_attribute3_o =>ben_agf_shd.g_old_rec.agf_attribute3
187: ,p_agf_attribute4_o =>ben_agf_shd.g_old_rec.agf_attribute4
188: ,p_agf_attribute5_o =>ben_agf_shd.g_old_rec.agf_attribute5
189: ,p_agf_attribute6_o =>ben_agf_shd.g_old_rec.agf_attribute6
182: ,p_business_group_id_o =>ben_agf_shd.g_old_rec.business_group_id
183: ,p_agf_attribute_category_o =>ben_agf_shd.g_old_rec.agf_attribute_category
184: ,p_agf_attribute1_o =>ben_agf_shd.g_old_rec.agf_attribute1
185: ,p_agf_attribute2_o =>ben_agf_shd.g_old_rec.agf_attribute2
186: ,p_agf_attribute3_o =>ben_agf_shd.g_old_rec.agf_attribute3
187: ,p_agf_attribute4_o =>ben_agf_shd.g_old_rec.agf_attribute4
188: ,p_agf_attribute5_o =>ben_agf_shd.g_old_rec.agf_attribute5
189: ,p_agf_attribute6_o =>ben_agf_shd.g_old_rec.agf_attribute6
190: ,p_agf_attribute7_o =>ben_agf_shd.g_old_rec.agf_attribute7
183: ,p_agf_attribute_category_o =>ben_agf_shd.g_old_rec.agf_attribute_category
184: ,p_agf_attribute1_o =>ben_agf_shd.g_old_rec.agf_attribute1
185: ,p_agf_attribute2_o =>ben_agf_shd.g_old_rec.agf_attribute2
186: ,p_agf_attribute3_o =>ben_agf_shd.g_old_rec.agf_attribute3
187: ,p_agf_attribute4_o =>ben_agf_shd.g_old_rec.agf_attribute4
188: ,p_agf_attribute5_o =>ben_agf_shd.g_old_rec.agf_attribute5
189: ,p_agf_attribute6_o =>ben_agf_shd.g_old_rec.agf_attribute6
190: ,p_agf_attribute7_o =>ben_agf_shd.g_old_rec.agf_attribute7
191: ,p_agf_attribute8_o =>ben_agf_shd.g_old_rec.agf_attribute8
184: ,p_agf_attribute1_o =>ben_agf_shd.g_old_rec.agf_attribute1
185: ,p_agf_attribute2_o =>ben_agf_shd.g_old_rec.agf_attribute2
186: ,p_agf_attribute3_o =>ben_agf_shd.g_old_rec.agf_attribute3
187: ,p_agf_attribute4_o =>ben_agf_shd.g_old_rec.agf_attribute4
188: ,p_agf_attribute5_o =>ben_agf_shd.g_old_rec.agf_attribute5
189: ,p_agf_attribute6_o =>ben_agf_shd.g_old_rec.agf_attribute6
190: ,p_agf_attribute7_o =>ben_agf_shd.g_old_rec.agf_attribute7
191: ,p_agf_attribute8_o =>ben_agf_shd.g_old_rec.agf_attribute8
192: ,p_agf_attribute9_o =>ben_agf_shd.g_old_rec.agf_attribute9
185: ,p_agf_attribute2_o =>ben_agf_shd.g_old_rec.agf_attribute2
186: ,p_agf_attribute3_o =>ben_agf_shd.g_old_rec.agf_attribute3
187: ,p_agf_attribute4_o =>ben_agf_shd.g_old_rec.agf_attribute4
188: ,p_agf_attribute5_o =>ben_agf_shd.g_old_rec.agf_attribute5
189: ,p_agf_attribute6_o =>ben_agf_shd.g_old_rec.agf_attribute6
190: ,p_agf_attribute7_o =>ben_agf_shd.g_old_rec.agf_attribute7
191: ,p_agf_attribute8_o =>ben_agf_shd.g_old_rec.agf_attribute8
192: ,p_agf_attribute9_o =>ben_agf_shd.g_old_rec.agf_attribute9
193: ,p_agf_attribute10_o =>ben_agf_shd.g_old_rec.agf_attribute10
186: ,p_agf_attribute3_o =>ben_agf_shd.g_old_rec.agf_attribute3
187: ,p_agf_attribute4_o =>ben_agf_shd.g_old_rec.agf_attribute4
188: ,p_agf_attribute5_o =>ben_agf_shd.g_old_rec.agf_attribute5
189: ,p_agf_attribute6_o =>ben_agf_shd.g_old_rec.agf_attribute6
190: ,p_agf_attribute7_o =>ben_agf_shd.g_old_rec.agf_attribute7
191: ,p_agf_attribute8_o =>ben_agf_shd.g_old_rec.agf_attribute8
192: ,p_agf_attribute9_o =>ben_agf_shd.g_old_rec.agf_attribute9
193: ,p_agf_attribute10_o =>ben_agf_shd.g_old_rec.agf_attribute10
194: ,p_agf_attribute11_o =>ben_agf_shd.g_old_rec.agf_attribute11
187: ,p_agf_attribute4_o =>ben_agf_shd.g_old_rec.agf_attribute4
188: ,p_agf_attribute5_o =>ben_agf_shd.g_old_rec.agf_attribute5
189: ,p_agf_attribute6_o =>ben_agf_shd.g_old_rec.agf_attribute6
190: ,p_agf_attribute7_o =>ben_agf_shd.g_old_rec.agf_attribute7
191: ,p_agf_attribute8_o =>ben_agf_shd.g_old_rec.agf_attribute8
192: ,p_agf_attribute9_o =>ben_agf_shd.g_old_rec.agf_attribute9
193: ,p_agf_attribute10_o =>ben_agf_shd.g_old_rec.agf_attribute10
194: ,p_agf_attribute11_o =>ben_agf_shd.g_old_rec.agf_attribute11
195: ,p_agf_attribute12_o =>ben_agf_shd.g_old_rec.agf_attribute12
188: ,p_agf_attribute5_o =>ben_agf_shd.g_old_rec.agf_attribute5
189: ,p_agf_attribute6_o =>ben_agf_shd.g_old_rec.agf_attribute6
190: ,p_agf_attribute7_o =>ben_agf_shd.g_old_rec.agf_attribute7
191: ,p_agf_attribute8_o =>ben_agf_shd.g_old_rec.agf_attribute8
192: ,p_agf_attribute9_o =>ben_agf_shd.g_old_rec.agf_attribute9
193: ,p_agf_attribute10_o =>ben_agf_shd.g_old_rec.agf_attribute10
194: ,p_agf_attribute11_o =>ben_agf_shd.g_old_rec.agf_attribute11
195: ,p_agf_attribute12_o =>ben_agf_shd.g_old_rec.agf_attribute12
196: ,p_agf_attribute13_o =>ben_agf_shd.g_old_rec.agf_attribute13
189: ,p_agf_attribute6_o =>ben_agf_shd.g_old_rec.agf_attribute6
190: ,p_agf_attribute7_o =>ben_agf_shd.g_old_rec.agf_attribute7
191: ,p_agf_attribute8_o =>ben_agf_shd.g_old_rec.agf_attribute8
192: ,p_agf_attribute9_o =>ben_agf_shd.g_old_rec.agf_attribute9
193: ,p_agf_attribute10_o =>ben_agf_shd.g_old_rec.agf_attribute10
194: ,p_agf_attribute11_o =>ben_agf_shd.g_old_rec.agf_attribute11
195: ,p_agf_attribute12_o =>ben_agf_shd.g_old_rec.agf_attribute12
196: ,p_agf_attribute13_o =>ben_agf_shd.g_old_rec.agf_attribute13
197: ,p_agf_attribute14_o =>ben_agf_shd.g_old_rec.agf_attribute14
190: ,p_agf_attribute7_o =>ben_agf_shd.g_old_rec.agf_attribute7
191: ,p_agf_attribute8_o =>ben_agf_shd.g_old_rec.agf_attribute8
192: ,p_agf_attribute9_o =>ben_agf_shd.g_old_rec.agf_attribute9
193: ,p_agf_attribute10_o =>ben_agf_shd.g_old_rec.agf_attribute10
194: ,p_agf_attribute11_o =>ben_agf_shd.g_old_rec.agf_attribute11
195: ,p_agf_attribute12_o =>ben_agf_shd.g_old_rec.agf_attribute12
196: ,p_agf_attribute13_o =>ben_agf_shd.g_old_rec.agf_attribute13
197: ,p_agf_attribute14_o =>ben_agf_shd.g_old_rec.agf_attribute14
198: ,p_agf_attribute15_o =>ben_agf_shd.g_old_rec.agf_attribute15
191: ,p_agf_attribute8_o =>ben_agf_shd.g_old_rec.agf_attribute8
192: ,p_agf_attribute9_o =>ben_agf_shd.g_old_rec.agf_attribute9
193: ,p_agf_attribute10_o =>ben_agf_shd.g_old_rec.agf_attribute10
194: ,p_agf_attribute11_o =>ben_agf_shd.g_old_rec.agf_attribute11
195: ,p_agf_attribute12_o =>ben_agf_shd.g_old_rec.agf_attribute12
196: ,p_agf_attribute13_o =>ben_agf_shd.g_old_rec.agf_attribute13
197: ,p_agf_attribute14_o =>ben_agf_shd.g_old_rec.agf_attribute14
198: ,p_agf_attribute15_o =>ben_agf_shd.g_old_rec.agf_attribute15
199: ,p_agf_attribute16_o =>ben_agf_shd.g_old_rec.agf_attribute16
192: ,p_agf_attribute9_o =>ben_agf_shd.g_old_rec.agf_attribute9
193: ,p_agf_attribute10_o =>ben_agf_shd.g_old_rec.agf_attribute10
194: ,p_agf_attribute11_o =>ben_agf_shd.g_old_rec.agf_attribute11
195: ,p_agf_attribute12_o =>ben_agf_shd.g_old_rec.agf_attribute12
196: ,p_agf_attribute13_o =>ben_agf_shd.g_old_rec.agf_attribute13
197: ,p_agf_attribute14_o =>ben_agf_shd.g_old_rec.agf_attribute14
198: ,p_agf_attribute15_o =>ben_agf_shd.g_old_rec.agf_attribute15
199: ,p_agf_attribute16_o =>ben_agf_shd.g_old_rec.agf_attribute16
200: ,p_agf_attribute17_o =>ben_agf_shd.g_old_rec.agf_attribute17
193: ,p_agf_attribute10_o =>ben_agf_shd.g_old_rec.agf_attribute10
194: ,p_agf_attribute11_o =>ben_agf_shd.g_old_rec.agf_attribute11
195: ,p_agf_attribute12_o =>ben_agf_shd.g_old_rec.agf_attribute12
196: ,p_agf_attribute13_o =>ben_agf_shd.g_old_rec.agf_attribute13
197: ,p_agf_attribute14_o =>ben_agf_shd.g_old_rec.agf_attribute14
198: ,p_agf_attribute15_o =>ben_agf_shd.g_old_rec.agf_attribute15
199: ,p_agf_attribute16_o =>ben_agf_shd.g_old_rec.agf_attribute16
200: ,p_agf_attribute17_o =>ben_agf_shd.g_old_rec.agf_attribute17
201: ,p_agf_attribute18_o =>ben_agf_shd.g_old_rec.agf_attribute18
194: ,p_agf_attribute11_o =>ben_agf_shd.g_old_rec.agf_attribute11
195: ,p_agf_attribute12_o =>ben_agf_shd.g_old_rec.agf_attribute12
196: ,p_agf_attribute13_o =>ben_agf_shd.g_old_rec.agf_attribute13
197: ,p_agf_attribute14_o =>ben_agf_shd.g_old_rec.agf_attribute14
198: ,p_agf_attribute15_o =>ben_agf_shd.g_old_rec.agf_attribute15
199: ,p_agf_attribute16_o =>ben_agf_shd.g_old_rec.agf_attribute16
200: ,p_agf_attribute17_o =>ben_agf_shd.g_old_rec.agf_attribute17
201: ,p_agf_attribute18_o =>ben_agf_shd.g_old_rec.agf_attribute18
202: ,p_agf_attribute19_o =>ben_agf_shd.g_old_rec.agf_attribute19
195: ,p_agf_attribute12_o =>ben_agf_shd.g_old_rec.agf_attribute12
196: ,p_agf_attribute13_o =>ben_agf_shd.g_old_rec.agf_attribute13
197: ,p_agf_attribute14_o =>ben_agf_shd.g_old_rec.agf_attribute14
198: ,p_agf_attribute15_o =>ben_agf_shd.g_old_rec.agf_attribute15
199: ,p_agf_attribute16_o =>ben_agf_shd.g_old_rec.agf_attribute16
200: ,p_agf_attribute17_o =>ben_agf_shd.g_old_rec.agf_attribute17
201: ,p_agf_attribute18_o =>ben_agf_shd.g_old_rec.agf_attribute18
202: ,p_agf_attribute19_o =>ben_agf_shd.g_old_rec.agf_attribute19
203: ,p_agf_attribute20_o =>ben_agf_shd.g_old_rec.agf_attribute20
196: ,p_agf_attribute13_o =>ben_agf_shd.g_old_rec.agf_attribute13
197: ,p_agf_attribute14_o =>ben_agf_shd.g_old_rec.agf_attribute14
198: ,p_agf_attribute15_o =>ben_agf_shd.g_old_rec.agf_attribute15
199: ,p_agf_attribute16_o =>ben_agf_shd.g_old_rec.agf_attribute16
200: ,p_agf_attribute17_o =>ben_agf_shd.g_old_rec.agf_attribute17
201: ,p_agf_attribute18_o =>ben_agf_shd.g_old_rec.agf_attribute18
202: ,p_agf_attribute19_o =>ben_agf_shd.g_old_rec.agf_attribute19
203: ,p_agf_attribute20_o =>ben_agf_shd.g_old_rec.agf_attribute20
204: ,p_agf_attribute21_o =>ben_agf_shd.g_old_rec.agf_attribute21
197: ,p_agf_attribute14_o =>ben_agf_shd.g_old_rec.agf_attribute14
198: ,p_agf_attribute15_o =>ben_agf_shd.g_old_rec.agf_attribute15
199: ,p_agf_attribute16_o =>ben_agf_shd.g_old_rec.agf_attribute16
200: ,p_agf_attribute17_o =>ben_agf_shd.g_old_rec.agf_attribute17
201: ,p_agf_attribute18_o =>ben_agf_shd.g_old_rec.agf_attribute18
202: ,p_agf_attribute19_o =>ben_agf_shd.g_old_rec.agf_attribute19
203: ,p_agf_attribute20_o =>ben_agf_shd.g_old_rec.agf_attribute20
204: ,p_agf_attribute21_o =>ben_agf_shd.g_old_rec.agf_attribute21
205: ,p_agf_attribute22_o =>ben_agf_shd.g_old_rec.agf_attribute22
198: ,p_agf_attribute15_o =>ben_agf_shd.g_old_rec.agf_attribute15
199: ,p_agf_attribute16_o =>ben_agf_shd.g_old_rec.agf_attribute16
200: ,p_agf_attribute17_o =>ben_agf_shd.g_old_rec.agf_attribute17
201: ,p_agf_attribute18_o =>ben_agf_shd.g_old_rec.agf_attribute18
202: ,p_agf_attribute19_o =>ben_agf_shd.g_old_rec.agf_attribute19
203: ,p_agf_attribute20_o =>ben_agf_shd.g_old_rec.agf_attribute20
204: ,p_agf_attribute21_o =>ben_agf_shd.g_old_rec.agf_attribute21
205: ,p_agf_attribute22_o =>ben_agf_shd.g_old_rec.agf_attribute22
206: ,p_agf_attribute23_o =>ben_agf_shd.g_old_rec.agf_attribute23
199: ,p_agf_attribute16_o =>ben_agf_shd.g_old_rec.agf_attribute16
200: ,p_agf_attribute17_o =>ben_agf_shd.g_old_rec.agf_attribute17
201: ,p_agf_attribute18_o =>ben_agf_shd.g_old_rec.agf_attribute18
202: ,p_agf_attribute19_o =>ben_agf_shd.g_old_rec.agf_attribute19
203: ,p_agf_attribute20_o =>ben_agf_shd.g_old_rec.agf_attribute20
204: ,p_agf_attribute21_o =>ben_agf_shd.g_old_rec.agf_attribute21
205: ,p_agf_attribute22_o =>ben_agf_shd.g_old_rec.agf_attribute22
206: ,p_agf_attribute23_o =>ben_agf_shd.g_old_rec.agf_attribute23
207: ,p_agf_attribute24_o =>ben_agf_shd.g_old_rec.agf_attribute24
200: ,p_agf_attribute17_o =>ben_agf_shd.g_old_rec.agf_attribute17
201: ,p_agf_attribute18_o =>ben_agf_shd.g_old_rec.agf_attribute18
202: ,p_agf_attribute19_o =>ben_agf_shd.g_old_rec.agf_attribute19
203: ,p_agf_attribute20_o =>ben_agf_shd.g_old_rec.agf_attribute20
204: ,p_agf_attribute21_o =>ben_agf_shd.g_old_rec.agf_attribute21
205: ,p_agf_attribute22_o =>ben_agf_shd.g_old_rec.agf_attribute22
206: ,p_agf_attribute23_o =>ben_agf_shd.g_old_rec.agf_attribute23
207: ,p_agf_attribute24_o =>ben_agf_shd.g_old_rec.agf_attribute24
208: ,p_agf_attribute25_o =>ben_agf_shd.g_old_rec.agf_attribute25
201: ,p_agf_attribute18_o =>ben_agf_shd.g_old_rec.agf_attribute18
202: ,p_agf_attribute19_o =>ben_agf_shd.g_old_rec.agf_attribute19
203: ,p_agf_attribute20_o =>ben_agf_shd.g_old_rec.agf_attribute20
204: ,p_agf_attribute21_o =>ben_agf_shd.g_old_rec.agf_attribute21
205: ,p_agf_attribute22_o =>ben_agf_shd.g_old_rec.agf_attribute22
206: ,p_agf_attribute23_o =>ben_agf_shd.g_old_rec.agf_attribute23
207: ,p_agf_attribute24_o =>ben_agf_shd.g_old_rec.agf_attribute24
208: ,p_agf_attribute25_o =>ben_agf_shd.g_old_rec.agf_attribute25
209: ,p_agf_attribute26_o =>ben_agf_shd.g_old_rec.agf_attribute26
202: ,p_agf_attribute19_o =>ben_agf_shd.g_old_rec.agf_attribute19
203: ,p_agf_attribute20_o =>ben_agf_shd.g_old_rec.agf_attribute20
204: ,p_agf_attribute21_o =>ben_agf_shd.g_old_rec.agf_attribute21
205: ,p_agf_attribute22_o =>ben_agf_shd.g_old_rec.agf_attribute22
206: ,p_agf_attribute23_o =>ben_agf_shd.g_old_rec.agf_attribute23
207: ,p_agf_attribute24_o =>ben_agf_shd.g_old_rec.agf_attribute24
208: ,p_agf_attribute25_o =>ben_agf_shd.g_old_rec.agf_attribute25
209: ,p_agf_attribute26_o =>ben_agf_shd.g_old_rec.agf_attribute26
210: ,p_agf_attribute27_o =>ben_agf_shd.g_old_rec.agf_attribute27
203: ,p_agf_attribute20_o =>ben_agf_shd.g_old_rec.agf_attribute20
204: ,p_agf_attribute21_o =>ben_agf_shd.g_old_rec.agf_attribute21
205: ,p_agf_attribute22_o =>ben_agf_shd.g_old_rec.agf_attribute22
206: ,p_agf_attribute23_o =>ben_agf_shd.g_old_rec.agf_attribute23
207: ,p_agf_attribute24_o =>ben_agf_shd.g_old_rec.agf_attribute24
208: ,p_agf_attribute25_o =>ben_agf_shd.g_old_rec.agf_attribute25
209: ,p_agf_attribute26_o =>ben_agf_shd.g_old_rec.agf_attribute26
210: ,p_agf_attribute27_o =>ben_agf_shd.g_old_rec.agf_attribute27
211: ,p_agf_attribute28_o =>ben_agf_shd.g_old_rec.agf_attribute28
204: ,p_agf_attribute21_o =>ben_agf_shd.g_old_rec.agf_attribute21
205: ,p_agf_attribute22_o =>ben_agf_shd.g_old_rec.agf_attribute22
206: ,p_agf_attribute23_o =>ben_agf_shd.g_old_rec.agf_attribute23
207: ,p_agf_attribute24_o =>ben_agf_shd.g_old_rec.agf_attribute24
208: ,p_agf_attribute25_o =>ben_agf_shd.g_old_rec.agf_attribute25
209: ,p_agf_attribute26_o =>ben_agf_shd.g_old_rec.agf_attribute26
210: ,p_agf_attribute27_o =>ben_agf_shd.g_old_rec.agf_attribute27
211: ,p_agf_attribute28_o =>ben_agf_shd.g_old_rec.agf_attribute28
212: ,p_agf_attribute29_o =>ben_agf_shd.g_old_rec.agf_attribute29
205: ,p_agf_attribute22_o =>ben_agf_shd.g_old_rec.agf_attribute22
206: ,p_agf_attribute23_o =>ben_agf_shd.g_old_rec.agf_attribute23
207: ,p_agf_attribute24_o =>ben_agf_shd.g_old_rec.agf_attribute24
208: ,p_agf_attribute25_o =>ben_agf_shd.g_old_rec.agf_attribute25
209: ,p_agf_attribute26_o =>ben_agf_shd.g_old_rec.agf_attribute26
210: ,p_agf_attribute27_o =>ben_agf_shd.g_old_rec.agf_attribute27
211: ,p_agf_attribute28_o =>ben_agf_shd.g_old_rec.agf_attribute28
212: ,p_agf_attribute29_o =>ben_agf_shd.g_old_rec.agf_attribute29
213: ,p_agf_attribute30_o =>ben_agf_shd.g_old_rec.agf_attribute30
206: ,p_agf_attribute23_o =>ben_agf_shd.g_old_rec.agf_attribute23
207: ,p_agf_attribute24_o =>ben_agf_shd.g_old_rec.agf_attribute24
208: ,p_agf_attribute25_o =>ben_agf_shd.g_old_rec.agf_attribute25
209: ,p_agf_attribute26_o =>ben_agf_shd.g_old_rec.agf_attribute26
210: ,p_agf_attribute27_o =>ben_agf_shd.g_old_rec.agf_attribute27
211: ,p_agf_attribute28_o =>ben_agf_shd.g_old_rec.agf_attribute28
212: ,p_agf_attribute29_o =>ben_agf_shd.g_old_rec.agf_attribute29
213: ,p_agf_attribute30_o =>ben_agf_shd.g_old_rec.agf_attribute30
214: ,p_object_version_number_o =>ben_agf_shd.g_old_rec.object_version_number
207: ,p_agf_attribute24_o =>ben_agf_shd.g_old_rec.agf_attribute24
208: ,p_agf_attribute25_o =>ben_agf_shd.g_old_rec.agf_attribute25
209: ,p_agf_attribute26_o =>ben_agf_shd.g_old_rec.agf_attribute26
210: ,p_agf_attribute27_o =>ben_agf_shd.g_old_rec.agf_attribute27
211: ,p_agf_attribute28_o =>ben_agf_shd.g_old_rec.agf_attribute28
212: ,p_agf_attribute29_o =>ben_agf_shd.g_old_rec.agf_attribute29
213: ,p_agf_attribute30_o =>ben_agf_shd.g_old_rec.agf_attribute30
214: ,p_object_version_number_o =>ben_agf_shd.g_old_rec.object_version_number
215: );
208: ,p_agf_attribute25_o =>ben_agf_shd.g_old_rec.agf_attribute25
209: ,p_agf_attribute26_o =>ben_agf_shd.g_old_rec.agf_attribute26
210: ,p_agf_attribute27_o =>ben_agf_shd.g_old_rec.agf_attribute27
211: ,p_agf_attribute28_o =>ben_agf_shd.g_old_rec.agf_attribute28
212: ,p_agf_attribute29_o =>ben_agf_shd.g_old_rec.agf_attribute29
213: ,p_agf_attribute30_o =>ben_agf_shd.g_old_rec.agf_attribute30
214: ,p_object_version_number_o =>ben_agf_shd.g_old_rec.object_version_number
215: );
216: --
209: ,p_agf_attribute26_o =>ben_agf_shd.g_old_rec.agf_attribute26
210: ,p_agf_attribute27_o =>ben_agf_shd.g_old_rec.agf_attribute27
211: ,p_agf_attribute28_o =>ben_agf_shd.g_old_rec.agf_attribute28
212: ,p_agf_attribute29_o =>ben_agf_shd.g_old_rec.agf_attribute29
213: ,p_agf_attribute30_o =>ben_agf_shd.g_old_rec.agf_attribute30
214: ,p_object_version_number_o =>ben_agf_shd.g_old_rec.object_version_number
215: );
216: --
217: exception
210: ,p_agf_attribute27_o =>ben_agf_shd.g_old_rec.agf_attribute27
211: ,p_agf_attribute28_o =>ben_agf_shd.g_old_rec.agf_attribute28
212: ,p_agf_attribute29_o =>ben_agf_shd.g_old_rec.agf_attribute29
213: ,p_agf_attribute30_o =>ben_agf_shd.g_old_rec.agf_attribute30
214: ,p_object_version_number_o =>ben_agf_shd.g_old_rec.object_version_number
215: );
216: --
217: exception
218: --
235: -- ----------------------------------------------------------------------------
236: Procedure del
237: (
238: p_effective_date in date,
239: p_rec in ben_agf_shd.g_rec_type
240: ) is
241: --
242: l_proc varchar2(72) := g_package||'del';
243: --
245: hr_utility.set_location('Entering:'||l_proc, 5);
246: --
247: -- We must lock the row which we need to delete.
248: --
249: ben_agf_shd.lck
250: (
251: p_rec.age_fctr_id,
252: p_rec.object_version_number
253: );
280: p_age_fctr_id in number,
281: p_object_version_number in number
282: ) is
283: --
284: l_rec ben_agf_shd.g_rec_type;
285: l_proc varchar2(72) := g_package||'del';
286: --
287: Begin
288: hr_utility.set_location('Entering:'||l_proc, 5);