eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_COMPETENCE_ELEMENT_SWI dependencies on PER_CEL_SHD

Line 702: per_cel_shd.lck

698: (p_constant_value => p_validate);
699: --
700: -- look to see if the competence_id has been changed
701: --
702: per_cel_shd.lck
703: (p_competence_element_id => p_competence_element_id
704: ,p_object_version_number => p_object_version_number
705: );
706: --

Line 708: and per_cel_shd.g_old_rec.competence_id<>p_competence_id then

704: ,p_object_version_number => p_object_version_number
705: );
706: --
707: if p_competence_id<>hr_api.g_number
708: and per_cel_shd.g_old_rec.competence_id<>p_competence_id then
709: --
710: -- the competence has been updated, so delete the old competence element
711: -- and insert a new one.
712: --

Line 727: ,p_type => per_cel_shd.g_old_rec.type

723: hr_competence_element_api.create_competence_element
724: (p_validate => false
725: ,p_competence_element_id => l_competence_element_id
726: ,p_object_version_number => p_object_version_number
727: ,p_type => per_cel_shd.g_old_rec.type
728: ,p_business_group_id => per_cel_shd.g_old_rec.business_group_id
729: ,p_enterprise_id => per_cel_shd.g_old_rec.enterprise_id
730: ,p_competence_id => get_non_gmisc_value( per_cel_shd.g_old_rec.competence_id,p_competence_id)
731: ,p_proficiency_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.proficiency_level_id,p_proficiency_level_id)

Line 728: ,p_business_group_id => per_cel_shd.g_old_rec.business_group_id

724: (p_validate => false
725: ,p_competence_element_id => l_competence_element_id
726: ,p_object_version_number => p_object_version_number
727: ,p_type => per_cel_shd.g_old_rec.type
728: ,p_business_group_id => per_cel_shd.g_old_rec.business_group_id
729: ,p_enterprise_id => per_cel_shd.g_old_rec.enterprise_id
730: ,p_competence_id => get_non_gmisc_value( per_cel_shd.g_old_rec.competence_id,p_competence_id)
731: ,p_proficiency_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.proficiency_level_id,p_proficiency_level_id)
732: ,p_high_proficiency_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.high_proficiency_level_id,p_high_proficiency_level_id)

Line 729: ,p_enterprise_id => per_cel_shd.g_old_rec.enterprise_id

725: ,p_competence_element_id => l_competence_element_id
726: ,p_object_version_number => p_object_version_number
727: ,p_type => per_cel_shd.g_old_rec.type
728: ,p_business_group_id => per_cel_shd.g_old_rec.business_group_id
729: ,p_enterprise_id => per_cel_shd.g_old_rec.enterprise_id
730: ,p_competence_id => get_non_gmisc_value( per_cel_shd.g_old_rec.competence_id,p_competence_id)
731: ,p_proficiency_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.proficiency_level_id,p_proficiency_level_id)
732: ,p_high_proficiency_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.high_proficiency_level_id,p_high_proficiency_level_id)
733: ,p_weighting_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.weighting_level_id,p_weighting_level_id)

Line 730: ,p_competence_id => get_non_gmisc_value( per_cel_shd.g_old_rec.competence_id,p_competence_id)

726: ,p_object_version_number => p_object_version_number
727: ,p_type => per_cel_shd.g_old_rec.type
728: ,p_business_group_id => per_cel_shd.g_old_rec.business_group_id
729: ,p_enterprise_id => per_cel_shd.g_old_rec.enterprise_id
730: ,p_competence_id => get_non_gmisc_value( per_cel_shd.g_old_rec.competence_id,p_competence_id)
731: ,p_proficiency_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.proficiency_level_id,p_proficiency_level_id)
732: ,p_high_proficiency_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.high_proficiency_level_id,p_high_proficiency_level_id)
733: ,p_weighting_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.weighting_level_id,p_weighting_level_id)
734: ,p_rating_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.rating_level_id,p_rating_level_id)

Line 731: ,p_proficiency_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.proficiency_level_id,p_proficiency_level_id)

727: ,p_type => per_cel_shd.g_old_rec.type
728: ,p_business_group_id => per_cel_shd.g_old_rec.business_group_id
729: ,p_enterprise_id => per_cel_shd.g_old_rec.enterprise_id
730: ,p_competence_id => get_non_gmisc_value( per_cel_shd.g_old_rec.competence_id,p_competence_id)
731: ,p_proficiency_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.proficiency_level_id,p_proficiency_level_id)
732: ,p_high_proficiency_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.high_proficiency_level_id,p_high_proficiency_level_id)
733: ,p_weighting_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.weighting_level_id,p_weighting_level_id)
734: ,p_rating_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.rating_level_id,p_rating_level_id)
735: ,p_person_id => per_cel_shd.g_old_rec.person_id

Line 732: ,p_high_proficiency_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.high_proficiency_level_id,p_high_proficiency_level_id)

728: ,p_business_group_id => per_cel_shd.g_old_rec.business_group_id
729: ,p_enterprise_id => per_cel_shd.g_old_rec.enterprise_id
730: ,p_competence_id => get_non_gmisc_value( per_cel_shd.g_old_rec.competence_id,p_competence_id)
731: ,p_proficiency_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.proficiency_level_id,p_proficiency_level_id)
732: ,p_high_proficiency_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.high_proficiency_level_id,p_high_proficiency_level_id)
733: ,p_weighting_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.weighting_level_id,p_weighting_level_id)
734: ,p_rating_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.rating_level_id,p_rating_level_id)
735: ,p_person_id => per_cel_shd.g_old_rec.person_id
736: ,p_job_id => per_cel_shd.g_old_rec.job_id

Line 733: ,p_weighting_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.weighting_level_id,p_weighting_level_id)

729: ,p_enterprise_id => per_cel_shd.g_old_rec.enterprise_id
730: ,p_competence_id => get_non_gmisc_value( per_cel_shd.g_old_rec.competence_id,p_competence_id)
731: ,p_proficiency_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.proficiency_level_id,p_proficiency_level_id)
732: ,p_high_proficiency_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.high_proficiency_level_id,p_high_proficiency_level_id)
733: ,p_weighting_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.weighting_level_id,p_weighting_level_id)
734: ,p_rating_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.rating_level_id,p_rating_level_id)
735: ,p_person_id => per_cel_shd.g_old_rec.person_id
736: ,p_job_id => per_cel_shd.g_old_rec.job_id
737: ,p_valid_grade_id => per_cel_shd.g_old_rec.valid_grade_id

Line 734: ,p_rating_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.rating_level_id,p_rating_level_id)

730: ,p_competence_id => get_non_gmisc_value( per_cel_shd.g_old_rec.competence_id,p_competence_id)
731: ,p_proficiency_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.proficiency_level_id,p_proficiency_level_id)
732: ,p_high_proficiency_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.high_proficiency_level_id,p_high_proficiency_level_id)
733: ,p_weighting_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.weighting_level_id,p_weighting_level_id)
734: ,p_rating_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.rating_level_id,p_rating_level_id)
735: ,p_person_id => per_cel_shd.g_old_rec.person_id
736: ,p_job_id => per_cel_shd.g_old_rec.job_id
737: ,p_valid_grade_id => per_cel_shd.g_old_rec.valid_grade_id
738: ,p_position_id => per_cel_shd.g_old_rec.position_id

Line 735: ,p_person_id => per_cel_shd.g_old_rec.person_id

731: ,p_proficiency_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.proficiency_level_id,p_proficiency_level_id)
732: ,p_high_proficiency_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.high_proficiency_level_id,p_high_proficiency_level_id)
733: ,p_weighting_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.weighting_level_id,p_weighting_level_id)
734: ,p_rating_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.rating_level_id,p_rating_level_id)
735: ,p_person_id => per_cel_shd.g_old_rec.person_id
736: ,p_job_id => per_cel_shd.g_old_rec.job_id
737: ,p_valid_grade_id => per_cel_shd.g_old_rec.valid_grade_id
738: ,p_position_id => per_cel_shd.g_old_rec.position_id
739: ,p_organization_id => per_cel_shd.g_old_rec.organization_id

Line 736: ,p_job_id => per_cel_shd.g_old_rec.job_id

732: ,p_high_proficiency_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.high_proficiency_level_id,p_high_proficiency_level_id)
733: ,p_weighting_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.weighting_level_id,p_weighting_level_id)
734: ,p_rating_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.rating_level_id,p_rating_level_id)
735: ,p_person_id => per_cel_shd.g_old_rec.person_id
736: ,p_job_id => per_cel_shd.g_old_rec.job_id
737: ,p_valid_grade_id => per_cel_shd.g_old_rec.valid_grade_id
738: ,p_position_id => per_cel_shd.g_old_rec.position_id
739: ,p_organization_id => per_cel_shd.g_old_rec.organization_id
740: ,p_parent_competence_element_id => per_cel_shd.g_old_rec.parent_competence_element_id

Line 737: ,p_valid_grade_id => per_cel_shd.g_old_rec.valid_grade_id

733: ,p_weighting_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.weighting_level_id,p_weighting_level_id)
734: ,p_rating_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.rating_level_id,p_rating_level_id)
735: ,p_person_id => per_cel_shd.g_old_rec.person_id
736: ,p_job_id => per_cel_shd.g_old_rec.job_id
737: ,p_valid_grade_id => per_cel_shd.g_old_rec.valid_grade_id
738: ,p_position_id => per_cel_shd.g_old_rec.position_id
739: ,p_organization_id => per_cel_shd.g_old_rec.organization_id
740: ,p_parent_competence_element_id => per_cel_shd.g_old_rec.parent_competence_element_id
741: ,p_activity_version_id => per_cel_shd.g_old_rec.activity_version_id

Line 738: ,p_position_id => per_cel_shd.g_old_rec.position_id

734: ,p_rating_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.rating_level_id,p_rating_level_id)
735: ,p_person_id => per_cel_shd.g_old_rec.person_id
736: ,p_job_id => per_cel_shd.g_old_rec.job_id
737: ,p_valid_grade_id => per_cel_shd.g_old_rec.valid_grade_id
738: ,p_position_id => per_cel_shd.g_old_rec.position_id
739: ,p_organization_id => per_cel_shd.g_old_rec.organization_id
740: ,p_parent_competence_element_id => per_cel_shd.g_old_rec.parent_competence_element_id
741: ,p_activity_version_id => per_cel_shd.g_old_rec.activity_version_id
742: ,p_assessment_id => per_cel_shd.g_old_rec.assessment_id

Line 739: ,p_organization_id => per_cel_shd.g_old_rec.organization_id

735: ,p_person_id => per_cel_shd.g_old_rec.person_id
736: ,p_job_id => per_cel_shd.g_old_rec.job_id
737: ,p_valid_grade_id => per_cel_shd.g_old_rec.valid_grade_id
738: ,p_position_id => per_cel_shd.g_old_rec.position_id
739: ,p_organization_id => per_cel_shd.g_old_rec.organization_id
740: ,p_parent_competence_element_id => per_cel_shd.g_old_rec.parent_competence_element_id
741: ,p_activity_version_id => per_cel_shd.g_old_rec.activity_version_id
742: ,p_assessment_id => per_cel_shd.g_old_rec.assessment_id
743: ,p_assessment_type_id => per_cel_shd.g_old_rec.assessment_type_id

Line 740: ,p_parent_competence_element_id => per_cel_shd.g_old_rec.parent_competence_element_id

736: ,p_job_id => per_cel_shd.g_old_rec.job_id
737: ,p_valid_grade_id => per_cel_shd.g_old_rec.valid_grade_id
738: ,p_position_id => per_cel_shd.g_old_rec.position_id
739: ,p_organization_id => per_cel_shd.g_old_rec.organization_id
740: ,p_parent_competence_element_id => per_cel_shd.g_old_rec.parent_competence_element_id
741: ,p_activity_version_id => per_cel_shd.g_old_rec.activity_version_id
742: ,p_assessment_id => per_cel_shd.g_old_rec.assessment_id
743: ,p_assessment_type_id => per_cel_shd.g_old_rec.assessment_type_id
744: ,p_mandatory => get_non_gmisc_value( per_cel_shd.g_old_rec.mandatory,p_mandatory)

Line 741: ,p_activity_version_id => per_cel_shd.g_old_rec.activity_version_id

