Search Results line_amount_within_tol

Overview

POS_SCO_TOLERANCE_GRP is an Oracle E-Business Suite package body owned by the APPS schema and classified as a Group (GRP) API. It resides within the Procurement/Ordering (POS) module and supports Supplier Collaboration (SCO) business flows in Oracle EBS 12.1.1 and 12.2.2. The package serves as a thin, workflow-facing wrapper layer that exposes tolerance-checking and routing logic to the Oracle Workflow engine.

The underlying business logic is implemented in the companion package POS_SCO_TOLERANCE_PVT. Every procedure in POS_SCO_TOLERANCE_GRP follows the standard Oracle Workflow PL/SQL API signature (itemtype, itemkey, actid, funcmode, resultout) and immediately delegates to its counterpart in the private package. This separation of concerns allows the Workflow activity definitions to call a stable APS-visible entry point while the implementation, defaulting, and validation logic remains in the private PL/SQL layer. The header comment records "$Header: POSGTOLB.pls 120.0 2005/06/01" and the package is identified by G_PKG_NAME = 'POS_SCO_TOLERANCE_GRP' with G_FILE_NAME = 'POSGTOLS.pls'. The package also reads the profile option AFLOG_ENABLED through FND_PROFILE.VALUE to determine whether debug logging is active.

Key Procedures and Functions

The package documents fourteen procedures, all conforming to the Workflow PL/SQL function activity convention:

• INITIALIZE_TOL_VALUES — Initializes tolerance values used by the SCO tolerance workflow; this is the procedure most frequently referenced when searching for the tolerance setup logic.
• PROMISE_DATE_WITHIN_TOL — Evaluates whether the promise date falls within defined tolerance bounds.
• UNIT_PRICE_WITHIN_TOL — Checks whether the unit price is within permitted tolerances.
• SHIP_QUANTITY_WITHIN_TOL — Determines whether shipped quantity is within tolerance.
• DOC_AMOUNT_WITHIN_TOL — Validates document amount against tolerance thresholds.
• LINE_AMOUNT_WITHIN_TOL — Validates line amount against tolerance thresholds.
• SHIP_AMOUNT_WITHIN_TOL — Validates ship amount against tolerance thresholds.
• ROUTE_TO_REQUESTER — Routes the tolerance exception or approval to the requester.
• MARK_SCO_FOR_REQ — Marks the supplier collaboration record for requisition processing.
• ROUTE_SCO_BIZ_RULES — Applies routing based on supplier collaboration business rules.
• AUTO_APP_BIZ_RULES — Applies automatic approval business rules.
• PROMISE_DATE_CHANGE — Handles changes to the promise date within the workflow.
• INITIATE_RCO_FLOW — Initiates the RCO (Requisition Change Order) flow.
• START_RCO_WORKFLOW — Starts the RCO workflow process.

Each procedure is declared with the standard Workflow parameters and delegates directly to the corresponding procedure in POS_SCO_TOLERANCE_PVT.

Tables Accessed

The ETRM metadata does not enumerate any tables referenced directly by this package through APPS synonyms. Because the package is a pure delegation layer, all table access (reading tolerance definitions, SCO document data, and workflow attributes) occurs inside POS_SCO_TOLERANCE_PVT rather than in this group wrapper. No direct DML is performed here.

Usage Notes

POS_SCO_TOLERANCE_GRP is invoked by the Oracle Workflow engine through function activity definitions configured in the Supplier Collaboration tolerance process. It is not called by Oracle Forms, concurrent programs, or other PL/SQL packages directly — the metadata confirms it is referenced by zero other packages. Customizations should never modify this wrapper; instead they should extend or override POS_SCO_TOLERANCE_PVT. When debugging tolerance behavior, set AFLOG_ENABLED to enable logging and trace execution into the private package where the substantive logic executes.