APPS.FA_UPGHARNESS_PKG SQL Statements

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

Line: 60

   update fa_deprn_periods dp
   set    dp.xla_conversion_status = 'H'
   where dp.xla_conversion_status is not null
   and   dp.xla_conversion_status not like 'U%'
   and   exists
   (
    select 'x'
    from   gl_period_statuses ps,
           fa_book_controls bc
    where  ps.application_id = 101
    and    ps.migration_status_code in ('P', 'U')
    and    bc.set_of_books_id = ps.set_of_books_id
    and    dp.book_type_code = bc.book_type_code
    and    dp.period_name = ps.period_name
   );

Line: 108

   l_worker.delete;

Line: 143

   select count(*)
   into   l_errors
   from   fa_deprn_periods
   where  nvl(xla_conversion_status, 'UA') not in ('UT', 'UD', 'UA', 'H');

Line: 201

   select xla_upg_batches_s.nextval
   into   l_batch_id
   from   dual;

Line: 249

   select xla_upg_batches_s.nextval
   into   l_batch_id
   from   dual;

Line: 297

   select bc.book_type_code, ps.period_name
   from   gl_period_statuses ps,
          fa_book_controls bc
   where  ps.application_id = 101
   and    ps.migration_status_code in ('P', 'U')
   and    bc.set_of_books_id = ps.set_of_books_id;

Line: 313

   ad_parallel_updates_pkg.initialize_rowid_range(
           ad_parallel_updates_pkg.ROWID_RANGE,
           p_table_owner,
           l_table_name1,
           p_script_name,
           p_worker_id,
           p_workers_num,
           l_batch_size, 0);

Line: 322

   ad_parallel_updates_pkg.get_rowid_range(
           l_start_rowid,
           l_end_rowid,
           l_any_rows_to_process,
           l_batch_size,
           TRUE);

Line: 342

      ad_parallel_updates_pkg.processed_rowid_range(
          l_rows_processed,
          l_end_rowid);

Line: 351

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

Line: 364

   select count(*)
   into   l_group_books
   from   fa_book_controls
   where  allow_group_deprn_flag = 'Y';

Line: 369

   ad_parallel_updates_pkg.initialize_rowid_range(
           ad_parallel_updates_pkg.ROWID_RANGE,
           p_table_owner,
           l_table_name2,
           p_script_name,
           p_worker_id,
           p_workers_num,
           l_batch_size, 0);

Line: 378

   ad_parallel_updates_pkg.get_rowid_range(
           l_start_rowid,
           l_end_rowid,
           l_any_rows_to_process,
           l_batch_size,
           TRUE);

Line: 410

      ad_parallel_updates_pkg.processed_rowid_range(
          l_rows_processed,
          l_end_rowid);

Line: 420

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

Line: 440

         update fa_deprn_periods dp
         set    dp.xla_conversion_status =
                decode (substr(dp.xla_conversion_status, 1, 1),
                        'H', '1',
                        'E', '1',
                        'U', '1',
                        '0', to_char(to_number(dp.xla_conversion_status) + 1),
                        '1', to_char(to_number(dp.xla_conversion_status) + 1),
                        '2', to_char(to_number(dp.xla_conversion_status) + 1),
                        '3', to_char(to_number(dp.xla_conversion_status) + 1),
                        '4', to_char(to_number(dp.xla_conversion_status) + 1),
                        '5', to_char(to_number(dp.xla_conversion_status) + 1),
                        '6', to_char(to_number(dp.xla_conversion_status) + 1),
                        '7', to_char(to_number(dp.xla_conversion_status) + 1),
                        '8', to_char(to_number(dp.xla_conversion_status) + 1),
                        '9', to_char(to_number(dp.xla_conversion_status) + 1),
                        dp.xla_conversion_status)
         where  dp.book_type_code = l_book_type_code_tbl(i)
         and   dp.period_name = l_period_name_tbl(i)
         and   dp.xla_conversion_status is not null
         and   dp.xla_conversion_status not in ('UA', 'UT');

Line: 488

   update fa_deprn_periods dp
   set    dp.xla_conversion_status = 'UT'
   where  dp.xla_conversion_status = to_char (p_workers_num)
   and    exists
   (
    select 'x'
    from   gl_period_statuses ps,
           fa_book_controls bc
    where  ps.application_id = 101
    and    ps.migration_status_code in ('P', 'U')
    and    bc.set_of_books_id = ps.set_of_books_id
    and    dp.book_type_code = bc.book_type_code
    and    ps.period_name = dp.period_name
   );

