Search Results igs_ru_call_pkg




Overview
Explore in AI Chat

Overview

IGS_RU_CALL_PKG is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema, classified under the OTHER API category within the ETRM (Enterprise Transaction Repository Model) inventory. It operates in the Oracle EBS 12.1.1 and 12.2.2 release streams and supports the Rules Engine functionality of the Oracle Student System / Student Records family of modules, evidenced by its membership in the IGS_RU (Rules) namespace and its dependencies on related rule components such as IGS_RU_NAMED_RULE_PKG, IGS_RU_GROUP_PKG, IGS_RU_ITEM_PKG, and IGS_RU_DESCRIPTION_PKG.

The package serves as the data access and persistence layer for the IGS_RU_CALL entity, which records rule calls within the Rules Engine execution framework. It encapsulates the standard table-handling operations required for maintaining rows in the underlying base table, exposing a controlled API surface to both the Forms-based user interface and other PL/SQL components. The body is documented as VALID in the ETRM metadata, and no other database object references it, indicating that it is an invoking layer rather than a called-upon utility.

Key Procedures and Functions

The package body documents thirteen procedures and functions, organized around conventional DML and validation patterns:

  • INSERT_ROW — Inserts a new record into the IGS_RU_CALL table, applying default and audit values.
  • LOCK_ROW — Acquires a row-level lock on an existing IGS_RU_CALL record to prevent concurrent modification.
  • UPDATE_ROW — Updates mutable columns of an existing IGS_RU_CALL row.
  • ADD_ROW — Higher-level add operation that combines key validation and insertion logic.
  • DELETE_ROW — Removes a specified IGS_RU_CALL record after applicable checks.
  • GET_PK_FOR_VALIDATION — Returns the primary key of the target row for validation purposes.
  • GET_UK1_FOR_VALIDATION — Returns the first unique key value used in validation routines.
  • GET_FK_IGS_RU_NAMED_RULE — Retrieves the foreign key linkage to the named rule entity.
  • GET_FK_IGS_RU_DESCRIPTION — Retrieves the foreign key linkage to the rule description entity.
  • GET_FK_IGS_RU_GROUP_SG — Returns the foreign key to the rule group (SG) entity.
  • GET_FK_IGS_RU_GROUP_SEQ — Returns the foreign key sequence value for the rule group relationship.
  • CHECK_CONSTRAINTS — Validates business and referential integrity constraints prior to DML.
  • BEFORE_DML — Pre-DML hook that prepares audit columns and invokes constraint validation.

Tables Accessed

The package body reads and writes the IGS_RU_CALL base table through the APPS synonym layer. This table stores the call records generated when rule processing is evaluated within the Rules Engine. The foreign-key accessor functions imply logical relationships to the named rule, description, and group entities maintained by the sibling IGS_RU packages. Dependencies on IGS_GE_MSG_STACK, FND_MESSAGE, and APP_EXCEPTION indicate the package raises and manages user-facing error messages through the standard EBS message stack.

Usage Notes

IGS_RU_CALL_PKG is referenced by fourteen other database objects within the APPS schema, confirming its role as a shared data-access component rather than a terminal or standalone utility. It is typically invoked from Oracle Forms during the maintenance of rule-call data, and from dependent PL/SQL packages that require validated inserts, updates, or lookups against IGS_RU_CALL. Customizations and extensions should call the documented procedures rather than issuing direct DML against the base table, preserving constraint checks, audit population, and message handling. As with all APPS-owned packages, changes must be applied through supported patching to avoid invalidating dependent objects.