Search Results igs_ad_wf_applcomp_upd_s

Overview

IGS_AD_WF_001 is a Workflow integration package body owned by APPS and classified under the ETRM framework as OTHER. It belongs to the Oracle Advanced Admissions (IGS) product family and resides within the Oracle E-Business Suite 12.1.1 and 12.2.2 installations. Its principal business function is to raise Oracle Workflow business events on behalf of the Advanced Admissions module, so that downstream workflow processes — notifications, approvals, and status-driven routing — are triggered automatically when admissions data changes. The header comment in the source identifies the Financial Aid Integration build and Bug 3202866 as the originating work item, with a creation date of 10-OCT-2003. The package therefore acts as the bridge between transactional admissions tables and the Workflow Event System (WF_EVENT), insulating calling modules from the mechanics of event construction and subscription matching.

Key Procedures and Functions

The package exposes twenty-six documented procedures and functions. The central entry point is WF_ADM_ACADEMIC_INDEX, which accepts a person identifier together with optional admission application number, nominated course code, sequence number, and old and new academic index values before emitting the Academic Index business event. The generic helper WF_RAISE_EVENT performs the actual event-raising call and is reused by the remaining event procedures. The balance of the package consists of purpose-built event procedures, each named for the business occurrence it signals: TRANSCRIPT_ENTRD_EVENT, TRANSCRIPT_UPD_EVENT, TESTSCORE_CRT_EVENT, TESTSCORE_UPD_EVENT, TESTSEG_CRT_EVENT and TESTSEG_UPD_EVENT for test and transcript activity; ACADHIST_CRT_EVENT and ACADHIST_UPD_EVENT for academic history; CREATE_APPLICATION_EVENT and ASSIGN_REQUIRMENT_DONE_EVENT for application lifecycle; and a family of status-change procedures covering APPCOMP_STATUS_UPD_EVENT, ENTRY_QUAL_STATUS_UPD_EVENT, LATE_ADM_FEE_STATUS_UPD_EVENT, COND_OFFER_STATUS_UPD_EVENT, OFFER_DEFER_STATUS_UPD_EVENT and WAITLIST_STATUS_UPD_EVENT. Fee processing is represented by FEE_PAYMENT_CRT_EVENT and FEE_PAYMENT_UPD_EVENT. Each procedure marshals its business keys into a workflow parameter list and delegates to WF_RAISE_EVENT.

Tables Accessed

The documented table references fall into three groups. Configuration and identity data are read from FND_NEW_MESSAGES and FND_USER; the latter supplies the user name used as the workflow role when the event is raised. Transactional admissions data is resolved through APPS synonyms including IGS_AD_APPL_ALL and IGS_AD_BE_PRESUB_APPL_S, providing the application identifiers carried in the event payload. Sequence generators — IGS_AD_ACADINDEX_WF_S, IGS_AD_WF_ACADHIST_CRT_S, IGS_AD_WF_ACADHIST_UPD_S, IGS_AD_WF_APPLCOMP_UPD_S, IGS_AD_WF_APP_INST_STAT_UPD_S, IGS_AD_WF_APP_PROC_STAT_UPD_S, IGS_AD_WF_APP_QUAL_CODE_S, IGS_AD_WF_APP_RECONS_REQ_S, IGS_AD_WF_ASSREQ_S, IGS_AD_WF_CNDOFFER_UPD_S and IGS_AD_WF_CRT_APPL_S — are used to obtain the unique event keys required by the Workflow Event System. The source also referenced the profile option IGS_WF_ENABLE through FND_PROFILE.VALUE, which gates whether event raising proceeds at all.

Usage Notes

The package is designed to be invoked by other Advanced Admissions PL/SQL modules rather than directly by end users. ETRM records 17 other packages referencing it, confirming its role as a shared integration utility. Calls are typically embedded in the insert, update and status-change logic of admissions forms and business APIs so that a Workflow event is raised as an immediate side effect of the data change. Because event creation depends on the IGS_WF_ENABLE profile option, administrators control activation at the environment level. Any custom code that manipulates admissions transcript, test score, application, offer, waitlist or fee records should invoke the corresponding procedure to preserve downstream workflow consistency.