Line: 504

   update fa_deprn_periods dp
   set    dp.xla_conversion_status = 'ET'
   where  dp.xla_conversion_status <> to_char (p_workers_num)
   and    dp.xla_conversion_status not in ('UA', 'UT')
   and    dp.xla_conversion_status is not null
   and    exists
   (
    select 'x'
    from   gl_period_statuses ps,
           fa_book_controls bc
    where  ps.application_id = 101
    and    ps.migration_status_code in ('P', 'U')
    and    bc.set_of_books_id = ps.set_of_books_id
    and    dp.book_type_code = bc.book_type_code
    and    ps.period_name = dp.period_name
   );

Line: 557

   select bc.book_type_code, ps.period_name
   from   gl_period_statuses ps,
          fa_book_controls bc
   where  ps.application_id = 101
   and    ps.migration_status_code in ('P', 'U')
   and    bc.set_of_books_id = ps.set_of_books_id;

Line: 575

    select count(*)
    into   l_deprn_run
    from   fa_deprn_periods dp
    where  dp.period_close_date is null
    and    dp.deprn_run = 'Y'
    and    dp.xla_conversion_status is not null
    and    dp.xla_conversion_status not in ('UA', 'UD')
    and   exists
    (
     select 'x'
     from   gl_period_statuses ps,
            fa_book_controls bc
     where  ps.application_id = 101
     and    ps.migration_status_code in ('P', 'U')
     and    bc.set_of_books_id = ps.set_of_books_id
     and    dp.book_type_code = bc.book_type_code
     and    dp.period_name = ps.period_name
    );

Line: 598

   ad_parallel_updates_pkg.initialize_rowid_range(
           ad_parallel_updates_pkg.ROWID_RANGE,
           p_table_owner,
           l_table_name1,
           p_script_name,
           p_worker_id,
           p_workers_num,
           l_batch_size, 0);

Line: 607

   ad_parallel_updates_pkg.get_rowid_range(
           l_start_rowid,
           l_end_rowid,
           l_any_rows_to_process,
           l_batch_size,
           TRUE);

Line: 628

      ad_parallel_updates_pkg.processed_rowid_range(
          l_rows_processed,
          l_end_rowid);

Line: 637

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

Line: 657

   ad_parallel_updates_pkg.initialize_rowid_range(
           ad_parallel_updates_pkg.ROWID_RANGE,
           p_table_owner,
           l_table_name2,
           p_script_name,
           1,                   -- p_worker_id
           1,                   -- p_workers_num
           l_batch_size, 0);

Line: 666

   ad_parallel_updates_pkg.get_rowid_range(
           l_start_rowid,
           l_end_rowid,
           l_any_rows_to_process,
           l_batch_size,
           TRUE);

Line: 686

      ad_parallel_updates_pkg.processed_rowid_range(
          l_rows_processed,
          l_end_rowid);

Line: 695

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

Line: 710

      update fa_deprn_periods dp
      set    dp.xla_conversion_status =
             decode (substr(dp.xla_conversion_status, 1, 1),
                     'U', '1',
                     'E', '1',
                     '0', to_char(to_number(dp.xla_conversion_status) + 1),
                     '1', to_char(to_number(dp.xla_conversion_status) + 1),
                     '2', to_char(to_number(dp.xla_conversion_status) + 1),
                     '3', to_char(to_number(dp.xla_conversion_status) + 1),
                     '4', to_char(to_number(dp.xla_conversion_status) + 1),
                     '5', to_char(to_number(dp.xla_conversion_status) + 1),
                     '6', to_char(to_number(dp.xla_conversion_status) + 1),
                     '7', to_char(to_number(dp.xla_conversion_status) + 1),
                     '8', to_char(to_number(dp.xla_conversion_status) + 1),
                     '9', to_char(to_number(dp.xla_conversion_status) + 1),
                     dp.xla_conversion_status)
      where dp.xla_conversion_status is not null
      and   dp.xla_conversion_status not in ('UA', 'UD', 'H')
      and   dp.period_close_date is null;

