Search Results igf_aw_coa_gen




Overview
Explore in AI Chat

Overview

IGF_AW_COA_GEN is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema that supports the Award year-end processing and Cost of Attendance (COA) generation functions within the Oracle Student Financial Aid (formerly Oracle Financial Aid) module, part of the broader Oracle Advanced Benefits / Student Systems footprint in EBS 12.1.1 and 12.2.2. The package is classified as an "OTHER" API type, meaning it is an internal supporting package rather than a fully published public API; it nonetheless forms part of the integration layer that the financial aid front-end forms and concurrent programs call to build, validate, and persist award period COA data.

The primary business purpose is to generate Cost of Attendance records for a student's award period by aggregating institutional, enrollment, and packaging data. It coordinates with the award packaging engine (IGF_AW_PACKAGING), the award definition tables, and the enrollment tables from the Student Systems (IGS) schema to determine eligible periods, enrollment intensity, and award amounts. Documented metadata shows the body exposes thirteen procedures and functions and references a broad set of awards, enrollment, and person tables, confirming it is a core data-preparation utility for term-based COA and disbursement calculations.

Key Procedures and Functions

The documented entry points (13 total) include:

  • COA_AMOUNT — returns the computed Cost of Attendance amount for a given award period context.
  • AWARD_AMOUNT — returns the award amount applicable to the period being processed.
  • ISCOALOCKED — checks whether COA generation is currently locked to prevent concurrent modification.
  • DOLOCK — acquires the COA lock prior to processing.
  • DOUNLOCK — releases the COA lock after processing completes.
  • GETBASEDETAILS — retrieves the base award or base record details used as the foundation for COA computation.
  • INS_COA_TODO — inserts a todo or work item into the student todo list (IGS_PE_STD_TODO) indicating COA action is required.
  • GET_COA_MONTHS — derives the number of months in the COA period, used for prorating amounts.
  • SET_AWD_PROC_STATUS — updates the award processing status on the award record.
  • GET_AWARD_PERIOD_DATES — returns the effective start and end dates for the award period.
  • CANUSEANTICIPVAL — determines whether anticipated award values may be used in the computation.
  • CHECK_OSS_ATTRIB — validates Oracle Student System attributes relevant to the COA calculation.
  • COA_DURATION — computes the duration of the COA period.

No parameter lists are documented; the descriptions above are limited to documented purpose.

Tables Accessed

Documented table references (through APPS synonyms) include the award and award-period tables IGF_AW_AWARD_ALL, IGF_AW_AWARD_PRD, IGF_AW_AWD_PRD_TERM, and IGF_AW_AWD_DISB_ALL, which supply the award, period, term, and disbursement context. COA-specific tables IGF_AW_COA_ITEMS, IGF_AW_COA_ITM_TERMS, and IGF_AW_COA_RATE_DET hold the COA line items, their term mapping, and rate detail used to build a student's cost budget. IGF_AW_ITEM and IGF_AP_FA_ANT_DATA, IGF_AP_FA_BASE_REC_ALL, and IGF_AP_BATCH_AW_MAP_ALL provide item definitions, anticipated/actual financial aid data, base record data, and batch-award mapping. Enrollment and person context come from HZ_PARTIES, IGS_EN_SPA_TERMS, IGS_PE_STD_TODO, and IGS_PE_TEACH_PERIODS_ALL. The package therefore reads institutional and enrollment attributes and writes COA, award status, and todo records.

Usage Notes

IGF_AW_COA_GEN is invoked internally by the financial aid award packaging and year-end COA processes rather than through a public API contract. It is referenced by seventeen other database objects, indicating it is a shared utility called from sibling packages such as IGF_AW_PACKAGING, IGF_AW_AWARD_PKG, IGF_AW_COA_ITEMS_PKG, IGF_AW_COA_ITM_TERMS_PKG, and various IGS/IGF generator packages. Typical invocations occur when a COA record must be created or refreshed for a student's award period, and the lock/unlock pair (ISCOALOCKED, DOLOCK, DOUNLOCK) protects against concurrent generation. Because it is an internal package, customization should be avoided; extension should be performed through supported credit or packaging rules. Support for EBS 12.1.1 and 12.2.2 is consistent with the standard file naming and dependency footprint shown in the ETRM metadata.