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_COMPETENCES

Line 138: name per_competences_vl.name%TYPE,

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(
142: name per_competences_vl.name%TYPE,

Line 142: name per_competences_vl.name%TYPE,

138: name per_competences_vl.name%TYPE,
139: rank number );
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,

Line 143: competence_id per_competences.competence_id%TYPE,

139: rank number );
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,

Line 157: competence_alias per_competences.competence_alias%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,
158: global varchar2(1),
159: description per_competences.description%TYPE,
160: date_from per_competences.date_from%TYPE,
161: certification_required per_competences.certification_required%TYPE,

Line 159: description per_competences.description%TYPE,

155: read_only_attr number,
156: detail_attr number,
157: competence_alias per_competences.competence_alias%TYPE,
158: global varchar2(1),
159: description per_competences.description%TYPE,
160: date_from per_competences.date_from%TYPE,
161: certification_required per_competences.certification_required%TYPE,
162: behavioural_indicator per_competences.behavioural_indicator%TYPE,
163: low_step_value per_rating_levels_vl.step_value%TYPE,

Line 160: date_from per_competences.date_from%TYPE,

156: detail_attr number,
157: competence_alias per_competences.competence_alias%TYPE,
158: global varchar2(1),
159: description per_competences.description%TYPE,
160: date_from per_competences.date_from%TYPE,
161: certification_required per_competences.certification_required%TYPE,
162: behavioural_indicator per_competences.behavioural_indicator%TYPE,
163: low_step_value per_rating_levels_vl.step_value%TYPE,
164: low_step_name per_rating_levels_vl.name%TYPE,

Line 161: certification_required per_competences.certification_required%TYPE,

157: competence_alias per_competences.competence_alias%TYPE,
158: global varchar2(1),
159: description per_competences.description%TYPE,
160: date_from per_competences.date_from%TYPE,
161: certification_required per_competences.certification_required%TYPE,
162: behavioural_indicator per_competences.behavioural_indicator%TYPE,
163: low_step_value per_rating_levels_vl.step_value%TYPE,
164: low_step_name per_rating_levels_vl.name%TYPE,
165: high_step_value per_rating_levels_vl.step_value%TYPE,

Line 162: behavioural_indicator per_competences.behavioural_indicator%TYPE,

158: global varchar2(1),
159: description per_competences.description%TYPE,
160: date_from per_competences.date_from%TYPE,
161: certification_required per_competences.certification_required%TYPE,
162: behavioural_indicator per_competences.behavioural_indicator%TYPE,
163: low_step_value per_rating_levels_vl.step_value%TYPE,
164: low_step_name per_rating_levels_vl.name%TYPE,
165: high_step_value per_rating_levels_vl.step_value%TYPE,
166: high_step_name per_rating_levels_vl.name%TYPE,

Line 175: competence_id per_competences.competence_id%TYPE );

171:
172: TYPE sel_comp_tab IS TABLE OF bus_rules_comps INDEX BY BINARY_INTEGER ;
173:
174: type competences_rc is RECORD (
175: competence_id per_competences.competence_id%TYPE );
176: type competences_tbl is TABLE OF competences_rc INDEX BY BINARY_INTEGER;
177:
178: TYPE appr_prds_rc is RECORD (
179: appraisal_period_id per_appraisal_periods.appraisal_period_id%TYPE,

Line 2004: per_competences_vl pc,

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
2008: WHERE pce.type = 'REQUIREMENT'

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)