Search Results get_ledger_name

Overview

GL_OPEN_BAL_REVAL_RPT_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the generic "OTHER" API category. Its documented purpose is to encapsulate all the PL/SQL logic required by the "GL Open Balances Revaluation" report. The package declaration, sourced from glxobrvs.pls, is defined with AUTHID CURRENT_USER, meaning that all unqualified object references are resolved against the privileges of the invoking user rather than the package owner. This design supports the report's dynamic query building against a data template, since the package is intended to run under the responsibility and data access context of the end user.

The package serves as a server-side helper library for the XML data template GLXOBRVR.xml. Rather than embedding business logic directly in the template, Oracle centralizes it in this package so that functions can be called at report execution time to resolve parameter values, derive conversion rates, and constrain the data set presented to the user.

Key Procedures and Functions

The package exposes four documented program units:

• BEFOREREPORT — A public function invoked before the report is executed. It initializes global variables that are subsequently used to build the queries in the data template dynamically.
• GET_REVAL_CONVERSION_RATE — A public function that returns the conversion rate applied by the revaluation program for a given period. It accepts code combination, account, and currency as inputs and returns the corresponding rate.
• GET_DATA_ACCESS_SET_NAME — A public function that returns the data access set name, derived from the value of the report parameter ACCESS_SET_ID_PARAM.
• GET_LEDGER_NAME — A public function that returns the ledger name based on the value of the report parameter LEDGER_ID_PARAM. This is the unit most commonly located by developers searching for ledger name resolution within the open balances revaluation flow.

All public functions are consumed by the data template GLXOBRVR.xml, and the package is not referenced by any other database package.

Tables Accessed

The package reads from the following tables through APPS synonyms:

• GL_LEDGERS — Provides the ledger name resolved by GET_LEDGER_NAME from LEDGER_ID_PARAM.
• GL_ACCESS_SETS — Supplies the data access set name resolved by GET_DATA_ACCESS_SET_NAME.
• GL_JE_HEADERS and GL_JE_LINES — Journal entry header and line data used to evaluate open balances subject to revaluation.
• GL_PERIODS — Period definitions used to constrain the reporting range and to support the conversion rate lookup.
• PLITBLM — The generic Oracle Reports/EBS parameter list table, used to hold report parameters during execution.

Usage Notes

This package is not intended for ad hoc invocation. It is called exclusively by the GL Open Balances Revaluation report through its XML data template GLXOBRVR.xml. The typical execution path is a concurrent program run from the General Ledger responsibility, where the user supplies ledger, access set, and period parameters. The BEFOREREPORT function executes first to populate global state; the remaining functions are then called from within the template's SQL queries to resolve the ledger name, data access set name, and revaluation conversion rate.

Because the functions reference report parameters, custom code should not call them outside the report context. The declared LAST UPDATE DATE of the specification is 14-MAY-2007, and the header identifies version 120.0.12000000.1, reflecting the Release 12 code line applicable to both 12.1.1 and 12.2.2 environments.