Search Results calculate_efc

Overview

IGF_AP_EFC_CALC is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the "OTHER" API category. It belongs to the Oracle Financial Aid (IGF) product family and supports the Expected Family Contribution (EFC) calculation logic used by the institution's financial aid processing. The package header, identified internally as IGFAP25S.pls, was originally authored in December 2001 to resolve Bug 2142666, which concerned the EFC Download (DLD) process. Its core purpose is to provide the program units required by the EFC Calculation concurrent program, which determines a student's expected financial contribution based on ISIR (Institutional Student Information Record) data.

The package is declared with AUTHID CURRENT_USER, meaning that its executing privileges are resolved against the invoking schema rather than the defining schema, a design typical of EBS packages that must respect the security context of the calling application.

Key Procedures and Functions

The documented package exposes two primary program units:

• GET_EFC_NO_OF_MONTHS — A function that returns a numeric value representing the number of months applicable to an award calculation. As described in the source comments, its purpose is to determine the exact number of months across an academic period while avoiding double-counting of overlapping terms and disregarding gaps between terms. It was modified under Bug 2613546 (October 2003), at which point the previously used P_flag parameter was dropped from its signature, leaving the end date of the last teaching/load calendar and the student's base identifier as its inputs.
• CALCULATE_EFC — A procedure that performs the principal EFC computation, accepting an ISIR matched record as an IN OUT NOCOPY parameter. This is the driving routine invoked by the EFC Calculation concurrent program; it evaluates the matched ISIR data and populates the EFC values.

The package also declares package-level exceptions (EXCEPTION_IN_REJECTS and EXCEPTION_IN_SETUP) and global variables typed against the paid_efc column of IGF_AP_ISIR_MATCHED_ALL, used to hold intermediate EFC amounts.

Tables Accessed

The package interacts with the following documented tables through APPS synonyms:

• IGF_AP_ISIR_MATCHED_ALL — The base table holding matched ISIR records; the package reads and writes EFC values here, and uses its paid_efc column to type the global holders.
• IGF_AW_COA_ITM_TERMS — Provides the award COA item term data used to derive term and month counts for the calculation.
• IGF_FC_EFC_ALT_FAC — Supplies alternative EFC factor data used in the computation logic.

Usage Notes

IGF_AP_EFC_CALC is not intended for direct end-user invocation. It is called by the EFC Calculation concurrent program and is referenced by seven other packages within the financial aid module. Because its logic depends on matched ISIR and award term data, it must run after ISIR matching and setup data have been established; otherwise the package raises EXCEPTION_IN_SETUP or EXCEPTION_IN_REJECTS. Customizations should avoid altering the signature of GET_EFC_NO_OF_MONTHS, since the P_flag removal was a deliberate backward-incompatible change in the delivered code.