eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_AGF_DEL dependencies on BEN_AGF_SHD

Line 51: Procedure delete_dml(p_rec in ben_agf_shd.g_rec_type) is

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

Line 58: ben_agf_shd.g_api_dml := true; -- Set the api dml status

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

Line 65: ben_agf_shd.g_api_dml := false; -- Unset the api dml status

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

Line 72: ben_agf_shd.g_api_dml := false; -- Unset the api dml status

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

Line 73: ben_agf_shd.constraint_error

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;

Line 76: ben_agf_shd.g_api_dml := false; -- Unset the api dml status

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: -- ----------------------------------------------------------------------------

Line 112: Procedure pre_delete(p_rec in ben_agf_shd.g_rec_type) is

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

Line 155: p_effective_date in date,p_rec in ben_agf_shd.g_rec_type) is

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

Line 170: ,p_name_o =>ben_agf_shd.g_old_rec.name

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

Line 171: ,p_mx_age_num_o =>ben_agf_shd.g_old_rec.mx_age_num

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

Line 172: ,p_mn_age_num_o =>ben_agf_shd.g_old_rec.mn_age_num

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

Line 173: ,p_age_uom_o =>ben_agf_shd.g_old_rec.age_uom

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

Line 174: ,p_no_mn_age_flag_o =>ben_agf_shd.g_old_rec.no_mn_age_flag

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

Line 175: ,p_no_mx_age_flag_o =>ben_agf_shd.g_old_rec.no_mx_age_flag

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

Line 176: ,p_age_to_use_cd_o =>ben_agf_shd.g_old_rec.age_to_use_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

Line 177: ,p_age_det_cd_o =>ben_agf_shd.g_old_rec.age_det_cd

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

Line 178: ,p_age_det_rl_o =>ben_agf_shd.g_old_rec.age_det_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

Line 179: ,p_rndg_cd_o =>ben_agf_shd.g_old_rec.rndg_cd

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

Line 180: ,p_rndg_rl_o =>ben_agf_shd.g_old_rec.rndg_rl

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

Line 181: ,p_age_calc_rl_o =>ben_agf_shd.g_old_rec.age_calc_rl

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

Line 182: ,p_business_group_id_o =>ben_agf_shd.g_old_rec.business_group_id

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

Line 183: ,p_agf_attribute_category_o =>ben_agf_shd.g_old_rec.agf_attribute_category

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

Line 184: ,p_agf_attribute1_o =>ben_agf_shd.g_old_rec.agf_attribute1

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

Line 185: ,p_agf_attribute2_o =>ben_agf_shd.g_old_rec.agf_attribute2

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

Line 186: ,p_agf_attribute3_o =>ben_agf_shd.g_old_rec.agf_attribute3

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

Line 187: ,p_agf_attribute4_o =>ben_agf_shd.g_old_rec.agf_attribute4

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

Line 188: ,p_agf_attribute5_o =>ben_agf_shd.g_old_rec.agf_attribute5

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

Line 189: ,p_agf_attribute6_o =>ben_agf_shd.g_old_rec.agf_attribute6

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

Line 190: ,p_agf_attribute7_o =>ben_agf_shd.g_old_rec.agf_attribute7

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

Line 191: ,p_agf_attribute8_o =>ben_agf_shd.g_old_rec.agf_attribute8

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

Line 192: ,p_agf_attribute9_o =>ben_agf_shd.g_old_rec.agf_attribute9

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

Line 193: ,p_agf_attribute10_o =>ben_agf_shd.g_old_rec.agf_attribute10

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

Line 194: ,p_agf_attribute11_o =>ben_agf_shd.g_old_rec.agf_attribute11

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

Line 195: ,p_agf_attribute12_o =>ben_agf_shd.g_old_rec.agf_attribute12

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

Line 196: ,p_agf_attribute13_o =>ben_agf_shd.g_old_rec.agf_attribute13

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

Line 197: ,p_agf_attribute14_o =>ben_agf_shd.g_old_rec.agf_attribute14

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

Line 198: ,p_agf_attribute15_o =>ben_agf_shd.g_old_rec.agf_attribute15

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

Line 199: ,p_agf_attribute16_o =>ben_agf_shd.g_old_rec.agf_attribute16

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

Line 200: ,p_agf_attribute17_o =>ben_agf_shd.g_old_rec.agf_attribute17

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

Line 201: ,p_agf_attribute18_o =>ben_agf_shd.g_old_rec.agf_attribute18

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

Line 202: ,p_agf_attribute19_o =>ben_agf_shd.g_old_rec.agf_attribute19

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

Line 203: ,p_agf_attribute20_o =>ben_agf_shd.g_old_rec.agf_attribute20

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

Line 204: ,p_agf_attribute21_o =>ben_agf_shd.g_old_rec.agf_attribute21

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

Line 205: ,p_agf_attribute22_o =>ben_agf_shd.g_old_rec.agf_attribute22

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

Line 206: ,p_agf_attribute23_o =>ben_agf_shd.g_old_rec.agf_attribute23

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

Line 207: ,p_agf_attribute24_o =>ben_agf_shd.g_old_rec.agf_attribute24

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

Line 208: ,p_agf_attribute25_o =>ben_agf_shd.g_old_rec.agf_attribute25

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

Line 209: ,p_agf_attribute26_o =>ben_agf_shd.g_old_rec.agf_attribute26

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

Line 210: ,p_agf_attribute27_o =>ben_agf_shd.g_old_rec.agf_attribute27

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

Line 211: ,p_agf_attribute28_o =>ben_agf_shd.g_old_rec.agf_attribute28

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: );

Line 212: ,p_agf_attribute29_o =>ben_agf_shd.g_old_rec.agf_attribute29

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: --

Line 213: ,p_agf_attribute30_o =>ben_agf_shd.g_old_rec.agf_attribute30

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

Line 214: ,p_object_version_number_o =>ben_agf_shd.g_old_rec.object_version_number

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: --

Line 239: p_rec in ben_agf_shd.g_rec_type

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: --

Line 249: ben_agf_shd.lck

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: );

Line 284: l_rec ben_agf_shd.g_rec_type;

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);