eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_MASS_DEPRN_BASIS_PKG SQL Statements

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

Line: 60


   l_period_update_flag_tbl                     char_tbl_type;

Line: 84


      select ds.asset_id,
             bks.rowid,
             bks.group_asset_id,
             ad.asset_type,
             bks.depreciate_flag,
             bks.deprn_method_code,
             bks.life_in_months,
             mt.method_id,
             mt.rate_source_rule,
             mt.deprn_basis_rule,
             bks.cost,
             bks.salvage_value,
             bks.recoverable_cost,
             bks.adjusted_cost,
             ds.deprn_reserve,
             ds.deprn_reserve - ds.deprn_amount,
             ds.ytd_deprn,
             ds.deprn_reserve,
             bks.adjusted_cost,
             bks.rate_adjustment_factor,
             bks.formula_factor,
             bks.eofy_reserve,
             bks.tracking_method,
             bks.eofy_formula_factor,
             bks.adjusted_capacity,
             bks.production_capacity - ds.ltd_production,
             bks.exclude_fully_rsv_flag,
             nvl(mt.deprn_basis_rule_id, 0),
             nvl(drd.period_update_flag, 'N'),
             nvl(drd.use_eofy_reserve_flag, 'N'),  -- Bug4940246
             decode (drd.rule_name,
              'POLISH 30% WITH A SWITCH TO DECLINING CLASSICAL AND FLAT RATE',
                 FA_STD_TYPES.FAD_DBR_POLISH_1,
              'POLISH 30% WITH A SWITCH TO FLAT RATE',
                 FA_STD_TYPES.FAD_DBR_POLISH_2,
              'POLISH DECLINING MODIFIED WITH A SWITCH TO DECLINING CLASSICAL AND FLAT RATE',
                 FA_STD_TYPES.FAD_DBR_POLISH_3,
              'POLISH DECLINING MODIFIED WITH A SWITCH TO FLAT RATE',
                 FA_STD_TYPES.FAD_DBR_POLISH_4,
              'POLISH STANDARD DECLINING WITH A SWITCH TO FLAT RATE',
                 FA_STD_TYPES.FAD_DBR_POLISH_5,
              FA_STD_TYPES.FAD_DBR_POLISH_NONE)
	     , nvl(mt.guarantee_rate_method_flag, 'NO') -- Bug 6665510: FP: Japan Tax Reform Project
      from   fa_deprn_summary ds,
             fa_books bks,
             fa_methods mt,
             fa_deprn_rule_details drd,
             fa_additions_b ad
      where  ds.book_type_code = p_book_type_code
      and    ds.period_counter = p_period_counter
      and    MOD(ds.asset_id, p_total_requests) = (p_request_number - 1)
      and    ds.book_type_code = bks.book_type_code
      and    ds.asset_id = bks.asset_id
      and    bks.transaction_header_id_out is null
      and    bks.deprn_method_code = mt.method_code
      and    nvl(bks.life_in_months, -99) = nvl(mt.life_in_months, -99)
      and    mt.deprn_basis_rule_id = drd.deprn_basis_rule_id (+)
      and    mt.rate_source_rule = drd.rate_source_rule (+)
      and    mt.deprn_basis_rule = drd.deprn_basis_rule (+)
      and    ds.asset_id = ad.asset_id;

