APPS.IBY_QUERYSET_PKG SQL Statements

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

Line: 43

      SELECT count(*)
        INTO num_trxns
        FROM iby_batches_all
       WHERE BatchID = order_id_in;

Line: 49

        SELECT BatchStatus
          INTO status_out
          FROM iby_batches_all
         WHERE BatchID = order_id_in;

Line: 78

        SELECT count(*)
          INTO num_trxns
          FROM iby_transactions_set_v
         WHERE order_id = order_id_in
           AND merchant_id = merchant_id_in
           AND trxn_type IN (2)
           AND split_id = split_id_in
           AND (request_type IN (2,4)
                OR
                request_type IS NULL)
           AND status = 0;

Line: 94

          SELECT TRX.set_trxn_id, TRX.amount, TRX.currency
            INTO prev_set_trxn_id_in_out,price_out,currency_out
            FROM iby_transactions_set_v TRX
           WHERE order_id = order_id_in
             AND merchant_id = merchant_id_in
             AND trxn_type IN (2)
             AND split_id = split_id_in
             AND (request_type IN (2,4)
                  OR
                  request_type IS NULL)
             AND status = 0;

Line: 123

        SELECT count(*)
          INTO num_trxns
          FROM iby_transactions_set_v
         WHERE order_id = order_id_in
           AND merchant_id = merchant_id_in
           AND trxn_type IN (2,4,101) -- auth, authrev, or subsequentauth
           AND split_id = split_id_in
           AND (request_type IN (2,4)
                OR
                request_type IS NULL)
           AND status = 0;

Line: 139

          SELECT count(*)
            INTO num_trxns
            FROM iby_transactions_set_v
           WHERE order_id = order_id_in
             AND merchant_id = merchant_id_in
             AND trxn_type = 4 		-- authrev
             AND split_id = split_id_in
             AND (request_type IN (2,4)
                  OR
                  request_type IS NULL)
             AND status = 0;

Line: 154

            SELECT TRX.set_trxn_id, TRX.amount, TRX.currency
              INTO prev_set_trxn_id_in_out,price_out,currency_out
              FROM iby_transactions_set_v TRX
             WHERE order_id = order_id_in
               AND merchant_id = merchant_id_in
               AND trxn_type = 4         --authrev
               AND split_id = split_id_in
               AND (request_type IN (2,4)
                    OR
                    request_type IS NULL)
               AND status = 0;

Line: 183

          SELECT TRX.set_trxn_id, TRX.amount, TRX.currency
            INTO prev_set_trxn_id_in_out,price_out,currency_out
            FROM iby_transactions_set_v TRX
           WHERE order_id = order_id_in
             AND merchant_id = merchant_id_in
             AND trxn_type IN (2, 4, 101)
             AND split_id = split_id_in
             AND (request_type IN (2,4)
                  OR
                  request_type IS NULL)
             AND status = 0;

Line: 212

        SELECT count(*)
          INTO num_trxns
          FROM iby_transactions_set_v
         WHERE order_id = order_id_in
           AND merchant_id = merchant_id_in
           AND ( trxn_type IN (8, 9)
                 OR
                 (trxn_type = 3 AND request_type IN (2,4)))
           AND split_id = split_id_in;

Line: 226

          SELECT TRX.set_trxn_id, TRX.amount, TRX.currency
            INTO prev_set_trxn_id_in_out,price_out,currency_out
            FROM iby_transactions_set_v TRX
           WHERE order_id = order_id_in
             AND merchant_id = merchant_id_in
             AND  ( trxn_type IN (8, 9)
                    OR
                  (trxn_type = 3 AND request_type IN (2,4)))
             AND split_id = split_id_in;

Line: 250

        SELECT count(*)
          INTO num_trxns
          FROM iby_transactions_set_v
         WHERE order_id = order_id_in
           AND merchant_id = merchant_id_in
           AND trxn_type = 5
           AND split_id = split_id_in;

Line: 262

          SELECT TRX.set_trxn_id, TRX.amount, TRX.currency
            INTO prev_set_trxn_id_in_out,price_out,currency_out
            FROM iby_transactions_set_v TRX
           WHERE order_id = order_id_in
             AND merchant_id = merchant_id_in
             AND trxn_type = 5
             AND split_id = split_id_in;

Line: 300

     SELECT ROUT.bepid , BEP.baseurl, BEP.suffix
       INTO v_id, v_base_url, v_suffix
       FROM iby_bepinfo BEP, iby_routinginfo ROUT
      WHERE UPPER(ROUT.paymentmethodname) = UPPER(payment_name_in)
        AND BEP.bepid = ROUT.bepid
        AND ROUT.configured = 1;

Line: 342

         SELECT status
           FROM iby_transactions_set_v
           WHERE order_id = order_id_in
           AND merchant_id = merchant_id_in
           AND trxn_type IN (tx1, tx2)
           AND split_id = split_id_in
           ORDER BY time DESC;

Line: 394

       SELECT count(*)
         INTO num_trxns
         FROM iby_transactions_set_v
         WHERE order_id = order_id_in
         AND merchant_id = merchant_id_in
         AND trxn_type in (2,3)
         AND request_type = 2;

Line: 408

         SELECT status
           INTO loc_status
           FROM iby_transactions_set_v
           WHERE order_id = order_id_in
           AND merchant_id = merchant_id_in
           AND trxn_type in (2,3)
           AND request_type = 2
           ORDER BY TIME DESC;

Line: 442

         SELECT amount,currency
           FROM iby_transactions_set_v
           WHERE order_id = order_id_in
           AND merchant_id = merchant_id_in
           AND trxn_type IN (tx1, tx2)
           AND split_id = split_id_in
           ORDER BY time DESC;

Line: 484

       SELECT count(*)
         INTO num_trxns
         FROM iby_transactions_set_v
         WHERE order_id = order_id_in
         AND merchant_id = merchant_id_in
         AND trxn_type in (2,3)
         AND request_type = 2;

Line: 495

         SELECT amount,currency
           INTO price_out, currency_out
           FROM iby_transactions_set_v
           WHERE order_id = order_id_in
           AND merchant_id = merchant_id_in
           AND trxn_type in (2,3)
           AND request_type = 2
           ORDER BY TIME DESC;

Line: 534

    SELECT count(*)
      INTO num_trxns
      FROM iby_transactions_set_v
     WHERE order_id = order_id_in
       AND merchant_id = merchant_id_in
       AND split_id = split_id_in
       AND trxn_type = 101;

Line: 548

      SELECT status
        INTO status_out
        FROM iby_transactions_set_v
       WHERE order_id = order_id_in
         AND merchant_id = merchant_id_in
         AND split_id = split_id_in
         AND trxn_type = 101;

Line: 558

    SELECT count(*)
      INTO num_trxns
      FROM iby_transactions_set_v
     WHERE order_id = order_id_in
       AND merchant_id = merchant_id_in
       AND split_id = prev_split_id_in
       AND trxn_type IN (2, 101)
       AND (request_type IN (2,4)
            OR
            request_type IS NULL)
       AND status = 0;

Line: 577

      SELECT set_trxn_id, subseq_auth_ind
        INTO set_trxn_id_out, auth_ind
        FROM iby_transactions_set_v
       WHERE order_id = order_id_in
         AND merchant_id = merchant_id_in
         AND split_id = prev_split_id_in
         AND trxn_type IN (2,101)
         AND (request_type IN (2,4)
              OR
              request_type IS NULL)
         AND status = 0;