Search Results igs_re_workflow




Overview
Explore in AI Chat

Overview

IGS_RE_WORKFLOW is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the Oracle Student System (formerly Oracle iLearning/Student Records, module prefix IGS) for research and thesis management. It is the central workflow orchestration package for the Research and Thesis (RE) product family, coordinating the notification, approval, and status-transition logic that drives the research lifecycle: research topic submission and approval, supervisor assignment, supervision progress, thesis submission, thesis examination, and final result publication.

The package is a notification-centric workflow hub. Rather than containing primary business validation logic, it typically bridges RE business entities to the Oracle Workflow engine by raising workflow events and by composing/sending notifications via the FND_NEW_MESSAGES notification queue. Its status in the data dictionary is VALID, and it exhibits low dependency depth — depending only on SYS.STANDARD at the package level — while acting as a shared utility consumed by seven higher-level packages.

Key Procedures and Functions

The documented interface exposes 16 procedures/functions, organized into paired event-raising and notification routines across the research sub-processes:

Together these routines implement the "event then notify" pattern: a *_EVENT procedure signals the workflow engine of a state change, and a *_NOT procedure (or the MILSTN_NOTIFY_PRCS processing routine) constructs and dispatches the notification.

Tables Accessed

The package reads and writes the following tables via APPS synonyms, which define its true scope:

These tables confirm the package operates across the full research pipeline, from topic registration through examination to results.

Usage Notes

IGS_RE_WORKFLOW is invoked indirectly rather than directly by end users. Its callers are the RE functional packages — IGS_RE_CANDIDATURE_PKG, IGS_RE_SPRVSR_PKG, IGS_RE_THESIS_PKG, IGS_RE_THESIS_EXAM_PKG, IGS_RE_MILESTONE_PKG, IGS_EN_WORKFLOW, and IGS_EN_STDNT_PS_ATT_PKG — which call its event and notification routines when business transactions are committed from Oracle Forms or concurrent programs. Typically, submission of a topic, thesis, or result in an RE form triggers the owning package, which calls the appropriate *_EVENT and *_NOT routine here. Because of this dependency, changes to this package can affect the entire research workflow chain; it should be treated as a shared infrastructure package when applying patches in 12.1.1 or 12.2.2.