Search Results igs_ad_ter_edu_pkg




Overview
Explore in AI Chat

Overview

IGS_AD_TER_EDU_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that encapsulates the transactional data manipulation logic for the IGS_AD_TER_EDU entity within the Oracle Student System (OSS) / Higher Education product family. The entity represents academic term education records — that is, the educational qualifications, levels, or achievements associated with a student's enrolment in a specific academic term. The package serves as a Table API (TAPI-style) layer over the IGS_AD_TER_EDU table, providing standardized insert, update, delete, and validation routines that other Oracle Student System components call rather than performing direct DML against the base table. Under the documented ETRM classification the package is registered as an "OTHER" API, meaning it exposes a programmatic interface but is not registered as a public, versioned business API. Its status is VALID in both Oracle EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The documented interface exposes fifteen procedures and functions, organized into four functional groups:

Tables Accessed

The package operates against a single documented base table, IGS_AD_TER_EDU, accessed through an APPS synonym. This table stores the term education records it inserts, updates, locks, and deletes. The foreign key lookup routines reference the parent entities that the table depends on — country code (IGS_PE_COUNTRY_CD), honours level (IGS_GR_HONOURS_LEVEL), institution (IGS_OR_INSTITUTION), language code (IGS_PE_LANGUAGE_CD), person (IGS_PE_PERSON), and the term education level components (IGS_AD_TER_EDU_LV_COM and IGS_AD_TER_EDU_LVL_QF) — but resolution of those keys is performed by the corresponding foreign key packages, not by this package directly.

Usage Notes

IGS_AD_TER_EDU_PKG is referenced by seven other packages, including IGS_AD_PRC_TAC_OFFER, IGS_AD_TER_ED_LVL_QF_PKG, IGS_AD_TER_ED_LV_COM_PKG, IGS_AD_TER_ED_UNI_AT_PKG, IGS_GR_HONOURS_LEVEL_PKG, IGS_PE_COUNTRY_CD_PKG, and IGS_PE_LANGUAGE_CD_PKG. This dependency web indicates the package is invoked by higher-level admissions and student-record APIs that create or maintain term education data, either through Oracle Forms, concurrent programs, or custom PL/SQL that requires a controlled, validated path to IGS_AD_TER_EDU. Because access is exclusively through the package rather than direct table DML, customizations should call the documented insert, update, and delete entry points and honor the before-DML and constraint-check sequence to preserve data integrity and concurrency control.