Search Results ap_apxindtl_xmlp_pkg




Overview
Explore in AI Chat

Overview

APPS.AP_APXINDTL_XMLP_PKG is the PL/SQL package associated with the Oracle Payables Invoice Detail Report, an XML Publisher (BI Publisher) concurrent program delivered under the AP module. The report provides a detailed or summarized listing of invoice activity, including invoice amounts, discount amounts taken, discount amounts lost, and currency conversion information for a selected set of books and date range. Consistent with the XML Publisher report package convention, this package acts as the report logic container: it declares the report's concurrent program parameters as package-level globals, performs initialization and cover-page data retrieval before the report data model executes, and supplies formula functions and query predicates that the report's data template invokes at run time.

The package is declared with AUTHID CURRENT_USER and, as reflected by the header (APXINDTLS.pls, version 120.0, dated 2007/12/27), it is a shipped, non-supportable (noship) report package. It is generated and owned by APPS and is not referenced by any other package in the E-Business Suite, confirming it is a standalone reporting artifact rather than a shared library.

Key Procedures and Functions

The package exposes 34 documented procedures and functions. The initialization and report lifecycle functions are central to report execution:

  • CUSTOM_INIT — Performs report-specific initialization prior to the report's main query.
  • BEFOREREPORT and AFTERREPORT — Standard XML Publisher report trigger functions executed at report start and completion.
  • GET_BASE_CURR_DATA — Retrieves base currency information (currency code, precision, minimum account unit, description) for the reporting ledger.
  • GET_COVER_PAGE_VALUES — Populates cover-page fields such as company name header, report start date, and report run time.
  • GET_NLS_STRINGS and GET_NLS_VENDOR_TYPE — Resolve NLS-translated strings (Yes/No/All, vendor type lookup meanings) for the report layout.
  • GET_COMPANY_NAME — Resolves the company/organization name displayed on the report.
  • GET_FLEXDATA — Retrieves key flexfield (chart of accounts) data for account segments and descriptions.

The remaining functions are report formulas and query utilities. The C_ALLCURR_* functions (C_ALLCURR_DSCNT_AMT_TKNFORMULA, C_ALLCURR_INV_AMTFORMULA, C_ALLCURR_DSCNT_AMT_LOSTFORMUL, C_ALLCURR_NO_RATE_CNTFORMULA) and the C_M_ALLCURR_* variants compute currency-converted summary amounts and discount metrics for the All Currencies and multi-currency sections of the report. SET_DYNAMIC_WHERE builds the dynamic WHERE clause used by the report query. SET_QUERY, the function of interest to users searching for "set_query," defines or adjusts the report's query for execution. C_BASE_CURRENCY_CODE_P is a helper for the base currency code value.

Tables Accessed

The package references AP_SYSTEM_PARAMETERS, the Payables system options table, primarily to obtain default currency and precision information for the reporting set of books. This data drives the base currency conversion and rounding behavior applied by the C_ALLCURR_* formula functions.

Usage Notes

AP_APXINDTL_XMLP_PKG is invoked indirectly when the Invoice Detail Report concurrent program is submitted. Users select parameters such as set of books, start and end dates, vendor type, vendor, and summary option; the concurrent manager then runs the XML Publisher report, which calls CUSTOM_INIT, BEFOREREPORT, and the data retrieval functions. SET_QUERY and SET_DYNAMIC_WHERE are called during query construction and should not be invoked directly. Because the package is AUTHID CURRENT_USER and references APPS synonyms, it must be executed in an environment where APPS and Payables objects are accessible. As a noship report package, it should not be modified or called from custom code; customization is best achieved by copying the report definition.