Search Results igf_sl_cl_create_chg




Overview
Explore in AI Chat

Overview

The APPS.IGF_SL_CL_CREATE_CHG package body is a component of the Oracle E-Business Suite (EBS) Financial Aid / Student Loan (IGF) module, a sub-ledger used primarily by higher-education institutions to manage Title IV federal student loan processing. In releases 12.1.1 and 12.2.2, the package is a VALID, compiled PL/SQL unit owned by the APPS schema and classified under the "OTHER" API category. It is not registered as a formal public interface, but rather serves as an internal processing engine invoked by higher-level change or recalculation routines.

Its business function is to generate and persist change records for student loan entities — loans, loan origination records (LORs), awards, and disbursements — whenever a triggering event (such as an adjustment, cancellation, or recalculation) requires the system to record a delta. The package name suggests "Student Loan Change Creation," and its four documented procedures align with that purpose: it creates change rows for each of the four primary loan artifact types.

Key Procedures and Functions

The ETRM documentation enumerates four procedures/functions in this package body. Parameter lists are not published, and per documentation policy should not be inferred.

Each procedure funnels through the change-detail and change-processing infrastructure provided by IGF_SL_CLCHSN_DTLS, IGF_SL_CLCHSN_DTLS_PKG, and IGF_SL_CL_CHG_PRC, ensuring changes are logged consistently and routed for downstream processing.

Tables Accessed

The package reads and/or writes the following documented tables via APPS synonyms:

  • IGF_AW_AWARD_ALL — award header data used by CREATE_AWD_CHG_REC.
  • IGF_AW_AWD_DISB_ALL — award disbursement records used by CREATE_DISB_CHG_REC.
  • IGF_SL_LOANS_ALL — loan master records used by CREATE_LOAN_CHG_REC.
  • IGF_SL_LOR_ALL — loan origination records used by CREATE_LOR_CHG_REC.
  • IGF_SL_CLCHSN_DTLS — change detail rows, the primary persistence target for newly created change records.
  • IGF_SL_CL_RESP_R1_ALL and IGF_SL_CL_RESP_R8_ALL — response/regulatory reporting tables consulted during change processing.
  • IGF_SL_CL_SETUP_ALL — setup/configuration controlling change behavior.
  • FND_NEW_MESSAGES — Oracle Application Object Library message repository used for error and notification text.

Usage Notes

This package is not an end-user entry point. It is invoked indirectly by the change-processing layer (IGF_SL_CL_CHG_PRC) and by the loan/award adjustment flows. The ETRM metadata notes it is referenced by four other packages, confirming its role as a lower-level dependency rather than a public API. Typical invocation paths include:

  • Award and disbursement adjustment forms in the Financial Aid module, which trigger change rows when amounts or statuses are modified.
  • Loan origination and loan maintenance activities that require an audit trail of changes.
  • Concurrent batch processes that reconcile loan data with Common Origination and Disbursement (COD) requirements.

Because it is classified "OTHER" and not flagged as a public API, custom extensions should avoid calling IGF_SL_CL_CREATE_CHG directly. Rely instead on the supported change-processing packages, and treat this object as an internal implementation detail. Error handling leverages FND_MESSAGE, FND_NEW_MESSAGES, and APP_EXCEPTION, consistent with standard EBS coding conventions.