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 2278: l_assessment_comp_id per_assessments.assessment_id%TYPE;

2274: l_assess_obj_return_status VARCHAR2(10) default null;
2275: l_apprl_id per_appraisals.appraisal_id%TYPE default null;
2276: l_apprl_templ_info appraisal_templ_info;
2277: NO_APPRL_TEMPL_WITH_THIS_ID EXCEPTION;
2278: l_assessment_comp_id per_assessments.assessment_id%TYPE;
2279: l_assessment_obj_id per_assessments.assessment_id%TYPE;
2280: l_assessment_comp_ovn per_assessments.object_version_number%TYPE;
2281: l_assessment_obj_ovn per_assessments.object_version_number%TYPE;
2282: l_assess_comps assess_comps_info;

Line 2279: l_assessment_obj_id per_assessments.assessment_id%TYPE;

2275: l_apprl_id per_appraisals.appraisal_id%TYPE default null;
2276: l_apprl_templ_info appraisal_templ_info;
2277: NO_APPRL_TEMPL_WITH_THIS_ID EXCEPTION;
2278: l_assessment_comp_id per_assessments.assessment_id%TYPE;
2279: l_assessment_obj_id per_assessments.assessment_id%TYPE;
2280: l_assessment_comp_ovn per_assessments.object_version_number%TYPE;
2281: l_assessment_obj_ovn per_assessments.object_version_number%TYPE;
2282: l_assess_comps assess_comps_info;
2283: l_check_default_job_comps varchar2(2) default '';

Line 2280: l_assessment_comp_ovn per_assessments.object_version_number%TYPE;

2276: l_apprl_templ_info appraisal_templ_info;
2277: NO_APPRL_TEMPL_WITH_THIS_ID EXCEPTION;
2278: l_assessment_comp_id per_assessments.assessment_id%TYPE;
2279: l_assessment_obj_id per_assessments.assessment_id%TYPE;
2280: l_assessment_comp_ovn per_assessments.object_version_number%TYPE;
2281: l_assessment_obj_ovn per_assessments.object_version_number%TYPE;
2282: l_assess_comps assess_comps_info;
2283: l_check_default_job_comps varchar2(2) default '';
2284:

Line 2281: l_assessment_obj_ovn per_assessments.object_version_number%TYPE;

2277: NO_APPRL_TEMPL_WITH_THIS_ID EXCEPTION;
2278: l_assessment_comp_id per_assessments.assessment_id%TYPE;
2279: l_assessment_obj_id per_assessments.assessment_id%TYPE;
2280: l_assessment_comp_ovn per_assessments.object_version_number%TYPE;
2281: l_assessment_obj_ovn per_assessments.object_version_number%TYPE;
2282: l_assess_comps assess_comps_info;
2283: l_check_default_job_comps varchar2(2) default '';
2284:
2285: l_comp_ele_id per_competence_elements.competence_element_id%TYPE;

Line 2850: select assessment_id, object_version_number from per_assessments

2846: -- Declare local variables
2847: l_proc varchar2(72) := g_package||'delete_appraisal_for_person ';
2848:
2849: cursor get_assessm_for_apprl(apprl_id per_appraisals.appraisal_id%TYPE) is
2850: select assessment_id, object_version_number from per_assessments
2851: where appraisal_id = apprl_id;
2852:
2853: cursor get_competences(assess_id per_assessments.assessment_id%TYPE) is
2854: select competence_element_id, object_version_number from per_competence_elements

Line 2853: cursor get_competences(assess_id per_assessments.assessment_id%TYPE) is

2849: cursor get_assessm_for_apprl(apprl_id per_appraisals.appraisal_id%TYPE) is
2850: select assessment_id, object_version_number from per_assessments
2851: where appraisal_id = apprl_id;
2852:
2853: cursor get_competences(assess_id per_assessments.assessment_id%TYPE) is
2854: select competence_element_id, object_version_number from per_competence_elements
2855: where assessment_id = assess_id order by competence_element_id desc ;
2856:
2857: --