APPS.AHL_OSP_ORDERS_PVT dependencies on PO_HEADERS_ALL

Line 811: SELECT 'x' FROM po_headers_all

807: p_osp_order_id IN NUMBER,
808: p_po_header_id IN NUMBER
809: )IS
810: CURSOR val_po_header_id_csr(p_po_header_id IN NUMBER,p_osp_order_id IN NUMBER) IS
811: SELECT 'x' FROM po_headers_all
812: WHERE po_header_id = p_po_header_id
813: AND reference_num = p_osp_order_id
814: AND interface_source_code = G_APP_NAME;
815: l_exist VARCHAR2(1);

Line 3381: SELECT 'x' FROM po_headers_all

3377: FUNCTION vendor_id_exist_in_PO( p_po_header_id IN NUMBER,
3378: p_vendor_id IN NUMBER
3379: ) RETURN BOOLEAN IS
3380: CURSOR vendor_id_csr(p_po_header_id IN NUMBER, p_vendor_id IN NUMBER) IS
3381: SELECT 'x' FROM po_headers_all
3382: WHERE po_header_id = p_po_header_id
3383: AND vendor_id = p_vendor_id;
3384: l_exist VARCHAR(1);
3385: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.vendor_id_exist_in_PO';

Line 3409: SELECT 'x' FROM po_headers_all

3405: FUNCTION vendor_site_id_exist_in_PO( p_po_header_id IN NUMBER,
3406: p_vendor_site_id IN NUMBER
3407: ) RETURN BOOLEAN IS
3408: CURSOR vendor_site_id_csr(p_po_header_id IN NUMBER, p_vendor_site_id IN NUMBER) IS
3409: SELECT 'x' FROM po_headers_all
3410: WHERE po_header_id = p_po_header_id
3411: AND vendor_site_id = p_vendor_site_id;
3412: l_exist VARCHAR(1);
3413: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.vendor_site_id_exist_in_PO';

Line 7638: po_headers_all po

7634: SELECT decode(osp.po_header_id, null, osp.vendor_id, po.vendor_id) vendor_id,
7635: decode(osp.po_header_id, null, osp.vendor_site_id, po.vendor_site_id) vendor_site_id --, vendor_contact_id
7636: INTO l_vendor_id, l_vendor_site_id --, l_vendor_contact_id
7637: FROM ahl_osp_orders_b osp,
7638: po_headers_all po
7639: WHERE osp.osp_order_id = p_osp_order_line_rec.osp_order_id
7640: AND osp.po_header_id = po.po_header_id(+);
7641: */
7642: --modified by mpothuku on 14-mar-2008 to fix the Bug 6885513