Search Results add_log_table_process

Overview

The APPS.IGF_SL_PREF_LENDER package body is a PL/SQL component within the Oracle E-Business Suite Financial Aid module (IGF), specifically supporting the Federal Family Education Loan Program (FFELP) and related loan processing flows. Its documented business purpose is to assign a preferred lender to a group of students, where the target population is identified through Person ID Groups rather than being entered individually. This makes the package a bulk-processing utility: an administrator defines a set of persons (for example, by an academic or administrative grouping) and the package walks that population, determines the appropriate preferred lender, and records the assignment.

The header history confirms the package was introduced or substantially expanded in September 2003 by developer bkkumar under the "FFELP Loans – Assign Preferred Lender" enhancement, tracked against FA 122 Loan Enhancements. Subsequent changes addressed defects (Bug #4097414 on the c_get_persons cursor, Bug #4187798 raising log levels from LEVEL_STATEMENT to LEVEL_EXCEPTION at three lines) and a 2003 update-flag correction. The source file is IGFSL21B.pls, version 120.7, last shipped in May 2006.

Key Procedures and Functions

The ETRM metadata documents a single public procedure, MAIN. This is the entry point for the preferred-lender assignment process. Its responsibilities, as evidenced by the package annotations, include driving the Person ID Group selection logic, iterating the resulting student population, resolving the preferred lender for each person, and writing the assignment outcome back to the loan recipient data. Internally the package defines supporting constructs such as the log_record record type (fields person_number and message_text drawn from fnd_new_messages.message_text), which is used to accumulate per-person status messages for the process log. The cursor c_get_persons performs population retrieval and was the subject of a targeted defect fix. No parameter lists are published in the documented metadata, so parameters should be confirmed against the installed source.

Tables Accessed

The package reads and writes across Financial Aid, Trading Community, and FND reference data. IGF_SL_CL_RECIPIENT is the primary target — it holds loan recipients and stores the assigned preferred lender. IGF_SL_CL_PREF_LENDERS supplies the set of valid preferred lenders available for assignment. IGS_PE_PERSID_GROUP_ALL defines the Person ID Groups that delimit the student population, and IGS_PE_HZ_PARTIES links those person records to TCA party identifiers. HZ_PARTIES provides party name and identity context. The loan and item-level tables IGF_AP_FA_BASE_REC_ALL, IGF_AP_TD_ITEM_INST_ALL, and IGF_AP_TD_ITEM_MST_ALL support the underlying award, disbursement, and item master data used to validate eligibility. FND_NEW_MESSAGES supplies translatable message text for the log record type, and PLITBLM is the standard EBS PL/SQL message lookup table.

Usage Notes

IGF_SL_PREF_LENDER is classified as OTHER rather than a public API, indicating it is intended for internal invocation rather than as a supported external interface. It is not referenced by any other documented package. Typical invocation is from an Oracle Forms-based Financial Aid screen, or from a concurrent program registered to call IGF_SL_PREF_LENDER.MAIN, allowing preferred-lender assignment to be scheduled against a Person ID Group. Because the process performs mass updates on IGF_SL_CL_RECIPIENT, it should be run during controlled batch windows. Custom code that calls MAIN directly must replicate the logging and validation behavior and should guard against partial population matches. Note that the ETRM metadata does not document the add_log_table_process routine the user searched for; if such a procedure exists it is not part of the documented public interface, and its presence should be verified in the installed source. The May 2006 header date means later 12.1.1 and 12.2.2 distributions may carry incremental patches, so always review the actual deployed body.