Search Results jgrx_wt




Overview
Explore in AI Chat

Overview

JGRX_WT is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema that supports global withholding tax (WHT) reporting and extraction for Financials. The "JGRX" prefix identifies the object as part of the Oracle Financials global (JG) reporting suite, and the "_WT" suffix denotes the withholding tax reporting component. In Oracle EBS 12.1.1 and 12.2.2, withholding tax functionality spans Payables, Purchasing, and Receivables, and JGRX_WT operates in that space by combining a standard cost or reporting extract with an XML Publisher–style report lifecycle.

The package's dependency list confirms this role: it references AP_INVOICE_DISTRIBUTIONS_ALL, AP_UTILITIES_PKG, FA_RX_FLEX_PKG, FA_RX_UTIL_PKG, FND_MO_REPORTING_API, FND_LOOKUPS, FND_PROFILE, GL_SETS_OF_BOOKS, and PO_LOOKUP_CODES. Collectively these objects provide invoice distribution data, key flexfield handling, reporting infrastructure, lookup semantics, profile option values, and chart of accounts context — the exact inputs required to produce a withholding tax report.

Key Procedures and Functions

ETRM documents nine program units within this package, which follow a conventional report flow:

  • BEFORE_REPORT — Performs report initialization and setup logic prior to the main data query.
  • WHT_BEFORE_REPORT — The withholding-tax-specific variant of the before-report phase, applying WHT-specific parameters or filters.
  • WHT_BIND — Binds values into the query or cursor used to drive the WHT extract.
  • WHT_AFTER_FETCH — Executes row-level post-processing after each fetch, which is where WHT calculation, translation, or formatting is typically applied.
  • JG_WHT_EXTRACT — The core extraction routine that assembles the withholding tax data set.
  • GET_WITHHOLDING_TAX — Returns withholding tax information for a given context, serving as the retrieval function for tax amounts.
  • GET_LOOKUP_MEANING — Resolves lookup codes to their display meanings using FND_LOOKUPS.
  • SET_RETCODE — Sets a return or status code so that callers can programmatically determine success or failure.
  • APPEND_ERRBUF — Appends messages to an error buffer, supporting the standard EBS error-buffer convention used by concurrent programs.

Tables Accessed

The documented table references (through APPS synonyms) are:

  • AP_INVOICE_DISTRIBUTIONS_ALL — The primary source of Payables invoice distribution lines, from which withholding tax amounts and taxable bases are derived.
  • AP_SYSTEM_PARAMETERS_ALL — Supplies Payables system-level defaults and accounting preferences that affect extract behavior.
  • DBMS_SQL — Oracle's dynamic SQL package, used for constructing and executing the report query dynamically (consistent with the WHT_BIND routine).
  • PLITBLM — A PL/SQL internal table package, typically used for buffering or joining row sets during extraction.

The package also reads GL_SETS_OF_BOOKS, FND_LOOKUPS, FND_PROFILE, and PO_LOOKUP_CODES to resolve ledger context, lookup meanings, profile values, and purchasing lookup codes respectively.

Usage Notes

JGRX_WT is invoked as part of the Oracle Financials global withholding tax reporting concurrent program rather than from interactive forms. The presence of BEFORE_REPORT, WHT_BIND, and WHT_AFTER_FETCH indicates it drives a report data model, and SET_RETCODE / APPEND_ERRBUF confirm it complies with the EBS concurrent program error-handling convention. ETRM states the package is not referenced by any database object, meaning it is an entry-point or top-level report package rather than a shared utility. Because it is a package body that is not publicly referenced, customizations should not call its internal routines directly; instead, custom code should invoke the corresponding concurrent program or replicate the extract logic against the underlying base tables.