Search Results admp_val_aa_update

Overview

IGS_AD_VAL_AA is a validation package within the Oracle E-Business Suite Advanced Admissions (Student Systems) module, owned by the APPS schema. Its primary business function is to enforce business rules and data integrity during the processing of applicant admission records, particularly around application status transitions, admission category assignment, academic calendar validation, and admission fee/category checks. The package acts as a centralized validation layer that other Admissions packages and concurrent programs call before committing admission data changes.

IGS_AD_VAL_AA is classified as a standard (non-API) internal validation utility. It operates in both Oracle EBS 12.1.1 and 12.2.2 environments with identical object metadata. The object is marked VALID and depends only on the SYS STANDARD package, indicating it is a pure PL/SQL validation module with no external program unit dependencies beyond the database kernel.

Key Procedures and Functions

• ADMP_VAL_AA_INSERT — Validates data during insertion of a new applicant admission record, ensuring required fields and statuses conform to Admissions rules before the row is created.
• ADMP_VAL_AA_UPDATE — Validates data during updates to an existing applicant admission record.
• ADMP_VAL_AA_DELETE — Validates whether a record may be deleted, checking for dependent data that would prevent removal.
• ADMP_VAL_AA_APPL_DT — Validates the application date against configured admissions calendar rules.
• ADMP_VAL_AA_ACAD_CAL — Validates the academic calendar associated with the admission.
• ADMP_VAL_AA_ADM_CAL — Validates the admission calendar associated with the record.
• ADMP_VAL_AA_ADM_CAT — Validates admission category values against the configured category setup.
• ADMP_VAL_AA_AAS — Validates the applicant admission status value.
• ADMP_VAL_AAS_CLOSED — Determines whether the applicant admission status represents a closed state.
• ADMP_VAL_AA_AFS — Validates the admission fee status.
• ADMP_VAL_AA_TAC_APPL — Validates TAC (Transfer Admission Category / admissions processing) application data.

All 11 subprograms follow the ADMP_VAL_AA* naming convention, confirming this package is a dedicated validation utility used across the Admissions application lifecycle.

Tables Accessed

The package references setup and transaction tables through APPS synonyms, including:

• IGS_AD_APPL_STAT, IGS_AD_CNDNL_OFRSTAT, IGS_AD_FEE_STAT, IGS_AD_OFR_RESP_STAT, IGS_AD_OU_STAT — status lookup and validation tables for application, conditional offer, fee, offer response, and organizational unit statuses.
• IGS_AD_PRD_AD_PRC_CA — links admission periods, admission processing cycles, and calendars.
• IGS_CA_INST_REL, IGS_CA_STAT, IGS_CA_TYPE — calendar instance relation, status, and type definitions used for calendar validation.
• IGS_CO_CAT_MAP, IGS_EN_CAT_MAPPING, IGS_FI_FEE_CAT_MAP — category mapping tables across offerings, enrollments, and finance, supporting category and fee validation.
• IGS_PE_ALT_PERS_ID, IGS_PE_HZ_PARTIES, IGS_PE_PERSON_ID_TYP — person identifiers, party records, and person ID type definitions used to validate applicant identity data.

Usage Notes

IGS_AD_VAL_AA is referenced by seven other packages, including IGS_AD_APPL_PKG, IGS_AD_GEN_012, IGS_AD_GEN_014, IGS_AD_PRC_TAC_OFFER, IGS_AD_PS_APPL_INST_PKG, IGS_AD_SS_APPL_UPD_PAGE, IGS_AD_VAL_ACAI, and its own body. This indicates it is invoked primarily from within Admissions business logic packages, OAF-based self-service pages (IGS_AD_SS_APPL_UPD_PAGE), concurrent generation programs (IGS_AD_GEN_*), and offer-processing routines. Customizations should not modify this package directly; instead, it is called as a validation utility. Direct invocation from custom code is possible but should respect the documented procedure names and use APPS synonyms for table access.