eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_WF_PKG dependencies on JTF_RS_RESOURCE_EXTNS

Line 380: FROM JTF_RS_RESOURCE_EXTNS

376:
377:
378: CURSOR c_resource_id(b_user_id NUMBER) IS
379: SELECT RESOURCE_ID
380: FROM JTF_RS_RESOURCE_EXTNS
381: WHERE USER_ID=b_user_id;
382:
383: --assignee bug
384: CURSOR c_user_id(b_resource_id NUMBER) IS

Line 386: FROM JTF_RS_RESOURCE_EXTNS

382:
383: --assignee bug
384: CURSOR c_user_id(b_resource_id NUMBER) IS
385: SELECT USER_ID
386: FROM JTF_RS_RESOURCE_EXTNS
387: WHERE RESOURCE_ID=b_resource_id;
388:
389: l_assignee_user_id NUMBER;
390:

Line 469: FROM jtf_rs_resource_extns jtrs

465:
466: CURSOR l_get_user_id(p_resource_id IN NUMBER)
467: IS
468: SELECT jtrs.user_id
469: FROM jtf_rs_resource_extns jtrs
470: WHERE jtrs.resource_id = p_resource_id;
471:
472: BEGIN
473: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 595: FROM JTF_RS_RESOURCE_EXTNS

591:
592:
593: CURSOR c_resource_id(b_user_id NUMBER) IS
594: SELECT RESOURCE_ID
595: FROM JTF_RS_RESOURCE_EXTNS
596: WHERE USER_ID=b_user_id;
597:
598: CURSOR c_access(b_task_assignment_id NUMBER,b_user_id NUMBER)
599: IS

Line 608: FROM JTF_RS_RESOURCE_EXTNS

604:
605: --assignee bug
606: CURSOR c_user_id(b_resource_id NUMBER) IS
607: SELECT USER_ID
608: FROM JTF_RS_RESOURCE_EXTNS
609: WHERE RESOURCE_ID=b_resource_id;
610:
611: l_assignee_user_id NUMBER;
612:

Line 939: FROM JTF_TASK_ASSIGNMENTS tas, JTF_RS_RESOURCE_EXTNS rs

935: l_sqlerrmsg VARCHAR2(4000);
936:
937: CURSOR c_task_ass_csr (b_task_id NUMBER) IS
938: SELECT rs.RESOURCE_ID, rs.USER_ID, tas.TASK_ASSIGNMENT_ID
939: FROM JTF_TASK_ASSIGNMENTS tas, JTF_RS_RESOURCE_EXTNS rs
940: WHERE TASK_ID = b_task_id
941: AND tas.RESOURCE_ID = rs.RESOURCE_ID;
942:
943: CURSOR l_task_post_upd_csr(b_task_id NUMBER)

Line 984: FROM JTF_RS_RESOURCE_EXTNS

980: WHERE TASK_ID=b_task_id;
981:
982: CURSOR c_resource_id(b_user_id NUMBER) IS
983: SELECT RESOURCE_ID
984: FROM JTF_RS_RESOURCE_EXTNS
985: WHERE USER_ID=b_user_id;
986:
987: --assignee bug
988: CURSOR c_user_id(b_resource_id NUMBER) IS

Line 990: FROM JTF_RS_RESOURCE_EXTNS

986:
987: --assignee bug
988: CURSOR c_user_id(b_resource_id NUMBER) IS
989: SELECT USER_ID
990: FROM JTF_RS_RESOURCE_EXTNS
991: WHERE RESOURCE_ID=b_resource_id;
992:
993: l_assignee_user_id NUMBER;
994:

Line 1897: l_resource_id jtf_rs_resource_extns.resource_id%type;

