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_COMPETENCE_ELEMENTS

Line 105: competence_id per_competence_elements.competence_id%TYPE,

101: show_overall_comments per_appraisal_templates.show_overall_comments%TYPE
102: );
103:
104: TYPE assess_comps_info IS RECORD (
105: competence_id per_competence_elements.competence_id%TYPE,
106: competence_element_id per_competence_elements.competence_element_id%TYPE,
107: TYPE per_competence_elements.TYPE%TYPE,
108: parent_competence_element_id per_competence_elements.parent_competence_element_id%TYPE,
109: NAME per_competences_vl.NAME%TYPE,

Line 106: competence_element_id per_competence_elements.competence_element_id%TYPE,

102: );
103:
104: TYPE assess_comps_info IS RECORD (
105: competence_id per_competence_elements.competence_id%TYPE,
106: competence_element_id per_competence_elements.competence_element_id%TYPE,
107: TYPE per_competence_elements.TYPE%TYPE,
108: parent_competence_element_id per_competence_elements.parent_competence_element_id%TYPE,
109: NAME per_competences_vl.NAME%TYPE,
110: RANK NUMBER

Line 107: TYPE per_competence_elements.TYPE%TYPE,

103:
104: TYPE assess_comps_info IS RECORD (
105: competence_id per_competence_elements.competence_id%TYPE,
106: competence_element_id per_competence_elements.competence_element_id%TYPE,
107: TYPE per_competence_elements.TYPE%TYPE,
108: parent_competence_element_id per_competence_elements.parent_competence_element_id%TYPE,
109: NAME per_competences_vl.NAME%TYPE,
110: RANK NUMBER
111: );

Line 108: parent_competence_element_id per_competence_elements.parent_competence_element_id%TYPE,

104: TYPE assess_comps_info IS RECORD (
105: competence_id per_competence_elements.competence_id%TYPE,
106: competence_element_id per_competence_elements.competence_element_id%TYPE,
107: TYPE per_competence_elements.TYPE%TYPE,
108: parent_competence_element_id per_competence_elements.parent_competence_element_id%TYPE,
109: NAME per_competences_vl.NAME%TYPE,
110: RANK NUMBER
111: );
112:

Line 116: competence_element_id per_competence_elements.competence_element_id%TYPE,

112:
113: TYPE bus_rules_comps IS RECORD (
114: NAME per_competences_vl.NAME%TYPE,
115: competence_id per_competences.competence_id%TYPE,
116: competence_element_id per_competence_elements.competence_element_id%TYPE,
117: mandatory per_competence_elements.mandatory%TYPE,
118: proficiency_level_id per_competence_elements.proficiency_level_id%TYPE,
119: high_proficiency_level_id per_competence_elements.high_proficiency_level_id%TYPE,
120: organization_id per_competence_elements.organization_id%TYPE,

Line 117: mandatory per_competence_elements.mandatory%TYPE,

113: TYPE bus_rules_comps IS RECORD (
114: NAME per_competences_vl.NAME%TYPE,
115: competence_id per_competences.competence_id%TYPE,
116: competence_element_id per_competence_elements.competence_element_id%TYPE,
117: mandatory per_competence_elements.mandatory%TYPE,
118: proficiency_level_id per_competence_elements.proficiency_level_id%TYPE,
119: high_proficiency_level_id per_competence_elements.high_proficiency_level_id%TYPE,
120: organization_id per_competence_elements.organization_id%TYPE,
121: job_id per_competence_elements.job_id%TYPE,

Line 118: proficiency_level_id per_competence_elements.proficiency_level_id%TYPE,

114: NAME per_competences_vl.NAME%TYPE,
115: competence_id per_competences.competence_id%TYPE,
116: competence_element_id per_competence_elements.competence_element_id%TYPE,
117: mandatory per_competence_elements.mandatory%TYPE,
118: proficiency_level_id per_competence_elements.proficiency_level_id%TYPE,
119: high_proficiency_level_id per_competence_elements.high_proficiency_level_id%TYPE,
120: organization_id per_competence_elements.organization_id%TYPE,
121: job_id per_competence_elements.job_id%TYPE,
122: position_id per_competence_elements.position_id%TYPE,

Line 119: high_proficiency_level_id per_competence_elements.high_proficiency_level_id%TYPE,

115: competence_id per_competences.competence_id%TYPE,
116: competence_element_id per_competence_elements.competence_element_id%TYPE,
117: mandatory per_competence_elements.mandatory%TYPE,
118: proficiency_level_id per_competence_elements.proficiency_level_id%TYPE,
119: high_proficiency_level_id per_competence_elements.high_proficiency_level_id%TYPE,
120: organization_id per_competence_elements.organization_id%TYPE,
121: job_id per_competence_elements.job_id%TYPE,
122: position_id per_competence_elements.position_id%TYPE,
123: valid_grade_id per_competence_elements.valid_grade_id%TYPE,

Line 120: organization_id per_competence_elements.organization_id%TYPE,

116: competence_element_id per_competence_elements.competence_element_id%TYPE,
117: mandatory per_competence_elements.mandatory%TYPE,
118: proficiency_level_id per_competence_elements.proficiency_level_id%TYPE,
119: high_proficiency_level_id per_competence_elements.high_proficiency_level_id%TYPE,
120: organization_id per_competence_elements.organization_id%TYPE,
121: job_id per_competence_elements.job_id%TYPE,
122: position_id per_competence_elements.position_id%TYPE,
123: valid_grade_id per_competence_elements.valid_grade_id%TYPE,
124: business_group_id per_competence_elements.business_group_id%TYPE,

Line 121: job_id per_competence_elements.job_id%TYPE,

117: mandatory per_competence_elements.mandatory%TYPE,
118: proficiency_level_id per_competence_elements.proficiency_level_id%TYPE,
119: high_proficiency_level_id per_competence_elements.high_proficiency_level_id%TYPE,
120: organization_id per_competence_elements.organization_id%TYPE,
121: job_id per_competence_elements.job_id%TYPE,
122: position_id per_competence_elements.position_id%TYPE,
123: valid_grade_id per_competence_elements.valid_grade_id%TYPE,
124: business_group_id per_competence_elements.business_group_id%TYPE,
125: enterprise_id per_competence_elements.enterprise_id%TYPE,

Line 122: position_id per_competence_elements.position_id%TYPE,

118: proficiency_level_id per_competence_elements.proficiency_level_id%TYPE,
119: high_proficiency_level_id per_competence_elements.high_proficiency_level_id%TYPE,
120: organization_id per_competence_elements.organization_id%TYPE,
121: job_id per_competence_elements.job_id%TYPE,
122: position_id per_competence_elements.position_id%TYPE,
123: valid_grade_id per_competence_elements.valid_grade_id%TYPE,
124: business_group_id per_competence_elements.business_group_id%TYPE,
125: enterprise_id per_competence_elements.enterprise_id%TYPE,
126: structure_type hr_lookups.meaning%TYPE,

Line 123: valid_grade_id per_competence_elements.valid_grade_id%TYPE,

119: high_proficiency_level_id per_competence_elements.high_proficiency_level_id%TYPE,
120: organization_id per_competence_elements.organization_id%TYPE,
121: job_id per_competence_elements.job_id%TYPE,
122: position_id per_competence_elements.position_id%TYPE,
123: valid_grade_id per_competence_elements.valid_grade_id%TYPE,
124: business_group_id per_competence_elements.business_group_id%TYPE,
125: enterprise_id per_competence_elements.enterprise_id%TYPE,
126: structure_type hr_lookups.meaning%TYPE,
127: read_only_attr NUMBER,

Line 124: business_group_id per_competence_elements.business_group_id%TYPE,

120: organization_id per_competence_elements.organization_id%TYPE,
121: job_id per_competence_elements.job_id%TYPE,
122: position_id per_competence_elements.position_id%TYPE,
123: valid_grade_id per_competence_elements.valid_grade_id%TYPE,
124: business_group_id per_competence_elements.business_group_id%TYPE,
125: enterprise_id per_competence_elements.enterprise_id%TYPE,
126: structure_type hr_lookups.meaning%TYPE,
127: read_only_attr NUMBER,
128: detail_attr NUMBER,

Line 125: enterprise_id per_competence_elements.enterprise_id%TYPE,

121: job_id per_competence_elements.job_id%TYPE,
122: position_id per_competence_elements.position_id%TYPE,
123: valid_grade_id per_competence_elements.valid_grade_id%TYPE,
124: business_group_id per_competence_elements.business_group_id%TYPE,
125: enterprise_id per_competence_elements.enterprise_id%TYPE,
126: structure_type hr_lookups.meaning%TYPE,
127: read_only_attr NUMBER,
128: detail_attr NUMBER,
129: competence_alias per_competences.competence_alias%TYPE,

Line 142: TYPE per_competence_elements.TYPE%TYPE

138: high_step_name per_rating_levels_vl.NAME%TYPE,
139: lookup_code hr_lookups.lookup_code%TYPE,
140: minimum_proficiency VARCHAR2 (100),
141: maximum_proficiency VARCHAR2 (100),
142: TYPE per_competence_elements.TYPE%TYPE
143: );
144:
145: TYPE sel_comp_tab IS TABLE OF bus_rules_comps
146: INDEX BY BINARY_INTEGER;

Line 730: FROM per_competence_elements pce,

726: NULL, NULL,
727: r2.step_value || ' - ' || r2.NAME
728: ) maximum_proficiency,
729: pce.TYPE
730: FROM per_competence_elements pce,
731: per_competences_vl pc,
732: hr_lookups hrl,
733: per_rating_levels_vl r1,
734: per_rating_levels_vl r2

Line 781: FROM per_competence_elements pce,

777: NULL, NULL,
778: r2.step_value || ' - ' || r2.NAME
779: ) maximum_proficiency,
780: pce.TYPE
781: FROM per_competence_elements pce,
782: per_competences_vl pc,
783: hr_lookups hrl,
784: per_rating_levels_vl r1,
785: per_rating_levels_vl r2

