Search Results igs_re_thesis_exam_pkg




Overview
Explore in AI Chat

Overview

IGS_RE_THESIS_EXAM_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the Student System (IGS) product family for Research and Thesis tracking. In the context of Oracle EBS 12.1.1 and 12.2.2, this package provides the core data access and manipulation layer for the IGS_RE_THESIS_EXAM entity, which records thesis examination instances associated with a student's research degree progression. The package encapsulates insert, update, delete, and locking operations against the underlying thesis examination table, and it is a foundational dependency for a wide range of Higher Education thesis, research, and admissions processes. Its API classification is recorded as OTHER, indicating it is an internal transactional handler rather than a formally published public API. The package is documented as VALID in ETRM, and it is referenced by ten other packages and object definitions across the IGS schema, confirming its role as a shared low-level service for thesis examination data.

Key Procedures and Functions

The package exposes thirteen documented procedures and functions grouped into three functional categories.

Together, these routines form the standard table-handler pattern used across the IGS application schema.

Tables Accessed

The documented table accessed by this package is IGS_RE_THESIS_EXAM, referenced through an APPS synonym. This table stores the individual thesis examination records, including the examination type, the parent thesis, the outcome/result, the examining panel type, and any associated transferable item. All DML procedures write to or modify this table, while the GET_FK functions read the parent key columns to resolve relationships. The package depends only on SYS.STANDARD at the database level, confirming it relies on the IGS_RE_THESIS_EXAM table and its declared foreign key relationships rather than on additional documented tables.

Usage Notes

IGS_RE_THESIS_EXAM_PKG is not typically invoked directly by end users. It is called by higher-level thesis and research packages, including IGS_RE_THESIS_PKG, IGS_RE_THESIS_RESULT_PKG, IGS_RE_THS_EXAM_TYPE_PKG, IGS_RE_THS_PNL_MBR_PKG, IGS_RE_THS_PNL_TYPE_PKG, IGS_RE_THE_LGCY_PUB, IGS_TR_ITEM_PKG, IGS_EN_INS_CA_TRNSFR, IGS_AD_INT_RECONSIDER, and IGS_AD_VAL_ACAI_FTR_OFFER. These callers exercise the package during thesis examination maintenance screens, admissions reconsideration, transfer credit processing, and legacy data migration or validation. Maintenance of this package should be coordinated with all ten dependent objects, since changes to the DML or foreign key retrieval logic can cascade across thesis examination, thesis result, and admissions workflows in both EBS 12.1.1 and 12.2.2 environments.