Search Results igf_gr_pell_calc




Overview
Explore in AI Chat

Overview

IGF_GR_PELL_CALC is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the Oracle Student System / Financial Aid (IGF) product family. Its business function is to compute United States federal Pell Grant award amounts and to derive the disbursement quantities that flow into the financial aid disbursement process. Pell Grants are needs-based, entitlement-style awards whose value depends on the student's enrollment status, the academic term structure, the institution's cost of attendance, and the federal award schedule defined for the award year. IGF_GR_PELL_CALC encapsulates the institution-specific rules that translate a student's attendance pattern and the Pell award matrix into actual dollar amounts and expected disbursement counts for a term or award period.

The package is central rather than peripheral: it is referenced by eight other packages, including IGF_GR_PELL, IGF_GR_GEN_XML, IGF_AW_PACKAGING, IGF_DB_DISB, IGF_SL_REL_DISB, IGF_GR_REPACKAGE, IGF_GR_RFMS_ORIG, and IGF_AW_GEN_003, and it participates in the Records/FM (RFMS) origination flow. The status of the object is VALID in both the 12.1.1 and 12.2.2 documented environments, and its API classification is recorded as OTHER, meaning it is an internal calculation utility rather than a formally published public API.

Key Procedures and Functions

Nine documented procedures and functions constitute the package's functional surface:

  • GET_PELL_SETUP — Retrieves the institution's Pell configuration records, establishing the parameters that govern subsequent award calculations.
  • GET_PELL_COA_EFC — Obtains the cost of attendance and the Expected Family Contribution used to determine need and award level.
  • GET_PELL_ATTENDANCE_TYPE — Derives the student's attendance/enrollment classification, which drives the fractional award percentages applied to a full-time award.
  • GET_PELL_MATRIX_AMT — Resolves the applicable amount from the Pell award matrix (schedule) for the award year.
  • CALC_PELL — Performs the core Pell award computation, combining setup, need, attendance, and matrix values.
  • PELL_ELIG — Evaluates Pell eligibility for the student or award record.
  • CALC_TERM_PELL — Computes the Pell amount attributable to a specific academic term.
  • CALC_FT_MAX_PELL — Determines the maximum full-time Pell award, used as the basis for prorating part-time awards.
  • NUM_DISB — Calculates the number of disbursements, supporting the payment schedule generated for the award.

Tables Accessed

The package reads and writes through APPS synonyms. Core award and fund configuration is held in IGF_GR_PELL_SETUP_ALL, IGF_AW_FUND_MAST_ALL, IGF_AW_AWD_DIST_PLANS, IGF_AW_DP_TERMS, IGF_AW_DP_TEACH_PRDS, IGF_AW_ITEM, IGF_AW_COA_ITEMS, and IGF_AW_COA_ITM_TERMS. Student-level data is drawn from IGF_AP_FA_BASE_REC_ALL, IGF_AP_FA_ANT_DATA, IGF_AP_ATTEND_MAP_ALL, and IGF_AP_BATCH_AW_MAP_ALL. Term and calendar context comes from IGS_CA_INST_ALL, while IGF_GR_ALT_AMTS supplies alternate amount adjustments and FND_NEW_MESSAGES is used for error/notification messaging.

Usage Notes

IGF_GR_PELL_CALC is not typically invoked directly from a form. It is called by the higher-level Pell processing and packaging packages (IGF_GR_PELL, IGF_AW_PACKAGING), by disbursement and release logic (IGF_DB_DISB, IGF_SL_REL_DISB), and by the XML/origination generators (IGF_GR_GEN_XML, IGF_GR_RFMS_ORIG) that submit Pell records to the federal Common Origination and Disbursement system. Customizations should avoid modifying the packaged logic; instead, institution-specific values should be maintained through the documented setup tables so that CALC_PELL, CALC_TERM_PELL, and NUM_DISB produce compliant results.