APPS.WF_DIAGNOSTICS_APPS dependencies on DBMS_LOB

Line 61: dbms_lob.CreateTemporary(l_value, TRUE, dbms_lob.Session);

57: begin
58:
59: l_status := 'S';
60:
61: dbms_lob.CreateTemporary(l_value, TRUE, dbms_lob.Session);
62: -- Set up Header
63: l_temp_result := g_head;
64: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
65:

Line 64: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

60:
61: dbms_lob.CreateTemporary(l_value, TRUE, dbms_lob.Session);
62: -- Set up Header
63: l_temp_result := g_head;
64: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
65:
66: -- If GSM is enabled in ICM
67: select decode(fnd_profile.value('CONC_GSM_ENABLED'), 'Y', 'ENABLED', 'NOT ENABLED')
68: into l_gsm_enabled from dual;

Line 73: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

69:
70: l_temp_result := '
' || '' || '

GSM is ' || l_gsm_enabled || 71: '

';
72:
73: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
74:
75: if (l_gsm_enabled = 'NOT ENABLED') then
76: l_status := 'E';
77: end if;

Line 107: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

103: l_status := 'E';
104: END IF;
105: END IF;
106:
107: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
108:
109: -- If the Service Instance are enabled
110: l_temp_result := '
';
111: l_temp_result := l_temp_result|| '';

Line 217: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

213:
214: END IF; -- count GT 0
215:
216: l_temp_result := l_temp_result ||'

Workflow GSC Services status:

';
217: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
218:
219: -- Show the classpath etc. based on if it has ever started before
220: -- TODO : Whether these VARS should be displayd for each Service Instance or only
221: -- Once.

Line 250: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

246: ' ';
247: end loop;
248:
249: l_temp_result := l_temp_result ||'
';
250: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
251:
252: end if; -- Env .variables
253:
254: -- Send the final HTML Output to the caller

Line 255: dbms_lob.WriteAppend(l_value, length(g_end), g_end);

251:
252: end if; -- Env .variables
253:
254: -- Send the final HTML Output to the caller
255: dbms_lob.WriteAppend(l_value, length(g_end), g_end);
256: p_value := l_value;
257:
258: return l_status;
259: end Get_GSM_Setup_Info;

Line 299: dbms_lob.createtemporary(p_xmldoc,true,dbms_lob.session);

295: AND FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) then
296: ecx_logging_enabled := true;
297: end if;
298:
299: dbms_lob.createtemporary(p_xmldoc,true,dbms_lob.session);
300: ecx_outbound.GETXML(
301: i_map_code => 'TestingDirectOut',
302: i_debug_level => 3,
303: i_xmldoc => p_xmldoc,

Line 325: -- dbms_lob.freetemporary(p_xmldoc);

321: outbound_logfile := 'No log file name as logging was not enabled for module: '
322: ||ecx_debug.g_sqlprefix||'%';
323: END IF;
324:
325: -- dbms_lob.freetemporary(p_xmldoc);
326:
327: dbms_lob.createtemporary(i_tmp,true,dbms_lob.session);
328: /* file := utl_file.fopen(ecx_utils.g_logdir,i_file_name, 'r');
329: loop

Line 327: dbms_lob.createtemporary(i_tmp,true,dbms_lob.session);

323: END IF;
324:
325: -- dbms_lob.freetemporary(p_xmldoc);
326:
327: dbms_lob.createtemporary(i_tmp,true,dbms_lob.session);
328: /* file := utl_file.fopen(ecx_utils.g_logdir,i_file_name, 'r');
329: loop
330: begin
331: utl_file.get_line(file, i_buffer);

Line 332: dbms_lob.writeappend(i_tmp,lengthb(i_buffer),i_buffer);

328: /* file := utl_file.fopen(ecx_utils.g_logdir,i_file_name, 'r');
329: loop
330: begin
331: utl_file.get_line(file, i_buffer);
332: dbms_lob.writeappend(i_tmp,lengthb(i_buffer),i_buffer);
333: exception
334: when no_data_found then
335: exit;
336: when others then

Line 353: dbms_lob.freetemporary(i_tmp);

349: i_logfile,
350: i_temp
351: );
352:
353: dbms_lob.freetemporary(i_tmp);
354:
355: inbound_ret_code := i_ret_code;
356: inbound_errbuf := i_errbuf;
357: -- inbound_logfile := i_logfile;

Line 367: dbms_lob.freetemporary(p_xmldoc);

363: ||ecx_debug.g_sqlprefix||'%';
364: END IF;
365: exception
366: when others then
367: dbms_lob.freetemporary(p_xmldoc);
368: dbms_lob.freetemporary(i_tmp);
369:
370: outbound_ret_code := p_ret_code;
371: outbound_errbuf := p_errbuf;

Line 368: dbms_lob.freetemporary(i_tmp);

364: END IF;
365: exception
366: when others then
367: dbms_lob.freetemporary(p_xmldoc);
368: dbms_lob.freetemporary(i_tmp);
369:
370: outbound_ret_code := p_ret_code;
371: outbound_errbuf := p_errbuf;
372: outbound_logfile := p_logfile;