[Home] [Help]
899: l_assess_obj_return_status VARCHAR2(10) default null;
900: l_apprl_id per_appraisals.appraisal_id%TYPE default null;
901: l_apprl_templ_info appraisal_templ_info;
902: NO_APPRL_TEMPL_WITH_THIS_ID EXCEPTION;
903: l_assessment_comp_id per_assessments.assessment_id%TYPE;
904: l_assessment_obj_id per_assessments.assessment_id%TYPE;
905: l_assessment_comp_ovn per_assessments.object_version_number%TYPE;
906: l_assessment_obj_ovn per_assessments.object_version_number%TYPE;
907: l_assess_comps assess_comps_info;
900: l_apprl_id per_appraisals.appraisal_id%TYPE default null;
901: l_apprl_templ_info appraisal_templ_info;
902: NO_APPRL_TEMPL_WITH_THIS_ID EXCEPTION;
903: l_assessment_comp_id per_assessments.assessment_id%TYPE;
904: l_assessment_obj_id per_assessments.assessment_id%TYPE;
905: l_assessment_comp_ovn per_assessments.object_version_number%TYPE;
906: l_assessment_obj_ovn per_assessments.object_version_number%TYPE;
907: l_assess_comps assess_comps_info;
908: l_check_default_job_comps varchar2(2) default '';
901: l_apprl_templ_info appraisal_templ_info;
902: NO_APPRL_TEMPL_WITH_THIS_ID EXCEPTION;
903: l_assessment_comp_id per_assessments.assessment_id%TYPE;
904: l_assessment_obj_id per_assessments.assessment_id%TYPE;
905: l_assessment_comp_ovn per_assessments.object_version_number%TYPE;
906: l_assessment_obj_ovn per_assessments.object_version_number%TYPE;
907: l_assess_comps assess_comps_info;
908: l_check_default_job_comps varchar2(2) default '';
909:
902: NO_APPRL_TEMPL_WITH_THIS_ID EXCEPTION;
903: l_assessment_comp_id per_assessments.assessment_id%TYPE;
904: l_assessment_obj_id per_assessments.assessment_id%TYPE;
905: l_assessment_comp_ovn per_assessments.object_version_number%TYPE;
906: l_assessment_obj_ovn per_assessments.object_version_number%TYPE;
907: l_assess_comps assess_comps_info;
908: l_check_default_job_comps varchar2(2) default '';
909:
910: l_comp_ele_id per_competence_elements.competence_element_id%TYPE;