Search Results igs_re_ths_exam_type_pkg

Overview

The IGS_RE_THS_EXAM_TYPE_PKG package is a PL/SQL API in the Oracle E-Business Suite (EBS) environment, owned by the APPS schema and classified as an OTHER API. It forms part of the Oracle Student System / Academic Enterprise (IGS) module, specifically the Research & External (RE) component dealing with thesis examination types. The package defines the standard DML interface through which the Oracle Forms-based maintenance screens interact with the IGS_RE_THS_EXAM_TYPE base table. It enforces business rules, validates referential and column-level constraints, and provides the row-level locking semantics required by the Oracle Forms framework. The header indicates that the package is defined with AUTHID CURRENT_USER, meaning invoker's rights are applied, and that the most recent source revision carries the header identifier IGSRI20S.pls 115.3, consistent with the original 2002-era IGS delivery that persists unchanged through later releases.

Key Procedures and Functions

The package exposes eight documented program units, all of which follow the canonical Oracle Forms-enabled DML pattern:

• INSERT_ROW — Inserts a new thesis examination type record into the base table, accepting the primary key value, description, and closed indicator alongside a mode flag.
• LOCK_ROW — Acquires a row-level lock on an existing record to support concurrent edit sessions; used by Oracle Forms when a user begins modifying a record.
• UPDATE_ROW — Updates the description and closed indicator of an existing thesis examination type, identifying the row by its ROWID.
• ADD_ROW — A convenience wrapper that performs an insert-or-update decision, typically invoked by Forms to add a record without distinguishing between insert and update contexts.
• DELETE_ROW — Removes a thesis examination type record identified by ROWID, subject to any applicable dependent-record checks.
• GET_PK_FOR_VALIDATION — A boolean function used to confirm that a given thesis examination type value corresponds to a valid primary key before dependent processing proceeds.
• CHECK_CONSTRAINTS — Validates the value supplied for a named column against the constraints defined for that column, supporting Forms' client-side validation.
• BEFORE_DML — A central pre-DML hook that stamps audit columns (creation date, created by, last update date, last updated by, last update login) and applies the WHO-column conventions required across IGS tables.

Tables Accessed

The package operates against a single base table, IGS_RE_THS_EXAM_TYPE, referenced via its APPS synonym. This table stores the valid set of thesis examination types (for example, distinctions between thesis proposals, final defences, or qualifying examinations) together with a description and a closed indicator used to retire a type from active use without deleting its history. All inserts, updates, deletes, locks, and validation queries performed by the package target this table; the BEFORE_DML procedure also writes the audit columns on that same table.

Usage Notes

IGS_RE_THS_EXAM_TYPE_PKG is not typically invoked directly by end users. It is called from the Oracle Forms maintenance block associated with the thesis examination type setup screen, where the Forms runtime translates user actions into INSERT_ROW, LOCK_ROW, UPDATE_ROW, ADD_ROW, and DELETE_ROW calls. The BEFORE_DML procedure is invoked automatically as the pre-insert and pre-update trigger, and CHECK_CONSTRAINTS and GET_PK_FOR_VALIDATION are used during field validation. The package is also referenced by two other IGS packages, which call its validation and locking routines when processing dependent thesis records. Custom code that must respect IGS business rules should call these same APIs rather than performing direct DML on IGS_RE_THS_EXAM_TYPE, ensuring that audit columns and constraints are consistently applied.