Search Results edit_header

Overview

POS_ASBN is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Advanced Shipment Notice (ASN) and supplier self-service shopping cart flow within Oracle Procurement. The package encapsulates the server-side presentation and data logic required to render and maintain the ASN shop cart header, coordinating form-level item attributes such as alignment, display flags, list of values behavior, and field length with the underlying database tables. It is declared AUTHID CURRENT_USER, meaning that it executes with the privileges of the invoking user rather than the definer, a design choice consistent with packages that must respect the caller's session and organization context. The package also exposes session-management utilities (notably SET_SESSION_INFO) that establish language, script, organization, user, session, and responsibility identifiers used throughout the ASN rendering process.

Key Procedures and Functions

The package exposes seventeen documented program units. The session and result utilities include SET_SESSION_INFO, which initializes the global session context variables, and GET_RESULT_VALUE, which retrieves a value by row and column index from the internal text table used to buffer ASN form data.

A family of item attribute functions returns presentation metadata for a given form item index: ITEM_HALIGN and ITEM_VALIGN return horizontal and vertical alignment; ITEM_NAME and ITEM_CODE return the item's display name and internal code; ITEM_STYLE returns styling information; ITEM_DISPLAYED and ITEM_UPDATEABLE return boolean flags governing whether the item is visible and editable; ITEM_LOV returns the associated list of values; ITEM_MAXLENGTH returns the maximum permitted length for the item's input; and ITEM_SIZE returns the rendered field size. The ITEM_MAXLENGTH function is of particular interest to callers searching this package, as it governs input truncation and validation for ASN header fields.

The procedural interface comprises BUILD_BUTTONS, which constructs up to three named action buttons together with their associated functions; ASBN_DETAILS, which drives the ASN detail rendering; EDIT_HEADER and PAINT_EDIT_HEADER, which manage the header editing workflow and its display; and UPDATE_HEADER, which persists header changes such as invoice number, invoice date, and freight amount.

Tables Accessed

The package references POS_ASN_SHOP_CART_HEADERS through an APPS synonym, which stores the ASN shop cart header records that the edit and update procedures read and maintain. The HTP and OWA_UTIL packages supply HTML generation and web utility primitives used to render the ASN pages, while PLITBLM provides the PL/SQL table (index-by table) infrastructure backing the internal text buffer declared as t_text_table. Together these objects support the display, editing, and persistence of ASN shopping cart header information.

Usage Notes

POS_ASBN is invoked from the Oracle EBS ASN self-service web flow rather than from an Oracle Forms canvas; the HTML-oriented dependencies (HTP, OWA_UTIL) confirm that it renders browser output. The documented metadata records no dependent packages referencing POS_ASBN, indicating it is a top-level entry point called directly by the ASN application layer. Customizations should avoid altering the global session variables or the public signatures, and any extension of ITEM_MAXLENGTH behavior should be validated against the underlying column widths in POS_ASN_SHOP_CART_HEADERS. As an APPS-owned package, modifications require the standard EBS customization and patching discipline to remain upgrade-safe across 12.1.1 and 12.2.2.