Search Results igf_sl_cl_orig




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:

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.