Search Results jg_jgzzfale_xmlp_pkg




Overview
Explore in AI Chat

Overview

The APPS.JG_JGZZFALE_XMLP_PKG package is the generated PL/SQL package body that supports an Oracle Reports XML Publisher (XMLP) concurrent program within Oracle E-Business Suite. Based on its owner (APPS) and naming convention (_XMLP_PKG), it serves as the server-side PL/SQL wrapper for a report executable, exposing package-level globals (report parameters, lexical parameters, and layout columns) and the standard report trigger entry points that Oracle Reports invokes at runtime. The JG_ prefix associates the object with the Oracle Financials for EMEA (Global Accounting) product family, and the JGZZFALE report identifier indicates a statutory/general ledger financial statement extract. In EBS 12.1.1 and 12.2.2 this package exists in the same form; it is documented in ETRM 12.2.2 with an API classification of OTHER, meaning it is not a public or private API intended for customer extension but is instead a report-support artifact.

Key Procedures and Functions

The package declares 16 documented procedures and functions. Two are the report-level triggers: BEFOREREPORT, which executes prior to report data retrieval, and AFTERREPORT, which runs after the report completes. Together these typically initialize package globals, validate parameters, and populate report header values. CF_PARENT_ACCT_DESCRFORMULA is a group/column formula function used to derive a parent-account description from a supplied parent account value, and is likely referenced from a report layout formula column.

The remaining functions are standard generated accessors that expose the value of each report parameter or layout column to the report engine. Their return names correspond to the report's datamodel elements: P_PRECISION, P_PRECISION_WIDTH, P_STATUTORY_REPORT, P_BALANCING_SEGMENT, P_SUMMARY, P_BOOK_TYPE_CODE, P_PERIOD, P_CONC_REQUEST_ID, and CP_DATE_FORMAT, plus report output (RP_) values such as RP_COMPANY_NAME, RP_REPORT_NAME, RP_SOB_NAME, RP_SOB_ID, RP_CURRENCY_CODE, RP_ACCT_VALUESET_NAME, RP_BOOK, RP_BAL_SEG, RP_PERIOD, RP_OFFICIAL_RUN, and RP_PARENT_TOTALS.

The user's search term CP_DATE_FORMAT_P refers to the accessor function CP_DATE_FORMAT_P RETURN VARCHAR2, which returns the value of the lexical/global parameter CP_DATE_FORMAT (declared as VARCHAR2(11)) to the report layout. This parameter controls the display format of date values rendered in the report output and is a common mechanism for localization.

Tables Accessed

Per the documented metadata, this package reads data via APPS-owned synonyms: FA_BOOK_CONTROLS and FA_SYSTEM_CONTROLS, both Fixed Assets configuration tables, and FND_CURRENCIES, the standard EBS currency definition table. These are used to derive book type, ledger/system context, and currency formatting values needed by the statutory financial statement report. No writes are implied by the metadata.

Usage Notes

This package is not referenced by any other package (referenced by 0 packages) and is not intended for direct customer invocation. It is called only by the Oracle Reports executable underlying the JGZZFALE XML Publisher concurrent program. Developers customizing the report should treat CP_DATE_FORMAT_P and the other accessors as read-only interfaces used by report triggers and formula columns, not as reusable APIs.