Search Results p_tax_name

Overview

JG_WITHHOLDING_TAX_PKG is a global withholding tax wrapper package in the Oracle E-Business Tax (ETRM) module. Its principal business function is to act as a country-dispatching layer that routes withholding tax rate determination and rounding requests to the appropriate country-specific withholding tax package based on the legal entity's product code. The package is owned by APPS and classified as OTHER in the ETRM 12.2.2 documentation.

The central mechanism is a call to jg_zz_shared_pkg.get_product, which returns a two-character product code that identifies the localization in use. In the documented source, recognized codes include 'JA' (Japan), 'JE' (Japan, commented out in the current version), and 'JL' (Korea). Depending on the code returned, the package delegates processing to JA_AWT_PKG or JL_AWT_PKG. If no matching product code is found, the package returns a null value, effectively signaling that no withholding tax rate could be resolved.

This delegation design keeps global withholding logic centralized while allowing country-specific tax rules, thresholds, and rounding conventions to be maintained in separate localization packages.

Key Procedures and Functions

• GET_RATE_ID — A function that determines the applicable withholding tax rate identifier for a given transaction. The user search term p_tax_name corresponds directly to the P_Tax_Name parameter of this function. The function resolves the product code for the current organization, then routes to JA_AWT_PKG.Get_Rate_Id or JL_AWT_PKG.Get_Rate_Id. The documented parameter list includes P_Tax_Name, P_Invoice_Id, P_Payment_Num, P_Awt_Date, and P_Amount, and the function returns a numeric rate identifier or NULL when no localization matches.
• AWT_ROUNDING — A procedure that performs withholding tax rounding for a check run. It retrieves the ORG_ID profile value, resolves the product code, and dispatches to JA_AWT_PKG.AWT_Rounding or JL_AWT_PKG.AWT_Rounding. The documented parameter is P_Checkrun_Name. If no product code matches, the procedure performs no action.
• JG_SPECIAL_ROUNDING — A procedure that applies special rounding to the withheld amount and checks a minimum withheld amount. The documented header comment identifies Korea as the country of implementation, indicating that this logic supports country-specific rounding and threshold rules not covered by standard rounding.

Tables Accessed

The ETRM metadata does not document any base tables accessed directly by JG_WITHHOLDING_TAX_PKG through APPS synonyms. The package relies on profile option retrieval via fnd_profile.get for the ORG_ID setting and on shared utility calls such as jg_zz_shared_pkg.get_product. Any table reads or writes occur within the delegated country-specific packages (JA_AWT_PKG, JL_AWT_PKG), which hold the actual data access logic for withholding tax rates and amounts.

Usage Notes

This package is typically invoked during withholding tax calculation and payment processing flows, including check run processing where rounding must be applied. GET_RATE_ID is called when a rate must be resolved for a specific invoice or payment line, and AWT_ROUNDING is invoked as part of the check run lifecycle.

The package is referenced by one other package, indicating it serves as a shared dependency rather than an entry point exposed directly to end users. It is not designed to be called from a form or concurrent program as a standalone program; rather, it is called from other PL/SQL code. Customizations should not be applied directly to this wrapper, since the country-specific logic resides in the delegated localization packages. The 'JE' branches are commented out in the documented source, so Japanese withholding behavior currently flows exclusively through the 'JA' path.