PL/SQL Syntax

function Generate  
  (p_event_name in varchar2, 
   p_event_key in varchar2) return clob;

Description

Generates the event data for events in the Seed event group. This event data contains Business Event System object definitions which can be used to replicate the objects from one system to another.

The Seed event group includes the following events:

• oracle.apps.wf.event.event.create

• oracle.apps.wf.event.event.update

• oracle.apps.wf.event.event.delete

• oracle.apps.wf.event.group.create

• oracle.apps.wf.event.group.update

• oracle.apps.wf.event.group.delete

• oracle.apps.wf.event.system.create

• oracle.apps.wf.event.system.update

• oracle.apps.wf.event.system.delete

• oracle.apps.wf.event.agent.create

• oracle.apps.wf.event.agent.update

• oracle.apps.wf.event.agent.delete

• oracle.apps.wf.agent.group.create

• oracle.apps.wf.agent.group.update

• oracle.apps.wf.agent.group.delete

• oracle.apps.wf.event.subscription.create

• oracle.apps.wf.event.subscription.update

• oracle.apps.wf.event.subscription.delete

• oracle.apps.wf.event.all.sync

For the event, event group, system, agent, agent group member, and subscription definition events, WF_EVENT_FUNCTIONS_PKG.Generate() calls the Generate APIs associated with the corresponding tables to produce the event data XML document. For the Synchronize Event Systems event, WF_EVENT_FUNCTIONS_PKG.Generate() produces an XML document containing all the event, event group, system, agent, agent group member, and subscription definitions from the Event Manager on the local system.

Arguments (input)