1893: IS
1894: l_debrief_header_id csf_debrief_headers.debrief_header_id%TYPE;
1895: l_task_assignment_id csf_debrief_headers.task_assignment_id%type;
1896: l_user_id fnd_user.user_id%type;
1897: l_resource_id jtf_rs_resource_extns.resource_id%type;
1898:
1899: CURSOR l_csm_debrfdel_csr (p_debrief_header_id csf_debrief_headers.debrief_header_id%type) IS
1900: SELECT dhdr.task_assignment_id, jtrs.user_id, jta.resource_id
1901: FROM csf_debrief_headers dhdr,

Line 1903: jtf_rs_resource_extns jtrs

1899: CURSOR l_csm_debrfdel_csr (p_debrief_header_id csf_debrief_headers.debrief_header_id%type) IS
1900: SELECT dhdr.task_assignment_id, jtrs.user_id, jta.resource_id
1901: FROM csf_debrief_headers dhdr,
1902: jtf_task_assignments jta,
1903: jtf_rs_resource_extns jtrs
1904: WHERE dhdr.debrief_header_id = p_debrief_header_id
1905: AND jta.task_assignment_id = dhdr.task_assignment_id
1906: AND jtrs.resource_id = jta.resource_id
1907: ;

Line 2387: jtf_rs_resource_extns jtrs,

2383: FROM po_location_associations_all pla,
2384: hz_cust_site_uses_all csu,
2385: hz_cust_acct_sites_all cas,
2386: csp_rs_cust_relations rcr,
2387: jtf_rs_resource_extns jtrs,
2388: hz_party_sites hps,
2389: hz_locations hzl
2390: WHERE pla.location_id = p_locationid
2391: AND csu.site_use_id = pla.site_use_id

Line 2464: jtf_rs_resource_extns jtrs,

2460: FROM po_location_associations_all pla,
2461: hz_cust_site_uses_all csu,
2462: hz_cust_acct_sites_all cas,
2463: csp_rs_cust_relations rcr,
2464: jtf_rs_resource_extns jtrs,
2465: hz_party_sites hps,
2466: hz_locations hzl
2467: WHERE pla.location_id = p_locationid
2468: AND csu.site_use_id = pla.site_use_id

Line 2531: jtf_rs_resource_extns jtrs

2527: CURSOR l_req_hdr_csr(p_req_header_id IN NUMBER ) IS
2528: SELECT hdr.resource_id,
2529: jtrs.user_id
2530: FROM csp_requirement_headers hdr,
2531: jtf_rs_resource_extns jtrs
2532: WHERE hdr.requirement_header_id = p_req_header_id
2533: AND jtrs.resource_id = hdr.resource_id
2534: UNION
2535: SELECT ta.resource_id,

Line 2540: jtf_rs_resource_extns jtrs

2536: jtrs.user_id
2537: FROM csp_requirement_headers hdr,
2538: jtf_tasks_b jt,
2539: jtf_task_assignments ta,
2540: jtf_rs_resource_extns jtrs
2541: WHERE hdr.requirement_header_id = p_req_header_id
2542: AND jt.task_id = hdr.task_id
2543: AND ta.task_id = jt.task_id
2544: AND jtrs.resource_id = ta.resource_id

Line 2676: jtf_rs_resource_extns jtrs

2672: hdr.resource_id,
2673: jtrs.user_id
2674: FROM csp_requirement_headers hdr,
2675: csp_requirement_lines line,
2676: jtf_rs_resource_extns jtrs
2677: WHERE hdr.requirement_header_id = line.requirement_header_id
2678: AND line.requirement_line_id = p_req_line_id
2679: AND jtrs.resource_id = hdr.resource_id
2680: UNION

Line 2688: jtf_rs_resource_extns jtrs

2684: FROM csp_requirement_headers hdr,
2685: csp_requirement_lines line,
2686: jtf_tasks_b jt,
2687: jtf_task_assignments ta,
2688: jtf_rs_resource_extns jtrs
2689: WHERE hdr.requirement_header_id = line.requirement_header_id
2690: AND line.requirement_line_id = p_req_line_id
2691: AND jt.task_id = hdr.task_id
2692: AND ta.task_id = jt.task_id