Results for “igs_re_ths_pnl_mbr_pkg”

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

Overview

IGS_RE_THS_PNL_MBR_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM (E-Business Suite Technical Reference Manual) as an "OTHER" API. It belongs to the Oracle Student System / Higher Education component (the IGS_ product prefix), and its name indicates responsibility for managing panel member records associated with thesis examinations. In the academic domain supported by IGS, a thesis examination panel consists of examiners and appointed members who evaluate a postgraduate thesis. This package encapsulates the data-maintenance logic required to create, modify, and delete those panel member rows, and to enforce the referential and validation rules that govern them.

The package is documented as VALID in both 12.1.1 and 12.2.2 environments. Because it is a table-handler style package rather than a business-level API, it is normally called by higher-level thesis examination packages and validation routines rather than directly by end users.

Key Procedures and Functions

• INSERT_ROW — inserts a new panel member record into the underlying table.
• UPDATE_ROW — applies changes to an existing panel member row.
• DELETE_ROW — removes a panel member row.
• ADD_ROW — convenience routine that wraps insert behavior, typically performing any pre-insert defaulting before delegating to INSERT_ROW.
• LOCK_ROW — acquires a row-level lock on the target record to support concurrent update integrity, usually invoked before an update or delete.
• CHECK_CONSTRAINTS — performs application-level validation of the business rules associated with a panel member record prior to DML.
• BEFORE_DML — central pre-DML routine that populates WHO columns and common attributes (creation/update audit fields) before insert or update processing.
• GET_PK_FOR_VALIDATION — returns primary key information used by validation logic to confirm the identity of the record being processed.
• GET_FK_IGS_PE_PERSON — foreign key lookup helper returning the person reference for the panel member.
• GET_FK_IGS_RE_THESIS_EXAM — foreign key lookup helper returning the parent thesis examination reference.
• GET_FK_IGS_RE_THESIS_RESULT — foreign key lookup helper returning the associated thesis result reference.
• GET_FK_IGS_RE_THS_PNL_MR_TP — foreign key lookup helper returning the panel member type reference.

Tables Accessed

The package operates against a single documented base table, IGS_RE_THS_PNL_MBR, accessed through an APPS synonym. This table stores the panel member records for thesis examinations, linking each member to a person, a thesis examination, a thesis result, and a panel member type. The foreign-key helper functions above exist precisely to resolve those related identifiers, while INSERT_ROW, UPDATE_ROW, DELETE_ROW, and ADD_ROW perform the physical DML. The dependencies list references SYS.STANDARD, indicating only standard PL/SQL built-ins are used in addition to the IGS objects.

Usage Notes

IGS_RE_THS_PNL_MBR_PKG is referenced by six other packages: IGS_AD_INT_RECONSIDER, IGS_AD_VAL_ACAI_FTR_OFFER, IGS_EN_INS_CA_TRNSFR, IGS_RE_THESIS_EXAM_PKG, IGS_RE_THESIS_RESULT_PKG, and IGS_RE_THS_PNL_MR_TP_PKG, and it also references itself. These callers indicate the package is invoked during thesis examination processing, thesis result maintenance, panel member type validation, and admissions-related reconsideration and transfer logic. It is not intended as a standalone business API; customizations should invoke it only indirectly through those higher-level packages, or replicate its table-handler pattern when extending thesis panel functionality. Direct DML against IGS_RE_THS_PNL_MBR should be avoided so that the validation and audit logic in BEFORE_DML and CHECK_CONSTRAINTS is preserved.