Line: 147


      select ds.asset_id,
             bks.rowid,
             bks.group_asset_id,
             ad.asset_type,
             bks.depreciate_flag,
             bks.deprn_method_code,
             bks.life_in_months,
             mt.method_id,
             mt.rate_source_rule,
             mt.deprn_basis_rule,
             bks.cost,
             bks.salvage_value,
             bks.recoverable_cost,
             bks.adjusted_cost,
             ds.deprn_reserve,
             ds.deprn_reserve - ds.deprn_amount,
             ds.ytd_deprn,
             ds.deprn_reserve,
             bks.adjusted_cost,
             bks.rate_adjustment_factor,
             bks.formula_factor,
             bks.eofy_reserve,
             bks.tracking_method,
             bks.eofy_formula_factor,
             bks.adjusted_capacity,
             bks.production_capacity - ds.ltd_production,
             bks.exclude_fully_rsv_flag,
             nvl(mt.deprn_basis_rule_id, 0),
             nvl(drd.period_update_flag, 'N'),
             nvl(drd.use_eofy_reserve_flag, 'N'),  -- Bug4940246
             decode (drd.rule_name,
              'POLISH 30% WITH A SWITCH TO DECLINING CLASSICAL AND FLAT RATE',
                 FA_STD_TYPES.FAD_DBR_POLISH_1,
              'POLISH 30% WITH A SWITCH TO FLAT RATE',
                 FA_STD_TYPES.FAD_DBR_POLISH_2,
              'POLISH DECLINING MODIFIED WITH A SWITCH TO DECLINING CLASSICAL AND FLAT RATE',
                 FA_STD_TYPES.FAD_DBR_POLISH_3,
              'POLISH DECLINING MODIFIED WITH A SWITCH TO FLAT RATE',
                 FA_STD_TYPES.FAD_DBR_POLISH_4,
              'POLISH STANDARD DECLINING WITH A SWITCH TO FLAT RATE',
                 FA_STD_TYPES.FAD_DBR_POLISH_5,
              FA_STD_TYPES.FAD_DBR_POLISH_NONE)
	      , nvl(mt.guarantee_rate_method_flag, 'NO') -- Bug 6665510: FP: Japan Tax Reform Project
      from   fa_deprn_summary_mrc_v ds,
             fa_books_mrc_v bks,
             fa_methods mt,
             fa_deprn_rule_details drd,
             fa_additions_b ad
      where  ds.book_type_code = p_book_type_code
      and    ds.period_counter = p_period_counter
      and    MOD(ds.asset_id, p_total_requests) = (p_request_number - 1)
      and    ds.book_type_code = bks.book_type_code
      and    ds.asset_id = bks.asset_id
      and    bks.transaction_header_id_out is null
      and    bks.deprn_method_code = mt.method_code
      and    nvl(bks.life_in_months, -99) = nvl(mt.life_in_months, -99)
      and    mt.deprn_basis_rule_id = drd.deprn_basis_rule_id (+)
      and    mt.rate_source_rule = drd.rate_source_rule (+)
      and    mt.deprn_basis_rule = drd.deprn_basis_rule (+)
      and    ds.asset_id = ad.asset_id;

Line: 230


      select dp.fiscal_year,
             decode (dp.period_num,
                     ct.number_per_fiscal_year, 'Y',
                     'N') eofy_flag
      into   l_fiscal_year,
             l_eofy_flag
      from   fa_book_controls_mrc_v bc,
             fa_deprn_periods_mrc_v dp,
             fa_calendar_types ct
      where  dp.book_type_code = p_book_type_code
      and    dp.period_counter = p_period_counter
      and    bc.book_type_code = p_book_type_code
      and    bc.deprn_calendar = ct.calendar_type;

Line: 246


      select dp.fiscal_year,
             decode (dp.period_num,
                     ct.number_per_fiscal_year, 'Y',
                     'N') eofy_flag,
	     dp.period_num
      into   l_fiscal_year,
             l_eofy_flag,
	     l_period_num
      from   fa_book_controls bc,
             fa_deprn_periods dp,
             fa_calendar_types ct
      where  dp.book_type_code = p_book_type_code
      and    dp.period_counter = p_period_counter
      and    bc.book_type_code = p_book_type_code
      and    bc.deprn_calendar = ct.calendar_type;

Line: 307


               l_period_update_flag_tbl,
               l_use_eofy_reserve_flag,-- Bug4940246
               l_polish_rule_tbl,
	       l_guarantee_rate_flag_tbl  -- Bug 6665510: FP: Japan Tax Reform Project
               limit c_batch_size;

Line: 343


               l_period_update_flag_tbl,
               l_use_eofy_reserve_flag,  -- Bug4940246
               l_polish_rule_tbl,
	       l_guarantee_rate_flag_tbl  -- Bug 6665510: FP: Japan Tax Reform Project
               limit c_batch_size;

Line: 373


            fa_debug_pkg.add(l_calling_fn,'l_period_update_flag_tbl',
                             l_period_update_flag_tbl(i), g_log_level_rec);

Line: 380


               (l_period_update_flag_tbl(i) = 'N')) or
              ((l_eofy_flag = 'Y') and
               (l_use_eofy_reserve_flag(i) = 'N') and
               (l_period_update_flag_tbl(i) = 'N')) then

              l_new_adjusted_cost_tbl(i) := l_old_adjusted_cost_tbl(i);

