Search Results po_val_headers




Overview
Explore in AI Chat

Overview

PO_VAL_HEADERS is an Oracle EBS validation package in the APPS schema responsible for enforcing business rules on Purchase Order header data before records are committed to the database. It operates as a subordinate validation engine within the purchasing module, invoked by the higher-level PO_VALIDATIONS package to perform row-level and column-level integrity checks against both the PO_HEADERS_ALL table and its interface/GTL staging counterpart PO_HEADERS_GT. The package encapsulates header-specific validations covering pricing tolerances, agreement/contract dates, supplier status, currency rates, document numbering, and mandatory key references. Because validation logic is centralized here rather than duplicated in forms or concurrent programs, PO_VAL_HEADERS ensures consistent enforcement regardless of entry channel. It is registered as an OTHER-classified API package in ETRM for 12.2.2 and remains VALID in 12.1.1 environments.

Key Procedures and Functions

The package exposes 45 documented procedures and functions. The ETRM metadata names the following, grouped here by purpose:

Tables Accessed

Documented references (via APPS synonyms) include:

Usage Notes

PO_VAL_HEADERS is not intended for direct invocation by end users. It is called indirectly through APPS.PO_VALIDATIONS, its sole documented referrer, which itself is referenced by purchasing forms, the PO Approval workflow, and header import/interface concurrent programs. Custom PL/SQL that must validate purchase order headers should call PO_VALIDATIONS rather than PO_VAL_HEADERS directly, since the parent package orchestrates header, line, and line-location checks in sequence and consolidates results into PO_VALIDATION_RESULTS_TYPE using the PO_TBL_DATE, PO_TBL_NUMBER, PO_TBL_VARCHAR2000, and PO_TBL_VARCHAR30 collection types. Because behavior is governed by system parameters and financials setup, validations such as amount tolerances and supplier-hold warnings vary by operating unit configuration. In 12.1.1 and 12.2.2 the object is identical in classification, and any modification should be avoided in favor of wrapping or extending PO_VALIDATIONS, as EBS treats this package as proprietary internal validation logic.