APPS.IBY_TUNNEL_CONFIG_UPG_PKG SQL Statements

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

Line: 11

    l_update_count NUMBER;

Line: 14

      SELECT bepid, suffix, name, baseurl
      FROM iby_bepinfo
      WHERE (NOT baseurl IS NULL)
      ORDER BY last_update_date DESC;

Line: 22

    SELECT transmit_protocol_name
    INTO l_tunnel_name
    FROM iby_transmit_protocols_vl
    WHERE transmit_protocol_code='IBY_DELIVERY_ENVELOPE';

Line: 29

      SELECT iby_transmit_configs_s.nextval INTO l_config_id FROM DUAL;

Line: 32

      UPDATE iby_transmit_configs_b
      SET tunneling_trans_config_id=l_config_id
      WHERE transmit_configuration_id IN
        (SELECT online_auth_trans_config_id
         FROM iby_fndcpt_user_cc_pf_b p, iby_bepkeys k
         WHERE (p.bep_account_id = k.bep_account_id)
           AND (k.bepid = bep_rec.bepid)
        )
        AND (tunneling_trans_config_id IS NULL);

Line: 41

      l_update_count := SQL%ROWCOUNT;

Line: 42

      UPDATE iby_transmit_configs_b
      SET tunneling_trans_config_id=l_config_id
      WHERE transmit_configuration_id IN
        (SELECT settlement_trans_config_id
         FROM iby_fndcpt_user_cc_pf_b p, iby_bepkeys k
         WHERE (p.bep_account_id = k.bep_account_id)
           AND (k.bepid = bep_rec.bepid)
        )
      AND (tunneling_trans_config_id IS NULL);

Line: 51

      l_update_count := l_update_count + SQL%ROWCOUNT;

Line: 52

      UPDATE iby_transmit_configs_b
      SET tunneling_trans_config_id=l_config_id
      WHERE transmit_configuration_id IN
        (SELECT query_trans_config_id
         FROM iby_fndcpt_user_cc_pf_b p, iby_bepkeys k
         WHERE (p.bep_account_id = k.bep_account_id)
           AND (k.bepid = bep_rec.bepid)
        )
        AND (tunneling_trans_config_id IS NULL);

Line: 61

      l_update_count := l_update_count + SQL%ROWCOUNT;

Line: 64

      UPDATE iby_transmit_configs_b
      SET tunneling_trans_config_id=l_config_id
      WHERE transmit_configuration_id IN
        (SELECT online_deb_trans_config_id
         FROM iby_fndcpt_user_dc_pf_b p, iby_bepkeys k
         WHERE (p.bep_account_id = k.bep_account_id)
           AND (k.bepid = bep_rec.bepid)
        )
        AND (tunneling_trans_config_id IS NULL);

Line: 73

      l_update_count := l_update_count + SQL%ROWCOUNT;

Line: 74

      UPDATE iby_transmit_configs_b
      SET tunneling_trans_config_id=l_config_id
      WHERE transmit_configuration_id IN
        (SELECT settlement_trans_config_id
         FROM iby_fndcpt_user_dc_pf_b p, iby_bepkeys k
         WHERE (p.bep_account_id = k.bep_account_id)
           AND (k.bepid = bep_rec.bepid)
        )
        AND (tunneling_trans_config_id IS NULL);

Line: 83

      l_update_count := l_update_count + SQL%ROWCOUNT;

Line: 84

      UPDATE iby_transmit_configs_b
      SET tunneling_trans_config_id=l_config_id
      WHERE transmit_configuration_id IN
        (SELECT query_trans_config_id
         FROM iby_fndcpt_user_dc_pf_b p, iby_bepkeys k
         WHERE (p.bep_account_id = k.bep_account_id)
           AND (k.bepid = bep_rec.bepid)
        )
        AND (tunneling_trans_config_id IS NULL);

Line: 93

      l_update_count := l_update_count + SQL%ROWCOUNT;

Line: 96

      UPDATE iby_transmit_configs_b
      SET tunneling_trans_config_id=l_config_id
      WHERE transmit_configuration_id IN
        (SELECT verify_trans_config_id
         FROM iby_fndcpt_user_eft_pf_b p, iby_bepkeys k
         WHERE (p.bep_account_id = k.bep_account_id)
           AND (k.bepid = bep_rec.bepid)
        )
        AND (tunneling_trans_config_id IS NULL);

Line: 105

      l_update_count := l_update_count + SQL%ROWCOUNT;

Line: 106

      UPDATE iby_transmit_configs_b
      SET tunneling_trans_config_id=l_config_id
      WHERE transmit_configuration_id IN
        (SELECT funds_xfer_trans_config_id
         FROM iby_fndcpt_user_eft_pf_b p, iby_bepkeys k
         WHERE (p.bep_account_id = k.bep_account_id)
           AND (k.bepid = bep_rec.bepid)
        )
        AND (tunneling_trans_config_id IS NULL);

Line: 115

      l_update_count := l_update_count + SQL%ROWCOUNT;

Line: 116

      UPDATE iby_transmit_configs_b
      SET tunneling_trans_config_id=l_config_id
      WHERE transmit_configuration_id IN
        (SELECT query_trans_config_id
         FROM iby_fndcpt_user_eft_pf_b p, iby_bepkeys k
         WHERE (p.bep_account_id = k.bep_account_id)
           AND (k.bepid = bep_rec.bepid)
        )
        AND (tunneling_trans_config_id IS NULL);

Line: 125

      l_update_count := l_update_count + SQL%ROWCOUNT;

Line: 127

      IF (l_update_count>0) THEN
        l_config_name := bep_rec.name || ' ' || l_tunnel_name;

Line: 140

        IBY_PP_MLSUTL_PVT.TRANS_CONFIG_INSERT_ROW
        (lx_rowid,l_config_id,1,null,'IBY_DELIVERY_ENVELOPE',
         null,l_config_name,sysdate,fnd_global.user_id,sysdate,
         fnd_global.user_id,fnd_global.login_id);

Line: 145

        INSERT INTO iby_transmit_values
        (transmit_value_id, transmit_configuration_id, transmit_parameter_code,
         transmit_varchar2_value, transmit_number_value, transmit_date_value,
         created_by, creation_date, last_updated_by, last_update_date,
         last_update_login, object_version_number)
        VALUES
        (iby_transmit_values_s.nextval, l_config_id, 'WEB_URL',
         l_url, null, null,
         fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,
         fnd_global.login_id, 1);