APPS.FA_REVALUATION_PVT dependencies on FA_BOOKS

Line 515: fa_books_pkg.deactivate_row

511: reval_err;
512: end if;
513: end if;
514: -- terminate the active row
515: fa_books_pkg.deactivate_row
516: (x_asset_id => px_asset_hdr_rec.asset_id,
517: x_book_type_code => px_asset_hdr_rec.book_type_code,
518: x_transaction_header_id_out => px_trans_rec.transaction_header_id,
519: x_date_ineffective => px_trans_rec.who_info.last_update_date,

Line 528: 'after fa_books_pkg.deactivate_row',

524:
525: IF (p_log_level_rec.statement_level)
526: THEN
527: fa_debug_pkg.ADD (l_calling_fn,
528: 'after fa_books_pkg.deactivate_row',
529: 1
530: , p_log_level_rec => p_log_level_rec);
531: END IF;
532:

Line 533: -- fa books

529: 1
530: , p_log_level_rec => p_log_level_rec);
531: END IF;
532:
533: -- fa books
534: fa_books_pkg.insert_row
535: (x_rowid => l_bks_rowid,
536: x_book_type_code => px_asset_hdr_rec.book_type_code,
537: x_asset_id => px_asset_hdr_rec.asset_id,

Line 534: fa_books_pkg.insert_row

530: , p_log_level_rec => p_log_level_rec);
531: END IF;
532:
533: -- fa books
534: fa_books_pkg.insert_row
535: (x_rowid => l_bks_rowid,
536: x_book_type_code => px_asset_hdr_rec.book_type_code,
537: x_asset_id => px_asset_hdr_rec.asset_id,
538: x_date_placed_in_service => l_asset_fin_rec_new.date_placed_in_service,

Line 689: UPDATE FA_BOOKS

685: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
686: raise reval_err;
687: end if;
688:
689: UPDATE FA_BOOKS
690: SET rate_in_use = l_rate_in_use
691: WHERE book_type_code = px_asset_hdr_rec.book_type_code
692: AND asset_id = px_asset_hdr_rec.asset_id
693: AND date_ineffective is null;

Line 3505: update fa_books_summary set reval_loss_balance = reval_loss_balance + ABS (l_reval_loss)

3501: l_adj_in.adjustment_amount := ABS (l_reval_loss);
3502:
3503: IF (l_reval_loss <> 0) THEN
3504: IF p_mrc_sob_type_code = 'P' THEN
3505: update fa_books_summary set reval_loss_balance = reval_loss_balance + ABS (l_reval_loss)
3506: where asset_id = p_asset_hdr_rec.asset_id
3507: and book_type_code = p_asset_hdr_rec.book_type_code
3508: and period_counter >= l_adj_in.period_counter_adjusted ;
3509: ELSE

Line 3831: delete from fa_books

3827: fa_debug_pkg.add(l_calling_fn,'Deleting accounting entries of reval thid: '
3828: , p_thid,p_log_level_rec => p_log_level_rec);
3829: end if;
3830:
3831: delete from fa_books
3832: where transaction_header_id_out is null
3833: and transaction_header_id_in = p_thid
3834: and book_type_code = p_asset_hdr_rec.book_type_code
3835: and asset_id = p_asset_hdr_rec.asset_id ;

Line 3851: update fa_books

3847: /*update fa_mass_Revaluations
3848: set status = 'ROLLBACKED'
3849: where */
3850:
3851: update fa_books
3852: set date_ineffective = null
3853: , transaction_header_id_out = null
3854: where asset_id = p_asset_hdr_rec.asset_id
3855: and book_type_code = p_asset_hdr_rec.book_type_code

Line 4150: UPDATE FA_BOOKS

4146: and book_type_code = p_asset_hdr_rec.book_type_code
4147: and transaction_header_id = p_thid
4148: ;
4149:
4150: UPDATE FA_BOOKS
4151: SET DATE_INEFFECTIVE = l_trans_rec.who_info.last_update_date
4152: , last_update_date = l_trans_rec.who_info.last_update_date
4153: , TRANSACTION_HEADER_ID_OUT = l_trans_rec.transaction_header_id
4154: WHERE ASSET_ID = p_asset_hdr_rec.asset_id

Line 4159: INSERT INTO FA_BOOKS( BOOK_TYPE_CODE

4155: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
4156: AND TRANSACTION_HEADER_ID_in = p_thid
4157: AND TRANSACTION_HEADER_ID_OUT is null;
4158:
4159: INSERT INTO FA_BOOKS( BOOK_TYPE_CODE
4160: , ASSET_ID
4161: , DATE_PLACED_IN_SERVICE
4162: , DATE_EFFECTIVE
4163: , DEPRN_START_DATE

Line 4389: FROM FA_BOOKS

4385: , OVER_DEPRECIATE_OPTION
4386: , DISABLED_FLAG
4387: , CASH_GENERATING_UNIT_ID
4388: , RATE_IN_USE
4389: FROM FA_BOOKS
4390: WHERE TRANSACTION_HEADER_ID_out = p_thid
4391: AND ASSET_ID = p_asset_hdr_rec.asset_id
4392: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code;
4393: