APPS.AHL_OSP_ORDERS_PVT dependencies on PO_HEADERS_ALL

Line 790: SELECT 'x' FROM po_headers_all

786: p_osp_order_id IN NUMBER,
787: p_po_header_id IN NUMBER
788: )IS
789: CURSOR val_po_header_id_csr(p_po_header_id IN NUMBER,p_osp_order_id IN NUMBER) IS
790: SELECT 'x' FROM po_headers_all
791: WHERE po_header_id = p_po_header_id
792: AND reference_num = p_osp_order_id
793: AND interface_source_code = G_APP_NAME;
794: l_exist VARCHAR2(1);

Line 3343: SELECT 'x' FROM po_headers_all

3339: FUNCTION vendor_id_exist_in_PO( p_po_header_id IN NUMBER,
3340: p_vendor_id IN NUMBER
3341: ) RETURN BOOLEAN IS
3342: CURSOR vendor_id_csr(p_po_header_id IN NUMBER, p_vendor_id IN NUMBER) IS
3343: SELECT 'x' FROM po_headers_all
3344: WHERE po_header_id = p_po_header_id
3345: AND vendor_id = p_vendor_id;
3346: l_exist VARCHAR(1);
3347: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.vendor_id_exist_in_PO';

Line 3371: SELECT 'x' FROM po_headers_all

3367: FUNCTION vendor_site_id_exist_in_PO( p_po_header_id IN NUMBER,
3368: p_vendor_site_id IN NUMBER
3369: ) RETURN BOOLEAN IS
3370: CURSOR vendor_site_id_csr(p_po_header_id IN NUMBER, p_vendor_site_id IN NUMBER) IS
3371: SELECT 'x' FROM po_headers_all
3372: WHERE po_header_id = p_po_header_id
3373: AND vendor_site_id = p_vendor_site_id;
3374: l_exist VARCHAR(1);
3375: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.vendor_site_id_exist_in_PO';

Line 7189: po_headers_all po

7185: SELECT decode(osp.po_header_id, null, osp.vendor_id, po.vendor_id) vendor_id,
7186: decode(osp.po_header_id, null, osp.vendor_site_id, po.vendor_site_id) vendor_site_id --, vendor_contact_id
7187: INTO l_vendor_id, l_vendor_site_id --, l_vendor_contact_id
7188: FROM ahl_osp_orders_b osp,
7189: po_headers_all po
7190: WHERE osp.osp_order_id = p_osp_order_line_rec.osp_order_id
7191: AND osp.po_header_id = po.po_header_id(+);
7192: */
7193: --modified by mpothuku on 14-mar-2008 to fix the Bug 6885513