Search Results igf_sl_lar_creation




Overview
Explore in AI Chat

Overview

The APPS.IGF_SL_LAR_CREATION package belongs to the Oracle Student Financial Aid (formerly part of the Oracle Student System / Financial Aid module) product family within Oracle E-Business Suite. Its stated purpose, as recorded in the package header, is to insert loan records into the IGF_SL_LOANS table. It therefore serves as the loan award creation engine for the Student Loan (SL) subsystem, translating award data held against a student's financial aid record into discrete loan disbursement records that can subsequently be processed by downstream loan origination, promissory note, and disbursement routines. The package has been in the codebase since 2000 and was maintained through the 12.1.1 and 12.2.2 releases. Its header documents an HR integration change (Bug 3709292) and structural changes replacing legacy base-table column anchors with the IGS views igs_pr_css_class_std_v and igs_ps_ver_all, reflecting the migration to the IGS (Student System) schema as the master for class standing and program type data.

Key Procedures and Functions

The package spec exposes four documented program units:

  • GET_DL_CL_STD_CODE — Resolves the Direct Loan and Campus-Based loan standard codes for a given student, based on the base ID, class standing, and program type supplied by the caller. It returns the DL and CL codes as OUT parameters, drawing on the IGF_AP_CLASS_STD_MAP mapping table.
  • INSERT_LOAN_RECORDS — The primary workhorse procedure. It accepts an award year, run mode, fund ID, base ID, and award ID (plus legacy dummy parameters retained for concurrent-program argument compatibility) and writes the resulting loan rows. It reports status through the standard ERRBUF and RETCODE OUT parameters, indicating it is designed primarily for concurrent program invocation.
  • GET_LOAN_START_DT — Returns the loan period start date for a given award, taking p_award_id and returning a DATE. This function was explicitly published in the package specification as part of the FA 151 HR Integration enhancement (Bug 3709292) so that other modules and custom extensions could reliably derive the loan start date.
  • GET_LOAN_END_DT — Returns the corresponding loan period end date for an award, mirroring GET_LOAN_START_DT and published under the same enhancement.

Tables Accessed

The package operates across a wide slice of the Financial Aid and Student System schemas. Award and disbursement data are read from IGF_AW_AWARD_ALL, IGF_AW_AWD_DISB_ALL, and IGF_AW_AWD_DIST_PLANS, while fund configuration is drawn from IGF_AW_FUND_CAT_ALL and IGF_AW_FUND_MAST_ALL. Student-level attributes come from IGF_AP_FA_BASE_REC_ALL, IGF_AP_CLASS_STD_MAP, IGF_AP_ISIR_MATCHED_ALL, and IGF_AP_PR_PRG_TYPE, with institutional reference data (program type, class standing) sourced through IGS views such as IGS_PS_VER_ALL and igs_pr_css_class_std_v. Pell-specific data is read from IGF_GR_ATTEND_PELL and IGF_GR_REPORT_PELL, alternate borrower data from IGF_SL_ALT_BORW_ALL, party identity from HZ_PARTIES, and error messaging from FND_NEW_MESSAGES. All are accessed via APPS synonyms.

Usage Notes

INSERT_LOAN_RECORDS is typically registered as a concurrent program, evidenced by its ERRBUF/RETCODE signature and the dummy parameters used to pad the concurrent argument list. It is invoked during loan award processing and recalculation runs for a specified award year and fund. GET_DL_CL_STD_CODE, GET_LOAN_START_DT, and GET_LOAN_END_DT are callable functions intended for use by other PL/SQL packages and by custom extensions. The package is referenced by four other packages within the application, confirming its role as a shared utility in the loan processing chain. Customizations should avoid modifying the package directly and should instead wrap the published functions, particularly GET_LOAN_START_DT and GET_LOAN_END_DT, for date derivation logic.