[Home] [Help]
50: -- Internal Table Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy per_cel_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin
61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
64: --
65: per_cel_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the per_competence_elements Row
68: --
69: -- bug fix 3991608
143: achieved_date = p_rec.achieved_date,
144: appr_line_score = p_rec.appr_line_score
145: where competence_element_id = p_rec.competence_element_id;
146: --
147: per_cel_shd.g_api_dml := false; -- Unset the api dml status
148: --
149: hr_utility.set_location(' Leaving:'||l_proc, 10);
150: --
151: Exception
150: --
151: Exception
152: When hr_api.check_integrity_violated Then
153: -- A check constraint has been violated
154: per_cel_shd.g_api_dml := false; -- Unset the api dml status
155: per_cel_shd.constraint_error
156: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
157: When hr_api.parent_integrity_violated Then
158: -- Parent integrity has been violated
151: Exception
152: When hr_api.check_integrity_violated Then
153: -- A check constraint has been violated
154: per_cel_shd.g_api_dml := false; -- Unset the api dml status
155: per_cel_shd.constraint_error
156: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
157: When hr_api.parent_integrity_violated Then
158: -- Parent integrity has been violated
159: per_cel_shd.g_api_dml := false; -- Unset the api dml status
155: per_cel_shd.constraint_error
156: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
157: When hr_api.parent_integrity_violated Then
158: -- Parent integrity has been violated
159: per_cel_shd.g_api_dml := false; -- Unset the api dml status
160: per_cel_shd.constraint_error
161: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
162: When hr_api.unique_integrity_violated Then
163: -- Unique integrity has been violated
156: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
157: When hr_api.parent_integrity_violated Then
158: -- Parent integrity has been violated
159: per_cel_shd.g_api_dml := false; -- Unset the api dml status
160: per_cel_shd.constraint_error
161: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
162: When hr_api.unique_integrity_violated Then
163: -- Unique integrity has been violated
164: per_cel_shd.g_api_dml := false; -- Unset the api dml status
160: per_cel_shd.constraint_error
161: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
162: When hr_api.unique_integrity_violated Then
163: -- Unique integrity has been violated
164: per_cel_shd.g_api_dml := false; -- Unset the api dml status
165: per_cel_shd.constraint_error
166: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
167: When Others Then
168: per_cel_shd.g_api_dml := false; -- Unset the api dml status
161: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
162: When hr_api.unique_integrity_violated Then
163: -- Unique integrity has been violated
164: per_cel_shd.g_api_dml := false; -- Unset the api dml status
165: per_cel_shd.constraint_error
166: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
167: When Others Then
168: per_cel_shd.g_api_dml := false; -- Unset the api dml status
169: Raise;
164: per_cel_shd.g_api_dml := false; -- Unset the api dml status
165: per_cel_shd.constraint_error
166: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
167: When Others Then
168: per_cel_shd.g_api_dml := false; -- Unset the api dml status
169: Raise;
170: End update_dml;
171: --
172: -- ----------------------------------------------------------------------------
200: -- Internal Table Handler Use Only.
201: --
202: -- {End Of Comments}
203: -- ----------------------------------------------------------------------------
204: Procedure pre_update(p_rec in per_cel_shd.g_rec_type) is
205: --
206: l_proc varchar2(72) := g_package||'pre_update';
207: --
208: Begin
242: -- Internal Table Handler Use Only.
243: --
244: -- {End Of Comments}
245: -- ----------------------------------------------------------------------------
246: Procedure post_update(p_rec in per_cel_shd.g_rec_type) is
247: --
248: l_proc varchar2(72) := g_package||'post_update';
249: --
250: Begin
340: p_information19 => p_rec.information19 ,
341: p_information20 => p_rec.information20 ,
342: p_achieved_date => p_rec.achieved_date ,
343: p_appr_line_score => p_rec.appr_line_score,
344: p_business_group_id_o => per_cel_shd.g_old_rec.business_group_id ,
345: p_object_version_number_o => per_cel_shd.g_old_rec.object_version_number,
346: p_type_o => per_cel_shd.g_old_rec.type ,
347: p_competence_id_o => per_cel_shd.g_old_rec.competence_id ,
348: -- p_member_competence_set_id_o =>
341: p_information20 => p_rec.information20 ,
342: p_achieved_date => p_rec.achieved_date ,
343: p_appr_line_score => p_rec.appr_line_score,
344: p_business_group_id_o => per_cel_shd.g_old_rec.business_group_id ,
345: p_object_version_number_o => per_cel_shd.g_old_rec.object_version_number,
346: p_type_o => per_cel_shd.g_old_rec.type ,
347: p_competence_id_o => per_cel_shd.g_old_rec.competence_id ,
348: -- p_member_competence_set_id_o =>
349: -- per_cel_shd.g_old_rec.member_competence_set_id ,
342: p_achieved_date => p_rec.achieved_date ,
343: p_appr_line_score => p_rec.appr_line_score,
344: p_business_group_id_o => per_cel_shd.g_old_rec.business_group_id ,
345: p_object_version_number_o => per_cel_shd.g_old_rec.object_version_number,
346: p_type_o => per_cel_shd.g_old_rec.type ,
347: p_competence_id_o => per_cel_shd.g_old_rec.competence_id ,
348: -- p_member_competence_set_id_o =>
349: -- per_cel_shd.g_old_rec.member_competence_set_id ,
350: p_proficiency_level_id_o => per_cel_shd.g_old_rec.proficiency_level_id ,
343: p_appr_line_score => p_rec.appr_line_score,
344: p_business_group_id_o => per_cel_shd.g_old_rec.business_group_id ,
345: p_object_version_number_o => per_cel_shd.g_old_rec.object_version_number,
346: p_type_o => per_cel_shd.g_old_rec.type ,
347: p_competence_id_o => per_cel_shd.g_old_rec.competence_id ,
348: -- p_member_competence_set_id_o =>
349: -- per_cel_shd.g_old_rec.member_competence_set_id ,
350: p_proficiency_level_id_o => per_cel_shd.g_old_rec.proficiency_level_id ,
351: p_high_proficiency_level_id_o =>
345: p_object_version_number_o => per_cel_shd.g_old_rec.object_version_number,
346: p_type_o => per_cel_shd.g_old_rec.type ,
347: p_competence_id_o => per_cel_shd.g_old_rec.competence_id ,
348: -- p_member_competence_set_id_o =>
349: -- per_cel_shd.g_old_rec.member_competence_set_id ,
350: p_proficiency_level_id_o => per_cel_shd.g_old_rec.proficiency_level_id ,
351: p_high_proficiency_level_id_o =>
352: per_cel_shd.g_old_rec.high_proficiency_level_id ,
353: p_weighting_level_id_o => per_cel_shd.g_old_rec.weighting_level_id ,
346: p_type_o => per_cel_shd.g_old_rec.type ,
347: p_competence_id_o => per_cel_shd.g_old_rec.competence_id ,
348: -- p_member_competence_set_id_o =>
349: -- per_cel_shd.g_old_rec.member_competence_set_id ,
350: p_proficiency_level_id_o => per_cel_shd.g_old_rec.proficiency_level_id ,
351: p_high_proficiency_level_id_o =>
352: per_cel_shd.g_old_rec.high_proficiency_level_id ,
353: p_weighting_level_id_o => per_cel_shd.g_old_rec.weighting_level_id ,
354: p_rating_level_id_o => per_cel_shd.g_old_rec.rating_level_id ,
348: -- p_member_competence_set_id_o =>
349: -- per_cel_shd.g_old_rec.member_competence_set_id ,
350: p_proficiency_level_id_o => per_cel_shd.g_old_rec.proficiency_level_id ,
351: p_high_proficiency_level_id_o =>
352: per_cel_shd.g_old_rec.high_proficiency_level_id ,
353: p_weighting_level_id_o => per_cel_shd.g_old_rec.weighting_level_id ,
354: p_rating_level_id_o => per_cel_shd.g_old_rec.rating_level_id ,
355: p_person_id_o => per_cel_shd.g_old_rec.person_id ,
356: p_enterprise_id_o => per_cel_shd.g_old_rec.enterprise_id ,
349: -- per_cel_shd.g_old_rec.member_competence_set_id ,
350: p_proficiency_level_id_o => per_cel_shd.g_old_rec.proficiency_level_id ,
351: p_high_proficiency_level_id_o =>
352: per_cel_shd.g_old_rec.high_proficiency_level_id ,
353: p_weighting_level_id_o => per_cel_shd.g_old_rec.weighting_level_id ,
354: p_rating_level_id_o => per_cel_shd.g_old_rec.rating_level_id ,
355: p_person_id_o => per_cel_shd.g_old_rec.person_id ,
356: p_enterprise_id_o => per_cel_shd.g_old_rec.enterprise_id ,
357: p_job_id_o => per_cel_shd.g_old_rec.job_id ,
350: p_proficiency_level_id_o => per_cel_shd.g_old_rec.proficiency_level_id ,
351: p_high_proficiency_level_id_o =>
352: per_cel_shd.g_old_rec.high_proficiency_level_id ,
353: p_weighting_level_id_o => per_cel_shd.g_old_rec.weighting_level_id ,
354: p_rating_level_id_o => per_cel_shd.g_old_rec.rating_level_id ,
355: p_person_id_o => per_cel_shd.g_old_rec.person_id ,
356: p_enterprise_id_o => per_cel_shd.g_old_rec.enterprise_id ,
357: p_job_id_o => per_cel_shd.g_old_rec.job_id ,
358: p_valid_grade_id_o => per_cel_shd.g_old_rec.valid_grade_id ,
351: p_high_proficiency_level_id_o =>
352: per_cel_shd.g_old_rec.high_proficiency_level_id ,
353: p_weighting_level_id_o => per_cel_shd.g_old_rec.weighting_level_id ,
354: p_rating_level_id_o => per_cel_shd.g_old_rec.rating_level_id ,
355: p_person_id_o => per_cel_shd.g_old_rec.person_id ,
356: p_enterprise_id_o => per_cel_shd.g_old_rec.enterprise_id ,
357: p_job_id_o => per_cel_shd.g_old_rec.job_id ,
358: p_valid_grade_id_o => per_cel_shd.g_old_rec.valid_grade_id ,
359: p_position_id_o => per_cel_shd.g_old_rec.position_id ,
352: per_cel_shd.g_old_rec.high_proficiency_level_id ,
353: p_weighting_level_id_o => per_cel_shd.g_old_rec.weighting_level_id ,
354: p_rating_level_id_o => per_cel_shd.g_old_rec.rating_level_id ,
355: p_person_id_o => per_cel_shd.g_old_rec.person_id ,
356: p_enterprise_id_o => per_cel_shd.g_old_rec.enterprise_id ,
357: p_job_id_o => per_cel_shd.g_old_rec.job_id ,
358: p_valid_grade_id_o => per_cel_shd.g_old_rec.valid_grade_id ,
359: p_position_id_o => per_cel_shd.g_old_rec.position_id ,
360: p_organization_id_o => per_cel_shd.g_old_rec.organization_id ,
353: p_weighting_level_id_o => per_cel_shd.g_old_rec.weighting_level_id ,
354: p_rating_level_id_o => per_cel_shd.g_old_rec.rating_level_id ,
355: p_person_id_o => per_cel_shd.g_old_rec.person_id ,
356: p_enterprise_id_o => per_cel_shd.g_old_rec.enterprise_id ,
357: p_job_id_o => per_cel_shd.g_old_rec.job_id ,
358: p_valid_grade_id_o => per_cel_shd.g_old_rec.valid_grade_id ,
359: p_position_id_o => per_cel_shd.g_old_rec.position_id ,
360: p_organization_id_o => per_cel_shd.g_old_rec.organization_id ,
361: -- p_work_item_id_o => per_cel_shd.g_old_rec.work_item_id ,
354: p_rating_level_id_o => per_cel_shd.g_old_rec.rating_level_id ,
355: p_person_id_o => per_cel_shd.g_old_rec.person_id ,
356: p_enterprise_id_o => per_cel_shd.g_old_rec.enterprise_id ,
357: p_job_id_o => per_cel_shd.g_old_rec.job_id ,
358: p_valid_grade_id_o => per_cel_shd.g_old_rec.valid_grade_id ,
359: p_position_id_o => per_cel_shd.g_old_rec.position_id ,
360: p_organization_id_o => per_cel_shd.g_old_rec.organization_id ,
361: -- p_work_item_id_o => per_cel_shd.g_old_rec.work_item_id ,
362: -- p_competence_set_id_o => per_cel_shd.g_old_rec.competence_set_id ,
355: p_person_id_o => per_cel_shd.g_old_rec.person_id ,
356: p_enterprise_id_o => per_cel_shd.g_old_rec.enterprise_id ,
357: p_job_id_o => per_cel_shd.g_old_rec.job_id ,
358: p_valid_grade_id_o => per_cel_shd.g_old_rec.valid_grade_id ,
359: p_position_id_o => per_cel_shd.g_old_rec.position_id ,
360: p_organization_id_o => per_cel_shd.g_old_rec.organization_id ,
361: -- p_work_item_id_o => per_cel_shd.g_old_rec.work_item_id ,
362: -- p_competence_set_id_o => per_cel_shd.g_old_rec.competence_set_id ,
363: p_parent_competence_element_o =>
356: p_enterprise_id_o => per_cel_shd.g_old_rec.enterprise_id ,
357: p_job_id_o => per_cel_shd.g_old_rec.job_id ,
358: p_valid_grade_id_o => per_cel_shd.g_old_rec.valid_grade_id ,
359: p_position_id_o => per_cel_shd.g_old_rec.position_id ,
360: p_organization_id_o => per_cel_shd.g_old_rec.organization_id ,
361: -- p_work_item_id_o => per_cel_shd.g_old_rec.work_item_id ,
362: -- p_competence_set_id_o => per_cel_shd.g_old_rec.competence_set_id ,
363: p_parent_competence_element_o =>
364: per_cel_shd.g_old_rec.parent_competence_element_id ,
357: p_job_id_o => per_cel_shd.g_old_rec.job_id ,
358: p_valid_grade_id_o => per_cel_shd.g_old_rec.valid_grade_id ,
359: p_position_id_o => per_cel_shd.g_old_rec.position_id ,
360: p_organization_id_o => per_cel_shd.g_old_rec.organization_id ,
361: -- p_work_item_id_o => per_cel_shd.g_old_rec.work_item_id ,
362: -- p_competence_set_id_o => per_cel_shd.g_old_rec.competence_set_id ,
363: p_parent_competence_element_o =>
364: per_cel_shd.g_old_rec.parent_competence_element_id ,
365: p_activity_version_id_o => per_cel_shd.g_old_rec.activity_version_id ,
358: p_valid_grade_id_o => per_cel_shd.g_old_rec.valid_grade_id ,
359: p_position_id_o => per_cel_shd.g_old_rec.position_id ,
360: p_organization_id_o => per_cel_shd.g_old_rec.organization_id ,
361: -- p_work_item_id_o => per_cel_shd.g_old_rec.work_item_id ,
362: -- p_competence_set_id_o => per_cel_shd.g_old_rec.competence_set_id ,
363: p_parent_competence_element_o =>
364: per_cel_shd.g_old_rec.parent_competence_element_id ,
365: p_activity_version_id_o => per_cel_shd.g_old_rec.activity_version_id ,
366: p_assessment_id_o => per_cel_shd.g_old_rec.assessment_id ,
360: p_organization_id_o => per_cel_shd.g_old_rec.organization_id ,
361: -- p_work_item_id_o => per_cel_shd.g_old_rec.work_item_id ,
362: -- p_competence_set_id_o => per_cel_shd.g_old_rec.competence_set_id ,
363: p_parent_competence_element_o =>
364: per_cel_shd.g_old_rec.parent_competence_element_id ,
365: p_activity_version_id_o => per_cel_shd.g_old_rec.activity_version_id ,
366: p_assessment_id_o => per_cel_shd.g_old_rec.assessment_id ,
367: p_assessment_type_id_o => per_cel_shd.g_old_rec.assessment_type_id ,
368: p_mandatory_o => per_cel_shd.g_old_rec.mandatory ,
361: -- p_work_item_id_o => per_cel_shd.g_old_rec.work_item_id ,
362: -- p_competence_set_id_o => per_cel_shd.g_old_rec.competence_set_id ,
363: p_parent_competence_element_o =>
364: per_cel_shd.g_old_rec.parent_competence_element_id ,
365: p_activity_version_id_o => per_cel_shd.g_old_rec.activity_version_id ,
366: p_assessment_id_o => per_cel_shd.g_old_rec.assessment_id ,
367: p_assessment_type_id_o => per_cel_shd.g_old_rec.assessment_type_id ,
368: p_mandatory_o => per_cel_shd.g_old_rec.mandatory ,
369: p_effective_date_from_o => per_cel_shd.g_old_rec.effective_date_from ,
362: -- p_competence_set_id_o => per_cel_shd.g_old_rec.competence_set_id ,
363: p_parent_competence_element_o =>
364: per_cel_shd.g_old_rec.parent_competence_element_id ,
365: p_activity_version_id_o => per_cel_shd.g_old_rec.activity_version_id ,
366: p_assessment_id_o => per_cel_shd.g_old_rec.assessment_id ,
367: p_assessment_type_id_o => per_cel_shd.g_old_rec.assessment_type_id ,
368: p_mandatory_o => per_cel_shd.g_old_rec.mandatory ,
369: p_effective_date_from_o => per_cel_shd.g_old_rec.effective_date_from ,
370: p_effective_date_to_o => per_cel_shd.g_old_rec.effective_date_to ,
363: p_parent_competence_element_o =>
364: per_cel_shd.g_old_rec.parent_competence_element_id ,
365: p_activity_version_id_o => per_cel_shd.g_old_rec.activity_version_id ,
366: p_assessment_id_o => per_cel_shd.g_old_rec.assessment_id ,
367: p_assessment_type_id_o => per_cel_shd.g_old_rec.assessment_type_id ,
368: p_mandatory_o => per_cel_shd.g_old_rec.mandatory ,
369: p_effective_date_from_o => per_cel_shd.g_old_rec.effective_date_from ,
370: p_effective_date_to_o => per_cel_shd.g_old_rec.effective_date_to ,
371: p_group_competence_type_o => per_cel_shd.g_old_rec.group_competence_type,
364: per_cel_shd.g_old_rec.parent_competence_element_id ,
365: p_activity_version_id_o => per_cel_shd.g_old_rec.activity_version_id ,
366: p_assessment_id_o => per_cel_shd.g_old_rec.assessment_id ,
367: p_assessment_type_id_o => per_cel_shd.g_old_rec.assessment_type_id ,
368: p_mandatory_o => per_cel_shd.g_old_rec.mandatory ,
369: p_effective_date_from_o => per_cel_shd.g_old_rec.effective_date_from ,
370: p_effective_date_to_o => per_cel_shd.g_old_rec.effective_date_to ,
371: p_group_competence_type_o => per_cel_shd.g_old_rec.group_competence_type,
372: p_competence_type_o => per_cel_shd.g_old_rec.competence_type ,
365: p_activity_version_id_o => per_cel_shd.g_old_rec.activity_version_id ,
366: p_assessment_id_o => per_cel_shd.g_old_rec.assessment_id ,
367: p_assessment_type_id_o => per_cel_shd.g_old_rec.assessment_type_id ,
368: p_mandatory_o => per_cel_shd.g_old_rec.mandatory ,
369: p_effective_date_from_o => per_cel_shd.g_old_rec.effective_date_from ,
370: p_effective_date_to_o => per_cel_shd.g_old_rec.effective_date_to ,
371: p_group_competence_type_o => per_cel_shd.g_old_rec.group_competence_type,
372: p_competence_type_o => per_cel_shd.g_old_rec.competence_type ,
373: p_sequence_number_o => per_cel_shd.g_old_rec.sequence_number ,
366: p_assessment_id_o => per_cel_shd.g_old_rec.assessment_id ,
367: p_assessment_type_id_o => per_cel_shd.g_old_rec.assessment_type_id ,
368: p_mandatory_o => per_cel_shd.g_old_rec.mandatory ,
369: p_effective_date_from_o => per_cel_shd.g_old_rec.effective_date_from ,
370: p_effective_date_to_o => per_cel_shd.g_old_rec.effective_date_to ,
371: p_group_competence_type_o => per_cel_shd.g_old_rec.group_competence_type,
372: p_competence_type_o => per_cel_shd.g_old_rec.competence_type ,
373: p_sequence_number_o => per_cel_shd.g_old_rec.sequence_number ,
374: p_normal_elapse_duration_o =>
367: p_assessment_type_id_o => per_cel_shd.g_old_rec.assessment_type_id ,
368: p_mandatory_o => per_cel_shd.g_old_rec.mandatory ,
369: p_effective_date_from_o => per_cel_shd.g_old_rec.effective_date_from ,
370: p_effective_date_to_o => per_cel_shd.g_old_rec.effective_date_to ,
371: p_group_competence_type_o => per_cel_shd.g_old_rec.group_competence_type,
372: p_competence_type_o => per_cel_shd.g_old_rec.competence_type ,
373: p_sequence_number_o => per_cel_shd.g_old_rec.sequence_number ,
374: p_normal_elapse_duration_o =>
375: per_cel_shd.g_old_rec.normal_elapse_duration ,
368: p_mandatory_o => per_cel_shd.g_old_rec.mandatory ,
369: p_effective_date_from_o => per_cel_shd.g_old_rec.effective_date_from ,
370: p_effective_date_to_o => per_cel_shd.g_old_rec.effective_date_to ,
371: p_group_competence_type_o => per_cel_shd.g_old_rec.group_competence_type,
372: p_competence_type_o => per_cel_shd.g_old_rec.competence_type ,
373: p_sequence_number_o => per_cel_shd.g_old_rec.sequence_number ,
374: p_normal_elapse_duration_o =>
375: per_cel_shd.g_old_rec.normal_elapse_duration ,
376: p_normal_elapse_duration_uni_o =>
369: p_effective_date_from_o => per_cel_shd.g_old_rec.effective_date_from ,
370: p_effective_date_to_o => per_cel_shd.g_old_rec.effective_date_to ,
371: p_group_competence_type_o => per_cel_shd.g_old_rec.group_competence_type,
372: p_competence_type_o => per_cel_shd.g_old_rec.competence_type ,
373: p_sequence_number_o => per_cel_shd.g_old_rec.sequence_number ,
374: p_normal_elapse_duration_o =>
375: per_cel_shd.g_old_rec.normal_elapse_duration ,
376: p_normal_elapse_duration_uni_o =>
377: per_cel_shd.g_old_rec.normal_elapse_duration_unit ,
371: p_group_competence_type_o => per_cel_shd.g_old_rec.group_competence_type,
372: p_competence_type_o => per_cel_shd.g_old_rec.competence_type ,
373: p_sequence_number_o => per_cel_shd.g_old_rec.sequence_number ,
374: p_normal_elapse_duration_o =>
375: per_cel_shd.g_old_rec.normal_elapse_duration ,
376: p_normal_elapse_duration_uni_o =>
377: per_cel_shd.g_old_rec.normal_elapse_duration_unit ,
378: p_source_of_proficiency_leve_o =>
379: per_cel_shd.g_old_rec.source_of_proficiency_level ,
373: p_sequence_number_o => per_cel_shd.g_old_rec.sequence_number ,
374: p_normal_elapse_duration_o =>
375: per_cel_shd.g_old_rec.normal_elapse_duration ,
376: p_normal_elapse_duration_uni_o =>
377: per_cel_shd.g_old_rec.normal_elapse_duration_unit ,
378: p_source_of_proficiency_leve_o =>
379: per_cel_shd.g_old_rec.source_of_proficiency_level ,
380: p_line_score_o => per_cel_shd.g_old_rec.line_score ,
381: p_certification_date_o => per_cel_shd.g_old_rec.certification_date ,
375: per_cel_shd.g_old_rec.normal_elapse_duration ,
376: p_normal_elapse_duration_uni_o =>
377: per_cel_shd.g_old_rec.normal_elapse_duration_unit ,
378: p_source_of_proficiency_leve_o =>
379: per_cel_shd.g_old_rec.source_of_proficiency_level ,
380: p_line_score_o => per_cel_shd.g_old_rec.line_score ,
381: p_certification_date_o => per_cel_shd.g_old_rec.certification_date ,
382: p_certification_method_o => per_cel_shd.g_old_rec.certification_method ,
383: p_next_certification_date_o =>
376: p_normal_elapse_duration_uni_o =>
377: per_cel_shd.g_old_rec.normal_elapse_duration_unit ,
378: p_source_of_proficiency_leve_o =>
379: per_cel_shd.g_old_rec.source_of_proficiency_level ,
380: p_line_score_o => per_cel_shd.g_old_rec.line_score ,
381: p_certification_date_o => per_cel_shd.g_old_rec.certification_date ,
382: p_certification_method_o => per_cel_shd.g_old_rec.certification_method ,
383: p_next_certification_date_o =>
384: per_cel_shd.g_old_rec.next_certification_date ,
377: per_cel_shd.g_old_rec.normal_elapse_duration_unit ,
378: p_source_of_proficiency_leve_o =>
379: per_cel_shd.g_old_rec.source_of_proficiency_level ,
380: p_line_score_o => per_cel_shd.g_old_rec.line_score ,
381: p_certification_date_o => per_cel_shd.g_old_rec.certification_date ,
382: p_certification_method_o => per_cel_shd.g_old_rec.certification_method ,
383: p_next_certification_date_o =>
384: per_cel_shd.g_old_rec.next_certification_date ,
385: p_comments_o => per_cel_shd.g_old_rec.comments ,
378: p_source_of_proficiency_leve_o =>
379: per_cel_shd.g_old_rec.source_of_proficiency_level ,
380: p_line_score_o => per_cel_shd.g_old_rec.line_score ,
381: p_certification_date_o => per_cel_shd.g_old_rec.certification_date ,
382: p_certification_method_o => per_cel_shd.g_old_rec.certification_method ,
383: p_next_certification_date_o =>
384: per_cel_shd.g_old_rec.next_certification_date ,
385: p_comments_o => per_cel_shd.g_old_rec.comments ,
386: p_attribute_category_o => per_cel_shd.g_old_rec.attribute_category ,
380: p_line_score_o => per_cel_shd.g_old_rec.line_score ,
381: p_certification_date_o => per_cel_shd.g_old_rec.certification_date ,
382: p_certification_method_o => per_cel_shd.g_old_rec.certification_method ,
383: p_next_certification_date_o =>
384: per_cel_shd.g_old_rec.next_certification_date ,
385: p_comments_o => per_cel_shd.g_old_rec.comments ,
386: p_attribute_category_o => per_cel_shd.g_old_rec.attribute_category ,
387: p_attribute1_o => per_cel_shd.g_old_rec.attribute1 ,
388: p_attribute2_o => per_cel_shd.g_old_rec.attribute2 ,
381: p_certification_date_o => per_cel_shd.g_old_rec.certification_date ,
382: p_certification_method_o => per_cel_shd.g_old_rec.certification_method ,
383: p_next_certification_date_o =>
384: per_cel_shd.g_old_rec.next_certification_date ,
385: p_comments_o => per_cel_shd.g_old_rec.comments ,
386: p_attribute_category_o => per_cel_shd.g_old_rec.attribute_category ,
387: p_attribute1_o => per_cel_shd.g_old_rec.attribute1 ,
388: p_attribute2_o => per_cel_shd.g_old_rec.attribute2 ,
389: p_attribute3_o => per_cel_shd.g_old_rec.attribute3 ,
382: p_certification_method_o => per_cel_shd.g_old_rec.certification_method ,
383: p_next_certification_date_o =>
384: per_cel_shd.g_old_rec.next_certification_date ,
385: p_comments_o => per_cel_shd.g_old_rec.comments ,
386: p_attribute_category_o => per_cel_shd.g_old_rec.attribute_category ,
387: p_attribute1_o => per_cel_shd.g_old_rec.attribute1 ,
388: p_attribute2_o => per_cel_shd.g_old_rec.attribute2 ,
389: p_attribute3_o => per_cel_shd.g_old_rec.attribute3 ,
390: p_attribute4_o => per_cel_shd.g_old_rec.attribute4 ,
383: p_next_certification_date_o =>
384: per_cel_shd.g_old_rec.next_certification_date ,
385: p_comments_o => per_cel_shd.g_old_rec.comments ,
386: p_attribute_category_o => per_cel_shd.g_old_rec.attribute_category ,
387: p_attribute1_o => per_cel_shd.g_old_rec.attribute1 ,
388: p_attribute2_o => per_cel_shd.g_old_rec.attribute2 ,
389: p_attribute3_o => per_cel_shd.g_old_rec.attribute3 ,
390: p_attribute4_o => per_cel_shd.g_old_rec.attribute4 ,
391: p_attribute5_o => per_cel_shd.g_old_rec.attribute5 ,
384: per_cel_shd.g_old_rec.next_certification_date ,
385: p_comments_o => per_cel_shd.g_old_rec.comments ,
386: p_attribute_category_o => per_cel_shd.g_old_rec.attribute_category ,
387: p_attribute1_o => per_cel_shd.g_old_rec.attribute1 ,
388: p_attribute2_o => per_cel_shd.g_old_rec.attribute2 ,
389: p_attribute3_o => per_cel_shd.g_old_rec.attribute3 ,
390: p_attribute4_o => per_cel_shd.g_old_rec.attribute4 ,
391: p_attribute5_o => per_cel_shd.g_old_rec.attribute5 ,
392: p_attribute6_o => per_cel_shd.g_old_rec.attribute6 ,
385: p_comments_o => per_cel_shd.g_old_rec.comments ,
386: p_attribute_category_o => per_cel_shd.g_old_rec.attribute_category ,
387: p_attribute1_o => per_cel_shd.g_old_rec.attribute1 ,
388: p_attribute2_o => per_cel_shd.g_old_rec.attribute2 ,
389: p_attribute3_o => per_cel_shd.g_old_rec.attribute3 ,
390: p_attribute4_o => per_cel_shd.g_old_rec.attribute4 ,
391: p_attribute5_o => per_cel_shd.g_old_rec.attribute5 ,
392: p_attribute6_o => per_cel_shd.g_old_rec.attribute6 ,
393: p_attribute7_o => per_cel_shd.g_old_rec.attribute7 ,
386: p_attribute_category_o => per_cel_shd.g_old_rec.attribute_category ,
387: p_attribute1_o => per_cel_shd.g_old_rec.attribute1 ,
388: p_attribute2_o => per_cel_shd.g_old_rec.attribute2 ,
389: p_attribute3_o => per_cel_shd.g_old_rec.attribute3 ,
390: p_attribute4_o => per_cel_shd.g_old_rec.attribute4 ,
391: p_attribute5_o => per_cel_shd.g_old_rec.attribute5 ,
392: p_attribute6_o => per_cel_shd.g_old_rec.attribute6 ,
393: p_attribute7_o => per_cel_shd.g_old_rec.attribute7 ,
394: p_attribute8_o => per_cel_shd.g_old_rec.attribute8 ,
387: p_attribute1_o => per_cel_shd.g_old_rec.attribute1 ,
388: p_attribute2_o => per_cel_shd.g_old_rec.attribute2 ,
389: p_attribute3_o => per_cel_shd.g_old_rec.attribute3 ,
390: p_attribute4_o => per_cel_shd.g_old_rec.attribute4 ,
391: p_attribute5_o => per_cel_shd.g_old_rec.attribute5 ,
392: p_attribute6_o => per_cel_shd.g_old_rec.attribute6 ,
393: p_attribute7_o => per_cel_shd.g_old_rec.attribute7 ,
394: p_attribute8_o => per_cel_shd.g_old_rec.attribute8 ,
395: p_attribute9_o => per_cel_shd.g_old_rec.attribute9 ,
388: p_attribute2_o => per_cel_shd.g_old_rec.attribute2 ,
389: p_attribute3_o => per_cel_shd.g_old_rec.attribute3 ,
390: p_attribute4_o => per_cel_shd.g_old_rec.attribute4 ,
391: p_attribute5_o => per_cel_shd.g_old_rec.attribute5 ,
392: p_attribute6_o => per_cel_shd.g_old_rec.attribute6 ,
393: p_attribute7_o => per_cel_shd.g_old_rec.attribute7 ,
394: p_attribute8_o => per_cel_shd.g_old_rec.attribute8 ,
395: p_attribute9_o => per_cel_shd.g_old_rec.attribute9 ,
396: p_attribute10_o => per_cel_shd.g_old_rec.attribute10 ,
389: p_attribute3_o => per_cel_shd.g_old_rec.attribute3 ,
390: p_attribute4_o => per_cel_shd.g_old_rec.attribute4 ,
391: p_attribute5_o => per_cel_shd.g_old_rec.attribute5 ,
392: p_attribute6_o => per_cel_shd.g_old_rec.attribute6 ,
393: p_attribute7_o => per_cel_shd.g_old_rec.attribute7 ,
394: p_attribute8_o => per_cel_shd.g_old_rec.attribute8 ,
395: p_attribute9_o => per_cel_shd.g_old_rec.attribute9 ,
396: p_attribute10_o => per_cel_shd.g_old_rec.attribute10 ,
397: p_attribute11_o => per_cel_shd.g_old_rec.attribute11 ,
390: p_attribute4_o => per_cel_shd.g_old_rec.attribute4 ,
391: p_attribute5_o => per_cel_shd.g_old_rec.attribute5 ,
392: p_attribute6_o => per_cel_shd.g_old_rec.attribute6 ,
393: p_attribute7_o => per_cel_shd.g_old_rec.attribute7 ,
394: p_attribute8_o => per_cel_shd.g_old_rec.attribute8 ,
395: p_attribute9_o => per_cel_shd.g_old_rec.attribute9 ,
396: p_attribute10_o => per_cel_shd.g_old_rec.attribute10 ,
397: p_attribute11_o => per_cel_shd.g_old_rec.attribute11 ,
398: p_attribute12_o => per_cel_shd.g_old_rec.attribute12 ,
391: p_attribute5_o => per_cel_shd.g_old_rec.attribute5 ,
392: p_attribute6_o => per_cel_shd.g_old_rec.attribute6 ,
393: p_attribute7_o => per_cel_shd.g_old_rec.attribute7 ,
394: p_attribute8_o => per_cel_shd.g_old_rec.attribute8 ,
395: p_attribute9_o => per_cel_shd.g_old_rec.attribute9 ,
396: p_attribute10_o => per_cel_shd.g_old_rec.attribute10 ,
397: p_attribute11_o => per_cel_shd.g_old_rec.attribute11 ,
398: p_attribute12_o => per_cel_shd.g_old_rec.attribute12 ,
399: p_attribute13_o => per_cel_shd.g_old_rec.attribute13 ,
392: p_attribute6_o => per_cel_shd.g_old_rec.attribute6 ,
393: p_attribute7_o => per_cel_shd.g_old_rec.attribute7 ,
394: p_attribute8_o => per_cel_shd.g_old_rec.attribute8 ,
395: p_attribute9_o => per_cel_shd.g_old_rec.attribute9 ,
396: p_attribute10_o => per_cel_shd.g_old_rec.attribute10 ,
397: p_attribute11_o => per_cel_shd.g_old_rec.attribute11 ,
398: p_attribute12_o => per_cel_shd.g_old_rec.attribute12 ,
399: p_attribute13_o => per_cel_shd.g_old_rec.attribute13 ,
400: p_attribute14_o => per_cel_shd.g_old_rec.attribute14 ,
393: p_attribute7_o => per_cel_shd.g_old_rec.attribute7 ,
394: p_attribute8_o => per_cel_shd.g_old_rec.attribute8 ,
395: p_attribute9_o => per_cel_shd.g_old_rec.attribute9 ,
396: p_attribute10_o => per_cel_shd.g_old_rec.attribute10 ,
397: p_attribute11_o => per_cel_shd.g_old_rec.attribute11 ,
398: p_attribute12_o => per_cel_shd.g_old_rec.attribute12 ,
399: p_attribute13_o => per_cel_shd.g_old_rec.attribute13 ,
400: p_attribute14_o => per_cel_shd.g_old_rec.attribute14 ,
401: p_attribute15_o => per_cel_shd.g_old_rec.attribute15 ,
394: p_attribute8_o => per_cel_shd.g_old_rec.attribute8 ,
395: p_attribute9_o => per_cel_shd.g_old_rec.attribute9 ,
396: p_attribute10_o => per_cel_shd.g_old_rec.attribute10 ,
397: p_attribute11_o => per_cel_shd.g_old_rec.attribute11 ,
398: p_attribute12_o => per_cel_shd.g_old_rec.attribute12 ,
399: p_attribute13_o => per_cel_shd.g_old_rec.attribute13 ,
400: p_attribute14_o => per_cel_shd.g_old_rec.attribute14 ,
401: p_attribute15_o => per_cel_shd.g_old_rec.attribute15 ,
402: p_attribute16_o => per_cel_shd.g_old_rec.attribute16 ,
395: p_attribute9_o => per_cel_shd.g_old_rec.attribute9 ,
396: p_attribute10_o => per_cel_shd.g_old_rec.attribute10 ,
397: p_attribute11_o => per_cel_shd.g_old_rec.attribute11 ,
398: p_attribute12_o => per_cel_shd.g_old_rec.attribute12 ,
399: p_attribute13_o => per_cel_shd.g_old_rec.attribute13 ,
400: p_attribute14_o => per_cel_shd.g_old_rec.attribute14 ,
401: p_attribute15_o => per_cel_shd.g_old_rec.attribute15 ,
402: p_attribute16_o => per_cel_shd.g_old_rec.attribute16 ,
403: p_attribute17_o => per_cel_shd.g_old_rec.attribute17 ,
396: p_attribute10_o => per_cel_shd.g_old_rec.attribute10 ,
397: p_attribute11_o => per_cel_shd.g_old_rec.attribute11 ,
398: p_attribute12_o => per_cel_shd.g_old_rec.attribute12 ,
399: p_attribute13_o => per_cel_shd.g_old_rec.attribute13 ,
400: p_attribute14_o => per_cel_shd.g_old_rec.attribute14 ,
401: p_attribute15_o => per_cel_shd.g_old_rec.attribute15 ,
402: p_attribute16_o => per_cel_shd.g_old_rec.attribute16 ,
403: p_attribute17_o => per_cel_shd.g_old_rec.attribute17 ,
404: p_attribute18_o => per_cel_shd.g_old_rec.attribute18 ,
397: p_attribute11_o => per_cel_shd.g_old_rec.attribute11 ,
398: p_attribute12_o => per_cel_shd.g_old_rec.attribute12 ,
399: p_attribute13_o => per_cel_shd.g_old_rec.attribute13 ,
400: p_attribute14_o => per_cel_shd.g_old_rec.attribute14 ,
401: p_attribute15_o => per_cel_shd.g_old_rec.attribute15 ,
402: p_attribute16_o => per_cel_shd.g_old_rec.attribute16 ,
403: p_attribute17_o => per_cel_shd.g_old_rec.attribute17 ,
404: p_attribute18_o => per_cel_shd.g_old_rec.attribute18 ,
405: p_attribute19_o => per_cel_shd.g_old_rec.attribute19 ,
398: p_attribute12_o => per_cel_shd.g_old_rec.attribute12 ,
399: p_attribute13_o => per_cel_shd.g_old_rec.attribute13 ,
400: p_attribute14_o => per_cel_shd.g_old_rec.attribute14 ,
401: p_attribute15_o => per_cel_shd.g_old_rec.attribute15 ,
402: p_attribute16_o => per_cel_shd.g_old_rec.attribute16 ,
403: p_attribute17_o => per_cel_shd.g_old_rec.attribute17 ,
404: p_attribute18_o => per_cel_shd.g_old_rec.attribute18 ,
405: p_attribute19_o => per_cel_shd.g_old_rec.attribute19 ,
406: p_attribute20_o => per_cel_shd.g_old_rec.attribute20 ,
399: p_attribute13_o => per_cel_shd.g_old_rec.attribute13 ,
400: p_attribute14_o => per_cel_shd.g_old_rec.attribute14 ,
401: p_attribute15_o => per_cel_shd.g_old_rec.attribute15 ,
402: p_attribute16_o => per_cel_shd.g_old_rec.attribute16 ,
403: p_attribute17_o => per_cel_shd.g_old_rec.attribute17 ,
404: p_attribute18_o => per_cel_shd.g_old_rec.attribute18 ,
405: p_attribute19_o => per_cel_shd.g_old_rec.attribute19 ,
406: p_attribute20_o => per_cel_shd.g_old_rec.attribute20 ,
407: p_object_id_o => per_cel_shd.g_old_rec.object_id ,
400: p_attribute14_o => per_cel_shd.g_old_rec.attribute14 ,
401: p_attribute15_o => per_cel_shd.g_old_rec.attribute15 ,
402: p_attribute16_o => per_cel_shd.g_old_rec.attribute16 ,
403: p_attribute17_o => per_cel_shd.g_old_rec.attribute17 ,
404: p_attribute18_o => per_cel_shd.g_old_rec.attribute18 ,
405: p_attribute19_o => per_cel_shd.g_old_rec.attribute19 ,
406: p_attribute20_o => per_cel_shd.g_old_rec.attribute20 ,
407: p_object_id_o => per_cel_shd.g_old_rec.object_id ,
408: p_object_name_o => per_cel_shd.g_old_rec.object_name ,
401: p_attribute15_o => per_cel_shd.g_old_rec.attribute15 ,
402: p_attribute16_o => per_cel_shd.g_old_rec.attribute16 ,
403: p_attribute17_o => per_cel_shd.g_old_rec.attribute17 ,
404: p_attribute18_o => per_cel_shd.g_old_rec.attribute18 ,
405: p_attribute19_o => per_cel_shd.g_old_rec.attribute19 ,
406: p_attribute20_o => per_cel_shd.g_old_rec.attribute20 ,
407: p_object_id_o => per_cel_shd.g_old_rec.object_id ,
408: p_object_name_o => per_cel_shd.g_old_rec.object_name ,
409: p_party_id_o => per_cel_shd.g_old_rec.party_id, -- HR/TCA merge
402: p_attribute16_o => per_cel_shd.g_old_rec.attribute16 ,
403: p_attribute17_o => per_cel_shd.g_old_rec.attribute17 ,
404: p_attribute18_o => per_cel_shd.g_old_rec.attribute18 ,
405: p_attribute19_o => per_cel_shd.g_old_rec.attribute19 ,
406: p_attribute20_o => per_cel_shd.g_old_rec.attribute20 ,
407: p_object_id_o => per_cel_shd.g_old_rec.object_id ,
408: p_object_name_o => per_cel_shd.g_old_rec.object_name ,
409: p_party_id_o => per_cel_shd.g_old_rec.party_id, -- HR/TCA merge
410: -- BUG3356369
403: p_attribute17_o => per_cel_shd.g_old_rec.attribute17 ,
404: p_attribute18_o => per_cel_shd.g_old_rec.attribute18 ,
405: p_attribute19_o => per_cel_shd.g_old_rec.attribute19 ,
406: p_attribute20_o => per_cel_shd.g_old_rec.attribute20 ,
407: p_object_id_o => per_cel_shd.g_old_rec.object_id ,
408: p_object_name_o => per_cel_shd.g_old_rec.object_name ,
409: p_party_id_o => per_cel_shd.g_old_rec.party_id, -- HR/TCA merge
410: -- BUG3356369
411: p_qualification_type_id_o => per_cel_shd.g_old_rec.qualification_type_id,
404: p_attribute18_o => per_cel_shd.g_old_rec.attribute18 ,
405: p_attribute19_o => per_cel_shd.g_old_rec.attribute19 ,
406: p_attribute20_o => per_cel_shd.g_old_rec.attribute20 ,
407: p_object_id_o => per_cel_shd.g_old_rec.object_id ,
408: p_object_name_o => per_cel_shd.g_old_rec.object_name ,
409: p_party_id_o => per_cel_shd.g_old_rec.party_id, -- HR/TCA merge
410: -- BUG3356369
411: p_qualification_type_id_o => per_cel_shd.g_old_rec.qualification_type_id,
412: p_unit_standard_type_o => per_cel_shd.g_old_rec.unit_standard_type,
405: p_attribute19_o => per_cel_shd.g_old_rec.attribute19 ,
406: p_attribute20_o => per_cel_shd.g_old_rec.attribute20 ,
407: p_object_id_o => per_cel_shd.g_old_rec.object_id ,
408: p_object_name_o => per_cel_shd.g_old_rec.object_name ,
409: p_party_id_o => per_cel_shd.g_old_rec.party_id, -- HR/TCA merge
410: -- BUG3356369
411: p_qualification_type_id_o => per_cel_shd.g_old_rec.qualification_type_id,
412: p_unit_standard_type_o => per_cel_shd.g_old_rec.unit_standard_type,
413: p_status_o => per_cel_shd.g_old_rec.status,
407: p_object_id_o => per_cel_shd.g_old_rec.object_id ,
408: p_object_name_o => per_cel_shd.g_old_rec.object_name ,
409: p_party_id_o => per_cel_shd.g_old_rec.party_id, -- HR/TCA merge
410: -- BUG3356369
411: p_qualification_type_id_o => per_cel_shd.g_old_rec.qualification_type_id,
412: p_unit_standard_type_o => per_cel_shd.g_old_rec.unit_standard_type,
413: p_status_o => per_cel_shd.g_old_rec.status,
414: p_information_category_o => per_cel_shd.g_old_rec.information_category ,
415: p_information1_o => per_cel_shd.g_old_rec.information1 ,
408: p_object_name_o => per_cel_shd.g_old_rec.object_name ,
409: p_party_id_o => per_cel_shd.g_old_rec.party_id, -- HR/TCA merge
410: -- BUG3356369
411: p_qualification_type_id_o => per_cel_shd.g_old_rec.qualification_type_id,
412: p_unit_standard_type_o => per_cel_shd.g_old_rec.unit_standard_type,
413: p_status_o => per_cel_shd.g_old_rec.status,
414: p_information_category_o => per_cel_shd.g_old_rec.information_category ,
415: p_information1_o => per_cel_shd.g_old_rec.information1 ,
416: p_information2_o => per_cel_shd.g_old_rec.information2 ,
409: p_party_id_o => per_cel_shd.g_old_rec.party_id, -- HR/TCA merge
410: -- BUG3356369
411: p_qualification_type_id_o => per_cel_shd.g_old_rec.qualification_type_id,
412: p_unit_standard_type_o => per_cel_shd.g_old_rec.unit_standard_type,
413: p_status_o => per_cel_shd.g_old_rec.status,
414: p_information_category_o => per_cel_shd.g_old_rec.information_category ,
415: p_information1_o => per_cel_shd.g_old_rec.information1 ,
416: p_information2_o => per_cel_shd.g_old_rec.information2 ,
417: p_information3_o => per_cel_shd.g_old_rec.information3 ,
410: -- BUG3356369
411: p_qualification_type_id_o => per_cel_shd.g_old_rec.qualification_type_id,
412: p_unit_standard_type_o => per_cel_shd.g_old_rec.unit_standard_type,
413: p_status_o => per_cel_shd.g_old_rec.status,
414: p_information_category_o => per_cel_shd.g_old_rec.information_category ,
415: p_information1_o => per_cel_shd.g_old_rec.information1 ,
416: p_information2_o => per_cel_shd.g_old_rec.information2 ,
417: p_information3_o => per_cel_shd.g_old_rec.information3 ,
418: p_information4_o => per_cel_shd.g_old_rec.information4 ,
411: p_qualification_type_id_o => per_cel_shd.g_old_rec.qualification_type_id,
412: p_unit_standard_type_o => per_cel_shd.g_old_rec.unit_standard_type,
413: p_status_o => per_cel_shd.g_old_rec.status,
414: p_information_category_o => per_cel_shd.g_old_rec.information_category ,
415: p_information1_o => per_cel_shd.g_old_rec.information1 ,
416: p_information2_o => per_cel_shd.g_old_rec.information2 ,
417: p_information3_o => per_cel_shd.g_old_rec.information3 ,
418: p_information4_o => per_cel_shd.g_old_rec.information4 ,
419: p_information5_o => per_cel_shd.g_old_rec.information5 ,
412: p_unit_standard_type_o => per_cel_shd.g_old_rec.unit_standard_type,
413: p_status_o => per_cel_shd.g_old_rec.status,
414: p_information_category_o => per_cel_shd.g_old_rec.information_category ,
415: p_information1_o => per_cel_shd.g_old_rec.information1 ,
416: p_information2_o => per_cel_shd.g_old_rec.information2 ,
417: p_information3_o => per_cel_shd.g_old_rec.information3 ,
418: p_information4_o => per_cel_shd.g_old_rec.information4 ,
419: p_information5_o => per_cel_shd.g_old_rec.information5 ,
420: p_information6_o => per_cel_shd.g_old_rec.information6 ,
413: p_status_o => per_cel_shd.g_old_rec.status,
414: p_information_category_o => per_cel_shd.g_old_rec.information_category ,
415: p_information1_o => per_cel_shd.g_old_rec.information1 ,
416: p_information2_o => per_cel_shd.g_old_rec.information2 ,
417: p_information3_o => per_cel_shd.g_old_rec.information3 ,
418: p_information4_o => per_cel_shd.g_old_rec.information4 ,
419: p_information5_o => per_cel_shd.g_old_rec.information5 ,
420: p_information6_o => per_cel_shd.g_old_rec.information6 ,
421: p_information7_o => per_cel_shd.g_old_rec.information7 ,
414: p_information_category_o => per_cel_shd.g_old_rec.information_category ,
415: p_information1_o => per_cel_shd.g_old_rec.information1 ,
416: p_information2_o => per_cel_shd.g_old_rec.information2 ,
417: p_information3_o => per_cel_shd.g_old_rec.information3 ,
418: p_information4_o => per_cel_shd.g_old_rec.information4 ,
419: p_information5_o => per_cel_shd.g_old_rec.information5 ,
420: p_information6_o => per_cel_shd.g_old_rec.information6 ,
421: p_information7_o => per_cel_shd.g_old_rec.information7 ,
422: p_information8_o => per_cel_shd.g_old_rec.information8 ,
415: p_information1_o => per_cel_shd.g_old_rec.information1 ,
416: p_information2_o => per_cel_shd.g_old_rec.information2 ,
417: p_information3_o => per_cel_shd.g_old_rec.information3 ,
418: p_information4_o => per_cel_shd.g_old_rec.information4 ,
419: p_information5_o => per_cel_shd.g_old_rec.information5 ,
420: p_information6_o => per_cel_shd.g_old_rec.information6 ,
421: p_information7_o => per_cel_shd.g_old_rec.information7 ,
422: p_information8_o => per_cel_shd.g_old_rec.information8 ,
423: p_information9_o => per_cel_shd.g_old_rec.information9 ,
416: p_information2_o => per_cel_shd.g_old_rec.information2 ,
417: p_information3_o => per_cel_shd.g_old_rec.information3 ,
418: p_information4_o => per_cel_shd.g_old_rec.information4 ,
419: p_information5_o => per_cel_shd.g_old_rec.information5 ,
420: p_information6_o => per_cel_shd.g_old_rec.information6 ,
421: p_information7_o => per_cel_shd.g_old_rec.information7 ,
422: p_information8_o => per_cel_shd.g_old_rec.information8 ,
423: p_information9_o => per_cel_shd.g_old_rec.information9 ,
424: p_information10_o => per_cel_shd.g_old_rec.information10 ,
417: p_information3_o => per_cel_shd.g_old_rec.information3 ,
418: p_information4_o => per_cel_shd.g_old_rec.information4 ,
419: p_information5_o => per_cel_shd.g_old_rec.information5 ,
420: p_information6_o => per_cel_shd.g_old_rec.information6 ,
421: p_information7_o => per_cel_shd.g_old_rec.information7 ,
422: p_information8_o => per_cel_shd.g_old_rec.information8 ,
423: p_information9_o => per_cel_shd.g_old_rec.information9 ,
424: p_information10_o => per_cel_shd.g_old_rec.information10 ,
425: p_information11_o => per_cel_shd.g_old_rec.information11 ,
418: p_information4_o => per_cel_shd.g_old_rec.information4 ,
419: p_information5_o => per_cel_shd.g_old_rec.information5 ,
420: p_information6_o => per_cel_shd.g_old_rec.information6 ,
421: p_information7_o => per_cel_shd.g_old_rec.information7 ,
422: p_information8_o => per_cel_shd.g_old_rec.information8 ,
423: p_information9_o => per_cel_shd.g_old_rec.information9 ,
424: p_information10_o => per_cel_shd.g_old_rec.information10 ,
425: p_information11_o => per_cel_shd.g_old_rec.information11 ,
426: p_information12_o => per_cel_shd.g_old_rec.information12 ,
419: p_information5_o => per_cel_shd.g_old_rec.information5 ,
420: p_information6_o => per_cel_shd.g_old_rec.information6 ,
421: p_information7_o => per_cel_shd.g_old_rec.information7 ,
422: p_information8_o => per_cel_shd.g_old_rec.information8 ,
423: p_information9_o => per_cel_shd.g_old_rec.information9 ,
424: p_information10_o => per_cel_shd.g_old_rec.information10 ,
425: p_information11_o => per_cel_shd.g_old_rec.information11 ,
426: p_information12_o => per_cel_shd.g_old_rec.information12 ,
427: p_information13_o => per_cel_shd.g_old_rec.information13 ,
420: p_information6_o => per_cel_shd.g_old_rec.information6 ,
421: p_information7_o => per_cel_shd.g_old_rec.information7 ,
422: p_information8_o => per_cel_shd.g_old_rec.information8 ,
423: p_information9_o => per_cel_shd.g_old_rec.information9 ,
424: p_information10_o => per_cel_shd.g_old_rec.information10 ,
425: p_information11_o => per_cel_shd.g_old_rec.information11 ,
426: p_information12_o => per_cel_shd.g_old_rec.information12 ,
427: p_information13_o => per_cel_shd.g_old_rec.information13 ,
428: p_information14_o => per_cel_shd.g_old_rec.information14 ,
421: p_information7_o => per_cel_shd.g_old_rec.information7 ,
422: p_information8_o => per_cel_shd.g_old_rec.information8 ,
423: p_information9_o => per_cel_shd.g_old_rec.information9 ,
424: p_information10_o => per_cel_shd.g_old_rec.information10 ,
425: p_information11_o => per_cel_shd.g_old_rec.information11 ,
426: p_information12_o => per_cel_shd.g_old_rec.information12 ,
427: p_information13_o => per_cel_shd.g_old_rec.information13 ,
428: p_information14_o => per_cel_shd.g_old_rec.information14 ,
429: p_information15_o => per_cel_shd.g_old_rec.information15 ,
422: p_information8_o => per_cel_shd.g_old_rec.information8 ,
423: p_information9_o => per_cel_shd.g_old_rec.information9 ,
424: p_information10_o => per_cel_shd.g_old_rec.information10 ,
425: p_information11_o => per_cel_shd.g_old_rec.information11 ,
426: p_information12_o => per_cel_shd.g_old_rec.information12 ,
427: p_information13_o => per_cel_shd.g_old_rec.information13 ,
428: p_information14_o => per_cel_shd.g_old_rec.information14 ,
429: p_information15_o => per_cel_shd.g_old_rec.information15 ,
430: p_information16_o => per_cel_shd.g_old_rec.information16 ,
423: p_information9_o => per_cel_shd.g_old_rec.information9 ,
424: p_information10_o => per_cel_shd.g_old_rec.information10 ,
425: p_information11_o => per_cel_shd.g_old_rec.information11 ,
426: p_information12_o => per_cel_shd.g_old_rec.information12 ,
427: p_information13_o => per_cel_shd.g_old_rec.information13 ,
428: p_information14_o => per_cel_shd.g_old_rec.information14 ,
429: p_information15_o => per_cel_shd.g_old_rec.information15 ,
430: p_information16_o => per_cel_shd.g_old_rec.information16 ,
431: p_information17_o => per_cel_shd.g_old_rec.information17 ,
424: p_information10_o => per_cel_shd.g_old_rec.information10 ,
425: p_information11_o => per_cel_shd.g_old_rec.information11 ,
426: p_information12_o => per_cel_shd.g_old_rec.information12 ,
427: p_information13_o => per_cel_shd.g_old_rec.information13 ,
428: p_information14_o => per_cel_shd.g_old_rec.information14 ,
429: p_information15_o => per_cel_shd.g_old_rec.information15 ,
430: p_information16_o => per_cel_shd.g_old_rec.information16 ,
431: p_information17_o => per_cel_shd.g_old_rec.information17 ,
432: p_information18_o => per_cel_shd.g_old_rec.information18 ,
425: p_information11_o => per_cel_shd.g_old_rec.information11 ,
426: p_information12_o => per_cel_shd.g_old_rec.information12 ,
427: p_information13_o => per_cel_shd.g_old_rec.information13 ,
428: p_information14_o => per_cel_shd.g_old_rec.information14 ,
429: p_information15_o => per_cel_shd.g_old_rec.information15 ,
430: p_information16_o => per_cel_shd.g_old_rec.information16 ,
431: p_information17_o => per_cel_shd.g_old_rec.information17 ,
432: p_information18_o => per_cel_shd.g_old_rec.information18 ,
433: p_information19_o => per_cel_shd.g_old_rec.information19 ,
426: p_information12_o => per_cel_shd.g_old_rec.information12 ,
427: p_information13_o => per_cel_shd.g_old_rec.information13 ,
428: p_information14_o => per_cel_shd.g_old_rec.information14 ,
429: p_information15_o => per_cel_shd.g_old_rec.information15 ,
430: p_information16_o => per_cel_shd.g_old_rec.information16 ,
431: p_information17_o => per_cel_shd.g_old_rec.information17 ,
432: p_information18_o => per_cel_shd.g_old_rec.information18 ,
433: p_information19_o => per_cel_shd.g_old_rec.information19 ,
434: p_information20_o => per_cel_shd.g_old_rec.information20 ,
427: p_information13_o => per_cel_shd.g_old_rec.information13 ,
428: p_information14_o => per_cel_shd.g_old_rec.information14 ,
429: p_information15_o => per_cel_shd.g_old_rec.information15 ,
430: p_information16_o => per_cel_shd.g_old_rec.information16 ,
431: p_information17_o => per_cel_shd.g_old_rec.information17 ,
432: p_information18_o => per_cel_shd.g_old_rec.information18 ,
433: p_information19_o => per_cel_shd.g_old_rec.information19 ,
434: p_information20_o => per_cel_shd.g_old_rec.information20 ,
435: p_achieved_date_o => per_cel_shd.g_old_rec.achieved_date ,
428: p_information14_o => per_cel_shd.g_old_rec.information14 ,
429: p_information15_o => per_cel_shd.g_old_rec.information15 ,
430: p_information16_o => per_cel_shd.g_old_rec.information16 ,
431: p_information17_o => per_cel_shd.g_old_rec.information17 ,
432: p_information18_o => per_cel_shd.g_old_rec.information18 ,
433: p_information19_o => per_cel_shd.g_old_rec.information19 ,
434: p_information20_o => per_cel_shd.g_old_rec.information20 ,
435: p_achieved_date_o => per_cel_shd.g_old_rec.achieved_date ,
436: p_appr_line_score_o => per_cel_shd.g_old_rec.appr_line_score
429: p_information15_o => per_cel_shd.g_old_rec.information15 ,
430: p_information16_o => per_cel_shd.g_old_rec.information16 ,
431: p_information17_o => per_cel_shd.g_old_rec.information17 ,
432: p_information18_o => per_cel_shd.g_old_rec.information18 ,
433: p_information19_o => per_cel_shd.g_old_rec.information19 ,
434: p_information20_o => per_cel_shd.g_old_rec.information20 ,
435: p_achieved_date_o => per_cel_shd.g_old_rec.achieved_date ,
436: p_appr_line_score_o => per_cel_shd.g_old_rec.appr_line_score
437: );
430: p_information16_o => per_cel_shd.g_old_rec.information16 ,
431: p_information17_o => per_cel_shd.g_old_rec.information17 ,
432: p_information18_o => per_cel_shd.g_old_rec.information18 ,
433: p_information19_o => per_cel_shd.g_old_rec.information19 ,
434: p_information20_o => per_cel_shd.g_old_rec.information20 ,
435: p_achieved_date_o => per_cel_shd.g_old_rec.achieved_date ,
436: p_appr_line_score_o => per_cel_shd.g_old_rec.appr_line_score
437: );
438: exception
431: p_information17_o => per_cel_shd.g_old_rec.information17 ,
432: p_information18_o => per_cel_shd.g_old_rec.information18 ,
433: p_information19_o => per_cel_shd.g_old_rec.information19 ,
434: p_information20_o => per_cel_shd.g_old_rec.information20 ,
435: p_achieved_date_o => per_cel_shd.g_old_rec.achieved_date ,
436: p_appr_line_score_o => per_cel_shd.g_old_rec.appr_line_score
437: );
438: exception
439: when hr_api.cannot_find_prog_unit then
432: p_information18_o => per_cel_shd.g_old_rec.information18 ,
433: p_information19_o => per_cel_shd.g_old_rec.information19 ,
434: p_information20_o => per_cel_shd.g_old_rec.information20 ,
435: p_achieved_date_o => per_cel_shd.g_old_rec.achieved_date ,
436: p_appr_line_score_o => per_cel_shd.g_old_rec.appr_line_score
437: );
438: exception
439: when hr_api.cannot_find_prog_unit then
440: hr_api.cannot_find_prog_unit_error
490: -- Internal Table Handler Use Only.
491: --
492: -- {End Of Comments}
493: -- ----------------------------------------------------------------------------
494: Procedure convert_defs(p_rec in out nocopy per_cel_shd.g_rec_type) is
495: --
496: l_proc varchar2(72) := g_package||'convert_defs';
497: --
498: Begin
505: -- is being used then we must set to the 'current' argument value.
506: --
507: If (p_rec.type = hr_api.g_varchar2) then
508: p_rec.type :=
509: per_cel_shd.g_old_rec.type;
510: End If;
511: If (p_rec.business_group_id = hr_api.g_number) then
512: p_rec.business_group_id :=
513: per_cel_shd.g_old_rec.business_group_id;
509: per_cel_shd.g_old_rec.type;
510: End If;
511: If (p_rec.business_group_id = hr_api.g_number) then
512: p_rec.business_group_id :=
513: per_cel_shd.g_old_rec.business_group_id;
514: End If;
515: If (p_rec.competence_id = hr_api.g_number) then
516: p_rec.competence_id :=
517: per_cel_shd.g_old_rec.competence_id;
513: per_cel_shd.g_old_rec.business_group_id;
514: End If;
515: If (p_rec.competence_id = hr_api.g_number) then
516: p_rec.competence_id :=
517: per_cel_shd.g_old_rec.competence_id;
518: End If;
519: If (p_rec.proficiency_level_id = hr_api.g_number) then
520: p_rec.proficiency_level_id :=
521: per_cel_shd.g_old_rec.proficiency_level_id;
517: per_cel_shd.g_old_rec.competence_id;
518: End If;
519: If (p_rec.proficiency_level_id = hr_api.g_number) then
520: p_rec.proficiency_level_id :=
521: per_cel_shd.g_old_rec.proficiency_level_id;
522: End If;
523: If (p_rec.high_proficiency_level_id = hr_api.g_number) then
524: p_rec.high_proficiency_level_id :=
525: per_cel_shd.g_old_rec.high_proficiency_level_id;
521: per_cel_shd.g_old_rec.proficiency_level_id;
522: End If;
523: If (p_rec.high_proficiency_level_id = hr_api.g_number) then
524: p_rec.high_proficiency_level_id :=
525: per_cel_shd.g_old_rec.high_proficiency_level_id;
526: End If;
527: If (p_rec.weighting_level_id = hr_api.g_number) then
528: p_rec.weighting_level_id :=
529: per_cel_shd.g_old_rec.weighting_level_id;
525: per_cel_shd.g_old_rec.high_proficiency_level_id;
526: End If;
527: If (p_rec.weighting_level_id = hr_api.g_number) then
528: p_rec.weighting_level_id :=
529: per_cel_shd.g_old_rec.weighting_level_id;
530: End If;
531: If (p_rec.rating_level_id = hr_api.g_number) then
532: p_rec.rating_level_id :=
533: per_cel_shd.g_old_rec.rating_level_id;
529: per_cel_shd.g_old_rec.weighting_level_id;
530: End If;
531: If (p_rec.rating_level_id = hr_api.g_number) then
532: p_rec.rating_level_id :=
533: per_cel_shd.g_old_rec.rating_level_id;
534: End If;
535: If (p_rec.person_id = hr_api.g_number) then
536: p_rec.person_id :=
537: per_cel_shd.g_old_rec.person_id;
533: per_cel_shd.g_old_rec.rating_level_id;
534: End If;
535: If (p_rec.person_id = hr_api.g_number) then
536: p_rec.person_id :=
537: per_cel_shd.g_old_rec.person_id;
538: End If;
539: If (p_rec.job_id = hr_api.g_number) then
540: p_rec.job_id :=
541: per_cel_shd.g_old_rec.job_id;
537: per_cel_shd.g_old_rec.person_id;
538: End If;
539: If (p_rec.job_id = hr_api.g_number) then
540: p_rec.job_id :=
541: per_cel_shd.g_old_rec.job_id;
542: End If;
543: If (p_rec.valid_grade_id = hr_api.g_number) then
544: p_rec.valid_grade_id :=
545: per_cel_shd.g_old_rec.valid_grade_id;
541: per_cel_shd.g_old_rec.job_id;
542: End If;
543: If (p_rec.valid_grade_id = hr_api.g_number) then
544: p_rec.valid_grade_id :=
545: per_cel_shd.g_old_rec.valid_grade_id;
546: end if;
547: If (p_rec.enterprise_id = hr_api.g_number) then
548: p_rec.enterprise_id :=
549: per_cel_shd.g_old_rec.enterprise_id;
545: per_cel_shd.g_old_rec.valid_grade_id;
546: end if;
547: If (p_rec.enterprise_id = hr_api.g_number) then
548: p_rec.enterprise_id :=
549: per_cel_shd.g_old_rec.enterprise_id;
550: End If;
551: If (p_rec.position_id = hr_api.g_number) then
552: p_rec.position_id :=
553: per_cel_shd.g_old_rec.position_id;
549: per_cel_shd.g_old_rec.enterprise_id;
550: End If;
551: If (p_rec.position_id = hr_api.g_number) then
552: p_rec.position_id :=
553: per_cel_shd.g_old_rec.position_id;
554: End If;
555: If (p_rec.organization_id = hr_api.g_number) then
556: p_rec.organization_id :=
557: per_cel_shd.g_old_rec.organization_id;
553: per_cel_shd.g_old_rec.position_id;
554: End If;
555: If (p_rec.organization_id = hr_api.g_number) then
556: p_rec.organization_id :=
557: per_cel_shd.g_old_rec.organization_id;
558: End If;
559: If (p_rec.parent_competence_element_id = hr_api.g_number) then
560: p_rec.parent_competence_element_id :=
561: per_cel_shd.g_old_rec.parent_competence_element_id;
557: per_cel_shd.g_old_rec.organization_id;
558: End If;
559: If (p_rec.parent_competence_element_id = hr_api.g_number) then
560: p_rec.parent_competence_element_id :=
561: per_cel_shd.g_old_rec.parent_competence_element_id;
562: End If;
563: If (p_rec.activity_version_id = hr_api.g_number) then
564: p_rec.activity_version_id :=
565: per_cel_shd.g_old_rec.activity_version_id;
561: per_cel_shd.g_old_rec.parent_competence_element_id;
562: End If;
563: If (p_rec.activity_version_id = hr_api.g_number) then
564: p_rec.activity_version_id :=
565: per_cel_shd.g_old_rec.activity_version_id;
566: End If;
567: If (p_rec.assessment_id = hr_api.g_number) then
568: p_rec.assessment_id :=
569: per_cel_shd.g_old_rec.assessment_id;
565: per_cel_shd.g_old_rec.activity_version_id;
566: End If;
567: If (p_rec.assessment_id = hr_api.g_number) then
568: p_rec.assessment_id :=
569: per_cel_shd.g_old_rec.assessment_id;
570: End If;
571: If (p_rec.assessment_type_id = hr_api.g_number) then
572: p_rec.assessment_type_id :=
573: per_cel_shd.g_old_rec.assessment_type_id;
569: per_cel_shd.g_old_rec.assessment_id;
570: End If;
571: If (p_rec.assessment_type_id = hr_api.g_number) then
572: p_rec.assessment_type_id :=
573: per_cel_shd.g_old_rec.assessment_type_id;
574: End If;
575: If (p_rec.mandatory = hr_api.g_varchar2) then
576: p_rec.mandatory :=
577: per_cel_shd.g_old_rec.mandatory;
573: per_cel_shd.g_old_rec.assessment_type_id;
574: End If;
575: If (p_rec.mandatory = hr_api.g_varchar2) then
576: p_rec.mandatory :=
577: per_cel_shd.g_old_rec.mandatory;
578: End If;
579: If (p_rec.effective_date_from = hr_api.g_date) then
580: p_rec.effective_date_from :=
581: per_cel_shd.g_old_rec.effective_date_from;
577: per_cel_shd.g_old_rec.mandatory;
578: End If;
579: If (p_rec.effective_date_from = hr_api.g_date) then
580: p_rec.effective_date_from :=
581: per_cel_shd.g_old_rec.effective_date_from;
582: End If;
583: If (p_rec.effective_date_to = hr_api.g_date) then
584: p_rec.effective_date_to :=
585: per_cel_shd.g_old_rec.effective_date_to;
581: per_cel_shd.g_old_rec.effective_date_from;
582: End If;
583: If (p_rec.effective_date_to = hr_api.g_date) then
584: p_rec.effective_date_to :=
585: per_cel_shd.g_old_rec.effective_date_to;
586: End If;
587: If (p_rec.group_competence_type = hr_api.g_varchar2) then
588: p_rec.group_competence_type :=
589: per_cel_shd.g_old_rec.group_competence_type;
585: per_cel_shd.g_old_rec.effective_date_to;
586: End If;
587: If (p_rec.group_competence_type = hr_api.g_varchar2) then
588: p_rec.group_competence_type :=
589: per_cel_shd.g_old_rec.group_competence_type;
590: End If;
591: If (p_rec.competence_type = hr_api.g_varchar2) then
592: p_rec.competence_type :=
593: per_cel_shd.g_old_rec.competence_type;
589: per_cel_shd.g_old_rec.group_competence_type;
590: End If;
591: If (p_rec.competence_type = hr_api.g_varchar2) then
592: p_rec.competence_type :=
593: per_cel_shd.g_old_rec.competence_type;
594: End If;
595: If (p_rec.normal_elapse_duration = hr_api.g_number) then
596: p_rec.normal_elapse_duration :=
597: per_cel_shd.g_old_rec.normal_elapse_duration;
593: per_cel_shd.g_old_rec.competence_type;
594: End If;
595: If (p_rec.normal_elapse_duration = hr_api.g_number) then
596: p_rec.normal_elapse_duration :=
597: per_cel_shd.g_old_rec.normal_elapse_duration;
598: End If;
599: If (p_rec.normal_elapse_duration_unit = hr_api.g_varchar2) then
600: p_rec.normal_elapse_duration_unit :=
601: per_cel_shd.g_old_rec.normal_elapse_duration_unit;
597: per_cel_shd.g_old_rec.normal_elapse_duration;
598: End If;
599: If (p_rec.normal_elapse_duration_unit = hr_api.g_varchar2) then
600: p_rec.normal_elapse_duration_unit :=
601: per_cel_shd.g_old_rec.normal_elapse_duration_unit;
602: End If;
603: If (p_rec.sequence_number = hr_api.g_number) then
604: p_rec.sequence_number :=
605: per_cel_shd.g_old_rec.sequence_number;
601: per_cel_shd.g_old_rec.normal_elapse_duration_unit;
602: End If;
603: If (p_rec.sequence_number = hr_api.g_number) then
604: p_rec.sequence_number :=
605: per_cel_shd.g_old_rec.sequence_number;
606: End If;
607: If (p_rec.source_of_proficiency_level = hr_api.g_varchar2) then
608: p_rec.source_of_proficiency_level :=
609: per_cel_shd.g_old_rec.source_of_proficiency_level;
605: per_cel_shd.g_old_rec.sequence_number;
606: End If;
607: If (p_rec.source_of_proficiency_level = hr_api.g_varchar2) then
608: p_rec.source_of_proficiency_level :=
609: per_cel_shd.g_old_rec.source_of_proficiency_level;
610: End If;
611: If (p_rec.line_score = hr_api.g_number) then
612: p_rec.line_score :=
613: per_cel_shd.g_old_rec.line_score;
609: per_cel_shd.g_old_rec.source_of_proficiency_level;
610: End If;
611: If (p_rec.line_score = hr_api.g_number) then
612: p_rec.line_score :=
613: per_cel_shd.g_old_rec.line_score;
614: End If;
615: If (p_rec.certification_date = hr_api.g_date) then
616: p_rec.certification_date :=
617: per_cel_shd.g_old_rec.certification_date;
613: per_cel_shd.g_old_rec.line_score;
614: End If;
615: If (p_rec.certification_date = hr_api.g_date) then
616: p_rec.certification_date :=
617: per_cel_shd.g_old_rec.certification_date;
618: End If;
619: If (p_rec.certification_method = hr_api.g_varchar2) then
620: p_rec.certification_method :=
621: per_cel_shd.g_old_rec.certification_method;
617: per_cel_shd.g_old_rec.certification_date;
618: End If;
619: If (p_rec.certification_method = hr_api.g_varchar2) then
620: p_rec.certification_method :=
621: per_cel_shd.g_old_rec.certification_method;
622: End If;
623: If (p_rec.next_certification_date = hr_api.g_date) then
624: p_rec.next_certification_date :=
625: per_cel_shd.g_old_rec.next_certification_date;
621: per_cel_shd.g_old_rec.certification_method;
622: End If;
623: If (p_rec.next_certification_date = hr_api.g_date) then
624: p_rec.next_certification_date :=
625: per_cel_shd.g_old_rec.next_certification_date;
626: End If;
627: If (p_rec.comments = hr_api.g_varchar2) then
628: p_rec.comments :=
629: per_cel_shd.g_old_rec.comments;
625: per_cel_shd.g_old_rec.next_certification_date;
626: End If;
627: If (p_rec.comments = hr_api.g_varchar2) then
628: p_rec.comments :=
629: per_cel_shd.g_old_rec.comments;
630: End If;
631: If (p_rec.attribute_category = hr_api.g_varchar2) then
632: p_rec.attribute_category :=
633: per_cel_shd.g_old_rec.attribute_category;
629: per_cel_shd.g_old_rec.comments;
630: End If;
631: If (p_rec.attribute_category = hr_api.g_varchar2) then
632: p_rec.attribute_category :=
633: per_cel_shd.g_old_rec.attribute_category;
634: End If;
635: If (p_rec.attribute1 = hr_api.g_varchar2) then
636: p_rec.attribute1 :=
637: per_cel_shd.g_old_rec.attribute1;
633: per_cel_shd.g_old_rec.attribute_category;
634: End If;
635: If (p_rec.attribute1 = hr_api.g_varchar2) then
636: p_rec.attribute1 :=
637: per_cel_shd.g_old_rec.attribute1;
638: End If;
639: If (p_rec.attribute2 = hr_api.g_varchar2) then
640: p_rec.attribute2 :=
641: per_cel_shd.g_old_rec.attribute2;
637: per_cel_shd.g_old_rec.attribute1;
638: End If;
639: If (p_rec.attribute2 = hr_api.g_varchar2) then
640: p_rec.attribute2 :=
641: per_cel_shd.g_old_rec.attribute2;
642: End If;
643: If (p_rec.attribute3 = hr_api.g_varchar2) then
644: p_rec.attribute3 :=
645: per_cel_shd.g_old_rec.attribute3;
641: per_cel_shd.g_old_rec.attribute2;
642: End If;
643: If (p_rec.attribute3 = hr_api.g_varchar2) then
644: p_rec.attribute3 :=
645: per_cel_shd.g_old_rec.attribute3;
646: End If;
647: If (p_rec.attribute4 = hr_api.g_varchar2) then
648: p_rec.attribute4 :=
649: per_cel_shd.g_old_rec.attribute4;
645: per_cel_shd.g_old_rec.attribute3;
646: End If;
647: If (p_rec.attribute4 = hr_api.g_varchar2) then
648: p_rec.attribute4 :=
649: per_cel_shd.g_old_rec.attribute4;
650: End If;
651: If (p_rec.attribute5 = hr_api.g_varchar2) then
652: p_rec.attribute5 :=
653: per_cel_shd.g_old_rec.attribute5;
649: per_cel_shd.g_old_rec.attribute4;
650: End If;
651: If (p_rec.attribute5 = hr_api.g_varchar2) then
652: p_rec.attribute5 :=
653: per_cel_shd.g_old_rec.attribute5;
654: End If;
655: If (p_rec.attribute6 = hr_api.g_varchar2) then
656: p_rec.attribute6 :=
657: per_cel_shd.g_old_rec.attribute6;
653: per_cel_shd.g_old_rec.attribute5;
654: End If;
655: If (p_rec.attribute6 = hr_api.g_varchar2) then
656: p_rec.attribute6 :=
657: per_cel_shd.g_old_rec.attribute6;
658: End If;
659: If (p_rec.attribute7 = hr_api.g_varchar2) then
660: p_rec.attribute7 :=
661: per_cel_shd.g_old_rec.attribute7;
657: per_cel_shd.g_old_rec.attribute6;
658: End If;
659: If (p_rec.attribute7 = hr_api.g_varchar2) then
660: p_rec.attribute7 :=
661: per_cel_shd.g_old_rec.attribute7;
662: End If;
663: If (p_rec.attribute8 = hr_api.g_varchar2) then
664: p_rec.attribute8 :=
665: per_cel_shd.g_old_rec.attribute8;
661: per_cel_shd.g_old_rec.attribute7;
662: End If;
663: If (p_rec.attribute8 = hr_api.g_varchar2) then
664: p_rec.attribute8 :=
665: per_cel_shd.g_old_rec.attribute8;
666: End If;
667: If (p_rec.attribute9 = hr_api.g_varchar2) then
668: p_rec.attribute9 :=
669: per_cel_shd.g_old_rec.attribute9;
665: per_cel_shd.g_old_rec.attribute8;
666: End If;
667: If (p_rec.attribute9 = hr_api.g_varchar2) then
668: p_rec.attribute9 :=
669: per_cel_shd.g_old_rec.attribute9;
670: End If;
671: If (p_rec.attribute10 = hr_api.g_varchar2) then
672: p_rec.attribute10 :=
673: per_cel_shd.g_old_rec.attribute10;
669: per_cel_shd.g_old_rec.attribute9;
670: End If;
671: If (p_rec.attribute10 = hr_api.g_varchar2) then
672: p_rec.attribute10 :=
673: per_cel_shd.g_old_rec.attribute10;
674: End If;
675: If (p_rec.attribute11 = hr_api.g_varchar2) then
676: p_rec.attribute11 :=
677: per_cel_shd.g_old_rec.attribute11;
673: per_cel_shd.g_old_rec.attribute10;
674: End If;
675: If (p_rec.attribute11 = hr_api.g_varchar2) then
676: p_rec.attribute11 :=
677: per_cel_shd.g_old_rec.attribute11;
678: End If;
679: If (p_rec.attribute12 = hr_api.g_varchar2) then
680: p_rec.attribute12 :=
681: per_cel_shd.g_old_rec.attribute12;
677: per_cel_shd.g_old_rec.attribute11;
678: End If;
679: If (p_rec.attribute12 = hr_api.g_varchar2) then
680: p_rec.attribute12 :=
681: per_cel_shd.g_old_rec.attribute12;
682: End If;
683: If (p_rec.attribute13 = hr_api.g_varchar2) then
684: p_rec.attribute13 :=
685: per_cel_shd.g_old_rec.attribute13;
681: per_cel_shd.g_old_rec.attribute12;
682: End If;
683: If (p_rec.attribute13 = hr_api.g_varchar2) then
684: p_rec.attribute13 :=
685: per_cel_shd.g_old_rec.attribute13;
686: End If;
687: If (p_rec.attribute14 = hr_api.g_varchar2) then
688: p_rec.attribute14 :=
689: per_cel_shd.g_old_rec.attribute14;
685: per_cel_shd.g_old_rec.attribute13;
686: End If;
687: If (p_rec.attribute14 = hr_api.g_varchar2) then
688: p_rec.attribute14 :=
689: per_cel_shd.g_old_rec.attribute14;
690: End If;
691: If (p_rec.attribute15 = hr_api.g_varchar2) then
692: p_rec.attribute15 :=
693: per_cel_shd.g_old_rec.attribute15;
689: per_cel_shd.g_old_rec.attribute14;
690: End If;
691: If (p_rec.attribute15 = hr_api.g_varchar2) then
692: p_rec.attribute15 :=
693: per_cel_shd.g_old_rec.attribute15;
694: End If;
695: If (p_rec.attribute16 = hr_api.g_varchar2) then
696: p_rec.attribute16 :=
697: per_cel_shd.g_old_rec.attribute16;
693: per_cel_shd.g_old_rec.attribute15;
694: End If;
695: If (p_rec.attribute16 = hr_api.g_varchar2) then
696: p_rec.attribute16 :=
697: per_cel_shd.g_old_rec.attribute16;
698: End If;
699: If (p_rec.attribute17 = hr_api.g_varchar2) then
700: p_rec.attribute17 :=
701: per_cel_shd.g_old_rec.attribute17;
697: per_cel_shd.g_old_rec.attribute16;
698: End If;
699: If (p_rec.attribute17 = hr_api.g_varchar2) then
700: p_rec.attribute17 :=
701: per_cel_shd.g_old_rec.attribute17;
702: End If;
703: If (p_rec.attribute18 = hr_api.g_varchar2) then
704: p_rec.attribute18 :=
705: per_cel_shd.g_old_rec.attribute18;
701: per_cel_shd.g_old_rec.attribute17;
702: End If;
703: If (p_rec.attribute18 = hr_api.g_varchar2) then
704: p_rec.attribute18 :=
705: per_cel_shd.g_old_rec.attribute18;
706: End If;
707: If (p_rec.attribute19 = hr_api.g_varchar2) then
708: p_rec.attribute19 :=
709: per_cel_shd.g_old_rec.attribute19;
705: per_cel_shd.g_old_rec.attribute18;
706: End If;
707: If (p_rec.attribute19 = hr_api.g_varchar2) then
708: p_rec.attribute19 :=
709: per_cel_shd.g_old_rec.attribute19;
710: End If;
711: If (p_rec.attribute20 = hr_api.g_varchar2) then
712: p_rec.attribute20 :=
713: per_cel_shd.g_old_rec.attribute20;
709: per_cel_shd.g_old_rec.attribute19;
710: End If;
711: If (p_rec.attribute20 = hr_api.g_varchar2) then
712: p_rec.attribute20 :=
713: per_cel_shd.g_old_rec.attribute20;
714: End If;
715: if (p_rec.object_id = hr_api.g_number) then
716: p_rec.object_id :=
717: per_cel_shd.g_old_rec.object_id;
713: per_cel_shd.g_old_rec.attribute20;
714: End If;
715: if (p_rec.object_id = hr_api.g_number) then
716: p_rec.object_id :=
717: per_cel_shd.g_old_rec.object_id;
718: End If;
719:
720: If (p_rec.object_name = hr_api.g_varchar2) then
721: p_rec.object_name :=
718: End If;
719:
720: If (p_rec.object_name = hr_api.g_varchar2) then
721: p_rec.object_name :=
722: per_cel_shd.g_old_rec.object_name;
723: End if;
724: -- ngundura added last two if conditions for object_id and name
725: If (p_rec.party_id = hr_api.g_number) then -- HR/TCA merge
726: p_rec.party_id :=
723: End if;
724: -- ngundura added last two if conditions for object_id and name
725: If (p_rec.party_id = hr_api.g_number) then -- HR/TCA merge
726: p_rec.party_id :=
727: per_cel_shd.g_old_rec.party_id;
728: End If;
729: If (p_rec.qualification_type_id = hr_api.g_number) then
730: p_rec.qualification_type_id :=
731: per_cel_shd.g_old_rec.qualification_type_id;
727: per_cel_shd.g_old_rec.party_id;
728: End If;
729: If (p_rec.qualification_type_id = hr_api.g_number) then
730: p_rec.qualification_type_id :=
731: per_cel_shd.g_old_rec.qualification_type_id;
732: End If;
733: If (p_rec.unit_standard_type = hr_api.g_varchar2) then
734: p_rec.unit_standard_type :=
735: per_cel_shd.g_old_rec.unit_standard_type;
731: per_cel_shd.g_old_rec.qualification_type_id;
732: End If;
733: If (p_rec.unit_standard_type = hr_api.g_varchar2) then
734: p_rec.unit_standard_type :=
735: per_cel_shd.g_old_rec.unit_standard_type;
736: End If;
737: If (p_rec.status = hr_api.g_varchar2) then
738: p_rec.status :=
739: per_cel_shd.g_old_rec.status;
735: per_cel_shd.g_old_rec.unit_standard_type;
736: End If;
737: If (p_rec.status = hr_api.g_varchar2) then
738: p_rec.status :=
739: per_cel_shd.g_old_rec.status;
740: End If;
741: If (p_rec.information_category = hr_api.g_varchar2) then
742: p_rec.information_category :=
743: per_cel_shd.g_old_rec.information_category;
739: per_cel_shd.g_old_rec.status;
740: End If;
741: If (p_rec.information_category = hr_api.g_varchar2) then
742: p_rec.information_category :=
743: per_cel_shd.g_old_rec.information_category;
744: End If;
745: If (p_rec.information1 = hr_api.g_varchar2) then
746: p_rec.information1 :=
747: per_cel_shd.g_old_rec.information1;
743: per_cel_shd.g_old_rec.information_category;
744: End If;
745: If (p_rec.information1 = hr_api.g_varchar2) then
746: p_rec.information1 :=
747: per_cel_shd.g_old_rec.information1;
748: End If;
749: If (p_rec.information2 = hr_api.g_varchar2) then
750: p_rec.information2 :=
751: per_cel_shd.g_old_rec.information2;
747: per_cel_shd.g_old_rec.information1;
748: End If;
749: If (p_rec.information2 = hr_api.g_varchar2) then
750: p_rec.information2 :=
751: per_cel_shd.g_old_rec.information2;
752: End If;
753: If (p_rec.information3 = hr_api.g_varchar2) then
754: p_rec.information3 :=
755: per_cel_shd.g_old_rec.information3;
751: per_cel_shd.g_old_rec.information2;
752: End If;
753: If (p_rec.information3 = hr_api.g_varchar2) then
754: p_rec.information3 :=
755: per_cel_shd.g_old_rec.information3;
756: End If;
757: If (p_rec.information4 = hr_api.g_varchar2) then
758: p_rec.information4 :=
759: per_cel_shd.g_old_rec.information4;
755: per_cel_shd.g_old_rec.information3;
756: End If;
757: If (p_rec.information4 = hr_api.g_varchar2) then
758: p_rec.information4 :=
759: per_cel_shd.g_old_rec.information4;
760: End If;
761: If (p_rec.information5 = hr_api.g_varchar2) then
762: p_rec.information5 :=
763: per_cel_shd.g_old_rec.information5;
759: per_cel_shd.g_old_rec.information4;
760: End If;
761: If (p_rec.information5 = hr_api.g_varchar2) then
762: p_rec.information5 :=
763: per_cel_shd.g_old_rec.information5;
764: End If;
765: If (p_rec.information6 = hr_api.g_varchar2) then
766: p_rec.information6 :=
767: per_cel_shd.g_old_rec.information6;
763: per_cel_shd.g_old_rec.information5;
764: End If;
765: If (p_rec.information6 = hr_api.g_varchar2) then
766: p_rec.information6 :=
767: per_cel_shd.g_old_rec.information6;
768: End If;
769: If (p_rec.information7 = hr_api.g_varchar2) then
770: p_rec.information7 :=
771: per_cel_shd.g_old_rec.information7;
767: per_cel_shd.g_old_rec.information6;
768: End If;
769: If (p_rec.information7 = hr_api.g_varchar2) then
770: p_rec.information7 :=
771: per_cel_shd.g_old_rec.information7;
772: End If;
773: If (p_rec.information8 = hr_api.g_varchar2) then
774: p_rec.information8 :=
775: per_cel_shd.g_old_rec.information8;
771: per_cel_shd.g_old_rec.information7;
772: End If;
773: If (p_rec.information8 = hr_api.g_varchar2) then
774: p_rec.information8 :=
775: per_cel_shd.g_old_rec.information8;
776: End If;
777: If (p_rec.information9 = hr_api.g_varchar2) then
778: p_rec.information9 :=
779: per_cel_shd.g_old_rec.information9;
775: per_cel_shd.g_old_rec.information8;
776: End If;
777: If (p_rec.information9 = hr_api.g_varchar2) then
778: p_rec.information9 :=
779: per_cel_shd.g_old_rec.information9;
780: End If;
781: If (p_rec.information10 = hr_api.g_varchar2) then
782: p_rec.information10 :=
783: per_cel_shd.g_old_rec.information10;
779: per_cel_shd.g_old_rec.information9;
780: End If;
781: If (p_rec.information10 = hr_api.g_varchar2) then
782: p_rec.information10 :=
783: per_cel_shd.g_old_rec.information10;
784: End If;
785: If (p_rec.information11 = hr_api.g_varchar2) then
786: p_rec.information11 :=
787: per_cel_shd.g_old_rec.information11;
783: per_cel_shd.g_old_rec.information10;
784: End If;
785: If (p_rec.information11 = hr_api.g_varchar2) then
786: p_rec.information11 :=
787: per_cel_shd.g_old_rec.information11;
788: End If;
789: If (p_rec.information12 = hr_api.g_varchar2) then
790: p_rec.information12 :=
791: per_cel_shd.g_old_rec.information12;
787: per_cel_shd.g_old_rec.information11;
788: End If;
789: If (p_rec.information12 = hr_api.g_varchar2) then
790: p_rec.information12 :=
791: per_cel_shd.g_old_rec.information12;
792: End If;
793: If (p_rec.information13 = hr_api.g_varchar2) then
794: p_rec.information13 :=
795: per_cel_shd.g_old_rec.information13;
791: per_cel_shd.g_old_rec.information12;
792: End If;
793: If (p_rec.information13 = hr_api.g_varchar2) then
794: p_rec.information13 :=
795: per_cel_shd.g_old_rec.information13;
796: End If;
797: If (p_rec.information14 = hr_api.g_varchar2) then
798: p_rec.information14 :=
799: per_cel_shd.g_old_rec.information14;
795: per_cel_shd.g_old_rec.information13;
796: End If;
797: If (p_rec.information14 = hr_api.g_varchar2) then
798: p_rec.information14 :=
799: per_cel_shd.g_old_rec.information14;
800: End If;
801: If (p_rec.information15 = hr_api.g_varchar2) then
802: p_rec.information15 :=
803: per_cel_shd.g_old_rec.information15;
799: per_cel_shd.g_old_rec.information14;
800: End If;
801: If (p_rec.information15 = hr_api.g_varchar2) then
802: p_rec.information15 :=
803: per_cel_shd.g_old_rec.information15;
804: End If;
805: If (p_rec.information16 = hr_api.g_varchar2) then
806: p_rec.information16 :=
807: per_cel_shd.g_old_rec.information16;
803: per_cel_shd.g_old_rec.information15;
804: End If;
805: If (p_rec.information16 = hr_api.g_varchar2) then
806: p_rec.information16 :=
807: per_cel_shd.g_old_rec.information16;
808: End If;
809: If (p_rec.information17 = hr_api.g_varchar2) then
810: p_rec.information17 :=
811: per_cel_shd.g_old_rec.information17;
807: per_cel_shd.g_old_rec.information16;
808: End If;
809: If (p_rec.information17 = hr_api.g_varchar2) then
810: p_rec.information17 :=
811: per_cel_shd.g_old_rec.information17;
812: End If;
813: If (p_rec.information18 = hr_api.g_varchar2) then
814: p_rec.information18 :=
815: per_cel_shd.g_old_rec.information18;
811: per_cel_shd.g_old_rec.information17;
812: End If;
813: If (p_rec.information18 = hr_api.g_varchar2) then
814: p_rec.information18 :=
815: per_cel_shd.g_old_rec.information18;
816: End If;
817: If (p_rec.information19 = hr_api.g_varchar2) then
818: p_rec.information19 :=
819: per_cel_shd.g_old_rec.information19;
815: per_cel_shd.g_old_rec.information18;
816: End If;
817: If (p_rec.information19 = hr_api.g_varchar2) then
818: p_rec.information19 :=
819: per_cel_shd.g_old_rec.information19;
820: End If;
821: If (p_rec.information20 = hr_api.g_varchar2) then
822: p_rec.information20 :=
823: per_cel_shd.g_old_rec.information20;
819: per_cel_shd.g_old_rec.information19;
820: End If;
821: If (p_rec.information20 = hr_api.g_varchar2) then
822: p_rec.information20 :=
823: per_cel_shd.g_old_rec.information20;
824: End If;
825: If (p_rec.achieved_date = hr_api.g_date) then
826: p_rec.achieved_date :=
827: per_cel_shd.g_old_rec.achieved_date;
823: per_cel_shd.g_old_rec.information20;
824: End If;
825: If (p_rec.achieved_date = hr_api.g_date) then
826: p_rec.achieved_date :=
827: per_cel_shd.g_old_rec.achieved_date;
828: End If;
829: If (p_rec.appr_line_score = hr_api.g_number) then
830: p_rec.appr_line_score :=
831: per_cel_shd.g_old_rec.appr_line_score;
827: per_cel_shd.g_old_rec.achieved_date;
828: End If;
829: If (p_rec.appr_line_score = hr_api.g_number) then
830: p_rec.appr_line_score :=
831: per_cel_shd.g_old_rec.appr_line_score;
832: End If;
833: --
834: hr_utility.set_location(' Leaving:'||l_proc, 10);
835: --
839: -- |---------------------------------< upd >----------------------------------|
840: -- ----------------------------------------------------------------------------
841: Procedure upd
842: (
843: p_rec in out nocopy per_cel_shd.g_rec_type,
844: p_validate in boolean default false,
845: p_effective_date in date
846: ) is
847: --
860: End If;
861: --
862: -- We must lock the row which we need to update.
863: --
864: per_cel_shd.lck
865: (
866: p_rec.competence_element_id,
867: p_rec.object_version_number
868: );
989: p_achieved_date in date default hr_api.g_date,
990: p_appr_line_score in number default hr_api.g_number
991: ) is
992: --
993: l_rec per_cel_shd.g_rec_type;
994: l_proc varchar2(72) := g_package||'upd';
995: --
996: Begin
997: hr_utility.set_location('Entering:'||l_proc, 5);
999: -- Call conversion function to turn arguments into the
1000: -- l_rec structure.
1001: --
1002: l_rec :=
1003: per_cel_shd.convert_args
1004: (
1005: p_competence_element_id,
1006: p_object_version_number,
1007: hr_api.g_varchar2,