Search Results get_fk_igs_as_unit_mode

Overview

IGS_AS_UNIT_CLASS_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the "Other" API category within the ETRM repository. It belongs to the Student Systems (IGS) product family, specifically the Academic Scheduling (AS) module, and manages the IGS_AS_UNIT_CLASS entity. A unit class represents a scheduled delivery of a unit (course) in a particular attendance mode — for example, an on-campus lecture, an external or distance offering, or an evening class — together with supporting attributes such as day of week, start and end time, and a closed indicator.

The package implements the standard EBS table-handler pattern, providing the procedural interface through which Oracle Forms and other callers perform DML against the underlying table while enforcing primary key validation, foreign key validation, column constraint checking, and auditing or WHO-column population. It is a private-style, forms-support package rather than a public, multi-customer API, and the header comment block confirms an original creation date of 2005 with no significant change since.

Key Procedures and Functions

• INSERT_ROW — Inserts a new unit class record, accepting the ORG_ID, UNIT_CLASS, UNIT_MODE, DESCRIPTION, DAY_OF_WEEK, START_TIME, END_TIME, and CLOSED_IND values, and returning the generated ROWID for subsequent optimistic locking.
• LOCK_ROW — Re-reads the row identified by the supplied ROWID and key columns and locks it for update, confirming that the record has not been modified by another session since it was queried.
• UPDATE_ROW — Applies changes to an existing unit class identified by ROWID, updating the descriptive, scheduling, and closed-indicator columns.
• ADD_ROW — Performs an insert-or-update style "add" operation, taking the same column set as INSERT_ROW and returning the ROWID.
• GET_PK_FOR_VALIDATION — Boolean function that validates whether the supplied UNIT_CLASS value corresponds to an existing primary key, used by the form's key validation triggers.
• GET_FK_IGS_AS_UNIT_MODE — Validates the foreign key relationship between the unit class record and the referenced IGS_AS_UNIT_MODE value, ensuring the attendance mode exists before the row is saved.
• CHECK_CONSTRAINTS — Validates a named column or all columns against the table's defined check constraints, typically invoked from form-level validation logic.
• BEFORE_DML — Centralized pre-DML hook that performs common validation and WHO-column defaulting before insert, update, or delete actions.

Tables Accessed

The package operates on IGS_AS_UNIT_CLASS_ALL, referenced through an APPS synonym. This is the multi-organization table that stores unit class definitions, with ORG_ID supplying the operating unit context. INSERT_ROW and ADD_ROW write new rows; LOCK_ROW and UPDATE_ROW read and update existing rows; GET_PK_FOR_VALIDATION queries the primary key; and GET_FK_IGS_AS_UNIT_MODE performs a lookup against the unit mode reference data to confirm referential integrity.

Usage Notes

IGS_AS_UNIT_CLASS_PKG is referenced by nine other packages in the EBS data model, indicating it participates in a broader dependency chain within Academic Scheduling. Its primary consumer is the Oracle Forms maintenance screen for unit classes, whose block-level triggers call ADD_ROW, UPDATE_ROW, LOCK_ROW, and the validation routines. The X_MODE parameter, defaulting to 'R', follows the EBS convention that distinguishes runtime invocation from the forms design-time or validation-only modes. Custom extensions that need to create or maintain unit classes programmatically should call these procedures rather than issuing direct DML against IGS_AS_UNIT_CLASS_ALL, so that the package's validation and audit logic is preserved. Because the package is not a published public API, direct calls carry the usual caveat of possible signature change in future patches.