Search Results igf_sl_dl_lor_crresp_pkg




Overview
Explore in AI Chat

Overview

The APPS.IGF_SL_DL_LOR_CRRESP_PKG package body is a member of the Oracle E-Business Suite (EBS) Financial Aid module, delivered under the IGF application prefix that identifies Oracle's Student Financial Aid / Student Loan processing components. In the 12.1.1 and 12.2.2 releases, the package encapsulates the DML (Data Manipulation Language) logic associated with the IGF_SL_DL_LOR_CRRESP entity — a "Loan Origination Record" (LOR) response construct originating from the Direct Loan (DL) interface. This entity stores responses received in connection with loan origination records exchanged with the external Direct Loan servicing environment.

The package is classified as an OTHER-type API in the ETRM (E-Business Suite Technical Reference Manual), meaning it is neither a fully published public API nor a private internal helper, but rather a supporting package used internally by the student loan processing subsystem. Its status is VALID and it resides in the APPS schema, the standard home for shared EBS application logic.

Key Procedures and Functions

The package body exposes eight documented procedures/functions that together implement a conventional table-handler API:

  • INSERT_ROW — Performs the physical insertion of a new Loan Origination Record response row into the underlying table, applying defaults and audit columns as required.
  • LOCK_ROW — Acquires a row-level lock to prevent concurrent modification, typically used before an update to ensure data integrity.
  • UPDATE_ROW — Applies modifications to an existing Loan Origination Record response row.
  • ADD_ROW — A higher-level wrapper that coordinates insertion logic, likely invoking BEFORE_DML and INSERT_ROW together.
  • DELETE_ROW — Removes an existing Loan Origination Record response row from the table.
  • GET_PK_FOR_VALIDATION — Retrieves the primary key of a target row so that validation logic can confirm existence and uniqueness.
  • GET_FK_IGF_SL_DL_BATCH — Resolves the foreign key reference linking the LOR response to its parent batch record in the IGF_SL_DL_BATCH entity.
  • BEFORE_DML — A pre-processing routine that executes common logic — such as deriving audit columns, applying WHO columns, or validating business rules — prior to any insert, update, or delete.

Tables Accessed

The package reads from and writes to two primary base tables via APPS synonyms:

  • IGF_SL_DL_LOR_CRRESP_ALL — The core "ALL" table that holds Loan Origination Record response data for all operating units, and which the DML procedures directly manipulate.
  • IGF_SL_DL_LOR_CRRESP_S — A companion "S" table, typically a translation or security/sequence-support table associated with the same entity.
  • DUAL — The conventional Oracle dummy table, invoked for singleton lookups and expressions.

The package also references the related entity IGF_SL_DL_BATCH indirectly through its GET_FK_IGF_SL_DL_BATCH function and through the IGF_SL_DL_BATCH_PKG dependency, confirming that Loan Origination Record responses are maintained as children of a Direct Loan batch.

Usage Notes

As an OTHER-classification package, IGF_SL_DL_LOR_CRRESP_PKG is not intended to be invoked directly by end users or called from arbitrary custom code. It is instead invoked by the standard Student Loan forms, concurrent programs, and other internal IGF packages that manage the Direct Loan response lifecycle. The dependency list confirms that it references IGF_SL_DL_BATCH_PKG, IGF_AW_GEN, FND_MESSAGE, FND_GLOBAL, APP_EXCEPTION, and IGS_GE_MSG_STACK for message handling, error management, and global context.

Because it is not referenced by any other database object, IGS/IGF developers extending Direct Loan processing should treat it as an internal helper and, where possible, favor the higher-level batch package for integration. Any customization should preserve the BEFORE_DML contract so that audit columns and validations remain intact across releases 12.1.1 and 12.2.2.