Search Results get_ufk_igs_ca_inst

Overview

The APPS.IGS_AD_PERD_AD_CAT_PKG package is a component of the Oracle E-Business Suite (EBS) Student Systems / Higher Education module, specifically belonging to the Academic Data (IGS_AD) family of objects. Its name reflects its purpose: it manages the association between academic periods (PERD) and admissions/admission categories (AD_CAT). In practice, this package provides the low-level data-access and maintenance layer for the IGS_AD_PERD_AD_CAT intersection table, which links an admissions period to one or more admissions categories. The object is documented as STATUS VALID in the APPS schema and is classified under the ETRM metadata as an "OTHER" API type rather than a public, supported API.

The package exists to encapsulate the insert, update, delete, locking, and validation logic for the period-to-admissions-category relationship. By centralising this logic, Oracle ensures that the intersection records remain consistent with the parent records and that foreign key and unique key constraints are respected before DML is committed. It forms part of the internal plumbing that supports higher-level admissions processing packages and concurrent programs rather than being intended for direct customer invocation.

Key Procedures and Functions

The ETRM documentation lists ten documented procedures and functions. INSERT_ROW creates a new period-to-category association row. LOCK_ROW obtains a row-level lock on an existing association to serialize concurrent updates. UPDATE_ROW modifies an existing association record. ADD_ROW provides the combined "create or update" entry point commonly found in Oracle ADS (Applications Data Store) generated packages. DELETE_ROW removes an association. GET_PK_FOR_VALIDATION returns the primary key of a row so that it can be validated before DML proceeds. BEFORE_DML is the pre-DML hook that populates WHO columns and derived fields prior to insert or update. CHECK_CONSTRAINTS verifies not-null, unique, and foreign key constraints against the candidate record. GET_FK_IGS_AD_CAT resolves the foreign key to the admissions category parent. GET_UFK_IGS_CA_INST resolves the user foreign key to the IGS_CA_INST (calendar instance) parent. Parameter lists are not reproduced here, as they are not enumerated in the supplied metadata.

Tables Accessed

The single documented table is IGS_AD_PERD_AD_CAT, accessed through its APPS synonym. This is the intersection entity that stores the valid combinations of admissions period and admissions category. The package reads it for validation and locking, and writes to it for insert, update, and delete operations. The foreign key helpers indicate logical dependencies on the admissions category parent (IGS_AD_CAT) and the calendar instance parent (IGS_CA_INST), even though those parent tables are not directly listed in the documented table access.

Usage Notes

This package is referenced by five other packages and forms, including IGS_AD_CAT_PKG, IGS_AD_INS_ADMPERD, IGS_AD_PECRS_OFOP_DT_PKG, IGS_AD_PRD_AD_PRC_CA_PKG, and IGS_CA_INST_PKG. These callers invoke the package most often from admissions maintenance forms or from other PL/SQL routines that populate period-to-category mappings. Because it is classified as an internal data-access package rather than a public API, it should not normally be called directly from custom code; customers requiring this functionality should use the supported higher-level admissions APIs. When invoked, it must run as the APPS schema with the standard EBS session context initialised so that the WHO audit columns and org context are correctly populated.