APPS.ECX_PRINT_LOCAL dependencies on DBMS_LOB

Line 54: dbms_lob.createtemporary(i_xmldoc,TRUE,DBMS_LOB.SESSION);

50: i_length :=0;
51: i_temp:='';
52:
53: if i_xmldoc is null then
54: dbms_lob.createtemporary(i_xmldoc,TRUE,DBMS_LOB.SESSION);
55: end if;
56:
57: for i in 1..i_tmpxml.COUNT loop
58: -- check for the element length

Line 66: dbms_lob.writeappend(i_xmldoc,i_length, i_temp);

62: if(i_writeamount+i_length > 10000) then
63: if(l_statementEnabled) then
64: ecx_debug.log(l_statement,'Buffer Length', to_char(i_length),i_method_name);
65: end if;
66: dbms_lob.writeappend(i_xmldoc,i_length, i_temp);
67: if(l_statementEnabled) then
68: ecx_debug.log(l_statement, i_temp,i_method_name);
69: end if;
70: i_temp:='';

Line 82: dbms_lob.writeappend(i_xmldoc,i_length, i_temp);

78: end loop;
79:
80: if(i_tmpxml.COUNT > 0)
81: then
82: dbms_lob.writeappend(i_xmldoc,i_length, i_temp);
83: if(l_statementEnabled) then
84: ecx_debug.log(l_statement, i_temp,i_method_name);
85: end if;
86: end if;

Line 529: if dbms_lob.istemporary(i_xmldoc) = 1 then

525: append_clob;
526: ecx_utils.g_xml_frag.delete;
527: x_xmldoc := i_xmldoc;
528:
529: if dbms_lob.istemporary(i_xmldoc) = 1 then
530: dbms_lob.freetemporary(i_xmldoc);
531: i_xmldoc := null;
532: end if;
533:

Line 530: dbms_lob.freetemporary(i_xmldoc);

526: ecx_utils.g_xml_frag.delete;
527: x_xmldoc := i_xmldoc;
528:
529: if dbms_lob.istemporary(i_xmldoc) = 1 then
530: dbms_lob.freetemporary(i_xmldoc);
531: i_xmldoc := null;
532: end if;
533:
534: exception

Line 536: if dbms_lob.istemporary(i_xmldoc) = 1 then

532: end if;
533:
534: exception
535: when ecx_utils.program_exit then
536: if dbms_lob.istemporary(i_xmldoc) = 1 then
537: dbms_lob.freetemporary(i_xmldoc);
538: i_xmldoc := null;
539: end if;
540: raise ECX_UTILS.PROGRAM_EXIT;

Line 537: dbms_lob.freetemporary(i_xmldoc);

533:
534: exception
535: when ecx_utils.program_exit then
536: if dbms_lob.istemporary(i_xmldoc) = 1 then
537: dbms_lob.freetemporary(i_xmldoc);
538: i_xmldoc := null;
539: end if;
540: raise ECX_UTILS.PROGRAM_EXIT;
541:

Line 547: if dbms_lob.istemporary(i_xmldoc) = 1 then

543: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_PRINT_LOCAL.xmlPOPALL');
544: if(l_unexpectedEnabled) then
545: ecx_debug.log(l_unexpected,'ECX', SQLERRM || '- ECX_PRINT_LOCAL.xmlPOPALL',i_method_name);
546: end if;
547: if dbms_lob.istemporary(i_xmldoc) = 1 then
548: dbms_lob.freetemporary(i_xmldoc);
549: i_xmldoc := null;
550: end if;
551: raise ECX_UTILS.PROGRAM_EXIT;

Line 548: dbms_lob.freetemporary(i_xmldoc);

544: if(l_unexpectedEnabled) then
545: ecx_debug.log(l_unexpected,'ECX', SQLERRM || '- ECX_PRINT_LOCAL.xmlPOPALL',i_method_name);
546: end if;
547: if dbms_lob.istemporary(i_xmldoc) = 1 then
548: dbms_lob.freetemporary(i_xmldoc);
549: i_xmldoc := null;
550: end if;
551: raise ECX_UTILS.PROGRAM_EXIT;
552: end xmlPOPALL;

Line 1360: if dbms_lob.istemporary(i_xmldoc) = 1 then

1356: ecx_print_local.first_time_printing := false;
1357: suppress_profile := get_suppress_profile;
1358: /* Reinitialize the clob, so that it would not have left over
1359: data from previous run */
1360: if dbms_lob.istemporary(i_xmldoc) = 1 then
1361: dbms_lob.freetemporary(i_xmldoc);
1362: end if;
1363: i_xmldoc := null;
1364: else

Line 1361: dbms_lob.freetemporary(i_xmldoc);

1357: suppress_profile := get_suppress_profile;
1358: /* Reinitialize the clob, so that it would not have left over
1359: data from previous run */
1360: if dbms_lob.istemporary(i_xmldoc) = 1 then
1361: dbms_lob.freetemporary(i_xmldoc);
1362: end if;
1363: i_xmldoc := null;
1364: else
1365: if ecx_utils.g_target(i).parent_attribute_id =

Line 1769: clength := dbms_lob.getlength(clob_value);

1765: clength pls_integer:=0;
1766: i_temp varchar2(32767);
1767: --i_temp1 varchar2(32767);
1768: Begin
1769: clength := dbms_lob.getlength(clob_value);
1770: while clength >= i loop
1771: i_temp := dbms_lob.substr(clob_value,g_split_threshold,i);
1772: /*
1773: if (not is_cdata) then

Line 1771: i_temp := dbms_lob.substr(clob_value,g_split_threshold,i);

1767: --i_temp1 varchar2(32767);
1768: Begin
1769: clength := dbms_lob.getlength(clob_value);
1770: while clength >= i loop
1771: i_temp := dbms_lob.substr(clob_value,g_split_threshold,i);
1772: /*
1773: if (not is_cdata) then
1774: escape_spec_char(i_temp, i_temp1);
1775: else