DBA Data[Home] [Help]

APPS.PER_APR_UPD dependencies on PER_APR_SHD

Line 48: Procedure update_dml(p_rec in out nocopy per_apr_shd.g_rec_type) is

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

Line 134: per_apr_shd.constraint_error

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

Line 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

Line 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;

Line 180: Procedure pre_update(p_rec in per_apr_shd.g_rec_type) is

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

Line 222: Procedure post_update(p_rec in per_apr_shd.g_rec_type) is

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

Line 289: p_business_group_id_o => per_apr_shd.g_old_rec.business_group_id ,

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 ,

Line 290: p_appraisal_template_id_o => per_apr_shd.g_old_rec.appraisal_template_id ,

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 ,

Line 291: p_appraisee_person_id_o => per_apr_shd.g_old_rec.appraisee_person_id ,

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 ,

Line 292: p_appraiser_person_id_o => per_apr_shd.g_old_rec.appraiser_person_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 ,

Line 293: p_appraisal_date_o => per_apr_shd.g_old_rec.appraisal_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,

Line 294: p_group_date_o => per_apr_shd.g_old_rec.group_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 ,

Line 295: p_group_initiator_id_o => per_apr_shd.g_old_rec.group_initiator_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 ,
299: p_next_appraisal_date_o => per_apr_shd.g_old_rec.next_appraisal_date ,

Line 296: p_appraisal_period_end_date_o => per_apr_shd.g_old_rec.appraisal_period_end_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 ,

Line 297: p_appraisal_period_start_dat_o => per_apr_shd.g_old_rec.appraisal_period_start_date,

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 ,

Line 298: p_type_o => per_apr_shd.g_old_rec.type ,

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,

Line 299: p_next_appraisal_date_o => per_apr_shd.g_old_rec.next_appraisal_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,
303: p_open_o => per_apr_shd.g_old_rec.open ,

Line 300: p_status_o => per_apr_shd.g_old_rec.status ,

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 ,

Line 301: p_comments_o => per_apr_shd.g_old_rec.comments ,

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 ,

Line 302: p_overall_performance_level_o => per_apr_shd.g_old_rec.overall_performance_level_id,

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 ,

Line 303: p_open_o => per_apr_shd.g_old_rec.open ,

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 ,

Line 304: p_attribute_category_o => per_apr_shd.g_old_rec.attribute_category ,

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 ,

Line 305: p_attribute1_o => per_apr_shd.g_old_rec.attribute1 ,

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 ,

Line 306: p_attribute2_o => per_apr_shd.g_old_rec.attribute2 ,

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 ,

Line 307: p_attribute3_o => per_apr_shd.g_old_rec.attribute3 ,

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 ,

Line 308: p_attribute4_o => per_apr_shd.g_old_rec.attribute4 ,

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 ,

Line 309: p_attribute5_o => per_apr_shd.g_old_rec.attribute5 ,

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 ,

Line 310: p_attribute6_o => per_apr_shd.g_old_rec.attribute6 ,

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 ,

Line 311: p_attribute7_o => per_apr_shd.g_old_rec.attribute7 ,

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 ,

Line 312: p_attribute8_o => per_apr_shd.g_old_rec.attribute8 ,

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 ,

Line 313: p_attribute9_o => per_apr_shd.g_old_rec.attribute9 ,

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 ,

Line 314: p_attribute10_o => per_apr_shd.g_old_rec.attribute10 ,

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 ,

Line 315: p_attribute11_o => per_apr_shd.g_old_rec.attribute11 ,

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 ,

Line 316: p_attribute12_o => per_apr_shd.g_old_rec.attribute12 ,

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 ,

Line 317: p_attribute13_o => per_apr_shd.g_old_rec.attribute13 ,

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 ,

Line 318: p_attribute14_o => per_apr_shd.g_old_rec.attribute14 ,

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 ,

Line 319: p_attribute15_o => per_apr_shd.g_old_rec.attribute15 ,

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 ,

Line 320: p_attribute16_o => per_apr_shd.g_old_rec.attribute16 ,

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 ,

Line 321: p_attribute17_o => per_apr_shd.g_old_rec.attribute17 ,

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,

Line 322: p_attribute18_o => per_apr_shd.g_old_rec.attribute18 ,

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 ,

Line 323: p_attribute19_o => per_apr_shd.g_old_rec.attribute19 ,

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,

Line 324: p_attribute20_o => per_apr_shd.g_old_rec.attribute20 ,

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 ,

Line 325: p_object_version_number_o => per_apr_shd.g_old_rec.object_version_number,

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 ,

Line 326: p_system_type_o => per_apr_shd.g_old_rec.system_type ,

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 ,

Line 327: p_system_params_o => per_apr_shd.g_old_rec.system_params,

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,

Line 328: p_appraisee_access_o => per_apr_shd.g_old_rec.appraisee_access ,

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,

Line 329: p_main_appraiser_id_o => per_apr_shd.g_old_rec.main_appraiser_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,

