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_COMPLETE_APPRAISAL_SS dependencies on PER_COMPETENCE_ELEMENTS

Line 449: from per_competence_elements pce, per_appraisals pa, per_all_people_f ppf, per_competences pc,

445: cursor get_assessment_competences (appr_id IN number) is
446: select pce.competence_id, pc.name, pce.competence_element_id, pce.proficiency_level_id,
447: pce.business_group_id, pce.enterprise_id,pce.effective_date_from, pce.effective_date_to, pa.appraisal_id, pa.appraisee_person_id,
448: ppf.party_id, decode(rating.step_value, null, null, rating.step_value||' - '||rating.name) prof_level
449: from per_competence_elements pce, per_appraisals pa, per_all_people_f ppf, per_competences pc,
450: per_rating_levels rating
451: where pce.type='ASSESSMENT'
452: and pce.object_name = 'APPRAISAL_ID'
453: and pce.object_id = appr_id

Line 485: from per_appraisals appr, per_competence_elements pce

481: pce.attribute13, pce.attribute14, pce.attribute15, pce.attribute16,
482: pce.attribute17, pce.attribute18, pce.attribute19,
483: pce.attribute20, pce.object_id,
484: pce.object_name, pce.party_id
485: from per_appraisals appr, per_competence_elements pce
486: where appr.appraisal_id = appr_id
487: and appr.appraisee_person_id = pce.person_id
488: and pce.type = 'PERSONAL'
489: and trunc(sysdate) between pce.effective_date_from and

Line 514: l_old_ovn per_competence_elements.object_version_number%TYPE;

510: -- AND ceo.DATE_FROM <= p_effective_date
511: -- And nvl(ceo.DATE_TO,p_effective_date) >= p_effective_date ;
512:
513: match_found boolean default false;
514: l_old_ovn per_competence_elements.object_version_number%TYPE;
515: l_new_ovn per_competence_elements.object_version_number%TYPE;
516: l_comp_ele_id per_competence_elements.competence_element_id%TYPE;
517: talent_mang_src_typ varchar2(100);
518: each_comp_status varchar2(10);

Line 515: l_new_ovn per_competence_elements.object_version_number%TYPE;

511: -- And nvl(ceo.DATE_TO,p_effective_date) >= p_effective_date ;
512:
513: match_found boolean default false;
514: l_old_ovn per_competence_elements.object_version_number%TYPE;
515: l_new_ovn per_competence_elements.object_version_number%TYPE;
516: l_comp_ele_id per_competence_elements.competence_element_id%TYPE;
517: talent_mang_src_typ varchar2(100);
518: each_comp_status varchar2(10);
519: error_message varchar2(500) default null;

Line 516: l_comp_ele_id per_competence_elements.competence_element_id%TYPE;

512:
513: match_found boolean default false;
514: l_old_ovn per_competence_elements.object_version_number%TYPE;
515: l_new_ovn per_competence_elements.object_version_number%TYPE;
516: l_comp_ele_id per_competence_elements.competence_element_id%TYPE;
517: talent_mang_src_typ varchar2(100);
518: each_comp_status varchar2(10);
519: error_message varchar2(500) default null;
520: assessed_comps number default 0;

Line 526: l_comp_status per_competence_elements.status%type;

522:
523: l_out_from_date per_comp_element_outcomes.DATE_FROM%type;
524: l_out_ovn per_comp_element_outcomes.OBJECT_VERSION_NUMBER%type;
525: l_comp_ele_out_id per_comp_element_outcomes.COMP_ELEMENT_OUTCOME_ID%type;
526: l_comp_status per_competence_elements.status%type;
527: l_achieved_date per_competence_elements.ACHIEVED_DATE%type;
528:
529: BEGIN
530:

Line 527: l_achieved_date per_competence_elements.ACHIEVED_DATE%type;

523: l_out_from_date per_comp_element_outcomes.DATE_FROM%type;
524: l_out_ovn per_comp_element_outcomes.OBJECT_VERSION_NUMBER%type;
525: l_comp_ele_out_id per_comp_element_outcomes.COMP_ELEMENT_OUTCOME_ID%type;
526: l_comp_status per_competence_elements.status%type;
527: l_achieved_date per_competence_elements.ACHIEVED_DATE%type;
528:
529: BEGIN
530:
531: -- write an utility to get the value to apply the changes or not

Line 1769: next_comp_ele_id per_competence_elements.competence_element_id%TYPE;

1765: IS
1766: appraisal_id per_appraisals.appraisal_id%type;
1767: l_ins_ovn number;
1768: l_ins_comp_id number;
1769: next_comp_ele_id per_competence_elements.competence_element_id%TYPE;
1770: l_person_id number;
1771: l_log varchar2(4000);
1772: chg_appr_status varchar2(2);
1773: apply_pers_profile_status varchar2(2);