WF_EVENT_SUBSCRIPTIONS
Subscription for Business Event System
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GUID | RAW | (16) | Yes | Event subscription global unique id |
SYSTEM_GUID | RAW | (16) | Yes | System that this subscription should take action |
SOURCE_TYPE | VARCHAR2 | (8) | Yes | Where the event comes from like ERROR, EXTERNAL or LOCAL |
SOURCE_AGENT_GUID | RAW | (16) | From which agent the event comes from | |
EVENT_FILTER_GUID | RAW | (16) | Yes | What event this subscription is interested in |
PHASE | NUMBER | Order of subscriptions to take place when there are multiple subscriptions on an event. when phase is 100 or above, the subscription is considered deferred. | ||
STATUS | VARCHAR2 | (8) | Yes | Subscription status which could be ENALBLED or DISABLED. |
RULE_DATA | VARCHAR2 | (8) | Yes | Data that the rule function is interested in which could be KEY or MESSAGE |
OUT_AGENT_GUID | RAW | (16) | Send the event to this agent | |
TO_AGENT_GUID | RAW | (16) | Retrive event from this agent | |
PRIORITY | NUMBER | Subscription priority | ||
RULE_FUNCTION | VARCHAR2 | (240) | Function to be run for this subscription | |
WF_PROCESS_TYPE | VARCHAR2 | (30) | Item type of a workflow to be invoked | |
WF_PROCESS_NAME | VARCHAR2 | (30) | Process in above item type to be invoked | |
PARAMETERS | VARCHAR2 | (4000) | Parameters to be passed in | |
OWNER_NAME | VARCHAR2 | (30) | Subscription owner name which usually is the product name | |
OWNER_TAG | VARCHAR2 | (30) | Subscription owner tag wich usually is the product short code | |
DESCRIPTION | VARCHAR2 | (240) | Description of the subscription | |
EXPRESSION | VARCHAR2 | (4000) | something that will be evaluated at runtime to further restrict if an event subscription rule applied | |
SECURITY_GROUP_ID | VARCHAR2 | (32) | identifier reserved for hosting environment | |
CUSTOMIZATION_LEVEL | VARCHAR2 | (1) | Yes | CUSTOMIZATION_LEVEL |
LICENSED_FLAG | VARCHAR2 | (1) | Yes | LICENSED_FLAG |
INVOCATION_ID | NUMBER | INVOCATION_ID | ||
MAP_CODE | VARCHAR2 | (30) | MAP_CODE |
Usage:
cursor cur_subscriptions(c_guid in varchar2) is
select s.wf_process_name
, s.wf_process_type
, s.rule_function
, s.source_type
, s.description
from wf_event_subscriptions s
where s.event_filter_guid = c_guid
order by source_type;