Search Results po_req_document_update_pvt




Overview
Explore in AI Chat

Overview

APPS.PO_REQ_DOCUMENT_UPDATE_PVT is a private PL/SQL package within the Oracle E-Business Suite Purchasing application. It forms part of the infrastructure that supports the Oracle Purchasing requisition update flow, providing the low-level logic used to apply changes to requisition documents. In EBS release 12.1.1 and 12.2.2, the package operates exclusively within the APPS schema and is classified as a private (PVT) API, meaning it is not intended as a public integration interface. Its role is to perform the database-level updates against requisition header, line, and distribution records that result from a user or process modifying an existing requisition. The package depends on the record type PO_REQ_CHANGES_REC_TYPE, which is the structure used to carry change information into the update logic. This relationship is significant because developers searching for "po_req_changes_rec_type" often arrive at this package, since it consumes that record type to determine what requisition attributes must be modified.

Key Procedures and Functions

The ETRM metadata documents a single procedure within this package:

  • UPDATE_REQUISITION — The core routine responsible for executing the update of a requisition document. It accepts requisition change data and applies the necessary modifications to the underlying requisition tables. The procedure encapsulates the validation and persistence logic required to keep requisition records consistent after a change request. No public parameter list is documented in the metadata, and parameter details should be confirmed directly against the package specification in the target environment.

Tables Accessed

The package references the following tables through APPS synonyms:

  • PO_REQUISITION_LINES — Stores the requisition line detail; updated to reflect changed quantity, price, item, or other line attributes.
  • PO_REQ_DISTRIBUTIONS — Holds the distribution accounting and charge information for requisition lines; updated when distributions are modified.
  • PO_LINE_TYPES — Provides line type validation and reference information used during update processing.
  • PO_SESSION_GT and PO_SESSION_GT_S — Global temporary tables used to stage session-level data during the update operation.
  • DUAL — Used for single-row lookups and PL/SQL assignments.
  • PLITBLM — A standard Oracle-supplied table commonly used for PL/SQL index-by table handling.

Usage Notes

PO_REQ_DOCUMENT_UPDATE_PVT is a private package and should not be called directly from custom code. It is referenced by the public group package PO_REQ_DOCUMENT_UPDATE_GRP, which exposes the supported interface for requisition document updates. In practice, the package is invoked indirectly through the Oracle Purchasing forms and through the group package when a requisition is modified, including through the core Requisition form and related change-order flows. Because the package is classified as PVT, Oracle does not guarantee backward compatibility for its signature across patches or upgrades. Developers who need to programmatically update requisitions should use the documented public APIs in PO_REQ_DOCUMENT_UPDATE_GRP or the requisition import interface rather than calling UPDATE_REQUISITION directly. When referencing PO_REQ_CHANGES_REC_TYPE, the record type is consumed internally by this package as the vehicle for passing change metadata into the update logic, so customizations that construct that record type must populate it according to the current package specification.