Search Results igs_ge_note_rf_num_s

Overview

IGS_AD_APPL_NOTES_PKG is the PL/SQL package body owned by the APPS schema that encapsulates the data-access and validation logic for application notes in the Oracle E-Business Suite student system (the IGS product family associated with Oracle Student System / recruitment and admissions). The AD component indicates the admissions area, and the package governs the IGS_AD_APPL_NOTES base table and its _S (secondary/translation) companion. The package exposes a full generated-style CRUD surface — insert, lock, update, delete, and a before-DML trigger entry point — plus helper lookups used to resolve primary, unique, and foreign key values ahead of DML. It is classified under the ETRM API classification OTHER, meaning it is an internal supporting package rather than a formally published public API.

The user search term igs_ge_note_rf_num_s reflects the cross-product dependency this package carries: the general Notes infrastructure in the IGS_GE_* schema objects (note types, note reference numbers, and the note entity itself) underpins the admissions-specific note records.

Key Procedures and Functions

The documented package interface comprises eleven procedures and functions, all standard to the Oracle Forms / server-side generated table handler pattern:

• INSERT_ROW — performs a direct insert into the application notes table.
• LOCK_ROW — acquires a row-level lock, typically via SELECT ... FOR UPDATE, to support optimistic concurrency in an interactive form.
• UPDATE_ROW — applies column changes to an existing note row.
• ADD_ROW — higher-level create routine that derives key values and delegates to the insert path; the counterpart used by form-level "add record" logic.
• DELETE_ROW — removes a note record.
• GET_PK_FOR_VALIDATION — returns the primary key value used to validate the record identity.
• GET_UK_FOR_VALIDATION — returns the unique key value used for unique-constraint validation.
• GET_FK_IGS_AD_PS_APPL_INST — resolves the foreign key to the application instance entity.
• GET_FK_IGS_AD_NOTE_TYPES — resolves the foreign key to the note type definition.
• CHECK_CONSTRAINTS — validates business and referential constraints before DML executes.
• BEFORE_DML — a shared pre-DML hook that populates WHO columns and enforces the above checks; invoked by the database trigger.

Tables Accessed

The package reads and writes the admissions notes table and its shadow row table:

• IGS_AD_APPL_NOTES — the primary store of notes attached to an applicant's record.
• IGS_AD_APPL_NOTES_S — the companion row/translation table keyed to the base note.
• IGS_GE_NOTE — the general notes entity holding the note text and metadata.
• IGS_GE_NOTE_RF_NUM_S — the note reference-number table, which is exactly the object named in the user's search; it supplies the reference number sequence used when a new note is created.

The package further depends on the _PKG counterparts of these tables, on IGS_AD_NOTE_TYPES_PKG for note-type semantics, on IGS_AD_PS_APPL_INST_PKG for application-instance context, and on framework utilities FND_GLOBAL, FND_MESSAGE, IGS_GE_MSG_STACK, IGS_AD_GEN_007, and IGS_SC_GEN_001. Exceptions are handled through APP_EXCEPTION.

Usage Notes

IGS_AD_APPL_NOTES_PKG is an internal package. It is invoked primarily by the admissions forms that maintain applicant notes, and by the database trigger that calls BEFORE_DML on the underlying table. ETRM records it as referenced by five other packages, so custom extensions and concurrent programs that write application notes should route through this package rather than performing raw DML, thereby preserving constraint checking, foreign-key resolution, and WHO-column population. Because it is not a published API, its signature may change between releases; upgraders on 12.1.1 and 12.2.2 should re-validate any custom code that calls it directly.