Line 832: FROM per_competence_elements pce,

828: NULL, NULL,
829: r2.step_value || ' - ' || r2.NAME
830: ) maximum_proficiency,
831: pce.TYPE
832: FROM per_competence_elements pce,
833: per_competences_vl pc,
834: hr_lookups hrl,
835: per_rating_levels_vl r1,
836: per_rating_levels_vl r2

Line 883: FROM per_competence_elements pce,

879: NULL, NULL,
880: r2.step_value || ' - ' || r2.NAME
881: ) maximum_proficiency,
882: pce.TYPE
883: FROM per_competence_elements pce,
884: per_competences_vl pc,
885: hr_lookups hrl,
886: per_rating_levels_vl r1,
887: per_rating_levels_vl r2

Line 1136: p_assess_type_id per_competence_elements.assessment_type_id%TYPE

1132: FROM per_appraisal_templates
1133: WHERE appraisal_template_id = p_appraisal_templ_id;
1134:
1135: CURSOR get_assess_templ_comps (
1136: p_assess_type_id per_competence_elements.assessment_type_id%TYPE
1137: )
1138: IS
1139: SELECT ce.competence_id, ce.competence_element_id, ce.TYPE,
1140: ce.parent_competence_element_id, c.NAME,

Line 1143: FROM per_competence_elements a,

