Search Results aso_order_status_pvt

Overview

The ASO_ORDER_STATUS_PVT package body is a private PL/SQL implementation owned by the APPS schema and classified as a PVT (private) API within Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the ASO (Order Capture / Sales Orders) module and serves as the internal engine that resolves and returns order status information for sales order headers and lines. The package encapsulates the logic required to query and interpret order status from the Order Management schema without exposing its implementation directly to external callers, which is consistent with its PVT classification. The object is documented as VALID in the ETRM repository, indicating that it compiles cleanly against its dependencies and that its specification is present alongside the body.

Key Procedures and Functions

The package body exposes two documented program units:

• GET_HEADER_STATUS — Returns the current status of a sales order header. It abstracts the ordering and derivation rules used to determine the header-level state, insulating callers from the underlying OE_HEADER_STATUS_PUB API.
• GET_LINE_STATUS — Returns the current status of an individual sales order line. It performs the equivalent status resolution for line-level records, delegating to OE_LINE_STATUS_PUB.

Although the metadata lists only two procedures, the internal logic in the body likely includes additional helper logic that supports these two entry points. Parameter lists are not documented in the ETRM excerpt and should be obtained from the actual package specification before use.

Tables Accessed

The ETRM metadata records no direct table references through APPS synonyms for this package body. Instead, the package relies on two public Order Management APIs as its data sources:

• OE_HEADER_STATUS_PUB — supplies header-level status resolution.
• OE_LINE_STATUS_PUB — supplies line-level status resolution.

These public packages in turn read from the underlying Order Management base tables (such as OE_ORDER_HEADERS_ALL and OE_ORDER_LINES_ALL) and the associated status lookup views. Because the private package delegates rather than querying tables directly, the metadata shows no table dependencies. This delegation is significant: it means status logic is centralized and any changes to the status model are picked up automatically by ASO_ORDER_STATUS_PVT without code changes in the ASO layer.

Usage Notes

ASO_ORDER_STATUS_PVT is not referenced by any other database object according to the ETRM dependency report, and it references only ASO_ORDER_STATUS_PVT (specification), OE_HEADER_STATUS_PUB, OE_LINE_STATUS_PUB, and the SYS STANDARD package. Its private nature means it is intended to be called only from within the ASO module, most commonly from other ASO packages, Oracle Forms-based Order Capture screens, or internal concurrent processing logic that needs to display or evaluate order status. Because it is not a public API, custom code should generally prefer the corresponding public OE_HEADER_STATUS_PUB and OE_LINE_STATUS_PUB interfaces directly. Customizations that do call this package must account for the possibility that private signatures change between releases, and should be revalidated after any patch or upgrade. Given the two-procedure footprint, the most reliable approach is to inspect the specification via USER_SOURCE or DBA_SOURCE on the target instance before writing dependent code.