Search Results remove_awd_rules_override

Overview

IGF_AW_GEN_003 is a PL/SQL package in the Oracle E-Business Suite Applications (APPS) schema that supports the Award Management functionality of Oracle Student System / Financial Aid (the IGF module family). It belongs to the family of generated award processing packages (the "IGF_AW_GEN_00x" series) that encode the core business rules for award disbursement scheduling, award status transitions, and award amount validation.

The package is classified under the ETRM (E-Business Suite Technical Reference Manual) as an OTHER API, meaning it is not a formally published public API but is a supporting internal package invoked by forms, concurrent programs, and other packages within the Financial Aid award workflow. Its principal responsibilities are: automatically generating disbursement schedules when an award is created or modified, rounding and reconciling disbursement amounts, synchronising the award accepted amount with the disbursement table, handling status reversals (cancelled/declined back to offered/accepted), validating award and disbursement dates and amounts, and managing holds triggered by over-award conditions. The package header carries a CVS revision marker of 120.1 dated 2005/07/01, consistent with the 12.1.1 code line and unchanged in 12.2.2.

Key Procedures and Functions

The package exposes 19 documented procedures. The ETRM metadata for the user query term get_total_disb is satisfied by the GET_TOTAL_DISB procedure, which returns the aggregate disbursement total for an award and is typically consumed by validation and amount-reconciliation logic. The documented procedures are grouped as follows:

• CREATE_AUTO_DISB – generates the automatic disbursement schedule for an award, using the fund, award, offered amount, award status, distribution plan, plan method code, and award period code as the controlling inputs.
• ROUND_OFF_DISBURSEMENTS – adjusts generated disbursement lines so that rounding differences reconcile to the offered amount, using the distribution plan method code and the disbursement count.
• UPDATE_ACCEPT_AMOUNT – writes the accepted amount back to the disbursement table when an award moves from Offered to Accepted and the accepted amount is null or zero (Bug 2332588).
• UPDATE_AWD_CANCELL_TO_OFFER – restores transaction type, eligibility status, eligibility date, and award amount when an award transitions from Cancelled or Declined back to Offered or Accepted (Bug 2375571).
• REMOVE_AWD_RULES_OVERRIDE and CREATE_OVER_AWD_HOLDS – clear rule overrides and place holds when an over-award condition is detected.
• UPDATING_COA_IN_FA_BASE, CHECK_COA – maintain and validate Chart of Accounts values on the Financial Aid base record.
• CHECK_AMOUNTS, CHECK_DISBDTS, CHECK_COMMON_TERMS, GET_COMMON_PERCT – validate award amounts, disbursement dates, and common term percentages.
• UPDATE_BILL_FLAG, DELETE_AWD_DISB, AWD_GROUP_FREEZE, GET_PLAN_DISB_COUNT, GET_TOTAL_DISB, CREATE_PELL_DISB, UPDATE_AWARD_APP_TRANS – manage billing flags, remove disbursement lines, freeze award groups, count plan disbursements, total disbursements, create Pell disbursements, and update award application transactions.

Tables Accessed

The package reads and writes through APPS synonyms. Principal award tables are IGF_AW_AWARD_ALL and IGF_AW_AWARD_T_ALL (award header and translated award), and disbursement data resides in IGF_AW_AWD_DISB_ALL. Distribution planning uses IGF_AW_AWD_DIST_PLANS, IGF_AW_AWD_PRD_TERM, IGF_AW_DP_TEACH_PRDS, and IGF_AW_DB_CHG_DTLS. Award funding is drawn from IGF_AW_FUND_MAST_ALL and IGF_AW_FUND_CAT_ALL, while chart-of-accounts validation uses IGF_AW_COA_ITEMS and IGF_AW_COA_ITM_TERMS. Student and application data flow through IGF_AP_FA_BASE_REC_ALL, IGF_AP_ISIR_MATCHED_ALL, and IGF_AP_BATCH_AW_MAP_ALL. Error messaging uses FND_NEW_MESSAGES.

Usage Notes

IGF_AW_GEN_003 is normally invoked indirectly: Award Management forms call it during award creation, status change, and disbursement regeneration; concurrent programs may call it for bulk award processing. It is referenced by four other packages, and custom extensions should call the documented procedures rather than the underlying tables to preserve award/disbursement integrity. No public parameter documentation exists beyond the header excerpt, so callers should rely on the shipped signatures and treat the package as internal to the 12.1.1 / 12.2.2 code line.