APPS.IEX_ATA_PUB SQL Statements

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

Line: 125

    SELECT count(*) into l_str_level_count
    FROM IEX_LOOKUPS_V
    WHERE LOOKUP_TYPE='IEX_RUNNING_LEVEL'
    AND iex_utilities.validate_running_level(LOOKUP_CODE)='Y';

Line: 130

    select iex_utilities.validate_running_level(decode(P_STR_LEVEL,'PARTY','CUSTOMER','ACCOUNT','ACCOUNT','BILLTOSITE','BILL_TO','BILL_TO'))
    into l_str_status
    from dual;

Line: 137

          FND_FILE.PUT_LINE(FND_FILE.LOG, ' Please select the value for Parameter Territory Level');

Line: 221

            g_user_id, g_last_update_login, g_prog_appl_id, g_prog_id,
            g_request_id, g_num_rollup_days, g_conversion_type);

Line: 268

      select to_char( sysdate, 'DD-Mon-YYYY HH24:MI:SS') into l_date_str from dual;

Line: 290

      select to_char( sysdate, 'DD-Mon-YYYY HH24:MI:SS') into l_date_str from dual;

Line: 301

     SELECT count(*) INTO  l_acc_count FROM jtf_tae_1600_cust_trans;

Line: 322

     SELECT count(*) INTO  l_acc_count FROM jtf_tae_1600_cust_WINNERS;

Line: 485

        SELECT fnd_concurrent_requests_s.nextval
        FROM   dual;

Line: 500

    g_last_update_login := TO_NUMBER(fnd_profile.value('CONC_LOGIN_ID'));

Line: 545

        select to_char( sysdate, 'DD-Mon-YYYY HH24:MI:SS') into l_date_str from dual;

Line: 599

        select value into s from V$PARAMETER where name = 'sort_area_size';

Line: 607

        select value into s from V$PARAMETER where name = 'hash_area_size';

Line: 649

        UPDATE JTF_TAE_1001_ACCOUNT_TRANS
            SET worker_id = mod (trans_object_id, l_ActualWorker) + 1;

Line: 651

        IEX_DEBUG('UPDATE JTF_TAE_1001_ACCOUNT_TRANS.worker_id');

Line: 653

        UPDATE JTF_TAE_1001_ACCOUNT_NM_TRANS
            SET worker_id = mod (trans_object_id, l_ActualWorker) + 1;

Line: 655

        IEX_DEBUG('UPDATE JTF_TAE_1001_ACCOUNT_NM_TRANS.worker_id');