Search Results resp_ins_tpm_tri

Overview

IGS_RE_GEN_003 is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the Oracle Student System (formerly Oracle Higher Education) product family. The IGS_RE prefix identifies it as belonging to the Research and Research Outputs module of the student system, which supports institutions in tracking research supervision, thesis and dissertation processing, and examination panel administration. The package name contains the suffix GEN, indicating that it functions as a general-purpose utility package whose routines are consumed horizontally by multiple business-level packages rather than being exposed directly to end users.

The documented status of the object is VALID, and its dependency footprint confirms that it operates as a low-level service layer: it references only SYS.STANDARD at the database level, meaning it relies on no other application packages, while it is referenced by several higher-level research packages. This inverted dependency profile is characteristic of a packages designed to centralize history and status-transition logic so that the calling packages remain free of duplicated insert logic.

Key Procedures and Functions

The ETRM metadata documents six procedures, all of which follow a consistent naming convention indicating their role as history and transition record-insertion routines:

• RESP_INS_MIL_HIST — inserts milestone history records for research supervision activity, capturing the progression of a supervisor or student through defined research milestones.
• RESP_INS_TEX_HIST — inserts thesis history records, recording the state changes that occur across the thesis lifecycle.
• RESP_INS_TEX_TRI — inserts thesis transition records, documenting the movement of a thesis from one workflow step or status to the next.
• RESP_INS_THE_HIST — inserts thesis examination history records, preserving the audit trail of examination-related state changes.
• RESP_INS_TPM_HIST — inserts thesis panel member history records, tracking the composition and status of examination panels over time.
• RESP_INS_TPM_TRI — inserts thesis panel member transition records, capturing individual panel member movement through the examination workflow.

All six routines are insert-oriented; none of the documented names suggest query, update, or delete behavior. No parameter lists are documented and none are inferred here.

Tables Accessed

The package accesses the following tables through APPS synonyms, which is standard practice for seeded Oracle EBS code:

• IGS_RE_SPRVSR and IGS_RE_SPRVSR_TYPE — supervisor details and supervisor type definitions, needed to attribute milestone history to the correct supervisor and classification.
• IGS_RE_THESIS_EXAM — the thesis examination entity, referenced when writing examination history and thesis transition records.
• IGS_RE_THS_PNL_MBR and IGS_RE_THS_PNL_TYPE — thesis panel member and panel type data, used for panel member history and transition inserts.
• IGS_TR_STATUS and IGS_TR_STEP — the shared status and workflow step reference tables, used to resolve the from/to state values recorded in every history and transition row.
• FND_USER — the Oracle Application Object Library user table, used to stamp the operating user on audit rows.

Usage Notes

IGS_RE_GEN_003 is not intended to be invoked from a form or concurrent program directly. It is called by the four packages documented as referencing it: IGS_PR_MILESTONE_PKG, IGS_RE_THESIS_PKG, IGS_RE_THESIS_EXAM_PKG, and IGS_RE_THS_PNL_MBR_PKG. These parent packages handle the transaction and validation logic exposed through the Research Tracking and Thesis Management windows, and they delegate the audit-trail writes to IGS_RE_GEN_003. Customizations and extensions should treat this package as an internal API: it is safe to call the documented insert routines from custom PL/SQL that manipulates research history, but direct updates to the underlying IGS_RE and IGS_TR tables should be avoided to preserve the integrity of the transition and status records this package produces.