APPS.GMO_DISP_CON_PKG dependencies on DBMS_LOB

Line 171: l_len := DBMS_LOB.GETLENGTH (l_final_clob);

167:
168: -- write the XML into out file
169: l_limit:= 1;
170: l_final_clob := l_result.getClobVal();
171: l_len := DBMS_LOB.GETLENGTH (l_final_clob);
172: FND_FILE.PUT(FND_FILE.LOG, 'Size'||l_len);
173: LOOP
174: IF l_len > l_limit THEN
175: l_xml_data := DBMS_LOB.SUBSTR (l_final_clob,10,l_limit);

Line 175: l_xml_data := DBMS_LOB.SUBSTR (l_final_clob,10,l_limit);

171: l_len := DBMS_LOB.GETLENGTH (l_final_clob);
172: FND_FILE.PUT(FND_FILE.LOG, 'Size'||l_len);
173: LOOP
174: IF l_len > l_limit THEN
175: l_xml_data := DBMS_LOB.SUBSTR (l_final_clob,10,l_limit);
176: FND_FILE.PUT(FND_FILE.OUTPUT,l_xml_data);
177: FND_FILE.PUT(FND_FILE.LOG,l_xml_data);
178: l_xml_data := NULL;
179: l_limit:= l_limit + 10;

Line 181: l_xml_data := DBMS_LOB.SUBSTR (l_final_clob,10,l_limit);

177: FND_FILE.PUT(FND_FILE.LOG,l_xml_data);
178: l_xml_data := NULL;
179: l_limit:= l_limit + 10;
180: ELSE
181: l_xml_data := DBMS_LOB.SUBSTR (l_final_clob,10,l_limit);
182: FND_FILE.PUT(FND_FILE.OUTPUT, l_xml_data);
183: FND_FILE.PUT(FND_FILE.LOG,l_xml_data);
184: l_xml_data := NULL;
185: EXIT;

Line 346: l_len := DBMS_LOB.GETLENGTH (l_final_clob);

342:
343: -- write the XML into out file
344: l_limit:= 1;
345: l_final_clob := l_result.getClobVal();
346: l_len := DBMS_LOB.GETLENGTH (l_final_clob);
347: FND_FILE.PUT(FND_FILE.LOG, 'Size'||l_len);
348: LOOP
349: IF l_len > l_limit THEN
350: l_xml_data := DBMS_LOB.SUBSTR (l_final_clob,10,l_limit);

Line 350: l_xml_data := DBMS_LOB.SUBSTR (l_final_clob,10,l_limit);

346: l_len := DBMS_LOB.GETLENGTH (l_final_clob);
347: FND_FILE.PUT(FND_FILE.LOG, 'Size'||l_len);
348: LOOP
349: IF l_len > l_limit THEN
350: l_xml_data := DBMS_LOB.SUBSTR (l_final_clob,10,l_limit);
351: FND_FILE.PUT(FND_FILE.OUTPUT,l_xml_data);
352: FND_FILE.PUT(FND_FILE.LOG,l_xml_data);
353: l_xml_data := NULL;
354: l_limit:= l_limit + 10;

Line 356: l_xml_data := DBMS_LOB.SUBSTR (l_final_clob,10,l_limit);

352: FND_FILE.PUT(FND_FILE.LOG,l_xml_data);
353: l_xml_data := NULL;
354: l_limit:= l_limit + 10;
355: ELSE
356: l_xml_data := DBMS_LOB.SUBSTR (l_final_clob,10,l_limit);
357: FND_FILE.PUT(FND_FILE.OUTPUT, l_xml_data);
358: FND_FILE.PUT(FND_FILE.LOG,l_xml_data);
359: l_xml_data := NULL;
360: EXIT;