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 134: competence_id per_competence_elements.competence_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,
135: competence_element_id per_competence_elements.competence_element_id%TYPE,
136: type per_competence_elements.type%TYPE,
137: parent_competence_element_id per_competence_elements.parent_competence_element_id%TYPE,
138: name per_competences_vl.name%TYPE,

Line 135: competence_element_id per_competence_elements.competence_element_id%TYPE,

131: );
132:
133: TYPE assess_comps_info is RECORD (
134: competence_id per_competence_elements.competence_id%TYPE,
135: competence_element_id per_competence_elements.competence_element_id%TYPE,
136: type per_competence_elements.type%TYPE,
137: parent_competence_element_id per_competence_elements.parent_competence_element_id%TYPE,
138: name per_competences_vl.name%TYPE,
139: rank number );

Line 136: type per_competence_elements.type%TYPE,

132:
133: TYPE assess_comps_info is RECORD (
134: competence_id per_competence_elements.competence_id%TYPE,
135: competence_element_id per_competence_elements.competence_element_id%TYPE,
136: type per_competence_elements.type%TYPE,
137: parent_competence_element_id per_competence_elements.parent_competence_element_id%TYPE,
138: name per_competences_vl.name%TYPE,
139: rank number );
140:

Line 137: parent_competence_element_id per_competence_elements.parent_competence_element_id%TYPE,

