Results for “get_headings”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGF_AW_GEN_004 is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the Financial Aid module of the Oracle Student System / Student Aid product family (the "IGF" prefix denotes the Oracle Financial Aid schema). Its role is to provide the server-side logic used primarily in the generation and processing of award notification letters and related financial aid correspondence. The package consolidates a set of wrapper functions and utility routines that assemble the data required by the award letter templates — including award amounts, expected family contribution (EFC), unmet need, and need calculations — and returns formatted heading and award detail strings to the letter-generation engine.

Key Procedures and Functions

The package exposes eighteen documented procedures and functions. The most significant include:

• CORP_PRE_PROCESS — the main pre-processing driver for correspondence. It accepts document, selection, person, list, and letter type parameters, and returns an out-bind SQL statement and exception message used by the correspondence framework.
• GET_HEADINGS — returns heading text for the award letter, typically driven by a person identifier. This is the routine most commonly referenced when users search for "get_headings".
• GET_AWARD_DATA — retrieves award detail information for a person and fund, accepting optional parameters that control which award fields are returned.
• EFC_I, EFC_F, NEED_I, NEED_F, UNMETNEED_I, UNMETNEED_F — the paired interface/function ("_I"/"_F") routines that compute Expected Family Contribution, need, and unmet need values.
• IS_INAS_INTEGRATED — a flag function indicating whether the INAS integration is active.
• GET_TERM_TOTAL, GET_AWARD_DESC, GET_CORR_CUST_TEXT — retrieve award totals, award descriptions, and customised correspondence text.
• GET_BASE_ID_FOR_PERSON and GET_PERSON_ID — identifier lookup helpers added for award notification processing.
• LOAN_DISBURSEMENT_UPDATE, MISSING_ITEMS_UPDATE, AWARD_LETTER_UPDATE — maintenance routines that update disbursement, missing-item, and award-letter records.

Tables Accessed

The package reads and writes the core financial aid tables (accessed through APPS synonyms), including:

• IGF_AP_FA_BASE_REC_ALL — the base financial aid record, keyed by base_id.
• IGF_AW_AWARD_ALL and IGF_AW_AWD_LTR_TMP — award records and the award letter template.
• IGF_AW_AWD_PRD_TERM and IGF_AP_FA_BASE_REC_ALL — awarding-period setup and term data.
• IGF_AP_CSS_PROFILE_ALL — CSS/need-analysis profile details for EFC and need calculations.
• IGF_AP_ST_CORR_TEXT — custom correspondence text.
• IGF_DB_AWD_DISB_DTL_ALL — disbursement detail for loan updates.
• IGF_AW_FUND_MAST_ALL — fund master data.
• IGF_AP_TD_ITEM_INST_ALL — tracking/missing item instances.
• IGS_CA_INST_ALL, IGS_CO_MAPPING, IGS_PE_PERSID_GROUP_ALL — institution, mapping, and person-ID group data.
• DUAL and PLITBLM — Oracle/PL/SQL utility tables.

Usage Notes

IGF_AW_GEN_004 is invoked from award letter correspondence processing within the Student Aid module and is referenced by ten other packages. CORP_PRE_PROCESS is typically driven by concurrent programs or the correspondence engine, while the GET_* and EFC_*/NEED_*/UNMETNEED_* routines are called during letter merge for each recipient. Because the package header carries a "noship" designation and specific FA bug-fix history (FA 124, 137, 152, 157), it should be treated as an internal Oracle module: custom code should call the documented public routines rather than reference internals directly.