Search Results get_header_status

Overview

APPS.ASO_ORDER_STATUS_PVT is a private PL/SQL package within the Oracle E-Business Suite Order Capture (ASO) module. Its header declares AUTHID CURRENT_USER, indicating that the package executes with the privileges of the calling schema, which is characteristic of internal, private (PVT) helper packages that are not intended for direct customer use. The package is a private utility component whose purpose is to resolve order status information for the sales order entities managed by ASO. It encapsulates the logic used to derive and return the status of a header-level sales order and its associated lines. In Oracle EBS 12.1.1 and 12.2.2, ASO provides the shared order capture entities that are exposed through public APIs such as ASO_ORDER_PUB; the private package documented here supplies supporting status-determination behavior invoked by those public layers rather than by end customers directly.

Key Procedures and Functions

• GET_HEADER_STATUS — Returns the status value for a specified sales order header. The caller supplies a header identifier, and the procedure returns the resulting status through its output parameter. This is the procedure associated with the user search term "get_header_status" and is the counterpart to the line-level status routine below.
• GET_LINE_STATUS — Returns the status value for a specified sales order line. The caller supplies a line identifier, and the procedure returns the resulting line status through its output parameter.

Both procedures are declared in the package specification and are defined in the body. The documented signature shows a single input identifier and a single output status string for each routine, reflecting a narrow, focused contract. No overloaded variants are documented.

Tables Accessed

The ETRM metadata records no directly referenced tables under APPS synonyms for this package. Because the package operates on sales order header and line status, the tables underlying its processing are the ASO order capture base tables, which are referenced internally through the package body rather than exposed in the specification. Any direct dependency is therefore not surfaced in the documented metadata, and the package provides no additional table contract to callers beyond the identifiers and returned status strings.

Usage Notes

The package is classified as PVT (private), meaning it is not part of the supported public API surface. It is intended for internal invocation by other ASO components, including the public order APIs and the order capture forms that need to display or validate order and line status. The metadata records zero referencing packages, suggesting that in the documented release its callers are form-level or internal consumers rather than other PL/SQL packages. Custom code should not call ASO_ORDER_STATUS_PVT directly; developers requiring order status should use the supported public interfaces. Because the package runs with AUTHID CURRENT_USER, callers must have the appropriate object and data privileges for the underlying ASO tables when invoking it. The header comment indicates the specification is stable and unchanged since its original 2005 revision, which is consistent with a long-standing internal helper retained across 12.1.1 and 12.2.2.