Search Results igs_ad_appl_eval_pkg




Overview
Explore in AI Chat

Overview

IGS_AD_APPL_EVAL_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the Other API category within the Student System (IGS) product family. It encapsulates the business logic for creating, maintaining, and validating records in the applicant evaluation entity, which stores the outcomes of academic evaluations performed against admissions applications. In Oracle EBS 12.1.1 and 12.2.2, this package acts as the primary programmatic gateway to the IGS_AD_APPL_EVAL base table and its corresponding sequence and intersection entities, shielding calling modules from direct DML against those objects. The package status is documented as VALID and it is referenced by seven other packages, which confirms its role as a shared, foundational component within the admissions evaluation subsystem rather than an end-user facing construct. Its documented interface includes eighteen procedures and functions spanning row maintenance, foreign key retrieval, constraint checking, workflow validation, and evaluation sequencing.

Key Procedures and Functions

The package exposes a conventional table handler interface for the evaluation entity. INSERT_ROW, UPDATE_ROW, ADD_ROW, and DELETE_ROW provide the standard Create, Update, and Delete operations, with ADD_ROW serving as the higher-level entry point that orchestrates insertion logic. LOCK_ROW performs pessimistic locking of a target row to serialize concurrent modifications. BEFORE_DML and AFTER_DML implement the pre- and post-processing hooks that enforce derived column values and integrity rules during insert, update, and delete operations.

Tables Accessed

The package operates against five documented base and intersection tables accessed through APPS synonyms. IGS_AD_APPL_EVAL is the primary entity holding evaluation records, while IGS_AD_APPL_EVAL_S provides the corresponding sequence for surrogate key generation. IGS_AD_PS_APPL_INST_ALL links evaluations to application instances, and IGS_AD_APPL_ARP associates them with application rating plans. IGS_AD_APL_REV_PRF_ALL supplies admission review profile context used during validation and sequencing. All access is performed under APPS privileges.

Usage Notes

IGS_AD_APPL_EVAL_PKG is not intended for direct invocation by end users. It is called by dependent packages including IGS_AD_ASSIGN_EVAL_AI_PKG, IGS_AD_CODE_CLASSES_PKG, IGS_AD_INT_RECONSIDER, IGS_AD_PS_APPL_INST_PKG, IGS_AD_RS_VALUES_PKG, IGS_AD_VAL_ACAI_FTR_OFFER, and IGS_RATINGS_PUB. These callers drive it from admissions forms, workflow processes, and concurrent evaluation programs. Customizations should invoke the package rather than issuing DML against the underlying tables, preserving the constraint checks and workflow notifications implemented in the Before and After DML hooks. Because the documented metadata does not disclose parameter signatures, implementers should reference the deployed package specification in the target environment before coding calls.