APPS.WF_RULE dependencies on DBMS_LOB

Line 105: IsTmp := dbms_lob.istemporary(p_event.GetEventData());

101: select source_type into srctype from wf_event_subscriptions
102: where guid = p_subscription_guid;
103:
104: -- Need to check if clob is temporary instead of null
105: IsTmp := dbms_lob.istemporary(p_event.GetEventData());
106: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.istemp',
107: 'Event Data is Temp: '||IsTmp);
108: if ((IsTmp= 1 and srctype = 'LOCAL')
109: or (IsTmp= 0 and srctype in ('EXTERNAL','ERROR'))) then

Line 115: clob_len := dbms_lob.getlength(myclob);

111: 'wf.plsql.wf_rule.log.event_data', 'Begin EventData');
112: myclob := p_event.getEventData();
113: if myclob is not null then
114: offset := 1;
115: clob_len := dbms_lob.getlength(myclob);
116: while( offset <= clob_len ) loop
117: wf_log_pkg.string( wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.message',
118: dbms_lob.substr( myclob, clob_bufsize, offset ));
119: offset := offset + clob_bufsize;

Line 118: dbms_lob.substr( myclob, clob_bufsize, offset ));

114: offset := 1;
115: clob_len := dbms_lob.getlength(myclob);
116: while( offset <= clob_len ) loop
117: wf_log_pkg.string( wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.message',
118: dbms_lob.substr( myclob, clob_bufsize, offset ));
119: offset := offset + clob_bufsize;
120: end loop;
121: end if;
122: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.event_data', 'End EventData');

Line 830: dbms_lob.createTemporary(doc, true, DBMS_LOB.CALL);

826: select to_char(sysdate, timeMask)
827: into generateTime
828: from sys.dual;
829:
830: dbms_lob.createTemporary(doc, true, DBMS_LOB.CALL);
831:
832: l_str := ''||wf_core.newLine;
833:
834: l_str := l_str||' 856: '"> 857: ']]>';
858: dbms_lob.writeAppend(lob_loc => doc,
859: amount => length(l_str),
860: buffer => l_str);
861:
862: end loop;

Line 870: dbms_lob.writeAppend(lob_loc => doc,

866: end if;
867:
868: l_str := l_str||''||wf_core.newLine;
869:
870: dbms_lob.writeAppend(lob_loc => doc,
871: amount => length(l_str),
872: buffer => l_str);
873:
874: return doc;