Results for “get_dl_version”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGF_SL_GEN is a general-purpose PL/SQL package body in the APPS schema that supports the Oracle E-Business Suite Student Loan (SL) processing area within the Financial Aid module (IGF). It serves as a utility and validation layer for Stafford, PLUS, Graduate PLUS, and alternative loan processing, providing reusable logic for lender and disbursement setup validation, borrower and person detail retrieval, batch/file-type resolution, and code conversions. The package is classified as OTHER in the ETRM repository, meaning it is an internal support package rather than a public API, yet it is referenced by 42 other database objects, confirming its role as a shared dependency across loan generation, packaging, award, and disbursement programs.

The business function of IGF_SL_GEN is to centralize loan validation rules and lookup-driven derivations so that multiple loan processes (certification, disbursement, and origination) apply consistent eligibility and configuration checks against loan setup tables, fund master data, and preferred lender records.

Key Procedures and Functions

• GET_PERSON_DETAILS — Retrieves borrower or student person information used during loan processing.
• CHECK_REL — Validates relationship data between parties relevant to loan eligibility.
• CHK_DL_FED_FUND_CODE / CHK_CL_FED_FUND_CODE — Validate federal fund codes for Direct Loan (DL) and Campus-Based/CL processing respectively.
• CHK_DL_STAFFORD / CHK_CL_STAFFORD — Validate Stafford loan eligibility or setup for DL and CL paths.
• CHK_DL_PLUS / CHK_CL_PLUS / CHK_CL_GPLUS — Validate PLUS and Graduate PLUS loan configuration or eligibility.
• CHK_CL_ALT — Validates alternative loan setup or eligibility.
• BASE10_TO_BASE36 — Utility conversion used for generating encoded identifiers or keys.
• GET_GRADE_LEVEL_DESC / GET_ENROLLMENT_DESC — Return descriptive text for grade level and enrollment status lookups.
• GET_DL_VERSION / GET_CL_VERSION — Return the applicable version indicator for DL and CL processing.
• GET_DL_FILE_TYPE / GET_CL_FILE_TYPE — Resolve the file type configuration used in loan file generation.
• GET_DL_BATCH_DETAILS / GET_CL_BATCH_DETAILS — Retrieve batch processing detail records for DL and CL runs.
• GET_DISB_DATE — Derives or returns the applicable disbursement date for a loan.

Tables Accessed

• HZ_PARTIES, HZ_LOCATIONS, HZ_PARTY_SITES — Party and address data for borrowers, students, and lenders.
• IGF_SL_LOANS_ALL, IGF_SL_LOR_ALL, IGF_SL_CLCHSN_DTLS — Core loan, loan origination record, and loan change detail data.
• IGF_SL_CL_SETUP_ALL, IGF_SL_DL_SETUP_ALL, IGF_SL_CL_FILE_TYPE, IGF_SL_DL_FILE_TYPE — Setup and file-type configuration for CL and DL loan types.
• IGF_SL_CL_PREF_LENDERS — Preferred lender definitions used in lender validation.
• IGF_AW_AWARD_ALL, IGF_AW_FUND_CAT_ALL, IGF_AW_FUND_MAST_ALL — Award and fund category/master data consulted during fund code validation.
• IGF_AP_FA_BASE_REC_ALL, IGF_AP_FA_ANT_DATA — Application base and anticipated aid data feeding loan eligibility.
• IGS_OR_ORG_ALT_IDS, IGS_AD_* and IGS_PE_* views — Organization and person identifiers, application status, and person EIT data used in validation logic.

Usage Notes

IGF_SL_GEN is invoked indirectly through dependent packages such as IGF_AW_GEN, IGF_AW_PACKAGING, IGF_GR_GEN, IGF_SL_LOANS_PKG, IGF_AP_GEN_001, and IGS_GE_MSG_STACK, which call its validation and lookup routines during award packaging, loan origination, and disbursement generation. It is typically triggered from concurrent programs that process loan batches and from Financial Aid forms where staff review or certify loans. Because the package is not a documented public API and is not referenced by any database object outside the APPS schema, customizations should call it only through its parent processes rather than directly. All error handling routes through FND_MESSAGE, APP_EXCEPTION, and IGS_GE_MSG_STACK, and logging uses FND_LOG and FND_GLOBAL, so failures surface through standard EBS message and log facilities.