Search Results disp_actual_flagformula

Overview

APPS.GL_GLRJED_XMLP_PKG is the PL/SQL package that backs the Oracle General Ledger concurrent program commonly known as the General Ledger Journal Entry Detail Report (internal short name GLRJED). The package follows the standard Oracle Reports XML Publisher (XMLP) architecture introduced in Release 12, where a report definition invokes a database package to bind parameters, construct a dynamic SQL statement at runtime, and supply formatted column values to the report layout via the publisher's data model. It belongs to the Oracle E-Business Suite 12.1.1 and 12.2.2 code lines, and its ownership is registered under the APPS schema with an API classification of OTHER, confirming it is an internal report-support package rather than a published public API.

The core business purpose is to present General Ledger journal entry activity — including beginning and ending balances, debit and credit amounts, and account segment detail — for a selected ledger, period range, and account flexfield range. Because the GL chart of accounts is a key flexfield, the report must resolve account structure dynamically. The package solves this through the STRUCT_NUM, SELECT_ALL, WHERE_FLEX, and ORDERBY_* constants and package variables, which build the account concatenation, filter, and ordering clauses against the account code combinations table.

Key Procedures and Functions

The package exposes 44 documented procedures and functions. The report lifecycle entries are BEFOREREPORT and AFTERREPORT, which initialize and clean up global state, and resolve the ledger name, currency, and access set context used throughout the report.

The balance presentation layer is handled by BEGIN_BALFORMULA and END_BALFORMULA, which format the opening and closing balance columns for each account line. BEGIN_BAL_DR_CRFORMULA and END_BAL_DR_CRFORMULA perform the equivalent presentation for opening and closing debit/credit balances. BUD_ENC_TYPE_NAMEFORMULA converts the budget or encumbrance type identifier into a display name for the report header.

The specific function referenced in the search, DISP_ACTUAL_FLAGFORMULA, formats the P_ACTUAL_FLAG parameter into a human-readable label so the report shows whether the balances are Actual, Budget, or Encumbrance. Complementing it, WHERE_ACTUAL_TYPE_P supplies the corresponding SQL predicate restriction, ensuring the account balances selected match the requested actual flag and, where applicable, the budget or encumbrance type identifier.

The period logic uses START_EFFECTIVE_PERIOD_NUMFORM and END_EFFECTIVE_PERIOD_NUMFORMUL to translate the P_START_PERIOD and P_END_PERIOD parameters into effective period numbers, while GL_GET_EFFECTIVE_NUM is a helper function returning the effective period number for a given period name.

Tables Accessed

Four tables are referenced through APPS synonyms. GL_LEDGERS supplies the ledger name, ledger currency, and chart of accounts structure, and drives the P_LEDGER_CURRENCY and P_ACTUAL_FLAG context. GL_PERIOD_STATUSES provides period names, effective period numbers, and open or closed status, underpinning the effective period functions. GL_ACCESS_SETS and GL_LEDGER_SET_ASSIGNMENTS resolve the data access set associated with the requested ledger, which the package uses to build the ACCESS_SET_NAME and P_ACCESS_SET_ID values and enforce ledger security. No other tables are documented as directly referenced.

Usage Notes

GL_GLRJED_XMLP_PKG is invoked only through the concurrent program that runs the GLRJED XML Publisher report, from the Submit Request or the General Ledger journals and reports menu paths. It is not called from Oracle Forms directly and is not referenced by other database packages, consistent with the documented "referenced by 0 other packages" attribute. Custom Oracle Reports or XML Publisher layouts intended to extend the journal entry detail report can reuse the same parameter contract (P_LEDGER_ID, P_START_PERIOD, P_END_PERIOD, P_ACTUAL_FLAG, P_MIN_FLEX, P_MAX_FLEX, P_ORDER_TYPE, P_ACCESS_SET_ID, P_CURRENCY_TYPE, P_ENTERED_CURRENCY). Changes to the package signature or the flexfield filter constants must be treated as report-level customizations, since the package is an internally owned component of the Oracle E-Business Suite code line.