Results for “igf_sl_dl_pnote_status”
5 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The APPS.IGF_SL_DL_LI_IMP_PKG package body is a component of the Oracle E-Business Suite Financial Aid module, commonly referenced as IGS or the Student Systems / Financial Aid family of products. It belongs to the loan management area of the product, specifically the Direct Loan (DL) and Stafford Loan processing infrastructure within the Oracle Financial Aid solution, and is classified in the ETRM repository as an "OTHER" type API rather than a formal public API.
Its primary business purpose is to drive the import and staging of loan-related interface records from external sources — most notably the Common Origination and Disbursement (COD) system used by the U.S. Department of Education — into the Oracle Financial Aid loan origination and disbursement tables. The package reads raw interface records held in staging structures (such as IGF_SL_LI_DLOR_INTS), validates them, and posts the cleaned data into the permanent Direct Loan tables.
A user searching for the term igf_sl_credit_override is typically investigating how credit decision overrides and credit decision dates on a loan record are handled during the import process. Although the package metadata provided does not list a dedicated procedure named after this term, the cursor declared in the package body contains columns such as credit_decision_date, indicating that the import logic does process credit-related decision data that feeds override and eligibility determinations on student loan accounts.
Key Procedures and Functions
The ETRM metadata documents a single entry point for this package:
- RUN — The primary driver procedure. It orchestrates the lifecycle of a loan import run: opening the interface cursor, iterating over the batch of staging rows (keyed by batch ID, alternate code, and import status types), applying TRIM, TRUNC, and data-conversion logic on character, date, and numeric fields, and then performing the corresponding inserts or updates against the target tables. It is the single callable unit through which the whole import is executed.
No other procedures or functions are documented in the ETRM metadata provided.
Tables Accessed
The package touches a broad set of Financial Aid and Trading Community tables via APPS synonyms, which can be grouped functionally:
- Staging / interface tables —
IGF_SL_LI_DLOR_INTS,IGF_SL_DL_FILE_TYPE, andIGF_SL_CL_BATCH_ALLhold the raw and batch-level loan records being imported. - Award and demographic tables —
IGF_AW_AWARD_ALL,IGF_AW_LI_COA_INTS,HZ_PARTIES, andHZ_RELATIONSHIPSsupply award, person, and relationship context for matching. - Disbursement and disbursement-responsibility tables —
IGF_DB_AWD_DISB_DTL_ALL,IGF_DB_DL_DISB_RESP_ALL, andIGF_SL_DL_CHG_RESP_ALLcapture disbursement details and change responsibility records. - FA base and ISIR tables —
IGF_AP_FA_BASE_REC_ALLandIGF_AP_ISIR_MATCHED_ALLprovide the applicant/financial aid base record and ISIR match data used for eligibility checks. - Pell and borrower tables —
IGF_GR_ATTEND_PELL,IGF_GR_REPORT_PELL, andIGF_SL_ALT_BORW_ALLsupport Pell grant attendance/reporting and alternate borrower data. - Loan batch interface —
IGF_AP_LI_BAT_INTSholds the loan batch interface rows that coordinate the import.
These tables are read primarily to validate and match import rows, and are written to when the import posts validated loan records into the permanent system.
Usage Notes
IGF_SL_DL_LI_IMP_PKG.RUN is not a public API and is not referenced by any other packaged procedure, meaning it is invoked directly rather than as a dependent routine.
In practice, the RUN procedure is executed from a concurrent program or batch process that imports COD loan data into Oracle Financial Aid. Sites generally schedule it as part of the loan data load cycle rather than calling it interactively. Because the cursor accepts a batch ID and alternate code as parameters, callers control the scope of each run.
For customizations or troubleshooting related to igf_sl_credit_override, this package is relevant because the import cursor carries credit decision data and loan change status fields that drive downstream override logic. Any change to credit override handling on imported loans would typically surface in the data staged through here, or in the downstream tables this package populates.
Because the object is billed as an "OTHER" classification API with only one documented procedure, extensions should avoid modifying the package body and instead consume the target tables after import completes.
-
Direct Loan Promissory Note Status
-
Direct Loan Promissory Note Status
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2