APPS.FA_DEPRN_EVENTS_PKG SQL Statements

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

Line: 29

  select rowid,
         asset_id
    from fa_deprn_summary
   where book_type_code = p_book_type_code
     and period_counter = p_period_counter
     and event_id      is null
     and (deprn_amount - deprn_adjustment_amount <> 0 or
          reval_amortization <> 0)
     and MOD(asset_id, p_total_requests) = (p_request_number - 1)
     and deprn_source_code        <> 'TRACK';

Line: 44

  select rowid,
         asset_id
    from fa_mc_deprn_summary
   where set_of_books_id = p_set_of_books_id
     and book_type_code  = p_book_type_code
     and period_counter  = p_period_counter
     and event_id       is null
     and (deprn_amount - deprn_adjustment_amount <> 0 or
          reval_amortization <> 0)
     and MOD(asset_id, p_total_requests) = (p_request_number - 1)
     and deprn_source_code        <> 'TRACK';

Line: 96

   select fa_deprn_summary_s.nextval
     into l_deprn_run_id
     from dual;

Line: 164

         fa_debug_pkg.add(l_calling_fn, 'performing', 'bulk update - primary',
                          p_log_level_rec => g_log_level_rec);

Line: 169

       UPDATE FA_DEPRN_SUMMARY
          SET event_id     = l_event_id_tbl(l_count),
              deprn_run_id = l_deprn_run_id
        WHERE rowid        = l_rowid_tbl(l_count);

Line: 176

       UPDATE FA_DEPRN_DETAIL
          SET event_id       = l_event_id_tbl(l_count),
              deprn_run_id   = l_deprn_run_id
        WHERE asset_id       = l_asset_id_tbl(l_count)
          AND book_type_code = p_book_type_code
          AND period_counter = p_period_counter;

Line: 184

         fa_debug_pkg.add(l_calling_fn, 'performing', 'bulk update - reporting',
                          p_log_level_rec => g_log_level_rec);

Line: 190

       UPDATE FA_MC_DEPRN_SUMMARY
          SET event_id       = l_event_id_tbl(l_count),
              deprn_run_id   = l_deprn_run_id
        WHERE asset_id       = l_asset_id_tbl(l_count)
          AND book_type_code = p_book_type_code
          AND period_counter = p_period_counter;

Line: 199

       UPDATE FA_MC_DEPRN_DETAIL
          SET event_id       = l_event_id_tbl(l_count),
              deprn_run_id   = l_deprn_run_id
        WHERE asset_id       = l_asset_id_tbl(l_count)
          AND book_type_code = p_book_type_code
          AND period_counter = p_period_counter;

Line: 207

         fa_debug_pkg.add(l_calling_fn, 'done', 'bulk updates',
                          p_log_level_rec => g_log_level_rec);

Line: 212

      INSERT into fa_deprn_events
          (asset_id            ,
           book_type_code      ,
           period_counter      ,
           deprn_run_id        ,
           deprn_run_date      ,
           event_id            ,
           reversal_event_id
           )
       VALUES
          (l_asset_id_tbl(l_count),
           p_book_type_code,
           p_period_counter,
           l_deprn_run_id,
           sysdate,
           l_event_id_tbl(l_count),
           null);

Line: 231

         fa_debug_pkg.add(l_calling_fn, 'done', 'bulk insert',
                          p_log_level_rec => g_log_level_rec);

Line: 300

            fa_debug_pkg.add(l_calling_fn, 'performing', 'bulk update - reporting1',
                             p_log_level_rec => g_log_level_rec);

Line: 305

         UPDATE FA_MC_DEPRN_SUMMARY
            SET event_id     = l_event_id_tbl(l_count),
                deprn_run_id = l_deprn_run_id
          WHERE rowid        = l_rowid_tbl(l_count);

Line: 312

         UPDATE FA_MC_DEPRN_DETAIL
            SET event_id       = l_event_id_tbl(l_count),
                deprn_run_id   = l_deprn_run_id
          WHERE asset_id       = l_asset_id_tbl(l_count)
            AND book_type_code = p_book_type_code
            AND period_counter = p_period_counter;

Line: 320

            fa_debug_pkg.add(l_calling_fn, 'performing', 'bulk update - reporting2',
                             p_log_level_rec => g_log_level_rec);

Line: 326

         UPDATE FA_MC_DEPRN_SUMMARY
            SET event_id         = l_event_id_tbl(l_count),
                deprn_run_id     = l_deprn_run_id
          WHERE set_of_books_id <> l_sob_tbl(l_sob_index)
            AND asset_id         = l_asset_id_tbl(l_count)
            AND book_type_code   = p_book_type_code
            AND period_counter   = p_period_counter;

Line: 335

            fa_debug_pkg.add(l_calling_fn, 'done', 'mc bulk updates',
                             p_log_level_rec => g_log_level_rec);

Line: 340

         INSERT into fa_deprn_events
             (asset_id            ,
              book_type_code      ,
              period_counter      ,
              deprn_run_id        ,
              deprn_run_date      ,
              event_id            ,
              reversal_event_id
              )
          VALUES
             (l_asset_id_tbl(l_count),
              p_book_type_code,
              p_period_counter,
              l_deprn_run_id,
              sysdate,
              l_event_id_tbl(l_count),
              null);

Line: 359

            fa_debug_pkg.add(l_calling_fn, 'done', 'bulk insert',
                             p_log_level_rec => g_log_level_rec);

Line: 435

  select rowid,
         asset_id
    from fa_deferred_deprn
   where corp_book_type_code = p_corp_book_type_code
     and tax_book_type_code  = p_tax_book_type_code
     and corp_period_counter = p_corp_period_counter
     and tax_period_counter  = p_tax_period_counter
     and event_id           is null;

Line: 450

  select rowid,
         asset_id
    from fa_mc_deferred_deprn
   where set_of_books_id     = p_set_of_books_id
     and corp_book_type_code = p_corp_book_type_code
     and tax_book_type_code  = p_tax_book_type_code
     and corp_period_counter = p_corp_period_counter
     and tax_period_counter  = p_tax_period_counter
     and event_id            is null;

Line: 517

       UPDATE FA_DEFERRED_DEPRN
          SET event_id = l_event_id_tbl(l_count)
        WHERE rowid    = l_rowid_tbl(l_count);

Line: 523

       UPDATE FA_MC_DEFERRED_DEPRN
          SET event_id            = l_event_id_tbl(l_count)
        WHERE asset_id            = l_asset_id_tbl(l_count)
          AND corp_book_type_code = p_corp_book_type_code
          AND tax_book_type_code  = p_tax_book_type_code
          AND corp_period_counter = p_corp_period_counter
          AND tax_period_counter  = p_tax_period_counter;

Line: 535

      INSERT into fa_deferred_deprn_events
          (asset_id            ,
           corp_book_type_code ,
           tax_book_type_code  ,
           corp_period_counter ,
           tax_period_counter  ,
           event_id
           )
       VALUES
          (l_asset_id_tbl(l_count),
           p_corp_book_type_code,
           p_tax_book_type_code,
           p_corp_period_counter,
           p_tax_period_counter,
           l_event_id_tbl(l_count));

Line: 600

         UPDATE FA_MC_DEFERRED_DEPRN
            SET event_id = l_event_id_tbl(l_count)
          WHERE rowid    = l_rowid_tbl(l_count);

Line: 606

         UPDATE FA_MC_DEFERRED_DEPRN
            SET event_id              = l_event_id_tbl(l_count)
          WHERE set_of_books_id      <> l_sob_tbl(l_sob_index)
            AND asset_id              = l_asset_id_tbl(l_count)
            AND corp_book_type_code = p_corp_book_type_code
            AND tax_book_type_code  = p_tax_book_type_code
            AND corp_period_counter = p_corp_period_counter
            AND tax_period_counter  = p_tax_period_counter;

Line: 617

         INSERT into fa_deferred_deprn_events
             (asset_id            ,
              corp_book_type_code ,
              tax_book_type_code  ,
              corp_period_counter ,
              tax_period_counter  ,
              event_id
              )
          VALUES
             (l_asset_id_tbl(l_count),
              p_corp_book_type_code,
              p_tax_book_type_code,
              p_corp_period_counter,
              p_tax_period_counter,
              l_event_id_tbl(l_count));