Results for “igs_re_val_the”

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

Overview

IGS_RE_VAL_THE is an Oracle EBS APPS schema PL/SQL package belonging to the Oracle Student System (formerly Oracle iLearning/Student Information) research and thesis management module. The package name indicates its role as a validation package ("VAL") governing the "THE" (thesis) entity within the IGS_RE (Research) product family. It is registered with an API classification of OTHER, meaning it is not exposed as a formally supported public API but is instead an internal validation engine consumed by higher-level thesis and supervisor packages.

In the context of Oracle EBS 12.1.1 and 12.2.2, this package underpins the integrity of thesis candidature records. It enforces institutional business rules around thesis submission milestones, expected submission dates, embargo handling, library deposit, final submission, and the evaluation of minimum subsidiary submission dates. It also provides duplicate thesis detection and candidate detail retrieval, both of which are essential to prevent conflicting thesis registrations for the same candidate or research program.

Key Procedures and Functions

The package exposes thirteen documented procedures and functions. Their purposes are as follows:

• RESP_VAL_THE_CTN — Validates the content of a thesis record, ensuring required attributes are populated and consistent before the record is accepted or persisted.
• RESP_VAL_THE_DEL_DT — Validates thesis deletion date logic, governing when a thesis record may be removed or marked as deleted.
• RESP_VAL_THE_EXPCT — Validates the expected submission date of a thesis against institutional rules and the candidate's candidature timeline.
• RESP_VAL_THE_EMBRG — Validates embargo conditions applied to a thesis, controlling restricted access periods.
• RESP_VAL_THE_DEL — Performs validation associated with the deletion of a thesis record.
• RESP_VAL_THE_LBRY — Validates library deposit details for a thesis, ensuring deposit requirements are met.
• RESP_VAL_THE_THR — Validates thesis threshold conditions, such as milestone or progress thresholds tied to the thesis lifecycle.
• RESP_VAL_THE_UPD — Validates update operations applied to an existing thesis record.
• RESP_VAL_THE_TTL — Validates the thesis title, including format, length, and business constraints.
• RESP_VAL_THE_FNL — Validates final thesis submission, confirming that all prerequisite conditions have been satisfied.
• GET_CANDIDACY_DTLS — Retrieves candidature details for a given thesis or candidate, supporting downstream processing and validation.
• CHECK_DUP_THESIS — Detects duplicate thesis records, preventing conflicting registrations.
• EVAL_MIN_SUB_DT — Evaluates the minimum submission date, used to determine the earliest permissible submission for a thesis.

Tables Accessed

The package operates against three documented APPS synonym tables. IGS_RE_CANDIDATURE_ALL stores candidature records for research students and is read to establish the candidate's registration context for date and eligibility validations. IGS_RE_THESIS_ALL is the primary thesis master table, holding title, submission, embargo, and library deposit attributes that the validation routines inspect and cross-check. IGS_RE_THESIS_EXAM holds thesis examination records, supporting validation logic related to examination status and final submission eligibility. Together these tables provide the data foundation for all content, date, and duplicate checks performed by the package.

Usage Notes

IGS_RE_VAL_THE is an internal validation package rather than a standalone business API. It is invoked indirectly by three higher-level APPS packages: IGS_RE_SPRVSR_LGCY_PUB, IGS_RE_THESIS_PKG, and IGS_RE_THE_LGCY_PUB. These callers execute the validation routines during thesis creation, maintenance, submission, and deletion flows, typically triggered from the Oracle Student System thesis maintenance forms or legacy public wrappers. Because the package is classified as OTHER and is self-referenced, customizations should avoid direct invocation and instead use the supported public packages that wrap it. Customers extending thesis validation logic should treat IGS_RE_VAL_THE as a read-mostly engine whose routines depend on the state of IGS_RE_CANDIDATURE_ALL, IGS_RE_THESIS_ALL, and IGS_RE_THESIS_EXAM, and should validate any changes against the documented dependency chain before deployment in 12.1.1 or 12.2.2 environments.