Search Results rulp_val_gpa




Overview
Explore in AI Chat

Overview

IGS_RU_GEN_004 is a PL/SQL package owned by the APPS schema within the Oracle E-Business Suite environment. The IGS_ prefix identifies it as belonging to the Student System (formerly Oracle Student System / iGS) product family. The RU component refers to the Rules Engine subsystem, which governs the configurable business rules that drive academic progression, enrollment validation, and transcript processing. In ETRM documentation the object is classified as an API of type OTHER, indicating that it exposes package-level routines intended for internal consumption by sibling packages rather than a formally published public API.

The package serves as a generation and validation utility for academic rules. It encapsulates the creation of rule records, the association of named rules, and a set of validation routines that verify administrative status, RGI descriptions, grade point average thresholds, and work assignment mappings before those values are committed to the underlying rule tables.

Key Procedures and Functions

The ETRM metadata documents seven procedures and functions:

  • RULP_INS_MAKE_RULE — Inserts a rule record into the rules repository. It is the primary insertion path for newly generated rules created by the calling process.
  • RULP_INS_UR_RULE — Inserts a unit-rule association, linking a rule to one or more academic units within the Unit Rules structure.
  • RULP_VAL_ADM_STATUS — Validates the administrative status value supplied for a rule, ensuring the status is recognised and permissible within the institutional configuration.
  • RULP_VAL_DESC_RGI — Validates description-related data associated with RGI (rule group indicator) entries, confirming that the descriptive attributes conform to expected values.
  • RULP_VAL_GPA — Validates grade point average parameters used by rules, including minimum and maximum thresholds that drive progression decisions.
  • RULP_VAL_NAMED_RULE — Validates a named rule reference, confirming that the rule name exists and is correctly formed before it is used in a rule definition.
  • RULP_VAL_WAM — Validates weighted average mark parameters, applying the same threshold checking discipline as the GPA validation routine.

The naming convention RULP_ (Rules Local Procedure) followed by an INS_ or VAL_ prefix distinguishes insert operations from validation operations, which is a consistent pattern across the IGS_RU_GEN_ series.

Tables Accessed

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

  • IGS_RU_RULE — the master rule repository, receiving rows from RULP_INS_MAKE_RULE.
  • IGS_PS_UNIT_RU — the association table between program/unit definitions and rules, populated by RULP_INS_UR_RULE.
  • IGS_RU_NAMED_RULE — stores named rule definitions referenced during validation.
  • IGS_RU_DESCRIPTION — holds descriptive text for rules, validated by RULP_VAL_DESC_RGI.
  • IGS_RU_RULE_SEQ_NUM_S — the sequence supplying surrogate rule identifiers during insertion.
  • DUAL — used for single-row validation queries.

Usage Notes

IGS_RU_GEN_004 is not invoked directly by end users. It is called by four other packages: IGS_AD_GEN_008, IGS_PR_GEN_001, IGS_PR_GEN_002, and IGS_RU_GEN_003. In release 12.1.1 and 12.2.2 these callers are typically triggered from Student System setup forms, concurrent programs that regenerate institutional rules, and admissions or progression processing that must validate rule parameters before committing academic decisions. Because the package is self-referenced, some routines call each other within the same unit of work, so callers should treat insertion routines as transactional and let the enclosing process manage commits. Custom extensions should call the validation routines before the insert routines to avoid propagating invalid rule data into the repository.