Search Results igf_sl_dl_batch_pkg




Overview
Explore in AI Chat

Overview

The APPS.IGF_SL_DL_BATCH_PKG package body is a core PL/SQL component within the Oracle E-Business Suite (EBS) Student Financial Aid / Financial Aid (IGF) module — specifically the "SL" (Student Loan) sub-area that manages loan disbursement processing. This package encapsulates the batch-level data manipulation logic for student loan disbursement batches, which are groups of loan disbursement records processed together for a given award period or disbursement cycle. The package provides the procedural foundation for creating, maintaining, and validating loan disbursement batch headers, following the standard Oracle EBS table-handling (TAPI-style) pattern of INSERT_ROW, UPDATE_ROW, LOCK_ROW, and DELETE_ROW operations alongside validation and pre-DML hooks.

The object is classified as "OTHER" by the ETRM, indicating it is an internal application-programming interface rather than a formally published public API. The package body is marked VALID in the APPS schema on the 12.1.1 reference environment, and the same definition is expected to carry forward into 12.2.x environments.

Key Procedures and Functions

The package exposes seven documented procedures/functions:

  • INSERT_ROW — Inserts a new loan disbursement batch record into the base table, populating the mandatory columns used by the TAPI layer.
  • LOCK_ROW — Acquires a row lock on an existing batch record, preventing concurrent modification while an update or delete is in progress.
  • UPDATE_ROW — Applies changes to an existing batch record, coordinating with the locking mechanism to ensure data integrity.
  • ADD_ROW — A higher-level wrapper that combines validation and insertion logic for adding a batch record in one call.
  • DELETE_ROW — Removes a batch record, typically subject to validation that the batch is not associated with downstream disbursement activity.
  • GET_PK_FOR_VALIDATION — Resolves the primary key required for validation checks, used by the pre-DML validation flow to identify the record being processed.
  • BEFORE_DML — The pre-DML hook that enforces WHO-column population (creation/update user and date via FND_GLOBAL), validation rules, and message-stack error handling before insert, update, or delete operations proceed.

Tables Accessed

The package reads and writes two application tables via APPS synonyms, plus the standard oracle dictionary view:

  • IGF_SL_DL_BATCH_ALL — The base table holding loan disbursement batch records; the target of INSERT_ROW, UPDATE_ROW, and DELETE_ROW.
  • IGF_SL_DL_BATCH_S — The translation/seed table for batch-level reference data, joined during validation to resolve display values.
  • DUAL — Used for scalar PL/SQL evaluations and validation expressions.

Additionally, the dependency list shows the package body calls several sibling IGF packages: IGF_SL_DL_CHG_RESP_PKG, IGF_SL_DL_CHG_SEND_PKG, IGF_SL_DL_LOR_CRRESP_PKG, IGF_SL_DL_LOR_RESP_PKG, and IGF_SL_DL_PNOTE_RESP_PKG, which handle change responses, letters of recommendation, and promissory note responses. These are invoked to keep downstream response tracking consistent with batch modifications.

Usage Notes

IGF_SL_DL_BATCH_PKG is typically invoked indirectly rather than called directly by end users. It is used by standard EBS forms (such as the loan disbursement batch setup forms) and by concurrent programs that generate or maintain disbursement batch records. Custom code should not call the individual row handlers unless it respects the BEFORE_DML contract, because error conditions are accumulated on IGS_GE_MSG_STACK and surfaced through FND_MESSAGE. The package is referenced by twelve other database objects, confirming it is a dependency in the loan disbursement processing chain and should be modified with care to avoid invalidating dependents.