Search Results c_nls_na

Overview

APPS.AP_APXINROH_XMLP_PKG is the report-generation package body supporting the Oracle Payables Invoice Register and related XML Publisher (BI Publisher) concurrent programs in Oracle E-Business Suite 12.1.1 and 12.2.2. The package encapsulates the data preparation, parameter defaulting, and localized string retrieval logic required before the report template is rendered. It is classified under the ETRM as an "OTHER" API, indicating it is not a public, callable business API but rather an internal report driver generated by the Oracle Reports-to-XML Publisher conversion tooling. Its primary responsibilities include resolving the base currency configuration for the operating unit, interpreting user-supplied date parameters into the correct semantics for due date versus discount date filtering, and populating NLS (National Language Support) display strings used throughout the report layout. A distinctive characteristic of this package is the use of PL/SQL function-based columns and package-level variables (prefixed with "c_") that expose computed values directly to the XML Publisher data model as bind or group parameters.

Key Procedures and Functions

The package exposes 34 documented procedures and functions, several of which warrant individual attention. GET_NLS_STRINGS is directly relevant to the user search term "c_nls_na": it queries FND_LOOKUPS and AP_LOOKUP_CODES to populate localized display values including nls_all, nls_na, nls_no_desc, nls_yes, and nls_no, assigning the "Not Applicable" text to the nls_na variable used for null or inapplicable report fields. GET_BASE_CURR_DATA retrieves the base currency code, precision, minimum accountable unit, and description from AP_SYSTEM_PARAMETERS and FND_CURRENCIES_VL, storing them in package variables c_base_currency_code, c_base_precision, c_base_min_acct_unit, and c_base_description. CUSTOM_INIT interprets the P_DATE_PAR parameter: when it equals 'Discount Date', the start and end discount date parameters are derived from P_START_DATE and P_END_DATE; otherwise the due date parameters are assigned. BEFOREREPORT and AFTERREPORT provide the standard pre- and post-processing hooks invoked by the report engine. GET_COMPANY_NAME and GET_FLEXDATA resolve organizational and descriptive flexfield presentation values. GET_PARAMETER_DISP_VALUE returns the display value for a given parameter for the report header. The "c_" prefixed functions such as C_ORDER_BYFORMULA, C_ORDER_BY1FORMULA, C_REP_TOTAL_COUNTFORMULA, C_REP_TOTAL_REMAININGFORMULA, C_REP_TOTAL_ORIGINALFORMULA, and C_VENDOR_CLAUSEFORMULA supply computed SELECT clauses, ordering clauses, and summary totals to the report query. The remaining functions (C_BASE_CURRENCY_CODE_P, C_BASE_PRECISION_P, C_BASE_MIN_ACCT_UNIT_P, C_BASE_DESCRIPTION_P, C_COMPANY_NAME_HEADER_P) are accessor functions returning the package variable values to the report data model.

Tables Accessed

The package reads from AP_SYSTEM_PARAMETERS, joined to FND_CURRENCIES_VL, to obtain the base currency configuration. It queries AP_LOOKUP_CODES and FND_LOOKUPS for NLS string resolution. HZ_PARTIES is referenced in conjunction with party-level lookups, typically in support of vendor name or party display within the report output. No insert, update, or delete operations are performed; the package is strictly read-only against these tables.

Usage Notes

The package is invoked automatically by the XML Publisher concurrent program that renders the Invoice Register report. It is not intended for direct invocation from forms or custom code, and the ETRM metadata confirms it is referenced by zero other packages. Customizations should avoid modifying this seeded package body; instead, the underlying report definition or data template should be extended. Because the package relies on FND_LOOKUPS for NLS strings, administrators must ensure lookup values for the YES_NO and related lookup types are defined for every installed language; the "c_nls_na" value in particular depends on a valid AP_LOOKUP_CODES entry for the "Not Applicable" displayed_field.