Search Results create_lor_chg_rec




Overview
Explore in AI Chat

Overview

IGF_SL_CL_CREATE_CHG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the CommonLine (Common Line) Release 4 student loan processing interface within the Oracle Financial Aid / Student Loan (IGF) module. Its purpose, as documented in the package header created by Sanil Madathil in October 2004, is to create Change Records for CommonLine Release 4 version loans. These change records are generated whenever award or loan information changes for loans that carry the "Accepted" status.

The package is invoked through table handlers on the Disbursement and Loans tables, meaning it functions as part of the ETRM (Enterprise Transaction Record Management) framework that monitors DML activity on specific tables and drives downstream processing. By automatically generating the appropriate change records, the package ensures that the CommonLine interface remains synchronized with the most current award, loan, loan origination record, and disbursement data before transmissions are constructed and sent to external loan servicers and guarantee agencies.

Key Procedures and Functions

Four public procedures are defined in this specification:

  • CREATE_LOAN_CHG_REC — Accepts a row from the loans table and generates a change record reflecting modifications to an existing CommonLine Release 4 loan. It returns a status flag and a message name through its OUT parameters.
  • CREATE_LOR_CHG_REC — Accepts a row from the Loan Origination Record (LOR) table and produces the corresponding change record for loan origination data. Like the loan routine, it reports success or failure and a message name back to the caller.
  • CREATE_AWD_CHG_REC — Creates a change record based on award-level information. It takes an award identifier, an old amount, a new amount, and a change type indicator, and returns a boolean status plus a message name. This is the routine associated with the user search term "create_awd_chg_rec."
  • CREATE_DISB_CHG_REC — Creates a change record for disbursement activity by comparing a new disbursement row against the prior (old) disbursement row, again returning status and message name outputs.

All four procedures follow a consistent error-handling contract: a boolean return status and a message name that callers can resolve through the standard message dictionary.

Tables Accessed

The package operates against several IGF tables through APPS synonyms. IGF_AW_AWARD_ALL supplies award-level data used by CREATE_AWD_CHG_REC; IGF_AW_AWD_DISB_ALL holds disbursement records compared by CREATE_DISB_CHG_REC; IGF_SL_LOANS_ALL is the source for loan change records; and IGF_SL_LOR_ALL provides the loan origination record data used by CREATE_LOR_CHG_REC.

Change record persistence and CommonLine context rely on IGF_SL_CLCHSN_DTLS, IGF_SL_CL_RESP_R1_ALL, IGF_SL_CL_RESP_R8_ALL, and IGF_SL_CL_SETUP_ALL, which store change detail, response, and setup information. FND_NEW_MESSAGES is referenced to supply message names for the OUT parameters. The package is in turn referenced by four other packages, indicating it is a dependency within the broader CommonLine processing chain.

Usage Notes

IGF_SL_CL_CREATE_CHG is not intended to be called directly by end users. It is invoked indirectly through table handlers on the Disbursement and Loans tables, meaning changes performed through the standard EBS forms or concurrent processes on those tables trigger the change record logic automatically. The package only applies to CommonLine Release 4 loans in "Accepted" status, so change records are not produced for other versions or unaccepted loans.

Developers extending or troubleshooting CommonLine processing should be aware that error diagnosis depends on resolving the returned message name, and that the package participates in a broader dependency graph (referenced by four packages). Customizations that bypass the documented table handlers may prevent change records from being generated, resulting in stale or inaccurate CommonLine transmissions.