Results for “igs_ad_val_aors”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_AD_VAL_AORS is an Oracle E-Business Suite PL/SQL validation package body owned by the APPS schema and classified by ETRM as an "OTHER" API. The name decomposes into the IGS (Student System / Oracle Student System) product prefix, the AD (Admissions) module identifier, and the VAL (validation) and AORS (Applicant Offer Response / Admissions Offer Response) functional tokens. The package therefore supplies server-side validation logic for the Admissions offer-response subsystem, ensuring that an applicant's response to an institution offer of admission (acceptance, decline, deferral, and related statuses) is consistent with institutional rules before it is committed.

The object is documented as VALID in the ETRM 12.1.1 metadata and is not referenced by any other database object; only one other package references it. It is an internal helper package rather than a public integration API, so it is expected to be called from the Admissions forms and from other IGS_AD packages rather than directly from external interfaces.

Key Procedures and Functions

Two documented procedures are exposed by the package:

• ADMP_VAL_SAORS_CLSD — Validates the closed-record condition for the offer-response status. It confirms that a response or status change is not being applied to a record that has already been administratively closed, thereby preventing illegal updates to finalized admissions decisions.
• ADMP_VAL_AORS_DFLT — Validates default/derived values for the admissions offer-response record, ensuring that defaulted statuses, lookup values, and response codes conform to the expected configuration before the record is saved.

No parameter lists are documented in the ETRM extract, and none are asserted here. Each procedure follows the package's uniform error-handling convention of raising failures through the shared IGS message stack rather than returning boolean status codes.

Tables Accessed

The single documented table referenced through APPS synonyms is IGS_AD_OFR_RESP_STAT, which stores offer-response status information for admissions applicants. The validation procedures read this table to confirm the current status of an offer-response row, to determine whether the record is already closed, and to resolve the valid default status values applicable to the record. No inserts or updates to the table are documented from this package; it functions as a read-oriented validation layer preceding DML performed by the calling Admissions logic.

Usage Notes

This package is invoked when a user or process creates or modifies an admissions offer response — typically from the Admissions inquiry and maintenance forms, and from other IGS_AD packages that handle applicant decisions. Because the object is not referenced by any other database object and is documented as a private validation component, it should be treated as internal to the Student System Admissions module. Customizations should call the public Admissions APIs rather than this package directly. When invoked, the package depends on IGS_AD_OFR_RESP_STAT, IGS_LOOKUP_VALUES, APP_EXCEPTION, FND_MESSAGE, and IGS_GE_MSG_STACK, and it surfaces validation failures through the IGS message stack, which the calling form or concurrent program is responsible for displaying to the user. Because of the dependency on IGS_LOOKUP_VALUES, any change to Admissions lookup configurations can alter the validation outcomes produced by ADMP_VAL_AORS_DFLT.