WF_EVENTS

Event definitions for Business Event System

Name Datatype Length Mandatory Comments
GUID RAW (16) Yes Global Unique ID
NAME VARCHAR2 (240) Yes Event Name
TYPE VARCHAR2 (8) Yes Type of event which could be EVENT or GROUP
STATUS VARCHAR2 (8) Yes Status of event which could be ENABLED OR DISABLED
GENERATE_FUNCTION VARCHAR2 (240)
Function to generate the message body of such event
OWNER_NAME VARCHAR2 (30)
Event owner name which usually is the product name
OWNER_TAG VARCHAR2 (30)
Event owner tag which usually is the product short code
SECURITY_GROUP_ID VARCHAR2 (32)
identifier reserved for hosting environment
CUSTOMIZATION_LEVEL VARCHAR2 (1) Yes CUSTOMIZATION_LEVEL
LICENSED_FLAG VARCHAR2 (1) Yes LICENSED_FLAG

Usage:


  cursor cur_event(c_name   in dba_objects.object_name%type := '%'
                 , n_appid  in number) is
  select e.name
  ,      e.guid id
  from wf_events e
  ,    fnd_application a
  where a.application_id = n_appid
  and   e.owner_tag = a.application_short_name
  and   e.name like c_name ESCAPE '\';

procedure ls_event(c_guid in varchar2) is

  cursor cur_event(c_guid in varchar2) is
  SELECT NAME
  ,      TYPE
  ,      STATUS
  ,      GENERATE_FUNCTION
  ,      OWNER_NAME
  ,      OWNER_TAG
  FROM WF_EVENTS
  where GUID = c_guid;