APPS.PO_HEADERS_DRAFT_PKG dependencies on PO_HEADERS_ALL

Line 471: FROM po_headers_all

467: tax_attribute_update_code, --
468: supplier_auth_enabled_flag, -- bug5022835
469: cat_admin_auth_enabled_flag, -- bug5022835
470: pay_when_paid -- E and C ER
471: FROM po_headers_all
472: WHERE po_header_id = p_po_header_id_tbl(i)
473: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
474: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
475:

Line 628: DELETE FROM po_headers_all PH

624:
625: -- bug5187544
626: -- Delete only lines that have not been rejected
627:
628: DELETE FROM po_headers_all PH
629: WHERE PH.po_header_id IN
630: ( SELECT PHD.po_header_id
631: FROM po_headers_draft_all PHD
632: WHERE PHD.draft_id = p_draft_id

Line 667: MERGE INTO po_headers_all PH

663: -- PH.cpa_reference
664: -- PH.style_id
665: -- PH.supplier_auth_enabled_flag
666: -- PH.cat_admin_auth_enabled_flag
667: MERGE INTO po_headers_all PH
668: USING (
669: SELECT
670: PHD.draft_id,
671: PHD.delete_flag,

Line 1370: FROM po_headers_all

1366: END IF;
1367:
1368: SELECT 1
1369: INTO l_dummy
1370: FROM po_headers_all
1371: WHERE po_header_id = p_po_header_id
1372: FOR UPDATE NOWAIT;
1373:
1374: IF (PO_LOG.d_proc) THEN