Search Results igs_ad_offresp_stat_wf_s

Overview

The APPS.IGS_AD_OFFRESP_STATUS_WF package body is a workflow-enabled PL/SQL component within the Oracle E-Business Suite (EBS) Advanced Admissions module of the Student System (formerly Oracle Student System, now integrated as part of the higher-education footprint supported in 12.1.1 and 12.2.2). Its principal business function is to manage the status transitions and notification handling associated with applicant offer responses during the admissions lifecycle. In the admissions domain, an "offer" is a provisional admission decision extended to an applicant, and the "offer response" captures the applicant's acceptance or decline of that offer. This package bridges the relational admissions data model with the Oracle Workflow engine, orchestrating how status changes to an offer response propagate into workflow events, attribute resolution, and downstream routing decisions.

The object is marked VALID in the ETRM dictionary and is classified as an OTHER API, indicating it is an internal integration package rather than a public, externally documented API. It is therefore consumed primarily by the admissions workflow infrastructure and related generated or supporting packages rather than by customer-authored code.

Key Procedures and Functions

• ADM_OFFER_RESPONSE_CHANGED — The central handler invoked when an applicant's offer response status changes. It coordinates the workflow event, resolves the person and application context, and drives status-dependent processing.
• WF_GET_PERSON_ATTRIBUTES — A workflow attribute accessor that supplies person-level attributes (resolved through person and user views) to the workflow engine so that notification and routing logic can reference applicant details.
• CHECK_SINGLE_RESPONSE — A validation routine that verifies the response configuration, ensuring that single-response rules are honored before status processing proceeds.

These three documented procedures constitute the functional surface of the package. Each communicates with Oracle Workflow through the WF_CORE, WF_ENGINE, WF_EVENT, and WF_EVENT_T dependencies, passing parameters using WF_PARAMETER_LIST_T.

Tables Accessed

• IGS_AD_APPL_ALL and IGS_AD_APPL — The base admissions application records that anchor an offer and its response.
• IGS_AD_PS_APPL_INST_ALL — Tracks application instances and their status, forming the link between the applicant and program of study.
• IGS_AD_PRD_AD_PRC_CA — The program-to-admission-process configuration, defining which admission processes apply.
• IGS_AD_OFFRESP_STAT_WF_S — The offer response status workflow sequence, which supplies the next status values used during transitions.
• FND_USER — Resolves the Oracle Applications user identity associated with the person for workflow attribution.
• IGS_PE_PERSON_BASE_V — The person base view, providing applicant biographical attributes to workflow.
• DUAL and PLITBLM — Utility references used for PL/SQL table handling and singleton queries.
• IGS_AD_GEN_002, IGS_AD_GEN_008, and IGS_CA_INST — Supporting generation and calendar-instance logic used in admissions processing.

Usage Notes

This package is invoked indirectly through the admissions workflow configuration rather than by end users. Typical invocation occurs when an offer response status is updated — for example, through the admissions forms, a workflow-driven concurrent process, or an event raised by the Workflow Engine. The ADM_OFFER_RESPONSE_CHANGED procedure is the natural entry point, called by workflow event subscriptions or by the forms layer when a user records a response. Because the package is categorized as OTHER and is not referenced by any documented database object, customizations should not call it directly without validating the 12.1.1/12.2.2-specific implementation. The 12.2.x releases share the same 12.1.1 file system data model for the Student System, so behavior is consistent across both releases.