APPS.GMPPSRP dependencies on DBMS_LOB

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

1079: FROM gmp_bucketed_xml_temp
1080: WHERE bckt_matl_xml_id = p_sequence_num;
1081: l_limit:= 1;
1082:
1083: l_len := DBMS_LOB.GETLENGTH (l_file);
1084: LOOP
1085: IF l_len > l_limit THEN
1086: file_varchar2 := DBMS_LOB.SUBSTR (l_file,10,l_limit);
1087: FND_FILE.PUT(FND_FILE.OUTPUT,file_varchar2);

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

1082:
1083: l_len := DBMS_LOB.GETLENGTH (l_file);
1084: LOOP
1085: IF l_len > l_limit THEN
1086: file_varchar2 := DBMS_LOB.SUBSTR (l_file,10,l_limit);
1087: FND_FILE.PUT(FND_FILE.OUTPUT,file_varchar2);
1088: FND_FILE.PUT(FND_FILE.LOG, file_varchar2);
1089: file_varchar2 := NULL;
1090: l_limit:= l_limit + 10;

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

1088: FND_FILE.PUT(FND_FILE.LOG, file_varchar2);
1089: file_varchar2 := NULL;
1090: l_limit:= l_limit + 10;
1091: ELSE
1092: file_varchar2 := DBMS_LOB.SUBSTR (l_file,10,l_limit);
1093: FND_FILE.PUT(FND_FILE.OUTPUT, file_varchar2);
1094: FND_FILE.PUT(FND_FILE.LOG,file_varchar2);
1095: file_varchar2 := NULL;
1096: EXIT;