Search Results igf_sl_dl_pnote_s_p_all_s

Overview

The package body APPS.IGF_SL_DL_PNOTE_S_P_PKG belongs to the Oracle E-Business Suite (EBS) Financial Aid module, operating within the schema APPS and classified under the API classification OTHER. Its functional purpose is to manage the master (non-translated) table IGF_SL_DL_PNOTE_S_P_ALL, which stores promissory note data associated with student loan processing under the Federal Family Education Loan (FFEL) and Direct Loan (DL) framework. The package provides the standard Oracle Forms-driven DML layer for this entity: it encapsulates row insertion, locking, update, sequence population, foreign key derivation, and pre-DML normalization logic. In EBS releases 12.1.1 and 12.2.2, this package body remains VALID and is a private support component for the corresponding entity table rather than a public, documented API. It is not referenced by any other database object, confirming its role as a leaf-level implementation package consumed principally by the associated Oracle Forms module and the "_S" synonym-view layer (IGF_SL_DL_PNOTE_S_P_ALL_S).

Key Procedures and Functions

The package body exposes eight documented procedures and functions, all consistent with the standard Oracle Forms table handler pattern:

• INSERT_ROW — performs the actual insert of a new promissory note row into the base table, applying any column defaults or validations established for the entity.
• LOCK_ROW — issues the SELECT ... FOR UPDATE lock required by Forms for optimistic concurrency control and edit-mode row stabilization.
• UPDATE_ROW — writes modified column values back to an existing promissory note record.
• ADD_ROW — creates a new row in the Forms block, invoking table-specific defaulting and sequence assignment logic.
• DELETE_ROW — removes a promissory note row from the base table.
• GET_PK_FOR_VALIDATION — returns the primary key value used by Forms for row validation and coordination with subordinate detail blocks.
• GET_FK_IGF_SL_LOANS — resolves and returns the foreign key linking the promissory note record to its parent loan record in the IGF_SL_LOANS entity, supporting master-detail relationship enforcement.
• BEFORE_DML — a pre-DML trigger routine that executes normalization, message-stack setup, and environment checks before the insert, update, or delete operation proceeds.

No parameter lists are documented in the ETRM metadata; descriptions above are strictly purpose-based.

Tables Accessed

• IGF_SL_DL_PNOTE_S_P_ALL — the base ("_ALL") master table holding promissory note records. All insert, update, lock, and delete operations target this table.
• IGF_SL_DL_PNOTE_S_P_ALL_S — the translated synonym view over the base table, used by the "_S" (language-aware) layer for reading and defaulting values.
• DUAL — referenced for single-row calculations, sequence retrieval in the standard Forms pattern, and environment resolution.

Usage Notes

IGF_SL_DL_PNOTE_S_P_PKG is invoked implicitly by the Oracle Forms module that maintains promissory note records within the Oracle Student Financial Aid (IGF) application. The Forms block's PRE-INSERT, PRE-UPDATE, PRE-DELETE, POST-QUERY, and ON-LOCK triggers route through the procedures above. Supporting dependencies — APP_EXCEPTION, FND_GLOBAL, FND_MESSAGE, IGF_SL_LOANS_PKG, IGS_GE_GEN_003, and IGS_GE_MSG_STACK — indicate that the package performs message substitution, multi-org or user context resolution via FND_GLOBAL, and loan-parent lookups via IGF_SL_LOANS_PKG. Because the package body is not referenced elsewhere and is not published as a formal public API, customizations should not call it directly; integrators requiring promissory note data should target the underlying synonym views or a documented XML/interface instead. The dependency on IGS_GE_MSG_STACK also signals that error conditions are surfaced through the standard EBS message stack, ensuring Forms-level error display.