Search Results igs_en_unit_set_rule_pkg




Overview
Explore in AI Chat

Overview

IGS_EN_UNIT_SET_RULE_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the Student Systems (IGS) product family, specifically within the enrollment (IGS_EN) module. It encapsulates the business logic governing unit set rules, the configuration records that determine which academic units may be combined, restricted, or conditionally grouped within a student's enrollment unit set. In Oracle EBS 12.1.1 and 12.2.2, this package acts as the validation and maintenance layer beneath the unit set definition forms and the enrollment processing engine, ensuring that any rule attached to a unit set is internally consistent before it is persisted to the database.

The package is recorded as VALID in the ETRM repository and is designated with an API classification of OTHER, indicating that it is primarily an internal, form-supporting package rather than a published public API. Its dependency footprint confirms this role: it depends on the SYS.STANDARD package and is referenced by IGS_EN_UNIT_SET_PKG along with the generated code units IGS_PS_GEN_008 and IGS_RU_GEN_005. The circular self-reference shown for IGS_EN_UNIT_SET_RULE_PKG reflects internal package body calls.

Key Procedures and Functions

The 11 documented program units divide into three functional groups.

  • DML entry points: INSERT_ROW, UPDATE_ROW, and DELETE_ROW provide the standard table maintenance operations for unit set rule records. ADD_ROW performs the initial row creation used by the forms layer, typically preceded by primary key acquisition.
  • Row locking and validation: LOCK_ROW issues the SELECT ... FOR UPDATE used to serialize concurrent edits of the same rule row. GET_PK_FOR_VALIDATION retrieves the primary key used to confirm that a submitted record corresponds to an existing row. CHECK_CONSTRAINTS performs the cross-field and referential validation that must pass before any write is committed. BEFORE_DML is the trigger-style procedure that centralizes the pre-insert and pre-update logic, including WHO column stamping and audit population.
  • Foreign key resolution: GET_FK_IGS_RU_RULE, GET_FK_IGS_RU_CALL, and GET_FK_IGS_EN_UNIT_SET return the foreign key descriptors linking a unit set rule to its parent rule, call, and unit set definitions. These are consumed by the generic foreign key validation framework rather than called directly by end users.

No parameter lists are documented in the ETRM metadata; the signatures follow standard Oracle Designer/Headstart generation conventions and should be confirmed against the deployed package specification for the specific release.

Tables Accessed

The only documented table reference is IGS_EN_UNIT_SET_RULE, accessed through an APPS synonym. This table stores the rule rows that constrain unit set construction, including the parent rule, the associated call identifier, and the unit set to which the rule applies. All procedure logic in the package is oriented toward maintaining and validating rows in this single base table; the foreign key return procedures do not query additional entities directly but resolve descriptors against the same table and its referenced parents.

Usage Notes

IGS_EN_UNIT_SET_RULE_PKG is invoked indirectly rather than called by end users. Its principal consumers are the Oracle Forms-based enrollment setup screens for unit sets, which call ADD_ROW, INSERT_ROW, UPDATE_ROW, DELETE_ROW, and LOCK_ROW during record navigation and commit cycles. IGS_EN_UNIT_SET_PKG, the parent unit set package, invokes these routines when validating or propagating unit set definitions. The generated units IGS_PS_GEN_008 and IGS_RU_GEN_005 reference the package in the program unit (PS) and rules (RU) modules respectively, indicating use during rule generation and program-of-study enrollment validation.

Customizations should avoid modifying this package directly; instead, extensions should be layered through the supported enrollment APIs or by adding validation via the documented CHECK_CONSTRAINTS and BEFORE_DML hooks where the site's implementation permits. Because the package is dependent on SYS.STANDARD and generates compiled code at install time, recompilation is required after any patch that alters IGS_EN_UNIT_SET_RULE. In 12.2.2 the Online Patching (adop) cycle phases must be observed when deploying changes to this object.