Search Results igs_ps_wf_event_pkg




Overview
Explore in AI Chat

Overview

The package body APPS.IGS_PS_WF_EVENT_PKG belongs to the Oracle EBS Student System (IGS) product family and provides the workflow event integration layer for the faculty workload planning process. Its principal business function is to create Oracle Workflow events and notifications that signal when a faculty member's assigned teaching or supervision workload has exceeded a defined threshold. The package supports the "Exceed Faculty Workload" business scenario, in which the institution monitors teaching load allocations and raises a controlled exception when limits are breached. The package resides in the APPS schema and held a VALID status in the ETRM registry, confirming it was compiled and present in the delivered environment for both 12.1.1 and the 12.2.x code line.

Key Procedures and Functions

The package body exposes five documented procedures and functions. No parameter lists are reproduced here, as the ETRM metadata records only object names and callable classifications.

  • WF_CREATE_EVENT — The core workflow plumbing routine. It builds an Oracle Workflow event from the supplied context, populates the event payload, and raises the event through the Workflow engine so that subscriptions and notifications can fire.
  • FAC_EXCEED_WL_EVENT — The business-facing driver that determines when a faculty workload exception has occurred and delegates to WF_CREATE_EVENT to publish the corresponding notification.
  • GENERATE_FACULTY_LIST — Produces the list-level output for faculty workload reporting, assembling the set of faculty records that qualify for the workload review.
  • GENERATE_FACULTY_HEADER — Emits the header portion of the generated faculty workload document, including the descriptive and profile-driven context.
  • GENERATE_FACULTY_BODY — Emits the detail or body portion of the workload document, presenting the per-faculty workload lines that back the exception.

The GENERATE_* trio follows the conventional Oracle Reports layout decomposition of header and body, used so that the workload output can be rendered as a report or attached to a notification.

Tables Accessed

The dependency list confirms the following data objects, all accessed through APPS synonyms.

Utility dependencies include FND_FILE, FND_GLOBAL, FND_MESSAGE, FND_PROFILE, WF_ENGINE, WF_EVENT, and WF_NOTIFICATION, together with IGS_GE_GEN_003, IGS_GE_MSG_STACK, IGS_PS_GEN_001, and IGS_PS_USEC_OCCURS_PKG.

Usage Notes

IGS_PS_WF_EVENT_PKG is not referenced by any other database object, so it is normally the entry point rather than an internal dependency. It is typically invoked from the faculty workload concurrent program or the faculty workload maintenance form, where a user submits workload data and the system evaluates it against the configured ceiling. When the threshold is exceeded, FAC_EXCEED_WL_EVENT is called, which in turn uses WF_CREATE_EVENT to raise the notification to the designated approver or administrator. The GENERATE_FACULTY_LIST, GENERATE_FACULTY_HEADER, and GENERATE_FACULTY_BODY routines are called to render the supporting workload listing that accompanies the notification. Because the package is classified as OTHER rather than a supported public API, customizations should avoid direct calls and instead rely on the delivered concurrent program and form entry points. Site-specific thresholds and recipients are resolved through FND_PROFILE and the person type mappings, so profile options must be configured before the workload notification can be produced successfully.