Search Results get_fk_igs_ge_note

Overview

APPS.IGS_FI_P_SA_NOTES_PKG is a public PL/SQL API package within the Oracle E-Business Suite Financials family, specific to the Student Systems (IGS) product line. Its name indicates its role: it manages "SA Notes" (student account notes) records that associate a party with an effective date and a reference number. The package follows the Oracle EBS "table handler" pattern, exposing a controlled set of procedures and functions that implement insert, update, delete, lock, and validation logic against the underlying base and translated tables. It is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling schema rather than the package owner. The Header comment ($Header: IGSSI93S.pls 115.4 2002/11/29) reflects an early IGS release, and the code has since been maintained alongside the 12.1.1 and 12.2.2 application versions.

Key Procedures and Functions

The package exposes nine documented program units. Each is a named entry point that isolates callers from direct DML against the tables described below.

• INSERT_ROW — Creates a new student account notes record, accepting rowid, primary key, party, effective date, reference number, and mode. The primary key and rowid are returned to the caller.
• LOCK_ROW — Acquires a row-level lock on an existing record, supporting the read-modify-write pattern used by EBS forms.
• UPDATE_ROW — Modifies an existing record identified by rowid, updating the party, effective date, and reference number.
• ADD_ROW — Combines insert-or-update semantics, inserting when the record is new and updating when it already exists.
• DELETE_ROW — Removes the record identified by the supplied rowid.
• GET_PK_FOR_VALIDATION — Returns a Boolean indicating whether a given party_sa_notes_id resolves to a valid primary key.
• GET_UK_FOR_validation — Returns a Boolean indicating whether the combination of party, effective date, and reference number forms a valid unique key.
• GET_FK_IGS_GE_NOTE — This is the referential-integrity validation routine the user searched for. It accepts a reference number and validates that the value exists as a foreign key in the IGS_GE_NOTE entity before a note record is committed. Note that the companion routine get_fk_igs_fi_subaccts_all was removed in Enhancement 2564643 as part of the subaccount removal build.
• BEFORE_DML — A shared pre-DML hook invoked internally to stamp WHO columns (creation date, created by, last update date/by, last update login) across the DML entry points, enforcing the standard EBS audit trail.

Tables Accessed

The package operates against four documented objects, reached through APPS synonyms:

• IGS_FI_P_SA_NOTES — The base table holding student account note records; the primary target of insert, update, and delete operations.
• IGS_FI_P_SA_NOTES_S — The translated (TL) companion table holding language-specific text for the notes.
• HZ_PARTIES — The TCA party master, read by validation routines to confirm that the owning party identifier is legitimate.
• DUAL — Used for single-row PL/SQL select expressions, typically within the validation and WHO-stamping logic.

Usage Notes

IGS_FI_P_SA_NOTES_PKG is a low-level handler API, not a business-level public interface. It is most commonly invoked by Oracle Forms developed for the IGS Student Financials module, where the "SA Notes" block triggers insert, update, lock, and delete calls during user interaction. The validation functions (GET_PK_FOR_VALIDATION, GET_UK_FOR_validation) and the foreign-key routine GET_FK_IGS_GE_NOTE are called by the forms' validation and post-query triggers, and by any concurrent program or custom PL/SQL that inserts note records and must enforce the same integrity rules. The package is referenced by at least one other package in the ETRM registry, and custom extensions should call these documented routines rather than performing direct DML, ensuring consistent audit population and referential checks. Because the code base dates to the 11i era, adopters on 12.2.2 should confirm that the APPS synonym dependencies and the IGS_GE_NOTE foreign key remain valid for their patched release level.