APPS.AHL_OSP_PO_REQ_PVT dependencies on PO_REQUISITION_HEADERS_ALL

Line 1557: FROM PO_REQUISITION_HEADERS_ALL POREQ, AHL_OSP_ORDERS_B OSP

1553: x_po_req_header_id OUT NOCOPY NUMBER) IS
1554:
1555: CURSOR l_get_po_req_hdr_csr(p_osp_order_id IN NUMBER) IS
1556: SELECT POREQ.REQUISITION_HEADER_ID
1557: FROM PO_REQUISITION_HEADERS_ALL POREQ, AHL_OSP_ORDERS_B OSP
1558: WHERE POREQ.INTERFACE_SOURCE_LINE_ID = p_osp_order_id AND
1559: OSP.OSP_ORDER_ID = p_osp_order_id AND
1560: OSP.OPERATING_UNIT_ID = POREQ.ORG_ID AND
1561: POREQ.INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME;

Line 1873: NOT EXISTS (SELECT 1 FROM po_requisition_headers_all where requisition_header_id = osp.po_req_header_id);

1869: WHERE osp.status_code = G_OSP_REQ_CREATED_STATUS AND
1870: osp.order_type_code in ('SERVICE', 'EXCHANGE') AND
1871: -- Added by jaramana on April 7, 2008 for bug 6609988
1872: osp.operating_unit_id = MO_GLOBAL.get_current_org_id() AND
1873: NOT EXISTS (SELECT 1 FROM po_requisition_headers_all where requisition_header_id = osp.po_req_header_id);
1874:
1875: CURSOR get_osp_line_dtls_csr(c_osp_order_id IN NUMBER) IS
1876: SELECT ospl.osp_order_id,
1877: ospl.osp_order_line_id,

Line 2001: PO_REQUISITION_HEADERS_ALL REQH,

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
2005: REQL.REQUISITION_HEADER_ID = REQH.REQUISITION_HEADER_ID AND

Line 2300: FROM po_requisition_headers_all poh

2296: FUNCTION Is_PO_Req_Closed(p_po_req_header_id IN NUMBER) RETURN VARCHAR2 IS
2297:
2298: CURSOR l_is_req_closed_csr(p_po_req_header_id IN NUMBER) IS
2299: SELECT 1
2300: FROM po_requisition_headers_all poh
2301: WHERE poh.requisition_header_id = p_po_req_header_id
2302: AND (nvl(poh.closed_code, 'OPEN') IN ('CANCELLED', 'CLOSED','FINALLY CLOSED', 'REJECTED', 'RETURNED')
2303: OR
2304: nvl(poh.authorization_status, 'INCOMPLETE') = 'CANCELLED'

Line 2310: FROM po_requisition_headers_all poh

2306:
2307: --Verify that the passed PO_REQ_HEADER_ID is valid
2308: CURSOR l_val_req_hdr_id_csr(p_po_req_header_id IN NUMBER) IS
2309: SELECT poh.requisition_header_id
2310: FROM po_requisition_headers_all poh
2311: WHERE poh.requisition_header_id = p_po_req_header_id;
2312:
2313:
2314: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Is_PO_Req_Closed';