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 153: appraisal_template_id per_appraisal_templates.appraisal_template_id%TYPE,

149: effective_state_date per_all_assignments_f.effective_start_date%TYPE
150: );
151:
152: TYPE appraisal_templ_info IS RECORD (
153: appraisal_template_id per_appraisal_templates.appraisal_template_id%TYPE,
154: assessment_type_id per_appraisal_templates.assessment_type_id%TYPE,
155: objective_asmnt_type_id per_appraisal_templates.objective_asmnt_type_id%TYPE,
156: business_group_id per_appraisal_templates.business_group_id%TYPE
157: );

Line 154: assessment_type_id per_appraisal_templates.assessment_type_id%TYPE,

150: );
151:
152: TYPE appraisal_templ_info IS RECORD (
153: appraisal_template_id per_appraisal_templates.appraisal_template_id%TYPE,
154: assessment_type_id per_appraisal_templates.assessment_type_id%TYPE,
155: objective_asmnt_type_id per_appraisal_templates.objective_asmnt_type_id%TYPE,
156: business_group_id per_appraisal_templates.business_group_id%TYPE
157: );
158:

Line 155: objective_asmnt_type_id per_appraisal_templates.objective_asmnt_type_id%TYPE,

151:
152: TYPE appraisal_templ_info IS RECORD (
153: appraisal_template_id per_appraisal_templates.appraisal_template_id%TYPE,
154: assessment_type_id per_appraisal_templates.assessment_type_id%TYPE,
155: objective_asmnt_type_id per_appraisal_templates.objective_asmnt_type_id%TYPE,
156: business_group_id per_appraisal_templates.business_group_id%TYPE
157: );
158:
159: TYPE assess_comps_info IS RECORD (

Line 156: business_group_id per_appraisal_templates.business_group_id%TYPE

152: TYPE appraisal_templ_info IS RECORD (
153: appraisal_template_id per_appraisal_templates.appraisal_template_id%TYPE,
154: assessment_type_id per_appraisal_templates.assessment_type_id%TYPE,
155: objective_asmnt_type_id per_appraisal_templates.objective_asmnt_type_id%TYPE,
156: business_group_id per_appraisal_templates.business_group_id%TYPE
157: );
158:
159: TYPE assess_comps_info IS RECORD (
160: competence_id per_competence_elements.competence_id%TYPE,

Line 213: business_group_id per_appraisal_templates.business_group_id%TYPE

209:
210: TYPE appr_prds_rc IS RECORD (
211: appraisal_period_id per_appraisal_periods.appraisal_period_id%TYPE,
212: appraisal_template_id per_appraisal_periods.appraisal_template_id%TYPE,
213: business_group_id per_appraisal_templates.business_group_id%TYPE
214: );
215:
216: TYPE appr_prds_tbl IS TABLE OF appr_prds_rc
217: INDEX BY BINARY_INTEGER;

Line 883: FROM per_appraisal_periods prds, per_appraisal_templates templ

879:
880: CURSOR csr_apprl_periods (p_pln_id per_perf_mgmt_plans.plan_id%TYPE)
881: IS
882: SELECT prds.appraisal_period_id, prds.appraisal_template_id, templ.business_group_id
883: FROM per_appraisal_periods prds, per_appraisal_templates templ
884: WHERE prds.plan_id = p_pln_id AND templ.appraisal_template_id = prds.appraisal_template_id;
885:
886: l_last_bg_id per_appraisal_templates.business_group_id%TYPE;
887: l_bg_change BOOLEAN DEFAULT FALSE;

Line 886: l_last_bg_id per_appraisal_templates.business_group_id%TYPE;

882: SELECT prds.appraisal_period_id, prds.appraisal_template_id, templ.business_group_id
883: FROM per_appraisal_periods prds, per_appraisal_templates templ
884: WHERE prds.plan_id = p_pln_id AND templ.appraisal_template_id = prds.appraisal_template_id;
885:
886: l_last_bg_id per_appraisal_templates.business_group_id%TYPE;
887: l_bg_change BOOLEAN DEFAULT FALSE;
888: l_check_cross_bg_templ BOOLEAN DEFAULT FALSE;
889: l_appr_prds_tbl appr_prds_tbl;
890: e_invl_templ_popl EXCEPTION;

Line 2979: p_appraisal_templ_id per_appraisal_templates.appraisal_template_id%TYPE,

2975: -- {End Of Comments}
2976: -- ----------------------------------------------------------------------------
2977: PROCEDURE create_appraisal_for_person (
2978: p_score_card_id per_personal_scorecards.scorecard_id%TYPE,
2979: p_appraisal_templ_id per_appraisal_templates.appraisal_template_id%TYPE,
2980: p_effective_date DATE,
2981: p_appraisal_start_date DATE,
2982: p_appraisal_end_date DATE,
2983: p_appraisal_status per_appraisals.status%TYPE DEFAULT 'PLANNED',

Line 3012: FROM per_appraisal_templates

3008:
3009: CURSOR get_appraisal_templ_info (p_appraisal_templ_id per_appraisals.appraisal_template_id%TYPE)
3010: IS
3011: SELECT appraisal_template_id, assessment_type_id, objective_asmnt_type_id, business_group_id
3012: FROM per_appraisal_templates
3013: WHERE appraisal_template_id = p_appraisal_templ_id;
3014:
3015: CURSOR get_assess_templ_comps (p_assess_type_id per_competence_elements.assessment_type_id%TYPE)
3016: IS

Line 3039: CURSOR get_assess_templ_info (p_assess_templ per_appraisal_templates.assessment_type_id%TYPE)

3035: SELECT objective_id, scorecard_id, object_version_number, NAME
3036: FROM per_objectives
3037: WHERE scorecard_id = p_scorecard_id AND appraise_flag = 'Y';
3038:
3039: CURSOR get_assess_templ_info (p_assess_templ per_appraisal_templates.assessment_type_id%TYPE)
3040: IS
3041: SELECT default_job_competencies, assessment_type_id
3042: FROM per_assessment_types
3043: WHERE assessment_type_id = p_assess_templ;

Line 6855: FROM per_appraisals pa, per_appraisal_templates pat

6851: IS
6852: SELECT hr_general.decode_lookup ('APPRAISAL_SYSTEM_STATUS', appraisal_system_status) status,
6853: pat.NAME appraisal_template_name, pa.appraisal_period_start_date, pa.appraisal_period_end_date, COUNT (*)
6854: COUNT
6855: FROM per_appraisals pa, per_appraisal_templates pat
6856: WHERE pa.plan_id = p_plan_id AND pa.appraisal_template_id = pat.appraisal_template_id
6857: GROUP BY hr_general.decode_lookup ('APPRAISAL_SYSTEM_STATUS', appraisal_system_status),
6858: pat.NAME,
6859: pa.appraisal_period_start_date,