Search Results progtrans_event

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:

• FND_USER and HZ_PARTIES — resolve approver, instructor, and student identities for notification routing.
• IGS_EN_INST_ACTION_S — instructor action records that drive petition and approval notifications.
• IGS_EN_INTM_RCOND_S, IGS_EN_INTM_TYPES, IGS_EN_INTRMN_S — intermission records, types, and recommendation data used by the intermission event.
• IGS_EN_PRGDSC_S — program discontinuation records, the primary source for PROGDISCONT_EVENT.
• IGS_EN_PRGTRN_S and IGS_EN_PROFOP_S — program transfer and program option records.
• IGS_EN_STATUS_MAIL_REQ_S — queued status change mail requests.
• IGS_EN_STUDENT_PLACEMENT_S — student placement data.
• IGS_EN_STUD_SPLPERM_REQ_S and IGS_EN_WITHDRAW_PERM_S — withdrawal and special permission request records.
• IGS_AS_ORD_ITM_INT and IGS_CA_TYPE — supporting assessment and calendar type reference data.

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.