737: ,p_valid_grade_id => per_cel_shd.g_old_rec.valid_grade_id
738: ,p_position_id => per_cel_shd.g_old_rec.position_id
739: ,p_organization_id => per_cel_shd.g_old_rec.organization_id
740: ,p_parent_competence_element_id => per_cel_shd.g_old_rec.parent_competence_element_id
741: ,p_activity_version_id => per_cel_shd.g_old_rec.activity_version_id
742: ,p_assessment_id => per_cel_shd.g_old_rec.assessment_id
743: ,p_assessment_type_id => per_cel_shd.g_old_rec.assessment_type_id
744: ,p_mandatory => get_non_gmisc_value( per_cel_shd.g_old_rec.mandatory,p_mandatory)
745: ,p_effective_date_from => get_non_gmisc_value( per_cel_shd.g_old_rec.effective_date_from, p_effective_date_from)

Line 742: ,p_assessment_id => per_cel_shd.g_old_rec.assessment_id

738: ,p_position_id => per_cel_shd.g_old_rec.position_id
739: ,p_organization_id => per_cel_shd.g_old_rec.organization_id
740: ,p_parent_competence_element_id => per_cel_shd.g_old_rec.parent_competence_element_id
741: ,p_activity_version_id => per_cel_shd.g_old_rec.activity_version_id
742: ,p_assessment_id => per_cel_shd.g_old_rec.assessment_id
743: ,p_assessment_type_id => per_cel_shd.g_old_rec.assessment_type_id
744: ,p_mandatory => get_non_gmisc_value( per_cel_shd.g_old_rec.mandatory,p_mandatory)
745: ,p_effective_date_from => get_non_gmisc_value( per_cel_shd.g_old_rec.effective_date_from, p_effective_date_from)
746: ,p_effective_date_to => get_non_gmisc_value( per_cel_shd.g_old_rec.effective_date_to, p_effective_date_to)

Line 743: ,p_assessment_type_id => per_cel_shd.g_old_rec.assessment_type_id

739: ,p_organization_id => per_cel_shd.g_old_rec.organization_id
740: ,p_parent_competence_element_id => per_cel_shd.g_old_rec.parent_competence_element_id
741: ,p_activity_version_id => per_cel_shd.g_old_rec.activity_version_id
742: ,p_assessment_id => per_cel_shd.g_old_rec.assessment_id
743: ,p_assessment_type_id => per_cel_shd.g_old_rec.assessment_type_id
744: ,p_mandatory => get_non_gmisc_value( per_cel_shd.g_old_rec.mandatory,p_mandatory)
745: ,p_effective_date_from => get_non_gmisc_value( per_cel_shd.g_old_rec.effective_date_from, p_effective_date_from)
746: ,p_effective_date_to => get_non_gmisc_value( per_cel_shd.g_old_rec.effective_date_to, p_effective_date_to)
747: ,p_group_competence_type => get_non_gmisc_value( per_cel_shd.g_old_rec.group_competence_type,p_group_competence_type)

Line 744: ,p_mandatory => get_non_gmisc_value( per_cel_shd.g_old_rec.mandatory,p_mandatory)

740: ,p_parent_competence_element_id => per_cel_shd.g_old_rec.parent_competence_element_id
741: ,p_activity_version_id => per_cel_shd.g_old_rec.activity_version_id
742: ,p_assessment_id => per_cel_shd.g_old_rec.assessment_id
743: ,p_assessment_type_id => per_cel_shd.g_old_rec.assessment_type_id
744: ,p_mandatory => get_non_gmisc_value( per_cel_shd.g_old_rec.mandatory,p_mandatory)
745: ,p_effective_date_from => get_non_gmisc_value( per_cel_shd.g_old_rec.effective_date_from, p_effective_date_from)
746: ,p_effective_date_to => get_non_gmisc_value( per_cel_shd.g_old_rec.effective_date_to, p_effective_date_to)
747: ,p_group_competence_type => get_non_gmisc_value( per_cel_shd.g_old_rec.group_competence_type,p_group_competence_type)
748: ,p_competence_type => get_non_gmisc_value( per_cel_shd.g_old_rec.competence_type,p_competence_type)

Line 745: ,p_effective_date_from => get_non_gmisc_value( per_cel_shd.g_old_rec.effective_date_from, p_effective_date_from)

741: ,p_activity_version_id => per_cel_shd.g_old_rec.activity_version_id
742: ,p_assessment_id => per_cel_shd.g_old_rec.assessment_id
743: ,p_assessment_type_id => per_cel_shd.g_old_rec.assessment_type_id
744: ,p_mandatory => get_non_gmisc_value( per_cel_shd.g_old_rec.mandatory,p_mandatory)
745: ,p_effective_date_from => get_non_gmisc_value( per_cel_shd.g_old_rec.effective_date_from, p_effective_date_from)
746: ,p_effective_date_to => get_non_gmisc_value( per_cel_shd.g_old_rec.effective_date_to, p_effective_date_to)
747: ,p_group_competence_type => get_non_gmisc_value( per_cel_shd.g_old_rec.group_competence_type,p_group_competence_type)
748: ,p_competence_type => get_non_gmisc_value( per_cel_shd.g_old_rec.competence_type,p_competence_type)
749: ,p_normal_elapse_duration => get_non_gmisc_value( per_cel_shd.g_old_rec.normal_elapse_duration,p_normal_elapse_duration )

Line 746: ,p_effective_date_to => get_non_gmisc_value( per_cel_shd.g_old_rec.effective_date_to, p_effective_date_to)

742: ,p_assessment_id => per_cel_shd.g_old_rec.assessment_id
743: ,p_assessment_type_id => per_cel_shd.g_old_rec.assessment_type_id
744: ,p_mandatory => get_non_gmisc_value( per_cel_shd.g_old_rec.mandatory,p_mandatory)
745: ,p_effective_date_from => get_non_gmisc_value( per_cel_shd.g_old_rec.effective_date_from, p_effective_date_from)
746: ,p_effective_date_to => get_non_gmisc_value( per_cel_shd.g_old_rec.effective_date_to, p_effective_date_to)
747: ,p_group_competence_type => get_non_gmisc_value( per_cel_shd.g_old_rec.group_competence_type,p_group_competence_type)
748: ,p_competence_type => get_non_gmisc_value( per_cel_shd.g_old_rec.competence_type,p_competence_type)
749: ,p_normal_elapse_duration => get_non_gmisc_value( per_cel_shd.g_old_rec.normal_elapse_duration,p_normal_elapse_duration )
750: ,p_normal_elapse_duration_unit => get_non_gmisc_value( per_cel_shd.g_old_rec.normal_elapse_duration_unit,p_normal_elapse_duration_unit)

Line 747: ,p_group_competence_type => get_non_gmisc_value( per_cel_shd.g_old_rec.group_competence_type,p_group_competence_type)

743: ,p_assessment_type_id => per_cel_shd.g_old_rec.assessment_type_id
744: ,p_mandatory => get_non_gmisc_value( per_cel_shd.g_old_rec.mandatory,p_mandatory)
745: ,p_effective_date_from => get_non_gmisc_value( per_cel_shd.g_old_rec.effective_date_from, p_effective_date_from)
746: ,p_effective_date_to => get_non_gmisc_value( per_cel_shd.g_old_rec.effective_date_to, p_effective_date_to)
747: ,p_group_competence_type => get_non_gmisc_value( per_cel_shd.g_old_rec.group_competence_type,p_group_competence_type)
748: ,p_competence_type => get_non_gmisc_value( per_cel_shd.g_old_rec.competence_type,p_competence_type)
749: ,p_normal_elapse_duration => get_non_gmisc_value( per_cel_shd.g_old_rec.normal_elapse_duration,p_normal_elapse_duration )
750: ,p_normal_elapse_duration_unit => get_non_gmisc_value( per_cel_shd.g_old_rec.normal_elapse_duration_unit,p_normal_elapse_duration_unit)
751: ,p_sequence_number => get_non_gmisc_value( per_cel_shd.g_old_rec.sequence_number,p_sequence_number )

Line 748: ,p_competence_type => get_non_gmisc_value( per_cel_shd.g_old_rec.competence_type,p_competence_type)

744: ,p_mandatory => get_non_gmisc_value( per_cel_shd.g_old_rec.mandatory,p_mandatory)
745: ,p_effective_date_from => get_non_gmisc_value( per_cel_shd.g_old_rec.effective_date_from, p_effective_date_from)
746: ,p_effective_date_to => get_non_gmisc_value( per_cel_shd.g_old_rec.effective_date_to, p_effective_date_to)
747: ,p_group_competence_type => get_non_gmisc_value( per_cel_shd.g_old_rec.group_competence_type,p_group_competence_type)
748: ,p_competence_type => get_non_gmisc_value( per_cel_shd.g_old_rec.competence_type,p_competence_type)
749: ,p_normal_elapse_duration => get_non_gmisc_value( per_cel_shd.g_old_rec.normal_elapse_duration,p_normal_elapse_duration )
750: ,p_normal_elapse_duration_unit => get_non_gmisc_value( per_cel_shd.g_old_rec.normal_elapse_duration_unit,p_normal_elapse_duration_unit)
751: ,p_sequence_number => get_non_gmisc_value( per_cel_shd.g_old_rec.sequence_number,p_sequence_number )
752: ,p_source_of_proficiency_level => get_non_gmisc_value( per_cel_shd.g_old_rec.source_of_proficiency_level, p_source_of_proficiency_level)

Line 749: ,p_normal_elapse_duration => get_non_gmisc_value( per_cel_shd.g_old_rec.normal_elapse_duration,p_normal_elapse_duration )

745: ,p_effective_date_from => get_non_gmisc_value( per_cel_shd.g_old_rec.effective_date_from, p_effective_date_from)
746: ,p_effective_date_to => get_non_gmisc_value( per_cel_shd.g_old_rec.effective_date_to, p_effective_date_to)
747: ,p_group_competence_type => get_non_gmisc_value( per_cel_shd.g_old_rec.group_competence_type,p_group_competence_type)
748: ,p_competence_type => get_non_gmisc_value( per_cel_shd.g_old_rec.competence_type,p_competence_type)
749: ,p_normal_elapse_duration => get_non_gmisc_value( per_cel_shd.g_old_rec.normal_elapse_duration,p_normal_elapse_duration )
750: ,p_normal_elapse_duration_unit => get_non_gmisc_value( per_cel_shd.g_old_rec.normal_elapse_duration_unit,p_normal_elapse_duration_unit)
751: ,p_sequence_number => get_non_gmisc_value( per_cel_shd.g_old_rec.sequence_number,p_sequence_number )
752: ,p_source_of_proficiency_level => get_non_gmisc_value( per_cel_shd.g_old_rec.source_of_proficiency_level, p_source_of_proficiency_level)
753: ,p_line_score => get_non_gmisc_value( per_cel_shd.g_old_rec.line_score,p_line_score )

Line 750: ,p_normal_elapse_duration_unit => get_non_gmisc_value( per_cel_shd.g_old_rec.normal_elapse_duration_unit,p_normal_elapse_duration_unit)

746: ,p_effective_date_to => get_non_gmisc_value( per_cel_shd.g_old_rec.effective_date_to, p_effective_date_to)
747: ,p_group_competence_type => get_non_gmisc_value( per_cel_shd.g_old_rec.group_competence_type,p_group_competence_type)
748: ,p_competence_type => get_non_gmisc_value( per_cel_shd.g_old_rec.competence_type,p_competence_type)
749: ,p_normal_elapse_duration => get_non_gmisc_value( per_cel_shd.g_old_rec.normal_elapse_duration,p_normal_elapse_duration )
750: ,p_normal_elapse_duration_unit => get_non_gmisc_value( per_cel_shd.g_old_rec.normal_elapse_duration_unit,p_normal_elapse_duration_unit)
751: ,p_sequence_number => get_non_gmisc_value( per_cel_shd.g_old_rec.sequence_number,p_sequence_number )
752: ,p_source_of_proficiency_level => get_non_gmisc_value( per_cel_shd.g_old_rec.source_of_proficiency_level, p_source_of_proficiency_level)
753: ,p_line_score => get_non_gmisc_value( per_cel_shd.g_old_rec.line_score,p_line_score )
754: ,p_certification_date => get_non_gmisc_value( per_cel_shd.g_old_rec.certification_date, p_certification_date)

Line 751: ,p_sequence_number => get_non_gmisc_value( per_cel_shd.g_old_rec.sequence_number,p_sequence_number )

