Search Results sub_cl_originate

Overview

IGF_SL_CL_ORIG is a PL/SQL package in the APPS schema that belongs to the Oracle Financial Aid module of Oracle E-Business Suite, part of the broader Student Systems (IGS/IGF) product family. The module name component "SL" designates Student Loans, "CL" designates the CommonLine processing interface used by the U.S. federal and private student loan industry, and "ORIG" denotes origination. The package therefore implements the loan origination business function: the set of validations, data derivations, and record creations performed when a student loan is originated with a lender, guarantor, servicer, or school before the funds are disbursed.

The package is classified as OTHER in the ETRM registry, meaning it is an internal processing package rather than a formally published open API. Its status is VALID in the documented 12.1.1 environment, and the same metadata applies to the 12.2.2 code line. In the dependency listing, IGF_SL_CL_ORIG references IGF_SL_LOANS_ALL and IGS_CA_INST directly, and is self-referencing, indicating that wrapper entry points call additional packaged logic within the same unit.

Key Procedures and Functions

• CL_ORIGINATE — The primary entry point for originating a student loan. Invocation of this procedure drives the origination workflow for a loan record, including the resolution of lender, guarantor, servicer, and recipient data and the validation of loan attributes before the origination record is committed.
• SUB_CL_ORIGINATE — A subordinate or sub-processing routine invoked in support of CL_ORIGINATE. It isolates a discrete portion of the origination steps, allowing the top-level procedure to delegate repeated or conditional processing rather than duplicating logic.

Both procedures are documented by name only; the ETRM metadata does not publish their parameter signatures. The self-referencing dependency confirms that these two entry points call one another or share common packaged logic.

Tables Accessed

The package operates against the following documented tables through APPS synonyms:

• IGF_SL_LOANS_ALL — The core student loan master table; origination reads and updates loan records here. It is also the one table the dependency analysis shows the package referencing explicitly in SQL.
• IGF_SL_CL_RECIPIENT, IGF_SL_GUARANTOR, IGF_SL_LENDER, IGF_SL_SERVICER — Party reference data identifying the recipient, guarantor, lender, and servicer associated with the origination.
• IGF_SL_CL_PREF_LENDERS — Preferred lender configuration used to resolve or validate lender selection.
• IGF_SL_CL_FILE_TYPE, IGF_SL_PE_CITI_MAP — CommonLine file type definitions and mapping data used to construct or interpret origination records exchanged with external loan partners.
• IGF_SL_LOR_ALL, IGF_SL_LOR_LOC_ALL — Loan origination request header and location detail tables, central to the origination transaction itself.
• IGF_AW_AWARD_ALL, IGF_AW_FUND_MAST_ALL, IGF_AW_FUND_CAT_ALL — Award and fund records that supply the financial aid context for the loan being originated.
• IGF_AP_FA_BASE_REC_ALL, IGF_AP_ISIR_MATCHED_ALL — Applicant base records and ISIR matching results used to validate eligibility.
• IGS_CA_INST — The institution/calendar instance, supplying the academic context.

Usage Notes

IGF_SL_CL_ORIG is an internal package and is not exposed as a public API. It is normally invoked indirectly by the Student Loans origination forms, by concurrent programs that generate and transmit CommonLine origination files to lenders and guarantors, or by other Financial Aid packages during the loan processing cycle. Because the package carries an OTHER classification and no published parameter interface, customizations should not call it directly; implementers are advised to use the supported Student Loans processes instead. The package is not referenced by any other documented package, which confines its blast radius to the direct origination flow. Oracle's standard disclaimer applies to the proprietary contents, and any modification of seeded logic requires an approved custom wrapper to preserve upgrade safety in both 12.1.1 and 12.2.2.