Search Results igs_ad_wf_eval_s

Overview

The APPS.IGS_AD_ASSIGN_EVAL_AI_PKG package body is a component of the Oracle E-Business Suite student systems module (IGS), specifically within the Admissions (AD) product family. Its primary business purpose is to automate the assignment of evaluations to applicant assignment instances during the admissions lifecycle. In an academic institution's admissions process, applicants are frequently required to complete evaluations — such as academic credential reviews, English proficiency assessments, or interview-based evaluations — before an admission decision can be rendered. This package orchestrates that assignment logic, including the routing of evaluator assignments, the calculation of evaluation routing statistics, and the generation of workflow notifications to evaluators.

The package operates in the Oracle EBS 12.1.1 and 12.2.2 environments and is owned by the APPS schema, a standard convention for shared application-level PL/SQL objects. Its status is VALID, indicating it is properly compiled and available for use. The metadata classifies this object as an "OTHER" API, meaning it is not exposed as an open interface or public API but rather serves internal operational processing.

Key Procedures and Functions

The documented package exposes seven procedures and functions. Their names indicate the following purposes:

• ASSIGN_EVAL_TO_APPL_INST — Assigns an evaluation to a specific applicant instance. This is the core routine for linking an evaluation record to an admission applicant instance.
• ASSIGN_EVAL_TO_AI — A related routine that assigns an evaluation to an applicant assignment (AI) record, likely handling the assignment-level granularity of the same evaluation assignment process.
• WF_INFORM_EVALUATOR_APPL — Generates a workflow notification to inform an evaluator about an assigned applicant. This integrates with the Oracle Workflow engine (WF_EVENT, WF_DIRECTORY, WF_RULE).
• RULE_FUNCTION — A workflow rule function, typically used as a conditional predicate within a workflow process to govern branching or evaluation assignment decisions.
• CALC_RATSTAT — Calculates evaluation routing statistics, likely aggregating assignment counts or completion ratios for evaluation routing decisions.
• SET_DNS_IND — Sets a "Do Not Show" or similar indicator flag, controlling display suppression on related applicant assignment records.
• SET_EVAL_SEQUENCE — Establishes or updates the sequence ordering for evaluations, ensuring evaluations are processed or presented in the correct order.

Tables Accessed

The package references a broad set of admissions tables through APPS synonyms, including IGS_AD_APPL_EVAL (evaluation records), IGS_AD_PS_APPL_INST_ALL (applicant instances), IGS_AD_APL_REV_PRF_ALL, IGS_AD_APL_RPRF_RGR, and IGS_AD_APL_RVPF_RSL (reviewer profile and rule-related data), IGS_AD_APPL_ARP (applicant review profile), IGS_AD_OU_STAT (organizational unit status), IGS_AD_RVGR_EVALTR (evaluator-to-evaluation routing), and IGS_AD_WF_EVAL_S (workflow evaluation sequence). It also interfaces with the IGS_AD_APPL_EVAL_PKG package and the IGS_AD_APPL_EVAL_S/V views, and uses standard Oracle infrastructure objects such as DUAL, PLITBLM, FND_FILE, FND_MESSAGE, APP_EXCEPTION, and IGS_GE_MSG_STACK for message handling and logging.

Usage Notes

Because this package is not referenced by any database object (per the dependency data) except its own internal code and it is referenced by two other packages, it is typically invoked indirectly. It is most likely called from concurrent programs, Oracle Forms events within the Admissions module, or workflow processes triggered when an applicant instance reaches a predefined evaluation stage. The WF_INFORM_EVALUATOR_APPL and RULE_FUNCTION routines strongly suggest integration with Oracle Workflow, where the package may be called by workflow activities to notify evaluators and evaluate routing rules. Developers extending evaluation assignment logic would invoke the ASSIGN_EVAL_TO_APPL_INST or ASSIGN_EVAL_TO_AI routines, while the SET_* routines are invoked to maintain indicator and sequence state during assignment processing.