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 370: FROM JTF_RS_RESOURCE_EXTNS

366:
367:
368: CURSOR c_resource_id(b_user_id NUMBER) IS
369: SELECT RESOURCE_ID
370: FROM JTF_RS_RESOURCE_EXTNS
371: WHERE USER_ID=b_user_id;
372:
373: --assignee bug
374: CURSOR c_user_id(b_resource_id NUMBER) IS

Line 376: FROM JTF_RS_RESOURCE_EXTNS

372:
373: --assignee bug
374: CURSOR c_user_id(b_resource_id NUMBER) IS
375: SELECT USER_ID
376: FROM JTF_RS_RESOURCE_EXTNS
377: WHERE RESOURCE_ID=b_resource_id;
378:
379: l_assignee_user_id NUMBER;
380:

Line 465: FROM jtf_rs_resource_extns jtrs

461:
462: CURSOR l_get_user_id(p_resource_id IN NUMBER)
463: IS
464: SELECT jtrs.user_id
465: FROM jtf_rs_resource_extns jtrs
466: WHERE jtrs.resource_id = p_resource_id;
467:
468: BEGIN
469: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 585: FROM JTF_RS_RESOURCE_EXTNS

581:
582:
583: CURSOR c_resource_id(b_user_id NUMBER) IS
584: SELECT RESOURCE_ID
585: FROM JTF_RS_RESOURCE_EXTNS
586: WHERE USER_ID=b_user_id;
587:
588: CURSOR c_access(b_task_assignment_id NUMBER,b_user_id NUMBER)
589: IS

Line 598: FROM JTF_RS_RESOURCE_EXTNS

594:
595: --assignee bug
596: CURSOR c_user_id(b_resource_id NUMBER) IS
597: SELECT USER_ID
598: FROM JTF_RS_RESOURCE_EXTNS
599: WHERE RESOURCE_ID=b_resource_id;
600:
601: l_assignee_user_id NUMBER;
602:

Line 937: FROM JTF_TASK_ASSIGNMENTS tas, JTF_RS_RESOURCE_EXTNS rs

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

Line 976: FROM JTF_RS_RESOURCE_EXTNS

972: WHERE TASK_ID=b_task_id;
973:
974: CURSOR c_resource_id(b_user_id NUMBER) IS
975: SELECT RESOURCE_ID
976: FROM JTF_RS_RESOURCE_EXTNS
977: WHERE USER_ID=b_user_id;
978:
979: --assignee bug
980: CURSOR c_user_id(b_resource_id NUMBER) IS

Line 982: FROM JTF_RS_RESOURCE_EXTNS

978:
979: --assignee bug
980: CURSOR c_user_id(b_resource_id NUMBER) IS
981: SELECT USER_ID
982: FROM JTF_RS_RESOURCE_EXTNS
983: WHERE RESOURCE_ID=b_resource_id;
984:
985: l_assignee_user_id NUMBER;
986:

Line 1913: l_resource_id jtf_rs_resource_extns.resource_id%type;

1909: IS
1910: l_debrief_header_id csf_debrief_headers.debrief_header_id%TYPE;
1911: l_task_assignment_id csf_debrief_headers.task_assignment_id%type;
1912: l_user_id fnd_user.user_id%type;
1913: l_resource_id jtf_rs_resource_extns.resource_id%type;
1914:
1915: CURSOR l_csm_debrfdel_csr (p_debrief_header_id csf_debrief_headers.debrief_header_id%type) IS
1916: SELECT dhdr.task_assignment_id, jtrs.user_id, jta.resource_id
1917: FROM csf_debrief_headers dhdr,

Line 1919: jtf_rs_resource_extns jtrs

1915: CURSOR l_csm_debrfdel_csr (p_debrief_header_id csf_debrief_headers.debrief_header_id%type) IS
1916: SELECT dhdr.task_assignment_id, jtrs.user_id, jta.resource_id
1917: FROM csf_debrief_headers dhdr,
1918: jtf_task_assignments jta,
1919: jtf_rs_resource_extns jtrs
1920: WHERE dhdr.debrief_header_id = p_debrief_header_id
1921: AND jta.task_assignment_id = dhdr.task_assignment_id
1922: AND jtrs.resource_id = jta.resource_id
1923: ;

Line 2523: jtf_rs_resource_extns jtrs

2519: CURSOR l_req_hdr_csr(p_req_header_id IN NUMBER ) IS
2520: SELECT hdr.resource_id,
2521: jtrs.user_id
2522: FROM csp_requirement_headers hdr,
2523: jtf_rs_resource_extns jtrs
2524: WHERE hdr.requirement_header_id = p_req_header_id
2525: AND jtrs.resource_id = hdr.resource_id
2526: UNION
2527: SELECT ta.resource_id,

Line 2532: jtf_rs_resource_extns jtrs

2528: jtrs.user_id
2529: FROM csp_requirement_headers hdr,
2530: jtf_tasks_b jt,
2531: jtf_task_assignments ta,
2532: jtf_rs_resource_extns jtrs
2533: WHERE hdr.requirement_header_id = p_req_header_id
2534: AND jt.task_id = hdr.task_id
2535: AND ta.task_id = jt.task_id
2536: AND jtrs.resource_id = ta.resource_id

Line 2668: jtf_rs_resource_extns jtrs

2664: hdr.resource_id,
2665: jtrs.user_id
2666: FROM csp_requirement_headers hdr,
2667: csp_requirement_lines line,
2668: jtf_rs_resource_extns jtrs
2669: WHERE hdr.requirement_header_id = line.requirement_header_id
2670: AND line.requirement_line_id = p_req_line_id
2671: AND jtrs.resource_id = hdr.resource_id
2672: UNION

Line 2680: jtf_rs_resource_extns jtrs

2676: FROM csp_requirement_headers hdr,
2677: csp_requirement_lines line,
2678: jtf_tasks_b jt,
2679: jtf_task_assignments ta,
2680: jtf_rs_resource_extns jtrs
2681: WHERE hdr.requirement_header_id = line.requirement_header_id
2682: AND line.requirement_line_id = p_req_line_id
2683: AND jt.task_id = hdr.task_id
2684: AND ta.task_id = jt.task_id