Search Results eval_max_cp

Overview

IGS_EN_ELGBL_PROGRAM is a PL/SQL package in the APPS schema that implements the enrollment eligibility engine for Oracle Student System (formerly Oracle Higher Education). Its central responsibility is to evaluate whether a student is permitted to enroll in, or remain enrolled in, a program of study, and to enforce the credit-point and rule-based constraints that govern that eligibility. The package evaluates program steps, minimum and maximum credit-point thresholds, forced unit types, and cross-validation rules against the student's academic record. It also provides the workflow hook used to compute credit points for enrollment processing. Because eligibility in Student System is defined through configurable program and category rules rather than hard-coded logic, this package acts as the interpretive layer that resolves those configurations at runtime against a specific person, program, and term.

Key Procedures and Functions

The package exposes approximately twelve documented procedures and functions, primarily organised around credit-point evaluation:

• CALC_MIN_CP / CALC_MAX_CP — compute the minimum and maximum credit points applicable to a student's program enrolment.
• GET_PER_MIN_MAX_CP, GET_APPLIED_MIN_CP, GET_APPLIED_MAX_CP — retrieve period-based and applied minimum/maximum credit point values used in downstream eligibility checks.
• EVAL_MIN_CP / EVAL_MAX_CP — evaluate whether the student's current enrolment satisfies the calculated minimum and maximum credit-point bounds.
• EVAL_FAIL_MIN_CP — evaluates the consequence of failing to meet the minimum credit-point requirement, typically driving warning or restriction outcomes.
• EVAL_PROGRAM_STEPS — assesses progression through the defined program steps that a student must satisfy.
• EVAL_UNIT_FORCED_TYPE — determines whether a unit is constrained to a forced unit type under the applicable program rules.
• EVAL_CROSS_VALIDATION — applies cross-validation rules across programs or enrolment combinations.
• STDNT_CRD_PNT_ENRL_WORKFLOW — the workflow-invoked entry point that initiates student credit-point enrolment processing.

Tables Accessed

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

• IGS_EN_PIG_CP_SETUP, IGS_EN_CAT_PRC_DTL, IGS_EN_CONFIG_ENR_CP — configuration sources for credit-point rules and category processing detail.
• IGS_EN_ELGB_OVR_STEP — eligibility override steps applied during evaluation.
• IGS_EN_SU_ATTEMPT_ALL — the student's unit attempt records, which supply the actual credit points and attempt outcomes used in comparisons.
• IGS_CA_INST_ALL, IGS_CA_INST_REL, IGS_CA_TYPE — calendar instance and instance-relationship data that establishes the effective term and period context.
• IGS_AS_UNIT_MODE, IGS_EN_METHOD_TYPE — delivery mode and attendance method reference data.
• IGS_PE_PERSENC_EFFCT, IGS_PE_PERSON_TYPES, IGS_PE_USR_AVAL_ALL — person-level effective data, person types, and user availability, used for personalisation and filtering.
• IGS_EN_WF_BE002_S, FND_NEW_MESSAGES — workflow message/notification infrastructure used when eligibility outcomes must be communicated.

Usage Notes

IGS_EN_ELGBL_PROGRAM is not ordinarily invoked directly by end users. It is referenced by nine other packages and views, including IGS_EN_ADD_UNITS_API, IGS_EN_DROP_UNITS_API, IGS_EN_ELGB_OVR_UOO_PKG, IGS_EN_ENROLL_WLST, IGS_EN_REINSTATE_PKG, IGS_EN_GEN_011, IGS_EN_SS_SCHEDULE_DISP_V, IGS_EN_SS_STUD_CONTEXT_V, and IGS_SS_EN_WRAPPERS. It is therefore called transitively whenever a student adds or drops units, is placed on or taken off a waitlist, is reinstated, or when self-service schedule and student-context pages render eligibility information. The workflow entry point is triggered by the enrollment credit-point workflow process. Customisations should call the public procedures rather than replicating eligibility logic, since the rules are configuration-driven and vary by institution and program. The package is VALID in both Oracle EBS 12.1.1 and 12.2.2, and its dependencies are confined to SYS.STANDARD plus internal Student System objects.