APPS.GMP_DESPATCH_LOAD_RPT_PKG dependencies on DBMS_LOB

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

702: WHERE RESDISP_XML_RPT_ID = p_sequence_num;
703:
704: l_limit:= 1;
705:
706: l_len := DBMS_LOB.GETLENGTH (l_file);
707:
708: log_message (' l_len - '||l_len);
709:
710: LOOP

Line 712: file_varchar2 := DBMS_LOB.SUBSTR (l_file,100,l_limit);

708: log_message (' l_len - '||l_len);
709:
710: LOOP
711: IF l_len > l_limit THEN
712: file_varchar2 := DBMS_LOB.SUBSTR (l_file,100,l_limit);
713: FND_FILE.PUT(FND_FILE.OUTPUT,file_varchar2);
714: FND_FILE.PUT(FND_FILE.LOG, file_varchar2);
715: file_varchar2 := NULL;
716: l_limit:= l_limit + 100;

Line 718: file_varchar2 := DBMS_LOB.SUBSTR (l_file,100,l_limit);

714: FND_FILE.PUT(FND_FILE.LOG, file_varchar2);
715: file_varchar2 := NULL;
716: l_limit:= l_limit + 100;
717: ELSE
718: file_varchar2 := DBMS_LOB.SUBSTR (l_file,100,l_limit);
719: FND_FILE.PUT(FND_FILE.OUTPUT, file_varchar2);
720: FND_FILE.PUT(FND_FILE.LOG,file_varchar2);
721: file_varchar2 := NULL;
722: EXIT;