APPS.GMPMPACT dependencies on DBMS_LOB

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

2224: FROM gmp_unbucketed_xml_temp
2225: WHERE ubckt_matl_xml_id = p_sequence_num;
2226: l_limit:= 1;
2227:
2228: l_len := DBMS_LOB.GETLENGTH (l_file);
2229: LOOP
2230: IF l_len > l_limit THEN
2231: file_varchar2 := DBMS_LOB.SUBSTR (l_file,10,l_limit);
2232: FND_FILE.PUT(FND_FILE.OUTPUT,file_varchar2);

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

2227:
2228: l_len := DBMS_LOB.GETLENGTH (l_file);
2229: LOOP
2230: IF l_len > l_limit THEN
2231: file_varchar2 := DBMS_LOB.SUBSTR (l_file,10,l_limit);
2232: FND_FILE.PUT(FND_FILE.OUTPUT,file_varchar2);
2233: FND_FILE.PUT(FND_FILE.LOG, file_varchar2);
2234: file_varchar2 := NULL;
2235: l_limit:= l_limit + 10;

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

2233: FND_FILE.PUT(FND_FILE.LOG, file_varchar2);
2234: file_varchar2 := NULL;
2235: l_limit:= l_limit + 10;
2236: ELSE
2237: file_varchar2 := DBMS_LOB.SUBSTR (l_file,10,l_limit);
2238: FND_FILE.PUT(FND_FILE.OUTPUT, file_varchar2);
2239: FND_FILE.PUT(FND_FILE.LOG,file_varchar2);
2240: file_varchar2 := NULL;
2241: EXIT;