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.IRC_SKILLS_MATCHING_PKG dependencies on PER_RATING_LEVELS

Line 12: max_id PER_RATING_LEVELS.rating_level_id%TYPE,

8: --GLOBAL TYPES gt_...
9: --Tie together the corresponding 3 related ID's
10: TYPE gt_skill_rec_type IS RECORD (
11: skill_id PER_COMPETENCES.competence_id%type,
12: max_id PER_RATING_LEVELS.rating_level_id%TYPE,
13: min_id PER_RATING_LEVELS.rating_level_id%TYPE,
14: essential PER_COMPETENCE_ELEMENTS.mandatory%TYPE );
15:
16: --Type to hold the set of records tying in the sets of three related input strings

Line 13: min_id PER_RATING_LEVELS.rating_level_id%TYPE,

9: --Tie together the corresponding 3 related ID's
10: TYPE gt_skill_rec_type IS RECORD (
11: skill_id PER_COMPETENCES.competence_id%type,
12: max_id PER_RATING_LEVELS.rating_level_id%TYPE,
13: min_id PER_RATING_LEVELS.rating_level_id%TYPE,
14: essential PER_COMPETENCE_ELEMENTS.mandatory%TYPE );
15:
16: --Type to hold the set of records tying in the sets of three related input strings
17: TYPE gt_skills_tab_type IS TABLE OF gt_skill_rec_type index by binary_integer;

Line 36: per_rating_levels minpr,

32: MIN(maxpr.STEP_VALUE) lowest_max_level,
33: pce.MANDATORY
34: FROM per_competences pc,
35: per_competence_elements pce,
36: per_rating_levels minpr,
37: per_rating_levels maxpr
38: WHERE pc.competence_id = pce.competence_id
39: AND pce.PROFICIENCY_LEVEL_ID = minpr.rating_level_id(+)
40: AND pce.HIGH_PROFICIENCY_LEVEL_ID = maxpr.rating_level_id(+)

Line 37: per_rating_levels maxpr

33: pce.MANDATORY
34: FROM per_competences pc,
35: per_competence_elements pce,
36: per_rating_levels minpr,
37: per_rating_levels maxpr
38: WHERE pc.competence_id = pce.competence_id
39: AND pce.PROFICIENCY_LEVEL_ID = minpr.rating_level_id(+)
40: AND pce.HIGH_PROFICIENCY_LEVEL_ID = maxpr.rating_level_id(+)
41: AND pce.type = 'REQUIREMENT'

Line 54: CURSOR gc_rating_level_details(cp_rate_scale PER_RATING_LEVELS.rating_scale_id%TYPE,

50: pce.MANDATORY,
51: pc.rating_scale_id;
52:
53:
54: CURSOR gc_rating_level_details(cp_rate_scale PER_RATING_LEVELS.rating_scale_id%TYPE,
55: cp_step_value1 PER_RATING_LEVELS.step_value%TYPE,
56: cp_step_value2 PER_RATING_LEVELS.step_value%TYPE) IS
57: SELECT rating_level_id --, step_value, name as level_name
58: FROM per_rating_levels

Line 55: cp_step_value1 PER_RATING_LEVELS.step_value%TYPE,

51: pc.rating_scale_id;
52:
53:
54: CURSOR gc_rating_level_details(cp_rate_scale PER_RATING_LEVELS.rating_scale_id%TYPE,
55: cp_step_value1 PER_RATING_LEVELS.step_value%TYPE,
56: cp_step_value2 PER_RATING_LEVELS.step_value%TYPE) IS
57: SELECT rating_level_id --, step_value, name as level_name
58: FROM per_rating_levels
59: WHERE rating_scale_id = CP_RATE_SCALE

Line 56: cp_step_value2 PER_RATING_LEVELS.step_value%TYPE) IS

52:
53:
54: CURSOR gc_rating_level_details(cp_rate_scale PER_RATING_LEVELS.rating_scale_id%TYPE,
55: cp_step_value1 PER_RATING_LEVELS.step_value%TYPE,
56: cp_step_value2 PER_RATING_LEVELS.step_value%TYPE) IS
57: SELECT rating_level_id --, step_value, name as level_name
58: FROM per_rating_levels
59: WHERE rating_scale_id = CP_RATE_SCALE
60: AND ( step_value = CP_STEP_VALUE1 or step_value = CP_STEP_VALUE2)

Line 58: FROM per_rating_levels

