Search Results igf_sl_gen

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.

Lookup Type: IGF_SL_GEN 12.2.2
product: IGF - Financial Aid (Obsolete) , meaning: General Lookup Codes , description: General Lookup Codes ,
Lookup Type: IGF_SL_GEN 12.1.1
product: IGF - Financial Aid , meaning: General Lookup Codes , description: General Lookup Codes ,
SYNONYM: APPS.IGF_SL_CL_FILE_TYPE 12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGF_SL_CL_FILE_TYPE, status:VALID,
SYNONYM: APPS.IGF_SL_LOR_ALL 12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGF_SL_LOR_ALL, status:VALID,
SYNONYM: APPS.IGF_SL_DL_SETUP_ALL 12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGF_SL_DL_SETUP_ALL, status:VALID,
SYNONYM: APPS.IGF_SL_DL_FILE_TYPE 12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGF_SL_DL_FILE_TYPE, status:VALID,
SYNONYM: APPS.IGF_SL_CL_SETUP_ALL 12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGF_SL_CL_SETUP_ALL, status:VALID,
SYNONYM: APPS.IGF_SL_CL_PREF_LENDERS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGF_SL_CL_PREF_LENDERS, status:VALID,
SYNONYM: APPS.IGS_OR_ORG_ALT_IDS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_OR_ORG_ALT_IDS, status:VALID,
PACKAGE BODY: APPS.IGF_SL_GEN 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGF_SL_GEN, status:VALID,
SYNONYM: APPS.IGF_AW_FUND_CAT_ALL 12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGF_AW_FUND_CAT_ALL, status:VALID,
SYNONYM: APPS.IGF_SL_LOANS_ALL 12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGF_SL_LOANS_ALL, status:VALID,
SYNONYM: APPS.IGF_AW_FUND_MAST_ALL 12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGF_AW_FUND_MAST_ALL, status:VALID,
PACKAGE: APPS.IGS_CA_COMPUTE_DA_VAL_PKG 12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_CA_COMPUTE_DA_VAL_PKG, status:VALID,
PACKAGE: APPS.IGF_SL_GEN 12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGF_SL_GEN, status:VALID,
VIEW: APPS.IGF_SL_LOANS 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGF.IGF_SL_LOANS, object_name:IGF_SL_LOANS, status:VALID,
SYNONYM: APPS.IGS_PE_HZ_PTY_SITES 12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_PE_HZ_PTY_SITES, status:VALID,
SYNONYM: APPS.IGF_SL_CLCHSN_DTLS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGF_SL_CLCHSN_DTLS, status:VALID,
SYNONYM: APPS.IGF_AP_FA_ANT_DATA 12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGF_AP_FA_ANT_DATA, status:VALID,
SYNONYM: APPS.IGS_OR_ORG_ALT_IDTYP 12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_OR_ORG_ALT_IDTYP, status:VALID,
PACKAGE BODY: APPS.IGF_SL_DL_CHG_ACK 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGF_SL_DL_CHG_ACK, status:VALID,
PACKAGE BODY: APPS.IGF_DB_DL_DISB_ORIG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGF_DB_DL_DISB_ORIG, status:VALID,
PACKAGE BODY: APPS.IGF_SL_CL_PREF_LENDERS_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGF_SL_CL_PREF_LENDERS_PKG, status:VALID,
PACKAGE BODY: APPS.IGF_SL_LOR_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGF_SL_LOR_PKG, status:VALID,
PACKAGE BODY: APPS.IGF_DB_DL_ORIG_ACK 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGF_DB_DL_ORIG_ACK, status:VALID,
PACKAGE BODY: APPS.IGF_AP_PROCESS_CORRECTIONS 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGF_AP_PROCESS_CORRECTIONS, status:VALID,
PACKAGE: APPS.IGF_AW_PACKAGING 12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGF_AW_PACKAGING, status:VALID,
PACKAGE BODY: APPS.IGF_DB_CL_ROSTER 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGF_DB_CL_ROSTER, status:VALID,
PACKAGE BODY: APPS.IGF_SL_AWARD 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGF_SL_AWARD, status:VALID,
PACKAGE: APPS.IGF_AP_GEN_001 12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGF_AP_GEN_001, status:VALID,
PACKAGE BODY: APPS.IGF_SL_DL_RECORD 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGF_SL_DL_RECORD, status:VALID,
SYNONYM: APPS.IGF_AW_AWARD_ALL 12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGF_AW_AWARD_ALL, status:VALID,
PACKAGE BODY: APPS.IGF_DB_DL_RECONC 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGF_DB_DL_RECONC, status:VALID,
PACKAGE BODY: APPS.IGF_SL_DL_PRINT_PNOTE 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGF_SL_DL_PRINT_PNOTE, status:VALID,
PACKAGE BODY: APPS.IGF_GR_LI_IMPORT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGF_GR_LI_IMPORT, status:VALID,
PACKAGE BODY: APPS.IGF_SL_DL_VALIDATION 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGF_SL_DL_VALIDATION, status:VALID,
SYNONYM: APPS.IGS_PE_EIT 12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_PE_EIT, status:VALID,
PACKAGE BODY: APPS.IGF_SL_CL_CHG_PRC 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGF_SL_CL_CHG_PRC, status:VALID,
PACKAGE BODY: APPS.IGF_SL_DL_PNOTE_ACK 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGF_SL_DL_PNOTE_ACK, status:VALID,
PACKAGE BODY: APPS.IGF_SL_CL_VALIDATION 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGF_SL_CL_VALIDATION, status:VALID,
PACKAGE BODY: APPS.IGF_GR_RFMS_ORIG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGF_GR_RFMS_ORIG, status:VALID,
VIEW: APPS.IGS_PE_CONTACTS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_PE_CONTACTS_V, object_name:IGS_PE_CONTACTS_V, status:VALID,
PACKAGE BODY: APPS.IGF_SL_DL_CHG_ORIG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGF_SL_DL_CHG_ORIG, status:VALID,
PACKAGE BODY: APPS.IGF_GR_PELL 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGF_GR_PELL, status:VALID,
PACKAGE BODY: APPS.IGF_SL_CL_CHG_FILE 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGF_SL_CL_CHG_FILE, status:VALID,
VIEW: APPS.IGS_AD_APPL_STAT_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_AD_APPL_STAT_V, object_name:IGS_AD_APPL_STAT_V, status:VALID,
PACKAGE BODY: APPS.IGF_AW_AWD_DISB_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGF_AW_AWD_DISB_PKG, status:VALID,
PACKAGE BODY: APPS.IGF_SL_DL_ORIG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGF_SL_DL_ORIG, status:VALID,
PACKAGE BODY: APPS.IGF_SL_DL_ORIG_ACK 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGF_SL_DL_ORIG_ACK, status:VALID,
PACKAGE BODY: APPS.IGF_SL_LOANS_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGF_SL_LOANS_PKG, status:VALID,