Search Results igf_aw_fund_mast_pkg




Overview
Explore in AI Chat

Overview

IGF_AW_FUND_MAST_PKG is an APPS-owned PL/SQL package in the Oracle E-Business Suite financial aid module (IGF), the schema family that supports Oracle Student Financial Aid and the awarding lifecycle. The package encapsulates the data-access and validation logic for the Fund Master entity, the master definition of a financial aid fund within the institution's awarding structure. It is classified as an OTHER API, meaning it is an internal implementation package rather than a formally published public API, and it is documented with VALID status in the ETRM repository for release 12.1.1. The package owns the insert, update, delete, lock, and validation operations against the Fund Master base table and its translation table, centralizing those operations so that the numerous dependent packages and forms modules do not manipulate the underlying tables directly. It is referenced by seventeen other packages in the APPS schema, confirming its role as a foundational dependency within the IGF awarding and fund setup architecture.

Key Procedures and Functions

The ETRM metadata documents eleven procedures and functions. The core DML operations are INSERT_ROW, UPDATE_ROW, and DELETE_ROW, which respectively create, modify, and remove Fund Master records, and ADD_ROW and BEFORE_DML, which support row creation and pre-DML processing. LOCK_ROW provides pessimistic locking of a Fund Master record, allowing callers to acquire a row lock before performing dependent updates. GET_PK_FOR_VALIDATION and GET_UK_FOR_VALIDATION are validation helpers: the former resolves the primary key of a Fund Master row, and the latter resolves the unique key used to confirm that a candidate record does not duplicate an existing entry. Three foreign-key retrieval functions are documented: GET_UFK_IGF_AW_FUND_CAT retrieves the value for the fund category unique foreign key, GET_FK_IGS_CA_INST retrieves the foreign key referencing the institution instance, and GET_FK_IGS_FI_CR_TYPES retrieves the foreign key referencing the credit types definition. Together these procedures and functions provide the persistence, locking, uniqueness checking, and referential validation surface required by the Fund Master entity.

Tables Accessed

The package accesses three tables through APPS synonyms. IGF_AW_FUND_MAST_ALL is the multi-org base table that stores Fund Master records for the current organization context; it is the principal target of the insert, update, delete, and lock operations. IGF_AW_FUND_MAST_S is the corresponding translated table, holding language-specific descriptive attributes for Fund Master rows, and is maintained alongside the base table where translatable columns exist. DUAL is used for single-row utility queries, typically for sequence value retrieval or constant evaluation during validation. The foreign-key functions reference institution and credit-type identifiers whose source tables are implied by the IGS_CA_INST and IGS_FI_CR_TYPES designators.

Usage Notes

Because IGF_AW_FUND_MAST_PKG is an internal data-access package rather than a public API, it is normally invoked indirectly. The seventeen dependent packages, including IGF_AW_AWARD_PKG, IGF_AW_FUND_CAT_PKG, IGF_AW_FUND_PRG_PKG, IGF_AW_FUND_TD_MAP_PKG, IGF_AW_FUND_TP_PKG, IGF_AW_FUND_UNIT_PKG, IGF_AW_FUND_INCL_PKG, IGF_AW_FUND_EXCL_PKG, IGF_AW_FUND_FEECLAS_PKG, and IGF_AW_ROLLOVER, call its procedures to read and validate Fund Master data while processing awards, funding categories, programs, and rollover activity. IGF_AW_GEN, IGF_SP_FC_PKG, IGF_SP_ROLLOVER, IGF_SP_STDNT_REL_PKG, and IGS_FI_BILL_PLN_CRD_PKG also depend on it. In practice the package is reached through the Fund Master setup forms in the Oracle EBS application, during fund definition maintenance, and through concurrent programs and custom extensions that create or validate fund records. Custom code should treat the package as an internal implementation detail and prefer the supported public APIs of the financial aid module where they exist.