Search Results igf_aw_process_s

Overview

IGF_AW_COA_CALC is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema, classified in ETRM documentation as an OTHER-type API rather than a formal public interface. It forms part of the Oracle Grants / Oracle Financial Aid (IGF) module family, specifically the Award (AW) subcomponent. Its role is to calculate and derive Chart of Accounts (COA) values for awards and award-related distributions, and to support the generation and update of COA item data used downstream by award processing logic. The package is a supporting utility within the award COA generation chain rather than a standalone entry point; it is not referenced by any other database object according to the documented dependency metadata, which indicates it is invoked directly by concurrent programs, forms, or the award generation routines rather than being called from other shared packages.

Key Procedures and Functions

The ETRM metadata documents a single procedure, RUN. This procedure constitutes the operational entry point of the package and is responsible for orchestrating the COA calculation logic, including the reading of award and award-attribute records, resolution of COA item and item-term definitions, and the population or recalculation of the relevant award COA structures. Because the package body is documented as VALID and contains one procedure, custom extensions should treat RUN as the sole supported invocation point rather than attempting to call internal, undocumented subprograms.

Tables Accessed

The package reads and writes an identifiable set of documented tables, all referenced through APPS synonyms:

• IGF_AW_AWARD_ALL — the master award table, providing the award header context for COA calculation.
• IGF_AW_COA_ITEMS — COA item definitions used to determine which account segments apply to an award.
• IGF_AW_COA_ITM_TERMS — COA item term rules that govern how and when COA items are applied.
• IGF_AW_FUND_CAT_ALL and IGF_AW_FUND_MAST_ALL — fund category and fund master data used to derive funding-related COA attributes.
• IGF_AW_PROCESS_S — the award process sequence table that supplies processing control and sequence values.
• IGF_AP_FA_BASE_REC_ALL — base record data supporting award participant and financial aid linkage.
• IGS_PE_PRSID_GRP_MEM_ALL and IGS_PE_PERSID_GROUP_ALL — person identification group and membership tables used to resolve student or person identifiers.
• FND_NEW_MESSAGES — the Oracle Application Object Library message repository used for error and status reporting.
• DUAL — used for single-row SQL constructs.

Usage Notes

IGF_AW_COA_CALC is typically invoked as part of award COA generation and update processing, most likely from concurrent programs or award maintenance forms that drive the RUN procedure. The package depends on a wide set of supporting packages, including IGF_AW_COA_GEN, IGF_AW_COA_UPDATE, IGF_AW_GEN, IGF_AW_PACKNG_SUBFNS, IGF_AP_SS_PKG, IGS_GE_MSG_STACK, and FND utilities for logging, messaging, and file output (FND_FILE, FND_LOG, FND_MESSAGE, APP_EXCEPTION). Because it depends on FND_FILE, the RUN procedure is likely designed to run under concurrent manager control, where output and log files are available. Custom code should call only the documented RUN procedure, avoid direct manipulation of the underlying COA tables, and preserve the package's dependency on the standard message and logging infrastructure. Since the package is not referenced by any other database object, its execution lineage must be traced through the calling concurrent program or form rather than through package call graphs.