Search Results conscurrencycode_p




Overview
Explore in AI Chat

Overview

GL_GLXUSA_XMLP_PKG is an Oracle Application Object Library (AOL) report driver package owned by APPS and classified as OTHER within ETRM 12.2.2. It supports the General Ledger consolidation report known by the short name GLXUSA, which presents consolidation information between a parent ledger and its subsidiary ledgers for a selected consolidation definition and accounting period. The package encapsulates the PL/SQL logic required by the Oracle Reports executable: it holds the concurrent request identifier, the selected consolidation identifier, period name and period type, and the dynamic SQL fragments used to build account and balance join clauses.

The naming convention (_XMLP_PKG) indicates that this is the programmatic interface behind an XML Publisher (BI Publisher) model, where the package performs data preparation and the template controls presentation. The package is most closely associated with the search term "consolidation_name_p", a public function that exposes the resolved consolidation name to the report definition and to any dependent queries.

Key Procedures and Functions

The package declares a set of package-level variables that carry context between the report's triggers and queries, together with twelve documented procedures and functions:

  • BEFOREREPORT — performs pre-execution setup, typically resolving the consolidation identifier into ledger, currency, and period set attributes and initialising the global variables used by subsequent queries.
  • AFTERREPORT — performs post-execution cleanup and returns control to the report. It conventionally returns a boolean status.
  • GL_GET_CONSOLIDATION_INFO — the principal data-derivation routine. It accepts a consolidation identifier and returns the consolidation name, the consolidation method, the consolidation currency, the from and to ledger identifiers, a description, and an error buffer for exception reporting.
  • GL_CHECK_CONS_ACCOUNTS — validates whether consolidation account definitions exist for the given consolidation and average/actual flags, returning an indicator of records present. This is used to short-circuit the report when no accounts are defined.
  • CONSOLIDATION_NAME_P — accessor function returning the value of the CONSOLIDATION_NAME package variable.
  • PARENTLEDGERNAME_P and SUBSIDLEDGERNAME_P — accessor functions returning the parent and subsidiary ledger names.
  • CONSCURRENCYCODE_P and FROMCURRENCYCODE_P — accessor functions returning the consolidation currency and the source currency code.
  • SUBSIDLEDGERID_P — returns the subsidiary ledger identifier as a number.
  • PERIODSETNAME_P — returns the accounting period set name associated with the consolidation.
  • STRUCT_NUM_P — returns the consolidation structure number used to link the report output to the consolidation hierarchy.

All accessor functions follow the Oracle Reports group-function pattern, allowing the report layout to reference package state directly rather than duplicating query logic.

Tables Accessed

Through APPS synonyms, the package reads consolidation configuration and ledger relationship data:

  • GL_CONSOLIDATION — the consolidation definition header, source of the consolidation name, method, currency, and structure number.
  • GL_CONSOLIDATION_ACCOUNTS — the account ranges mapped to a consolidation, validated by GL_CHECK_CONS_ACCOUNTS.
  • GL_CONSOLIDATION_HISTORY — historical consolidation run information, used to determine prior consolidation activity and status.
  • GL_LEDGERS — ledger definitions, providing ledger names and currency codes for the parent and subsidiary ledgers.
  • GL_LEDGER_RELATIONSHIPS — the parent-to-subsidiary linkage that determines which ledgers participate in the consolidation and supplies the from/to ledger identifiers returned by GL_GET_CONSOLIDATION_INFO.

The package is read-oriented; consolidation balances are queried dynamically using the P_BALJOIN, P_ACCOUNTS, and P_ORDERBY fragments rather than being hard-coded.

Usage Notes

GL_GLXUSA_XMLP_PKG is invoked indirectly through the GLXUSA concurrent program / XML Publisher report. It is not referenced by any other documented package (referenced by 0 other packages), so its public functions are effectively a private contract with the report definition file. Parameters such as P_CONSOLIDATION_ID, P_PERIOD_NAME, and P_PERIOD_TYPE are populated by the concurrent program from user-entered report parameters.

Customisations should not modify this seeded package. Any extension should be implemented through a copy of the report definition or through a custom package that calls GL_GET_CONSOLIDATION_INFO and GL_CHECK_CONS_ACCOUNTS as documented public entry points. Because the package relies on AOL session context and the concurrent request identifier, direct invocation from SQL*Plus requires initialising the FND session before the accessor functions return meaningful values.