Search Results ap_get_message

Overview

APPS.AP_APXWTGNR_XMLP_PKG is the Oracle Reports PL/SQL library package that supports the Payables Withholding Tax (AWT) report generator in Oracle E-Business Suite 12.1.1 and 12.2.2. The package name derives from the report source file APXWTGNR, and the compiled report is registered with the Application Object Library as a concurrent program. It implements the standard Oracle Reports XML Publisher integration pattern, in which an RDF or XML report uses a package for its report-level triggers and formula columns, with an AUTHID CURRENT_USER declaration so it executes with the privileges of the APPS schema.

The package is a parameter-driven reporting component. It declares a public parameter block that supplies the report's selection criteria and display values, including the report identifier (P_AWT_REPORT), set of books (P_SET_OF_BOOKS_ID), fiscal year, date range, tax authority and site identifiers, supplier and supplier name ranges, checkrun name, invoice classes, posted status, and reporting currency. Additional parameters capture withholding certificate expiration ranges and demographic supplier attributes. Several of the parameters are paired with _V display variables, and a set of tax authority address parameters default to a "No Tax Authority Info" placeholder when no matching authority record is found.

Key Procedures and Functions

The package exposes 103 documented procedures and functions. Among them, parameter-handling and initialization routines include ACCEPT_PARAMETER, BEFOREPFORM, BEFOREREPORT, and AFTERREPORT, which manage the report lifecycle, resolve user entries, and populate the public variables before the report data model is executed. CUSTOM_INIT performs package-level initialization.

Data retrieval functions supply the report layout with values. GET_BASE_CURR_DATA and CBASECURRENCYNAME resolve the base or functional currency description; CACTUALCURRENCYNAME and CACTUALAMOUNTSUBJECT resolve the reporting currency and amounts subject to withholding. CINVOICEACTUALAMOUNT, CINVOICEAMOUNTEXEMPT, and CINVOICECLASS return invoice amount and classification values, while CGLDISTPOSTEDSTATUS and CTAADDRESS, CSITEADDRESS, and CACTUALTAXAMOUNT return posting status, tax authority and site addresses, and actual tax amounts. GET_COVER_PAGE_VALUES, GET_COMPANY_NAME, CREPORTTITLE, and GET_NLS_STRINGS populate the cover page, company name, report title, and translated strings, respectively.

Tables Accessed

The package reads from the standard Payables base tables through APPS synonyms. AP_CHECKS supplies payment and checkrun information. AP_INVOICES and AP_INVOICE_DISTRIBUTIONS provide invoice headers, lines, and distribution amounts used in withholding calculations, while AP_INVOICE_PAYMENTS links invoices to their payments. AP_PRODUCT_SETUP and AP_SYSTEM_PARAMETERS return Payables setup options and system-level defaults, including currency and precision settings. FND_CONCURRENT_PROGRAMS provides the concurrent program definition and name, and FND_CURRENCIES supplies currency codes and descriptions used in the reporting currency columns. Consistent with a report package, most access is read-only retrieval for layout purposes.

Usage Notes

AP_APXWTGNR_XMLP_PKG is invoked indirectly by the Withholding Tax report when the concurrent request is run from the Submit Requests window or from the Payables menu. Reports packages are not intended for direct call by application code; they are referenced by the companion report definition and by the concurrent program registration. The package is referenced by zero other PL/SQL packages according to the ETRM repository, confirming its role as a report-support artifact rather than a shared API. Customizations should be limited to parameter defaults and concurrent program options, since modifying the package body may affect report behavior and is not supported by Oracle.