Search Results admp_upd_acai_comm




Overview
Explore in AI Chat

Overview

IGS_AD_GEN_012 is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the Student System (IGS) product family and specifically associated with the Admissions (AD) module. The package is documented as VALID in ETRM for both 12.1.1 and 12.2.2, indicating it remains an active and compiled object across the two release lines. Its API classification is recorded as OTHER, meaning it is not published as a formal public API but instead functions as an internal utility package invoked by other Admissions components.

The naming pattern (IGS_AD_GEN_012) indicates this is one of a series of generated Admissions packages that consolidate update logic and status queries used during application processing, offer management, and admissions decision handling. Its procedures are oriented around updating applicant and admissions calendar/offer status records, while a small number of getter and lookup functions supply code values back to callers.

Key Procedures and Functions

The documented interface exposes eight procedures and functions:

  • ADMP_UPD_ACAI_COMM — Updates admissions calendar/application-instance records relating to a committed (offered or accepted) status.
  • ADMP_UPD_ACAI_DEFER — Handles the deferred status path, updating the corresponding admissions application instance records when an applicant defers.
  • ADMP_UPD_ACAI_LAPSED — Processes the lapsed status path, marking application instances that have timed out or expired.
  • ADMP_UPD_ACAI_RECON — Supports reconciliation updates, aligning admissions application instance data with downstream status changes.
  • ADMP_UPD_ADM_PP — Updates admissions-related person preferences for the applicant record.
  • ADMP_UPD_ENQ_PP — Updates enquiry-related person preferences, parallel to the admissions preference update above.
  • ADMS_GET_ACAIU_UV — Retrieval function returning a value associated with an admissions application instance (UV denotes a utility/value return).
  • RET_GROUP_CD — Returns a group code value used in status or grouping logic within the Admissions flow.

No parameter signatures are documented in ETRM; callers should inspect the package specification through the Application Object Library or an IDE to confirm exact argument lists before invoking these routines.

Tables Accessed

The package references seven tables through APPS synonyms, reflecting its focus on Admissions status configuration and person preferences:

  • IGS_AD_CAL_CONF — Admissions calendar configuration, providing the calendar context for status updates.
  • IGS_AD_CNDNL_OFRSTAT — Conditional offer status codes used when evaluating offer outcomes.
  • IGS_AD_FEE_STAT — Fee status values that influence whether an application can progress.
  • IGS_AD_OFR_RESP_STAT — Offer response status codes, central to accept, defer, and lapse processing.
  • IGS_AD_OU_STAT — Organizational unit status codes linked to the offering unit.
  • IGS_AD_PRD_AD_PRC_CA — Program admissions process calendar association, tying programs to admissions cycles.
  • IGS_PE_PERS_PREFS_ALL — Person preferences, updated by the ADMP_UPD_ADM_PP and ADMP_UPD_ENQ_PP routines.

Usage Notes

IGS_AD_GEN_012 is not intended for direct end-user invocation. It is referenced by IGR_GEN_001, indicating it is called from the Student System Admissions forms and related concurrent or event-driven processes. Typical invocation occurs when an applicant's offer response (accept, decline, defer, or lapse) is recorded, triggering the corresponding ADMP_UPD_ACAI_* routine to synchronize application instance status. The ADMP_UPD_ADM_PP and ADMP_UPD_ENQ_PP procedures are similarly invoked during preference capture within admissions and enquiry workflows.

Because the package carries an OTHER classification and lacks a published API contract, customizations should wrap these routines rather than modify them, and any extensions should be validated against the 12.1.1 and 12.2.2 release levels. Where possible, invoke the parent forms or standard processes rather than calling the procedures directly to preserve upgrade safety.