Search Results testscore_upd_event

Overview

IGS_AD_WF_001 is a PL/SQL package owned by the APPS schema that serves as the Workflow event integration layer for the Oracle Student System (IGS) admissions module in Oracle E-Business Suite 12.1.1 and 12.2.2. Its principal business function is to raise Oracle Workflow business events from within the admissions data model so that downstream subscribers — notification agents, approval routing, and external integration consumers — can react to changes in applicant, transcript, test score, academic history, and offer status data. The package encapsulates the event-raising logic that would otherwise be scattered across forms, concurrent programs, and database triggers, providing a single controlled entry point for the admissions event model.

Key Procedures and Functions

The documented procedures fall into several functional groups:

• Admissions application events: WF_ADM_ACADEMIC_INDEX, CREATE_APPLICATION_EVENT, 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, WAITLIST_STATUS_UPD_EVENT, and ASSIGN_REQUIRMENT_DONE_EVENT publish events reflecting changes to an application's academic index, completion status, entry qualification, fees, conditional offers, deferrals, waitlist placement, and requirement assignment.
• Transcript and academic history events: TRANSCRIPT_ENTRD_EVENT (the object of the user's search), TRANSCRIPT_UPD_EVENT, ACADHIST_CRT_EVENT, and ACADHIST_UPD_EVENT signal the entry or update of transcript records and the creation or modification of academic history rows.
• Test score and test segment events: TESTSCORE_CRT_EVENT, TESTSEG_CRT_EVENT, TESTSCORE_UPD_EVENT, and TESTSEG_UPD_EVENT raise events when test result headers, test segments, or segment scores are created or amended.
• Fee payment events: FEE_PAYMENT_CRT_EVENT and FEE_PAYMENT_UPD_EVENT publish creation and update events for admissions fee payments.
• Generic event raiser: WF_RAISE_EVENT provides a common internal mechanism used by the specialised procedures to invoke the Workflow Event API with the appropriate event name and payload.

Each procedure accepts identifying keys — typically person, application, transcript, test results, or academic history identifiers — together with old and new values for attributes that changed, enabling subscribers to compare before and after states.

Tables Accessed

The package reads and writes several IGS tables via APPS synonyms. Workflow subscription staging tables such as 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 hold event payloads keyed to the corresponding business event. IGS_AD_ACADINDEX_WF_S captures academic index changes. IGS_AD_APPL_ALL and IGS_AD_BE_PRESUB_APPL_S supply applicant and pre-submission application context. FND_USER and FND_NEW_MESSAGES support notification addressing and message delivery within the Workflow framework.

Usage Notes

IGS_AD_WF_001 is normally invoked indirectly. Admissions forms and concurrent programs call these procedures after committing changes to applicant, transcript, test score, or offer data, so that a corresponding business event is raised only once the transaction is durable. Oracle Workflow subscriptions configured by the institution then consume the events for notifications, approvals, and outbound integrations. Because the package is referenced by 17 other packages, customisations should not alter its public signatures; extensions are better implemented by adding new Workflow subscriptions against the raised events. Direct calls are appropriate in custom PL/SQL only when the caller supplies the correct identifying keys and expects the same event semantics as the standard admissions flows.