Search Results g_ledger_id

Overview

JG_ZZ_AUDIT_GL_PKG is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It is the default data template package for the Audit GL reports, which fall under the Oracle Financials for India (JG) localization layer and support VAT and tax reporting requirements. Its primary responsibility is to assemble and prepare report data — encompassing legal entity, ledger, tax calendar, and taxpayer identifier information — before the Audit GL report output is generated by Oracle Reports or an equivalent reporting engine. The package is classified as OTHER in the ETRM metadata and is not published as a public API for general application use.

Key Procedures and Functions

The package body exposes the following documented program units:

• BEFOREREPORT — The report-level entry point invoked prior to report execution. It performs setup and data preparation using local variables such as the functional currency code, reporting legal entity and its identifier, transaction number, period start and end dates, reporting mode, and taxpayer identifier derived from jg_zz_vat records. This function governs the initialization flow that the remaining helper functions support.
• GET_LEDGER_ID — Returns the ledger identifier used to constrain the audit data set for the report run. This corresponds directly to the search term g_ledger_id and is the mechanism through which the report resolves which ledger's accounting and tax entries are audited. Callers rely on this function to avoid hard-coding a ledger in report queries or templates.
• GET_ENTITY_IDENTIFIER — Resolves the identifier associated with the reporting legal entity or registered tax entity, supplying the entity context required for VAT register and audit GL reporting.
• GET_TAX_CALENDAR_NAME — Returns the tax calendar name applicable to the reporting configuration, enabling the report to align periods with the correct tax calendar rather than the accounting calendar alone.

Tables Accessed

The package reads and writes the following tables through APPS synonyms:

• JG_ZZ_VAT_REP_ENTITIES and XLE_REGISTRATIONS — supply registered reporting entities and legal entity registration data used to derive entity and ledger context.
• JG_ZZ_VAT_TRX_DETAILS and JG_ZZ_VAT_TRX_GT — hold VAT transaction details and the global temporary table populated during report processing; the global temporary table is used to stage audit data, including the taxpayer identifier (stored as a character value in jg_info_v17 per the change record for Bug 5192284).
• HZ_PARTIES, HZ_LOCATIONS, and HZ_CONTACT_POINTS — provide party, location, and contact information used for entity identification and report presentation.

Usage Notes

JG_ZZ_AUDIT_GL_PKG is invoked indirectly through the Audit GL report data template rather than by ad hoc application code. The BEFOREREPORT function is called automatically by the reporting tool at run time, and the helper functions are consumed internally during that execution. Because the ETRM metadata records no dependent packages referencing this package, it should be treated as an internal localization component. Customizations should be limited to report templates or cloning the logic, as direct modifications to the APPS-owned package body are not supported and would be overwritten by patching.