Search Results igs_re_ths_pnl_type_pkg




Overview
Explore in AI Chat

Overview

IGS_RE_THS_PNL_TYPE_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM repository as an "OTHER" API. It belongs to the Oracle Student System / Recruiting and Admissions (IGS) product family, specifically the Research and Education (RE) module dealing with thesis and dissertation processing. Its core business purpose is to manage the validation and definition of thesis panel types — the configurable categories (for example, internal examiner panel, external examiner panel, or viva panel) used when organizing examination panels for higher-degree research candidates.

Functionally, the package acts as a table-level API wrapper around the IGS_RE_THS_PNL_TYPE entity, providing the standard insert, update, delete, lock, and validation operations expected of an EBS table handler. It does not encode complex academic business logic itself; instead it centralizes controlled data manipulation of panel type reference data, ensuring that dependent examination and thesis-level processing packages operate against consistent, validated panel type rows. It is registered as VALID in the documented environment, indicating that both the package specification and body compile successfully against their declared dependencies.

The package specifies eight documented procedures and functions, and its dependency footprint is deliberately narrow: it references only SYS.STANDARD and the synonym-backed IGS_RE_THS_PNL_TYPE table, while two packages in the same schema depend upon it.

Key Procedures and Functions

  • INSERT_ROW — Inserts a new panel type record into the underlying table, applying the package's defaulting and validation conventions.
  • UPDATE_ROW — Modifies an existing panel type row, preserving the integrity of associated examination data.
  • DELETE_ROW — Removes a panel type record, typically subject to referential integrity checks against existing thesis examination data.
  • LOCK_ROW — Acquires a row-level lock on a specified panel type record to prevent concurrent modification during a transaction.
  • ADD_ROW — Provides the higher-level insertion entry point used when creating a new panel type through the application layer.
  • GET_PK_FOR_VALIDATION — Retrieves the primary key for a candidate record for use in validation routines, confirming the target row exists before dependent processing continues.
  • CHECK_CONSTRAINTS — Enforces the package-level and database-level constraint rules that a panel type record must satisfy before DML is committed.
  • BEFORE_DML — A pre-DML hook invoked ahead of insert, update, or delete operations to apply consistent defaulting, auditing, and validation logic.

Tables Accessed

The package operates against a single documented base table: IGS_RE_THS_PNL_TYPE, accessed through an APPS synonym. This table stores the master list of thesis panel type definitions, including the identifying code and descriptive attributes used to categorize examination panels. All eight procedures ultimately read from or write to this table. No additional tables are recorded in the documented dependency list, so any validation performed by CHECK_CONSTRAINTS is expected to be limited to the panel type entity itself or deferred to the database constraint layer.

Usage Notes

IGS_RE_THS_PNL_TYPE_PKG is typically invoked indirectly rather than directly by end users. Its documented referencers are IGS_RE_THESIS_EXAM_PKG and IGS_RE_THE_LGCY_PUB, which call into it when setting up or amending examination panels for thesis candidates. It may also be reached from the Oracle Forms-based setup and maintenance screens that administer panel type reference data. Custom extensions should call the documented procedures rather than issuing direct DML against IGS_RE_THS_PNL_TYPE, so that the BEFORE_DML and CHECK_CONSTRAINTS logic is applied consistently. Because the package is a low-level table handler, it should not be treated as a public integration API; integrations should use the higher-level thesis examination and public (LGCY_PUB) interfaces that encapsulate it.