54: CURSOR gc_rating_level_details(cp_rate_scale PER_RATING_LEVELS.rating_scale_id%TYPE,
55: cp_step_value1 PER_RATING_LEVELS.step_value%TYPE,
56: cp_step_value2 PER_RATING_LEVELS.step_value%TYPE) IS
57: SELECT rating_level_id --, step_value, name as level_name
58: FROM per_rating_levels
59: WHERE rating_scale_id = CP_RATE_SCALE
60: AND ( step_value = CP_STEP_VALUE1 or step_value = CP_STEP_VALUE2)
61: ORDER BY step_value;
62:

Line 63: CURSOR gc_comp_rating_level_details(cp_competence_id PER_RATING_LEVELS.competence_id%TYPE,

59: WHERE rating_scale_id = CP_RATE_SCALE
60: AND ( step_value = CP_STEP_VALUE1 or step_value = CP_STEP_VALUE2)
61: ORDER BY step_value;
62:
63: CURSOR gc_comp_rating_level_details(cp_competence_id PER_RATING_LEVELS.competence_id%TYPE,
64: cp_step_value1 PER_RATING_LEVELS.step_value%TYPE,
65: cp_step_value2 PER_RATING_LEVELS.step_value%TYPE) IS
66: SELECT rating_level_id --, step_value, name as level_name
67: FROM per_rating_levels

Line 64: cp_step_value1 PER_RATING_LEVELS.step_value%TYPE,

60: AND ( step_value = CP_STEP_VALUE1 or step_value = CP_STEP_VALUE2)
61: ORDER BY step_value;
62:
63: CURSOR gc_comp_rating_level_details(cp_competence_id PER_RATING_LEVELS.competence_id%TYPE,
64: cp_step_value1 PER_RATING_LEVELS.step_value%TYPE,
65: cp_step_value2 PER_RATING_LEVELS.step_value%TYPE) IS
66: SELECT rating_level_id --, step_value, name as level_name
67: FROM per_rating_levels
68: WHERE competence_id = CP_COMPETENCE_ID

Line 65: cp_step_value2 PER_RATING_LEVELS.step_value%TYPE) IS

61: ORDER BY step_value;
62:
63: CURSOR gc_comp_rating_level_details(cp_competence_id PER_RATING_LEVELS.competence_id%TYPE,
64: cp_step_value1 PER_RATING_LEVELS.step_value%TYPE,
65: cp_step_value2 PER_RATING_LEVELS.step_value%TYPE) IS
66: SELECT rating_level_id --, step_value, name as level_name
67: FROM per_rating_levels
68: WHERE competence_id = CP_COMPETENCE_ID
69: AND ( step_value = CP_STEP_VALUE1 or step_value = CP_STEP_VALUE2)

Line 67: FROM per_rating_levels

63: CURSOR gc_comp_rating_level_details(cp_competence_id PER_RATING_LEVELS.competence_id%TYPE,
64: cp_step_value1 PER_RATING_LEVELS.step_value%TYPE,
65: cp_step_value2 PER_RATING_LEVELS.step_value%TYPE) IS
66: SELECT rating_level_id --, step_value, name as level_name
67: FROM per_rating_levels
68: WHERE competence_id = CP_COMPETENCE_ID
69: AND ( step_value = CP_STEP_VALUE1 or step_value = CP_STEP_VALUE2)
70: ORDER BY step_value;
71:

Line 168: TYPE lt_rating_level_tab_type is table of per_rating_levels.step_value%type index by binary_integer;

164: --Instances
165: lc_dyn_query_cur lt_dyn_query_cur_type;
166:
167: --Store for the valid numbers used to ease the latter dynamic queries
168: TYPE lt_rating_level_tab_type is table of per_rating_levels.step_value%type index by binary_integer;
169: --Instances
170: l_rating_level_tab lt_rating_level_tab_type;
171:
172: --Tie together the corresponding 3 related ID's

Line 175: max_level_num PER_RATING_LEVELS.step_value%TYPE,

171:
172: --Tie together the corresponding 3 related ID's
173: TYPE lr_input_rec_type IS RECORD (
174: skill_id PER_COMPETENCES.competence_id%type,
175: max_level_num PER_RATING_LEVELS.step_value%TYPE,
176: min_level_num PER_RATING_LEVELS.step_value%TYPE );
177:
178: --Type to hold the set of records tying in the sets of three related input strings
179: TYPE lt_input_tab_type IS TABLE OF lr_input_rec_type index by binary_integer;

