Search Results rulp_val_rud_desc




Overview
Explore in AI Chat

Overview

The APPS.IGS_RU_VAL_RUD package is a validation utility within the Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 environment, belonging to the iGS (Higher Education) product family. The package name decomposes into a recognizable naming convention: IGS identifies the iGS/Student System module, RU refers to the Rules Engine component, VAL denotes validation logic, and RUD abbreviates "RU Description." The package exists to validate a new IGS_RU_RULE (rule) description against its previously stored counterpart, ensuring that rule description changes conform to the structural and business constraints enforced by the Rules Engine.

The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than the defining schema. The header dates to the 11i era (header revision 115.5, dated 2002/11/29), but the package remains documented and shipped under the APPS schema through the 12.1.1 and 12.2.2 releases, where it continues to be referenced by dependent iGS components.

Key Procedures and Functions

The ETRM metadata documents a single callable program unit within this package:

  • RULP_VAL_RUD_DESC — A function that validates a new rule description against the old rule description and associated rule attributes. It accepts the prior sequence number, prior return type, prior rule description, and prior turing (evaluation) function, together with the new return type and new rule description. It returns a Boolean success indicator and returns any diagnostic text through an OUT NOCOPY message parameter. A PRAGMA RESTRICT_REFERENCES(..., WNDS) directive confirms the function performs no database writes (Write No Database State), making it safe for use in SQL and read-only validation contexts.

The function is a pure business-rule validator: it compares old versus new values for a rule definition and determines whether the proposed change is permissible, surfacing a descriptive message on failure.

Tables Accessed

The package resolves the following tables through APPS synonyms, which the validator consults while assessing rule description changes:

  • IGS_RU_DESCRIPTION — Stores rule descriptions; the primary source against which new description text is compared.
  • IGS_RU_ITEM — Defines individual rule items that participate in rule evaluation, providing contextual structure for descriptions.
  • IGS_RU_NAMED_RULE — Holds named rule definitions, linking descriptions to identifiable rules used across the Rules Engine.
  • IGS_RU_RET_TYPE — Defines valid return types for rules; consulted to verify that a new return type is consistent and recognized.

Because the function carries the WNDS restriction pragma, these tables are read for validation only; the package does not persist changes.

Usage Notes

This package is typically invoked from the iGS Rules Engine setup and maintenance forms, where administrators create or revise rule descriptions. When a user edits a rule description, the form calls RULP_VAL_RUD_DESC to confirm the change is valid before committing. The ETRM metadata records that the package is referenced by one other package, indicating it participates in a layered validation chain rather than standing alone. Custom extensions that programmatically maintain iGS rule definitions can invoke the function directly, checking the Boolean return value and displaying the message parameter when validation fails. Its WNDS pragma and AUTHID CURRENT_USER declaration make it suitable for read-only validation from PL/SQL, forms, and any calling code executing under an APPS-enabled user session.