Results for “awt_rounding”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The PL/SQL package body APPS.JL_AWT_PKG belongs to the Oracle E-Business Suite globalization layer that supports Withholding Tax (AWT) processing for Latin American localizations, most notably the Brazilian and Argentinian financial modules. It is classified in the ETRM metadata as an OTHER API, meaning it is a supporting globalization stub rather than a public, customer-callable interface. The package provides two extension points — a rate resolution function (Get_Rate_Id) and a rounding procedure (AWT_Rounding) — that Oracle Financials calls during Withholding Tax calculation on invoices and payments. The package body carries a header of jlzzawtb.pls version 115.0, last touched in October 1999, indicating it is a long-standing component of the JL (Latin America) schema family. The most searched term associated with this object, awt_rounding, corresponds directly to the AWT_Rounding procedure documented here.

Key Procedures and Functions

• Get_Rate_Id — A function used for rate resolution implementations in Withholding Tax. Its documented purpose is to return a rate identifier value (RETURN number) for a given withholding tax scenario. The literal implementation in the body is return(null);, reflecting the customer/product extension stub pattern where the base Oracle code supplies a no-op default that a localization or customer-specific implementation can override or extend. Parameter naming (tax name, invoice, payment, withholding date, amount) reflects the inputs typically available at tax calculation time, though the exact signature must not be assumed beyond what the metadata shows.
• AWT_Rounding — A procedure used for rounding implementations in Withholding Tax. Its body is a NULL; no-op placeholder. It is invoked during Withholding Tax processing to allow site-specific rounding rules to be applied to computed withholding amounts. Because the default body does nothing, sites requiring non-standard rounding must supply their own logic in a customized version of this package.

Both objects were created on 07-OCT-1999 by J Karouzakis and carry the standard Oracle Corporation copyright header. Together they represent the two documented extension hooks in this package: rate determination and amount rounding.

Tables Accessed

The ETRM metadata lists no tables referenced via APPS synonyms for this package body. This is consistent with the visible source, in which both the function and the procedure contain only a return(null); statement and a NULL; statement respectively. No DML, cursor, or query is present in the documented body. Any table access associated with actual withholding calculations is performed by the calling framework (for example the AWT tax engine and the Latin American financials modules) rather than inside this stub. Implementations that extend these routines would typically read withholding tax setup and rate tables, but the base package documented here touches none.

Usage Notes

• Invocation context: The package is invoked internally by Oracle Financials during Withholding Tax processing on invoices and payments, particularly in Latin American localizations that rely on the AWT framework. It is not a standalone concurrent program and is not exposed on a form by itself.
• Dependency: The metadata records that this package is referenced by one other package, confirming it is called from within the AWT processing stack rather than being an entry point.
• Extension pattern: Because both routines are no-op stubs, the package is intended as an override point. Customers or Oracle localization teams replace or augment the body to supply site-specific rate lookup and rounding behavior.
• Version context: The header pins this source to 115.0 (1999), so in EBS 12.1.1 and 12.2.2 it appears as an unchanged legacy globalization component. When researching awt_rounding, note that the shipped body performs no rounding; any observed rounding behavior originates from a customized or localized copy of this package.

In summary, JL_AWT_PKG is a compact, purpose-built globalization stub supplying two documented Withholding Tax extension hooks — Get_Rate_Id for rate resolution and AWT_Rounding for rounding — with no base table access and limited external exposure.