Search Results tolerance_hold_names




Overview
Explore in AI Chat

Overview

APPS.AP_APXTOLRP_XMLP_PKG is the generated PL/SQL package body that supports the Oracle Payables Invoice Tolerance Report (APXTOLRP), an XML Publisher (BI Publisher) concurrent program report. In Oracle EBS 12.1.1 and 12.2.2 this package follows the standard XML Publisher report package pattern: a specification declares global variables and function signatures, and the body implements the server-side logic invoked at report runtime by the Oracle Reports/XML Publisher integration layer. Its purpose is to retrieve report parameter values, resolve NLS (National Language Support) display strings, populate cover-page and header values, and expose a set of constant accessor functions used to embed translated labels and report metadata into the generated XML output.

Key Procedures and Functions

The package body exposes seventeen documented program units. The principal data-retrieval functions are:

  • GET_BASE_CURR_DATA — Retrieves base currency information (base currency code, precision, minimum accountable unit, and description) from AP_SYSTEM_PARAMETERS and FND_CURRENCIES for use in report formatting and amount display.
  • CUSTOM_INIT — Performs custom initialization of package-level state before the report executes.
  • GET_COVER_PAGE_VALUES — Populates the cover-page values presented at the beginning of the report output.
  • GET_NLS_STRINGS — Resolves translated display strings via FND_LOOKUPS ('YES_NO') and AP_LOOKUP_CODES ('NLS REPORT PARAMETER', 'NLS TRANSLATION'), assigning C_NLS_YES, C_NLS_NO, C_NLS_ALL, C_NLS_VOID, and C_NLS_NA.
  • BEFOREREPORT — Standard XML Publisher before-report trigger that orchestrates initialization and parameter setup prior to data retrieval.
  • TOLERANCE_HOLD_NAMES — Derives the human-readable names of tolerance holds applied to invoices, supporting the report's core purpose of showing invoices held for exceeding tolerance limits. This is the function associated with the user search term.
  • AFTERREPORT — Standard after-report trigger for cleanup or final output processing.

The remaining ten functions are constant accessors returning report metadata and localized labels: 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, C_NLS_END_OF_REPORT_P, C_REPORT_START_DATE_P, C_COMPANY_NAME_HEADER_P, and APPLICATIONS_TEMPLATE_REPORT_P.

Tables Accessed

  • AP_SYSTEM_PARAMETERS — Read to obtain the base currency code configured for the Payables application, essential for correct monetary formatting of tolerance amounts.
  • FND_CURRENCIES — Read to obtain currency precision and minimum accountable unit for the base currency, ensuring amounts are rendered with the correct number of decimal places.

Additional lookup data is drawn from FND_LOOKUPS and AP_LOOKUP_CODES for NLS string resolution. The report does not maintain persistent state; all access is read-only.

Usage Notes

This package is invoked indirectly by the Oracle Payables Invoice Tolerance Report concurrent program through the XML Publisher runtime. It is not referenced by any other PL/SQL package; there are zero documented dependent packages, confirming its role as a report-specific implementation package rather than a shared API. Customizations should not modify this package body directly. Client-specific extensions are more appropriately implemented through XML Publisher data templates, custom report templates, or a cloned concurrent program. Given the header date of 2007, the logic is stable across 12.1.1 and 12.2.2, and the TOLERANCE_HOLD_NAMES routine remains the key logic for interpreting hold reason names on the report output.