Search Results jg_jgzzfaad_xmlp_pkg




Overview
Explore in AI Chat

Overview

APPS.JG_JGZZFAAD_XMLP_PKG is the generated PL/SQL package body that supports the Oracle EBS Fixed Assets XML Publisher concurrent program JGZZFAAD. The package follows the standard XML Publisher (XMLP) generation pattern used throughout Release 12.1.1 and 12.2.2, in which a report definition is bound to a data model whose PL/SQL package supplies the before-report and after-report hooks, the SQL/group data fetchers, and the formula (CF_) functions evaluated at report render time. As seen in the package source header (JGZZFAADB.pls 120.0, 2008/01/08), the body belongs to the Java- and Oracle Forms-facing Fixed Assets reporting family and is classified in ETRM as an OTHER API rather than a public business API.

The business purpose is to present Asset Cost Balances and Accumulated Depreciation Balances in a multi-column, period-over-period layout. The BEFOREREPORT function interrogates the accounting flexfield structure, identifies the balancing segment, account segment, and FA cost centre segment, resolves the corresponding value set names (the VALUE_SET_NAME variable that drives the user's rp_acct_valueset_name query), and then submits the appropriate FARX_BL child report — ASSET_COST_BALANCES_RPT when P_REPORT_TYPE is 'COST', otherwise ACCUM_DEPRN_BALANCES_RPT — passing the book, from-period, to-period, request ID, and user ID. A non-zero RETCODE raises SUBMIT_ERROR, aborting the XMLP output.

Key Procedures and Functions

Tables Accessed

  • FA_BOOK_CONTROLS — Book setup rows used to validate P_BOOK_TYPE_CODE and derive the set of books (ledger) and functional currency for the selected book.
  • FA_SYSTEM_CONTROLS — Fixed Assets system options, including the accounting flexfield structure identifier used to locate the balancing, account, and cost centre segments and their value sets.
  • FND_CURRENCIES — Currency code and description lookup for displaying amounts in the correct reporting currency.

Usage Notes

The package is invoked exclusively through the JGZZFAAD concurrent program; it is not called by other packages in the EBS data model (referenced by 0 other packages). Customisations should be limited to the XML template and data model, since the package body is regenerated from JGZZFAADB.pls whenever the report definition changes. The user search term rp_acct_valueset_name corresponds to the VALUE_SET_NAME parameter populated by BEFOREREPORT; adjustments to the accounting valueset displayed on the report are therefore made by changing the report's parameter defaults or segment mappings, not by editing the generated package.