Search Results igf_aw_item_pkg




Overview
Explore in AI Chat

Overview

The APPS.IGF_AW_ITEM_PKG package body is a table-handler (row-level DML) utility within the Oracle E-Business Suite Financial Aid / Awards (IGF) module. Its role is to encapsulate the insert, update, delete, and locking logic for records stored in the IGF_AW_ITEM table, which stores individual award item lines associated with a student's award record. By centralizing these operations in a single package body rather than permitting direct DML against the underlying table, Oracle EBS enforces consistent validation, primary-key resolution, and concurrency control across every component that manipulates award items. The package is classified as an "OTHER" API in the ETRM documentation, meaning it is a supporting internal utility rather than a public, business-facing interface such as an awards-processing API.

Key Procedures and Functions

The package body exposes seven documented procedures and functions:

  • INSERT_ROW — Performs the actual insertion of a new row into IGF_AW_ITEM, populating the columns from the passed record structure and applying WHO-column auditing.
  • LOCK_ROW — Issues a SELECT ... FOR UPDATE against the target row to obtain a row-level lock, protecting the record from concurrent modification during an edit or processing transaction.
  • UPDATE_ROW — Modifies the columns of an existing award item row, re-applying the audit columns and committing the validated changes.
  • ADD_ROW — A higher-level entry point that coordinates the addition of a new award item, typically invoked by forms or callers that require the insert path plus associated validations.
  • DELETE_ROW — Removes an award item row, normally after the caller has validated that the row may be deleted.
  • GET_PK_FOR_VALIDATION — Resolves the primary key for the row so that validation logic can uniquely identify the record being processed.
  • BEFORE_DML — A pre-DML hook that executes common validation and defaulting logic, such as populating WHO columns via FND_GLOBAL, before insert or update proceeds.

No parameter lists are documented in the ETRM metadata, so signatures should be confirmed against the deployed source before reuse.

Tables Accessed

The only documented table referenced through APPS synonyms is IGF_AW_ITEM. All five DML operations — insert, lock, update, add, and delete — and the primary-key lookup target this single table. The package reads and writes here because IGF_AW_ITEM is the sole persistent store for award item detail; there are no documented child or lookup tables accessed directly by this package body.

Usage Notes

Because IGF_AW_ITEM_PKG is a row-handler package rather than a public API, it is invoked indirectly. Its principal callers are Oracle Forms-based award maintenance screens, concurrent programs that process or adjust award items, and custom extensions that need to manipulate award item records while respecting the same validation and locking rules. The package depends on IGF_AW_ITEM and on several sibling packages, including IGF_AW_COA_GRP_ITEM_PKG, IGF_AW_COA_ITEMS_PKG, and IGS_GE_MSG_STACK, and on standard utilities such as APP_EXCEPTION, FND_GLOBAL, and FND_MESSAGE. The ETRM metadata notes that the package body is not referenced by any database object but is referenced by two other packages, indicating it functions as a supporting layer rather than a top-level interface. Custom code should not call these procedures directly unless the calling transaction also supplies the validation that the Forms layer would normally provide.