Search Results get_parameter_disp_value

Overview

APPS.AP_APXINROH_XMLP_PKG is the generated PL/SQL package that underpins the Oracle Payables Invoice Register and Invoice On-Hold reports in Oracle E-Business Suite 12.1.1 and 12.2.2. These reports are registered as concurrent programs and are executed through the Oracle Reports Server, which invokes the package entry points BeforeReport and AfterReport to compute report-level values, resolve parameters, and populate global variables used by the report layout. The package is declared AUTHID CURRENT_USER and executes under the privileges of the APPS schema. Its role is strictly report-supporting: it retrieves system parameter and party information, derives NLS strings for translated column headings and messages, formats the accounting flexfield display, and exposes the SELECT statements and group filters that populate the report data model.

Key Procedures and Functions

The 34 documented functions and procedures fall into four functional groups.

• Initialization and driver functions: CUSTOM_INIT, BEFOREREPORT, and AFTERREPORT are the report trigger entry points that set up globals, resolve the report run context, and clean up state after execution.
• Data retrieval functions: GET_BASE_CURR_DATA, GET_COVER_PAGE_VALUES, GET_COMPANY_NAME, GET_FLEXDATA, and GET_PARAMETER_DISP_VALUE populate the cover page, currency precision, company header name, and accounting flexfield display values that appear on the report output.
• NLS and localization functions: GET_NLS_STRINGS returns translated literals such as C_NLS_YES, C_NLS_NO, C_NLS_ALL, C_NLS_NA, C_NLS_NO_DATA_EXISTS, and C_NLS_END_OF_REPORT that are used throughout the layout.
• Formula column functions: C_ORDER_BYFORMULA, C_ORDER_BY1FORMULA, C_REP_TOTAL_COUNTFORMULA, C_REP_TOTAL_REMAININGFORMULA, C_REP_TOTAL_ORIGINALFORMULA, and C_VENDOR_CLAUSEFORMULA correspond to formula columns in the report data model. C_VENDOR_CLAUSEFORMULA is the formula queried by the user; it produces the vendor selection clause that is appended to the report query to restrict the invoice register to a specific vendor or party. The remaining formulas build the ORDER BY sort string and subtotal aggregations for count, remaining amount, and original amount.
• Parameter helper cursors: functions such as C_BASE_CURRENCY_CODE_P, C_BASE_PRECISION_P, C_BASE_MIN_ACCT_UNIT_P, C_BASE_DESCRIPTION_P, and C_COMPANY_NAME_HEADER_P return individual values that populate the corresponding package-level globals used by the report layout.

Tables Accessed

The package reads two documented tables through APPS synonyms.

• AP_SYSTEM_PARAMETERS — Provides the set of books context, base currency code, precision, minimum accounting unit, and description used by GET_BASE_CURR_DATA and related parameter functions.
• HZ_PARTIES — Supplies party and vendor name information used to build the vendor clause and to resolve CP_PARTY_NAME for the report heading.

The package does not write to these tables; all access is read-only for reporting purposes.

Usage Notes

AP_APXINROH_XMLP_PKG is invoked exclusively by the Invoice Register and Invoice On-Hold concurrent programs when the user submits the report from the Payables responsibility. It is not intended to be called from custom forms or third-party code. Because the package is AUTHID CURRENT_USER, callers must connect as APPS or a user granted execute on the package with the required AP and HZ privileges. Customizations should be limited to the underlying report definition or to extensions placed in custom packages, since the APXINROH package is regenerated by the Reports compiler and any direct modification will be overwritten during patching.