Line 330: p_assignment_id_o => per_apr_shd.g_old_rec.assignment_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 ,

Line 331: p_assignment_start_date_o => per_apr_shd.g_old_rec.assignment_start_date,

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,

Line 332: p_asg_business_group_id_o => per_apr_shd.g_old_rec.assignment_business_group_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 ,

Line 333: p_assignment_organization_id_o => per_apr_shd.g_old_rec.assignment_organization_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,

Line 334: p_assignment_job_id_o => per_apr_shd.g_old_rec.assignment_job_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,
338: p_potential_readiness_level_o => per_apr_shd.g_old_rec.potential_readiness_level,

Line 335: p_assignment_position_id_o => per_apr_shd.g_old_rec.assignment_position_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,
339: p_potnl_short_term_workopp_o => per_apr_shd.g_old_rec.potential_short_term_workopp,

Line 336: p_assignment_grade_id_o => per_apr_shd.g_old_rec.assignment_grade_id ,

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,

Line 337: p_appraisal_system_status_o => per_apr_shd.g_old_rec.appraisal_system_status,

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,

Line 338: p_potential_readiness_level_o => per_apr_shd.g_old_rec.potential_readiness_level,

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,

Line 339: p_potnl_short_term_workopp_o => per_apr_shd.g_old_rec.potential_short_term_workopp,

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,

Line 340: p_potnl_long_term_workopp_o => per_apr_shd.g_old_rec.potential_long_term_workopp,

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,

Line 341: p_potential_details_o => per_apr_shd.g_old_rec.potential_details,

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,

Line 342: p_event_id_o => per_apr_shd.g_old_rec.event_id,

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,

Line 343: p_show_competency_ratings_o => per_apr_shd.g_old_rec.show_competency_ratings,

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,

Line 344: p_show_objective_ratings_o => per_apr_shd.g_old_rec.show_objective_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,

Line 345: p_show_questionnaire_info_o => per_apr_shd.g_old_rec.show_questionnaire_info,

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,

Line 346: p_show_participant_details_o => per_apr_shd.g_old_rec.show_participant_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,
350: p_show_overall_comments_o => per_apr_shd.g_old_rec.show_overall_comments,

Line 347: p_show_participant_ratings_o => per_apr_shd.g_old_rec.show_participant_ratings,

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,

Line 348: p_show_participant_names_o => per_apr_shd.g_old_rec.show_participant_names,

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,

Line 349: p_show_overall_ratings_o => per_apr_shd.g_old_rec.show_overall_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,
353: p_appraisee_comments_o => per_apr_shd.g_old_rec.appraisee_comments,

Line 350: p_show_overall_comments_o => per_apr_shd.g_old_rec.show_overall_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,

Line 351: p_update_appraisal_o => per_apr_shd.g_old_rec.update_appraisal,

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

Line 352: p_provide_overall_feedback_o => per_apr_shd.g_old_rec.provide_overall_feedback,

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: );

Line 353: p_appraisee_comments_o => per_apr_shd.g_old_rec.appraisee_comments,

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

Line 354: p_plan_id_o => per_apr_shd.g_old_rec.plan_id,

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

Line 355: p_offline_status_o => per_apr_shd.g_old_rec.offline_status

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

Line 413: Procedure convert_defs(p_rec in out nocopy per_apr_shd.g_rec_type) is

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

Line 428: per_apr_shd.g_old_rec.business_group_id;

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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 475: p_rec.open := per_apr_shd.g_old_rec.open;

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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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 :=

Line 564: per_apr_shd.g_old_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;

Line 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 :=

Line 573: per_apr_shd.g_old_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;

Line 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;

Line 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;

Line 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 :=

Line 590: per_apr_shd.g_old_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;

Line 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;

Line 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;

Line 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;

Line 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 :=

Line 611: per_apr_shd.g_old_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;

Line 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;

Line 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;

Line 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;

Line 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 :=

Line 632: per_apr_shd.g_old_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 :=

Line 637: per_apr_shd.g_old_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 :=

Line 642: per_apr_shd.g_old_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 :=

Line 647: per_apr_shd.g_old_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 :=

Line 652: per_apr_shd.g_old_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 :=

Line 657: per_apr_shd.g_old_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 :=

Line 662: per_apr_shd.g_old_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 :=

Line 667: per_apr_shd.g_old_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 :=

Line 672: per_apr_shd.g_old_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 :=

Line 677: per_apr_shd.g_old_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 :=

Line 682: per_apr_shd.g_old_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 :=

Line 687: per_apr_shd.g_old_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 :=

Line 692: per_apr_shd.g_old_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 :=

Line 697: per_apr_shd.g_old_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;

Line 708: p_rec in out nocopy per_apr_shd.g_rec_type,

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:

Line 729: per_apr_shd.lck

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: );

Line 847: l_rec per_apr_shd.g_rec_type;

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);

Line 857: per_apr_shd.convert_args

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,