APPS.PON_FORMS_UTIL_PVT dependencies on DBMS_LOB

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

333: line varchar2(2000);
334: l_index Number;
335: begin
336: g_newline := fnd_global.newline();
337: xmlstr := dbms_lob.SUBSTR(result,32767);
338: loop
339: exit when xmlstr is null;
340: l_index := instr(xmlstr,g_newline);
341: line := substr(xmlstr,1,l_index-1);

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

1741: rollback to SAVEPOINT PON_XMLSCHEMA;
1742:
1743: DBMS_XMLQUERY.closecontext(l_queryCtx);
1744:
1745: l_schemOffset := DBMS_LOB.INSTR(p_schema,'')+12;
1746: DBMS_LOB.TRIM(p_schema,l_schemOffset);
1747:
1748: --The code below removed the
1749: -- from the xsd

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

1742:
1743: DBMS_XMLQUERY.closecontext(l_queryCtx);
1744:
1745: l_schemOffset := DBMS_LOB.INSTR(p_schema,'')+12;
1746: DBMS_LOB.TRIM(p_schema,l_schemOffset);
1747:
1748: --The code below removed the
1749: -- from the xsd
1750:

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

1748: --The code below removed the
1749: -- from the xsd
1750:
1751: -- Get the length of tag for
1752: l_xmlTagOffset := DBMS_LOB.INSTR(p_schema,'>');
1753:
1754: -- Get the position where
1755: -- ends
1756: l_documentOffset := DBMS_LOB.INSTR(p_schema,'>',1,2);

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

1752: l_xmlTagOffset := DBMS_LOB.INSTR(p_schema,'>');
1753:
1754: -- Get the position where
1755: -- ends
1756: l_documentOffset := DBMS_LOB.INSTR(p_schema,'>',1,2);
1757:
1758: -- length of
1759: l_documentTagLength := l_documentOffset-l_xmlTagOffset;
1760: l_blankTextForDocumentTag := '';

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

1765: l_blankTextForDocumentTag := l_blankTextForDocumentTag ||' ';
1766: l_count := l_count+1;
1767: end loop;
1768:
1769: dbms_lob.write(p_schema,l_documentTagLength,l_xmlTagOffset+1,l_blankTextForDocumentTag);
1770:
1771: print_debug_log(l_api_name, 'END ');
1772:
1773: exception