APPS.JTF_RS_SKILLS_REPORT_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 32: l_resource_id jtf_rs_resource_extns.resource_id%type := x_resource_id;

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;

Line 35: m_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;

Line 36: p_resource_id jtf_rs_resource_extns.resource_id%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;
40: p_level number;

Line 37: l_res_mgr_name jtf_rs_resource_extns_vl.resource_name%type;

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:

Line 42: cursor c_res_hier (l_resource_id jtf_rs_resource_extns.resource_id%type) is

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

Line 44: from jtf_rs_resource_extns

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:

Line 51: cursor c_res_mgr_name (l_resource_id jtf_rs_resource_extns.resource_id%type) is

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:

Line 53: from jtf_rs_resource_extns_vl

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:

Line 129: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE

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

Line 147: from jtf_rs_resource_extns_vl

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

Line 189: l_resource_number jtf_rs_resource_extns.resource_number%type;

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;

Line 190: l_resource_name jtf_rs_resource_extns_vl.resource_name%type;

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):='';

Line 191: l_res_name jtf_rs_resource_extns_vl.resource_name%type;

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: