APPS.CN_PURGE_TABLES_PVT SQL Statements

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

Line: 13

PROCEDURE insert_archive
  (
    table_id   NUMBER,
    seq_num    NUMBER,
    table_name VARCHAR2,
    row_count  NUMBER,
    any_rows_to_process varchar2)
IS
  pragma autonomous_transaction;

Line: 24

   INSERT
     INTO cn_arc_audit_desc_all
     (TABLE_ID,ARCHIVE_PURGE_ID,TABLES_NAME,TABLE_AP_ROWS,ARCHIVE_PURGE_DATE,ANY_ROWS_TO_PROCESS_FLAG,ATTRIBUTE1,
      ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
      VALUES
    (
      table_id           ,
      seq_num            ,
      table_name         ,
      row_count          ,
      sysdate            ,
      any_rows_to_process,
      NULL               ,
      NULL               ,
      NULL               ,
      NULL               ,
      NULL               ,
      fnd_global.user_id ,
      sysdate            ,
      fnd_global.user_id ,
      sysdate            ,
      fnd_global.user_id
    );

Line: 76

PROCEDURE delete_table
  (
    p_start_period_id     IN NUMBER,
    p_end_period_id       IN NUMBER,
    x_start_date          IN DATE,
    x_end_date            IN DATE,
    p_worker_id           IN NUMBER,
    p_no_of_workers       IN NUMBER,
    p_batch_size          IN NUMBER,
    p_table_owner         IN VARCHAR2,
    p_table_name          IN VARCHAR2,
    p_script_name         IN VARCHAR2,
    p_addnl_para          IN VARCHAR2,
    x_row_to_process_flag OUT nocopy VARCHAR2,
    x_return_status       OUT nocopy VARCHAR2
  )
IS
  l_start_rowid rowid;

Line: 103

    'CN_PURGE_TABLES_PVT.delete_table:Start   '
  )
  ;

Line: 108

    'CN_PURGE_TABLES_PVT.delete_table:p_table_name   ' || p_table_name
  )
  ;

Line: 113

    'CN_PURGE_TABLES_PVT.delete_table:p_table_owner   ' || p_table_owner
  )
  ;

Line: 118

    'CN_PURGE_TABLES_PVT.delete_table:p_script_name   ' || p_script_name
  )
  ;

Line: 123

    'CN_PURGE_TABLES_PVT.delete_table:p_worker_id   ' || p_worker_id
  )
  ;

Line: 128

    'CN_PURGE_TABLES_PVT.delete_table:p_no_of_workers   ' || p_no_of_workers
  )
  ;

Line: 133

    'CN_PURGE_TABLES_PVT.delete_table:p_batch_size   ' || p_batch_size
  )
  ;

Line: 136

   SELECT TO_CHAR(sysdate,'dd-mm-rr:hh:mi:ss') INTO l_time FROM dual;

Line: 138

  debugmsg('CN_PURGE_TABLES_PVT.delete_table: delete start l_time    ' || l_time );

Line: 140

  ad_parallel_updates_pkg.initialize_rowid_range( ad_parallel_updates_pkg.ROWID_RANGE, p_table_owner, p_table_name, p_script_name, p_worker_id, p_no_of_workers, p_batch_size, 0);

Line: 142

  debugmsg('CN_PURGE_TABLES_PVT.delete_table:after  ad_parallel_updates_pkg.initialize_rowid_range  ' );

Line: 144

  ad_parallel_updates_pkg.get_rowid_range( l_start_rowid, l_END_rowid, l_any_rows_to_process, p_batch_size, TRUE);

Line: 146

  debugmsg('CN_PURGE_TABLES_PVT.delete_table:after ad_parallel_updates_pkg.get_rowid_range l_any_rows_to_process ' );

Line: 151

    debugmsg('CN_PURGE_TABLES_PVT.delete_table: before loop l_any_rows_to_process is true   ' );

Line: 155

    debugmsg('CN_PURGE_TABLES_PVT.delete_table: before loop l_any_rows_to_process is false   ' );

Line: 165

         DELETE
          /*+ ROWID (cnh) */
           FROM CN_PAYMENT_API_ALL cnh
          WHERE period_id BETWEEN p_start_period_id AND p_end_period_id
        AND rowid BETWEEN l_start_rowid AND l_end_rowid;

Line: 171

         DELETE
          /*+ ROWID (cnh) */
           FROM cn_posting_details_all cnh
          WHERE pay_period_id BETWEEN p_start_period_id AND p_end_period_id
        AND paid_flag = 'Y'
        AND rowid BETWEEN l_start_rowid AND l_end_rowid;

Line: 179

         DELETE
          /*+ ROWID (cnh) */
           FROM cn_payment_transactions_all cnh
          WHERE pay_period_id BETWEEN p_start_period_id AND p_end_period_id
        AND paid_flag = 'Y'
        AND rowid BETWEEN l_start_rowid AND l_end_rowid;

Line: 187

         DELETE
          /*+ ROWID (cnh) */
           FROM cn_commission_lines_all cnh
          WHERE processed_period_id BETWEEN p_start_period_id AND p_end_period_id
        AND rowid BETWEEN l_start_rowid AND l_end_rowid;

Line: 195

         DELETE
          /*+ ROWID (cnh) */
           FROM cn_commission_headers_all cnh
          WHERE processed_period_id BETWEEN p_start_period_id AND p_end_period_id
        AND rowid BETWEEN l_start_rowid AND l_end_rowid;

Line: 201

         DELETE
          /*+ ROWID (cnh) */
           FROM cn_trx_sales_lines_all cnh
          WHERE processed_date BETWEEN x_start_date AND x_end_date
        AND rowid BETWEEN l_start_rowid AND l_end_rowid;

Line: 207

         DELETE
          /*+ ROWID (t1) */
           FROM cn_trx_lines_all tl
          WHERE tl.TRX_ID IN
          (SELECT DISTINCT t.TRX_ID
             FROM cn_trx_all t
            WHERE TRUNC(t.processed_date) BETWEEN x_start_date AND x_end_date
          );

Line: 216

         DELETE
          /*+ ROWID (cnh) */
           FROM cn_trx_all cnh
          WHERE processed_date BETWEEN x_start_date AND x_end_date
        AND rowid BETWEEN l_start_rowid AND l_end_rowid;

Line: 222

         DELETE
          /*+ ROWID (cnh) */
           FROM cn_not_trx_all cnh
          WHERE processed_date BETWEEN x_start_date AND x_end_date
        AND rowid BETWEEN l_start_rowid AND l_end_rowid;

Line: 228

         DELETE
          /*+ ROWID (i) */
           FROM cn_invoice_changes_all i
          WHERE i.comm_lines_api_id IN
          (SELECT DISTINCT c.comm_lines_api_id
             FROM cn_comm_lines_api_all c
            WHERE c.processed_period_id BETWEEN p_start_period_id AND p_end_period_id
          )
        AND rowid BETWEEN l_start_rowid AND l_end_rowid;

Line: 238

         l_sql := 'DELETE
           /*+ ROWID (ih) */
           FROM cn_imp_headers ih
          WHERE ih.imp_header_id IN ' || p_addnl_para ||
        ' AND rowid BETWEEN ' ||  l_start_rowid || ' AND ' || l_end_rowid;

Line: 245

         l_sql := 'DELETE
          /*+ ROWID (cnh) */
           FROM cn_imp_lines cnh
          WHERE import_type_code = ''TRXAPI''
        AND imp_header_id IN ' || p_addnl_para ||
        ' AND rowid BETWEEN ' || l_start_rowid || ' AND ' || l_end_rowid;

Line: 253

         DELETE
          /*+ ROWID (cnh) */
           FROM cn_comm_lines_api_all cnh
          WHERE processed_period_id BETWEEN p_start_period_id AND p_end_period_id
        AND rowid BETWEEN l_start_rowid AND l_end_rowid;

Line: 259

         DELETE
          /*+ ROWID (qa) */
           FROM cn_srp_quota_assigns_all qa
          WHERE qa.srp_plan_assign_id IN
          (SELECT DISTINCT pl.srp_plan_assign_id
             FROM cn_srp_plan_assigns_all pl
            WHERE ((pl.start_date BETWEEN x_start_date AND x_end_date)
          AND (pl.end_date BETWEEN x_start_date AND x_end_date))
          )
        AND rowid BETWEEN l_start_rowid AND l_end_rowid;

Line: 270

         DELETE
          /*+ ROWID (ra) */
           FROM cn_srp_rate_assigns_all ra
          WHERE ra.srp_plan_assign_id IN
          (SELECT DISTINCT pl.srp_plan_assign_id
             FROM cn_srp_plan_assigns_all pl
            WHERE ((pl.start_date BETWEEN x_start_date AND x_end_date)
          AND (pl.end_date BETWEEN x_start_date AND x_end_date))
          )
        AND rowid BETWEEN l_start_rowid AND l_end_rowid;

Line: 281

         DELETE
          /*+ ROWID (ru) */
           FROM cn_srp_rule_uplifts_all ru
          WHERE ru.srp_quota_rule_id IN
          (SELECT DISTINCT qr.srp_quota_rule_id
             FROM cn_srp_quota_rules_all qr
            WHERE qr.srp_plan_assign_id IN
            (SELECT DISTINCT pl.srp_plan_assign_id
               FROM cn_srp_plan_assigns_all pl
              WHERE ((pl.start_date BETWEEN x_start_date AND x_end_date)
            AND (pl.end_date BETWEEN x_start_date AND x_end_date))
            )
          )
        AND rowid BETWEEN l_start_rowid AND l_end_rowid;

Line: 296

         DELETE
          /*+ ROWID (ra) */
           FROM cn_srp_quota_rules_all ra
          WHERE ra.srp_plan_assign_id IN
          (SELECT DISTINCT pl.srp_plan_assign_id
             FROM cn_srp_plan_assigns_all pl
            WHERE ((pl.start_date BETWEEN x_start_date AND x_end_date)
          AND (pl.end_date BETWEEN x_start_date AND x_end_date))
          )
        AND rowid BETWEEN l_start_rowid AND l_end_rowid;

Line: 307

         DELETE
          /*+ ROWID (cnh) */
           FROM cn_srp_plan_assigns_all cnh
          WHERE ((start_date BETWEEN x_start_date AND x_end_date)
        AND (end_date BETWEEN x_start_date AND x_end_date))
        AND rowid BETWEEN l_start_rowid AND l_end_rowid;

Line: 314

         DELETE
          /*+ ROWID (qe) */
           FROM cn_srp_period_quotas_ext_all qe
          WHERE qe.srp_period_quota_id IN
          (SELECT DISTINCT qa.srp_period_quota_id
             FROM cn_srp_period_quotas_all qa
            WHERE qa.period_id BETWEEN p_start_period_id AND p_end_period_id
          )
        AND rowid BETWEEN l_start_rowid AND l_end_rowid;

Line: 324

         DELETE
          /*+ ROWID (cnh) */
           FROM cn_srp_per_quota_rc_all cnh
          WHERE period_id BETWEEN p_start_period_id AND p_end_period_id
        AND rowid BETWEEN l_start_rowid AND l_end_rowid;

Line: 330

         DELETE
          /*+ ROWID (cnh) */
           FROM cn_srp_period_quotas_all cnh
          WHERE period_id BETWEEN p_start_period_id AND p_end_period_id
        AND rowid BETWEEN l_start_rowid AND l_end_rowid;

Line: 336

         DELETE
          /*+ ROWID (af) */
           FROM cn_pay_approval_flow_all af
          WHERE af.payrun_id IN
          (SELECT DISTINCT pa.payrun_id
             FROM cn_payruns_all pa
            WHERE pa.PAY_PERIOD_ID BETWEEN p_start_period_id AND p_end_period_id
          )
        AND rowid BETWEEN l_start_rowid AND l_end_rowid;

Line: 346

         DELETE
          /*+ ROWID (cnh) */
           FROM cn_worksheet_qg_dtls_all cnh
          WHERE period_id BETWEEN p_start_period_id AND p_end_period_id
        AND rowid BETWEEN l_start_rowid AND l_end_rowid;

Line: 352

         DELETE
          /*+ ROWID (pw) */
           FROM cn_payment_worksheets_all pw
          WHERE pw.payrun_id IN
          (SELECT DISTINCT pa.payrun_id
             FROM cn_payruns_all pa
            WHERE pa.PAY_PERIOD_ID BETWEEN p_start_period_id AND p_end_period_id
          )
        AND rowid BETWEEN l_start_rowid AND l_end_rowid;

Line: 362

         DELETE
          /*+ ROWID (je) */
           FROM cn_ledger_journal_entries_all je
          WHERE je.srp_period_id IN
          (SELECT DISTINCT sp.srp_period_id
             FROM cn_srp_periods_all sp
            WHERE sp.period_id BETWEEN p_start_period_id AND p_end_period_id
          )
        AND rowid BETWEEN l_start_rowid AND l_end_rowid;

Line: 372

         DELETE
          /*+ ROWID (cnh) */
           FROM cn_posting_details_sum_all cnh
          WHERE pay_period_id BETWEEN p_start_period_id AND p_end_period_id
        AND rowid BETWEEN l_start_rowid AND l_end_rowid;

Line: 378

         DELETE
          /*+ ROWID (wb) */
           FROM cn_worksheet_bonuses_all wb
          WHERE wb.payrun_id IN
          (SELECT DISTINCT pa.payrun_id
             FROM cn_payruns_all pa
            WHERE pa.PAY_PERIOD_ID BETWEEN p_start_period_id AND p_end_period_id
          )
        AND rowid BETWEEN l_start_rowid AND l_end_rowid;

Line: 388

         DELETE
          /*+ ROWID (pw) */
           FROM cn_payment_worksheets_all pw
          WHERE pw.payrun_id IN
          (SELECT DISTINCT pa.payrun_id
             FROM cn_payruns_all pa
            WHERE pa.PAY_PERIOD_ID BETWEEN p_start_period_id AND p_end_period_id
          )
        AND rowid BETWEEN l_start_rowid AND l_end_rowid;

Line: 398

         DELETE
          /*+ ROWID (cnh) */
           FROM cn_payruns_all cnh
          WHERE pay_period_id BETWEEN p_start_period_id AND p_end_period_id
        AND rowid BETWEEN l_start_rowid AND l_end_rowid;

Line: 404

         DELETE
          /*+ ROWID (cnh) */
           FROM cn_srp_periods_all cnh
          WHERE period_id BETWEEN p_start_period_id AND p_end_period_id
        AND rowid BETWEEN l_start_rowid AND l_end_rowid;

Line: 411

         DELETE
          /*+ ROWID (cnh) */
           FROM cn_process_audits_all cnh
          WHERE rowid BETWEEN l_start_rowid AND l_end_rowid;

Line: 417

         DELETE
          /*+ ROWID (cnh) */
           FROM cn_process_audit_lines_all cnh
          WHERE rowid BETWEEN l_start_rowid AND l_end_rowid;

Line: 423

         DELETE
          /*+ ROWID (cnh) */
           FROM cn_process_batches_all cnh
          WHERE period_id BETWEEN p_start_period_id AND p_end_period_id
        AND rowid BETWEEN l_start_rowid AND l_end_rowid;

Line: 430

         DELETE
          /*+ ROWID (cnh) */
           FROM cn_srp_intel_periods_all cnh
          WHERE period_id BETWEEN p_start_period_id AND p_end_period_id
        AND rowid BETWEEN l_start_rowid AND l_end_rowid;

Line: 440

      debugmsg('Before ad_parallel_updates_pkg.processed_rowid_range value_error - ' || sqlerrm);

Line: 443

      debugmsg('Before ad_parallel_updates_pkg.processed_rowid_range error - ' || sqlerrm);

Line: 447

    ad_parallel_updates_pkg.processed_rowid_range( l_rows_processed, l_END_rowid);

Line: 452

    ad_parallel_updates_pkg.get_rowid_range( l_start_rowid, l_end_rowid, l_any_rows_to_process, p_batch_size, FALSE);

Line: 456

  SELECT TO_CHAR(sysdate,'dd-mm-rr:hh:mi:ss') INTO l_time FROM dual;

Line: 457

  debugmsg('CN_PURGE_TABLES_PVT.delete_table: delete end l_time    ' || l_time );

Line: 458

  debugmsg('CN_PURGE_TABLES_PVT.delete_table:end  final   ' );

Line: 468

END delete_table;

Line: 490

  SELECT DISTINCT h.imp_header_id
       FROM cn_imp_headers h
      WHERE exists (select distinct l.imp_header_id from cn_imp_lines l where h.imp_header_id = l.imp_header_id
      and to_date(l.col3, 'dd-mm-rr') between  x_start_date AND x_end_date
      and h.imp_header_id not in (select distinct l2.imp_header_id from cn_imp_lines l2 where
      to_date(l2.col3, 'dd-mm-rr')  not between  x_start_date AND x_end_date
      ));

Line: 524

  delete_table ( p_start_period_id => p_start_period_id,
                p_end_period_id => p_end_period_id,
                x_start_date => x_start_date,
                x_end_date => x_end_date,
                p_worker_id => p_worker_id,
                p_no_of_workers => p_no_of_workers,
                p_batch_size => p_batch_size,
                p_table_owner => l_table_owner,
                p_table_name => upper(l_table_name),
                p_script_name => g_script_name || '_' || p_cn_archive_all_s,
                p_addnl_para => '',
                x_row_to_process_flag => l_any_rows_to_process,
                x_return_status => x_return_status );

Line: 540

  delete_table ( p_start_period_id => p_start_period_id,
                p_end_period_id => p_end_period_id,
                x_start_date => x_start_date,
                x_end_date => x_end_date,
                p_worker_id => p_worker_id,
                p_no_of_workers => p_no_of_workers,
                p_batch_size => p_batch_size,
                p_table_owner => l_table_owner,
                p_table_name => upper(l_table_name),
                p_script_name => g_script_name || '_' || p_cn_archive_all_s,
                p_addnl_para => '',
                x_row_to_process_flag => l_any_rows_to_process,
                x_return_status => x_return_status );

Line: 556

  delete_table ( p_start_period_id => p_start_period_id,
                p_end_period_id => p_end_period_id,
                x_start_date => x_start_date,
                x_end_date => x_end_date,
                p_worker_id => p_worker_id,
                p_no_of_workers => p_no_of_workers,
                p_batch_size => p_batch_size,
                p_table_owner => l_table_owner,
                p_table_name => upper(l_table_name),
                p_script_name => g_script_name || '_' || p_cn_archive_all_s,
                p_addnl_para => '',
                x_row_to_process_flag => l_any_rows_to_process,
                x_return_status => x_return_status );

Line: 572

  delete_table ( p_start_period_id => p_start_period_id,
                p_end_period_id => p_end_period_id,
                x_start_date => x_start_date,
                x_end_date => x_end_date,
                p_worker_id => p_worker_id,
                p_no_of_workers => p_no_of_workers,
                p_batch_size => p_batch_size,
                p_table_owner => l_table_owner,
                p_table_name => upper(l_table_name),
                p_script_name => g_script_name || '_' || p_cn_archive_all_s,
                p_addnl_para => '',
                x_row_to_process_flag => l_any_rows_to_process,
                x_return_status => x_return_status );

Line: 588

  delete_table ( p_start_period_id => p_start_period_id,
                p_end_period_id => p_end_period_id,
                x_start_date => x_start_date,
                x_end_date => x_end_date,
                p_worker_id => p_worker_id,
                p_no_of_workers => p_no_of_workers,
                p_batch_size => p_batch_size,
                p_table_owner => l_table_owner,
                p_table_name => upper(l_table_name),
                p_script_name => g_script_name || '_' || p_cn_archive_all_s,
                p_addnl_para => '',
                x_row_to_process_flag => l_any_rows_to_process,
                x_return_status => x_return_status );

Line: 605

  delete_table ( p_start_period_id => p_start_period_id,
                p_end_period_id => p_end_period_id,
                x_start_date => x_start_date,
                x_end_date => x_end_date,
                p_worker_id => p_worker_id,
                p_no_of_workers => p_no_of_workers,
                p_batch_size => p_batch_size,
                p_table_owner => l_table_owner,
                p_table_name => upper(l_table_name),
                p_script_name => g_script_name || '_' || p_cn_archive_all_s,
                p_addnl_para => '',
                x_row_to_process_flag => l_any_rows_to_process,
                x_return_status => x_return_status );

Line: 622

  delete_table ( p_start_period_id => p_start_period_id,
                p_end_period_id => p_end_period_id,
                x_start_date => x_start_date,
                x_end_date => x_end_date,
                p_worker_id => p_worker_id,
                p_no_of_workers => p_no_of_workers,
                p_batch_size => p_batch_size,
                p_table_owner => l_table_owner,
                p_table_name => upper(l_table_name),
                p_script_name => g_script_name || '_' || p_cn_archive_all_s,
                p_addnl_para => '',
                x_row_to_process_flag => l_any_rows_to_process,
                x_return_status => x_return_status );

Line: 639

  delete_table ( p_start_period_id => p_start_period_id,
                p_end_period_id => p_end_period_id,
                x_start_date => x_start_date,
                x_end_date => x_end_date,
                p_worker_id => p_worker_id,
                p_no_of_workers => p_no_of_workers,
                p_batch_size => p_batch_size,
                p_table_owner => l_table_owner,
                p_table_name => upper(l_table_name),
                p_script_name => g_script_name || '_' || p_cn_archive_all_s,
                p_addnl_para => '',
                x_row_to_process_flag => l_any_rows_to_process,
                x_return_status => x_return_status );

Line: 655

  delete_table ( p_start_period_id => p_start_period_id,
                p_end_period_id => p_end_period_id,
                x_start_date => x_start_date,
                x_end_date => x_end_date,
                p_worker_id => p_worker_id,
                p_no_of_workers => p_no_of_workers,
                p_batch_size => p_batch_size,
                p_table_owner => l_table_owner,
                p_table_name => upper(l_table_name),
                p_script_name => g_script_name || '_' || p_cn_archive_all_s,
                p_addnl_para => '',
                x_row_to_process_flag => l_any_rows_to_process,
                x_return_status => x_return_status );

Line: 671

  delete_table ( p_start_period_id => p_start_period_id,
                p_end_period_id => p_end_period_id,
                x_start_date => x_start_date,
                x_end_date => x_end_date,
                p_worker_id => p_worker_id,
                p_no_of_workers => p_no_of_workers,
                p_batch_size => p_batch_size,
                p_table_owner => l_table_owner,
                p_table_name => upper(l_table_name),
                p_script_name => g_script_name || '_' || p_cn_archive_all_s,
                p_addnl_para => '',
                x_row_to_process_flag => l_any_rows_to_process,
                x_return_status => x_return_status );

Line: 713

      delete_table ( p_start_period_id => p_start_period_id,
                p_end_period_id => p_end_period_id,
                x_start_date => x_start_date,
                x_end_date => x_end_date,
                p_worker_id => p_worker_id,
                p_no_of_workers => p_no_of_workers,
                p_batch_size => p_batch_size,
                p_table_owner => l_table_owner,
                p_table_name => upper(l_table_name),
                p_script_name => g_script_name || '_' || p_cn_archive_all_s,
                p_addnl_para => l_imp_header_id_list,
                x_row_to_process_flag => l_any_rows_to_process,
                x_return_status => x_return_status );

Line: 729

      delete_table ( p_start_period_id => p_start_period_id,
                p_end_period_id => p_end_period_id,
                x_start_date => x_start_date,
                x_end_date => x_end_date,
                p_worker_id => p_worker_id,
                p_no_of_workers => p_no_of_workers,
                p_batch_size => p_batch_size,
                p_table_owner => l_table_owner,
                p_table_name => upper(l_table_name),
                p_script_name => g_script_name || '_' || p_cn_archive_all_s,
                p_addnl_para => l_imp_header_id_list,
                x_row_to_process_flag => l_any_rows_to_process,
                x_return_status => x_return_status );

Line: 753

  delete_table ( p_start_period_id => p_start_period_id,
                p_end_period_id => p_end_period_id,
                x_start_date => x_start_date,
                x_end_date => x_end_date,
                p_worker_id => p_worker_id,
                p_no_of_workers => p_no_of_workers,
                p_batch_size => p_batch_size,
                p_table_owner => l_table_owner,
                p_table_name => upper(l_table_name),
                p_script_name => g_script_name || '_' || p_cn_archive_all_s,
                p_addnl_para => '',
                x_row_to_process_flag => l_any_rows_to_process,
                x_return_status => x_return_status );

Line: 796

  SELECT DISTINCT h.imp_header_id
       FROM cn_imp_headers h
      WHERE exists (select distinct l.imp_header_id from cn_imp_lines l where h.imp_header_id = l.imp_header_id
      and to_date(l.col3, 'dd-mm-rr') between  x_start_date AND x_end_date
      and h.imp_header_id not in (select distinct l2.imp_header_id from cn_imp_lines l2 where
      to_date(l2.col3, 'dd-mm-rr')  not between  x_start_date AND x_end_date
      ));

Line: 831

   SELECT COUNT(*)
     INTO l_row_count
     FROM cn_payment_api_all
    WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;

Line: 838

  insert_archive(cn_payment_api_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 842

   SELECT COUNT(*)
     INTO l_row_count
     FROM cn_posting_details_all
    WHERE pay_period_id BETWEEN p_start_period_id AND p_end_period_id
  AND paid_flag = 'Y';

Line: 850

  insert_archive(cn_posting_details_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 854

   SELECT COUNT(*)
     INTO l_row_count
     FROM cn_payment_transactions_all
    WHERE pay_period_id BETWEEN p_start_period_id AND p_end_period_id
  AND paid_flag = 'Y';

Line: 862

  insert_archive(cn_payment_transactions_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 866

   SELECT COUNT(*)
     INTO l_row_count
     FROM cn_commission_lines_all
    WHERE processed_period_id BETWEEN p_start_period_id AND p_end_period_id;

Line: 874

  insert_archive(cn_commission_lines_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 878

   SELECT COUNT(*)
     INTO l_row_count
     FROM cn_commission_headers_all
    WHERE processed_period_id BETWEEN p_start_period_id AND p_end_period_id;

Line: 886

  insert_archive(cn_commission_headers_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 890

   SELECT COUNT(*)
     INTO l_row_count
     FROM cn_trx_sales_lines_all
    WHERE TRUNC(processed_date) BETWEEN x_start_date AND x_end_date;

Line: 898

  insert_archive(cn_trx_sales_lines_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 902

   SELECT COUNT(*)
     INTO l_row_count
     FROM cn_trx_lines_all tl
    WHERE tl.TRX_ID IN
    (SELECT DISTINCT t.TRX_ID
       FROM cn_trx_all t
      WHERE TRUNC(t.processed_date) BETWEEN x_start_date AND x_end_date
    );

Line: 914

  insert_archive(cn_trx_lines_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 918

   SELECT COUNT(*)
     INTO l_row_count
     FROM cn_trx_all
    WHERE TRUNC(processed_date) BETWEEN x_start_date AND x_end_date;

Line: 926

  insert_archive(cn_trx_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 930

   SELECT COUNT(*)
     INTO l_row_count
     FROM cn_not_trx_all
    WHERE processed_date BETWEEN x_start_date AND x_end_date;

Line: 938

  insert_archive(cn_not_trx_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 942

   SELECT COUNT(*)
     INTO l_row_count
     FROM cn_invoice_changes_all i
    WHERE i.comm_lines_api_id IN
    (SELECT DISTINCT c.comm_lines_api_id
       FROM cn_comm_lines_api_all c
      WHERE c.processed_period_id BETWEEN p_start_period_id AND p_end_period_id
    );

Line: 954

  insert_archive(cn_invoice_changes_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 984

     l_sql := 'SELECT COUNT(*) FROM cn_imp_lines WHERE import_type_code = ''TRXAPI'' AND imp_header_id in ' || l_imp_header_id_list;

Line: 991

      insert_archive(cn_imp_lines_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 996

      l_sql := 'SELECT COUNT(*) FROM cn_imp_headers ih WHERE ih.imp_header_id IN ' || l_imp_header_id_list;

Line: 1003

      insert_archive(cn_imp_headers_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 1015

   SELECT COUNT(*)
     INTO l_row_count
     FROM cn_comm_lines_api_all
    WHERE processed_period_id BETWEEN p_start_period_id AND p_end_period_id;

Line: 1023

  insert_archive(cn_comm_lines_api_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 1076

  delete_table ( p_start_period_id => p_start_period_id,
                p_end_period_id => p_end_period_id,
                x_start_date => x_start_date,
                x_end_date => x_end_date,
                p_worker_id => p_worker_id,
                p_no_of_workers => p_no_of_workers,
                p_batch_size => p_batch_size,
                p_table_owner => l_table_owner,
                p_table_name => upper(l_table_name),
                p_script_name => g_script_name || '_' || p_cn_archive_all_s,
                p_addnl_para => '',
                x_row_to_process_flag => l_any_rows_to_process,
                x_return_status => x_return_status );

Line: 1093

  delete_table ( p_start_period_id => p_start_period_id,
                p_end_period_id => p_end_period_id,
                x_start_date => x_start_date,
                x_end_date => x_end_date,
                p_worker_id => p_worker_id,
                p_no_of_workers => p_no_of_workers,
                p_batch_size => p_batch_size,
                p_table_owner => l_table_owner,
                p_table_name => upper(l_table_name),
                p_script_name => g_script_name || '_' || p_cn_archive_all_s,
                p_addnl_para => '',
                x_row_to_process_flag => l_any_rows_to_process,
                x_return_status => x_return_status );

Line: 1109

  delete_table ( p_start_period_id => p_start_period_id,
                p_end_period_id => p_end_period_id,
                x_start_date => x_start_date,
                x_end_date => x_end_date,
                p_worker_id => p_worker_id,
                p_no_of_workers => p_no_of_workers,
                p_batch_size => p_batch_size,
                p_table_owner => l_table_owner,
                p_table_name => upper(l_table_name),
                p_script_name => g_script_name || '_' || p_cn_archive_all_s,
                p_addnl_para => '',
                x_row_to_process_flag => l_any_rows_to_process,
                x_return_status => x_return_status );

Line: 1126

  delete_table ( p_start_period_id => p_start_period_id,
                p_end_period_id => p_end_period_id,
                x_start_date => x_start_date,
                x_end_date => x_end_date,
                p_worker_id => p_worker_id,
                p_no_of_workers => p_no_of_workers,
                p_batch_size => p_batch_size,
                p_table_owner => l_table_owner,
                p_table_name => upper(l_table_name),
                p_script_name => g_script_name || '_' || p_cn_archive_all_s,
                p_addnl_para => '',
                x_row_to_process_flag => l_any_rows_to_process,
                x_return_status => x_return_status );

Line: 1142

  delete_table ( p_start_period_id => p_start_period_id,
                p_end_period_id => p_end_period_id,
                x_start_date => x_start_date,
                x_end_date => x_end_date,
                p_worker_id => p_worker_id,
                p_no_of_workers => p_no_of_workers,
                p_batch_size => p_batch_size,
                p_table_owner => l_table_owner,
                p_table_name => upper(l_table_name),
                p_script_name => g_script_name || '_' || p_cn_archive_all_s,
                p_addnl_para => '',
                x_row_to_process_flag => l_any_rows_to_process,
                x_return_status => x_return_status );

Line: 1158

  delete_table ( p_start_period_id => p_start_period_id,
                p_end_period_id => p_end_period_id,
                x_start_date => x_start_date,
                x_end_date => x_end_date,
                p_worker_id => p_worker_id,
                p_no_of_workers => p_no_of_workers,
                p_batch_size => p_batch_size,
                p_table_owner => l_table_owner,
                p_table_name => upper(l_table_name),
                p_script_name => g_script_name || '_' || p_cn_archive_all_s,
                p_addnl_para => '',
                x_row_to_process_flag => l_any_rows_to_process,
                x_return_status => x_return_status );

Line: 1175

  delete_table ( p_start_period_id => p_start_period_id,
                p_end_period_id => p_end_period_id,
                x_start_date => x_start_date,
                x_end_date => x_end_date,
                p_worker_id => p_worker_id,
                p_no_of_workers => p_no_of_workers,
                p_batch_size => p_batch_size,
                p_table_owner => l_table_owner,
                p_table_name => upper(l_table_name),
                p_script_name => g_script_name || '_' || p_cn_archive_all_s,
                p_addnl_para => '',
                x_row_to_process_flag => l_any_rows_to_process,
                x_return_status => x_return_status );

Line: 1191

  delete_table ( p_start_period_id => p_start_period_id,
                p_end_period_id => p_end_period_id,
                x_start_date => x_start_date,
                x_end_date => x_end_date,
                p_worker_id => p_worker_id,
                p_no_of_workers => p_no_of_workers,
                p_batch_size => p_batch_size,
                p_table_owner => l_table_owner,
                p_table_name => upper(l_table_name),
                p_script_name => g_script_name || '_' || p_cn_archive_all_s,
                p_addnl_para => '',
                x_row_to_process_flag => l_any_rows_to_process,
                x_return_status => x_return_status );

Line: 1207

  delete_table ( p_start_period_id => p_start_period_id,
                p_end_period_id => p_end_period_id,
                x_start_date => x_start_date,
                x_end_date => x_end_date,
                p_worker_id => p_worker_id,
                p_no_of_workers => p_no_of_workers,
                p_batch_size => p_batch_size,
                p_table_owner => l_table_owner,
                p_table_name => upper(l_table_name),
                p_script_name => g_script_name || '_' || p_cn_archive_all_s,
                p_addnl_para => '',
                x_row_to_process_flag => l_any_rows_to_process,
                x_return_status => x_return_status );

Line: 1223

  delete_table ( p_start_period_id => p_start_period_id,
                p_end_period_id => p_end_period_id,
                x_start_date => x_start_date,
                x_end_date => x_end_date,
                p_worker_id => p_worker_id,
                p_no_of_workers => p_no_of_workers,
                p_batch_size => p_batch_size,
                p_table_owner => l_table_owner,
                p_table_name => upper(l_table_name),
                p_script_name => g_script_name || '_' || p_cn_archive_all_s,
                p_addnl_para => '',
                x_row_to_process_flag => l_any_rows_to_process,
                x_return_status => x_return_status );

Line: 1239

  delete_table ( p_start_period_id => p_start_period_id,
                p_end_period_id => p_end_period_id,
                x_start_date => x_start_date,
                x_end_date => x_end_date,
                p_worker_id => p_worker_id,
                p_no_of_workers => p_no_of_workers,
                p_batch_size => p_batch_size,
                p_table_owner => l_table_owner,
                p_table_name => upper(l_table_name),
                p_script_name => g_script_name || '_' || p_cn_archive_all_s,
                p_addnl_para => '',
                x_row_to_process_flag => l_any_rows_to_process,
                x_return_status => x_return_status );

Line: 1303

   SELECT COUNT(*)
     INTO l_row_count
     FROM cn_srp_period_quotas_ext_all qe
    WHERE qe.srp_period_quota_id IN
    (SELECT DISTINCT qa.srp_period_quota_id
       FROM cn_srp_period_quotas_all qa
      WHERE qa.period_id BETWEEN p_start_period_id AND p_end_period_id
    );

Line: 1316

  insert_archive(cn_srp_period_quotas_ext_all_i,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 1320

   SELECT COUNT(*)
     INTO l_row_count
     FROM cn_srp_per_quota_rc_all
    WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;

Line: 1329

  insert_archive(cn_srp_per_quota_rc_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 1333

   SELECT COUNT(*)
     INTO l_row_count
     FROM cn_srp_period_quotas_all
    WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;

Line: 1342

  insert_archive(cn_srp_period_quotas_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 1346

   SELECT COUNT(*)
     INTO l_row_count
     FROM cn_pay_approval_flow_all af
    WHERE af.payrun_id IN
    (SELECT DISTINCT pa.payrun_id
       FROM cn_payruns_all pa
      WHERE pa.PAY_PERIOD_ID BETWEEN p_start_period_id AND p_end_period_id
    );

Line: 1359

  insert_archive(cn_pay_approval_flow_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 1363

   SELECT COUNT(*)
     INTO l_row_count
     FROM cn_worksheet_qg_dtls_all
    WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;

Line: 1372

  insert_archive(cn_worksheet_qg_dtls_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 1376

   SELECT COUNT(*)
     INTO l_row_count
     FROM cn_payment_worksheets_all pw
    WHERE pw.payrun_id IN
    (SELECT DISTINCT pa.payrun_id
       FROM cn_payruns_all pa
      WHERE pa.PAY_PERIOD_ID BETWEEN p_start_period_id AND p_end_period_id
    );

Line: 1389

  insert_archive(cn_payment_worksheets_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 1393

   SELECT COUNT(*)
     INTO l_row_count
     FROM cn_ledger_journal_entries_all je
    WHERE je.srp_period_id IN
    (SELECT DISTINCT sp.srp_period_id
       FROM cn_srp_periods_all sp
      WHERE sp.period_id BETWEEN p_start_period_id AND p_end_period_id
    );

Line: 1406

  insert_archive(cn_ledger_journal_entries_alli,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 1410

   SELECT COUNT(*)
     INTO l_row_count
     FROM cn_posting_details_sum_all
    WHERE pay_period_id BETWEEN p_start_period_id AND p_end_period_id;

Line: 1419

  insert_archive(cn_posting_details_sum_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 1423

   SELECT COUNT(*)
     INTO l_row_count
     FROM cn_worksheet_bonuses_all wb
    WHERE wb.payrun_id IN
    (SELECT DISTINCT pa.payrun_id
       FROM cn_payruns_all pa
      WHERE pa.PAY_PERIOD_ID BETWEEN p_start_period_id AND p_end_period_id
    );

Line: 1436

  insert_archive(cn_worksheet_bonuses_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 1440

   SELECT COUNT(*)
     INTO l_row_count
     FROM cn_payruns_all
    WHERE PAY_PERIOD_ID BETWEEN p_start_period_id AND p_end_period_id;

Line: 1449

  insert_archive(cn_payruns_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 1453

   SELECT COUNT(*)
     INTO l_row_count
     FROM cn_srp_periods_all
    WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;

Line: 1462

  insert_archive(cn_srp_periods_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 1514

  delete_table ( p_start_period_id => p_start_period_id,
                p_end_period_id => p_end_period_id,
                x_start_date => x_start_date,
                x_end_date => x_end_date,
                p_worker_id => p_worker_id,
                p_no_of_workers => p_no_of_workers,
                p_batch_size => p_batch_size,
                p_table_owner => l_table_owner,
                p_table_name => upper(l_table_name),
                p_script_name => g_script_name || '_' || p_cn_archive_all_s,
                p_addnl_para => '',
                x_row_to_process_flag => l_any_rows_to_process,
                x_return_status => x_return_status );

Line: 1531

  delete_table ( p_start_period_id => p_start_period_id,
                p_end_period_id => p_end_period_id,
                x_start_date => x_start_date,
                x_end_date => x_end_date,
                p_worker_id => p_worker_id,
                p_no_of_workers => p_no_of_workers,
                p_batch_size => p_batch_size,
                p_table_owner => l_table_owner,
                p_table_name => upper(l_table_name),
                p_script_name => g_script_name || '_' || p_cn_archive_all_s,
                p_addnl_para => '',
                x_row_to_process_flag => l_any_rows_to_process,
                x_return_status => x_return_status );

Line: 1547

  delete_table ( p_start_period_id => p_start_period_id,
                p_end_period_id => p_end_period_id,
                x_start_date => x_start_date,
                x_end_date => x_end_date,
                p_worker_id => p_worker_id,
                p_no_of_workers => p_no_of_workers,
                p_batch_size => p_batch_size,
                p_table_owner => l_table_owner,
                p_table_name => upper(l_table_name),
                p_script_name => g_script_name || '_' || p_cn_archive_all_s,
                p_addnl_para => '',
                x_row_to_process_flag => l_any_rows_to_process,
                x_return_status => x_return_status );

Line: 1563

  delete_table ( p_start_period_id => p_start_period_id,
                p_end_period_id => p_end_period_id,
                x_start_date => x_start_date,
                x_end_date => x_end_date,
                p_worker_id => p_worker_id,
                p_no_of_workers => p_no_of_workers,
                p_batch_size => p_batch_size,
                p_table_owner => l_table_owner,
                p_table_name => upper(l_table_name),
                p_script_name => g_script_name || '_' || p_cn_archive_all_s,
                p_addnl_para => '',
                x_row_to_process_flag => l_any_rows_to_process,
                x_return_status => x_return_status );

Line: 1580

  delete_table ( p_start_period_id => p_start_period_id,
                p_end_period_id => p_end_period_id,
                x_start_date => x_start_date,
                x_end_date => x_end_date,
                p_worker_id => p_worker_id,
                p_no_of_workers => p_no_of_workers,
                p_batch_size => p_batch_size,
                p_table_owner => l_table_owner,
                p_table_name => upper(l_table_name),
                p_script_name => g_script_name || '_' || p_cn_archive_all_s,
                p_addnl_para => '',
                x_row_to_process_flag => l_any_rows_to_process,
                x_return_status => x_return_status );

Line: 1596

  delete_table ( p_start_period_id => p_start_period_id,
                p_end_period_id => p_end_period_id,
                x_start_date => x_start_date,
                x_end_date => x_end_date,
                p_worker_id => p_worker_id,
                p_no_of_workers => p_no_of_workers,
                p_batch_size => p_batch_size,
                p_table_owner => l_table_owner,
                p_table_name => upper(l_table_name),
                p_script_name => g_script_name || '_' || p_cn_archive_all_s,
                p_addnl_para => '',
                x_row_to_process_flag => l_any_rows_to_process,
                x_return_status => x_return_status );

Line: 1661

   SELECT COUNT(*)
     INTO l_row_count
     FROM cn_srp_payee_assigns_all pa
    WHERE pa.srp_quota_assign_id IN
    (SELECT DISTINCT qa.srp_quota_assign_id
       FROM cn_srp_period_quotas_all qa
      WHERE qa.srp_plan_assign_id IN
      (SELECT DISTINCT pl.srp_plan_assign_id
         FROM cn_srp_plan_assigns_all pl
        WHERE ((pl.start_date BETWEEN x_start_date AND x_end_date)
      AND (pl.end_date BETWEEN x_start_date AND x_end_date))
      )
    );

Line: 1679

  insert_archive(cn_srp_payee_assigns_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 1683

   SELECT COUNT(*)
     INTO l_row_count
     FROM cn_srp_quota_assigns_all qa
    WHERE qa.srp_plan_assign_id IN
    (SELECT DISTINCT pl.srp_plan_assign_id
       FROM cn_srp_plan_assigns_all pl
      WHERE ((pl.start_date BETWEEN x_start_date AND x_end_date)
    AND (pl.end_date BETWEEN x_start_date AND x_end_date))
    );

Line: 1697

  insert_archive(cn_srp_quota_assigns_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 1701

   SELECT COUNT(*)
     INTO l_row_count
     FROM cn_srp_rate_assigns_all ra
    WHERE ra.srp_plan_assign_id IN
    (SELECT DISTINCT pl.srp_plan_assign_id
       FROM cn_srp_plan_assigns_all pl
      WHERE ((pl.start_date BETWEEN x_start_date AND x_end_date)
    AND pl.end_date BETWEEN x_start_date AND x_end_date)
    );

Line: 1715

  insert_archive(cn_srp_rate_assigns_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 1719

   SELECT COUNT(*)
     INTO l_row_count
     FROM cn_srp_rule_uplifts_all ru
    WHERE ru.srp_quota_rule_id IN
    (SELECT DISTINCT qr.srp_quota_rule_id
       FROM cn_srp_quota_rules_all qr
      WHERE qr.srp_plan_assign_id IN
      (SELECT DISTINCT pl.srp_plan_assign_id
         FROM cn_srp_plan_assigns_all pl
        WHERE ((pl.start_date BETWEEN x_start_date AND x_end_date)
      AND (pl.end_date BETWEEN x_start_date AND x_end_date))
      )
    );

Line: 1737

  insert_archive(cn_srp_rule_uplifts_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 1741

   SELECT COUNT(*)
     INTO l_row_count
     FROM cn_srp_quota_rules_all ra
    WHERE ra.srp_plan_assign_id IN
    (SELECT DISTINCT pl.srp_plan_assign_id
       FROM cn_srp_plan_assigns_all pl
      WHERE ((pl.start_date BETWEEN x_start_date AND x_end_date)
    AND (pl.end_date BETWEEN x_start_date AND x_end_date))
    );

Line: 1755

  insert_archive(cn_srp_quota_rules_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 1759

   SELECT COUNT(*)
     INTO l_row_count
     FROM cn_srp_plan_assigns_all
    WHERE ((start_date BETWEEN x_start_date AND x_end_date)
  AND (end_date BETWEEN x_start_date AND x_end_date));

Line: 1769

  insert_archive(cn_srp_plan_assigns_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 1821

  delete_table ( p_start_period_id => p_start_period_id,
                p_end_period_id => p_end_period_id,
                x_start_date => x_start_date,
                x_end_date => x_end_date,
                p_worker_id => p_worker_id,
                p_no_of_workers => p_no_of_workers,
                p_batch_size => p_batch_size,
                p_table_owner => l_table_owner,
                p_table_name => upper(l_table_name),
                p_script_name => g_script_name || '_' || p_cn_archive_all_s,
                p_addnl_para => '',
                x_row_to_process_flag => l_any_rows_to_process,
                x_return_status => x_return_status );

Line: 1838

  delete_table ( p_start_period_id => p_start_period_id,
                p_end_period_id => p_end_period_id,
                x_start_date => x_start_date,
                x_end_date => x_end_date,
                p_worker_id => p_worker_id,
                p_no_of_workers => p_no_of_workers,
                p_batch_size => p_batch_size,
                p_table_owner => l_table_owner,
                p_table_name => upper(l_table_name),
                p_script_name => g_script_name || '_' || p_cn_archive_all_s,
                p_addnl_para => '',
                x_row_to_process_flag => l_any_rows_to_process,
                x_return_status => x_return_status );

Line: 1854

 delete_table ( p_start_period_id => p_start_period_id,
                p_end_period_id => p_end_period_id,
                x_start_date => x_start_date,
                x_end_date => x_end_date,
                p_worker_id => p_worker_id,
                p_no_of_workers => p_no_of_workers,
                p_batch_size => p_batch_size,
                p_table_owner => l_table_owner,
                p_table_name => upper(l_table_name),
                p_script_name => g_script_name || '_' || p_cn_archive_all_s,
                p_addnl_para => '',
                x_row_to_process_flag => l_any_rows_to_process,
                x_return_status => x_return_status );

Line: 1870

  delete_table ( p_start_period_id => p_start_period_id,
                p_end_period_id => p_end_period_id,
                x_start_date => x_start_date,
                x_end_date => x_end_date,
                p_worker_id => p_worker_id,
                p_no_of_workers => p_no_of_workers,
                p_batch_size => p_batch_size,
                p_table_owner => l_table_owner,
                p_table_name => upper(l_table_name),
                p_script_name => g_script_name || '_' || p_cn_archive_all_s,
                p_addnl_para => '',
                x_row_to_process_flag => l_any_rows_to_process,
                x_return_status => x_return_status );

Line: 1934

   SELECT COUNT(*) INTO l_row_count FROM cn_process_audit_lines_all;

Line: 1940

  insert_archive(cn_process_audit_lines_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 1944

   SELECT COUNT(*) INTO l_row_count FROM cn_process_audits_all;

Line: 1950

  insert_archive(cn_process_audits_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 1954

   SELECT COUNT(*)
     INTO l_row_count
     FROM cn_process_batches_all
    WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;

Line: 1963

  insert_archive(cn_process_batches_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 1967

   SELECT COUNT(*)
     INTO l_row_count
     FROM cn_srp_intel_periods_all
    WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;

Line: 1976

  insert_archive(cn_srp_intel_periods_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 2007

  SELECT DISTINCT h.imp_header_id
       FROM cn_imp_headers h
      WHERE exists (select distinct l.imp_header_id from cn_imp_lines l where h.imp_header_id = l.imp_header_id
      and to_date(l.col3, 'dd-mm-rr') between  x_start_date AND x_end_date
      and h.imp_header_id not in (select distinct l2.imp_header_id from cn_imp_lines l2 where
      to_date(l2.col3, 'dd-mm-rr')  not between  x_start_date AND x_end_date
      ));

Line: 2033

  l_sql := l_sql || ' as select *  from CN_PAYMENT_API_ALL where period_id  between ' || p_start_period_id || ' and ' || p_end_period_id;

Line: 2036

    SELECT COUNT(*)
     INTO l_row_count
     FROM cn_payment_api_all
    WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;

Line: 2043

  insert_archive(cn_payment_api_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 2052

  l_sql := l_sql || ' as select *  from cn_posting_details_all where pay_period_id  between ' || p_start_period_id || ' and ' || p_end_period_id || ' and paid_flag = ''Y''';

Line: 2055

   SELECT COUNT(*)
     INTO l_row_count
     FROM cn_posting_details_all
    WHERE pay_period_id BETWEEN p_start_period_id AND p_end_period_id;

Line: 2062

  insert_archive(cn_posting_details_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 2070

  l_sql := l_sql || ' as select *  from cn_payment_transactions_all where pay_period_id  between ' || p_start_period_id || ' and ' || p_end_period_id || ' and paid_flag = ''Y''';

Line: 2073

   SELECT COUNT(*)
     INTO l_row_count
     FROM cn_payment_transactions_all
    WHERE pay_period_id BETWEEN p_start_period_id AND p_end_period_id
  AND paid_flag = 'Y';

Line: 2081

  insert_archive(cn_payment_transactions_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 2089

  l_sql := l_sql || ' as select *  from  cn_commission_lines_all  where processed_period_id  between   ' || p_start_period_id || ' and ' || p_end_period_id;

Line: 2092

  SELECT COUNT(*)
     INTO l_row_count
     FROM cn_commission_lines_all
    WHERE processed_period_id BETWEEN p_start_period_id AND p_end_period_id;

Line: 2099

  insert_archive(cn_commission_lines_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 2107

  l_sql := l_sql || ' as select *  from cn_commission_headers_all  where processed_period_id  between  ' || p_start_period_id || ' and ' || p_end_period_id;

Line: 2110

 SELECT COUNT(*)
     INTO l_row_count
     FROM cn_commission_headers_all
    WHERE processed_period_id BETWEEN p_start_period_id AND p_end_period_id;

Line: 2117

  insert_archive(cn_commission_headers_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 2125

  l_sql := l_sql || ' as select *  from cn_trx_sales_lines_all where TRUNC(processed_date)  between ''' || x_start_date ||'''' || ' and ''' || x_end_date ||'''';

Line: 2128

    SELECT COUNT(*)
     INTO l_row_count
     FROM cn_trx_sales_lines_all
    WHERE TRUNC(processed_date) BETWEEN x_start_date AND x_end_date;

Line: 2135

  insert_archive(cn_trx_sales_lines_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 2143

  l_sql := l_sql || ' as select *  from cn_trx_lines_all tl where tl.TRX_ID in (Select distinct t.TRX_ID from cn_trx_all t where TRUNC(t.processed_date)  between ''' || x_start_date ||'''' || ' and ''' || x_end_date ||'''' || ' ) ';

Line: 2146

   SELECT COUNT(*)
     INTO l_row_count
     FROM cn_trx_lines_all tl
    WHERE tl.TRX_ID IN
    (SELECT DISTINCT t.TRX_ID
       FROM cn_trx_all t
      WHERE TRUNC(t.processed_date) BETWEEN x_start_date AND x_end_date
    );

Line: 2157

  insert_archive(cn_trx_lines_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 2165

  l_sql := l_sql || ' as select *  from cn_trx_all where TRUNC(processed_date)  between ''' || x_start_date ||'''' || ' and ''' || x_end_date ||'''';

Line: 2168

    SELECT COUNT(*)
     INTO l_row_count
     FROM cn_trx_all
    WHERE TRUNC(processed_date) BETWEEN x_start_date AND x_end_date;

Line: 2175

  insert_archive(cn_trx_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 2183

  l_sql := l_sql || ' as select *  from cn_not_trx_all where processed_date  between ''' || x_start_date ||'''' || ' and ''' || x_end_date ||'''';

Line: 2186

  SELECT COUNT(*)
     INTO l_row_count
     FROM cn_not_trx_all
    WHERE processed_date BETWEEN x_start_date AND x_end_date;

Line: 2193

  insert_archive(cn_not_trx_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 2201

  l_sql := l_sql || ' as select *  from  cn_invoice_changes_all i  where i.comm_lines_api_id in ' ||
           ' (select distinct c.comm_lines_api_id from cn_comm_lines_api_all c where c.processed_period_id  between  ' ||
           p_start_period_id || ' and ' || p_end_period_id || ' ) ';

Line: 2206

 SELECT COUNT(*)
     INTO l_row_count
     FROM cn_invoice_changes_all i
    WHERE i.comm_lines_api_id IN
    (SELECT DISTINCT c.comm_lines_api_id
       FROM cn_comm_lines_api_all c
      WHERE c.processed_period_id BETWEEN p_start_period_id AND p_end_period_id );

Line: 2216

  insert_archive(cn_invoice_changes_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 2254

      l_sql := l_sql || ' as select *  from cn_imp_lines il  where il.import_type_code = ''TRXAPI'' and  il.imp_header_id in '
        || l_imp_header_id_list;

Line: 2261

      l_sql := 'SELECT COUNT(*) FROM cn_imp_lines WHERE import_type_code = ''TRXAPI'' AND imp_header_id in ' || l_imp_header_id_list;

Line: 2268

      insert_archive(cn_imp_lines_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 2277

        l_sql := l_sql || ' as select *  from cn_imp_headers ih where ih.imp_header_id  in '
        || l_imp_header_id_list;

Line: 2282

      l_sql := 'SELECT COUNT(*) FROM cn_imp_headers ih WHERE ih.imp_header_id IN ' || l_imp_header_id_list;

Line: 2288

      insert_archive(cn_imp_headers_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 2304

  l_sql := l_sql || ' as select *  from  cn_comm_lines_api_all where processed_period_id  between  ' || p_start_period_id || ' and ' || p_end_period_id;

Line: 2307

   SELECT COUNT(*)
     INTO l_row_count
     FROM cn_comm_lines_api_all
    WHERE processed_period_id BETWEEN p_start_period_id AND p_end_period_id;

Line: 2314

  insert_archive(cn_comm_lines_api_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 2358

  l_sql := l_sql || ' as select * from cn_srp_period_quotas_ext_all qe where ' ||
         ' qe.srp_period_quota_id in (Select distinct qa.srp_period_quota_id  from cn_srp_period_quotas_all qa  where qa.period_id between ' ||
         p_start_period_id || ' and ' || p_end_period_id || ' ) ';

Line: 2363

   SELECT COUNT(*)
     INTO l_row_count
     FROM cn_srp_period_quotas_ext_all qe
    WHERE qe.srp_period_quota_id IN
    (SELECT DISTINCT qa.srp_period_quota_id
       FROM cn_srp_period_quotas_all qa
      WHERE qa.period_id BETWEEN p_start_period_id AND p_end_period_id
    );

Line: 2374

  insert_archive(cn_srp_period_quotas_ext_all_i,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 2384

  l_sql := l_sql || ' as select * from cn_srp_per_quota_rc_all  where period_id  between  ' || p_start_period_id || ' and ' || p_end_period_id ;

Line: 2387

  SELECT COUNT(*)
     INTO l_row_count
     FROM cn_srp_per_quota_rc_all
    WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;

Line: 2394

  insert_archive(cn_srp_per_quota_rc_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 2403

  l_sql := l_sql || ' as select * from cn_srp_period_quotas_all  where period_id  between  ' || p_start_period_id || ' and ' || p_end_period_id;

Line: 2406

   SELECT COUNT(*)
     INTO l_row_count
     FROM cn_srp_period_quotas_all
    WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;

Line: 2413

  insert_archive(cn_srp_period_quotas_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 2422

  l_sql := l_sql || ' as select * from cn_pay_approval_flow_all af where af.payrun_id in (Select distinct pa.payrun_id from cn_payruns_all pa  where pa.PAY_PERIOD_ID  between  ' || p_start_period_id || ' and ' || p_end_period_id || ' ) ';

Line: 2425

   SELECT COUNT(*)
     INTO l_row_count
     FROM cn_pay_approval_flow_all af
    WHERE af.payrun_id IN
    (SELECT DISTINCT pa.payrun_id
       FROM cn_payruns_all pa
      WHERE pa.PAY_PERIOD_ID BETWEEN p_start_period_id AND p_end_period_id
    );

Line: 2436

  insert_archive(cn_pay_approval_flow_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 2445

  l_sql := l_sql || ' as select * from cn_worksheet_qg_dtls_all where period_id  between  ' || p_start_period_id || ' and ' || p_end_period_id;

Line: 2448

  SELECT COUNT(*)
     INTO l_row_count
     FROM cn_worksheet_qg_dtls_all
    WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;

Line: 2455

  insert_archive(cn_worksheet_qg_dtls_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 2464

  l_sql := l_sql || ' as select * from cn_payment_worksheets_all pw where pw.payrun_id in (Select distinct pa.payrun_id from cn_payruns_all pa  where pa.PAY_PERIOD_ID  between  ' || p_start_period_id || ' and ' || p_end_period_id || ' ) ';

Line: 2467

  SELECT COUNT(*)
     INTO l_row_count
     FROM cn_payment_worksheets_all pw
    WHERE pw.payrun_id IN
    (SELECT DISTINCT pa.payrun_id
       FROM cn_payruns_all pa
      WHERE pa.PAY_PERIOD_ID BETWEEN p_start_period_id AND p_end_period_id
    );

Line: 2478

  insert_archive(cn_payment_worksheets_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 2487

  l_sql := l_sql || ' as select * from cn_ledger_journal_entries_all je where je.srp_period_id in (Select distinct sp.srp_period_id from cn_srp_periods_all sp where sp.period_id  between  ' || p_start_period_id || ' and ' || p_end_period_id || ' ) ';

Line: 2490

   SELECT COUNT(*)
     INTO l_row_count
     FROM cn_ledger_journal_entries_all je
    WHERE je.srp_period_id IN
    (SELECT DISTINCT sp.srp_period_id
       FROM cn_srp_periods_all sp
      WHERE sp.period_id BETWEEN p_start_period_id AND p_end_period_id
    );

Line: 2501

  insert_archive(cn_ledger_journal_entries_alli,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 2510

  l_sql := l_sql || ' as select * from cn_posting_details_sum_all where pay_period_id  between  ' || p_start_period_id || ' and ' || p_end_period_id;

Line: 2513

    SELECT COUNT(*)
     INTO l_row_count
     FROM cn_posting_details_sum_all
    WHERE pay_period_id BETWEEN p_start_period_id AND p_end_period_id;

Line: 2520

  insert_archive(cn_posting_details_sum_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 2529

  l_sql := l_sql || ' as select * from cn_worksheet_bonuses_all wb where wb.payrun_id in (Select distinct pa.payrun_id from cn_payruns_all pa where pa.PAY_PERIOD_ID  between  ' || p_start_period_id || ' and ' || p_end_period_id || ' ) ';

Line: 2532

  SELECT COUNT(*)
     INTO l_row_count
     FROM cn_worksheet_bonuses_all wb
    WHERE wb.payrun_id IN
    (SELECT DISTINCT pa.payrun_id
       FROM cn_payruns_all pa
      WHERE pa.PAY_PERIOD_ID BETWEEN p_start_period_id AND p_end_period_id
    );

Line: 2543

  insert_archive(cn_worksheet_bonuses_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 2552

  l_sql := l_sql || ' as select * from cn_payruns_all where PAY_PERIOD_ID  between  ' || p_start_period_id || ' and ' || p_end_period_id;

Line: 2555

   SELECT COUNT(*)
     INTO l_row_count
     FROM cn_payruns_all
    WHERE PAY_PERIOD_ID BETWEEN p_start_period_id AND p_end_period_id;

Line: 2562

  insert_archive(cn_payruns_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 2571

  l_sql := l_sql || ' as select * from cn_srp_periods_all where period_id  between  ' || p_start_period_id || ' and ' || p_end_period_id;

Line: 2574

   SELECT COUNT(*)
     INTO l_row_count
     FROM cn_srp_periods_all
    WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;

Line: 2581

  insert_archive(cn_srp_periods_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 2626

  l_sql := l_sql || ' as select * from cn_srp_payee_assigns_all pa where pa.srp_quota_assign_id in (Select distinct qa.srp_quota_assign_id from cn_srp_period_quotas_all qa  where qa.srp_plan_assign_id in (Select distinct pl.srp_plan_assign_id
    from cn_srp_plan_assigns_all pl where ((pl.start_date  between ''' || x_start_date ||'''' || ' and ''' || x_end_date ||''''
    || ' ) and (pl.end_date  between ''' || x_start_date ||'''' || ' and ''' || x_end_date ||'''' || '))))';

Line: 2631

   SELECT COUNT(*)
     INTO l_row_count
     FROM cn_srp_payee_assigns_all pa
    WHERE pa.srp_quota_assign_id IN
    (SELECT DISTINCT qa.srp_quota_assign_id
       FROM cn_srp_period_quotas_all qa
      WHERE qa.srp_plan_assign_id IN
      (SELECT DISTINCT pl.srp_plan_assign_id
         FROM cn_srp_plan_assigns_all pl
        WHERE ((pl.start_date BETWEEN x_start_date AND x_end_date)
      AND (pl.end_date BETWEEN x_start_date AND x_end_date))
      )
    );

Line: 2647

  insert_archive(cn_srp_payee_assigns_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 2657

  l_sql := l_sql || ' as select * from cn_srp_quota_assigns_all qa  where qa.srp_plan_assign_id in (Select distinct pl.srp_plan_assign_id from cn_srp_plan_assigns_all pl
          where ((pl.start_date  between  ''' || x_start_date ||'''' || ' and ''' || x_end_date ||''''
          || ' )  and (pl.end_date  between ''' || x_start_date ||'''' || ' and ''' || x_end_date ||'''' || ')))';

Line: 2662

   SELECT COUNT(*)
     INTO l_row_count
     FROM cn_srp_quota_assigns_all qa
    WHERE qa.srp_plan_assign_id IN
    (SELECT DISTINCT pl.srp_plan_assign_id
       FROM cn_srp_plan_assigns_all pl
      WHERE ((pl.start_date BETWEEN x_start_date AND x_end_date)
    AND (pl.end_date BETWEEN x_start_date AND x_end_date))
    );

Line: 2674

  insert_archive(cn_srp_quota_assigns_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 2683

  l_sql := l_sql || ' as select * from cn_srp_rate_assigns_all ra  where ra.srp_plan_assign_id in (Select distinct pl.srp_plan_assign_id from cn_srp_plan_assigns_all pl
           where ((pl.start_date  between  ''' || x_start_date ||'''' || ' and ''' || x_end_date ||''''
           || ' )  and pl.end_date  between ''' || x_start_date ||'''' || ' and ''' || x_end_date ||'''' || '))';

Line: 2688

   SELECT COUNT(*)
     INTO l_row_count
     FROM cn_srp_rate_assigns_all ra
    WHERE ra.srp_plan_assign_id IN
    (SELECT DISTINCT pl.srp_plan_assign_id
       FROM cn_srp_plan_assigns_all pl
      WHERE ((pl.start_date BETWEEN x_start_date AND x_end_date)
    AND pl.end_date BETWEEN x_start_date AND x_end_date)
    );

Line: 2700

  insert_archive(cn_srp_rate_assigns_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 2709

  l_sql := l_sql || ' as select * from cn_srp_rule_uplifts_all ru  ' ||
           ' where ru.srp_quota_rule_id in (Select distinct qr.srp_quota_rule_id from cn_srp_quota_rules_all qr ' ||
           ' where qr.srp_plan_assign_id in (Select distinct pl.srp_plan_assign_id from cn_srp_plan_assigns_all pl ' ||
           ' where ((pl.start_date  between  ''' || x_start_date ||'''' || ' and ''' || x_end_date ||''''
           || ' )  and (pl.end_date  between ''' || x_start_date ||'''' || ' and ''' || x_end_date ||'''' || '))))';

Line: 2716

  SELECT COUNT(*)
     INTO l_row_count
     FROM cn_srp_rule_uplifts_all ru
    WHERE ru.srp_quota_rule_id IN
    (SELECT DISTINCT qr.srp_quota_rule_id
       FROM cn_srp_quota_rules_all qr
      WHERE qr.srp_plan_assign_id IN
      (SELECT DISTINCT pl.srp_plan_assign_id
         FROM cn_srp_plan_assigns_all pl
        WHERE ((pl.start_date BETWEEN x_start_date AND x_end_date)
      AND (pl.end_date BETWEEN x_start_date AND x_end_date))
      )
    );

Line: 2732

  insert_archive(cn_srp_rule_uplifts_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 2741

  l_sql := l_sql || ' as select * from cn_srp_quota_rules_all ra where ra.srp_plan_assign_id in (Select distinct pl.srp_plan_assign_id from cn_srp_plan_assigns_all pl
         where ((pl.start_date  between ''' || x_start_date ||'''' || ' and ''' || x_end_date ||''''
         || ' )  and (pl.end_date  between ''' || x_start_date ||'''' || ' and ''' || x_end_date ||'''' || ')))';

Line: 2746

  SELECT COUNT(*)
     INTO l_row_count
     FROM cn_srp_quota_rules_all ra
    WHERE ra.srp_plan_assign_id IN
    (SELECT DISTINCT pl.srp_plan_assign_id
       FROM cn_srp_plan_assigns_all pl
      WHERE ((pl.start_date BETWEEN x_start_date AND x_end_date)
    AND (pl.end_date BETWEEN x_start_date AND x_end_date))
    );

Line: 2758

  insert_archive(cn_srp_quota_rules_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 2767

  l_sql := l_sql || ' as select * from cn_srp_plan_assigns_all where ((start_date  between ''' || x_start_date ||'''' || ' and ''' || x_end_date ||'''' || ') and (end_date  between ''' || x_start_date ||'''' || ' and ''' || x_end_date ||'''' || ' ))';

Line: 2770

  SELECT COUNT(*)
     INTO l_row_count
     FROM cn_srp_plan_assigns_all
    WHERE ((start_date BETWEEN x_start_date AND x_end_date)
  AND (end_date BETWEEN x_start_date AND x_end_date));

Line: 2778

  insert_archive(cn_srp_plan_assigns_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 2823

  l_sql := l_sql || ' as select * from cn_process_batches_all  where period_id  between ' || p_start_period_id || ' and ' || p_end_period_id;

Line: 2826

 SELECT COUNT(*)
     INTO l_row_count
     FROM cn_process_batches_all
    WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;

Line: 2833

  insert_archive(cn_process_batches_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 2842

  l_sql := l_sql || ' as select * from cn_srp_intel_periods_all  where period_id  between  ' || p_start_period_id || ' and ' || p_end_period_id;

Line: 2845

 SELECT COUNT(*)
     INTO l_row_count
     FROM cn_srp_intel_periods_all
    WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;

Line: 2852

  insert_archive(cn_srp_intel_periods_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line: 2896

  SELECT CN_ARC_AUDIT_ALL_S.nextval INTO l_cn_archive_all_s FROM dual;

Line: 2968

   INSERT
     INTO cn_arc_audit_all
     (ARCHIVE_PURGE_ID,TOT_AP_TABLES_COUNT,TOT_AP_ROWS,ARCHIVE_PURGE_DATE,START_PERIOD_ID,END_PERIOD_ID,ORG_ID,RUN_MODE,
     ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
     VALUES
    (
      l_cn_archive_all_s,
      x_msg_count       ,
      l_tot_rows_count  ,
      sysdate           ,
      p_start_period_id ,
      p_end_period_id   ,
      p_org_id          ,
      l_run_mode        ,
      NULL              ,
      NULL              ,
      NULL              ,
      NULL              ,
      NULL              ,
      fnd_global.user_id,
      sysdate           ,
      fnd_global.user_id,
      sysdate           ,
      fnd_global.user_id
    );

Line: 3039

   SELECT CN_ARC_AUDIT_ALL_S.nextval INTO l_cn_archive_all_s FROM dual;

Line: 3173

   SELECT CN_ARC_AUDIT_ALL_S.nextval INTO l_cn_archive_all_s FROM dual;

Line: 3253

   INSERT
     INTO cn_arc_audit_all
      (ARCHIVE_PURGE_ID,TOT_AP_TABLES_COUNT,TOT_AP_ROWS,ARCHIVE_PURGE_DATE,START_PERIOD_ID,END_PERIOD_ID,ORG_ID,RUN_MODE,
     ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
     VALUES
    (
      l_cn_archive_all_s,
      x_msg_count       ,
      l_tot_rows_count  ,
      sysdate           ,
      p_start_period_id ,
      p_end_period_id   ,
      p_org_id          ,
      l_run_mode        ,
      NULL              ,
      NULL              ,
      NULL              ,
      NULL              ,
      NULL              ,
      fnd_global.user_id,
      sysdate           ,
      fnd_global.user_id,
      sysdate           ,
      fnd_global.user_id
    );