Search Results igf_ap_gen




Overview
Explore in AI Chat

Overview

IGF_AP_GEN is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the Financial Aid module of Oracle Student System (formerly Oracle Student Financial Aid), which is delivered under the IGF and IGS object prefixes. The package serves as a general-purpose utility and validation library supporting the automated packaging, disbursement, and tracking of Title IV and institutional financial aid awards. Its responsibilities include translating lookup codes into human-readable meanings, validating borrower and person records, verifying the eligibility of calendar and award-year instances, evaluating batch integrity, retrieving student ISIR data and Expected Family Contribution (EFC) values, computing both individual and cumulative Cost of Attendance (COA) amounts, and updating the status of disbursement items and preferred-lender to-do records.

Consistent with its documented classification of OTHER, IGF_AP_GEN is not a public API in the sense of a business-facing interface; rather, it is an internal helper package invoked by other Financial Aid processing routines. The dependency metadata shows that it is referenced by 24 other packages and references approximately fifteen package bodies directly, including IGF_AP_EFC_CALC, IGF_AP_TD_ITEM_INST_PKG, and IGF_AP_GEN itself.

Key Procedures and Functions

The ETRM metadata documents twelve procedures and functions in the 12.1.1 release. Their purposes are as follows:

Tables Accessed

The package reads and writes a defined set of APPS-synonymed base tables. Federal and ISIR-related data is held in IGF_AP_ISIR_MATCHED_ALL, IGF_AP_FA_BASE_REC_ALL, and IGF_FC_SAR_CD_MST. Award and cost-of-attendance data resides in IGF_AW_COA_ITM_TERMS and IGF_AW_LI_COA_INTS. Term item and disbursement data is stored in IGF_AP_TD_ITEM_INST_ALL, IGF_AP_TD_ITEM_MST_ALL, IGF_AP_LI_BAT_INTS (via the IGF_AP_TD_ITEM_INST_PKG dependency), and the IGF_AP_TD_ITEM_INST_V view. Preferred-lender loan processing relies on IGF_SL_CL_PREF_LENDERS. Person and party validation uses HZ_PARTIES and IGS_PE_HZ_PARTIES. Calendar and award-year context is supplied by IGS_CA_INST_ALL, IGS_CA_INST_REL, IGS_CA_TYPE, IGS_CA_LOAD_TO_TEACH_V, and IGS_PE_PERSON_BASE_V. Utility and messaging behaviour depends on DBMS_SQL, DBMS_UTILITY, FND_MESSAGE, FND_PROFILE, WF_EVENT, and APP_EXCEPTION.

Usage Notes

IGF_AP_GEN is invoked indirectly through Financial Aid setup forms, concurrent programs that generate and track Title IV disbursements, and batch processes that update borrower, ISIR, and preferred-lender records. Because it depends on FND_PROFILE and FND_MESSAGE, it must run within an APPS session where profile options and message dictionaries are available. Custom extensions should treat it as a supporting utility: callers should not rely on internal procedure signatures unless the package is wrapped and versioned, since Oracle EBS 12.1.1 and 12.2.2 patches may replace the body. Direct modification is not supported, and any custom validation should prefer the documented public APIs that already call this package.