Search Results admp_get_sys_aods

Overview

IGS_AD_GEN_009 is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM "OTHER" API category. It belongs to the Oracle Student System (formerly Oracle Advanced Education/Recruitment) module, as indicated by the IGS_AD prefix designating Admissions functionality. The package is declared with AUTHID CURRENT_USER, meaning its procedures execute with the privileges of the invoking schema rather than the package owner, which is standard practice for utility packages that must respect the caller's security context.

Functionally, IGS_AD_GEN_009 is a status translation utility. Each of its eight functions accepts an internal admissions status code and returns a system-defined value (a description or lookup result) for that code. The "SYS" component in each function name (Admp_Get_Sys_*) reflects this purpose: converting stored status codes into human-readable or system-standard representations used throughout Admissions screens and reports. The package version header (115.3, dated 2002) indicates it is a long-standing component of the Student System data model, and it is referenced by 20 other packages, confirming its role as a shared foundational utility rather than an application entry point.

Key Procedures and Functions

The package exposes eight functions, each targeting a distinct Admissions status domain:

• Admp_Get_Sys_Acos — resolves conditional offer status codes.
• Admp_Get_Sys_Ads — resolves admission document status codes.
• Admp_Get_Sys_Aeqs — resolves admission entry qualification status codes.
• Admp_Get_Sys_Afs — resolves admission fee status codes.
• Admp_Get_Sys_Aods — resolves admission offer deferment status codes. This is the function associated with the search term "admp_get_sys_aods."
• Admp_Get_Sys_Aors — resolves admission offer response status codes.
• Admp_Get_Sys_Aos — resolves admission outcome status codes.
• Admp_Get_Sys_Auos — resolves admission outcome status codes, operating against the unit/offering-level outcome status table rather than the general outcome table.

Each function takes a single IN VARCHAR2 parameter representing the stored status code and returns the resolved system status as VARCHAR2. The metadata does not document the internal lookup mechanism, but the pattern is consistent across all eight functions.

Tables Accessed

Each function correlates to a corresponding Admissions status table accessed through APPS synonyms:

• IGS_AD_OFRDFRMT_STAT — offer deferment status (Admp_Get_Sys_Aods).
• IGS_AD_CNDNL_OFRSTAT — conditional offer status (Admp_Get_Sys_Acos).
• IGS_AD_DOC_STAT — document status (Admp_Get_Sys_Ads).
• IGS_AD_ENT_QF_STAT — entry qualification status (Admp_Get_Sys_Aeqs).
• IGS_AD_FEE_STAT — fee status (Admp_Get_Sys_Afs).
• IGS_AD_OFR_RESP_STAT — offer response status (Admp_Get_Sys_Aors).
• IGS_AD_OU_STAT — outcome status (Admp_Get_Sys_Aos).
• IGS_AD_UNIT_OU_STAT — unit-level outcome status (Admp_Get_Sys_Auos).

These are seeded setup/lookup tables holding valid status values for each admissions processing stage. The package reads them to validate and translate the incoming code.

Usage Notes

Because IGS_AD_GEN_009 is referenced by 20 other packages, it is normally consumed indirectly rather than called directly by end users. Typical invocations include Admissions inquiry and maintenance forms that display translated status text, concurrent programs generating admissions correspondence or reports, and custom extensions requiring consistent status description resolution. Developers extending the Student System should call these functions rather than querying the status tables directly, ensuring consistency with delivered behavior. Note that these functions validate and translate codes; they do not update recruitment or admissions data. The package exists in both EBS 12.1.1 and 12.2.2 with no documented interface changes, and the dated header confirms compatibility across releases.