APPS.FTE_BULKLOAD_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 39

    SELECT  qp_process_id_s.nextval
      INTO l_id
      FROM dual;

Line: 78

  v_LastUpdateDate	DATE;

Line: 85

   select fmdf.template_id
   from   fte_mile_download_files fmdf
   where  fmdf.file_name = ci_file_name;

Line: 180

      v_LastUpdateDate := sysdate;

Line: 181

      INSERT INTO FTE_BULKLOAD_DATA (LOAD_ID,
				     LOAD_TYPE,
				     FILE_TYPE,
				     FILE_NAME,
				     FILE_SIZE,
				     REQUEST_ID,
				     CONTENT,
				     CREATED_BY,
				     CREATION_DATE,
				     LAST_UPDATED_BY,
				     LAST_UPDATE_DATE,
				     LAST_UPDATE_LOGIN)

      VALUES (p_LoadId, p_LoadType, p_FileType, p_FileName,
	      0, p_RequestId, EMPTY_BLOB(), FND_GLOBAL.USER_ID,
	      v_LastUpdateDate, FND_GLOBAL.USER_ID, v_LastUpdateDate, FND_GLOBAL.USER_ID);

Line: 645

	  l_block_header.DELETE;

Line: 646

	  l_block_data.DELETE;

Line: 647

	  g_block_header_index.DELETE;

Line: 680

	l_block_header.DELETE;

Line: 681

	l_block_data.DELETE;

Line: 682

	g_block_header_index.DELETE;

Line: 775

    SELECT content, file_size INTO l_content, l_size
      FROM   fte_bulkload_data
      WHERE  file_name = p_file_name
      	AND  load_id = p_load_id;

Line: 865

	    l_block_header.DELETE;

Line: 866

	    l_block_data.DELETE;

Line: 867

	    g_block_header_index.DELETE;

Line: 922

      l_block_header.DELETE;

Line: 923

      l_block_data.DELETE;

Line: 924

      g_block_header_index.DELETE;

Line: 1235

  PROCEDURE UPDATE_RID( p_FileName     IN    VARCHAR2,
      		        p_LoadId       IN    NUMBER,
      			p_FileType     IN    VARCHAR2,
      			p_LoadType     IN    VARCHAR2,
      			p_RequestId    IN    NUMBER ) IS

  l_module_name  CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.UPDATE_RID';

Line: 1254

      UPDATE FTE_BULKLOAD_DATA
	 SET request_id = p_RequestId,
	     LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
	     LAST_UPDATE_DATE = sysdate,
	     LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
        WHERE load_id = p_LoadId AND
         load_type =  p_LoadType AND
         file_type =  p_FileType AND
         file_name =  p_FileName;

Line: 1265

      UPDATE FTE_BULKLOAD_DATA
	 SET request_id = p_RequestId,
	     LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
	     LAST_UPDATE_DATE = sysdate,
	     LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
        WHERE load_id = p_LoadId AND
         load_type =  p_LoadType;

Line: 1283

  END UPDATE_RID;

Line: 1310

  v_LastUpdateDate DATE;

Line: 1332

      SELECT file_name, load_type
        INTO p_FileName, p_LoadType
	FROM fte_bulkload_data
	WHERE load_id = p_LoadId;

Line: 1348

	  -- select the column into which we are going to load
	  -- the file. There should be only one column returned by this
	  -- query. The Load ID should be unique.
          SELECT content
	    INTO p_FileContents
	    FROM fte_bulkload_data
  	    WHERE load_id = p_LoadId
	    FOR UPDATE;

Line: 1361

          v_LastUpdateDate := sysdate;

Line: 1363

	  UPDATE FTE_BULKLOAD_DATA
	    SET  last_update_date = v_LastUpdateDate,
	  	 file_size = v_FileSize,
  	         LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
	     	 LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
	    WHERE load_id = p_LoadId;

Line: 1370

          SELECT content
	    INTO p_FileContents
	    FROM fte_bulkload_data
	    WHERE load_id = p_LoadId;