Results for “depend_stat_2001”
4 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IGF_AW_GEN is a PL/SQL package body in the APPS schema that supports the Oracle E-Business Suite Financial Aid subsystem, specifically the Award (AW) module. It serves as a general-purpose maintenance and processing engine for award, disbursement, fund, and financial-aid baseline records. Rather than exposing a public API, IGF_AW_GEN gathers a collection of utility, update, and validation routines used during award generation, disbursement processing, and notification handling. Its documented status is VALID in both the 12.1.1 and 12.2.2 releases, and it is classified as an OTHER API within the ETRM documentation. The package has an exceptionally wide integration footprint: it is referenced by 190 other database objects, indicating that it sits near the center of the Financial Aid Award dependency graph and is invoked by award, disbursement, loan, and baseline-record packages throughout the module.
Key Procedures and Functions
The ETRM metadata documents sixteen procedures and functions. Their names indicate the following purposes:
- LOOKUP_DESC — returns a descriptive value for a lookup code, typically resolving codes through IGF_LOOKUPS_VIEW or IGS_LOOKUPS_VIEW.
- GET_VER_NUM — retrieves a version number, likely supporting row versioning on award or related records.
- UPDATE_DISB — performs updates against award disbursement records.
- UPDATE_FABASE_AWDS — updates financial-aid baseline award records, aligning base records with award data.
- GET_ORG_ID / SET_ORG_ID — retrieve and set the current operating unit (organization) context used for multi-org security.
- UPDATE_FMAST — updates fund master records.
- UPDATE_AWARD — performs maintenance updates on award header records.
- CHECK_LD_CAL_TPS — validates loan or disbursement calendar/term-period setup.
- CHECK_NUMBER_FORMAT — validates the format of a number value, likely for award or disbursement identifiers.
- DEPEND_STAT_2001 — a dependency/status routine associated with a specific 2001-era processing rule.
- GET_NOTIFICATION_STATUS / UPDATE_NOTIFICATION_STATUS / UPDATE_AWD_NOTIFICATION_STATUS — retrieve and update notification status at the general and award levels.
- GET_CONCURRENT_PROG_NAME — resolves a concurrent program name from FND_CONCURRENT_PROGRAMS_TL for logging or display.
- IS_FUND_LOCKED_FOR_AWD_PERIOD — determines whether a fund is locked for a given award period, supporting fund control logic.
Tables Accessed
The package reads and writes a broad set of Financial Aid tables through APPS synonyms. Award data is handled via IGF_AW_AWARD_ALL, IGF_AW_AWARD_PRD, IGF_AW_AWD_DISB_ALL, IGF_AW_AWD_DIST_PLANS, IGF_AW_AWD_PRD_TERM, IGF_AW_DP_TEACH_PRDS, and IGF_AW_DP_TERMS. Fund data is accessed through IGF_AW_FUND_CAT_ALL and IGF_AW_FUND_MAST_ALL. Baseline and matched record tables include IGF_AP_FA_BASE_REC_ALL and IGF_AP_ISIR_MATCHED_ALL. Disbursement detail is handled through IGF_DB_AWD_DISB_DTL_ALL. Setup and control tables include IGF_SL_CL_SETUP_ALL and IGS_CA_INST_ALL. FND_CONCURRENT_PROGRAMS_TL is queried for concurrent program names. It also interacts with package objects IGF_AP_FA_BASE_REC_PKG, IGF_AW_AWARD_PKG, IGF_AW_FUND_MAST_PKG, IGF_DB_AWD_DISB_DTL_PKG, IGF_SL_AWARD, IGF_SL_LOANS_PKG, IGF_SL_GEN, IGS_GE_GEN_003, and IGS_GE_MSG_STACK for error handling, messaging, and cross-package processing.
Usage Notes
IGF_AW_GEN is not an end-user form package; it is invoked programmatically from award and disbursement processing flows, concurrent programs, and dependent Financial Aid packages. Because 190 objects reference it, changes to its internal logic carry broad regression risk and should be validated against award generation, disbursement, fund control, and notification scenarios. Error handling is routed through APP_EXCEPTION, FND_MESSAGE, FND_LOG, and IGS_GE_MSG_STACK, allowing exceptions and messages to surface correctly in concurrent manager logs and forms. When troubleshooting award or disbursement discrepancies in 12.1.1 or 12.2.2, the documented routines UPDATE_AWARD, UPDATE_DISB, UPDATE_FMAST, and IS_FUND_LOCKED_FOR_AWD_PERIOD are the primary entry points to review.
-
PACKAGE: APPS.IGF_AW_GEN 12.1.1
-
PACKAGE: APPS.IGF_AW_GEN 12.1.1