Search Results eval_unit_reenroll

Overview

IGS_EN_ELGBL_UNIT is a VALID PL/SQL package owned by the APPS schema in the Oracle E-Business Suite student system, part of the Oracle Student System (formerly Oracle iLearning / Student Records) module. Its overarching business function is to centralize the eligibility evaluation logic that determines whether a student may enroll in, add, drop, reinstate, or maintain enrollment in a specific unit offering option (UOO) within a program. In the EBS higher-education data model, "eligibility" is a multi-dimensional concept: a student's request to take a unit may be blocked or allowed by program rules, prerequisites, co-requisites, incompatible units, seat reservations, permission grants, visa or international-status constraints, repeat limitations, time conflicts, and audit restrictions. Rather than distributing that logic across every calling API, Oracle consolidates it inside IGS_EN_ELGBL_UNIT, which acts as a shared eligibility engine.

The package is classified under ETRM API classification "OTHER" and exposes approximately nineteen documented procedures and functions, all named with an EVAL_ prefix, indicating an evaluation-oriented design where each routine returns a determination about a specific eligibility dimension.

Key Procedures and Functions

The documented entry points cover distinct rule domains:

• EVAL_UNIT_STEPS — evaluates enrollment step sequencing configured for the unit.
• EVAL_UNIT_SS_ALLOWED — determines whether self-service enrollment is permitted for the unit.
• EVAL_PROGRAM_CHECK — validates the student against program-level eligibility criteria.
• EVAL_UNIT_FORCED_LOCATION / EVAL_UNIT_FORCED_MODE — assess whether the unit mandates a specific teaching location or study mode.
• EVAL_UNIT_REPEAT — checks repeat-attempt rules.
• EVAL_TIME_CONFLICT — detects clashes with existing enrollments.
• EVAL_PREREQ / EVAL_COREQ / EVAL_INCOMPATIBLE — evaluate prerequisite, co-requisite, and incompatible-unit conditions.
• EVAL_SPL_PERMISSION — verifies special permission grants.
• EVAL_RSV_SEAT — evaluates reserved-seat availability.
• EVAL_CART_MAX — enforces maximum enrollment cart limits.
• EVAL_INTMSN_UNIT_LVL / EVAL_VISA_UNIT_LVL — apply international-student and visa-status restrictions at unit level.
• EVAL_AUDIT_PERMISSION and EVAL_STUDENT_AUDIT_LIMIT — govern auditing rights and audit load limits.
• EVAL_UNIT_REENROLL — assesses re-enrollment eligibility.
• EVAL_AWARD_PROG_ONLY — restricts enrollment to award-program units.

Each routine encapsulates one rule family; callers combine results to reach a final enrollment decision. No parameter signatures are documented in the ETRM extract, so they should be confirmed against the package specification before use.

Tables Accessed

The package reads setup and transactional tables through APPS synonyms, including IGS_AS_SU_SETATMPT (student attempt records), IGS_EN_ELGB_OVR_STEP (eligibility override steps), IGS_EN_INST_WL_STPS (institution waitlist steps), IGS_EN_INTM_TYPES (intermission types), IGS_EN_REP_PROCESS (repeat processing), IGS_EN_SPL_PERM (special permissions), IGS_EN_STDNT_PS_INTM (student program intermissions), IGS_EN_SU_ATTEMPT_ALL (all unit attempts), IGS_PE_PERSON_TYPES, IGS_PE_VISA, and the reservation tables IGS_PS_RSV_EXT, IGS_PS_RSV_ORGUN_PRF, IGS_PS_RSV_UOP_PRF, and IGS_PS_RSV_UOP_PRI. FND_NEW_MESSAGES supplies Oracle Forms-style error and warning messages. The package is predominantly a read-and-validate component, consulting these tables to support its evaluations.

Usage Notes

IGS_EN_ELGBL_UNIT is invoked indirectly rather than by end users. Documented referencing objects include IGS_EN_ADD_UNITS_API, IGS_EN_DROP_UNITS_API, IGS_EN_ELGBL_PROGRAM, IGS_EN_ELGB_OVR_UOO_PKG, IGS_EN_ENROLL_WLST, IGS_EN_PLAN_UTILS, IGS_EN_REINSTATE_PKG, IGS_EN_SUA_LGCY_PUB, IGS_EN_VAL_SUA, IGS_SS_EN_WRAPPERS, and the generated packages IGS_AV_GEN_001, IGS_EN_GEN_011, and IGS_EN_GEN_015. This means eligibility checking occurs transparently during self-service enrollment, administrative add/drop, waitlist processing, reinstatement, and legacy SUA flows. Customizations should call the add/drop APIs rather than the evaluation routines directly, and any changes to eligibility rules should be made through the institution's setup, not by modifying this package, which is a protected Oracle-owned object.