Search Results igs_ru_gen_003




Overview
Explore in AI Chat

Overview

IGS_RU_GEN_003 is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the Student Systems (IGS) product family. Its name prefix, "RU," identifies it as part of the Rules engine component of the Student System, which is responsible for defining, storing, and evaluating the configurable business rules that govern enrollment, fees, progression, and unit registration. IGS_RU_GEN_003 sits within the broader set of IGS_RU_GEN_xxx packages that implement generic rule-handling logic, and it is registered as VALID in the ETRM data dictionary for releases 12.1.1 and 12.2.2. The package exposes a procedural API for rule lookup, rule maintenance (insert, delete, copy), retention-type resolution, and student fee or scope calculation. It is a utility layer rather than an end-user-facing component; other IGS packages and views call it to obtain rule definitions and to evaluate those rules against student or unit data.

Key Procedures and Functions

The documented API comprises nine procedures and functions:

  • RULP_GET_RULE — Retrieves a rule definition, most likely by rule identifier or key attributes, so that callers can inspect or apply the rule.
  • RULP_GET_RGI — Returns the rule group or rule-item reference associated with a rule, supporting navigation of the rule hierarchy.
  • RULP_GET_RET_TYPE — Resolves a retention type code, used when rules determine whether a student, unit attempt, or enrollment is retained or carried forward.
  • RULP_INS_COPY_RULE — Inserts a new rule as a copy of an existing rule, enabling rule versioning or reuse across rule sets.
  • RULP_DEL_RULE — Deletes a rule definition from the rules repository.
  • RULP_DEL_UR_RULE — Deletes a unit-rule association, removing the linkage between a rule and a unit offering.
  • RULP_DEL_RLOV — Deletes a list-of-values entry used in rule definition, such as a permissible value for a rule parameter.
  • RULP_CLC_STUDENT_FEE — Calculates a student fee, presumably by evaluating the applicable fee rules for the student's program, unit, or enrollment.
  • RULP_CLC_STUDENT_SCOPE — Calculates a student scope value, which in Student Systems typically governs the range or applicability of a rule or process for a given student.

No parameter lists are asserted here; the documented metadata names the procedures and functions but does not publish their signatures.

Tables Accessed

The package reads and writes the core rule repository tables through APPS synonyms:

  • IGS_RU_RULE — the primary rule definition table, central to RULP_GET_RULE, RULP_INS_COPY_RULE, and RULP_DEL_RULE.
  • IGS_RU_SET and IGS_RU_SET_MEMBER — define rule sets and their members, supporting group-level rule evaluation.
  • IGS_RU_ITEM — stores individual rule items or conditions that make up a rule.
  • IGS_RU_LOV — holds list-of-values entries referenced in rule construction, managed by RULP_DEL_RLOV.
  • IGS_RU_RET_TYPE — the retention type reference table used by RULP_GET_RET_TYPE.
  • IGS_RU_DESCRIPTION — descriptive text for rules.
  • IGS_RU_CALL — records rule invocation or call context.
  • IGS_PS_UNIT_RU — associates rules with program/unit offerings, relevant to RULP_DEL_UR_RULE.

Usage Notes

IGS_RU_GEN_003 is invoked indirectly by a wide range of Student System components. The ETRM dependency list shows it is referenced by sixteen objects, including views such as IGS_EN_CPD_EXT_V, IGS_EN_UNIT_SET_RULE_V, IGS_PR_COHORT_V, and IGS_PS_STAGE_RU_V, as well as packages IGS_EN_ELGBL_PERSON, IGS_FI_PRC_FEE_ASS, IGS_PR_GEN_005, IGS_PR_GEN_006, IGS_PS_GEN_001, IGS_PS_GEN_008, and the sibling package IGS_RU_GEN_001. It self-references, indicating recursive or helper calls within its own logic. In practice, therefore, it is invoked from Forms, concurrent programs, and custom extensions whenever rule data must be fetched, maintained, or evaluated — particularly during eligibility checks, fee assessment, progression and stage processing, and unit-registration validation. It depends only on the SYS STANDARD package, making it a foundational, reusable rules utility rather than a business-rule owner itself.