44: -- Internal Table Handler Use Only.
45:
46: -- {End Of Comments}
47: -- ---------------------------------------------------------------------------+
48: Procedure update_dml(p_rec in out nocopy per_apr_shd.g_rec_type) is
49:
50: l_proc varchar2(72) := g_package||'update_dml';
51:
52: Begin
132:
133: Exception
134: When hr_api.check_integrity_violated Then
135: -- A check constraint has been violated
136: per_apr_shd.constraint_error
137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When hr_api.parent_integrity_violated Then
139: -- Parent integrity has been violated
140: per_apr_shd.constraint_error
136: per_apr_shd.constraint_error
137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When hr_api.parent_integrity_violated Then
139: -- Parent integrity has been violated
140: per_apr_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When hr_api.unique_integrity_violated Then
143: -- Unique integrity has been violated
144: per_apr_shd.constraint_error
140: per_apr_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When hr_api.unique_integrity_violated Then
143: -- Unique integrity has been violated
144: per_apr_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When Others Then
147: Raise;
148: End update_dml;
178: -- Internal Table Handler Use Only.
179:
180: -- {End Of Comments}
181: -- ---------------------------------------------------------------------------+
182: Procedure pre_update(p_rec in per_apr_shd.g_rec_type) is
183:
184: l_proc varchar2(72) := g_package||'pre_update';
185:
186: Begin
220: -- Internal Table Handler Use Only.
221:
222: -- {End Of Comments}
223: -- ---------------------------------------------------------------------------+
224: Procedure post_update(p_rec in per_apr_shd.g_rec_type) is
225:
226: l_proc varchar2(72) := g_package||'post_update';
227:
228: Begin
288: p_potential_details => p_rec.potential_details,
289: p_event_id => p_rec.event_id,
290: p_offline_status => p_rec.offline_status,
291: p_retention_potential => p_rec.retention_potential,
292: p_business_group_id_o => per_apr_shd.g_old_rec.business_group_id ,
293: p_appraisal_template_id_o => per_apr_shd.g_old_rec.appraisal_template_id ,
294: p_appraisee_person_id_o => per_apr_shd.g_old_rec.appraisee_person_id ,
295: p_appraiser_person_id_o => per_apr_shd.g_old_rec.appraiser_person_id ,
296: p_appraisal_date_o => per_apr_shd.g_old_rec.appraisal_date ,
289: p_event_id => p_rec.event_id,
290: p_offline_status => p_rec.offline_status,
291: p_retention_potential => p_rec.retention_potential,
292: p_business_group_id_o => per_apr_shd.g_old_rec.business_group_id ,
293: p_appraisal_template_id_o => per_apr_shd.g_old_rec.appraisal_template_id ,
294: p_appraisee_person_id_o => per_apr_shd.g_old_rec.appraisee_person_id ,
295: p_appraiser_person_id_o => per_apr_shd.g_old_rec.appraiser_person_id ,
296: p_appraisal_date_o => per_apr_shd.g_old_rec.appraisal_date ,
297: p_group_date_o => per_apr_shd.g_old_rec.group_date ,
290: p_offline_status => p_rec.offline_status,
291: p_retention_potential => p_rec.retention_potential,
292: p_business_group_id_o => per_apr_shd.g_old_rec.business_group_id ,
293: p_appraisal_template_id_o => per_apr_shd.g_old_rec.appraisal_template_id ,
294: p_appraisee_person_id_o => per_apr_shd.g_old_rec.appraisee_person_id ,
295: p_appraiser_person_id_o => per_apr_shd.g_old_rec.appraiser_person_id ,
296: p_appraisal_date_o => per_apr_shd.g_old_rec.appraisal_date ,
297: p_group_date_o => per_apr_shd.g_old_rec.group_date ,
298: p_group_initiator_id_o => per_apr_shd.g_old_rec.group_initiator_id ,
291: p_retention_potential => p_rec.retention_potential,
292: p_business_group_id_o => per_apr_shd.g_old_rec.business_group_id ,
293: p_appraisal_template_id_o => per_apr_shd.g_old_rec.appraisal_template_id ,
294: p_appraisee_person_id_o => per_apr_shd.g_old_rec.appraisee_person_id ,
295: p_appraiser_person_id_o => per_apr_shd.g_old_rec.appraiser_person_id ,
296: p_appraisal_date_o => per_apr_shd.g_old_rec.appraisal_date ,
297: p_group_date_o => per_apr_shd.g_old_rec.group_date ,
298: p_group_initiator_id_o => per_apr_shd.g_old_rec.group_initiator_id ,
299: p_appraisal_period_end_date_o => per_apr_shd.g_old_rec.appraisal_period_end_date ,
292: p_business_group_id_o => per_apr_shd.g_old_rec.business_group_id ,
293: p_appraisal_template_id_o => per_apr_shd.g_old_rec.appraisal_template_id ,
294: p_appraisee_person_id_o => per_apr_shd.g_old_rec.appraisee_person_id ,
295: p_appraiser_person_id_o => per_apr_shd.g_old_rec.appraiser_person_id ,
296: p_appraisal_date_o => per_apr_shd.g_old_rec.appraisal_date ,
297: p_group_date_o => per_apr_shd.g_old_rec.group_date ,
298: p_group_initiator_id_o => per_apr_shd.g_old_rec.group_initiator_id ,
299: p_appraisal_period_end_date_o => per_apr_shd.g_old_rec.appraisal_period_end_date ,
300: p_appraisal_period_start_dat_o => per_apr_shd.g_old_rec.appraisal_period_start_date,
293: p_appraisal_template_id_o => per_apr_shd.g_old_rec.appraisal_template_id ,
294: p_appraisee_person_id_o => per_apr_shd.g_old_rec.appraisee_person_id ,
295: p_appraiser_person_id_o => per_apr_shd.g_old_rec.appraiser_person_id ,
296: p_appraisal_date_o => per_apr_shd.g_old_rec.appraisal_date ,
297: p_group_date_o => per_apr_shd.g_old_rec.group_date ,
298: p_group_initiator_id_o => per_apr_shd.g_old_rec.group_initiator_id ,
299: p_appraisal_period_end_date_o => per_apr_shd.g_old_rec.appraisal_period_end_date ,
300: p_appraisal_period_start_dat_o => per_apr_shd.g_old_rec.appraisal_period_start_date,
301: p_type_o => per_apr_shd.g_old_rec.type ,
294: p_appraisee_person_id_o => per_apr_shd.g_old_rec.appraisee_person_id ,
295: p_appraiser_person_id_o => per_apr_shd.g_old_rec.appraiser_person_id ,
296: p_appraisal_date_o => per_apr_shd.g_old_rec.appraisal_date ,
297: p_group_date_o => per_apr_shd.g_old_rec.group_date ,
298: p_group_initiator_id_o => per_apr_shd.g_old_rec.group_initiator_id ,
299: p_appraisal_period_end_date_o => per_apr_shd.g_old_rec.appraisal_period_end_date ,
300: p_appraisal_period_start_dat_o => per_apr_shd.g_old_rec.appraisal_period_start_date,
301: p_type_o => per_apr_shd.g_old_rec.type ,
302: p_next_appraisal_date_o => per_apr_shd.g_old_rec.next_appraisal_date ,
295: p_appraiser_person_id_o => per_apr_shd.g_old_rec.appraiser_person_id ,
296: p_appraisal_date_o => per_apr_shd.g_old_rec.appraisal_date ,
297: p_group_date_o => per_apr_shd.g_old_rec.group_date ,
298: p_group_initiator_id_o => per_apr_shd.g_old_rec.group_initiator_id ,
299: p_appraisal_period_end_date_o => per_apr_shd.g_old_rec.appraisal_period_end_date ,
300: p_appraisal_period_start_dat_o => per_apr_shd.g_old_rec.appraisal_period_start_date,
301: p_type_o => per_apr_shd.g_old_rec.type ,
302: p_next_appraisal_date_o => per_apr_shd.g_old_rec.next_appraisal_date ,
303: p_status_o => per_apr_shd.g_old_rec.status ,
296: p_appraisal_date_o => per_apr_shd.g_old_rec.appraisal_date ,
297: p_group_date_o => per_apr_shd.g_old_rec.group_date ,
298: p_group_initiator_id_o => per_apr_shd.g_old_rec.group_initiator_id ,
299: p_appraisal_period_end_date_o => per_apr_shd.g_old_rec.appraisal_period_end_date ,
300: p_appraisal_period_start_dat_o => per_apr_shd.g_old_rec.appraisal_period_start_date,
301: p_type_o => per_apr_shd.g_old_rec.type ,
302: p_next_appraisal_date_o => per_apr_shd.g_old_rec.next_appraisal_date ,
303: p_status_o => per_apr_shd.g_old_rec.status ,
304: p_comments_o => per_apr_shd.g_old_rec.comments ,
297: p_group_date_o => per_apr_shd.g_old_rec.group_date ,
298: p_group_initiator_id_o => per_apr_shd.g_old_rec.group_initiator_id ,
299: p_appraisal_period_end_date_o => per_apr_shd.g_old_rec.appraisal_period_end_date ,
300: p_appraisal_period_start_dat_o => per_apr_shd.g_old_rec.appraisal_period_start_date,
301: p_type_o => per_apr_shd.g_old_rec.type ,
302: p_next_appraisal_date_o => per_apr_shd.g_old_rec.next_appraisal_date ,
303: p_status_o => per_apr_shd.g_old_rec.status ,
304: p_comments_o => per_apr_shd.g_old_rec.comments ,
305: p_overall_performance_level_o => per_apr_shd.g_old_rec.overall_performance_level_id,
298: p_group_initiator_id_o => per_apr_shd.g_old_rec.group_initiator_id ,
299: p_appraisal_period_end_date_o => per_apr_shd.g_old_rec.appraisal_period_end_date ,
300: p_appraisal_period_start_dat_o => per_apr_shd.g_old_rec.appraisal_period_start_date,
301: p_type_o => per_apr_shd.g_old_rec.type ,
302: p_next_appraisal_date_o => per_apr_shd.g_old_rec.next_appraisal_date ,
303: p_status_o => per_apr_shd.g_old_rec.status ,
304: p_comments_o => per_apr_shd.g_old_rec.comments ,
305: p_overall_performance_level_o => per_apr_shd.g_old_rec.overall_performance_level_id,
306: p_open_o => per_apr_shd.g_old_rec.open ,
299: p_appraisal_period_end_date_o => per_apr_shd.g_old_rec.appraisal_period_end_date ,
300: p_appraisal_period_start_dat_o => per_apr_shd.g_old_rec.appraisal_period_start_date,
301: p_type_o => per_apr_shd.g_old_rec.type ,
302: p_next_appraisal_date_o => per_apr_shd.g_old_rec.next_appraisal_date ,
303: p_status_o => per_apr_shd.g_old_rec.status ,
304: p_comments_o => per_apr_shd.g_old_rec.comments ,
305: p_overall_performance_level_o => per_apr_shd.g_old_rec.overall_performance_level_id,
306: p_open_o => per_apr_shd.g_old_rec.open ,
307: p_attribute_category_o => per_apr_shd.g_old_rec.attribute_category ,
300: p_appraisal_period_start_dat_o => per_apr_shd.g_old_rec.appraisal_period_start_date,
301: p_type_o => per_apr_shd.g_old_rec.type ,
302: p_next_appraisal_date_o => per_apr_shd.g_old_rec.next_appraisal_date ,
303: p_status_o => per_apr_shd.g_old_rec.status ,
304: p_comments_o => per_apr_shd.g_old_rec.comments ,
305: p_overall_performance_level_o => per_apr_shd.g_old_rec.overall_performance_level_id,
306: p_open_o => per_apr_shd.g_old_rec.open ,
307: p_attribute_category_o => per_apr_shd.g_old_rec.attribute_category ,
308: p_attribute1_o => per_apr_shd.g_old_rec.attribute1 ,
301: p_type_o => per_apr_shd.g_old_rec.type ,
302: p_next_appraisal_date_o => per_apr_shd.g_old_rec.next_appraisal_date ,
303: p_status_o => per_apr_shd.g_old_rec.status ,
304: p_comments_o => per_apr_shd.g_old_rec.comments ,
305: p_overall_performance_level_o => per_apr_shd.g_old_rec.overall_performance_level_id,
306: p_open_o => per_apr_shd.g_old_rec.open ,
307: p_attribute_category_o => per_apr_shd.g_old_rec.attribute_category ,
308: p_attribute1_o => per_apr_shd.g_old_rec.attribute1 ,
309: p_attribute2_o => per_apr_shd.g_old_rec.attribute2 ,
302: p_next_appraisal_date_o => per_apr_shd.g_old_rec.next_appraisal_date ,
303: p_status_o => per_apr_shd.g_old_rec.status ,
304: p_comments_o => per_apr_shd.g_old_rec.comments ,
305: p_overall_performance_level_o => per_apr_shd.g_old_rec.overall_performance_level_id,
306: p_open_o => per_apr_shd.g_old_rec.open ,
307: p_attribute_category_o => per_apr_shd.g_old_rec.attribute_category ,
308: p_attribute1_o => per_apr_shd.g_old_rec.attribute1 ,
309: p_attribute2_o => per_apr_shd.g_old_rec.attribute2 ,
310: p_attribute3_o => per_apr_shd.g_old_rec.attribute3 ,
303: p_status_o => per_apr_shd.g_old_rec.status ,
304: p_comments_o => per_apr_shd.g_old_rec.comments ,
305: p_overall_performance_level_o => per_apr_shd.g_old_rec.overall_performance_level_id,
306: p_open_o => per_apr_shd.g_old_rec.open ,
307: p_attribute_category_o => per_apr_shd.g_old_rec.attribute_category ,
308: p_attribute1_o => per_apr_shd.g_old_rec.attribute1 ,
309: p_attribute2_o => per_apr_shd.g_old_rec.attribute2 ,
310: p_attribute3_o => per_apr_shd.g_old_rec.attribute3 ,
311: p_attribute4_o => per_apr_shd.g_old_rec.attribute4 ,
304: p_comments_o => per_apr_shd.g_old_rec.comments ,
305: p_overall_performance_level_o => per_apr_shd.g_old_rec.overall_performance_level_id,
306: p_open_o => per_apr_shd.g_old_rec.open ,
307: p_attribute_category_o => per_apr_shd.g_old_rec.attribute_category ,
308: p_attribute1_o => per_apr_shd.g_old_rec.attribute1 ,
309: p_attribute2_o => per_apr_shd.g_old_rec.attribute2 ,
310: p_attribute3_o => per_apr_shd.g_old_rec.attribute3 ,
311: p_attribute4_o => per_apr_shd.g_old_rec.attribute4 ,
312: p_attribute5_o => per_apr_shd.g_old_rec.attribute5 ,
305: p_overall_performance_level_o => per_apr_shd.g_old_rec.overall_performance_level_id,
306: p_open_o => per_apr_shd.g_old_rec.open ,
307: p_attribute_category_o => per_apr_shd.g_old_rec.attribute_category ,
308: p_attribute1_o => per_apr_shd.g_old_rec.attribute1 ,
309: p_attribute2_o => per_apr_shd.g_old_rec.attribute2 ,
310: p_attribute3_o => per_apr_shd.g_old_rec.attribute3 ,
311: p_attribute4_o => per_apr_shd.g_old_rec.attribute4 ,
312: p_attribute5_o => per_apr_shd.g_old_rec.attribute5 ,
313: p_attribute6_o => per_apr_shd.g_old_rec.attribute6 ,
306: p_open_o => per_apr_shd.g_old_rec.open ,
307: p_attribute_category_o => per_apr_shd.g_old_rec.attribute_category ,
308: p_attribute1_o => per_apr_shd.g_old_rec.attribute1 ,
309: p_attribute2_o => per_apr_shd.g_old_rec.attribute2 ,
310: p_attribute3_o => per_apr_shd.g_old_rec.attribute3 ,
311: p_attribute4_o => per_apr_shd.g_old_rec.attribute4 ,
312: p_attribute5_o => per_apr_shd.g_old_rec.attribute5 ,
313: p_attribute6_o => per_apr_shd.g_old_rec.attribute6 ,
314: p_attribute7_o => per_apr_shd.g_old_rec.attribute7 ,
307: p_attribute_category_o => per_apr_shd.g_old_rec.attribute_category ,
308: p_attribute1_o => per_apr_shd.g_old_rec.attribute1 ,
309: p_attribute2_o => per_apr_shd.g_old_rec.attribute2 ,
310: p_attribute3_o => per_apr_shd.g_old_rec.attribute3 ,
311: p_attribute4_o => per_apr_shd.g_old_rec.attribute4 ,
312: p_attribute5_o => per_apr_shd.g_old_rec.attribute5 ,
313: p_attribute6_o => per_apr_shd.g_old_rec.attribute6 ,
314: p_attribute7_o => per_apr_shd.g_old_rec.attribute7 ,
315: p_attribute8_o => per_apr_shd.g_old_rec.attribute8 ,
308: p_attribute1_o => per_apr_shd.g_old_rec.attribute1 ,
309: p_attribute2_o => per_apr_shd.g_old_rec.attribute2 ,
310: p_attribute3_o => per_apr_shd.g_old_rec.attribute3 ,
311: p_attribute4_o => per_apr_shd.g_old_rec.attribute4 ,
312: p_attribute5_o => per_apr_shd.g_old_rec.attribute5 ,
313: p_attribute6_o => per_apr_shd.g_old_rec.attribute6 ,
314: p_attribute7_o => per_apr_shd.g_old_rec.attribute7 ,
315: p_attribute8_o => per_apr_shd.g_old_rec.attribute8 ,
316: p_attribute9_o => per_apr_shd.g_old_rec.attribute9 ,
309: p_attribute2_o => per_apr_shd.g_old_rec.attribute2 ,
310: p_attribute3_o => per_apr_shd.g_old_rec.attribute3 ,
311: p_attribute4_o => per_apr_shd.g_old_rec.attribute4 ,
312: p_attribute5_o => per_apr_shd.g_old_rec.attribute5 ,
313: p_attribute6_o => per_apr_shd.g_old_rec.attribute6 ,
314: p_attribute7_o => per_apr_shd.g_old_rec.attribute7 ,
315: p_attribute8_o => per_apr_shd.g_old_rec.attribute8 ,
316: p_attribute9_o => per_apr_shd.g_old_rec.attribute9 ,
317: p_attribute10_o => per_apr_shd.g_old_rec.attribute10 ,
310: p_attribute3_o => per_apr_shd.g_old_rec.attribute3 ,
311: p_attribute4_o => per_apr_shd.g_old_rec.attribute4 ,
312: p_attribute5_o => per_apr_shd.g_old_rec.attribute5 ,
313: p_attribute6_o => per_apr_shd.g_old_rec.attribute6 ,
314: p_attribute7_o => per_apr_shd.g_old_rec.attribute7 ,
315: p_attribute8_o => per_apr_shd.g_old_rec.attribute8 ,
316: p_attribute9_o => per_apr_shd.g_old_rec.attribute9 ,
317: p_attribute10_o => per_apr_shd.g_old_rec.attribute10 ,
318: p_attribute11_o => per_apr_shd.g_old_rec.attribute11 ,
311: p_attribute4_o => per_apr_shd.g_old_rec.attribute4 ,
312: p_attribute5_o => per_apr_shd.g_old_rec.attribute5 ,
313: p_attribute6_o => per_apr_shd.g_old_rec.attribute6 ,
314: p_attribute7_o => per_apr_shd.g_old_rec.attribute7 ,
315: p_attribute8_o => per_apr_shd.g_old_rec.attribute8 ,
316: p_attribute9_o => per_apr_shd.g_old_rec.attribute9 ,
317: p_attribute10_o => per_apr_shd.g_old_rec.attribute10 ,
318: p_attribute11_o => per_apr_shd.g_old_rec.attribute11 ,
319: p_attribute12_o => per_apr_shd.g_old_rec.attribute12 ,
312: p_attribute5_o => per_apr_shd.g_old_rec.attribute5 ,
313: p_attribute6_o => per_apr_shd.g_old_rec.attribute6 ,
314: p_attribute7_o => per_apr_shd.g_old_rec.attribute7 ,
315: p_attribute8_o => per_apr_shd.g_old_rec.attribute8 ,
316: p_attribute9_o => per_apr_shd.g_old_rec.attribute9 ,
317: p_attribute10_o => per_apr_shd.g_old_rec.attribute10 ,
318: p_attribute11_o => per_apr_shd.g_old_rec.attribute11 ,
319: p_attribute12_o => per_apr_shd.g_old_rec.attribute12 ,
320: p_attribute13_o => per_apr_shd.g_old_rec.attribute13 ,
313: p_attribute6_o => per_apr_shd.g_old_rec.attribute6 ,
314: p_attribute7_o => per_apr_shd.g_old_rec.attribute7 ,
315: p_attribute8_o => per_apr_shd.g_old_rec.attribute8 ,
316: p_attribute9_o => per_apr_shd.g_old_rec.attribute9 ,
317: p_attribute10_o => per_apr_shd.g_old_rec.attribute10 ,
318: p_attribute11_o => per_apr_shd.g_old_rec.attribute11 ,
319: p_attribute12_o => per_apr_shd.g_old_rec.attribute12 ,
320: p_attribute13_o => per_apr_shd.g_old_rec.attribute13 ,
321: p_attribute14_o => per_apr_shd.g_old_rec.attribute14 ,
314: p_attribute7_o => per_apr_shd.g_old_rec.attribute7 ,
315: p_attribute8_o => per_apr_shd.g_old_rec.attribute8 ,
316: p_attribute9_o => per_apr_shd.g_old_rec.attribute9 ,
317: p_attribute10_o => per_apr_shd.g_old_rec.attribute10 ,
318: p_attribute11_o => per_apr_shd.g_old_rec.attribute11 ,
319: p_attribute12_o => per_apr_shd.g_old_rec.attribute12 ,
320: p_attribute13_o => per_apr_shd.g_old_rec.attribute13 ,
321: p_attribute14_o => per_apr_shd.g_old_rec.attribute14 ,
322: p_attribute15_o => per_apr_shd.g_old_rec.attribute15 ,
315: p_attribute8_o => per_apr_shd.g_old_rec.attribute8 ,
316: p_attribute9_o => per_apr_shd.g_old_rec.attribute9 ,
317: p_attribute10_o => per_apr_shd.g_old_rec.attribute10 ,
318: p_attribute11_o => per_apr_shd.g_old_rec.attribute11 ,
319: p_attribute12_o => per_apr_shd.g_old_rec.attribute12 ,
320: p_attribute13_o => per_apr_shd.g_old_rec.attribute13 ,
321: p_attribute14_o => per_apr_shd.g_old_rec.attribute14 ,
322: p_attribute15_o => per_apr_shd.g_old_rec.attribute15 ,
323: p_attribute16_o => per_apr_shd.g_old_rec.attribute16 ,
316: p_attribute9_o => per_apr_shd.g_old_rec.attribute9 ,
317: p_attribute10_o => per_apr_shd.g_old_rec.attribute10 ,
318: p_attribute11_o => per_apr_shd.g_old_rec.attribute11 ,
319: p_attribute12_o => per_apr_shd.g_old_rec.attribute12 ,
320: p_attribute13_o => per_apr_shd.g_old_rec.attribute13 ,
321: p_attribute14_o => per_apr_shd.g_old_rec.attribute14 ,
322: p_attribute15_o => per_apr_shd.g_old_rec.attribute15 ,
323: p_attribute16_o => per_apr_shd.g_old_rec.attribute16 ,
324: p_attribute17_o => per_apr_shd.g_old_rec.attribute17 ,
317: p_attribute10_o => per_apr_shd.g_old_rec.attribute10 ,
318: p_attribute11_o => per_apr_shd.g_old_rec.attribute11 ,
319: p_attribute12_o => per_apr_shd.g_old_rec.attribute12 ,
320: p_attribute13_o => per_apr_shd.g_old_rec.attribute13 ,
321: p_attribute14_o => per_apr_shd.g_old_rec.attribute14 ,
322: p_attribute15_o => per_apr_shd.g_old_rec.attribute15 ,
323: p_attribute16_o => per_apr_shd.g_old_rec.attribute16 ,
324: p_attribute17_o => per_apr_shd.g_old_rec.attribute17 ,
325: p_attribute18_o => per_apr_shd.g_old_rec.attribute18 ,
318: p_attribute11_o => per_apr_shd.g_old_rec.attribute11 ,
319: p_attribute12_o => per_apr_shd.g_old_rec.attribute12 ,
320: p_attribute13_o => per_apr_shd.g_old_rec.attribute13 ,
321: p_attribute14_o => per_apr_shd.g_old_rec.attribute14 ,
322: p_attribute15_o => per_apr_shd.g_old_rec.attribute15 ,
323: p_attribute16_o => per_apr_shd.g_old_rec.attribute16 ,
324: p_attribute17_o => per_apr_shd.g_old_rec.attribute17 ,
325: p_attribute18_o => per_apr_shd.g_old_rec.attribute18 ,
326: p_attribute19_o => per_apr_shd.g_old_rec.attribute19 ,
319: p_attribute12_o => per_apr_shd.g_old_rec.attribute12 ,
320: p_attribute13_o => per_apr_shd.g_old_rec.attribute13 ,
321: p_attribute14_o => per_apr_shd.g_old_rec.attribute14 ,
322: p_attribute15_o => per_apr_shd.g_old_rec.attribute15 ,
323: p_attribute16_o => per_apr_shd.g_old_rec.attribute16 ,
324: p_attribute17_o => per_apr_shd.g_old_rec.attribute17 ,
325: p_attribute18_o => per_apr_shd.g_old_rec.attribute18 ,
326: p_attribute19_o => per_apr_shd.g_old_rec.attribute19 ,
327: p_attribute20_o => per_apr_shd.g_old_rec.attribute20 ,
320: p_attribute13_o => per_apr_shd.g_old_rec.attribute13 ,
321: p_attribute14_o => per_apr_shd.g_old_rec.attribute14 ,
322: p_attribute15_o => per_apr_shd.g_old_rec.attribute15 ,
323: p_attribute16_o => per_apr_shd.g_old_rec.attribute16 ,
324: p_attribute17_o => per_apr_shd.g_old_rec.attribute17 ,
325: p_attribute18_o => per_apr_shd.g_old_rec.attribute18 ,
326: p_attribute19_o => per_apr_shd.g_old_rec.attribute19 ,
327: p_attribute20_o => per_apr_shd.g_old_rec.attribute20 ,
328: p_object_version_number_o => per_apr_shd.g_old_rec.object_version_number,
321: p_attribute14_o => per_apr_shd.g_old_rec.attribute14 ,
322: p_attribute15_o => per_apr_shd.g_old_rec.attribute15 ,
323: p_attribute16_o => per_apr_shd.g_old_rec.attribute16 ,
324: p_attribute17_o => per_apr_shd.g_old_rec.attribute17 ,
325: p_attribute18_o => per_apr_shd.g_old_rec.attribute18 ,
326: p_attribute19_o => per_apr_shd.g_old_rec.attribute19 ,
327: p_attribute20_o => per_apr_shd.g_old_rec.attribute20 ,
328: p_object_version_number_o => per_apr_shd.g_old_rec.object_version_number,
329: p_system_type_o => per_apr_shd.g_old_rec.system_type ,
322: p_attribute15_o => per_apr_shd.g_old_rec.attribute15 ,
323: p_attribute16_o => per_apr_shd.g_old_rec.attribute16 ,
324: p_attribute17_o => per_apr_shd.g_old_rec.attribute17 ,
325: p_attribute18_o => per_apr_shd.g_old_rec.attribute18 ,
326: p_attribute19_o => per_apr_shd.g_old_rec.attribute19 ,
327: p_attribute20_o => per_apr_shd.g_old_rec.attribute20 ,
328: p_object_version_number_o => per_apr_shd.g_old_rec.object_version_number,
329: p_system_type_o => per_apr_shd.g_old_rec.system_type ,
330: p_system_params_o => per_apr_shd.g_old_rec.system_params,
323: p_attribute16_o => per_apr_shd.g_old_rec.attribute16 ,
324: p_attribute17_o => per_apr_shd.g_old_rec.attribute17 ,
325: p_attribute18_o => per_apr_shd.g_old_rec.attribute18 ,
326: p_attribute19_o => per_apr_shd.g_old_rec.attribute19 ,
327: p_attribute20_o => per_apr_shd.g_old_rec.attribute20 ,
328: p_object_version_number_o => per_apr_shd.g_old_rec.object_version_number,
329: p_system_type_o => per_apr_shd.g_old_rec.system_type ,
330: p_system_params_o => per_apr_shd.g_old_rec.system_params,
331: p_appraisee_access_o => per_apr_shd.g_old_rec.appraisee_access ,
324: p_attribute17_o => per_apr_shd.g_old_rec.attribute17 ,
325: p_attribute18_o => per_apr_shd.g_old_rec.attribute18 ,
326: p_attribute19_o => per_apr_shd.g_old_rec.attribute19 ,
327: p_attribute20_o => per_apr_shd.g_old_rec.attribute20 ,
328: p_object_version_number_o => per_apr_shd.g_old_rec.object_version_number,
329: p_system_type_o => per_apr_shd.g_old_rec.system_type ,
330: p_system_params_o => per_apr_shd.g_old_rec.system_params,
331: p_appraisee_access_o => per_apr_shd.g_old_rec.appraisee_access ,
332: p_main_appraiser_id_o => per_apr_shd.g_old_rec.main_appraiser_id ,
325: p_attribute18_o => per_apr_shd.g_old_rec.attribute18 ,
326: p_attribute19_o => per_apr_shd.g_old_rec.attribute19 ,
327: p_attribute20_o => per_apr_shd.g_old_rec.attribute20 ,
328: p_object_version_number_o => per_apr_shd.g_old_rec.object_version_number,
329: p_system_type_o => per_apr_shd.g_old_rec.system_type ,
330: p_system_params_o => per_apr_shd.g_old_rec.system_params,
331: p_appraisee_access_o => per_apr_shd.g_old_rec.appraisee_access ,
332: p_main_appraiser_id_o => per_apr_shd.g_old_rec.main_appraiser_id ,
333: p_assignment_id_o => per_apr_shd.g_old_rec.assignment_id ,
326: p_attribute19_o => per_apr_shd.g_old_rec.attribute19 ,
327: p_attribute20_o => per_apr_shd.g_old_rec.attribute20 ,
328: p_object_version_number_o => per_apr_shd.g_old_rec.object_version_number,
329: p_system_type_o => per_apr_shd.g_old_rec.system_type ,
330: p_system_params_o => per_apr_shd.g_old_rec.system_params,
331: p_appraisee_access_o => per_apr_shd.g_old_rec.appraisee_access ,
332: p_main_appraiser_id_o => per_apr_shd.g_old_rec.main_appraiser_id ,
333: p_assignment_id_o => per_apr_shd.g_old_rec.assignment_id ,
334: p_assignment_start_date_o => per_apr_shd.g_old_rec.assignment_start_date,
327: p_attribute20_o => per_apr_shd.g_old_rec.attribute20 ,
328: p_object_version_number_o => per_apr_shd.g_old_rec.object_version_number,
329: p_system_type_o => per_apr_shd.g_old_rec.system_type ,
330: p_system_params_o => per_apr_shd.g_old_rec.system_params,
331: p_appraisee_access_o => per_apr_shd.g_old_rec.appraisee_access ,
332: p_main_appraiser_id_o => per_apr_shd.g_old_rec.main_appraiser_id ,
333: p_assignment_id_o => per_apr_shd.g_old_rec.assignment_id ,
334: p_assignment_start_date_o => per_apr_shd.g_old_rec.assignment_start_date,
335: p_asg_business_group_id_o => per_apr_shd.g_old_rec.assignment_business_group_id,
328: p_object_version_number_o => per_apr_shd.g_old_rec.object_version_number,
329: p_system_type_o => per_apr_shd.g_old_rec.system_type ,
330: p_system_params_o => per_apr_shd.g_old_rec.system_params,
331: p_appraisee_access_o => per_apr_shd.g_old_rec.appraisee_access ,
332: p_main_appraiser_id_o => per_apr_shd.g_old_rec.main_appraiser_id ,
333: p_assignment_id_o => per_apr_shd.g_old_rec.assignment_id ,
334: p_assignment_start_date_o => per_apr_shd.g_old_rec.assignment_start_date,
335: p_asg_business_group_id_o => per_apr_shd.g_old_rec.assignment_business_group_id,
336: p_assignment_organization_id_o => per_apr_shd.g_old_rec.assignment_organization_id,
329: p_system_type_o => per_apr_shd.g_old_rec.system_type ,
330: p_system_params_o => per_apr_shd.g_old_rec.system_params,
331: p_appraisee_access_o => per_apr_shd.g_old_rec.appraisee_access ,
332: p_main_appraiser_id_o => per_apr_shd.g_old_rec.main_appraiser_id ,
333: p_assignment_id_o => per_apr_shd.g_old_rec.assignment_id ,
334: p_assignment_start_date_o => per_apr_shd.g_old_rec.assignment_start_date,
335: p_asg_business_group_id_o => per_apr_shd.g_old_rec.assignment_business_group_id,
336: p_assignment_organization_id_o => per_apr_shd.g_old_rec.assignment_organization_id,
337: p_assignment_job_id_o => per_apr_shd.g_old_rec.assignment_job_id ,
330: p_system_params_o => per_apr_shd.g_old_rec.system_params,
331: p_appraisee_access_o => per_apr_shd.g_old_rec.appraisee_access ,
332: p_main_appraiser_id_o => per_apr_shd.g_old_rec.main_appraiser_id ,
333: p_assignment_id_o => per_apr_shd.g_old_rec.assignment_id ,
334: p_assignment_start_date_o => per_apr_shd.g_old_rec.assignment_start_date,
335: p_asg_business_group_id_o => per_apr_shd.g_old_rec.assignment_business_group_id,
336: p_assignment_organization_id_o => per_apr_shd.g_old_rec.assignment_organization_id,
337: p_assignment_job_id_o => per_apr_shd.g_old_rec.assignment_job_id ,
338: p_assignment_position_id_o => per_apr_shd.g_old_rec.assignment_position_id,
331: p_appraisee_access_o => per_apr_shd.g_old_rec.appraisee_access ,
332: p_main_appraiser_id_o => per_apr_shd.g_old_rec.main_appraiser_id ,
333: p_assignment_id_o => per_apr_shd.g_old_rec.assignment_id ,
334: p_assignment_start_date_o => per_apr_shd.g_old_rec.assignment_start_date,
335: p_asg_business_group_id_o => per_apr_shd.g_old_rec.assignment_business_group_id,
336: p_assignment_organization_id_o => per_apr_shd.g_old_rec.assignment_organization_id,
337: p_assignment_job_id_o => per_apr_shd.g_old_rec.assignment_job_id ,
338: p_assignment_position_id_o => per_apr_shd.g_old_rec.assignment_position_id,
339: p_assignment_grade_id_o => per_apr_shd.g_old_rec.assignment_grade_id ,
332: p_main_appraiser_id_o => per_apr_shd.g_old_rec.main_appraiser_id ,
333: p_assignment_id_o => per_apr_shd.g_old_rec.assignment_id ,
334: p_assignment_start_date_o => per_apr_shd.g_old_rec.assignment_start_date,
335: p_asg_business_group_id_o => per_apr_shd.g_old_rec.assignment_business_group_id,
336: p_assignment_organization_id_o => per_apr_shd.g_old_rec.assignment_organization_id,
337: p_assignment_job_id_o => per_apr_shd.g_old_rec.assignment_job_id ,
338: p_assignment_position_id_o => per_apr_shd.g_old_rec.assignment_position_id,
339: p_assignment_grade_id_o => per_apr_shd.g_old_rec.assignment_grade_id ,
340: p_appraisal_system_status_o => per_apr_shd.g_old_rec.appraisal_system_status,
333: p_assignment_id_o => per_apr_shd.g_old_rec.assignment_id ,
334: p_assignment_start_date_o => per_apr_shd.g_old_rec.assignment_start_date,
335: p_asg_business_group_id_o => per_apr_shd.g_old_rec.assignment_business_group_id,
336: p_assignment_organization_id_o => per_apr_shd.g_old_rec.assignment_organization_id,
337: p_assignment_job_id_o => per_apr_shd.g_old_rec.assignment_job_id ,
338: p_assignment_position_id_o => per_apr_shd.g_old_rec.assignment_position_id,
339: p_assignment_grade_id_o => per_apr_shd.g_old_rec.assignment_grade_id ,
340: p_appraisal_system_status_o => per_apr_shd.g_old_rec.appraisal_system_status,
341: p_potential_readiness_level_o => per_apr_shd.g_old_rec.potential_readiness_level,
334: p_assignment_start_date_o => per_apr_shd.g_old_rec.assignment_start_date,
335: p_asg_business_group_id_o => per_apr_shd.g_old_rec.assignment_business_group_id,
336: p_assignment_organization_id_o => per_apr_shd.g_old_rec.assignment_organization_id,
337: p_assignment_job_id_o => per_apr_shd.g_old_rec.assignment_job_id ,
338: p_assignment_position_id_o => per_apr_shd.g_old_rec.assignment_position_id,
339: p_assignment_grade_id_o => per_apr_shd.g_old_rec.assignment_grade_id ,
340: p_appraisal_system_status_o => per_apr_shd.g_old_rec.appraisal_system_status,
341: p_potential_readiness_level_o => per_apr_shd.g_old_rec.potential_readiness_level,
342: p_potnl_short_term_workopp_o => per_apr_shd.g_old_rec.potential_short_term_workopp,
335: p_asg_business_group_id_o => per_apr_shd.g_old_rec.assignment_business_group_id,
336: p_assignment_organization_id_o => per_apr_shd.g_old_rec.assignment_organization_id,
337: p_assignment_job_id_o => per_apr_shd.g_old_rec.assignment_job_id ,
338: p_assignment_position_id_o => per_apr_shd.g_old_rec.assignment_position_id,
339: p_assignment_grade_id_o => per_apr_shd.g_old_rec.assignment_grade_id ,
340: p_appraisal_system_status_o => per_apr_shd.g_old_rec.appraisal_system_status,
341: p_potential_readiness_level_o => per_apr_shd.g_old_rec.potential_readiness_level,
342: p_potnl_short_term_workopp_o => per_apr_shd.g_old_rec.potential_short_term_workopp,
343: p_potnl_long_term_workopp_o => per_apr_shd.g_old_rec.potential_long_term_workopp,
336: p_assignment_organization_id_o => per_apr_shd.g_old_rec.assignment_organization_id,
337: p_assignment_job_id_o => per_apr_shd.g_old_rec.assignment_job_id ,
338: p_assignment_position_id_o => per_apr_shd.g_old_rec.assignment_position_id,
339: p_assignment_grade_id_o => per_apr_shd.g_old_rec.assignment_grade_id ,
340: p_appraisal_system_status_o => per_apr_shd.g_old_rec.appraisal_system_status,
341: p_potential_readiness_level_o => per_apr_shd.g_old_rec.potential_readiness_level,
342: p_potnl_short_term_workopp_o => per_apr_shd.g_old_rec.potential_short_term_workopp,
343: p_potnl_long_term_workopp_o => per_apr_shd.g_old_rec.potential_long_term_workopp,
344: p_potential_details_o => per_apr_shd.g_old_rec.potential_details,
337: p_assignment_job_id_o => per_apr_shd.g_old_rec.assignment_job_id ,
338: p_assignment_position_id_o => per_apr_shd.g_old_rec.assignment_position_id,
339: p_assignment_grade_id_o => per_apr_shd.g_old_rec.assignment_grade_id ,
340: p_appraisal_system_status_o => per_apr_shd.g_old_rec.appraisal_system_status,
341: p_potential_readiness_level_o => per_apr_shd.g_old_rec.potential_readiness_level,
342: p_potnl_short_term_workopp_o => per_apr_shd.g_old_rec.potential_short_term_workopp,
343: p_potnl_long_term_workopp_o => per_apr_shd.g_old_rec.potential_long_term_workopp,
344: p_potential_details_o => per_apr_shd.g_old_rec.potential_details,
345: p_event_id_o => per_apr_shd.g_old_rec.event_id,
338: p_assignment_position_id_o => per_apr_shd.g_old_rec.assignment_position_id,
339: p_assignment_grade_id_o => per_apr_shd.g_old_rec.assignment_grade_id ,
340: p_appraisal_system_status_o => per_apr_shd.g_old_rec.appraisal_system_status,
341: p_potential_readiness_level_o => per_apr_shd.g_old_rec.potential_readiness_level,
342: p_potnl_short_term_workopp_o => per_apr_shd.g_old_rec.potential_short_term_workopp,
343: p_potnl_long_term_workopp_o => per_apr_shd.g_old_rec.potential_long_term_workopp,
344: p_potential_details_o => per_apr_shd.g_old_rec.potential_details,
345: p_event_id_o => per_apr_shd.g_old_rec.event_id,
346: p_show_competency_ratings_o => per_apr_shd.g_old_rec.show_competency_ratings,
339: p_assignment_grade_id_o => per_apr_shd.g_old_rec.assignment_grade_id ,
340: p_appraisal_system_status_o => per_apr_shd.g_old_rec.appraisal_system_status,
341: p_potential_readiness_level_o => per_apr_shd.g_old_rec.potential_readiness_level,
342: p_potnl_short_term_workopp_o => per_apr_shd.g_old_rec.potential_short_term_workopp,
343: p_potnl_long_term_workopp_o => per_apr_shd.g_old_rec.potential_long_term_workopp,
344: p_potential_details_o => per_apr_shd.g_old_rec.potential_details,
345: p_event_id_o => per_apr_shd.g_old_rec.event_id,
346: p_show_competency_ratings_o => per_apr_shd.g_old_rec.show_competency_ratings,
347: p_show_objective_ratings_o => per_apr_shd.g_old_rec.show_objective_ratings,
340: p_appraisal_system_status_o => per_apr_shd.g_old_rec.appraisal_system_status,
341: p_potential_readiness_level_o => per_apr_shd.g_old_rec.potential_readiness_level,
342: p_potnl_short_term_workopp_o => per_apr_shd.g_old_rec.potential_short_term_workopp,
343: p_potnl_long_term_workopp_o => per_apr_shd.g_old_rec.potential_long_term_workopp,
344: p_potential_details_o => per_apr_shd.g_old_rec.potential_details,
345: p_event_id_o => per_apr_shd.g_old_rec.event_id,
346: p_show_competency_ratings_o => per_apr_shd.g_old_rec.show_competency_ratings,
347: p_show_objective_ratings_o => per_apr_shd.g_old_rec.show_objective_ratings,
348: p_show_questionnaire_info_o => per_apr_shd.g_old_rec.show_questionnaire_info,
341: p_potential_readiness_level_o => per_apr_shd.g_old_rec.potential_readiness_level,
342: p_potnl_short_term_workopp_o => per_apr_shd.g_old_rec.potential_short_term_workopp,
343: p_potnl_long_term_workopp_o => per_apr_shd.g_old_rec.potential_long_term_workopp,
344: p_potential_details_o => per_apr_shd.g_old_rec.potential_details,
345: p_event_id_o => per_apr_shd.g_old_rec.event_id,
346: p_show_competency_ratings_o => per_apr_shd.g_old_rec.show_competency_ratings,
347: p_show_objective_ratings_o => per_apr_shd.g_old_rec.show_objective_ratings,
348: p_show_questionnaire_info_o => per_apr_shd.g_old_rec.show_questionnaire_info,
349: p_show_participant_details_o => per_apr_shd.g_old_rec.show_participant_details,
342: p_potnl_short_term_workopp_o => per_apr_shd.g_old_rec.potential_short_term_workopp,
343: p_potnl_long_term_workopp_o => per_apr_shd.g_old_rec.potential_long_term_workopp,
344: p_potential_details_o => per_apr_shd.g_old_rec.potential_details,
345: p_event_id_o => per_apr_shd.g_old_rec.event_id,
346: p_show_competency_ratings_o => per_apr_shd.g_old_rec.show_competency_ratings,
347: p_show_objective_ratings_o => per_apr_shd.g_old_rec.show_objective_ratings,
348: p_show_questionnaire_info_o => per_apr_shd.g_old_rec.show_questionnaire_info,
349: p_show_participant_details_o => per_apr_shd.g_old_rec.show_participant_details,
350: p_show_participant_ratings_o => per_apr_shd.g_old_rec.show_participant_ratings,
343: p_potnl_long_term_workopp_o => per_apr_shd.g_old_rec.potential_long_term_workopp,
344: p_potential_details_o => per_apr_shd.g_old_rec.potential_details,
345: p_event_id_o => per_apr_shd.g_old_rec.event_id,
346: p_show_competency_ratings_o => per_apr_shd.g_old_rec.show_competency_ratings,
347: p_show_objective_ratings_o => per_apr_shd.g_old_rec.show_objective_ratings,
348: p_show_questionnaire_info_o => per_apr_shd.g_old_rec.show_questionnaire_info,
349: p_show_participant_details_o => per_apr_shd.g_old_rec.show_participant_details,
350: p_show_participant_ratings_o => per_apr_shd.g_old_rec.show_participant_ratings,
351: p_show_participant_names_o => per_apr_shd.g_old_rec.show_participant_names,
344: p_potential_details_o => per_apr_shd.g_old_rec.potential_details,
345: p_event_id_o => per_apr_shd.g_old_rec.event_id,
346: p_show_competency_ratings_o => per_apr_shd.g_old_rec.show_competency_ratings,
347: p_show_objective_ratings_o => per_apr_shd.g_old_rec.show_objective_ratings,
348: p_show_questionnaire_info_o => per_apr_shd.g_old_rec.show_questionnaire_info,
349: p_show_participant_details_o => per_apr_shd.g_old_rec.show_participant_details,
350: p_show_participant_ratings_o => per_apr_shd.g_old_rec.show_participant_ratings,
351: p_show_participant_names_o => per_apr_shd.g_old_rec.show_participant_names,
352: p_show_overall_ratings_o => per_apr_shd.g_old_rec.show_overall_ratings,
345: p_event_id_o => per_apr_shd.g_old_rec.event_id,
346: p_show_competency_ratings_o => per_apr_shd.g_old_rec.show_competency_ratings,
347: p_show_objective_ratings_o => per_apr_shd.g_old_rec.show_objective_ratings,
348: p_show_questionnaire_info_o => per_apr_shd.g_old_rec.show_questionnaire_info,
349: p_show_participant_details_o => per_apr_shd.g_old_rec.show_participant_details,
350: p_show_participant_ratings_o => per_apr_shd.g_old_rec.show_participant_ratings,
351: p_show_participant_names_o => per_apr_shd.g_old_rec.show_participant_names,
352: p_show_overall_ratings_o => per_apr_shd.g_old_rec.show_overall_ratings,
353: p_show_overall_comments_o => per_apr_shd.g_old_rec.show_overall_comments,
346: p_show_competency_ratings_o => per_apr_shd.g_old_rec.show_competency_ratings,
347: p_show_objective_ratings_o => per_apr_shd.g_old_rec.show_objective_ratings,
348: p_show_questionnaire_info_o => per_apr_shd.g_old_rec.show_questionnaire_info,
349: p_show_participant_details_o => per_apr_shd.g_old_rec.show_participant_details,
350: p_show_participant_ratings_o => per_apr_shd.g_old_rec.show_participant_ratings,
351: p_show_participant_names_o => per_apr_shd.g_old_rec.show_participant_names,
352: p_show_overall_ratings_o => per_apr_shd.g_old_rec.show_overall_ratings,
353: p_show_overall_comments_o => per_apr_shd.g_old_rec.show_overall_comments,
354: p_update_appraisal_o => per_apr_shd.g_old_rec.update_appraisal,
347: p_show_objective_ratings_o => per_apr_shd.g_old_rec.show_objective_ratings,
348: p_show_questionnaire_info_o => per_apr_shd.g_old_rec.show_questionnaire_info,
349: p_show_participant_details_o => per_apr_shd.g_old_rec.show_participant_details,
350: p_show_participant_ratings_o => per_apr_shd.g_old_rec.show_participant_ratings,
351: p_show_participant_names_o => per_apr_shd.g_old_rec.show_participant_names,
352: p_show_overall_ratings_o => per_apr_shd.g_old_rec.show_overall_ratings,
353: p_show_overall_comments_o => per_apr_shd.g_old_rec.show_overall_comments,
354: p_update_appraisal_o => per_apr_shd.g_old_rec.update_appraisal,
355: p_provide_overall_feedback_o => per_apr_shd.g_old_rec.provide_overall_feedback,
348: p_show_questionnaire_info_o => per_apr_shd.g_old_rec.show_questionnaire_info,
349: p_show_participant_details_o => per_apr_shd.g_old_rec.show_participant_details,
350: p_show_participant_ratings_o => per_apr_shd.g_old_rec.show_participant_ratings,
351: p_show_participant_names_o => per_apr_shd.g_old_rec.show_participant_names,
352: p_show_overall_ratings_o => per_apr_shd.g_old_rec.show_overall_ratings,
353: p_show_overall_comments_o => per_apr_shd.g_old_rec.show_overall_comments,
354: p_update_appraisal_o => per_apr_shd.g_old_rec.update_appraisal,
355: p_provide_overall_feedback_o => per_apr_shd.g_old_rec.provide_overall_feedback,
356: p_appraisee_comments_o => per_apr_shd.g_old_rec.appraisee_comments,
349: p_show_participant_details_o => per_apr_shd.g_old_rec.show_participant_details,
350: p_show_participant_ratings_o => per_apr_shd.g_old_rec.show_participant_ratings,
351: p_show_participant_names_o => per_apr_shd.g_old_rec.show_participant_names,
352: p_show_overall_ratings_o => per_apr_shd.g_old_rec.show_overall_ratings,
353: p_show_overall_comments_o => per_apr_shd.g_old_rec.show_overall_comments,
354: p_update_appraisal_o => per_apr_shd.g_old_rec.update_appraisal,
355: p_provide_overall_feedback_o => per_apr_shd.g_old_rec.provide_overall_feedback,
356: p_appraisee_comments_o => per_apr_shd.g_old_rec.appraisee_comments,
357: p_plan_id_o => per_apr_shd.g_old_rec.plan_id,
350: p_show_participant_ratings_o => per_apr_shd.g_old_rec.show_participant_ratings,
351: p_show_participant_names_o => per_apr_shd.g_old_rec.show_participant_names,
352: p_show_overall_ratings_o => per_apr_shd.g_old_rec.show_overall_ratings,
353: p_show_overall_comments_o => per_apr_shd.g_old_rec.show_overall_comments,
354: p_update_appraisal_o => per_apr_shd.g_old_rec.update_appraisal,
355: p_provide_overall_feedback_o => per_apr_shd.g_old_rec.provide_overall_feedback,
356: p_appraisee_comments_o => per_apr_shd.g_old_rec.appraisee_comments,
357: p_plan_id_o => per_apr_shd.g_old_rec.plan_id,
358: p_offline_status_o => per_apr_shd.g_old_rec.offline_status,
351: p_show_participant_names_o => per_apr_shd.g_old_rec.show_participant_names,
352: p_show_overall_ratings_o => per_apr_shd.g_old_rec.show_overall_ratings,
353: p_show_overall_comments_o => per_apr_shd.g_old_rec.show_overall_comments,
354: p_update_appraisal_o => per_apr_shd.g_old_rec.update_appraisal,
355: p_provide_overall_feedback_o => per_apr_shd.g_old_rec.provide_overall_feedback,
356: p_appraisee_comments_o => per_apr_shd.g_old_rec.appraisee_comments,
357: p_plan_id_o => per_apr_shd.g_old_rec.plan_id,
358: p_offline_status_o => per_apr_shd.g_old_rec.offline_status,
359: p_retention_potential_o => per_apr_shd.g_old_rec.retention_potential,
352: p_show_overall_ratings_o => per_apr_shd.g_old_rec.show_overall_ratings,
353: p_show_overall_comments_o => per_apr_shd.g_old_rec.show_overall_comments,
354: p_update_appraisal_o => per_apr_shd.g_old_rec.update_appraisal,
355: p_provide_overall_feedback_o => per_apr_shd.g_old_rec.provide_overall_feedback,
356: p_appraisee_comments_o => per_apr_shd.g_old_rec.appraisee_comments,
357: p_plan_id_o => per_apr_shd.g_old_rec.plan_id,
358: p_offline_status_o => per_apr_shd.g_old_rec.offline_status,
359: p_retention_potential_o => per_apr_shd.g_old_rec.retention_potential,
360: p_show_participant_comments_o => per_apr_shd.g_old_rec.show_participant_comments -- 8651478 bug fix
353: p_show_overall_comments_o => per_apr_shd.g_old_rec.show_overall_comments,
354: p_update_appraisal_o => per_apr_shd.g_old_rec.update_appraisal,
355: p_provide_overall_feedback_o => per_apr_shd.g_old_rec.provide_overall_feedback,
356: p_appraisee_comments_o => per_apr_shd.g_old_rec.appraisee_comments,
357: p_plan_id_o => per_apr_shd.g_old_rec.plan_id,
358: p_offline_status_o => per_apr_shd.g_old_rec.offline_status,
359: p_retention_potential_o => per_apr_shd.g_old_rec.retention_potential,
360: p_show_participant_comments_o => per_apr_shd.g_old_rec.show_participant_comments -- 8651478 bug fix
361: );
354: p_update_appraisal_o => per_apr_shd.g_old_rec.update_appraisal,
355: p_provide_overall_feedback_o => per_apr_shd.g_old_rec.provide_overall_feedback,
356: p_appraisee_comments_o => per_apr_shd.g_old_rec.appraisee_comments,
357: p_plan_id_o => per_apr_shd.g_old_rec.plan_id,
358: p_offline_status_o => per_apr_shd.g_old_rec.offline_status,
359: p_retention_potential_o => per_apr_shd.g_old_rec.retention_potential,
360: p_show_participant_comments_o => per_apr_shd.g_old_rec.show_participant_comments -- 8651478 bug fix
361: );
362: exception
355: p_provide_overall_feedback_o => per_apr_shd.g_old_rec.provide_overall_feedback,
356: p_appraisee_comments_o => per_apr_shd.g_old_rec.appraisee_comments,
357: p_plan_id_o => per_apr_shd.g_old_rec.plan_id,
358: p_offline_status_o => per_apr_shd.g_old_rec.offline_status,
359: p_retention_potential_o => per_apr_shd.g_old_rec.retention_potential,
360: p_show_participant_comments_o => per_apr_shd.g_old_rec.show_participant_comments -- 8651478 bug fix
361: );
362: exception
363: when hr_api.cannot_find_prog_unit then
356: p_appraisee_comments_o => per_apr_shd.g_old_rec.appraisee_comments,
357: p_plan_id_o => per_apr_shd.g_old_rec.plan_id,
358: p_offline_status_o => per_apr_shd.g_old_rec.offline_status,
359: p_retention_potential_o => per_apr_shd.g_old_rec.retention_potential,
360: p_show_participant_comments_o => per_apr_shd.g_old_rec.show_participant_comments -- 8651478 bug fix
361: );
362: exception
363: when hr_api.cannot_find_prog_unit then
364: hr_api.cannot_find_prog_unit_error
414: -- Internal Table Handler Use Only.
415:
416: -- {End Of Comments}
417: -- ---------------------------------------------------------------------------+
418: Procedure convert_defs(p_rec in out nocopy per_apr_shd.g_rec_type) is
419:
420: l_proc varchar2(72) := g_package||'convert_defs';
421:
422: Begin
429: -- is being used then we must set to the 'current' argument value.
430:
431: If (p_rec.business_group_id = hr_api.g_number) then
432: p_rec.business_group_id :=
433: per_apr_shd.g_old_rec.business_group_id;
434: End If;
435: If (p_rec.appraisal_template_id = hr_api.g_number) then
436: p_rec.appraisal_template_id :=
437: per_apr_shd.g_old_rec.appraisal_template_id;
433: per_apr_shd.g_old_rec.business_group_id;
434: End If;
435: If (p_rec.appraisal_template_id = hr_api.g_number) then
436: p_rec.appraisal_template_id :=
437: per_apr_shd.g_old_rec.appraisal_template_id;
438: End If;
439: If (p_rec.appraisee_person_id = hr_api.g_number) then
440: p_rec.appraisee_person_id :=
441: per_apr_shd.g_old_rec.appraisee_person_id;
437: per_apr_shd.g_old_rec.appraisal_template_id;
438: End If;
439: If (p_rec.appraisee_person_id = hr_api.g_number) then
440: p_rec.appraisee_person_id :=
441: per_apr_shd.g_old_rec.appraisee_person_id;
442: End If;
443: If (p_rec.appraiser_person_id = hr_api.g_number) then
444: p_rec.appraiser_person_id :=
445: per_apr_shd.g_old_rec.appraiser_person_id;
441: per_apr_shd.g_old_rec.appraisee_person_id;
442: End If;
443: If (p_rec.appraiser_person_id = hr_api.g_number) then
444: p_rec.appraiser_person_id :=
445: per_apr_shd.g_old_rec.appraiser_person_id;
446: End If;
447: If (p_rec.appraisal_date = hr_api.g_date) then
448: p_rec.appraisal_date :=
449: per_apr_shd.g_old_rec.appraisal_date;
445: per_apr_shd.g_old_rec.appraiser_person_id;
446: End If;
447: If (p_rec.appraisal_date = hr_api.g_date) then
448: p_rec.appraisal_date :=
449: per_apr_shd.g_old_rec.appraisal_date;
450: End If;
451: If (p_rec.appraisal_period_end_date = hr_api.g_date) then
452: p_rec.appraisal_period_end_date :=
453: per_apr_shd.g_old_rec.appraisal_period_end_date;
449: per_apr_shd.g_old_rec.appraisal_date;
450: End If;
451: If (p_rec.appraisal_period_end_date = hr_api.g_date) then
452: p_rec.appraisal_period_end_date :=
453: per_apr_shd.g_old_rec.appraisal_period_end_date;
454: End If;
455: If (p_rec.appraisal_period_start_date = hr_api.g_date) then
456: p_rec.appraisal_period_start_date :=
457: per_apr_shd.g_old_rec.appraisal_period_start_date;
453: per_apr_shd.g_old_rec.appraisal_period_end_date;
454: End If;
455: If (p_rec.appraisal_period_start_date = hr_api.g_date) then
456: p_rec.appraisal_period_start_date :=
457: per_apr_shd.g_old_rec.appraisal_period_start_date;
458: End If;
459: If (p_rec.type = hr_api.g_varchar2) then
460: p_rec.type :=
461: per_apr_shd.g_old_rec.type;
457: per_apr_shd.g_old_rec.appraisal_period_start_date;
458: End If;
459: If (p_rec.type = hr_api.g_varchar2) then
460: p_rec.type :=
461: per_apr_shd.g_old_rec.type;
462: End If;
463: If (p_rec.next_appraisal_date = hr_api.g_date) then
464: p_rec.next_appraisal_date :=
465: per_apr_shd.g_old_rec.next_appraisal_date;
461: per_apr_shd.g_old_rec.type;
462: End If;
463: If (p_rec.next_appraisal_date = hr_api.g_date) then
464: p_rec.next_appraisal_date :=
465: per_apr_shd.g_old_rec.next_appraisal_date;
466: End If;
467: If (p_rec.status = hr_api.g_varchar2) then
468: p_rec.status :=
469: per_apr_shd.g_old_rec.status;
465: per_apr_shd.g_old_rec.next_appraisal_date;
466: End If;
467: If (p_rec.status = hr_api.g_varchar2) then
468: p_rec.status :=
469: per_apr_shd.g_old_rec.status;
470: End If;
471: If (p_rec.comments = hr_api.g_varchar2) then
472: p_rec.comments :=
473: per_apr_shd.g_old_rec.comments;
469: per_apr_shd.g_old_rec.status;
470: End If;
471: If (p_rec.comments = hr_api.g_varchar2) then
472: p_rec.comments :=
473: per_apr_shd.g_old_rec.comments;
474: End If;
475: If (p_rec.overall_performance_level_id = hr_api.g_number) then
476: p_rec.overall_performance_level_id :=
477: per_apr_shd.g_old_rec.overall_performance_level_id;
473: per_apr_shd.g_old_rec.comments;
474: End If;
475: If (p_rec.overall_performance_level_id = hr_api.g_number) then
476: p_rec.overall_performance_level_id :=
477: per_apr_shd.g_old_rec.overall_performance_level_id;
478: End If;
479: If (p_rec.open = hr_api.g_varchar2) then
480: p_rec.open := per_apr_shd.g_old_rec.open;
481: End If;
476: p_rec.overall_performance_level_id :=
477: per_apr_shd.g_old_rec.overall_performance_level_id;
478: End If;
479: If (p_rec.open = hr_api.g_varchar2) then
480: p_rec.open := per_apr_shd.g_old_rec.open;
481: End If;
482: If (p_rec.attribute_category = hr_api.g_varchar2) then
483: p_rec.attribute_category :=
484: per_apr_shd.g_old_rec.attribute_category;
480: p_rec.open := per_apr_shd.g_old_rec.open;
481: End If;
482: If (p_rec.attribute_category = hr_api.g_varchar2) then
483: p_rec.attribute_category :=
484: per_apr_shd.g_old_rec.attribute_category;
485: End If;
486: If (p_rec.attribute1 = hr_api.g_varchar2) then
487: p_rec.attribute1 :=
488: per_apr_shd.g_old_rec.attribute1;
484: per_apr_shd.g_old_rec.attribute_category;
485: End If;
486: If (p_rec.attribute1 = hr_api.g_varchar2) then
487: p_rec.attribute1 :=
488: per_apr_shd.g_old_rec.attribute1;
489: End If;
490: If (p_rec.attribute2 = hr_api.g_varchar2) then
491: p_rec.attribute2 :=
492: per_apr_shd.g_old_rec.attribute2;
488: per_apr_shd.g_old_rec.attribute1;
489: End If;
490: If (p_rec.attribute2 = hr_api.g_varchar2) then
491: p_rec.attribute2 :=
492: per_apr_shd.g_old_rec.attribute2;
493: End If;
494: If (p_rec.attribute3 = hr_api.g_varchar2) then
495: p_rec.attribute3 :=
496: per_apr_shd.g_old_rec.attribute3;
492: per_apr_shd.g_old_rec.attribute2;
493: End If;
494: If (p_rec.attribute3 = hr_api.g_varchar2) then
495: p_rec.attribute3 :=
496: per_apr_shd.g_old_rec.attribute3;
497: End If;
498: If (p_rec.attribute4 = hr_api.g_varchar2) then
499: p_rec.attribute4 :=
500: per_apr_shd.g_old_rec.attribute4;
496: per_apr_shd.g_old_rec.attribute3;
497: End If;
498: If (p_rec.attribute4 = hr_api.g_varchar2) then
499: p_rec.attribute4 :=
500: per_apr_shd.g_old_rec.attribute4;
501: End If;
502: If (p_rec.attribute5 = hr_api.g_varchar2) then
503: p_rec.attribute5 :=
504: per_apr_shd.g_old_rec.attribute5;
500: per_apr_shd.g_old_rec.attribute4;
501: End If;
502: If (p_rec.attribute5 = hr_api.g_varchar2) then
503: p_rec.attribute5 :=
504: per_apr_shd.g_old_rec.attribute5;
505: End If;
506: If (p_rec.attribute6 = hr_api.g_varchar2) then
507: p_rec.attribute6 :=
508: per_apr_shd.g_old_rec.attribute6;
504: per_apr_shd.g_old_rec.attribute5;
505: End If;
506: If (p_rec.attribute6 = hr_api.g_varchar2) then
507: p_rec.attribute6 :=
508: per_apr_shd.g_old_rec.attribute6;
509: End If;
510: If (p_rec.attribute7 = hr_api.g_varchar2) then
511: p_rec.attribute7 :=
512: per_apr_shd.g_old_rec.attribute7;
508: per_apr_shd.g_old_rec.attribute6;
509: End If;
510: If (p_rec.attribute7 = hr_api.g_varchar2) then
511: p_rec.attribute7 :=
512: per_apr_shd.g_old_rec.attribute7;
513: End If;
514: If (p_rec.attribute8 = hr_api.g_varchar2) then
515: p_rec.attribute8 :=
516: per_apr_shd.g_old_rec.attribute8;
512: per_apr_shd.g_old_rec.attribute7;
513: End If;
514: If (p_rec.attribute8 = hr_api.g_varchar2) then
515: p_rec.attribute8 :=
516: per_apr_shd.g_old_rec.attribute8;
517: End If;
518: If (p_rec.attribute9 = hr_api.g_varchar2) then
519: p_rec.attribute9 :=
520: per_apr_shd.g_old_rec.attribute9;
516: per_apr_shd.g_old_rec.attribute8;
517: End If;
518: If (p_rec.attribute9 = hr_api.g_varchar2) then
519: p_rec.attribute9 :=
520: per_apr_shd.g_old_rec.attribute9;
521: End If;
522: If (p_rec.attribute10 = hr_api.g_varchar2) then
523: p_rec.attribute10 :=
524: per_apr_shd.g_old_rec.attribute10;
520: per_apr_shd.g_old_rec.attribute9;
521: End If;
522: If (p_rec.attribute10 = hr_api.g_varchar2) then
523: p_rec.attribute10 :=
524: per_apr_shd.g_old_rec.attribute10;
525: End If;
526: If (p_rec.attribute11 = hr_api.g_varchar2) then
527: p_rec.attribute11 :=
528: per_apr_shd.g_old_rec.attribute11;
524: per_apr_shd.g_old_rec.attribute10;
525: End If;
526: If (p_rec.attribute11 = hr_api.g_varchar2) then
527: p_rec.attribute11 :=
528: per_apr_shd.g_old_rec.attribute11;
529: End If;
530: If (p_rec.attribute12 = hr_api.g_varchar2) then
531: p_rec.attribute12 :=
532: per_apr_shd.g_old_rec.attribute12;
528: per_apr_shd.g_old_rec.attribute11;
529: End If;
530: If (p_rec.attribute12 = hr_api.g_varchar2) then
531: p_rec.attribute12 :=
532: per_apr_shd.g_old_rec.attribute12;
533: End If;
534: If (p_rec.attribute13 = hr_api.g_varchar2) then
535: p_rec.attribute13 :=
536: per_apr_shd.g_old_rec.attribute13;
532: per_apr_shd.g_old_rec.attribute12;
533: End If;
534: If (p_rec.attribute13 = hr_api.g_varchar2) then
535: p_rec.attribute13 :=
536: per_apr_shd.g_old_rec.attribute13;
537: End If;
538: If (p_rec.attribute14 = hr_api.g_varchar2) then
539: p_rec.attribute14 :=
540: per_apr_shd.g_old_rec.attribute14;
536: per_apr_shd.g_old_rec.attribute13;
537: End If;
538: If (p_rec.attribute14 = hr_api.g_varchar2) then
539: p_rec.attribute14 :=
540: per_apr_shd.g_old_rec.attribute14;
541: End If;
542: If (p_rec.attribute15 = hr_api.g_varchar2) then
543: p_rec.attribute15 :=
544: per_apr_shd.g_old_rec.attribute15;
540: per_apr_shd.g_old_rec.attribute14;
541: End If;
542: If (p_rec.attribute15 = hr_api.g_varchar2) then
543: p_rec.attribute15 :=
544: per_apr_shd.g_old_rec.attribute15;
545: End If;
546: If (p_rec.attribute16 = hr_api.g_varchar2) then
547: p_rec.attribute16 :=
548: per_apr_shd.g_old_rec.attribute16;
544: per_apr_shd.g_old_rec.attribute15;
545: End If;
546: If (p_rec.attribute16 = hr_api.g_varchar2) then
547: p_rec.attribute16 :=
548: per_apr_shd.g_old_rec.attribute16;
549: End If;
550: If (p_rec.attribute17 = hr_api.g_varchar2) then
551: p_rec.attribute17 :=
552: per_apr_shd.g_old_rec.attribute17;
548: per_apr_shd.g_old_rec.attribute16;
549: End If;
550: If (p_rec.attribute17 = hr_api.g_varchar2) then
551: p_rec.attribute17 :=
552: per_apr_shd.g_old_rec.attribute17;
553: End If;
554: If (p_rec.attribute18 = hr_api.g_varchar2) then
555: p_rec.attribute18 :=
556: per_apr_shd.g_old_rec.attribute18;
552: per_apr_shd.g_old_rec.attribute17;
553: End If;
554: If (p_rec.attribute18 = hr_api.g_varchar2) then
555: p_rec.attribute18 :=
556: per_apr_shd.g_old_rec.attribute18;
557: End If;
558: If (p_rec.attribute19 = hr_api.g_varchar2) then
559: p_rec.attribute19 :=
560: per_apr_shd.g_old_rec.attribute19;
556: per_apr_shd.g_old_rec.attribute18;
557: End If;
558: If (p_rec.attribute19 = hr_api.g_varchar2) then
559: p_rec.attribute19 :=
560: per_apr_shd.g_old_rec.attribute19;
561: End If;
562: If (p_rec.attribute20 = hr_api.g_varchar2) then
563: p_rec.attribute20 :=
564: per_apr_shd.g_old_rec.attribute20;
560: per_apr_shd.g_old_rec.attribute19;
561: End If;
562: If (p_rec.attribute20 = hr_api.g_varchar2) then
563: p_rec.attribute20 :=
564: per_apr_shd.g_old_rec.attribute20;
565: End If;
566:
567: If (p_rec.system_type = hr_api.g_varchar2) then
568: p_rec.system_type :=
565: End If;
566:
567: If (p_rec.system_type = hr_api.g_varchar2) then
568: p_rec.system_type :=
569: per_apr_shd.g_old_rec.system_type;
570: End If;
571: If (p_rec.system_params = hr_api.g_varchar2) then
572: p_rec.system_params :=
573: per_apr_shd.g_old_rec.system_params;
569: per_apr_shd.g_old_rec.system_type;
570: End If;
571: If (p_rec.system_params = hr_api.g_varchar2) then
572: p_rec.system_params :=
573: per_apr_shd.g_old_rec.system_params;
574: End If;
575:
576: If (p_rec.appraisee_access = hr_api.g_varchar2) then
577: p_rec.appraisee_access :=
574: End If;
575:
576: If (p_rec.appraisee_access = hr_api.g_varchar2) then
577: p_rec.appraisee_access :=
578: per_apr_shd.g_old_rec.appraisee_access;
579: End If;
580: If (p_rec.main_appraiser_id = hr_api.g_number) then
581: p_rec.main_appraiser_id :=
582: per_apr_shd.g_old_rec.main_appraiser_id;
578: per_apr_shd.g_old_rec.appraisee_access;
579: End If;
580: If (p_rec.main_appraiser_id = hr_api.g_number) then
581: p_rec.main_appraiser_id :=
582: per_apr_shd.g_old_rec.main_appraiser_id;
583: End If;
584: If (p_rec.assignment_id = hr_api.g_number) then
585: p_rec.assignment_id :=
586: per_apr_shd.g_old_rec.assignment_id;
582: per_apr_shd.g_old_rec.main_appraiser_id;
583: End If;
584: If (p_rec.assignment_id = hr_api.g_number) then
585: p_rec.assignment_id :=
586: per_apr_shd.g_old_rec.assignment_id;
587: End If;
588: If (p_rec.assignment_start_date = hr_api.g_date) then
589: p_rec.assignment_start_date :=
590: per_apr_shd.g_old_rec.assignment_start_date;
586: per_apr_shd.g_old_rec.assignment_id;
587: End If;
588: If (p_rec.assignment_start_date = hr_api.g_date) then
589: p_rec.assignment_start_date :=
590: per_apr_shd.g_old_rec.assignment_start_date;
591: End If;
592:
593: If (p_rec.assignment_business_group_id = hr_api.g_number) then
594: p_rec.assignment_business_group_id :=
591: End If;
592:
593: If (p_rec.assignment_business_group_id = hr_api.g_number) then
594: p_rec.assignment_business_group_id :=
595: per_apr_shd.g_old_rec.assignment_business_group_id;
596: End If;
597: If (p_rec.assignment_organization_id = hr_api.g_number) then
598: p_rec.assignment_organization_id :=
599: per_apr_shd.g_old_rec.assignment_organization_id;
595: per_apr_shd.g_old_rec.assignment_business_group_id;
596: End If;
597: If (p_rec.assignment_organization_id = hr_api.g_number) then
598: p_rec.assignment_organization_id :=
599: per_apr_shd.g_old_rec.assignment_organization_id;
600: End If;
601: If (p_rec.assignment_job_id = hr_api.g_number) then
602: p_rec.assignment_job_id :=
603: per_apr_shd.g_old_rec.assignment_job_id;
599: per_apr_shd.g_old_rec.assignment_organization_id;
600: End If;
601: If (p_rec.assignment_job_id = hr_api.g_number) then
602: p_rec.assignment_job_id :=
603: per_apr_shd.g_old_rec.assignment_job_id;
604: End If;
605: If (p_rec.assignment_position_id = hr_api.g_number) then
606: p_rec.assignment_position_id :=
607: per_apr_shd.g_old_rec.assignment_position_id;
603: per_apr_shd.g_old_rec.assignment_job_id;
604: End If;
605: If (p_rec.assignment_position_id = hr_api.g_number) then
606: p_rec.assignment_position_id :=
607: per_apr_shd.g_old_rec.assignment_position_id;
608: End If;
609: If (p_rec.assignment_grade_id = hr_api.g_number) then
610: p_rec.assignment_grade_id :=
611: per_apr_shd.g_old_rec.assignment_grade_id;
607: per_apr_shd.g_old_rec.assignment_position_id;
608: End If;
609: If (p_rec.assignment_grade_id = hr_api.g_number) then
610: p_rec.assignment_grade_id :=
611: per_apr_shd.g_old_rec.assignment_grade_id;
612: End If;
613:
614: If (p_rec.potential_readiness_level = hr_api.g_varchar2) then
615: p_rec.potential_readiness_level :=
612: End If;
613:
614: If (p_rec.potential_readiness_level = hr_api.g_varchar2) then
615: p_rec.potential_readiness_level :=
616: per_apr_shd.g_old_rec.potential_readiness_level;
617: End If;
618: If (p_rec.potential_short_term_workopp = hr_api.g_varchar2) then
619: p_rec.potential_short_term_workopp :=
620: per_apr_shd.g_old_rec.potential_short_term_workopp;
616: per_apr_shd.g_old_rec.potential_readiness_level;
617: End If;
618: If (p_rec.potential_short_term_workopp = hr_api.g_varchar2) then
619: p_rec.potential_short_term_workopp :=
620: per_apr_shd.g_old_rec.potential_short_term_workopp;
621: End If;
622: If (p_rec.potential_long_term_workopp = hr_api.g_varchar2) then
623: p_rec.potential_long_term_workopp :=
624: per_apr_shd.g_old_rec.potential_long_term_workopp;
620: per_apr_shd.g_old_rec.potential_short_term_workopp;
621: End If;
622: If (p_rec.potential_long_term_workopp = hr_api.g_varchar2) then
623: p_rec.potential_long_term_workopp :=
624: per_apr_shd.g_old_rec.potential_long_term_workopp;
625: End If;
626: If (p_rec.potential_details = hr_api.g_varchar2) then
627: p_rec.potential_details :=
628: per_apr_shd.g_old_rec.potential_details;
624: per_apr_shd.g_old_rec.potential_long_term_workopp;
625: End If;
626: If (p_rec.potential_details = hr_api.g_varchar2) then
627: p_rec.potential_details :=
628: per_apr_shd.g_old_rec.potential_details;
629: End If;
630: If (p_rec.event_id = hr_api.g_number) then
631: p_rec.event_id :=
632: per_apr_shd.g_old_rec.event_id;
628: per_apr_shd.g_old_rec.potential_details;
629: End If;
630: If (p_rec.event_id = hr_api.g_number) then
631: p_rec.event_id :=
632: per_apr_shd.g_old_rec.event_id;
633: End If;
634:
635: If (p_rec.appraisal_system_status = hr_api.g_varchar2) then
636: p_rec.appraisal_system_status :=
633: End If;
634:
635: If (p_rec.appraisal_system_status = hr_api.g_varchar2) then
636: p_rec.appraisal_system_status :=
637: per_apr_shd.g_old_rec.appraisal_system_status;
638: End If;
639:
640: If (p_rec.show_competency_ratings = hr_api.g_varchar2) then
641: p_rec.show_competency_ratings :=
638: End If;
639:
640: If (p_rec.show_competency_ratings = hr_api.g_varchar2) then
641: p_rec.show_competency_ratings :=
642: per_apr_shd.g_old_rec.show_competency_ratings;
643: End If;
644:
645: If (p_rec.show_objective_ratings = hr_api.g_varchar2) then
646: p_rec.show_objective_ratings :=
643: End If;
644:
645: If (p_rec.show_objective_ratings = hr_api.g_varchar2) then
646: p_rec.show_objective_ratings :=
647: per_apr_shd.g_old_rec.show_objective_ratings;
648: End If;
649:
650: If (p_rec.show_questionnaire_info = hr_api.g_varchar2) then
651: p_rec.show_questionnaire_info :=
648: End If;
649:
650: If (p_rec.show_questionnaire_info = hr_api.g_varchar2) then
651: p_rec.show_questionnaire_info :=
652: per_apr_shd.g_old_rec.show_questionnaire_info;
653: End If;
654:
655: If (p_rec.show_participant_details = hr_api.g_varchar2) then
656: p_rec.show_participant_details :=
653: End If;
654:
655: If (p_rec.show_participant_details = hr_api.g_varchar2) then
656: p_rec.show_participant_details :=
657: per_apr_shd.g_old_rec.show_participant_details;
658: End If;
659:
660: If (p_rec.show_participant_ratings = hr_api.g_varchar2) then
661: p_rec.show_participant_ratings :=
658: End If;
659:
660: If (p_rec.show_participant_ratings = hr_api.g_varchar2) then
661: p_rec.show_participant_ratings :=
662: per_apr_shd.g_old_rec.show_participant_ratings;
663: End If;
664:
665: If (p_rec.show_participant_names = hr_api.g_varchar2) then
666: p_rec.show_participant_names :=
663: End If;
664:
665: If (p_rec.show_participant_names = hr_api.g_varchar2) then
666: p_rec.show_participant_names :=
667: per_apr_shd.g_old_rec.show_participant_names;
668: End If;
669:
670: If (p_rec.show_overall_ratings = hr_api.g_varchar2) then
671: p_rec.show_overall_ratings :=
668: End If;
669:
670: If (p_rec.show_overall_ratings = hr_api.g_varchar2) then
671: p_rec.show_overall_ratings :=
672: per_apr_shd.g_old_rec.show_overall_ratings;
673: End If;
674:
675: If (p_rec.show_overall_comments = hr_api.g_varchar2) then
676: p_rec.show_overall_comments :=
673: End If;
674:
675: If (p_rec.show_overall_comments = hr_api.g_varchar2) then
676: p_rec.show_overall_comments :=
677: per_apr_shd.g_old_rec.show_overall_comments;
678: End If;
679:
680: If (p_rec.update_appraisal = hr_api.g_varchar2) then
681: p_rec.update_appraisal :=
678: End If;
679:
680: If (p_rec.update_appraisal = hr_api.g_varchar2) then
681: p_rec.update_appraisal :=
682: per_apr_shd.g_old_rec.update_appraisal;
683: End If;
684:
685: If (p_rec.provide_overall_feedback = hr_api.g_varchar2) then
686: p_rec.provide_overall_feedback :=
683: End If;
684:
685: If (p_rec.provide_overall_feedback = hr_api.g_varchar2) then
686: p_rec.provide_overall_feedback :=
687: per_apr_shd.g_old_rec.provide_overall_feedback;
688: End If;
689:
690: If (p_rec.appraisee_comments = hr_api.g_varchar2) then
691: p_rec.appraisee_comments :=
688: End If;
689:
690: If (p_rec.appraisee_comments = hr_api.g_varchar2) then
691: p_rec.appraisee_comments :=
692: per_apr_shd.g_old_rec.appraisee_comments;
693: End If;
694:
695: If (p_rec.plan_id = hr_api.g_number) then
696: p_rec.plan_id :=
693: End If;
694:
695: If (p_rec.plan_id = hr_api.g_number) then
696: p_rec.plan_id :=
697: per_apr_shd.g_old_rec.plan_id;
698: End If;
699:
700: If (p_rec.offline_status = hr_api.g_varchar2) then
701: p_rec.offline_status :=
698: End If;
699:
700: If (p_rec.offline_status = hr_api.g_varchar2) then
701: p_rec.offline_status :=
702: per_apr_shd.g_old_rec.offline_status;
703: End If;
704:
705: If (p_rec.retention_potential = hr_api.g_varchar2) then
706: p_rec.retention_potential :=
703: End If;
704:
705: If (p_rec.retention_potential = hr_api.g_varchar2) then
706: p_rec.retention_potential :=
707: per_apr_shd.g_old_rec.retention_potential;
708: End If;
709:
710: -- 8651478 bug fix
711: If (p_rec.show_participant_comments = hr_api.g_varchar2) then
709:
710: -- 8651478 bug fix
711: If (p_rec.show_participant_comments = hr_api.g_varchar2) then
712: p_rec.show_participant_comments :=
713: per_apr_shd.g_old_rec.show_participant_comments;
714: End If;
715:
716: hr_utility.set_location(' Leaving:'||l_proc, 10);
717:
721: -- |---------------------------------< upd >----------------------------------|
722: -- ---------------------------------------------------------------------------+
723: Procedure upd
724: (
725: p_rec in out nocopy per_apr_shd.g_rec_type,
726: p_effective_date in date,
727: p_validate in boolean default false
728: ) is
729:
742: End If;
743:
744: -- We must lock the row which we need to update.
745:
746: per_apr_shd.lck
747: (
748: p_rec.appraisal_id,
749: p_rec.object_version_number
750: );
862: p_validate in boolean default false,
863: p_show_participant_comments in varchar2 default hr_api.g_varchar2 -- 8651478 bug fix
864: ) is
865:
866: l_rec per_apr_shd.g_rec_type;
867: l_proc varchar2(72) := g_package||'upd';
868:
869: Begin
870: hr_utility.set_location('Entering:'||l_proc, 5);
872: -- Call conversion function to turn arguments into the
873: -- l_rec structure.
874:
875: l_rec :=
876: per_apr_shd.convert_args
877: (
878: p_appraisal_id,
879: hr_api.g_number,
880: p_object_version_number,