Search Results check_plan_code

Overview

IGF_AW_GEN_005 is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, belonging to the Oracle Student Financial Aid (formerly Financial Aid) product family under the IGF module prefix. The package is a valid, compiled database object in both 12.1.1 and 12.2.2 releases and is classified as an OTHER API rather than a public open interface or a formal public API. Its principal responsibility is the maintenance and validation of award disbursement plans and distribution plans associated with financial aid awards. These plans determine how an awarded amount is spread across academic periods, how funds are sourced from the fund master, and how encumbrances and disbursements are subsequently released to students.

The package therefore sits in the award configuration and disbursement-planning layer of the Financial Aid subsystem, bridging award header data, distribution plan definitions, payment period terms, and fund master records. It is referenced by several higher-level packages, indicating that it acts as a shared internal utility rather than an end-user entry point.

Key Procedures and Functions

• UPDATE_PLAN — Maintains the primary award plan record, allowing plan-level attributes to be modified after initial award processing.
• UPDATE_DIST_PLAN — Updates the distribution plan, which governs the split of an awarded amount across terms and disbursement periods.
• CHECK_PLAN_CODE — Validates a plan code for existence and correctness before it is accepted into plan or distribution processing.
• DELETE_PLAN — Removes a plan record, typically during award revision or cancellation activity.
• GET_STUD_HOLD_EFFECT — Retrieves the effect of a student hold on disbursement, supporting compliance rules that prevent or delay release of funds.
• VALIDATE_STUDENT_EFC — Validates the student's Expected Family Contribution value, used in need-analysis-driven eligibility and packaging decisions.

The procedures cluster logically into plan maintenance (UPDATE_PLAN, UPDATE_DIST_PLAN, DELETE_PLAN, CHECK_PLAN_CODE), hold and disbursement control (GET_STUD_HOLD_EFFECT), and eligibility validation (VALIDATE_STUDENT_EFC).

Tables Accessed

The package reads and writes award and fund configuration data through APPS synonyms, including IGF_AP_FA_BASE_REC_ALL for the base financial aid record, IGF_AW_AWARD for award headers, IGF_AW_AWD_DIST_PLANS and IGF_AW_DP_TERMS for distribution plan and term definitions, IGF_AW_AWD_PRD_TERM for award period terms, and IGF_AW_FUND_MAST_ALL for the fund master. Student encumbrance, hold, and fund exclusion data are accessed via IGS_PE_PERSENC_EFFCT, IGS_PE_PERS_ENCUMB, and IGS_PE_FUND_EXCL, while IGF_AW_DP_TEACH_PRDS and DUAL support term and utility operations.

Usage Notes

IGF_AW_GEN_005 is not intended for direct end-user invocation. It is called from Oracle Forms and from concurrent or batch award processing programs, and it is referenced by IGF_AW_PACKAGING, IGF_AW_SS_GEN_PKG, IGF_DB_DISB, and IGF_SL_REL_DISB. Customizations should treat the package as an internal dependency and invoke the higher-level public APIs instead. Because procedures such as DELETE_PLAN and UPDATE_DIST_PLAN write to award data, any direct use should be performed within a controlled transaction with appropriate validation and rollback handling.