APPS.WF_DIAGNOSTICS_APPS dependencies on DBMS_LOB

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

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

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

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

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

66:
67: l_temp_result := '
' || '' || '

GSM is ' || l_gsm_enabled || 68: '

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

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

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

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

210:
211: END IF; -- count GT 0
212:
213: l_temp_result := l_temp_result ||'

Workflow GSC Services status:

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

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

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

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

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

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

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

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

318: outbound_logfile := 'Please ensure that FND-Logging is enabled for module '
319: ||ecx_debug.g_sqlprefix||'%';
320: END IF;
321:
322: -- dbms_lob.freetemporary(p_xmldoc);
323:
324: dbms_lob.createtemporary(i_tmp,true,dbms_lob.session);
325: /* file := utl_file.fopen(ecx_utils.g_logdir,i_file_name, 'r');
326: loop

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

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

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

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

Line 350: dbms_lob.freetemporary(i_tmp);

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

Line 364: dbms_lob.freetemporary(p_xmldoc);

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

Line 365: dbms_lob.freetemporary(i_tmp);

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