Search Results accept_parameter

Overview

The APPS.AP_APXWTGNR_XMLP_PKG package body is an Oracle E-Business Suite XML Publisher (BI Publisher) report generation package responsible for producing the Withholding Tax (AWT) reports in Oracle Payables. The package supports the report variants identified within the code as AWT4 and AWT5, among other withholding tax report modes, by assembling the SQL fragments, dynamic bind variables, and lookup strings required by the underlying XML Publisher data template. Its header comment references $Header: APXWTGNRB.pls 120.0.12020000.3, confirming that the file was updated during the 12.2 release cycle and is delivered under the APPS schema.

The package follows the standard Oracle report package pattern: a report header function (BEFOREREPORT), a set of getter functions that expose derived values to the XML template, a series of column-level formatting functions, and a report completion handler (AFTERREPORT). It centralizes withholding-tax report logic so that the XML Publisher template remains declarative.

Key Procedures and Functions

The ETRM metadata documents 103 procedures and functions. The most significant include:

• GET_BASE_CURR_DATA — Queries AP_SYSTEM_PARAMETERS joined to FND_CURRENCIES_VL to populate the base currency code, precision, minimum accountable unit, and currency description into package globals used in amount formatting.
• CUSTOM_INIT — The core initialization routine. It establishes a savepoint (BEFORE_AWT_REPORT), transfers report parameter values into package variables, and conditionally constructs the Tax Authority–related SQL aliases (P_TAX_AUTHORITY_NAME, P_TAX_AUTHORITY_SITE_CODE, address columns) when the report is AWT4 or AWT5.
• ACCEPT_PARAMETER — Receives incoming concurrent program parameters for the report and validates them before execution.
• GET_COVER_PAGE_VALUES and GET_NLS_STRINGS — Populate cover-page fields and translated (NLS) labels for the report output.
• BEFOREREPORT / AFTERREPORT — Standard XML Publisher entry and exit points, initializing globals and cleaning up state.
• Numerous column-level accessors such as GET_COMPANY_NAME, CBASECURRENCYNAME, CREPORTTITLE, CTAADDRESS, CSITEADDRESS, CINVOICECLASS, CACTUALCURRENCYNAME, CINVOICEACTUALAMOUNT, CINVOICEAMOUNTEXEMPT, CGLDISTPOSTEDSTATUS, and CACTUALAMOUNTSUBJECT, each returning a formatted string or value to the report template.

Tables Accessed

The package reads from the following documented tables (via APPS synonyms):

• AP_SYSTEM_PARAMETERS — Supplies the base currency code used throughout amount formatting.
• AP_INVOICES, AP_INVOICE_DISTRIBUTIONS, and AP_INVOICE_PAYMENTS — Provide withholding-tax invoice, distribution, and payment detail that forms the body of the AWT report.
• AP_CHECKS — Provides payment document information.
• AP_PRODUCT_SETUP — Supplies product installation settings referenced during report execution.
• FND_CURRENCIES_VL — Currency precision, minimum accountable unit, and description.
• FND_CONCURRENT_PROGRAMS — Referenced in the standard concurrent program context handling.

Usage Notes

This package executes as part of the AP Withholding Tax Generator XML Publisher concurrent program, invoked from the Oracle Payables responsibility (typically Reports > Withholding Tax reports). Because it is an XML Publisher package, it is not called directly by users or forms; instead, the concurrent manager calls the PL/SQL package, which returns parameter data and cursor results to the associated XML template. The ACCEPT_PARAMETER function is the documented entry point for parameter acceptance, and any custom code that must replicate the report behavior should reference that function rather than reimplementing parameter validation. No other packages reference this package, so it should be treated as a self-contained report implementation specific to the AWT report variants it supports.