Search Results wf_inform_stud




Overview
Explore in AI Chat

Overview

IGS_EN_WLST_GEN_PROC is a PL/SQL package in the Oracle E-Business Suite Student Systems (IGS) product family, specifically belonging to the Enrollment (IGS_EN) module. It is owned by the APPS schema and declared with AUTHID CURRENT_USER, meaning its SQL statements execute with the privileges of the invoking user rather than the package owner. The package was originally authored by Sanil Madathil (Oracle IDC) on 18-JUL-2001 and carries a change history reflecting the Waitlist Enhancements build (Bug# 3052426) and the Term records build (Bug# 2829263).

Its core business purpose is to support waitlist processing for unit offerings. It retrieves person and unit-of-offer detail, resequences and reassigns waitlist positions, recalculates priority preferences, determines whether a student should be notified, and drives workflow notifications (email) to both students and administrators. The package thus forms the notification and position-management backbone of the student waitlist lifecycle.

Key Procedures and Functions

  • GETMESSAGETEXT — A function returning the message text associated with a supplied message name, used to build notification content.
  • GETPERSONDETAIL — Retrieves person attributes (person number, full name, e-mail address) required for correspondence.
  • GETUOODETAIL — Retrieves unit-of-offer-option attributes such as unit code, unit title, calendar type, and alternate code, providing context for the notification.
  • WF_INFORM_STUD — Raises the workflow event used to send a notification e-mail to the student. Parameters were modified in the Term records build (Bug# 2829263).
  • WF_SEND_MAIL_STUD — Sends the actual mail to the student.
  • WF_SEND_MAIL_ADM — Sends the corresponding mail to the administrator.
  • INFORM_STUD_NOT — Determines and raises the notification to inform the student, the entry point most commonly associated with the "inform_stud_not" search term.
  • ENRP_RESEQUENCE_WLST — Resequences the waitlist, adjusting stored positions following changes in the queue.
  • ENRP_WLST_ASSIGN_POS — Assigns a waitlist position to an enrollment.
  • ENRP_WLST_DT_RESEQ — Resequences waitlist entries by date.
  • ENRP_WLST_PRI_PREF_CALC — Calculates priority and preference values used for ordering the waitlist.
  • CHECK_STUD_COUNT — Checks the count of students, typically to compare against available places.
  • CHECK_MANUAL_IND — Checks the manual indicator governing whether automatic processing applies.

Tables Accessed

The package reads and writes through APPS synonyms. Person and identity data come from HZ_PARTIES, IGS_PE_PERSON, and related person tables. Offer and waitlist configuration is drawn from IGS_PS_UOFR_WLST_PRF, IGS_PS_UOFR_WLST_PRI, IGS_PS_USEC_WLST_PRF, IGS_PS_USEC_WLST_PRI, IGS_EN_ORUN_WLST_PRF, and IGS_EN_ORUN_WLST_PRI. Attempt and enrollment records are handled via IGS_AS_SU_SETATMPT, IGS_EN_SU_ATTEMPT_ALL, and IGS_PS_USEC_TCH_RESP. Notification and workflow state reside in IGS_EN_INFORM_STUD_S, IGS_EN_WF_BE_EN001_S, and IGS_EN_WF_MAILSTUD_S. FND_USER and FND_RESPONSIBILITY are used to resolve the administrating user and responsibility for mail routing.

Usage Notes

IGS_EN_WLST_GEN_PROC is an internal processing package, invoked by Oracle Student System enrollment forms, concurrent programs, and workflow background processes rather than called directly by end users. At least five other packages reference it, indicating it is a shared utility within the enrollment waitlist flow. Its principal runtime role is to evaluate waitlist status and trigger student and administrator notifications. Customizations should avoid modifying the package signature, particularly WF_INFORM_STUD, whose parameters were already altered by an Oracle patch, and should copy the package for extension rather than editing the shipped version.