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.

[Home] [Help]

APPS.HR_PERF_MGMT_PLAN_INTERNAL dependencies on PER_ASSESSMENTS

Line 3056: l_assessment_comp_id per_assessments.assessment_id%TYPE;

3052: l_assess_obj_return_status VARCHAR2 (10) DEFAULT NULL;
3053: l_apprl_id per_appraisals.appraisal_id%TYPE DEFAULT NULL;
3054: l_apprl_templ_info appraisal_templ_info;
3055: no_apprl_templ_with_this_id EXCEPTION;
3056: l_assessment_comp_id per_assessments.assessment_id%TYPE;
3057: l_assessment_obj_id per_assessments.assessment_id%TYPE;
3058: l_assessment_comp_ovn per_assessments.object_version_number%TYPE;
3059: l_assessment_obj_ovn per_assessments.object_version_number%TYPE;
3060: l_assess_comps assess_comps_info;

Line 3057: l_assessment_obj_id per_assessments.assessment_id%TYPE;

3053: l_apprl_id per_appraisals.appraisal_id%TYPE DEFAULT NULL;
3054: l_apprl_templ_info appraisal_templ_info;
3055: no_apprl_templ_with_this_id EXCEPTION;
3056: l_assessment_comp_id per_assessments.assessment_id%TYPE;
3057: l_assessment_obj_id per_assessments.assessment_id%TYPE;
3058: l_assessment_comp_ovn per_assessments.object_version_number%TYPE;
3059: l_assessment_obj_ovn per_assessments.object_version_number%TYPE;
3060: l_assess_comps assess_comps_info;
3061: l_check_default_job_comps VARCHAR2 (2) DEFAULT '';

Line 3058: l_assessment_comp_ovn per_assessments.object_version_number%TYPE;

3054: l_apprl_templ_info appraisal_templ_info;
3055: no_apprl_templ_with_this_id EXCEPTION;
3056: l_assessment_comp_id per_assessments.assessment_id%TYPE;
3057: l_assessment_obj_id per_assessments.assessment_id%TYPE;
3058: l_assessment_comp_ovn per_assessments.object_version_number%TYPE;
3059: l_assessment_obj_ovn per_assessments.object_version_number%TYPE;
3060: l_assess_comps assess_comps_info;
3061: l_check_default_job_comps VARCHAR2 (2) DEFAULT '';
3062: l_comp_ele_id per_competence_elements.competence_element_id%TYPE;

Line 3059: l_assessment_obj_ovn per_assessments.object_version_number%TYPE;

3055: no_apprl_templ_with_this_id EXCEPTION;
3056: l_assessment_comp_id per_assessments.assessment_id%TYPE;
3057: l_assessment_obj_id per_assessments.assessment_id%TYPE;
3058: l_assessment_comp_ovn per_assessments.object_version_number%TYPE;
3059: l_assessment_obj_ovn per_assessments.object_version_number%TYPE;
3060: l_assess_comps assess_comps_info;
3061: l_check_default_job_comps VARCHAR2 (2) DEFAULT '';
3062: l_comp_ele_id per_competence_elements.competence_element_id%TYPE;
3063: l_comp_ovn per_competence_elements.object_version_number%TYPE;

Line 3762: FROM per_assessments

3758:
3759: CURSOR get_assessm_for_apprl (apprl_id per_appraisals.appraisal_id%TYPE)
3760: IS
3761: SELECT assessment_id, object_version_number
3762: FROM per_assessments
3763: WHERE appraisal_id = apprl_id;
3764:
3765: CURSOR get_competences (assess_id per_assessments.assessment_id%TYPE)
3766: IS

Line 3765: CURSOR get_competences (assess_id per_assessments.assessment_id%TYPE)

3761: SELECT assessment_id, object_version_number
3762: FROM per_assessments
3763: WHERE appraisal_id = apprl_id;
3764:
3765: CURSOR get_competences (assess_id per_assessments.assessment_id%TYPE)
3766: IS
3767: SELECT competence_element_id, object_version_number
3768: FROM per_competence_elements
3769: WHERE assessment_id = assess_id