Search Results is_lookup_code_exist

Overview

IGF_AP_LI_PROF_IMP_PROC is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite. It belongs to the Oracle Financial Aid (IGF) product family and supports the import and profiling of student financial aid data, specifically the Loan/Profile Interface for the Title IV and institutional aid processing flows. The package serves as the procedural engine behind the import of loan and profile records received from external sources — most notably the U.S. Department of Education's Common Origination and Disbursement (COD) and Institutional Student Information Record (ISIR) data — into the EBS Financial Aid tables.

The package's core responsibility is to read staged rows from CSS and ISIR interface tables, validate and transform the incoming values, populate the appropriate financial aid base tables, and surface errors or informational messages back to the user through the standard Oracle message stack. The cursor c_int_data defined in the package body illustrates the breadth of attributes processed: person identifiers, college codes, academic year, registration and application dates and types, financial aid status, citizenship and visa classification, household composition, and an extensive set of tax, income, asset, and liability figures (for example ADJUSTED_GROSS_AMT, HOME_VALUE_AMT, and BUS_FARM_VALUE_AMT).

Key Procedures and Functions

Two procedures are documented for this package body:

• MAIN — The primary entry point. It drives the overall import cycle: opening the interface cursor for the supplied batch, iterating the staged rows, applying validation and transformation rules, writing valid records to the target tables, and logging errors for records that fail. It is the procedure invoked directly by the calling concurrent program or form when the user initiates a profile/loan import.
• CSS_IMPORT — Handles the import of CSS (College Scholarship Service) profile data specifically. It takes the batch context established by MAIN and performs the CSS-specific mapping, validation, and persistence logic, including lookups resolved through the interface tables and person identifier sources.

The user search term is_lookup_code_exist reflects a common pattern in this and sibling IGF packages, where lookup codes supplied by external agencies are validated against the FND lookup facility before the record proceeds. Where such a check exists, it protects downstream data integrity by rejecting or flagging unknown code values rather than allowing them into the base tables.

Tables Accessed

• IGF_AP_CSS_INTERFACE_ALL and IGF_AP_ISIR_INTRFACE_ALL — the CSS and ISIR staging interfaces that supply the raw imported records.
• IGF_AP_LI_BAT_INTS and IGF_AP_LI_CSS_INTS — loan and CSS interface batch tables used to group and control imports.
• IGF_AW_LI_COA_INTS — Cost of Attendance interface data associated with the loan/profile cycle.
• IGS_PE_PERSON_ID_TYP and IGS_PE_ALT_PERS_ID — person identifier types and alternate person identifiers used to resolve the incoming student to an existing person record.
• FND_NEW_MESSAGES — used for retrieving localized message text via the standard message stack.

Usage Notes

The package is normally invoked indirectly. In a typical EBS Financial Aid deployment it is called from a concurrent program or from a form-based import action that sets up the batch identifier first, then delegates to MAIN and CSS_IMPORT. Because it is classified as OTHER rather than as a public API, it should not be called directly from custom code without understanding the surrounding batch context. Referenced by zero other packages in the documented metadata, it sits near the edge of the Financial Aid dependency graph and depends on the standard Oracle message, utility (DBMS_UTILITY), and dual-table infrastructure to function.