Search Results get_uk2_for_validation

Overview

IGS_AD_NOTE_TYPES_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Oracle Student System (formerly Oracle iLearning / Student Administration) and manages the setup data for admission note types. Specifically, it provides the application programming interface for maintaining records in which a note category is paired with a specific note type, together with an optional description and an active/closed status indicator.

The package follows the standard Oracle Forms-generated table handler pattern: it combines DML routines (insert, update, delete, add, lock) with validation functions and a pre-DML processing hook. The API classification recorded in the ETRM metadata is OTHER, meaning it is not a public, supported business API exposed for general consumption but rather an internal handler invoked by the owning forms and by other EBS code that manipulates the IGS_AD_NOTE_TYPES entity. It is referenced by three other packages, confirming that it is embedded in a wider dependency chain within the Student System schema family.

Key Procedures and Functions

The package exposes ten documented program units:

• INSERT_ROW — Inserts a new note type record, returning the generated row identifier and note type identifier to the caller.
• ADD_ROW — Companion insert routine that follows the same pattern as INSERT_ROW; used by the Forms infrastructure when adding a row through the standard block handler.
• UPDATE_ROW — Updates the note category, note type, description, and closed indicator for an existing record identified by its row identifier.
• LOCK_ROW — Obtains a lock on the target row using the row identifier and current column values, providing optimistic concurrency control for multi-user editing.
• DELETE_ROW — Deletes the note type record identified by the supplied row identifier.
• GET_PK_FOR_VALIDATION — Validates that a supplied note type identifier exists, optionally filtered by the closed indicator.
• GET_UK_FOR_Validation — Validates the natural unique key formed by note category and note type, optionally restricted to open records.
• GET_UK2_FOR_VALIDATION — The function the user searched for. It validates a second unique-key combination consisting of the note type identifier and the note category, again with the closed indicator available as an optional filter. This allows the forms layer to confirm that a proposed identifier/category pairing is acceptable before committing a row.
• CHECK_CONSTRAINTS — Applies column-level constraint checking, accepting an optional column name and value.
• BEFORE_DML — A pre-DML hook that performs common validation and derived-value logic before any insert, update, or delete operation is executed.

Tables Accessed

The package operates against two APPS synonyms:

• IGS_AD_NOTE_TYPES — the base transactional table holding note type definitions. All DML and validation logic is directed here.
• IGS_AD_NOTE_TYPES_S — the corresponding sequence or secondary support table used to generate and track the note type identifier and row identifier values.

Usage Notes

IGS_AD_NOTE_TYPES_PKG is invoked primarily from the Oracle Forms-based maintenance screen for admission note types, where the block-level handlers call INSERT_ROW, UPDATE_ROW, DELETE_ROW, and the validation functions during record navigation and commit. Because the unique-key validation routines accept an optional closed indicator, callers must pass the correct status context so that the duplicate check is scoped properly. Custom code and the three dependent packages may also call the validation functions directly when performing set-based loads, but the package is not a documented public API and its signature should be treated as version-sensitive across the 12.1.1 and 12.2.2 code lines.