Search Results teach_periods

Overview

IGF_AW_GEN_003 is a general-purpose PL/SQL package body in the Oracle E-Business Suite 12.1.1 / 12.2.2 Financial Aid (IGF) module, part of the Award (AW) subsystem. The package encapsulates the core disbursement-generation logic used by the Student Aid award engine: it determines how many disbursements should be produced for a distribution plan, calculates disbursement amounts and dates, applies award-period term rules, creates holds where awards are exceeded, and posts the resulting data to the accounts-payable base records. The single-source header comments indicate the body has existed since the early releases of the product and was most recently modified in the 12.x code line (file version 120.23). Because the module is classified as OTHER rather than a published public API, it is intended for internal invocation by the Financial Aid award programs and forms rather than for direct customer use. The user search term teach_periods refers to the IGF_AW_DP_TEACH_PRDS table, which stores teaching-period definitions attached to distribution-plan terms and which several functions here use to validate that common terms exist between an award and its associated plan.

Key Procedures and Functions

The body exposes nineteen documented procedures and functions:

• GET_PLAN_DISB_COUNT — returns the number of disbursements scheduled for a distribution plan, optionally filtered by award period code; internally opens cursors against IGF_AW_DP_TERMS joined to IGF_AW_DP_TEACH_PRDS to test for common terms.
• GET_COMMON_PERCT — computes the percentage of terms shared between a plan and its award.
• CHECK_COMMON_TERMS — validates that common terms exist between plan and award.
• CREATE_AUTO_DISB — the principal disbursement generator, inserting disbursement records into IGF_AW_AWD_DISB_ALL.
• CREATE_PELL_DISB — creates Pell Grant-specific disbursement records.
• ROUND_OFF_DISBURSEMENTS — applies rounding rules to calculated disbursement amounts.
• CHECK_AMOUNTS and CHECK_DISBDTS — validation routines for disbursement amounts and dates.
• CHECK_COA — validates chart-of-accounts combinations.
• GET_TOTAL_DISB — returns the aggregate disbursed amount.
• UPDATE_ACCEPT_AMOUNT — updates the accepted amount on an award.
• UPDATE_BILL_FLAG — maintains billing indicator state.
• UPDATE_AWD_CANCELL_TO_OFFER, UPDATE_AWARD_APP_TRANS, REMOVE_AWD_RULES_OVERRIDE, UPDATING_COA_IN_FA_BASE — update award, application-transaction, rule-override, and FA-base COA data.
• CREATE_OVER_AWD_HOLDS — inserts holds when disbursements would exceed the award.
• AWD_GROUP_FREEZE — controls freezing of an award group.
• DELETE_AWD_DISB — deletes award disbursement records.

Tables Accessed

Documented table references include IGF_AW_AWD_DIST_PLANS and IGF_AW_DP_TEACH_PRDS (distribution plans and their teaching periods), IGF_AW_AWD_PRD_TERM (award period term definitions), IGF_AW_AWD_DISB_ALL (the disbursement repository), IGF_AW_AWARD_ALL and IGF_AW_AWARD_T_ALL (award header and translation tables), IGF_AW_FUND_CAT_ALL and IGF_AW_FUND_MAST_ALL (fund category and master data), IGF_AW_COA_ITEMS and IGF_AW_COA_ITM_TERMS (chart-of-accounts item and term mappings), IGF_AW_DB_CHG_DTLS (disbursement change details), IGF_AP_FA_BASE_REC_ALL, IGF_AP_BATCH_AW_MAP_ALL, and IGF_AP_ISIR_MATCHED_ALL (accounts-payable base, batch mapping, and ISIR match data), plus FND_NEW_MESSAGES for user-facing messages. These tables supply the plan definitions read at the start of disbursement generation and receive the disbursement, hold, and COA updates written at the end.

Usage Notes

IGF_AW_GEN_003 is invoked indirectly by the Financial Aid award maintenance forms and by the concurrent programs that mass-generate and adjust award disbursements. Four other packages reference it, so changes to its signature or cursor logic can cascade across the award subsystem. In 12.1.1 and 12.2.2 no functional differences in this object are documented; the same PL/SQL is delivered in both releases. Customizations should call the underlying public award APIs rather than this body directly, and any extension that queries teach_periods should preserve the join between IGF_AW_DP_TERMS and IGF_AW_DP_TEACH_PRDS to avoid breaking the common-term validation performed by GET_PLAN_DISB_COUNT and CHECK_COMMON_TERMS.