Search Results calendar_aware_alt

Overview

APPS.AP_APXINPSR_XMLP_PKG is the package body that supports the Oracle Payables Prepayment Invoice Register and related XML Publisher (BI Publisher) concurrent report, APXINPSR. The package encapsulates the PL/SQL logic required to initialize report parameters, build dynamic SQL fragments, resolve currency formatting attributes, and populate cover-page and header values for the printed output. In Oracle EBS 12.1.1 and 12.2.2, this package is invoked at runtime by the XML Publisher report engine when the APXINPSR concurrent program executes, and it is typical of the generated _XMLP_PKG pattern used to wrap report-specific logic behind a stable PL/SQL API. Its classification is OTHER, indicating it is not a public or standard open interface API but an internal report support package owned by APPS.

Key Procedures and Functions

The package exposes 35 documented procedures and functions. The principal ones include:

• GET_BASE_CURR_DATA — Retrieves the base currency code, precision, minimum accountable unit, and description from AP_SYSTEM_PARAMETERS and FND_CURRENCIES, populating package-level globals used for currency formatting throughout the report.
• CUSTOM_INIT — Builds dynamic SQL fragments for vendor and invoice queries, incorporating parameters such as vendor ID, vendor type lookup code, prepayment type (temporary or permanent), and date ranges. This drives the report's data selection logic.
• GET_COVER_PAGE_VALUES and GET_COMPANY_NAME — Resolve company and cover-page attributes displayed in the report header.
• GET_NLS_STRINGS — Populates NLS-dependent display strings.
• BEFOREREPORT and AFTERREPORT — Standard XML Publisher report triggers for setup and teardown.
• C_AMOUNT_FOR_SUMFORMULA, C_AMOUNT_REMAINING_CONVERTFORM, and C_AMOUNT_REMAINING_DSPFORMULA — Formatting functions for monetary totals on the report layout.
• NLS constant functions such as C_NLS_YES_P, C_NLS_NO_P, C_NLS_ALL_P, C_NLS_NO_DATA_EXISTS_P, C_NLS_VOID_P, C_NLS_NA_P, and C_NLS_END_OF_REPORT_P — Return localized literals used across the template.
• Constant accessors such as C_REPORT_START_DATE_P, C_COMPANY_NAME_HEADER_P, and C_BASE_CURRENCY_CODE_P — Expose package state to the report layout.

Tables Accessed

The package reads from two documented tables via APPS synonyms:

• AP_SYSTEM_PARAMETERS — Supplies the base currency code set at the Payables system level.
• FND_CURRENCIES — Provides currency precision, minimum accountable unit, and description used to format and label amounts.

Both are read-only lookups; no inserts, updates, or deletes are performed by this package.

Usage Notes

AP_APXINPSR_XMLP_PKG is invoked exclusively by the XML Publisher concurrent program APXINPSR when generating the Prepayment Invoice Register. It is not referenced by any other documented package, confirming its role as a report-local support module. The functions and NLS constants are called directly from the report's XML layout template. The term "calendar_aware_alt" is not a documented attribute of this package; users searching that term should verify whether it refers to a different object or a layout-level element. Customizations to this package should be avoided, as Oracle may overwrite it during patching.