Search Results po_pdoi_move_to_draft_tabs_pvt




Overview
Explore in AI Chat

Overview

PO_PDOI_MOVE_TO_DRAFT_TABS_PVT is an internal Oracle E-Business Suite PL/SQL package owned by the APPS schema. Its name identifies it as a private (PVT) member of the Purchasing Document Open Interface (PDOI) family. The package performs the staging step that migrates validated purchasing document data from the PDOI interface tables into the corresponding "draft" tables that back the Purchasing, Negotiation, and iProcurement authoring user interfaces.

In the Oracle EBS 12.1.1 and 12.2.2 architectures, PDOI is the batch ingestion path for purchase orders, blanket agreements, contracts, quotations, and releases. When suppliers, EDI feeds, legacy systems, or external integrations submit documents through the interface tables, PO_PDOI_MAINPROC_PVT orchestrates validation and processing. The MOVE_TO_DRAFT_TABS_PVT package occupies the point in that flow where successfully validated rows are transferred into the draft model so that a user can open the document, review it, and complete the submission. It is not a public API and is not intended to be called by customer extensions.

Key Procedures and Functions

The package exposes eight documented procedures covering the principal document entities and their child records:

  • INSERT_HEADERS — moves validated header-level document information from the interface area into the draft header structures.
  • INSERT_LINES — creates draft line records corresponding to the validated interface lines.
  • UPDATE_LINES — applies corrections or refinements to draft lines already created, reconciling values that changed during validation.
  • INSERT_LINE_LOCS — populates draft line location (shipment) records for the affected lines.
  • INSERT_DISTS — creates draft distribution records associated with the line locations.
  • INSERT_PRICE_DIFFS — handles price differential records that adjust line pricing in the draft document.
  • MERGE_ATTR_VALUES — consolidates attribute values collected through the attribute value interface into the draft attribute value tables.
  • MERGE_ATTR_VALUES_TLP — the translated/TP (TLP) counterpart of the attribute merge, applying multilingual attribute definitions and values.

Each procedure operates strictly against draft-model structures, which is why the naming convention is "MOVE_TO_DRAFT_TABS".

Tables Accessed

The package writes into draft and interface tables and reads from setup and interface sources through APPS synonyms. Draft targets include PO_DISTRIBUTIONS_DRAFT_ALL, PO_GA_ORG_ASSIGN_DRAFT, PO_ATTRIBUTE_VALUES_DRAFT, and PO_ATTRIBUTE_VALUES_TLP_DRAFT. Source and staging tables include PO_DISTRIBUTIONS_INTERFACE, PO_ATTR_VALUES_INTERFACE, and PO_ATTR_VALUES_TLP_INTERFACE. The attribute value base and translation tables, PO_ATTRIBUTE_VALUES, PO_ATTRIBUTE_VALUES_S, PO_ATTRIBUTE_VALUES_TLP, and PO_ATTRIBUTE_VALUES_TLP_S, are read to resolve the destination of merged attribute rows. Setup lookups include FND_CURRENCIES for currency validation and MTL_SYSTEM_ITEMS for item-master context, while PO_GA_ORG_ASSIGNMENTS_S supplies the operating-unit assignment definition. PO_PDOI_TYPES provides the record and collection types shared across the PDOI suite, PO_TBL_NUMBER provides numeric table type support, and DBMS_SQL is used for dynamic SQL execution.

Usage Notes

PO_PDOI_MOVE_TO_DRAFT_TABS_PVT is invoked internally by PO_PDOI_MAINPROC_PVT as part of the standard PDOI execution path. It is not exposed through a form or a standalone concurrent program; the visible entry points remain the PDOI concurrent programs such as the Purchasing Document Open Interface import. The package is also referenced by itself, indicating internal recursive or iterative calls during processing. Because the object is classified as PVT, Oracle does not guarantee its signature between releases, so customizations should invoke only the documented public APIs and the supported PDOI import concurrent programs. Correct behavior depends on the interface tables being populated in the documented sequence and on validation having completed before the draft move executes.