Line: 478


            update fa_books_mrc_v
            set    adjusted_cost = decode (l_polish_rule_tbl(i),
                      FA_STD_TYPES.FAD_DBR_POLISH_NONE,
                         nvl(l_new_adjusted_cost_tbl(i), 0),
                      l_old_adjusted_cost_tbl(i)),
                   formula_factor = decode (l_polish_rule_tbl(i),
                      FA_STD_TYPES.FAD_DBR_POLISH_NONE,
                         nvl(l_new_formula_factor_tbl(i), 1),
                      l_old_formula_factor_tbl(i)),
                   eofy_adj_cost = decode (l_polish_rule_tbl(i),
                      FA_STD_TYPES.FAD_DBR_POLISH_NONE,
                         l_old_adjusted_cost_tbl(i),
                      eofy_adj_cost),
                   eofy_formula_factor = decode (l_polish_rule_tbl(i),
                      FA_STD_TYPES.FAD_DBR_POLISH_NONE,
                         l_new_formula_factor_tbl(i),
                      eofy_formula_factor),
                   eofy_reserve = decode (l_polish_rule_tbl(i),
                      FA_STD_TYPES.FAD_DBR_POLISH_NONE,
                         nvl(l_current_total_rsv_tbl(i), 0),
                      eofy_reserve),
                   prior_eofy_reserve = decode (l_polish_rule_tbl(i),
                      FA_STD_TYPES.FAD_DBR_POLISH_NONE,
                         nvl(l_eofy_reserve_tbl(i), 0),
                      prior_eofy_reserve),
                   eop_adj_cost = decode (l_polish_rule_tbl(i),
                      FA_STD_TYPES.FAD_DBR_POLISH_NONE,
                         decode (l_period_update_flag_tbl(i),
                            'Y', nvl(l_old_adjusted_cost_tbl(i), 0),
                            decode (l_exclude_fully_rsv_flag_tbl(i),
                               'Y', nvl(l_old_adjusted_cost_tbl(i), 0),
                               eop_adj_cost)),
                      eop_adj_cost),
                   eop_formula_factor = decode (l_polish_rule_tbl(i),
                      FA_STD_TYPES.FAD_DBR_POLISH_NONE,
                         decode (l_period_update_flag_tbl(i),
                            'Y', nvl(l_eofy_formula_factor_tbl(i), 1),
                            decode (l_exclude_fully_rsv_flag_tbl(i),
                               'Y', nvl(l_eofy_formula_factor_tbl(i), 1),
                                eop_formula_factor)),
                      eop_formula_factor),
                   adjusted_capacity = decode (l_polish_rule_tbl(i),
                      FA_STD_TYPES.FAD_DBR_POLISH_NONE,
                         decode (l_period_update_flag_tbl(i),
                            'Y', nvl(l_new_adjusted_capacity_tbl(i), 0),
                            decode (l_exclude_fully_rsv_flag_tbl(i),
                               'Y', nvl(l_new_adjusted_capacity_tbl(i), 0),
                               adjusted_capacity)),
                      adjusted_capacity)
            where  rowid = l_bks_rowid_tbl(i);

Line: 532


            update fa_books_mrc_v
            set    adjusted_cost = decode (l_polish_rule_tbl(i),
                      FA_STD_TYPES.FAD_DBR_POLISH_NONE,
                         nvl(l_new_adjusted_cost_tbl(i), 0),
                      l_old_adjusted_cost_tbl(i)),
                   formula_factor = decode (l_polish_rule_tbl(i),
                      FA_STD_TYPES.FAD_DBR_POLISH_NONE,
                         nvl(l_new_formula_factor_tbl(i), 1),
                      l_old_formula_factor_tbl(i)),
                   prior_eofy_reserve = decode (l_polish_rule_tbl(i),
                      FA_STD_TYPES.FAD_DBR_POLISH_NONE,
                         nvl(l_eofy_reserve_tbl(i), 0),
                      prior_eofy_reserve),
                   eop_adj_cost = decode (l_polish_rule_tbl(i),
                      FA_STD_TYPES.FAD_DBR_POLISH_NONE,
                         decode (l_period_update_flag_tbl(i),
                            'Y', nvl(l_old_adjusted_cost_tbl(i), 0),
                            decode (l_exclude_fully_rsv_flag_tbl(i),
                               'Y', nvl(l_old_adjusted_cost_tbl(i), 0),
                               eop_adj_cost)),
                      eop_adj_cost),
                   eop_formula_factor = decode (l_polish_rule_tbl(i),
                      FA_STD_TYPES.FAD_DBR_POLISH_NONE,
                         decode (l_period_update_flag_tbl(i),
                            'Y', nvl(l_eofy_formula_factor_tbl(i), 1),
                            decode (l_exclude_fully_rsv_flag_tbl(i),
                               'Y', nvl(l_eofy_formula_factor_tbl(i), 1),
                                eop_formula_factor)),
                      eop_formula_factor),
                   adjusted_capacity = decode (l_polish_rule_tbl(i),
                      FA_STD_TYPES.FAD_DBR_POLISH_NONE,
                         decode (l_period_update_flag_tbl(i),
                            'Y', nvl(l_new_adjusted_capacity_tbl(i), 0),
                            decode (l_exclude_fully_rsv_flag_tbl(i),
                               'Y', nvl(l_new_adjusted_capacity_tbl(i), 0),
                               adjusted_capacity)),
                      adjusted_capacity)
            where  rowid = l_bks_rowid_tbl(i);

