Search Results acct_level1_valueformula

Overview

The APPS.JG_JGZZGLJRB_XMLP_PKG package is a PL/SQL specification and body that backs an Oracle E-Business Suite concurrent program in the Global (JG) product family. In Oracle EBS 12.1.1 and 12.2.2, the JG product handles global tax, legal entity, and localization reporting requirements, and the _XMLP_PKG naming suffix identifies a package generated to support an XML Publisher (BI Publisher) report. The internal name fragment JGZZGLJRB is characteristic of a translated (Chinese localization) report identifier, and the package is bound to a specific XML Publisher template. Its role is to resolve and format the runtime data the report template requires — most significantly legal entity registration details and the multi-level accounting flexfield structure — before the XML output is rendered. The package status is VALID under the APPS schema, and it is classified as an OTHER API rather than a public (OPEN) API, meaning it is intended for internal use by the report and not for direct customer invocation.

Key Procedures and Functions

The package exposes 91 documented program units oriented around the before/after report triggers and the value resolution required by the XML template. The principal logical groups are:

• Report lifecycle triggers — BEFOREREPORT and AFTERREPORT initialize session context and clean up after execution.
• Legal entity functions — GET_LE_INFO and the LE_*FORMULA functions (LEGAL_ENTITY_NAMEFORMULA, LE_ADDRESS_LINE_1FORMULA, LE_ADDRESS_LINE_2FORMULA, LE_ADDRESS_LINE_3FORMULA, LE_CITYFORMULA, LE_POSTAL_CODEFORMULA, LE_REGISTRATION_NUMBERFORMULA, LE_ACTIVITY_CODEFORMULA) return the legal entity name, address, registration number, and activity code for display in the report header and detail sections.
• Accounting flexfield functions — the ACCT_LEVEL1_VALUEFORMULA through ACCT_LEVEL5_VALUEFORMULA functions and their associated ACCT_LEVELn_VALUE_DESCFORMULA counterparts resolve the value and description of each accounting key flexfield segment for up to five segment levels.

No parameter signatures are exposed in the metadata; the functions are called by the XML Publisher template using standard group-element formula syntax.

Tables Accessed

The package reads the following tables through APPS synonyms:

• GL_LEDGERS, GL_LEDGER_CONFIGURATIONS, and GL_LEDGER_CONFIG_DETAILS — to identify the ledger and its configuration, including the legal entity assigned to the ledger.
• GL_ACCESS_SETS — to resolve the chart of accounts and accounting flexfield structure used by the ledger.
• FND_ID_FLEX_SEGMENTS — to obtain segment names, ordering, and value set assignments for the accounting key flexfield.
• GL_PERIOD_STATUSES — to determine the open/closed status and period context for the reporting range.
• DUAL — used for single-row calculations and constant resolution.

The package is primarily read-only against these tables; no DML against application data is documented.

Usage Notes

This package is invoked indirectly. In a standard deployment, a user submits the associated JG XML Publisher concurrent program, the Oracle Reports/XML Publisher engine calls BEFOREREPORT, executes the report query, and the template invokes the formula functions to populate the output. The package is not referenced by any other package (referenced by 0 packages), so it should not be treated as a shared API. Customizations should be limited to the underlying XML template or a clone of the package with a distinct name; direct modification of APPS.JG_JGZZGLJRB_XMLP_PKG is not supported and will be overwritten by patching or upgrade in 12.1.1 or 12.2.2.