747: ,p_group_competence_type => get_non_gmisc_value( per_cel_shd.g_old_rec.group_competence_type,p_group_competence_type)
748: ,p_competence_type => get_non_gmisc_value( per_cel_shd.g_old_rec.competence_type,p_competence_type)
749: ,p_normal_elapse_duration => get_non_gmisc_value( per_cel_shd.g_old_rec.normal_elapse_duration,p_normal_elapse_duration )
750: ,p_normal_elapse_duration_unit => get_non_gmisc_value( per_cel_shd.g_old_rec.normal_elapse_duration_unit,p_normal_elapse_duration_unit)
751: ,p_sequence_number => get_non_gmisc_value( per_cel_shd.g_old_rec.sequence_number,p_sequence_number )
752: ,p_source_of_proficiency_level => get_non_gmisc_value( per_cel_shd.g_old_rec.source_of_proficiency_level, p_source_of_proficiency_level)
753: ,p_line_score => get_non_gmisc_value( per_cel_shd.g_old_rec.line_score,p_line_score )
754: ,p_certification_date => get_non_gmisc_value( per_cel_shd.g_old_rec.certification_date, p_certification_date)
755: ,p_certification_method => get_non_gmisc_value( per_cel_shd.g_old_rec.certification_method, p_certification_method)

Line 752: ,p_source_of_proficiency_level => get_non_gmisc_value( per_cel_shd.g_old_rec.source_of_proficiency_level, p_source_of_proficiency_level)

748: ,p_competence_type => get_non_gmisc_value( per_cel_shd.g_old_rec.competence_type,p_competence_type)
749: ,p_normal_elapse_duration => get_non_gmisc_value( per_cel_shd.g_old_rec.normal_elapse_duration,p_normal_elapse_duration )
750: ,p_normal_elapse_duration_unit => get_non_gmisc_value( per_cel_shd.g_old_rec.normal_elapse_duration_unit,p_normal_elapse_duration_unit)
751: ,p_sequence_number => get_non_gmisc_value( per_cel_shd.g_old_rec.sequence_number,p_sequence_number )
752: ,p_source_of_proficiency_level => get_non_gmisc_value( per_cel_shd.g_old_rec.source_of_proficiency_level, p_source_of_proficiency_level)
753: ,p_line_score => get_non_gmisc_value( per_cel_shd.g_old_rec.line_score,p_line_score )
754: ,p_certification_date => get_non_gmisc_value( per_cel_shd.g_old_rec.certification_date, p_certification_date)
755: ,p_certification_method => get_non_gmisc_value( per_cel_shd.g_old_rec.certification_method, p_certification_method)
756: ,p_next_certification_date => get_non_gmisc_value( per_cel_shd.g_old_rec.next_certification_date, p_next_certification_date)

Line 753: ,p_line_score => get_non_gmisc_value( per_cel_shd.g_old_rec.line_score,p_line_score )

749: ,p_normal_elapse_duration => get_non_gmisc_value( per_cel_shd.g_old_rec.normal_elapse_duration,p_normal_elapse_duration )
750: ,p_normal_elapse_duration_unit => get_non_gmisc_value( per_cel_shd.g_old_rec.normal_elapse_duration_unit,p_normal_elapse_duration_unit)
751: ,p_sequence_number => get_non_gmisc_value( per_cel_shd.g_old_rec.sequence_number,p_sequence_number )
752: ,p_source_of_proficiency_level => get_non_gmisc_value( per_cel_shd.g_old_rec.source_of_proficiency_level, p_source_of_proficiency_level)
753: ,p_line_score => get_non_gmisc_value( per_cel_shd.g_old_rec.line_score,p_line_score )
754: ,p_certification_date => get_non_gmisc_value( per_cel_shd.g_old_rec.certification_date, p_certification_date)
755: ,p_certification_method => get_non_gmisc_value( per_cel_shd.g_old_rec.certification_method, p_certification_method)
756: ,p_next_certification_date => get_non_gmisc_value( per_cel_shd.g_old_rec.next_certification_date, p_next_certification_date)
757: ,p_comments => get_non_gmisc_value( per_cel_shd.g_old_rec.comments, p_comments)

Line 754: ,p_certification_date => get_non_gmisc_value( per_cel_shd.g_old_rec.certification_date, p_certification_date)

750: ,p_normal_elapse_duration_unit => get_non_gmisc_value( per_cel_shd.g_old_rec.normal_elapse_duration_unit,p_normal_elapse_duration_unit)
751: ,p_sequence_number => get_non_gmisc_value( per_cel_shd.g_old_rec.sequence_number,p_sequence_number )
752: ,p_source_of_proficiency_level => get_non_gmisc_value( per_cel_shd.g_old_rec.source_of_proficiency_level, p_source_of_proficiency_level)
753: ,p_line_score => get_non_gmisc_value( per_cel_shd.g_old_rec.line_score,p_line_score )
754: ,p_certification_date => get_non_gmisc_value( per_cel_shd.g_old_rec.certification_date, p_certification_date)
755: ,p_certification_method => get_non_gmisc_value( per_cel_shd.g_old_rec.certification_method, p_certification_method)
756: ,p_next_certification_date => get_non_gmisc_value( per_cel_shd.g_old_rec.next_certification_date, p_next_certification_date)
757: ,p_comments => get_non_gmisc_value( per_cel_shd.g_old_rec.comments, p_comments)
758: ,p_attribute_category => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute_category, p_attribute_category)

Line 755: ,p_certification_method => get_non_gmisc_value( per_cel_shd.g_old_rec.certification_method, p_certification_method)

751: ,p_sequence_number => get_non_gmisc_value( per_cel_shd.g_old_rec.sequence_number,p_sequence_number )
752: ,p_source_of_proficiency_level => get_non_gmisc_value( per_cel_shd.g_old_rec.source_of_proficiency_level, p_source_of_proficiency_level)
753: ,p_line_score => get_non_gmisc_value( per_cel_shd.g_old_rec.line_score,p_line_score )
754: ,p_certification_date => get_non_gmisc_value( per_cel_shd.g_old_rec.certification_date, p_certification_date)
755: ,p_certification_method => get_non_gmisc_value( per_cel_shd.g_old_rec.certification_method, p_certification_method)
756: ,p_next_certification_date => get_non_gmisc_value( per_cel_shd.g_old_rec.next_certification_date, p_next_certification_date)
757: ,p_comments => get_non_gmisc_value( per_cel_shd.g_old_rec.comments, p_comments)
758: ,p_attribute_category => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute_category, p_attribute_category)
759: ,p_attribute1 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute1, p_attribute1)

Line 756: ,p_next_certification_date => get_non_gmisc_value( per_cel_shd.g_old_rec.next_certification_date, p_next_certification_date)

752: ,p_source_of_proficiency_level => get_non_gmisc_value( per_cel_shd.g_old_rec.source_of_proficiency_level, p_source_of_proficiency_level)
753: ,p_line_score => get_non_gmisc_value( per_cel_shd.g_old_rec.line_score,p_line_score )
754: ,p_certification_date => get_non_gmisc_value( per_cel_shd.g_old_rec.certification_date, p_certification_date)
755: ,p_certification_method => get_non_gmisc_value( per_cel_shd.g_old_rec.certification_method, p_certification_method)
756: ,p_next_certification_date => get_non_gmisc_value( per_cel_shd.g_old_rec.next_certification_date, p_next_certification_date)
757: ,p_comments => get_non_gmisc_value( per_cel_shd.g_old_rec.comments, p_comments)
758: ,p_attribute_category => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute_category, p_attribute_category)
759: ,p_attribute1 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute1, p_attribute1)
760: ,p_attribute2 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute2, p_attribute2)

Line 757: ,p_comments => get_non_gmisc_value( per_cel_shd.g_old_rec.comments, p_comments)

753: ,p_line_score => get_non_gmisc_value( per_cel_shd.g_old_rec.line_score,p_line_score )
754: ,p_certification_date => get_non_gmisc_value( per_cel_shd.g_old_rec.certification_date, p_certification_date)
755: ,p_certification_method => get_non_gmisc_value( per_cel_shd.g_old_rec.certification_method, p_certification_method)
756: ,p_next_certification_date => get_non_gmisc_value( per_cel_shd.g_old_rec.next_certification_date, p_next_certification_date)
757: ,p_comments => get_non_gmisc_value( per_cel_shd.g_old_rec.comments, p_comments)
758: ,p_attribute_category => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute_category, p_attribute_category)
759: ,p_attribute1 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute1, p_attribute1)
760: ,p_attribute2 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute2, p_attribute2)
761: ,p_attribute3 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute3, p_attribute3)

Line 758: ,p_attribute_category => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute_category, p_attribute_category)

754: ,p_certification_date => get_non_gmisc_value( per_cel_shd.g_old_rec.certification_date, p_certification_date)
755: ,p_certification_method => get_non_gmisc_value( per_cel_shd.g_old_rec.certification_method, p_certification_method)
756: ,p_next_certification_date => get_non_gmisc_value( per_cel_shd.g_old_rec.next_certification_date, p_next_certification_date)
757: ,p_comments => get_non_gmisc_value( per_cel_shd.g_old_rec.comments, p_comments)
758: ,p_attribute_category => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute_category, p_attribute_category)
759: ,p_attribute1 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute1, p_attribute1)
760: ,p_attribute2 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute2, p_attribute2)
761: ,p_attribute3 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute3, p_attribute3)
762: ,p_attribute4 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute4, p_attribute4)

Line 759: ,p_attribute1 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute1, p_attribute1)

755: ,p_certification_method => get_non_gmisc_value( per_cel_shd.g_old_rec.certification_method, p_certification_method)
756: ,p_next_certification_date => get_non_gmisc_value( per_cel_shd.g_old_rec.next_certification_date, p_next_certification_date)
757: ,p_comments => get_non_gmisc_value( per_cel_shd.g_old_rec.comments, p_comments)
758: ,p_attribute_category => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute_category, p_attribute_category)
759: ,p_attribute1 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute1, p_attribute1)
760: ,p_attribute2 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute2, p_attribute2)
761: ,p_attribute3 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute3, p_attribute3)
762: ,p_attribute4 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute4, p_attribute4)
763: ,p_attribute5 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute5, p_attribute5)

Line 760: ,p_attribute2 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute2, p_attribute2)

756: ,p_next_certification_date => get_non_gmisc_value( per_cel_shd.g_old_rec.next_certification_date, p_next_certification_date)
757: ,p_comments => get_non_gmisc_value( per_cel_shd.g_old_rec.comments, p_comments)
758: ,p_attribute_category => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute_category, p_attribute_category)
759: ,p_attribute1 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute1, p_attribute1)
760: ,p_attribute2 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute2, p_attribute2)
761: ,p_attribute3 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute3, p_attribute3)
762: ,p_attribute4 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute4, p_attribute4)
763: ,p_attribute5 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute5, p_attribute5)
764: ,p_attribute6 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute6, p_attribute6)

Line 761: ,p_attribute3 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute3, p_attribute3)

757: ,p_comments => get_non_gmisc_value( per_cel_shd.g_old_rec.comments, p_comments)
758: ,p_attribute_category => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute_category, p_attribute_category)
759: ,p_attribute1 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute1, p_attribute1)
760: ,p_attribute2 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute2, p_attribute2)
761: ,p_attribute3 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute3, p_attribute3)
762: ,p_attribute4 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute4, p_attribute4)
763: ,p_attribute5 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute5, p_attribute5)
764: ,p_attribute6 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute6, p_attribute6)
765: ,p_attribute7 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute7, p_attribute7)

Line 762: ,p_attribute4 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute4, p_attribute4)

758: ,p_attribute_category => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute_category, p_attribute_category)
759: ,p_attribute1 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute1, p_attribute1)
760: ,p_attribute2 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute2, p_attribute2)
761: ,p_attribute3 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute3, p_attribute3)
762: ,p_attribute4 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute4, p_attribute4)
763: ,p_attribute5 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute5, p_attribute5)
764: ,p_attribute6 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute6, p_attribute6)
765: ,p_attribute7 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute7, p_attribute7)
766: ,p_attribute8 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute8, p_attribute8)

Line 763: ,p_attribute5 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute5, p_attribute5)

759: ,p_attribute1 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute1, p_attribute1)
760: ,p_attribute2 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute2, p_attribute2)
761: ,p_attribute3 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute3, p_attribute3)
762: ,p_attribute4 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute4, p_attribute4)
763: ,p_attribute5 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute5, p_attribute5)
764: ,p_attribute6 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute6, p_attribute6)
765: ,p_attribute7 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute7, p_attribute7)
766: ,p_attribute8 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute8, p_attribute8)
767: ,p_attribute9 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute9, p_attribute9)

