Search Results igs_ru_val_unit_rule




Overview
Explore in AI Chat

Overview

IGS_RU_VAL_UNIT_RULE is a valid PL/SQL package body owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It forms part of the Student System (also marketed as Oracle Student System, the predecessor of the higher-education components in EBS), specifically within the Rules and Validation subsystem. The package encapsulates the validation logic that determines whether a student is permitted to enrol in, or remain enrolled in, a given program unit offering. Its procedures evaluate institutional rules against the student's current attempt records, program status, and eligibility overrides, and return a pass/fail outcome that the calling enrolment engine uses to accept, warn, or reject the enrolment action.

The API classification recorded in ETRM is OTHER, indicating that the package is an internal validation engine rather than a published customer-facing API. It is not referenced by any other database object, so its entry points are consumed directly by forms, concurrent processes, and other Student System routines that require an authoritative ruling on unit-level eligibility.

Key Procedures and Functions

  • RULP_VAL_ENROL_UNIT — The principal validation entry point. It assesses whether a student may enrol in a specified unit offering, considering the rule definitions attached to that offering.
  • RULP_VAL_PREREQ — Evaluates prerequisite rules, verifying that the student has satisfied the required prior units or equivalent achievements before the target unit is permitted.
  • RULP_VAL_COREQ — Evaluates corequisite rules, checking that units which must be taken concurrently are present in the student's current study pattern.
  • RULP_VAL_INCOMP — Evaluates incompatible (incompatible/prohibited) unit rules, preventing enrolment in units that conflict with units already attempted or currently held.

Each procedure applies the rule definitions maintained against the unit version and returns a status that the caller interprets, without raising hard errors for ordinary rule failures.

Tables Accessed

The package reads and, where check results must be persisted, writes to several Student System tables through APPS synonyms:

  • IGS_PS_UNIT_VER_RU — Unit version rule definitions that drive the validation checks.
  • IGS_PS_USEC_RU — Unit section rule records linking rules to specific offerings.
  • IGS_EN_STDNT_PS_ATT_ALL — The full set of student program attempt records used to establish the student's enrolment history and current standing.
  • IGS_EN_ELGB_OVR_UOO — Eligibility overrides permitting a student to bypass a rule failure for a specific unit offering option.
  • IGS_CA_STAT — Calendar/call status data used to constrain validation to the applicable teaching period.

Additional dependencies include IGS_CA_INST, IGS_CA_TEACH_TO_LOAD_V, IGS_EN_SU_ATTEMPT, IGS_EN_STDNT_PS_ATT, IGS_EN_GEN_015, IGS_RU_GEN_001, and STANDARD; these supply calendar instance data, teaching-load information, attempt detail, and general-purpose utility routines.

Usage Notes

IGS_RU_VAL_UNIT_RULE is invoked from the Student System enrolment forms and from batch enrolment or validation concurrent programs whenever a unit enrolment is created or amended. It is referenced by three other packages, which call its procedures to obtain a consolidated rule ruling rather than querying the rule tables individually. Custom code should call the documented procedures as a black box and must not depend on internal private routines, since the package body may change between patches. Because the package only reports rule outcomes and relies on eligibility overrides for exceptions, extend behaviour through IGS_EN_ELGB_OVR_UOO rather than modifying package logic.