Search Results admp_get_short_dt

Overview

IGS_AD_GEN_008 is a PL/SQL package in the APPS schema belonging to the Oracle Student System (formerly Oracle iRecruitment/Admissions) module of Oracle E-Business Suite. It is classified as an OTHER API in the ETRM metadata for release 12.1.1 and remains present in 12.2.2. The package is declared AUTHID CURRENT_USER, meaning its SQL statements execute with the privileges of the calling user rather than the package owner, and it is intended to be invoked in the context of the APPS schema where the relevant synonyms exist.

The package supplies reusable lookup and conversion utilities used throughout the admissions and academic calendar subsystems. Its core purpose is to translate short internal status codes into their descriptive equivalents for administrative fee status, deferred admission offer status, offer response status, admission outcome status, and academic unit outcome status. In addition, it retrieves short date representations for calendar instances and evaluates status rules governing correspondence generation. The documented header carries the revision marker $Header: IGSAD08S.pls 115.6 2002/11/28, indicating the source is a long-standing component of the Student System data model.

Key Procedures and Functions

The package exposes nine documented program units:

• ADMP_GET_SAFS — Returns a descriptive string for a supplied admission fee status code, resolving values held in the administrative fee status reference table.
• ADMP_GET_SAODS — Returns a descriptive string for a supplied admission offer deferred status code. This is the function targeted by the search term admp_get_saods.
• ADMP_GET_SAORS — Returns a descriptive string for an admission offer response status code.
• ADMP_GET_SAOS — Returns a descriptive string for an admission outcome status code. It carries the PRAGMA RESTRICT_REFERENCES (Admp_Get_Saos, WNDS, WNPS) declaration, confirming it performs no writes to database state or package state.
• ADMP_GET_SAUOS — Returns a descriptive string for an academic unit outcome status code, drawn from the unit outcome status reference data.
• ADMP_GET_SHORT_DT — Accepts an admission calendar type and calendar instance sequence number and returns a DATE, providing the short-form date associated with that calendar instance.
• ADMP_GET_STATUS_RULE — Evaluates a status rule for a given person, correspondence type, application number, nominated course, admission calendar instance sequence and letter parameter type, returning the applicable status string. It is used to determine whether a specific piece of correspondence should be generated.
• ADMP_GET_SYS_AAS — Returns a descriptive string for a system-level admission application status code.
• GET_ACAD_CAL — A procedure that resolves the academic calendar type and sequence corresponding to a given admission calendar type and sequence. It accepts the admission calendar type, admission sequence, admission alternate code and a message parameter as IN OUT/OUT NOCOPY arguments and returns the derived academic calendar type and sequence together with the alternate code and any diagnostic message.

Tables Accessed

The package reads from reference and transactional tables in the Student System schema via APPS synonyms. Status lookup functions draw on IGS_AD_FEE_STAT, IGS_AD_OFRDFRMT_STAT, IGS_AD_OFR_RESP_STAT, IGS_AD_OU_STAT, IGS_AD_UNIT_OU_STAT, IGS_AD_APPL_STAT and IGS_CA_STAT. Calendar resolution and short-date logic rely on IGS_CA_TYPE, IGS_CA_INST_REL and IGS_AD_CAL_CONF, the admissions calendar configuration table. The status-rule evaluation additionally depends on admission application and correspondence data, consistent with the documented parameters referencing person, application number and letter parameter type. All access is read-only in the documented interface; the restrictive pragma on ADMP_GET_SAOS confirms no data modification occurs.

Usage Notes

IGS_AD_GEN_008 is referenced by 31 other packages, indicating it is a low-level utility layer rather than an entry point for end-user transactions. It is typically invoked from admissions and calendar forms, from concurrent programs that process offer, outcome and correspondence logic, and from custom extensions that need to render human-readable status descriptions from stored codes. The AUTHID CURRENT_USER declaration means callers must have the appropriate synonyms and grants. Because ADMP_GET_SAOS is declared WNDS/WNPS, it is safe to call from SQL statements, including SELECT lists and function-based expressions, subject to the usual purity constraints. Developers referencing admp_get_saods should treat it as a scalar conversion function that returns a VARCHAR2 description for a deferred admission offer status code and should not expect it to perform validation or raise application errors for unrecognised input.