Line 764: ,p_attribute6 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute6, p_attribute6)

760: ,p_attribute2 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute2, p_attribute2)
761: ,p_attribute3 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute3, p_attribute3)
762: ,p_attribute4 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute4, p_attribute4)
763: ,p_attribute5 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute5, p_attribute5)
764: ,p_attribute6 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute6, p_attribute6)
765: ,p_attribute7 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute7, p_attribute7)
766: ,p_attribute8 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute8, p_attribute8)
767: ,p_attribute9 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute9, p_attribute9)
768: ,p_attribute10 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute10, p_attribute10)

Line 765: ,p_attribute7 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute7, p_attribute7)

761: ,p_attribute3 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute3, p_attribute3)
762: ,p_attribute4 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute4, p_attribute4)
763: ,p_attribute5 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute5, p_attribute5)
764: ,p_attribute6 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute6, p_attribute6)
765: ,p_attribute7 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute7, p_attribute7)
766: ,p_attribute8 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute8, p_attribute8)
767: ,p_attribute9 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute9, p_attribute9)
768: ,p_attribute10 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute10, p_attribute10)
769: ,p_attribute11 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute11, p_attribute11)

Line 766: ,p_attribute8 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute8, p_attribute8)

762: ,p_attribute4 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute4, p_attribute4)
763: ,p_attribute5 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute5, p_attribute5)
764: ,p_attribute6 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute6, p_attribute6)
765: ,p_attribute7 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute7, p_attribute7)
766: ,p_attribute8 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute8, p_attribute8)
767: ,p_attribute9 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute9, p_attribute9)
768: ,p_attribute10 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute10, p_attribute10)
769: ,p_attribute11 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute11, p_attribute11)
770: ,p_attribute12 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute12, p_attribute12)

Line 767: ,p_attribute9 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute9, p_attribute9)

763: ,p_attribute5 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute5, p_attribute5)
764: ,p_attribute6 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute6, p_attribute6)
765: ,p_attribute7 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute7, p_attribute7)
766: ,p_attribute8 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute8, p_attribute8)
767: ,p_attribute9 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute9, p_attribute9)
768: ,p_attribute10 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute10, p_attribute10)
769: ,p_attribute11 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute11, p_attribute11)
770: ,p_attribute12 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute12, p_attribute12)
771: ,p_attribute13 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute13, p_attribute13)

Line 768: ,p_attribute10 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute10, p_attribute10)

764: ,p_attribute6 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute6, p_attribute6)
765: ,p_attribute7 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute7, p_attribute7)
766: ,p_attribute8 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute8, p_attribute8)
767: ,p_attribute9 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute9, p_attribute9)
768: ,p_attribute10 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute10, p_attribute10)
769: ,p_attribute11 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute11, p_attribute11)
770: ,p_attribute12 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute12, p_attribute12)
771: ,p_attribute13 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute13, p_attribute13)
772: ,p_attribute14 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute14, p_attribute14)

Line 769: ,p_attribute11 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute11, p_attribute11)

765: ,p_attribute7 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute7, p_attribute7)
766: ,p_attribute8 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute8, p_attribute8)
767: ,p_attribute9 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute9, p_attribute9)
768: ,p_attribute10 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute10, p_attribute10)
769: ,p_attribute11 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute11, p_attribute11)
770: ,p_attribute12 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute12, p_attribute12)
771: ,p_attribute13 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute13, p_attribute13)
772: ,p_attribute14 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute14, p_attribute14)
773: ,p_attribute15 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute15, p_attribute15)

Line 770: ,p_attribute12 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute12, p_attribute12)

766: ,p_attribute8 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute8, p_attribute8)
767: ,p_attribute9 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute9, p_attribute9)
768: ,p_attribute10 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute10, p_attribute10)
769: ,p_attribute11 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute11, p_attribute11)
770: ,p_attribute12 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute12, p_attribute12)
771: ,p_attribute13 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute13, p_attribute13)
772: ,p_attribute14 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute14, p_attribute14)
773: ,p_attribute15 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute15, p_attribute15)
774: ,p_attribute16 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute16, p_attribute16)

Line 771: ,p_attribute13 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute13, p_attribute13)

767: ,p_attribute9 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute9, p_attribute9)
768: ,p_attribute10 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute10, p_attribute10)
769: ,p_attribute11 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute11, p_attribute11)
770: ,p_attribute12 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute12, p_attribute12)
771: ,p_attribute13 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute13, p_attribute13)
772: ,p_attribute14 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute14, p_attribute14)
773: ,p_attribute15 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute15, p_attribute15)
774: ,p_attribute16 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute16, p_attribute16)
775: ,p_attribute17 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute17, p_attribute17)

Line 772: ,p_attribute14 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute14, p_attribute14)

768: ,p_attribute10 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute10, p_attribute10)
769: ,p_attribute11 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute11, p_attribute11)
770: ,p_attribute12 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute12, p_attribute12)
771: ,p_attribute13 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute13, p_attribute13)
772: ,p_attribute14 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute14, p_attribute14)
773: ,p_attribute15 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute15, p_attribute15)
774: ,p_attribute16 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute16, p_attribute16)
775: ,p_attribute17 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute17, p_attribute17)
776: ,p_attribute18 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute18, p_attribute18)

Line 773: ,p_attribute15 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute15, p_attribute15)

769: ,p_attribute11 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute11, p_attribute11)
770: ,p_attribute12 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute12, p_attribute12)
771: ,p_attribute13 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute13, p_attribute13)
772: ,p_attribute14 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute14, p_attribute14)
773: ,p_attribute15 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute15, p_attribute15)
774: ,p_attribute16 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute16, p_attribute16)
775: ,p_attribute17 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute17, p_attribute17)
776: ,p_attribute18 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute18, p_attribute18)
777: ,p_attribute19 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute19, p_attribute19)

Line 774: ,p_attribute16 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute16, p_attribute16)

770: ,p_attribute12 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute12, p_attribute12)
771: ,p_attribute13 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute13, p_attribute13)
772: ,p_attribute14 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute14, p_attribute14)
773: ,p_attribute15 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute15, p_attribute15)
774: ,p_attribute16 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute16, p_attribute16)
775: ,p_attribute17 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute17, p_attribute17)
776: ,p_attribute18 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute18, p_attribute18)
777: ,p_attribute19 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute19, p_attribute19)
778: ,p_attribute20 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute20, p_attribute20)

Line 775: ,p_attribute17 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute17, p_attribute17)

771: ,p_attribute13 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute13, p_attribute13)
772: ,p_attribute14 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute14, p_attribute14)
773: ,p_attribute15 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute15, p_attribute15)
774: ,p_attribute16 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute16, p_attribute16)
775: ,p_attribute17 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute17, p_attribute17)
776: ,p_attribute18 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute18, p_attribute18)
777: ,p_attribute19 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute19, p_attribute19)
778: ,p_attribute20 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute20, p_attribute20)
779: ,p_effective_date => p_effective_date

Line 776: ,p_attribute18 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute18, p_attribute18)

772: ,p_attribute14 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute14, p_attribute14)
773: ,p_attribute15 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute15, p_attribute15)
774: ,p_attribute16 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute16, p_attribute16)
775: ,p_attribute17 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute17, p_attribute17)
776: ,p_attribute18 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute18, p_attribute18)
777: ,p_attribute19 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute19, p_attribute19)
778: ,p_attribute20 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute20, p_attribute20)
779: ,p_effective_date => p_effective_date
780: ,p_object_id => per_cel_shd.g_old_rec.object_id

Line 777: ,p_attribute19 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute19, p_attribute19)

773: ,p_attribute15 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute15, p_attribute15)
774: ,p_attribute16 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute16, p_attribute16)
775: ,p_attribute17 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute17, p_attribute17)
776: ,p_attribute18 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute18, p_attribute18)
777: ,p_attribute19 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute19, p_attribute19)
778: ,p_attribute20 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute20, p_attribute20)
779: ,p_effective_date => p_effective_date
780: ,p_object_id => per_cel_shd.g_old_rec.object_id
781: ,p_object_name => per_cel_shd.g_old_rec.object_name

Line 778: ,p_attribute20 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute20, p_attribute20)

774: ,p_attribute16 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute16, p_attribute16)
775: ,p_attribute17 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute17, p_attribute17)
776: ,p_attribute18 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute18, p_attribute18)
777: ,p_attribute19 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute19, p_attribute19)
778: ,p_attribute20 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute20, p_attribute20)
779: ,p_effective_date => p_effective_date
780: ,p_object_id => per_cel_shd.g_old_rec.object_id
781: ,p_object_name => per_cel_shd.g_old_rec.object_name
782: ,p_party_id => get_non_gmisc_value( per_cel_shd.g_old_rec.party_id, p_party_id)

Line 780: ,p_object_id => per_cel_shd.g_old_rec.object_id

776: ,p_attribute18 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute18, p_attribute18)
777: ,p_attribute19 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute19, p_attribute19)
778: ,p_attribute20 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute20, p_attribute20)
779: ,p_effective_date => p_effective_date
780: ,p_object_id => per_cel_shd.g_old_rec.object_id
781: ,p_object_name => per_cel_shd.g_old_rec.object_name
782: ,p_party_id => get_non_gmisc_value( per_cel_shd.g_old_rec.party_id, p_party_id)
783: ,p_appr_line_score => get_non_gmisc_value( per_cel_shd.g_old_rec.appr_line_score, p_appr_line_score)
784: ,p_status => get_non_gmisc_value( per_cel_shd.g_old_rec.status, p_status)

Line 781: ,p_object_name => per_cel_shd.g_old_rec.object_name

777: ,p_attribute19 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute19, p_attribute19)
778: ,p_attribute20 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute20, p_attribute20)
779: ,p_effective_date => p_effective_date
780: ,p_object_id => per_cel_shd.g_old_rec.object_id
781: ,p_object_name => per_cel_shd.g_old_rec.object_name
782: ,p_party_id => get_non_gmisc_value( per_cel_shd.g_old_rec.party_id, p_party_id)
783: ,p_appr_line_score => get_non_gmisc_value( per_cel_shd.g_old_rec.appr_line_score, p_appr_line_score)
784: ,p_status => get_non_gmisc_value( per_cel_shd.g_old_rec.status, p_status)
785: );

Line 782: ,p_party_id => get_non_gmisc_value( per_cel_shd.g_old_rec.party_id, p_party_id)

778: ,p_attribute20 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute20, p_attribute20)
779: ,p_effective_date => p_effective_date
780: ,p_object_id => per_cel_shd.g_old_rec.object_id
781: ,p_object_name => per_cel_shd.g_old_rec.object_name
782: ,p_party_id => get_non_gmisc_value( per_cel_shd.g_old_rec.party_id, p_party_id)
783: ,p_appr_line_score => get_non_gmisc_value( per_cel_shd.g_old_rec.appr_line_score, p_appr_line_score)
784: ,p_status => get_non_gmisc_value( per_cel_shd.g_old_rec.status, p_status)
785: );
786: else

Line 783: ,p_appr_line_score => get_non_gmisc_value( per_cel_shd.g_old_rec.appr_line_score, p_appr_line_score)

779: ,p_effective_date => p_effective_date
780: ,p_object_id => per_cel_shd.g_old_rec.object_id
781: ,p_object_name => per_cel_shd.g_old_rec.object_name
782: ,p_party_id => get_non_gmisc_value( per_cel_shd.g_old_rec.party_id, p_party_id)
783: ,p_appr_line_score => get_non_gmisc_value( per_cel_shd.g_old_rec.appr_line_score, p_appr_line_score)
784: ,p_status => get_non_gmisc_value( per_cel_shd.g_old_rec.status, p_status)
785: );
786: else
787: if (nvl(p_datetrack_update_mode, '#') <> hr_api.g_update) then

Line 784: ,p_status => get_non_gmisc_value( per_cel_shd.g_old_rec.status, p_status)

780: ,p_object_id => per_cel_shd.g_old_rec.object_id
781: ,p_object_name => per_cel_shd.g_old_rec.object_name
782: ,p_party_id => get_non_gmisc_value( per_cel_shd.g_old_rec.party_id, p_party_id)
783: ,p_appr_line_score => get_non_gmisc_value( per_cel_shd.g_old_rec.appr_line_score, p_appr_line_score)
784: ,p_status => get_non_gmisc_value( per_cel_shd.g_old_rec.status, p_status)
785: );
786: else
787: if (nvl(p_datetrack_update_mode, '#') <> hr_api.g_update) then
788:

