APPS.FND_EXEC_MIG_CMDS SQL Statements

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

Line: 16

      UPDATE fnd_ts_mig_cmds
         SET start_date = sysdate,
             last_update_date = sysdate,
             end_date = null
       WHERE lineno = p_lineno;

Line: 24

      UPDATE fnd_ts_mig_cmds
         SET migration_status = 'SUCCESS',
             end_date = sysdate,
             last_update_date = sysdate,
             error_text = NULL
       WHERE lineno = p_lineno;

Line: 37

       UPDATE fnd_ts_mig_cmds
          SET migration_status = 'ERROR',
              end_date = sysdate,
              error_text = l_err,
              last_update_date = sysdate
        WHERE lineno = p_lineno;

Line: 65

    SELECT lineno,
           owner,
           object_name,
           migration_cmd,
           partitioned,
           parent_owner,
           parent_object_name,
           execution_mode
      FROM fnd_ts_mig_cmds
     WHERE parent_lineno = l_lineno;

Line: 149

    select lineno,
           owner,
           object_name,
           migration_cmd,
           partitioned,
           parent_owner,
           parent_object_name
      from fnd_ts_mig_cmds
     --where object_type IN ('TABLE', 'INDEX', 'MVIEW', 'MV_LOG', 'LONG_INDEX','LONG_MVLOG')
     where object_type IN ('TABLE', 'INDEX', 'MVIEW', 'MV_LOG')
       and migration_status in ('ERROR', 'GENERATED')
       and object_name not like 'FND_TS_MIG_CMDS%'
       and object_name not like 'FND_TS_SIZING%'
       and object_name not like 'FND_TS_PROD_INSTS%'
       AND execution_mode = l_exec_mode
       AND ( (migration_status = 'ERROR' -- for restart
             OR
             (migration_status = 'GENERATED'
              AND start_date IS NOT NULL)) -- for restart of Abort cases
           OR
           (parent_lineno IS NULL)    -- for first time enqueueing
           OR
(migration_status = 'GENERATED' and parent_lineno in (select lineno from fnd_ts_mig_cmds where migration_status='SUCCESS'))  -- for bug 4332349
         )
     order by total_blocks desc;

Line: 181

    update fnd_ts_mig_status set num_threads=num_threads+1 where item='EXE_MIG_CMDS';

Line: 202

    l_string := 'select lineno,
                 owner,
                 object_name,
                 migration_cmd,
                 partitioned,
                 parent_owner,
                 parent_object_name
            from fnd_ts_mig_cmds
           where owner IN '||l_schema_list||'
             and object_type IN (''TABLE'', ''INDEX'', ''MVIEW'', ''MV_LOG'', ''LONG_INDEX'',''LONG_MVLOG'')
             and migration_status in (''ERROR'', ''GENERATED'')
             and object_name not like ''FND_TS_MIG_CMDS%''
             and object_name not like ''FND_TS_SIZING%''
             and object_name not like ''FND_TS_PROD_INSTS%''
             AND execution_mode = '''||p_exec_mode||'''
             AND ( (migration_status = ''ERROR''
                   OR
                   (migration_status = ''GENERATED''
                    AND start_date IS NOT NULL))
                 OR
                 (parent_lineno IS NULL))
           order by total_blocks desc';

Line: 236

     SELECT COUNT(1)
       INTO l_cnt
       FROM v$session
      WHERE module = 'TS_MIGRATE_SEQUENTIAL_OBJECTS'
        AND status <> 'KILLED';

Line: 255

          cmdtab.lineno.DELETE;

Line: 280

          cmdtab.lineno.DELETE;

Line: 355

            SELECT COUNT(1)
              INTO l_cnt
              FROM v$session
             WHERE module = 'TS_MIGRATE_SEQUENTIAL_OBJECTS'
               AND status <> 'KILLED';

Line: 362

                update fnd_ts_mig_status set num_threads=num_threads-1, status=decode(num_threads,1,'SUCCESS',status),detail_message=decode(num_threads,1,'',detail_message) where item='EXE_MIG_CMDS';

Line: 371

                update fnd_ts_mig_status set num_threads=num_threads-1, status=decode(num_threads,1,'SUCCESS',status),detail_message=decode(num_threads,1,'',detail_message) where item='EXE_MIG_CMDS';

