Search Results jl_jlcoarcr_xmlp_pkg




Overview
Explore in AI Chat

Overview

JL_JLCOARCR_XMLP_PKG is an Oracle EBS PL/SQL package owned by the APPS schema and is classified as an "OTHER" API. It serves as the backend database package for the JLCOARCR concurrent program report—the Oracle Latin American (JL) Accounts Receivable Collection Advice / Receipt Confirmation Report. The package is generated in the standard Oracle Reports XML Publisher (XMLP) pattern, where the concurrent program invokes a report whose data model and formula columns are backed by a PL/SQL package stored in the database. It declares a declaration section of public package-level variables that mirror the report's concurrent program parameters (such as P_CUSTOMER_NUMBER_FROM, P_RECEIPT_DATE_FROM, P_PAYMENT_METHOD, P_SET_OF_BOOKS_ID, and P_LEGAL_ENTITY_ID) plus output/derived globals (C_FUNC_CURRENCY, C_PRECISION, C_SOB_NAME, C_REPORT_RUN_TIME, VLOCATION_ID, COMPANY_NAME, NIT_NUMBER). The package's core responsibility is to resolve set-of-books and currency information, convert numeric amounts to words, and expose report formula helper functions that render statutory data for Latin American localization reporting.

Key Procedures and Functions

  • GL_GET_SET_OF_BOOKS_INFO — procedure that resolves set-of-books metadata (chart of accounts ID, set-of-books name, and functional currency) for the report's operating context.
  • GET_INFO — procedure that determines currency precision and minimum accounting unit details for the currency code passed in.
  • BEFOREREPORT — standard XML Publisher before-report function; initializes package state before report execution.
  • AFTERREPORT — standard XML Publisher after-report function; performs post-report cleanup or finalization.
  • CONVERT_NUMBER2 — function that converts a numeric segment value into its character representation.
  • CONVERT_NUMBER — function that converts an integer into a character (spelled-out) representation.
  • GET_WORD_VALUE — function that returns the word form of an amount using supplied unit/sub-unit singular and plural labels and a unit ratio, used for check-printing style amount-in-words rendering.
  • PRECISION — function that returns the precision for a given currency code.
  • CF_INVOICE_NUMFORMULA — report formula function that formats the invoice number for display.
  • VLOCATION_ID_P, COMPANY_NAME_P, NIT_NUMBER_P, DIGIT_VERIF_P, VADDRESS1_P, 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 — report formula accessor functions that expose the corresponding package globals to the report layout.

Tables Accessed

The package references two documented objects via APPS synonyms:

  • HZ_GEOGRAPHIES — the TCA geography table, used to resolve location/address geography information associated with the VLOCATION_ID and the customer address globals (VADDRESS1, VTOWN_CITY, VREGION, VCOUNTRY).
  • DUAL — used for single-row arithmetic and numeric/currency conversion validation logic.

Usage Notes

This package is invoked exclusively as the supporting database package for the JLCOARCR concurrent program/report in Oracle EBS 12.1.1 and 12.2.2. It is not designed as a public API and is referenced by zero other packages, confirming it is a report-specific implementation artifact. Concurrent program submission passes the report's parameters to the package variables, then BEFOREREPORT initializes set-of-books and currency contexts, the report query executes, formula columns call the CF_ and _P accessor functions, and AFTERREPORT finalizes. The VLOCATION_ID / VLOCATION_ID_P token appears when resolving the legal entity or customer location for the Latin American receipt/collection advice layout. Customizations should treat it as a non-public object and avoid direct calls, since it is regenerated with the report definition.