APPS.EGO_BULKLOAD_ENTITIES SQL Statements

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

Line: 75

PROCEDURE updateUploadedRowsToIntfTable (p_result_format_usage_id IN  NUMBER)
IS
  l_intf_status_tobe_process  NUMBER;

Line: 85

  UPDATE EGO_BULKLOAD_INTF
  SET process_status = l_intf_status_upload_done
  WHERE resultfmt_usage_id = p_result_format_usage_id
    AND process_status = l_intf_status_tobe_process;

Line: 92

END updateUploadedRowsToIntfTable;

Line: 121

  SELECT  CUSTOMIZATION_APPLICATION_ID,
          REGION_APPLICATION_ID,
          REGION_CODE
  FROM  EGO_RESULTS_FMT_USAGES
  WHERE   RESULTFMT_USAGE_ID = p_rf_id;

Line: 165

  UPDATE EGO_BULKLOAD_INTF
  SET
    PROCESS_STATUS = G_DATA_ROWS_READY_FOR_API,
    LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
    REQUEST_ID = FND_GLOBAL.conc_request_id,
    PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
    PROGRAM_ID = FND_GLOBAL.conc_program_id
  WHERE RESULTFMT_USAGE_ID = result_format_usage_id
    AND process_status = G_DATA_ROWS_UPLOADED_NEW;

Line: 240

        updateUploadedRowsToIntfTable (p_result_format_usage_id => result_format_usage_id);

Line: 249

      UPDATE  EGO_BULKLOAD_INTF
        SET   PROCESS_STATUS = 1
      WHERE   RESULTFMT_USAGE_ID = result_format_usage_id;

Line: 259

        UPDATE EGO_BULKLOAD_INTF SET PROCESS_STATUS = 1
        WHERE RESULTFMT_USAGE_ID = result_format_usage_id;

Line: 282

  updateUploadedRowsToIntfTable (p_result_format_usage_id => result_format_usage_id);

Line: 302

   * it will launch the concurrent program and call API to update
   * the request id into ego_import_batches_b table
   */
  PROCEDURE Run_Import_Program(
            p_resultfmt_usage_id            IN  NUMBER,
            p_user_id                       IN  NUMBER,
            p_language                      IN  VARCHAR2,
            p_resp_id                       IN  NUMBER,
            p_appl_id                       IN  NUMBER,
            p_run_from                      IN  VARCHAR2,
            p_create_new_batch              IN  VARCHAR2,
            p_batch_id                      IN  NUMBER,
            p_batch_name                    IN  VARCHAR2,
            p_auto_imp_on_data_load         IN  VARCHAR2,
            p_auto_match_on_data_load       IN  VARCHAR2,
            p_change_order_option           IN  VARCHAR2,
            p_add_all_items_to_CO           IN  VARCHAR2,
            p_change_order_category         IN  VARCHAR2,
            p_change_order_type             IN  VARCHAR2,
            p_change_order_name             IN  VARCHAR2,
            p_change_order_number           IN  VARCHAR2,
            p_change_order_desc             IN  VARCHAR2,
            p_schedule_date                 IN  DATE,
            p_nir_option                     IN VARCHAR2,
            x_request_id                    OUT NOCOPY NUMBER)
  IS
    l_request_id        NUMBER;

Line: 371

      EGO_IMPORT_PVT.Update_Request_Id_To_Batch(
             p_import_request_id   => l_imp_request_id,
             p_match_request_id    => l_match_request_id,
             p_batch_id            => p_batch_id);