Search Results validate_disb_act_int_rec

Overview

IGF_AW_LI_IMPORT is an APPS-owned PL/SQL package within the Oracle E-Business Suite (12.1.1 and 12.2.2) that supports the Oracle Student Financial Aid (formerly Financial Aid / IGF) module. It is a processing and validation engine used to import award and disbursement interface records — the staging data that feeds the financial aid award and disbursement structures. The package exists to move data from interim interface tables into the core award, disbursement, and third-party (AP/FA) tables, applying business validation logic along the way. It is classified as an "OTHER" API, meaning it is an internal, processing-oriented utility rather than a public, partner-facing API.

This package is not referenced by any other documented packages, and it appears in the dependency tree as a self-referencing object, which indicates its procedures are called internally or directly rather than exposed through a higher-level parent package.

Key Procedures and Functions

The ETRM metadata documents seven procedures/functions, each supporting a distinct phase of the import lifecycle:

• MAIN — The top-level driver procedure that orchestrates the import process, invoking the validation and processing routines in sequence.
• VALIDATE_AWDYEAR_INT_REC — Validates award-year interface records, checking that data conforms to required award-year rules before acceptance into core tables.
• VALIDATE_DISBURS_INT_REC — Validates disbursement interface records prior to disbursement processing.
• VALIDATE_DISB_ACT_INT_REC — Validates disbursement-activity interface records, ensuring consistency for activity-level disbursement entries.
• VALIDATE_DISB_HOLD_INT_REC — Validates disbursement-hold interface records, checking holds placed against disbursements.
• GET_BASE_ID_FROM_PER_NUM — Retrieves a base identifier from a person number, resolving the person reference used to link award records to HZ_PARTIES.
• RUN — Executes the import as a whole, likely invoked as the entry point for the concurrent process.

Tables Accessed

IGF_AW_LI_IMPORT reads and writes a broad set of APPS-synonymed tables:

• HZ_PARTIES — Resolves the person/party identity behind award records using person number lookups.
• IGF_AW_LI_AWD_INTS / IGF_AW_LI_DISB_INTS — The core interface (staging) tables holding award and disbursement records to be imported.
• IGF_AW_AWARD_ALL, IGF_AW_AWD_DISB_ALL — Core award and award-disbursement tables receiving validated data.
• IGF_AW_AWARD_LEVEL_HIST / _S — Award-level history and its sequence, updated as award levels change.
• IGF_AP_BATCH_AW_MAP_ALL, IGF_AP_FA_BASE_REC_ALL, IGF_AP_ISIR_MATCHED_ALL — AP/FA batch mapping, base records, and ISIR match data used for disbursement processing.
• IGF_AW_COA_ITEMS, IGF_AW_COA_ITM_TERMS — Cost-of-attendance item and term structures referenced during validation.
• IGF_AW_DB_CHG_DTLS, IGF_AW_DB_COD_DTLS — Disbursement change and cost-of-attendance detail tables.
• FND_LOG_MESSAGES — Receives log output for error and audit traceability.

Usage Notes

This package is normally invoked through an Oracle EBS concurrent program (the RUN entry point) or via the financial aid interface forms, using the FND standard logging framework to record diagnostics. Because it is an OTHER-classified package with no documented public parameters, it should be treated as internal API: custom code should call it only when performing bulk award/disbursement interface imports, and only after existing validations have been understood. Developers should not modify package logic, as it participates in the standard award/disbursement data flow and depends on the documented tables above.