Search Results le_address_line_1formula

Overview

APPS.JG_JGZZGLJRN_XMLP_PKG is the generated PL/SQL package that backs the Oracle EBS Global Accounting Journal report (JGZZGLJRN), a global ledger journal listing used in globalization and multi-organization environments. The package follows the standard Oracle Reports XML Publisher (XMLP) architecture in Release 12.1.1 and 12.2.2, in which a report's data model is implemented as a PL/SQL package owned by APPS, with the report executable invoking the package's BEFOREREPORT and AFTERREPORT entry points and the packaged functions supplying formula columns to the report layout.

The package's declared variables expose the report's parameter surface: ledger, access set, chart of accounts, period range, currency, balance type, budget/encumbrance type, account ranges, journal source and category, batch name, and document sequence ranges. Dynamically constructed WHERE-clause variables (DAS_WHERE, CURR_WHERE_JRNL, PERIOD_WHERE, ACCT_WHERE) support runtime filtering, while SELECT_ACCOUNT builds a concatenated multi-segment account display string spanning SEGMENT1 through SEGMENT30.

Key Procedures and Functions

The package exposes 89 documented procedures and functions. The following are the most relevant to the legal entity and ledger context:

• BEFOREREPORT / AFTERREPORT — Standard XMLP lifecycle hooks that initialize parameters and perform cleanup before and after report execution.
• LEGAL_ENTITY_IDFORMULA — Supplies the legal entity identifier for the report output. This is the object surfaced by the search term "legal_entity_idformula".
• LEGAL_ENTITY_NAMEFORMULA — Derives the legal entity name for display in the report header or column.
• GET_LE_INFO — Retrieves legal entity attributes used by the LE_* formula functions.
• LE_ADDRESS_LINE_1FORMULA, LE_ADDRESS_LINE_2FORMULA, LE_ADDRESS_LINE_3FORMULA, LE_CITYFORMULA, LE_POSTAL_CODEFORMULA — Format the legal entity's address into report layout elements.
• LE_REGISTRATION_NUMBERFORMULA, LE_ACTIVITY_CODEFORMULA — Expose the legal entity's registration number and activity code.
• SECONDARY_TRACK_SEGMENT_DESCFO — Resolves descriptive text for the secondary tracking segment.
• CF_LEDGER_NAMEFORMULA — Produces the ledger name used in report output.
• GET_EFF_PERIOD_NUM — Determines the effective period number for the selected ledger and period range.
• DATA_ACCESS_SET_NAME_P, CHART_OF_ACCOUNTS_ID_P, DAS_WHERE_P, CURR_WHERE_JRNL_P, PERIOD_WHERE_P — Populate the package-level variables that drive data access set filtering, chart of accounts, currency, and period predicates.

Tables Accessed

The package reads the following APPS synonyms:

• FND_DOCUMENT_SEQUENCES — Validates and resolves document sequence names and value ranges.
• GL_ACCESS_SETS — Resolves the data access set used to restrict ledger and balancing segment access.
• GL_JE_CATEGORIES and GL_JE_SOURCES — Supply journal category and source descriptions for filtering and display.
• GL_LEDGERS — Provides ledger name, chart of accounts, and currency attributes.
• GL_LEDGER_CONFIG_DETAILS — Identifies the legal entity associated with the ledger configuration.
• GL_LEDGER_NORM_SEG_VALS — Stores segment value assignments used to derive legal entity context.
• GL_PERIODS — Resolves period names and effective period numbers for the selected range.
• DUAL — Used for single-row computations in formula functions.

Usage Notes

JG_JGZZGLJRN_XMLP_PKG is invoked exclusively by the Global Accounting Journal report concurrent program. It is not referenced by any other package (Referenced by 0 other packages), so it is not intended for direct API consumption. Because the package is generated by Oracle Reports and is marked "noship" in its header, it should not be modified; customizations should be applied to a copy or through supported report parameters. The package was last updated in the 12.1.x code line and remains present in 12.2.2 for backward compatibility with the JGZZGLJRN report. The legal entity formula functions exist primarily to satisfy localization and statutory reporting requirements where the legal entity identity must appear on the printed journal listing.