Search Results tolerance_frame




Overview
Explore in AI Chat

Overview

POS_ASL_TOLERANCE_PKG is a server-side PL/SQL package in the Oracle E-Business Suite Purchasing module (APPS schema). It governs the maintenance of Approved Supplier List (ASL) tolerance definitions that control the quantity, percentage, or date tolerances applied to supplier item receipts and related documents. In Oracle Purchasing, an ASL entry can carry tolerance rules that determine how much over- or under-receipt is permissible before the system flags a discrepancy or blocks receipt processing. This package provides the user-interface rendering layer and the submission logic that together allow a user to view, populate, and commit those tolerance records for one or more ASL entries.

The package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking session rather than the definer, and it carries a very early header date (115.0, 1999), identifying it as a long-standing component of the Purchasing codebase that has persisted into EBS 12.1.1 and 12.2.2 largely unchanged. It is classified as OTHER under the ETRM API taxonomy, indicating it is not a public, supported integration API but an internal module invoked by Purchasing forms and concurrent processes.

Key Procedures and Functions

  • TOLERANCE_FRAME — Accepts an optional ASL identifier and is the entry point that renders the tolerance maintenance frame, the HTML-based screen (or form-embedded region) in which ASL tolerance data is displayed and edited. It drives the presentation layer through the HTP and OWA_UTIL packages and establishes session context such as organization, user, responsibility, and request identifiers held in the package-level globals.
  • SUBMIT_TOLERANCE — The transactional counterpart to the frame. It receives the tolerance rows entered by the user as associative-array collections (a text-table type indexed by binary integer), covering ASL identifiers, using organizations, days-in-advance values, and tolerance amounts. It also accepts scalar control parameters including an ASL identifier, an action code, row counters, and an error-row indicator, then persists the submitted tolerance records and reports processing outcomes back to the caller.

Both procedures are documented; no additional functions are exposed in the metadata.

Tables Accessed

  • PO_SUPPLIER_ITEM_TOLERANCE — The primary base table. It stores the per-supplier-item tolerance definitions that the package reads for display in the tolerance frame and writes during tolerance submission. All user-entered tolerance values flow into this table through the APPS synonym.
  • DBMS_SQL — Oracle's dynamic SQL built-in, used for constructing and executing SQL statements at runtime, typically for the flexible query and update paths required by the tolerance frame.
  • HTP and OWA_UTIL — Oracle's PL/SQL web toolkit packages, employed to generate the HTML markup and manage the HTTP session for the tolerance frame interface.
  • PLITBLM — A utility package used within this code family for list and table rendering support.

Usage Notes

POS_ASL_TOLERANCE_PKG is an internal, non-API component. It is invoked from the Purchasing module's ASL and supplier item maintenance flows — most directly from the form or web page that presents supplier item tolerances — and can also be reached through concurrent processing that submits tolerance updates. Because it is catalogued as OTHER and reference-database analysis shows no other packages calling it, it should be treated as a private implementation detail rather than an integration surface. Customizations should not call TOLERANCE_FRAME or SUBMIT_TOLERANCE directly; instead, developers integrating ASL tolerance data should rely on supported Purchasing APIs or direct, carefully controlled DML against PO_SUPPLIER_ITEM_TOLERANCE. Any functional changes to this package must be revalidated against the ASL tolerance screens in both 12.1.1 and 12.2.2, since the online page behavior depends on its HTML-generation logic.