Results for “igs_re_val_ca”

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

Overview

IGS_RE_VAL_CA 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 (formerly Oracle iLearning/Recruitment & Admissions) product family, as indicated by the IGS prefix and its heavy interaction with candidature, admission, and secondary-school assessment tables. The package provides validation logic for candidate assessment (CA) data and related admissions constructs. Its name suggests a "validation" role focused on the "CA" (Candidate Assessment / Credit Application) domain.

The package is currently VALID and depends only on the SYS.STANDARD package, indicating it is a fairly self-contained validation utility that does not itself depend on other custom or product packages. It is, however, referenced by several other application packages, demonstrating that it sits at the base of the validation layer for admissions and enrolment processing.

Key Procedures and Functions

The ETRM repository documents 11 callable units within IGS_RE_VAL_CA. These include:

• ADMP_VAL_CA_COMM — Validates admission-related candidate assessment comments.
• RESP_VAL_CA_UPD — Validates candidate assessment responses for update operations.
• RESP_VAL_CA_TOPIC — Validates responses at the topic level within candidate assessment.
• RESP_VAL_CA_ACAI — Validates responses tied to ACAI (Admission Candidate Assessment Item) records.
• RESP_VAL_CA_MAXSBMSN — Enforces the maximum submission limit for candidate assessment responses.
• RESP_VAL_CA_MINSBMSN — Enforces the minimum submission limit for candidate assessment responses.
• RESP_VAL_CA_SCA — Validates responses related to Student Candidate Assessment.
• RESP_VAL_CA_ACAI_DEL — Validates deletion of ACAI responses.
• RESP_VAL_CA_SCA_DEL — Validates deletion of SCA responses.
• RESP_VAL_GTCC_CLOSED — Validates GTCC (Grade Transfer / Credit Conversion) closed records.
• RESP_VAL_CA_SCA_ACAI — Validates responses across SCA and ACAI combinations.

No parameter signatures are published in the ETRM metadata; callers should consult the package specification directly. Function names consistently indicate boolean or error-message returns used for pre-commit validation.

Tables Accessed

The package references three application tables via APPS synonyms:

• IGS_AD_OU_STAT — Admissions organizational unit status. Used to validate that the relevant admissions unit is active before allowing CA processing.
• IGS_EN_SPA_AWD_AIM — Enrolment award aim data. Referenced when validating candidate assessment outcomes against award aims.
• IGS_RE_GV_TOA_CLS_CD — Recruitment/entry grade value and transfer of award classification codes. Used in GTCC closed-record validation.

These tables confirm the package's role bridging admissions (AD), enrolment (EN), and recruitment (RE) data.

Usage Notes

IGS_RE_VAL_CA is referenced by five application packages: IGS_AD_PS_APPL_INST_PKG, IGS_AD_VAL_ACAI_STATUS, IGS_EN_SPA_LGCY_PUB, IGS_EN_TRANSFER_APIS, and IGS_RE_CANDIDATURE_PKG, and it references itself (recursive internal calls). This pattern indicates that IGS_RE_VAL_CA is invoked from within admission processing, enrolment transfer APIs, and candidature maintenance routines. It is not normally called directly from Oracle Forms or concurrent programs but is instead embedded as a validation layer invoked by higher-level product APIs. Custom extensions integrating with Oracle Student System admissions or transfer processing may call these validation routines before committing candidate assessment or transfer-of-award data. Because only SYS.STANDARD is a listed dependency, the package is relatively lightweight and safe to call repeatedly during interactive validation.