Search Results igs_ru_call_rule_pkg




Overview
Explore in AI Chat

Overview

The APPS.IGS_RU_CALL_RULE_PKG is a PL/SQL package that belongs to the Oracle E-Business Suite ETRM (Education and Research) product family, specifically the Student Records / Rules (IGS_RU) module in Oracle EBS 12.1.1 and 12.2.2. Its function is to encapsulate the data manipulation and validation logic for the IGS_RU_CALL_RULE entity, which stores definitions of "call rules" used within the rules engine of the Student System. Call rules determine the conditions under which particular rule actions or named rules are invoked during academic and enrollment processing.

The package is classified as OTHER in the ETRM metadata, meaning it is not a public, documented integration API but an internal data-access layer used by the application's own forms and dependent packages. It is maintained in the APPS schema with a VALID status in both 12.1.1 and 12.2.2.

Key Procedures and Functions

The documented interface exposes ten procedures and functions that implement the standard Oracle Forms–style DML stack for the underlying entity:

  • INSERT_ROW — Inserts a new call-rule record into the base table.
  • ADD_ROW — Alternate/auxiliary insert entry point, typically used by calling code that supplies key values differently than INSERT_ROW.
  • UPDATE_ROW — Applies modifications to an existing call-rule row.
  • DELETE_ROW — Removes a call-rule row.
  • LOCK_ROW — Acquires a row-level lock (SELECT FOR UPDATE) to support concurrent-safe editing and optimistic locking.
  • GET_PK_FOR_VALIDATION — Returns the primary key used to validate that a row exists or to fetch it for referential checks.
  • GET_UK1_FOR_VALIDATION — Returns the first unique-key value used in uniqueness validation of call rules.
  • GET_FK_IGS_RU_NAMED_RULE — Returns the foreign key into the named-rule entity, used to enforce referential integrity.
  • CHECK_CONSTRAINTS — Validates business and database constraints before a DML operation completes.
  • BEFORE_DML — Pre-DML hook that populates WHO columns, defaults, and derived values before insert/update/delete.

Tables Accessed

The package accesses a single documented base table, IGS_RU_CALL_RULE, referenced through the APPS synonym. This table stores the call-rule definitions themselves. The procedures read it for validation and locking (GET_PK_FOR_VALIDATION, GET_UK1_FOR_VALIDATION, GET_FK_IGS_RU_NAMED_RULE, LOCK_ROW) and write to it for inserts, updates, and deletes (INSERT_ROW, ADD_ROW, UPDATE_ROW, DELETE_ROW). The foreign-key helper additionally implies a logical relationship to the named-rule entity maintained by IGS_RU_NAMED_RULE_PKG.

Usage Notes

This package is referenced by one other package, IGS_RU_NAMED_RULE_PKG, and by itself, indicating that call rules are consumed by the named-rule layer of the IGS_RU rules engine. In normal operation it is invoked from the Student System maintenance forms when administrators define or edit call rules, and from dependent PL/SQL code during rule evaluation. Because it is classified OTHER rather than as a public API, custom integrators should not call it directly; instead they should use the supported ETRM APIs or UI for maintaining rules. Any customization that references it must respect the BEFORE_DML / CHECK_CONSTRAINTS sequence and the row-locking behavior to avoid concurrency corruption in multi-user EBS 12.1.1 and 12.2.2 environments.