Line 863: ,p_type => per_cel_shd.g_old_rec.type

859: hr_competence_element_api.create_competence_element
860: (p_validate => false
861: ,p_competence_element_id => l_competence_element_id
862: ,p_object_version_number => l_object_version_number
863: ,p_type => per_cel_shd.g_old_rec.type
864: ,p_business_group_id => per_cel_shd.g_old_rec.business_group_id
865: ,p_enterprise_id => per_cel_shd.g_old_rec.enterprise_id
866: ,p_competence_id => get_non_gmisc_value( per_cel_shd.g_old_rec.competence_id,p_competence_id)
867: ,p_proficiency_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.proficiency_level_id,p_proficiency_level_id)

Line 864: ,p_business_group_id => per_cel_shd.g_old_rec.business_group_id

860: (p_validate => false
861: ,p_competence_element_id => l_competence_element_id
862: ,p_object_version_number => l_object_version_number
863: ,p_type => per_cel_shd.g_old_rec.type
864: ,p_business_group_id => per_cel_shd.g_old_rec.business_group_id
865: ,p_enterprise_id => per_cel_shd.g_old_rec.enterprise_id
866: ,p_competence_id => get_non_gmisc_value( per_cel_shd.g_old_rec.competence_id,p_competence_id)
867: ,p_proficiency_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.proficiency_level_id,p_proficiency_level_id)
868: ,p_high_proficiency_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.high_proficiency_level_id,p_high_proficiency_level_id)

Line 865: ,p_enterprise_id => per_cel_shd.g_old_rec.enterprise_id

861: ,p_competence_element_id => l_competence_element_id
862: ,p_object_version_number => l_object_version_number
863: ,p_type => per_cel_shd.g_old_rec.type
864: ,p_business_group_id => per_cel_shd.g_old_rec.business_group_id
865: ,p_enterprise_id => per_cel_shd.g_old_rec.enterprise_id
866: ,p_competence_id => get_non_gmisc_value( per_cel_shd.g_old_rec.competence_id,p_competence_id)
867: ,p_proficiency_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.proficiency_level_id,p_proficiency_level_id)
868: ,p_high_proficiency_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.high_proficiency_level_id,p_high_proficiency_level_id)
869: ,p_weighting_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.weighting_level_id,p_weighting_level_id)

Line 866: ,p_competence_id => get_non_gmisc_value( per_cel_shd.g_old_rec.competence_id,p_competence_id)

862: ,p_object_version_number => l_object_version_number
863: ,p_type => per_cel_shd.g_old_rec.type
864: ,p_business_group_id => per_cel_shd.g_old_rec.business_group_id
865: ,p_enterprise_id => per_cel_shd.g_old_rec.enterprise_id
866: ,p_competence_id => get_non_gmisc_value( per_cel_shd.g_old_rec.competence_id,p_competence_id)
867: ,p_proficiency_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.proficiency_level_id,p_proficiency_level_id)
868: ,p_high_proficiency_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.high_proficiency_level_id,p_high_proficiency_level_id)
869: ,p_weighting_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.weighting_level_id,p_weighting_level_id)
870: ,p_rating_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.rating_level_id,p_rating_level_id)

Line 867: ,p_proficiency_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.proficiency_level_id,p_proficiency_level_id)

863: ,p_type => per_cel_shd.g_old_rec.type
864: ,p_business_group_id => per_cel_shd.g_old_rec.business_group_id
865: ,p_enterprise_id => per_cel_shd.g_old_rec.enterprise_id
866: ,p_competence_id => get_non_gmisc_value( per_cel_shd.g_old_rec.competence_id,p_competence_id)
867: ,p_proficiency_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.proficiency_level_id,p_proficiency_level_id)
868: ,p_high_proficiency_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.high_proficiency_level_id,p_high_proficiency_level_id)
869: ,p_weighting_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.weighting_level_id,p_weighting_level_id)
870: ,p_rating_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.rating_level_id,p_rating_level_id)
871: ,p_person_id => per_cel_shd.g_old_rec.person_id

Line 868: ,p_high_proficiency_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.high_proficiency_level_id,p_high_proficiency_level_id)

864: ,p_business_group_id => per_cel_shd.g_old_rec.business_group_id
865: ,p_enterprise_id => per_cel_shd.g_old_rec.enterprise_id
866: ,p_competence_id => get_non_gmisc_value( per_cel_shd.g_old_rec.competence_id,p_competence_id)
867: ,p_proficiency_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.proficiency_level_id,p_proficiency_level_id)
868: ,p_high_proficiency_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.high_proficiency_level_id,p_high_proficiency_level_id)
869: ,p_weighting_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.weighting_level_id,p_weighting_level_id)
870: ,p_rating_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.rating_level_id,p_rating_level_id)
871: ,p_person_id => per_cel_shd.g_old_rec.person_id
872: ,p_job_id => per_cel_shd.g_old_rec.job_id

Line 869: ,p_weighting_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.weighting_level_id,p_weighting_level_id)

865: ,p_enterprise_id => per_cel_shd.g_old_rec.enterprise_id
866: ,p_competence_id => get_non_gmisc_value( per_cel_shd.g_old_rec.competence_id,p_competence_id)
867: ,p_proficiency_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.proficiency_level_id,p_proficiency_level_id)
868: ,p_high_proficiency_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.high_proficiency_level_id,p_high_proficiency_level_id)
869: ,p_weighting_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.weighting_level_id,p_weighting_level_id)
870: ,p_rating_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.rating_level_id,p_rating_level_id)
871: ,p_person_id => per_cel_shd.g_old_rec.person_id
872: ,p_job_id => per_cel_shd.g_old_rec.job_id
873: ,p_valid_grade_id => per_cel_shd.g_old_rec.valid_grade_id

Line 870: ,p_rating_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.rating_level_id,p_rating_level_id)

866: ,p_competence_id => get_non_gmisc_value( per_cel_shd.g_old_rec.competence_id,p_competence_id)
867: ,p_proficiency_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.proficiency_level_id,p_proficiency_level_id)
868: ,p_high_proficiency_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.high_proficiency_level_id,p_high_proficiency_level_id)
869: ,p_weighting_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.weighting_level_id,p_weighting_level_id)
870: ,p_rating_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.rating_level_id,p_rating_level_id)
871: ,p_person_id => per_cel_shd.g_old_rec.person_id
872: ,p_job_id => per_cel_shd.g_old_rec.job_id
873: ,p_valid_grade_id => per_cel_shd.g_old_rec.valid_grade_id
874: ,p_position_id => per_cel_shd.g_old_rec.position_id

Line 871: ,p_person_id => per_cel_shd.g_old_rec.person_id

867: ,p_proficiency_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.proficiency_level_id,p_proficiency_level_id)
868: ,p_high_proficiency_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.high_proficiency_level_id,p_high_proficiency_level_id)
869: ,p_weighting_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.weighting_level_id,p_weighting_level_id)
870: ,p_rating_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.rating_level_id,p_rating_level_id)
871: ,p_person_id => per_cel_shd.g_old_rec.person_id
872: ,p_job_id => per_cel_shd.g_old_rec.job_id
873: ,p_valid_grade_id => per_cel_shd.g_old_rec.valid_grade_id
874: ,p_position_id => per_cel_shd.g_old_rec.position_id
875: ,p_organization_id => per_cel_shd.g_old_rec.organization_id

Line 872: ,p_job_id => per_cel_shd.g_old_rec.job_id

868: ,p_high_proficiency_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.high_proficiency_level_id,p_high_proficiency_level_id)
869: ,p_weighting_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.weighting_level_id,p_weighting_level_id)
870: ,p_rating_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.rating_level_id,p_rating_level_id)
871: ,p_person_id => per_cel_shd.g_old_rec.person_id
872: ,p_job_id => per_cel_shd.g_old_rec.job_id
873: ,p_valid_grade_id => per_cel_shd.g_old_rec.valid_grade_id
874: ,p_position_id => per_cel_shd.g_old_rec.position_id
875: ,p_organization_id => per_cel_shd.g_old_rec.organization_id
876: ,p_parent_competence_element_id => per_cel_shd.g_old_rec.parent_competence_element_id

Line 873: ,p_valid_grade_id => per_cel_shd.g_old_rec.valid_grade_id

869: ,p_weighting_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.weighting_level_id,p_weighting_level_id)
870: ,p_rating_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.rating_level_id,p_rating_level_id)
871: ,p_person_id => per_cel_shd.g_old_rec.person_id
872: ,p_job_id => per_cel_shd.g_old_rec.job_id
873: ,p_valid_grade_id => per_cel_shd.g_old_rec.valid_grade_id
874: ,p_position_id => per_cel_shd.g_old_rec.position_id
875: ,p_organization_id => per_cel_shd.g_old_rec.organization_id
876: ,p_parent_competence_element_id => per_cel_shd.g_old_rec.parent_competence_element_id
877: ,p_activity_version_id => per_cel_shd.g_old_rec.activity_version_id

Line 874: ,p_position_id => per_cel_shd.g_old_rec.position_id

870: ,p_rating_level_id => get_non_gmisc_value( per_cel_shd.g_old_rec.rating_level_id,p_rating_level_id)
871: ,p_person_id => per_cel_shd.g_old_rec.person_id
872: ,p_job_id => per_cel_shd.g_old_rec.job_id
873: ,p_valid_grade_id => per_cel_shd.g_old_rec.valid_grade_id
874: ,p_position_id => per_cel_shd.g_old_rec.position_id
875: ,p_organization_id => per_cel_shd.g_old_rec.organization_id
876: ,p_parent_competence_element_id => per_cel_shd.g_old_rec.parent_competence_element_id
877: ,p_activity_version_id => per_cel_shd.g_old_rec.activity_version_id
878: ,p_assessment_id => per_cel_shd.g_old_rec.assessment_id

Line 875: ,p_organization_id => per_cel_shd.g_old_rec.organization_id

871: ,p_person_id => per_cel_shd.g_old_rec.person_id
872: ,p_job_id => per_cel_shd.g_old_rec.job_id
873: ,p_valid_grade_id => per_cel_shd.g_old_rec.valid_grade_id
874: ,p_position_id => per_cel_shd.g_old_rec.position_id
875: ,p_organization_id => per_cel_shd.g_old_rec.organization_id
876: ,p_parent_competence_element_id => per_cel_shd.g_old_rec.parent_competence_element_id
877: ,p_activity_version_id => per_cel_shd.g_old_rec.activity_version_id
878: ,p_assessment_id => per_cel_shd.g_old_rec.assessment_id
879: ,p_assessment_type_id => per_cel_shd.g_old_rec.assessment_type_id

Line 876: ,p_parent_competence_element_id => per_cel_shd.g_old_rec.parent_competence_element_id

872: ,p_job_id => per_cel_shd.g_old_rec.job_id
873: ,p_valid_grade_id => per_cel_shd.g_old_rec.valid_grade_id
874: ,p_position_id => per_cel_shd.g_old_rec.position_id
875: ,p_organization_id => per_cel_shd.g_old_rec.organization_id
876: ,p_parent_competence_element_id => per_cel_shd.g_old_rec.parent_competence_element_id
877: ,p_activity_version_id => per_cel_shd.g_old_rec.activity_version_id
878: ,p_assessment_id => per_cel_shd.g_old_rec.assessment_id
879: ,p_assessment_type_id => per_cel_shd.g_old_rec.assessment_type_id
880: ,p_mandatory => get_non_gmisc_value( per_cel_shd.g_old_rec.mandatory,p_mandatory)

Line 877: ,p_activity_version_id => per_cel_shd.g_old_rec.activity_version_id

873: ,p_valid_grade_id => per_cel_shd.g_old_rec.valid_grade_id
874: ,p_position_id => per_cel_shd.g_old_rec.position_id
875: ,p_organization_id => per_cel_shd.g_old_rec.organization_id
876: ,p_parent_competence_element_id => per_cel_shd.g_old_rec.parent_competence_element_id
877: ,p_activity_version_id => per_cel_shd.g_old_rec.activity_version_id
878: ,p_assessment_id => per_cel_shd.g_old_rec.assessment_id
879: ,p_assessment_type_id => per_cel_shd.g_old_rec.assessment_type_id
880: ,p_mandatory => get_non_gmisc_value( per_cel_shd.g_old_rec.mandatory,p_mandatory)
881: ,p_effective_date_from => get_non_gmisc_value( per_cel_shd.g_old_rec.effective_date_from, p_effective_date_from)

