Search Results get_fk_igf_aw_item




Overview
Explore in AI Chat

Overview

IGF_AW_COA_ITEMS_PKG is an Oracle Application Object Library (AOL) generated table-handler package owned by the APPS schema, classified under the OTHER API category. It provides the standard procedural interface for the IGF_AW_COA_ITEMS table, a child table within the Oracle E-Business Suite Financial Aid (IGF) module that stores Chart of Accounts (COA) item-level amounts associated with Award/Base records. The package encapsulates the canonical generated-forms pattern: row insertion, row locking, row update, row addition, row deletion, primary-key validation, and foreign-key lookup. Version history places the source at file IGFWI57S.pls, revision 120.0 (2005/06/02), consistent with the 11i to 12.x code lineage that carries forward into EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The package exposes nine documented routines organized around the DML lifecycle and validation:

  • INSERT_ROW — Inserts a new COA item row, taking the rowid, base identifier, item code, amount, PELL COA amount, alternate PELL amount, fixed-cost indicator, legacy record flag, mode, and lock flag.
  • LOCK_ROW — Acquires a pessimistic lock on an existing row for the duration of the transaction.
  • UPDATE_ROW — Updates an existing row identified by rowid, applying the same amount and flag attributes as INSERT_ROW.
  • ADD_ROW — Combines insert semantics with rowid return, enabling the caller to obtain the generated ROWID immediately.
  • DELETE_ROW — Removes the row identified by its ROWID.
  • GET_PK_FOR_VALIDATION — Boolean function that validates the composite primary key composed of base_id and item_code. Used by the generated form to confirm a candidate key exists before permitting DML.
  • GET_FK_IGF_AP_FA_BASE_REC — Foreign-key lookup helper that validates the base_id against the parent base record. This is the routine the user's search term most closely maps to in the sibling FK-validation family.
  • GET_FK_IGF_AW_ITEM — Foreign-key lookup helper that validates the item_code against the IGF_AW_ITEM reference table. This is the exact procedure the user searched for under the term get_fk_igf_aw_item.
  • BEFORE_DML — Internal pre-DML hook invoked by the insert, update, add, and delete routines to enforce WHO-column stamping, duplicate-key checks, and mandatory-attribute validation before the operation proceeds.

Tables Accessed

The package is bound to a single base table, IGF_AW_COA_ITEMS, accessed through the APPS synonym. It reads the table for row locking, primary-key validation, and foreign-key lookups, and writes to the table for insert, add, update, and delete operations. The foreign-key validation routines reference parent objects — the award base record (IGF_AP_FA_BASE_REC) and the award item definition (IGF_AW_ITEM) — to confirm that the child row's base_id and item_code values satisfy referential integrity before DML commits.

Usage Notes

In the EBS 12.1.1 and 12.2.2 file systems, IGF_AW_COA_ITEMS_PKG is typically invoked from Oracle Forms generated against the IGF_AW_COA_ITEMS block, from concurrent programs that programmatically create COA item lines for awards, and from custom PL/SQL that must maintain referential integrity against the award base and item tables. Because the package is referenced by eight other packages, callers should treat it as a stable public interface rather than an internal helper. Update operations should route through UPDATE_ROW or LOCK_ROW rather than direct DML to preserve BEFORE_DML validation, WHO-column audit stamping, and the row-level locking discipline expected by the generated forms layer. The get_fk_igf_aw_item routine is the canonical entry point for validating an item_code against IGF_AW_ITEM before inserting or updating a COA item row.