Search Results igf_sl_dl_pnote_p_p_pkg




Overview
Explore in AI Chat

Overview

IGF_SL_DL_PNOTE_P_P_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema. The prefix follows the EBS convention used for generated Forms block handlers: IGF denotes the Financial Aid / Student Loan (formerly iGrants/IGF) product family, SL denotes the Student Loan module, and the trailing _P_P_PKG suffix identifies it as a private, form-generated package associated with a Promissory Note (PNOTE) block. In the context of Oracle EBS 12.1.1 and 12.2.2, the package implements the row-level DML logic that a Student Loan promissory note maintenance form invokes when end users insert, update, lock, or delete promissory note records.

Its documented API classification is OTHER, and the ETRM metadata reports a status of VALID with no package or package body errors. The package is instantiated against the APPS schema and depends only on SYS.STANDARD at the language level, with its real data access routed through APPS synonyms.

Key Procedures and Functions

The ETRM metadata documents eight procedures and functions:

  • INSERT_ROW — Performs the physical insert of a new promissory note row into the base table when the form commits a newly entered record.
  • ADD_ROW — Supports the form's "add row" action, preparing a new in-memory record and obtaining default/populated values before the row is persisted.
  • UPDATE_ROW — Applies changes made by the user to an existing promissory note record and writes them back to the base table.
  • DELETE_ROW — Removes a promissory note row that the user has marked for deletion.
  • LOCK_ROW — Issues the standard row-level locking call (SELECT FOR UPDATE) against the base table so concurrent form sessions cannot modify the same promissory note record simultaneously.
  • BEFORE_DML — A pre-DML trigger-style routine that performs validation, WHO-column (created_by/updated_by and timestamps) population, and any attribute derivation before insert, update, or delete executes.
  • GET_PK_FOR_VALIDATION — Returns the primary key value used by the form's validation logic to confirm record identity.
  • GET_FK_IGF_SL_LOANS — Returns the foreign key value linking the promissory note to its parent Student Loan record in IGF_SL_LOANS.

As is typical for generated block packages, these routines are not intended as a public integration API but as the mechanics behind a specific form block.

Tables Accessed

The package accesses the following objects through APPS synonyms:

  • IGF_SL_DL_PNOTE_P_P_ALL — The base (transaction) table holding promissory note records. All insert, update, delete, lock, and validation operations target this table.
  • IGF_SL_DL_PNOTE_P_P_ALL_S — The corresponding sequence used to generate primary key values for new promissory note rows, referenced by INSERT_ROW and ADD_ROW.
  • DUAL — Used for single-row lookups and sequence evaluation, consistent with standard PL/SQL generation patterns.

Usage Notes

IGF_SL_DL_PNOTE_P_P_PKG is invoked indirectly rather than called directly. Within Oracle EBS, form-generated packages are triggered by the Forms runtime when a user interacts with the promissory note block — querying, creating, updating, or deleting a note. The metadata confirms the package is referenced by IGF_SL_DL_PNOTE_P_P_PKG itself, by the print routine IGF_SL_DL_PRINT_PNOTE, by the loan processing package IGF_SL_LOANS_PKG, and by the loan import package IGF_SL_DL_LI_IMP_PKG. This dependency set indicates it participates in promissory note lifecycle processing across form maintenance, printing, and loan import flows. Custom code should treat these routines as internal and interact with the underlying APPS tables or the higher-level loan APIs instead.