41: -- Internal Table Handler Use Only.
42:
43: -- {End Of Comments}
44: -- ---------------------------------------------------------------------------+
45: Procedure delete_dml(p_rec in per_apr_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_apr_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_apr_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_apr_shd.g_rec_type) is
145:
146: l_proc varchar2(72) := g_package||'post_delete';
147:
148: Begin
152:
153: begin
154: per_apr_rkd.after_delete (
155: p_appraisal_id => p_rec.appraisal_id ,
156: p_business_group_id_o => per_apr_shd.g_old_rec.business_group_id ,
157: p_appraisal_template_id_o => per_apr_shd.g_old_rec.appraisal_template_id ,
158: p_appraisee_person_id_o => per_apr_shd.g_old_rec.appraisee_person_id ,
159: p_appraiser_person_id_o => per_apr_shd.g_old_rec.appraiser_person_id ,
160: p_appraisal_date_o => per_apr_shd.g_old_rec.appraisal_date ,
153: begin
154: per_apr_rkd.after_delete (
155: p_appraisal_id => p_rec.appraisal_id ,
156: p_business_group_id_o => per_apr_shd.g_old_rec.business_group_id ,
157: p_appraisal_template_id_o => per_apr_shd.g_old_rec.appraisal_template_id ,
158: p_appraisee_person_id_o => per_apr_shd.g_old_rec.appraisee_person_id ,
159: p_appraiser_person_id_o => per_apr_shd.g_old_rec.appraiser_person_id ,
160: p_appraisal_date_o => per_apr_shd.g_old_rec.appraisal_date ,
161: p_group_date_o => per_apr_shd.g_old_rec.group_date ,
154: per_apr_rkd.after_delete (
155: p_appraisal_id => p_rec.appraisal_id ,
156: p_business_group_id_o => per_apr_shd.g_old_rec.business_group_id ,
157: p_appraisal_template_id_o => per_apr_shd.g_old_rec.appraisal_template_id ,
158: p_appraisee_person_id_o => per_apr_shd.g_old_rec.appraisee_person_id ,
159: p_appraiser_person_id_o => per_apr_shd.g_old_rec.appraiser_person_id ,
160: p_appraisal_date_o => per_apr_shd.g_old_rec.appraisal_date ,
161: p_group_date_o => per_apr_shd.g_old_rec.group_date ,
162: p_group_initiator_id_o => per_apr_shd.g_old_rec.group_initiator_id ,
155: p_appraisal_id => p_rec.appraisal_id ,
156: p_business_group_id_o => per_apr_shd.g_old_rec.business_group_id ,
157: p_appraisal_template_id_o => per_apr_shd.g_old_rec.appraisal_template_id ,
158: p_appraisee_person_id_o => per_apr_shd.g_old_rec.appraisee_person_id ,
159: p_appraiser_person_id_o => per_apr_shd.g_old_rec.appraiser_person_id ,
160: p_appraisal_date_o => per_apr_shd.g_old_rec.appraisal_date ,
161: p_group_date_o => per_apr_shd.g_old_rec.group_date ,
162: p_group_initiator_id_o => per_apr_shd.g_old_rec.group_initiator_id ,
163: p_appraisal_period_end_date_o => per_apr_shd.g_old_rec.appraisal_period_end_date ,
156: p_business_group_id_o => per_apr_shd.g_old_rec.business_group_id ,
157: p_appraisal_template_id_o => per_apr_shd.g_old_rec.appraisal_template_id ,
158: p_appraisee_person_id_o => per_apr_shd.g_old_rec.appraisee_person_id ,
159: p_appraiser_person_id_o => per_apr_shd.g_old_rec.appraiser_person_id ,
160: p_appraisal_date_o => per_apr_shd.g_old_rec.appraisal_date ,
161: p_group_date_o => per_apr_shd.g_old_rec.group_date ,
162: p_group_initiator_id_o => per_apr_shd.g_old_rec.group_initiator_id ,
163: p_appraisal_period_end_date_o => per_apr_shd.g_old_rec.appraisal_period_end_date ,
164: p_appraisal_period_start_dat_o => per_apr_shd.g_old_rec.appraisal_period_start_date ,
157: p_appraisal_template_id_o => per_apr_shd.g_old_rec.appraisal_template_id ,
158: p_appraisee_person_id_o => per_apr_shd.g_old_rec.appraisee_person_id ,
159: p_appraiser_person_id_o => per_apr_shd.g_old_rec.appraiser_person_id ,
160: p_appraisal_date_o => per_apr_shd.g_old_rec.appraisal_date ,
161: p_group_date_o => per_apr_shd.g_old_rec.group_date ,
162: p_group_initiator_id_o => per_apr_shd.g_old_rec.group_initiator_id ,
163: p_appraisal_period_end_date_o => per_apr_shd.g_old_rec.appraisal_period_end_date ,
164: p_appraisal_period_start_dat_o => per_apr_shd.g_old_rec.appraisal_period_start_date ,
165: p_type_o => per_apr_shd.g_old_rec.type ,
158: p_appraisee_person_id_o => per_apr_shd.g_old_rec.appraisee_person_id ,
159: p_appraiser_person_id_o => per_apr_shd.g_old_rec.appraiser_person_id ,
160: p_appraisal_date_o => per_apr_shd.g_old_rec.appraisal_date ,
161: p_group_date_o => per_apr_shd.g_old_rec.group_date ,
162: p_group_initiator_id_o => per_apr_shd.g_old_rec.group_initiator_id ,
163: p_appraisal_period_end_date_o => per_apr_shd.g_old_rec.appraisal_period_end_date ,
164: p_appraisal_period_start_dat_o => per_apr_shd.g_old_rec.appraisal_period_start_date ,
165: p_type_o => per_apr_shd.g_old_rec.type ,
166: p_next_appraisal_date_o => per_apr_shd.g_old_rec.next_appraisal_date ,
159: p_appraiser_person_id_o => per_apr_shd.g_old_rec.appraiser_person_id ,
160: p_appraisal_date_o => per_apr_shd.g_old_rec.appraisal_date ,
161: p_group_date_o => per_apr_shd.g_old_rec.group_date ,
162: p_group_initiator_id_o => per_apr_shd.g_old_rec.group_initiator_id ,
163: p_appraisal_period_end_date_o => per_apr_shd.g_old_rec.appraisal_period_end_date ,
164: p_appraisal_period_start_dat_o => per_apr_shd.g_old_rec.appraisal_period_start_date ,
165: p_type_o => per_apr_shd.g_old_rec.type ,
166: p_next_appraisal_date_o => per_apr_shd.g_old_rec.next_appraisal_date ,
167: p_status_o => per_apr_shd.g_old_rec.status ,
160: p_appraisal_date_o => per_apr_shd.g_old_rec.appraisal_date ,
161: p_group_date_o => per_apr_shd.g_old_rec.group_date ,
162: p_group_initiator_id_o => per_apr_shd.g_old_rec.group_initiator_id ,
163: p_appraisal_period_end_date_o => per_apr_shd.g_old_rec.appraisal_period_end_date ,
164: p_appraisal_period_start_dat_o => per_apr_shd.g_old_rec.appraisal_period_start_date ,
165: p_type_o => per_apr_shd.g_old_rec.type ,
166: p_next_appraisal_date_o => per_apr_shd.g_old_rec.next_appraisal_date ,
167: p_status_o => per_apr_shd.g_old_rec.status ,
168: p_comments_o => per_apr_shd.g_old_rec.comments ,
161: p_group_date_o => per_apr_shd.g_old_rec.group_date ,
162: p_group_initiator_id_o => per_apr_shd.g_old_rec.group_initiator_id ,
163: p_appraisal_period_end_date_o => per_apr_shd.g_old_rec.appraisal_period_end_date ,
164: p_appraisal_period_start_dat_o => per_apr_shd.g_old_rec.appraisal_period_start_date ,
165: p_type_o => per_apr_shd.g_old_rec.type ,
166: p_next_appraisal_date_o => per_apr_shd.g_old_rec.next_appraisal_date ,
167: p_status_o => per_apr_shd.g_old_rec.status ,
168: p_comments_o => per_apr_shd.g_old_rec.comments ,
169: p_overall_performance_level_o => per_apr_shd.g_old_rec.overall_performance_level_id,
162: p_group_initiator_id_o => per_apr_shd.g_old_rec.group_initiator_id ,
163: p_appraisal_period_end_date_o => per_apr_shd.g_old_rec.appraisal_period_end_date ,
164: p_appraisal_period_start_dat_o => per_apr_shd.g_old_rec.appraisal_period_start_date ,
165: p_type_o => per_apr_shd.g_old_rec.type ,
166: p_next_appraisal_date_o => per_apr_shd.g_old_rec.next_appraisal_date ,
167: p_status_o => per_apr_shd.g_old_rec.status ,
168: p_comments_o => per_apr_shd.g_old_rec.comments ,
169: p_overall_performance_level_o => per_apr_shd.g_old_rec.overall_performance_level_id,
170: p_open_o => per_apr_shd.g_old_rec.open ,
163: p_appraisal_period_end_date_o => per_apr_shd.g_old_rec.appraisal_period_end_date ,
164: p_appraisal_period_start_dat_o => per_apr_shd.g_old_rec.appraisal_period_start_date ,
165: p_type_o => per_apr_shd.g_old_rec.type ,
166: p_next_appraisal_date_o => per_apr_shd.g_old_rec.next_appraisal_date ,
167: p_status_o => per_apr_shd.g_old_rec.status ,
168: p_comments_o => per_apr_shd.g_old_rec.comments ,
169: p_overall_performance_level_o => per_apr_shd.g_old_rec.overall_performance_level_id,
170: p_open_o => per_apr_shd.g_old_rec.open ,
171: p_attribute_category_o => per_apr_shd.g_old_rec.attribute_category ,
164: p_appraisal_period_start_dat_o => per_apr_shd.g_old_rec.appraisal_period_start_date ,
165: p_type_o => per_apr_shd.g_old_rec.type ,
166: p_next_appraisal_date_o => per_apr_shd.g_old_rec.next_appraisal_date ,
167: p_status_o => per_apr_shd.g_old_rec.status ,
168: p_comments_o => per_apr_shd.g_old_rec.comments ,
169: p_overall_performance_level_o => per_apr_shd.g_old_rec.overall_performance_level_id,
170: p_open_o => per_apr_shd.g_old_rec.open ,
171: p_attribute_category_o => per_apr_shd.g_old_rec.attribute_category ,
172: p_attribute1_o => per_apr_shd.g_old_rec.attribute1 ,
165: p_type_o => per_apr_shd.g_old_rec.type ,
166: p_next_appraisal_date_o => per_apr_shd.g_old_rec.next_appraisal_date ,
167: p_status_o => per_apr_shd.g_old_rec.status ,
168: p_comments_o => per_apr_shd.g_old_rec.comments ,
169: p_overall_performance_level_o => per_apr_shd.g_old_rec.overall_performance_level_id,
170: p_open_o => per_apr_shd.g_old_rec.open ,
171: p_attribute_category_o => per_apr_shd.g_old_rec.attribute_category ,
172: p_attribute1_o => per_apr_shd.g_old_rec.attribute1 ,
173: p_attribute2_o => per_apr_shd.g_old_rec.attribute2 ,
166: p_next_appraisal_date_o => per_apr_shd.g_old_rec.next_appraisal_date ,
167: p_status_o => per_apr_shd.g_old_rec.status ,
168: p_comments_o => per_apr_shd.g_old_rec.comments ,
169: p_overall_performance_level_o => per_apr_shd.g_old_rec.overall_performance_level_id,
170: p_open_o => per_apr_shd.g_old_rec.open ,
171: p_attribute_category_o => per_apr_shd.g_old_rec.attribute_category ,
172: p_attribute1_o => per_apr_shd.g_old_rec.attribute1 ,
173: p_attribute2_o => per_apr_shd.g_old_rec.attribute2 ,
174: p_attribute3_o => per_apr_shd.g_old_rec.attribute3 ,
167: p_status_o => per_apr_shd.g_old_rec.status ,
168: p_comments_o => per_apr_shd.g_old_rec.comments ,
169: p_overall_performance_level_o => per_apr_shd.g_old_rec.overall_performance_level_id,
170: p_open_o => per_apr_shd.g_old_rec.open ,
171: p_attribute_category_o => per_apr_shd.g_old_rec.attribute_category ,
172: p_attribute1_o => per_apr_shd.g_old_rec.attribute1 ,
173: p_attribute2_o => per_apr_shd.g_old_rec.attribute2 ,
174: p_attribute3_o => per_apr_shd.g_old_rec.attribute3 ,
175: p_attribute4_o => per_apr_shd.g_old_rec.attribute4 ,
168: p_comments_o => per_apr_shd.g_old_rec.comments ,
169: p_overall_performance_level_o => per_apr_shd.g_old_rec.overall_performance_level_id,
170: p_open_o => per_apr_shd.g_old_rec.open ,
171: p_attribute_category_o => per_apr_shd.g_old_rec.attribute_category ,
172: p_attribute1_o => per_apr_shd.g_old_rec.attribute1 ,
173: p_attribute2_o => per_apr_shd.g_old_rec.attribute2 ,
174: p_attribute3_o => per_apr_shd.g_old_rec.attribute3 ,
175: p_attribute4_o => per_apr_shd.g_old_rec.attribute4 ,
176: p_attribute5_o => per_apr_shd.g_old_rec.attribute5 ,
169: p_overall_performance_level_o => per_apr_shd.g_old_rec.overall_performance_level_id,
170: p_open_o => per_apr_shd.g_old_rec.open ,
171: p_attribute_category_o => per_apr_shd.g_old_rec.attribute_category ,
172: p_attribute1_o => per_apr_shd.g_old_rec.attribute1 ,
173: p_attribute2_o => per_apr_shd.g_old_rec.attribute2 ,
174: p_attribute3_o => per_apr_shd.g_old_rec.attribute3 ,
175: p_attribute4_o => per_apr_shd.g_old_rec.attribute4 ,
176: p_attribute5_o => per_apr_shd.g_old_rec.attribute5 ,
177: p_attribute6_o => per_apr_shd.g_old_rec.attribute6 ,
170: p_open_o => per_apr_shd.g_old_rec.open ,
171: p_attribute_category_o => per_apr_shd.g_old_rec.attribute_category ,
172: p_attribute1_o => per_apr_shd.g_old_rec.attribute1 ,
173: p_attribute2_o => per_apr_shd.g_old_rec.attribute2 ,
174: p_attribute3_o => per_apr_shd.g_old_rec.attribute3 ,
175: p_attribute4_o => per_apr_shd.g_old_rec.attribute4 ,
176: p_attribute5_o => per_apr_shd.g_old_rec.attribute5 ,
177: p_attribute6_o => per_apr_shd.g_old_rec.attribute6 ,
178: p_attribute7_o => per_apr_shd.g_old_rec.attribute7 ,
171: p_attribute_category_o => per_apr_shd.g_old_rec.attribute_category ,
172: p_attribute1_o => per_apr_shd.g_old_rec.attribute1 ,
173: p_attribute2_o => per_apr_shd.g_old_rec.attribute2 ,
174: p_attribute3_o => per_apr_shd.g_old_rec.attribute3 ,
175: p_attribute4_o => per_apr_shd.g_old_rec.attribute4 ,
176: p_attribute5_o => per_apr_shd.g_old_rec.attribute5 ,
177: p_attribute6_o => per_apr_shd.g_old_rec.attribute6 ,
178: p_attribute7_o => per_apr_shd.g_old_rec.attribute7 ,
179: p_attribute8_o => per_apr_shd.g_old_rec.attribute8 ,
172: p_attribute1_o => per_apr_shd.g_old_rec.attribute1 ,
173: p_attribute2_o => per_apr_shd.g_old_rec.attribute2 ,
174: p_attribute3_o => per_apr_shd.g_old_rec.attribute3 ,
175: p_attribute4_o => per_apr_shd.g_old_rec.attribute4 ,
176: p_attribute5_o => per_apr_shd.g_old_rec.attribute5 ,
177: p_attribute6_o => per_apr_shd.g_old_rec.attribute6 ,
178: p_attribute7_o => per_apr_shd.g_old_rec.attribute7 ,
179: p_attribute8_o => per_apr_shd.g_old_rec.attribute8 ,
180: p_attribute9_o => per_apr_shd.g_old_rec.attribute9 ,
173: p_attribute2_o => per_apr_shd.g_old_rec.attribute2 ,
174: p_attribute3_o => per_apr_shd.g_old_rec.attribute3 ,
175: p_attribute4_o => per_apr_shd.g_old_rec.attribute4 ,
176: p_attribute5_o => per_apr_shd.g_old_rec.attribute5 ,
177: p_attribute6_o => per_apr_shd.g_old_rec.attribute6 ,
178: p_attribute7_o => per_apr_shd.g_old_rec.attribute7 ,
179: p_attribute8_o => per_apr_shd.g_old_rec.attribute8 ,
180: p_attribute9_o => per_apr_shd.g_old_rec.attribute9 ,
181: p_attribute10_o => per_apr_shd.g_old_rec.attribute10 ,
174: p_attribute3_o => per_apr_shd.g_old_rec.attribute3 ,
175: p_attribute4_o => per_apr_shd.g_old_rec.attribute4 ,
176: p_attribute5_o => per_apr_shd.g_old_rec.attribute5 ,
177: p_attribute6_o => per_apr_shd.g_old_rec.attribute6 ,
178: p_attribute7_o => per_apr_shd.g_old_rec.attribute7 ,
179: p_attribute8_o => per_apr_shd.g_old_rec.attribute8 ,
180: p_attribute9_o => per_apr_shd.g_old_rec.attribute9 ,
181: p_attribute10_o => per_apr_shd.g_old_rec.attribute10 ,
182: p_attribute11_o => per_apr_shd.g_old_rec.attribute11 ,
175: p_attribute4_o => per_apr_shd.g_old_rec.attribute4 ,
176: p_attribute5_o => per_apr_shd.g_old_rec.attribute5 ,
177: p_attribute6_o => per_apr_shd.g_old_rec.attribute6 ,
178: p_attribute7_o => per_apr_shd.g_old_rec.attribute7 ,
179: p_attribute8_o => per_apr_shd.g_old_rec.attribute8 ,
180: p_attribute9_o => per_apr_shd.g_old_rec.attribute9 ,
181: p_attribute10_o => per_apr_shd.g_old_rec.attribute10 ,
182: p_attribute11_o => per_apr_shd.g_old_rec.attribute11 ,
183: p_attribute12_o => per_apr_shd.g_old_rec.attribute12 ,
176: p_attribute5_o => per_apr_shd.g_old_rec.attribute5 ,
177: p_attribute6_o => per_apr_shd.g_old_rec.attribute6 ,
178: p_attribute7_o => per_apr_shd.g_old_rec.attribute7 ,
179: p_attribute8_o => per_apr_shd.g_old_rec.attribute8 ,
180: p_attribute9_o => per_apr_shd.g_old_rec.attribute9 ,
181: p_attribute10_o => per_apr_shd.g_old_rec.attribute10 ,
182: p_attribute11_o => per_apr_shd.g_old_rec.attribute11 ,
183: p_attribute12_o => per_apr_shd.g_old_rec.attribute12 ,
184: p_attribute13_o => per_apr_shd.g_old_rec.attribute13 ,
177: p_attribute6_o => per_apr_shd.g_old_rec.attribute6 ,
178: p_attribute7_o => per_apr_shd.g_old_rec.attribute7 ,
179: p_attribute8_o => per_apr_shd.g_old_rec.attribute8 ,
180: p_attribute9_o => per_apr_shd.g_old_rec.attribute9 ,
181: p_attribute10_o => per_apr_shd.g_old_rec.attribute10 ,
182: p_attribute11_o => per_apr_shd.g_old_rec.attribute11 ,
183: p_attribute12_o => per_apr_shd.g_old_rec.attribute12 ,
184: p_attribute13_o => per_apr_shd.g_old_rec.attribute13 ,
185: p_attribute14_o => per_apr_shd.g_old_rec.attribute14 ,
178: p_attribute7_o => per_apr_shd.g_old_rec.attribute7 ,
179: p_attribute8_o => per_apr_shd.g_old_rec.attribute8 ,
180: p_attribute9_o => per_apr_shd.g_old_rec.attribute9 ,
181: p_attribute10_o => per_apr_shd.g_old_rec.attribute10 ,
182: p_attribute11_o => per_apr_shd.g_old_rec.attribute11 ,
183: p_attribute12_o => per_apr_shd.g_old_rec.attribute12 ,
184: p_attribute13_o => per_apr_shd.g_old_rec.attribute13 ,
185: p_attribute14_o => per_apr_shd.g_old_rec.attribute14 ,
186: p_attribute15_o => per_apr_shd.g_old_rec.attribute15 ,
179: p_attribute8_o => per_apr_shd.g_old_rec.attribute8 ,
180: p_attribute9_o => per_apr_shd.g_old_rec.attribute9 ,
181: p_attribute10_o => per_apr_shd.g_old_rec.attribute10 ,
182: p_attribute11_o => per_apr_shd.g_old_rec.attribute11 ,
183: p_attribute12_o => per_apr_shd.g_old_rec.attribute12 ,
184: p_attribute13_o => per_apr_shd.g_old_rec.attribute13 ,
185: p_attribute14_o => per_apr_shd.g_old_rec.attribute14 ,
186: p_attribute15_o => per_apr_shd.g_old_rec.attribute15 ,
187: p_attribute16_o => per_apr_shd.g_old_rec.attribute16 ,
180: p_attribute9_o => per_apr_shd.g_old_rec.attribute9 ,
181: p_attribute10_o => per_apr_shd.g_old_rec.attribute10 ,
182: p_attribute11_o => per_apr_shd.g_old_rec.attribute11 ,
183: p_attribute12_o => per_apr_shd.g_old_rec.attribute12 ,
184: p_attribute13_o => per_apr_shd.g_old_rec.attribute13 ,
185: p_attribute14_o => per_apr_shd.g_old_rec.attribute14 ,
186: p_attribute15_o => per_apr_shd.g_old_rec.attribute15 ,
187: p_attribute16_o => per_apr_shd.g_old_rec.attribute16 ,
188: p_attribute17_o => per_apr_shd.g_old_rec.attribute17 ,
181: p_attribute10_o => per_apr_shd.g_old_rec.attribute10 ,
182: p_attribute11_o => per_apr_shd.g_old_rec.attribute11 ,
183: p_attribute12_o => per_apr_shd.g_old_rec.attribute12 ,
184: p_attribute13_o => per_apr_shd.g_old_rec.attribute13 ,
185: p_attribute14_o => per_apr_shd.g_old_rec.attribute14 ,
186: p_attribute15_o => per_apr_shd.g_old_rec.attribute15 ,
187: p_attribute16_o => per_apr_shd.g_old_rec.attribute16 ,
188: p_attribute17_o => per_apr_shd.g_old_rec.attribute17 ,
189: p_attribute18_o => per_apr_shd.g_old_rec.attribute18 ,
182: p_attribute11_o => per_apr_shd.g_old_rec.attribute11 ,
183: p_attribute12_o => per_apr_shd.g_old_rec.attribute12 ,
184: p_attribute13_o => per_apr_shd.g_old_rec.attribute13 ,
185: p_attribute14_o => per_apr_shd.g_old_rec.attribute14 ,
186: p_attribute15_o => per_apr_shd.g_old_rec.attribute15 ,
187: p_attribute16_o => per_apr_shd.g_old_rec.attribute16 ,
188: p_attribute17_o => per_apr_shd.g_old_rec.attribute17 ,
189: p_attribute18_o => per_apr_shd.g_old_rec.attribute18 ,
190: p_attribute19_o => per_apr_shd.g_old_rec.attribute19 ,
183: p_attribute12_o => per_apr_shd.g_old_rec.attribute12 ,
184: p_attribute13_o => per_apr_shd.g_old_rec.attribute13 ,
185: p_attribute14_o => per_apr_shd.g_old_rec.attribute14 ,
186: p_attribute15_o => per_apr_shd.g_old_rec.attribute15 ,
187: p_attribute16_o => per_apr_shd.g_old_rec.attribute16 ,
188: p_attribute17_o => per_apr_shd.g_old_rec.attribute17 ,
189: p_attribute18_o => per_apr_shd.g_old_rec.attribute18 ,
190: p_attribute19_o => per_apr_shd.g_old_rec.attribute19 ,
191: p_attribute20_o => per_apr_shd.g_old_rec.attribute20 ,
184: p_attribute13_o => per_apr_shd.g_old_rec.attribute13 ,
185: p_attribute14_o => per_apr_shd.g_old_rec.attribute14 ,
186: p_attribute15_o => per_apr_shd.g_old_rec.attribute15 ,
187: p_attribute16_o => per_apr_shd.g_old_rec.attribute16 ,
188: p_attribute17_o => per_apr_shd.g_old_rec.attribute17 ,
189: p_attribute18_o => per_apr_shd.g_old_rec.attribute18 ,
190: p_attribute19_o => per_apr_shd.g_old_rec.attribute19 ,
191: p_attribute20_o => per_apr_shd.g_old_rec.attribute20 ,
192: p_object_version_number_o => per_apr_shd.g_old_rec.object_version_number ,
185: p_attribute14_o => per_apr_shd.g_old_rec.attribute14 ,
186: p_attribute15_o => per_apr_shd.g_old_rec.attribute15 ,
187: p_attribute16_o => per_apr_shd.g_old_rec.attribute16 ,
188: p_attribute17_o => per_apr_shd.g_old_rec.attribute17 ,
189: p_attribute18_o => per_apr_shd.g_old_rec.attribute18 ,
190: p_attribute19_o => per_apr_shd.g_old_rec.attribute19 ,
191: p_attribute20_o => per_apr_shd.g_old_rec.attribute20 ,
192: p_object_version_number_o => per_apr_shd.g_old_rec.object_version_number ,
193: p_system_type_o => per_apr_shd.g_old_rec.system_type ,
186: p_attribute15_o => per_apr_shd.g_old_rec.attribute15 ,
187: p_attribute16_o => per_apr_shd.g_old_rec.attribute16 ,
188: p_attribute17_o => per_apr_shd.g_old_rec.attribute17 ,
189: p_attribute18_o => per_apr_shd.g_old_rec.attribute18 ,
190: p_attribute19_o => per_apr_shd.g_old_rec.attribute19 ,
191: p_attribute20_o => per_apr_shd.g_old_rec.attribute20 ,
192: p_object_version_number_o => per_apr_shd.g_old_rec.object_version_number ,
193: p_system_type_o => per_apr_shd.g_old_rec.system_type ,
194: p_system_params_o => per_apr_shd.g_old_rec.system_params ,
187: p_attribute16_o => per_apr_shd.g_old_rec.attribute16 ,
188: p_attribute17_o => per_apr_shd.g_old_rec.attribute17 ,
189: p_attribute18_o => per_apr_shd.g_old_rec.attribute18 ,
190: p_attribute19_o => per_apr_shd.g_old_rec.attribute19 ,
191: p_attribute20_o => per_apr_shd.g_old_rec.attribute20 ,
192: p_object_version_number_o => per_apr_shd.g_old_rec.object_version_number ,
193: p_system_type_o => per_apr_shd.g_old_rec.system_type ,
194: p_system_params_o => per_apr_shd.g_old_rec.system_params ,
195: p_appraisee_access_o => per_apr_shd.g_old_rec.appraisee_access ,
188: p_attribute17_o => per_apr_shd.g_old_rec.attribute17 ,
189: p_attribute18_o => per_apr_shd.g_old_rec.attribute18 ,
190: p_attribute19_o => per_apr_shd.g_old_rec.attribute19 ,
191: p_attribute20_o => per_apr_shd.g_old_rec.attribute20 ,
192: p_object_version_number_o => per_apr_shd.g_old_rec.object_version_number ,
193: p_system_type_o => per_apr_shd.g_old_rec.system_type ,
194: p_system_params_o => per_apr_shd.g_old_rec.system_params ,
195: p_appraisee_access_o => per_apr_shd.g_old_rec.appraisee_access ,
196: p_main_appraiser_id_o => per_apr_shd.g_old_rec.main_appraiser_id ,
189: p_attribute18_o => per_apr_shd.g_old_rec.attribute18 ,
190: p_attribute19_o => per_apr_shd.g_old_rec.attribute19 ,
191: p_attribute20_o => per_apr_shd.g_old_rec.attribute20 ,
192: p_object_version_number_o => per_apr_shd.g_old_rec.object_version_number ,
193: p_system_type_o => per_apr_shd.g_old_rec.system_type ,
194: p_system_params_o => per_apr_shd.g_old_rec.system_params ,
195: p_appraisee_access_o => per_apr_shd.g_old_rec.appraisee_access ,
196: p_main_appraiser_id_o => per_apr_shd.g_old_rec.main_appraiser_id ,
197: p_assignment_id_o => per_apr_shd.g_old_rec.assignment_id ,
190: p_attribute19_o => per_apr_shd.g_old_rec.attribute19 ,
191: p_attribute20_o => per_apr_shd.g_old_rec.attribute20 ,
192: p_object_version_number_o => per_apr_shd.g_old_rec.object_version_number ,
193: p_system_type_o => per_apr_shd.g_old_rec.system_type ,
194: p_system_params_o => per_apr_shd.g_old_rec.system_params ,
195: p_appraisee_access_o => per_apr_shd.g_old_rec.appraisee_access ,
196: p_main_appraiser_id_o => per_apr_shd.g_old_rec.main_appraiser_id ,
197: p_assignment_id_o => per_apr_shd.g_old_rec.assignment_id ,
198: p_assignment_start_date_o => per_apr_shd.g_old_rec.assignment_start_date ,
191: p_attribute20_o => per_apr_shd.g_old_rec.attribute20 ,
192: p_object_version_number_o => per_apr_shd.g_old_rec.object_version_number ,
193: p_system_type_o => per_apr_shd.g_old_rec.system_type ,
194: p_system_params_o => per_apr_shd.g_old_rec.system_params ,
195: p_appraisee_access_o => per_apr_shd.g_old_rec.appraisee_access ,
196: p_main_appraiser_id_o => per_apr_shd.g_old_rec.main_appraiser_id ,
197: p_assignment_id_o => per_apr_shd.g_old_rec.assignment_id ,
198: p_assignment_start_date_o => per_apr_shd.g_old_rec.assignment_start_date ,
199: p_asg_business_group_id_o => per_apr_shd.g_old_rec.assignment_business_group_id ,
192: p_object_version_number_o => per_apr_shd.g_old_rec.object_version_number ,
193: p_system_type_o => per_apr_shd.g_old_rec.system_type ,
194: p_system_params_o => per_apr_shd.g_old_rec.system_params ,
195: p_appraisee_access_o => per_apr_shd.g_old_rec.appraisee_access ,
196: p_main_appraiser_id_o => per_apr_shd.g_old_rec.main_appraiser_id ,
197: p_assignment_id_o => per_apr_shd.g_old_rec.assignment_id ,
198: p_assignment_start_date_o => per_apr_shd.g_old_rec.assignment_start_date ,
199: p_asg_business_group_id_o => per_apr_shd.g_old_rec.assignment_business_group_id ,
200: p_assignment_organization_id_o => per_apr_shd.g_old_rec.assignment_organization_id ,
193: p_system_type_o => per_apr_shd.g_old_rec.system_type ,
194: p_system_params_o => per_apr_shd.g_old_rec.system_params ,
195: p_appraisee_access_o => per_apr_shd.g_old_rec.appraisee_access ,
196: p_main_appraiser_id_o => per_apr_shd.g_old_rec.main_appraiser_id ,
197: p_assignment_id_o => per_apr_shd.g_old_rec.assignment_id ,
198: p_assignment_start_date_o => per_apr_shd.g_old_rec.assignment_start_date ,
199: p_asg_business_group_id_o => per_apr_shd.g_old_rec.assignment_business_group_id ,
200: p_assignment_organization_id_o => per_apr_shd.g_old_rec.assignment_organization_id ,
201: p_assignment_job_id_o => per_apr_shd.g_old_rec.assignment_job_id,
194: p_system_params_o => per_apr_shd.g_old_rec.system_params ,
195: p_appraisee_access_o => per_apr_shd.g_old_rec.appraisee_access ,
196: p_main_appraiser_id_o => per_apr_shd.g_old_rec.main_appraiser_id ,
197: p_assignment_id_o => per_apr_shd.g_old_rec.assignment_id ,
198: p_assignment_start_date_o => per_apr_shd.g_old_rec.assignment_start_date ,
199: p_asg_business_group_id_o => per_apr_shd.g_old_rec.assignment_business_group_id ,
200: p_assignment_organization_id_o => per_apr_shd.g_old_rec.assignment_organization_id ,
201: p_assignment_job_id_o => per_apr_shd.g_old_rec.assignment_job_id,
202: p_assignment_position_id_o => per_apr_shd.g_old_rec.assignment_position_id,
195: p_appraisee_access_o => per_apr_shd.g_old_rec.appraisee_access ,
196: p_main_appraiser_id_o => per_apr_shd.g_old_rec.main_appraiser_id ,
197: p_assignment_id_o => per_apr_shd.g_old_rec.assignment_id ,
198: p_assignment_start_date_o => per_apr_shd.g_old_rec.assignment_start_date ,
199: p_asg_business_group_id_o => per_apr_shd.g_old_rec.assignment_business_group_id ,
200: p_assignment_organization_id_o => per_apr_shd.g_old_rec.assignment_organization_id ,
201: p_assignment_job_id_o => per_apr_shd.g_old_rec.assignment_job_id,
202: p_assignment_position_id_o => per_apr_shd.g_old_rec.assignment_position_id,
203: p_assignment_grade_id_o => per_apr_shd.g_old_rec.assignment_grade_id,
196: p_main_appraiser_id_o => per_apr_shd.g_old_rec.main_appraiser_id ,
197: p_assignment_id_o => per_apr_shd.g_old_rec.assignment_id ,
198: p_assignment_start_date_o => per_apr_shd.g_old_rec.assignment_start_date ,
199: p_asg_business_group_id_o => per_apr_shd.g_old_rec.assignment_business_group_id ,
200: p_assignment_organization_id_o => per_apr_shd.g_old_rec.assignment_organization_id ,
201: p_assignment_job_id_o => per_apr_shd.g_old_rec.assignment_job_id,
202: p_assignment_position_id_o => per_apr_shd.g_old_rec.assignment_position_id,
203: p_assignment_grade_id_o => per_apr_shd.g_old_rec.assignment_grade_id,
204: p_appraisal_system_status_o => per_apr_shd.g_old_rec.appraisal_system_status,
197: p_assignment_id_o => per_apr_shd.g_old_rec.assignment_id ,
198: p_assignment_start_date_o => per_apr_shd.g_old_rec.assignment_start_date ,
199: p_asg_business_group_id_o => per_apr_shd.g_old_rec.assignment_business_group_id ,
200: p_assignment_organization_id_o => per_apr_shd.g_old_rec.assignment_organization_id ,
201: p_assignment_job_id_o => per_apr_shd.g_old_rec.assignment_job_id,
202: p_assignment_position_id_o => per_apr_shd.g_old_rec.assignment_position_id,
203: p_assignment_grade_id_o => per_apr_shd.g_old_rec.assignment_grade_id,
204: p_appraisal_system_status_o => per_apr_shd.g_old_rec.appraisal_system_status,
205: p_potential_readiness_level_o => per_apr_shd.g_old_rec.potential_readiness_level,
198: p_assignment_start_date_o => per_apr_shd.g_old_rec.assignment_start_date ,
199: p_asg_business_group_id_o => per_apr_shd.g_old_rec.assignment_business_group_id ,
200: p_assignment_organization_id_o => per_apr_shd.g_old_rec.assignment_organization_id ,
201: p_assignment_job_id_o => per_apr_shd.g_old_rec.assignment_job_id,
202: p_assignment_position_id_o => per_apr_shd.g_old_rec.assignment_position_id,
203: p_assignment_grade_id_o => per_apr_shd.g_old_rec.assignment_grade_id,
204: p_appraisal_system_status_o => per_apr_shd.g_old_rec.appraisal_system_status,
205: p_potential_readiness_level_o => per_apr_shd.g_old_rec.potential_readiness_level,
206: p_potnl_short_term_workopp_o => per_apr_shd.g_old_rec.potential_short_term_workopp,
199: p_asg_business_group_id_o => per_apr_shd.g_old_rec.assignment_business_group_id ,
200: p_assignment_organization_id_o => per_apr_shd.g_old_rec.assignment_organization_id ,
201: p_assignment_job_id_o => per_apr_shd.g_old_rec.assignment_job_id,
202: p_assignment_position_id_o => per_apr_shd.g_old_rec.assignment_position_id,
203: p_assignment_grade_id_o => per_apr_shd.g_old_rec.assignment_grade_id,
204: p_appraisal_system_status_o => per_apr_shd.g_old_rec.appraisal_system_status,
205: p_potential_readiness_level_o => per_apr_shd.g_old_rec.potential_readiness_level,
206: p_potnl_short_term_workopp_o => per_apr_shd.g_old_rec.potential_short_term_workopp,
207: p_potnl_long_term_workopp_o => per_apr_shd.g_old_rec.potential_long_term_workopp,
200: p_assignment_organization_id_o => per_apr_shd.g_old_rec.assignment_organization_id ,
201: p_assignment_job_id_o => per_apr_shd.g_old_rec.assignment_job_id,
202: p_assignment_position_id_o => per_apr_shd.g_old_rec.assignment_position_id,
203: p_assignment_grade_id_o => per_apr_shd.g_old_rec.assignment_grade_id,
204: p_appraisal_system_status_o => per_apr_shd.g_old_rec.appraisal_system_status,
205: p_potential_readiness_level_o => per_apr_shd.g_old_rec.potential_readiness_level,
206: p_potnl_short_term_workopp_o => per_apr_shd.g_old_rec.potential_short_term_workopp,
207: p_potnl_long_term_workopp_o => per_apr_shd.g_old_rec.potential_long_term_workopp,
208: p_potential_details_o => per_apr_shd.g_old_rec.potential_details,
201: p_assignment_job_id_o => per_apr_shd.g_old_rec.assignment_job_id,
202: p_assignment_position_id_o => per_apr_shd.g_old_rec.assignment_position_id,
203: p_assignment_grade_id_o => per_apr_shd.g_old_rec.assignment_grade_id,
204: p_appraisal_system_status_o => per_apr_shd.g_old_rec.appraisal_system_status,
205: p_potential_readiness_level_o => per_apr_shd.g_old_rec.potential_readiness_level,
206: p_potnl_short_term_workopp_o => per_apr_shd.g_old_rec.potential_short_term_workopp,
207: p_potnl_long_term_workopp_o => per_apr_shd.g_old_rec.potential_long_term_workopp,
208: p_potential_details_o => per_apr_shd.g_old_rec.potential_details,
209: p_event_id_o => per_apr_shd.g_old_rec.event_id,
202: p_assignment_position_id_o => per_apr_shd.g_old_rec.assignment_position_id,
203: p_assignment_grade_id_o => per_apr_shd.g_old_rec.assignment_grade_id,
204: p_appraisal_system_status_o => per_apr_shd.g_old_rec.appraisal_system_status,
205: p_potential_readiness_level_o => per_apr_shd.g_old_rec.potential_readiness_level,
206: p_potnl_short_term_workopp_o => per_apr_shd.g_old_rec.potential_short_term_workopp,
207: p_potnl_long_term_workopp_o => per_apr_shd.g_old_rec.potential_long_term_workopp,
208: p_potential_details_o => per_apr_shd.g_old_rec.potential_details,
209: p_event_id_o => per_apr_shd.g_old_rec.event_id,
210: p_show_competency_ratings_o => per_apr_shd.g_old_rec.show_competency_ratings,
203: p_assignment_grade_id_o => per_apr_shd.g_old_rec.assignment_grade_id,
204: p_appraisal_system_status_o => per_apr_shd.g_old_rec.appraisal_system_status,
205: p_potential_readiness_level_o => per_apr_shd.g_old_rec.potential_readiness_level,
206: p_potnl_short_term_workopp_o => per_apr_shd.g_old_rec.potential_short_term_workopp,
207: p_potnl_long_term_workopp_o => per_apr_shd.g_old_rec.potential_long_term_workopp,
208: p_potential_details_o => per_apr_shd.g_old_rec.potential_details,
209: p_event_id_o => per_apr_shd.g_old_rec.event_id,
210: p_show_competency_ratings_o => per_apr_shd.g_old_rec.show_competency_ratings,
211: p_show_objective_ratings_o => per_apr_shd.g_old_rec.show_objective_ratings,
204: p_appraisal_system_status_o => per_apr_shd.g_old_rec.appraisal_system_status,
205: p_potential_readiness_level_o => per_apr_shd.g_old_rec.potential_readiness_level,
206: p_potnl_short_term_workopp_o => per_apr_shd.g_old_rec.potential_short_term_workopp,
207: p_potnl_long_term_workopp_o => per_apr_shd.g_old_rec.potential_long_term_workopp,
208: p_potential_details_o => per_apr_shd.g_old_rec.potential_details,
209: p_event_id_o => per_apr_shd.g_old_rec.event_id,
210: p_show_competency_ratings_o => per_apr_shd.g_old_rec.show_competency_ratings,
211: p_show_objective_ratings_o => per_apr_shd.g_old_rec.show_objective_ratings,
212: p_show_questionnaire_info_o => per_apr_shd.g_old_rec.show_questionnaire_info,
205: p_potential_readiness_level_o => per_apr_shd.g_old_rec.potential_readiness_level,
206: p_potnl_short_term_workopp_o => per_apr_shd.g_old_rec.potential_short_term_workopp,
207: p_potnl_long_term_workopp_o => per_apr_shd.g_old_rec.potential_long_term_workopp,
208: p_potential_details_o => per_apr_shd.g_old_rec.potential_details,
209: p_event_id_o => per_apr_shd.g_old_rec.event_id,
210: p_show_competency_ratings_o => per_apr_shd.g_old_rec.show_competency_ratings,
211: p_show_objective_ratings_o => per_apr_shd.g_old_rec.show_objective_ratings,
212: p_show_questionnaire_info_o => per_apr_shd.g_old_rec.show_questionnaire_info,
213: p_show_participant_details_o => per_apr_shd.g_old_rec.show_participant_details,
206: p_potnl_short_term_workopp_o => per_apr_shd.g_old_rec.potential_short_term_workopp,
207: p_potnl_long_term_workopp_o => per_apr_shd.g_old_rec.potential_long_term_workopp,
208: p_potential_details_o => per_apr_shd.g_old_rec.potential_details,
209: p_event_id_o => per_apr_shd.g_old_rec.event_id,
210: p_show_competency_ratings_o => per_apr_shd.g_old_rec.show_competency_ratings,
211: p_show_objective_ratings_o => per_apr_shd.g_old_rec.show_objective_ratings,
212: p_show_questionnaire_info_o => per_apr_shd.g_old_rec.show_questionnaire_info,
213: p_show_participant_details_o => per_apr_shd.g_old_rec.show_participant_details,
214: p_show_participant_ratings_o => per_apr_shd.g_old_rec.show_participant_ratings,
207: p_potnl_long_term_workopp_o => per_apr_shd.g_old_rec.potential_long_term_workopp,
208: p_potential_details_o => per_apr_shd.g_old_rec.potential_details,
209: p_event_id_o => per_apr_shd.g_old_rec.event_id,
210: p_show_competency_ratings_o => per_apr_shd.g_old_rec.show_competency_ratings,
211: p_show_objective_ratings_o => per_apr_shd.g_old_rec.show_objective_ratings,
212: p_show_questionnaire_info_o => per_apr_shd.g_old_rec.show_questionnaire_info,
213: p_show_participant_details_o => per_apr_shd.g_old_rec.show_participant_details,
214: p_show_participant_ratings_o => per_apr_shd.g_old_rec.show_participant_ratings,
215: p_show_participant_names_o => per_apr_shd.g_old_rec.show_participant_names,
208: p_potential_details_o => per_apr_shd.g_old_rec.potential_details,
209: p_event_id_o => per_apr_shd.g_old_rec.event_id,
210: p_show_competency_ratings_o => per_apr_shd.g_old_rec.show_competency_ratings,
211: p_show_objective_ratings_o => per_apr_shd.g_old_rec.show_objective_ratings,
212: p_show_questionnaire_info_o => per_apr_shd.g_old_rec.show_questionnaire_info,
213: p_show_participant_details_o => per_apr_shd.g_old_rec.show_participant_details,
214: p_show_participant_ratings_o => per_apr_shd.g_old_rec.show_participant_ratings,
215: p_show_participant_names_o => per_apr_shd.g_old_rec.show_participant_names,
216: p_show_overall_ratings_o => per_apr_shd.g_old_rec.show_overall_ratings,
209: p_event_id_o => per_apr_shd.g_old_rec.event_id,
210: p_show_competency_ratings_o => per_apr_shd.g_old_rec.show_competency_ratings,
211: p_show_objective_ratings_o => per_apr_shd.g_old_rec.show_objective_ratings,
212: p_show_questionnaire_info_o => per_apr_shd.g_old_rec.show_questionnaire_info,
213: p_show_participant_details_o => per_apr_shd.g_old_rec.show_participant_details,
214: p_show_participant_ratings_o => per_apr_shd.g_old_rec.show_participant_ratings,
215: p_show_participant_names_o => per_apr_shd.g_old_rec.show_participant_names,
216: p_show_overall_ratings_o => per_apr_shd.g_old_rec.show_overall_ratings,
217: p_show_overall_comments_o => per_apr_shd.g_old_rec.show_overall_comments,
210: p_show_competency_ratings_o => per_apr_shd.g_old_rec.show_competency_ratings,
211: p_show_objective_ratings_o => per_apr_shd.g_old_rec.show_objective_ratings,
212: p_show_questionnaire_info_o => per_apr_shd.g_old_rec.show_questionnaire_info,
213: p_show_participant_details_o => per_apr_shd.g_old_rec.show_participant_details,
214: p_show_participant_ratings_o => per_apr_shd.g_old_rec.show_participant_ratings,
215: p_show_participant_names_o => per_apr_shd.g_old_rec.show_participant_names,
216: p_show_overall_ratings_o => per_apr_shd.g_old_rec.show_overall_ratings,
217: p_show_overall_comments_o => per_apr_shd.g_old_rec.show_overall_comments,
218: p_update_appraisal_o => per_apr_shd.g_old_rec.update_appraisal,
211: p_show_objective_ratings_o => per_apr_shd.g_old_rec.show_objective_ratings,
212: p_show_questionnaire_info_o => per_apr_shd.g_old_rec.show_questionnaire_info,
213: p_show_participant_details_o => per_apr_shd.g_old_rec.show_participant_details,
214: p_show_participant_ratings_o => per_apr_shd.g_old_rec.show_participant_ratings,
215: p_show_participant_names_o => per_apr_shd.g_old_rec.show_participant_names,
216: p_show_overall_ratings_o => per_apr_shd.g_old_rec.show_overall_ratings,
217: p_show_overall_comments_o => per_apr_shd.g_old_rec.show_overall_comments,
218: p_update_appraisal_o => per_apr_shd.g_old_rec.update_appraisal,
219: p_provide_overall_feedback_o => per_apr_shd.g_old_rec.provide_overall_feedback,
212: p_show_questionnaire_info_o => per_apr_shd.g_old_rec.show_questionnaire_info,
213: p_show_participant_details_o => per_apr_shd.g_old_rec.show_participant_details,
214: p_show_participant_ratings_o => per_apr_shd.g_old_rec.show_participant_ratings,
215: p_show_participant_names_o => per_apr_shd.g_old_rec.show_participant_names,
216: p_show_overall_ratings_o => per_apr_shd.g_old_rec.show_overall_ratings,
217: p_show_overall_comments_o => per_apr_shd.g_old_rec.show_overall_comments,
218: p_update_appraisal_o => per_apr_shd.g_old_rec.update_appraisal,
219: p_provide_overall_feedback_o => per_apr_shd.g_old_rec.provide_overall_feedback,
220: p_appraisee_comments_o => per_apr_shd.g_old_rec.appraisee_comments,
213: p_show_participant_details_o => per_apr_shd.g_old_rec.show_participant_details,
214: p_show_participant_ratings_o => per_apr_shd.g_old_rec.show_participant_ratings,
215: p_show_participant_names_o => per_apr_shd.g_old_rec.show_participant_names,
216: p_show_overall_ratings_o => per_apr_shd.g_old_rec.show_overall_ratings,
217: p_show_overall_comments_o => per_apr_shd.g_old_rec.show_overall_comments,
218: p_update_appraisal_o => per_apr_shd.g_old_rec.update_appraisal,
219: p_provide_overall_feedback_o => per_apr_shd.g_old_rec.provide_overall_feedback,
220: p_appraisee_comments_o => per_apr_shd.g_old_rec.appraisee_comments,
221: p_plan_id_o => per_apr_shd.g_old_rec.plan_id,
214: p_show_participant_ratings_o => per_apr_shd.g_old_rec.show_participant_ratings,
215: p_show_participant_names_o => per_apr_shd.g_old_rec.show_participant_names,
216: p_show_overall_ratings_o => per_apr_shd.g_old_rec.show_overall_ratings,
217: p_show_overall_comments_o => per_apr_shd.g_old_rec.show_overall_comments,
218: p_update_appraisal_o => per_apr_shd.g_old_rec.update_appraisal,
219: p_provide_overall_feedback_o => per_apr_shd.g_old_rec.provide_overall_feedback,
220: p_appraisee_comments_o => per_apr_shd.g_old_rec.appraisee_comments,
221: p_plan_id_o => per_apr_shd.g_old_rec.plan_id,
222: p_offline_status_o => per_apr_shd.g_old_rec.offline_status
215: p_show_participant_names_o => per_apr_shd.g_old_rec.show_participant_names,
216: p_show_overall_ratings_o => per_apr_shd.g_old_rec.show_overall_ratings,
217: p_show_overall_comments_o => per_apr_shd.g_old_rec.show_overall_comments,
218: p_update_appraisal_o => per_apr_shd.g_old_rec.update_appraisal,
219: p_provide_overall_feedback_o => per_apr_shd.g_old_rec.provide_overall_feedback,
220: p_appraisee_comments_o => per_apr_shd.g_old_rec.appraisee_comments,
221: p_plan_id_o => per_apr_shd.g_old_rec.plan_id,
222: p_offline_status_o => per_apr_shd.g_old_rec.offline_status
223: );
216: p_show_overall_ratings_o => per_apr_shd.g_old_rec.show_overall_ratings,
217: p_show_overall_comments_o => per_apr_shd.g_old_rec.show_overall_comments,
218: p_update_appraisal_o => per_apr_shd.g_old_rec.update_appraisal,
219: p_provide_overall_feedback_o => per_apr_shd.g_old_rec.provide_overall_feedback,
220: p_appraisee_comments_o => per_apr_shd.g_old_rec.appraisee_comments,
221: p_plan_id_o => per_apr_shd.g_old_rec.plan_id,
222: p_offline_status_o => per_apr_shd.g_old_rec.offline_status
223: );
224: exception
217: p_show_overall_comments_o => per_apr_shd.g_old_rec.show_overall_comments,
218: p_update_appraisal_o => per_apr_shd.g_old_rec.update_appraisal,
219: p_provide_overall_feedback_o => per_apr_shd.g_old_rec.provide_overall_feedback,
220: p_appraisee_comments_o => per_apr_shd.g_old_rec.appraisee_comments,
221: p_plan_id_o => per_apr_shd.g_old_rec.plan_id,
222: p_offline_status_o => per_apr_shd.g_old_rec.offline_status
223: );
224: exception
225: when hr_api.cannot_find_prog_unit then
218: p_update_appraisal_o => per_apr_shd.g_old_rec.update_appraisal,
219: p_provide_overall_feedback_o => per_apr_shd.g_old_rec.provide_overall_feedback,
220: p_appraisee_comments_o => per_apr_shd.g_old_rec.appraisee_comments,
221: p_plan_id_o => per_apr_shd.g_old_rec.plan_id,
222: p_offline_status_o => per_apr_shd.g_old_rec.offline_status
223: );
224: exception
225: when hr_api.cannot_find_prog_unit then
226: hr_api.cannot_find_prog_unit_error
237: -- |---------------------------------< del >----------------------------------|
238: -- ---------------------------------------------------------------------------+
239: Procedure del
240: (
241: p_rec in per_apr_shd.g_rec_type,
242: p_validate in boolean default false
243: ) is
244:
245: l_proc varchar2(72) := g_package||'del';
257: End If;
258:
259: -- We must lock the row which we need to delete.
260:
261: per_apr_shd.lck
262: (
263: p_rec.appraisal_id,
264: p_rec.object_version_number
265: );
309: p_object_version_number in number,
310: p_validate in boolean default false
311: ) is
312:
313: l_rec per_apr_shd.g_rec_type;
314: l_proc varchar2(72) := g_package||'del';
315:
316: Begin
317: hr_utility.set_location('Entering:'||l_proc, 5);