Search Results get_fk_igs_ad_appl

Overview

APPS.IGS_AD_SPL_INTERESTS_PKG is a PL/SQL package that encapsulates the data manipulation and validation logic for the IGS_AD_SPL_INTERESTS entity within the Oracle E-Business Suite Advanced Admissions (Student Systems) product family. The entity stores the special interests declared by a person against an admission application — for example, an applicant's stated areas of academic, sporting, or extracurricular interest captured at the time of application. The package provides the standard IGS table-handler API surface (insert, update, lock, delete, add) together with the validation routines required by Oracle Forms and by server-side integrity enforcement. It is classified in ETRM as an OTHER API, meaning it is an internal handler rather than a public, externally supported integration interface.

Key Procedures and Functions

The package exposes eleven documented units. The DML procedures mirror the underlying table structure: INSERT_ROW and ADD_ROW create a special-interest record for a person and admission application, accepting the primary key and descriptive columns and honouring an X_MODE flag that controls validation behaviour; UPDATE_ROW modifies an existing row; LOCK_ROW issues the standard optimistic-locking check for a row identified by its primary key; and DELETE_ROW removes a record. The validation functions GET_PK_FOR_VALIDATION and GET_UK_FOR_VALIDATION confirm that a given primary key or unique-key combination (special interest type, admission application number, and person) is valid, returning a Boolean result for use in Forms validation triggers.

The foreign-key procedures GET_FK_IGS_AD_APPL and GET_FK_IGS_AD_CODE_CLASSES verify that the referenced admission application / person and the referenced special-interest code class exist before a row is written. The user-searched identifier, GET_FK_IGS_AD_APPL, corresponds directly to the documented procedure Get_FK_Igs_Ad_Appl, which takes a person identifier and admission application number and enforces the parent relationship to the admissions application. CHECK_CONSTRAINTS applies the table's declarative check constraints, optionally narrowed to a single column. BEFORE_DML is the internal pre-processing hook that normalises default values and timestamps prior to each DML action.

Tables Accessed

The package operates on IGS_AD_SPL_INTERESTS, the base table holding special-interest records, and IGS_AD_SPL_INTERESTS_S, its translated (_S) shadow table used to store language-specific descriptive text. Both are addressed through APPS synonyms. Inserts and updates write to both tables where translated attributes exist; locks and deletes act on the base table via the ROWID supplied by the calling form.

Usage Notes

This package is normally invoked indirectly. Oracle Forms built on the IGS_AD_SPL_INTERESTS block call the DML, locking, and validation procedures through the standard table-handler pattern, with BEFORE_DML firing automatically ahead of each database operation. The foreign-key and validation routines are executed from Forms validation triggers to produce user-facing errors. The package is also referenced by five other packages in the admissions schema, which rely on its validation functions rather than duplicating the entity's business rules. Direct invocation from custom code is possible but unsupported; the module header (120.1, 2005) indicates it has been stable across the 12.1.1 and 12.2.2 releases, and any customisation should be confined to wrapper logic rather than modification of the seeded package.