424: l_offset := 1;
425:
426: IF (p_file_id IS NOT NULL) THEN
427: SELECT file_data INTO l_xmlBlob_loc 428: FROM fnd_lobs 429: WHERE file_id = p_file_id;
430:
431: l_totalLen := DBMS_LOB.GETLENGTH(l_xmlBlob_loc);
432: l_chunksize := DBMS_LOB.GETCHUNKSIZE(l_xmlBlob_loc);