Search Results update_awd_notification_status

Overview

IGF_AW_GEN is a general-purpose PL/SQL utility package in the Oracle E-Business Suite Financial Aid / Award (IGF) module, owned by the APPS schema. As its name and header comments indicate, it consolidates commonly used functions and procedures that support award processing, disbursement handling, notification management, and fund-period locking logic. The package header carries a long change history spanning Bug 2216956 (2002) through FA 157 (2005), reflecting its role as a shared utility layer reused across the IGF awarding and disbursement subsystems. It is referenced by approximately 190 other packages, confirming that it functions as a foundational library rather than a standalone business process driver.

Key Procedures and Functions

• LOOKUP_DESC — Returns a descriptive value for a given lookup type and lookup code, providing a centralised mechanism for translating coded values into user-facing descriptions.
• GET_VER_NUM — Returns a version number used in file processing; the header notes process codes for DL, FFEL, PELL, ISIR, and PROFILE.
• UPDATE_DISB — Updates an award disbursement record, comparing an old and new row image.
• UPDATE_FABASE_AWDS — Updates award records associated with a financial aid base record, applying a packaging status.
• GET_ORG_ID / SET_ORG_ID — Retrieve and set the current operating unit (organization) identifier.
• UPDATE_FMAST / UPDATE_AWARD — Maintain fund master and award records respectively.
• CHECK_LD_CAL_TPS — Validates load calendar term periods; its signature was revised in 2003 to accept an award disbursement plan ID.
• CHECK_NUMBER_FORMAT — Validates formatting of numeric values.
• DEPEND_STAT_2001 — Handles dependency status logic tied to the 2001 need-analysis cycle.
• GET_NOTIFICATION_STATUS / UPDATE_NOTIFICATION_STATUS / UPDATE_AWD_NOTIFICATION_STATUS — Read and maintain notification status at both general and award-specific levels.
• GET_CONCURRENT_PROG_NAME — Returns the user-facing name of a concurrent program, resolving the identifier against FND_CONCURRENT_PROGRAMS_TL.
• IS_FUND_LOCKED_FOR_AWD_PERIOD — Determines whether a fund is locked for a given award period, guarding against edits to locked financial data.

Tables Accessed

The package reads and writes several core IGF and shared tables. FND_CONCURRENT_PROGRAMS_TL supplies translated concurrent program names for GET_CONCURRENT_PROG_NAME. Award data is held in IGF_AW_AWARD_ALL, IGF_AW_AWARD_PRD, IGF_AW_AWD_DISB_ALL, IGF_AW_AWD_DIST_PLANS, IGF_AW_AWD_PRD_TERM, and IGF_DB_AWD_DISB_DTL_ALL. Fund configuration relies on IGF_AW_FUND_MAST_ALL and IGF_AW_FUND_CAT_ALL. Calendar and term logic uses IGS_CA_INST_ALL, IGF_AW_DP_TEACH_PRDS, and IGF_AW_DP_TERMS. Financial aid base and ISIR data come from IGF_AP_FA_BASE_REC_ALL and IGF_AP_ISIR_MATCHED_ALL, while IGF_SL_CL_SETUP_ALL supports setup validation.

Usage Notes

IGF_AW_GEN is invoked internally by the broader IGF package suite rather than directly by end users. Its procedures and functions are typically called from award maintenance forms, disbursement concurrent programs, notification workflows, and other IGF packages that require org context, lookup translation, or fund-lock checks. Custom extensions should call the documented APIs rather than duplicate their logic, since the package centralises validation and status handling across the awarding and disbursement lifecycle. Because it is referenced so widely, changes to signatures are high-impact and are reflected in the retained backward-compatibility parameters noted in the header history.