APPS.PAY_PRG_PROCESS_EVENTS SQL Statements

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

Line: 277

  l_update_name          varchar2(30);

Line: 310

    l_update_name := 'PAYPRGEVT' ||X_Argument6;

Line: 316

    ad_parallel_updates_pkg.initialize_id_range(
           X_update_type=>ad_parallel_updates_pkg.ID_RANGE,
           X_owner=>l_table_owner,
           X_table=>l_table_name,
           X_script=>l_update_name,
           X_ID_column=>l_id_column,
           X_worker_id=>X_Worker_Id,
           X_num_workers=>X_num_workers,
           X_batch_size=>X_batch_size,
           X_debug_level=>0);

Line: 328

    ad_parallel_updates_pkg.get_id_range(
           l_start_id,
           l_end_id,
           l_any_rows_to_process,
           X_batch_size,
           TRUE);

Line: 365

      ad_parallel_updates_pkg.processed_id_range(
          l_rows_processed,
          l_end_id);

Line: 372

      ad_parallel_updates_pkg.get_id_range(
         l_start_id,
         l_end_id,
         l_any_rows_to_process,
         X_batch_size,
         FALSE);

Line: 472

     select ppe.*
     from pay_process_events ppe
     where ppe.creation_date < fnd_date.canonical_to_date(p_purge_date)
       and ppe.assignment_id between x_start_id and x_end_id
       and (not exists
           (select 1
            from pay_recorded_requests prr
            where prr.attribute1 = ppe.assignment_id
              and prr.attribute_category = 'RETRONOT_ASG')
         or ppe.creation_date < (select prr.recorded_date
                                 from pay_recorded_requests prr
                                 where prr.attribute1 = ppe.assignment_id
                                   and prr.attribute_category = 'RETRONOT_ASG'));

Line: 529

        ppes_table_rec(k).event_update_id := ppe_table_rec(k).event_update_id;

Line: 534

        ppes_table_rec(k).last_update_date := ppe_table_rec(k).last_update_date;

Line: 535

        ppes_table_rec(k).last_updated_by := ppe_table_rec(k).last_updated_by;

Line: 536

        ppes_table_rec(k).last_update_login := ppe_table_rec(k).last_update_login;

Line: 546

     insert into PAY_PROCESS_EVENTS_SHADOW
     values ppes_table_rec(x);

Line: 550

     delete from PAY_PROCESS_EVENTS
     where process_event_id = process_event_rec(x);