Search Results c_report_start_date

Overview

APPS.AP_APXTOLRP_XMLP_PKG is a generated PL/SQL package that supports the Oracle Payables XML Publisher report known internally as APXTOLRP (Tolerance Report). In Oracle EBS 12.1.1 and 12.2.2, reports built on the XML Publisher (BI Publisher) engine are wrapped by an auto-generated package that supplies user exit logic, lexical parameter values, NLS (National Language Support) strings, and report-level initialization and cleanup routines. This package is created by the XML Publisher report generation utilities and is classified in ETRM as an "OTHER" API, meaning it is not a public, supported integration interface but an internal runtime artifact of the concurrent report architecture.

The package header declares a set of public variables and functions. The global variables hold the concurrent request identifier and switches, while the bulk of the package exposes "getter" functions that return NLS-translated literal strings used inside the report template. The C_NLS_* variables and their corresponding _P functions provide localized text for values such as Yes, No, All, Void, N/A, "No Data Exists", and "End of Report." The user specifically searched for c_nls_void_p, which is the function that returns the localized string used to represent a voided payment or void status within the Tolerance Report output.

Key Procedures and Functions

The package exposes seventeen documented procedures and functions. Initialization and data-retrieval routines include:

• GET_BASE_CURR_DATA — Retrieves base currency information, used to format monetary values consistently in the report.
• CUSTOM_INIT — Performs report-specific setup before execution begins.
• GET_COVER_PAGE_VALUES — Populates the cover page parameters and header values of the report.
• GET_NLS_STRINGS — Loads the translated literal strings into the C_NLS_* global variables.
• BEFOREREPORT — The standard XML Publisher user exit invoked before report execution; orchestrates the initialization sequence.
• TOLERANCE_HOLD_NAMES — Resolves and returns the descriptive names for tolerance hold reasons used by the report.
• AFTERREPORT — Standard user exit invoked after report completion for cleanup.

Each C_NLS_* global has a matching getter function: 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. These allow the report layout to reference the localized value at runtime. C_REPORT_START_DATE_P and C_COMPANY_NAME_HEADER_P return the report start date and the company name header respectively, while APPLICATIONS_TEMPLATE_REPORT_P returns the template report indicator.

Tables Accessed

Per the ETRM metadata, the package references two tables through APPS synonyms:

• AP_SYSTEM_PARAMETERS — Read to obtain Payables system-level settings, including base currency and organization defaults used in report formatting and header display.
• FND_CURRENCIES — Read to resolve currency codes and descriptions for monetary columns in the Tolerance Report.

Both tables are accessed read-only during report initialization and data retrieval; the package does not write to application data tables.

Usage Notes

This package is not intended for direct invocation by custom code. It is executed automatically when the APXTOLRP concurrent program runs, with the XML Publisher engine calling BEFOREREPORT and AFTERREPORT as user exits and invoking the getter functions from within the RTF or XSL-FO template. Because it is a generated artifact, any customization should be applied to the underlying report definition and data model rather than to this package, since regeneration will overwrite changes. The package is not referenced by any other PL/SQL package, confirming its role as a leaf-level runtime component tied solely to its own report. In 12.2.2 the same structure is retained, with the package still owned by APPS and still resolving AP_SYSTEM_PARAMETERS and FND_CURRENCIES through synonyms.