Search Results adm_offer_response_changed




Overview
Explore in AI Chat

Overview

IGS_AD_OFFRESP_STATUS_WF is an Oracle EBS APPS schema PL/SQL package that supports the workflow-driven processing of offer response statuses within the Oracle Student System (formerly Oracle iLearning/Recruiting) admissions module. It is classified under the ETRM as an "OTHER" API object, indicating that it is not a standard public API but rather an internal workflow integration utility invoked by the admissions subsystem. Its primary business function is to detect and respond to changes in an applicant's offer response status and to expose person-level attributes to the Oracle Workflow engine so that the appropriate notification or downstream process can be triggered. In the admissions lifecycle, once an offer has been extended to an applicant, the applicant's response (acceptance, decline, or conditional response) may change over time. This package provides the programmatic hook that allows those changes to be recognized and communicated through workflow, ensuring that admissions staff and dependent business processes remain synchronized with the applicant's current position.

Key Procedures and Functions

The package exposes three documented entry points. Each serves a distinct role in the offer response workflow:

  • ADM_OFFER_RESPONSE_CHANGED — The principal workflow event handler. It is called when a change to an offer response status has been detected, and it initiates or resumes the relevant workflow process so that notifications, status updates, or subsequent admissions activities can proceed.
  • WF_GET_PERSON_ATTRIBUTES — Retrieves person-related attributes for use by Oracle Workflow. This function supplies the workflow engine with the descriptive data (such as applicant identification details) needed to populate notification messages or to satisfy workflow attribute requirements.
  • CHECK_SINGLE_RESPONSE — Performs a validation that determines whether a single, unambiguous offer response exists for the applicant. This guards against ambiguous or multiple-response scenarios before the workflow takes action.

The documented metadata does not specify parameter lists for these routines; consumers should therefore treat them as internal workflow interfaces and avoid direct invocation from custom code.

Tables Accessed

The package reads and writes several core Student System tables through APPS synonyms:

  • IGS_AD_PS_APPL_INST_ALL — The applicant instance table, holding the admissions application instance records that anchor the offer response data.
  • IGS_AD_APPL_ALL — The base application table, providing applicant and application-level context.
  • IGS_AD_OFFRESP_STAT_WF_S — The offer response status workflow staging table, used to track workflow-relevant response state.
  • IGS_AD_PRD_AD_PRC_CA — The admissions process calendar/configuration table, consulted for process timing and validation.
  • FND_USER — The EBS application user table, used for responsibility or user context.
  • DUAL and PLITBLM — Standard utility objects used for scalar evaluation and PL/SQL table operations.

Usage Notes

IGS_AD_OFFRESP_STATUS_WF is an internal workflow integration package. It is referenced by IGS_AD_PS_APPL_INST_PKG, which invokes it as part of the offer response processing chain. It is not intended for direct invocation by forms, concurrent programs, or custom extensions. Administrators troubleshooting offer-response notifications should examine this package alongside its caller, IGS_AD_PS_APPL_INST_PKG, and verify that the underlying IGS_AD_OFFRESP_STAT_WF_S records are being populated correctly. Any modification should be performed only by Oracle Support, as the package is a delivered, VALID object within the APPS schema.