Search Results item_reqd

Overview

APPS.POS_ASL_TOLERANCE_PKG is a PL/SQL package body that supports the Oracle E-Business Suite Procurement module’s Approved Supplier List (ASL) tolerance maintenance functionality. Specifically, it provides the server-side logic used to present and process the supplier item tolerance setup used within the iProcurement / Procurement web-based interface. The package is classified as OTHER in the ETRM metadata, indicating it is not a standard open interface or programmatic API, but rather an internal utility package supporting a specific UI flow.

The package’s responsibility is to orchestrate the rendering of the tolerance frame, gather user session context, and submit tolerance setup actions through the supplied procedures TOLERANCE_FRAME and SUBMIT_TOLERANCE. The header comment references POSASLTB.pls and an Oracle version-control timestamp of 1999, reflecting the long-lived legacy of this object across EBS releases, including 12.1.1 and 12.2.2.

The user search term “item_valign” is not an object or procedure exposed by this package. It does not appear in the documented metadata; the closest related internal helper is item_halign, which returns an HTML alignment attribute for table cells. No procedure or package named item_valign is documented for POS_ASL_TOLERANCE_PKG, so the search term likely reflects a custom or misremembered object name unrelated to this package.

Key Procedures and Functions

The ETRM metadata documents two procedures for this package:

• TOLERANCE_FRAME — Renders the HTML frame that presents the supplier item tolerance user interface. It acts as the entry point for displaying the tolerance maintenance page.
• SUBMIT_TOLERANCE — Handles submission of tolerance data entered by the user, performing the validation and persistence logic against the underlying tolerance table.

Internal helper routines visible in the source excerpt include set_session_info, which validates the ICX session and initializes organization, language, user, session, and responsibility context via icx_sec and fnd_client_info; button, which emits HTML button markup; item_reqd, which returns a required-field indicator image; and item_halign, which returns an HTML alignment attribute. These helpers are supporting rendering utilities and are not part of the public package contract.

Tables Accessed

The package references PO_SUPPLIER_ITEM_TOLERANCE, the base table storing supplier item tolerance definitions used by the ASL tolerance functionality. This table is read and written during the display and submission flows handled by TOLERANCE_FRAME and SUBMIT_TOLERANCE.

The package also references DBMS_SQL, HTP, OWA_UTIL, and PLITBLM. HTP and OWA_UTIL are used to generate the HTML output; DBMS_SQL and PLITBLM support dynamic SQL and PL/SQL table handling used by the internal rendering routines.

Usage Notes

POS_ASL_TOLERANCE_PKG is invoked from the Oracle EBS web-based procurement pages that manage Approved Supplier List tolerance setup. It is not intended to be called directly from a concurrent program or from custom code; the documented metadata indicates it is referenced by zero other packages, confirming it sits at the top of the call stack as a UI-serving package.

Because the package relies on ICX session context (organization, responsibility, user, and language), it must be invoked within an authenticated EBS web session. Direct invocation outside that context will fail the validatesession check. When troubleshooting tolerance page behavior, this package is the relevant object to inspect, and any search for item_valign should be redirected to the documented procedures and helpers described above.