Search Results check_lend_relation

Overview

IGF_SL_GEN is a generic utility package within the Oracle E-Business Suite Financial Aid module, specifically supporting the Student Loan processing functionality (the "IGF_SL" prefix denotes Student Loan). The package resides in the APPS schema and serves as a shared library of helper routines used across the Student Loan subsystem, providing common validation, lookup, formatting, and data retrieval services that other packages and forms depend upon. Its documented purpose centers on supporting both Direct Loan (DL) and Campus-Based/Commercial Loan (CL) processing within the Oracle Student System and Financial Aid products. Given that the metadata indicates the package is referenced by 42 other packages, IGF_SL_GEN occupies a foundational position in the Student Loan architecture, and changes to its routines can cascade broadly through the loan-processing code base. The package header history shows an evolution spanning 2000 through 2006, accommodating enhancements such as multiple Financial Aid offices, loan enhancements, and CL version overrides by Organization Unit.

Key Procedures and Functions

The 29 documented routines fall into several functional groupings:

• Person and relationship utilities: GET_PERSON_DETAILS, CHECK_REL, and CHECK_LEND_RELATION support retrieval of person information and validation of relationships between borrowers, lenders, and other parties. The package also declares a person_dtl_rec record type that structures personal detail fields such as name, SSN, date of birth, citizenship, and address components.
• Loan validation checks: CHK_DL_FED_FUND_CODE, CHK_DL_STAFFORD, CHK_DL_PLUS, CHK_CL_FED_FUND_CODE, CHK_CL_GPLUS, CHK_CL_STAFFORD, CHK_CL_PLUS, and CHK_CL_ALT validate loan program eligibility, fund codes, and loan types for Direct Loan and Campus-Based/Commercial Loan programs respectively.
• Version retrieval: GET_DL_VERSION and GET_CL_VERSION return the applicable loan version numbers. GET_CL_VERSION accepts a base identifier parameter to correctly resolve CL version numbers when Organization Unit overrides apply.
• File and batch metadata: GET_DL_FILE_TYPE, GET_CL_FILE_TYPE, GET_DL_BATCH_DETAILS, and GET_CL_BATCH_DETAILS retrieve configuration details for loan file transmissions and batch processing.
• Formatting and descriptive lookups: BASE10_TO_BASE36 performs numeric base conversion, GET_GRADE_LEVEL_DESC and GET_ENROLLMENT_DESC return human-readable descriptions for coded values, and GET_DISB_DATE returns disbursement dates, which is the routine associated with the user's search term.
• Organization resolution: GET_ASSOCIATED_ORG and GET_STU_FAO_CODE resolve Financial Aid office associations and codes, supporting the multiple-FA-office enhancement.

Tables Accessed

The package reads from a range of configuration, transaction, and reference tables through APPS synonyms. Student Loan setup and transaction data comes from IGF_SL_CL_SETUP_ALL, IGF_SL_DL_SETUP_ALL, IGF_SL_CL_FILE_TYPE, IGF_SL_DL_FILE_TYPE, IGF_SL_CL_PREF_LENDERS, IGF_SL_LOANS_ALL, and IGF_SL_LOR_ALL. Financial aid award and fund information is drawn from IGF_AW_AWARD_ALL, IGF_AW_FUND_CAT_ALL, IGF_AW_FUND_MAST_ALL, and IGF_AP_FA_BASE_REC_ALL. Party and address data is retrieved from the TCA tables HZ_PARTIES, HZ_LOCATIONS, and HZ_PARTY_SITES. Organization alternate identifiers are resolved through IGS_OR_ORG_ALT_IDS. These accesses support person lookup, fund code validation, loan versioning, disbursement date resolution, and file/batch configuration retrieval.

Usage Notes

IGF_SL_GEN is invoked primarily from other PL/SQL packages and from Oracle Forms within the Financial Aid responsibility, rather than being exposed directly to end users. Because it is a shared utility package referenced by 42 dependent packages, it is typically called during loan origination, disbursement processing, file generation, and validation workflows. The GET_DISB_DATE function in particular would be called during disbursement scheduling and loan file creation to determine the correct date associated with a disbursement event. Developers extending Student Loan functionality should call these routines rather than reimplementing the logic, and should be mindful that modifications affect all dependent packages. There are no concurrent program entry points documented for this package itself.