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_WPM_MASS_APR_PUSH dependencies on PER_COMPETENCES

Line 96: name per_competences_vl.name%TYPE,

92: competence_id per_competence_elements.competence_id%TYPE,
93: competence_element_id per_competence_elements.competence_element_id%TYPE,
94: type per_competence_elements.type%TYPE,
95: parent_competence_element_id per_competence_elements.parent_competence_element_id%TYPE,
96: name per_competences_vl.name%TYPE,
97: rank number );
98:
99: TYPE bus_rules_comps IS RECORD(
100: name per_competences_vl.name%TYPE,

Line 100: name per_competences_vl.name%TYPE,

96: name per_competences_vl.name%TYPE,
97: rank number );
98:
99: TYPE bus_rules_comps IS RECORD(
100: name per_competences_vl.name%TYPE,
101: competence_id per_competences.competence_id%TYPE,
102: competence_element_id per_competence_elements.competence_element_id%TYPE,
103: mandatory per_competence_elements.mandatory%TYPE,
104: proficiency_level_id per_competence_elements.proficiency_level_id%TYPE,

Line 101: competence_id per_competences.competence_id%TYPE,

97: rank number );
98:
99: TYPE bus_rules_comps IS RECORD(
100: name per_competences_vl.name%TYPE,
101: competence_id per_competences.competence_id%TYPE,
102: competence_element_id per_competence_elements.competence_element_id%TYPE,
103: mandatory per_competence_elements.mandatory%TYPE,
104: proficiency_level_id per_competence_elements.proficiency_level_id%TYPE,
105: high_proficiency_level_id per_competence_elements.high_proficiency_level_id%TYPE,

Line 115: competence_alias per_competences.competence_alias%TYPE,

111: enterprise_id per_competence_elements.enterprise_id%TYPE,
112: structure_type hr_lookups.meaning%TYPE,
113: read_only_attr number,
114: detail_attr number,
115: competence_alias per_competences.competence_alias%TYPE,
116: global varchar2(1),
117: description per_competences.description%TYPE,
118: date_from per_competences.date_from%TYPE,
119: certification_required per_competences.certification_required%TYPE,

Line 117: description per_competences.description%TYPE,

113: read_only_attr number,
114: detail_attr number,
115: competence_alias per_competences.competence_alias%TYPE,
116: global varchar2(1),
117: description per_competences.description%TYPE,
118: date_from per_competences.date_from%TYPE,
119: certification_required per_competences.certification_required%TYPE,
120: behavioural_indicator per_competences.behavioural_indicator%TYPE,
121: low_step_value per_rating_levels_vl.step_value%TYPE,

Line 118: date_from per_competences.date_from%TYPE,

114: detail_attr number,
115: competence_alias per_competences.competence_alias%TYPE,
116: global varchar2(1),
117: description per_competences.description%TYPE,
118: date_from per_competences.date_from%TYPE,
119: certification_required per_competences.certification_required%TYPE,
120: behavioural_indicator per_competences.behavioural_indicator%TYPE,
121: low_step_value per_rating_levels_vl.step_value%TYPE,
122: low_step_name per_rating_levels_vl.name%TYPE,

Line 119: certification_required per_competences.certification_required%TYPE,

115: competence_alias per_competences.competence_alias%TYPE,
116: global varchar2(1),
117: description per_competences.description%TYPE,
118: date_from per_competences.date_from%TYPE,
119: certification_required per_competences.certification_required%TYPE,
120: behavioural_indicator per_competences.behavioural_indicator%TYPE,
121: low_step_value per_rating_levels_vl.step_value%TYPE,
122: low_step_name per_rating_levels_vl.name%TYPE,
123: high_step_value per_rating_levels_vl.step_value%TYPE,

Line 120: behavioural_indicator per_competences.behavioural_indicator%TYPE,

116: global varchar2(1),
117: description per_competences.description%TYPE,
118: date_from per_competences.date_from%TYPE,
119: certification_required per_competences.certification_required%TYPE,
120: behavioural_indicator per_competences.behavioural_indicator%TYPE,
121: low_step_value per_rating_levels_vl.step_value%TYPE,
122: low_step_name per_rating_levels_vl.name%TYPE,
123: high_step_value per_rating_levels_vl.step_value%TYPE,
124: high_step_name per_rating_levels_vl.name%TYPE,

Line 133: competence_id per_competences.competence_id%TYPE );

129:
130: TYPE sel_comp_tab IS TABLE OF bus_rules_comps INDEX BY BINARY_INTEGER ;
131:
132: type competences_rc is RECORD (
133: competence_id per_competences.competence_id%TYPE );
134: type competences_tbl is TABLE OF competences_rc INDEX BY BINARY_INTEGER;
135:
136: --
137: -- ----------------------------------------------------------------------------

Line 571: per_competences_vl pc,

567: decode(r1.step_value, null, null, r1.step_value||' - '||r1.name) minimum_proficiency,
568: decode(r2.step_value, null, null, r2.step_value||' - '||r2.name) maximum_proficiency,
569: pce.type
570: FROM per_competence_elements pce,
571: per_competences_vl pc,
572: hr_lookups hrl,
573: per_rating_levels_vl r1,
574: per_rating_levels_vl r2
575: WHERE pce.type = 'REQUIREMENT'

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

843: cursor get_assess_templ_comps(p_assess_type_id per_competence_elements.assessment_type_id%TYPE)
844: IS
845: select ce.competence_id, ce.competence_element_id, ce.type, ce.parent_competence_element_id, c.name,
846: rank() over (partition by ce.competence_id order by ce.competence_element_id) rank
847: from per_competence_elements a, per_competence_elements ce, per_competences_vl c
848: where a.assessment_type_id = p_assess_type_id
849: and a.type = 'ASSESSMENT_GROUP'
850: and (nvl(c.date_from,trunc(sysdate)) <= trunc(sysdate))
851: and nvl(c.date_to,trunc(sysdate)) >= trunc(sysdate)