[Home] [Help]
278: order by fth.transaction_header_id desc;
279:
280: CURSOR c_get_old_adj_cost IS
281: select fb.ADJUSTED_COST
282: from fa_books fb,fa_transaction_headers fth
283: where fb.asset_id = l_asset_hdr_rec.asset_id
284: and fb. book_type_code = l_asset_hdr_rec.book_type_code
285: and fb.transaction_header_id_in = fth.transaction_header_id
286: and fb.book_type_code = fth.book_type_code
1042: /*Bug 9574021 need to keep original value of period counter fully reserve and period counter life complete for extended asset*/
1043: IF (l_asset_fin_rec.deprn_method_code = 'JP-STL-EXTND') then
1044: SELECT PERIOD_COUNTER_LIFE_COMPLETE,PERIOD_COUNTER_FULLY_RESERVED
1045: INTO t_period_counter_life_complete(i),t_period_counter_fully_rsv(i)
1046: FROM FA_BOOKS
1047: WHERE BOOK_TYPE_CODE = p_book_type_code
1048: AND ASSET_ID = l_asset_hdr_rec.asset_id
1049: AND TRANSACTION_HEADER_ID_OUT is NULL;
1050: /*BUG 9786860 */
1704:
1705: -- Deactivate Books
1706: if (p_mrc_sob_type_code = 'R') then
1707: if (p_log_level_rec.statement_level) then
1708: fa_debug_pkg.add(l_calling_fn,'Deactivating ', 'FA_BOOKS_MRC_V', p_log_level_rec => p_log_level_rec);
1709: end if;
1710:
1711: FORALL i in 1..t_request_id.count
1712: UPDATE FA_MC_BOOKS
1719: RETURNING transaction_header_id_in BULK COLLECT INTO t_old_thid;
1720:
1721: else
1722: if (p_log_level_rec.statement_level) then
1723: fa_debug_pkg.add(l_calling_fn,'Deactivating ', 'FA_BOOKS', p_log_level_rec => p_log_level_rec);
1724: end if;
1725:
1726: FORALL i in 1..t_request_id.count
1727: UPDATE FA_BOOKS
1723: fa_debug_pkg.add(l_calling_fn,'Deactivating ', 'FA_BOOKS', p_log_level_rec => p_log_level_rec);
1724: end if;
1725:
1726: FORALL i in 1..t_request_id.count
1727: UPDATE FA_BOOKS
1728: SET DATE_INEFFECTIVE = t_creation_date(i)
1729: , TRANSACTION_HEADER_ID_OUT = t_thid(i)
1730: WHERE ASSET_ID = t_asset_id(i)
1731: AND BOOK_TYPE_CODE = p_book_type_code
1735: -- Insert books
1736:
1737: if (p_mrc_sob_type_code = 'R') then
1738: if (p_log_level_rec.statement_level) then
1739: fa_debug_pkg.add(l_calling_fn,'Inserting record into ', 'FA_BOOKS_MRC_V', p_log_level_rec => p_log_level_rec);
1740: end if;
1741:
1742: FORALL i in 1..t_request_id.count
1743: INSERT INTO FA_MC_BOOKS( SET_OF_BOOKS_ID
1975: and SET_OF_BOOKS_ID = p_set_of_books_id ;
1976:
1977: else
1978: if (p_log_level_rec.statement_level) then
1979: fa_debug_pkg.add(l_calling_fn,'Inserting record into ', 'FA_BOOKS', p_log_level_rec => p_log_level_rec);
1980: end if;
1981:
1982: FORALL i in 1..t_request_id.count
1983: INSERT INTO FA_BOOKS( BOOK_TYPE_CODE
1979: fa_debug_pkg.add(l_calling_fn,'Inserting record into ', 'FA_BOOKS', p_log_level_rec => p_log_level_rec);
1980: end if;
1981:
1982: FORALL i in 1..t_request_id.count
1983: INSERT INTO FA_BOOKS( BOOK_TYPE_CODE
1984: , ASSET_ID
1985: , DATE_PLACED_IN_SERVICE
1986: , DATE_EFFECTIVE
1987: , DEPRN_START_DATE
2231: , PRIOR_DEPRN_LIMIT_TYPE
2232: , EXTENDED_DEPRECIATION_PERIOD
2233: , EXTENDED_DEPRN_FLAG
2234: , t_period_counter_fully_ext(i) --bug 9786860
2235: FROM FA_BOOKS
2236: WHERE TRANSACTION_HEADER_ID_IN = t_old_thid(i);
2237: end if;
2238:
2239: if (p_log_level_rec.statement_level) then