APPS.FTE_BULKLOAD_PKG dependencies on DBMS_LOB

Line 122: v_FileExists := DBMS_LOB.FILEEXISTS(v_FileLocator);

118:
119: IF (p_LoadType NOT IN ('LTL_ASSOC', 'DTT_DWNLD')) THEN
120: -- initialize the BFILE locator for reading
121: v_FileLocator := BFILENAME('UPLOAD_DIR', p_FileName);
122: v_FileExists := DBMS_LOB.FILEEXISTS(v_FileLocator);
123: IF v_FileExists <> 1 THEN
124: IF (g_debug_on) THEN
125: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'File Not Found', WSH_DEBUG_SV.c_proc_level);
126: END IF;

Line 789: dbms_lob.read (l_content, l_amount, l_position, temp_buffer);

785: l_last_block_processed := FALSE;
786:
787: WHILE l_size > 0 LOOP
788: --read a big chunk at a time:
789: dbms_lob.read (l_content, l_amount, l_position, temp_buffer);
790: data_buffer := data_buffer || utl_raw.cast_to_varchar2(temp_buffer);
791: data_buffer := replace(data_buffer, g_carriage_return, ''); --dos2unix conversion
792:
793: --Now tokenize by linefeed

Line 1345: DBMS_LOB.FILEOPEN(v_FileLocator, DBMS_LOB.FILE_READONLY);

1341:
1342: IF (upper(l_source_type) = 'SERVER') THEN
1343: -- initialize the BFILE locator for reading
1344: v_FileLocator := BFILENAME('UPLOAD_DIR', p_FileName);
1345: DBMS_LOB.FILEOPEN(v_FileLocator, DBMS_LOB.FILE_READONLY);
1346: v_FileSize := DBMS_LOB.GETLENGTH(v_FileLocator);
1347:
1348: -- select the column into which we are going to load
1349: -- the file. There should be only one column returned by this

Line 1346: v_FileSize := DBMS_LOB.GETLENGTH(v_FileLocator);

1342: IF (upper(l_source_type) = 'SERVER') THEN
1343: -- initialize the BFILE locator for reading
1344: v_FileLocator := BFILENAME('UPLOAD_DIR', p_FileName);
1345: DBMS_LOB.FILEOPEN(v_FileLocator, DBMS_LOB.FILE_READONLY);
1346: v_FileSize := DBMS_LOB.GETLENGTH(v_FileLocator);
1347:
1348: -- select the column into which we are going to load
1349: -- the file. There should be only one column returned by this
1350: -- query. The Load ID should be unique.

Line 1358: DBMS_LOB.LOADFROMFILE(p_FileContents, v_FileLocator, v_FileSize);

1354: WHERE load_id = p_LoadId
1355: FOR UPDATE;
1356:
1357: -- load the entire file into the charactor LOB.
1358: DBMS_LOB.LOADFROMFILE(p_FileContents, v_FileLocator, v_FileSize);
1359: DBMS_LOB.FILECLOSE(v_FileLocator);
1360:
1361: v_LastUpdateDate := sysdate;
1362:

Line 1359: DBMS_LOB.FILECLOSE(v_FileLocator);

1355: FOR UPDATE;
1356:
1357: -- load the entire file into the charactor LOB.
1358: DBMS_LOB.LOADFROMFILE(p_FileContents, v_FileLocator, v_FileSize);
1359: DBMS_LOB.FILECLOSE(v_FileLocator);
1360:
1361: v_LastUpdateDate := sysdate;
1362:
1363: UPDATE FTE_BULKLOAD_DATA