Search Results ap_apxptptr_xmlp_pkg




Overview
Explore in AI Chat

Overview

AP_APXPTPTR_XMLP_PKG is a PL/SQL package in the APPS schema of Oracle E-Business Suite (validated under 12.1.1 and 12.2.2) that supports the Oracle Payables Print Payables Transfer to General Ledger report. The suffix _XMLP_PKG identifies it as an XML Publisher (Oracle BI Publisher) report-level package generated by the XML Publisher template/definition framework. Its principal business function is to supply the runtime data extraction, lookups, NLS strings, formatting attributes, and report header/footer values required to render the Payables Transfer to General Ledger report output. The package implements the standard XML Publisher report structure: package-level global variables that carry report context between the before-report and after-report phases, helper functions that retrieve system-level and reference data, and initialization/cleanup routines. It is classified under the ETRM as an "OTHER" API type, meaning it is not a public, callable business API, but rather an internal report-support package associated with a concurrent program.

Key Procedures and Functions

The ETRM metadata documents twenty procedures and functions. The data retrieval and report-lifecycle routines include:

  • GET_BASE_CURR_DATA — retrieves base currency information used throughout the report, including precision, minimum account unit, and description, holding these in package globals for reuse.
  • GET_COVER_PAGE_VALUES — assembles the values printed on the report cover page, such as company name, report title, and reporting period.
  • GET_COMPANY_NAME — returns the operating company/organization name for the report header.
  • GET_NLS_STRINGS — loads NLS-dependent literals from the message dictionary or constants into package variables so the report renders correctly in the session language.
  • BEFOREREPORT — the XML Publisher before-report trigger; initializes globals, calls the data-fetch helpers, and prepares report context.
  • AFTERREPORT — the XML Publisher after-report trigger; performs cleanup and final report-state handling.
  • CUSTOM_INIT — performs package-specific initialization invoked during report setup.

Package-level constants and global variables include C_BASE_CURRENCY_CODE_P, C_BASE_PRECISION_P, C_BASE_MIN_ACCT_UNIT_P, C_BASE_DESCRIPTION_P, C_COMPANY_NAME_HEADER_P, C_REPORT_START_DATE_P, C_CHART_OF_ACCOUNTS_ID_P, and the NLS literals C_NLS_YES_P, C_NLS_NO_P, C_NLS_ALL_P, C_NLS_NO_DATA_EXISTS_P, C_NLS_TERMTYPE_P, and C_NLS_END_OF_REPORT_P. These carry currency, chart-of-accounts, and localized text values between the report phases.

Tables Accessed

The package reads AP_SYSTEM_PARAMETERS through the APPS synonym. AP_SYSTEM_PARAMETERS is the Oracle Payables system-level setup table and holds the base currency code, precision, minimum accountable unit, chart of accounts identifier, and reporting-related defaults. The package uses these values to drive currency formatting and account validation in the transfer report. No other base tables are documented in the ETRM metadata; the report's primary data is drawn from the Payables transfer/accounting views referenced indirectly by the concurrent program.

Usage Notes

AP_APXPTPTR_XMLP_PKG is not invoked directly by users or by custom application code. It is referenced exclusively by its own concurrent program and XML Publisher report definition, and the ETRM records zero external package dependencies. The package is executed within the Oracle Payables responsibility when the Print Payables Transfer to General Ledger concurrent program runs; the before-report and after-report triggers fire automatically as part of the XML Publisher processing. Because it interacts with the FND message/NLS framework and the AP system parameters, customizations should not alter its globals. Oracle's proprietary and confidential notice applies, and the package should be treated as source-supplied report infrastructure rather than a supported extension point.