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_WPM_MASS_APR_PUSH dependencies on PER_ASSESSMENTS

Line 1224: l_assessment_comp_id per_assessments.assessment_id%TYPE;

1220: l_apprl_id per_appraisals.appraisal_id%TYPE
1221: DEFAULT NULL;
1222: l_apprl_templ_info appraisal_templ_info;
1223: no_apprl_templ_with_this_id EXCEPTION;
1224: l_assessment_comp_id per_assessments.assessment_id%TYPE;
1225: l_assessment_obj_id per_assessments.assessment_id%TYPE;
1226: l_assessment_comp_ovn per_assessments.object_version_number%TYPE;
1227: l_assessment_obj_ovn per_assessments.object_version_number%TYPE;
1228: l_assess_comps assess_comps_info;

Line 1225: l_assessment_obj_id per_assessments.assessment_id%TYPE;

1221: DEFAULT NULL;
1222: l_apprl_templ_info appraisal_templ_info;
1223: no_apprl_templ_with_this_id EXCEPTION;
1224: l_assessment_comp_id per_assessments.assessment_id%TYPE;
1225: l_assessment_obj_id per_assessments.assessment_id%TYPE;
1226: l_assessment_comp_ovn per_assessments.object_version_number%TYPE;
1227: l_assessment_obj_ovn per_assessments.object_version_number%TYPE;
1228: l_assess_comps assess_comps_info;
1229: l_check_default_job_comps VARCHAR2 (2) DEFAULT '';

Line 1226: l_assessment_comp_ovn per_assessments.object_version_number%TYPE;

1222: l_apprl_templ_info appraisal_templ_info;
1223: no_apprl_templ_with_this_id EXCEPTION;
1224: l_assessment_comp_id per_assessments.assessment_id%TYPE;
1225: l_assessment_obj_id per_assessments.assessment_id%TYPE;
1226: l_assessment_comp_ovn per_assessments.object_version_number%TYPE;
1227: l_assessment_obj_ovn per_assessments.object_version_number%TYPE;
1228: l_assess_comps assess_comps_info;
1229: l_check_default_job_comps VARCHAR2 (2) DEFAULT '';
1230: l_comp_ele_id per_competence_elements.competence_element_id%TYPE;

Line 1227: l_assessment_obj_ovn per_assessments.object_version_number%TYPE;

1223: no_apprl_templ_with_this_id EXCEPTION;
1224: l_assessment_comp_id per_assessments.assessment_id%TYPE;
1225: l_assessment_obj_id per_assessments.assessment_id%TYPE;
1226: l_assessment_comp_ovn per_assessments.object_version_number%TYPE;
1227: l_assessment_obj_ovn per_assessments.object_version_number%TYPE;
1228: l_assess_comps assess_comps_info;
1229: l_check_default_job_comps VARCHAR2 (2) DEFAULT '';
1230: l_comp_ele_id per_competence_elements.competence_element_id%TYPE;
1231: l_comp_ovn per_competence_elements.object_version_number%TYPE;

Line 1286: FROM per_assessments

1282: SELECT 'Y'
1283: FROM DUAL
1284: WHERE EXISTS (
1285: SELECT '1'
1286: FROM per_assessments
1287: WHERE appraisal_id = p_appraisal_id
1288: AND assessment_type_id = p_assessment_type_id);
1289:
1290: l_comp_ass_exists VARCHAR2 (1);