Search Results igs_en_unit_set_pkg




Overview
Explore in AI Chat

Overview

The APPS.IGS_EN_UNIT_SET_PKG package is a core data access and validation component within the Oracle E-Business Suite Student System (IGS) enrollment module. It provides the transactional layer for the IGS_EN_UNIT_SET_ALL entity, which represents unit sets — groupings of academic units (courses) that students can enroll in as a single managed block, commonly used to model programs, majors, or prescribed study combinations. The package encapsulates the DML logic required to insert, update, lock, and delete unit set records, and it enforces the foreign key and constraint rules that govern the relationship between a unit set and its status. It is classified under the ETRM as an OTHER API, meaning it is intended primarily for internal consumption by Oracle's own enrollment forms and dependent packages rather than as a formally published open interface. The package operates in the APPS schema, is marked VALID, and depends only on SYS.STANDARD, confirming it is a self-contained PL/SQL unit with no external library dependencies.

Key Procedures and Functions

The documented API surface comprises eleven procedures and functions, organized around standard table-handler conventions:

  • INSERT_ROW — Inserts a new unit set record into the base table.
  • UPDATE_ROW — Updates an existing unit set record.
  • DELETE_ROW — Removes a unit set record.
  • LOCK_ROW — Acquires a row-level lock on the target unit set, typically used to serialize concurrent modifications before an update or delete.
  • ADD_ROW — A higher-level wrapper that performs the combined validation and insertion sequence.
  • BEFORE_DML — A pre-DML hook that executes standard housekeeping (such as WHO column population and validation) prior to insert or update operations.
  • CHECK_CONSTRAINTS — Validates that all required constraints and foreign key relationships are satisfied before committing changes.
  • GET_PK_FOR_VALIDATION — Retrieves the primary key of a unit set for validation purposes.
  • GET_FK_IGS_OR_UNIT — Resolves the foreign key relationship to the organizational unit entity.
  • GET_FK_IGS_EN_UNIT_SET_CAT — Resolves the foreign key to the unit set category entity.
  • GET_FK_IGS_EN_UNIT_SET_STAT — Resolves the foreign key to the unit set status entity.

Parameter lists are intentionally omitted; these routines follow the standard IGS table-handler signature pattern (primary key values, column values, and x_return_status/x_msg_count/x_msg_data out parameters).

Tables Accessed

The package reads from and writes to two documented tables, referenced through APPS synonyms:

  • IGS_EN_UNIT_SET_ALL — The primary unit set table, holding the master enrollment unit set definition, including its name, category, effective dates, and organizational unit association. This is the table acted upon by INSERT_ROW, UPDATE_ROW, DELETE_ROW, and LOCK_ROW.
  • IGS_EN_UNIT_SET_STAT — The unit set status table, which records the lifecycle status of a unit set. The GET_FK_IGS_EN_UNIT_SET_STAT function resolves this relationship, and CHECK_CONSTRAINTS verifies that a valid status exists before changes are committed.

Usage Notes

This package is not a standalone business API; it is invoked indirectly. The ETRM dependency listing shows it is referenced by 34 packages, including IGS_EN_UNIT_SET_CAT_PKG, IGS_EN_UNIT_SET_MAP_PKG, IGS_EN_UNIT_SET_NOTE_PKG, IGS_EN_UNIT_SET_RULE_PKG, and IGS_EN_UNIT_SET_STAT_PKG, as well as cross-module consumers such as IGS_AD_UNIT_SETS_PKG, IGS_AS_SU_SETATMPT_PKG, IGS_PS_OFR_UNIT_SET_PKG, and IGS_FI_FEE_AS_ITEMS_PKG. In practice it is called from the Oracle Student System enrollment forms, from concurrent programs that maintain unit set data, and from legacy public APIs such as IGS_EN_SUSA_LGCY_PUB. Because it is classified as OTHER rather than a formal public API, customizations should avoid calling it directly; developers should instead extend through the higher-level unit set packages or use approved open interfaces. Direct invocation risks bypassing validation logic and WHO column maintenance performed by BEFORE_DML.