Results for “igs_re_sprvsr_pkg”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_RE_SPRVSR_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, part of the Student System (IGS) product family. Its name indicates it manages "supervisor" data within the Research/Records (RE) module, specifically records stored in the IGS_RE_SPRVSR table. In the EBS 12.1.1 and 12.2.2 architectures, the package functions as a table-handler layer that encapsulates all DML against IGS_RE_SPRVSR, exposes foreign-key validation lookups, and enforces referential integrity constraints on behalf of the higher-level business logic. It is classified as OTHER under the ETRM API taxonomy, meaning it is a supporting internal package rather than a public, externally documented API. Its purpose is to standardise how supervisor-related rows are inserted, updated, locked, and validated by dependent packages in the student records and research supervisor domain.

Key Procedures and Functions

The ETRM metadata documents 14 procedures and functions. The table-handling business procedures include INSERT_ROW, UPDATE_ROW, DELETE_ROW, and ADD_ROW, which provide the standard insert, modify, delete, and add operations against IGS_RE_SPRVSR. LOCK_ROW provides optimistic-locking support by placing a row lock before update, guarding against concurrent modification. BEFORE_DML is a trigger-style pre-processing routine that likely derives audit columns, defaults, or surrogate keys prior to DML execution. CHECK_CONSTRAINTS performs validation of the business and integrity constraints applicable to a supervisor row.

The remaining documented routines are validation lookups. GET_PK_FOR_VALIDATION and GET_UK1_FOR_VALIDATION return the primary and unique-key identifier values used by the framework to validate a row when it is referenced. GET_FK_IGS_RE_CANDIDATURE, GET_FK_IGS_OR_UNIT, GET_FK_IGS_PE_PERSON, GET_FK_IGS_RE_SPRVSR_TYPE, and GET_FK_IGS_RE_SPRVSR are foreign-key helper functions that resolve the parent keys associated with a supervisor row: its candidature, its organisational unit, its person record, its supervisor type, and a self-referencing supervisor relationship. Together these routines implement the referential-integrity contract that the surrounding IGS packages rely upon.

Tables Accessed

The single documented table referenced through APPS synonyms is IGS_RE_SPRVSR, the supervisor table itself. INSERT_ROW, ADD_ROW, UPDATE_ROW, and DELETE_ROW write to this table; LOCK_ROW and the GET_* validation routines read from it. The foreign-key functions additionally resolve keys pointing to parent entities for candidature (IGS_RE_CANDIDATURE), organisational unit (IGS_OR_UNIT), person (IGS_PE_PERSON), supervisor type (IGS_RE_SPRVSR_TYPE), and the supervisor's own parent record (IGS_RE_SPRVSR), reflecting the associated lookup tables implied by the function names. The dependency listing confirms the package references only the SYS STANDARD schema object in addition to its own table dependencies.

Usage Notes

IGS_RE_SPRVSR_PKG is referenced by six other packages: IGS_AD_INT_RECONSIDER, IGS_AD_VAL_ACAI_FTR_OFFER, IGS_EN_INS_CA_TRNSFR, IGS_RE_CANDIDATURE_PKG, IGS_RE_SPRVSR_LGCY_PUB, and IGS_RE_SPRVSR_TYPE_PKG, as well as by itself for recursive supervisor relationships. It is typically invoked indirectly from these packages during supervisor assignment, candidature maintenance, transfer processing, and admissions-related validation flows, rather than being called directly by end users. No direct form or concurrent-program invocation is documented, so customisations should call the wrapping business packages rather than the table handlers to preserve integrity rules. Because the package is a supporting internal component, it should be treated as subject to change between releases and not relied upon as a stable external interface.