Search Results cp_comp_nit_verf_dig_p

Overview

APPS.JL_JLCOGLNM_XMLP_PKG is a report-support package body associated with the Oracle E-Business Suite (EBS) localization extract for the JL_CO_GL_MG_LITERALS dataset, used within the general ledger localized reporting flow (JLCOGLNM). In Oracle EBS 12.1.1 and 12.2.2, XML Publisher (XMLP) concurrent programs commonly rely on a companion PL/SQL package generated from an Oracle Reports source. This package encapsulates the server-side logic required to initialize report parameters, retrieve literals and company identification data, and compute derived formula columns consumed by the XML Publisher template. The business purpose is to produce a statutory or tax-oriented general ledger listing keyed to a legal entity, set of books, and reported year, resolving literal code ranges dynamically so the report reflects the correct scope for the selected accounting context. The package reads first-party legal entity information to populate the report title and company tax identifier, and derives default literal start/end boundaries when the user does not supply them.

Key Procedures and Functions

The documented package exposes eight procedures and functions, oriented around the standard Oracle Reports XMLP execution model:

• BEFOREREPORT — Initializes the report context. It captures the concurrent request identifier, validates that the reported year is supplied (raising an application error when absent), resolves default literal start and end values from the literal table, derives the currency code from the set of books, and populates the report subtitle and company NIT (registration number) from legal entity information.
• AFTERREPORT — Performs report-termination cleanup and returns success; in the XMLP form it is essentially a placeholder that preserves the Oracle Reports post-report trigger contract.
• CF_TOTALFORMULA — A report formula column that computes the total value presented in the report output.
• CP_COMP_NIT_P — A report-level parameter (placeholder) carrying the company NIT / registration number resolved during BEFOREREPORT from the first-party information view. The search term "cp_comp_nit_p" refers directly to this documented element.
• CP_COMP_NIT_VERF_DIG_P — A report-level parameter holding the verification digit associated with the company NIT.
• CP_LITERAL_START_P — A report-level parameter exposing the resolved starting literal code, either user-supplied or derived as the minimum literal for the year and set of books.
• CP_LITERAL_END_P — A report-level parameter exposing the resolved ending literal code, either user-supplied or derived as the maximum literal for the year and set of books.
• CP_TOTAL_P — A report-level parameter carrying the accumulated or computed total passed to the report layout.

Tables Accessed

The package accesses the documented table JL_CO_GL_MG_LITERALS via its APPS synonym. This table stores literal code records keyed by reported year and set of books. BEFOREREPORT queries it using MIN and MAX aggregation to establish default literal range boundaries when the user does not specify them, defaulting to 0 and 9999 respectively when no rows qualify. Additional reads (noted in the source excerpt but not enumerated in the documented table list) include GL_SETS_OF_BOOKS for currency code and report subtitle fallback, and XLE_FIRSTPARTY_INFORMATION_V for the company name and registration number.

Usage Notes

This package body is invoked automatically by the Oracle Reports/XML Publisher runtime when the JLCOGLNM concurrent program is submitted. It is not intended for direct call from Oracle Forms or custom application code. The documented procedures and functions are triggered by the report's Before Report and After Report events, and the CP_* elements are report parameters binding report logic to the XML template. The package is referenced by zero other packages, confirming that it functions exclusively as the runtime scaffold for its associated XMLP report definition. Any modification should be treated as a localization-sensitive change and tested against both 12.1.1 and 12.2.2 environments.