Line: 743

         update fa_deprn_periods dp
         set    dp.xla_conversion_status =
                decode (substr(dp.xla_conversion_status, 1, 1),
                        'U', '1',
                        'E', '1',
                        '0', to_char(to_number(dp.xla_conversion_status) + 1),
                        '1', to_char(to_number(dp.xla_conversion_status) + 1),
                        '2', to_char(to_number(dp.xla_conversion_status) + 1),
                        '3', to_char(to_number(dp.xla_conversion_status) + 1),
                        '4', to_char(to_number(dp.xla_conversion_status) + 1),
                        '5', to_char(to_number(dp.xla_conversion_status) + 1),
                        '6', to_char(to_number(dp.xla_conversion_status) + 1),
                        '7', to_char(to_number(dp.xla_conversion_status) + 1),
                        '8', to_char(to_number(dp.xla_conversion_status) + 1),
                        '9', to_char(to_number(dp.xla_conversion_status) + 1),
                        dp.xla_conversion_status)
         where dp.book_type_code = l_book_type_code_tbl(i)
         and   dp.period_name = l_period_name_tbl(i)
         and   dp.xla_conversion_status is not null
         and   dp.xla_conversion_status not in ('UA', 'UD', 'H');

Line: 792

   update fa_deprn_periods dp
   set    dp.xla_conversion_status = 'UA'
   where  dp.xla_conversion_status = to_char (p_workers_num)
   and    exists
   (
    select 'x'
    from   gl_period_statuses ps,
           fa_book_controls bc
    where  ps.application_id = 101
    and    ps.migration_status_code in ('P', 'U')
    and    bc.set_of_books_id = ps.set_of_books_id
    and    dp.book_type_code = bc.book_type_code
    and    ps.period_name = dp.period_name
   );

Line: 810

   update fa_deprn_periods dp
   set    dp.xla_conversion_status = 'ED'
   where  dp.xla_conversion_status <> to_char (p_workers_num)
   and    dp.xla_conversion_status not in ('UA', 'UT', 'UD')
   and    dp.xla_conversion_status is not null
   and    exists
   (
    select 'x'
    from   gl_period_statuses ps,
           fa_book_controls bc
    where  ps.application_id = 101
    and    ps.migration_status_code in ('P', 'U')
    and    bc.set_of_books_id = ps.set_of_books_id
    and    dp.book_type_code = bc.book_type_code
    and    ps.period_name = dp.period_name
   );

Line: 834

   update gl_period_statuses
   set    migration_status_code = 'U'
   where  migration_status_code = 'P'
   and    application_id = 101
   and    (ledger_id, period_name) in
   (
    select bc.set_of_books_id, dp.period_name
    from   fa_deprn_periods dp,
           fa_book_controls bc
    where  dp.xla_conversion_status in ('UA', 'UD', 'UT')
    and    bc.book_type_code = dp.book_type_code
    union all
    select bc.set_of_books_id, dp.period_name
    from   fa_deprn_periods dp,
           fa_mc_book_controls bc
    where  dp.xla_conversion_status in ('UA', 'UD', 'UT')
    and    bc.book_type_code = dp.book_type_code
    and    bc.enabled_flag = 'Y'
   );

Line: 858

   update gl_period_statuses ps
   set    ps.migration_status_code = null
   where  ps.migration_status_code = 'P'
   and    ps.application_id = 101
   and not exists
   (
    select 'x'
    from   fa_deprn_periods dp,
           fa_book_controls bc
    where  bc.book_type_code = dp.book_type_code
    and    bc.set_of_books_id = ps.ledger_id
    and    dp.period_name = ps.period_name
    union all
    select 'x'
    from   fa_deprn_periods dp,
           fa_mc_book_controls bc
    where  bc.book_type_code = dp.book_type_code
    and    bc.enabled_flag = 'Y'
    and    bc.set_of_books_id = ps.ledger_id
    and    dp.period_name = ps.period_name
   );

Line: 880

   update gl_period_statuses ps
   set    ps.migration_status_code = null
   where  ps.migration_status_code = 'P'
   and    ps.application_id = 101
   and exists
   (
    select 'x'
    from   fa_deprn_periods dp,
           fa_book_controls bc
    where  bc.book_type_code = dp.book_type_code
    and    bc.set_of_books_id = ps.ledger_id
    and    dp.period_name = ps.period_name
    and    dp.xla_conversion_status is null
    union all
    select 'x'
    from   fa_deprn_periods dp,
           fa_mc_book_controls bc
    where  bc.book_type_code = dp.book_type_code
    and    bc.enabled_flag = 'Y'
    and    bc.set_of_books_id = ps.ledger_id
    and    dp.period_name = ps.period_name
    and    dp.xla_conversion_status is null
   );