41: -- Internal Table Handler Use Only.
42: --
43: -- {End Of Comments}
44: -- ----------------------------------------------------------------------------
45: Procedure delete_dml(p_rec in per_rsc_shd.g_rec_type) is
46: --
47: l_proc varchar2(72) := g_package||'delete_dml';
48: --
49: Begin
60: --
61: Exception
62: When hr_api.child_integrity_violated then
63: -- Child integrity has been violated
64: per_rsc_shd.constraint_error
65: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
66: When Others Then
67: Raise;
68: End delete_dml;
98: -- Internal Table Handler Use Only.
99: --
100: -- {End Of Comments}
101: -- ----------------------------------------------------------------------------
102: Procedure pre_delete(p_rec in per_rsc_shd.g_rec_type) is
103: --
104: l_proc varchar2(72) := g_package||'pre_delete';
105: --
106: Begin
140: -- Internal table Handler Use Only.
141: --
142: -- {End Of Comments}
143: -- ----------------------------------------------------------------------------
144: Procedure post_delete(p_rec in per_rsc_shd.g_rec_type) is
145: --
146: l_proc varchar2(72) := g_package||'post_delete';
147: --
148: Begin
152: --
153: begin
154: per_rsc_rkd.after_delete (
155: p_rating_scale_id => p_rec.rating_scale_id ,
156: p_business_group_id_o => per_rsc_shd.g_old_rec.business_group_id ,
157: p_object_version_number_o => per_rsc_shd.g_old_rec.object_version_number,
158: p_name_o => per_rsc_shd.g_old_rec.name ,
159: p_type_o => per_rsc_shd.g_old_rec.type ,
160: p_description_o => per_rsc_shd.g_old_rec.description ,
153: begin
154: per_rsc_rkd.after_delete (
155: p_rating_scale_id => p_rec.rating_scale_id ,
156: p_business_group_id_o => per_rsc_shd.g_old_rec.business_group_id ,
157: p_object_version_number_o => per_rsc_shd.g_old_rec.object_version_number,
158: p_name_o => per_rsc_shd.g_old_rec.name ,
159: p_type_o => per_rsc_shd.g_old_rec.type ,
160: p_description_o => per_rsc_shd.g_old_rec.description ,
161: p_default_flag_o => per_rsc_shd.g_old_rec.default_flag ,
154: per_rsc_rkd.after_delete (
155: p_rating_scale_id => p_rec.rating_scale_id ,
156: p_business_group_id_o => per_rsc_shd.g_old_rec.business_group_id ,
157: p_object_version_number_o => per_rsc_shd.g_old_rec.object_version_number,
158: p_name_o => per_rsc_shd.g_old_rec.name ,
159: p_type_o => per_rsc_shd.g_old_rec.type ,
160: p_description_o => per_rsc_shd.g_old_rec.description ,
161: p_default_flag_o => per_rsc_shd.g_old_rec.default_flag ,
162: p_max_scale_step_o => per_rsc_shd.g_old_rec.max_scale_step ,
155: p_rating_scale_id => p_rec.rating_scale_id ,
156: p_business_group_id_o => per_rsc_shd.g_old_rec.business_group_id ,
157: p_object_version_number_o => per_rsc_shd.g_old_rec.object_version_number,
158: p_name_o => per_rsc_shd.g_old_rec.name ,
159: p_type_o => per_rsc_shd.g_old_rec.type ,
160: p_description_o => per_rsc_shd.g_old_rec.description ,
161: p_default_flag_o => per_rsc_shd.g_old_rec.default_flag ,
162: p_max_scale_step_o => per_rsc_shd.g_old_rec.max_scale_step ,
163: p_min_scale_step_o => per_rsc_shd.g_old_rec.min_scale_step ,
156: p_business_group_id_o => per_rsc_shd.g_old_rec.business_group_id ,
157: p_object_version_number_o => per_rsc_shd.g_old_rec.object_version_number,
158: p_name_o => per_rsc_shd.g_old_rec.name ,
159: p_type_o => per_rsc_shd.g_old_rec.type ,
160: p_description_o => per_rsc_shd.g_old_rec.description ,
161: p_default_flag_o => per_rsc_shd.g_old_rec.default_flag ,
162: p_max_scale_step_o => per_rsc_shd.g_old_rec.max_scale_step ,
163: p_min_scale_step_o => per_rsc_shd.g_old_rec.min_scale_step ,
164: p_attribute_category_o => per_rsc_shd.g_old_rec.attribute_category ,
157: p_object_version_number_o => per_rsc_shd.g_old_rec.object_version_number,
158: p_name_o => per_rsc_shd.g_old_rec.name ,
159: p_type_o => per_rsc_shd.g_old_rec.type ,
160: p_description_o => per_rsc_shd.g_old_rec.description ,
161: p_default_flag_o => per_rsc_shd.g_old_rec.default_flag ,
162: p_max_scale_step_o => per_rsc_shd.g_old_rec.max_scale_step ,
163: p_min_scale_step_o => per_rsc_shd.g_old_rec.min_scale_step ,
164: p_attribute_category_o => per_rsc_shd.g_old_rec.attribute_category ,
165: p_attribute1_o => per_rsc_shd.g_old_rec.attribute1 ,
158: p_name_o => per_rsc_shd.g_old_rec.name ,
159: p_type_o => per_rsc_shd.g_old_rec.type ,
160: p_description_o => per_rsc_shd.g_old_rec.description ,
161: p_default_flag_o => per_rsc_shd.g_old_rec.default_flag ,
162: p_max_scale_step_o => per_rsc_shd.g_old_rec.max_scale_step ,
163: p_min_scale_step_o => per_rsc_shd.g_old_rec.min_scale_step ,
164: p_attribute_category_o => per_rsc_shd.g_old_rec.attribute_category ,
165: p_attribute1_o => per_rsc_shd.g_old_rec.attribute1 ,
166: p_attribute2_o => per_rsc_shd.g_old_rec.attribute2 ,
159: p_type_o => per_rsc_shd.g_old_rec.type ,
160: p_description_o => per_rsc_shd.g_old_rec.description ,
161: p_default_flag_o => per_rsc_shd.g_old_rec.default_flag ,
162: p_max_scale_step_o => per_rsc_shd.g_old_rec.max_scale_step ,
163: p_min_scale_step_o => per_rsc_shd.g_old_rec.min_scale_step ,
164: p_attribute_category_o => per_rsc_shd.g_old_rec.attribute_category ,
165: p_attribute1_o => per_rsc_shd.g_old_rec.attribute1 ,
166: p_attribute2_o => per_rsc_shd.g_old_rec.attribute2 ,
167: p_attribute3_o => per_rsc_shd.g_old_rec.attribute3 ,
160: p_description_o => per_rsc_shd.g_old_rec.description ,
161: p_default_flag_o => per_rsc_shd.g_old_rec.default_flag ,
162: p_max_scale_step_o => per_rsc_shd.g_old_rec.max_scale_step ,
163: p_min_scale_step_o => per_rsc_shd.g_old_rec.min_scale_step ,
164: p_attribute_category_o => per_rsc_shd.g_old_rec.attribute_category ,
165: p_attribute1_o => per_rsc_shd.g_old_rec.attribute1 ,
166: p_attribute2_o => per_rsc_shd.g_old_rec.attribute2 ,
167: p_attribute3_o => per_rsc_shd.g_old_rec.attribute3 ,
168: p_attribute4_o => per_rsc_shd.g_old_rec.attribute4 ,
161: p_default_flag_o => per_rsc_shd.g_old_rec.default_flag ,
162: p_max_scale_step_o => per_rsc_shd.g_old_rec.max_scale_step ,
163: p_min_scale_step_o => per_rsc_shd.g_old_rec.min_scale_step ,
164: p_attribute_category_o => per_rsc_shd.g_old_rec.attribute_category ,
165: p_attribute1_o => per_rsc_shd.g_old_rec.attribute1 ,
166: p_attribute2_o => per_rsc_shd.g_old_rec.attribute2 ,
167: p_attribute3_o => per_rsc_shd.g_old_rec.attribute3 ,
168: p_attribute4_o => per_rsc_shd.g_old_rec.attribute4 ,
169: p_attribute5_o => per_rsc_shd.g_old_rec.attribute5 ,
162: p_max_scale_step_o => per_rsc_shd.g_old_rec.max_scale_step ,
163: p_min_scale_step_o => per_rsc_shd.g_old_rec.min_scale_step ,
164: p_attribute_category_o => per_rsc_shd.g_old_rec.attribute_category ,
165: p_attribute1_o => per_rsc_shd.g_old_rec.attribute1 ,
166: p_attribute2_o => per_rsc_shd.g_old_rec.attribute2 ,
167: p_attribute3_o => per_rsc_shd.g_old_rec.attribute3 ,
168: p_attribute4_o => per_rsc_shd.g_old_rec.attribute4 ,
169: p_attribute5_o => per_rsc_shd.g_old_rec.attribute5 ,
170: p_attribute6_o => per_rsc_shd.g_old_rec.attribute6 ,
163: p_min_scale_step_o => per_rsc_shd.g_old_rec.min_scale_step ,
164: p_attribute_category_o => per_rsc_shd.g_old_rec.attribute_category ,
165: p_attribute1_o => per_rsc_shd.g_old_rec.attribute1 ,
166: p_attribute2_o => per_rsc_shd.g_old_rec.attribute2 ,
167: p_attribute3_o => per_rsc_shd.g_old_rec.attribute3 ,
168: p_attribute4_o => per_rsc_shd.g_old_rec.attribute4 ,
169: p_attribute5_o => per_rsc_shd.g_old_rec.attribute5 ,
170: p_attribute6_o => per_rsc_shd.g_old_rec.attribute6 ,
171: p_attribute7_o => per_rsc_shd.g_old_rec.attribute7 ,
164: p_attribute_category_o => per_rsc_shd.g_old_rec.attribute_category ,
165: p_attribute1_o => per_rsc_shd.g_old_rec.attribute1 ,
166: p_attribute2_o => per_rsc_shd.g_old_rec.attribute2 ,
167: p_attribute3_o => per_rsc_shd.g_old_rec.attribute3 ,
168: p_attribute4_o => per_rsc_shd.g_old_rec.attribute4 ,
169: p_attribute5_o => per_rsc_shd.g_old_rec.attribute5 ,
170: p_attribute6_o => per_rsc_shd.g_old_rec.attribute6 ,
171: p_attribute7_o => per_rsc_shd.g_old_rec.attribute7 ,
172: p_attribute8_o => per_rsc_shd.g_old_rec.attribute8 ,
165: p_attribute1_o => per_rsc_shd.g_old_rec.attribute1 ,
166: p_attribute2_o => per_rsc_shd.g_old_rec.attribute2 ,
167: p_attribute3_o => per_rsc_shd.g_old_rec.attribute3 ,
168: p_attribute4_o => per_rsc_shd.g_old_rec.attribute4 ,
169: p_attribute5_o => per_rsc_shd.g_old_rec.attribute5 ,
170: p_attribute6_o => per_rsc_shd.g_old_rec.attribute6 ,
171: p_attribute7_o => per_rsc_shd.g_old_rec.attribute7 ,
172: p_attribute8_o => per_rsc_shd.g_old_rec.attribute8 ,
173: p_attribute9_o => per_rsc_shd.g_old_rec.attribute9 ,
166: p_attribute2_o => per_rsc_shd.g_old_rec.attribute2 ,
167: p_attribute3_o => per_rsc_shd.g_old_rec.attribute3 ,
168: p_attribute4_o => per_rsc_shd.g_old_rec.attribute4 ,
169: p_attribute5_o => per_rsc_shd.g_old_rec.attribute5 ,
170: p_attribute6_o => per_rsc_shd.g_old_rec.attribute6 ,
171: p_attribute7_o => per_rsc_shd.g_old_rec.attribute7 ,
172: p_attribute8_o => per_rsc_shd.g_old_rec.attribute8 ,
173: p_attribute9_o => per_rsc_shd.g_old_rec.attribute9 ,
174: p_attribute10_o => per_rsc_shd.g_old_rec.attribute10 ,
167: p_attribute3_o => per_rsc_shd.g_old_rec.attribute3 ,
168: p_attribute4_o => per_rsc_shd.g_old_rec.attribute4 ,
169: p_attribute5_o => per_rsc_shd.g_old_rec.attribute5 ,
170: p_attribute6_o => per_rsc_shd.g_old_rec.attribute6 ,
171: p_attribute7_o => per_rsc_shd.g_old_rec.attribute7 ,
172: p_attribute8_o => per_rsc_shd.g_old_rec.attribute8 ,
173: p_attribute9_o => per_rsc_shd.g_old_rec.attribute9 ,
174: p_attribute10_o => per_rsc_shd.g_old_rec.attribute10 ,
175: p_attribute11_o => per_rsc_shd.g_old_rec.attribute11 ,
168: p_attribute4_o => per_rsc_shd.g_old_rec.attribute4 ,
169: p_attribute5_o => per_rsc_shd.g_old_rec.attribute5 ,
170: p_attribute6_o => per_rsc_shd.g_old_rec.attribute6 ,
171: p_attribute7_o => per_rsc_shd.g_old_rec.attribute7 ,
172: p_attribute8_o => per_rsc_shd.g_old_rec.attribute8 ,
173: p_attribute9_o => per_rsc_shd.g_old_rec.attribute9 ,
174: p_attribute10_o => per_rsc_shd.g_old_rec.attribute10 ,
175: p_attribute11_o => per_rsc_shd.g_old_rec.attribute11 ,
176: p_attribute12_o => per_rsc_shd.g_old_rec.attribute12 ,
169: p_attribute5_o => per_rsc_shd.g_old_rec.attribute5 ,
170: p_attribute6_o => per_rsc_shd.g_old_rec.attribute6 ,
171: p_attribute7_o => per_rsc_shd.g_old_rec.attribute7 ,
172: p_attribute8_o => per_rsc_shd.g_old_rec.attribute8 ,
173: p_attribute9_o => per_rsc_shd.g_old_rec.attribute9 ,
174: p_attribute10_o => per_rsc_shd.g_old_rec.attribute10 ,
175: p_attribute11_o => per_rsc_shd.g_old_rec.attribute11 ,
176: p_attribute12_o => per_rsc_shd.g_old_rec.attribute12 ,
177: p_attribute13_o => per_rsc_shd.g_old_rec.attribute13 ,
170: p_attribute6_o => per_rsc_shd.g_old_rec.attribute6 ,
171: p_attribute7_o => per_rsc_shd.g_old_rec.attribute7 ,
172: p_attribute8_o => per_rsc_shd.g_old_rec.attribute8 ,
173: p_attribute9_o => per_rsc_shd.g_old_rec.attribute9 ,
174: p_attribute10_o => per_rsc_shd.g_old_rec.attribute10 ,
175: p_attribute11_o => per_rsc_shd.g_old_rec.attribute11 ,
176: p_attribute12_o => per_rsc_shd.g_old_rec.attribute12 ,
177: p_attribute13_o => per_rsc_shd.g_old_rec.attribute13 ,
178: p_attribute14_o => per_rsc_shd.g_old_rec.attribute14 ,
171: p_attribute7_o => per_rsc_shd.g_old_rec.attribute7 ,
172: p_attribute8_o => per_rsc_shd.g_old_rec.attribute8 ,
173: p_attribute9_o => per_rsc_shd.g_old_rec.attribute9 ,
174: p_attribute10_o => per_rsc_shd.g_old_rec.attribute10 ,
175: p_attribute11_o => per_rsc_shd.g_old_rec.attribute11 ,
176: p_attribute12_o => per_rsc_shd.g_old_rec.attribute12 ,
177: p_attribute13_o => per_rsc_shd.g_old_rec.attribute13 ,
178: p_attribute14_o => per_rsc_shd.g_old_rec.attribute14 ,
179: p_attribute15_o => per_rsc_shd.g_old_rec.attribute15 ,
172: p_attribute8_o => per_rsc_shd.g_old_rec.attribute8 ,
173: p_attribute9_o => per_rsc_shd.g_old_rec.attribute9 ,
174: p_attribute10_o => per_rsc_shd.g_old_rec.attribute10 ,
175: p_attribute11_o => per_rsc_shd.g_old_rec.attribute11 ,
176: p_attribute12_o => per_rsc_shd.g_old_rec.attribute12 ,
177: p_attribute13_o => per_rsc_shd.g_old_rec.attribute13 ,
178: p_attribute14_o => per_rsc_shd.g_old_rec.attribute14 ,
179: p_attribute15_o => per_rsc_shd.g_old_rec.attribute15 ,
180: p_attribute16_o => per_rsc_shd.g_old_rec.attribute16 ,
173: p_attribute9_o => per_rsc_shd.g_old_rec.attribute9 ,
174: p_attribute10_o => per_rsc_shd.g_old_rec.attribute10 ,
175: p_attribute11_o => per_rsc_shd.g_old_rec.attribute11 ,
176: p_attribute12_o => per_rsc_shd.g_old_rec.attribute12 ,
177: p_attribute13_o => per_rsc_shd.g_old_rec.attribute13 ,
178: p_attribute14_o => per_rsc_shd.g_old_rec.attribute14 ,
179: p_attribute15_o => per_rsc_shd.g_old_rec.attribute15 ,
180: p_attribute16_o => per_rsc_shd.g_old_rec.attribute16 ,
181: p_attribute17_o => per_rsc_shd.g_old_rec.attribute17 ,
174: p_attribute10_o => per_rsc_shd.g_old_rec.attribute10 ,
175: p_attribute11_o => per_rsc_shd.g_old_rec.attribute11 ,
176: p_attribute12_o => per_rsc_shd.g_old_rec.attribute12 ,
177: p_attribute13_o => per_rsc_shd.g_old_rec.attribute13 ,
178: p_attribute14_o => per_rsc_shd.g_old_rec.attribute14 ,
179: p_attribute15_o => per_rsc_shd.g_old_rec.attribute15 ,
180: p_attribute16_o => per_rsc_shd.g_old_rec.attribute16 ,
181: p_attribute17_o => per_rsc_shd.g_old_rec.attribute17 ,
182: p_attribute18_o => per_rsc_shd.g_old_rec.attribute18 ,
175: p_attribute11_o => per_rsc_shd.g_old_rec.attribute11 ,
176: p_attribute12_o => per_rsc_shd.g_old_rec.attribute12 ,
177: p_attribute13_o => per_rsc_shd.g_old_rec.attribute13 ,
178: p_attribute14_o => per_rsc_shd.g_old_rec.attribute14 ,
179: p_attribute15_o => per_rsc_shd.g_old_rec.attribute15 ,
180: p_attribute16_o => per_rsc_shd.g_old_rec.attribute16 ,
181: p_attribute17_o => per_rsc_shd.g_old_rec.attribute17 ,
182: p_attribute18_o => per_rsc_shd.g_old_rec.attribute18 ,
183: p_attribute19_o => per_rsc_shd.g_old_rec.attribute19 ,
176: p_attribute12_o => per_rsc_shd.g_old_rec.attribute12 ,
177: p_attribute13_o => per_rsc_shd.g_old_rec.attribute13 ,
178: p_attribute14_o => per_rsc_shd.g_old_rec.attribute14 ,
179: p_attribute15_o => per_rsc_shd.g_old_rec.attribute15 ,
180: p_attribute16_o => per_rsc_shd.g_old_rec.attribute16 ,
181: p_attribute17_o => per_rsc_shd.g_old_rec.attribute17 ,
182: p_attribute18_o => per_rsc_shd.g_old_rec.attribute18 ,
183: p_attribute19_o => per_rsc_shd.g_old_rec.attribute19 ,
184: p_attribute20_o => per_rsc_shd.g_old_rec.attribute20 );
177: p_attribute13_o => per_rsc_shd.g_old_rec.attribute13 ,
178: p_attribute14_o => per_rsc_shd.g_old_rec.attribute14 ,
179: p_attribute15_o => per_rsc_shd.g_old_rec.attribute15 ,
180: p_attribute16_o => per_rsc_shd.g_old_rec.attribute16 ,
181: p_attribute17_o => per_rsc_shd.g_old_rec.attribute17 ,
182: p_attribute18_o => per_rsc_shd.g_old_rec.attribute18 ,
183: p_attribute19_o => per_rsc_shd.g_old_rec.attribute19 ,
184: p_attribute20_o => per_rsc_shd.g_old_rec.attribute20 );
185:
178: p_attribute14_o => per_rsc_shd.g_old_rec.attribute14 ,
179: p_attribute15_o => per_rsc_shd.g_old_rec.attribute15 ,
180: p_attribute16_o => per_rsc_shd.g_old_rec.attribute16 ,
181: p_attribute17_o => per_rsc_shd.g_old_rec.attribute17 ,
182: p_attribute18_o => per_rsc_shd.g_old_rec.attribute18 ,
183: p_attribute19_o => per_rsc_shd.g_old_rec.attribute19 ,
184: p_attribute20_o => per_rsc_shd.g_old_rec.attribute20 );
185:
186: exception
179: p_attribute15_o => per_rsc_shd.g_old_rec.attribute15 ,
180: p_attribute16_o => per_rsc_shd.g_old_rec.attribute16 ,
181: p_attribute17_o => per_rsc_shd.g_old_rec.attribute17 ,
182: p_attribute18_o => per_rsc_shd.g_old_rec.attribute18 ,
183: p_attribute19_o => per_rsc_shd.g_old_rec.attribute19 ,
184: p_attribute20_o => per_rsc_shd.g_old_rec.attribute20 );
185:
186: exception
187: when hr_api.cannot_find_prog_unit then
180: p_attribute16_o => per_rsc_shd.g_old_rec.attribute16 ,
181: p_attribute17_o => per_rsc_shd.g_old_rec.attribute17 ,
182: p_attribute18_o => per_rsc_shd.g_old_rec.attribute18 ,
183: p_attribute19_o => per_rsc_shd.g_old_rec.attribute19 ,
184: p_attribute20_o => per_rsc_shd.g_old_rec.attribute20 );
185:
186: exception
187: when hr_api.cannot_find_prog_unit then
188: hr_api.cannot_find_prog_unit_error
199: -- |---------------------------------< del >----------------------------------|
200: -- ----------------------------------------------------------------------------
201: Procedure del
202: (
203: p_rec in per_rsc_shd.g_rec_type,
204: p_validate in boolean default false
205: ) is
206: --
207: l_proc varchar2(72) := g_package||'del';
219: End If;
220: --
221: -- We must lock the row which we need to delete.
222: --
223: per_rsc_shd.lck
224: (
225: p_rec.rating_scale_id,
226: p_rec.object_version_number
227: );
267: p_object_version_number in number,
268: p_validate in boolean default false
269: ) is
270: --
271: l_rec per_rsc_shd.g_rec_type;
272: l_proc varchar2(72) := g_package||'del';
273: --
274: Begin
275: hr_utility.set_location('Entering:'||l_proc, 5);