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 537: FROM jtf_rs_resource_extns

533: IF (p_resource_user_id IS NULL) THEN
534: BEGIN
535: SELECT nvl(user_id,-99)
536: INTO l_resource_user_id
537: FROM jtf_rs_resource_extns
538: WHERE resource_id = p_resource_id;
539: EXCEPTION WHEN NO_DATA_FOUND THEN
540: l_resource_user_id := -99;
541: WHEN OTHERS THEN

Line 592: FROM jtf_rs_resource_extns

588: ELSIF ((l_profile_value = 'NONE') AND (p_group_id IS NOT NULL)) THEN
589: BEGIN
590: SELECT resource_id
591: INTO l_resource_id
592: FROM jtf_rs_resource_extns
593: WHERE user_id = l_user_id
594: AND rownum < 2;
595: EXCEPTION
596: WHEN NO_DATA_FOUND THEN

Line 709: from jtf_rs_resource_extns connect by

705: l_user_id number;
706:
707: cursor mgr_usr_ids(p_res_id number) is
708: select user_id
709: from jtf_rs_resource_extns connect by
710: source_id = prior source_mgr_id
711: start with resource_id = p_res_id;
712:
713: BEGIN