Results for “get_bud_status_flag”

8 results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGIGGACC_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. The package belongs to the Oracle Grants Accounting (IGI) application family and supports budget inquiry and validation functionality used by the Grants Accounting budget views. ETRM classifies this package under the API classification "OTHER," indicating that it is an internal package rather than a formally published public API intended for customer extension or direct invocation.

The package provides utility logic for determining budget status and balance conditions. Its procedures and functions are referenced by the Grants Accounting budget variance views, specifically IGI_BUD_VARIANCE_BAL_V and IGI_BUD_VARIANCE_SEC_BAL_V, which present budget-versus-actual comparison data. The package therefore acts as a supporting layer beneath these views, supplying the derived flags and computed values that the views expose to end users.

Key Procedures and Functions

ETRM documents four procedures and functions within IGIGGACC_PKG:

  • SET_PROFILE — Establishes or initializes profile-related context used by the other routines in the package. This is consistent with the common Oracle EBS pattern of caching profile option values for the duration of a session or process.
  • GET_AVERAGE_UNBALANCED — Returns a computed value representing the average unbalanced amount associated with a budget or budget line. The function supports the variance analysis performed by the budget variance views.
  • GET_BALANCED_BUDGET_FLAG — Returns a flag indicating whether a budget is balanced. This drives indicators within the Grants Accounting budget inquiry screens and reports.
  • GET_BUD_STATUS_FLAG — Returns a status flag describing the state of a budget, used by the variance views and other dependent components to conditionally display or process budget data.

Parameter lists are not documented in the ETRM metadata and are not reproduced here. The routines are designed as internal helpers rather than a supported integration interface.

Tables Accessed

The ETRM dependency extract for IGIGGACC_PKG does not enumerate base tables or APPS synonyms. The documented dependency data lists only the SYS STANDARD package, reflecting the general dependency recorded for the package specification. The package is referenced by the two budget variance views, which in turn are built on Grants Accounting budget tables and the budgets interface. Practically, the package reads budget balance and status information sourced from the Grants Accounting and Oracle Budget schema objects underlying those views; however, the specific table list is not published in the available metadata and should not be assumed.

Usage Notes

IGIGGACC_PKG is an internal package and is not part of the documented public Grants Accounting API. It should be treated as a private implementation detail of the IGI budget variance views. Because the two documented views depend on this package, changes to its logic can affect the budget variance inquiry pages and any custom reports or views built on top of IGI_BUD_VARIANCE_BAL_V and IGI_BUD_VARIANCE_SEC_BAL_V.

Typical invocation occurs indirectly: Oracle Forms or OAF pages query the variance views, the views invoke the package functions to obtain the computed average unbalanced value and the balanced budget and budget status flags, and the results are rendered in the budget inquiry interface. Direct calls from custom code are not recommended, since procedure signatures are not published and are subject to change without notice between releases. Developers extending Grants Accounting budget reporting should query the underlying views rather than call IGIGGACC_PKG directly, and should validate behavior against the specific 12.1.1 or 12.2.2 patch level in use. Consultation of the package body via the EBS "show dependent code" facility is advisable when diagnosing budget status discrepancies observed in the variance views.