Search Results multi_row_label

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:

• Session and value helpers: SET_SESSION_INFO, GET_RESULT_VALUE — initialise session context (language, org, user, responsibility, request) and retrieve output values for the calling page or program.
• Field attribute functions: ITEM_REQD, ITEM_HALIGN, ITEM_VALIGN, ITEM_NAME, ITEM_CODE, ITEM_STYLE, ITEM_DISPLAYED, ITEM_UPDATEABLE, ITEM_SIZE, ITEM_MAXLENGTH, ITEM_WRAP — return the display/validation attributes of a given item.
• LOV helpers: ITEM_LOV, ITEM_LOV_MULTI — build List of Values definitions.
• Label helpers: HIDDEN_LABEL, HIDDEN_FIELD, SINGLE_ROW_LABEL, MULTI_ROW_LABEL, NON_UPDATEABLE — generate label/hidden field markup.

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:

• POS_ASN_SHOP_CART_DETAILS and POS_ASN_SHOP_CART_HEADERS — the shop-cart ASN staging tables that hold line and header data entered by the user.
• PO_INTERFACE_ERRORS — read to surface validation errors for the header and each line.
• PO_HEADERS_ALL, PO_LINES_ALL, PO_LINE_LOCATIONS_ALL, PO_DISTRIBUTIONS_ALL, PO_HEADERS, PO_LOCATION_ASSOCIATIONS — source purchase order data used to derive shipment/receipt details.
• RCV_HEADERS_INTERFACE, RCV_HEADERS_INTERFACE_S, RCV_TRANSACTIONS_INTERFACE, RCV_TRANSACTIONS_INTERFACE_S, RCV_INTERFACE_GROUPS_S — receiving open interface tables and sequences written by the package for the receiving processor.
• AK_FLOW_REGION_RELATIONS — used in the flow/region navigation configuration.

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.