APPS.IRC_SKILLS_MATCHING_PKG dependencies on PER_COMPETENCE_ELEMENTS

Line 14: essential PER_COMPETENCE_ELEMENTS.mandatory%TYPE );

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;
18:

Line 22: CURSOR gc_skills_reqd_list (cp_org PER_COMPETENCE_ELEMENTS.enterprise_id%TYPE,

18:
19:
20: --GLOBAL CURSORS gt_...
21: -- Cursor to get a list of skills and levels for a given set of scopes
22: CURSOR gc_skills_reqd_list (cp_org PER_COMPETENCE_ELEMENTS.enterprise_id%TYPE,
23: cp_bgp PER_COMPETENCE_ELEMENTS.organization_id%TYPE,
24: cp_job PER_COMPETENCE_ELEMENTS.position_id%TYPE,
25: cp_pos PER_COMPETENCE_ELEMENTS.position_id%TYPE,
26: cp_eff_date PER_COMPETENCE_ELEMENTS.effective_date_to%TYPE

Line 23: cp_bgp PER_COMPETENCE_ELEMENTS.organization_id%TYPE,

19:
20: --GLOBAL CURSORS gt_...
21: -- Cursor to get a list of skills and levels for a given set of scopes
22: CURSOR gc_skills_reqd_list (cp_org PER_COMPETENCE_ELEMENTS.enterprise_id%TYPE,
23: cp_bgp PER_COMPETENCE_ELEMENTS.organization_id%TYPE,
24: cp_job PER_COMPETENCE_ELEMENTS.position_id%TYPE,
25: cp_pos PER_COMPETENCE_ELEMENTS.position_id%TYPE,
26: cp_eff_date PER_COMPETENCE_ELEMENTS.effective_date_to%TYPE
27: ) IS

Line 24: cp_job PER_COMPETENCE_ELEMENTS.position_id%TYPE,

20: --GLOBAL CURSORS gt_...
21: -- Cursor to get a list of skills and levels for a given set of scopes
22: CURSOR gc_skills_reqd_list (cp_org PER_COMPETENCE_ELEMENTS.enterprise_id%TYPE,
23: cp_bgp PER_COMPETENCE_ELEMENTS.organization_id%TYPE,
24: cp_job PER_COMPETENCE_ELEMENTS.position_id%TYPE,
25: cp_pos PER_COMPETENCE_ELEMENTS.position_id%TYPE,
26: cp_eff_date PER_COMPETENCE_ELEMENTS.effective_date_to%TYPE
27: ) IS
28: SELECT pc.name,

Line 25: cp_pos PER_COMPETENCE_ELEMENTS.position_id%TYPE,

21: -- Cursor to get a list of skills and levels for a given set of scopes
22: CURSOR gc_skills_reqd_list (cp_org PER_COMPETENCE_ELEMENTS.enterprise_id%TYPE,
23: cp_bgp PER_COMPETENCE_ELEMENTS.organization_id%TYPE,
24: cp_job PER_COMPETENCE_ELEMENTS.position_id%TYPE,
25: cp_pos PER_COMPETENCE_ELEMENTS.position_id%TYPE,
26: cp_eff_date PER_COMPETENCE_ELEMENTS.effective_date_to%TYPE
27: ) IS
28: SELECT pc.name,
29: pc.competence_id,

Line 26: cp_eff_date PER_COMPETENCE_ELEMENTS.effective_date_to%TYPE

22: CURSOR gc_skills_reqd_list (cp_org PER_COMPETENCE_ELEMENTS.enterprise_id%TYPE,
23: cp_bgp PER_COMPETENCE_ELEMENTS.organization_id%TYPE,
24: cp_job PER_COMPETENCE_ELEMENTS.position_id%TYPE,
25: cp_pos PER_COMPETENCE_ELEMENTS.position_id%TYPE,
26: cp_eff_date PER_COMPETENCE_ELEMENTS.effective_date_to%TYPE
27: ) IS
28: SELECT pc.name,
29: pc.competence_id,
30: pc.rating_scale_id,

Line 35: per_competence_elements pce,

31: MAX(minpr.STEP_VALUE) highest_min_level,
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(+)

Line 272: l_sql_from :=' FROM per_competence_elements pce';

268: BEGIN
269: l_rowcount := 0;
270: l_sql_query :='';
271: l_sql_select :=' SELECT count(*)';
272: l_sql_from :=' FROM per_competence_elements pce';
273: l_sql_where :=' WHERE pce.person_id = :1 '
274: ||' AND trunc(sysdate) between pce.effective_date_from and nvl(pce.effective_date_to,sysdate)'
275: ||' AND ( ( ';
276: FOR l IN table_of_ids.first .. table_of_ids.last

Line 647: from per_competence_elements

643: select competence_id,
644: nvl(mandatory,'N') as mandatory,
645: nvl(proficiency_level_id,-1) as proficiency_level_id,
646: nvl(high_proficiency_level_id,-1) as high_proficiency_level_id
647: from per_competence_elements
648: where object_name = 'VACANCY'
649: and object_id = CP_VACANCY_ID;
650:
651: l_esse_sk_list_str varchar2(4000);