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 92: competence_id per_competence_elements.competence_id%TYPE,

88: show_overall_comments per_appraisal_templates.show_overall_comments%TYPE
89: );
90:
91: TYPE assess_comps_info is RECORD (
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,

Line 93: competence_element_id per_competence_elements.competence_element_id%TYPE,

89: );
90:
91: TYPE assess_comps_info is RECORD (
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 );

Line 94: type per_competence_elements.type%TYPE,

90:
91: TYPE assess_comps_info is RECORD (
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:

Line 95: parent_competence_element_id per_competence_elements.parent_competence_element_id%TYPE,

91: TYPE assess_comps_info is RECORD (
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(

Line 102: competence_element_id per_competence_elements.competence_element_id%TYPE,

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,
106: organization_id per_competence_elements.organization_id%TYPE,

Line 103: mandatory per_competence_elements.mandatory%TYPE,

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,
106: organization_id per_competence_elements.organization_id%TYPE,
107: job_id per_competence_elements.job_id%TYPE,

Line 104: proficiency_level_id per_competence_elements.proficiency_level_id%TYPE,

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,
106: organization_id per_competence_elements.organization_id%TYPE,
107: job_id per_competence_elements.job_id%TYPE,
108: position_id per_competence_elements.position_id%TYPE,

Line 105: high_proficiency_level_id per_competence_elements.high_proficiency_level_id%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,
106: organization_id per_competence_elements.organization_id%TYPE,
107: job_id per_competence_elements.job_id%TYPE,
108: position_id per_competence_elements.position_id%TYPE,
109: valid_grade_id per_competence_elements.valid_grade_id%TYPE,

Line 106: organization_id per_competence_elements.organization_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,
106: organization_id per_competence_elements.organization_id%TYPE,
107: job_id per_competence_elements.job_id%TYPE,
108: position_id per_competence_elements.position_id%TYPE,
109: valid_grade_id per_competence_elements.valid_grade_id%TYPE,
110: business_group_id per_competence_elements.business_group_id%TYPE,

Line 107: job_id per_competence_elements.job_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,
106: organization_id per_competence_elements.organization_id%TYPE,
107: job_id per_competence_elements.job_id%TYPE,
108: position_id per_competence_elements.position_id%TYPE,
109: valid_grade_id per_competence_elements.valid_grade_id%TYPE,
110: business_group_id per_competence_elements.business_group_id%TYPE,
111: enterprise_id per_competence_elements.enterprise_id%TYPE,

Line 108: position_id per_competence_elements.position_id%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,
106: organization_id per_competence_elements.organization_id%TYPE,
107: job_id per_competence_elements.job_id%TYPE,
108: position_id per_competence_elements.position_id%TYPE,
109: valid_grade_id per_competence_elements.valid_grade_id%TYPE,
110: business_group_id per_competence_elements.business_group_id%TYPE,
111: enterprise_id per_competence_elements.enterprise_id%TYPE,
112: structure_type hr_lookups.meaning%TYPE,

Line 109: valid_grade_id per_competence_elements.valid_grade_id%TYPE,

105: high_proficiency_level_id per_competence_elements.high_proficiency_level_id%TYPE,
106: organization_id per_competence_elements.organization_id%TYPE,
107: job_id per_competence_elements.job_id%TYPE,
108: position_id per_competence_elements.position_id%TYPE,
109: valid_grade_id per_competence_elements.valid_grade_id%TYPE,
110: business_group_id per_competence_elements.business_group_id%TYPE,
111: enterprise_id per_competence_elements.enterprise_id%TYPE,
112: structure_type hr_lookups.meaning%TYPE,
113: read_only_attr number,

Line 110: business_group_id per_competence_elements.business_group_id%TYPE,

106: organization_id per_competence_elements.organization_id%TYPE,
107: job_id per_competence_elements.job_id%TYPE,
108: position_id per_competence_elements.position_id%TYPE,
109: valid_grade_id per_competence_elements.valid_grade_id%TYPE,
110: business_group_id per_competence_elements.business_group_id%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,

Line 111: enterprise_id per_competence_elements.enterprise_id%TYPE,

107: job_id per_competence_elements.job_id%TYPE,
108: position_id per_competence_elements.position_id%TYPE,
109: valid_grade_id per_competence_elements.valid_grade_id%TYPE,
110: business_group_id per_competence_elements.business_group_id%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,

Line 128: type per_competence_elements.type%TYPE);

124: high_step_name per_rating_levels_vl.name%TYPE,
125: lookup_code hr_lookups.lookup_code%TYPE,
126: minimum_proficiency varchar2(100),
127: maximum_proficiency varchar2(100),
128: type per_competence_elements.type%TYPE);
129:
130: TYPE sel_comp_tab IS TABLE OF bus_rules_comps INDEX BY BINARY_INTEGER ;
131:
132: type competences_rc is RECORD (

Line 570: FROM per_competence_elements pce,

566: hrl.lookup_code,
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

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

839: FROM per_appraisal_templates
840: WHERE appraisal_template_id = p_appraisal_templ_id;
841:
842:
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

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)

Line 910: l_comp_ele_id per_competence_elements.competence_element_id%TYPE;

906: l_assessment_obj_ovn per_assessments.object_version_number%TYPE;
907: l_assess_comps assess_comps_info;
908: l_check_default_job_comps varchar2(2) default '';
909:
910: l_comp_ele_id per_competence_elements.competence_element_id%TYPE;
911: l_comp_ovn per_competence_elements.object_version_number%TYPE;
912: l_return_status varchar2(10) default '';
913: l_competence_error varchar2(1000) default null;
914: module_name varchar2(100) default 'MASS APPRAISAL CREATION';

Line 911: l_comp_ovn per_competence_elements.object_version_number%TYPE;

907: l_assess_comps assess_comps_info;
908: l_check_default_job_comps varchar2(2) default '';
909:
910: l_comp_ele_id per_competence_elements.competence_element_id%TYPE;
911: l_comp_ovn per_competence_elements.object_version_number%TYPE;
912: l_return_status varchar2(10) default '';
913: l_competence_error varchar2(1000) default null;
914: module_name varchar2(100) default 'MASS APPRAISAL CREATION';
915: l_error_message varchar2(1000) default null;