[Home] [Help]
1565: WHERE PO_REQ_LINE_ID IS NULL
1566: AND OSP_ORDER_ID = p_osp_order_id;
1567:
1568: CURSOR l_get_po_req_line_csr(p_osp_order_line_id IN NUMBER, p_po_req_header_id IN NUMBER) IS
1569: SELECT REQUISITION_LINE_ID FROM PO_REQUISITION_LINES_ALL
1570: WHERE REFERENCE_NUM = p_osp_order_line_id AND
1571: REQUISITION_HEADER_ID = p_po_req_header_id;
1572:
1573: CURSOR l_get_request_id_csr(p_osp_order_id IN NUMBER) IS
1577: CURSOR check_req_completeness_csr(c_po_req_header_id IN NUMBER) IS
1578: select 1 from dual where
1579: (select count(*) from AHL_OSP_ORDER_LINES where OSP_ORDER_ID = p_osp_order_id) =
1580: (select count(*) from
1581: PO_REQUISITION_LINES_ALL REQL, AHL_OSP_ORDER_LINES OSPL
1582: where OSPL.OSP_ORDER_ID = p_osp_order_id
1583: AND REQL.REFERENCE_NUM = OSPL.osp_order_line_id
1584: AND REQL.REQUISITION_HEADER_ID = c_po_req_header_id);
1585:
1996: OL.OSP_ORDER_LINE_ID,
1997: REQH.INTERFACE_SOURCE_LINE_ID,
1998: OL.OBJECT_VERSION_NUMBER,
1999: OSP.OBJECT_VERSION_NUMBER
2000: FROM PO_REQUISITION_LINES_ALL REQL,
2001: PO_REQUISITION_HEADERS_ALL REQH,
2002: AHL_OSP_ORDER_LINES OL,
2003: AHL_OSP_ORDERS_B OSP
2004: WHERE nvl(REQL.CANCEL_FLAG,'N') = 'Y' AND -- Canceled Req Line
2159: NVL(OL.STATUS_CODE, ' ') <> G_OL_REQ_DELETED_STATUS AND -- Not yet updated
2160: OSP.OSP_ORDER_ID = OL.OSP_ORDER_ID AND
2161: -- Added by jaramana on April 7, 2008 for bug 6609988
2162: OSP.OPERATING_UNIT_ID = MO_GLOBAL.get_current_org_id() AND
2163: NOT EXISTS (SELECT REQUISITION_LINE_ID FROM PO_REQUISITION_LINES_ALL WHERE REQUISITION_LINE_ID = OL.PO_REQ_LINE_ID) -- Req Line Deleted
2164: ORDER BY OL.OSP_ORDER_ID; -- One OSP Order at a time
2165:
2166: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Handle_Deleted_Req_Lines';
2167: l_osp_order_id NUMBER := -1;