Search Results milstn_notify_prcs

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:

• RETOPIC_EVENT / RETOPIC_NOT — Raise and notify the workflow event for research topic (registration of topic) submission and its associated notification to the relevant role.
• RETHESIS_EVENT / THESIS_NOT — Event and notification routines for thesis submission processing.
• SUPERVISION_EVENT / SUPERVISION_NOT — Event and notification routines governing supervisor assignment and supervision activity.
• OVERDUESUB_EVENT / OVERDUESUB_NOT — Event and notification routines for overdue thesis or milestone submissions.
• MILESTONE_EVENT / MILSTN_NOTIFY_PRCS / MILSTN_NOTIFY_NOT — Event raising for milestones, plus the milestone notification processing routine and its corresponding notification builder.
• THESIS_EXAM_EVENT — Event routine for thesis examination scheduling.
• THESIS_RESULT_EVENT — Event routine for publication of examination results.
• CONFIRM_REG_EVENT / CONFIRM_REG_NOT — Event and notification routines for confirmation of registration in the research programme.
• CREATE_ADHOC_ROLE — Creates an ad-hoc workflow role, typically used to dynamically route notifications to a supervisor, panel member, or administrative actor not otherwise represented by a standard role.

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:

• FND_NEW_MESSAGES, FND_USER — Workflow notification queue and recipient resolution.
• IGS_AS_ORD_ITM_INT — Assessment/order item interface used for examination or milestone assessment records.
• IGS_EN_OVRSUB_S — Overdue submission tracking for the enrolment/research programme.
• IGS_RE_RETOPC_S — Research topic submissions.
• IGS_RE_SPRVSN_S, IGS_RE_SPRVSR — Supervision records and supervisor master data.
• IGS_RE_THESIS_S, IGS_RE_EXMSUB_S — Thesis records and thesis examination submissions.
• IGS_RE_REGCFM_S — Registration confirmation records.
• IGS_RE_RESUPD_S — Thesis result updates.
• IGS_RE_MILSTN_S, IGS_RE_MILNOT_S, IGS_PR_MILESTONE_TYP — Milestone instances, milestone notifications, and milestone type definitions.
• IGS_RE_THS_PNL_MBR — Thesis panel members, used for notification routing.

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.