Results for “jg_special_rounding”

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

Overview

JG_WITHHOLDING_TAX_PKG is a global tax (JG) PL/SQL package owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It supports withholding tax processing for Oracle Payables and, more broadly, for the globalization tax engine, by resolving applicable withholding tax rates and applying jurisdiction-specific rounding to withheld amounts. The package header carries the standard EBS revision marker $Header: jgzzawts.pls, indicating it originated as a globalization (JGZZ) source file, and it is declared with AUTHID CURRENT_USER, meaning its SQL executes under the privileges of the invoking schema rather than the definer.

From a functional standpoint the package bridges the withholding tax configuration stored in the E-Business Tax repository and the transactional processing of invoices and payments. Because withholding tax regimes vary widely, particularly in the Asia-Pacific region, the package embeds country-specific logic, and the in-source comments explicitly identify Korea as a supported country for special rounding behaviour. In the ETRM 12.2.2 metadata the API is classified as OTHER, reflecting its role as an internal utility rather than a published interface.

Key Procedures and Functions

• GET_RATE_ID — A function that returns the withholding tax rate identifier applicable to a given tax name, invoice, payment, effective date, and amount. It is the primary resolution point through which downstream withholding calculations obtain the correct rate record, taking into account the tax name, the invoice and payment context, and the transaction amount so that tiered or threshold-based rates can be selected.
• AWT_ROUNDING — A procedure keyed by check run name that performs rounding of withheld amounts during payment batch processing. It consolidates rounding behaviour across the payments selected for a check run, aligning the withheld tax values with the applicable currency precision rules.
• JG_SPECIAL_ROUNDING — Documented in the source comments as performing "special rounding for the Withheld Amount" and checking a minimum withheld amount. Although the ETRM record lists three documented procedures, the specification exposes this logic through JG_SPECIAL_WITHHELD_AMT, which receives and returns the withheld amount and base withheld amount together with currency codes, invoice exchange rate, tax name, and calling sequence. Countries explicitly cited include Korea.

Tables Accessed

The ETRM metadata does not enumerate specific tables referenced through APPS synonyms for this package. Based on the functional behaviour described above, the package operates against the withholding tax rate and configuration tables maintained by E-Business Tax, together with Payables invoice and payment distributions that supply the tax name, invoice identifier, payment number, withholding date, and amount used by GET_RATE_ID. No direct table list is documented, so integrators should treat the underlying data model as internal.

Usage Notes

JG_WITHHOLDING_TAX_PKG is an internal utility rather than a documented public API, and the metadata records that it is referenced by one other package, confirming it is consumed by higher-level withholding tax processing logic. It is typically invoked indirectly during Payables invoice validation, withholding tax calculation, and payment batch processing, including the rounding step executed per check run. The AUTHID CURRENT_USER declaration means that any custom code calling these routines must run under a schema with the necessary privileges on the underlying tax and Payables objects. Because the package is not classified as a public API and its signature may change between releases, customizations should avoid calling it directly where a supported E-Business Tax or Payables API exists.