Line 878: ,p_assessment_id => per_cel_shd.g_old_rec.assessment_id

874: ,p_position_id => per_cel_shd.g_old_rec.position_id
875: ,p_organization_id => per_cel_shd.g_old_rec.organization_id
876: ,p_parent_competence_element_id => per_cel_shd.g_old_rec.parent_competence_element_id
877: ,p_activity_version_id => per_cel_shd.g_old_rec.activity_version_id
878: ,p_assessment_id => per_cel_shd.g_old_rec.assessment_id
879: ,p_assessment_type_id => per_cel_shd.g_old_rec.assessment_type_id
880: ,p_mandatory => get_non_gmisc_value( per_cel_shd.g_old_rec.mandatory,p_mandatory)
881: ,p_effective_date_from => get_non_gmisc_value( per_cel_shd.g_old_rec.effective_date_from, p_effective_date_from)
882: ,p_effective_date_to => get_non_gmisc_value( per_cel_shd.g_old_rec.effective_date_to, p_effective_date_to)

Line 879: ,p_assessment_type_id => per_cel_shd.g_old_rec.assessment_type_id

875: ,p_organization_id => per_cel_shd.g_old_rec.organization_id
876: ,p_parent_competence_element_id => per_cel_shd.g_old_rec.parent_competence_element_id
877: ,p_activity_version_id => per_cel_shd.g_old_rec.activity_version_id
878: ,p_assessment_id => per_cel_shd.g_old_rec.assessment_id
879: ,p_assessment_type_id => per_cel_shd.g_old_rec.assessment_type_id
880: ,p_mandatory => get_non_gmisc_value( per_cel_shd.g_old_rec.mandatory,p_mandatory)
881: ,p_effective_date_from => get_non_gmisc_value( per_cel_shd.g_old_rec.effective_date_from, p_effective_date_from)
882: ,p_effective_date_to => get_non_gmisc_value( per_cel_shd.g_old_rec.effective_date_to, p_effective_date_to)
883: ,p_group_competence_type => get_non_gmisc_value( per_cel_shd.g_old_rec.group_competence_type,p_group_competence_type)

Line 880: ,p_mandatory => get_non_gmisc_value( per_cel_shd.g_old_rec.mandatory,p_mandatory)

876: ,p_parent_competence_element_id => per_cel_shd.g_old_rec.parent_competence_element_id
877: ,p_activity_version_id => per_cel_shd.g_old_rec.activity_version_id
878: ,p_assessment_id => per_cel_shd.g_old_rec.assessment_id
879: ,p_assessment_type_id => per_cel_shd.g_old_rec.assessment_type_id
880: ,p_mandatory => get_non_gmisc_value( per_cel_shd.g_old_rec.mandatory,p_mandatory)
881: ,p_effective_date_from => get_non_gmisc_value( per_cel_shd.g_old_rec.effective_date_from, p_effective_date_from)
882: ,p_effective_date_to => get_non_gmisc_value( per_cel_shd.g_old_rec.effective_date_to, p_effective_date_to)
883: ,p_group_competence_type => get_non_gmisc_value( per_cel_shd.g_old_rec.group_competence_type,p_group_competence_type)
884: ,p_competence_type => get_non_gmisc_value( per_cel_shd.g_old_rec.competence_type,p_competence_type)

Line 881: ,p_effective_date_from => get_non_gmisc_value( per_cel_shd.g_old_rec.effective_date_from, p_effective_date_from)

877: ,p_activity_version_id => per_cel_shd.g_old_rec.activity_version_id
878: ,p_assessment_id => per_cel_shd.g_old_rec.assessment_id
879: ,p_assessment_type_id => per_cel_shd.g_old_rec.assessment_type_id
880: ,p_mandatory => get_non_gmisc_value( per_cel_shd.g_old_rec.mandatory,p_mandatory)
881: ,p_effective_date_from => get_non_gmisc_value( per_cel_shd.g_old_rec.effective_date_from, p_effective_date_from)
882: ,p_effective_date_to => get_non_gmisc_value( per_cel_shd.g_old_rec.effective_date_to, p_effective_date_to)
883: ,p_group_competence_type => get_non_gmisc_value( per_cel_shd.g_old_rec.group_competence_type,p_group_competence_type)
884: ,p_competence_type => get_non_gmisc_value( per_cel_shd.g_old_rec.competence_type,p_competence_type)
885: ,p_normal_elapse_duration => get_non_gmisc_value( per_cel_shd.g_old_rec.normal_elapse_duration,p_normal_elapse_duration )

Line 882: ,p_effective_date_to => get_non_gmisc_value( per_cel_shd.g_old_rec.effective_date_to, p_effective_date_to)

878: ,p_assessment_id => per_cel_shd.g_old_rec.assessment_id
879: ,p_assessment_type_id => per_cel_shd.g_old_rec.assessment_type_id
880: ,p_mandatory => get_non_gmisc_value( per_cel_shd.g_old_rec.mandatory,p_mandatory)
881: ,p_effective_date_from => get_non_gmisc_value( per_cel_shd.g_old_rec.effective_date_from, p_effective_date_from)
882: ,p_effective_date_to => get_non_gmisc_value( per_cel_shd.g_old_rec.effective_date_to, p_effective_date_to)
883: ,p_group_competence_type => get_non_gmisc_value( per_cel_shd.g_old_rec.group_competence_type,p_group_competence_type)
884: ,p_competence_type => get_non_gmisc_value( per_cel_shd.g_old_rec.competence_type,p_competence_type)
885: ,p_normal_elapse_duration => get_non_gmisc_value( per_cel_shd.g_old_rec.normal_elapse_duration,p_normal_elapse_duration )
886: ,p_normal_elapse_duration_unit => get_non_gmisc_value( per_cel_shd.g_old_rec.normal_elapse_duration_unit,p_normal_elapse_duration_unit)

Line 883: ,p_group_competence_type => get_non_gmisc_value( per_cel_shd.g_old_rec.group_competence_type,p_group_competence_type)

879: ,p_assessment_type_id => per_cel_shd.g_old_rec.assessment_type_id
880: ,p_mandatory => get_non_gmisc_value( per_cel_shd.g_old_rec.mandatory,p_mandatory)
881: ,p_effective_date_from => get_non_gmisc_value( per_cel_shd.g_old_rec.effective_date_from, p_effective_date_from)
882: ,p_effective_date_to => get_non_gmisc_value( per_cel_shd.g_old_rec.effective_date_to, p_effective_date_to)
883: ,p_group_competence_type => get_non_gmisc_value( per_cel_shd.g_old_rec.group_competence_type,p_group_competence_type)
884: ,p_competence_type => get_non_gmisc_value( per_cel_shd.g_old_rec.competence_type,p_competence_type)
885: ,p_normal_elapse_duration => get_non_gmisc_value( per_cel_shd.g_old_rec.normal_elapse_duration,p_normal_elapse_duration )
886: ,p_normal_elapse_duration_unit => get_non_gmisc_value( per_cel_shd.g_old_rec.normal_elapse_duration_unit,p_normal_elapse_duration_unit)
887: ,p_sequence_number => get_non_gmisc_value( per_cel_shd.g_old_rec.sequence_number,p_sequence_number )

Line 884: ,p_competence_type => get_non_gmisc_value( per_cel_shd.g_old_rec.competence_type,p_competence_type)

880: ,p_mandatory => get_non_gmisc_value( per_cel_shd.g_old_rec.mandatory,p_mandatory)
881: ,p_effective_date_from => get_non_gmisc_value( per_cel_shd.g_old_rec.effective_date_from, p_effective_date_from)
882: ,p_effective_date_to => get_non_gmisc_value( per_cel_shd.g_old_rec.effective_date_to, p_effective_date_to)
883: ,p_group_competence_type => get_non_gmisc_value( per_cel_shd.g_old_rec.group_competence_type,p_group_competence_type)
884: ,p_competence_type => get_non_gmisc_value( per_cel_shd.g_old_rec.competence_type,p_competence_type)
885: ,p_normal_elapse_duration => get_non_gmisc_value( per_cel_shd.g_old_rec.normal_elapse_duration,p_normal_elapse_duration )
886: ,p_normal_elapse_duration_unit => get_non_gmisc_value( per_cel_shd.g_old_rec.normal_elapse_duration_unit,p_normal_elapse_duration_unit)
887: ,p_sequence_number => get_non_gmisc_value( per_cel_shd.g_old_rec.sequence_number,p_sequence_number )
888: ,p_source_of_proficiency_level => get_non_gmisc_value( per_cel_shd.g_old_rec.source_of_proficiency_level, p_source_of_proficiency_level)

Line 885: ,p_normal_elapse_duration => get_non_gmisc_value( per_cel_shd.g_old_rec.normal_elapse_duration,p_normal_elapse_duration )

881: ,p_effective_date_from => get_non_gmisc_value( per_cel_shd.g_old_rec.effective_date_from, p_effective_date_from)
882: ,p_effective_date_to => get_non_gmisc_value( per_cel_shd.g_old_rec.effective_date_to, p_effective_date_to)
883: ,p_group_competence_type => get_non_gmisc_value( per_cel_shd.g_old_rec.group_competence_type,p_group_competence_type)
884: ,p_competence_type => get_non_gmisc_value( per_cel_shd.g_old_rec.competence_type,p_competence_type)
885: ,p_normal_elapse_duration => get_non_gmisc_value( per_cel_shd.g_old_rec.normal_elapse_duration,p_normal_elapse_duration )
886: ,p_normal_elapse_duration_unit => get_non_gmisc_value( per_cel_shd.g_old_rec.normal_elapse_duration_unit,p_normal_elapse_duration_unit)
887: ,p_sequence_number => get_non_gmisc_value( per_cel_shd.g_old_rec.sequence_number,p_sequence_number )
888: ,p_source_of_proficiency_level => get_non_gmisc_value( per_cel_shd.g_old_rec.source_of_proficiency_level, p_source_of_proficiency_level)
889: ,p_line_score => get_non_gmisc_value( per_cel_shd.g_old_rec.line_score,p_line_score )

Line 886: ,p_normal_elapse_duration_unit => get_non_gmisc_value( per_cel_shd.g_old_rec.normal_elapse_duration_unit,p_normal_elapse_duration_unit)

882: ,p_effective_date_to => get_non_gmisc_value( per_cel_shd.g_old_rec.effective_date_to, p_effective_date_to)
883: ,p_group_competence_type => get_non_gmisc_value( per_cel_shd.g_old_rec.group_competence_type,p_group_competence_type)
884: ,p_competence_type => get_non_gmisc_value( per_cel_shd.g_old_rec.competence_type,p_competence_type)
885: ,p_normal_elapse_duration => get_non_gmisc_value( per_cel_shd.g_old_rec.normal_elapse_duration,p_normal_elapse_duration )
886: ,p_normal_elapse_duration_unit => get_non_gmisc_value( per_cel_shd.g_old_rec.normal_elapse_duration_unit,p_normal_elapse_duration_unit)
887: ,p_sequence_number => get_non_gmisc_value( per_cel_shd.g_old_rec.sequence_number,p_sequence_number )
888: ,p_source_of_proficiency_level => get_non_gmisc_value( per_cel_shd.g_old_rec.source_of_proficiency_level, p_source_of_proficiency_level)
889: ,p_line_score => get_non_gmisc_value( per_cel_shd.g_old_rec.line_score,p_line_score )
890: ,p_certification_date => get_non_gmisc_value( per_cel_shd.g_old_rec.certification_date, p_certification_date)

Line 887: ,p_sequence_number => get_non_gmisc_value( per_cel_shd.g_old_rec.sequence_number,p_sequence_number )

883: ,p_group_competence_type => get_non_gmisc_value( per_cel_shd.g_old_rec.group_competence_type,p_group_competence_type)
884: ,p_competence_type => get_non_gmisc_value( per_cel_shd.g_old_rec.competence_type,p_competence_type)
885: ,p_normal_elapse_duration => get_non_gmisc_value( per_cel_shd.g_old_rec.normal_elapse_duration,p_normal_elapse_duration )
886: ,p_normal_elapse_duration_unit => get_non_gmisc_value( per_cel_shd.g_old_rec.normal_elapse_duration_unit,p_normal_elapse_duration_unit)
887: ,p_sequence_number => get_non_gmisc_value( per_cel_shd.g_old_rec.sequence_number,p_sequence_number )
888: ,p_source_of_proficiency_level => get_non_gmisc_value( per_cel_shd.g_old_rec.source_of_proficiency_level, p_source_of_proficiency_level)
889: ,p_line_score => get_non_gmisc_value( per_cel_shd.g_old_rec.line_score,p_line_score )
890: ,p_certification_date => get_non_gmisc_value( per_cel_shd.g_old_rec.certification_date, p_certification_date)
891: ,p_certification_method => get_non_gmisc_value( per_cel_shd.g_old_rec.certification_method, p_certification_method)

