Search Results jg_jgzzgljrn_xmlp_pkg




Overview
Explore in AI Chat

Overview

APPS.JG_JGZZGLJRN_XMLP_PKG is the packaged backend of a Global Accounting (JG) XML Publisher concurrent report that produces a general journal listing. The package body coordinates report execution by resolving user-supplied report parameters into the bind and lexical variables consumed by the report's underlying SQL query, then delegating output rendering to the XML Publisher engine. Its scope spans ledger (or ledger set) selection, data access set validation, chart of accounts resolution, period and currency filtering, and legal entity address/registration information used for statutory reporting headers.

The package belongs to the Global Accounting localized reporting layer, which is significant for installations using Global Ledger or country-specific journal reporting requirements. The embedded header comment ($Header: JGZZGLJRNB.pls 120.2 2007/12/25 16:06:35 npannamp noship $) indicates the source is marked "noship" — that is, it is not shipped as part of the standard product but delivered as a localized or customer-requested concurrent program, consistent with its APPS ownership and OTHER API classification.

Key Procedures and Functions

The documented package exposes 89 procedures and functions, most of which follow the XML Publisher formula-column convention (names suffixed with FORMULA) and parameter-resolution convention (names suffixed with _P).

Tables Accessed

The package reads (and does not directly write) from the following APPS synonyms:

The tables referenced list notably does not include GL_JE_HEADERS or GL_JE_LINES; those are referenced directly by the report's own SQL query (the data model), not by this package body.

Usage Notes

This package is invoked implicitly by the XML Publisher concurrent program associated with the JGZZGLJRN report definition. Administrators run it from the Submit Request form or via FND_REQUEST.SUBMIT_REQUEST, supplying parameters such as ledger or ledger set, data access set, period, currency, and journal source/category. The BEFOREREPORT trigger fires before the data model executes, so any parameter errors (invalid access set, missing ledger) surface as report-level warnings. Because the source is marked "noship," the package should be treated as a localized extension; upgrades should verify version 120.2 or later remains compatible with the EBS 12.1.1/12.2.2 GL and JG schema. The unrelated search term gl_je_headers_u1 refers to the unique index on GL_JE_HEADERS and is not manipulated by this package; journal header rows are read by the report's SQL, not here.