1139: SELECT ce.competence_id, ce.competence_element_id, ce.TYPE,
1140: ce.parent_competence_element_id, c.NAME,
1141: RANK () OVER (PARTITION BY ce.competence_id ORDER BY ce.competence_element_id)
1142: RANK
1143: FROM per_competence_elements a,
1144: per_competence_elements ce,
1145: per_competences_vl c
1146: WHERE a.assessment_type_id = p_assess_type_id
1147: AND a.TYPE = 'ASSESSMENT_GROUP'

Line 1144: per_competence_elements ce,

1140: ce.parent_competence_element_id, c.NAME,
1141: RANK () OVER (PARTITION BY ce.competence_id ORDER BY ce.competence_element_id)
1142: RANK
1143: FROM per_competence_elements a,
1144: per_competence_elements ce,
1145: per_competences_vl c
1146: WHERE a.assessment_type_id = p_assess_type_id
1147: AND a.TYPE = 'ASSESSMENT_GROUP'
1148: AND (NVL (c.date_from, TRUNC (SYSDATE)) <= TRUNC (SYSDATE))

Line 1230: l_comp_ele_id per_competence_elements.competence_element_id%TYPE;

1226: l_assessment_comp_ovn per_assessments.object_version_number%TYPE;
1227: l_assessment_obj_ovn per_assessments.object_version_number%TYPE;
1228: l_assess_comps assess_comps_info;
1229: l_check_default_job_comps VARCHAR2 (2) DEFAULT '';
1230: l_comp_ele_id per_competence_elements.competence_element_id%TYPE;
1231: l_comp_ovn per_competence_elements.object_version_number%TYPE;
1232: l_return_status VARCHAR2 (10) DEFAULT '';
1233: l_competence_error VARCHAR2 (1000) DEFAULT NULL;
1234: module_name VARCHAR2 (100)

Line 1231: l_comp_ovn per_competence_elements.object_version_number%TYPE;

1227: l_assessment_obj_ovn per_assessments.object_version_number%TYPE;
1228: l_assess_comps assess_comps_info;
1229: l_check_default_job_comps VARCHAR2 (2) DEFAULT '';
1230: l_comp_ele_id per_competence_elements.competence_element_id%TYPE;
1231: l_comp_ovn per_competence_elements.object_version_number%TYPE;
1232: l_return_status VARCHAR2 (10) DEFAULT '';
1233: l_competence_error VARCHAR2 (1000) DEFAULT NULL;
1234: module_name VARCHAR2 (100)
1235: DEFAULT 'MASS APPRAISAL CREATION';