Search Results igf_sl_dl_pdet_resp_pkg




Overview
Explore in AI Chat

Overview

IGF_SL_DL_PDET_RESP_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/Financial Aid functionality delivered through the ETRM (Enterprise Tax and Regulatory Management) code line. Operationally, the package encapsulates the DML and validation logic for the IGF_SL_DL_PDET_RESP entity — the "Direct Loan Promissory Note Detail Response" records exchanged between the institution and the Common Origination and Disbursement (COD) system. It functions as a low-level data-access layer, isolating row insertion, locking, updating, deletion, and pre-DML validation for that entity so that higher-level business packages can manage promissory note response data without embedding direct SQL against the underlying table.

Key Procedures and Functions

The package exposes eight documented program units:

  • INSERT_ROW — Inserts a new detail response row into the base table, populating the primary key and all attributed columns.
  • LOCK_ROW — Acquires a row-level lock on an existing record to serialize concurrent updates, typically invoked before an edit.
  • UPDATE_ROW — Persists modifications to an existing detail response record.
  • ADD_ROW — Provides a controlled add path for a new detail response, generally handling surrogate key derivation prior to insertion.
  • DELETE_ROW — Removes a detail response record from the base table.
  • GET_PK_FOR_VALIDATION — Returns or resolves the primary key value used to validate the uniqueness and integrity of a detail response record.
  • GET_FK_IGF_SL_DL_PNOTE_RESP — Returns the foreign key that links the detail response to its parent promissory note response record, enabling coordinated processing across the header and detail entities.
  • BEFORE_DML — Serves as the pre-DML validation hook invoked by the other procedures to enforce business rules and column derivations before a row is inserted, updated, or deleted.

Tables Accessed

The package reads and writes the APPS synonym IGF_SL_DL_PDET_RESP, the base table holding promissory note detail response rows. INSERT_ROW, ADD_ROW, UPDATE_ROW, and DELETE_ROW perform the actual data modification; LOCK_ROW, GET_PK_FOR_VALIDATION, and GET_FK_IGF_SL_DL_PNOTE_RESP query the table to support concurrency control and referential validation. All access is through the APPS schema synonym, so the package inherits the standard EBS privileges and the SYS.STANDARD dependency reflected in the object metadata.

Usage Notes

IGF_SL_DL_PDET_RESP_PKG is not intended for direct end-user invocation. It is referenced by the following APPS packages, which comprise its principal callers: IGF_SL_DL_LI_IMP_PKG (loan import processing), IGF_SL_DL_PNOTE_ACK (promissory note acknowledgment), and IGF_SL_DL_PNOTE_RESP_PKG (promissory note response processing). These callers invoke the DML and validation routines as part of inbound COD file processing, record maintenance through EBS forms, and any concurrent program or custom extension that maintains Direct Loan promissory note responses. The package is also self-referenced, indicating internal calls among its own routines. Because it is a row-level data layer, integrations should call the higher-level packages wherever possible so that complete validation and dependent record handling are preserved for both Oracle EBS 12.1.1 and 12.2.2 environments.