Search Results pos_asn




Overview
Explore in AI Chat

Overview

POS_ASN is an Oracle E-Business Suite PL/SQL package, owned by APPS and declared with AUTHID CURRENT_USER, that supports the Advanced Shipment Notice (ASN) and shop cart style processing used in Oracle Purchasing and Receiving. Its header comment ($Header: POSASNES.pls 115.6) indicates the package has been part of the EBS code line since the earlier 11.x releases and remains present in 12.1.1 and 12.2.2. The package coordinates the translation of shop-cart style ASN data captured in the POS_ASN_SHOP_CART tables into the Receiving Open Interface tables so that shipments and receipts can be processed by the standard receiving flow.

The package also contains a substantial set of UI-helper routines that generate HTML/form attributes — item names, labels, LOV definitions, alignment, styles, and editability flags — used by the ASN shop cart self-service pages. This dual role, data interface staging plus presentation metadata, reflects the age and multi-purpose nature of the package.

Key Procedures and Functions

ETRM documents 46 procedures and functions. They fall into several groups:

The package also defines the cursor c_shipment_err which joins PO_INTERFACE_ERRORS to POS_ASN_SHOP_CART_DETAILS, and c_header_err and c_lines cursors that construct the interface row payload (transaction type SHIP/RECEIVE, processing status, grouping by request). These cursors support the conversion of shop-cart ASN rows into RCV interface rows.

Tables Accessed

The package reads and writes the following tables via APPS synonyms:

Usage Notes

POS_ASN is typically invoked in one of two ways. First, the ASN shop cart OAF/HTML pages call its attribute and label functions to render each field, and call SET_SESSION_INFO to establish context. Second, the conversion logic (cursors c_header_err, c_shipment_err, c_lines) writes into the Receiving Open Interface tables, which are then processed by the standard Receiving Transaction Processor or a concurrent program that submits receiving transactions.

Customisations that need to extend ASN shop cart behaviour, or that reprocess ASN data, may reference this package directly from custom PL/SQL, but Oracle recommends using the receiving open interface APIs instead. Because a large portion of the package builds presentation markup, it should be treated as an internal, non-public interface and not called from custom code where a supported public API exists.