Search Results ap_apxmhlet_xmlp_pkg




Overview
Explore in AI Chat

Overview

AP_APXMHLET_XMLP_PKG is an Oracle Application Object Library package body owned by the APPS schema in Oracle E-Business Suite. It is the compiled implementation of a report logic package that supports the Oracle Payables XML Publisher (BI Publisher) report identified by the APXMHLET short name, which is associated with the Payables expense/accounting reporting family that relies on lookup-driven header and base currency information. The package encapsulates the data-fetch and formatting logic used at runtime by the concurrent report program, rather than exposing a callable business API to other modules. Its status is VALID and the package body is not referenced by any other database object, confirming that it operates as a leaf-level report utility invoked only through the Oracle Reports/XML Publisher execution framework.

Key Procedures and Functions

The documented package exposes 22 procedures and functions, combining Oracle Reports report triggers with reporting helper logic:

The C_* members follow the conventional Oracle Reports pattern of package-level constants/globals fed by their corresponding GET_* routines.

Tables Accessed

The package reads from the following objects, resolved through APPS synonyms:

  • AP_SYSTEM_PARAMETERS — the primary Payables configuration source, supplying base currency, precision and accounting unit defaults used in the base currency routines and company name logic.
  • FND_CURRENCIES_VL — the currencies view, supplying currency code and descriptive information for display.
  • FND_LOOKUPS and AP_LOOKUP_CODES — the lookup tables supplying the report's list-of-values and NLS lookup values.
  • GL_SETS_OF_BOOKS — the accounting books/ledger definition, used to derive set-of-books context for the report header.
  • DBMS_STANDARD and STANDARD — PL/SQL standard packages supporting the compiled body.

All access is read-only; the package performs no data manipulation.

Usage Notes

AP_APXMHLET_XMLP_PKG is invoked indirectly by the associated Oracle Payables concurrent program when the XML Publisher report is submitted from the Payables responsibility. It is not referenced by any other database package, so custom code should not depend on it. Because its C_* globals and helper functions are populated by the report triggers (BEFOREREPORT, CUSTOM_INIT) during a report run, external or standalone invocation outside the report execution context will not yield meaningful values. In both Oracle EBS 12.1.1 and 12.2.2 the package remains VALID and performs the same reporting role; the primary 12.2.x consideration is that ledger and base-currency resolution respects the multi-organization access and data access set model, so users must have the appropriate Payables and General Ledger access for the report to return base currency data correctly.