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 839: dbms_lob.createTemporary(doc, true, DBMS_LOB.CALL);

835: select to_char(sysdate, timeMask)
836: into generateTime
837: from sys.dual;
838:
839: dbms_lob.createTemporary(doc, true, DBMS_LOB.CALL);
840:
841: l_str := ''||wf_core.newLine;
842:
843: l_str := l_str||' 865: '"> 866: ']]>';
867: dbms_lob.writeAppend(lob_loc => doc,
868: amount => length(l_str),
869: buffer => l_str);
870:
871: end loop;

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

875: end if;
876:
877: l_str := l_str||''||wf_core.newLine;
878:
879: dbms_lob.writeAppend(lob_loc => doc,
880: amount => length(l_str),
881: buffer => l_str);
882:
883: return doc;