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 CSP_REQUIREMENT_LINES

Line 2658: l_req_line_id csp_requirement_lines.requirement_line_id%TYPE;

2654: END CSP_REQ_HEADERS_POST_DEL;
2655:
2656: PROCEDURE CSP_REQ_LINES_POST_INS(x_return_status OUT NOCOPY varchar2)
2657: IS
2658: l_req_line_id csp_requirement_lines.requirement_line_id%TYPE;
2659: l_sqlerrno varchar2(20);
2660: l_sqlerrmsg varchar2(2000);
2661:
2662: CURSOR l_req_line_csr(p_req_line_id IN NUMBER ) IS

Line 2667: csp_requirement_lines line,

2663: SELECT hdr.requirement_header_id,
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

Line 2677: csp_requirement_lines line,

2673: SELECT hdr.requirement_header_id,
2674: ta.resource_id,
2675: jtrs.user_id
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

Line 2698: l_req_line_id := CSP_REQUIREMENT_LINES_PKG.user_hook_rec.REQUIREMENT_LINE_ID;

2694:
2695: CSM_UTIL_PKG.LOG('Entering CSM_WF_PKG.CSP_REQ_LINES_POST_INS', 'CSM_WF_PKG.CSP_REQ_LINES_POST_INS',
2696: FND_LOG.LEVEL_PROCEDURE );
2697:
2698: l_req_line_id := CSP_REQUIREMENT_LINES_PKG.user_hook_rec.REQUIREMENT_LINE_ID;
2699:
2700: FOR r_req_line_rec IN l_req_line_csr(l_req_line_id) LOOP
2701: IF csm_util_pkg.is_palm_resource(r_req_line_rec.resource_id) THEN
2702: csm_csp_req_lines_event_pkg.csp_req_lines_mdirty_i(p_requirement_line_id=>l_req_line_id,

Line 2724: l_req_line_id csp_requirement_lines.requirement_line_id%TYPE;

2720: END CSP_REQ_LINES_POST_INS;
2721:
2722: PROCEDURE CSP_REQ_LINES_POST_UPD(x_return_status OUT NOCOPY varchar2)
2723: IS
2724: l_req_line_id csp_requirement_lines.requirement_line_id%TYPE;
2725: l_sqlerrno varchar2(20);
2726: l_sqlerrmsg varchar2(2000);
2727:
2728: CURSOR l_req_line_csr(p_req_line_id IN NUMBER ) IS

Line 2744: l_req_line_id := CSP_REQUIREMENT_LINES_PKG.user_hook_rec.REQUIREMENT_LINE_ID;

2740:
2741: CSM_UTIL_PKG.LOG('Entering CSM_WF_PKG.CSP_REQ_LINES_POST_UPD', 'CSM_WF_PKG.CSP_REQ_LINES_POST_UPD',
2742: FND_LOG.LEVEL_PROCEDURE );
2743:
2744: l_req_line_id := CSP_REQUIREMENT_LINES_PKG.user_hook_rec.REQUIREMENT_LINE_ID;
2745:
2746: FOR r_req_line_rec IN l_req_line_csr(l_req_line_id) LOOP
2747: csm_csp_req_lines_event_pkg.csp_req_lines_mdirty_u(p_requirement_line_id=>l_req_line_id,
2748: p_user_id=>r_req_line_rec.user_id);

Line 2765: l_req_line_id csp_requirement_lines.requirement_line_id%TYPE;

2761: END CSP_REQ_LINES_POST_UPD;
2762:
2763: PROCEDURE CSP_REQ_LINES_POST_DEL(x_return_status OUT NOCOPY varchar2)
2764: IS
2765: l_req_line_id csp_requirement_lines.requirement_line_id%TYPE;
2766: l_sqlerrno varchar2(20);
2767: l_sqlerrmsg varchar2(2000);
2768:
2769: CURSOR l_req_line_acc_csr(p_req_line_id IN NUMBER ) IS

Line 2785: l_req_line_id := CSP_REQUIREMENT_LINES_PKG.user_hook_rec.REQUIREMENT_LINE_ID;

2781:
2782: CSM_UTIL_PKG.LOG('Entering CSM_WF_PKG.CSP_REQ_LINES_POST_DEL', 'CSM_WF_PKG.CSP_REQ_LINES_POST_DEL',
2783: FND_LOG.LEVEL_PROCEDURE );
2784:
2785: l_req_line_id := CSP_REQUIREMENT_LINES_PKG.user_hook_rec.REQUIREMENT_LINE_ID;
2786:
2787: FOR r_req_line_acc_rec IN l_req_line_acc_csr(l_req_line_id) LOOP
2788: csm_csp_req_lines_event_pkg.csp_req_lines_mdirty_d(p_requirement_line_id=>l_req_line_id,
2789: p_user_id=>r_req_line_acc_rec.user_id);

Line 2806: l_req_line_id csp_requirement_lines.requirement_line_id%TYPE;

2802: END CSP_REQ_LINES_POST_DEL;
2803:
2804: PROCEDURE CSP_REQ_LINE_DETAILS_POST_INS(x_return_status OUT NOCOPY varchar2)
2805: IS
2806: l_req_line_id csp_requirement_lines.requirement_line_id%TYPE;
2807: l_req_line_detail_id csp_req_line_details.req_line_detail_id%TYPE;
2808: l_sqlerrno varchar2(20);
2809: l_sqlerrmsg varchar2(2000);
2810:

Line 2847: l_req_line_id csp_requirement_lines.requirement_line_id%TYPE;

2843: END CSP_REQ_LINE_DETAILS_POST_INS;
2844:
2845: PROCEDURE CSP_REQ_LINE_DETAILS_POST_UPD(x_return_status OUT NOCOPY varchar2)
2846: IS
2847: l_req_line_id csp_requirement_lines.requirement_line_id%TYPE;
2848: l_req_line_detail_id csp_req_line_details.req_line_detail_id%TYPE;
2849: l_sqlerrno varchar2(20);
2850: l_sqlerrmsg varchar2(2000);
2851:

Line 2882: l_req_line_id csp_requirement_lines.requirement_line_id%TYPE;

2878: END CSP_REQ_LINE_DETAILS_POST_UPD;
2879:
2880: PROCEDURE CSP_REQ_LINE_DETAILS_PRE_DEL(x_return_status OUT NOCOPY varchar2)
2881: IS
2882: l_req_line_id csp_requirement_lines.requirement_line_id%TYPE;
2883: l_req_line_detail_id csp_req_line_details.req_line_detail_id%TYPE;
2884: l_sqlerrno varchar2(20);
2885: l_sqlerrmsg varchar2(2000);
2886: