Search Results get_return_code

Overview

APPS.PO_REQ_ISO_SV is a server-side PL/SQL specification (package spec) belonging to the Oracle Purchasing module of Oracle E-Business Suite. The object is registered in ETRM with an API classification of OTHER, indicating that it is a supporting internal API rather than a general-purpose public interface. Its name and procedure signatures associate it with the integration between Order Management (OE) and Purchasing requisition processing, specifically the "ISO" (internal sales order / internal requisition) flow.

In Oracle EBS, an internal sales order raised in Order Management generates a corresponding internal requisition in Purchasing, which is then processed into a purchase order that ships from an internal (inventory) source. PO_REQ_ISO_SV encapsulates the logic invoked when that internal sales order must be processed or cancelled — for example, cancellation of the OE order line propagates a cancellation reason and quantity back into the requisition/order pipeline. The package therefore acts as the serviced (SV) entry point between the Order Management transaction and the Purchasing requisition/order chain.

Key Procedures and Functions

The documented package exposes two program units, matching the ETRM record of two procedures/functions total.

• CALL_PROCESS_ORDER — The primary procedure. It is the entry point used to process an internal sales order against its associated requisition context. Its parameters, per the source listing, carry the OE header identifier, the OE line identifier, the affected line quantity, and a cancellation reason, with standard OUT parameters for message data, message count, and return status. It is invoked when the internal order/requisition linkage requires processing or cancellation handling. The NOCOPY OUT parameters indicate a bulk-friendly, message-stack-based calling convention consistent with other EBS PL/SQL APIs.
• GET_RETURN_CODE — A helper function that maps a status string to a return code. It is used internally (or by callers) to normalize status values into a code representation for consistent error/success handling around CALL_PROCESS_ORDER.

No public tables or additional overloads are documented in the ETRM metadata.

Tables Accessed

The ETRM metadata for PO_REQ_ISO_SV does not list any referenced tables via APPS synonyms. This is consistent with a thin service wrapper whose data access is likely delegated to other Purchasing or Order Management packages and views, or performed through dynamic or indirect references not captured in the documented metadata. No base tables are documented as read or written directly by this package.

Usage Notes

PO_REQ_ISO_SV is an internal supporting API and is not intended for direct customer invocation. In practice it is called from the internal sales order processing path — typically triggered when an OE order or line is processed or cancelled and the corresponding internal requisition/order must be synchronized. Because it is classified as OTHER rather than PUBLIC, Oracle does not guarantee its signature or behavior across releases.

Custom code should avoid depending on CALL_PROCESS_ORDER or GET_RETURN_CODE directly; supported integration points (such as the documented Order Management or Purchasing public APIs, or the standard internal order workflow) should be used instead. The ETRM record shows the package is referenced by zero other packages, reinforcing that it is a terminal, internally invoked service unit in the 12.1.1 / 12.2.2 code line. The header comment dated 2005 with the "noship" designation also indicates it is a non-shipped, internal-only object.