Search Results igs_ad_note_types_s

Overview

The APPS.IGS_AD_NOTE_TYPES_PKG package body is a generated Oracle EBS PL/SQL package that serves as the primary database access layer for the Admissions Note Types entity within the Oracle Student System (IGS) product family. The IGS_AD prefix identifies the owning module as Admissions, while NOTE_TYPES denotes the entity that categorizes the types of notes attached to admission applications, applicants, and related admissions records. The package encapsulates all Create, Read, Update, and Delete (CRUD) operations against the base table IGS_AD_NOTE_TYPES and its language/translation table IGS_AD_NOTE_TYPES_S.

The package body is classified under ETRM as API classification: OTHER, indicating that it is primarily an internal generated handler rather than a published, extensible business API. It is owned by the APPS schema, holds a status of VALID, and exposes ten documented procedures that together implement row-level DML, concurrency locking, uniqueness verification, constraint enforcement, and pre-DML auditing hooks. The package is referenced by three other database objects, and it in turn depends on standard EBS infrastructure packages such as FND_GLOBAL, FND_MESSAGE, APP_EXCEPTION, IGS_GE_MSG_STACK, and IGS_LOOKUPS_VIEW_PKG.

Key Procedures and Functions

• INSERT_ROW — Inserts a new row into the note types entity, populating the primary key and audit columns.
• LOCK_ROW — Acquires a row-level lock on an existing note type record to enforce optimistic concurrency control.
• UPDATE_ROW — Applies modifications to an existing note type row.
• ADD_ROW — Wrapper procedure that combines validation and insertion, used by the generated form or downstream callers to add a complete note type record.
• DELETE_ROW — Removes a note type record from the base table.
• GET_PK_FOR_VALIDATION — Returns the primary key value for the current record so that uniqueness and referential validation can be performed.
• GET_UK_FOR_VALIDATION — Retrieves the first unique key value used for duplicate checking.
• GET_UK2_FOR_VALIDATION — Retrieves the second unique key value, supporting multi-column uniqueness enforcement.
• CHECK_CONSTRAINTS — Validates business and database constraints prior to DML, raising errors via FND_MESSAGE and IGS_GE_MSG_STACK.
• BEFORE_DML — Pre-DML trigger-style hook that standardizes who-columns and other bookkeeping fields using FND_GLOBAL.

Tables Accessed

The package reads from and writes to two documented tables, both accessed via APPS synonyms:

• IGS_AD_NOTE_TYPES — The base transactional table holding note type definitions, their attributes, and audit columns.
• IGS_AD_NOTE_TYPES_S — The language/translation table that stores the user-facing description of each note type in the installed languages. The _S suffix is the standard EBS convention for seed or translation tables.

Additionally, the package body references IGS_AD_APPL_NOTES_PKG, suggesting that note type records share validation logic or lookups with the application notes package, and IGS_LOOKUPS_VIEW_PKG for validation against Oracle Applications lookup values.

Usage Notes

The package is normally invoked indirectly. In a standard EBS 12.1.1 or 12.2.2 deployment, the Admissions Note Types maintenance form (typically an Oracle Forms-based screen) calls these procedures through its generated block handlers, so users interact with the package whenever they create, modify, or delete a note type through the application UI. The package may also be invoked from concurrent programs that seed or migrate note type reference data, and from custom extensions or interfaces that need to insert note type rows programmatically.

Because the package relies on FND_GLOBAL for session context and FND_MESSAGE for error presentation, all callers must run within an EBS application session with the correct APPS privileges. When extending or integrating the Admissions module, custom code should generally call the documented wrapper procedures (particularly ADD_ROW, UPDATE_ROW, and DELETE_ROW) rather than issuing direct SQL against IGS_AD_NOTE_TYPES, so that validation, locking, and audit conventions remain consistent with the rest of the Oracle Student System.