APPS.CSE_FA_STAGE_PKG dependencies on DBMS_LOB

Line 35: DBMS_LOB.CREATETEMPORARY(v_clob, TRUE);

31: v_buffer PLS_INTEGER := 32767;
32: l_xpath VARCHAR2(1000);
33:
34: BEGIN
35: DBMS_LOB.CREATETEMPORARY(v_clob, TRUE);
36:
37: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(p_blob) / v_buffer) LOOP
38: v_varchar := UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(p_blob, v_buffer, v_start));
39: DBMS_LOB.WRITEAPPEND(v_clob, LENGTH(v_varchar), v_varchar);

Line 37: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(p_blob) / v_buffer) LOOP

33:
34: BEGIN
35: DBMS_LOB.CREATETEMPORARY(v_clob, TRUE);
36:
37: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(p_blob) / v_buffer) LOOP
38: v_varchar := UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(p_blob, v_buffer, v_start));
39: DBMS_LOB.WRITEAPPEND(v_clob, LENGTH(v_varchar), v_varchar);
40: v_start := v_start + v_buffer;
41: END LOOP;

Line 38: v_varchar := UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(p_blob, v_buffer, v_start));

34: BEGIN
35: DBMS_LOB.CREATETEMPORARY(v_clob, TRUE);
36:
37: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(p_blob) / v_buffer) LOOP
38: v_varchar := UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(p_blob, v_buffer, v_start));
39: DBMS_LOB.WRITEAPPEND(v_clob, LENGTH(v_varchar), v_varchar);
40: v_start := v_start + v_buffer;
41: END LOOP;
42:

Line 39: DBMS_LOB.WRITEAPPEND(v_clob, LENGTH(v_varchar), v_varchar);

35: DBMS_LOB.CREATETEMPORARY(v_clob, TRUE);
36:
37: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(p_blob) / v_buffer) LOOP
38: v_varchar := UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(p_blob, v_buffer, v_start));
39: DBMS_LOB.WRITEAPPEND(v_clob, LENGTH(v_varchar), v_varchar);
40: v_start := v_start + v_buffer;
41: END LOOP;
42:
43: RETURN v_clob;

Line 57: DBMS_LOB.CREATETEMPORARY(l_blob, FALSE);

53: v_lang Pls_Integer := 0;
54: v_warning Pls_Integer := 0;
55: BEGIN
56:
57: DBMS_LOB.CREATETEMPORARY(l_blob, FALSE);
58:
59: DBMS_LOB.convertToBlob(l_blob,p_clob,DBMS_lob.getlength(p_clob),
60: v_in,v_out,DBMS_LOB.default_csid,v_lang,v_warning);
61:

Line 59: DBMS_LOB.convertToBlob(l_blob,p_clob,DBMS_lob.getlength(p_clob),

55: BEGIN
56:
57: DBMS_LOB.CREATETEMPORARY(l_blob, FALSE);
58:
59: DBMS_LOB.convertToBlob(l_blob,p_clob,DBMS_lob.getlength(p_clob),
60: v_in,v_out,DBMS_LOB.default_csid,v_lang,v_warning);
61:
62: return l_blob;
63: EXCEPTION WHEN OTHERS THEN

Line 60: v_in,v_out,DBMS_LOB.default_csid,v_lang,v_warning);

56:
57: DBMS_LOB.CREATETEMPORARY(l_blob, FALSE);
58:
59: DBMS_LOB.convertToBlob(l_blob,p_clob,DBMS_lob.getlength(p_clob),
60: v_in,v_out,DBMS_LOB.default_csid,v_lang,v_warning);
61:
62: return l_blob;
63: EXCEPTION WHEN OTHERS THEN
64: RAISE;

Line 372: dbms_lob.writeappend(g_clob, length(l_message_with_newline), l_message_with_newline);

368:
369: BEGIN
370: fnd_file.put_line(fnd_file.output, p_message);
371: l_message_with_newline := add_newline(p_message);
372: dbms_lob.writeappend(g_clob, length(l_message_with_newline), l_message_with_newline);
373: END out;
374:
375: FUNCTION fill(
376: p_column IN varchar2,

Line 395: dbms_lob.createtemporary(g_clob,TRUE, dbms_lob.session);

391: FOR stage_rec IN stage_cur
392: LOOP
393:
394: IF stage_cur%rowcount = 1 THEN
395: dbms_lob.createtemporary(g_clob,TRUE, dbms_lob.session);
396:
397: l_out := ' New Assets to be Tracked in Installed Base - Report';
398: out(l_out);
399: l_out := ' ---------------------------------------------------';

Line 472: dbms_lob.copy(x_document, dest_lob, dbms_lob.getlength(bdoc));

468:
469: --Convert the blob stored in FND_LOBS to clob
470: x_document_type := content_type || ';name=' || filename;
471: dest_lob := BLOB_TO_CLOB(bdoc);
472: dbms_lob.copy(x_document, dest_lob, dbms_lob.getlength(bdoc));
473: EXCEPTION
474: WHEN OTHERS THEN
475: wf_core.CONTEXT('cse_fa_stage_pkg'
476: ,'get_report_clob'