DBA Data[Home] [Help]

APPS.WF_EVENT dependencies on DBMS_LOB

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

140:
141: else
142: cmd := ''||ename||''||
143: p_event.getEventKey()||'
';
144: dbms_lob.createtemporary(msg, FALSE, DBMS_LOB.CALL);
145: dbms_lob.write(msg, length(cmd), 1, cmd);
146: end if;
147:
148: p_event.event_data := msg ;

Line 145: dbms_lob.write(msg, length(cmd), 1, cmd);

141: else
142: cmd := ''||ename||''||
143: p_event.getEventKey()||'
';
144: dbms_lob.createtemporary(msg, FALSE, DBMS_LOB.CALL);
145: dbms_lob.write(msg, length(cmd), 1, cmd);
146: end if;
147:
148: p_event.event_data := msg ;
149: -- p_event.setEventData(msg);

Line 622: -- Use dbms_lob.istemporary to see if any clob

618: -- Exception happened in Generate Method should be thrown
619: -- up.
620: --
621: -- mjc Check if we are required to Generate Message
622: -- Use dbms_lob.istemporary to see if any clob
623: --
624: begin
625: if (NOT genmsg) AND
626: (p_rule_data = 'MESSAGE') AND

Line 633: -- if dbms_lob.istemporary(p_event.GetEventData()) = 0 then

629: wf_log_pkg.string(wf_log_pkg.level_statement,
630: 'wf.plsql.WF_EVENT.dispatch_internal.Rule_Data',
631: 'Rule Data is MESSAGE and Source is LOCAL');
632: end if;
633: -- if dbms_lob.istemporary(p_event.GetEventData()) = 0 then
634: -- Bug Fix for 4286207
635: begin
636: if (p_event.GetEventData() is null) or
637: (p_event.GetEventData() is not null and dbms_lob.getlength(p_event.GetEventData()) = 0) then

Line 637: (p_event.GetEventData() is not null and dbms_lob.getlength(p_event.GetEventData()) = 0) then

633: -- if dbms_lob.istemporary(p_event.GetEventData()) = 0 then
634: -- Bug Fix for 4286207
635: begin
636: if (p_event.GetEventData() is null) or
637: (p_event.GetEventData() is not null and dbms_lob.getlength(p_event.GetEventData()) = 0) then
638: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
639: wf_log_pkg.string(wf_log_pkg.level_statement,
640: 'wf.plsql.WF_EVENT.dispatch_internal.generate',
641: 'Need to Generate Message');