Search Results igf_aw_award_level_hist_pkg




Overview
Explore in AI Chat

Overview

IGF_AW_AWARD_LEVEL_HIST_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Oracle Grants Management (formerly Oracle Grants Accounting) module. Its specific responsibility is to manage the award level history records associated with awards processed through the IGF (Grants) application family. Award level history captures the chronological record of changes to an award's funding levels, enabling institutions to track how an award amount was established, revised, supplemented, or reduced over its lifecycle. The package conforms to the standard Oracle EBS table-handler (TPK) design pattern, exposing a stable, encapsulated API against the underlying IGF_AW_AWARD_LEVEL_HIST table so that dependent programs and forms need not issue direct DML. The ETRM metadata records the package as VALID and classifies it as an OTHER API type, meaning it is not a public, externally supported interface but an internal implementation utility used by other Grants module components.

Key Procedures and Functions

The package exposes nine documented procedures and functions, consistent with the Oracle table-handler convention:

  • INSERT_ROW — Inserts a new award level history row, typically invoked when a new award level record is created.
  • LOCK_ROW — Acquires a row-level lock on an existing history record, used to guarantee consistency before updates or deletes within a transaction.
  • UPDATE_ROW — Modifies the attributes of an existing award level history row.
  • ADD_ROW — Provides the higher-level entry point that combines validation and insertion of a history row.
  • DELETE_ROW — Removes a history row from the base table.
  • GET_PK_FOR_VALIDATION — Retrieves the primary key of a history record for validation purposes, supporting referential or uniqueness checks.
  • GET_FK_IGF_AW_AWD_DIST_PLANS — Resolves the foreign key relationship to the award distribution plan entity, returning the key value needed to associate a history row with its distribution plan.
  • GET_FK_IGF_AW_AWARD — Resolves the foreign key relationship to the parent award, returning the award identifier used to tie each history row to its award.
  • BEFORE_DML — The standard pre-DML trigger procedure that performs WHO-column population and other row-level defaulting and validation logic prior to insert, update, or delete.

Tables Accessed

The package reads and writes IGF_AW_AWARD_LEVEL_HIST, accessed through the APPS synonym. This table stores the historical funding-level records for awards, including the association to the parent award (IGF_AW_AWARD) and to the award distribution plan (IGF_AW_AWD_DIST_PLANS), both of which are resolved via the GET_FK_* functions. The dependency metadata also shows references to the SYS.STANDARD package supplied by the PL/SQL runtime, reflecting ordinary language-level constructs rather than application logic.

Usage Notes

Because the package is a table handler, it is normally invoked indirectly. The documented dependency information shows that IGF_AW_AWARD_LEVEL_HIST_PKG is referenced by two other packages: IGF_AW_AWARD_PKG and IGF_AW_LI_IMPORT. IGF_AW_AWARD_PKG is the primary award maintenance package, and it calls the level history handler whenever award level data is created or changed. IGF_AW_LI_IMPORT handles import processing, so the history handler is also exercised during bulk award or award-line import routines that must record level history entries. In practice, the procedures execute in response to award form submissions, concurrent import programs, and any custom extensions that maintain award levels. Developers should call the package's procedures rather than writing directly to IGF_AW_AWARD_LEVEL_HIST, since the package enforces the BEFORE_DML defaulting and validation logic and preserves the foreign key integrity linking history rows to awards and distribution plans.