APPS.HR_COMPLETE_APPRAISAL_SS dependencies on PER_COMPETENCE_ELEMENTS

Line 559: FROM per_competence_elements pce,

555: pa.appraisee_person_id,
556: ppf.party_id,
557: DECODE (rating.step_value, NULL, NULL, rating.step_value || ' - ' || rating.NAME)
558: prof_level
559: FROM per_competence_elements pce,
560: per_appraisals pa,
561: per_all_people_f ppf,
562: per_competences pc,
563: per_rating_levels rating

Line 635: FROM per_appraisals appr, per_competence_elements pce

631: pce.attribute20,
632: pce.object_id,
633: pce.object_name,
634: pce.party_id
635: FROM per_appraisals appr, per_competence_elements pce
636: WHERE appr.appraisal_id = appr_id
637: AND appr.appraisee_person_id = pce.person_id
638: AND pce.TYPE = 'PERSONAL'
639: AND TRUNC (SYSDATE) BETWEEN pce.effective_date_from

Line 702: l_old_ovn per_competence_elements.object_version_number%TYPE;

698:
699: -- AND ceo.DATE_FROM <= p_effective_date
700: -- And nvl(ceo.DATE_TO,p_effective_date) >= p_effective_date ;
701: match_found BOOLEAN DEFAULT FALSE;
702: l_old_ovn per_competence_elements.object_version_number%TYPE;
703: l_new_ovn per_competence_elements.object_version_number%TYPE;
704: l_comp_ele_id per_competence_elements.competence_element_id%TYPE;
705: talent_mang_src_typ VARCHAR2 (100);
706: each_comp_status VARCHAR2 (10);

Line 703: l_new_ovn per_competence_elements.object_version_number%TYPE;

699: -- AND ceo.DATE_FROM <= p_effective_date
700: -- And nvl(ceo.DATE_TO,p_effective_date) >= p_effective_date ;
701: match_found BOOLEAN DEFAULT FALSE;
702: l_old_ovn per_competence_elements.object_version_number%TYPE;
703: l_new_ovn per_competence_elements.object_version_number%TYPE;
704: l_comp_ele_id per_competence_elements.competence_element_id%TYPE;
705: talent_mang_src_typ VARCHAR2 (100);
706: each_comp_status VARCHAR2 (10);
707: error_message VARCHAR2 (500) DEFAULT NULL;

Line 704: l_comp_ele_id per_competence_elements.competence_element_id%TYPE;

700: -- And nvl(ceo.DATE_TO,p_effective_date) >= p_effective_date ;
701: match_found BOOLEAN DEFAULT FALSE;
702: l_old_ovn per_competence_elements.object_version_number%TYPE;
703: l_new_ovn per_competence_elements.object_version_number%TYPE;
704: l_comp_ele_id per_competence_elements.competence_element_id%TYPE;
705: talent_mang_src_typ VARCHAR2 (100);
706: each_comp_status VARCHAR2 (10);
707: error_message VARCHAR2 (500) DEFAULT NULL;
708: assessed_comps NUMBER DEFAULT 0;

Line 713: l_comp_status per_competence_elements.status%TYPE;

709: l_comp_log VARCHAR2 (32767);
710: l_out_from_date per_comp_element_outcomes.date_from%TYPE;
711: l_out_ovn per_comp_element_outcomes.object_version_number%TYPE;
712: l_comp_ele_out_id per_comp_element_outcomes.comp_element_outcome_id%TYPE;
713: l_comp_status per_competence_elements.status%TYPE;
714: l_achieved_date per_competence_elements.achieved_date%TYPE;
715: BEGIN
716: -- write an utility to get the value to apply the changes or not
717: hr_multi_message.enable_message_list;

Line 714: l_achieved_date per_competence_elements.achieved_date%TYPE;

710: l_out_from_date per_comp_element_outcomes.date_from%TYPE;
711: l_out_ovn per_comp_element_outcomes.object_version_number%TYPE;
712: l_comp_ele_out_id per_comp_element_outcomes.comp_element_outcome_id%TYPE;
713: l_comp_status per_competence_elements.status%TYPE;
714: l_achieved_date per_competence_elements.achieved_date%TYPE;
715: BEGIN
716: -- write an utility to get the value to apply the changes or not
717: hr_multi_message.enable_message_list;
718:

Line 2593: next_comp_ele_id per_competence_elements.competence_element_id%TYPE;

2589: IS
2590: appraisal_id per_appraisals.appraisal_id%TYPE;
2591: l_ins_ovn NUMBER;
2592: l_ins_comp_id NUMBER;
2593: next_comp_ele_id per_competence_elements.competence_element_id%TYPE;
2594: l_person_id NUMBER;
2595: l_log VARCHAR2 (4000);
2596: chg_appr_status VARCHAR2 (2);
2597: apply_pers_profile_status VARCHAR2 (2);