Line: 581


            update fa_books
            set    adjusted_cost = decode (l_polish_rule_tbl(i),
                      FA_STD_TYPES.FAD_DBR_POLISH_NONE,
                         nvl(l_new_adjusted_cost_tbl(i), 0),
                      l_old_adjusted_cost_tbl(i)),
                   formula_factor = decode (l_polish_rule_tbl(i),
                      FA_STD_TYPES.FAD_DBR_POLISH_NONE,
                         nvl(l_new_formula_factor_tbl(i), 1),
                      l_old_formula_factor_tbl(i)),
                   eofy_adj_cost = decode (l_polish_rule_tbl(i),
                      FA_STD_TYPES.FAD_DBR_POLISH_NONE,
                         l_old_adjusted_cost_tbl(i),
                      eofy_adj_cost),
                   eofy_formula_factor = decode (l_polish_rule_tbl(i),
                      FA_STD_TYPES.FAD_DBR_POLISH_NONE,
                         l_new_formula_factor_tbl(i),
                      eofy_formula_factor),
                   eofy_reserve = decode (l_polish_rule_tbl(i),
                      FA_STD_TYPES.FAD_DBR_POLISH_NONE,
                         nvl(l_current_total_rsv_tbl(i), 0),
                      eofy_reserve),
                   prior_eofy_reserve = decode (l_polish_rule_tbl(i),
                      FA_STD_TYPES.FAD_DBR_POLISH_NONE,
                         nvl(l_eofy_reserve_tbl(i), 0),
                      prior_eofy_reserve),
                   eop_adj_cost = decode (l_polish_rule_tbl(i),
                      FA_STD_TYPES.FAD_DBR_POLISH_NONE,
                         decode (l_period_update_flag_tbl(i),
                            'Y', nvl(l_old_adjusted_cost_tbl(i), 0),
                            decode (l_exclude_fully_rsv_flag_tbl(i),
                               'Y', nvl(l_old_adjusted_cost_tbl(i), 0),
                               eop_adj_cost)),
                      eop_adj_cost),
                   eop_formula_factor = decode (l_polish_rule_tbl(i),
                      FA_STD_TYPES.FAD_DBR_POLISH_NONE,
                         decode (l_period_update_flag_tbl(i),
                            'Y', nvl(l_eofy_formula_factor_tbl(i), 1),
                            decode (l_exclude_fully_rsv_flag_tbl(i),
                               'Y', nvl(l_eofy_formula_factor_tbl(i), 1),
                                eop_formula_factor)),
                      eop_formula_factor),
                   adjusted_capacity = decode (l_polish_rule_tbl(i),
                      FA_STD_TYPES.FAD_DBR_POLISH_NONE,
                         decode (l_period_update_flag_tbl(i),
                            'Y', nvl(l_new_adjusted_capacity_tbl(i), 0),
                            decode (l_exclude_fully_rsv_flag_tbl(i),
                               'Y', nvl(l_new_adjusted_capacity_tbl(i), 0),
                               adjusted_capacity)),
                      adjusted_capacity)
            where  rowid = l_bks_rowid_tbl(i);

