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_APPRAISAL_TEMPLATES

Line 443: p_talent_mang_src_typ per_appraisal_templates.COMP_PROFILE_SOURCE_TYPE%TYPE)

439: ( appr_id per_appraisals.appraisal_id%TYPE,
440: p_log in out nocopy varchar2,
441: apply_pers_profile_status in out nocopy varchar2,
442: p_new_appraisal in boolean DEFAULT true,
443: p_talent_mang_src_typ per_appraisal_templates.COMP_PROFILE_SOURCE_TYPE%TYPE)
444: IS
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,

Line 1728: l_curr_appr_tmplt_id per_appraisal_templates.appraisal_template_id%type;

1724:
1725: PROCEDURE post_appraisal_completion(p_appraisal_id in number)
1726: IS
1727: l_plan_id per_perf_mgmt_plans.plan_id%type;
1728: l_curr_appr_tmplt_id per_appraisal_templates.appraisal_template_id%type;
1729:
1730: CURSOR get_plan_template_id IS
1731: SELECT plan_id, appraisal_template_id
1732: FROM per_appraisals

Line 1781: l_talent_mang_src_typ per_appraisal_templates.COMP_PROFILE_SOURCE_TYPE%TYPE;

1777: lv_apply_pers_comps_log wf_item_attributes.text_default%TYPE;
1778: lv_upd_train_comps_status_log wf_item_attributes.text_default%TYPE;
1779: lv_upd_create_event_status_log wf_item_attributes.text_default%TYPE;
1780: p_new_appraisal boolean;
1781: l_talent_mang_src_typ per_appraisal_templates.COMP_PROFILE_SOURCE_TYPE%TYPE;
1782: l_available_flag per_appraisal_templates.available_flag%TYPE;
1783: update_personal_profile varchar2(100) default null;
1784: l_proc varchar2(100);
1785: cursor c_appr_template_details(c_appraisal_id in number) is

Line 1782: l_available_flag per_appraisal_templates.available_flag%TYPE;

1778: lv_upd_train_comps_status_log wf_item_attributes.text_default%TYPE;
1779: lv_upd_create_event_status_log wf_item_attributes.text_default%TYPE;
1780: p_new_appraisal boolean;
1781: l_talent_mang_src_typ per_appraisal_templates.COMP_PROFILE_SOURCE_TYPE%TYPE;
1782: l_available_flag per_appraisal_templates.available_flag%TYPE;
1783: update_personal_profile varchar2(100) default null;
1784: l_proc varchar2(100);
1785: cursor c_appr_template_details(c_appraisal_id in number) is
1786: select available_flag ,update_personal_comp_profile,comp_profile_source_type

Line 1787: from per_appraisal_templates pat ,per_appraisals pa where

1783: update_personal_profile varchar2(100) default null;
1784: l_proc varchar2(100);
1785: cursor c_appr_template_details(c_appraisal_id in number) is
1786: select available_flag ,update_personal_comp_profile,comp_profile_source_type
1787: from per_appraisal_templates pat ,per_appraisals pa where
1788: pa.appraisal_template_id = pat.appraisal_template_id
1789: and pa.appraisal_id = c_appraisal_id;
1790: BEGIN
1791: l_proc := 'HR_COMPLETE_APPRAISAL_SS.COMPLETE_APPR';