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_PERF_MGMT_PLAN_INTERNAL dependencies on PER_APPRAISAL_TEMPLATES

Line 127: appraisal_template_id per_appraisal_templates.appraisal_template_id%TYPE,

123: effective_state_date per_all_assignments_f.effective_start_date%TYPE
124: );
125:
126: TYPE appraisal_templ_info is RECORD (
127: appraisal_template_id per_appraisal_templates.appraisal_template_id%TYPE,
128: assessment_type_id per_appraisal_templates.assessment_type_id%TYPE,
129: objective_asmnt_type_id per_appraisal_templates.objective_asmnt_type_id%TYPE,
130: business_group_id per_appraisal_templates.business_group_id%TYPE
131: );

Line 128: assessment_type_id per_appraisal_templates.assessment_type_id%TYPE,

124: );
125:
126: TYPE appraisal_templ_info is RECORD (
127: appraisal_template_id per_appraisal_templates.appraisal_template_id%TYPE,
128: assessment_type_id per_appraisal_templates.assessment_type_id%TYPE,
129: objective_asmnt_type_id per_appraisal_templates.objective_asmnt_type_id%TYPE,
130: business_group_id per_appraisal_templates.business_group_id%TYPE
131: );
132:

Line 129: objective_asmnt_type_id per_appraisal_templates.objective_asmnt_type_id%TYPE,

125:
126: TYPE appraisal_templ_info is RECORD (
127: appraisal_template_id per_appraisal_templates.appraisal_template_id%TYPE,
128: assessment_type_id per_appraisal_templates.assessment_type_id%TYPE,
129: objective_asmnt_type_id per_appraisal_templates.objective_asmnt_type_id%TYPE,
130: business_group_id per_appraisal_templates.business_group_id%TYPE
131: );
132:
133: TYPE assess_comps_info is RECORD (

Line 130: business_group_id per_appraisal_templates.business_group_id%TYPE

126: TYPE appraisal_templ_info is RECORD (
127: appraisal_template_id per_appraisal_templates.appraisal_template_id%TYPE,
128: assessment_type_id per_appraisal_templates.assessment_type_id%TYPE,
129: objective_asmnt_type_id per_appraisal_templates.objective_asmnt_type_id%TYPE,
130: business_group_id per_appraisal_templates.business_group_id%TYPE
131: );
132:
133: TYPE assess_comps_info is RECORD (
134: competence_id per_competence_elements.competence_id%TYPE,

Line 181: business_group_id per_appraisal_templates.business_group_id%TYPE);

177:
178: TYPE appr_prds_rc is RECORD (
179: appraisal_period_id per_appraisal_periods.appraisal_period_id%TYPE,
180: appraisal_template_id per_appraisal_periods.appraisal_template_id%TYPE,
181: business_group_id per_appraisal_templates.business_group_id%TYPE);
182: type appr_prds_tbl is table of appr_prds_rc index by binary_integer;
183:
184:
185: -- added for PERF ADMIN ACTIONS

Line 576: from per_appraisal_periods prds, per_appraisal_templates templ

572: select p_plan_rec.top_position_id subordinate_position_id from dual));
573:
574: CURSOR csr_apprl_periods(p_pln_id per_perf_mgmt_plans.plan_id%TYPE) IS
575: select prds.appraisal_period_id, prds.appraisal_template_id, templ.business_group_id
576: from per_appraisal_periods prds, per_appraisal_templates templ
577: where prds.plan_id = p_pln_id
578: and templ.appraisal_template_id = prds.appraisal_template_id;
579:
580: l_last_bg_id per_appraisal_templates.business_group_id%TYPE;

Line 580: l_last_bg_id per_appraisal_templates.business_group_id%TYPE;

576: from per_appraisal_periods prds, per_appraisal_templates templ
577: where prds.plan_id = p_pln_id
578: and templ.appraisal_template_id = prds.appraisal_template_id;
579:
580: l_last_bg_id per_appraisal_templates.business_group_id%TYPE;
581: l_bg_change boolean default false;
582: l_check_cross_bg_templ boolean default false;
583: l_appr_prds_tbl appr_prds_tbl;
584: e_invl_templ_popl exception;

Line 2201: p_appraisal_templ_id per_appraisal_templates.appraisal_template_id%TYPE,

2197: -- {End Of Comments}
2198: -- ----------------------------------------------------------------------------
2199: PROCEDURE create_appraisal_for_person
2200: ( p_score_card_id per_personal_scorecards.scorecard_id%TYPE,
2201: p_appraisal_templ_id per_appraisal_templates.appraisal_template_id%TYPE,
2202: p_effective_date DATE,
2203: p_appraisal_start_date DATE,
2204: p_appraisal_end_date DATE,
2205: p_appraisal_status per_appraisals.status%TYPE default 'PLANNED',

Line 2234: FROM per_appraisal_templates

2230:
2231: cursor get_appraisal_templ_info (p_appraisal_templ_id per_appraisals.appraisal_template_id%TYPE)
2232: IS
2233: SELECT appraisal_template_id, assessment_type_id, objective_asmnt_type_id, business_group_id
2234: FROM per_appraisal_templates
2235: WHERE appraisal_template_id = p_appraisal_templ_id;
2236:
2237:
2238: cursor get_assess_templ_comps(p_assess_type_id per_competence_elements.assessment_type_id%TYPE)

Line 2262: cursor get_assess_templ_info (p_assess_templ per_appraisal_templates.assessment_type_id%TYPE)

2258: select objective_id, scorecard_id, object_version_number, name from per_objectives
2259: where scorecard_id = p_scorecard_id
2260: and APPRAISE_FLAG = 'Y';
2261:
2262: cursor get_assess_templ_info (p_assess_templ per_appraisal_templates.assessment_type_id%TYPE)
2263: IS
2264: select DEFAULT_JOB_COMPETENCIES, ASSESSMENT_TYPE_ID from per_assessment_types
2265: where ASSESSMENT_TYPE_ID = p_assess_templ;
2266:

Line 5151: ,per_appraisal_templates pat

5147: ,pa.appraisal_period_start_date
5148: ,pa.appraisal_period_end_date
5149: , count(*) COUNT
5150: FROM per_appraisals pa
5151: ,per_appraisal_templates pat
5152: WHERE pa.plan_id = p_plan_id
5153: AND pa.appraisal_template_id = pat.appraisal_template_id
5154: GROUP BY
5155: hr_general.decode_lookup('APPRAISAL_SYSTEM_STATUS',appraisal_system_status)