Search Results igs_en_workflow




Overview
Explore in AI Chat

Overview

IGS_EN_WORKFLOW is an Oracle E-Business Suite PL/SQL package owned by APPS that provides workflow and notification integration for the Student Systems (IGS) enrollment and progression modules. It is classified as an OTHER API, meaning it is a supporting utility package rather than a public business API, and it is referenced by seven other packages within the EBS schema. The package header carries a change history tracing its evolution from its original creation in July 2001 through several enhancements, including the addition of the STUDENT_PLACEMENT_EVENT procedure for placement builds and RAISE_SPI_RCOND_EVENT for an identified bug fix. Its central purpose is to raise workflow events and generate correspondence notifications when significant changes occur to a student's enrollment status, program registration, or academic standing. Within the IGS architecture the package acts as the bridge between transactional enrollment data stored in the IGS_EN_* tables and the Oracle Workflow notification infrastructure, allowing institutions to automate communication with students, instructors, and approvers.

Key Procedures and Functions

The package exposes fifteen documented procedures and functions, each oriented to a distinct notification or workflow event:

  • SUA_STATUS_CHANGE_MAIL — dispatches notification mail when a student unit attempt status changes.
  • INFORM_STDNT_INSTRUCT_ACTION — notifies a student of an instructor action, such as an approval or rejection decision.
  • INFORM_INSTRUCT_STDNT_PETITION — informs an instructor of a student petition submitted for their review.
  • INTERMISSION_EVENT — raises a workflow event for an approved or requested intermission (leave of absence), including intermission type and duration.
  • PROGDISCONT_EVENT — raises the program discontinuation event, the object matching the user's search term progdiscont_not. It signals that a student has discontinued a program, capturing the discontinuation date and reason code.
  • PROGTRANS_EVENT — handles program transfer, recording the source and destination program, transfer date, attendance attributes, and program status.
  • PROGOFROPT_EVENT — processes program option changes for a student.
  • ENR_NOTIFICATION — generates general enrollment notifications.
  • INTERMISSION_NOT — produces the correspondence notification counterpart to the intermission event.
  • PROGTRANS_NOT — issues notification when a program transfer is processed.
  • PROGOFROPT_NOT — issues notification for program option changes.
  • PROGDISCONT_NOT — issues the notification associated with program discontinuation.
  • STUDENT_PLACEMENT_EVENT — raises a workflow event during the placement build process.
  • RAISE_WITHDRAW_PERM_EVT — raises the event supporting withdrawal permission requests.
  • RAISE_SPI_RCOND_EVENT — raises the event associated with special progression or recondition rules.

Tables Accessed

The package reads and writes through APPS synonyms to the following documented tables:

Usage Notes

IGS_EN_WORKFLOW is not intended for direct end-user invocation. It is called from the IGS enrollment forms, from concurrent programs that process student progression and discontinuation, and from other IGS packages, as confirmed by its seven inbound references. The _EVENT procedures raise Oracle Workflow business events, while the _NOT procedures generate the associated correspondence output. Institutions implementing program discontinuation or transfer notifications typically subscribe to the raised events in Oracle Workflow Builder, so the package serves as the emission point rather than the delivery mechanism. Because the package is classified OTHER and carries an older header revision, customizations should reference it cautiously and verify procedure signatures against the deployed release before extension.