Search Results jg_undo_extended_withholding




Overview
Explore in AI Chat

Overview

JG_EXTENDED_WITHHOLDING_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the extended withholding tax functionality used primarily in Latin American localizations (notably Brazil and Argentina). Extended withholding in Oracle Payables/Receivables encompasses tax withholding calculations performed at the invoice distribution line level, beyond the standard Payables withholding model. The package provides the procedural logic required to determine, apply, reverse, and reconcile extended withholding amounts against invoice distributions, and it interacts with selected invoice records and Payables distributions to keep withholding balances consistent during invoice entry, matching, prepayment application, and adjustments. It is classified as an OTHER API, meaning it is not a public, documented open interface but is a supporting internal package invoked by the withholding callout framework.

Key Procedures and Functions

The ETRM metadata documents seven procedures and functions within this package:

  • JG_DO_EXTENDED_WITHHOLDING — Applies extended withholding against the invoice distributions; it drives the calculation and booking of withheld amounts.
  • JG_UNDO_EXTENDED_WITHHOLDING — Reverses a previously applied extended withholding, restoring the distribution and withholding balances to their prior state.
  • JG_UNDO_TEMP_EXT_WITHHOLDING — Reverses temporary extended withholding entries, typically used when a withholding was provisionally calculated but not permanently committed.
  • JG_EXT_WITHHOLDING_DEFAULT — Derives/defaults the extended withholding attributes for a given transaction context.
  • JG_EXTENDED_MATCH — Handles the matching logic that ties withholding amounts to the corresponding invoice distributions during match and validation processes.
  • JG_EXTENDED_INSERT_DIST — Inserts the withholding distribution records generated by the extended withholding calculation.
  • JG_EXT_WITHHOLDING_PREPAY — Manages extended withholding behavior when prepayments are applied to invoices.

Parameter lists are not documented in the available metadata and are intentionally not reproduced here.

Tables Accessed

  • AP_INVOICE_DISTRIBUTIONS_ALL — The primary Payables distribution table. The package reads and writes distributions to calculate withholding amounts, insert withholding distributions, and reverse them on undo operations.
  • AP_SELECTED_INVOICES_ALL — Stores invoice selection data used in withholding processing; the package consults it when determining which invoices and withholding lines are subject to extended withholding treatment.

Usage Notes

JG_EXTENDED_WITHHOLDING_PKG is not intended for direct invocation by end users or typical customizations. It is called by the Payables withholding callout framework, as reflected by its reverse dependencies: AP_AWT_CALLOUT_PKG and AP_EXTENDED_WITHHOLDING_PKG both reference it, along with a same-named wrapper. Its procedures are therefore exercised automatically during invoice entry, invoice matching, prepayment application, and the reversal/undo of withholding when invoices are adjusted, cancelled, or validated. Support and diagnostic work typically begins with the callout package rather than this internal routine, since the callout decides when to invoke extended withholding logic. The package status is VALID in the documented environment across EBS 12.1.1 and 12.2.2. Because it is classified as an OTHER API and relies on APPS synonyms, any custom code should avoid calling it directly; changes to withholding configuration or tax setup should instead be made through the standard Receivables and Payables setup forms that the callout framework reads.