Line: 388

    select lineno,
           migration_cmd
      from fnd_ts_mig_cmds
     where owner = p_owner
       and object_type = 'DISABLE_CONSTRAINT'
     order by lineno asc;

Line: 403

        UPDATE fnd_ts_mig_cmds
           SET start_date = sysdate,
               end_date = null
         WHERE lineno = disable_rec.lineno;

Line: 410

        UPDATE fnd_ts_mig_cmds
           SET migration_status = 'SUCCESS',
               end_date = sysdate,
               last_update_date = sysdate,
               error_text = NULL
         WHERE lineno = disable_rec.lineno;

Line: 420

          UPDATE fnd_ts_mig_cmds
             SET migration_status = 'ERROR',
                 end_date = sysdate,
                 error_text = l_err,
                 last_update_date = sysdate
           WHERE lineno = disable_rec.lineno;

Line: 435

    select lineno,
           migration_cmd
      from fnd_ts_mig_cmds
     where owner = p_owner
       and object_type = 'DISABLE_TRIGGER'
     order by lineno asc;

Line: 450

        UPDATE fnd_ts_mig_cmds
           SET start_date = sysdate,
               end_date = null
         WHERE lineno = disable_rec.lineno;

Line: 457

        UPDATE fnd_ts_mig_cmds
           SET migration_status = 'SUCCESS',
               end_date = sysdate,
               last_update_date = sysdate,
               error_text = NULL
         WHERE lineno = disable_rec.lineno;

Line: 467

          UPDATE fnd_ts_mig_cmds
             SET migration_status = 'ERROR',
                 end_date = sysdate,
                 error_text = l_err,
                 last_update_date = sysdate
           WHERE lineno = disable_rec.lineno;

Line: 482

    select lineno,
           migration_cmd
      from fnd_ts_mig_cmds
     where owner = p_owner
       and object_type = 'STOP_QUEUE'
     order by lineno asc;

Line: 497

        UPDATE fnd_ts_mig_cmds
           SET start_date = sysdate,
               end_date = null
         WHERE lineno = disable_rec.lineno;

Line: 504

        UPDATE fnd_ts_mig_cmds
           SET migration_status = 'SUCCESS',
               end_date = sysdate,
               last_update_date = sysdate,
               error_text = NULL
         WHERE lineno = disable_rec.lineno;

Line: 514

          UPDATE fnd_ts_mig_cmds
             SET migration_status = 'ERROR',
                 end_date = sysdate,
                 error_text = l_err,
                 last_update_date = sysdate
           WHERE lineno = disable_rec.lineno;

Line: 529

    select lineno,
           migration_cmd
      from fnd_ts_mig_cmds
     where owner = p_owner
       and object_type = 'DISABLE_POLICY'
     order by lineno asc;

Line: 544

        UPDATE fnd_ts_mig_cmds
           SET start_date = sysdate,
               end_date = null
         WHERE lineno = disable_rec.lineno;

Line: 551

        UPDATE fnd_ts_mig_cmds
           SET migration_status = 'SUCCESS',
               end_date = sysdate,
               last_update_date = sysdate,
               error_text = NULL
         WHERE lineno = disable_rec.lineno;

Line: 561

          UPDATE fnd_ts_mig_cmds
             SET migration_status = 'ERROR',
                 end_date = sysdate,
                 error_text = l_err,
                 last_update_date = sysdate
           WHERE lineno = disable_rec.lineno;

Line: 576

    select lineno,
           migration_cmd
      from fnd_ts_mig_cmds
     where object_type IN ('DISABLE_TRIGGER', 'DISABLE_CONSTRAINT', 'STOP_QUEUE', 'DISABLE_POLICY');

Line: 620

        UPDATE fnd_ts_mig_cmds
           SET start_date = sysdate,
               end_date = null
         WHERE lineno = disable_rec.lineno;

Line: 627

        UPDATE fnd_ts_mig_cmds
           SET migration_status = 'SUCCESS',
               end_date = sysdate,
               last_update_date = sysdate,
               error_text = NULL
         WHERE lineno = disable_rec.lineno;

Line: 637

          UPDATE fnd_ts_mig_cmds
             SET migration_status = 'ERROR',
                 end_date = sysdate,
                 error_text = l_err,
                 last_update_date = sysdate
           WHERE lineno = disable_rec.lineno;

Line: 646

    l_string := 'select lineno, migration_cmd from fnd_ts_mig_cmds
                  where owner IN '||l_schema_list||'
                    and object_type IN (''DISABLE_TRIGGER'', ''DISABLE_CONSTRAINT'', ''STOP_QUEUE'', ''DISABLE_POLICY'')';

Line: 656

        UPDATE fnd_ts_mig_cmds
           SET start_date = sysdate,
               end_date = null
         WHERE lineno = l_lineno;

Line: 663

        UPDATE fnd_ts_mig_cmds
           SET migration_status = 'SUCCESS',
               end_date = sysdate,
               last_update_date = sysdate,
               error_text = NULL
         WHERE lineno = l_lineno;

Line: 673

          UPDATE fnd_ts_mig_cmds
             SET migration_status = 'ERROR',
                 end_date = sysdate,
                 error_text = l_err,
                 last_update_date = sysdate
           WHERE lineno = l_lineno;

Line: 690

    select lineno,
           migration_cmd
      from fnd_ts_mig_cmds
     where owner = p_owner
       and object_type = 'ENABLE_CONSTRAINT'
     order by lineno asc;

Line: 705

        UPDATE fnd_ts_mig_cmds
           SET start_date = sysdate,
               end_date = null
         WHERE lineno = enable_rec.lineno;

Line: 712

        UPDATE fnd_ts_mig_cmds
           SET migration_status = 'SUCCESS',
               end_date = sysdate,
               last_update_date = sysdate,
               error_text = NULL
         WHERE lineno = enable_rec.lineno;

Line: 722

          UPDATE fnd_ts_mig_cmds
             SET migration_status = 'ERROR',
                 end_date = sysdate,
                 error_text = l_err,
                 last_update_date = sysdate
           WHERE lineno = enable_rec.lineno;

Line: 737

    select lineno,
           migration_cmd
      from fnd_ts_mig_cmds
     where owner = p_owner
       and object_type = 'ENABLE_TRIGGER'
     order by lineno asc;

Line: 752

        UPDATE fnd_ts_mig_cmds
           SET start_date = sysdate,
               end_date = null
         WHERE lineno = enable_rec.lineno;

Line: 759

        UPDATE fnd_ts_mig_cmds
           SET migration_status = 'SUCCESS',
               end_date = sysdate,
               last_update_date = sysdate,
               error_text = NULL
         WHERE lineno = enable_rec.lineno;

Line: 769

          UPDATE fnd_ts_mig_cmds
             SET migration_status = 'ERROR',
                 end_date = sysdate,
                 error_text = l_err,
                 last_update_date = sysdate
           WHERE lineno = enable_rec.lineno;

Line: 784

    select lineno,
           migration_cmd
      from fnd_ts_mig_cmds
     where owner = p_owner
       and object_type = 'START_QUEUE'
     order by lineno asc;

Line: 799

        UPDATE fnd_ts_mig_cmds
           SET start_date = sysdate,
               end_date = null
         WHERE lineno = enable_rec.lineno;

Line: 806

        UPDATE fnd_ts_mig_cmds
           SET migration_status = 'SUCCESS',
               end_date = sysdate,
               last_update_date = sysdate,
               error_text = NULL
         WHERE lineno = enable_rec.lineno;

Line: 816

          UPDATE fnd_ts_mig_cmds
             SET migration_status = 'ERROR',
                 end_date = sysdate,
                 error_text = l_err,
                 last_update_date = sysdate
           WHERE lineno = enable_rec.lineno;

Line: 831

    select lineno,
           migration_cmd
      from fnd_ts_mig_cmds
     where owner = p_owner
       and object_type = 'ENABLE_POLICY'
     order by lineno asc;

Line: 846

        UPDATE fnd_ts_mig_cmds
           SET start_date = sysdate,
               end_date = null
         WHERE lineno = enable_rec.lineno;

Line: 853

        UPDATE fnd_ts_mig_cmds
           SET migration_status = 'SUCCESS',
               end_date = sysdate,
               last_update_date = sysdate,
               error_text = NULL
         WHERE lineno = enable_rec.lineno;

