Search Results igf_aw_awd_disb_pkg




Overview
Explore in AI Chat

Overview

IGF_AW_AWD_DISB_PKG is a PL/SQL package owned by the APPS schema within the Oracle E-Business Suite "IGF" module, which supports the institution-wide Student Financial Aid and Awards functionality (formerly part of Oracle Financial Aid / Student Systems). The package is classified as an OTHER API type in the ETRM repository and remains in VALID status in both the 12.1.1 and 12.2.2 releases. Its central business purpose is to manage the disbursement records associated with an award—that is, the scheduled and actual release of approved award funds to a student. Disbursements are the mechanism by which an authorized award amount is converted into one or more dated payout lines, each of which may be subject to holds, revision reasons, loan processing, and change tracking. The package therefore operates squarely at the intersection of the award, disbursement, loan, and selection-change domains of the IGF schema.

Key Procedures and Functions

The ETRM metadata documents eleven procedures and functions, all of which follow Oracle Designer/Forms generator naming conventions:

  • INSERT_ROW — Inserts a new disbursement row into the underlying disbursement table, populating mandatory keys and audit columns.
  • ADD_ROW — A wrapper-style insert that typically also performs ancillary setup (defaults, derived columns) before invoking INSERT_ROW.
  • LOCK_ROW — Obtains a row-level lock for the specified disbursement record to enforce optimistic concurrency control.
  • UPDATE_ROW — Updates an existing disbursement row in place.
  • DELETE_ROW — Removes the identified disbursement record.
  • BEFORE_DML — A pre-insert/pre-update trigger-style procedure that applies derived values and validation rules before the DML is allowed.
  • GET_PK_FOR_VALIDATION — Retrieves the primary key of the row currently being validated, used by the validation framework.
  • GET_FK_IGF_AW_AWARD — Returns the foreign key referencing the parent award.
  • GET_FK_IGF_AW_AWD_RVSN_RSN — Returns the foreign key referencing the award revision reason.
  • GET_FK_IGS_CA_INST — Returns the foreign key referencing the IGS_CA_INST (calendar instance / term) context.
  • GET_FK_IGS_LOOKUPS_VIEW — Returns the foreign key referencing the IGS_LOOKUPS_VIEW lookup code.

The presence of these GET_FK helpers indicates the package participates in the Oracle Designer "table API" pattern used across the IGF schema.

Tables Accessed

The package reads and writes, via APPS synonyms, at least: IGF_AW_AWD_DISB_ALL (the disbursement base table), IGF_AW_AWARD_ALL (parent award), IGF_AW_AWD_RVSN_RSN (revision reasons), IGF_AW_DB_CHG_DTLS (disbursement change details), IGF_AW_FUND_CAT_ALL (fund category), IGF_GR_RFMS_ALL (regulation/RFMS), IGF_SL_CLCHSN_DTLS, IGF_SL_CL_SETUP_ALL, IGF_SL_LOANS_ALL, IGF_SL_LOR_ALL (student loan and origination records), and FND_NEW_MESSAGES (application message retrieval for error text). The loan tables indicate that disbursement rows drive or are driven by loan disbursements.

Usage Notes

IGF_AW_AWD_DISB_PKG is not typically called directly by end users; it is invoked indirectly by higher-level award and disbursement packages such as IGF_AW_AWARD_PKG, IGF_AW_AWD_RVSN_RSN_PKG, IGF_AW_GEN_003, IGF_AW_LI_IMPORT, IGF_AW_PACKAGING, IGF_AW_SS_GEN_PKG, IGF_DB_AWD_DISB_DTL_PKG, IGF_DB_DISB, IGF_DB_DISB_HOLDS_PKG, IGF_GR_REPACKAGE, IGF_SL_* loan packages, IGS_FI_BILL_PLN_CRD_PKG, and others—18 referencing packages in total. It is also referenced recursively within itself. Functional invocation occurs from award and disbursement maintenance forms, loan import/interface concurrent programs, packaging and disbursement generation routines, and revision-reason processing. Custom integrations should call the public row APIs (INSERT_ROW, UPDATE_ROW, DELETE_ROW) rather than issuing direct SQL against IGF_AW_AWD_DISB_ALL to preserve validation and change-tracking behavior.