[Home] [Help]
1087: h_total_cost := 0;
1088: h_total_adjusted_cost := 0;
1089: h_total_recoverable_cost := 0;
1090:
1091: -- issue query against fa_books_summary
1092: For i IN 1 .. p_track_member_table.COUNT LOOP
1093:
1094: if p_track_member_table(i).group_asset_id = h_group_asset_id and
1095: p_track_member_table(i).period_counter = h_period_counter and
2979: l_unplanned_exp_tbl(l_count) := l_unplanned_exp_tbl(l_count) + l_unplanned_exp_mem_tbl(l_count);
2980: end loop;
2981:
2982: FORALL l_count IN 1..l_mem_asset_id_tbl.count
2983: UPDATE FA_BOOKS_SUMMARY
2984: SET DEPRN_AMOUNT = l_unplanned_exp_tbl(l_count) + DEPRN_AMOUNT,
2985: YTD_DEPRN = l_unplanned_exp_tbl(l_count) + YTD_DEPRN
2986: WHERE BOOK_TYPE_CODE = h_book_type_code
2987: AND PERIOD_COUNTER = h_period_counter
8908: and adj.book_type_code = h_book_type_code
8909: and adj.period_counter_adjusted = p_period_counter
8910: and set_of_books_id = h_set_of_books_id;
8911:
8912: --* cursor to populate Group Assets record from FA_BOOKS_SUMMARY
8913: cursor GET_GROUP_INFO(p_period_counter number) is
8914: select FISCAL_YEAR,
8915: PERIOD_NUM,
8916: CALENDAR_PERIOD_OPEN_DATE,
8934: -- EOFY_SALVAGE_VALULE,
8935: EOFY_RESERVE,
8936: SYSTEM_DEPRN_AMOUNT,
8937: SYSTEM_BONUS_DEPRN_AMOUNT
8938: from FA_BOOKS_SUMMARY
8939: where book_type_code = h_book_type_code
8940: and asset_id = h_group_asset_id
8941: and period_counter = p_period_counter;
8942:
8973:
8974: cursor GET_GROUP_SYSTEM_INFO(p_fiscal_year number, p_period_counter_end number) is
8975: select sum(nvl(SYSTEM_DEPRN_AMOUNT,0)),
8976: sum(nvl(SYSTEM_BONUS_DEPRN_AMOUNT,0))
8977: from FA_BOOKS_SUMMARY
8978: where book_type_code = h_book_type_code
8979: and asset_id = h_group_asset_id
8980: and fiscal_year = p_fiscal_year
8981: and period_counter <= p_period_counter_end;
8993: --* cursor to populate Group Assets record (Temporary)
8994: cursor GET_GROUP_SALVAGE(p_fiscal_year number, p_period_num number) is
8995: select SALVAGE_VALUE,
8996: RECOVERABLE_COST
8997: from FA_BOOKS_SUMMARY
8998: where book_type_code = h_book_type_code
8999: and asset_id = h_group_asset_id
9000: and fiscal_year = p_fiscal_year
9001: and period_num = p_period_num;
9009: and fiscal_year = p_fiscal_year
9010: and period_num = p_period_num
9011: and set_of_books_id = h_set_of_books_id;
9012:
9013: -- cursor to query fa_books_summary for this member/period
9014: cursor GET_PRV_ROW_BS is
9015: select COST,
9016: SALVAGE_VALUE,
9017: RECOVERABLE_COST,
9021: BONUS_DEPRN_RESERVE,
9022: YTD_DEPRN,
9023: BONUS_YTD_DEPRN,
9024: EOFY_RESERVE
9025: from FA_BOOKS_SUMMARY
9026: where book_type_code = h_book_type_code
9027: and group_asset_id = h_group_asset_id
9028: and period_counter = h_processing_period_counter -1
9029: and asset_id = h_member_asset_id;
9304: if (p_log_level_rec.statement_level) then
9305: if (h_find_flag_1) then
9306: fa_debug_pkg.add(l_calling_fn, 'Memory Table has data for this asset', '+++', p_log_level_rec => p_log_level_rec);
9307: else
9308: fa_debug_pkg.add(l_calling_fn, 'Need to query fa_books_summary table due to no data in'||
9309: ' memory table','+++', p_log_level_rec => p_log_level_rec);
9310: end if;
9311: end if;
9312:
9743: h_bonus_ytd_deprn,
9744: h_eofy_reserve;
9745: if GET_PRV_ROW_BS%NOTFOUND then
9746: if (p_log_level_rec.statement_level) then
9747: fa_debug_pkg.add(l_calling_fn, 'No data in FA_BOOKS_SUMMARY', '***');
9748: end if;
9749: else
9750: if (p_log_level_rec.statement_level) then
9751: fa_debug_pkg.add(l_calling_fn, 'Data in FA_BOOKS_SUMMARY', 'FOUND', p_log_level_rec => p_log_level_rec);
9747: fa_debug_pkg.add(l_calling_fn, 'No data in FA_BOOKS_SUMMARY', '***');
9748: end if;
9749: else
9750: if (p_log_level_rec.statement_level) then
9751: fa_debug_pkg.add(l_calling_fn, 'Data in FA_BOOKS_SUMMARY', 'FOUND', p_log_level_rec => p_log_level_rec);
9752: end if;
9753: if h_processing_period_num = 1 then
9754: h_ytd_deprn := 0;
9755: h_bonus_ytd_deprn := 0;
10193: h_bonus_ytd_deprn,
10194: h_eofy_reserve;
10195: if GET_PRV_ROW_BS_MRC%NOTFOUND then
10196: if (p_log_level_rec.statement_level) then
10197: fa_debug_pkg.add(l_calling_fn, 'No data in FA_BOOKS_SUMMARY', '***');
10198: end if;
10199: else
10200: if (p_log_level_rec.statement_level) then
10201: fa_debug_pkg.add(l_calling_fn, 'Data in FA_BOOKS_SUMMARY', 'FOUND', p_log_level_rec => p_log_level_rec);
10197: fa_debug_pkg.add(l_calling_fn, 'No data in FA_BOOKS_SUMMARY', '***');
10198: end if;
10199: else
10200: if (p_log_level_rec.statement_level) then
10201: fa_debug_pkg.add(l_calling_fn, 'Data in FA_BOOKS_SUMMARY', 'FOUND', p_log_level_rec => p_log_level_rec);
10202: end if;
10203: if h_processing_period_num = 1 then
10204: h_ytd_deprn := 0;
10205: h_bonus_ytd_deprn := 0;
11312:
11313: --+=====================================================================
11314: -- Function: create_update_books_summary
11315: --
11316: -- This function will be called to insert row into fa_books_summary if not exists
11317: -- update fa_books_summary row if exists
11318: -- Used merge statement for bug 7195989
11319: --+=====================================================================
11320:
11313: --+=====================================================================
11314: -- Function: create_update_books_summary
11315: --
11316: -- This function will be called to insert row into fa_books_summary if not exists
11317: -- update fa_books_summary row if exists
11318: -- Used merge statement for bug 7195989
11319: --+=====================================================================
11320:
11321: FUNCTION create_update_bs_table(p_trans_rec in FA_API_TYPES.trans_rec_type,
11472: );
11473:
11474: else
11475: forall j in 1..l_tbl_member_asset_id.COUNT
11476: MERGE INTO FA_BOOKS_SUMMARY BS
11477: USING (
11478: SELECT
11479: l_tbl_group_asset_id(j) as group_asset_id,
11480: l_tbl_member_asset_id(j) as member_asset_id,