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