Search Results period_to_param

Overview

APPS.GL_OPEN_BAL_REVAL_RPT_PKG is a PL/SQL package body in the Oracle E-Business Suite General Ledger module, classified under the ETRM metadata as an "OTHER" API type rather than a public open interface. Its name indicates its role: an open balance revaluation report. The package assembles and formats the data required to report on the revaluation of open account balances, a period-end process in which foreign-currency balances are restated at a current exchange rate and the resulting unrealized gain or loss is recognized. The body has no documented dependents and is not referenced by any other database object, confirming that it functions as a report-side helper rather than a callable business API. It is a self-contained reporting utility whose logic is exposed to the user through a concurrent program or report layout rather than through direct programmatic invocation.

Key Procedures and Functions

The ETRM 12.2.2 metadata documents four units within the package body:

• BEFOREREPORT — Serves as the report initialization routine. Before the report executes, it establishes the runtime context for the report session, including the ledger and access-set conditions that determine which data the report will retrieve. This procedure supports the standard Oracle Reports "Before Report" trigger pattern used throughout General Ledger reporting packages.
• GET_REVAL_CONVERSION_RATE — Returns the conversion rate used to revalue the open balances for the report period. It supplies the exchange rate applied to foreign-currency balances so that they can be presented in the reporting currency.
• GET_DATA_ACCESS_SET_NAME — Retrieves the name of the data access set associated with the reporting session. The access set is central to data security in R12 and later, since it determines the ledgers and balancing segment values visible to the running user.
• GET_LEDGER_NAME — Returns the ledger name for the reported data. Combined with the access-set retrieval, it enables the report output to be clearly identified by ledger and access-set context.

No parameter lists are documented; the functions are used internally by the report logic to populate and label the report output.

Tables Accessed

The package reads from a defined set of GL tables, all referenced through APPS synonyms:

• GL_JE_HEADERS and GL_JE_LINES — Provide the journal entry header and line detail from which open balances and their foreign-currency amounts are derived.
• GL_LEDGERS — Supplies ledger definitions, including currency and accounting setup used to label and interpret the report.
• GL_PERIODS — Provides period definitions so revaluation activity can be attributed to the correct accounting period.
• GL_ACCESS_SETS — Supports the access-set and security logic used by GET_DATA_ACCESS_SET_NAME and the report initialization.
• PLITBLM — The Oracle Reports PL/SQL table type used for building and passing parameter values within the report; this is a supporting construct rather than a data table.

The dependency metadata also records calls into GL_ACCESS_SET_SECURITY_PKG and GL_MESSAGE, used respectively for data security enforcement and message handling.

Usage Notes

GL_OPEN_BAL_REVAL_RPT_PKG is invoked indirectly through Oracle Reports and the concurrent manager rather than by application code. A user typically submits the associated open balance revaluation report concurrent program; the report invokes BEFOREREPORT to initialize the session, calls the GET_* functions to resolve the ledger, access-set, and conversion-rate labels, and then queries GL_JE_HEADERS, GL_JE_LINES, GL_LEDGERS, and GL_PERIODS for the reporting data. Because the package is not referenced by any other database object, customizations should treat it as a report-owned component: modifications are best confined to the report definition and standard copy-and-customize practices. The package is valid in both Oracle EBS 12.1.1 and 12.2.2, though the R12 multi-org access-set model it depends on is most fully realized in the 12.2.x data access set architecture.