Search Results igs_ad_spl_interests_s

Overview

IGS_AD_SPL_INTERESTS_PKG is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite. It belongs to the Oracle Student System (IGS) product family and, more specifically, to the Admissions (IGS_AD) module. The package encapsulates the server-side data manipulation logic for the IGS_AD_SPL_INTERESTS entity, which stores the declared "special interests" recorded against an admissions application — for example, areas of academic, professional, or extracurricular interest supplied by an applicant. It functions as an internal table handler (API classification OTHER) rather than a public, versioned business API, and it is the programmatic layer that sits beneath the Admissions maintenance forms and validation routines that maintain this reference data.

Key Procedures and Functions

The ETRM metadata documents eleven callable units within the package body:

• INSERT_ROW — performs the physical insert of a new special-interests record into the underlying table.
• UPDATE_ROW — applies changes to an existing special-interests record.
• DELETE_ROW — removes an existing special-interests record.
• ADD_ROW — provides the higher-level "add" entry point used by the form layer, typically orchestrating key generation and the subsequent insert.
• LOCK_ROW — acquires a row-level lock for the target record, enforcing optimistic concurrency control before an update.
• GET_PK_FOR_VALIDATION — retrieves the primary key of a record for validation purposes.
• GET_UK_FOR_VALIDATION — retrieves or resolves the unique key used to validate uniqueness of the record.
• GET_FK_IGS_AD_APPL — returns the foreign key value linking the record to its parent admissions application.
• GET_FK_IGS_AD_CODE_CLASSES — returns the foreign key value linking the record to the code-classes (special-interest classification) reference data.
• CHECK_CONSTRAINTS — validates that all mandatory and referential constraints are satisfied prior to DML.
• BEFORE_DML — a pre-DML hook that stamps audit/WHO columns and performs any last-minute derivations before the row is written.

This grouping follows the standard Oracle Forms table-handler pattern (lock, insert, update, delete, and pre-DML processing) supplemented by validation helpers for the primary, unique, and foreign keys.

Tables Accessed

The package reads and writes two base objects, accessed through APPS synonyms:

• IGS_AD_SPL_INTERESTS — the primary transactional table holding the applicant's declared special interests, including the link to the admissions application (IGS_AD_APPL) and the interest code class (IGS_AD_CODE_CLASSES). This is the target of the INSERT_ROW, UPDATE_ROW, and DELETE_ROW operations.
• IGS_AD_SPL_INTERESTS_S — the sequence (or key-generation) object associated with the entity, consistent with the "S" naming convention used for primary-key generation in the IGS schema. The search term supplied by the user, "igs_ad_spl_interests_s", refers directly to this object.

Usage Notes

The package depends on several supporting components: APP_EXCEPTION and IGS_GE_MSG_STACK for error handling, FND_GLOBAL for environment context, FND_MESSAGE for message retrieval, IGS_AD_APPL_PKG and IGS_AD_CODE_CLASSES_PKG for parent-entity validation, IGS_AD_GEN_002 for entity-specific generation logic, and IGS_SC_GEN_001 for key generation. It is not referenced by any other database object, which confirms it is an internal handler rather than a published API.

Typical invocation occurs indirectly: the Admissions maintenance form that manages special-interest records calls these procedures on insert, update, and delete, with BEFORE_DML and CHECK_CONSTRAINTS executing automatically as part of the DML cycle. Because the package is not part of the supported public API surface, custom code should write to IGS_AD_SPL_INTERESTS through the approved admissions APIs (for example, IGS_AD_APPL_PKG) rather than calling this package directly, to preserve validation and audit integrity.