[Home] [Help]
955: l_reval_loss_balance number := 0;
956: cursor c_get_reval_loss(c_asset_id number,c_book varchar2)
957: is
958: select sum(decode(debit_credit_flag,'DR',adjustment_amount,-adjustment_amount))
959: from fa_adjustments
960: where asset_id = c_asset_id
961: and book_type_code = c_book
962: and adjustment_type = 'REVAL LOSS';
963:
2510:
2511: -- Bug 6666666 SORP END
2512: -- If cost adjustment is not 0 or the new life is not the
2513: -- same as old life and INSERT TRANSACTION_FLAG is TRUE then
2514: -- insert rows in FA_ADJUSTMENTS
2515: IF (p_reval_options_rec.run_mode = 'RUN')
2516: THEN
2517: IF ( x_reval_out.cost_adj <> 0
2518: OR p_asset_fin_rec_old.life_in_months <> x_reval_out.new_life
2540: px_asset_fin_rec_new.period_counter_life_complete :=
2541: x_reval_out.pc_fully_res;
2542:
2543: -- Load Adjustment structure for inserting into table
2544: -- FA_ADJUSTMENTS
2545:
2546: -- Get Asset Cost Account, Revaluation Reserve Account,
2547: -- Depreciation Reserve Account
2548: -- and Bonus Deprn Reserve Account
2763: l_adj_in.adjustment_amount := ABS (x_reval_out.reval_rsv_adj);
2764: l_adj_in.ACCOUNT := l_reval_rsv_acct;
2765: -- Added a new mode to differentiate the reval reserve
2766: -- value going
2767: -- from reval engine to fa_adjustments table vs.
2768: -- the reval reserve
2769: -- value going from depreciation engine to fa_deprn_detail
2770: -- table for bug 628863. aling
2771: l_adj_in.selection_mode := fa_adjust_type_pkg.fa_aj_active_reval;
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 ;
3836:
3837: delete from fa_adjustments
3838: where transaction_header_id = p_thid
3839: and asset_id = p_asset_hdr_rec.asset_id
3840: and book_type_code = p_asset_hdr_rec.book_type_code
3841: and period_counter_created = l_period_rec.period_counter;
4054: and book_type_code = p_asset_hdr_rec.book_type_code
4055: and transaction_header_id = p_thid
4056: ;
4057:
4058: INSERT INTO FA_ADJUSTMENTS(
4059: TRANSACTION_HEADER_ID
4060: , SOURCE_TYPE_CODE
4061: , ADJUSTMENT_TYPE
4062: , DEBIT_CREDIT_FLAG
4137: , GLOBAL_ATTRIBUTE20
4138: , GLOBAL_ATTRIBUTE_CATEGORY
4139: , DEPRN_OVERRIDE_FLAG
4140: , TRACK_MEMBER_FLAG
4141: , fa_adjustments_s.nextval -- ADJUSTMENT_LINE_ID
4142: , SOURCE_LINE_ID
4143: , SOURCE_DEST_CODE
4144: from fa_adjustments
4145: where asset_id = p_asset_hdr_rec.asset_id
4140: , TRACK_MEMBER_FLAG
4141: , fa_adjustments_s.nextval -- ADJUSTMENT_LINE_ID
4142: , SOURCE_LINE_ID
4143: , SOURCE_DEST_CODE
4144: from fa_adjustments
4145: where asset_id = p_asset_hdr_rec.asset_id
4146: and book_type_code = p_asset_hdr_rec.book_type_code
4147: and transaction_header_id = p_thid
4148: ;
4499: , GLOBAL_ATTRIBUTE20
4500: , GLOBAL_ATTRIBUTE_CATEGORY
4501: , DEPRN_OVERRIDE_FLAG
4502: , TRACK_MEMBER_FLAG
4503: , fa_adjustments_s.nextval -- ADJUSTMENT_LINE_ID
4504: , SOURCE_LINE_ID
4505: , SOURCE_DEST_CODE
4506: from fa_mc_adjustments
4507: where asset_id = p_asset_hdr_rec.asset_id