Search Results get_coa_months

Overview

IGF_AW_PACKNG_SUBFNS is a PL/SQL package owned by APPS that supports award packaging and fund-disbursement calculations within the Oracle E-Business Suite Financial Aid / Student Aid module (IGF). Its name reflects its role as a "subfunctions" utility layer invoked by the main packaging engine, providing reusable routines that evaluate student eligibility, loan limits, and award classifications against federal and institutional rules. The package header carries a revision history spanning 2003 through 2006, including references to Build# FA157 (Bug# 4382371), FA 125 (Multiple distribution methods), and Bug# 3360702, indicating it evolved alongside the award distribution plans and needs-analysis features.

The source header confirms that several legacy routines — specifically get_coa_months and stud_elig_chk — were obsoleted on 11-Oct-2004 by developer veramach. This is directly relevant to users searching for "get_coa_months": that procedure no longer exists as a callable API in this package, and any reference to it in documentation or custom code predates the 2004 consolidation.

Key Procedures and Functions

• CHECK_LOAN_LIMITS — Validates whether a student's loan amounts fall within applicable limits, using base ID, fund type, award ID, and distribution plan ID. The header notes parameters l_awd_period and l_called_from were added under Bug# 4382371, and that the signature changed from fund_id to adplans_id under FA 125. It returns a message name and optionally enforces aggregate limits.
• GET_FED_EFC — Retrieves the federal Expected Family Contribution (EFC) values for a given base ID and award period code, returning an EFC amount, a Pell-specific EFC, and an academic-year EFC.
• GET_CLASS_STND — Returns the classification standing for a student, based on base ID, person ID, distribution plan ID, award ID, and course type. The source notes an award_id parameter was added under Bug# 3360702 and the signature was reworked to use adplans_id.
• IS_OVER_AWARD_OCCURED — Determines whether an over-award condition has occurred for a student, a check central to packaging validation.

The package also declares a record type std_loan_rec and table type std_loan_tab for passing standard loan data between routines.

Tables Accessed

The package reads and writes against a broad set of APPS synonyms representing the core Financial Aid data model. Award and fund information is drawn from IGF_AW_AWARD_ALL, IGF_AW_FUND_CAT_ALL, IGF_AW_FUND_MAST_ALL, and IGF_AW_AWD_PRD_TERM. Distribution and disbursement logic depends on IGF_AW_AWD_DISB_ALL, IGF_AW_AWD_DIST_PLANS, and IGF_AW_DP_TERMS. Student need and ISIR data comes from IGF_AP_FA_BASE_REC_ALL, IGF_AP_FA_ANT_DATA, and IGF_AP_ISIR_MATCHED_ALL. Loan processing uses IGF_AW_LOAN_LIMIT_ALL, IGF_SL_LOANS_ALL, and IGF_SL_LOR_ALL, while classification mapping relies on IGF_AP_CLASS_STD_MAP and IGS_PS_VER_ALL.

Usage Notes

IGF_AW_PACKNG_SUBFNS is not a standalone user-facing API; it is called internally by the packaging engine and by 13 other documented packages. It is typically invoked during award packaging runs, when the system evaluates loan eligibility, EFC figures, classification standing, and over-award conditions. Customizations referencing the obsoleted get_coa_months or stud_elig_chk routines must be migrated to the surviving procedures listed above. Both 12.1.1 and 12.2.2 environments retain this package structure, though the file header indicates no active maintenance after the 2006 revision.