APPS.JTF_RS_RESOURCE_UTL_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 39: FROM jtf_rs_resource_extns rsc

35: , rsc.source_id
36: , rsc.object_version_number
37: , rsc.start_date_active
38: , rsc.end_date_active
39: FROM jtf_rs_resource_extns rsc
40: WHERE rsc.resource_id = l_resource_id;
41:
42: term_res_rec term_res_cur%rowtype;
43:

Line 63: CURSOR res_srp_cur(l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE)

59: res_role_rec res_role_cur%rowtype;
60:
61:
62: --cursor to get salesreps
63: CURSOR res_srp_cur(l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE)
64: IS
65: SELECT res.salesrep_id
66: , res.org_id
67: , res.start_date_active

Line 110: CURSOR res_team_cur(l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE)

106:
107: res_srp_terr_dup_rec res_srp_terr_dup_cur%rowtype;
108:
109: --cursor to get team memebr roles for the resource
110: CURSOR res_team_cur(l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE)
111: IS
112: SELECT rlt.role_relate_id
113: , rlt.start_date_active
114: , rlt.end_date_active

Line 130: CURSOR res_group_cur(l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE)

126:
127: res_team_rec res_team_cur%rowtype;
128:
129: --cursor to get roles for the resource
130: CURSOR res_group_cur(l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE)
131: IS
132: SELECT rlt.role_relate_id
133: , rlt.start_date_active
134: , rlt.end_date_active

Line 549: FROM jtf_rs_resource_extns

545: IF (p_resource_user_id IS NULL) THEN
546: BEGIN
547: SELECT nvl(user_id,-99)
548: INTO l_resource_user_id
549: FROM jtf_rs_resource_extns
550: WHERE resource_id = p_resource_id;
551: EXCEPTION WHEN NO_DATA_FOUND THEN
552: l_resource_user_id := -99;
553: WHEN OTHERS THEN

Line 604: FROM jtf_rs_resource_extns

600: ELSIF ((l_profile_value = 'NONE') AND (p_group_id IS NOT NULL)) THEN
601: BEGIN
602: SELECT resource_id
603: INTO l_resource_id
604: FROM jtf_rs_resource_extns
605: WHERE user_id = l_user_id
606: AND rownum < 2;
607: EXCEPTION
608: WHEN NO_DATA_FOUND THEN

Line 721: from jtf_rs_resource_extns connect by

717: l_user_id number;
718:
719: cursor mgr_usr_ids(p_res_id number) is
720: select user_id
721: from jtf_rs_resource_extns connect by
722: source_id = prior source_mgr_id
723: start with resource_id = p_res_id;
724:
725: BEGIN