APPS.FTE_BULKLOAD_PKG dependencies on FTE_BULKLOAD_DATA

Line 9: -- table FTE_BULKLOAD_DATA --

5: -- --
6: -- NAME: FTE_BULKLOAD_PKG --
7: -- TYPE: PACKAGE BODY --
8: -- DESCRIPTION: Contains procedures for storing bulkload request data in --
9: -- table FTE_BULKLOAD_DATA --
10: -- --
11: -- PROCEDURES and FUNCTIONS: --
12: -- FUNCTION GET_PROCESS_ID --
13: -- SUBMIT_DATA --

Line 52: -- Purpose: Create a new row in the database table 'FTE_BULKLOAD_DATA' with the

48: END GET_PROCESS_ID;
49:
50: ----------------------------------------------------------------------------------------------
51: -- Procedure: SUBMIT_DATA
52: -- Purpose: Create a new row in the database table 'FTE_BULKLOAD_DATA' with the
53: -- specified parameters when user uses the local file option. This represents a new
54: -- bulkloading request to the concurrent manager.
55: --
56: -- IN parameters:

Line 181: INSERT INTO FTE_BULKLOAD_DATA (LOAD_ID,

177: -- End of Pack J addition for DTT file upload
178: --+
179:
180: v_LastUpdateDate := sysdate;
181: INSERT INTO FTE_BULKLOAD_DATA (LOAD_ID,
182: LOAD_TYPE,
183: FILE_TYPE,
184: FILE_NAME,
185: FILE_SIZE,

Line 776: FROM fte_bulkload_data

772: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Load ID', p_load_id);
773: END IF;
774:
775: SELECT content, file_size INTO l_content, l_size
776: FROM fte_bulkload_data
777: WHERE file_name = p_file_name
778: AND load_id = p_load_id;
779:
780: data_buffer := NULL;

Line 1254: UPDATE FTE_BULKLOAD_DATA

1250: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Load ID', p_loadid);
1251: END IF;
1252:
1253: IF (p_LoadType <> 'DTT_DWNLD') THEN
1254: UPDATE FTE_BULKLOAD_DATA
1255: SET request_id = p_RequestId,
1256: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1257: LAST_UPDATE_DATE = sysdate,
1258: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID

Line 1265: UPDATE FTE_BULKLOAD_DATA

1261: file_type = p_FileType AND
1262: file_name = p_FileName;
1263:
1264: ELSIF (p_LoadType = 'DTT_DWNLD') THEN
1265: UPDATE FTE_BULKLOAD_DATA
1266: SET request_id = p_RequestId,
1267: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1268: LAST_UPDATE_DATE = sysdate,
1269: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID

Line 1334: FROM fte_bulkload_data

1330: EXECUTE IMMEDIATE v_sql_stmt;
1331:
1332: SELECT file_name, load_type
1333: INTO p_FileName, p_LoadType
1334: FROM fte_bulkload_data
1335: WHERE load_id = p_LoadId;
1336:
1337: --For LTL pricelists, we don't upload the file into the database, but rather
1338: --we read the contents of the file directly using UTL_FILE.

Line 1353: FROM fte_bulkload_data

1349: -- the file. There should be only one column returned by this
1350: -- query. The Load ID should be unique.
1351: SELECT content
1352: INTO p_FileContents
1353: FROM fte_bulkload_data
1354: WHERE load_id = p_LoadId
1355: FOR UPDATE;
1356:
1357: -- load the entire file into the charactor LOB.

Line 1363: UPDATE FTE_BULKLOAD_DATA

1359: DBMS_LOB.FILECLOSE(v_FileLocator);
1360:
1361: v_LastUpdateDate := sysdate;
1362:
1363: UPDATE FTE_BULKLOAD_DATA
1364: SET last_update_date = v_LastUpdateDate,
1365: file_size = v_FileSize,
1366: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1367: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID

Line 1372: FROM fte_bulkload_data

1368: WHERE load_id = p_LoadId;
1369: ELSE
1370: SELECT content
1371: INTO p_FileContents
1372: FROM fte_bulkload_data
1373: WHERE load_id = p_LoadId;
1374: END IF;
1375: END IF;
1376: p_ExitStatus := 0;