Search Results po_status_rec_type




Overview
Explore in AI Chat

Overview

APPS.PO_REQ_DOCUMENT_CHECKS_GRP is a public API group package within the Oracle E-Business Suite Purchasing (PO) module. Its source header indicates it has been part of the codebase since at least 2003, and it functions as the externally callable layer over the internal private package PO_REQ_DOCUMENT_CHECKS_PVT. The package exists to provide callers with a supported entry point for validating and resolving the status of requisition documents — requisition headers, requisition lines, and requisition distributions — during transactional processing. The AUTHID CURRENT_USER declaration means the package executes with the privileges of the invoking user rather than as the owning APPS schema, which is typical of EBS public APIs where fine-grained access and security group enforcement must apply.

The package sits in the requisition and purchasing document flow, where status checks determine whether a document is open, closed, cancelled, or otherwise in a state that permits further action. Such checks are essential before performing approval, modification, cancellation, or receipt-related operations.

Key Procedures and Functions

The documented package exposes two overloaded variants of a single procedure, REQ_STATUS_CHECK:

  • REQ_STATUS_CHECK (PL/SQL table overload) — Accepts requisition identifiers in bulk form, with header, line, and distribution identifiers passed as PO_TBL_NUMBER collections. This overload supports set-based or array-driven validation, allowing a caller to process multiple requisition documents in a single invocation.
  • REQ_STATUS_CHECK (scalar identifier overload) — Accepts single numeric requisition header, line, and distribution identifiers, with line and distribution defaulting to NULL. This is the conventional single-record form used when a caller needs to validate one requisition document at a time.

Both variants share a common calling convention characteristic of EBS PL/SQL APIs: an API version parameter, a mode parameter, and an optional lock flag defaulting to 'N'. They return the requisition status through an OUT parameter of type PO_STATUS_REC_TYPE — the type the user searched for as "po_status_rec_type" — together with the standard EBS API return status, message count, and message data parameters. The overload for bulk identifiers was introduced in the DropShip FPJ project, indicating the procedure was extended to support drop-shipment requisition flows. Detailed implementation comments reside in the body of PO_REQ_DOCUMENT_CHECKS_PVT.

Tables Accessed

Per the documented metadata, the package references the table PLITBLM via APPS synonyms. PLITBLM is one of the EBS interface/translation tables associated with Purchasing document processing, and its presence reflects the package's role in reading or validating requisition-related data during status determination. The primary requisition data itself is resolved within the private package layer.

Usage Notes

This group package is typically invoked by Oracle Purchasing forms and by other EBS packages that need to confirm requisition document status before proceeding with a transaction. The metadata records that it is referenced by one other package, confirming its role as a dependency rather than an end-user entry point. Custom code integrating with EBS requisition processing should call PO_REQ_DOCUMENT_CHECKS_GRP rather than the underlying _PVT package, as the GRP layer constitutes the documented, supported interface. Callers must supply a valid API version, select the appropriate overload for their data volume, and inspect x_return_status and the standard message parameters to detect errors. The x_req_status_rec OUT parameter of type PO_STATUS_REC_TYPE returns the resolved status record for use in downstream logic.