Search Results gl_cash_clr_acct_anal_rpt_pkg




Overview
Explore in AI Chat

Overview

GL_CASH_CLR_ACCT_ANAL_RPT_PKG is a PL/SQL package in the APPS schema that supports the Cash Clearing Account Analysis report within Oracle General Ledger. The package encapsulates the report logic required to analyze transactions that clear through a designated cash clearing account, reconciling Payables activity against General Ledger journal entries across a specified accounting period range. The package is classified as OTHER in the ETRM registry and its header carries the source revision glxccaas.pls 120.0.12000000.1, dated 2007/10/23, indicating a mature component that has been stable across multiple release boundaries.

The package declares a set of report parameters at the package specification level, including the data access set identifier, ledger identifier, chart of accounts identifier, account and code combination identifiers, a from/to period range, and a report type. It also declares global variables that are reused to construct SQL statements dynamically at runtime, most notably three query strings for AP uncleared, AP cleared, and GL uncleared activity, together with effective period number bounds and a dynamically assembled access restriction clause.

Key Procedures and Functions

  • BEFORE_REPORT — A function returning BOOLEAN that dynamically builds the queries used by the report. It is the primary initialization routine, responsible for assembling the query strings and period boundaries that drive report extraction.
  • ACCESS_SET_NAME — A function returning VARCHAR2 that retrieves the name of the data access set associated with the current report run. This function is the object most directly associated with the search term "access_set_name" and resolves the access set name from the access set identifier passed as a report parameter.
  • LEDGER_NAME — A function returning VARCHAR2 that retrieves the ledger name corresponding to the ledger identifier supplied to the report, used to present the ledger in the report heading and output.

Tables Accessed

The package reads from three documented tables through APPS synonyms:

  • GL_ACCESS_SETS — Supplies the access set name and definition used by the ACCESS_SET_NAME function and by the data security filtering applied to report queries.
  • GL_LEDGERS — Supplies ledger name and attributes for the LEDGER_NAME function and for validating the ledger parameter.
  • GL_PERIOD_STATUSES — Used to resolve effective period numbers and status for the from/to period range, ensuring the report reads only open or appropriate period activity.

Usage Notes

This package is invoked as part of the Cash Clearing Account Analysis report execution path, typically triggered from a concurrent program or from a General Ledger report submission interface. The BEFORE_REPORT function executes first to assemble the dynamic SQL, after which the access set and ledger name functions provide descriptive values for the report header. Because the package relies on package-level global variables, it is not re-entrant and is intended for single-threaded concurrent report execution. The package is not referenced by any other documented package, confirming it functions as a top-level reporting component rather than a shared library. Customizations should avoid altering the specification signatures, since the report definition depends on them.