DBA Data[Home] [Help]

APPS.FA_MASS_DEPRN_BASIS_PKG dependencies on FA_BOOKS

Line 128: fa_books bks,

124: FA_STD_TYPES.FAD_DBR_POLISH_NONE)
125: , nvl(ds.impairment_reserve, 0) -- P2IAS36
126: , nvl(mt.guarantee_rate_method_flag, 'NO') -- Bug:5930979:Japan Tax Reform Project
127: from fa_deprn_summary ds,
128: fa_books bks,
129: fa_methods mt,
130: fa_deprn_rule_details drd,
131: fa_additions_b ad
132: where ds.book_type_code = p_book_type_code

Line 475: -- Update fa_books with the new values. Business rules are:

471: end if; -- if ((l_eofy_flag = 'N') and -- Bug4940246
472:
473: end loop;
474:
475: -- Update fa_books with the new values. Business rules are:
476: -- 1. Do not update fa_books for any value if polish asset
477: -- 2. Only update eop_adj_cost, eop_formula_factor, adjusted_capacity,
478: -- old_adjusted_capacity if period_update_flag or
479: -- exclude_fully_reserve_flag is Yes

Line 476: -- 1. Do not update fa_books for any value if polish asset

472:
473: end loop;
474:
475: -- Update fa_books with the new values. Business rules are:
476: -- 1. Do not update fa_books for any value if polish asset
477: -- 2. Only update eop_adj_cost, eop_formula_factor, adjusted_capacity,
478: -- old_adjusted_capacity if period_update_flag or
479: -- exclude_fully_reserve_flag is Yes
480: -- 3. Only update eofy_adj_cost and eofy_formula_factor if eofy_flag

Line 603: update fa_books

599: end if;
600: if (l_eofy_flag = 'Y') then
601:
602: forall i IN 1..l_asset_id_tbl.count
603: update fa_books
604: set adjusted_cost = decode (l_polish_rule_tbl(i),
605: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
606: nvl(l_new_adjusted_cost_tbl(i), 0),
607: l_old_adjusted_cost_tbl(i)),

Line 661: update fa_books

657: fa_debug_pkg.add(l_calling_fn,'BEGIN',7, p_log_level_rec => g_log_level_rec);
658: end if;
659:
660: forall i IN 1..l_asset_id_tbl.count
661: update fa_books
662: set adjusted_cost = decode (l_polish_rule_tbl(i),
663: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
664: nvl(l_new_adjusted_cost_tbl(i), 0),
665: l_old_adjusted_cost_tbl(i)),

Line 751: update fa_books

747: end if; -- if l_guarantee_rate_flag_tbl
748: end loop;
749:
750: forall i IN 1..l_bks_rowid_tbl.count
751: update fa_books
752: set rate_in_use = l_rate_in_use_tbl(i)
753: where rowid = l_bks_rowid_tbl(i)
754: and l_guarantee_rate_flag_tbl(i) = 'YES';
755: