eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_UPGRADE_PARAM_PVT SQL Statements

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

Line: 23


PROCEDURE update_account
          (
          p_bep_account_id          IN NUMBER,
	  p_bepid                   IN NUMBER,
          p_merchant_account_names  IN JTF_VARCHAR2_TABLE_100,
          p_merchant_account_values IN JTF_VARCHAR2_TABLE_100,
          p_online_param_names      IN JTF_VARCHAR2_TABLE_100,
          p_online_param_values     IN JTF_VARCHAR2_TABLE_100,
          p_online_param_types      IN JTF_VARCHAR2_TABLE_100,
          p_settle_param_names      IN JTF_VARCHAR2_TABLE_100,
          p_settle_param_values     IN JTF_VARCHAR2_TABLE_100,
          p_settle_param_types      IN JTF_VARCHAR2_TABLE_100,
          p_query_param_names       IN JTF_VARCHAR2_TABLE_100,
          p_query_param_values      IN JTF_VARCHAR2_TABLE_100,
          p_query_param_types       IN JTF_VARCHAR2_TABLE_100,
          p_commit                  IN VARCHAR2 DEFAULT 'N'
          )
IS

l_user_id    NUMBER;

Line: 49


        SELECT ONLINE_AUTH_TRANS_CONFIG_ID,
               SETTLEMENT_TRANS_CONFIG_ID,
               QUERY_TRANS_CONFIG_ID
        FROM   IBY_FNDCPT_USER_CC_PF_B
        WHERE  BEP_ACCOUNT_ID=ci_bep_account_id;

Line: 57


IS     SELECT 1
       FROM   IBY_BEP_ACCT_OPT_VALS
       WHERE  BEPID=ci_bepid
       AND    BEP_ACCOUNT_ID=ci_bep_account_id;

Line: 66


IS    SELECT  1
      FROM   IBY_TRANSMIT_VALUES
      WHERE  TRANSMIT_CONFIGURATION_ID IN (ci_online_trans_config_id,
	ci_settle_trans_config_id,ci_query_trans_config_id);

Line: 106


                  INSERT INTO IBY_BEP_ACCT_OPT_VALS(
                  BEP_ACCOUNT_ID,
                  BEPID,
                  ACCOUNT_OPTION_CODE,
                  ACCOUNT_OPTION_VALUE,
                  CREATED_BY,
                  CREATION_DATE,
                  LAST_UPDATE_DATE,
                  LAST_UPDATE_LOGIN,
                  LAST_UPDATED_BY,
                  OBJECT_VERSION_NUMBER)
                VALUES(
                  p_bep_account_id,
                  p_bepid,
                  p_merchant_account_names(i),
                  p_merchant_account_values(i),
                  l_user_id,
                  sysdate,
                  sysdate,
                  l_user_id,
                  l_user_id,
                  1);

Line: 175


                  INSERT INTO IBY_TRANSMIT_VALUES(
                  TRANSMIT_VALUE_ID,
                  TRANSMIT_CONFIGURATION_ID,
                  TRANSMIT_PARAMETER_CODE,
                  TRANSMIT_VARCHAR2_VALUE,
                  CREATED_BY,
                  CREATION_DATE,
                  LAST_UPDATE_DATE,
                  LAST_UPDATE_LOGIN,
                  LAST_UPDATED_BY,
                  OBJECT_VERSION_NUMBER)
                VALUES(
                  iby_transmit_values_s.nextval,
                  l_online_config_id,
                  p_online_param_names(i),
                  p_online_param_values(i),
                  l_user_id,
                  sysdate,
                  sysdate,
                  l_user_id,
                  l_user_id,
                  1);

Line: 206


                  INSERT INTO IBY_TRANSMIT_VALUES(
                  TRANSMIT_VALUE_ID,
                  TRANSMIT_CONFIGURATION_ID,
                  TRANSMIT_PARAMETER_CODE,
                  TRANSMIT_NUMBER_VALUE,
                  CREATED_BY,
                  CREATION_DATE,
                  LAST_UPDATE_DATE,
                  LAST_UPDATE_LOGIN,
                  LAST_UPDATED_BY,
                  OBJECT_VERSION_NUMBER)
                VALUES(
                  iby_transmit_values_s.nextval,
                  l_online_config_id,
                  p_online_param_names(i),
                  TO_NUMBER(p_online_param_values(i)),
                  l_user_id,
                  sysdate,
                  sysdate,
                  l_user_id,
                  l_user_id,
                  1);

Line: 237


                  INSERT INTO IBY_TRANSMIT_VALUES(
                  TRANSMIT_VALUE_ID,
                  TRANSMIT_CONFIGURATION_ID,
                  TRANSMIT_PARAMETER_CODE,
                  TRANSMIT_DATE_VALUE,
                  CREATED_BY,
                  CREATION_DATE,
                  LAST_UPDATE_DATE,
                  LAST_UPDATE_LOGIN,
                  LAST_UPDATED_BY,
                  OBJECT_VERSION_NUMBER)
                VALUES(
                  iby_transmit_values_s.nextval,
                  l_online_config_id,
                  p_online_param_names(i),
                  TO_DATE(p_online_param_values(i), 'YYYY/MM/DD'),
                  l_user_id,
                  sysdate,
                  sysdate,
                  l_user_id,
                  l_user_id,
                  1);

