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_HEADERS

Line 2523: l_req_header_id csp_requirement_headers.requirement_header_id%TYPE;

2519: END CSP_SHIP_TO_ADDRESS_POST_UPD;
2520:
2521: PROCEDURE CSP_REQ_HEADERS_POST_INS(x_return_status OUT NOCOPY varchar2)
2522: IS
2523: l_req_header_id csp_requirement_headers.requirement_header_id%TYPE;
2524: l_sqlerrno varchar2(20);
2525: l_sqlerrmsg varchar2(2000);
2526:
2527: CURSOR l_req_hdr_csr(p_req_header_id IN NUMBER ) IS

Line 2530: FROM csp_requirement_headers hdr,

2526:
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

Line 2537: FROM csp_requirement_headers hdr,

2533: AND jtrs.resource_id = hdr.resource_id
2534: UNION
2535: SELECT ta.resource_id,
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

Line 2557: l_req_header_id := CSP_REQUIREMENT_HEADERS_PKG.user_hooks_rec.REQUIREMENT_HEADER_ID;

2553:
2554: CSM_UTIL_PKG.LOG('Entering CSM_WF_PKG.CSP_REQ_HEADERS_POST_INS', 'CSM_WF_PKG.CSP_REQ_HEADERS_POST_INS',
2555: FND_LOG.LEVEL_PROCEDURE );
2556:
2557: l_req_header_id := CSP_REQUIREMENT_HEADERS_PKG.user_hooks_rec.REQUIREMENT_HEADER_ID;
2558:
2559: FOR r_req_hdr_rec IN l_req_hdr_csr(l_req_header_id) LOOP
2560: IF csm_util_pkg.is_palm_resource(r_req_hdr_rec.resource_id) THEN
2561: csm_csp_req_headers_event_pkg.csp_req_headers_mdirty_i(p_requirement_header_id=>l_req_header_id,

Line 2583: l_req_header_id csp_requirement_headers.requirement_header_id%TYPE;

2579: END CSP_REQ_HEADERS_POST_INS;
2580:
2581: PROCEDURE CSP_REQ_HEADERS_POST_UPD(x_return_status OUT NOCOPY varchar2)
2582: IS
2583: l_req_header_id csp_requirement_headers.requirement_header_id%TYPE;
2584: l_sqlerrno varchar2(20);
2585: l_sqlerrmsg varchar2(2000);
2586:
2587: CURSOR l_req_hdr_csr(p_req_header_id IN NUMBER )

Line 2604: l_req_header_id := CSP_REQUIREMENT_HEADERS_PKG.user_hooks_rec.REQUIREMENT_HEADER_ID;

2600:
2601: CSM_UTIL_PKG.LOG('Entering CSM_WF_PKG.CSP_REQ_HEADERS_POST_UPD', 'CSM_WF_PKG.CSP_REQ_HEADERS_POST_UPD',
2602: FND_LOG.LEVEL_PROCEDURE );
2603:
2604: l_req_header_id := CSP_REQUIREMENT_HEADERS_PKG.user_hooks_rec.REQUIREMENT_HEADER_ID;
2605:
2606: FOR r_req_hdr_rec IN l_req_hdr_csr(l_req_header_id) LOOP
2607: csm_csp_req_headers_event_pkg.csp_req_headers_mdirty_u(p_requirement_header_id=>l_req_header_id,
2608: p_user_id=>r_req_hdr_rec.user_id);

Line 2625: l_req_header_id csp_requirement_headers.requirement_header_id%TYPE;

2621: END CSP_REQ_HEADERS_POST_UPD;
2622:
2623: PROCEDURE CSP_REQ_HEADERS_POST_DEL(x_return_status OUT NOCOPY varchar2)
2624: IS
2625: l_req_header_id csp_requirement_headers.requirement_header_id%TYPE;
2626: l_sqlerrno varchar2(20);
2627: l_sqlerrmsg varchar2(2000);
2628:
2629: CURSOR l_req_hdr_acc_csr(p_req_header_id IN NUMBER ) IS

Line 2645: l_req_header_id := CSP_REQUIREMENT_HEADERS_PKG.user_hooks_rec.REQUIREMENT_HEADER_ID;

2641:
2642: CSM_UTIL_PKG.LOG('Entering CSM_WF_PKG.CSP_REQ_HEADERS_POST_DEL', 'CSM_WF_PKG.CSP_REQ_HEADERS_POST_DEL',
2643: FND_LOG.LEVEL_PROCEDURE );
2644:
2645: l_req_header_id := CSP_REQUIREMENT_HEADERS_PKG.user_hooks_rec.REQUIREMENT_HEADER_ID;
2646:
2647: FOR r_req_hdr_acc_rec IN l_req_hdr_acc_csr(l_req_header_id) LOOP
2648: csm_csp_req_headers_event_pkg.csp_req_headers_mdirty_d(p_requirement_header_id=>l_req_header_id,
2649: p_user_id=>r_req_hdr_acc_rec.user_id);

Line 2674: FROM csp_requirement_headers hdr,

2670: CURSOR l_req_line_csr(p_req_line_id IN NUMBER ) IS
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

Line 2684: FROM csp_requirement_headers hdr,

2680: UNION
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