Search Results igs_ru_val_rgi

Overview

IGS_RU_VAL_RGI is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, classified under the Higher Education / Student System product family (the IGS prefix denotes the Oracle Student System module). Its name follows the EBS convention for a validation and maintenance unit: IGS_RU identifies the "Rules Unit" area, VAL indicates validation logic, and RGI refers to the Rule Group Item entity it governs. The package therefore provides the server-side validation engine that checks and persists rule group item definitions used by the Student System's rules infrastructure.

The ETRM metadata lists the object status as VALID, confirming that the compiled body is present and syntactically sound in the database. Its API classification is OTHER, meaning it is not exposed as a public, supported business API; it is an internal worker package. The metadata records no database object that references IGS_RU_VAL_RGI, indicating the package is invoked from outside the PL/SQL dependency chain — typically from forms, concurrent programs, or other run-time entry points rather than from another stored package.

Key Procedures and Functions

The package body exposes three documented program units:

• RULP_INS_RGI — the insert routine for rule group item records. It creates a new rule group item entry, applying the validation rules owned by this package before the row is written.
• RULP_SET_RGI — the set or maintenance routine. It assigns, updates, or configures an existing rule group item, again driving validation through the package's internal logic.
• RULP_VAL_GRP_RGI — the group-level validation routine. It validates a rule group item in the context of its parent rule group, checking cross-row consistency rather than validating a single item in isolation.

The RULP_ prefix is the standard EBS naming convention for rules-unit procedures, reinforcing that these are procedural entry points within the rules framework. No parameter lists are documented, and none should be assumed.

Tables Accessed

The ETRM dependency listing records two base tables referenced through APPS synonyms:

• IGS_RU_GROUP_ITEM — the primary table for rule group item definitions. RULP_INS_RGI and RULP_SET_RGI read and write here, validating item attributes before insert or update.
• IGS_RU_GROUP_SET — the parent rule group set table. It is queried to establish the grouping context required by RULP_VAL_GRP_RGI.

In addition to the base tables, the body depends on the companion APIs IGS_RU_GROUP_ITEM_PKG and IGS_RU_GROUP_SET_PKG, which supply the DML and lookup operations for the two tables. This layered design — validator package calling entity packages — keeps direct SQL confined to the entity layer and centralizes business validation in IGS_RU_VAL_RGI. The body also depends on the SYS STANDARD package, a normal PL/SQL compilation dependency.

Usage Notes

Because the package is not referenced by any database object, it is not called from another stored package. Typical invocation paths are the Student System maintenance forms and concurrent programs that manage rules unit group configuration, where the form or program issues the RULP_ procedures after performing its own field-level checks. The RULP_INS_RGI and RULP_SET_RGI procedures support the insert and update flows, while RULP_VAL_GRP_RGI is called when a rule group item must be validated against its group before the enclosing transaction commits.

Customizations should treat this package as internal. Direct calls from custom code are possible but unsupported, and any extension should reuse the same validation order — item-level checks first, then group-level validation via RULP_VAL_GRP_RGI — to preserve data integrity in IGS_RU_GROUP_ITEM and IGS_RU_GROUP_SET. Standard support policy applies to modifications of the APPS-owned body.