26:
27: dbms_lob.createtemporary(msg, FALSE, DBMS_LOB.CALL);
28:
29: if p_event_name = 'oracle.apps.wf.event.system.create' then
30: dtd := wf_systems_pkg.generate(p_event_key);
31: elsif p_event_name = 'oracle.apps.wf.event.system.delete' then
32: dtd := wf_systems_pkg.generate(p_event_key);
33: elsif p_event_name = 'oracle.apps.wf.event.system.update' then
34: dtd := wf_systems_pkg.generate(p_event_key);
28:
29: if p_event_name = 'oracle.apps.wf.event.system.create' then
30: dtd := wf_systems_pkg.generate(p_event_key);
31: elsif p_event_name = 'oracle.apps.wf.event.system.delete' then
32: dtd := wf_systems_pkg.generate(p_event_key);
33: elsif p_event_name = 'oracle.apps.wf.event.system.update' then
34: dtd := wf_systems_pkg.generate(p_event_key);
35: elsif p_event_name = 'oracle.apps.wf.event.agent.create' then
36: dtd := wf_agents_pkg.generate(p_event_key);
30: dtd := wf_systems_pkg.generate(p_event_key);
31: elsif p_event_name = 'oracle.apps.wf.event.system.delete' then
32: dtd := wf_systems_pkg.generate(p_event_key);
33: elsif p_event_name = 'oracle.apps.wf.event.system.update' then
34: dtd := wf_systems_pkg.generate(p_event_key);
35: elsif p_event_name = 'oracle.apps.wf.event.agent.create' then
36: dtd := wf_agents_pkg.generate(p_event_key);
37: elsif p_event_name = 'oracle.apps.wf.event.agent.delete' then
38: dtd := wf_agents_pkg.generate(p_event_key);
152:
153: dbms_lob.read(l_eventdata, l_length,1,x_message);
154:
155: if l_eventname = 'oracle.apps.wf.event.system.create' then
156: wf_systems_pkg.receive(x_message);
157: elsif l_eventname = 'oracle.apps.wf.event.system.delete' then
158: wf_systems_pkg.delete_row(l_eventkey);
159: elsif l_eventname = 'oracle.apps.wf.event.system.update' then
160: wf_systems_pkg.receive(x_message);
154:
155: if l_eventname = 'oracle.apps.wf.event.system.create' then
156: wf_systems_pkg.receive(x_message);
157: elsif l_eventname = 'oracle.apps.wf.event.system.delete' then
158: wf_systems_pkg.delete_row(l_eventkey);
159: elsif l_eventname = 'oracle.apps.wf.event.system.update' then
160: wf_systems_pkg.receive(x_message);
161: elsif l_eventname = 'oracle.apps.wf.event.agent.create' then
162: wf_agents_pkg.receive(x_message);
156: wf_systems_pkg.receive(x_message);
157: elsif l_eventname = 'oracle.apps.wf.event.system.delete' then
158: wf_systems_pkg.delete_row(l_eventkey);
159: elsif l_eventname = 'oracle.apps.wf.event.system.update' then
160: wf_systems_pkg.receive(x_message);
161: elsif l_eventname = 'oracle.apps.wf.event.agent.create' then
162: wf_agents_pkg.receive(x_message);
163: elsif l_eventname = 'oracle.apps.wf.event.agent.delete' then
164: wf_agents_pkg.delete_row(l_eventkey);