APPS.PAY_JP_ITAX_REPORT_PKG dependencies on DBMS_LOB

Line 444: dbms_lob.writeAppend(l_clob, length(l_value), l_value);

440: is
441: l_value varchar2(2000);
442: begin
443: l_value := p_tag || c_lf;
444: dbms_lob.writeAppend(l_clob, length(l_value), l_value);
445: end append_tag;
446: --
447: procedure append_item(
448: p_tag in varchar2,

Line 455: dbms_lob.writeAppend(l_clob, length(l_value), l_value);

451: l_value varchar2(2000);
452: begin
453: if p_value is not null then
454: l_value := '<' || p_tag || '>' || dbms_xmlgen.convert(p_value) || '' || c_lf;
455: dbms_lob.writeAppend(l_clob, length(l_value), l_value);
456: --
457: -- Workaround for XDO bug.6129128
458: --
459: l_value := '<' || p_tag || '_2>' || dbms_xmlgen.convert(p_value) || '' || c_lf;

Line 460: dbms_lob.writeAppend(l_clob, length(l_value), l_value);

456: --
457: -- Workaround for XDO bug.6129128
458: --
459: l_value := '<' || p_tag || '_2>' || dbms_xmlgen.convert(p_value) || '' || c_lf;
460: dbms_lob.writeAppend(l_clob, length(l_value), l_value);
461: l_value := '<' || p_tag || '_3>' || dbms_xmlgen.convert(p_value) || '' || c_lf;
462: dbms_lob.writeAppend(l_clob, length(l_value), l_value);
463: l_value := '<' || p_tag || '_4>' || dbms_xmlgen.convert(p_value) || '' || c_lf;
464: dbms_lob.writeAppend(l_clob, length(l_value), l_value);

Line 462: dbms_lob.writeAppend(l_clob, length(l_value), l_value);

458: --
459: l_value := '<' || p_tag || '_2>' || dbms_xmlgen.convert(p_value) || '' || c_lf;
460: dbms_lob.writeAppend(l_clob, length(l_value), l_value);
461: l_value := '<' || p_tag || '_3>' || dbms_xmlgen.convert(p_value) || '' || c_lf;
462: dbms_lob.writeAppend(l_clob, length(l_value), l_value);
463: l_value := '<' || p_tag || '_4>' || dbms_xmlgen.convert(p_value) || '' || c_lf;
464: dbms_lob.writeAppend(l_clob, length(l_value), l_value);
465: end if;
466: end append_item;

Line 464: dbms_lob.writeAppend(l_clob, length(l_value), l_value);

460: dbms_lob.writeAppend(l_clob, length(l_value), l_value);
461: l_value := '<' || p_tag || '_3>' || dbms_xmlgen.convert(p_value) || '' || c_lf;
462: dbms_lob.writeAppend(l_clob, length(l_value), l_value);
463: l_value := '<' || p_tag || '_4>' || dbms_xmlgen.convert(p_value) || '' || c_lf;
464: dbms_lob.writeAppend(l_clob, length(l_value), l_value);
465: end if;
466: end append_item;
467: --
468: procedure append_item(

Line 492: dbms_lob.createTemporary(l_clob, true, dbms_lob.call);

488: if g_index is not null then
489: --
490: -- Construct XML
491: --
492: dbms_lob.createTemporary(l_clob, true, dbms_lob.call);
493: dbms_lob.open(l_clob, dbms_lob.lob_readwrite);
494: append_tag('');
495: append_tag('');
496: --

Line 493: dbms_lob.open(l_clob, dbms_lob.lob_readwrite);

489: --
490: -- Construct XML
491: --
492: dbms_lob.createTemporary(l_clob, true, dbms_lob.call);
493: dbms_lob.open(l_clob, dbms_lob.lob_readwrite);
494: append_tag('');
495: append_tag('');
496: --
497: while g_index is not null and (g_chunk_size <= 0 or l_counter <= g_chunk_size) loop

Line 658: dbms_lob.freeTemporary(l_clob);

654: return l_clob;
655: exception
656: when others then
657: if l_clob is not null then
658: dbms_lob.freeTemporary(l_clob);
659: end if;
660: raise;
661: end getXML;
662: -- |---------------------------------------------------------------------------|