Search Results po_document_control_pub




Overview
Explore in AI Chat

Overview

PO_DOCUMENT_CONTROL_PUB is a public PL/SQL package in the APPS schema that governs the document control behaviour of Oracle Purchasing documents. Its central responsibility is to evaluate and enforce document control rules — such as those relating to document types, document numbering, approval and status handling — against purchasing documents held in the core Purchasing tables. The package exposes a public API classification, meaning it is intended for invocation by other Oracle E-Business Suite modules, partner integrations, and customer extensions rather than being reserved for internal use only. In Oracle EBS 12.1.1 and 12.2.2 the package is reported as VALID in the ETRM repository, confirming it is a supported, compiled database object within the APPS schema.

Key Procedures and Functions

The documented interface consists of a single public program unit, CONTROL_DOCUMENT. Consistent with the package name, this procedure applies document control logic to a purchasing document, typically determining whether the document satisfies the control rules defined for its document type and, where appropriate, updating or returning the resulting control state. Because the ETRM metadata records only the program name and no parameter signature, the exact argument list should be confirmed against the deployed package specification for the target release. No additional procedures or functions are documented for this package.

Tables Accessed

The package resolves its data access through APPS synonyms over the following documented tables:

  • PO_HEADERS / PO_HEADERS_ALL — the purchasing document header, supplying document type, status, and control attributes relevant to the document being evaluated.
  • PO_LINES — line-level detail used when control logic must consider the contents of the document.
  • PO_RELEASES_ALL — release and shipment information for blanket and planned purchase orders subject to the same control framework.
  • PO_DOCUMENT_TYPES — the definition of document types that drives which control rules apply.
  • PLITBLM — an Oracle Applications internal PL/SQL table type used for in-memory collection handling within the package logic.

Usage Notes

PO_DOCUMENT_CONTROL_PUB is referenced by other APPS packages, including PO_INBOUND_XML and CSP_REPAIR_PO_PVT, indicating that document control is applied during inbound XML processing of purchasing documents and during service/repair flows that manipulate purchase orders. It is therefore normally invoked indirectly by Purchasing forms, concurrent programs, and inbound integration processes rather than being called directly by end users. Custom code that needs to apply the same document control validation should call CONTROL_DOCUMENT rather than replicating the underlying rules, so that future changes to document control configuration remain consistent. As with all public Purchasing APIs, invocation should occur within a properly initialised session, with standard EBS error handling and rollback semantics applied, and the package specification should be reviewed for the exact parameter list and return behaviour on the specific release in use.