Search Results rulp_ins_rgi




Overview
Explore in AI Chat

Overview

IGS_RU_VAL_RGI is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified in the ETRM repository as an "OTHER" API rather than a public or private interface. Its name follows the IGS (Intelligent Grants System, later rebranded as Oracle Grants Accounting and integrated into Oracle Project Portfolio Management) naming conventions for the Research Administration (RU) module. The "RGI" suffix refers to the group item entity, indicating that this package controls the validation and insertion logic that links individual group items into the group set hierarchy used by the Research Administration grouping engine.

AUTHID CURRENT_USER is declared, meaning the package executes under the privileges of the calling schema rather than as its definer. In 12.1.1 and 12.2.2, this pattern is commonly used inside the APPS schema so that callers with appropriate grants can access the underlying base tables without requiring direct definer's-rights escalation. The package is declared with only three program units and is not exposed as a full public API; it functions as an internal support package.

Key Procedures and Functions

  • RULP_INS_RGI — The primary population routine. As documented in the source header comment, this procedure populates IGS_RU_GROUP_SET from IGS_RU_GROUP_ITEM. It is the entry point invoked when a batch or form operation needs to materialize group set records from the finer-grained group item staging table.
  • RULP_SET_RGI — Per the inline comment "To set gv_group_number", this procedure assigns the package-global variable that holds the current group number. It accepts a sequence number, a description number, and a description type, allowing the caller to scope subsequent operations to a specific group.
  • RULP_VAL_GRP_RGI — A Boolean function that verifies whether the insert group can be inserted into the current group. It carries the PRAGMA RESTRICT_REFERENCES(..., WNDS) directive, guaranteeing the function writes no database state. This makes it safe for use in SQL and in validation logic within forms or other PL/SQL units.

Tables Accessed

The package references two documented tables through APPS synonyms:

  • IGS_RU_GROUP_ITEM — The source table holding individual group item records. RULP_INS_RGI reads from this table during population.
  • IGS_RU_GROUP_SET — The target table receiving the consolidated group set records produced by RULP_INS_RGI. RULP_VAL_GRP_RGI consults the same structures to determine whether an insert into the current group would be valid.

Usage Notes

ETRM records show this package is referenced by exactly one other package, indicating a narrow, tightly coupled role in the Research Administration layer. It is typically invoked from the form or concurrent program logic that manages group setup, where a coordinator builds a group set from constituent group items. The validation function prevents duplicate or conflicting membership before the insert procedure commits the consolidated records.

Because the package is classified as OTHER and carries no documented public interface, customizations should avoid calling it directly; integrators should instead use the supported public APIs of the Research Administration module. Its significance lies in the internal consistency checks that keep the group item and group set tables synchronized.