Search Results po_req_document_checks_grp




Overview
Explore in AI Chat

Overview

PO_REQ_DOCUMENT_CHECKS_GRP is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema and classified as a Group (GRP) API. Its business purpose is to enforce document-level validation rules against purchasing requisitions before those requisitions are permitted to progress through their approval and processing lifecycle. The package is part of the broader PO_REQ_DOCUMENT_CHECKS family, which separates public group entry points from the private implementation logic housed in PO_REQ_DOCUMENT_CHECKS_PVT. The group package therefore acts as the externally callable façade through which forms, workflows, and custom code request requisition document checks.

A significant portion of the documented code relates to status checking. The header comment in the source identifies the procedures as "new procedures for status check added in DropShip FPJ project," indicating that the package was extended to support drop-shipment requisition flows introduced by that project. The package depends on the global profile option AFLOG_ENABLED (FND_PROFILE.VALUE) to control debug logging, with the package name constant G_PKG_NAME and a log prefix of po.plsql.PO_REQ_DOCUMENT_CHECKS_GRP.

Key Procedures and Functions

The ETRM metadata documents two procedures or functions in total.

  • REQ_STATUS_CHECK — The group entry point invoked when a caller needs to validate requisition status transitions or status-related document conditions. It delegates the substantive validation logic to PO_REQ_DOCUMENT_CHECKS_PVT.req_status_check, as noted in the source comments. This is the procedure most closely associated with the user's search term "req_status_check."
  • VALIDATE_STATUS_CHECK_INPUTS — An internal helper called by the req_status_check group procedure. It performs input validation on the parameters supplied to the status check, including verifying that the ID input tables p_req_header_id and p_req_line_id are of the same size, and that each entity supplies the required Requisition Header ID. The header is mandatory while the line is optional. The procedure accepts an API version, header/line/distribution ID tables, a mode, an optional lock flag defaulting to 'N', and returns a status record plus standard return status and message outputs. It initializes null tables to a dummy table of null values.

Tables Accessed

The documented table referenced through APPS synonyms is PLITBLM. In Oracle EBS this is a standard PL/SQL table-based structure used for list processing and message or ID collection. The package's work is primarily performed against the requisition header, line, and distribution identifier tables passed as parameters (PO_TBL_NUMBER collections) rather than through direct DML on requisition base tables, which is typical of validation-only group APIs. Reading and writing of core PO tables is performed inside the private PVT package, keeping the group layer thin.

Usage Notes

This package is normally invoked indirectly by Oracle Purchasing forms, requisition approval workflows, and Oracle iProcurement flows that must confirm a requisition's status and document readiness before it moves to the next step. Because it is a Group API, it is also the correct integration point for custom PL/SQL code that needs the same validation semantics as the standard application. Release upgrades between 12.1.1 and 12.2.2 preserve the API signature; the package is referenced by one other package, and callers should always respect the return status and message-count conventions. Direct calls to the private PVT package should be avoided, as the group layer is the supported entry point.