DBA Data[Home] [Help]

APPS.CSM_WF_PKG dependencies on CSP_REQUIREMENT_HEADERS

Line 2515: l_req_header_id csp_requirement_headers.requirement_header_id%TYPE;

2511: END CSP_SHIP_TO_ADDRESS_POST_UPD;
2512:
2513: PROCEDURE CSP_REQ_HEADERS_POST_INS(x_return_status OUT NOCOPY varchar2)
2514: IS
2515: l_req_header_id csp_requirement_headers.requirement_header_id%TYPE;
2516: l_sqlerrno varchar2(20);
2517: l_sqlerrmsg varchar2(2000);
2518:
2519: CURSOR l_req_hdr_csr(p_req_header_id IN NUMBER ) IS

Line 2522: FROM csp_requirement_headers hdr,

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

Line 2529: FROM csp_requirement_headers hdr,

2525: AND jtrs.resource_id = hdr.resource_id
2526: UNION
2527: SELECT ta.resource_id,
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

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

2545:
2546: CSM_UTIL_PKG.LOG('Entering CSM_WF_PKG.CSP_REQ_HEADERS_POST_INS', 'CSM_WF_PKG.CSP_REQ_HEADERS_POST_INS',
2547: FND_LOG.LEVEL_PROCEDURE );
2548:
2549: l_req_header_id := CSP_REQUIREMENT_HEADERS_PKG.user_hooks_rec.REQUIREMENT_HEADER_ID;
2550:
2551: FOR r_req_hdr_rec IN l_req_hdr_csr(l_req_header_id) LOOP
2552: IF csm_util_pkg.is_palm_resource(r_req_hdr_rec.resource_id) THEN
2553: csm_csp_req_headers_event_pkg.csp_req_headers_mdirty_i(p_requirement_header_id=>l_req_header_id,

Line 2575: l_req_header_id csp_requirement_headers.requirement_header_id%TYPE;

2571: END CSP_REQ_HEADERS_POST_INS;
2572:
2573: PROCEDURE CSP_REQ_HEADERS_POST_UPD(x_return_status OUT NOCOPY varchar2)
2574: IS
2575: l_req_header_id csp_requirement_headers.requirement_header_id%TYPE;
2576: l_sqlerrno varchar2(20);
2577: l_sqlerrmsg varchar2(2000);
2578:
2579: CURSOR l_req_hdr_csr(p_req_header_id IN NUMBER )

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

2592:
2593: CSM_UTIL_PKG.LOG('Entering CSM_WF_PKG.CSP_REQ_HEADERS_POST_UPD', 'CSM_WF_PKG.CSP_REQ_HEADERS_POST_UPD',
2594: FND_LOG.LEVEL_PROCEDURE );
2595:
2596: l_req_header_id := CSP_REQUIREMENT_HEADERS_PKG.user_hooks_rec.REQUIREMENT_HEADER_ID;
2597:
2598: FOR r_req_hdr_rec IN l_req_hdr_csr(l_req_header_id) LOOP
2599: csm_csp_req_headers_event_pkg.csp_req_headers_mdirty_u(p_requirement_header_id=>l_req_header_id,
2600: p_user_id=>r_req_hdr_rec.user_id);

Line 2617: l_req_header_id csp_requirement_headers.requirement_header_id%TYPE;

2613: END CSP_REQ_HEADERS_POST_UPD;
2614:
2615: PROCEDURE CSP_REQ_HEADERS_POST_DEL(x_return_status OUT NOCOPY varchar2)
2616: IS
2617: l_req_header_id csp_requirement_headers.requirement_header_id%TYPE;
2618: l_sqlerrno varchar2(20);
2619: l_sqlerrmsg varchar2(2000);
2620:
2621: CURSOR l_req_hdr_acc_csr(p_req_header_id IN NUMBER ) IS

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

2633:
2634: CSM_UTIL_PKG.LOG('Entering CSM_WF_PKG.CSP_REQ_HEADERS_POST_DEL', 'CSM_WF_PKG.CSP_REQ_HEADERS_POST_DEL',
2635: FND_LOG.LEVEL_PROCEDURE );
2636:
2637: l_req_header_id := CSP_REQUIREMENT_HEADERS_PKG.user_hooks_rec.REQUIREMENT_HEADER_ID;
2638:
2639: FOR r_req_hdr_acc_rec IN l_req_hdr_acc_csr(l_req_header_id) LOOP
2640: csm_csp_req_headers_event_pkg.csp_req_headers_mdirty_d(p_requirement_header_id=>l_req_header_id,
2641: p_user_id=>r_req_hdr_acc_rec.user_id);

Line 2666: FROM csp_requirement_headers hdr,

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

Line 2676: FROM csp_requirement_headers hdr,

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