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.

[Home] [Help]

APPS.CSM_WF_PKG dependencies on CSP_REQUIREMENT_LINES

Line 2666: l_req_line_id csp_requirement_lines.requirement_line_id%TYPE;

2662: END CSP_REQ_HEADERS_POST_DEL;
2663:
2664: PROCEDURE CSP_REQ_LINES_POST_INS(x_return_status OUT NOCOPY varchar2)
2665: IS
2666: l_req_line_id csp_requirement_lines.requirement_line_id%TYPE;
2667: l_sqlerrno varchar2(20);
2668: l_sqlerrmsg varchar2(2000);
2669:
2670: CURSOR l_req_line_csr(p_req_line_id IN NUMBER ) IS

Line 2675: csp_requirement_lines line,

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

Line 2685: csp_requirement_lines line,

2681: SELECT hdr.requirement_header_id,
2682: ta.resource_id,
2683: jtrs.user_id
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

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

2702:
2703: CSM_UTIL_PKG.LOG('Entering CSM_WF_PKG.CSP_REQ_LINES_POST_INS', 'CSM_WF_PKG.CSP_REQ_LINES_POST_INS',
2704: FND_LOG.LEVEL_PROCEDURE );
2705:
2706: l_req_line_id := CSP_REQUIREMENT_LINES_PKG.user_hook_rec.REQUIREMENT_LINE_ID;
2707:
2708: FOR r_req_line_rec IN l_req_line_csr(l_req_line_id) LOOP
2709: IF csm_util_pkg.is_palm_resource(r_req_line_rec.resource_id) THEN
2710: csm_csp_req_lines_event_pkg.csp_req_lines_mdirty_i(p_requirement_line_id=>l_req_line_id,

Line 2732: l_req_line_id csp_requirement_lines.requirement_line_id%TYPE;

2728: END CSP_REQ_LINES_POST_INS;
2729:
2730: PROCEDURE CSP_REQ_LINES_POST_UPD(x_return_status OUT NOCOPY varchar2)
2731: IS
2732: l_req_line_id csp_requirement_lines.requirement_line_id%TYPE;
2733: l_sqlerrno varchar2(20);
2734: l_sqlerrmsg varchar2(2000);
2735:
2736: CURSOR l_req_line_csr(p_req_line_id IN NUMBER ) IS

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

2748:
2749: CSM_UTIL_PKG.LOG('Entering CSM_WF_PKG.CSP_REQ_LINES_POST_UPD', 'CSM_WF_PKG.CSP_REQ_LINES_POST_UPD',
2750: FND_LOG.LEVEL_PROCEDURE );
2751:
2752: l_req_line_id := CSP_REQUIREMENT_LINES_PKG.user_hook_rec.REQUIREMENT_LINE_ID;
2753:
2754: FOR r_req_line_rec IN l_req_line_csr(l_req_line_id) LOOP
2755: csm_csp_req_lines_event_pkg.csp_req_lines_mdirty_u(p_requirement_line_id=>l_req_line_id,
2756: p_user_id=>r_req_line_rec.user_id);

Line 2773: l_req_line_id csp_requirement_lines.requirement_line_id%TYPE;

2769: END CSP_REQ_LINES_POST_UPD;
2770:
2771: PROCEDURE CSP_REQ_LINES_POST_DEL(x_return_status OUT NOCOPY varchar2)
2772: IS
2773: l_req_line_id csp_requirement_lines.requirement_line_id%TYPE;
2774: l_sqlerrno varchar2(20);
2775: l_sqlerrmsg varchar2(2000);
2776:
2777: CURSOR l_req_line_acc_csr(p_req_line_id IN NUMBER ) IS

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

2789:
2790: CSM_UTIL_PKG.LOG('Entering CSM_WF_PKG.CSP_REQ_LINES_POST_DEL', 'CSM_WF_PKG.CSP_REQ_LINES_POST_DEL',
2791: FND_LOG.LEVEL_PROCEDURE );
2792:
2793: l_req_line_id := CSP_REQUIREMENT_LINES_PKG.user_hook_rec.REQUIREMENT_LINE_ID;
2794:
2795: FOR r_req_line_acc_rec IN l_req_line_acc_csr(l_req_line_id) LOOP
2796: csm_csp_req_lines_event_pkg.csp_req_lines_mdirty_d(p_requirement_line_id=>l_req_line_id,
2797: p_user_id=>r_req_line_acc_rec.user_id);

Line 2814: l_req_line_id csp_requirement_lines.requirement_line_id%TYPE;

2810: END CSP_REQ_LINES_POST_DEL;
2811:
2812: PROCEDURE CSP_REQ_LINE_DETAILS_POST_INS(x_return_status OUT NOCOPY varchar2)
2813: IS
2814: l_req_line_id csp_requirement_lines.requirement_line_id%TYPE;
2815: l_req_line_detail_id csp_req_line_details.req_line_detail_id%TYPE;
2816: l_sqlerrno varchar2(20);
2817: l_sqlerrmsg varchar2(2000);
2818:

Line 2866: l_req_line_id csp_requirement_lines.requirement_line_id%TYPE;

2862: END CSP_REQ_LINE_DETAILS_POST_INS;
2863:
2864: PROCEDURE CSP_REQ_LINE_DETAILS_POST_UPD(x_return_status OUT NOCOPY varchar2)
2865: IS
2866: l_req_line_id csp_requirement_lines.requirement_line_id%TYPE;
2867: l_req_line_detail_id csp_req_line_details.req_line_detail_id%TYPE;
2868: l_sqlerrno varchar2(20);
2869: l_sqlerrmsg varchar2(2000);
2870:

Line 2919: l_req_line_id csp_requirement_lines.requirement_line_id%TYPE;

2915: END CSP_REQ_LINE_DETAILS_POST_UPD;
2916:
2917: PROCEDURE CSP_REQ_LINE_DETAILS_PRE_DEL(x_return_status OUT NOCOPY varchar2)
2918: IS
2919: l_req_line_id csp_requirement_lines.requirement_line_id%TYPE;
2920: l_req_line_detail_id csp_req_line_details.req_line_detail_id%TYPE;
2921: l_sqlerrno varchar2(20);
2922: l_sqlerrmsg varchar2(2000);
2923: