Search Results get_fk_igf_aw_coa_items




Overview
Explore in AI Chat

Overview

The APPS.IGF_AW_COA_ITM_TERMS_PKG package is a core table-handler package within the Oracle E-Business Suite Financials product family, specifically belonging to the Grants/Investments (IGF) module and supporting the Award Management (AW) and Chart of Accounts (COA) item-terms functionality. It encapsulates the insert, update, delete, and locking logic for the terms associated with Award Management Chart of Accounts items. In Oracle EBS 12.1.1 and 12.2.2, such packages form the application's internal DML layer, providing a stable programmatic interface that other packages, forms, and concurrent programs call rather than issuing direct SQL against the underlying tables. This improves maintainability, enforces validation and locking rules centrally, and isolates the physical table structure from calling code.

With an API classification of OTHER, the package is a maintenance-level API rather than a user-invocable business API. It is registered in the E-Business Taxonomy Reference Model (ETRM) with the object name IGF_AW_COA_ITM_TERMS_PKG, owner APPS, and status VALID.

Key Procedures and Functions

The package exposes nine documented procedures and functions:

  • INSERT_ROW — Inserts a new item-terms record into the base table.
  • LOCK_ROW — Acquires a locking read on an existing item-terms row, serializing concurrent modifications.
  • UPDATE_ROW — Applies changes to an existing item-terms record.
  • ADD_ROW — Adds a row through the package's augmentation path, typically invoked when the incoming data may represent a new or supplementary item term.
  • DELETE_ROW — Removes an item-terms record.
  • GET_PK_FOR_VALIDATION — Returns the primary key for validation purposes, allowing callers to verify that a row exists before proceeding with dependent processing.
  • GET_FK_IGF_AW_COA_ITEMS — Returns the foreign key linking a row to the parent IGF_AW_COA_ITEMS record.
  • GET_FK_IGS_CA_INST — Returns the foreign key linking a row to an IGS_CA_INST (student/contract instance) record, reflecting the shared IGS/IGF heritage of these objects.
  • BEFORE_DML — A pre-DML trigger helper executed to populate WHO columns and other standard audit fields before insert, update, or delete operations.

Parameter lists are not documented in the available metadata and are therefore not described here.

Tables Accessed

The package reads and writes the following tables via APPS synonyms:

  • IGF_AW_COA_ITM_TERMS — The primary base table; the target of all insert, update, delete, and lock operations.
  • IGF_AW_ITEM — The item master referenced when resolving or validating the item associated with a term.
  • IGF_AW_COA_HIST — The Chart of Accounts history table, used for audit and historical tracking of COA changes.
  • IGF_AP_FA_BASE_REC_ALL — A base record table used in the broader Award processing flow.

Usage Notes

The package is referenced by seven other application packages: IGF_AP_LG_COA_IMP, IGF_AW_COA_CALC, IGF_AW_COA_GEN, IGF_AW_COA_ITEMS_PKG, IGF_AW_LI_IMPORT, IGF_AW_COA_UPDATE, and IGF_GR_GEN. This dependency pattern shows that item-terms handling is invoked during COA import, COA generation and calculation, item maintenance, line-item import, and grant generation. In practice, the package is not called directly by end users; it is invoked by these higher-level award and grant processes and by any custom extensions that need to create or maintain item terms using a supported interface. Direct DML against IGF_AW_COA_ITM_TERMS should be avoided in favor of these procedures.