APPS.CSI_ML_CREATE_PUB SQL Statements

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

Line: 56

  SELECT a.inst_interface_id
  FROM   csi_instance_interface a
  WHERE  a.process_status = 'X';

Line: 70

  SELECT nvl(FND_PROFILE.VALUE('CSI_OPEN_INTERFACE_COMMIT_RECS'),1000)
  INTO   l_commit_recs
  FROM   dual;

Line: 76

  SELECT ceil(count(1)/l_commit_recs)
  INTO x_count
  FROM csi_instance_interface
  WHERE trunc(source_transaction_date) BETWEEN
              nvl(l_txn_from_date,trunc(source_transaction_date)) AND
              nvl(l_txn_to_date,trunc(source_transaction_date))
  AND process_status = 'R'
  AND parallel_worker_id is NULL
  AND source_system_name = nvl(p_source_system_name,source_system_name);

Line: 101

    UPDATE csi_instance_interface a
    SET process_status        = 'X'
    WHERE trunc(source_transaction_date) BETWEEN
                            nvl(l_txn_from_date,trunc(source_transaction_date)) AND
                            nvl(l_txn_to_date,trunc(source_transaction_date))
    AND process_status = 'R'
    AND source_system_name = nvl(p_source_system_name,source_system_name)
    AND parallel_worker_id is NULL
    AND rownum <= l_commit_recs;

Line: 111

    l_inst_id_tbl.delete;

Line: 324

  SELECT inst_interface_id,process_status
  FROM csi_instance_interface
  WHERE process_status = 'X'
  AND   nvl(transaction_identifier,'-1') = '-1'
  AND parallel_worker_id = pc_parallel_worker_id;

Line: 346

  SELECT nvl(FND_PROFILE.VALUE('CSI_OPEN_INTERFACE_COMMIT_RECS'),1000)
  INTO   l_commit_recs
  FROM   dual;

Line: 357

  SELECT ceil(count(1)/l_commit_recs)
  INTO x_count
  FROM csi_instance_interface
  WHERE trunc(source_transaction_date) BETWEEN
              nvl(l_txn_from_date,trunc(source_transaction_date)) AND
              nvl(l_txn_to_date,trunc(source_transaction_date))
  AND   nvl(transaction_identifier,'-1') = '-1'
  AND process_status = 'R'
  AND source_system_name = nvl(p_source_system_name,source_system_name)
  AND parallel_worker_id = p_worker_id;

Line: 389

      UPDATE csi_instance_interface a
      SET process_status        = 'X'
      WHERE trunc(source_transaction_date) BETWEEN
                              nvl(l_txn_from_date,trunc(source_transaction_date)) AND
                              nvl(l_txn_to_date,trunc(source_transaction_date))
      AND nvl(transaction_identifier,'-1') = '-1'
      AND process_status = 'R'
      AND source_system_name = nvl(p_source_system_name,source_system_name)
      AND parallel_worker_id = p_worker_id
      AND rownum <= l_commit_recs;

Line: 406

      l_inst_id_tbl.delete;

Line: 572

        UPDATE csi_instance_interface
        SET parallel_worker_id = -1
        WHERE inst_interface_id = l_inst_id_tbl(j).inst_interface_id;

Line: 606

        UPDATE csi_instance_interface
        SET parallel_worker_id = -1
        WHERE inst_interface_id = l_inst_id_tbl(j).inst_interface_id;

Line: 621

        UPDATE csi_instance_interface
        SET parallel_worker_id = -1
        WHERE inst_interface_id = l_inst_id_tbl(j).inst_interface_id;

Line: 640

        UPDATE csi_instance_interface
        SET parallel_worker_id = -1
        WHERE inst_interface_id = l_inst_id_tbl(j).inst_interface_id;