Line 888: ,p_source_of_proficiency_level => get_non_gmisc_value( per_cel_shd.g_old_rec.source_of_proficiency_level, p_source_of_proficiency_level)

884: ,p_competence_type => get_non_gmisc_value( per_cel_shd.g_old_rec.competence_type,p_competence_type)
885: ,p_normal_elapse_duration => get_non_gmisc_value( per_cel_shd.g_old_rec.normal_elapse_duration,p_normal_elapse_duration )
886: ,p_normal_elapse_duration_unit => get_non_gmisc_value( per_cel_shd.g_old_rec.normal_elapse_duration_unit,p_normal_elapse_duration_unit)
887: ,p_sequence_number => get_non_gmisc_value( per_cel_shd.g_old_rec.sequence_number,p_sequence_number )
888: ,p_source_of_proficiency_level => get_non_gmisc_value( per_cel_shd.g_old_rec.source_of_proficiency_level, p_source_of_proficiency_level)
889: ,p_line_score => get_non_gmisc_value( per_cel_shd.g_old_rec.line_score,p_line_score )
890: ,p_certification_date => get_non_gmisc_value( per_cel_shd.g_old_rec.certification_date, p_certification_date)
891: ,p_certification_method => get_non_gmisc_value( per_cel_shd.g_old_rec.certification_method, p_certification_method)
892: ,p_next_certification_date => get_non_gmisc_value( per_cel_shd.g_old_rec.next_certification_date, p_next_certification_date)

Line 889: ,p_line_score => get_non_gmisc_value( per_cel_shd.g_old_rec.line_score,p_line_score )

885: ,p_normal_elapse_duration => get_non_gmisc_value( per_cel_shd.g_old_rec.normal_elapse_duration,p_normal_elapse_duration )
886: ,p_normal_elapse_duration_unit => get_non_gmisc_value( per_cel_shd.g_old_rec.normal_elapse_duration_unit,p_normal_elapse_duration_unit)
887: ,p_sequence_number => get_non_gmisc_value( per_cel_shd.g_old_rec.sequence_number,p_sequence_number )
888: ,p_source_of_proficiency_level => get_non_gmisc_value( per_cel_shd.g_old_rec.source_of_proficiency_level, p_source_of_proficiency_level)
889: ,p_line_score => get_non_gmisc_value( per_cel_shd.g_old_rec.line_score,p_line_score )
890: ,p_certification_date => get_non_gmisc_value( per_cel_shd.g_old_rec.certification_date, p_certification_date)
891: ,p_certification_method => get_non_gmisc_value( per_cel_shd.g_old_rec.certification_method, p_certification_method)
892: ,p_next_certification_date => get_non_gmisc_value( per_cel_shd.g_old_rec.next_certification_date, p_next_certification_date)
893: ,p_comments => get_non_gmisc_value( per_cel_shd.g_old_rec.comments, p_comments)

Line 890: ,p_certification_date => get_non_gmisc_value( per_cel_shd.g_old_rec.certification_date, p_certification_date)

886: ,p_normal_elapse_duration_unit => get_non_gmisc_value( per_cel_shd.g_old_rec.normal_elapse_duration_unit,p_normal_elapse_duration_unit)
887: ,p_sequence_number => get_non_gmisc_value( per_cel_shd.g_old_rec.sequence_number,p_sequence_number )
888: ,p_source_of_proficiency_level => get_non_gmisc_value( per_cel_shd.g_old_rec.source_of_proficiency_level, p_source_of_proficiency_level)
889: ,p_line_score => get_non_gmisc_value( per_cel_shd.g_old_rec.line_score,p_line_score )
890: ,p_certification_date => get_non_gmisc_value( per_cel_shd.g_old_rec.certification_date, p_certification_date)
891: ,p_certification_method => get_non_gmisc_value( per_cel_shd.g_old_rec.certification_method, p_certification_method)
892: ,p_next_certification_date => get_non_gmisc_value( per_cel_shd.g_old_rec.next_certification_date, p_next_certification_date)
893: ,p_comments => get_non_gmisc_value( per_cel_shd.g_old_rec.comments, p_comments)
894: ,p_attribute_category => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute_category, p_attribute_category)

Line 891: ,p_certification_method => get_non_gmisc_value( per_cel_shd.g_old_rec.certification_method, p_certification_method)

887: ,p_sequence_number => get_non_gmisc_value( per_cel_shd.g_old_rec.sequence_number,p_sequence_number )
888: ,p_source_of_proficiency_level => get_non_gmisc_value( per_cel_shd.g_old_rec.source_of_proficiency_level, p_source_of_proficiency_level)
889: ,p_line_score => get_non_gmisc_value( per_cel_shd.g_old_rec.line_score,p_line_score )
890: ,p_certification_date => get_non_gmisc_value( per_cel_shd.g_old_rec.certification_date, p_certification_date)
891: ,p_certification_method => get_non_gmisc_value( per_cel_shd.g_old_rec.certification_method, p_certification_method)
892: ,p_next_certification_date => get_non_gmisc_value( per_cel_shd.g_old_rec.next_certification_date, p_next_certification_date)
893: ,p_comments => get_non_gmisc_value( per_cel_shd.g_old_rec.comments, p_comments)
894: ,p_attribute_category => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute_category, p_attribute_category)
895: ,p_attribute1 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute1, p_attribute1)

Line 892: ,p_next_certification_date => get_non_gmisc_value( per_cel_shd.g_old_rec.next_certification_date, p_next_certification_date)

888: ,p_source_of_proficiency_level => get_non_gmisc_value( per_cel_shd.g_old_rec.source_of_proficiency_level, p_source_of_proficiency_level)
889: ,p_line_score => get_non_gmisc_value( per_cel_shd.g_old_rec.line_score,p_line_score )
890: ,p_certification_date => get_non_gmisc_value( per_cel_shd.g_old_rec.certification_date, p_certification_date)
891: ,p_certification_method => get_non_gmisc_value( per_cel_shd.g_old_rec.certification_method, p_certification_method)
892: ,p_next_certification_date => get_non_gmisc_value( per_cel_shd.g_old_rec.next_certification_date, p_next_certification_date)
893: ,p_comments => get_non_gmisc_value( per_cel_shd.g_old_rec.comments, p_comments)
894: ,p_attribute_category => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute_category, p_attribute_category)
895: ,p_attribute1 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute1, p_attribute1)
896: ,p_attribute2 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute2, p_attribute2)

Line 893: ,p_comments => get_non_gmisc_value( per_cel_shd.g_old_rec.comments, p_comments)

889: ,p_line_score => get_non_gmisc_value( per_cel_shd.g_old_rec.line_score,p_line_score )
890: ,p_certification_date => get_non_gmisc_value( per_cel_shd.g_old_rec.certification_date, p_certification_date)
891: ,p_certification_method => get_non_gmisc_value( per_cel_shd.g_old_rec.certification_method, p_certification_method)
892: ,p_next_certification_date => get_non_gmisc_value( per_cel_shd.g_old_rec.next_certification_date, p_next_certification_date)
893: ,p_comments => get_non_gmisc_value( per_cel_shd.g_old_rec.comments, p_comments)
894: ,p_attribute_category => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute_category, p_attribute_category)
895: ,p_attribute1 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute1, p_attribute1)
896: ,p_attribute2 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute2, p_attribute2)
897: ,p_attribute3 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute3, p_attribute3)

Line 894: ,p_attribute_category => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute_category, p_attribute_category)

890: ,p_certification_date => get_non_gmisc_value( per_cel_shd.g_old_rec.certification_date, p_certification_date)
891: ,p_certification_method => get_non_gmisc_value( per_cel_shd.g_old_rec.certification_method, p_certification_method)
892: ,p_next_certification_date => get_non_gmisc_value( per_cel_shd.g_old_rec.next_certification_date, p_next_certification_date)
893: ,p_comments => get_non_gmisc_value( per_cel_shd.g_old_rec.comments, p_comments)
894: ,p_attribute_category => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute_category, p_attribute_category)
895: ,p_attribute1 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute1, p_attribute1)
896: ,p_attribute2 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute2, p_attribute2)
897: ,p_attribute3 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute3, p_attribute3)
898: ,p_attribute4 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute4, p_attribute4)

Line 895: ,p_attribute1 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute1, p_attribute1)

891: ,p_certification_method => get_non_gmisc_value( per_cel_shd.g_old_rec.certification_method, p_certification_method)
892: ,p_next_certification_date => get_non_gmisc_value( per_cel_shd.g_old_rec.next_certification_date, p_next_certification_date)
893: ,p_comments => get_non_gmisc_value( per_cel_shd.g_old_rec.comments, p_comments)
894: ,p_attribute_category => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute_category, p_attribute_category)
895: ,p_attribute1 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute1, p_attribute1)
896: ,p_attribute2 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute2, p_attribute2)
897: ,p_attribute3 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute3, p_attribute3)
898: ,p_attribute4 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute4, p_attribute4)
899: ,p_attribute5 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute5, p_attribute5)

Line 896: ,p_attribute2 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute2, p_attribute2)

892: ,p_next_certification_date => get_non_gmisc_value( per_cel_shd.g_old_rec.next_certification_date, p_next_certification_date)
893: ,p_comments => get_non_gmisc_value( per_cel_shd.g_old_rec.comments, p_comments)
894: ,p_attribute_category => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute_category, p_attribute_category)
895: ,p_attribute1 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute1, p_attribute1)
896: ,p_attribute2 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute2, p_attribute2)
897: ,p_attribute3 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute3, p_attribute3)
898: ,p_attribute4 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute4, p_attribute4)
899: ,p_attribute5 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute5, p_attribute5)
900: ,p_attribute6 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute6, p_attribute6)

Line 897: ,p_attribute3 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute3, p_attribute3)

893: ,p_comments => get_non_gmisc_value( per_cel_shd.g_old_rec.comments, p_comments)
894: ,p_attribute_category => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute_category, p_attribute_category)
895: ,p_attribute1 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute1, p_attribute1)
896: ,p_attribute2 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute2, p_attribute2)
897: ,p_attribute3 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute3, p_attribute3)
898: ,p_attribute4 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute4, p_attribute4)
899: ,p_attribute5 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute5, p_attribute5)
900: ,p_attribute6 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute6, p_attribute6)
901: ,p_attribute7 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute7, p_attribute7)

Line 898: ,p_attribute4 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute4, p_attribute4)

894: ,p_attribute_category => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute_category, p_attribute_category)
895: ,p_attribute1 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute1, p_attribute1)
896: ,p_attribute2 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute2, p_attribute2)
897: ,p_attribute3 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute3, p_attribute3)
898: ,p_attribute4 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute4, p_attribute4)
899: ,p_attribute5 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute5, p_attribute5)
900: ,p_attribute6 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute6, p_attribute6)
901: ,p_attribute7 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute7, p_attribute7)
902: ,p_attribute8 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute8, p_attribute8)

Line 899: ,p_attribute5 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute5, p_attribute5)

895: ,p_attribute1 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute1, p_attribute1)
896: ,p_attribute2 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute2, p_attribute2)
897: ,p_attribute3 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute3, p_attribute3)
898: ,p_attribute4 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute4, p_attribute4)
899: ,p_attribute5 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute5, p_attribute5)
900: ,p_attribute6 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute6, p_attribute6)
901: ,p_attribute7 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute7, p_attribute7)
902: ,p_attribute8 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute8, p_attribute8)
903: ,p_attribute9 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute9, p_attribute9)

Line 900: ,p_attribute6 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute6, p_attribute6)

896: ,p_attribute2 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute2, p_attribute2)
897: ,p_attribute3 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute3, p_attribute3)
898: ,p_attribute4 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute4, p_attribute4)
899: ,p_attribute5 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute5, p_attribute5)
900: ,p_attribute6 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute6, p_attribute6)
901: ,p_attribute7 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute7, p_attribute7)
902: ,p_attribute8 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute8, p_attribute8)
903: ,p_attribute9 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute9, p_attribute9)
904: ,p_attribute10 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute10, p_attribute10)

