44: -- Internal Table Handler Use Only.
45:
46: -- {End Of Comments}
47: -- ---------------------------------------------------------------------------+
48: Procedure update_dml(p_rec in out nocopy per_apt_shd.g_rec_type) is
49:
50: l_proc varchar2(72) := g_package||'update_dml';
51:
52: Begin
120:
121: Exception
122: When hr_api.check_integrity_violated Then
123: -- A check constraint has been violated
124: per_apt_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.parent_integrity_violated Then
127: -- Parent integrity has been violated
128: per_apt_shd.constraint_error
124: per_apt_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.parent_integrity_violated Then
127: -- Parent integrity has been violated
128: per_apt_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When hr_api.unique_integrity_violated Then
131: -- Unique integrity has been violated
132: per_apt_shd.constraint_error
128: per_apt_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When hr_api.unique_integrity_violated Then
131: -- Unique integrity has been violated
132: per_apt_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When Others Then
135: Raise;
136: End update_dml;
166: -- Internal Table Handler Use Only.
167:
168: -- {End Of Comments}
169: -- ---------------------------------------------------------------------------+
170: Procedure pre_update(p_rec in per_apt_shd.g_rec_type) is
171:
172: l_proc varchar2(72) := g_package||'pre_update';
173:
174: Begin
208: -- Internal Table Handler Use Only.
209:
210: -- {End Of Comments}
211: -- ---------------------------------------------------------------------------+
212: Procedure post_update(p_rec in per_apt_shd.g_rec_type) is
213:
214: l_proc varchar2(72) := g_package||'post_update';
215:
216: Begin
274: p_appraisee_off_template_code => p_rec.appraisee_off_template_code,
275: p_other_part_off_template_code => p_rec.other_part_off_template_code,
276: p_part_app_off_template_code => p_rec.part_app_off_template_code,
277: p_part_rev_off_template_code => p_rec.part_rev_off_template_code,
278: p_business_group_id_o => per_apt_shd.g_old_rec.business_group_id ,
279: p_object_version_number_o => per_apt_shd.g_old_rec.object_version_number ,
280: p_name_o => per_apt_shd.g_old_rec.name ,
281: p_description_o => per_apt_shd.g_old_rec.description ,
282: p_instructions_o => per_apt_shd.g_old_rec.instructions ,
275: p_other_part_off_template_code => p_rec.other_part_off_template_code,
276: p_part_app_off_template_code => p_rec.part_app_off_template_code,
277: p_part_rev_off_template_code => p_rec.part_rev_off_template_code,
278: p_business_group_id_o => per_apt_shd.g_old_rec.business_group_id ,
279: p_object_version_number_o => per_apt_shd.g_old_rec.object_version_number ,
280: p_name_o => per_apt_shd.g_old_rec.name ,
281: p_description_o => per_apt_shd.g_old_rec.description ,
282: p_instructions_o => per_apt_shd.g_old_rec.instructions ,
283: p_date_from_o => per_apt_shd.g_old_rec.date_from ,
276: p_part_app_off_template_code => p_rec.part_app_off_template_code,
277: p_part_rev_off_template_code => p_rec.part_rev_off_template_code,
278: p_business_group_id_o => per_apt_shd.g_old_rec.business_group_id ,
279: p_object_version_number_o => per_apt_shd.g_old_rec.object_version_number ,
280: p_name_o => per_apt_shd.g_old_rec.name ,
281: p_description_o => per_apt_shd.g_old_rec.description ,
282: p_instructions_o => per_apt_shd.g_old_rec.instructions ,
283: p_date_from_o => per_apt_shd.g_old_rec.date_from ,
284: p_date_to_o => per_apt_shd.g_old_rec.date_to ,
277: p_part_rev_off_template_code => p_rec.part_rev_off_template_code,
278: p_business_group_id_o => per_apt_shd.g_old_rec.business_group_id ,
279: p_object_version_number_o => per_apt_shd.g_old_rec.object_version_number ,
280: p_name_o => per_apt_shd.g_old_rec.name ,
281: p_description_o => per_apt_shd.g_old_rec.description ,
282: p_instructions_o => per_apt_shd.g_old_rec.instructions ,
283: p_date_from_o => per_apt_shd.g_old_rec.date_from ,
284: p_date_to_o => per_apt_shd.g_old_rec.date_to ,
285: p_assessment_type_id_o => per_apt_shd.g_old_rec.assessment_type_id ,
278: p_business_group_id_o => per_apt_shd.g_old_rec.business_group_id ,
279: p_object_version_number_o => per_apt_shd.g_old_rec.object_version_number ,
280: p_name_o => per_apt_shd.g_old_rec.name ,
281: p_description_o => per_apt_shd.g_old_rec.description ,
282: p_instructions_o => per_apt_shd.g_old_rec.instructions ,
283: p_date_from_o => per_apt_shd.g_old_rec.date_from ,
284: p_date_to_o => per_apt_shd.g_old_rec.date_to ,
285: p_assessment_type_id_o => per_apt_shd.g_old_rec.assessment_type_id ,
286: p_rating_scale_id_o => per_apt_shd.g_old_rec.rating_scale_id ,
279: p_object_version_number_o => per_apt_shd.g_old_rec.object_version_number ,
280: p_name_o => per_apt_shd.g_old_rec.name ,
281: p_description_o => per_apt_shd.g_old_rec.description ,
282: p_instructions_o => per_apt_shd.g_old_rec.instructions ,
283: p_date_from_o => per_apt_shd.g_old_rec.date_from ,
284: p_date_to_o => per_apt_shd.g_old_rec.date_to ,
285: p_assessment_type_id_o => per_apt_shd.g_old_rec.assessment_type_id ,
286: p_rating_scale_id_o => per_apt_shd.g_old_rec.rating_scale_id ,
287: p_questionnaire_template_id_o => per_apt_shd.g_old_rec.questionnaire_template_id ,
280: p_name_o => per_apt_shd.g_old_rec.name ,
281: p_description_o => per_apt_shd.g_old_rec.description ,
282: p_instructions_o => per_apt_shd.g_old_rec.instructions ,
283: p_date_from_o => per_apt_shd.g_old_rec.date_from ,
284: p_date_to_o => per_apt_shd.g_old_rec.date_to ,
285: p_assessment_type_id_o => per_apt_shd.g_old_rec.assessment_type_id ,
286: p_rating_scale_id_o => per_apt_shd.g_old_rec.rating_scale_id ,
287: p_questionnaire_template_id_o => per_apt_shd.g_old_rec.questionnaire_template_id ,
288: p_attribute_category_o => per_apt_shd.g_old_rec.attribute_category ,
281: p_description_o => per_apt_shd.g_old_rec.description ,
282: p_instructions_o => per_apt_shd.g_old_rec.instructions ,
283: p_date_from_o => per_apt_shd.g_old_rec.date_from ,
284: p_date_to_o => per_apt_shd.g_old_rec.date_to ,
285: p_assessment_type_id_o => per_apt_shd.g_old_rec.assessment_type_id ,
286: p_rating_scale_id_o => per_apt_shd.g_old_rec.rating_scale_id ,
287: p_questionnaire_template_id_o => per_apt_shd.g_old_rec.questionnaire_template_id ,
288: p_attribute_category_o => per_apt_shd.g_old_rec.attribute_category ,
289: p_attribute1_o => per_apt_shd.g_old_rec.attribute1 ,
282: p_instructions_o => per_apt_shd.g_old_rec.instructions ,
283: p_date_from_o => per_apt_shd.g_old_rec.date_from ,
284: p_date_to_o => per_apt_shd.g_old_rec.date_to ,
285: p_assessment_type_id_o => per_apt_shd.g_old_rec.assessment_type_id ,
286: p_rating_scale_id_o => per_apt_shd.g_old_rec.rating_scale_id ,
287: p_questionnaire_template_id_o => per_apt_shd.g_old_rec.questionnaire_template_id ,
288: p_attribute_category_o => per_apt_shd.g_old_rec.attribute_category ,
289: p_attribute1_o => per_apt_shd.g_old_rec.attribute1 ,
290: p_attribute2_o => per_apt_shd.g_old_rec.attribute2 ,
283: p_date_from_o => per_apt_shd.g_old_rec.date_from ,
284: p_date_to_o => per_apt_shd.g_old_rec.date_to ,
285: p_assessment_type_id_o => per_apt_shd.g_old_rec.assessment_type_id ,
286: p_rating_scale_id_o => per_apt_shd.g_old_rec.rating_scale_id ,
287: p_questionnaire_template_id_o => per_apt_shd.g_old_rec.questionnaire_template_id ,
288: p_attribute_category_o => per_apt_shd.g_old_rec.attribute_category ,
289: p_attribute1_o => per_apt_shd.g_old_rec.attribute1 ,
290: p_attribute2_o => per_apt_shd.g_old_rec.attribute2 ,
291: p_attribute3_o => per_apt_shd.g_old_rec.attribute3 ,
284: p_date_to_o => per_apt_shd.g_old_rec.date_to ,
285: p_assessment_type_id_o => per_apt_shd.g_old_rec.assessment_type_id ,
286: p_rating_scale_id_o => per_apt_shd.g_old_rec.rating_scale_id ,
287: p_questionnaire_template_id_o => per_apt_shd.g_old_rec.questionnaire_template_id ,
288: p_attribute_category_o => per_apt_shd.g_old_rec.attribute_category ,
289: p_attribute1_o => per_apt_shd.g_old_rec.attribute1 ,
290: p_attribute2_o => per_apt_shd.g_old_rec.attribute2 ,
291: p_attribute3_o => per_apt_shd.g_old_rec.attribute3 ,
292: p_attribute4_o => per_apt_shd.g_old_rec.attribute4 ,
285: p_assessment_type_id_o => per_apt_shd.g_old_rec.assessment_type_id ,
286: p_rating_scale_id_o => per_apt_shd.g_old_rec.rating_scale_id ,
287: p_questionnaire_template_id_o => per_apt_shd.g_old_rec.questionnaire_template_id ,
288: p_attribute_category_o => per_apt_shd.g_old_rec.attribute_category ,
289: p_attribute1_o => per_apt_shd.g_old_rec.attribute1 ,
290: p_attribute2_o => per_apt_shd.g_old_rec.attribute2 ,
291: p_attribute3_o => per_apt_shd.g_old_rec.attribute3 ,
292: p_attribute4_o => per_apt_shd.g_old_rec.attribute4 ,
293: p_attribute5_o => per_apt_shd.g_old_rec.attribute5 ,
286: p_rating_scale_id_o => per_apt_shd.g_old_rec.rating_scale_id ,
287: p_questionnaire_template_id_o => per_apt_shd.g_old_rec.questionnaire_template_id ,
288: p_attribute_category_o => per_apt_shd.g_old_rec.attribute_category ,
289: p_attribute1_o => per_apt_shd.g_old_rec.attribute1 ,
290: p_attribute2_o => per_apt_shd.g_old_rec.attribute2 ,
291: p_attribute3_o => per_apt_shd.g_old_rec.attribute3 ,
292: p_attribute4_o => per_apt_shd.g_old_rec.attribute4 ,
293: p_attribute5_o => per_apt_shd.g_old_rec.attribute5 ,
294: p_attribute6_o => per_apt_shd.g_old_rec.attribute6 ,
287: p_questionnaire_template_id_o => per_apt_shd.g_old_rec.questionnaire_template_id ,
288: p_attribute_category_o => per_apt_shd.g_old_rec.attribute_category ,
289: p_attribute1_o => per_apt_shd.g_old_rec.attribute1 ,
290: p_attribute2_o => per_apt_shd.g_old_rec.attribute2 ,
291: p_attribute3_o => per_apt_shd.g_old_rec.attribute3 ,
292: p_attribute4_o => per_apt_shd.g_old_rec.attribute4 ,
293: p_attribute5_o => per_apt_shd.g_old_rec.attribute5 ,
294: p_attribute6_o => per_apt_shd.g_old_rec.attribute6 ,
295: p_attribute7_o => per_apt_shd.g_old_rec.attribute7 ,
288: p_attribute_category_o => per_apt_shd.g_old_rec.attribute_category ,
289: p_attribute1_o => per_apt_shd.g_old_rec.attribute1 ,
290: p_attribute2_o => per_apt_shd.g_old_rec.attribute2 ,
291: p_attribute3_o => per_apt_shd.g_old_rec.attribute3 ,
292: p_attribute4_o => per_apt_shd.g_old_rec.attribute4 ,
293: p_attribute5_o => per_apt_shd.g_old_rec.attribute5 ,
294: p_attribute6_o => per_apt_shd.g_old_rec.attribute6 ,
295: p_attribute7_o => per_apt_shd.g_old_rec.attribute7 ,
296: p_attribute8_o => per_apt_shd.g_old_rec.attribute8 ,
289: p_attribute1_o => per_apt_shd.g_old_rec.attribute1 ,
290: p_attribute2_o => per_apt_shd.g_old_rec.attribute2 ,
291: p_attribute3_o => per_apt_shd.g_old_rec.attribute3 ,
292: p_attribute4_o => per_apt_shd.g_old_rec.attribute4 ,
293: p_attribute5_o => per_apt_shd.g_old_rec.attribute5 ,
294: p_attribute6_o => per_apt_shd.g_old_rec.attribute6 ,
295: p_attribute7_o => per_apt_shd.g_old_rec.attribute7 ,
296: p_attribute8_o => per_apt_shd.g_old_rec.attribute8 ,
297: p_attribute9_o => per_apt_shd.g_old_rec.attribute9 ,
290: p_attribute2_o => per_apt_shd.g_old_rec.attribute2 ,
291: p_attribute3_o => per_apt_shd.g_old_rec.attribute3 ,
292: p_attribute4_o => per_apt_shd.g_old_rec.attribute4 ,
293: p_attribute5_o => per_apt_shd.g_old_rec.attribute5 ,
294: p_attribute6_o => per_apt_shd.g_old_rec.attribute6 ,
295: p_attribute7_o => per_apt_shd.g_old_rec.attribute7 ,
296: p_attribute8_o => per_apt_shd.g_old_rec.attribute8 ,
297: p_attribute9_o => per_apt_shd.g_old_rec.attribute9 ,
298: p_attribute10_o => per_apt_shd.g_old_rec.attribute10 ,
291: p_attribute3_o => per_apt_shd.g_old_rec.attribute3 ,
292: p_attribute4_o => per_apt_shd.g_old_rec.attribute4 ,
293: p_attribute5_o => per_apt_shd.g_old_rec.attribute5 ,
294: p_attribute6_o => per_apt_shd.g_old_rec.attribute6 ,
295: p_attribute7_o => per_apt_shd.g_old_rec.attribute7 ,
296: p_attribute8_o => per_apt_shd.g_old_rec.attribute8 ,
297: p_attribute9_o => per_apt_shd.g_old_rec.attribute9 ,
298: p_attribute10_o => per_apt_shd.g_old_rec.attribute10 ,
299: p_attribute11_o => per_apt_shd.g_old_rec.attribute11 ,
292: p_attribute4_o => per_apt_shd.g_old_rec.attribute4 ,
293: p_attribute5_o => per_apt_shd.g_old_rec.attribute5 ,
294: p_attribute6_o => per_apt_shd.g_old_rec.attribute6 ,
295: p_attribute7_o => per_apt_shd.g_old_rec.attribute7 ,
296: p_attribute8_o => per_apt_shd.g_old_rec.attribute8 ,
297: p_attribute9_o => per_apt_shd.g_old_rec.attribute9 ,
298: p_attribute10_o => per_apt_shd.g_old_rec.attribute10 ,
299: p_attribute11_o => per_apt_shd.g_old_rec.attribute11 ,
300: p_attribute12_o => per_apt_shd.g_old_rec.attribute12 ,
293: p_attribute5_o => per_apt_shd.g_old_rec.attribute5 ,
294: p_attribute6_o => per_apt_shd.g_old_rec.attribute6 ,
295: p_attribute7_o => per_apt_shd.g_old_rec.attribute7 ,
296: p_attribute8_o => per_apt_shd.g_old_rec.attribute8 ,
297: p_attribute9_o => per_apt_shd.g_old_rec.attribute9 ,
298: p_attribute10_o => per_apt_shd.g_old_rec.attribute10 ,
299: p_attribute11_o => per_apt_shd.g_old_rec.attribute11 ,
300: p_attribute12_o => per_apt_shd.g_old_rec.attribute12 ,
301: p_attribute13_o => per_apt_shd.g_old_rec.attribute13 ,
294: p_attribute6_o => per_apt_shd.g_old_rec.attribute6 ,
295: p_attribute7_o => per_apt_shd.g_old_rec.attribute7 ,
296: p_attribute8_o => per_apt_shd.g_old_rec.attribute8 ,
297: p_attribute9_o => per_apt_shd.g_old_rec.attribute9 ,
298: p_attribute10_o => per_apt_shd.g_old_rec.attribute10 ,
299: p_attribute11_o => per_apt_shd.g_old_rec.attribute11 ,
300: p_attribute12_o => per_apt_shd.g_old_rec.attribute12 ,
301: p_attribute13_o => per_apt_shd.g_old_rec.attribute13 ,
302: p_attribute14_o => per_apt_shd.g_old_rec.attribute14 ,
295: p_attribute7_o => per_apt_shd.g_old_rec.attribute7 ,
296: p_attribute8_o => per_apt_shd.g_old_rec.attribute8 ,
297: p_attribute9_o => per_apt_shd.g_old_rec.attribute9 ,
298: p_attribute10_o => per_apt_shd.g_old_rec.attribute10 ,
299: p_attribute11_o => per_apt_shd.g_old_rec.attribute11 ,
300: p_attribute12_o => per_apt_shd.g_old_rec.attribute12 ,
301: p_attribute13_o => per_apt_shd.g_old_rec.attribute13 ,
302: p_attribute14_o => per_apt_shd.g_old_rec.attribute14 ,
303: p_attribute15_o => per_apt_shd.g_old_rec.attribute15 ,
296: p_attribute8_o => per_apt_shd.g_old_rec.attribute8 ,
297: p_attribute9_o => per_apt_shd.g_old_rec.attribute9 ,
298: p_attribute10_o => per_apt_shd.g_old_rec.attribute10 ,
299: p_attribute11_o => per_apt_shd.g_old_rec.attribute11 ,
300: p_attribute12_o => per_apt_shd.g_old_rec.attribute12 ,
301: p_attribute13_o => per_apt_shd.g_old_rec.attribute13 ,
302: p_attribute14_o => per_apt_shd.g_old_rec.attribute14 ,
303: p_attribute15_o => per_apt_shd.g_old_rec.attribute15 ,
304: p_attribute16_o => per_apt_shd.g_old_rec.attribute16 ,
297: p_attribute9_o => per_apt_shd.g_old_rec.attribute9 ,
298: p_attribute10_o => per_apt_shd.g_old_rec.attribute10 ,
299: p_attribute11_o => per_apt_shd.g_old_rec.attribute11 ,
300: p_attribute12_o => per_apt_shd.g_old_rec.attribute12 ,
301: p_attribute13_o => per_apt_shd.g_old_rec.attribute13 ,
302: p_attribute14_o => per_apt_shd.g_old_rec.attribute14 ,
303: p_attribute15_o => per_apt_shd.g_old_rec.attribute15 ,
304: p_attribute16_o => per_apt_shd.g_old_rec.attribute16 ,
305: p_attribute17_o => per_apt_shd.g_old_rec.attribute17 ,
298: p_attribute10_o => per_apt_shd.g_old_rec.attribute10 ,
299: p_attribute11_o => per_apt_shd.g_old_rec.attribute11 ,
300: p_attribute12_o => per_apt_shd.g_old_rec.attribute12 ,
301: p_attribute13_o => per_apt_shd.g_old_rec.attribute13 ,
302: p_attribute14_o => per_apt_shd.g_old_rec.attribute14 ,
303: p_attribute15_o => per_apt_shd.g_old_rec.attribute15 ,
304: p_attribute16_o => per_apt_shd.g_old_rec.attribute16 ,
305: p_attribute17_o => per_apt_shd.g_old_rec.attribute17 ,
306: p_attribute18_o => per_apt_shd.g_old_rec.attribute18 ,
299: p_attribute11_o => per_apt_shd.g_old_rec.attribute11 ,
300: p_attribute12_o => per_apt_shd.g_old_rec.attribute12 ,
301: p_attribute13_o => per_apt_shd.g_old_rec.attribute13 ,
302: p_attribute14_o => per_apt_shd.g_old_rec.attribute14 ,
303: p_attribute15_o => per_apt_shd.g_old_rec.attribute15 ,
304: p_attribute16_o => per_apt_shd.g_old_rec.attribute16 ,
305: p_attribute17_o => per_apt_shd.g_old_rec.attribute17 ,
306: p_attribute18_o => per_apt_shd.g_old_rec.attribute18 ,
307: p_attribute19_o => per_apt_shd.g_old_rec.attribute19 ,
300: p_attribute12_o => per_apt_shd.g_old_rec.attribute12 ,
301: p_attribute13_o => per_apt_shd.g_old_rec.attribute13 ,
302: p_attribute14_o => per_apt_shd.g_old_rec.attribute14 ,
303: p_attribute15_o => per_apt_shd.g_old_rec.attribute15 ,
304: p_attribute16_o => per_apt_shd.g_old_rec.attribute16 ,
305: p_attribute17_o => per_apt_shd.g_old_rec.attribute17 ,
306: p_attribute18_o => per_apt_shd.g_old_rec.attribute18 ,
307: p_attribute19_o => per_apt_shd.g_old_rec.attribute19 ,
308: p_attribute20_o => per_apt_shd.g_old_rec.attribute20 ,
301: p_attribute13_o => per_apt_shd.g_old_rec.attribute13 ,
302: p_attribute14_o => per_apt_shd.g_old_rec.attribute14 ,
303: p_attribute15_o => per_apt_shd.g_old_rec.attribute15 ,
304: p_attribute16_o => per_apt_shd.g_old_rec.attribute16 ,
305: p_attribute17_o => per_apt_shd.g_old_rec.attribute17 ,
306: p_attribute18_o => per_apt_shd.g_old_rec.attribute18 ,
307: p_attribute19_o => per_apt_shd.g_old_rec.attribute19 ,
308: p_attribute20_o => per_apt_shd.g_old_rec.attribute20 ,
309: p_objective_asmnt_type_id_o => per_apt_shd.g_old_rec.objective_asmnt_type_id,
302: p_attribute14_o => per_apt_shd.g_old_rec.attribute14 ,
303: p_attribute15_o => per_apt_shd.g_old_rec.attribute15 ,
304: p_attribute16_o => per_apt_shd.g_old_rec.attribute16 ,
305: p_attribute17_o => per_apt_shd.g_old_rec.attribute17 ,
306: p_attribute18_o => per_apt_shd.g_old_rec.attribute18 ,
307: p_attribute19_o => per_apt_shd.g_old_rec.attribute19 ,
308: p_attribute20_o => per_apt_shd.g_old_rec.attribute20 ,
309: p_objective_asmnt_type_id_o => per_apt_shd.g_old_rec.objective_asmnt_type_id,
310: p_ma_quest_template_id_o => per_apt_shd.g_old_rec.ma_quest_template_id,
303: p_attribute15_o => per_apt_shd.g_old_rec.attribute15 ,
304: p_attribute16_o => per_apt_shd.g_old_rec.attribute16 ,
305: p_attribute17_o => per_apt_shd.g_old_rec.attribute17 ,
306: p_attribute18_o => per_apt_shd.g_old_rec.attribute18 ,
307: p_attribute19_o => per_apt_shd.g_old_rec.attribute19 ,
308: p_attribute20_o => per_apt_shd.g_old_rec.attribute20 ,
309: p_objective_asmnt_type_id_o => per_apt_shd.g_old_rec.objective_asmnt_type_id,
310: p_ma_quest_template_id_o => per_apt_shd.g_old_rec.ma_quest_template_id,
311: p_link_appr_to_learning_path_o => per_apt_shd.g_old_rec.link_appr_to_learning_path,
304: p_attribute16_o => per_apt_shd.g_old_rec.attribute16 ,
305: p_attribute17_o => per_apt_shd.g_old_rec.attribute17 ,
306: p_attribute18_o => per_apt_shd.g_old_rec.attribute18 ,
307: p_attribute19_o => per_apt_shd.g_old_rec.attribute19 ,
308: p_attribute20_o => per_apt_shd.g_old_rec.attribute20 ,
309: p_objective_asmnt_type_id_o => per_apt_shd.g_old_rec.objective_asmnt_type_id,
310: p_ma_quest_template_id_o => per_apt_shd.g_old_rec.ma_quest_template_id,
311: p_link_appr_to_learning_path_o => per_apt_shd.g_old_rec.link_appr_to_learning_path,
312: p_final_score_formula_id_o => per_apt_shd.g_old_rec.final_score_formula_id,
305: p_attribute17_o => per_apt_shd.g_old_rec.attribute17 ,
306: p_attribute18_o => per_apt_shd.g_old_rec.attribute18 ,
307: p_attribute19_o => per_apt_shd.g_old_rec.attribute19 ,
308: p_attribute20_o => per_apt_shd.g_old_rec.attribute20 ,
309: p_objective_asmnt_type_id_o => per_apt_shd.g_old_rec.objective_asmnt_type_id,
310: p_ma_quest_template_id_o => per_apt_shd.g_old_rec.ma_quest_template_id,
311: p_link_appr_to_learning_path_o => per_apt_shd.g_old_rec.link_appr_to_learning_path,
312: p_final_score_formula_id_o => per_apt_shd.g_old_rec.final_score_formula_id,
313: p_update_personal_comp_profi_o => per_apt_shd.g_old_rec.update_personal_comp_profile,
306: p_attribute18_o => per_apt_shd.g_old_rec.attribute18 ,
307: p_attribute19_o => per_apt_shd.g_old_rec.attribute19 ,
308: p_attribute20_o => per_apt_shd.g_old_rec.attribute20 ,
309: p_objective_asmnt_type_id_o => per_apt_shd.g_old_rec.objective_asmnt_type_id,
310: p_ma_quest_template_id_o => per_apt_shd.g_old_rec.ma_quest_template_id,
311: p_link_appr_to_learning_path_o => per_apt_shd.g_old_rec.link_appr_to_learning_path,
312: p_final_score_formula_id_o => per_apt_shd.g_old_rec.final_score_formula_id,
313: p_update_personal_comp_profi_o => per_apt_shd.g_old_rec.update_personal_comp_profile,
314: p_comp_profile_source_type_o => per_apt_shd.g_old_rec.comp_profile_source_type,
307: p_attribute19_o => per_apt_shd.g_old_rec.attribute19 ,
308: p_attribute20_o => per_apt_shd.g_old_rec.attribute20 ,
309: p_objective_asmnt_type_id_o => per_apt_shd.g_old_rec.objective_asmnt_type_id,
310: p_ma_quest_template_id_o => per_apt_shd.g_old_rec.ma_quest_template_id,
311: p_link_appr_to_learning_path_o => per_apt_shd.g_old_rec.link_appr_to_learning_path,
312: p_final_score_formula_id_o => per_apt_shd.g_old_rec.final_score_formula_id,
313: p_update_personal_comp_profi_o => per_apt_shd.g_old_rec.update_personal_comp_profile,
314: p_comp_profile_source_type_o => per_apt_shd.g_old_rec.comp_profile_source_type,
315: p_show_competency_ratings_o => per_apt_shd.g_old_rec.show_competency_ratings,
308: p_attribute20_o => per_apt_shd.g_old_rec.attribute20 ,
309: p_objective_asmnt_type_id_o => per_apt_shd.g_old_rec.objective_asmnt_type_id,
310: p_ma_quest_template_id_o => per_apt_shd.g_old_rec.ma_quest_template_id,
311: p_link_appr_to_learning_path_o => per_apt_shd.g_old_rec.link_appr_to_learning_path,
312: p_final_score_formula_id_o => per_apt_shd.g_old_rec.final_score_formula_id,
313: p_update_personal_comp_profi_o => per_apt_shd.g_old_rec.update_personal_comp_profile,
314: p_comp_profile_source_type_o => per_apt_shd.g_old_rec.comp_profile_source_type,
315: p_show_competency_ratings_o => per_apt_shd.g_old_rec.show_competency_ratings,
316: p_show_objective_ratings_o => per_apt_shd.g_old_rec.show_objective_ratings,
309: p_objective_asmnt_type_id_o => per_apt_shd.g_old_rec.objective_asmnt_type_id,
310: p_ma_quest_template_id_o => per_apt_shd.g_old_rec.ma_quest_template_id,
311: p_link_appr_to_learning_path_o => per_apt_shd.g_old_rec.link_appr_to_learning_path,
312: p_final_score_formula_id_o => per_apt_shd.g_old_rec.final_score_formula_id,
313: p_update_personal_comp_profi_o => per_apt_shd.g_old_rec.update_personal_comp_profile,
314: p_comp_profile_source_type_o => per_apt_shd.g_old_rec.comp_profile_source_type,
315: p_show_competency_ratings_o => per_apt_shd.g_old_rec.show_competency_ratings,
316: p_show_objective_ratings_o => per_apt_shd.g_old_rec.show_objective_ratings,
317: p_show_overall_ratings_o => per_apt_shd.g_old_rec.show_overall_ratings,
310: p_ma_quest_template_id_o => per_apt_shd.g_old_rec.ma_quest_template_id,
311: p_link_appr_to_learning_path_o => per_apt_shd.g_old_rec.link_appr_to_learning_path,
312: p_final_score_formula_id_o => per_apt_shd.g_old_rec.final_score_formula_id,
313: p_update_personal_comp_profi_o => per_apt_shd.g_old_rec.update_personal_comp_profile,
314: p_comp_profile_source_type_o => per_apt_shd.g_old_rec.comp_profile_source_type,
315: p_show_competency_ratings_o => per_apt_shd.g_old_rec.show_competency_ratings,
316: p_show_objective_ratings_o => per_apt_shd.g_old_rec.show_objective_ratings,
317: p_show_overall_ratings_o => per_apt_shd.g_old_rec.show_overall_ratings,
318: p_show_overall_comments_o => per_apt_shd.g_old_rec.show_overall_comments,
311: p_link_appr_to_learning_path_o => per_apt_shd.g_old_rec.link_appr_to_learning_path,
312: p_final_score_formula_id_o => per_apt_shd.g_old_rec.final_score_formula_id,
313: p_update_personal_comp_profi_o => per_apt_shd.g_old_rec.update_personal_comp_profile,
314: p_comp_profile_source_type_o => per_apt_shd.g_old_rec.comp_profile_source_type,
315: p_show_competency_ratings_o => per_apt_shd.g_old_rec.show_competency_ratings,
316: p_show_objective_ratings_o => per_apt_shd.g_old_rec.show_objective_ratings,
317: p_show_overall_ratings_o => per_apt_shd.g_old_rec.show_overall_ratings,
318: p_show_overall_comments_o => per_apt_shd.g_old_rec.show_overall_comments,
319: p_provide_overall_feedback_o => per_apt_shd.g_old_rec.provide_overall_feedback,
312: p_final_score_formula_id_o => per_apt_shd.g_old_rec.final_score_formula_id,
313: p_update_personal_comp_profi_o => per_apt_shd.g_old_rec.update_personal_comp_profile,
314: p_comp_profile_source_type_o => per_apt_shd.g_old_rec.comp_profile_source_type,
315: p_show_competency_ratings_o => per_apt_shd.g_old_rec.show_competency_ratings,
316: p_show_objective_ratings_o => per_apt_shd.g_old_rec.show_objective_ratings,
317: p_show_overall_ratings_o => per_apt_shd.g_old_rec.show_overall_ratings,
318: p_show_overall_comments_o => per_apt_shd.g_old_rec.show_overall_comments,
319: p_provide_overall_feedback_o => per_apt_shd.g_old_rec.provide_overall_feedback,
320: p_show_participant_details_o => per_apt_shd.g_old_rec.show_participant_details,
313: p_update_personal_comp_profi_o => per_apt_shd.g_old_rec.update_personal_comp_profile,
314: p_comp_profile_source_type_o => per_apt_shd.g_old_rec.comp_profile_source_type,
315: p_show_competency_ratings_o => per_apt_shd.g_old_rec.show_competency_ratings,
316: p_show_objective_ratings_o => per_apt_shd.g_old_rec.show_objective_ratings,
317: p_show_overall_ratings_o => per_apt_shd.g_old_rec.show_overall_ratings,
318: p_show_overall_comments_o => per_apt_shd.g_old_rec.show_overall_comments,
319: p_provide_overall_feedback_o => per_apt_shd.g_old_rec.provide_overall_feedback,
320: p_show_participant_details_o => per_apt_shd.g_old_rec.show_participant_details,
321: p_allow_add_participant_o => per_apt_shd.g_old_rec.allow_add_participant,
314: p_comp_profile_source_type_o => per_apt_shd.g_old_rec.comp_profile_source_type,
315: p_show_competency_ratings_o => per_apt_shd.g_old_rec.show_competency_ratings,
316: p_show_objective_ratings_o => per_apt_shd.g_old_rec.show_objective_ratings,
317: p_show_overall_ratings_o => per_apt_shd.g_old_rec.show_overall_ratings,
318: p_show_overall_comments_o => per_apt_shd.g_old_rec.show_overall_comments,
319: p_provide_overall_feedback_o => per_apt_shd.g_old_rec.provide_overall_feedback,
320: p_show_participant_details_o => per_apt_shd.g_old_rec.show_participant_details,
321: p_allow_add_participant_o => per_apt_shd.g_old_rec.allow_add_participant,
322: p_show_additional_details_o => per_apt_shd.g_old_rec.show_additional_details,
315: p_show_competency_ratings_o => per_apt_shd.g_old_rec.show_competency_ratings,
316: p_show_objective_ratings_o => per_apt_shd.g_old_rec.show_objective_ratings,
317: p_show_overall_ratings_o => per_apt_shd.g_old_rec.show_overall_ratings,
318: p_show_overall_comments_o => per_apt_shd.g_old_rec.show_overall_comments,
319: p_provide_overall_feedback_o => per_apt_shd.g_old_rec.provide_overall_feedback,
320: p_show_participant_details_o => per_apt_shd.g_old_rec.show_participant_details,
321: p_allow_add_participant_o => per_apt_shd.g_old_rec.allow_add_participant,
322: p_show_additional_details_o => per_apt_shd.g_old_rec.show_additional_details,
323: p_show_participant_names_o => per_apt_shd.g_old_rec.show_participant_names,
316: p_show_objective_ratings_o => per_apt_shd.g_old_rec.show_objective_ratings,
317: p_show_overall_ratings_o => per_apt_shd.g_old_rec.show_overall_ratings,
318: p_show_overall_comments_o => per_apt_shd.g_old_rec.show_overall_comments,
319: p_provide_overall_feedback_o => per_apt_shd.g_old_rec.provide_overall_feedback,
320: p_show_participant_details_o => per_apt_shd.g_old_rec.show_participant_details,
321: p_allow_add_participant_o => per_apt_shd.g_old_rec.allow_add_participant,
322: p_show_additional_details_o => per_apt_shd.g_old_rec.show_additional_details,
323: p_show_participant_names_o => per_apt_shd.g_old_rec.show_participant_names,
324: p_show_participant_ratings_o => per_apt_shd.g_old_rec.show_participant_ratings,
317: p_show_overall_ratings_o => per_apt_shd.g_old_rec.show_overall_ratings,
318: p_show_overall_comments_o => per_apt_shd.g_old_rec.show_overall_comments,
319: p_provide_overall_feedback_o => per_apt_shd.g_old_rec.provide_overall_feedback,
320: p_show_participant_details_o => per_apt_shd.g_old_rec.show_participant_details,
321: p_allow_add_participant_o => per_apt_shd.g_old_rec.allow_add_participant,
322: p_show_additional_details_o => per_apt_shd.g_old_rec.show_additional_details,
323: p_show_participant_names_o => per_apt_shd.g_old_rec.show_participant_names,
324: p_show_participant_ratings_o => per_apt_shd.g_old_rec.show_participant_ratings,
325: p_available_flag_o => per_apt_shd.g_old_rec.available_flag,
318: p_show_overall_comments_o => per_apt_shd.g_old_rec.show_overall_comments,
319: p_provide_overall_feedback_o => per_apt_shd.g_old_rec.provide_overall_feedback,
320: p_show_participant_details_o => per_apt_shd.g_old_rec.show_participant_details,
321: p_allow_add_participant_o => per_apt_shd.g_old_rec.allow_add_participant,
322: p_show_additional_details_o => per_apt_shd.g_old_rec.show_additional_details,
323: p_show_participant_names_o => per_apt_shd.g_old_rec.show_participant_names,
324: p_show_participant_ratings_o => per_apt_shd.g_old_rec.show_participant_ratings,
325: p_available_flag_o => per_apt_shd.g_old_rec.available_flag,
326: p_show_questionnaire_info_o => per_apt_shd.g_old_rec.show_questionnaire_info,
319: p_provide_overall_feedback_o => per_apt_shd.g_old_rec.provide_overall_feedback,
320: p_show_participant_details_o => per_apt_shd.g_old_rec.show_participant_details,
321: p_allow_add_participant_o => per_apt_shd.g_old_rec.allow_add_participant,
322: p_show_additional_details_o => per_apt_shd.g_old_rec.show_additional_details,
323: p_show_participant_names_o => per_apt_shd.g_old_rec.show_participant_names,
324: p_show_participant_ratings_o => per_apt_shd.g_old_rec.show_participant_ratings,
325: p_available_flag_o => per_apt_shd.g_old_rec.available_flag,
326: p_show_questionnaire_info_o => per_apt_shd.g_old_rec.show_questionnaire_info,
327: p_ma_off_template_cd_o => per_apt_shd.g_old_rec.ma_off_template_code,
320: p_show_participant_details_o => per_apt_shd.g_old_rec.show_participant_details,
321: p_allow_add_participant_o => per_apt_shd.g_old_rec.allow_add_participant,
322: p_show_additional_details_o => per_apt_shd.g_old_rec.show_additional_details,
323: p_show_participant_names_o => per_apt_shd.g_old_rec.show_participant_names,
324: p_show_participant_ratings_o => per_apt_shd.g_old_rec.show_participant_ratings,
325: p_available_flag_o => per_apt_shd.g_old_rec.available_flag,
326: p_show_questionnaire_info_o => per_apt_shd.g_old_rec.show_questionnaire_info,
327: p_ma_off_template_cd_o => per_apt_shd.g_old_rec.ma_off_template_code,
328: p_appraisee_off_template_cd_o => per_apt_shd.g_old_rec.appraisee_off_template_code,
321: p_allow_add_participant_o => per_apt_shd.g_old_rec.allow_add_participant,
322: p_show_additional_details_o => per_apt_shd.g_old_rec.show_additional_details,
323: p_show_participant_names_o => per_apt_shd.g_old_rec.show_participant_names,
324: p_show_participant_ratings_o => per_apt_shd.g_old_rec.show_participant_ratings,
325: p_available_flag_o => per_apt_shd.g_old_rec.available_flag,
326: p_show_questionnaire_info_o => per_apt_shd.g_old_rec.show_questionnaire_info,
327: p_ma_off_template_cd_o => per_apt_shd.g_old_rec.ma_off_template_code,
328: p_appraisee_off_template_cd_o => per_apt_shd.g_old_rec.appraisee_off_template_code,
329: p_other_part_off_template_cd_o => per_apt_shd.g_old_rec.other_part_off_template_code,
322: p_show_additional_details_o => per_apt_shd.g_old_rec.show_additional_details,
323: p_show_participant_names_o => per_apt_shd.g_old_rec.show_participant_names,
324: p_show_participant_ratings_o => per_apt_shd.g_old_rec.show_participant_ratings,
325: p_available_flag_o => per_apt_shd.g_old_rec.available_flag,
326: p_show_questionnaire_info_o => per_apt_shd.g_old_rec.show_questionnaire_info,
327: p_ma_off_template_cd_o => per_apt_shd.g_old_rec.ma_off_template_code,
328: p_appraisee_off_template_cd_o => per_apt_shd.g_old_rec.appraisee_off_template_code,
329: p_other_part_off_template_cd_o => per_apt_shd.g_old_rec.other_part_off_template_code,
330: p_part_app_off_template_cd_o => per_apt_shd.g_old_rec.part_app_off_template_code,
323: p_show_participant_names_o => per_apt_shd.g_old_rec.show_participant_names,
324: p_show_participant_ratings_o => per_apt_shd.g_old_rec.show_participant_ratings,
325: p_available_flag_o => per_apt_shd.g_old_rec.available_flag,
326: p_show_questionnaire_info_o => per_apt_shd.g_old_rec.show_questionnaire_info,
327: p_ma_off_template_cd_o => per_apt_shd.g_old_rec.ma_off_template_code,
328: p_appraisee_off_template_cd_o => per_apt_shd.g_old_rec.appraisee_off_template_code,
329: p_other_part_off_template_cd_o => per_apt_shd.g_old_rec.other_part_off_template_code,
330: p_part_app_off_template_cd_o => per_apt_shd.g_old_rec.part_app_off_template_code,
331: p_part_rev_off_template_cd_o => per_apt_shd.g_old_rec.part_rev_off_template_code
324: p_show_participant_ratings_o => per_apt_shd.g_old_rec.show_participant_ratings,
325: p_available_flag_o => per_apt_shd.g_old_rec.available_flag,
326: p_show_questionnaire_info_o => per_apt_shd.g_old_rec.show_questionnaire_info,
327: p_ma_off_template_cd_o => per_apt_shd.g_old_rec.ma_off_template_code,
328: p_appraisee_off_template_cd_o => per_apt_shd.g_old_rec.appraisee_off_template_code,
329: p_other_part_off_template_cd_o => per_apt_shd.g_old_rec.other_part_off_template_code,
330: p_part_app_off_template_cd_o => per_apt_shd.g_old_rec.part_app_off_template_code,
331: p_part_rev_off_template_cd_o => per_apt_shd.g_old_rec.part_rev_off_template_code
332: );
325: p_available_flag_o => per_apt_shd.g_old_rec.available_flag,
326: p_show_questionnaire_info_o => per_apt_shd.g_old_rec.show_questionnaire_info,
327: p_ma_off_template_cd_o => per_apt_shd.g_old_rec.ma_off_template_code,
328: p_appraisee_off_template_cd_o => per_apt_shd.g_old_rec.appraisee_off_template_code,
329: p_other_part_off_template_cd_o => per_apt_shd.g_old_rec.other_part_off_template_code,
330: p_part_app_off_template_cd_o => per_apt_shd.g_old_rec.part_app_off_template_code,
331: p_part_rev_off_template_cd_o => per_apt_shd.g_old_rec.part_rev_off_template_code
332: );
333:
326: p_show_questionnaire_info_o => per_apt_shd.g_old_rec.show_questionnaire_info,
327: p_ma_off_template_cd_o => per_apt_shd.g_old_rec.ma_off_template_code,
328: p_appraisee_off_template_cd_o => per_apt_shd.g_old_rec.appraisee_off_template_code,
329: p_other_part_off_template_cd_o => per_apt_shd.g_old_rec.other_part_off_template_code,
330: p_part_app_off_template_cd_o => per_apt_shd.g_old_rec.part_app_off_template_code,
331: p_part_rev_off_template_cd_o => per_apt_shd.g_old_rec.part_rev_off_template_code
332: );
333:
334: exception
327: p_ma_off_template_cd_o => per_apt_shd.g_old_rec.ma_off_template_code,
328: p_appraisee_off_template_cd_o => per_apt_shd.g_old_rec.appraisee_off_template_code,
329: p_other_part_off_template_cd_o => per_apt_shd.g_old_rec.other_part_off_template_code,
330: p_part_app_off_template_cd_o => per_apt_shd.g_old_rec.part_app_off_template_code,
331: p_part_rev_off_template_cd_o => per_apt_shd.g_old_rec.part_rev_off_template_code
332: );
333:
334: exception
335: when hr_api.cannot_find_prog_unit then
386: -- Internal Table Handler Use Only.
387:
388: -- {End Of Comments}
389: -- ---------------------------------------------------------------------------+
390: Procedure convert_defs(p_rec in out nocopy per_apt_shd.g_rec_type) is
391:
392: l_proc varchar2(72) := g_package||'convert_defs';
393:
394: Begin
401: -- is being used then we must set to the 'current' argument value.
402:
403: If (p_rec.business_group_id = hr_api.g_number) then
404: p_rec.business_group_id :=
405: per_apt_shd.g_old_rec.business_group_id;
406: End If;
407: If (p_rec.name = hr_api.g_varchar2) then
408: p_rec.name :=
409: per_apt_shd.g_old_rec.name;
405: per_apt_shd.g_old_rec.business_group_id;
406: End If;
407: If (p_rec.name = hr_api.g_varchar2) then
408: p_rec.name :=
409: per_apt_shd.g_old_rec.name;
410: End If;
411: If (p_rec.description = hr_api.g_varchar2) then
412: p_rec.description :=
413: per_apt_shd.g_old_rec.description;
409: per_apt_shd.g_old_rec.name;
410: End If;
411: If (p_rec.description = hr_api.g_varchar2) then
412: p_rec.description :=
413: per_apt_shd.g_old_rec.description;
414: End If;
415: If (p_rec.instructions = hr_api.g_varchar2) then
416: p_rec.instructions :=
417: per_apt_shd.g_old_rec.instructions;
413: per_apt_shd.g_old_rec.description;
414: End If;
415: If (p_rec.instructions = hr_api.g_varchar2) then
416: p_rec.instructions :=
417: per_apt_shd.g_old_rec.instructions;
418: End If;
419: If (p_rec.date_from = hr_api.g_date) then
420: p_rec.date_from :=
421: per_apt_shd.g_old_rec.date_from;
417: per_apt_shd.g_old_rec.instructions;
418: End If;
419: If (p_rec.date_from = hr_api.g_date) then
420: p_rec.date_from :=
421: per_apt_shd.g_old_rec.date_from;
422: End If;
423: If (p_rec.date_to = hr_api.g_date) then
424: p_rec.date_to :=
425: per_apt_shd.g_old_rec.date_to;
421: per_apt_shd.g_old_rec.date_from;
422: End If;
423: If (p_rec.date_to = hr_api.g_date) then
424: p_rec.date_to :=
425: per_apt_shd.g_old_rec.date_to;
426: End If;
427: If (p_rec.assessment_type_id = hr_api.g_number) then
428: p_rec.assessment_type_id :=
429: per_apt_shd.g_old_rec.assessment_type_id;
425: per_apt_shd.g_old_rec.date_to;
426: End If;
427: If (p_rec.assessment_type_id = hr_api.g_number) then
428: p_rec.assessment_type_id :=
429: per_apt_shd.g_old_rec.assessment_type_id;
430: End If;
431: If (p_rec.rating_scale_id = hr_api.g_number) then
432: p_rec.rating_scale_id :=
433: per_apt_shd.g_old_rec.rating_scale_id;
429: per_apt_shd.g_old_rec.assessment_type_id;
430: End If;
431: If (p_rec.rating_scale_id = hr_api.g_number) then
432: p_rec.rating_scale_id :=
433: per_apt_shd.g_old_rec.rating_scale_id;
434: End If;
435: If (p_rec.questionnaire_template_id = hr_api.g_number) then
436: p_rec.questionnaire_template_id :=
437: per_apt_shd.g_old_rec.questionnaire_template_id;
433: per_apt_shd.g_old_rec.rating_scale_id;
434: End If;
435: If (p_rec.questionnaire_template_id = hr_api.g_number) then
436: p_rec.questionnaire_template_id :=
437: per_apt_shd.g_old_rec.questionnaire_template_id;
438: End If;
439: If (p_rec.attribute_category = hr_api.g_varchar2) then
440: p_rec.attribute_category :=
441: per_apt_shd.g_old_rec.attribute_category;
437: per_apt_shd.g_old_rec.questionnaire_template_id;
438: End If;
439: If (p_rec.attribute_category = hr_api.g_varchar2) then
440: p_rec.attribute_category :=
441: per_apt_shd.g_old_rec.attribute_category;
442: End If;
443: If (p_rec.attribute1 = hr_api.g_varchar2) then
444: p_rec.attribute1 :=
445: per_apt_shd.g_old_rec.attribute1;
441: per_apt_shd.g_old_rec.attribute_category;
442: End If;
443: If (p_rec.attribute1 = hr_api.g_varchar2) then
444: p_rec.attribute1 :=
445: per_apt_shd.g_old_rec.attribute1;
446: End If;
447: If (p_rec.attribute2 = hr_api.g_varchar2) then
448: p_rec.attribute2 :=
449: per_apt_shd.g_old_rec.attribute2;
445: per_apt_shd.g_old_rec.attribute1;
446: End If;
447: If (p_rec.attribute2 = hr_api.g_varchar2) then
448: p_rec.attribute2 :=
449: per_apt_shd.g_old_rec.attribute2;
450: End If;
451: If (p_rec.attribute3 = hr_api.g_varchar2) then
452: p_rec.attribute3 :=
453: per_apt_shd.g_old_rec.attribute3;
449: per_apt_shd.g_old_rec.attribute2;
450: End If;
451: If (p_rec.attribute3 = hr_api.g_varchar2) then
452: p_rec.attribute3 :=
453: per_apt_shd.g_old_rec.attribute3;
454: End If;
455: If (p_rec.attribute4 = hr_api.g_varchar2) then
456: p_rec.attribute4 :=
457: per_apt_shd.g_old_rec.attribute4;
453: per_apt_shd.g_old_rec.attribute3;
454: End If;
455: If (p_rec.attribute4 = hr_api.g_varchar2) then
456: p_rec.attribute4 :=
457: per_apt_shd.g_old_rec.attribute4;
458: End If;
459: If (p_rec.attribute5 = hr_api.g_varchar2) then
460: p_rec.attribute5 :=
461: per_apt_shd.g_old_rec.attribute5;
457: per_apt_shd.g_old_rec.attribute4;
458: End If;
459: If (p_rec.attribute5 = hr_api.g_varchar2) then
460: p_rec.attribute5 :=
461: per_apt_shd.g_old_rec.attribute5;
462: End If;
463: If (p_rec.attribute6 = hr_api.g_varchar2) then
464: p_rec.attribute6 :=
465: per_apt_shd.g_old_rec.attribute6;
461: per_apt_shd.g_old_rec.attribute5;
462: End If;
463: If (p_rec.attribute6 = hr_api.g_varchar2) then
464: p_rec.attribute6 :=
465: per_apt_shd.g_old_rec.attribute6;
466: End If;
467: If (p_rec.attribute7 = hr_api.g_varchar2) then
468: p_rec.attribute7 :=
469: per_apt_shd.g_old_rec.attribute7;
465: per_apt_shd.g_old_rec.attribute6;
466: End If;
467: If (p_rec.attribute7 = hr_api.g_varchar2) then
468: p_rec.attribute7 :=
469: per_apt_shd.g_old_rec.attribute7;
470: End If;
471: If (p_rec.attribute8 = hr_api.g_varchar2) then
472: p_rec.attribute8 :=
473: per_apt_shd.g_old_rec.attribute8;
469: per_apt_shd.g_old_rec.attribute7;
470: End If;
471: If (p_rec.attribute8 = hr_api.g_varchar2) then
472: p_rec.attribute8 :=
473: per_apt_shd.g_old_rec.attribute8;
474: End If;
475: If (p_rec.attribute9 = hr_api.g_varchar2) then
476: p_rec.attribute9 :=
477: per_apt_shd.g_old_rec.attribute9;
473: per_apt_shd.g_old_rec.attribute8;
474: End If;
475: If (p_rec.attribute9 = hr_api.g_varchar2) then
476: p_rec.attribute9 :=
477: per_apt_shd.g_old_rec.attribute9;
478: End If;
479: If (p_rec.attribute10 = hr_api.g_varchar2) then
480: p_rec.attribute10 :=
481: per_apt_shd.g_old_rec.attribute10;
477: per_apt_shd.g_old_rec.attribute9;
478: End If;
479: If (p_rec.attribute10 = hr_api.g_varchar2) then
480: p_rec.attribute10 :=
481: per_apt_shd.g_old_rec.attribute10;
482: End If;
483: If (p_rec.attribute11 = hr_api.g_varchar2) then
484: p_rec.attribute11 :=
485: per_apt_shd.g_old_rec.attribute11;
481: per_apt_shd.g_old_rec.attribute10;
482: End If;
483: If (p_rec.attribute11 = hr_api.g_varchar2) then
484: p_rec.attribute11 :=
485: per_apt_shd.g_old_rec.attribute11;
486: End If;
487: If (p_rec.attribute12 = hr_api.g_varchar2) then
488: p_rec.attribute12 :=
489: per_apt_shd.g_old_rec.attribute12;
485: per_apt_shd.g_old_rec.attribute11;
486: End If;
487: If (p_rec.attribute12 = hr_api.g_varchar2) then
488: p_rec.attribute12 :=
489: per_apt_shd.g_old_rec.attribute12;
490: End If;
491: If (p_rec.attribute13 = hr_api.g_varchar2) then
492: p_rec.attribute13 :=
493: per_apt_shd.g_old_rec.attribute13;
489: per_apt_shd.g_old_rec.attribute12;
490: End If;
491: If (p_rec.attribute13 = hr_api.g_varchar2) then
492: p_rec.attribute13 :=
493: per_apt_shd.g_old_rec.attribute13;
494: End If;
495: If (p_rec.attribute14 = hr_api.g_varchar2) then
496: p_rec.attribute14 :=
497: per_apt_shd.g_old_rec.attribute14;
493: per_apt_shd.g_old_rec.attribute13;
494: End If;
495: If (p_rec.attribute14 = hr_api.g_varchar2) then
496: p_rec.attribute14 :=
497: per_apt_shd.g_old_rec.attribute14;
498: End If;
499: If (p_rec.attribute15 = hr_api.g_varchar2) then
500: p_rec.attribute15 :=
501: per_apt_shd.g_old_rec.attribute15;
497: per_apt_shd.g_old_rec.attribute14;
498: End If;
499: If (p_rec.attribute15 = hr_api.g_varchar2) then
500: p_rec.attribute15 :=
501: per_apt_shd.g_old_rec.attribute15;
502: End If;
503: If (p_rec.attribute16 = hr_api.g_varchar2) then
504: p_rec.attribute16 :=
505: per_apt_shd.g_old_rec.attribute16;
501: per_apt_shd.g_old_rec.attribute15;
502: End If;
503: If (p_rec.attribute16 = hr_api.g_varchar2) then
504: p_rec.attribute16 :=
505: per_apt_shd.g_old_rec.attribute16;
506: End If;
507: If (p_rec.attribute17 = hr_api.g_varchar2) then
508: p_rec.attribute17 :=
509: per_apt_shd.g_old_rec.attribute17;
505: per_apt_shd.g_old_rec.attribute16;
506: End If;
507: If (p_rec.attribute17 = hr_api.g_varchar2) then
508: p_rec.attribute17 :=
509: per_apt_shd.g_old_rec.attribute17;
510: End If;
511: If (p_rec.attribute18 = hr_api.g_varchar2) then
512: p_rec.attribute18 :=
513: per_apt_shd.g_old_rec.attribute18;
509: per_apt_shd.g_old_rec.attribute17;
510: End If;
511: If (p_rec.attribute18 = hr_api.g_varchar2) then
512: p_rec.attribute18 :=
513: per_apt_shd.g_old_rec.attribute18;
514: End If;
515: If (p_rec.attribute19 = hr_api.g_varchar2) then
516: p_rec.attribute19 :=
517: per_apt_shd.g_old_rec.attribute19;
513: per_apt_shd.g_old_rec.attribute18;
514: End If;
515: If (p_rec.attribute19 = hr_api.g_varchar2) then
516: p_rec.attribute19 :=
517: per_apt_shd.g_old_rec.attribute19;
518: End If;
519: If (p_rec.attribute20 = hr_api.g_varchar2) then
520: p_rec.attribute20 :=
521: per_apt_shd.g_old_rec.attribute20;
517: per_apt_shd.g_old_rec.attribute19;
518: End If;
519: If (p_rec.attribute20 = hr_api.g_varchar2) then
520: p_rec.attribute20 :=
521: per_apt_shd.g_old_rec.attribute20;
522: End If;
523: If (p_rec.objective_asmnt_type_id = hr_api.g_number) then
524: p_rec.objective_asmnt_type_id :=
525: per_apt_shd.g_old_rec.objective_asmnt_type_id;
521: per_apt_shd.g_old_rec.attribute20;
522: End If;
523: If (p_rec.objective_asmnt_type_id = hr_api.g_number) then
524: p_rec.objective_asmnt_type_id :=
525: per_apt_shd.g_old_rec.objective_asmnt_type_id;
526: End If;
527: If (p_rec.ma_quest_template_id = hr_api.g_number) then
528: p_rec.ma_quest_template_id :=
529: per_apt_shd.g_old_rec.ma_quest_template_id;
525: per_apt_shd.g_old_rec.objective_asmnt_type_id;
526: End If;
527: If (p_rec.ma_quest_template_id = hr_api.g_number) then
528: p_rec.ma_quest_template_id :=
529: per_apt_shd.g_old_rec.ma_quest_template_id;
530: End If;
531: If (p_rec.link_appr_to_learning_path = hr_api.g_varchar2) then
532: p_rec.link_appr_to_learning_path :=
533: per_apt_shd.g_old_rec.link_appr_to_learning_path;
529: per_apt_shd.g_old_rec.ma_quest_template_id;
530: End If;
531: If (p_rec.link_appr_to_learning_path = hr_api.g_varchar2) then
532: p_rec.link_appr_to_learning_path :=
533: per_apt_shd.g_old_rec.link_appr_to_learning_path;
534: End If;
535: If (p_rec.final_score_formula_id = hr_api.g_number) then
536: p_rec.final_score_formula_id :=
537: per_apt_shd.g_old_rec.final_score_formula_id;
533: per_apt_shd.g_old_rec.link_appr_to_learning_path;
534: End If;
535: If (p_rec.final_score_formula_id = hr_api.g_number) then
536: p_rec.final_score_formula_id :=
537: per_apt_shd.g_old_rec.final_score_formula_id;
538: End If;
539: If (p_rec.update_personal_comp_profile = hr_api.g_varchar2) then
540: p_rec.update_personal_comp_profile :=
541: per_apt_shd.g_old_rec.update_personal_comp_profile;
537: per_apt_shd.g_old_rec.final_score_formula_id;
538: End If;
539: If (p_rec.update_personal_comp_profile = hr_api.g_varchar2) then
540: p_rec.update_personal_comp_profile :=
541: per_apt_shd.g_old_rec.update_personal_comp_profile;
542: End If;
543: If (p_rec.comp_profile_source_type = hr_api.g_varchar2) then
544: p_rec.comp_profile_source_type :=
545: per_apt_shd.g_old_rec.comp_profile_source_type;
541: per_apt_shd.g_old_rec.update_personal_comp_profile;
542: End If;
543: If (p_rec.comp_profile_source_type = hr_api.g_varchar2) then
544: p_rec.comp_profile_source_type :=
545: per_apt_shd.g_old_rec.comp_profile_source_type;
546: End If;
547: If (p_rec.show_competency_ratings = hr_api.g_varchar2) then
548: p_rec.show_competency_ratings :=
549: per_apt_shd.g_old_rec.show_competency_ratings;
545: per_apt_shd.g_old_rec.comp_profile_source_type;
546: End If;
547: If (p_rec.show_competency_ratings = hr_api.g_varchar2) then
548: p_rec.show_competency_ratings :=
549: per_apt_shd.g_old_rec.show_competency_ratings;
550: End If;
551: If (p_rec.show_objective_ratings = hr_api.g_varchar2) then
552: p_rec.show_objective_ratings :=
553: per_apt_shd.g_old_rec.show_objective_ratings;
549: per_apt_shd.g_old_rec.show_competency_ratings;
550: End If;
551: If (p_rec.show_objective_ratings = hr_api.g_varchar2) then
552: p_rec.show_objective_ratings :=
553: per_apt_shd.g_old_rec.show_objective_ratings;
554: End If;
555: If (p_rec.show_overall_ratings = hr_api.g_varchar2) then
556: p_rec.show_overall_ratings :=
557: per_apt_shd.g_old_rec.show_overall_ratings;
553: per_apt_shd.g_old_rec.show_objective_ratings;
554: End If;
555: If (p_rec.show_overall_ratings = hr_api.g_varchar2) then
556: p_rec.show_overall_ratings :=
557: per_apt_shd.g_old_rec.show_overall_ratings;
558: End If;
559: If (p_rec.show_overall_comments = hr_api.g_varchar2) then
560: p_rec.show_overall_comments :=
561: per_apt_shd.g_old_rec.show_overall_comments;
557: per_apt_shd.g_old_rec.show_overall_ratings;
558: End If;
559: If (p_rec.show_overall_comments = hr_api.g_varchar2) then
560: p_rec.show_overall_comments :=
561: per_apt_shd.g_old_rec.show_overall_comments;
562: End If;
563: If (p_rec.provide_overall_feedback = hr_api.g_varchar2) then
564: p_rec.provide_overall_feedback :=
565: per_apt_shd.g_old_rec.provide_overall_feedback;
561: per_apt_shd.g_old_rec.show_overall_comments;
562: End If;
563: If (p_rec.provide_overall_feedback = hr_api.g_varchar2) then
564: p_rec.provide_overall_feedback :=
565: per_apt_shd.g_old_rec.provide_overall_feedback;
566: End If;
567: If (p_rec.show_participant_details = hr_api.g_varchar2) then
568: p_rec.show_participant_details :=
569: per_apt_shd.g_old_rec.show_participant_details;
565: per_apt_shd.g_old_rec.provide_overall_feedback;
566: End If;
567: If (p_rec.show_participant_details = hr_api.g_varchar2) then
568: p_rec.show_participant_details :=
569: per_apt_shd.g_old_rec.show_participant_details;
570: End If;
571: If (p_rec.allow_add_participant = hr_api.g_varchar2) then
572: p_rec.allow_add_participant :=
573: per_apt_shd.g_old_rec.allow_add_participant;
569: per_apt_shd.g_old_rec.show_participant_details;
570: End If;
571: If (p_rec.allow_add_participant = hr_api.g_varchar2) then
572: p_rec.allow_add_participant :=
573: per_apt_shd.g_old_rec.allow_add_participant;
574: End If;
575: If (p_rec.show_additional_details = hr_api.g_varchar2) then
576: p_rec.show_additional_details :=
577: per_apt_shd.g_old_rec.show_additional_details;
573: per_apt_shd.g_old_rec.allow_add_participant;
574: End If;
575: If (p_rec.show_additional_details = hr_api.g_varchar2) then
576: p_rec.show_additional_details :=
577: per_apt_shd.g_old_rec.show_additional_details;
578: End If;
579: If (p_rec.show_participant_names = hr_api.g_varchar2) then
580: p_rec.show_participant_names :=
581: per_apt_shd.g_old_rec.show_participant_names;
577: per_apt_shd.g_old_rec.show_additional_details;
578: End If;
579: If (p_rec.show_participant_names = hr_api.g_varchar2) then
580: p_rec.show_participant_names :=
581: per_apt_shd.g_old_rec.show_participant_names;
582: End If;
583: If (p_rec.show_participant_ratings = hr_api.g_varchar2) then
584: p_rec.show_participant_ratings :=
585: per_apt_shd.g_old_rec.show_participant_ratings;
581: per_apt_shd.g_old_rec.show_participant_names;
582: End If;
583: If (p_rec.show_participant_ratings = hr_api.g_varchar2) then
584: p_rec.show_participant_ratings :=
585: per_apt_shd.g_old_rec.show_participant_ratings;
586: End If;
587: If (p_rec.available_flag = hr_api.g_varchar2) then
588: p_rec.available_flag :=
589: per_apt_shd.g_old_rec.available_flag;
585: per_apt_shd.g_old_rec.show_participant_ratings;
586: End If;
587: If (p_rec.available_flag = hr_api.g_varchar2) then
588: p_rec.available_flag :=
589: per_apt_shd.g_old_rec.available_flag;
590: End If;
591: If (p_rec.show_questionnaire_info = hr_api.g_varchar2) then
592: p_rec.show_questionnaire_info :=
593: per_apt_shd.g_old_rec.show_questionnaire_info;
589: per_apt_shd.g_old_rec.available_flag;
590: End If;
591: If (p_rec.show_questionnaire_info = hr_api.g_varchar2) then
592: p_rec.show_questionnaire_info :=
593: per_apt_shd.g_old_rec.show_questionnaire_info;
594: End If;
595: If (p_rec.ma_off_template_code =hr_api.g_varchar2) then
596: p_rec.ma_off_template_code :=
597: per_apt_shd.g_old_rec.ma_off_template_code;
593: per_apt_shd.g_old_rec.show_questionnaire_info;
594: End If;
595: If (p_rec.ma_off_template_code =hr_api.g_varchar2) then
596: p_rec.ma_off_template_code :=
597: per_apt_shd.g_old_rec.ma_off_template_code;
598: End If;
599: If (p_rec.appraisee_off_template_code =hr_api.g_varchar2) then
600: p_rec.appraisee_off_template_code :=
601: per_apt_shd.g_old_rec.appraisee_off_template_code;
597: per_apt_shd.g_old_rec.ma_off_template_code;
598: End If;
599: If (p_rec.appraisee_off_template_code =hr_api.g_varchar2) then
600: p_rec.appraisee_off_template_code :=
601: per_apt_shd.g_old_rec.appraisee_off_template_code;
602: End If;
603: If (p_rec.other_part_off_template_code =hr_api.g_varchar2) then
604: p_rec.other_part_off_template_code :=
605: per_apt_shd.g_old_rec.other_part_off_template_code;
601: per_apt_shd.g_old_rec.appraisee_off_template_code;
602: End If;
603: If (p_rec.other_part_off_template_code =hr_api.g_varchar2) then
604: p_rec.other_part_off_template_code :=
605: per_apt_shd.g_old_rec.other_part_off_template_code;
606: End If;
607: If (p_rec.part_rev_off_template_code =hr_api.g_varchar2) then
608: p_rec.part_rev_off_template_code :=
609: per_apt_shd.g_old_rec.part_rev_off_template_code;
605: per_apt_shd.g_old_rec.other_part_off_template_code;
606: End If;
607: If (p_rec.part_rev_off_template_code =hr_api.g_varchar2) then
608: p_rec.part_rev_off_template_code :=
609: per_apt_shd.g_old_rec.part_rev_off_template_code;
610: End If;
611: If (p_rec.part_app_off_template_code =hr_api.g_varchar2) then
612: p_rec.part_app_off_template_code :=
613: per_apt_shd.g_old_rec.part_app_off_template_code ;
609: per_apt_shd.g_old_rec.part_rev_off_template_code;
610: End If;
611: If (p_rec.part_app_off_template_code =hr_api.g_varchar2) then
612: p_rec.part_app_off_template_code :=
613: per_apt_shd.g_old_rec.part_app_off_template_code ;
614: End If;
615:
616: hr_utility.set_location(' Leaving:'||l_proc, 10);
617:
621: -- |---------------------------------< upd >----------------------------------|
622: -- ---------------------------------------------------------------------------+
623: Procedure upd
624: (
625: p_rec in out nocopy per_apt_shd.g_rec_type,
626: p_effective_date in date,
627: p_validate in boolean default false
628: ) is
629:
642: End If;
643:
644: -- We must lock the row which we need to update.
645:
646: per_apt_shd.lck
647: (
648: p_rec.appraisal_template_id,
649: p_rec.object_version_number
650: );
748: ,p_part_rev_off_template_code in varchar2 default hr_api.g_varchar2,
749: p_validate in boolean default false
750: ) is
751:
752: l_rec per_apt_shd.g_rec_type;
753: l_proc varchar2(72) := g_package||'upd';
754:
755: Begin
756: hr_utility.set_location('Entering:'||l_proc, 5);
758: -- Call conversion function to turn arguments into the
759: -- l_rec structure.
760:
761: l_rec :=
762: per_apt_shd.convert_args
763: (
764: p_appraisal_template_id,
765: hr_api.g_number,
766: p_object_version_number,