Search Results igf_sl_dl_chg_resp_pkg




Overview
Explore in AI Chat

Overview

IGF_SL_DL_CHG_RESP_PKG is an Oracle Application Object Library (APPS) PL/SQL package body that supports the Oracle Student Financial Aid / Student Loan (IGF) subsystem within Oracle E-Business Suite 12.1.1 and 12.2.2. The package encapsulates the change-responsibility logic associated with student loan disbursement processing, specifically the responsibility attributes recorded against disbursement batches held in the IGF_SL_DL_CHG_RESP_ALL table. It functions as a table-handling API (classified as OTHER in the ETRM registry) rather than a business-flow API, providing the standard DML services — insert, update, delete, lock, validation, and foreign-key retrieval — that Forms and concurrent programs require when maintaining change-responsibility records. The object is registered as VALID in the APPS schema and is documented in ETRM for release 12.1.1.

Key Procedures and Functions

The package body exposes eight documented program units, all consistent with the Oracle Forms server-side table handler pattern:

  • INSERT_ROW — Inserts a new change-responsibility record into the base table, populating standard WHO columns and the primary key.
  • LOCK_ROW — Issues a row-level lock against an existing record to serialize concurrent maintenance from Forms sessions.
  • UPDATE_ROW — Applies modified column values to an existing change-responsibility row.
  • ADD_ROW — Composite entry point that validates and inserts a new row, typically invoked from the Forms On-Insert trigger.
  • DELETE_ROW — Removes a change-responsibility record from the base table.
  • GET_PK_FOR_VALIDATION — Returns the primary key used to validate a row prior to DML, supporting the Forms validation cycle.
  • GET_FK_IGF_SL_DL_BATCH — Returns the foreign-key reference to the disbursement batch, establishing the parent-child link between a change-responsibility entry and its IGF_SL_DL_BATCH record.
  • BEFORE_DML — Central pre-DML hook that performs validation and defaulting, calling supporting utilities such as FND_MESSAGE, IGS_GE_MSG_STACK, and IGF_AW_GEN for error signalling.

Tables Accessed

The package operates against three documented tables (through APPS synonyms):

  • IGF_SL_DL_CHG_RESP_ALL — the base change-responsibility table; this is the primary insert/update/delete target.
  • IGF_SL_DL_CHG_RESP_S — the corresponding sequence source used to generate unique primary keys for new rows.
  • DUAL — used for singleton SELECT statements such as sequence retrieval and validation checks.

Referenced dependencies include IGF_SL_DL_BATCH_PKG for batch-level validation, APP_EXCEPTION and FND_GLOBAL for error handling and session context, and IGF_SL_DL_CHG_RESP_PKG itself (recursive reference) for internal helper calls.

Usage Notes

IGF_SL_DL_CHG_RESP_PKG is a back-end table handler invoked indirectly rather than called directly by end users. Its documented consumers are the Oracle Forms change-responsibility block (via the standard On-Insert, On-Update, On-Delete, and On-Lock triggers), concurrent programs or workflows that maintain disbursement change-responsibility data, and other PL/SQL packages in the IGF_SL_* family. ETRM records that the package is referenced by three other database objects, confirming its role as a dependency consumed by higher-level batch and disbursement processing logic. Because it is a table-handling API, customizations should call the documented entry points (ADD_ROW, UPDATE_ROW, DELETE_ROW, LOCK_ROW) rather than performing direct DML on IGF_SL_DL_CHG_RESP_ALL, so that the BEFORE_DML validation and foreign-key derivation logic remain intact. No object is recorded as being referenced by this package beyond its documented dependencies.