APPS.GMPMPACT dependencies on DBMS_LOB

Line 1873: DBMS_LOB.createtemporary(temp_clob, TRUE);

1869: -- DELETE FROM GMP_UNBUCKETED_XML_GTMP;
1870: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, x_stmt);
1871:
1872: -- B7481907 Rajesh Patangya starts
1873: DBMS_LOB.createtemporary(temp_clob, TRUE);
1874: DBMS_LOB.createtemporary(result, TRUE);
1875:
1876: qryctx := dbms_xmlgen.newcontext(x_stmt);
1877:

Line 1874: DBMS_LOB.createtemporary(result, TRUE);

1870: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, x_stmt);
1871:
1872: -- B7481907 Rajesh Patangya starts
1873: DBMS_LOB.createtemporary(temp_clob, TRUE);
1874: DBMS_LOB.createtemporary(result, TRUE);
1875:
1876: qryctx := dbms_xmlgen.newcontext(x_stmt);
1877:
1878: -- generate XML data

Line 1880: l_offset := DBMS_LOB.INSTR (lob_loc => temp_clob,

1876: qryctx := dbms_xmlgen.newcontext(x_stmt);
1877:
1878: -- generate XML data
1879: DBMS_XMLGEN.getXML (qryctx, temp_clob, DBMS_XMLGEN.none);
1880: l_offset := DBMS_LOB.INSTR (lob_loc => temp_clob,
1881: pattern => '>',
1882: offset => 1,
1883: nth => 1);
1884: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_offset - '||l_offset);

Line 1887: DBMS_LOB.erase (temp_clob, l_offset,1);

1883: nth => 1);
1884: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_offset - '||l_offset);
1885:
1886: -- Remove the header
1887: DBMS_LOB.erase (temp_clob, l_offset,1);
1888:
1889: -- The following line of code ensures that XML data
1890: -- generated here uses the right encoding
1891: DBMS_LOB.writeappend (result, length(l_xml_header), l_xml_header);

Line 1891: DBMS_LOB.writeappend (result, length(l_xml_header), l_xml_header);

1887: DBMS_LOB.erase (temp_clob, l_offset,1);
1888:
1889: -- The following line of code ensures that XML data
1890: -- generated here uses the right encoding
1891: DBMS_LOB.writeappend (result, length(l_xml_header), l_xml_header);
1892:
1893: -- Append the rest to xml output
1894: DBMS_LOB.append (result, temp_clob);
1895:

Line 1894: DBMS_LOB.append (result, temp_clob);

1890: -- generated here uses the right encoding
1891: DBMS_LOB.writeappend (result, length(l_xml_header), l_xml_header);
1892:
1893: -- Append the rest to xml output
1894: DBMS_LOB.append (result, temp_clob);
1895:
1896: -- close context and free memory
1897: DBMS_XMLGEN.closeContext(qryctx);
1898: DBMS_LOB.FREETEMPORARY (temp_clob);

Line 1898: DBMS_LOB.FREETEMPORARY (temp_clob);

1894: DBMS_LOB.append (result, temp_clob);
1895:
1896: -- close context and free memory
1897: DBMS_XMLGEN.closeContext(qryctx);
1898: DBMS_LOB.FREETEMPORARY (temp_clob);
1899: -- B7481907 Rajesh Patangya Ends
1900:
1901: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
1902: EXECUTE IMMEDIATE seq_stmt INTO x_seq_num ;

Line 2291: l_len := DBMS_LOB.GETLENGTH (l_file);

2287: FROM gmp_unbucketed_xml_temp
2288: WHERE ubckt_matl_xml_id = p_sequence_num;
2289: l_limit:= 1;
2290:
2291: l_len := DBMS_LOB.GETLENGTH (l_file);
2292: LOOP
2293: IF l_len > l_limit THEN
2294: file_varchar2 := DBMS_LOB.SUBSTR (l_file,10,l_limit);
2295: FND_FILE.PUT(FND_FILE.OUTPUT,file_varchar2);

Line 2294: file_varchar2 := DBMS_LOB.SUBSTR (l_file,10,l_limit);

2290:
2291: l_len := DBMS_LOB.GETLENGTH (l_file);
2292: LOOP
2293: IF l_len > l_limit THEN
2294: file_varchar2 := DBMS_LOB.SUBSTR (l_file,10,l_limit);
2295: FND_FILE.PUT(FND_FILE.OUTPUT,file_varchar2);
2296: FND_FILE.PUT(FND_FILE.LOG, file_varchar2);
2297: file_varchar2 := NULL;
2298: l_limit:= l_limit + 10;

Line 2300: file_varchar2 := DBMS_LOB.SUBSTR (l_file,10,l_limit);

2296: FND_FILE.PUT(FND_FILE.LOG, file_varchar2);
2297: file_varchar2 := NULL;
2298: l_limit:= l_limit + 10;
2299: ELSE
2300: file_varchar2 := DBMS_LOB.SUBSTR (l_file,10,l_limit);
2301: FND_FILE.PUT(FND_FILE.OUTPUT, file_varchar2);
2302: FND_FILE.PUT(FND_FILE.LOG,file_varchar2);
2303: file_varchar2 := NULL;
2304: EXIT;