Search Results igf_sl_dl_chg_send_s

Overview

The APPS.IGF_SL_DL_CHG_SEND_PKG package body is a component of the Oracle E-Business Suite (EBS) Financial Aid module, specifically within the Student Loan (IGF) subsystem. Its principal business function is to manage the transmission of student loan change (DL Change) records between the institution's EBS instance and external loan servicing or disbursement partners. The package encapsulates the server-side logic required to stage, validate, and dispatch change-send data relating to loan disbursements, adjustments, and related status updates. It operates against the base table IGF_SL_DL_CHG_SEND_ALL and its corresponding sequence IGF_SL_DL_CHG_SEND_S, providing the standard DML and validation operations that support the change-send workflow. In the context of Oracle EBS 12.1.1 and 12.2.2, this object is registered in the Applications schema (APPS) and remains in VALID status, indicating that it compiles successfully against the current database release. It serves as the programmatic layer beneath the change-send functionality, exposing procedures that forms, batch processes, and other PL/SQL packages rely upon to persist and retrieve change-send records consistently.

Key Procedures and Functions

The ETRM documentation records eight procedures and functions within the package body:

• INSERT_ROW — Inserts a new change-send record into the base table, populating the primary key from the associated sequence.
• LOCK_ROW — Acquires a row-level lock on an existing change-send record to serialize concurrent access during updates.
• UPDATE_ROW — Modifies an existing change-send record, typically used after validation or status transitions.
• ADD_ROW — Adds a row through the package's higher-level staging logic, coordinating insertion with sequence retrieval and default handling.
• DELETE_ROW — Removes a change-send record from the base table.
• GET_PK_FOR_VALIDATION — Returns the primary key of a record to be validated, supporting the package's validation framework.
• GET_FK_IGF_SL_DL_BATCH — Retrieves the foreign-key reference to the associated student loan disbursement batch, linking a change-send row to its parent batch.
• BEFORE_DML — A pre-DML trigger-style procedure that executes validation and default-value logic prior to INSERT, UPDATE, or DELETE operations.

Tables Accessed

The package reads and writes the following documented objects through APPS synonyms:

• IGF_SL_DL_CHG_SEND_ALL — The primary base table storing change-send records. All insert, update, delete, and lock operations target this table.
• IGF_SL_DL_CHG_SEND_S — The sequence supplying unique primary-key values for new change-send rows.
• DUAL — Used for sequence retrieval and single-value select operations within the package logic.

Additional dependencies include FND_GLOBAL and FND_MESSAGE for session context and message handling, APP_EXCEPTION and IGS_GE_MSG_STACK for error propagation, and IGF_AW_GEN, IGF_SL_DL_BATCH_PKG, and IGF_SL_DL_CHG_SEND_ALL for batch and generation logic.

Usage Notes

This package is typically invoked indirectly rather than called directly by end users. It is referenced by three other database objects, and the documentation indicates it is not referenced by any object outside the APPS schema. In practice, it is called from the Student Loan change-send forms, from the batch processing package IGF_SL_DL_BATCH_PKG, and from custom extensions that stage change-send records for outbound transmission. The BEFORE_DML procedure should be invoked prior to any direct DML performed outside the package to ensure validation rules and defaults are applied. Because it is marked VALID in both 12.1.1 and 12.2.2, the package is compatible with the Online Patching (adop) model introduced in 12.2, and no recompilation is required after patching cycles.