Line: 863

          UPDATE fnd_ts_mig_cmds
             SET migration_status = 'ERROR',
                 end_date = sysdate,
                 error_text = l_err,
                 last_update_date = sysdate
           WHERE lineno = enable_rec.lineno;

Line: 878

    select lineno,
           migration_cmd
      from fnd_ts_mig_cmds
     where object_type IN ('ENABLE_TRIGGER', 'ENABLE_CONSTRAINT', 'START_QUEUE', 'ENABLE_POLICY');

Line: 884

      select 1
      from   v$session
/*     where module in ('TS_MIGRATE_SEQUENTIAL_OBJECTS', 'TS_MIGRATE_PARALLEL_OBJECTS') */
      where  module in
     ('TS_MIGRATE_SEQUENTIAL_OBJECTS',
      'TS_MIGRATE_PARALLEL_OBJECTS',
      'TS_SET_DEFAULTS',
      'TS_DISABLE_CMDS',
      'TS_GENERATE_STATEMENTS',
      'TS_POSTMIGRATION_STEPS')
       and status <> 'KILLED';

Line: 899

    select lineno,
           migration_cmd
      from fnd_ts_mig_cmds
     where object_type = 'POSTMIG';

Line: 944

        UPDATE fnd_ts_mig_cmds
           SET start_date = sysdate,
               end_date = null
         WHERE lineno = enable_rec.lineno;

Line: 951

        UPDATE fnd_ts_mig_cmds
           SET migration_status = 'SUCCESS',
               end_date = sysdate,
               last_update_date = sysdate,
               error_text = NULL
         WHERE lineno = enable_rec.lineno;

Line: 961

          UPDATE fnd_ts_mig_cmds
             SET migration_status = 'ERROR',
                 end_date = sysdate,
                 error_text = l_err,
                 last_update_date = sysdate
           WHERE lineno = enable_rec.lineno;

Line: 970

    l_string := 'select lineno, migration_cmd from fnd_ts_mig_cmds
                  where owner IN '||l_schema_list||'
                    and object_type IN (''ENABLE_TRIGGER'', ''ENABLE_CONSTRAINT'', ''START_QUEUE'', ''ENABLE_POLICY'', ''POSTMIG'')';

Line: 979

        UPDATE fnd_ts_mig_cmds
           SET start_date = sysdate,
               end_date = null
         WHERE lineno = l_lineno;

Line: 986

        UPDATE fnd_ts_mig_cmds
           SET migration_status = 'SUCCESS',
               end_date = sysdate,
               last_update_date = sysdate,
               error_text = NULL
         WHERE lineno = l_lineno;

Line: 996

          UPDATE fnd_ts_mig_cmds
             SET migration_status = 'ERROR',
                 end_date = sysdate,
                 error_text = l_err,
                 last_update_date = sysdate
           WHERE lineno = l_lineno;

Line: 1013

         UPDATE fnd_ts_mig_cmds
            SET start_date = sysdate,
                end_date = null
          WHERE lineno = postmig_rec.lineno;

Line: 1020

         UPDATE fnd_ts_mig_cmds
            SET migration_status = 'SUCCESS',
                end_date = sysdate,
                last_update_date = sysdate,
                error_text = NULL
          WHERE lineno = postmig_rec.lineno;

Line: 1030

          UPDATE fnd_ts_mig_cmds
             SET migration_status = 'ERROR',
                 end_date = sysdate,
                 error_text = l_err,
                 last_update_date = sysdate
           WHERE lineno = postmig_rec.lineno;

Line: 1044

    select   *
    from     fnd_ts_mig_cmds
    where    migration_status <> 'SUCCESS'
    and      (object_name like 'FND_TS_MIG_CMDS%'
    or       object_name like 'FND_TS_PROD_INST%'
    or       object_name like 'FND_TS_SIZING%')
    order by lineno;

Line: 1070

      cmd_tab(j).last_update_date := sysdate;

Line: 1075

      cmd_tab(j).last_update_date := sysdate;

Line: 1082

      UPDATE fnd_ts_mig_cmds
         SET migration_status = cmd_tab(j).migration_status,
             start_date = cmd_tab(j).start_date,
             end_date = cmd_tab(j).end_date,
             last_update_date = cmd_tab(j).last_update_date,
             error_text = cmd_tab(j).error_text
       WHERE lineno = cmd_tab(i).lineno;