APPS.WF_EVENT_FUNCTIONS_PKG dependencies on DBMS_LOB

Line 27: dbms_lob.createtemporary(msg, FALSE, DBMS_LOB.CALL);

23: begin
24:
25: l_parameters := t_parameters(1,2);
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

Line 93: --dbms_lob.append(msg, wf_event_synchronize_pkg.CreateSyncClob);

89: dtd := wf_agent_groups_pkg.generate(l_parameters(1), l_parameters(2));
90: /** End of Bug 2398759 **/
91: elsif p_event_name = 'oracle.apps.wf.event.all.sync' then
92: wf_event_synchronize_pkg.CreateSyncClob(p_eventdata=>msg);
93: --dbms_lob.append(msg, wf_event_synchronize_pkg.CreateSyncClob);
94: else
95: null;
96: end if;
97:

Line 99: dbms_lob.write(msg, length(dtd), 1, dtd);

95: null;
96: end if;
97:
98: IF dtd IS NOT NULL THEN
99: dbms_lob.write(msg, length(dtd), 1, dtd);
100: END IF;
101:
102: return (msg);
103:

Line 151: l_length := dbms_lob.getlength(l_eventdata);

147:
148: if (l_eventname <> 'oracle.apps.wf.event.all.sync'
149: and l_eventname <> 'oracle.apps.wf.event.system.signup') then
150:
151: l_length := dbms_lob.getlength(l_eventdata);
152:
153: dbms_lob.read(l_eventdata, l_length,1,x_message);
154:
155: if l_eventname = 'oracle.apps.wf.event.system.create' then

Line 153: dbms_lob.read(l_eventdata, l_length,1,x_message);

149: and l_eventname <> 'oracle.apps.wf.event.system.signup') then
150:
151: l_length := dbms_lob.getlength(l_eventdata);
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