Line: 640


            update fa_books
            set    adjusted_cost = decode (l_polish_rule_tbl(i),
                      FA_STD_TYPES.FAD_DBR_POLISH_NONE,
                         nvl(l_new_adjusted_cost_tbl(i), 0),
                      l_old_adjusted_cost_tbl(i)),
                   formula_factor = decode (l_polish_rule_tbl(i),
                      FA_STD_TYPES.FAD_DBR_POLISH_NONE,
                         nvl(l_new_formula_factor_tbl(i), 1),
                      l_old_formula_factor_tbl(i)),
                   prior_eofy_reserve = decode (l_polish_rule_tbl(i),
                      FA_STD_TYPES.FAD_DBR_POLISH_NONE,
                         nvl(l_eofy_reserve_tbl(i), 0),
                      prior_eofy_reserve),
                   eop_adj_cost = decode (l_polish_rule_tbl(i),
                      FA_STD_TYPES.FAD_DBR_POLISH_NONE,
                         decode (l_period_update_flag_tbl(i),
                            'Y', nvl(l_old_adjusted_cost_tbl(i), 0),
                            decode (l_exclude_fully_rsv_flag_tbl(i),
                               'Y', nvl(l_old_adjusted_cost_tbl(i), 0),
                               eop_adj_cost)),
                      eop_adj_cost),
                   eop_formula_factor = decode (l_polish_rule_tbl(i),
                      FA_STD_TYPES.FAD_DBR_POLISH_NONE,
                         decode (l_period_update_flag_tbl(i),
                            'Y', nvl(l_eofy_formula_factor_tbl(i), 1),
                            decode (l_exclude_fully_rsv_flag_tbl(i),
                               'Y', nvl(l_eofy_formula_factor_tbl(i), 1),
                                eop_formula_factor)),
                      eop_formula_factor),
                   adjusted_capacity = decode (l_polish_rule_tbl(i),
                      FA_STD_TYPES.FAD_DBR_POLISH_NONE,
                         decode (l_period_update_flag_tbl(i),
                            'Y', nvl(l_new_adjusted_capacity_tbl(i), 0),
                            decode (l_exclude_fully_rsv_flag_tbl(i),
                               'Y', nvl(l_new_adjusted_capacity_tbl(i), 0),
                               adjusted_capacity)),
                      adjusted_capacity)
            where  rowid = l_bks_rowid_tbl(i);

Line: 730


            update fa_books
		    set rate_in_use = l_rate_in_use_tbl(i)
  		    where rowid = l_bks_rowid_tbl(i)
			and l_guarantee_rate_flag_tbl(i) = 'YES';

Line: 739


      l_bks_rowid_tbl.delete;

Line: 740


      l_asset_id_tbl.delete;

Line: 741


      l_group_asset_id_tbl.delete;

Line: 742


      l_asset_type_tbl.delete;

Line: 743


      l_depreciate_flag_tbl.delete;

Line: 744


      l_method_code_tbl.delete;

Line: 745


      l_life_in_months_tbl.delete;

Line: 746


      l_method_id_tbl.delete;

Line: 747


      l_method_type_tbl.delete;

Line: 748


      l_calc_basis_tbl.delete;

Line: 749


      l_cost_tbl.delete;

Line: 750


      l_salvage_value_tbl.delete;

Line: 751


      l_recoverable_cost_tbl.delete;

Line: 752


      l_adjusted_cost_tbl.delete;

Line: 753


      l_current_total_rsv_tbl.delete;

Line: 754


      l_current_rsv_tbl.delete;

Line: 755


      l_current_total_ytd_tbl.delete;

Line: 756


      l_hyp_total_rsv_tbl.delete;

Line: 757


      l_old_adjusted_cost_tbl.delete;

Line: 758


      l_old_raf_tbl.delete;

Line: 759


      l_old_formula_factor_tbl.delete;

Line: 760


      l_new_adjusted_cost_tbl.delete;

Line: 761


      l_new_raf_tbl.delete;

Line: 762


      l_new_formula_factor_tbl.delete;

Line: 763


      l_eofy_reserve_tbl.delete;

Line: 764


      l_tracking_method_tbl.delete;

Line: 765


      l_eofy_formula_factor_tbl.delete;

Line: 766


      l_adjusted_capacity_tbl.delete;

Line: 767


      l_new_adjusted_capacity_tbl.delete;

Line: 768


      l_exclude_fully_rsv_flag_tbl.delete;

Line: 769


      l_deprn_basis_rule_id_tbl.delete;

Line: 770


      l_period_update_flag_tbl.delete;

Line: 771


      l_polish_rule_tbl.delete;

Line: 774


      l_rate_in_use_tbl.delete;

Line: 775


      l_guarantee_rate_flag_tbl.delete;