Search Results igs_pr_ru_appl_pkg




Overview
Explore in AI Chat

Overview

The package body APPS.IGS_PR_RU_APPL_PKG belongs to the Oracle E-Business Suite product family known as Student Systems (the IGS prefix denotes the Student System / Student Records schema). It is classified as an "OTHER" API within the ETRM documentation for release 12.1.1 and remains valid in 12.1.1 and 12.2.2. The object encapsulates the data-manipulation and validation logic for the IGS_PR_RU_APPL_ALL entity, which represents the association between academic rules (Progression Rules) and the applications to which those rules are applied. This package serves primarily as the DML engine behind the various Foundation/Progression forms and validation routines, enforcing foreign-key integrity, primary-key derivation, row locking, and constraint checking for the rule-application relationship. It is not referenced by any other database object, but it references a substantial number of IGS_* packages and tables, indicating a mid-tier dependency within the Progression Rules subsystem rather than a low-level utility.

Key Procedures and Functions

The package exposes seventeen documented procedures and functions. Their purposes are:

  • INSERT_ROW — Inserts a new rule-application row into IGS_PR_RU_APPL_ALL.
  • LOCK_ROW — Acquires a row-level lock on an existing rule-application record prior to modification.
  • UPDATE_ROW — Applies changes to an existing rule-application row.
  • ADD_ROW — Convenience routine that coordinates the add path (typically calling INSERT_ROW and related validation).
  • DELETE_ROW — Removes an existing rule-application row.
  • GET_PK_FOR_VALIDATION — Derives and returns the primary-key values required during validation against the rule-application record.
  • GET_FK_IGS_PR_CLASS_STD — Retrieves the foreign-key value for the associated class/student record.
  • GET_FK_IGS_EN_ATD_TYPE — Retrieves the foreign key for the attendance-type reference.
  • GET_FK_IGS_PS_VER — Retrieves the foreign key for the program version.
  • GET_FK_IGS_OR_UNIT — Retrieves the foreign key for the organizational unit.
  • GET_FK_IGS_PR_RU_CAT — Retrieves the foreign key for the rule-application category.
  • GET_FK_IGS_PR_RU_OU — Retrieves the foreign key for the rule-application organizational unit.
  • GET_FK_IGS_PR_RULE — Retrieves the foreign key for the parent progression rule.
  • GET_FK_IGS_EN_STDNT_PS_ATT — Retrieves the foreign key for the student program attempt.
  • GET_FK_IGS_PR_STDNT_PR_OU — Retrieves the foreign key for the student progression OU association.
  • BEFORE_DML — Pre-DML trigger-style routine that performs common validation and setup before insert, update, or delete operations.
  • CHECK_CONSTRAINTS — Validates that all applicable business and integrity constraints are satisfied before the DML is committed.

Together these routines implement a standard Oracle Forms-based "table handler" API pattern: a generic DML trio (INSERT/UPDATE/DELETE), a lock, an add-coordinator, and a set of FK lookup helpers used by validation packages such as IGS_PR_VAL_PRA and IGS_PR_VAL_SOPC.

Tables Accessed

The single table documented as accessed is IGS_PR_RU_APPL_ALL (referenced through an APPS synonym). This table stores the row-level mapping between a progression rule (IGS_PR_RULE) and the context in which it applies — program version, attendance type, organizational unit, category, and student-related entities. All INSERT_ROW, UPDATE_ROW, DELETE_ROW, LOCK_ROW, and the FK getter routines operate against this table or its parent/child related entities. Because the getters retrieve foreign-key values by querying parent tables, the package indirectly depends on the validation and lookup packages listed in the dependency metadata (for example IGS_PR_RULE_PKG, IGS_PR_RU_CAT_PKG, IGS_PR_RU_OU_PKG, and IGS_OR_UNIT_PKG).

Usage Notes

In a typical Oracle EBS 12.1.1 or 12.2.2 deployment, this package is invoked indirectly by Student System forms (for example the Progression Rules maintenance form) and by concurrent or batch validation programs that process student progression. The Oracle Forms block for the rule-application entity calls these procedures as its ON-INSERT, ON-UPDATE, ON-DELETE, and ON-LOCK handlers. Because the package performs constraint checking and FK resolution, any custom extension that writes directly to IGS_PR_RU_APPL_ALL should call this API instead of using raw DML, to preserve validation and message-stack behavior (IGS_GE_MSG_STACK, FND_MESSAGE). The package is documented as "not referenced by any database object," which confirms it is an API entry point rather than an internal helper; consequently its procedures constitute the supported interface for managing rule-application rows.