Search Results po_standard_purchase_order




Overview
Explore in AI Chat

Overview

PO_INVOICE_HOLD_CHECK is a public PL/SQL package owned by the APPS schema within Oracle E-Business Suite. Its documented display name is "PO Payment Hold Check," and it is classified under the business entity PO_STANDARD_PURCHASE_ORDER. The package exists to supply information about the Pay When Paid term associated with a purchase order so that the caller can determine whether related invoices should be placed on hold. In practice, this package is a supporting utility called during invoice validation, allowing the Payables and Purchasing integration to enforce supplier payment terms that depend on the settlement status of the referenced purchase order.

Key Procedures and Functions

The package exposes three documented procedures. It is important to note that the ETRM metadata documents the names and purposes of these procedures but does not provide complete parameter lists for all of them; only the PAY_WHEN_PAID signature is fully available in the source excerpt.

  • PAY_WHEN_PAID — Determines whether the Pay When Paid term on a given purchase order is set to "Yes." It accepts the API version, the purchase order header identifier against which the invoice is being validated, and the invoice identifier. It returns the standard API return status, message count, and message data, together with an in-out flag (X_PAY_WHEN_PAID) that returns 'Y' when Pay When Paid is enabled on the PO and 'N' otherwise. This flag is the signal used by the caller to decide whether the related invoice should be held.
  • DELIVERABLE_OVERDUE_CHECK — Evaluates whether an associated deliverable is overdue, providing the caller with the information necessary to determine whether a hold condition applies based on deliverable timeliness.
  • DELIVERABLE_HOLD_CONTROL — Manages the hold logic tied to deliverables, determining whether a deliverable-related hold should be applied or released for the invoice under consideration.

Tables Accessed

The package reads from three documented tables through APPS synonyms:

  • PO_HEADERS_ALL — The base purchase order header table. It is queried to retrieve the Pay When Paid attribute and other header-level terms for the purchase order referenced by P_PO_HEADER_ID.
  • PO_HEADERS_DRAFT_ALL — The draft version of purchase order headers, consulted to account for changes made to the PO that may not yet be committed to the base table.
  • PO_DOC_STYLE_HEADERS — The document style header table, used to resolve the document style associated with the purchase order, which influences the applicable terms and hold behavior.

Usage Notes

PO_INVOICE_HOLD_CHECK is referenced by one other package, indicating that it is invoked programmatically rather than directly by end users. Typical invocation occurs during invoice validation, when the Payables side needs to determine whether a PO-linked invoice should be held because the purchase order carries a Pay When Paid term or an overdue deliverable. The procedures follow standard Oracle API conventions: callers must pass a valid p_api_version, a purchase order header identifier, and an invoice identifier, and must inspect x_return_status for FND_API.G_RET_STS_SUCCESS, G_RET_STS_ERROR, or G_RET_STS_UNEXP_ERROR before consuming the output values. Custom code that calls this package should treat it as a public API and avoid direct dependency on its internal query logic. Because the metadata documents only three procedures and little detail on the deliverable-related routines, developers extending this functionality should validate parameter signatures against the specific release of Oracle EBS 12.1.1 or 12.2.2 in use.