Search Results from_lnsv

Overview

APPS.JG_JGZZGLJRB_XMLP_PKG is the package body that implements the server-side PL/SQL logic for the Oracle E-Business Suite concurrent program report associated with the JG (Global Accounting) module, specifically the "JGZZGLJRB" report — a legal entity / ledger journal report. Within the EBS 12.1.1 and 12.2.2 architectures, XML Publisher (BI Publisher) concurrent programs are typically driven by an auto-generated package that conforms to the Oracle Reports-to-XML Publisher bridge pattern: a package specification matching an XML template, accompanied by this package body that holds all procedural logic, cursors, and column-formula functions.

The primary business purpose of the package is to resolve and expose legal entity information tied to a General Ledger ledger and its accounting configuration. It determines whether the ledger operates in an EXCLUSIVE or SHARED accounting environment, then builds the appropriate SQL fragments and values used to report legal entity names, addresses, and registration data. It also resolves the accounting flexfield structure used to render account level values on the report.

Key Procedures and Functions

The package exposes 91 documented program units. The central routine is BEFOREREPORT, a function that executes before the report renders. It captures the concurrent request ID via FND_GLOBAL, assigns the start and end date parameters, records a report execution timestamp, resolves the data access set name and ledger name, and inspects the ledger's accounting environment code. Based on the value returned (EXCLUSIVE or SHARED), it constructs registry variables such as SELECT_LE, FROM_LNSV, and LE_WHERE that downstream queries use to join legal entity information correctly. AFTERREPORT provides the complementary post-processing hook.

The user-searched function GET_LE_INFO belongs to a group of legal entity value functions. Related routines include LEGAL_ENTITY_NAMEFORMULA, LE_ADDRESS_LINE_1FORMULA through LE_ADDRESS_LINE_3FORMULA, LE_CITYFORMULA, LE_POSTAL_CODEFORMULA, LE_REGISTRATION_NUMBERFORMULA, and LE_ACTIVITY_CODEFORMULA. These are XML Publisher "formula" columns that fetch and format legal entity attributes for display in the report layout.

The accounting-level functions — ACCT_LEVEL1_VALUEFORMULA through ACCT_LEVEL5_VALUEFORMULA and their matching ACCT_LEVELn_VALUE_DESCFORMULA counterparts — resolve accounting flexfield segment values and their descriptions for up to five levels of the accounting structure. Additional documented units follow this same naming convention for further columns of the report.

Tables Accessed

• GL_LEDGERS — supplies the ledger configuration and ledger name for the selected LEDGER_ID.
• GL_LEDGER_CONFIGURATIONS — provides the ACCTG_ENVIRONMENT_CODE that determines EXCLUSIVE versus SHARED behavior.
• GL_LEDGER_CONFIG_DETAILS — retrieves the legal entity OBJECT_ID when the environment is EXCLUSIVE (OBJECT_TYPE_CODE = 'LEGAL_ENTITY').
• GL_ACCESS_SETS — resolves the access set name from P_ACCESS_SET_ID.
• FND_ID_FLEX_SEGMENTS — supports accounting flexfield segment resolution for the level value formulas.
• GL_PERIOD_STATUSES — provides period status context for the reporting period.
• DUAL — used to generate the report execution timestamp.

Usage Notes

This package is invoked implicitly by the EBS concurrent program framework when the JGZZGLJRB XML Publisher report is executed. Users do not call it directly; instead, the concurrent manager launches the report, passing parameters such as P_LEDGER_ID, P_START_DATE, P_END_DATE, and P_ACCESS_SET_ID. The BEFOREREPORT hook fires once per execution to establish session context. The registered tables are all accessed through APPS synonyms, and the package is referenced by zero other packages, confirming it is a standalone report driver. The GET_LE_INFO family of routines is documented specifically to support legal entity reporting fields, and its behavior is governed by the EXCLUSIVE/SHARED decision made in BEFOREREPORT.