Search Results igf_sl_dl_chg_send_pkg

Overview

IGF_SL_DL_CHG_SEND_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Student Loan (SL) module of the Oracle Financials/IGF (formerly Oracle Student System, later part of the Oracle Loans/Student Loan processing family). Its name and the presence of a foreign-key validation routine referencing IGF_SL_DL_BATCH indicate that it manages the Disbursement Change Send entity—records that capture changes to disbursement batches, such as changes to change codes, new values, and change status, that must be propagated or transmitted downstream. The package is declared with AUTHID CURRENT_USER, so it executes with the privileges of the invoking user rather than the definer, and its header carries an RCS revision string identifying it as a 2002-era source file (IGFLI17S.pls, 115.3). It exposes a standard Oracle Forms-style transactional API: insert, lock, update, add, and delete operations over a single base table, plus validation functions and a centralized BEFORE_DML hook. The classification is OTHER, meaning it is not an Oracle-published public Web API but is nonetheless used by other application code—three other packages reference it directly.

Key Procedures and Functions

The package provides eight documented callable units:

• INSERT_ROW — Inserts a new Disbursement Change Send record. It accepts the change number (as an OUT parameter, since the primary key is generated), the batch/debt identifier, loan number, change code, new value, status, and a mode flag defaulting to 'R'.
• LOCK_ROW — Issues a SELECT ... FOR UPDATE lock against the target row, using the rowid and identifying key columns, so Forms can implement optimistic locking before an edit.
• UPDATE_ROW — Modifies an existing change send row keyed by rowid and change number, updating the batch identifier, loan number, change code, new value, and status.
• ADD_ROW — Combines insert-or-update semantics. The rowid and change number are IN OUT NOCOPY, allowing the procedure to return the identity of an inserted or existing row.
• DELETE_ROW — Removes the row identified by the supplied rowid.
• GET_PK_FOR_VALIDATION — Boolean validation function that confirms the primary key (change number) exists before dependent DML is attempted.
• GET_FK_IGF_SL_DL_BATCH — Foreign-key validation routine for the parent batch table (IGF_SL_DL_BATCH). It is the routine surfaced by the search term get_fk_igf_sl_dl_batch, and it verifies that a given batch/debt identifier (x_dbth_id) is valid in the parent entity before allowing a change send record to reference it.
• BEFORE_DML — Centralized pre-DML handler invoked with an action code and the full set of column values. It applies standard Oracle EBS housekeeping conventions: who-columns (created_by, creation_date, last_updated_by, last_update_date) and last_update_login, plus any derived or validation logic, before the insert or update proceeds.

Tables Accessed

The package operates on three documented objects. IGF_SL_DL_CHG_SEND_ALL is the base transactional table holding all Disbursement Change Send rows, and is the target of INSERT_ROW, UPDATE_ROW, ADD_ROW, and DELETE_ROW. IGF_SL_DL_CHG_SEND_S is the corresponding sequence (and, in EBS multi-org convention, the paired table) used to generate the change number primary key populated via the NOCOPY OUT parameter. DUAL is referenced for lightweight validation queries, most notably inside GET_FK_IGF_SL_DL_BATCH and GET_PK_FOR_VALIDATION, where an existence check against the parent batch table (IGF_SL_DL_BATCH) is executed and the boolean result returned.

Usage Notes

This package is intended to be called from Oracle Forms-based UI code, from the Oracle EBS framework's server-side validation handlers, and from custom PL/SQL that must manipulate Disbursement Change Send rows while honoring the application's locking and auditing rules. Typical invocation follows the Forms pattern: LOCK_ROW before an edit, then UPDATE_ROW with the current rowid; ADD_ROW for combined create/update flows in a block; DELETE_ROW on block deletion; and GET_FK_IGF_SL_DL_BATCH or GET_PK_FOR_VALIDATION from a WHEN-VALIDATE-ITEM trigger or programmatic validation layer to enforce referential integrity against the parent batch entity. Because the package performs no COMMIT or ROLLBACK (standard for these Forms-support APIs), transaction control remains with the caller. Before_DML should not be called directly; it is intended as an internal hook from the DML procedures. In releases 12.1.1 and 12.2.2, the package remains available under APPS, and code migrating from SOA/WebADI integrations should call the documented procedures rather than writing to IGF_SL_DL_CHG_SEND_ALL directly, in order to preserve who-column population and foreign-key validation.