Line 901: ,p_attribute7 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute7, p_attribute7)

897: ,p_attribute3 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute3, p_attribute3)
898: ,p_attribute4 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute4, p_attribute4)
899: ,p_attribute5 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute5, p_attribute5)
900: ,p_attribute6 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute6, p_attribute6)
901: ,p_attribute7 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute7, p_attribute7)
902: ,p_attribute8 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute8, p_attribute8)
903: ,p_attribute9 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute9, p_attribute9)
904: ,p_attribute10 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute10, p_attribute10)
905: ,p_attribute11 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute11, p_attribute11)

Line 902: ,p_attribute8 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute8, p_attribute8)

898: ,p_attribute4 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute4, p_attribute4)
899: ,p_attribute5 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute5, p_attribute5)
900: ,p_attribute6 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute6, p_attribute6)
901: ,p_attribute7 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute7, p_attribute7)
902: ,p_attribute8 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute8, p_attribute8)
903: ,p_attribute9 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute9, p_attribute9)
904: ,p_attribute10 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute10, p_attribute10)
905: ,p_attribute11 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute11, p_attribute11)
906: ,p_attribute12 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute12, p_attribute12)

Line 903: ,p_attribute9 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute9, p_attribute9)

899: ,p_attribute5 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute5, p_attribute5)
900: ,p_attribute6 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute6, p_attribute6)
901: ,p_attribute7 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute7, p_attribute7)
902: ,p_attribute8 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute8, p_attribute8)
903: ,p_attribute9 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute9, p_attribute9)
904: ,p_attribute10 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute10, p_attribute10)
905: ,p_attribute11 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute11, p_attribute11)
906: ,p_attribute12 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute12, p_attribute12)
907: ,p_attribute13 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute13, p_attribute13)

Line 904: ,p_attribute10 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute10, p_attribute10)

900: ,p_attribute6 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute6, p_attribute6)
901: ,p_attribute7 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute7, p_attribute7)
902: ,p_attribute8 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute8, p_attribute8)
903: ,p_attribute9 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute9, p_attribute9)
904: ,p_attribute10 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute10, p_attribute10)
905: ,p_attribute11 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute11, p_attribute11)
906: ,p_attribute12 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute12, p_attribute12)
907: ,p_attribute13 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute13, p_attribute13)
908: ,p_attribute14 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute14, p_attribute14)

Line 905: ,p_attribute11 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute11, p_attribute11)

901: ,p_attribute7 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute7, p_attribute7)
902: ,p_attribute8 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute8, p_attribute8)
903: ,p_attribute9 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute9, p_attribute9)
904: ,p_attribute10 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute10, p_attribute10)
905: ,p_attribute11 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute11, p_attribute11)
906: ,p_attribute12 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute12, p_attribute12)
907: ,p_attribute13 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute13, p_attribute13)
908: ,p_attribute14 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute14, p_attribute14)
909: ,p_attribute15 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute15, p_attribute15)

Line 906: ,p_attribute12 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute12, p_attribute12)

902: ,p_attribute8 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute8, p_attribute8)
903: ,p_attribute9 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute9, p_attribute9)
904: ,p_attribute10 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute10, p_attribute10)
905: ,p_attribute11 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute11, p_attribute11)
906: ,p_attribute12 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute12, p_attribute12)
907: ,p_attribute13 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute13, p_attribute13)
908: ,p_attribute14 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute14, p_attribute14)
909: ,p_attribute15 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute15, p_attribute15)
910: ,p_attribute16 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute16, p_attribute16)

Line 907: ,p_attribute13 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute13, p_attribute13)

903: ,p_attribute9 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute9, p_attribute9)
904: ,p_attribute10 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute10, p_attribute10)
905: ,p_attribute11 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute11, p_attribute11)
906: ,p_attribute12 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute12, p_attribute12)
907: ,p_attribute13 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute13, p_attribute13)
908: ,p_attribute14 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute14, p_attribute14)
909: ,p_attribute15 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute15, p_attribute15)
910: ,p_attribute16 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute16, p_attribute16)
911: ,p_attribute17 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute17, p_attribute17)

Line 908: ,p_attribute14 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute14, p_attribute14)

904: ,p_attribute10 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute10, p_attribute10)
905: ,p_attribute11 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute11, p_attribute11)
906: ,p_attribute12 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute12, p_attribute12)
907: ,p_attribute13 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute13, p_attribute13)
908: ,p_attribute14 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute14, p_attribute14)
909: ,p_attribute15 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute15, p_attribute15)
910: ,p_attribute16 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute16, p_attribute16)
911: ,p_attribute17 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute17, p_attribute17)
912: ,p_attribute18 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute18, p_attribute18)

Line 909: ,p_attribute15 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute15, p_attribute15)

905: ,p_attribute11 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute11, p_attribute11)
906: ,p_attribute12 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute12, p_attribute12)
907: ,p_attribute13 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute13, p_attribute13)
908: ,p_attribute14 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute14, p_attribute14)
909: ,p_attribute15 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute15, p_attribute15)
910: ,p_attribute16 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute16, p_attribute16)
911: ,p_attribute17 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute17, p_attribute17)
912: ,p_attribute18 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute18, p_attribute18)
913: ,p_attribute19 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute19, p_attribute19)

Line 910: ,p_attribute16 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute16, p_attribute16)

906: ,p_attribute12 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute12, p_attribute12)
907: ,p_attribute13 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute13, p_attribute13)
908: ,p_attribute14 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute14, p_attribute14)
909: ,p_attribute15 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute15, p_attribute15)
910: ,p_attribute16 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute16, p_attribute16)
911: ,p_attribute17 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute17, p_attribute17)
912: ,p_attribute18 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute18, p_attribute18)
913: ,p_attribute19 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute19, p_attribute19)
914: ,p_attribute20 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute20, p_attribute20)

Line 911: ,p_attribute17 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute17, p_attribute17)

907: ,p_attribute13 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute13, p_attribute13)
908: ,p_attribute14 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute14, p_attribute14)
909: ,p_attribute15 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute15, p_attribute15)
910: ,p_attribute16 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute16, p_attribute16)
911: ,p_attribute17 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute17, p_attribute17)
912: ,p_attribute18 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute18, p_attribute18)
913: ,p_attribute19 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute19, p_attribute19)
914: ,p_attribute20 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute20, p_attribute20)
915: ,p_effective_date => p_effective_date

Line 912: ,p_attribute18 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute18, p_attribute18)

908: ,p_attribute14 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute14, p_attribute14)
909: ,p_attribute15 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute15, p_attribute15)
910: ,p_attribute16 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute16, p_attribute16)
911: ,p_attribute17 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute17, p_attribute17)
912: ,p_attribute18 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute18, p_attribute18)
913: ,p_attribute19 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute19, p_attribute19)
914: ,p_attribute20 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute20, p_attribute20)
915: ,p_effective_date => p_effective_date
916: ,p_object_id => per_cel_shd.g_old_rec.object_id

Line 913: ,p_attribute19 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute19, p_attribute19)

909: ,p_attribute15 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute15, p_attribute15)
910: ,p_attribute16 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute16, p_attribute16)
911: ,p_attribute17 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute17, p_attribute17)
912: ,p_attribute18 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute18, p_attribute18)
913: ,p_attribute19 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute19, p_attribute19)
914: ,p_attribute20 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute20, p_attribute20)
915: ,p_effective_date => p_effective_date
916: ,p_object_id => per_cel_shd.g_old_rec.object_id
917: ,p_object_name => per_cel_shd.g_old_rec.object_name

Line 914: ,p_attribute20 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute20, p_attribute20)

910: ,p_attribute16 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute16, p_attribute16)
911: ,p_attribute17 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute17, p_attribute17)
912: ,p_attribute18 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute18, p_attribute18)
913: ,p_attribute19 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute19, p_attribute19)
914: ,p_attribute20 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute20, p_attribute20)
915: ,p_effective_date => p_effective_date
916: ,p_object_id => per_cel_shd.g_old_rec.object_id
917: ,p_object_name => per_cel_shd.g_old_rec.object_name
918: ,p_party_id => get_non_gmisc_value( per_cel_shd.g_old_rec.party_id, p_party_id)

Line 916: ,p_object_id => per_cel_shd.g_old_rec.object_id

912: ,p_attribute18 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute18, p_attribute18)
913: ,p_attribute19 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute19, p_attribute19)
914: ,p_attribute20 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute20, p_attribute20)
915: ,p_effective_date => p_effective_date
916: ,p_object_id => per_cel_shd.g_old_rec.object_id
917: ,p_object_name => per_cel_shd.g_old_rec.object_name
918: ,p_party_id => get_non_gmisc_value( per_cel_shd.g_old_rec.party_id, p_party_id)
919: ,p_appr_line_score => get_non_gmisc_value( per_cel_shd.g_old_rec.appr_line_score, p_appr_line_score)
920: ,p_status => get_non_gmisc_value( per_cel_shd.g_old_rec.status, p_status)

Line 917: ,p_object_name => per_cel_shd.g_old_rec.object_name

913: ,p_attribute19 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute19, p_attribute19)
914: ,p_attribute20 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute20, p_attribute20)
915: ,p_effective_date => p_effective_date
916: ,p_object_id => per_cel_shd.g_old_rec.object_id
917: ,p_object_name => per_cel_shd.g_old_rec.object_name
918: ,p_party_id => get_non_gmisc_value( per_cel_shd.g_old_rec.party_id, p_party_id)
919: ,p_appr_line_score => get_non_gmisc_value( per_cel_shd.g_old_rec.appr_line_score, p_appr_line_score)
920: ,p_status => get_non_gmisc_value( per_cel_shd.g_old_rec.status, p_status)
921: );

Line 918: ,p_party_id => get_non_gmisc_value( per_cel_shd.g_old_rec.party_id, p_party_id)

914: ,p_attribute20 => get_non_gmisc_value( per_cel_shd.g_old_rec.attribute20, p_attribute20)
915: ,p_effective_date => p_effective_date
916: ,p_object_id => per_cel_shd.g_old_rec.object_id
917: ,p_object_name => per_cel_shd.g_old_rec.object_name
918: ,p_party_id => get_non_gmisc_value( per_cel_shd.g_old_rec.party_id, p_party_id)
919: ,p_appr_line_score => get_non_gmisc_value( per_cel_shd.g_old_rec.appr_line_score, p_appr_line_score)
920: ,p_status => get_non_gmisc_value( per_cel_shd.g_old_rec.status, p_status)
921: );
922: g_session_id := ICX_SEC.G_SESSION_ID;

Line 919: ,p_appr_line_score => get_non_gmisc_value( per_cel_shd.g_old_rec.appr_line_score, p_appr_line_score)

915: ,p_effective_date => p_effective_date
916: ,p_object_id => per_cel_shd.g_old_rec.object_id
917: ,p_object_name => per_cel_shd.g_old_rec.object_name
918: ,p_party_id => get_non_gmisc_value( per_cel_shd.g_old_rec.party_id, p_party_id)
919: ,p_appr_line_score => get_non_gmisc_value( per_cel_shd.g_old_rec.appr_line_score, p_appr_line_score)
920: ,p_status => get_non_gmisc_value( per_cel_shd.g_old_rec.status, p_status)
921: );
922: g_session_id := ICX_SEC.G_SESSION_ID;
923: g_competence_element_id := l_competence_element_id;

Line 920: ,p_status => get_non_gmisc_value( per_cel_shd.g_old_rec.status, p_status)

916: ,p_object_id => per_cel_shd.g_old_rec.object_id
917: ,p_object_name => per_cel_shd.g_old_rec.object_name
918: ,p_party_id => get_non_gmisc_value( per_cel_shd.g_old_rec.party_id, p_party_id)
919: ,p_appr_line_score => get_non_gmisc_value( per_cel_shd.g_old_rec.appr_line_score, p_appr_line_score)
920: ,p_status => get_non_gmisc_value( per_cel_shd.g_old_rec.status, p_status)
921: );
922: g_session_id := ICX_SEC.G_SESSION_ID;
923: g_competence_element_id := l_competence_element_id;
924: end if;