Search Results igf_sl_dl_pnote_p_p_all_s

Overview

IGF_SL_DL_P_PNOTE_P_P_PKG is the Oracle Application Object Library (APPS) PL/SQL package body that implements the server-side data access and DML layer for the Student Loan Promissory Note component of Oracle Financial Aid (part of the Oracle E-Business Suite 12.1.1 and 12.2.2 footprints under the IGF/IGS module family). The package name follows the standard Oracle Forms "P_P" (table handler plus post-processing) naming convention, denoting a generated table-handler package bound to the IGF_SL_DL_PNOTE_P_P_ALL entity. Its business purpose is to encapsulate the insert, update, delete, locking, primary and foreign key derivation, and pre-DML validation logic required to maintain promissory note records associated with Direct Loan disbursements processed for students. Because the package resides in the APPS schema and is fully validated, it operates against APPS synonyms and participates in the shared multitenant-safe environment typical of EBS 12.x.

Key Procedures and Functions

The documented interface exposes eight program units, each fulfilling a discrete role in the standard Forms-generated table-handler pattern:

• INSERT_ROW — Performs the core insertion of a new promissory note row into the base table.
• LOCK_ROW — Acquires a row-level lock on the target record with the correct FOR UPDATE semantics to serialize concurrent modifications.
• UPDATE_ROW — Applies changes to existing rows, typically including a WHO-column or last-update audit stamp.
• ADD_ROW — Inserts a row via the alternate transactional entry path used by Forms when records are appended to a block.
• DELETE_ROW — Removes the specified promissory note record.
• GET_PK_FOR_VALIDATION — Returns the primary key value required by the Forms framework to validate the current record before DML.
• GET_FK_IGF_SL_LOANS — Derives the foreign key linking the promissory note record to its parent loan in IGF_SL_LOANS_PKG, enforcing the loan-to-note relationship.
• BEFORE_DML — Central pre-DML hook that invokes validation, WHO-column population, and foreign key resolution prior to any INSERT, UPDATE, or DELETE.

Tables Accessed

The package operates exclusively through APPS synonyms against three documented relations:

• IGF_SL_DL_PNOTE_P_P_ALL — The base promissory note table; it is the primary read/write target for INSERT_ROW, UPDATE_ROW, ADD_ROW, DELETE_ROW, and LOCK_ROW.
• IGF_SL_DL_PNOTE_P_P_ALL_S — The associated sequence (referenced in the search term), supplying generated primary key values used by GET_PK_FOR_VALIDATION and BEFORE_DML.
• DUAL — Used for trivial single-row SELECTs, such as sequence NEXTVAL fetches and validation probes.

Usage Notes

The package is normally invoked from Oracle Forms-based Student Loan maintenance windows, where the Forms runtime calls the table handler automatically when an end user queries, creates, or modifies a promissory note. It may also be called from custom PL/SQL or concurrent programs that require programmatic DML against promissory notes, provided the caller respects the BEFORE_DML invocation order and supplies a valid loan foreign key. The package depends on shared EBS infrastructure — FND_GLOBAL and FND_MESSAGE for application context and messages, IGS_GE_MSG_STACK and IGS_GE_GEN_003 for error handling, APP_EXCEPTION for exception propagation, and IGF_SL_LOANS_PKG for loan-side processing. Because it is referenced by three other packages, changes to its behavior can propagate across the loan promissory note subsystem, so modifications should be validated against dependent forms and concurrent processes before deployment in either 12.1.1 or 12.2.2 environments.