APPS.PO_HEADERS_DRAFT_PKG dependencies on PO_HEADERS_ALL

Line 568: FROM po_headers_all

564: enable_all_sites, --ER 9824167
565: clm_contract_finance_code, -- CLM Phase 4
566: clm_special_contract_type,
567: clm_payment_instr_code -- CLM Phase 4
568: FROM po_headers_all
569: WHERE po_header_id = p_po_header_id_tbl(i)
570: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
571: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
572:

Line 726: DELETE FROM po_headers_all PH

722:
723: -- bug5187544
724: -- Delete only lines that have not been rejected
725:
726: DELETE FROM po_headers_all PH
727: WHERE PH.po_header_id IN
728: ( SELECT PHD.po_header_id
729: FROM po_headers_draft_all PHD
730: WHERE PHD.draft_id = p_draft_id

Line 772: MERGE INTO po_headers_all PH

768: -- PH.supplier_auth_enabled_flag
769: -- PH.cat_admin_auth_enabled_flag
770: -- PH.uda_template_id,
771: -- PH.uda_template_date
772: MERGE INTO po_headers_all PH
773: USING (
774: SELECT
775: PHD.draft_id,
776: PHD.delete_flag,

Line 1640: FROM po_headers_all

1636: END IF;
1637:
1638: SELECT 1
1639: INTO l_dummy
1640: FROM po_headers_all
1641: WHERE po_header_id = p_po_header_id
1642: FOR UPDATE NOWAIT;
1643:
1644: IF (PO_LOG.d_proc) THEN