APPS.JTF_TASK_WF_UTIL dependencies on JTF_RS_RESOURCE_EXTNS

Line 158: FROM jtf_rs_resource_extns

154:
155: PROCEDURE get_party_details(p_resource_id IN NUMBER, p_resource_type_code IN VARCHAR2, x_role_name OUT NOCOPY VARCHAR2) IS
156: CURSOR c_resource_party(b_resource_id jtf_tasks_b.owner_id%TYPE) IS
157: SELECT source_id,user_id
158: FROM jtf_rs_resource_extns
159: WHERE resource_id = b_resource_id;
160:
161: --l_party_id hz_parties.party_id%TYPE;
162: l_display_name VARCHAR2(100); -- check this declaration

Line 220: FROM jtf_rs_resource_extns

216: PROCEDURE find_role(p_resource_id IN NUMBER, p_resource_type_code IN VARCHAR2) IS
217: CURSOR c_group_members(b_group_id jtf_rs_group_members.GROUP_ID%TYPE) IS
218: SELECT resource_id
219: , 'RS_' || CATEGORY resource_type_code
220: FROM jtf_rs_resource_extns
221: WHERE resource_id IN(SELECT resource_id
222: FROM jtf_rs_group_members
223: WHERE GROUP_ID = b_group_id AND NVL(delete_flag, 'N') = 'N');
224:

Line 228: FROM jtf_rs_resource_extns

224:
225: CURSOR c_team_members(b_team_id jtf_rs_team_members.team_id%TYPE) IS
226: SELECT resource_id
227: , 'RS_' || CATEGORY resource_type_code
228: FROM jtf_rs_resource_extns
229: WHERE resource_id IN(SELECT team_resource_id
230: FROM jtf_rs_team_members
231: WHERE team_id = b_team_id AND NVL(delete_flag, 'N') = 'N');
232:

Line 602: FROM jtf_rs_resource_extns

598: WHERE task_status_id = b_status;
599:
600: CURSOR c_logged_res_id IS
601: SELECT resource_id
602: FROM jtf_rs_resource_extns
603: WHERE user_id = fnd_global.user_id;
604:
605: l_task_rec c_task_details%ROWTYPE;
606:

Line 628: l_logged_res_id jtf_rs_resource_extns.resource_id%TYPE;

624:
625: l_task_text VARCHAR2(1050);
626: l_backcomp_flag VARCHAR2(1);
627:
628: l_logged_res_id jtf_rs_resource_extns.resource_id%TYPE;
629:
630: l_wf_items VARCHAR2(500);
631: BEGIN
632: x_return_status := fnd_api.g_ret_sts_success;