Search Results class_std

Overview

IGS_EN_WLST_GEN_PROC is an Oracle EBS Student System (formerly Oracle Student System / IGS) PL/SQL package body owned by APPS and classified as a general-purpose (OTHER) process utility rather than a formal public API. Its purpose, as stated in the header comments, is to generate and manage waitlist processing for enrollment units, retrieve message text for student and administrator notifications, and raise business events that trigger workflow-based email delivery. The package encapsulates the procedural logic behind waitlist priority computation, position resequencing, manual assignment, and student communication.

The package coordinates three functional areas: (1) waitlist priority preference calculation based on enrollment unit offering rules, (2) automatic and manual waitlist position assignment and resequencing, and (3) notification to students and administrators via workflow events and mail. It is a supporting process package that is typically invoked by concurrent programs, enrollment processes, or other packages within the Student Systems product family.

Key Procedures and Functions

• GETMESSAGETEXT — Returns the message text for a given message name by invoking FND_MESSAGE.SET_NAME and FND_MESSAGE.GET against the IGS application message dictionary.
• GETPERSONDETAIL — Retrieves person-level details, typically resolving the student/person identity required for notification and waitlist processing.
• GETUOODETAIL — Retrieves unit offering option details relevant to the waitlist preference and priority logic.
• WF_INFORM_STUD — Raises the workflow business event that informs the student of waitlist status; parameters were modified under Bug# 2829263 for term record build.
• WF_SEND_MAIL_STUD — Sends the email notification to the student via the student mail staging mechanism.
• WF_SEND_MAIL_ADM — Sends the corresponding email notification to the administrator.
• ENRP_RESEQUENCE_WLST — Resequences waitlist entries to maintain contiguous priority ordering.
• CHECK_STUD_COUNT — Validates enrollment/student counts against waitlist capacity rules.
• CHECK_MANUAL_IND — Evaluates the manual-indicator flag controlling whether a waitlist position may be assigned manually.
• ENRP_WLST_ASSIGN_POS — Assigns a waitlist position to a student.
• ENRP_WLST_DT_RESEQ — Resequences waitlist entries by date, applying date-based ordering rules.
• ENRP_WLST_PRI_PREF_CALC — Calculates waitlist priority and preference values from unit offering waitlist preference and priority configuration.
• INFORM_STUD_NOT — Performs the student notification action itself, distinct from the workflow event and mail procedures.

Tables Accessed

The package reads and writes waitlist configuration and transactional data. It reads priority and preference configuration from IGS_PS_UOFR_WLST_PRI, IGS_PS_UOFR_WLST_PRF, IGS_PS_USEC_WLST_PRI, IGS_PS_USEC_WLST_PRF, and IGS_PS_USEC_TCH_RESP. Waitlist runtime records are held in IGS_EN_ORUN_WLST_PRI and IGS_EN_ORUN_WLST_PRF, while student notification and staging data reside in IGS_EN_INFORM_STUD_S, IGS_EN_WF_MAILSTUD_S, and IGS_EN_WF_BE_EN001_S. Enrollment attempt data is accessed through IGS_EN_SU_ATTEMPT_ALL and IGS_AS_SU_SETATMPT, and unit attempt updates pass CORE_INDICATOR_CODE to IGS_EN_SUA_API.UPDATE_UNIT_ATTEMPT (Enh Bug# 3052432, prevent dropping core units). Person and user resolution uses HZ_PARTIES, FND_USER, and FND_RESPONSIBILITY.

Usage Notes

IGS_EN_WLST_GEN_PROC is referenced by five other packages, indicating it is a shared internal process component rather than a directly called public API. It is invoked in the context of enrollment waitlist processing — concurrent programs, enrollment forms, and workflow-driven notification flows. The presence of WF_INFORM_STUD, WF_SEND_MAIL_STUD, and WF_SEND_MAIL_ADM confirms integration with Oracle Workflow business events and the IGS notification staging tables. The search term "class_std" reflects the student classification context used in waitlist priority and preference calculation.