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_COMPETENCE_ELEMENTS

Line 160: competence_id per_competence_elements.competence_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,
161: competence_element_id per_competence_elements.competence_element_id%TYPE,
162: TYPE per_competence_elements.TYPE%TYPE,
163: parent_competence_element_id per_competence_elements.parent_competence_element_id%TYPE,
164: NAME per_competences_vl.NAME%TYPE,

Line 161: competence_element_id per_competence_elements.competence_element_id%TYPE,

157: );
158:
159: TYPE assess_comps_info IS RECORD (
160: competence_id per_competence_elements.competence_id%TYPE,
161: competence_element_id per_competence_elements.competence_element_id%TYPE,
162: TYPE per_competence_elements.TYPE%TYPE,
163: parent_competence_element_id per_competence_elements.parent_competence_element_id%TYPE,
164: NAME per_competences_vl.NAME%TYPE,
165: RANK NUMBER

Line 162: TYPE per_competence_elements.TYPE%TYPE,

158:
159: TYPE assess_comps_info IS RECORD (
160: competence_id per_competence_elements.competence_id%TYPE,
161: competence_element_id per_competence_elements.competence_element_id%TYPE,
162: TYPE per_competence_elements.TYPE%TYPE,
163: parent_competence_element_id per_competence_elements.parent_competence_element_id%TYPE,
164: NAME per_competences_vl.NAME%TYPE,
165: RANK NUMBER
166: );

Line 163: parent_competence_element_id per_competence_elements.parent_competence_element_id%TYPE,

159: TYPE assess_comps_info IS RECORD (
160: competence_id per_competence_elements.competence_id%TYPE,
161: competence_element_id per_competence_elements.competence_element_id%TYPE,
162: TYPE per_competence_elements.TYPE%TYPE,
163: parent_competence_element_id per_competence_elements.parent_competence_element_id%TYPE,
164: NAME per_competences_vl.NAME%TYPE,
165: RANK NUMBER
166: );
167:

Line 171: competence_element_id per_competence_elements.competence_element_id%TYPE,

167:
168: TYPE bus_rules_comps IS RECORD (
169: NAME per_competences_vl.NAME%TYPE,
170: competence_id per_competences.competence_id%TYPE,
171: competence_element_id per_competence_elements.competence_element_id%TYPE,
172: mandatory per_competence_elements.mandatory%TYPE,
173: proficiency_level_id per_competence_elements.proficiency_level_id%TYPE,
174: high_proficiency_level_id per_competence_elements.high_proficiency_level_id%TYPE,
175: organization_id per_competence_elements.organization_id%TYPE,

Line 172: mandatory per_competence_elements.mandatory%TYPE,

168: TYPE bus_rules_comps IS RECORD (
169: NAME per_competences_vl.NAME%TYPE,
170: competence_id per_competences.competence_id%TYPE,
171: competence_element_id per_competence_elements.competence_element_id%TYPE,
172: mandatory per_competence_elements.mandatory%TYPE,
173: proficiency_level_id per_competence_elements.proficiency_level_id%TYPE,
174: high_proficiency_level_id per_competence_elements.high_proficiency_level_id%TYPE,
175: organization_id per_competence_elements.organization_id%TYPE,
176: job_id per_competence_elements.job_id%TYPE,

Line 173: proficiency_level_id per_competence_elements.proficiency_level_id%TYPE,

169: NAME per_competences_vl.NAME%TYPE,
170: competence_id per_competences.competence_id%TYPE,
171: competence_element_id per_competence_elements.competence_element_id%TYPE,
172: mandatory per_competence_elements.mandatory%TYPE,
173: proficiency_level_id per_competence_elements.proficiency_level_id%TYPE,
174: high_proficiency_level_id per_competence_elements.high_proficiency_level_id%TYPE,
175: organization_id per_competence_elements.organization_id%TYPE,
176: job_id per_competence_elements.job_id%TYPE,
177: position_id per_competence_elements.position_id%TYPE,

Line 174: high_proficiency_level_id per_competence_elements.high_proficiency_level_id%TYPE,

170: competence_id per_competences.competence_id%TYPE,
171: competence_element_id per_competence_elements.competence_element_id%TYPE,
172: mandatory per_competence_elements.mandatory%TYPE,
173: proficiency_level_id per_competence_elements.proficiency_level_id%TYPE,
174: high_proficiency_level_id per_competence_elements.high_proficiency_level_id%TYPE,
175: organization_id per_competence_elements.organization_id%TYPE,
176: job_id per_competence_elements.job_id%TYPE,
177: position_id per_competence_elements.position_id%TYPE,
178: valid_grade_id per_competence_elements.valid_grade_id%TYPE,

Line 175: organization_id per_competence_elements.organization_id%TYPE,

171: competence_element_id per_competence_elements.competence_element_id%TYPE,
172: mandatory per_competence_elements.mandatory%TYPE,
173: proficiency_level_id per_competence_elements.proficiency_level_id%TYPE,
174: high_proficiency_level_id per_competence_elements.high_proficiency_level_id%TYPE,
175: organization_id per_competence_elements.organization_id%TYPE,
176: job_id per_competence_elements.job_id%TYPE,
177: position_id per_competence_elements.position_id%TYPE,
178: valid_grade_id per_competence_elements.valid_grade_id%TYPE,
179: business_group_id per_competence_elements.business_group_id%TYPE,

Line 176: job_id per_competence_elements.job_id%TYPE,

172: mandatory per_competence_elements.mandatory%TYPE,
173: proficiency_level_id per_competence_elements.proficiency_level_id%TYPE,
174: high_proficiency_level_id per_competence_elements.high_proficiency_level_id%TYPE,
175: organization_id per_competence_elements.organization_id%TYPE,
176: job_id per_competence_elements.job_id%TYPE,
177: position_id per_competence_elements.position_id%TYPE,
178: valid_grade_id per_competence_elements.valid_grade_id%TYPE,
179: business_group_id per_competence_elements.business_group_id%TYPE,
180: enterprise_id per_competence_elements.enterprise_id%TYPE,

Line 177: position_id per_competence_elements.position_id%TYPE,

173: proficiency_level_id per_competence_elements.proficiency_level_id%TYPE,
174: high_proficiency_level_id per_competence_elements.high_proficiency_level_id%TYPE,
175: organization_id per_competence_elements.organization_id%TYPE,
176: job_id per_competence_elements.job_id%TYPE,
177: position_id per_competence_elements.position_id%TYPE,
178: valid_grade_id per_competence_elements.valid_grade_id%TYPE,
179: business_group_id per_competence_elements.business_group_id%TYPE,
180: enterprise_id per_competence_elements.enterprise_id%TYPE,
181: structure_type hr_lookups.meaning%TYPE,

Line 178: valid_grade_id per_competence_elements.valid_grade_id%TYPE,

174: high_proficiency_level_id per_competence_elements.high_proficiency_level_id%TYPE,
175: organization_id per_competence_elements.organization_id%TYPE,
176: job_id per_competence_elements.job_id%TYPE,
177: position_id per_competence_elements.position_id%TYPE,
178: valid_grade_id per_competence_elements.valid_grade_id%TYPE,
179: business_group_id per_competence_elements.business_group_id%TYPE,
180: enterprise_id per_competence_elements.enterprise_id%TYPE,
181: structure_type hr_lookups.meaning%TYPE,
182: read_only_attr NUMBER,

Line 179: business_group_id per_competence_elements.business_group_id%TYPE,

175: organization_id per_competence_elements.organization_id%TYPE,
176: job_id per_competence_elements.job_id%TYPE,
177: position_id per_competence_elements.position_id%TYPE,
178: valid_grade_id per_competence_elements.valid_grade_id%TYPE,
179: business_group_id per_competence_elements.business_group_id%TYPE,
180: enterprise_id per_competence_elements.enterprise_id%TYPE,
181: structure_type hr_lookups.meaning%TYPE,
182: read_only_attr NUMBER,
183: detail_attr NUMBER,

Line 180: enterprise_id per_competence_elements.enterprise_id%TYPE,

176: job_id per_competence_elements.job_id%TYPE,
177: position_id per_competence_elements.position_id%TYPE,
178: valid_grade_id per_competence_elements.valid_grade_id%TYPE,
179: business_group_id per_competence_elements.business_group_id%TYPE,
180: enterprise_id per_competence_elements.enterprise_id%TYPE,
181: structure_type hr_lookups.meaning%TYPE,
182: read_only_attr NUMBER,
183: detail_attr NUMBER,
184: competence_alias per_competences.competence_alias%TYPE,

Line 197: TYPE per_competence_elements.TYPE%TYPE

193: high_step_name per_rating_levels_vl.NAME%TYPE,
194: lookup_code hr_lookups.lookup_code%TYPE,
195: minimum_proficiency VARCHAR2 (100),
196: maximum_proficiency VARCHAR2 (100),
197: TYPE per_competence_elements.TYPE%TYPE
198: );
199:
200: TYPE sel_comp_tab IS TABLE OF bus_rules_comps
201: INDEX BY BINARY_INTEGER;

Line 2753: FROM per_competence_elements pce,

2749: pc.behavioural_indicator, r1.step_value low_step_value, r1.NAME low_step_name, r2.step_value high_step_value,
2750: r2.NAME high_step_name, hrl.lookup_code,
2751: DECODE (r1.step_value, NULL, NULL, r1.step_value || ' - ' || r1.NAME) minimum_proficiency,
2752: DECODE (r2.step_value, NULL, NULL, r2.step_value || ' - ' || r2.NAME) maximum_proficiency, pce.TYPE
2753: FROM per_competence_elements pce,
2754: per_competences_vl pc,
2755: hr_lookups hrl,
2756: per_rating_levels_vl r1,
2757: per_rating_levels_vl r2

Line 3015: CURSOR get_assess_templ_comps (p_assess_type_id per_competence_elements.assessment_type_id%TYPE)

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
3017: SELECT ce.competence_id, ce.competence_element_id, ce.TYPE, ce.parent_competence_element_id, c.NAME,
3018: RANK () OVER (PARTITION BY ce.competence_id ORDER BY ce.competence_element_id) RANK
3019: FROM per_competence_elements a, per_competence_elements ce, per_competences_vl c

Line 3019: FROM per_competence_elements a, per_competence_elements ce, per_competences_vl c

3015: CURSOR get_assess_templ_comps (p_assess_type_id per_competence_elements.assessment_type_id%TYPE)
3016: IS
3017: SELECT ce.competence_id, ce.competence_element_id, ce.TYPE, ce.parent_competence_element_id, c.NAME,
3018: RANK () OVER (PARTITION BY ce.competence_id ORDER BY ce.competence_element_id) RANK
3019: FROM per_competence_elements a, per_competence_elements ce, per_competences_vl c
3020: WHERE a.assessment_type_id = p_assess_type_id
3021: AND a.TYPE = 'ASSESSMENT_GROUP'
3022: AND (NVL (c.date_from, TRUNC (SYSDATE)) <= TRUNC (SYSDATE))
3023: AND NVL (c.date_to, TRUNC (SYSDATE)) >= TRUNC (SYSDATE)

Line 3062: l_comp_ele_id per_competence_elements.competence_element_id%TYPE;

3058: l_assessment_comp_ovn per_assessments.object_version_number%TYPE;
3059: l_assessment_obj_ovn per_assessments.object_version_number%TYPE;
3060: l_assess_comps assess_comps_info;
3061: l_check_default_job_comps VARCHAR2 (2) DEFAULT '';
3062: l_comp_ele_id per_competence_elements.competence_element_id%TYPE;
3063: l_comp_ovn per_competence_elements.object_version_number%TYPE;
3064: l_return_status VARCHAR2 (10) DEFAULT '';
3065: l_competence_error VARCHAR2 (1000) DEFAULT NULL;
3066: module_name VARCHAR2 (100) DEFAULT 'MASS APPRAISAL CREATION';

Line 3063: l_comp_ovn per_competence_elements.object_version_number%TYPE;

3059: l_assessment_obj_ovn per_assessments.object_version_number%TYPE;
3060: l_assess_comps assess_comps_info;
3061: l_check_default_job_comps VARCHAR2 (2) DEFAULT '';
3062: l_comp_ele_id per_competence_elements.competence_element_id%TYPE;
3063: l_comp_ovn per_competence_elements.object_version_number%TYPE;
3064: l_return_status VARCHAR2 (10) DEFAULT '';
3065: l_competence_error VARCHAR2 (1000) DEFAULT NULL;
3066: module_name VARCHAR2 (100) DEFAULT 'MASS APPRAISAL CREATION';
3067: l_error_message VARCHAR2 (1000) DEFAULT NULL;

Line 3768: FROM per_competence_elements

3764:
3765: CURSOR get_competences (assess_id per_assessments.assessment_id%TYPE)
3766: IS
3767: SELECT competence_element_id, object_version_number
3768: FROM per_competence_elements
3769: WHERE assessment_id = assess_id
3770: ORDER BY competence_element_id DESC;
3771: --
3772: BEGIN