Search Results po_inv_integration_grp




Overview
Explore in AI Chat

Overview

PO_INV_INTEGRATION_GRP is a packaged PL/SQL group (classified as GRP in the ETRM repository) owned by the APPS schema in Oracle E-Business Suite. Its name and header comment ("$Header: PO_INV_INTEGRATION_GRP.pls 120.1 2005/08/19 16:24:20 dreddy noship $") indicate that it provides integration-level utility routines that bridge Oracle Purchasing (PO) and Oracle Inventory (INV) processing. In release 12.1.1 and 12.2.2, the package exposes a small, stable public interface of two procedures that perform quantity conversions and dual-unit-of-measure deviation checks. These operations are fundamental to receiving, inspection, and inventory transaction flows, where quantities captured in a primary unit of measure must be validated against, or converted into, a secondary unit of measure. The package is a specification-only group with no documented package body members, meaning the two declared entry points constitute its complete documented surface.

Key Procedures and Functions

The package declares two public procedures, both following the standard EBS API signature pattern of an API version parameter and OUT NOCOPY return status and message parameters.

  • GET_CONVERTED_QTY — Converts a supplied quantity from one unit of measure to another for a given item. The procedure accepts the API version, item identifier, the source quantity, the source unit of measure, and the target unit of measure, and returns the converted quantity along with a status indicator. It relies on the UOM conversion definitions and item-level conversion attributes maintained in Oracle Inventory.
  • WITHIN_DEVIATION — Evaluates whether the relationship between a primary quantity and a secondary quantity falls within an acceptable deviation tolerance for a specified item and organization. The procedure receives the API version, organization identifier, item identifier, primary quantity, secondary quantity, and both units of measure, and returns a status and message data. This supports dual-UOM business scenarios in which the secondary quantity is derived or entered independently and must be validated against the primary quantity rather than converted exactly.

No parameter lists are inferred beyond those explicitly documented in the package specification.

Tables Accessed

The documented ETRM metadata lists no tables referenced through APPS synonyms for this package. Functionally, conversion logic of this type depends on Oracle Inventory's unit-of-measure conversion tables and item definition data, but these references are not enumerated in the provided metadata and should be confirmed against the actual package body in a given instance before being relied upon.

Usage Notes

PO_INV_INTEGRATION_GRP is not an end-user-facing API. It is invoked programmatically by higher-level EBS processing, and the metadata records that it is referenced by one other package. Typical invocation contexts include:

  • Receiving and inventory transaction APIs that must convert or validate dual-UOM quantities at the point of transaction entry.
  • Custom extensions and integrations that require the same conversion and deviation logic used by Oracle's standard PO/INV flows, rather than reimplementing it.
  • Any concurrent program or form-based process that accepts both a primary and a secondary quantity and must confirm their consistency before committing data.

Callers should pass the correct API version constant, verify the returned status before consuming output values, and handle the message data returned by WITHIN_DEVIATION for user-facing diagnostics. Because the package is owned by APPS, execute privileges must be granted explicitly to any custom schema invoking it.