Generate (Oracle Workflow Help)

Oracle Workflow Guide
Release 2.6.2
Part Number A95265-02


	Previous	Next		Contents	Index	Glossary

Generate

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.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, 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, and subscription definitions from the Event Manager on the local system.

Arguments (input)

p_event_name The internal name of the event.

p_event_key A string generated when the event occurs within a program or application. The event key uniquely identifies a specific instance of the event.

p_event_name	The internal name of the event.
p_event_key	A string generated when the event occurs within a program or application. The event key uniquely identifies a specific instance of the event.

Generate

See Also