APPS.WF_TEMP_LOB dependencies on DBMS_LOB

Line 20: dbms_lob.createtemporary(p_lob_tab(m).temp_lob,true,DBMS_LOB.SESSION);

16:
17: -- if we reach here, there is no temp lob available, create one.
18: m := p_lob_tab.COUNT+1;
19: p_lob_tab(m).temp_lob := null;
20: dbms_lob.createtemporary(p_lob_tab(m).temp_lob,true,DBMS_LOB.SESSION);
21: p_lob_tab(m).free := false;
22:
23: return(m);
24:

Line 38: dbms_lob.trim(p_lob_tab(loc).temp_lob,0);

34: is
35: begin
36: if (loc > 0 and loc <= p_lob_tab.COUNT) then
37: if (not p_lob_tab(loc).free) then
38: dbms_lob.trim(p_lob_tab(loc).temp_lob,0);
39: p_lob_tab(loc).free := true;
40: end if;
41: end if;
42:

Line 62: len := dbms_lob.getlength(p_lob_tab(i).temp_lob);

58: 'Count: '||to_char(p_lob_tab.COUNT));
59: end if;
60:
61: for i in 1..p_lob_tab.COUNT loop
62: len := dbms_lob.getlength(p_lob_tab(i).temp_lob);
63:
64: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
65: wf_log_pkg.string(wf_log_pkg.level_statement,
66: 'wf.plsql.WF_TEMP_LOB.ShowLOB.allocate',

Line 90: dbms_lob.read(p_lob_tab(i).temp_lob,amt,1,buf);

86: 'wf.plsql.WF_TEMP_LOB.ShowLOB.empty',
87: 'lob content: empty');
88: end if;
89: else
90: dbms_lob.read(p_lob_tab(i).temp_lob,amt,1,buf);
91: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
92: wf_log_pkg.string(wf_log_pkg.level_statement,
93: 'wf.plsql.WF_TEMP_LOB.ShowLOB.content',
94: 'lob content: '||buf);