Search Results po_req_document_checks_pvt




Overview
Explore in AI Chat

Overview

APPS.PO_REQ_DOCUMENT_CHECKS_PVT is a private PL/SQL package within the Oracle E-Business Suite Purchasing (PO) module, classified as a PVT (private) API. It provides the internal validation engine responsible for evaluating the document status of requisitions during the purchasing workflow. In Oracle EBS 12.1.1 and 12.2.2, this package supports encumbrance processing and requisition document state transitions by verifying whether requisition documents are eligible for further processing based on their current status. The package is not intended for direct customer invocation; it functions as a supporting utility invoked by public-facing packages such as PO_REQ_DOCUMENT_CHECKS_GRP and PO_REQ_DOCUMENT_UPDATE_PVT.

Key Procedures and Functions

The ETRM metadata documents a single procedure or function for this package:

  • REQ_STATUS_CHECK — Evaluates the status of a requisition document to determine whether it satisfies the conditions required for downstream processing. This check is central to ensuring that requisitions proceed only when in an appropriate state, preventing invalid transactions from entering encumbrance or update workflows.

No additional procedures or functions are documented in the ETRM metadata for this package. Parameter lists are not reproduced here, as the ETRM excerpt does not enumerate them. Developers requiring signature-level detail should reference the PL/SQL source via the EBS dependency browser.

Tables Accessed

The package operates against the following base tables through APPS synonyms:

  • PO_REQUISITION_HEADERS — Stores the parent requisition document records; the primary source of the document status being evaluated.
  • PO_REQUISITION_LINES — Contains requisition line details relevant to line-level status checks.
  • PO_HEADERS_GT — A global temporary table used to stage header context during validation processing.
  • PO_SESSION_GT — A session-scoped temporary table supporting runtime context for the check operation.
  • DUAL — Used for single-row evaluations and scalar computations.
  • PLITBLM — The PL/SQL table-to-column conversion utility used for set-based operations against ID lists.

These accesses are read-oriented in support of the status-check logic, with temporary tables holding intermediate state rather than persisting transactional data.

Usage Notes

PO_REQ_DOCUMENT_CHECKS_PVT is a private package and should not be invoked directly by custom code. The ETRM metadata confirms it is referenced by four packages within the APPS schema: PO_ENCUMBRANCE_PREPROCESSING, PO_REQ_DOCUMENT_CHECKS_GRP, PO_REQ_DOCUMENT_UPDATE_PVT, and recursively by itself. PO_REQ_DOCUMENT_CHECKS_GRP serves as the public wrapper layer, exposing the private logic to callers. The package is typically executed as part of concurrent encumbrance pre-processing and requisition update workflows, either during form-driven requisition actions or through concurrent program execution. The package depends on PO_STATUS_REC_TYPE, PO_TBL_NUMBER, and the SYS.STANDARD library. Because it relies on global temporary tables such as PO_SESSION_GT and PO_HEADERS_GT, invocation requires an active EBS session with the appropriate FND_GLOBAL context initialized. Customizations should target the public GRP-layer package rather than this private implementation, and any extension should respect the documented dependency chain to avoid breaking encumbrance pre-processing and requisition update logic across P2P flows in release 12.1.1 and 12.2.2.