APPS.PON_FORMS_UTIL_PVT dependencies on DBMS_LOB

Line 344: xmlstr := dbms_lob.SUBSTR(result,32767);

340: line varchar2(2000);
341: l_index Number;
342: begin
343: g_newline := fnd_global.newline();
344: xmlstr := dbms_lob.SUBSTR(result,32767);
345: loop
346: exit when xmlstr is null;
347: l_index := instr(xmlstr,g_newline);
348: line := substr(xmlstr,1,l_index-1);

Line 1809: l_schemOffset := DBMS_LOB.INSTR(p_schema,'')+12;

1805: rollback to SAVEPOINT PON_XMLSCHEMA;
1806:
1807: DBMS_XMLQUERY.closecontext(l_queryCtx);
1808:
1809: l_schemOffset := DBMS_LOB.INSTR(p_schema,'')+12;
1810: DBMS_LOB.TRIM(p_schema,l_schemOffset);
1811:
1812: --The code below removed the
1813: -- from the xsd

Line 1810: DBMS_LOB.TRIM(p_schema,l_schemOffset);

1806:
1807: DBMS_XMLQUERY.closecontext(l_queryCtx);
1808:
1809: l_schemOffset := DBMS_LOB.INSTR(p_schema,'')+12;
1810: DBMS_LOB.TRIM(p_schema,l_schemOffset);
1811:
1812: --The code below removed the
1813: -- from the xsd
1814:

Line 1816: l_xmlTagOffset := DBMS_LOB.INSTR(p_schema,'>');

1812: --The code below removed the
1813: -- from the xsd
1814:
1815: -- Get the length of tag for
1816: l_xmlTagOffset := DBMS_LOB.INSTR(p_schema,'>');
1817:
1818: -- Get the position where
1819: -- ends
1820: l_documentOffset := DBMS_LOB.INSTR(p_schema,'>',1,2);

Line 1820: l_documentOffset := DBMS_LOB.INSTR(p_schema,'>',1,2);

1816: l_xmlTagOffset := DBMS_LOB.INSTR(p_schema,'>');
1817:
1818: -- Get the position where
1819: -- ends
1820: l_documentOffset := DBMS_LOB.INSTR(p_schema,'>',1,2);
1821:
1822: -- length of
1823: l_documentTagLength := l_documentOffset-l_xmlTagOffset;
1824: l_blankTextForDocumentTag := '';

Line 1833: dbms_lob.write(p_schema,l_documentTagLength,l_xmlTagOffset+1,l_blankTextForDocumentTag);

1829: l_blankTextForDocumentTag := l_blankTextForDocumentTag ||' ';
1830: l_count := l_count+1;
1831: end loop;
1832:
1833: dbms_lob.write(p_schema,l_documentTagLength,l_xmlTagOffset+1,l_blankTextForDocumentTag);
1834:
1835: print_debug_log(l_api_name, 'END ');
1836:
1837: exception