Search Results set_eval_sequence

Overview

The IGS_AD_ASSIGN_EVAL_AI_PKG package is an Oracle Applications (APPS) PL/SQL package belonging to the Oracle Student System / Academic institution admissions and evaluation subsystem (the IGS_AD schema family). Its principal business purpose is to manage the assignment of evaluations — such as academic credential assessments, applicant ratings, and admission evaluation records — to applicant instances and applicant evaluation records. In the admissions and recruitment lifecycle, an application submitted by a prospective student must be evaluated by one or more evaluators according to configured rules. This package provides the programmatic engine that determines which evaluations apply, links them to the correct applicant instance and evaluation records, establishes evaluation sequencing, computes related rating statistics, and drives the workflow event that notifies evaluators of their assignments. The package is classified as a public API ("API classification: OTHER") and is a VALID object in the APPS schema on both Oracle EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The ETRM metadata documents seven callable units within this package:

• ASSIGN_EVAL_TO_APPL_INST — Assigns one or more evaluations to a specific applicant instance, initiating the evaluation relationship at the applicant-instance level.
• ASSIGN_EVAL_TO_AI — Assigns an evaluation to an applicant (or applicant instance) record, operating at a narrower granularity than the preceding procedure. This is the core assignment routine driving record creation.
• WF_INFORM_EVALUATOR_APPL — Raises or dispatches the workflow notification informing an evaluator that an application has been assigned to them for review.
• RULE_FUNCTION — Exposes assignment or evaluation logic in a form consumable by Oracle Workflow / rule-based evaluation engines.
• CALC_RATSTAT — Calculates rating statistics associated with the applicant ratings and evaluation results.
• SET_DNS_IND — Sets the "DNS" (do-not-something / decision or notification status) indicator flag on the relevant evaluation or applicant record.
• SET_EVAL_SEQUENCE — Establishes or updates the sequence ordering in which evaluations are to be performed.

Tables Accessed

The package operates across a family of IGS_AD tables accessed via APPS synonyms, including:

• IGS_AD_APPL_EVAL — the core applicant evaluation record.
• IGS_AD_PS_APPL_INST_ALL — applicant instance data (the person/application instance).
• IGS_AD_APL_REV_PRF_ALL, IGS_AD_APL_RPRF_RGR — applicant review profile and profile group configuration.
• IGS_AD_APL_RVPF_RSL, IGS_AD_APPL_ARP — review profile results and applicant admission/rating points.
• IGS_AD_APPL_EVAL_S, IGS_AD_WF_EVAL_S — evaluation and workflow evaluation staging/sequence tables.
• IGS_AD_OU_STAT, IGS_AD_RVGR_EVALTR — organizational unit status and reviewer/evaluator relationships.
• DUAL, PLITBLM — utility objects (single-row selection and PL/SQL index-by table support).

These tables support reading applicant configuration, writing assignment and evaluation records, and computing rating statistics.

Usage Notes

IGS_AD_ASSIGN_EVAL_AI_PKG is referenced by IGS_AD_APPL_EVAL_PKG and IGS_RATINGS_PUB, indicating it is typically invoked indirectly from the applicant evaluation package and the ratings public API rather than called directly by end users. It is also self-referencing. It depends on WF_EVENT_T, confirming integration with Oracle Workflow for evaluator notification. In practice it is invoked during admission processing — for example when an application is submitted or an evaluation cycle is initiated — often triggered from Student System forms, concurrent programs, or workflow background processes. Customizations should call it only through the documented entry points and should not modify its underlying tables directly.