DBA Data[Home] [Help]

APPS.WF_EVENT dependencies on DBMS_LOB

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

123:
124: else
125: cmd := ''||ename||''||
126: p_event.getEventKey()||'
';
127: dbms_lob.createtemporary(msg, FALSE, DBMS_LOB.CALL);
128: dbms_lob.write(msg, length(cmd), 1, cmd);
129: end if;
130:
131: p_event.event_data := msg ;

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

124: else
125: cmd := ''||ename||''||
126: p_event.getEventKey()||'
';
127: dbms_lob.createtemporary(msg, FALSE, DBMS_LOB.CALL);
128: dbms_lob.write(msg, length(cmd), 1, cmd);
129: end if;
130:
131: p_event.event_data := msg ;
132: -- p_event.setEventData(msg);

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

588: -- Exception happened in Generate Method should be thrown
589: -- up.
590: --
591: -- mjc Check if we are required to Generate Message
592: -- Use dbms_lob.istemporary to see if any clob
593: --
594: begin
595: if (NOT genmsg) AND
596: (p_rule_data = 'MESSAGE') AND

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

599: wf_log_pkg.string(wf_log_pkg.level_statement,
600: 'wf.plsql.WF_EVENT.dispatch_internal.Rule_Data',
601: 'Rule Data is MESSAGE and Source is LOCAL');
602: end if;
603: -- if dbms_lob.istemporary(p_event.GetEventData()) = 0 then
604: -- Bug Fix for 4286207
605: begin
606: if (p_event.GetEventData() is null) or
607: (p_event.GetEventData() is not null and dbms_lob.getlength(p_event.GetEventData()) = 0) then

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

603: -- if dbms_lob.istemporary(p_event.GetEventData()) = 0 then
604: -- Bug Fix for 4286207
605: begin
606: if (p_event.GetEventData() is null) or
607: (p_event.GetEventData() is not null and dbms_lob.getlength(p_event.GetEventData()) = 0) then
608: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
609: wf_log_pkg.string(wf_log_pkg.level_statement,
610: 'wf.plsql.WF_EVENT.dispatch_internal.generate',
611: 'Need to Generate Message');