Search Results igs_en_atd_mode_pkg




Overview
Explore in AI Chat

Overview

IGS_EN_ATD_MODE_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema. It belongs to the Student Systems product family, specifically the IGS (Oracle Student System / Higher Education) module, and its naming indicates it governs Attendance Mode reference data used in enrollment processing. In Oracle EBS 12.1.1 and 12.2.2 environments that include the Student System vertical, this package acts as the data-access layer for the attendance mode entity, encapsulating the insert, update, deletion, locking, and constraint-checking logic that surrounds the IGS_EN_ATD_MODE_ALL table. Rather than exposing raw DML to every calling program, the package centralizes row-level validation and primary/foreign key handling, which is the standard pattern for Oracle Student System reference-data packages. Its status is documented as VALID, confirming it is compiled and active in the environment from which the ETRM (E-Business Suite Technical Reference Manual) metadata was extracted.

Key Procedures and Functions

The package exposes a documented API surface of nine procedures and functions, all classified under the generic "OTHER" API classification. These comprise the standard generated table-handler pattern used throughout the IGS schema:

  • INSERT_ROW — Inserts a new attendance mode record into the underlying table.
  • UPDATE_ROW — Modifies attributes of an existing attendance mode record.
  • DELETE_ROW — Removes an attendance mode record.
  • ADD_ROW — Adds a row, typically performing surrogate key generation through the sequence-handling logic that precedes INSERT_ROW.
  • LOCK_ROW — Acquires a row-level lock to preserve concurrency control during multi-step transactions.
  • GET_PK_FOR_VALIDATION — Returns the primary key value required for validation lookups.
  • GET_FK_IGS_PS_GOVT_ATD_MODE — Retrieves the foreign key relationship linking attendance mode to the government attendance mode entity (IGS_PS_GOVT_ATD_MODE).
  • CHECK_CONSTRAINTS — Enforces business and referential integrity rules before DML is committed.
  • BEFORE_DML — A pre-DML trigger-style hook that standardizes audit column population and validation immediately prior to insert, update, or delete operations.

Tables Accessed

The only documented table referenced through APPS synonyms is IGS_EN_ATD_MODE_ALL, the multi-organization (installation-level) table storing attendance mode definitions. All insert, update, delete, and lock operations target this table, while validation procedures read it to confirm key existence and constraint satisfaction. The naming convention with the _ALL suffix indicates the table is partitioned by organization or business group, and the package respects that model. No other base tables are documented in the ETRM excerpt, though GET_FK_IGS_PS_GOVT_ATD_MODE implies a logical dependency on the government attendance mode reference set.

Usage Notes

IGS_EN_ATD_MODE_PKG is a foundational dependency rather than an end-user-facing API. The ETRM dependency report shows it is referenced by fourteen other packages, including IGS_EN_STDNT_PS_ATT_PKG (student attendance processing), IGS_PS_GOVT_ATD_MODE_PKG, IGS_AD_PS_APPL_INST_PKG and related admission-instruction packages, and several fee-calculation and optional-unit packages. This breadth of referencing packages confirms that attendance mode data underpins admissions, enrollment, attendance tracking, and fee assessments, each of which validates or derives values through this package. In practice the package is invoked from Oracle Forms-based setup windows that maintain attendance mode records, from concurrent programs performing bulk data maintenance, and from custom PL/SQL that must respect the same validation rules as the seeded forms. Because it holds CHECK_CONSTRAINTS and BEFORE_DML logic, direct DML against IGS_EN_ATD_MODE_ALL should be avoided; callers should route changes through this package to preserve audit integrity and referential consistency.