APPS.GMO_OC_TRANS_PKG dependencies on DBMS_LOB

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

145: CLOSE l_refcur;
146:
147: l_limit:= 1;
148: l_final_clob := l_result.getClobVal();
149: l_len := DBMS_LOB.GETLENGTH (l_final_clob);
150: FND_FILE.PUT(FND_FILE.LOG, 'Size'||l_len);
151: LOOP
152: IF l_len > l_limit THEN
153: l_xml_data := DBMS_LOB.SUBSTR (l_final_clob,10,l_limit);

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

149: l_len := DBMS_LOB.GETLENGTH (l_final_clob);
150: FND_FILE.PUT(FND_FILE.LOG, 'Size'||l_len);
151: LOOP
152: IF l_len > l_limit THEN
153: l_xml_data := DBMS_LOB.SUBSTR (l_final_clob,10,l_limit);
154: FND_FILE.PUT(FND_FILE.OUTPUT,l_xml_data);
155: FND_FILE.PUT(FND_FILE.LOG,l_xml_data);
156: l_xml_data := NULL;
157: l_limit:= l_limit + 10;

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

155: FND_FILE.PUT(FND_FILE.LOG,l_xml_data);
156: l_xml_data := NULL;
157: l_limit:= l_limit + 10;
158: ELSE
159: l_xml_data := DBMS_LOB.SUBSTR (l_final_clob,10,l_limit);
160: FND_FILE.PUT(FND_FILE.OUTPUT, l_xml_data);
161: FND_FILE.PUT(FND_FILE.LOG,l_xml_data);
162: l_xml_data := NULL;
163: EXIT;