Search Results delete_recurring




Overview
Explore in AI Chat

Overview

The APPS.GL_BUDGET_BATCHES_PKG package body implements the core maintenance logic for the GL_BUDGET_BATCHES intersection table in Oracle General Ledger. This table links budget versions to recurring batches, enabling the Budgetary Control and recurring budget generation features. When a budget version is created, or when recurring batches are defined with a budget flag enabled, rows must be inserted into GL_BUDGET_BATCHES so that the recurring batch process can propagate the correct budget version across the appropriate ledger. The package encapsulates these insert and delete operations, together with query procedures used by the Budget Batches form and its underlying block. Source header information (glibdbtb.pls 120.6) indicates the package has been stable since the 11i code line and carries forward unchanged into 12.1.1 and 12.2.2.

Key Procedures and Functions

  • INSERT_BUDGET — Inserts rows into GL_BUDGET_BATCHES for a given budget version and ledger, selecting all recurring batches whose budget flag is set to 'Y' and whose ledger matches. New rows are created with a status of 'U' (unprocessed).
  • INSERT_RECURRING — Performs the inverse operation: for a given recurring batch, it inserts a GL_BUDGET_BATCHES row for every eligible budget version, again with status 'U'.
  • DELETE_RECURRING — Removes all GL_BUDGET_BATCHES rows associated with a specified recurring batch, typically invoked when the recurring batch is deleted or when its budget flag is cleared.
  • SELECT_ROW — Query procedure used to fetch a single GL_BUDGET_BATCHES record, supporting the form's block-level retrieval logic.
  • SELECT_COLUMNS — Provides column-level validation and lookup support for the Budget Batches form, returning the attributes required for display and navigation.

Tables Accessed

  • GL_BUDGET_BATCHES — The primary target of all insert, delete, and select operations. It stores the budget version to recurring batch mapping and a processing status.
  • GL_BUDGET_VERSIONS — Read by INSERT_RECURRING to enumerate all budget versions that should be linked to a given recurring batch.
  • GL_RECURRING_BATCHES — Read by INSERT_BUDGET to identify recurring batches flagged for budgeting (budget_flag = 'Y') for a specified ledger.

Usage Notes

The package is invoked indirectly by the Budget Batches form and by concurrent programs that generate or maintain recurring budget batches. INSERT_BUDGET is normally called when a budget version is created or updated; INSERT_RECURRING is called when a recurring batch that affects budgeting is saved; DELETE_RECURRING fires when such a batch is removed. In the event of an unhandled error, the package raises the standard GL_UNHANDLED_EXCEPTION message via FND_MESSAGE, setting the token PROCEDURE to the calling routine so that the failing program unit is recorded in the error stack. Application exceptions are re-raised without modification, and NO_DATA_FOUND is silently ignored. The package is referenced by one other documented package, so customizations should assume it is a shared dependency and avoid changing its public signatures.