Search Results igs_en_unit_set_map_pkg




Overview
Explore in AI Chat

Overview

The APPS.IGS_EN_UNIT_SET_MAP_PKG package body is a server-side PL/SQL construct within the Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 environment, owned by the APPS schema and reported as VALID. It belongs to the Student Systems / Higher Education product family (the IGS_ prefix), specifically the enrollment (IGS_EN) module. Its principal business function is to manage the mapping between enrollment unit sets and their associated unit set definitions and pre-enrollment configuration records. The package acts as a data-access and validation layer over the IGS_EN_UNIT_SET_MAP table, providing the standard row-level operations (insert, lock, delete) plus foreign-key resolution and validation helpers commonly used by EBS forms, concurrent programs, and dependent APIs.

Key Procedures and Functions

The ETRM metadata documents seven procedures/functions, each reflecting a conventional EBS table-handler pattern:

  • INSERT_ROW — Inserts a new unit set mapping row into IGS_EN_UNIT_SET_MAP, populating the WHO columns and applying default/business logic prior to commit.
  • LOCK_ROW — Acquires a row-level lock on the target mapping record, ensuring pessimistic concurrency control when a form or caller intends to modify existing data.
  • DELETE_ROW — Removes an existing unit set mapping row, typically guarded by validation to preserve referential integrity.
  • GET_PK_FOR_VALIDATION — Returns or derives the primary key value required for validation, allowing callers to confirm uniqueness or existence of a mapping before DML.
  • GET_FK_IGS_EN_UNIT_SET — Resolves the foreign-key reference to the associated unit set, linking the mapping record to its parent unit set definition.
  • GET_FK_IGS_PS_US_PRENR_CFG — Resolves the foreign-key reference to the pre-enrollment configuration record, tying the mapping to the pre-enrollment setup context.
  • BEFORE_DML — A pre-DML hook that executes shared validation, defaulting, and WHO-column population logic before any insert, update, or delete is applied.

Tables Accessed

The package operates primarily on IGS_EN_UNIT_SET_MAP, referenced through the APPS synonym layer. This table stores the association records between enrollment unit sets and their pre-enrollment configuration, and it is the target of the INSERT_ROW, LOCK_ROW, and DELETE_ROW procedures as well as the source of the primary-key and foreign-key resolution routines. The foreign-key helpers (GET_FK_IGS_EN_UNIT_SET and GET_FK_IGS_PS_US_PRENR_CFG) imply logical retrieval of related unit set and pre-enrollment configuration data to satisfy validation and display requirements.

Usage Notes

This package is invoked programmatically rather than directly by end users. It is referenced by two other packages and, in turn, depends on IGS_EN_UNIT_SET_PKG and IGS_PS_US_PRENR_CFG_PKG, indicating it participates in a layered call stack within the enrollment and pre-enrollment configuration setup. Typical invocation paths include:

  • EBS Forms (Oracle Forms 10g/12c) that maintain unit set mappings, which call LOCK_ROW and BEFORE_DML during block navigation and commit processing.
  • Concurrent programs or batch loads that call INSERT_ROW and DELETE_ROW to bulk-maintain mapping records.
  • Custom PL/SQL that calls the FK resolution and PK validation routines to enforce consistency before performing dependent inserts.

Because the package raises errors through APP_EXCEPTION, FND_MESSAGE, and IGS_GE_MSG_STACK with messages surfaced via FND_GLOBAL, callers should observe the standard EBS error-handling conventions and not assume silent failure. The package is documented as not being referenced by any database object, so its use is confined to application-layer callers rather than triggers.