Search Results start_eff_period_numformula

Overview

APPS.GL_GLRGNL_XMLP_PKG is the generated PL/SQL package that backs the General Ledger "General Ledger Report" (GLRGNR) concurrent program XML Publisher template in Oracle EBS 12.1.1 and 12.2.2. It follows the standard Oracle Reports-to-XML-Publisher conversion pattern, in which the original report logic is preserved in a package that declares global substitution parameters, cursor bind values, and a series of formula columns consumed by the RTF layout. The package header exposes the report parameters (such as P_CONC_REQUEST_ID, P_CURRENCY_TYPE, P_ACTUAL_FLAG, P_START_PERIOD, P_END_PERIOD, P_LEDGER_ID, and P_ACCESS_SET_ID) alongside internal globals (for example CP_1, OLD_CCID, OLD_END_DR, OLD_END_CR, and LAST_PERIOD_YEAR) that carry state between formula invocations. Its business purpose is to produce a period-based General Ledger trial balance or account balance listing across one or more ledgers, presenting beginning balance, period activity, and ending balance for the selected accounts and currency type.

Key Procedures and Functions

The package contains fifty-one documented procedures and functions. BEFOREREPORT and AFTERREPORT perform the standard concurrent program initialization and cleanup, resolving ledger access, currency, and period context before the data model runs. Formula functions such as DISP_ACTUAL_FLAGFORMULA, DISP_CRFORMULA, BUD_ENC_TYPE_NAMEFORMULA, START_DATEFORMULA, and END_DATEFORMULA return formatted display values for report columns. Balance computations are handled by BEGIN_BALFORMULA, END_BALFORMULA, ACCOUNTED_BALFORMULA, and LAST_PERIOD_YEARFORMULA, while OLD_CCIDFORMULA, OLD_END_DRFORMULA, OLD_END_CRFORMULA, and NEW_RECORDFORMULA manage row-to-row break logic so that balances reset correctly at account boundaries. Period utilities GL_GET_PERIOD_DATES, GL_GET_EFF_PERIOD_NUM, and START_EFF_PERIOD_NUMFORMULA resolve the effective accounting period and its start and end dates. The functions BAD_STARTFORMULA and BAD_ENDFORMULA handle exception and invalid-value conditions for the report's start and end parameters, allowing the template to display a controlled result when the supplied date or period values cannot be validated rather than failing with an unhandled error.

Tables Accessed

The package references four core General Ledger tables through APPS synonyms. GL_LEDGERS supplies ledger definitions and the ledger currency used to determine the reporting currency context. GL_ACCESS_SETS and GL_LEDGER_SET_ASSIGNMENTS are used to resolve which ledgers and ledger sets the running user may access, supporting data access set security and multi-ledger reporting. GL_PERIOD_STATUSES provides period names and their open, closed, or never-opened status, which drives period validation and the effective period calculations used by GL_GET_EFF_PERIOD_NUM and the period date functions.

Usage Notes

GL_GLRGNL_XMLP_PKG is registered as the template package for the GLRGNR XML Publisher concurrent program and is invoked whenever that program is submitted. It is also listed as referenced by zero other packages, indicating it is a top-level, self-contained entry point rather than a shared utility library; custom code should not depend on its internal formulas because they are regenerated and overwritten each time the concurrent program definition is upgraded or the template is recompiled. Customizations should be applied through the RTF template or by copying the package, never by editing the shipped version in place.