Search Results ap_apxfpmdr_xmlp_pkg




Overview
Explore in AI Chat

Overview

The APPS.AP_APXFPMDR_XMLP_PKG package is a report-support PL/SQL package within the Oracle Payables (AP) module of Oracle E-Business Suite. The _XMLP_PKG suffix identifies it as a generated package that accompanies an Oracle BI Publisher (XML Publisher) report definition, providing the procedural PL/SQL logic that runs before and after the reporting query to prepare runtime values, derive localization strings, and populate parameters and lexical substitutions for the report template.

In ETRM terms this object is classified as OTHER rather than a public API, confirming that it is an internal implementation artifact rather than a supported integration interface. It is owned by the APPS schema, holds a status of VALID in both 12.1.1 and 12.2.2, and its documented dependency list shows references only to SYS and the STANDARD package, with no downstream packages referencing it. This narrow dependency footprint is typical of a report-package shell that relies on packaged constants and helper routines rather than exposing reusable programmatic services.

Key Procedures and Functions

The package exposes 23 documented procedures and functions. Their names indicate the standard XML Publisher report-package architecture — a set of before/after report entry points, a set of report parameter and constant accessors, and helper utilities for localization and header data.

  • BEFOREREPORT / AFTERREPORT — the primary entry points invoked by the concurrent manager around the report execution cycle. BEFOREREPORT performs initialization, parameter validation, and defaulting; AFTERREPORT performs post-processing cleanup and report-finalization logic.
  • CUSTOM_INIT — carries report-specific initialization logic, typically executing setup routines and deriving values used by the template.
  • GET_PARAMETER_VALUES — retrieves and evaluates the concurrent program parameter values passed into the report run.
  • GET_COMPANY_NAME and C_COMPANY_NAME_HEADER_P — resolve the legal entity or organization name printed in the report header.
  • GET_BASE_CURR_DATA — retrieves base currency information, including the currency code, precision, minimum accounting unit, and description, exposed through the accessors C_BASE_CURRENCY_CODE_P, C_BASE_PRECISION_P, C_BASE_MIN_ACCT_UNIT_P, and C_BASE_DESCRIPTION_P.
  • GET_NLS_STRINGS and the C_NLS_* constants — supply translated literal strings (Yes, No, All, No Data Exists, End of Report) so the XML template renders in the session language.
  • GET_COVER_PAGE_VALUES and C_REPORT_START_DATE_P — assemble cover-page and run-date values presented on the report output.
  • C_CHART_OF_ACCOUNTS_ID_P — exposes the chart of accounts identifier used to build accounting flexfield context in the report.

Tables Accessed

Through APPS synonyms the package reads a focused set of Payables and shared reference tables:

  • AP_SYSTEM_PARAMETERS — supplies ledger-level defaults such as base currency, accounting precision, and chart of accounts context.
  • AP_SUPPLIER_SITES_ALL — provides supplier site information for the report's payment or supplier detail sections.
  • CE_BANK_ACCOUNTS and CE_BANK_ACCT_USES_ALL — resolve internal bank account and bank account use details shown on the report.
  • HZ_PARTIES — supplies trading-partner and organization name data used in header and party identification sections.

Usage Notes

This package is not intended for direct invocation by custom code. It is executed automatically by the concurrent manager when the associated Oracle BI Publisher report — a Payables payment or bank-account-related report — is submitted. Customization is normally performed through XML Publisher template editing and, where necessary, modifying the PL/SQL package body under a supported patching strategy. Because it is classified as OTHER and is referenced by no other packages, developers should treat it as an internal report artifact and avoid building dependencies against it. Its persistence in both 12.1.1 and 12.2.2 confirms the report remains supported across those releases.