28:
29: c_grp_mem_rec c_grp_mem%rowtype;
30:
31: l_report_type varchar2(30) := x_report_type;
32: l_resource_id jtf_rs_resource_extns.resource_id%type := x_resource_id;
33: l_group_id jtf_rs_groups_b.group_id%type := x_group_id;
34:
35: m_resource_id jtf_rs_resource_extns.resource_id%type;
36: p_resource_id jtf_rs_resource_extns.resource_id%type;
31: l_report_type varchar2(30) := x_report_type;
32: l_resource_id jtf_rs_resource_extns.resource_id%type := x_resource_id;
33: l_group_id jtf_rs_groups_b.group_id%type := x_group_id;
34:
35: m_resource_id jtf_rs_resource_extns.resource_id%type;
36: p_resource_id jtf_rs_resource_extns.resource_id%type;
37: l_res_mgr_name jtf_rs_resource_extns_vl.resource_name%type;
38: l_group_name jtf_rs_groups_vl.group_name%type;
39: l_level_id number;
32: l_resource_id jtf_rs_resource_extns.resource_id%type := x_resource_id;
33: l_group_id jtf_rs_groups_b.group_id%type := x_group_id;
34:
35: m_resource_id jtf_rs_resource_extns.resource_id%type;
36: p_resource_id jtf_rs_resource_extns.resource_id%type;
37: l_res_mgr_name jtf_rs_resource_extns_vl.resource_name%type;
38: l_group_name jtf_rs_groups_vl.group_name%type;
39: l_level_id number;
40: p_level number;
33: l_group_id jtf_rs_groups_b.group_id%type := x_group_id;
34:
35: m_resource_id jtf_rs_resource_extns.resource_id%type;
36: p_resource_id jtf_rs_resource_extns.resource_id%type;
37: l_res_mgr_name jtf_rs_resource_extns_vl.resource_name%type;
38: l_group_name jtf_rs_groups_vl.group_name%type;
39: l_level_id number;
40: p_level number;
41:
38: l_group_name jtf_rs_groups_vl.group_name%type;
39: l_level_id number;
40: p_level number;
41:
42: cursor c_res_hier (l_resource_id jtf_rs_resource_extns.resource_id%type) is
43: select resource_id ,level
44: from jtf_rs_resource_extns
45: where level > 1
46: connect by source_mgr_id = prior source_id
40: p_level number;
41:
42: cursor c_res_hier (l_resource_id jtf_rs_resource_extns.resource_id%type) is
43: select resource_id ,level
44: from jtf_rs_resource_extns
45: where level > 1
46: connect by source_mgr_id = prior source_id
47: start with resource_id = l_resource_id;
48:
47: start with resource_id = l_resource_id;
48:
49: c_res_hier_rec c_res_hier%rowtype;
50:
51: cursor c_res_mgr_name (l_resource_id jtf_rs_resource_extns.resource_id%type) is
52: select resource_name
53: from jtf_rs_resource_extns_vl
54: where resource_id = l_resource_id;
55:
49: c_res_hier_rec c_res_hier%rowtype;
50:
51: cursor c_res_mgr_name (l_resource_id jtf_rs_resource_extns.resource_id%type) is
52: select resource_name
53: from jtf_rs_resource_extns_vl
54: where resource_id = l_resource_id;
55:
56: BEGIN
57:
125:
126: END show_res_skills;
127:
128: PROCEDURE get_res_skills (
129: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE
130: ,P_LEVEL IN NUMBER
131: ) IS
132:
133: cursor c_res_skills is
143: c_res_skills_rec c_res_skills%rowtype;
144:
145: cursor c_res_name is
146: select resource_name, resource_number
147: from jtf_rs_resource_extns_vl
148: where resource_id = p_resource_id;
149:
150: cursor c_prob_name (l_problem_code jtf_rs_problem_codes_v.problem_name%type) is
151: select problem_name
185: l_skill_type fnd_lookups.meaning%type := null;
186: l_skill_name varchar2(242) := null;
187: l_skill_level jtf_rs_skill_levels_vl.level_name%type := null;
188:
189: l_resource_number jtf_rs_resource_extns.resource_number%type;
190: l_resource_name jtf_rs_resource_extns_vl.resource_name%type;
191: l_res_name jtf_rs_resource_extns_vl.resource_name%type;
192:
193: l_level number := p_level;
186: l_skill_name varchar2(242) := null;
187: l_skill_level jtf_rs_skill_levels_vl.level_name%type := null;
188:
189: l_resource_number jtf_rs_resource_extns.resource_number%type;
190: l_resource_name jtf_rs_resource_extns_vl.resource_name%type;
191: l_res_name jtf_rs_resource_extns_vl.resource_name%type;
192:
193: l_level number := p_level;
194: l_padder varchar(200):='';
187: l_skill_level jtf_rs_skill_levels_vl.level_name%type := null;
188:
189: l_resource_number jtf_rs_resource_extns.resource_number%type;
190: l_resource_name jtf_rs_resource_extns_vl.resource_name%type;
191: l_res_name jtf_rs_resource_extns_vl.resource_name%type;
192:
193: l_level number := p_level;
194: l_padder varchar(200):='';
195: