Results for “get_corr_cust_text”

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

Overview

IGF_AW_GEN_004 is an Oracle E-Business Suite PL/SQL package body owned by APPS and classified as OTHER in the ETRM repository. It belongs to the Oracle Financial Aid (IGF) module and functions as a utility and wrapper library that supports award notification letter generation, award data retrieval, and needs-analysis calculations. The package sits between the higher-level letter and correspondence processes and the underlying Financial Aid base tables, exposing reusable functions that other packages, wrappers, and concurrent processes call to obtain award, term, and need figures.

According to the change history embedded in the source header, the package evolved across several Financial Aid releases: FA 124, FA 134, FA 137, FA 152, and FA 157. Notable changes included adding the get_base_id_for_person function, modifying corp_pre_process and build_sql_stmt to support dynamic and static person-id groups, resolving an issue where freq_attempt for one item was incorrectly added to other items, and refactoring code to address problems with very large person-id groups.

Key Procedures and Functions

The ETRM metadata documents 18 procedures and functions. They fall into several functional categories:

• Wrapper data retrieval — CORP_PRE_PROCESS, GET_AWARD_DATA, GET_TERM_TOTAL, and their wrapper counterparts (get_award_data_wrap, get_term_total_wrap) retrieve award and term totals for a person, accepting a person identifier and fund identifier along with a set of parameter slots. The wrappers expose these operations to the letter/reporting layer.
• Needs analysis — EFC_I, EFC_F, NEED_I, NEED_F, UNMETNEED_I, and UNMETNEED_F compute Expected Family Contribution, need, and unmet need. The _I suffix indicates an internal implementation and _F a function variant, used across the awarding letter logic.
• Letter and correspondence support — GET_HEADINGS returns column or section headings for letters; GET_AWARD_DESC returns award descriptions; GET_CORR_CUST_TEXT retrieves customized correspondence text; AWARD_LETTER_UPDATE updates the award letter record; LOAN_DISBURSEMENT_UPDATE maintains loan disbursement information.
• Data maintenance — MISSING_ITEMS_UPDATE processes items that were not previously captured, and GET_BASE_ID_FOR_PERSON and GET_PERSON_ID resolve identifiers, with the base-id function added in FA 157.
• Configuration checks — IS_INAS_INTEGRATED determines whether Institutional Needs Analysis System integration is active.

Based on the header excerpt, the wrappers expose parameters for person, fund, up to seven generic parameter slots, a flag, and an OUT total (for example p_awd_tot).

Tables Accessed

The package references the following APPS synonyms: IGF_AP_FA_BASE_REC_ALL and IGF_AP_CSS_PROFILE_ALL (base and CSS profile records for needs analysis), IGF_AW_AWARD_ALL and IGF_AW_AWD_PRD_TERM (award and award period/term detail), IGF_AW_FUND_MAST_ALL (fund setup), IGF_AW_AWD_LTR_TMP (award letter temporary staging), IGF_AP_ST_CORR_TEXT (correspondence text), IGF_AP_TD_ITEM_INST_ALL (item instances), IGF_DB_AWD_DISB_DTL_ALL (disbursement detail), IGS_CA_INST_ALL (calendar instances), IGS_CO_MAPPING and IGS_PE_PERSID_GROUP_ALL (person id groups), and the standard DUAL and PLITBLM utilities.

Usage Notes

IGF_AW_GEN_004 is not an end-user API; it is an internal library invoked from other PL/SQL units. The metadata records it as referenced by 10 other packages, and the header notes that dynamic and static person-id groups drive letter SQL statements through calls to IGS_PE_DYNAMIC_PERSID_GROUP.IGS_GET_DYNAMIC_SQL (changed from a procedure to a function). Applications include award notification letter generation, needs-analysis display, and correspondence processing within the Financial Aid module. Custom code extending Financial Aid letters should call the wrapper functions rather than duplicating award, term, need, or unmet-need logic. The large person-id group refactoring indicates the package should be used in a manner that avoids constructing excessive individual identifiers.