Search Results admp_val_aors_item

Overview

IGS_AD_VAL_ACAI_STATUS is an Oracle EBS 12.1.1 / 12.2.2 PL/SQL validation package owned by the APPS schema in the Student System (IGS) product family, specifically the Admissions (IGS_AD) module. The ACAI component of the name designates Application and Course Application Instance processing. The package encapsulates the business rules that verify the state and consistency of applications, course application instances, and their associated statuses before transactional operations commit.

The package is classified as OTHER, indicating it is an internal validation library rather than a published PL/SQL API. It depends on STANDARD (the SYS standard package) and is surfaced across a broad set of admissions modules. Its reach extends into the public application API and to the internal definition, import, offer, and self-service packages, meaning it is the common validation engine called before status changes are persisted.

Key Procedures and Functions

The package contains 38 documented procedures and functions. They follow a repetitive naming convention that groups validation checks by status type, and can be summarized by family:

• AEQS (Application Entry Qualification Status): ADMP_VAL_ACAI_AEQS, ADMP_VAL_AEQS_ITEM, ADMP_VAL_AEQS_CLOSED, ADMP_VAL_AEQS_AOS. These validate qualification status records and their items, including closure and application-of-study conditions.
• ADS (Admissions Decision Status): ADMP_VAL_ACAI_ADS, ADMP_VAL_ADS_ITEM, ADMP_VAL_ADS_CLOSED, ADMP_VAL_ADS_AOS. These verify decision statuses at the instance and item levels.
• AODS (Application Offer Decision Status): ADMP_VAL_ACAI_AODS, ADMP_VAL_AODS_ITEM, ADMP_VAL_AODS_CLOSED, ADMP_VAL_AODS_AORS. These cover offer decision validations, including associated offer response requirements.
• LAFS (Application Fee Status): ADMP_VAL_ACAI_LAFS, ADMP_VAL_LAFS_ITEM, ADMP_VAL_AFS_CLOSED, ADMP_VAL_LAFS_COO, ADMP_VAL_LAFS_AOS. These validate fee status, fee item closure, and cost-of-offer or application-of-study links.
• AORS (Application Offer Response Status): ADMP_VAL_ACAI_AORS, ADMP_VAL_AORS_ITEM, ADMP_VAL_AORS_CLOSED. These confirm offer response status and its dependent items.

Each family generally exposes a master validation, an item-level check, a closure check, and an association check, providing layered certainty before data is written.

Tables Accessed

Validation is performed against eleven IGS_AD base tables through APPS synonyms, all status-reference tables: IGS_AD_APPL_LTR and IGS_AD_APPL_LTR_PHR (letter templates and phrases), IGS_AD_APPL_STAT, IGS_AD_CNDNL_OFRSTAT, IGS_AD_DOC_STAT, IGS_AD_ENT_QF_STAT, IGS_AD_FEE_STAT, IGS_AD_OFRDFRMT_STAT, IGS_AD_OFR_RESP_STAT, IGS_AD_OU_STAT, and IGS_AD_UNIT_OU_STAT. The package reads these tables to resolve valid status codes and to confirm that a requested status is permissible for the application, offer, or fee context.

Usage Notes

IGS_AD_VAL_ACAI_STATUS is not invoked directly by end users. It is called from forms and concurrent programs through its nine consuming packages, including IGS_ADMAPPLICATION_PUB, IGS_AD_DEF_APPL_PKG, IGS_AD_GEN_013, IGS_AD_IMP_OFF_RESP_DATA, IGS_AD_PRC_TAC_OFFER, IGS_AD_PS_APPL_INST_PKG, IGS_AD_SS_APPL_FEE_PKG, IGS_AD_VAL_AA, and IGS_AD_VAL_ACAI_FTR_OFFER. It also references itself, reflecting internal cross-validation. The presence of IGS_ADMAPPLICATION_PUB confirms the package is part of the sanctioned admissions API call stack, and the self-service package indicates it is exercised during online applicant activity. Customizations that bypass these consuming packages risk committing status values that violate the documented integrity rules, so extensions should ideally route status changes through the public API.