Search Results igf_sl_dl_pnote_resp_pkg




Overview
Explore in AI Chat

Overview

IGF_SL_DL_PNOTE_RESP_PKG is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite. It belongs to the Financial Aid subsystem of Oracle Student Systems, reflected by the IGF prefix (Financial Aid) and the SL_DL component (Student Loan / Direct Loan). The suffix PNOTE_RESP refers to promissory note responsibility data, the entity that governs a borrower's obligations and responsibilities on a Direct Loan promissory note. The package implements the standard EBS table-handling API pattern: it encapsulates insert, update, delete, and locking logic for the promissory note responsibility entity, shielding callers from direct Data Manipulation Language (DML) against the underlying base and translation tables. Its documented API classification is OTHER, and the package is marked VALID in the ETRM repository for both 12.1.1 and 12.2.2.

Key Procedures and Functions

Eight procedures and functions are documented for this package, following the conventional EBS generated-API naming pattern:

  • INSERT_ROW — Inserts a new promissory note responsibility record into the base table, populating primary key and audit columns.
  • LOCK_ROW — Selects the target row for update, serializing concurrent modifications and raising an exception if the row is already locked or absent.
  • UPDATE_ROW — Applies modifications to an existing promissory note responsibility record, preserving the primary key and updating WHO columns.
  • ADD_ROW — Higher-level entry point that determines whether to insert a new row, updating an existing one; typically used by form and concurrent processing logic.
  • DELETE_ROW — Removes a promissory note responsibility record and any dependent translation rows.
  • GET_PK_FOR_VALIDATION — Retrieves the primary key of a row for validation checks, such as determining whether a record exists before insert or update.
  • GET_FK_IGF_SL_DL_BATCH — Returns the foreign key linking the promissory note responsibility record to its owning batch in IGF_SL_DL_BATCH, supporting batch-level processing.
  • BEFORE_DML — A pre-DML hook that enforces business rules, checks required columns, and raises messages before insert, update, or delete operations execute.

Tables Accessed

The package references two documented base tables through APPS synonyms and one utility table:

  • IGF_SL_DL_PNOTE_RESP_ALL — The base table storing promissory note responsibility records. This is the primary target of insert, update, delete, and lock operations.
  • IGF_SL_DL_PNOTE_RESP_ALL_S — The translation/sequence table associated with the base table, used to maintain language-dependent or sequence-maintained rows.
  • DUAL — The standard Oracle single-row utility table, used for lightweight validation and sequence lookups.

Dependency metadata shows the package also references IGF_SL_DL_BATCH_PKG, IGF_SL_DL_PDET_RESP_PKG, IGS_GE_GEN_003, IGS_GE_MSG_STACK, FND_GLOBAL, FND_MESSAGE, and APP_EXCEPTION, indicating integration with batch processing, detail-level promissory note responsibility logic, error messaging, and global environment context.

Usage Notes

IGF_SL_DL_PNOTE_RESP_PKG is not referenced by any other database object, so it is invoked as a top-level API. Typical callers are Oracle Forms-based maintenance screens for promissory note responsibility data, Direct Loan batch processing that creates or reconciles promissory note responses, and custom extensions that need to create or modify responsibility records via a supported API rather than direct DML. Callers should use ADD_ROW for user-driven maintenance (its internal logic selects insert or update as appropriate), INSERT_ROW or UPDATE_ROW for explicit control, and DELETE_ROW only after confirming dependencies. FND_GLOBAL supplies the application and user context used in the WHO audit columns, while FND_MESSAGE and IGS_GE_MSG_STACK drive error handling and user-facing messages. The GET_FK_IGF_SL_DL_BATCH function should be used when batch context must be resolved without querying the base table directly.