Search Results get_open_flag

Overview

APPS.GL_BUDGET_PERIOD_RANGES_PKG is a small, single-purpose PL/SQL package in the Oracle General Ledger (GL) module. Its business function is to expose the open/closed status of a budget period range for a specific budget version and accounting period year. In Oracle EBS budgeting, each budget version can have period ranges that are either open for entry and update or closed to further change. This package provides the programmatic accessor that other GL components — forms, concurrent programs, or custom extensions — call to determine whether a given budget version and period year is currently open.

The package body source header (glibprab.pls 120.3, dated 2005) indicates it is a long-standing, stable internal GL package rather than a public API. ETRM classifies it under API classification "OTHER," confirming it is treated as an internal helper rather than a formally published open interface.

Key Procedures and Functions

The ETRM metadata documents exactly one procedure for this package: GET_OPEN_FLAG. It is a public procedure with an IN OUT NOCOPY parameter that returns the open flag for a given budget version and period year. It is worth noting it is implemented as a procedure rather than a function, returning its result through the output parameter.

Its purpose is to look up the open_flag value stored in GL_BUDGET_PERIOD_RANGES for the specified budget_version_id and period_year. The procedure is a simple single-row lookup: it opens an explicit cursor, fetches the flag, and closes the cursor. Exception handling is deliberately structured: NO_DATA_FOUND causes a silent RETURN (leaving the caller's variable unchanged), application exceptions are re-raised, and any other error is translated through FND_MESSAGE with the token "SQLGL / GL_UNHANDLED_EXCEPTION" before being re-raised. No other procedures or functions are documented for this package, and no package-level state is declared.

Tables Accessed

The package reads a single table through its APPS synonym: GL_BUDGET_PERIOD_RANGES. This table stores the period-range definitions and their open/closed state for each budget version. The package only reads this table — it performs a SELECT of open_flag filtered by budget_version_id and period_year. No inserts, updates, or deletes are documented. There are no other documented table dependencies, and ETRM records no other packages referencing this one, indicating a narrow, well-contained data access footprint.

Usage Notes

This package is typically invoked from GL budget entry forms or program units that need to decide whether to allow budget data entry for a given period. A caller passes a budget version identifier and period year, and receives the open flag in an IN OUT variable.

Because the procedure is a procedure rather than a function, callers must declare and pass a variable to receive the result. In Oracle EBS 12.1.1 and 12.2.2, the GL_BUDGET_PERIOD_RANGES table and this package are part of the fixed GL schema, and the package is compiled into the APPS schema. Custom code may call it, but the ETRM "OTHER" classification indicates it is not a supported public API; customizations should reference the underlying table cautiously or mirror the package's read-only pattern. Callers should also account for the NO_DATA_FOUND behavior: when no period range exists for the given version and year, the output variable is left untouched rather than set to a default, so it should be initialized before invocation. Finally, because the cursor is a simple equality-based single-row lookup, no ordering or range logic is performed by the package itself.