Search Results consolidationname_p




Overview
Explore in AI Chat

Overview

APPS.GL_GLXDDA_XMLP_PKG is a generated Oracle Reports PL/SQL library package that supports the General Ledger consolidation-related XML Publisher report GLXDDA. Its header comment (GLXDDAS.pls, version 120.0, dated 2007/12/27) indicates that it is a report-side package shipped with the E-Business Suite but not part of the supported API surface ("noship"). The package serves as the server-side logic container for an Oracle Reports executable: it declares the report parameters, exposes the values of those parameters to the report layout through getter functions, performs pre- and post-report processing through the standard BeforeReport and AfterReport entry points, and supplies a helper routine that resolves consolidation definition details from the General Ledger consolidation tables.

The presence of parameters such as From_Ledger_Name, To_Ledger_Name, and ConsolidationName, together with the bind-style string WHERE_DR_CR_NOT_ZERO, indicates that the report presents consolidation activity between a source ledger and a target ledger for a given accounting period, with an option to suppress lines whose entered debit and credit amounts are both zero. In Oracle EBS 12.1.1 and 12.2.2 the object is owned by APPS and classified as OTHER, meaning it is an internal report component rather than a published API.

Key Procedures and Functions

  • BEFOREREPORT — Standard Oracle Reports package function invoked before the report query executes. It initialises report-level state, typically populating package variables and validating or resolving the incoming consolidation and ledger parameters.
  • AFTERREPORT — Standard Oracle Reports package function invoked after the report completes. It is used for post-processing and cleanup of package state.
  • GL_GET_CONSOLIDATION_INFO — Helper procedure that takes a consolidation identifier and returns the consolidation name, consolidation method, currency code, source (from) ledger identifier, target (to) ledger identifier, and a description, along with an error buffer. It is the primary data-resolution routine used to translate the consolidation selection made by the user into the ledger identifiers needed by the report query.
  • FROM_LEDGER_NAME_P — Getter function exposing the value of the From_Ledger_Name package variable to the report layout. This corresponds directly to the user's search term and supplies the name of the source ledger associated with the selected consolidation.
  • TO_LEDGER_NAME_P — Getter function exposing the target ledger name.
  • LEDGER_NAME_P — Getter function exposing the general Ledger_Name variable, used for the reporting ledger context.
  • STRUCT_NUM_P — Getter function exposing the STRUCT_NUM value, the consolidation structure or definition number.
  • CONSOLIDATIONNAME_P — Getter function exposing the resolved consolidation name for display on the report.
  • WHERE_DR_CR_NOT_ZERO_P — Getter function returning the WHERE_DR_CR_NOT_ZERO package constant, a dynamic SQL fragment that filters out consolidation lines where both entered debit and entered credit are zero or null.

Tables Accessed

The package accesses two General Ledger tables through APPS synonyms. GL_CONSOLIDATION is the consolidation definition table, read by GL_GET_CONSOLIDATION_INFO to obtain the consolidation name, method, currency, description, and the associated from and to ledger identifiers. GL_LEDGER_RELATIONSHIPS stores the relationships between ledgers, including the source-to-target mapping used to derive From_Ledger_Name and To_Ledger_Name. No other tables are documented for this package, and no direct writes are indicated; the package is a read-oriented report component.

Usage Notes

This package is not intended for direct invocation by customer code, as indicated by the "noship" header and its classification as OTHER. It is invoked indirectly when the associated Oracle Reports/XML Publisher consolidation report is executed, either from the General Ledger responsibility's consolidation menu or as a concurrent program submission. The BeforeReport and AfterReport functions are called by the Reports runtime, and the *_P getter functions are referenced by report layout formulas and query columns. Because the package is referenced by zero other packages, it has no external dependents within the EBS data model. Customisations that require equivalent consolidation-to-ledger resolution should use the supported public APIs for General Ledger consolidation rather than calling this report package, since its interface is generated and may change between releases without notice.