Line 176: min_level_num PER_RATING_LEVELS.step_value%TYPE );

172: --Tie together the corresponding 3 related ID's
173: TYPE lr_input_rec_type IS RECORD (
174: skill_id PER_COMPETENCES.competence_id%type,
175: max_level_num PER_RATING_LEVELS.step_value%TYPE,
176: min_level_num PER_RATING_LEVELS.step_value%TYPE );
177:
178: --Type to hold the set of records tying in the sets of three related input strings
179: TYPE lt_input_tab_type IS TABLE OF lr_input_rec_type index by binary_integer;
180: --Instances

Line 222: l_rating_level_id_temp per_rating_levels.rating_level_id%type;

218:
219: --Miscellaneous
220: l_concats VARCHAR2(1000):='';
221: l_rowcount number;
222: l_rating_level_id_temp per_rating_levels.rating_level_id%type;
223: l_step_value_temp per_rating_levels.step_value%type;
224:
225: INCONSISTENT_INPUT_LENGTHS EXCEPTION;
226:

Line 223: l_step_value_temp per_rating_levels.step_value%type;

219: --Miscellaneous
220: l_concats VARCHAR2(1000):='';
221: l_rowcount number;
222: l_rating_level_id_temp per_rating_levels.rating_level_id%type;
223: l_step_value_temp per_rating_levels.step_value%type;
224:
225: INCONSISTENT_INPUT_LENGTHS EXCEPTION;
226:
227: --SUB FUNCTION, turn input comma-delimeted list in to table

Line 284: l_sql_where := l_sql_where|| ' AND exists (select 1 from per_rating_levels where rating_level_id=pce.proficiency_level_id'||

280:
281: if table_of_ids(l).min_level_num <> '-1'
282: and table_of_ids(l).max_level_num <> '-1'
283: then
284: l_sql_where := l_sql_where|| ' AND exists (select 1 from per_rating_levels where rating_level_id=pce.proficiency_level_id'||
285: ' and step_value between ' || table_of_ids(l).min_level_num || ' and ' ||
286: table_of_ids(l).max_level_num || ' ) )';
287: elsif table_of_ids(l).min_level_num <> '-1'
288: then

Line 289: l_sql_where := l_sql_where|| ' AND exists (select 1 from per_rating_levels where rating_level_id=pce.proficiency_level_id'||

285: ' and step_value between ' || table_of_ids(l).min_level_num || ' and ' ||
286: table_of_ids(l).max_level_num || ' ) )';
287: elsif table_of_ids(l).min_level_num <> '-1'
288: then
289: l_sql_where := l_sql_where|| ' AND exists (select 1 from per_rating_levels where rating_level_id=pce.proficiency_level_id'||
290: ' and ' || '(step_value >= ' || table_of_ids(l).min_level_num || ' ) ) )';
291: elsif table_of_ids(l).max_level_num <> '-1'
292: then
293: l_sql_where := l_sql_where|| ' AND exists (select 1 from per_rating_levels where rating_level_id=pce.proficiency_level_id'||

Line 293: l_sql_where := l_sql_where|| ' AND exists (select 1 from per_rating_levels where rating_level_id=pce.proficiency_level_id'||

289: l_sql_where := l_sql_where|| ' AND exists (select 1 from per_rating_levels where rating_level_id=pce.proficiency_level_id'||
290: ' and ' || '(step_value >= ' || table_of_ids(l).min_level_num || ' ) ) )';
291: elsif table_of_ids(l).max_level_num <> '-1'
292: then
293: l_sql_where := l_sql_where|| ' AND exists (select 1 from per_rating_levels where rating_level_id=pce.proficiency_level_id'||
294: ' and ' || '(step_value <= ' || table_of_ids(l).max_level_num || ' ) ) )';
295: else
296: l_sql_where := l_sql_where|| ' )';
297: end if;

Line 352: l_sql_from :=' FROM per_rating_levels rl';

348: end if;
349: -- Got list, now build dynamic query
350:
351: l_sql_select :='SELECT rl.rating_level_id,rl.step_value';
352: l_sql_from :=' FROM per_rating_levels rl';
353: l_sql_where :=' WHERE rl.rating_level_id IN ('||l_concats||') ';
354: l_sql_query := l_sql_select||l_sql_from||l_sql_where;
355: --NB Appears cant put :1 in where clause and use "open l_rating_cur for g_sql_query using g_concats;"
356: open lc_dyn_query_cur for l_sql_query;