Search Results ap_apxvchcr_xmlp_pkg




Overview
Explore in AI Chat

Overview

APPS.AP_APXVCHCR_XMLP_PKG is the PL/SQL package associated with the Oracle Payables "Payables Voucher Check Report" concurrent program, a BI Publisher (XML Publisher) report identified by the executable short name APXVCHCR. The package encapsulates the report-specific logic required to initialize report parameters, resolve descriptive and NLS strings, derive currency and accounting attributes from Oracle Payables system options, and provide cover-page and formatting values consumed by the report template. It is declared with AUTHID CURRENT_USER and, per its header, has been classified as "noship," indicating that it is a report-support package rather than a public API.

The package is directly relevant to the search term "p_date_option." P_DATE_OPTION is a documented package-level variable of type VARCHAR2(15) that carries the date-selection option entered on the report's concurrent program parameter form. Its value determines which date range the report applies — for example, a user-specified range versus a system-derived date basis. The package's GET_DATE_OPTION function resolves and formats this value for display, storing the result in C_DATE_OPTION, which the report layout uses to print the selected date option on the cover page.

Key Procedures and Functions

  • BEFOREREPORT / AFTERREPORT — Standard report trigger functions. BeforeReport performs overall initialization; AfterReport handles end-of-report cleanup.
  • CUSTOM_INIT — Performs package-specific initialization at report startup.
  • GET_BASE_CURR_DATA / GET_COMPANY_NAME / GET_COVER_PAGE_VALUES — Populate functional currency attributes, the company name header, and the cover-page display values used by the report template.
  • GET_NLS_STRINGS — Loads translated (NLS) literals such as yes/no/all values and informational messages.
  • GET_FLEXDATA — Derives and returns the key flexfield accounting structure data referenced by the report.
  • CALCULATE_RUN_TIME — Computes and stores the report execution time (C_REPORT_RUN_TIME) for the cover page.
  • GET_DATE_OPTION — Resolves P_DATE_OPTION into the display value C_DATE_OPTION used by the report output.
  • C_PAY_CURR_NAMEFORMULA / C_BANK_CURR_NAMEFORMULA — Report formula functions that format payment and bank currency codes or names for display.
  • Initialization functions — GET_NLS_STRINGS, CUSTOM_INIT, and GET_COVER_PAGE_VALUES together prepare localized and header values before the report query executes.

Tables Accessed

Only one documented table is referenced through an APPS synonym: AP_SYSTEM_PARAMETERS. This table stores Oracle Payables system-level options, including functional/primary set of books attributes, precision and minimum accounting unit, base currency, and date-related system defaults. The package reads AP_SYSTEM_PARAMETERS to populate currency and precision globals and to validate the date option selected by the user against system-defined behavior.

Usage Notes

AP_APXVCHCR_XMLP_PKG is invoked indirectly by the Oracle EBS concurrent manager when the Payables Voucher Check Report is submitted. It is not called by forms or by other PL/SQL packages; ETRM records zero referencing packages. Because the package is flagged "noship," it is an internal report-support component and is not published for customer extension. Customizations that require altering the date-option behavior or cover-page values should be implemented with care, since the package is regenerated when the associated XML Publisher report definition is updated. When troubleshooting a p_date_option issue, the relevant path is the parameter passed into the concurrent program, the package variable P_DATE_OPTION, the GET_DATE_OPTION function, and the resulting C_DATE_OPTION display value used by the report template.