Search Results gl_budget_entities_s

Overview

APPS.GL_BUDGET_ENTITIES_PKG is a server-side PL/SQL package that encapsulates the core data access and validation logic for budget organizations in Oracle General Ledger. A budget organization, represented by the GL_BUDGET_ENTITIES table, defines the set of accounts and ranges over which budget amounts may be entered and tracked. The package provides the authoritative set of operations that General Ledger forms, concurrent programs, and other application modules use to query, insert, update, lock, and validate budget organization definitions.

The package is classified under ETRM as an OTHER API rather than a formal public API, which reflects its role as an internal engine used primarily by the Budget Organizations form and by the range-assignment concurrent process. Its header revision (120.8) dates to 2005, indicating a stable, long-lived interface that remains in use across 12.1.1 and 12.2.2. The package relies on the standard APPS exception and message utilities, including APP_EXCEPTION and FND_MESSAGE, to raise user-facing errors that surface on the form.

Key Procedures and Functions

• CHECK_UNIQUE — Verifies that no duplicate budget organization name exists within a given ledger, accounting for a row identifier so that updates to an existing row do not falsely conflict. It distinguishes a deleted organization by raising a specific message (GL_DUP_BUD_ORG_DEL_INP) versus a live duplicate (GL_DUPLICATE_BUD_ORG_NAME).
• CHECK_FOR_ALL — Returns a BOOLEAN indicating whether the organization name corresponds to the literal value "ALL," driven by a query against GL_LOOKUPS. This is the function referenced in the source excerpt and the object of the user's search. It is used to detect the predefined catch-all budget organization.
• HAS_RANGES — Determines whether a budget organization has any account range assignments defined.
• GET_UNIQUE_ID — Obtains a new primary key value for GL_BUDGET_ENTITIES from its sequence.
• LOCK_ORGANIZATION and LOCK_ROW — Acquire the appropriate row locks before modification, protecting concurrent editing of a budget organization.
• SELECT_COLUMNS — Retrieves column values for a budget organization row, supporting the form's query block.
• BUDGET_AND_ACCOUNT_SEG_INFO — Returns budget and accounting segment information associated with the organization.
• INSERT_ROW, UPDATE_ROW, and INSERT_ORG — Perform the physical inserts and updates against the base table and its translated table.
• SUBMIT_ASSIGN_RANGES_REQUEST — Submits the concurrent request that assigns account ranges to a budget organization.
• SET_BC_TIMESTAMP — Maintains the standard who-column timestamp used for optimistic locking and audit.

Tables Accessed

The package reads and writes GL_BUDGET_ENTITIES, the primary repository of budget organization definitions, and GL_BUDGET_ENTITIES_S for translated name and description values. GL_BUDGET_ASSIGNMENT_RANGES holds the account range assignments validated and manipulated by the package. GL_LEDGERS is joined to associate each organization with its owning ledger. GL_LOOKUPS supplies the "ALL" literal used by CHECK_FOR_ALL. DUAL is used for trivial single-row evaluations. All access is made through APPS synonyms, and the code references columns such as BUDGET_ENTITY_ID, LEDGER_ID, NAME, and STATUS_CODE.

Usage Notes

The package is normally invoked from the General Ledger Budget Organizations form during query, insert, update, and delete operations, and from the concurrent program that assigns ranges across an organization. It is referenced by four other packages, so customizations should call the documented entry points rather than modify the body. Because it is not a formally registered public API, Oracle does not guarantee backward compatibility; integrators should wrap calls defensively and rely on the raised FND_MESSAGE exceptions for error handling.