47: -- Internal Table Handler Use Only.
48:
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------+
51: Procedure delete_dml(p_rec in per_prt_shd.g_rec_type) is
52:
53: l_proc varchar2(72) := g_package||'delete_dml';
54:
55: Begin
64:
65: Exception
66: When hr_api.child_integrity_violated then
67: -- Child integrity has been violated
68: per_prt_shd.constraint_error
69: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
70: When Others Then
71: Raise;
72: End delete_dml;
102: -- Internal Table Handler Use Only.
103:
104: -- {End Of Comments}
105: -- ---------------------------------------------------------------------------+
106: Procedure pre_delete(p_rec in per_prt_shd.g_rec_type) is
107:
108: l_proc varchar2(72) := g_package||'pre_delete';
109:
110: Begin
144: -- Internal table Handler Use Only.
145:
146: -- {End Of Comments}
147: -- ----------------------------------------------------------------------------
148: Procedure post_delete(p_rec in per_prt_shd.g_rec_type) is
149:
150: l_proc varchar2(72) := g_package||'post_delete';
151:
152: Begin
157: begin
158: per_prt_rkd.after_delete (
159: p_performance_rating_id => p_rec.performance_rating_id ,
160: p_person_id_o => p_rec.person_id,
161: p_objective_id_o => per_prt_shd.g_old_rec.objective_id ,
162: p_object_version_number_o => per_prt_shd.g_old_rec.object_version_number,
163: p_appraisal_id_o => per_prt_shd.g_old_rec.appraisal_id ,
164: p_performance_level_id_o => per_prt_shd.g_old_rec.performance_level_id ,
165: p_comments_o => per_prt_shd.g_old_rec.comments ,
158: per_prt_rkd.after_delete (
159: p_performance_rating_id => p_rec.performance_rating_id ,
160: p_person_id_o => p_rec.person_id,
161: p_objective_id_o => per_prt_shd.g_old_rec.objective_id ,
162: p_object_version_number_o => per_prt_shd.g_old_rec.object_version_number,
163: p_appraisal_id_o => per_prt_shd.g_old_rec.appraisal_id ,
164: p_performance_level_id_o => per_prt_shd.g_old_rec.performance_level_id ,
165: p_comments_o => per_prt_shd.g_old_rec.comments ,
166: p_attribute_category_o => per_prt_shd.g_old_rec.attribute_category ,
159: p_performance_rating_id => p_rec.performance_rating_id ,
160: p_person_id_o => p_rec.person_id,
161: p_objective_id_o => per_prt_shd.g_old_rec.objective_id ,
162: p_object_version_number_o => per_prt_shd.g_old_rec.object_version_number,
163: p_appraisal_id_o => per_prt_shd.g_old_rec.appraisal_id ,
164: p_performance_level_id_o => per_prt_shd.g_old_rec.performance_level_id ,
165: p_comments_o => per_prt_shd.g_old_rec.comments ,
166: p_attribute_category_o => per_prt_shd.g_old_rec.attribute_category ,
167: p_attribute1_o => per_prt_shd.g_old_rec.attribute1 ,
160: p_person_id_o => p_rec.person_id,
161: p_objective_id_o => per_prt_shd.g_old_rec.objective_id ,
162: p_object_version_number_o => per_prt_shd.g_old_rec.object_version_number,
163: p_appraisal_id_o => per_prt_shd.g_old_rec.appraisal_id ,
164: p_performance_level_id_o => per_prt_shd.g_old_rec.performance_level_id ,
165: p_comments_o => per_prt_shd.g_old_rec.comments ,
166: p_attribute_category_o => per_prt_shd.g_old_rec.attribute_category ,
167: p_attribute1_o => per_prt_shd.g_old_rec.attribute1 ,
168: p_attribute2_o => per_prt_shd.g_old_rec.attribute2 ,
161: p_objective_id_o => per_prt_shd.g_old_rec.objective_id ,
162: p_object_version_number_o => per_prt_shd.g_old_rec.object_version_number,
163: p_appraisal_id_o => per_prt_shd.g_old_rec.appraisal_id ,
164: p_performance_level_id_o => per_prt_shd.g_old_rec.performance_level_id ,
165: p_comments_o => per_prt_shd.g_old_rec.comments ,
166: p_attribute_category_o => per_prt_shd.g_old_rec.attribute_category ,
167: p_attribute1_o => per_prt_shd.g_old_rec.attribute1 ,
168: p_attribute2_o => per_prt_shd.g_old_rec.attribute2 ,
169: p_attribute3_o => per_prt_shd.g_old_rec.attribute3 ,
162: p_object_version_number_o => per_prt_shd.g_old_rec.object_version_number,
163: p_appraisal_id_o => per_prt_shd.g_old_rec.appraisal_id ,
164: p_performance_level_id_o => per_prt_shd.g_old_rec.performance_level_id ,
165: p_comments_o => per_prt_shd.g_old_rec.comments ,
166: p_attribute_category_o => per_prt_shd.g_old_rec.attribute_category ,
167: p_attribute1_o => per_prt_shd.g_old_rec.attribute1 ,
168: p_attribute2_o => per_prt_shd.g_old_rec.attribute2 ,
169: p_attribute3_o => per_prt_shd.g_old_rec.attribute3 ,
170: p_attribute4_o => per_prt_shd.g_old_rec.attribute4 ,
163: p_appraisal_id_o => per_prt_shd.g_old_rec.appraisal_id ,
164: p_performance_level_id_o => per_prt_shd.g_old_rec.performance_level_id ,
165: p_comments_o => per_prt_shd.g_old_rec.comments ,
166: p_attribute_category_o => per_prt_shd.g_old_rec.attribute_category ,
167: p_attribute1_o => per_prt_shd.g_old_rec.attribute1 ,
168: p_attribute2_o => per_prt_shd.g_old_rec.attribute2 ,
169: p_attribute3_o => per_prt_shd.g_old_rec.attribute3 ,
170: p_attribute4_o => per_prt_shd.g_old_rec.attribute4 ,
171: p_attribute5_o => per_prt_shd.g_old_rec.attribute5 ,
164: p_performance_level_id_o => per_prt_shd.g_old_rec.performance_level_id ,
165: p_comments_o => per_prt_shd.g_old_rec.comments ,
166: p_attribute_category_o => per_prt_shd.g_old_rec.attribute_category ,
167: p_attribute1_o => per_prt_shd.g_old_rec.attribute1 ,
168: p_attribute2_o => per_prt_shd.g_old_rec.attribute2 ,
169: p_attribute3_o => per_prt_shd.g_old_rec.attribute3 ,
170: p_attribute4_o => per_prt_shd.g_old_rec.attribute4 ,
171: p_attribute5_o => per_prt_shd.g_old_rec.attribute5 ,
172: p_attribute6_o => per_prt_shd.g_old_rec.attribute6 ,
165: p_comments_o => per_prt_shd.g_old_rec.comments ,
166: p_attribute_category_o => per_prt_shd.g_old_rec.attribute_category ,
167: p_attribute1_o => per_prt_shd.g_old_rec.attribute1 ,
168: p_attribute2_o => per_prt_shd.g_old_rec.attribute2 ,
169: p_attribute3_o => per_prt_shd.g_old_rec.attribute3 ,
170: p_attribute4_o => per_prt_shd.g_old_rec.attribute4 ,
171: p_attribute5_o => per_prt_shd.g_old_rec.attribute5 ,
172: p_attribute6_o => per_prt_shd.g_old_rec.attribute6 ,
173: p_attribute7_o => per_prt_shd.g_old_rec.attribute7 ,
166: p_attribute_category_o => per_prt_shd.g_old_rec.attribute_category ,
167: p_attribute1_o => per_prt_shd.g_old_rec.attribute1 ,
168: p_attribute2_o => per_prt_shd.g_old_rec.attribute2 ,
169: p_attribute3_o => per_prt_shd.g_old_rec.attribute3 ,
170: p_attribute4_o => per_prt_shd.g_old_rec.attribute4 ,
171: p_attribute5_o => per_prt_shd.g_old_rec.attribute5 ,
172: p_attribute6_o => per_prt_shd.g_old_rec.attribute6 ,
173: p_attribute7_o => per_prt_shd.g_old_rec.attribute7 ,
174: p_attribute8_o => per_prt_shd.g_old_rec.attribute8 ,
167: p_attribute1_o => per_prt_shd.g_old_rec.attribute1 ,
168: p_attribute2_o => per_prt_shd.g_old_rec.attribute2 ,
169: p_attribute3_o => per_prt_shd.g_old_rec.attribute3 ,
170: p_attribute4_o => per_prt_shd.g_old_rec.attribute4 ,
171: p_attribute5_o => per_prt_shd.g_old_rec.attribute5 ,
172: p_attribute6_o => per_prt_shd.g_old_rec.attribute6 ,
173: p_attribute7_o => per_prt_shd.g_old_rec.attribute7 ,
174: p_attribute8_o => per_prt_shd.g_old_rec.attribute8 ,
175: p_attribute9_o => per_prt_shd.g_old_rec.attribute9 ,
168: p_attribute2_o => per_prt_shd.g_old_rec.attribute2 ,
169: p_attribute3_o => per_prt_shd.g_old_rec.attribute3 ,
170: p_attribute4_o => per_prt_shd.g_old_rec.attribute4 ,
171: p_attribute5_o => per_prt_shd.g_old_rec.attribute5 ,
172: p_attribute6_o => per_prt_shd.g_old_rec.attribute6 ,
173: p_attribute7_o => per_prt_shd.g_old_rec.attribute7 ,
174: p_attribute8_o => per_prt_shd.g_old_rec.attribute8 ,
175: p_attribute9_o => per_prt_shd.g_old_rec.attribute9 ,
176: p_attribute10_o => per_prt_shd.g_old_rec.attribute10 ,
169: p_attribute3_o => per_prt_shd.g_old_rec.attribute3 ,
170: p_attribute4_o => per_prt_shd.g_old_rec.attribute4 ,
171: p_attribute5_o => per_prt_shd.g_old_rec.attribute5 ,
172: p_attribute6_o => per_prt_shd.g_old_rec.attribute6 ,
173: p_attribute7_o => per_prt_shd.g_old_rec.attribute7 ,
174: p_attribute8_o => per_prt_shd.g_old_rec.attribute8 ,
175: p_attribute9_o => per_prt_shd.g_old_rec.attribute9 ,
176: p_attribute10_o => per_prt_shd.g_old_rec.attribute10 ,
177: p_attribute11_o => per_prt_shd.g_old_rec.attribute11 ,
170: p_attribute4_o => per_prt_shd.g_old_rec.attribute4 ,
171: p_attribute5_o => per_prt_shd.g_old_rec.attribute5 ,
172: p_attribute6_o => per_prt_shd.g_old_rec.attribute6 ,
173: p_attribute7_o => per_prt_shd.g_old_rec.attribute7 ,
174: p_attribute8_o => per_prt_shd.g_old_rec.attribute8 ,
175: p_attribute9_o => per_prt_shd.g_old_rec.attribute9 ,
176: p_attribute10_o => per_prt_shd.g_old_rec.attribute10 ,
177: p_attribute11_o => per_prt_shd.g_old_rec.attribute11 ,
178: p_attribute12_o => per_prt_shd.g_old_rec.attribute12 ,
171: p_attribute5_o => per_prt_shd.g_old_rec.attribute5 ,
172: p_attribute6_o => per_prt_shd.g_old_rec.attribute6 ,
173: p_attribute7_o => per_prt_shd.g_old_rec.attribute7 ,
174: p_attribute8_o => per_prt_shd.g_old_rec.attribute8 ,
175: p_attribute9_o => per_prt_shd.g_old_rec.attribute9 ,
176: p_attribute10_o => per_prt_shd.g_old_rec.attribute10 ,
177: p_attribute11_o => per_prt_shd.g_old_rec.attribute11 ,
178: p_attribute12_o => per_prt_shd.g_old_rec.attribute12 ,
179: p_attribute13_o => per_prt_shd.g_old_rec.attribute13 ,
172: p_attribute6_o => per_prt_shd.g_old_rec.attribute6 ,
173: p_attribute7_o => per_prt_shd.g_old_rec.attribute7 ,
174: p_attribute8_o => per_prt_shd.g_old_rec.attribute8 ,
175: p_attribute9_o => per_prt_shd.g_old_rec.attribute9 ,
176: p_attribute10_o => per_prt_shd.g_old_rec.attribute10 ,
177: p_attribute11_o => per_prt_shd.g_old_rec.attribute11 ,
178: p_attribute12_o => per_prt_shd.g_old_rec.attribute12 ,
179: p_attribute13_o => per_prt_shd.g_old_rec.attribute13 ,
180: p_attribute14_o => per_prt_shd.g_old_rec.attribute14 ,
173: p_attribute7_o => per_prt_shd.g_old_rec.attribute7 ,
174: p_attribute8_o => per_prt_shd.g_old_rec.attribute8 ,
175: p_attribute9_o => per_prt_shd.g_old_rec.attribute9 ,
176: p_attribute10_o => per_prt_shd.g_old_rec.attribute10 ,
177: p_attribute11_o => per_prt_shd.g_old_rec.attribute11 ,
178: p_attribute12_o => per_prt_shd.g_old_rec.attribute12 ,
179: p_attribute13_o => per_prt_shd.g_old_rec.attribute13 ,
180: p_attribute14_o => per_prt_shd.g_old_rec.attribute14 ,
181: p_attribute15_o => per_prt_shd.g_old_rec.attribute15 ,
174: p_attribute8_o => per_prt_shd.g_old_rec.attribute8 ,
175: p_attribute9_o => per_prt_shd.g_old_rec.attribute9 ,
176: p_attribute10_o => per_prt_shd.g_old_rec.attribute10 ,
177: p_attribute11_o => per_prt_shd.g_old_rec.attribute11 ,
178: p_attribute12_o => per_prt_shd.g_old_rec.attribute12 ,
179: p_attribute13_o => per_prt_shd.g_old_rec.attribute13 ,
180: p_attribute14_o => per_prt_shd.g_old_rec.attribute14 ,
181: p_attribute15_o => per_prt_shd.g_old_rec.attribute15 ,
182: p_attribute16_o => per_prt_shd.g_old_rec.attribute16 ,
175: p_attribute9_o => per_prt_shd.g_old_rec.attribute9 ,
176: p_attribute10_o => per_prt_shd.g_old_rec.attribute10 ,
177: p_attribute11_o => per_prt_shd.g_old_rec.attribute11 ,
178: p_attribute12_o => per_prt_shd.g_old_rec.attribute12 ,
179: p_attribute13_o => per_prt_shd.g_old_rec.attribute13 ,
180: p_attribute14_o => per_prt_shd.g_old_rec.attribute14 ,
181: p_attribute15_o => per_prt_shd.g_old_rec.attribute15 ,
182: p_attribute16_o => per_prt_shd.g_old_rec.attribute16 ,
183: p_attribute17_o => per_prt_shd.g_old_rec.attribute17 ,
176: p_attribute10_o => per_prt_shd.g_old_rec.attribute10 ,
177: p_attribute11_o => per_prt_shd.g_old_rec.attribute11 ,
178: p_attribute12_o => per_prt_shd.g_old_rec.attribute12 ,
179: p_attribute13_o => per_prt_shd.g_old_rec.attribute13 ,
180: p_attribute14_o => per_prt_shd.g_old_rec.attribute14 ,
181: p_attribute15_o => per_prt_shd.g_old_rec.attribute15 ,
182: p_attribute16_o => per_prt_shd.g_old_rec.attribute16 ,
183: p_attribute17_o => per_prt_shd.g_old_rec.attribute17 ,
184: p_attribute18_o => per_prt_shd.g_old_rec.attribute18 ,
177: p_attribute11_o => per_prt_shd.g_old_rec.attribute11 ,
178: p_attribute12_o => per_prt_shd.g_old_rec.attribute12 ,
179: p_attribute13_o => per_prt_shd.g_old_rec.attribute13 ,
180: p_attribute14_o => per_prt_shd.g_old_rec.attribute14 ,
181: p_attribute15_o => per_prt_shd.g_old_rec.attribute15 ,
182: p_attribute16_o => per_prt_shd.g_old_rec.attribute16 ,
183: p_attribute17_o => per_prt_shd.g_old_rec.attribute17 ,
184: p_attribute18_o => per_prt_shd.g_old_rec.attribute18 ,
185: p_attribute19_o => per_prt_shd.g_old_rec.attribute19 ,
178: p_attribute12_o => per_prt_shd.g_old_rec.attribute12 ,
179: p_attribute13_o => per_prt_shd.g_old_rec.attribute13 ,
180: p_attribute14_o => per_prt_shd.g_old_rec.attribute14 ,
181: p_attribute15_o => per_prt_shd.g_old_rec.attribute15 ,
182: p_attribute16_o => per_prt_shd.g_old_rec.attribute16 ,
183: p_attribute17_o => per_prt_shd.g_old_rec.attribute17 ,
184: p_attribute18_o => per_prt_shd.g_old_rec.attribute18 ,
185: p_attribute19_o => per_prt_shd.g_old_rec.attribute19 ,
186: p_attribute20_o => per_prt_shd.g_old_rec.attribute20 ,
179: p_attribute13_o => per_prt_shd.g_old_rec.attribute13 ,
180: p_attribute14_o => per_prt_shd.g_old_rec.attribute14 ,
181: p_attribute15_o => per_prt_shd.g_old_rec.attribute15 ,
182: p_attribute16_o => per_prt_shd.g_old_rec.attribute16 ,
183: p_attribute17_o => per_prt_shd.g_old_rec.attribute17 ,
184: p_attribute18_o => per_prt_shd.g_old_rec.attribute18 ,
185: p_attribute19_o => per_prt_shd.g_old_rec.attribute19 ,
186: p_attribute20_o => per_prt_shd.g_old_rec.attribute20 ,
187: p_appr_line_score_o => per_prt_shd.g_old_rec.appr_line_score);
180: p_attribute14_o => per_prt_shd.g_old_rec.attribute14 ,
181: p_attribute15_o => per_prt_shd.g_old_rec.attribute15 ,
182: p_attribute16_o => per_prt_shd.g_old_rec.attribute16 ,
183: p_attribute17_o => per_prt_shd.g_old_rec.attribute17 ,
184: p_attribute18_o => per_prt_shd.g_old_rec.attribute18 ,
185: p_attribute19_o => per_prt_shd.g_old_rec.attribute19 ,
186: p_attribute20_o => per_prt_shd.g_old_rec.attribute20 ,
187: p_appr_line_score_o => per_prt_shd.g_old_rec.appr_line_score);
188: exception
181: p_attribute15_o => per_prt_shd.g_old_rec.attribute15 ,
182: p_attribute16_o => per_prt_shd.g_old_rec.attribute16 ,
183: p_attribute17_o => per_prt_shd.g_old_rec.attribute17 ,
184: p_attribute18_o => per_prt_shd.g_old_rec.attribute18 ,
185: p_attribute19_o => per_prt_shd.g_old_rec.attribute19 ,
186: p_attribute20_o => per_prt_shd.g_old_rec.attribute20 ,
187: p_appr_line_score_o => per_prt_shd.g_old_rec.appr_line_score);
188: exception
189: when hr_api.cannot_find_prog_unit then
182: p_attribute16_o => per_prt_shd.g_old_rec.attribute16 ,
183: p_attribute17_o => per_prt_shd.g_old_rec.attribute17 ,
184: p_attribute18_o => per_prt_shd.g_old_rec.attribute18 ,
185: p_attribute19_o => per_prt_shd.g_old_rec.attribute19 ,
186: p_attribute20_o => per_prt_shd.g_old_rec.attribute20 ,
187: p_appr_line_score_o => per_prt_shd.g_old_rec.appr_line_score);
188: exception
189: when hr_api.cannot_find_prog_unit then
190: hr_api.cannot_find_prog_unit_error
183: p_attribute17_o => per_prt_shd.g_old_rec.attribute17 ,
184: p_attribute18_o => per_prt_shd.g_old_rec.attribute18 ,
185: p_attribute19_o => per_prt_shd.g_old_rec.attribute19 ,
186: p_attribute20_o => per_prt_shd.g_old_rec.attribute20 ,
187: p_appr_line_score_o => per_prt_shd.g_old_rec.appr_line_score);
188: exception
189: when hr_api.cannot_find_prog_unit then
190: hr_api.cannot_find_prog_unit_error
191: ( p_module_name => 'PER_PERFORMANCE_RATINGS'
201: -- |---------------------------------< del >----------------------------------|
202: -- ---------------------------------------------------------------------------+
203: Procedure del
204: (
205: p_rec in per_prt_shd.g_rec_type,
206: p_validate in boolean default false
207: ) is
208:
209: l_proc varchar2(72) := g_package||'del';
221: End If;
222:
223: -- We must lock the row which we need to delete.
224:
225: per_prt_shd.lck
226: (
227: p_rec.performance_rating_id,
228: p_rec.object_version_number
229: );
277: p_object_version_number in number,
278: p_validate in boolean default false
279: ) is
280:
281: l_rec per_prt_shd.g_rec_type;
282: l_proc varchar2(72) := g_package||'del';
283:
284: Begin
285: hr_utility.set_location('Entering:'||l_proc, 5);