APPS.PER_DATA_UPGRADER_UTIL SQL Statements

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

Line: 14

       select parameter_value
         from pay_action_parameters
	where parameter_name = 'LOGGING';

Line: 84

   ,p_update_name       varchar2
   ,p_batch_size        number
   ,p_upg_proc          varchar2)
is

  l_start_pkid          number;

Line: 102

  l_plsql := 'select count(distinct '||p_pkid_column||'),
                     min('||p_pkid_column||'),
                     max('||p_pkid_column||')
                from '||p_table_name;

Line: 116

    ad_parallel_updates_pkg.initialize_id_range(
         ad_parallel_updates_pkg.ID_RANGE,
         p_table_owner,
         p_table_name,
         p_update_name,
         p_pkid_column,
         p_this_worker_num,
         p_total_num_workers,
         p_batch_size,
         0 -- debug level
         );

Line: 130

    ad_parallel_updates_pkg.get_id_range(
         l_start_pkid,
         l_end_pkid,
         l_any_rows_to_process,
         p_batch_size,
         TRUE -- Restart flag
         );

Line: 163

      ad_parallel_updates_pkg.processed_id_range(
           l_rows_processed,
	   l_end_pkid);

Line: 168

      ** Commit the updates....
      */
      commit;

Line: 175

      ad_parallel_updates_pkg.get_id_range(
           l_start_pkid,
           l_end_pkid,
           l_any_rows_to_process,
           p_batch_size,
           FALSE -- Restart flag
	   );

Line: 189

    ** work so don't use the AD large table update utilities instead
    ** do the call directly but only if this is the first worker.  This means
    ** the other threads should exit without doing anything.
    */
    if p_this_worker_num = 1 then
      l_plsql := 'begin '||p_upg_proc||'(:CTRL, :START, :END, :ROWCOUNT); end;';

Line: 265

    select parameter_value
      into l_number_of_threads
      from pay_action_parameters
     where parameter_name = 'THREADS';

Line: 341

    writeLog('Doing large table update.', 'G', FALSE, 20);

Line: 349

       p_update_name       => p_param4,
       p_batch_size        => p_param5,
       p_upg_proc          => p_process_to_call);