Search Results convert_number2

Overview

APPS.JL_JLCOARCR_XMLP_PKG is the generated PL/SQL package body that backs the Oracle E-Business Suite XML Publisher concurrent program JLCOARCR (the Argentine Legal Company report, related to the JL (Latin America Localizations) product family). The body is stored under the APPS schema and is marked "noship," indicating it is an internal, non-shipped object generated by the XML Publisher report builder for the source file JLCOARCRB.pls. Its primary business function is to gather the company-level data required to render an Argentine legal document — legal entity name, tax identification (NIT), registered address, and city — and to expose the formatting and numeric-to-words conversion logic that the report layout requires. In Oracle EBS 12.1.1 and 12.2.2, this package follows the standard XML Publisher wrapper pattern: a BEFOREREPORT routine establishes the concurrent request context and set-of-books information, and a series of getter/setter wrappers expose report parameters and derived values to the RTF template.

Key Procedures and Functions

The package exposes 59 documented procedures and functions. The initialization and context routines include BEFOREREPORT, which captures the concurrent request ID via FND_GLOBAL and calls GL_GET_SET_OF_BOOKS_INFO to populate the chart of accounts, set-of-books name, and functional currency, and AFTERREPORT, the complementary teardown hook. GL_GET_SET_OF_BOOKS_INFO and GET_INFO retrieve set-of-books metadata and precision/minimum account unit settings respectively.

The numeric formatting and lexical conversion routines form the reporting core: CONVERT_NUMBER2 and CONVERT_NUMBER perform numeric-to-words conversion (the object referenced by the "convert_number2" search), while GET_WORD_VALUE supplies the corresponding word token for a numeric value and PRECISION returns currency precision used to drive decimal placement. CF_INVOICE_NUMFORMULA is a formula column function that supplies the invoice number value to the template.

The remaining documented members are the conventional XML Publisher parameter accessors: C_FUNC_CURRENCY_P, C_PRECISION_P, C_STRUCT_NUM_P, C_SOB_NAME_P, C_REPORT_START_DATE_P, C_REPORT_RUN_TIME_P, VLOCATION_ID_P, COMPANY_NAME_P, NIT_NUMBER_P, DIGIT_VERIF_P, and VADDRESS1_P, each of which exposes a package-level variable to the report data model.

Tables Accessed

The package reads from HZ_GEOGRAPHIES (via APPS synonym) to resolve the geography name and validate the city/region/country combination associated with the legal entity's primary location; this supports the printed address block. DUAL is referenced for single-row scalar evaluation. The excerpt additionally shows joins against HR_LOCATIONS and XLE_FIRSTPARTY_INFORMATION_V to obtain the legal entity name, NIT registration number, and address lines, with exception handlers supplying placeholder text when no legal entity row is found.

Usage Notes

JL_JLCOARCR_XMLP_PKG is invoked indirectly: the concurrent program JLCOARCR calls the package's BEFOREREPORT and AFTERREPORT hooks, and the XML Publisher engine calls the getter functions and CONVERT_NUMBER/CONVERT_NUMBER2 during template rendering. The package is not a public API — ETRM records zero packages referencing it — so it should not be called from custom forms or third-party code. Customization is appropriate only through the underlying report definition and template, not by modifying the generated package body.