Search Results where_dr_cr_not_zero

Overview

APPS.GL_GLXDDA_XMLP_PKG is the generated PL/SQL package body that supports the Oracle General Ledger consolidation audit/analysis report commonly associated with the GLXDDA concurrent program. It functions as an Oracle Reports XML Publisher (XMLP) server-side package, meaning it implements the report trigger logic (BeforeReport, AfterReport) and resolution of report parameters. Its core purpose is to resolve consolidation definitions and ledger relationships so that the report can present consolidation activity, including the review of translated and consolidated balances by source and target ledger.

The search term "where_dr_cr_not_zero" corresponds directly to WHERE_DR_CR_NOT_ZERO_P, one of the package's parameter-handling functions. It supports a report parameter that filters consolidation lines so that only entries where the debit or credit amount is non-zero are reported, eliminating null or offsetting zero-value rows. The package header comment ($Header: GLXDDAB.pls 120.0 ... noship) indicates a standalone, non-shipped report support unit.

Key Procedures and Functions

• BEFOREREPORT — Runs prior to report execution. It declares and resolves local variables for the consolidation, source ledger, target ledger, chart of accounts, base currency, and consolidation method, and invokes GL_GET_CONSOLIDATION_INFO to populate consolidation context, then populates ConsolidationName.
• AFTERREPORT — Executes after report generation, returning TRUE. In the modernized version the SRW.USER_EXIT calls are commented out and replaced with NULL.
• GL_GET_CONSOLIDATION_INFO — Retrieves consolidation definition attributes (name, method, currency, source and target ledger IDs, description) for a given consolidation ID and returns an error buffer for validation.
• STRUCT_NUM_P — Parameter function returning a structure/accounting flexfield structure value used by the report.
• LEDGER_NAME_P — Parameter function returning the ledger name value used to filter or label report output.
• TO_LEDGER_NAME_P — Parameter function returning the target ledger name for the consolidation.
• FROM_LEDGER_NAME_P — Parameter function returning the source ledger name for the consolidation.
• CONSOLIDATIONNAME_P — Parameter function returning the consolidation name (ConsolidationName package variable).
• WHERE_DR_CR_NOT_ZERO_P — Parameter/data function that supplies the WHERE clause fragment excluding zero debit and credit amounts, restricting output to rows with actual consolidation activity.

Tables Accessed

The package references two documented tables through APPS synonyms:

• GL_CONSOLIDATION — Stores consolidation definitions, including from_ledger_id, from_currency_code, method, and description. It is queried to resolve consolidation attributes and to feed GL_GET_CONSOLIDATION_INFO.
• GL_LEDGER_RELATIONSHIPS — Stores relationships between source and target ledgers, including target_ledger_name and currency codes. It is joined with GL_CONSOLIDATION to identify the consolidation's target ledger.

Usage Notes

This package is invoked automatically when the associated GL consolidation report/concurrent program runs; it is not called directly by forms or by other packages. ETRM records zero packages referencing it, confirming it is a top-level report support unit. Administrators and developers generally interact with it only to diagnose report parameter behavior, most notably the WHERE_DR_CR_NOT_ZERO parameter, or to troubleshoot consolidation/ledger resolution errors surfaced through the error buffer and RAISE_APPLICATION_ERROR branch.