Search Results count_ranges

Overview

GL_CONS_ACCOUNTS_PKG is a server-side PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It supports the Consolidation Run form, specifically the Accounts block, by encapsulating the data-manipulation and validation logic required to define and maintain the account ranges used in a consolidation run. Consolidation in General Ledger transfers balances from one or more subsidiary ledgers into a parent ledger; the account ranges captured in the Accounts block determine which accounts are selected for that transfer.

The package header carries a revision marker of 120.3 dated 2005/05/05, and its history records initial creation by E. Wilson on 20-APR-94. The package is classified as an OTHER API in the ETRM repository, meaning it is not a formally published open interface but is nonetheless a callable, documented unit within the consolidation form stack.

Key Procedures and Functions

• Insert_Consolidation_Accounts — a function that inserts records into GL_CONSOLIDATION_ACCOUNTS for a newly defined consolidation. It is invoked with the consolidation run identifier, consolidation identifier, and subsidiary (from) ledger identifier.
• Check_Unique_Element_Sequence — a procedure that verifies that the element sequence value is unique for a given consolidation_id and consolidation_run_id combination. The element sequence corresponds to the line number of an account range entry.
• Check_Account_Ranges_Overlap — a procedure that validates that the account ranges defined in the Accounts block do not overlap one another. The check operates across the low and high segment columns of the account range.
• Count_Ranges — a procedure that returns the number of account ranges defined for the consolidation context, supporting the form's navigation and validation logic.
• Copy_Ranges — a procedure that copies previously defined account ranges, typically used when duplicating a consolidation setup or carrying ranges forward between runs.
• Delete_Account_Range — a procedure that removes an account range record from the consolidation accounts structure.

Tables Accessed

The package reads and writes GL_CONSOLIDATION_ACCOUNTS, the table that stores the account range definitions tied to a consolidation run. All of the insert, copy, delete, count, and overlap-validation operations act on this table. The package also references GL_CONSOLIDATION_HISTORY, which holds the consolidation run history. Both tables are reached through APPS synonyms, consistent with standard EBS coding practice.

Usage Notes

GL_CONS_ACCOUNTS_PKG is invoked primarily from the Consolidation Run form when a user enters, copies, or deletes account ranges in the Accounts block. Validation procedures such as Check_Unique_Element_Sequence and Check_Account_Ranges_Overlap are fired during record entry to enforce integrity before the form commits. Count_Ranges supports control-flow logic such as determining whether ranges already exist for a consolidation.

The package is not referenced by any other documented package in the ETRM repository, indicating it is a leaf-level form-support package rather than a shared utility. Custom code may call Insert_Consolidation_Accounts or Copy_Ranges directly when programmatically seeding consolidation account ranges, but such use should mirror the form's calling conventions and supply valid consolidation run, consolidation, and ledger identifiers.