Search Results igf_aw_fund_td_map_pkg




Overview
Explore in AI Chat

Overview

The APPS.IGF_AW_FUND_TD_MAP_PKG package is a member of the Oracle E-Business Suite Grants Accounting (IGF) module, part of the Oracle ETRM (Enterprise Tracking and Resource Management) family of applications. Its principal business function is to maintain the mapping relationship between award funds and the transaction detail items (TD items) that compose them. In the grants lifecycle, an award fund represents a discrete pool of sponsored or cost-shared money, while transaction detail items represent the individual budget or expenditure components against which that money is applied. The package provides the data-access and DML layer that persists and validates these associations.

The object is owned by the APPS schema and carries a status of VALID in both 12.1.1 and 12.2.2. The ETRM documentation classifies it as an OTHER-type API, indicating it is an internal helper package invoked by other ETRM components rather than a public integration interface.

Key Procedures and Functions

The ETRM metadata documents ten procedures or functions within the package:

  • INSERT_ROW — inserts a new fund-to-TD-item mapping record.
  • UPDATE_ROW — modifies an existing mapping record.
  • DELETE_ROW — removes a mapping record.
  • LOCK_ROW — acquires a row-level lock to serialize concurrent updates.
  • ADD_ROW — convenience routine that creates a mapping entry, typically calling validation logic before insertion.
  • GET_PK_FOR_VALIDATION — retrieves the primary key used to validate a mapping row.
  • GET_UK_FOR_VALIDATION — retrieves the unique key used for uniqueness validation.
  • GET_FK_IGF_AW_FUND_MAST — returns the foreign key linking the mapping to the award fund master record.
  • GET_FK_IGF_AP_TD_ITEM_MST — returns the foreign key linking the mapping to the transaction detail item master record.
  • BEFORE_DML — trigger-style routine invoked before DML operations to enforce WHO-column and validation conventions.

The presence of both primary-key and unique-key validation functions, together with the two foreign-key accessors, confirms that the package enforces relational integrity between the fund master and the transaction detail item master.

Tables Accessed

The package operates against two documented base tables, referenced through APPS synonyms:

  • IGF_AW_FUND_TD_MAP_ALL — the primary intersection table holding the fund-to-TD-item mappings.
  • IGF_AW_FUND_TD_MAP_S — the corresponding sequence or surrogate-key support object used to generate identifiers.
  • DUAL — the standard Oracle single-row dummy table, used for key derivation and validation queries.

These tables persist the many-to-many or one-to-many relationships required to reconcile award funding against transaction-level detail.

Usage Notes

The package is referenced by three other packages: IGF_AP_TD_ITEM_MST_PKG, IGF_AW_FUND_MAST_PKG, and IGF_AW_ROLLOVER, and is also self-referencing. It is therefore invoked programmatically rather than directly by a form or concurrent program. Typical invocation occurs during award-fund maintenance and rollover processing, where the owning master packages call the mapping routines to keep fund-to-TD-item associations synchronized. Developers extending Grants Accounting should not call this package directly unless replicating the behavior of its documented callers; the supported integration surface lies in the master packages that consume it.