The following lines contain the word 'select', 'insert', 'update' or 'delete':
select ITF.REQUEST_ID
, ITF.IMPAIRMENT_ID
, ITF.BOOK_TYPE_CODE
, ITF.ASSET_ID
, ITF.CASH_GENERATING_UNIT_ID
, ITF.NET_BOOK_VALUE
, ITF.NET_SELLING_PRICE
, ITF.VALUE_IN_USE
, ITF.IMPAIRMENT_AMOUNT
, ITF.YTD_IMPAIRMENT
, ITF.impairment_reserve
, ITF.GOODWILL_ASSET_FLAG
, NVL(ITF.DEPRN_RUN_DATE,sysdate) -- bug #6658765
, NVL(ITF.DEPRN_AMOUNT,0) -- bug #6658765
, NVL(ITF.YTD_DEPRN,0) -- bug #6658765
, NVL(ITF.DEPRN_RESERVE,0) -- bug #6658765
, ITF.ADJUSTED_COST
, ITF.BONUS_RATE
, ITF.LTD_PRODUCTION
, ITF.PERIOD_COUNTER
, ITF.PRODUCTION
, ITF.REVAL_AMORTIZATION
, ITF.REVAL_AMORTIZATION_BASIS
, ITF.REVAL_DEPRN_EXPENSE
, NVL(ITF.REVAL_RESERVE,0)
, ITF.YTD_PRODUCTION
, ITF.YTD_REVAL_DEPRN_EXPENSE
, ITF.PRIOR_FY_EXPENSE
, ITF.BONUS_DEPRN_AMOUNT
, ITF.BONUS_YTD_DEPRN
, ITF.BONUS_DEPRN_RESERVE
, ITF.PRIOR_FY_BONUS_EXPENSE
, ITF.DEPRN_OVERRIDE_FLAG
, ITF.SYSTEM_DEPRN_AMOUNT
, ITF.SYSTEM_BONUS_DEPRN_AMOUNT
, nvl(ITF.DEPRN_ADJUSTMENT_AMOUNT, 0)
, nvl(ITF.BONUS_DEPRN_ADJUSTMENT_AMOUNT, 0)
, ITF.COST
, ITF.CREATION_DATE
, ITF.CREATED_BY
, ITF.CURRENT_UNITS
, ITF.CATEGORY_ID
, ITF.IMPAIRMENT_DATE
, ITF.PERIOD_OF_ADDITION_FLAG
, nvl(ITF.REVAL_RESERVE_ADJ_AMOUNT, 0)
, ITF.RATE_ADJUSTMENT_FACTOR
, ITF.FORMULA_FACTOR
, ITF.EOFY_RESERVE
, ITF.CAPITAL_ADJUSTMENT -- Start of Bug 6666666
, ITF.GENERAL_FUND
, ITF.IMPAIR_CLASS
, ITF.IMPAIR_LOSS_ACCT
, ITF.SPLIT_IMPAIR_FLAG
, ITF.SPLIT1_IMPAIR_CLASS
, ITF.SPLIT1_LOSS_AMOUNT
, ITF.SPLIT1_REVAL_RESERVE
, ITF.SPLIT1_PERCENT
, ITF.SPLIT1_LOSS_ACCT
, ITF.SPLIT2_IMPAIR_CLASS
, ITF.SPLIT2_LOSS_AMOUNT
, ITF.SPLIT2_REVAL_RESERVE
, ITF.SPLIT2_PERCENT
, ITF.SPLIT2_LOSS_ACCT
, ITF.SPLIT3_IMPAIR_CLASS
, ITF.SPLIT3_LOSS_AMOUNT
, ITF.SPLIT3_REVAL_RESERVE
, ITF.SPLIT3_PERCENT
, ITF.SPLIT3_LOSS_ACCT -- End of Bug 6666666
, nvl(ITF.ALLOWED_DEPRN_LIMIT_AMOUNT,0)
, ITF.REVAL_LOSS_BALANCE
from FA_ITF_IMPAIRMENTS ITF
, FA_IMPAIRMENTS IMP
where ITF.WORKER_ID = p_worker_id
and ITF.BOOK_TYPE_CODE = p_book_type_code
and IMP.REQUEST_ID = p_request_id
and IMP.BOOK_TYPE_CODE = p_book_type_code
and IMP.IMPAIRMENT_ID = ITF.IMPAIRMENT_ID
and IMP.STATUS = l_mode
and (IMP.IMPAIRMENT_AMOUNT <> 0 AND IMP.NET_BOOK_VALUE <> 0) -- Bug# 7000391
-- and ITF.PERIOD_COUNTER = p_period_rec.period_counter
;
select ITF.REQUEST_ID
, ITF.IMPAIRMENT_ID
, ITF.BOOK_TYPE_CODE
, ITF.ASSET_ID
, ITF.CASH_GENERATING_UNIT_ID
, ITF.NET_BOOK_VALUE
, ITF.NET_SELLING_PRICE
, ITF.VALUE_IN_USE
, ITF.IMPAIRMENT_AMOUNT
, ITF.YTD_IMPAIRMENT
, ITF.impairment_reserve
, ITF.GOODWILL_ASSET_FLAG
, NVL(ITF.DEPRN_RUN_DATE,sysdate) -- Bug #6658765
, NVL(ITF.DEPRN_AMOUNT,0) -- Bug #6658765
, NVL(ITF.YTD_DEPRN,0) -- Bug #6658765
, NVL(ITF.DEPRN_RESERVE,0) -- Bug #6658765
, ITF.ADJUSTED_COST
, ITF.BONUS_RATE
, ITF.LTD_PRODUCTION
, ITF.PERIOD_COUNTER
, ITF.PRODUCTION
, ITF.REVAL_AMORTIZATION
, ITF.REVAL_AMORTIZATION_BASIS
, ITF.REVAL_DEPRN_EXPENSE
, NVL(ITF.REVAL_RESERVE,0)
, ITF.YTD_PRODUCTION
, ITF.YTD_REVAL_DEPRN_EXPENSE
, ITF.PRIOR_FY_EXPENSE
, ITF.BONUS_DEPRN_AMOUNT
, ITF.BONUS_YTD_DEPRN
, ITF.BONUS_DEPRN_RESERVE
, ITF.PRIOR_FY_BONUS_EXPENSE
, ITF.DEPRN_OVERRIDE_FLAG
, ITF.SYSTEM_DEPRN_AMOUNT
, ITF.SYSTEM_BONUS_DEPRN_AMOUNT
, nvl(ITF.DEPRN_ADJUSTMENT_AMOUNT, 0)
, nvl(ITF.BONUS_DEPRN_ADJUSTMENT_AMOUNT, 0)
, ITF.COST
, ITF.CREATION_DATE
, ITF.CREATED_BY
, ITF.CURRENT_UNITS
, ITF.CATEGORY_ID
, ITF.IMPAIRMENT_DATE
, ITF.PERIOD_OF_ADDITION_FLAG
, nvl(ITF.REVAL_RESERVE_ADJ_AMOUNT, 0)
, ITF.RATE_ADJUSTMENT_FACTOR
, ITF.FORMULA_FACTOR
, ITF.EOFY_RESERVE
, ITF.CAPITAL_ADJUSTMENT -- Start of Bug 6666666
, ITF.GENERAL_FUND
, ITF.IMPAIR_CLASS
, ITF.IMPAIR_LOSS_ACCT
, ITF.SPLIT_IMPAIR_FLAG
, ITF.SPLIT1_IMPAIR_CLASS
, ITF.SPLIT1_LOSS_AMOUNT
, ITF.SPLIT1_REVAL_RESERVE
, ITF.SPLIT1_PERCENT
, ITF.SPLIT1_LOSS_ACCT
, ITF.SPLIT2_IMPAIR_CLASS
, ITF.SPLIT2_LOSS_AMOUNT
, ITF.SPLIT2_REVAL_RESERVE
, ITF.SPLIT2_PERCENT
, ITF.SPLIT2_LOSS_ACCT
, ITF.SPLIT3_IMPAIR_CLASS
, ITF.SPLIT3_LOSS_AMOUNT
, ITF.SPLIT3_REVAL_RESERVE
, ITF.SPLIT3_PERCENT
, ITF.SPLIT3_LOSS_ACCT -- End of Bug 6666666
, nvl(ITF.ALLOWED_DEPRN_LIMIT_AMOUNT,0)
, ITF.REVAL_LOSS_BALANCE
from FA_MC_ITF_IMPAIRMENTS ITF
, FA_MC_IMPAIRMENTS IMP
where ITF.WORKER_ID = p_worker_id
and ITF.BOOK_TYPE_CODE = p_book_type_code
and ITF.SET_OF_BOOKS_ID = p_set_of_books_id
and IMP.REQUEST_ID = p_request_id
and IMP.BOOK_TYPE_CODE = p_book_type_code
and IMP.IMPAIRMENT_ID = ITF.IMPAIRMENT_ID
and IMP.STATUS = l_mode
and IMP.SET_OF_BOOKS_ID = p_set_of_books_id
and (IMP.IMPAIRMENT_AMOUNT <> 0 AND IMP.NET_BOOK_VALUE <> 0) -- Bug# 7000391
-- and ITF.PERIOD_COUNTER = p_period_rec.period_counter
;
select th.transaction_header_id
, th.transaction_date_entered
, th.date_effective
, th.last_update_date
, th.last_updated_by
, th.transaction_subtype
, th.transaction_key
, th.amortization_start_date
, th.calling_interface
, decode(dt.transaction_header_id_out, null, null, dt.distribution_id)
, dt.code_combination_id
, dt.location_id
, dt.assigned_to
, dt.transaction_units
FROM fa_transaction_headers th
, fa_distribution_history dt
WHERE th.book_type_code = p_book_type_code
AND th.asset_id = l_asset_hdr_rec.asset_id
AND dt.asset_id = l_asset_hdr_rec.asset_id
AND dt.book_type_code = p_book_type_code
AND (dt.transaction_header_id_in = th.transaction_header_id or
dt.transaction_header_id_out = th.transaction_header_id)
AND th.transaction_type_code = 'TRANSFER'
AND th.transaction_date_entered <
p_period_rec.calendar_period_open_date
AND th.date_effective >= p_period_rec.period_open_date;
select fb.ADJUSTED_COST
from fa_mc_books fb,fa_transaction_headers fth
where fb.asset_id = l_asset_hdr_rec.asset_id
and fb. book_type_code = l_asset_hdr_rec.book_type_code
and fb.transaction_header_id_in = fth.transaction_header_id
and fb.book_type_code = fth.book_type_code
and fb.asset_id = fth.asset_id
and fb.deprn_method_code = 'JP-STL-EXTND'
and nvl(fth.transaction_key,'XX') <> 'IM'
order by fth.transaction_header_id desc;
select fb.ADJUSTED_COST
from fa_books fb,fa_transaction_headers fth
where fb.asset_id = l_asset_hdr_rec.asset_id
and fb. book_type_code = l_asset_hdr_rec.book_type_code
and fb.transaction_header_id_in = fth.transaction_header_id
and fb.book_type_code = fth.book_type_code
and fb.asset_id = fth.asset_id
and fb.deprn_method_code = 'JP-STL-EXTND'
and nvl(fth.transaction_key,'XX') <> 'IM'
order by fth.transaction_header_id desc;
t_thid FA_IMPAIRMENT_DELETE_PVT.tab_num15_type; /* 8394781 */
t_last_update_date tab_date_type;
t_last_updated_by tab_num15_type;
l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
l_adj.selection_retid := 0;
/*Bug#9182681 - to update request_id,for asset impairment report */
if (p_mrc_sob_type_code = 'R') then
UPDATE FA_MC_ITF_IMPAIRMENTS
set REQUEST_ID = p_request_id
WHERE WORKER_ID = p_worker_id
AND BOOK_TYPE_CODE = p_book_type_code
AND SET_OF_BOOKS_ID = p_set_of_books_id
AND IMPAIRMENT_ID in
(SELECT IMPAIRMENT_ID
FROM FA_MC_IMPAIRMENTS IMP
WHERE IMP.BOOK_TYPE_CODE = p_book_type_code
AND IMP.STATUS = l_mode
AND IMP.SET_OF_BOOKS_ID = p_set_of_books_id
AND (IMP.IMPAIRMENT_AMOUNT <> 0 AND IMP.NET_BOOK_VALUE <> 0));
UPDATE FA_ITF_IMPAIRMENTS
set REQUEST_ID = p_request_id
WHERE WORKER_ID = p_worker_id
AND BOOK_TYPE_CODE = p_book_type_code
AND IMPAIRMENT_ID in
(SELECT IMPAIRMENT_ID
FROM FA_IMPAIRMENTS IMP
WHERE IMP.BOOK_TYPE_CODE = p_book_type_code
AND IMP.STATUS = l_mode
AND (IMP.IMPAIRMENT_AMOUNT <> 0 AND IMP.NET_BOOK_VALUE <> 0));
t_thid.delete;
t_old_thid.delete;
UPDATE fa_deprn_override
SET status = 'POSTED'
WHERE asset_id = t_asset_id(i)
AND book_type_code = p_book_type_code
AND period_name = p_period_rec.period_name
AND t_deprn_override_flag(i) <> fa_std_types.FA_NO_OVERRIDE;
UPDATE FA_TRANSACTION_HEADERS
SET ATTRIBUTE15 = ATTRIBUTE15
WHERE ASSET_ID = t_asset_id(i)
AND BOOK_TYPE_CODE = p_book_type_code
AND TRANSACTION_TYPE_CODE = decode(G_release,'11',decode(t_period_of_addition_flag(i), 'Y', 'ADDITION', 'ADJUSTMENT'),'ADJUSTMENT')
AND TRANSACTION_DATE_ENTERED = t_impairment_date(i)
AND TRANSACTION_SUBTYPE = 'AMORTIZED'
AND TRANSACTION_KEY = 'IM'
AND CALLING_INTERFACE = 'FAPIMP'
AND DATE_EFFECTIVE = t_creation_date(i)
RETURNING TRANSACTION_HEADER_ID BULK COLLECT INTO t_thid;
if not FA_IMPAIRMENT_DELETE_PVT.process_impair_event(
p_book_type_code => p_book_type_code,
p_mrc_sob_type_code => p_mrc_sob_type_code,
p_set_of_books_id => l_secondary_sob_id,
p_calling_fn => l_calling_fn ,
p_thid => t_thid,
p_log_level_rec => p_log_level_rec ) then
raise pos_err;
fa_debug_pkg.add(l_calling_fn,'Insert into ', 'FA_TRANSACTION_HEADERS', p_log_level_rec => p_log_level_rec);
UPDATE FA_TRANSACTION_HEADERS
SET TRANSACTION_TYPE_CODE = 'ADDITION/VOID'
WHERE t_period_of_addition_flag(i) = 'Y'
AND asset_id = t_asset_id(i)
AND book_type_code = p_book_type_code
AND transaction_type_code = 'ADDITION';
INSERT INTO FA_TRANSACTION_HEADERS(
TRANSACTION_HEADER_ID
, BOOK_TYPE_CODE
, ASSET_ID
, TRANSACTION_TYPE_CODE
, TRANSACTION_DATE_ENTERED
, DATE_EFFECTIVE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, TRANSACTION_SUBTYPE
, TRANSACTION_KEY
, AMORTIZATION_START_DATE
, CALLING_INTERFACE
, MASS_TRANSACTION_ID
) VALUES (
FA_TRANSACTION_HEADERS_S.NEXTVAL
, p_book_type_code
, t_asset_id(i)
, decode(G_release,'11',decode(t_period_of_addition_flag(i), 'Y', 'ADDITION', 'ADJUSTMENT'),'ADJUSTMENT')
, t_impairment_date(i)
, t_creation_date(i)
, t_creation_date(i)
, t_created_by(i)
, 'AMORTIZED'
, 'IM'
, t_impairment_date(i)
, 'FAPIMP'
, t_impairment_id(i)
) RETURNING transaction_header_id BULK COLLECT INTO t_thid;
if not FA_IMPAIRMENT_DELETE_PVT.process_impair_event(
p_book_type_code => p_book_type_code,
p_mrc_sob_type_code => p_mrc_sob_type_code,
p_set_of_books_id => p_set_of_books_id,
p_calling_fn => l_calling_fn ,
p_thid => t_thid,
p_log_level_rec => p_log_level_rec ) then
raise pos_err;
l_adj.last_update_date := t_creation_date(i);
l_asset_dist_tbl.delete;
, t_last_update_date
, t_last_updated_by
, t_transaction_subtype
, t_transaction_key
, t_amortization_start_date
, t_calling_interface
, t_dist_id
, t_ccid
, t_loc_id
, t_assign_to
, t_trx_units;
l_trans_rec.who_info.last_update_date := t_creation_date(i);
l_trans_rec.who_info.last_updated_by := t_created_by(i);
SELECT PERIOD_COUNTER_LIFE_COMPLETE,PERIOD_COUNTER_FULLY_RESERVED
INTO t_period_counter_life_complete(i),t_period_counter_fully_rsv(i)
FROM FA_BOOKS
WHERE BOOK_TYPE_CODE = p_book_type_code
AND ASSET_ID = l_asset_hdr_rec.asset_id
AND TRANSACTION_HEADER_ID_OUT is NULL;
fa_debug_pkg.add(l_calling_fn,'Insert into ', 'FA_DEPRN_SUMMARY_MRC_V', p_log_level_rec => p_log_level_rec);
INSERT INTO FA_MC_DEPRN_SUMMARY( SET_OF_BOOKS_ID
, BOOK_TYPE_CODE
, ASSET_ID
, PERIOD_COUNTER
, DEPRN_RUN_DATE
, DEPRN_AMOUNT
, YTD_DEPRN
, DEPRN_RESERVE
, DEPRN_SOURCE_CODE
, ADJUSTED_COST
, BONUS_RATE
, REVAL_AMORTIZATION
, REVAL_DEPRN_EXPENSE
, REVAL_RESERVE
, YTD_REVAL_DEPRN_EXPENSE
, PRODUCTION
, YTD_PRODUCTION
, LTD_PRODUCTION
, REVAL_AMORTIZATION_BASIS
, PRIOR_FY_EXPENSE
, BONUS_DEPRN_AMOUNT
, BONUS_YTD_DEPRN
, BONUS_DEPRN_RESERVE
, BONUS_DEPRN_ADJUSTMENT_AMOUNT
, PRIOR_FY_BONUS_EXPENSE
, DEPRN_OVERRIDE_FLAG
, SYSTEM_DEPRN_AMOUNT
, SYSTEM_BONUS_DEPRN_AMOUNT
, IMPAIRMENT_AMOUNT
, YTD_IMPAIRMENT
, IMPAIRMENT_RESERVE
, CAPITAL_ADJUSTMENT -- Bug 6666666
, GENERAL_FUND -- Bug 6666666
, DEPRN_ADJUSTMENT_AMOUNT
, REVAL_LOSS_BALANCE
) VALUES ( p_set_of_books_id
, p_book_type_code -- BOOK_TYPE_CODE
, t_asset_id(i) -- ASSET_ID
, p_period_rec.period_counter -- PERIOD_COUNTER
, t_creation_date(i) -- DEPRN_RUN_DATE
, t_deprn_amount(i) -- DEPRN_AMOUNT
, t_ytd_deprn(i) -- YTD_DEPRN
, t_deprn_reserve(i) -- DEPRN_RESERVE
, 'DEPRN' -- DEPRN_SOURCE_CODE
, t_adjusted_cost(i) -- ADJUSTED_COST
, t_bonus_rate(i) -- BONUS_RATE
, t_reval_amortization(i) -- REVAL_AMORTIZATION
, t_reval_deprn_expense(i) -- REVAL_DEPRN_EXPENSE
, t_reval_reserve(i) -- REVAL_RESERVE
, t_ytd_reval_deprn_expense(i) -- YTD_REVAL_DEPRN_EXPENSE
, t_production(i) -- PRODUCTION
, t_ytd_production(i) -- YTD_PRODUCTION
, t_ltd_production(i) -- LTD_PRODUCTION
, t_reval_amortization_basis(i) -- REVAL_AMORTIZATION_BASIS
, t_prior_fy_expense(i) -- PRIOR_FY_EXPENSE
, t_bonus_deprn_amount(i) -- BONUS_DEPRN_AMOUNT
, t_bonus_ytd_deprn(i) -- BONUS_YTD_DEPRN
, t_bonus_deprn_reserve(i) -- BONUS_DEPRN_RESERVE
, t_bonus_deprn_adj_amount(i) -- BONUS_DEPRN_ADJUSTMENT_AMOUNT
, t_prior_fy_bonus_expense(i) -- PRIOR_FY_BONUS_EXPENSE
, t_deprn_override_flag(i) -- DEPRN_OVERRIDE_FLAG
, t_system_deprn_amount(i) -- SYSTEM_DEPRN_AMOUNT
, t_system_bonus_deprn_amount(i) -- SYSTEM_BONUS_DEPRN_AMOUNT
, t_impairment_amount(i) -- IMPAIRMENT_AMOUNT
, t_ytd_impairment(i) -- YTD_IMPAIRMENT
, t_impairment_reserve(i) -- impairment_reserve
, t_capital_adjustment(i)
- nvl(t_reval_amortization(i),0)
+ nvl(t_deprn_amount(i),0) -- Capital Adjustment -- Bug 6666666
, t_general_fund(i)
+ nvl(t_deprn_amount(i),0) -- General Fund -- Bug 6666666
, t_deprn_adjustment_amount(i)
, t_reval_loss_balance(i)
);
INSERT INTO FA_MC_DEPRN_SUMMARY( SET_OF_BOOKS_ID
, BOOK_TYPE_CODE
, ASSET_ID
, PERIOD_COUNTER
, DEPRN_RUN_DATE
, DEPRN_AMOUNT
, YTD_DEPRN
, DEPRN_RESERVE
, DEPRN_SOURCE_CODE
, ADJUSTED_COST
, BONUS_RATE
, REVAL_AMORTIZATION
, REVAL_DEPRN_EXPENSE
, REVAL_RESERVE
, YTD_REVAL_DEPRN_EXPENSE
, PRODUCTION
, YTD_PRODUCTION
, LTD_PRODUCTION
, REVAL_AMORTIZATION_BASIS
, PRIOR_FY_EXPENSE
, BONUS_DEPRN_AMOUNT
, BONUS_YTD_DEPRN
, BONUS_DEPRN_RESERVE
, BONUS_DEPRN_ADJUSTMENT_AMOUNT
, PRIOR_FY_BONUS_EXPENSE
, DEPRN_OVERRIDE_FLAG
, SYSTEM_DEPRN_AMOUNT
, SYSTEM_BONUS_DEPRN_AMOUNT
, IMPAIRMENT_AMOUNT
, YTD_IMPAIRMENT
, IMPAIRMENT_RESERVE
, CAPITAL_ADJUSTMENT -- Bug 6666666
, GENERAL_FUND -- Bug 6666666
, DEPRN_ADJUSTMENT_AMOUNT
, REVAL_LOSS_BALANCE
) VALUES ( p_set_of_books_id
, p_book_type_code -- BOOK_TYPE_CODE
, t_asset_id(i) -- ASSET_ID
, p_period_rec.period_counter -- PERIOD_COUNTER
, t_creation_date(i) -- DEPRN_RUN_DATE
, t_deprn_amount(i) -- DEPRN_AMOUNT
, t_ytd_deprn(i) -- YTD_DEPRN
, t_deprn_reserve(i) -- DEPRN_RESERVE
, 'DEPRN' -- DEPRN_SOURCE_CODE
, t_adjusted_cost(i) -- ADJUSTED_COST
, t_bonus_rate(i) -- BONUS_RATE
, t_reval_amortization(i) -- REVAL_AMORTIZATION
, t_reval_deprn_expense(i) -- REVAL_DEPRN_EXPENSE
, t_reval_reserve(i) -- REVAL_RESERVE
, t_ytd_reval_deprn_expense(i) -- YTD_REVAL_DEPRN_EXPENSE
, t_production(i) -- PRODUCTION
, t_ytd_production(i) -- YTD_PRODUCTION
, t_ltd_production(i) -- LTD_PRODUCTION
, t_reval_amortization_basis(i) -- REVAL_AMORTIZATION_BASIS
, t_prior_fy_expense(i) -- PRIOR_FY_EXPENSE
, t_bonus_deprn_amount(i) -- BONUS_DEPRN_AMOUNT
, t_bonus_ytd_deprn(i) -- BONUS_YTD_DEPRN
, t_bonus_deprn_reserve(i) -- BONUS_DEPRN_RESERVE
, t_bonus_deprn_adj_amount(i) -- BONUS_DEPRN_ADJUSTMENT_AMOUNT
, t_prior_fy_bonus_expense(i) -- PRIOR_FY_BONUS_EXPENSE
, t_deprn_override_flag(i) -- DEPRN_OVERRIDE_FLAG
, t_system_deprn_amount(i) -- SYSTEM_DEPRN_AMOUNT
, t_system_bonus_deprn_amount(i) -- SYSTEM_BONUS_DEPRN_AMOUNT
, t_impairment_amount(i) -- IMPAIRMENT_AMOUNT
, t_ytd_impairment(i) -- YTD_IMPAIRMENT
, t_impairment_reserve(i) -- impairment_reserve
, NULL -- Capital Adjustment -- Bug 6666666
, NULL -- General Fund -- Bug 6666666
, t_deprn_adjustment_amount(i)
, t_reval_loss_balance(i)
);
fa_debug_pkg.add(l_calling_fn,'Insert into ', 'FA_DEPRN_SUMMARY', p_log_level_rec => p_log_level_rec);
INSERT INTO FA_DEPRN_SUMMARY( BOOK_TYPE_CODE
, ASSET_ID
, PERIOD_COUNTER
, DEPRN_RUN_DATE
, DEPRN_AMOUNT
, YTD_DEPRN
, DEPRN_RESERVE
, DEPRN_SOURCE_CODE
, ADJUSTED_COST
, BONUS_RATE
, REVAL_AMORTIZATION
, REVAL_DEPRN_EXPENSE
, REVAL_RESERVE
, YTD_REVAL_DEPRN_EXPENSE
, PRODUCTION
, YTD_PRODUCTION
, LTD_PRODUCTION
, REVAL_AMORTIZATION_BASIS
, PRIOR_FY_EXPENSE
, BONUS_DEPRN_AMOUNT
, BONUS_YTD_DEPRN
, BONUS_DEPRN_RESERVE
, BONUS_DEPRN_ADJUSTMENT_AMOUNT
, PRIOR_FY_BONUS_EXPENSE
, DEPRN_OVERRIDE_FLAG
, SYSTEM_DEPRN_AMOUNT
, SYSTEM_BONUS_DEPRN_AMOUNT
, IMPAIRMENT_AMOUNT
, YTD_IMPAIRMENT
, IMPAIRMENT_RESERVE
, CAPITAL_ADJUSTMENT -- Bug 6666666
, GENERAL_FUND -- Bug 6666666
, DEPRN_ADJUSTMENT_AMOUNT
, REVAL_LOSS_BALANCE
) VALUES ( p_book_type_code -- BOOK_TYPE_CODE
, t_asset_id(i) -- ASSET_ID
, p_period_rec.period_counter -- PERIOD_COUNTER
, t_creation_date(i) -- DEPRN_RUN_DATE
, t_deprn_amount(i) -- DEPRN_AMOUNT
, t_ytd_deprn(i) -- YTD_DEPRN
, t_deprn_reserve(i) -- DEPRN_RESERVE
, 'DEPRN' -- DEPRN_SOURCE_CODE
, t_adjusted_cost(i) -- ADJUSTED_COST
, t_bonus_rate(i) -- BONUS_RATE
, t_reval_amortization(i) -- REVAL_AMORTIZATION
, t_reval_deprn_expense(i) -- REVAL_DEPRN_EXPENSE
, t_reval_reserve(i) -- REVAL_RESERVE
, t_ytd_reval_deprn_expense(i) -- YTD_REVAL_DEPRN_EXPENSE
, t_production(i) -- PRODUCTION
, t_ytd_production(i) -- YTD_PRODUCTION
, t_ltd_production(i) -- LTD_PRODUCTION
, t_reval_amortization_basis(i) -- REVAL_AMORTIZATION_BASIS
, t_prior_fy_expense(i) -- PRIOR_FY_EXPENSE
, t_bonus_deprn_amount(i) -- BONUS_DEPRN_AMOUNT
, t_bonus_ytd_deprn(i) -- BONUS_YTD_DEPRN
, t_bonus_deprn_reserve(i) -- BONUS_DEPRN_RESERVE
, t_bonus_deprn_adj_amount(i) -- BONUS_DEPRN_ADJUSTMENT_AMOUNT
, t_prior_fy_bonus_expense(i) -- PRIOR_FY_BONUS_EXPENSE
, t_deprn_override_flag(i) -- DEPRN_OVERRIDE_FLAG
, t_system_deprn_amount(i) -- SYSTEM_DEPRN_AMOUNT
, t_system_bonus_deprn_amount(i) -- SYSTEM_BONUS_DEPRN_AMOUNT
, t_impairment_amount(i) -- IMPAIRMENT_AMOUNT
, t_ytd_impairment(i) -- YTD_IMPAIRMENT
, t_impairment_reserve(i) -- impairment_reserve
, t_capital_adjustment(i)
- nvl(t_reval_amortization(i),0)
+ nvl(t_deprn_amount(i),0) -- Capital Adjustment -- Bug 6666666
, t_general_fund(i)
+ nvl(t_deprn_amount(i),0) -- General Fund -- Bug 6666666
, t_deprn_adjustment_amount(i)
, t_reval_loss_balance(i)
);
INSERT INTO FA_DEPRN_SUMMARY( BOOK_TYPE_CODE
, ASSET_ID
, PERIOD_COUNTER
, DEPRN_RUN_DATE
, DEPRN_AMOUNT
, YTD_DEPRN
, DEPRN_RESERVE
, DEPRN_SOURCE_CODE
, ADJUSTED_COST
, BONUS_RATE
, REVAL_AMORTIZATION
, REVAL_DEPRN_EXPENSE
, REVAL_RESERVE
, YTD_REVAL_DEPRN_EXPENSE
, PRODUCTION
, YTD_PRODUCTION
, LTD_PRODUCTION
, REVAL_AMORTIZATION_BASIS
, PRIOR_FY_EXPENSE
, BONUS_DEPRN_AMOUNT
, BONUS_YTD_DEPRN
, BONUS_DEPRN_RESERVE
, BONUS_DEPRN_ADJUSTMENT_AMOUNT
, PRIOR_FY_BONUS_EXPENSE
, DEPRN_OVERRIDE_FLAG
, SYSTEM_DEPRN_AMOUNT
, SYSTEM_BONUS_DEPRN_AMOUNT
, IMPAIRMENT_AMOUNT
, YTD_IMPAIRMENT
, IMPAIRMENT_RESERVE
, CAPITAL_ADJUSTMENT -- Bug 6666666
, GENERAL_FUND -- Bug 6666666
, DEPRN_ADJUSTMENT_AMOUNT
, REVAL_LOSS_BALANCE
) VALUES ( p_book_type_code -- BOOK_TYPE_CODE
, t_asset_id(i) -- ASSET_ID
, p_period_rec.period_counter -- PERIOD_COUNTER
, t_creation_date(i) -- DEPRN_RUN_DATE
, t_deprn_amount(i) -- DEPRN_AMOUNT
, t_ytd_deprn(i) -- YTD_DEPRN
, t_deprn_reserve(i) -- DEPRN_RESERVE
, 'DEPRN' -- DEPRN_SOURCE_CODE
, t_adjusted_cost(i) -- ADJUSTED_COST
, t_bonus_rate(i) -- BONUS_RATE
, t_reval_amortization(i) -- REVAL_AMORTIZATION
, t_reval_deprn_expense(i) -- REVAL_DEPRN_EXPENSE
, t_reval_reserve(i) -- REVAL_RESERVE
, t_ytd_reval_deprn_expense(i) -- YTD_REVAL_DEPRN_EXPENSE
, t_production(i) -- PRODUCTION
, t_ytd_production(i) -- YTD_PRODUCTION
, t_ltd_production(i) -- LTD_PRODUCTION
, t_reval_amortization_basis(i) -- REVAL_AMORTIZATION_BASIS
, t_prior_fy_expense(i) -- PRIOR_FY_EXPENSE
, t_bonus_deprn_amount(i) -- BONUS_DEPRN_AMOUNT
, t_bonus_ytd_deprn(i) -- BONUS_YTD_DEPRN
, t_bonus_deprn_reserve(i) -- BONUS_DEPRN_RESERVE
, t_bonus_deprn_adj_amount(i) -- BONUS_DEPRN_ADJUSTMENT_AMOUNT
, t_prior_fy_bonus_expense(i) -- PRIOR_FY_BONUS_EXPENSE
, t_deprn_override_flag(i) -- DEPRN_OVERRIDE_FLAG
, t_system_deprn_amount(i) -- SYSTEM_DEPRN_AMOUNT
, t_system_bonus_deprn_amount(i) -- SYSTEM_BONUS_DEPRN_AMOUNT
, t_impairment_amount(i) -- IMPAIRMENT_AMOUNT
, t_ytd_impairment(i) -- YTD_IMPAIRMENT
, t_impairment_reserve(i) -- impairment_reserve
, NULL -- Capital Adjustment -- Bug 6666666
, NULL -- General Fund -- Bug 6666666
, t_deprn_adjustment_amount(i)
, t_reval_loss_balance(i)
);
UPDATE FA_MC_BOOKS
SET DATE_INEFFECTIVE = t_creation_date(i)
, TRANSACTION_HEADER_ID_OUT = t_thid(i)
WHERE ASSET_ID = t_asset_id(i)
AND BOOK_TYPE_CODE = p_book_type_code
AND TRANSACTION_HEADER_ID_OUT is null
AND SET_OF_BOOKS_ID = p_set_of_books_id
RETURNING transaction_header_id_in BULK COLLECT INTO t_old_thid;
UPDATE FA_BOOKS
SET DATE_INEFFECTIVE = t_creation_date(i)
, TRANSACTION_HEADER_ID_OUT = t_thid(i)
WHERE ASSET_ID = t_asset_id(i)
AND BOOK_TYPE_CODE = p_book_type_code
AND TRANSACTION_HEADER_ID_OUT is null
RETURNING transaction_header_id_in BULK COLLECT INTO t_old_thid;
fa_debug_pkg.add(l_calling_fn,'Inserting record into ', 'FA_BOOKS_MRC_V', p_log_level_rec => p_log_level_rec);
INSERT INTO FA_MC_BOOKS( SET_OF_BOOKS_ID
, BOOK_TYPE_CODE
, ASSET_ID
, DATE_PLACED_IN_SERVICE
, DATE_EFFECTIVE
, DEPRN_START_DATE
, DEPRN_METHOD_CODE
, LIFE_IN_MONTHS
, RATE_ADJUSTMENT_FACTOR
, ADJUSTED_COST
, COST
, ORIGINAL_COST
, SALVAGE_VALUE
, PRORATE_CONVENTION_CODE
, PRORATE_DATE
, COST_CHANGE_FLAG
, ADJUSTMENT_REQUIRED_STATUS
, CAPITALIZE_FLAG
, RETIREMENT_PENDING_FLAG
, DEPRECIATE_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, TRANSACTION_HEADER_ID_IN
, ITC_AMOUNT_ID
, ITC_AMOUNT
, RETIREMENT_ID
, TAX_REQUEST_ID
, ITC_BASIS
, BASIC_RATE
, ADJUSTED_RATE
, BONUS_RULE
, CEILING_NAME
, RECOVERABLE_COST
, ADJUSTED_CAPACITY
, FULLY_RSVD_REVALS_COUNTER
, IDLED_FLAG
, PERIOD_COUNTER_CAPITALIZED
, PERIOD_COUNTER_FULLY_RESERVED
, PERIOD_COUNTER_FULLY_RETIRED
, PRODUCTION_CAPACITY
, REVAL_AMORTIZATION_BASIS
, REVAL_CEILING
, UNIT_OF_MEASURE
, UNREVALUED_COST
, ANNUAL_DEPRN_ROUNDING_FLAG
, PERCENT_SALVAGE_VALUE
, ALLOWED_DEPRN_LIMIT
, ALLOWED_DEPRN_LIMIT_AMOUNT
, PERIOD_COUNTER_LIFE_COMPLETE
, ADJUSTED_RECOVERABLE_COST
, ANNUAL_ROUNDING_FLAG
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE_CATEGORY
, EOFY_ADJ_COST
, EOFY_FORMULA_FACTOR
, SHORT_FISCAL_YEAR_FLAG
, CONVERSION_DATE
, ORIGINAL_DEPRN_START_DATE
, REMAINING_LIFE1
, REMAINING_LIFE2
, OLD_ADJUSTED_COST
, FORMULA_FACTOR
, GROUP_ASSET_ID
, SALVAGE_TYPE
, DEPRN_LIMIT_TYPE
, REDUCTION_RATE
, REDUCE_ADDITION_FLAG
, REDUCE_ADJUSTMENT_FLAG
, REDUCE_RETIREMENT_FLAG
, RECOGNIZE_GAIN_LOSS
, RECAPTURE_RESERVE_FLAG
, LIMIT_PROCEEDS_FLAG
, TERMINAL_GAIN_LOSS
, TRACKING_METHOD
, EXCLUDE_FULLY_RSV_FLAG
, EXCESS_ALLOCATION_OPTION
, DEPRECIATION_OPTION
, MEMBER_ROLLUP_FLAG
, ALLOCATE_TO_FULLY_RSV_FLAG
, ALLOCATE_TO_FULLY_RET_FLAG
, TERMINAL_GAIN_LOSS_AMOUNT
, CIP_COST
, YTD_PROCEEDS
, LTD_PROCEEDS
, LTD_COST_OF_REMOVAL
, EOFY_RESERVE
, PRIOR_EOFY_RESERVE
, EOP_ADJ_COST
, EOP_FORMULA_FACTOR
, EXCLUDE_PROCEEDS_FROM_BASIS
, RETIREMENT_DEPRN_OPTION
, TERMINAL_GAIN_LOSS_FLAG
, SUPER_GROUP_ID
, OVER_DEPRECIATE_OPTION
, DISABLED_FLAG
, CASH_GENERATING_UNIT_ID
) SELECT SET_OF_BOOKS_ID
, BOOK_TYPE_CODE
, ASSET_ID
, DATE_PLACED_IN_SERVICE
, t_creation_date(i) -- DATE_EFFECTIVE
, DEPRN_START_DATE
, DEPRN_METHOD_CODE
, LIFE_IN_MONTHS
, t_new_raf(i) --RATE_ADJUSTMENT_FACTOR
, t_new_adj_cost(i) -- ADJUSTED_COST
, COST
, ORIGINAL_COST
, SALVAGE_VALUE
, PRORATE_CONVENTION_CODE
, PRORATE_DATE
, COST_CHANGE_FLAG
, ADJUSTMENT_REQUIRED_STATUS
, CAPITALIZE_FLAG
, RETIREMENT_PENDING_FLAG
, DEPRECIATE_FLAG
, t_creation_date(i) -- LAST_UPDATE_DATE
, t_created_by(i) -- LAST_UPDATED_BY
, t_thid(i) -- TRANSACTION_HEADER_ID_IN
, ITC_AMOUNT_ID
, ITC_AMOUNT
, RETIREMENT_ID
, TAX_REQUEST_ID
, ITC_BASIS
, BASIC_RATE
, ADJUSTED_RATE
, BONUS_RULE
, CEILING_NAME
, RECOVERABLE_COST
, ADJUSTED_CAPACITY
, FULLY_RSVD_REVALS_COUNTER
, IDLED_FLAG
, PERIOD_COUNTER_CAPITALIZED
, t_period_counter_fully_rsv(i) -- phase5 decode(sign(t_new_adj_cost(i) - t_allowed_deprn_limit_amount(i)), 1, null, p_period_rec.period_counter) --PERIOD_COUNTER_FULLY_RESERVED
, PERIOD_COUNTER_FULLY_RETIRED
, PRODUCTION_CAPACITY
, t_reval_reserve(i)
, REVAL_CEILING
, UNIT_OF_MEASURE
, UNREVALUED_COST
, 'ADJ'
, PERCENT_SALVAGE_VALUE
, ALLOWED_DEPRN_LIMIT
, ALLOWED_DEPRN_LIMIT_AMOUNT
, t_period_counter_life_complete(i) -- phase5 decode(sign(t_new_adj_cost(i) - t_allowed_deprn_limit_amount(i)), 1, null, p_period_rec.period_counter) --PERIOD_COUNTER_LIFE_COMPLETE
, ADJUSTED_RECOVERABLE_COST
, ANNUAL_ROUNDING_FLAG
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE_CATEGORY
, EOFY_ADJ_COST
, EOFY_FORMULA_FACTOR
, SHORT_FISCAL_YEAR_FLAG
, CONVERSION_DATE
, ORIGINAL_DEPRN_START_DATE
, REMAINING_LIFE1
, REMAINING_LIFE2
, OLD_ADJUSTED_COST
, t_new_formula_factor(i) --FORMULA_FACTOR
, GROUP_ASSET_ID
, SALVAGE_TYPE
, DEPRN_LIMIT_TYPE
, REDUCTION_RATE
, REDUCE_ADDITION_FLAG
, REDUCE_ADJUSTMENT_FLAG
, REDUCE_RETIREMENT_FLAG
, RECOGNIZE_GAIN_LOSS
, RECAPTURE_RESERVE_FLAG
, LIMIT_PROCEEDS_FLAG
, TERMINAL_GAIN_LOSS
, TRACKING_METHOD
, EXCLUDE_FULLY_RSV_FLAG
, EXCESS_ALLOCATION_OPTION
, DEPRECIATION_OPTION
, MEMBER_ROLLUP_FLAG
, ALLOCATE_TO_FULLY_RSV_FLAG
, ALLOCATE_TO_FULLY_RET_FLAG
, TERMINAL_GAIN_LOSS_AMOUNT
, CIP_COST
, YTD_PROCEEDS
, LTD_PROCEEDS
, LTD_COST_OF_REMOVAL
, t_eofy_reserve(i) --EOFY_RESERVE
, PRIOR_EOFY_RESERVE
, EOP_ADJ_COST
, EOP_FORMULA_FACTOR
, EXCLUDE_PROCEEDS_FROM_BASIS
, RETIREMENT_DEPRN_OPTION
, TERMINAL_GAIN_LOSS_FLAG
, SUPER_GROUP_ID
, OVER_DEPRECIATE_OPTION
, DISABLED_FLAG
, CASH_GENERATING_UNIT_ID
FROM FA_MC_BOOKS
WHERE TRANSACTION_HEADER_ID_IN = t_old_thid(i)
and SET_OF_BOOKS_ID = p_set_of_books_id ;
fa_debug_pkg.add(l_calling_fn,'Inserting record into ', 'FA_BOOKS', p_log_level_rec => p_log_level_rec);
INSERT INTO FA_BOOKS( BOOK_TYPE_CODE
, ASSET_ID
, DATE_PLACED_IN_SERVICE
, DATE_EFFECTIVE
, DEPRN_START_DATE
, DEPRN_METHOD_CODE
, LIFE_IN_MONTHS
, RATE_ADJUSTMENT_FACTOR
, ADJUSTED_COST
, COST
, ORIGINAL_COST
, SALVAGE_VALUE
, PRORATE_CONVENTION_CODE
, PRORATE_DATE
, COST_CHANGE_FLAG
, ADJUSTMENT_REQUIRED_STATUS
, CAPITALIZE_FLAG
, RETIREMENT_PENDING_FLAG
, DEPRECIATE_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, TRANSACTION_HEADER_ID_IN
, ITC_AMOUNT_ID
, ITC_AMOUNT
, RETIREMENT_ID
, TAX_REQUEST_ID
, ITC_BASIS
, BASIC_RATE
, ADJUSTED_RATE
, BONUS_RULE
, CEILING_NAME
, RECOVERABLE_COST
, ADJUSTED_CAPACITY
, FULLY_RSVD_REVALS_COUNTER
, IDLED_FLAG
, PERIOD_COUNTER_CAPITALIZED
, PERIOD_COUNTER_FULLY_RESERVED
, PERIOD_COUNTER_FULLY_RETIRED
, PRODUCTION_CAPACITY
, REVAL_AMORTIZATION_BASIS
, REVAL_CEILING
, UNIT_OF_MEASURE
, UNREVALUED_COST
, ANNUAL_DEPRN_ROUNDING_FLAG
, PERCENT_SALVAGE_VALUE
, ALLOWED_DEPRN_LIMIT
, ALLOWED_DEPRN_LIMIT_AMOUNT
, PERIOD_COUNTER_LIFE_COMPLETE
, ADJUSTED_RECOVERABLE_COST
, ANNUAL_ROUNDING_FLAG
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE_CATEGORY
, EOFY_ADJ_COST
, EOFY_FORMULA_FACTOR
, SHORT_FISCAL_YEAR_FLAG
, CONVERSION_DATE
, ORIGINAL_DEPRN_START_DATE
, REMAINING_LIFE1
, REMAINING_LIFE2
, OLD_ADJUSTED_COST
, FORMULA_FACTOR
, GROUP_ASSET_ID
, SALVAGE_TYPE
, DEPRN_LIMIT_TYPE
, REDUCTION_RATE
, REDUCE_ADDITION_FLAG
, REDUCE_ADJUSTMENT_FLAG
, REDUCE_RETIREMENT_FLAG
, RECOGNIZE_GAIN_LOSS
, RECAPTURE_RESERVE_FLAG
, LIMIT_PROCEEDS_FLAG
, TERMINAL_GAIN_LOSS
, TRACKING_METHOD
, EXCLUDE_FULLY_RSV_FLAG
, EXCESS_ALLOCATION_OPTION
, DEPRECIATION_OPTION
, MEMBER_ROLLUP_FLAG
, ALLOCATE_TO_FULLY_RSV_FLAG
, ALLOCATE_TO_FULLY_RET_FLAG
, TERMINAL_GAIN_LOSS_AMOUNT
, CIP_COST
, YTD_PROCEEDS
, LTD_PROCEEDS
, LTD_COST_OF_REMOVAL
, EOFY_RESERVE
, PRIOR_EOFY_RESERVE
, EOP_ADJ_COST
, EOP_FORMULA_FACTOR
, EXCLUDE_PROCEEDS_FROM_BASIS
, RETIREMENT_DEPRN_OPTION
, TERMINAL_GAIN_LOSS_FLAG
, SUPER_GROUP_ID
, OVER_DEPRECIATE_OPTION
, DISABLED_FLAG
, CASH_GENERATING_UNIT_ID
, RATE_IN_USE
, NBV_AT_SWITCH
, PRIOR_ADJUSTED_RATE
, PRIOR_BASIC_RATE
, PRIOR_LIFE_IN_MONTHS
, PRIOR_DEPRN_METHOD
, PRIOR_DEPRN_LIMIT
, PRIOR_DEPRN_LIMIT_AMOUNT
, PRIOR_DEPRN_LIMIT_TYPE
, EXTENDED_DEPRECIATION_PERIOD
, EXTENDED_DEPRN_FLAG
, PERIOD_COUNTER_FULLY_EXTENDED
) SELECT BOOK_TYPE_CODE
, ASSET_ID
, DATE_PLACED_IN_SERVICE
, t_creation_date(i) -- DATE_EFFECTIVE
, DEPRN_START_DATE
, DEPRN_METHOD_CODE
, LIFE_IN_MONTHS
, t_new_raf(i) --RATE_ADJUSTMENT_FACTOR
, t_new_adj_cost(i) -- ADJUSTED_COST
, COST
, ORIGINAL_COST
, SALVAGE_VALUE
, PRORATE_CONVENTION_CODE
, PRORATE_DATE
, COST_CHANGE_FLAG
, ADJUSTMENT_REQUIRED_STATUS
, CAPITALIZE_FLAG
, RETIREMENT_PENDING_FLAG
, DEPRECIATE_FLAG
, t_creation_date(i) -- LAST_UPDATE_DATE
, t_created_by(i) -- LAST_UPDATED_BY
, t_thid(i) -- TRANSACTION_HEADER_ID_IN
, ITC_AMOUNT_ID
, ITC_AMOUNT
, RETIREMENT_ID
, TAX_REQUEST_ID
, ITC_BASIS
, BASIC_RATE
, ADJUSTED_RATE
, BONUS_RULE
, CEILING_NAME
, RECOVERABLE_COST
, ADJUSTED_CAPACITY
, FULLY_RSVD_REVALS_COUNTER
, IDLED_FLAG
, PERIOD_COUNTER_CAPITALIZED
, t_period_counter_fully_rsv(i) -- phase5 decode(sign(t_new_adj_cost(i)-t_allowed_deprn_limit_amount(i)), 1, null, p_period_rec.period_counter) --PERIOD_COUNTER_FULLY_RESERVED
, PERIOD_COUNTER_FULLY_RETIRED
, PRODUCTION_CAPACITY
, t_reval_reserve(i)
, REVAL_CEILING
, UNIT_OF_MEASURE
, UNREVALUED_COST
, 'ADJ'
, PERCENT_SALVAGE_VALUE
, ALLOWED_DEPRN_LIMIT
, ALLOWED_DEPRN_LIMIT_AMOUNT
, t_period_counter_life_complete(i) -- phase5 decode(sign(t_new_adj_cost(i) - t_allowed_deprn_limit_amount(i)), 1, null, p_period_rec.period_counter) --PERIOD_COUNTER_LIFE_COMPLETE
, ADJUSTED_RECOVERABLE_COST
, ANNUAL_ROUNDING_FLAG
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE_CATEGORY
, EOFY_ADJ_COST
, EOFY_FORMULA_FACTOR
, SHORT_FISCAL_YEAR_FLAG
, CONVERSION_DATE
, ORIGINAL_DEPRN_START_DATE
, REMAINING_LIFE1
, REMAINING_LIFE2
, OLD_ADJUSTED_COST
, t_new_formula_factor(i) --FORMULA_FACTOR
, GROUP_ASSET_ID
, SALVAGE_TYPE
, DEPRN_LIMIT_TYPE
, REDUCTION_RATE
, REDUCE_ADDITION_FLAG
, REDUCE_ADJUSTMENT_FLAG
, REDUCE_RETIREMENT_FLAG
, RECOGNIZE_GAIN_LOSS
, RECAPTURE_RESERVE_FLAG
, LIMIT_PROCEEDS_FLAG
, TERMINAL_GAIN_LOSS
, TRACKING_METHOD
, EXCLUDE_FULLY_RSV_FLAG
, EXCESS_ALLOCATION_OPTION
, DEPRECIATION_OPTION
, MEMBER_ROLLUP_FLAG
, ALLOCATE_TO_FULLY_RSV_FLAG
, ALLOCATE_TO_FULLY_RET_FLAG
, TERMINAL_GAIN_LOSS_AMOUNT
, CIP_COST
, YTD_PROCEEDS
, LTD_PROCEEDS
, LTD_COST_OF_REMOVAL
, t_eofy_reserve(i) --EOFY_RESERVE
, PRIOR_EOFY_RESERVE
, EOP_ADJ_COST
, EOP_FORMULA_FACTOR
, EXCLUDE_PROCEEDS_FROM_BASIS
, RETIREMENT_DEPRN_OPTION
, TERMINAL_GAIN_LOSS_FLAG
, SUPER_GROUP_ID
, OVER_DEPRECIATE_OPTION
, DISABLED_FLAG
, CASH_GENERATING_UNIT_ID
, t_rate_in_use(i)
, t_nbv_at_switch(i) --phase5
, PRIOR_ADJUSTED_RATE
, PRIOR_BASIC_RATE
, PRIOR_LIFE_IN_MONTHS
, PRIOR_DEPRN_METHOD
, PRIOR_DEPRN_LIMIT
, PRIOR_DEPRN_LIMIT_AMOUNT
, PRIOR_DEPRN_LIMIT_TYPE
, EXTENDED_DEPRECIATION_PERIOD
, EXTENDED_DEPRN_FLAG
, t_period_counter_fully_ext(i) --bug 9786860
FROM FA_BOOKS
WHERE TRANSACTION_HEADER_ID_IN = t_old_thid(i);
SELECT cp.start_date
, cp.end_date
, cp.period_name
, cp.period_num
, fy.fiscal_year
, fy.start_date
, fy.end_date
FROM fa_calendar_periods cp,
fa_deprn_periods dp,
fa_fiscal_year fy
WHERE dp.book_type_code = p_asset_hdr_rec.book_type_code
AND dp.period_counter = p_period_rec.period_counter
AND cp.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
AND cp.start_date = dp.calendar_period_close_date + 1
AND fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
AND cp.start_date between fy.start_date and fy.end_date;
l_dpr_in.update_override_status :=
((l_rate_source_rule = fa_std_types.FAD_RSR_FORMULA)
OR (((l_rate_source_rule = fa_std_types.FAD_RSR_CALC)
OR (l_rate_source_rule = fa_std_types.FAD_RSR_TABLE))
AND (l_deprn_basis_rule = fa_std_types.FAD_DBR_COST)));
l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
l_adj.selection_retid := 0;
p_trans_rec.who_info.last_update_date,
p_trans_rec.who_info.last_updated_by,
p_trans_rec.who_info.last_update_login, p_log_level_rec => p_log_level_rec) then
raise cre_err;
p_trans_rec.who_info.last_update_date,
p_trans_rec.who_info.last_updated_by,
p_trans_rec.who_info.last_update_login, p_log_level_rec => p_log_level_rec) then
raise cre_err;