Search Results c_curdate_p

Overview

APPS.AP_APXMHLET_XMLP_PKG is a report-support PL/SQL package in Oracle E-Business Suite that underpins the Oracle Payables XML Publisher (BI Publisher) letter-generation reports, such as APXMHLET. It is declared with AUTHID CURRENT_USER and is auto-generated in the standard XMLP report package pattern, where the package body supplies the "before report" and "after report" logic that Oracle Reports/XML Publisher templates call during execution, together with accessor functions that expose substituted parameter and constant values to the report layout. All 22 documented functions operate in the APPS schema and are classified as OTHER, indicating that the package is a report artifact rather than a public application programming interface. The package header carries a $Header comment dated 2007, consistent with the release history of the AP letter reports.

Key Procedures and Functions

• BEFOREREPORT / AFTERREPORT — Standard report lifecycle entry points invoked by the Reports runtime before and after the main data query.
• CUSTOM_INIT — Performs report initialization that is not supplied by the default XMLP skeleton.
• GET_BASE_CURR_DATA — Populates the base (functional) currency values: currency code, precision, minimum account unit, and description.
• GET_COVER_PAGE_VALUES — Retrieves the sender name, title, phone, and organization values used on the letter cover page.
• GET_COMPANY_NAME — Obtains the company name printed in the report header.
• GET_NLS_STRINGS — Loads translated Yes/No/All and "no data exists" literals for multilingual output.
• GET_FLEXDATA — Populates the P_FLEXDATA parameter, the key/value flexfield context string used by the letter report.
• CALCULATE_RUN_TIME — Derives the report run time value.
• C_BASE_CURRENCY_CODE_P, C_BASE_PRECISION_P, C_BASE_MIN_ACCT_UNIT_P, C_BASE_DESCRIPTION_P — Accessors returning base currency attributes.
• C_COMPANY_NAME_HEADER_P, C_REPORT_START_DATE_P, C_REPORT_RUN_TIME_P, C_CURDATE_P — Accessors for header and date constants.
• C_NLS_YES_P, C_NLS_NO_P, C_NLS_ALL_P, C_NLS_NO_DATA_EXISTS_P — Accessors exposing the NLS strings to the report template.
• C_CHART_OF_ACCOUNTS_ID_P — Accessor for the chart of accounts identifier.

Tables Accessed

Only one table is documented as referenced through APPS synonyms: AP_SYSTEM_PARAMETERS. This is the Payables system options table that supplies base currency, precision, minimum account unit, chart of accounts, and organization context. The package reads it during initialization routines (GET_BASE_CURR_DATA, GET_COMPANY_NAME, GET_FLEXDATA) rather than performing any writes. No other tables are documented as accessed by this package.

Usage Notes

The package is invoked implicitly by the Oracle Reports/XML Publisher runtime whenever the corresponding AP letter report (APXMHLET) is executed, either as a concurrent program submission or through the standard Submit Requests pathway. The get_flexdata function is of particular interest because it is the routine responsible for assembling the P_FLEXDATA string used in the letter report's accounting flexfield display. Customization is generally limited to copying the package into a CUSTOM schema and extending CUSTOM_INIT or the accessors, since the shipped package is unpinned report boilerplate that Oracle may regenerate. Direct calls from custom code are not supported, as the package is not registered as a public API and is referenced by no other packages.