Search Results igf_aw_fund_incl_pkg




Overview
Explore in AI Chat

Overview

APPS.IGF_AW_FUND_INCL_PKG is a PL/SQL package in the Oracle E-Business Suite Applications schema, classified in ETRM as an OTHER-type API. It belongs to the Oracle Grants / Federal Financials (IGF) product family, specifically the Award (AW) module. Its role is to manage the persistence and validation of Award fund inclusion records, which define the relationship between a fund master definition and the fund categories included within it. In the Award Funds model, funds are organized hierarchically: a fund master denotes the overall funding structure, a fund category classifies the source or type of funding, and a fund inclusion record binds a specific category to a fund master. This package supplies the standard insert, lock, delete, and pre-DML logic that the Award Funds forms and Concurrent Programs use when maintaining those inclusion records. The package is documented at status VALID and is installed in releases 12.1.1 and 12.2.2.

Key Procedures and Functions

The package exposes seven documented procedures and functions:

  • INSERT_ROW — Creates a new fund inclusion row in the underlying table, populating the standard WHO columns and enforcing the primary key for the new record.
  • LOCK_ROW — Acquires a row-level lock on an existing fund inclusion record, typically issued before an update so that concurrent sessions cannot modify the same row.
  • DELETE_ROW — Removes a fund inclusion record, invoked when a fund category is detached from a fund master.
  • GET_PK_FOR_VALIDATION — Returns the primary key value for a fund inclusion record, used by the calling form or API to validate that the row being processed is the correct one before DML proceeds.
  • GET_UFK_IGF_AW_FUND_CAT — Resolves the user-facing (unique) foreign key for the fund category related to the inclusion row. The naming convention indicates it derives the display value for the IGF_AW_FUND_CAT relationship rather than the raw ID.
  • GET_FK_IGF_AW_FUND_MAST — Resolves the foreign key reference to the fund master record. It supports the master relationship that determines which fund master owns the inclusion.
  • BEFORE_DML — A pre-DML hook that applies WHO/audit column defaults and last-update stamps immediately before an insert, update, or delete is committed.

Parameter lists are not documented in the ETRM extract and should be confirmed from the package specification in the database before custom invocation.

Tables Accessed

The documented table reference is IGF_AW_FUND_INCL_ALL, accessed through an APPS synonym. This is the multi-org table that stores fund inclusion records for the Award Funds setup. The package reads from it for lock, validation, and foreign key resolution operations, and writes to it through INSERT_ROW, DELETE_ROW, and BEFORE_DML. The two foreign-key helper routines logically depend on the fund category and fund master entities, which reside in the related tables managed by IGF_AW_FUND_CAT_PKG and IGF_AW_FUND_MAST_PKG respectively.

Usage Notes

This package is referenced by three other packages: IGF_AW_FUND_CAT_PKG, IGF_AW_FUND_MAST_PKG, and IGF_AW_ROLLOVER. IGF_AW_FUND_CAT_PKG and IGF_AW_FUND_MAST_PKG use the foreign key and validation helpers to resolve and verify their related records, while IGF_AW_ROLLOVER calls into the package when fund inclusion data must be carried forward during the rollover of award fund definitions. The package also recursively references itself, which is consistent with internal calls between its own procedures. In practice it is invoked from the Award Funds maintenance forms and from concurrent programs or custom PL/SQL that manipulate fund inclusion data, rather than being called directly by end users. Because it modifies data directly rather than through a public API wrapper, custom code should invoke it only in coordination with the standard Award Funds forms logic, and only after validating that the locked row and foreign key values match the intended fund master and category combination.