Search Results admp_get_sys_acos

Overview

The APPS.IGS_AD_GEN_009 package is a PL/SQL utility package within the Oracle E-Business Suite (EBS) product family generically known as the Oracle Student System / Admissions (IGS) modules. It is declared with AUTHID CURRENT_USER, meaning its database procedures execute with the privileges of the invoking user rather than the package owner, which is consistent with a shared lookup and code-translation helper maintained centrally under the APPS schema.

The business purpose of the package is to resolve stored system status codes for admissions-related entities into their human-readable or presentation values. Each function accepts a single incoming system status code (for example, an offer status or a fee status) and returns a corresponding descriptive value as a VARCHAR2. In practice this package acts as a decode layer that shields calling forms, concurrent programs, and other packages from embedding hard-coded status translations. By centralising this logic, Oracle ensures that changes to the meaning or display of an admissions status code are applied uniformly across all consumers of the package.

Key Procedures and Functions

The package exposes eight documented functions, all of which follow the same descriptive pattern:

• ADMP_GET_SYS_ACOS — returns the system status description for an admissions conditional offer status.
• ADMP_GET_SYS_ADS — returns the system status description for an admissions document status.
• ADMP_GET_SYS_AEQS — returns the system status description for an admissions entry qualification status.
• ADMP_GET_SYS_AFS — returns the system status description for an admissions fee status.
• ADMP_GET_SYS_AODS — returns the system status description for an admissions offer deferment status.
• ADMP_GET_SYS_AORS — returns the system status description for an admissions offer response status.
• ADMP_GET_SYS_AOS — returns the system status description for an admissions outcome status.
• ADMP_GET_SYS_AUOS — returns the system status description for an admissions outcome status (unit-offer variant).

Each function takes a single status input parameter and returns a VARCHAR2 result. The naming convention "ADMP_GET_SYS_..." indicates an Admissions (ADM) system-level getter. No procedures are documented; the package is purely a set of scalar functions.

Tables Accessed

The functions resolve their return values from admissions status reference tables reached through APPS synonyms. Documented tables include 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. Each table holds the code-to-description mapping for the corresponding admissions status domain, and the package performs lookup reads against these tables, returning the descriptive column for the supplied code. These are read-only reference accesses.

Usage Notes

The package is classified as API classification OTHER and is referenced by at least twenty other packages, indicating it is a widely reused internal helper. It is typically invoked from admissions enquiry and maintenance forms, from concurrent programs that produce status listings or validation output, and from custom extensions that must display an admissions status in a friendly form rather than as a raw code. Because the functions are deterministic lookups with no DML, callers can safely invoke them in SELECT statements and PL/SQL expressions. Developers extending Admissions functionality should call these functions rather than querying the underlying IGS_AD_* status tables directly, preserving consistent translations and insulating custom code from future reference-data changes.