Line: 278


                  INSERT INTO IBY_TRANSMIT_VALUES(
                  TRANSMIT_VALUE_ID,
                  TRANSMIT_CONFIGURATION_ID,
                  TRANSMIT_PARAMETER_CODE,
                  TRANSMIT_VARCHAR2_VALUE,
                  CREATED_BY,
                  CREATION_DATE,
                  LAST_UPDATE_DATE,
                  LAST_UPDATE_LOGIN,
                  LAST_UPDATED_BY,
                  OBJECT_VERSION_NUMBER)
                VALUES(
                  iby_transmit_values_s.nextval,
                  l_settle_config_id,
                  p_settle_param_names(i),
                  p_settle_param_values(i),
                  l_user_id,
                  sysdate,
                  sysdate,
                  l_user_id,
                  l_user_id,
                  1);

Line: 309


                  INSERT INTO IBY_TRANSMIT_VALUES(
                  TRANSMIT_VALUE_ID,
                  TRANSMIT_CONFIGURATION_ID,
                  TRANSMIT_PARAMETER_CODE,
                  TRANSMIT_NUMBER_VALUE,
                  CREATED_BY,
                  CREATION_DATE,
                  LAST_UPDATE_DATE,
                  LAST_UPDATE_LOGIN,
                  LAST_UPDATED_BY,
                  OBJECT_VERSION_NUMBER)
                VALUES(
                  iby_transmit_values_s.nextval,
                  l_settle_config_id,
                  p_settle_param_names(i),
                  p_settle_param_values(i),
                  l_user_id,
                  sysdate,
                  sysdate,
                  l_user_id,
                  l_user_id,
                  1);

Line: 340


                  INSERT INTO IBY_TRANSMIT_VALUES(
                  TRANSMIT_VALUE_ID,
                  TRANSMIT_CONFIGURATION_ID,
                  TRANSMIT_PARAMETER_CODE,
                  TRANSMIT_DATE_VALUE,
                  CREATED_BY,
                  CREATION_DATE,
                  LAST_UPDATE_DATE,
                  LAST_UPDATE_LOGIN,
                  LAST_UPDATED_BY,
                  OBJECT_VERSION_NUMBER)
                VALUES(
                  iby_transmit_values_s.nextval,
                  l_settle_config_id,
                  p_settle_param_names(i),
                  TO_DATE(p_settle_param_values(i), 'YYYY/MM/DD'),
                  l_user_id,
                  sysdate,
                  sysdate,
                  l_user_id,
                  l_user_id,
                  1);

Line: 384


                  INSERT INTO IBY_TRANSMIT_VALUES(
                  TRANSMIT_VALUE_ID,
                  TRANSMIT_CONFIGURATION_ID,
                  TRANSMIT_PARAMETER_CODE,
                  TRANSMIT_VARCHAR2_VALUE,
                  CREATED_BY,
                  CREATION_DATE,
                  LAST_UPDATE_DATE,
                  LAST_UPDATE_LOGIN,
                  LAST_UPDATED_BY,
                  OBJECT_VERSION_NUMBER)
                VALUES(
                  iby_transmit_values_s.nextval,
                  l_query_config_id,
                  p_query_param_names(i),
                  p_query_param_values(i),
                  l_user_id,
                  sysdate,
                  sysdate,
                  l_user_id,
                  l_user_id,
                  1);

Line: 414


                  INSERT INTO IBY_TRANSMIT_VALUES(
                  TRANSMIT_VALUE_ID,
                  TRANSMIT_CONFIGURATION_ID,
                  TRANSMIT_PARAMETER_CODE,
                  TRANSMIT_NUMBER_VALUE,
                  CREATED_BY,
                  CREATION_DATE,
                  LAST_UPDATE_DATE,
                  LAST_UPDATE_LOGIN,
                  LAST_UPDATED_BY,
                  OBJECT_VERSION_NUMBER)
                VALUES(
                  iby_transmit_values_s.nextval,
                  l_query_config_id,
                  p_query_param_names(i),
                  p_query_param_values(i),
                  l_user_id,
                  sysdate,
                  sysdate,
                  l_user_id,
                  l_user_id,
                  1);

Line: 445


                  INSERT INTO IBY_TRANSMIT_VALUES(
                  TRANSMIT_VALUE_ID,
                  TRANSMIT_CONFIGURATION_ID,
                  TRANSMIT_PARAMETER_CODE,
                  TRANSMIT_DATE_VALUE,
                  CREATED_BY,
                  CREATION_DATE,
                  LAST_UPDATE_DATE,
                  LAST_UPDATE_LOGIN,
                  LAST_UPDATED_BY,
                  OBJECT_VERSION_NUMBER)
                VALUES(
                  iby_transmit_values_s.nextval,
                  l_query_config_id,
                  p_query_param_names(i),
                  TO_DATE(p_query_param_values(i), 'YYYY/MM/DD'),
                  l_user_id,
                  sysdate,
                  sysdate,
                  l_user_id,
                  l_user_id,
                  1);