Results for “get_asn_data”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The APPS.WSH_OPSM_ASN_BE_PKG package is a backend PL/SQL component within Oracle E-Business Suite's Warehouse Management (WSH) module, specifically associated with the Order Pickup and Shipping Management (OPSM) feature set. Its primary business function is to support the generation and processing of Advance Shipment Notice (ASN) data used for outbound logistics and shipment confirmation. The package acts as the server-side logic layer that assembles structured ASN payloads from warehouse operational data and coordinates the submission of processing requests. In EBS 12.1.1 and 12.2.2, this package resides in the APPS schema and is classified as an OTHER API, indicating it is not part of a formally published public API set but is instead an internal component invoked by OPSM-related processes and dependent packages.

Key Procedures and Functions

The package exposes several documented procedures and functions, of which three are recorded in the ETRM metadata:

• GET_ASN_DATA — The core retrieval routine responsible for gathering ASN-related data from the warehouse operational tables. It consolidates container, delivery, item, and genealogy information into a form suitable for downstream ASN transmission or validation.
• SUBMIT_REQUEST — A submission routine that dispatches a processing request, typically beginning an ASN generation or outbound message flow. It serves as the entry point that downstream processes or concurrent programs call to initiate ASN handling.
• Additional internal procedures — The dependency listing references OPSM ASN collection types (containers, delivery, item details, genealogy, and items), which are consumed by the package's private and helper routines. Parameter lists for these routines are not enumerated in the documented metadata and should not be assumed.

Because the metadata records only three named procedures/functions, the package should be treated as a focused utility for ASN assembly and request submission rather than a broad public interface.

Tables Accessed

The package references the following documented objects via APPS synonyms and internal collection types:

• MTL_PARAMETERS — Read to resolve inventory organization context and warehouse-level setup attributes needed to scope ASN processing.
• DUAL — Used for scalar evaluations and single-row lookups.
• PLITBLM — A standard PL/SQL index-by table type used for in-memory collection handling.
• WSH_OPSM_ASN_CONTAINERS_TBL, WSH_OPSM_ASN_DELIVERY_TBL, WSH_OPSM_ASN_ITEMDETAILS_TBL, WSH_OPSM_ASN_ITEMGENEALOGY_TBL, WSH_OPSM_ASN_ITEMS_TBL — Referenced collection/table types that supply the container, delivery, item detail, genealogy, and item-level records required to build a complete ASN structure.

Usage Notes

WSH_OPSM_ASN_BE_PKG is typically invoked from within OPSM backend processes, concurrent programs, or custom code that requires the assembly or submission of ASN data. The package is self-referential in the dependency listing, confirming that it is referenced internally rather than by other documented application packages; the metadata records zero external package dependents. As an OTHER-classified component, it is not a supported public API and direct calls from custom extensions should be validated against the target EBS release (12.1.1 or 12.2.2), since internal signatures and behavior may differ between versions. Where present, the correct invocation pattern is to populate the relevant ASN collection types, call GET_ASN_DATA to build the payload, and use SUBMIT_REQUEST to trigger downstream processing.