Search Results fld_name

Overview

APPS.JG_JGZZRDLR_XMLP_PKG is a packaged Oracle Reports (XMLP) PL/SQL library that supports the reporting requirements of the JG (Global Accounting / Localizations) product family, specifically an accounts receivable and cash receipts reporting process. The package body encapsulates the report-level logic executed by the Oracle Reports runtime during a concurrent program run: report-level initialization, currency formatting helpers, and a substantial set of report column formulas used to compute and display receivable, tax, and foreign currency balances.

The package is classified as OTHER in the ETRM metadata, meaning it is not a public business API but rather an internal report driver. It follows the standard XML Publisher / Oracle Reports package naming convention (_XMLP_PKG), instantiated against a report definition whose bind parameters drive behavior. The header comment ($Header: JGZZRDLRB.pls 120.0 ...) confirms the source file is JGZZRDLRB.pls, a package body associated with the JG_JGZZRDLR report.

Key Procedures and Functions

The documented interface exposes 62 procedures and functions. The most significant are:

• BEFOREREPORT — the report-level initialization function. It resolves the report's concurrent request ID from FND_GLOBAL, derives the set of books context via FND_PROFILE and JG_GET_SET_OF_BOOKS_INFO, sets P_SET_OF_BOOKS_ID, functional currency (C_CURRENCY_CODE), chart of accounts structure (C_STRUCT_NUM), and set of books name (C_SET_OF_BOOKS_NAME). It also conditionally derives the P_RISKVAR1/2/3 risk-related expressions based on the P_INCL_RAR parameter and looks up the YES_NO meaning for that parameter.
• AFTERREPORT — the report-termination counterpart, executing cleanup and finalization logic on completion of the report run.
• FORMAT_CURRENCY — a helper that reads precision from FND_CURRENCIES and rounds a raw numeric string before formatting it for display. It accepts a currency code, a report field name, the raw numeric value, and a display currency code.
• C_PRT_*FORMULA functions — a large family of report formula columns controlling how amounts are presented. These include currency-level totals (C_PRT_TOT_CUR_FUNCFORMULA, C_PRT_TOT_CUR_FUNC_REMFORMULA), foreign currency totals (C_PRT_TOT_NET_FOREIGNFORMULA, C_PRT_TOT_NET_FOR_REMFORMULA), original foreign and functional amounts (C_PRT_ORIG_FRGN_AMOUNTFORMULA, C_PRT_ORIG_FUNC_AMOUNTFORMULA), foreign and functional amounts due remaining (C_PRT_FRGN_AMT_DUE_REMFORMULA, C_PRT_FUNC_AMT_DUE_REMFORMULA), and tax totals (C_PRT_TOT_TAX_FUNCFORMULA, C_PRT_TOT_TAX_FUNC_REMFORMULA).
• C_OA_PRT_*FORMULA functions — Oracle Assets / original amount variants of the above, applying the same logic to the OA (original amount) columns, e.g. C_OA_PRT_ORIG_FRGN_AMOUNTFORMU and C_OA_PRT_FUNC_AMT_DUE_REMFORMU.
• Site-level formula functions — C_PRT_TOT_SITE_FUNCFORMULA and C_PRT_TOT_SITE_FUNC_REMFORMULA summarize balances at the customer site level.

Tables Accessed

The package body reads from the following APPS synonyms:

• FND_CURRENCIES — queried in FORMAT_CURRENCY to obtain the currency precision used to round displayed amounts.
• AR_CASH_RECEIPTS — source of receipt header records used in the receivables report columns.
• AR_CASH_RECEIPT_HISTORY — provides receipt status and applied/unapplied history used in the amounts-due and remaining computations.
• AR_DUNNING_LETTERS — supplies dunning letter context where the report includes collection activity.
• AR_RECEIVABLE_APPLICATIONS — the primary source of application amounts (amount_applied, amount_due_original, amount_due_remaining) referenced in the P_RISKVAR expressions built in BEFOREREPORT.

Additionally, the package depends on FND_LOOKUPS (YES_NO lookup), FND_PROFILE, FND_GLOBAL, and the JG_GET_SET_OF_BOOKS_INFO helper, though only the AR tables are the primary data sources for the report.

Usage Notes

This package is not intended for direct invocation from forms, PL/SQL APIs, or custom code; it is auto-generated and bound to its Oracle Reports / XML Publisher report definition. It is executed implicitly by the Reports runtime when the corresponding concurrent program is submitted, with the runtime calling BEFOREREPORT before the data model executes and AFTERREPORT after the report completes. Report formula functions are invoked by the report layout engine per fetched row.

The ETRM metadata records that no other package references this package, confirming it is a leaf-level report driver. Customizations should not modify the generated package body directly, since Oracle ships it as noship and patches may overwrite it. Any change to report behavior, parameterization, or currency formatting should be implemented in a report copy or a supported user exit. Because BEFOREREPORT references the FLD_NAME parameter of FORMAT_CURRENCY whenever currency columns are rendered, the report's layout must supply a valid column alias matching the field name defined in the report definition.