133: TYPE assess_comps_info is RECORD (
134: competence_id per_competence_elements.competence_id%TYPE,
135: competence_element_id per_competence_elements.competence_element_id%TYPE,
136: type per_competence_elements.type%TYPE,
137: parent_competence_element_id per_competence_elements.parent_competence_element_id%TYPE,
138: name per_competences_vl.name%TYPE,
139: rank number );
140:
141: TYPE bus_rules_comps IS RECORD(

Line 144: competence_element_id per_competence_elements.competence_element_id%TYPE,

140:
141: TYPE bus_rules_comps IS RECORD(
142: name per_competences_vl.name%TYPE,
143: competence_id per_competences.competence_id%TYPE,
144: competence_element_id per_competence_elements.competence_element_id%TYPE,
145: mandatory per_competence_elements.mandatory%TYPE,
146: proficiency_level_id per_competence_elements.proficiency_level_id%TYPE,
147: high_proficiency_level_id per_competence_elements.high_proficiency_level_id%TYPE,
148: organization_id per_competence_elements.organization_id%TYPE,

Line 145: mandatory per_competence_elements.mandatory%TYPE,

141: TYPE bus_rules_comps IS RECORD(
142: name per_competences_vl.name%TYPE,
143: competence_id per_competences.competence_id%TYPE,
144: competence_element_id per_competence_elements.competence_element_id%TYPE,
145: mandatory per_competence_elements.mandatory%TYPE,
146: proficiency_level_id per_competence_elements.proficiency_level_id%TYPE,
147: high_proficiency_level_id per_competence_elements.high_proficiency_level_id%TYPE,
148: organization_id per_competence_elements.organization_id%TYPE,
149: job_id per_competence_elements.job_id%TYPE,

Line 146: proficiency_level_id per_competence_elements.proficiency_level_id%TYPE,

142: name per_competences_vl.name%TYPE,
143: competence_id per_competences.competence_id%TYPE,
144: competence_element_id per_competence_elements.competence_element_id%TYPE,
145: mandatory per_competence_elements.mandatory%TYPE,
146: proficiency_level_id per_competence_elements.proficiency_level_id%TYPE,
147: high_proficiency_level_id per_competence_elements.high_proficiency_level_id%TYPE,
148: organization_id per_competence_elements.organization_id%TYPE,
149: job_id per_competence_elements.job_id%TYPE,
150: position_id per_competence_elements.position_id%TYPE,

Line 147: high_proficiency_level_id per_competence_elements.high_proficiency_level_id%TYPE,

143: competence_id per_competences.competence_id%TYPE,
144: competence_element_id per_competence_elements.competence_element_id%TYPE,
145: mandatory per_competence_elements.mandatory%TYPE,
146: proficiency_level_id per_competence_elements.proficiency_level_id%TYPE,
147: high_proficiency_level_id per_competence_elements.high_proficiency_level_id%TYPE,
148: organization_id per_competence_elements.organization_id%TYPE,
149: job_id per_competence_elements.job_id%TYPE,
150: position_id per_competence_elements.position_id%TYPE,
151: valid_grade_id per_competence_elements.valid_grade_id%TYPE,

Line 148: organization_id per_competence_elements.organization_id%TYPE,

144: competence_element_id per_competence_elements.competence_element_id%TYPE,
145: mandatory per_competence_elements.mandatory%TYPE,
146: proficiency_level_id per_competence_elements.proficiency_level_id%TYPE,
147: high_proficiency_level_id per_competence_elements.high_proficiency_level_id%TYPE,
148: organization_id per_competence_elements.organization_id%TYPE,
149: job_id per_competence_elements.job_id%TYPE,
150: position_id per_competence_elements.position_id%TYPE,
151: valid_grade_id per_competence_elements.valid_grade_id%TYPE,
152: business_group_id per_competence_elements.business_group_id%TYPE,

Line 149: job_id per_competence_elements.job_id%TYPE,

145: mandatory per_competence_elements.mandatory%TYPE,
146: proficiency_level_id per_competence_elements.proficiency_level_id%TYPE,
147: high_proficiency_level_id per_competence_elements.high_proficiency_level_id%TYPE,
148: organization_id per_competence_elements.organization_id%TYPE,
149: job_id per_competence_elements.job_id%TYPE,
150: position_id per_competence_elements.position_id%TYPE,
151: valid_grade_id per_competence_elements.valid_grade_id%TYPE,
152: business_group_id per_competence_elements.business_group_id%TYPE,
153: enterprise_id per_competence_elements.enterprise_id%TYPE,

Line 150: position_id per_competence_elements.position_id%TYPE,

146: proficiency_level_id per_competence_elements.proficiency_level_id%TYPE,
147: high_proficiency_level_id per_competence_elements.high_proficiency_level_id%TYPE,
148: organization_id per_competence_elements.organization_id%TYPE,
149: job_id per_competence_elements.job_id%TYPE,
150: position_id per_competence_elements.position_id%TYPE,
151: valid_grade_id per_competence_elements.valid_grade_id%TYPE,
152: business_group_id per_competence_elements.business_group_id%TYPE,
153: enterprise_id per_competence_elements.enterprise_id%TYPE,
154: structure_type hr_lookups.meaning%TYPE,

Line 151: valid_grade_id per_competence_elements.valid_grade_id%TYPE,

147: high_proficiency_level_id per_competence_elements.high_proficiency_level_id%TYPE,
148: organization_id per_competence_elements.organization_id%TYPE,
149: job_id per_competence_elements.job_id%TYPE,
150: position_id per_competence_elements.position_id%TYPE,
151: valid_grade_id per_competence_elements.valid_grade_id%TYPE,
152: business_group_id per_competence_elements.business_group_id%TYPE,
153: enterprise_id per_competence_elements.enterprise_id%TYPE,
154: structure_type hr_lookups.meaning%TYPE,
155: read_only_attr number,

Line 152: business_group_id per_competence_elements.business_group_id%TYPE,

148: organization_id per_competence_elements.organization_id%TYPE,
149: job_id per_competence_elements.job_id%TYPE,
150: position_id per_competence_elements.position_id%TYPE,
151: valid_grade_id per_competence_elements.valid_grade_id%TYPE,
152: business_group_id per_competence_elements.business_group_id%TYPE,
153: enterprise_id per_competence_elements.enterprise_id%TYPE,
154: structure_type hr_lookups.meaning%TYPE,
155: read_only_attr number,
156: detail_attr number,

Line 153: enterprise_id per_competence_elements.enterprise_id%TYPE,

149: job_id per_competence_elements.job_id%TYPE,
150: position_id per_competence_elements.position_id%TYPE,
151: valid_grade_id per_competence_elements.valid_grade_id%TYPE,
152: business_group_id per_competence_elements.business_group_id%TYPE,
153: enterprise_id per_competence_elements.enterprise_id%TYPE,
154: structure_type hr_lookups.meaning%TYPE,
155: read_only_attr number,
156: detail_attr number,
157: competence_alias per_competences.competence_alias%TYPE,

Line 170: type per_competence_elements.type%TYPE);

166: high_step_name per_rating_levels_vl.name%TYPE,
167: lookup_code hr_lookups.lookup_code%TYPE,
168: minimum_proficiency varchar2(100),
169: maximum_proficiency varchar2(100),
170: type per_competence_elements.type%TYPE);
171:
172: TYPE sel_comp_tab IS TABLE OF bus_rules_comps INDEX BY BINARY_INTEGER ;
173:
174: type competences_rc is RECORD (

Line 2003: FROM per_competence_elements pce,

1999: hrl.lookup_code,
2000: decode(r1.step_value, null, null, r1.step_value||' - '||r1.name) minimum_proficiency,
2001: decode(r2.step_value, null, null, r2.step_value||' - '||r2.name) maximum_proficiency,
2002: pce.type
2003: FROM per_competence_elements pce,
2004: per_competences_vl pc,
2005: hr_lookups hrl,
2006: per_rating_levels_vl r1,
2007: per_rating_levels_vl r2

Line 2238: cursor get_assess_templ_comps(p_assess_type_id per_competence_elements.assessment_type_id%TYPE)

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)
2239: IS
2240: select ce.competence_id, ce.competence_element_id, ce.type, ce.parent_competence_element_id, c.name,
2241: rank() over (partition by ce.competence_id order by ce.competence_element_id) rank
2242: from per_competence_elements a, per_competence_elements ce, per_competences_vl c

Line 2242: from per_competence_elements a, per_competence_elements ce, per_competences_vl c

2238: cursor get_assess_templ_comps(p_assess_type_id per_competence_elements.assessment_type_id%TYPE)
2239: IS
2240: select ce.competence_id, ce.competence_element_id, ce.type, ce.parent_competence_element_id, c.name,
2241: rank() over (partition by ce.competence_id order by ce.competence_element_id) rank
2242: from per_competence_elements a, per_competence_elements ce, per_competences_vl c
2243: where a.assessment_type_id = p_assess_type_id
2244: and a.type = 'ASSESSMENT_GROUP'
2245: and (nvl(c.date_from,trunc(sysdate)) <= trunc(sysdate))
2246: and nvl(c.date_to,trunc(sysdate)) >= trunc(sysdate)

Line 2285: l_comp_ele_id per_competence_elements.competence_element_id%TYPE;

2281: l_assessment_obj_ovn per_assessments.object_version_number%TYPE;
2282: l_assess_comps assess_comps_info;
2283: l_check_default_job_comps varchar2(2) default '';
2284:
2285: l_comp_ele_id per_competence_elements.competence_element_id%TYPE;
2286: l_comp_ovn per_competence_elements.object_version_number%TYPE;
2287: l_return_status varchar2(10) default '';
2288: l_competence_error varchar2(1000) default null;
2289: module_name varchar2(100) default 'MASS APPRAISAL CREATION';

Line 2286: l_comp_ovn per_competence_elements.object_version_number%TYPE;

2282: l_assess_comps assess_comps_info;
2283: l_check_default_job_comps varchar2(2) default '';
2284:
2285: l_comp_ele_id per_competence_elements.competence_element_id%TYPE;
2286: l_comp_ovn per_competence_elements.object_version_number%TYPE;
2287: l_return_status varchar2(10) default '';
2288: l_competence_error varchar2(1000) default null;
2289: module_name varchar2(100) default 'MASS APPRAISAL CREATION';
2290: l_error_message varchar2(1000) default null;

Line 2854: select competence_element_id, object_version_number from per_competence_elements

2850: select assessment_id, object_version_number from per_assessments
2851: where appraisal_id = apprl_id;
2852:
2853: cursor get_competences(assess_id per_assessments.assessment_id%TYPE) is
2854: select competence_element_id, object_version_number from per_competence_elements
2855: where assessment_id = assess_id order by competence_element_id desc ;
2856:
2857: --
2858: Begin