The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT transaction_date_entered,
mass_reference_id
FROM fa_transaction_headers
WHERE transaction_header_id = p_trx_id ;
SELECT asset_category_id
FROM fa_additions_b
WHERE asset_id = p_c_asset_id ;
SELECT *
FROM igi_iac_det_balances
WHERE adjustment_id = p_current_adjustment ;
SELECT units_assigned, transaction_units
FROM fa_distribution_history
WHERE asset_id = p_c_asset_id
AND book_type_code = p_c_book_type_code
AND distribution_id = p_dist_id ;
SELECT *
FROM igi_iac_asset_balances
WHERE asset_id = p_c_asset_id
AND book_type_code = p_c_book_type_code
AND period_counter = p_period_counter ;
SELECT new.distribution_id
FROM fa_distribution_history NEW, fa_distribution_history old
WHERE old.retirement_id = p_c_retirement_id
AND old.location_id = new.location_id
AND old.code_combination_id = new.code_combination_id
AND NVL(old.assigned_to,-99) = NVL(new.assigned_to,-99)
AND old.transaction_header_id_out = new.transaction_header_id_in
AND old.distribution_id = p_old_distribution ;
SELECT units
FROM fa_asset_history
WHERE asset_id = p_c_asset_id
AND transaction_header_id_out IS NULL ;
SELECT period_counter
FROM igi_iac_transaction_headers
WHERE adjustment_id = p_adjustment_id ;
SELECT *
FROM igi_iac_fa_deprn ifd
WHERE ifd.adjustment_id = n_adjust_id
AND ifd.distribution_id = n_dist_id
AND ifd.period_counter = n_prd_cnt;
SELECT *
FROM fa_distribution_history fad
WHERE fad.asset_id = p_asset_id
AND fad.retirement_id = p_retirement_id
AND fad.distribution_id = p_distribution_id;
SELECT *
FROM fa_distribution_history fad
WHERE fad.asset_id = p_asset_id
AND fad.code_combination_id = p_code_combination_id
AND fad.units_assigned = p_transaction_units
AND fad.location_id = p_location_id
AND NVL(fad.assigned_to,-1) = p_assigned_to
AND fad.transaction_header_id_out IS NULL;
SELECT *
FROM igi_iac_transaction_headers
WHERE book_type_code = p_book_type_code
AND asset_id = p_asset_id
AND period_counter >= p_retire_period
AND period_counter <= p_current_period
AND transaction_type_code='REVALUATION'
AND adjustment_status='RUN';
SELECT asset_id,distribution_id,adjustment_type,SUM(DECODE(dr_cr_flag,'CR',1,-1)*Amount) amount,
adjustment_offset_type,report_ccid,code_combination_id,units_assigned
FROM igi_iac_adjustments
WHERE book_type_code = p_book_type_code
AND asset_id = p_asset_id
AND distribution_id = p_distribution_id
AND adjustment_id IN (SELECT adjustment_id
FROM igi_iac_transaction_headers
WHERE book_type_code = p_book_type_code
AND asset_id = p_asset_id
AND period_counter >= p_retire_period
AND period_counter <= p_current_period
AND transaction_type_code ='REVALUATION'
AND adjustment_status ='RUN')
GROUP BY asset_id,distribution_id,adjustment_type,adjustment_offset_type,report_ccid,code_combination_id,units_assigned;
SELECT *
FROM igi_iac_transaction_headers
WHERE book_type_code = p_book_type_code
AND asset_id = p_asset_id
AND period_counter >= p_retire_period
AND period_counter <= p_current_period
AND transaction_type_code='DEPRECIATION'
AND adjustment_status='COMPLETE';
SELECT asset_id,distribution_id,adjustment_type,SUM(DECODE(dr_cr_flag,'CR',1,-1)*Amount) amount,
adjustment_offset_type,report_ccid,code_combination_id,units_assigned
FROM igi_iac_adjustments
WHERE book_type_code = p_book_type_code
AND asset_id = p_asset_id
AND distribution_id = p_distribution_id
AND adjustment_id IN (SELECT adjustment_id
FROM igi_iac_transaction_headers
WHERE book_type_code = p_book_type_code
AND asset_id = p_asset_id
AND period_counter >= p_retire_period
AND period_counter <= p_current_period
AND transaction_type_code ='DEPRECIATION'
AND adjustment_status ='COMPLETE')
GROUP BY asset_id,distribution_id,adjustment_type,adjustment_offset_type,report_ccid,code_combination_id,units_assigned;
SELECT *
FROM igi_iac_det_balances
WHERE book_type_code = p_book_type_code
AND asset_id = p_asset_id
AND distribution_id = p_distribution_id
AND adjustment_id = (SELECT MAX(adjustment_id)
FROM igi_iac_transaction_headers
WHERE asset_id = p_asset_id
AND book_type_code = p_book_type_code
AND period_counter = ( SELECT max(period_counter)
FROM igi_iac_det_balances
WHERE book_type_code = p_book_type_code
AND asset_id = p_asset_id
AND distribution_id = p_distribution_id
AND period_counter < p_period_counter )
AND adjustment_status NOT IN ('PREVIEW','OBSOLETE'));
Select asset_number
From fa_additions
Where asset_id = cp_asset_id;
igi_iac_trans_headers_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_transaction_header_id => g_retire_rec.detail_info.transaction_header_id_in,
X_adjustment_id_out => NULL ,
X_transaction_type_code => g_ret_type_long,
X_transaction_date_entered => g_fa_trx.transaction_date_entered,
X_mass_refrence_id => g_fa_trx.mass_reference_id ,
X_transaction_sub_type => SUBSTR(g_retirement_type,1,1),
X_book_type_code => P_Book_Type_Code,
X_asset_id => p_asset_id ,
X_category_id => g_asset_category_id,
X_adj_deprn_start_date => NULL,
X_revaluation_type_flag => NULL,
X_adjustment_status => 'COMPLETE' ,
X_period_counter => P_Current_period,
X_mode =>'R',
X_event_id => P_Event_Id) ;
debug( g_state_level, l_path_name,'inserted trans_headers record');
igi_iac_trans_headers_pkg.update_row(l_adjustment_id_out,
l_retirement_adjustment_id,
'R') ;
debug( g_state_level,l_path_name,'updated old trans_headers record');
igi_iac_adjustments_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_book_type_code => P_Book_Type_Code ,
X_code_combination_id => l_nbv_retired_account_ccid,
X_set_of_books_id => g_sob_id ,
X_dr_cr_flag => 'DR' ,
X_amount => l_detail_balances_retire.adjustment_cost-l_detail_balances_retire.deprn_reserve,
X_adjustment_type => 'NBV RETIRED',
X_transfer_to_gl_flag => 'Y' ,
X_units_assigned => l_units_per_dist.units_assigned ,
X_asset_id => P_Asset_Id ,
X_distribution_id => l_detail_balances.distribution_id ,
X_period_counter => g_prd_rec.period_counter,
X_adjustment_offset_type => NULL,
X_report_ccid => NULL,
X_mode => 'R',
X_event_id => P_Event_Id ) ;
igi_iac_adjustments_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_book_type_code => P_Book_Type_Code ,
X_code_combination_id => l_nbv_retired_account_ccid,
X_set_of_books_id => g_sob_id ,
X_dr_cr_flag => 'CR' ,
X_amount => l_detail_balances_retire.deprn_reserve_backlog,
X_adjustment_type => 'NBV RETIRED',
X_transfer_to_gl_flag => 'Y' ,
X_units_assigned => l_units_per_dist.units_assigned ,
X_asset_id => P_Asset_Id ,
X_distribution_id => l_detail_balances.distribution_id ,
X_period_counter => g_prd_rec.period_counter,
X_adjustment_offset_type => NULL,
X_report_ccid => NULL,
X_mode => 'R',
X_event_id => P_Event_Id ) ;
debug( g_state_level,l_path_name, 'done 2nd nbv ret insert');
igi_iac_adjustments_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_book_type_code => P_Book_Type_Code ,
X_code_combination_id => l_reval_rsv_ret_acct_ccid,
X_set_of_books_id => g_sob_id ,
X_dr_cr_flag => 'CR' ,
X_amount => l_detail_balances_retire.reval_reserve_net,
X_adjustment_type => 'REVAL RSV RET',
X_transfer_to_gl_flag => 'Y' ,
X_units_assigned => l_units_per_dist.units_assigned ,
X_asset_id => P_Asset_Id ,
X_distribution_id => l_detail_balances.distribution_id ,
X_period_counter => g_prd_rec.period_counter,
X_adjustment_offset_type => NULL,
X_report_ccid => NULL,
X_mode => 'R',
X_event_id => P_Event_Id ) ;
igi_iac_adjustments_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_book_type_code => P_Book_Type_Code ,
X_code_combination_id => l_cost_account_ccid,
X_set_of_books_id => g_sob_id ,
X_dr_cr_flag => 'CR' ,
X_amount => l_detail_balances_retire.adjustment_cost,
X_adjustment_type => 'COST',
X_transfer_to_gl_flag => 'Y' ,
X_units_assigned => l_units_per_dist.units_assigned ,
X_asset_id => P_Asset_Id ,
X_distribution_id => l_detail_balances.distribution_id ,
X_period_counter => g_prd_rec.period_counter,
X_adjustment_offset_type => NULL,
X_report_ccid => NULL,
X_mode => 'R',
X_event_id => P_Event_Id ) ;
igi_iac_adjustments_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_book_type_code => P_Book_Type_Code ,
X_code_combination_id => l_acc_deprn_account_ccid,
X_set_of_books_id => g_sob_id ,
X_dr_cr_flag => 'DR' ,
X_amount => l_detail_balances_retire.deprn_reserve,
X_adjustment_type => 'RESERVE',
X_transfer_to_gl_flag => 'Y' ,
X_units_assigned => l_units_per_dist.units_assigned ,
X_asset_id => P_Asset_Id ,
X_distribution_id => l_detail_balances.distribution_id ,
X_period_counter => g_prd_rec.period_counter,
X_adjustment_offset_type => NULL,
X_report_ccid => NULL,
X_mode => 'R',
X_event_id => P_Event_Id ) ;
igi_iac_adjustments_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_book_type_code => P_Book_Type_Code ,
X_code_combination_id => l_backlog_account_ccid,
X_set_of_books_id => g_sob_id ,
X_dr_cr_flag => 'DR' ,
X_amount => l_detail_balances_retire.operating_acct_backlog,
X_adjustment_type => 'BL RESERVE',
X_transfer_to_gl_flag => 'Y' ,
X_units_assigned => l_units_per_dist.units_assigned ,
X_asset_id => P_Asset_Id ,
X_distribution_id => l_detail_balances.distribution_id ,
X_period_counter => g_prd_rec.period_counter,
X_adjustment_offset_type => 'OP EXPENSE',
X_report_ccid => l_op_exp_ccid,
X_mode => 'R',
X_event_id => P_Event_Id ) ;
igi_iac_adjustments_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_book_type_code => P_Book_Type_Code ,
X_code_combination_id => l_backlog_account_ccid,
X_set_of_books_id => g_sob_id ,
X_dr_cr_flag => 'DR' ,
X_amount => l_detail_balances_retire.reval_reserve_backlog,
X_adjustment_type => 'BL RESERVE',
X_transfer_to_gl_flag => 'Y' ,
X_units_assigned => l_units_per_dist.units_assigned ,
X_asset_id => P_Asset_Id ,
X_distribution_id => l_detail_balances.distribution_id ,
X_period_counter => g_prd_rec.period_counter,
X_adjustment_offset_type => 'REVAL RESERVE',
X_report_ccid => l_reval_rsv_account_ccid,
X_mode => 'R',
X_event_id => P_Event_Id ) ;
igi_iac_adjustments_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_book_type_code => P_Book_Type_Code ,
X_code_combination_id => l_reval_rsv_account_ccid,
X_set_of_books_id => g_sob_id ,
X_dr_cr_flag => 'DR' ,
X_amount => l_detail_balances_retire.reval_reserve_net,
X_adjustment_type => 'REVAL RESERVE',
X_transfer_to_gl_flag => 'Y' ,
X_units_assigned => l_units_per_dist.units_assigned ,
X_asset_id => P_Asset_Id ,
X_distribution_id => l_detail_balances.distribution_id ,
X_period_counter => g_prd_rec.period_counter,
X_adjustment_offset_type => NULL,
X_report_ccid => NULL,
X_mode => 'R',
X_event_id => P_Event_Id ) ;
/* Insert new detail balance record for this distribution */
IF (g_is_first_period) THEN
l_db_op_acct_ytd := 0;
debug( g_state_level,l_path_name,'start insert det bal');
igi_iac_det_balances_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_asset_id => P_Asset_Id ,
X_distribution_id => l_detail_balances.distribution_id ,
X_book_type_code => P_Book_Type_Code ,
X_period_counter => g_prd_rec.period_counter,
X_adjustment_cost => l_detail_balances_new.adjustment_cost ,
X_net_book_value => l_detail_balances_new.net_book_value,
X_reval_reserve_cost => l_detail_balances_new.reval_reserve_cost,
X_reval_reserve_backlog => l_detail_balances_new.reval_reserve_backlog,
X_reval_reserve_gen_fund => l_detail_balances_new.reval_reserve_gen_fund,
X_reval_reserve_net => l_detail_balances_new.reval_reserve_net,
X_operating_acct_cost => l_detail_balances_new.operating_acct_cost,
X_operating_acct_backlog => l_detail_balances_new.operating_acct_backlog,
X_operating_acct_net => l_detail_balances_new.operating_acct_net,
X_operating_acct_ytd => l_detail_balances.operating_acct_ytd,
X_deprn_period => l_detail_balances_new.deprn_period,
X_deprn_ytd => l_detail_balances_new.deprn_ytd,
X_deprn_reserve => l_detail_balances_new.deprn_reserve,
X_deprn_reserve_backlog => l_detail_balances_new.deprn_reserve_backlog,
X_general_fund_per => l_detail_balances_new.general_fund_per,
X_general_fund_acc => l_detail_balances_new.general_fund_acc,
X_last_reval_date => l_detail_balances.last_reval_date ,
X_current_reval_factor => l_detail_balances.current_reval_factor ,
X_cumulative_reval_factor => l_detail_balances.cumulative_reval_factor ,
X_active_flag => l_detail_balances.active_flag,
X_mode => 'R') ;
debug( g_state_level,l_path_name,'end insert det bals');
IGI_IAC_FA_DEPRN_PKG.Insert_Row(
x_rowid => g_rowid,
x_book_type_code => p_book_type_code,
x_asset_id => p_asset_id,
x_period_counter => g_prd_rec.period_counter,
x_adjustment_id => l_retirement_adjustment_id,
x_distribution_id => l_fa_deprn.distribution_id,
x_deprn_period => l_fa_total_new_deprn_prd,
x_deprn_ytd => l_fa_total_new_deprn_ytd,
x_deprn_reserve => l_fa_total_new_acc_deprn,
x_active_flag => NULL,
x_mode => 'R'
);
debug( g_state_level,l_path_name,'YTD record insert');
igi_iac_det_balances_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_asset_id => P_Asset_Id,
X_distribution_id => l_detail_balances.distribution_id ,
X_book_type_code => P_Book_Type_Code ,
X_period_counter => g_prd_rec.period_counter,
X_adjustment_cost => l_detail_balances.adjustment_cost ,
X_net_book_value => l_detail_balances.net_book_value,
X_reval_reserve_cost => l_detail_balances.reval_reserve_cost,
X_reval_reserve_backlog => l_detail_balances.reval_reserve_backlog,
X_reval_reserve_gen_fund => l_detail_balances.reval_reserve_gen_fund,
X_reval_reserve_net => l_detail_balances.reval_reserve_net,
X_operating_acct_cost => l_detail_balances.operating_acct_cost,
X_operating_acct_backlog => l_detail_balances.operating_acct_backlog,
X_operating_acct_net => l_detail_balances.operating_acct_net,
X_operating_acct_ytd => l_detail_balances.operating_acct_ytd,
X_deprn_period => l_detail_balances.deprn_period,
X_deprn_ytd => l_detail_balances.deprn_ytd,
X_deprn_reserve => l_detail_balances.deprn_reserve,
X_deprn_reserve_backlog => l_detail_balances.deprn_reserve_backlog,
X_general_fund_per => l_detail_balances.general_fund_per,
X_general_fund_acc => l_detail_balances.general_fund_acc,
X_last_reval_date => l_detail_balances.last_reval_date ,
X_current_reval_factor => l_detail_balances.current_reval_factor ,
X_cumulative_reval_factor => l_detail_balances.cumulative_reval_factor ,
X_active_flag => l_detail_balances.active_flag ,
X_mode => 'R') ;
IGI_IAC_FA_DEPRN_PKG.Insert_Row(
x_rowid => g_rowid,
x_book_type_code => p_book_type_code,
x_asset_id => p_asset_id,
x_period_counter => g_prd_rec.period_counter,
x_adjustment_id => l_retirement_adjustment_id,
x_distribution_id => l_fa_deprn.distribution_id,
x_deprn_period => l_fa_deprn.deprn_period,
x_deprn_ytd => l_fa_deprn_ytd,
x_deprn_reserve => l_fa_deprn.deprn_reserve,
x_active_flag => l_fa_deprn.active_flag,
x_mode => 'R'
);
SELECT max(period_counter)
INTO l_max_period_counter
FROM igi_iac_asset_balances
WHERE asset_id = P_Asset_Id
AND book_type_code = P_Book_Type_Code;
igi_iac_asset_balances_pkg.insert_row(
X_rowid => l_rowid ,
X_asset_id => p_asset_id,
X_book_type_code => p_book_type_code ,
X_period_counter => g_prd_rec.period_counter ,
X_net_book_value => l_asset_balances.net_book_value ,
X_adjusted_cost => l_asset_balances.adjusted_cost ,
X_operating_acct => l_asset_balances.operating_acct ,
X_reval_reserve => l_asset_balances.reval_reserve ,
X_deprn_amount => l_asset_balances.deprn_amount,
X_deprn_reserve => l_asset_balances.deprn_reserve ,
X_backlog_deprn_reserve => l_asset_balances.backlog_deprn_reserve ,
X_general_fund => l_asset_balances.general_fund ,
X_last_reval_date => l_asset_balances_rec.last_reval_date ,
X_current_reval_factor => l_asset_balances_rec.current_reval_factor,
X_cumulative_reval_factor => l_asset_balances_rec.cumulative_reval_factor,
X_mode => 'R') ;
igi_iac_asset_balances_pkg.update_row(
X_asset_id => p_asset_id,
X_book_type_code => p_book_type_code ,
X_period_counter => g_prd_rec.period_counter ,
X_net_book_value => l_asset_balances.net_book_value ,
X_adjusted_cost => l_asset_balances.adjusted_cost ,
X_operating_acct => l_asset_balances.operating_acct ,
X_reval_reserve => l_asset_balances.reval_reserve ,
X_deprn_amount => l_asset_balances.deprn_amount,
X_deprn_reserve => l_asset_balances.deprn_reserve ,
X_backlog_deprn_reserve => l_asset_balances.backlog_deprn_reserve ,
X_general_fund => l_asset_balances.general_fund ,
X_last_reval_date => l_asset_balances_rec.last_reval_date ,
X_current_reval_factor => l_asset_balances_rec.current_reval_factor,
X_cumulative_reval_factor => l_asset_balances_rec.cumulative_reval_factor,
X_mode => 'R') ;
igi_iac_trans_headers_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_transaction_header_id => g_retire_rec.detail_info.transaction_header_id_in,
X_adjustment_id_out => NULL ,
X_transaction_type_code => 'REVALUATION',
X_transaction_date_entered => g_fa_trx.transaction_date_entered,
X_mass_refrence_id => g_fa_trx.mass_reference_id ,
X_transaction_sub_type => 'RETIREMENT',
X_book_type_code => P_Book_Type_Code,
X_asset_id => p_asset_id ,
X_category_id => g_asset_category_id,
X_adj_deprn_start_date => NULL,
X_revaluation_type_flag => NULL,
X_adjustment_status => 'COMPLETE' ,
X_period_counter => P_Current_period,
X_mode =>'R',
X_event_id => P_Event_Id) ;
debug( g_state_level, l_path_name,'inserted trans_headers record');
igi_iac_trans_headers_pkg.update_row(l_adjustment_id_out,
l_retirement_adjustment_id,
'R') ;
debug( g_state_level,l_path_name,'updated old trans_headers record');
igi_iac_adjustments_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_book_type_code => P_Book_Type_Code ,
X_code_combination_id => l_all_occ_reval.code_combination_id,
X_set_of_books_id => g_sob_id ,
X_dr_cr_flag => 'DR',
X_amount => l_retire_amount,
X_adjustment_type => l_all_occ_reval.adjustment_type,
X_transfer_to_gl_flag => 'Y',
X_units_assigned => l_all_occ_reval.units_assigned ,
X_asset_id => p_Asset_Id ,
X_distribution_id => l_detail_balances.distribution_id ,
X_period_counter => g_prd_rec.period_counter,
X_adjustment_offset_type =>l_all_occ_reval.adjustment_offset_type,
X_report_ccid => l_all_occ_reval.report_ccid,
X_mode => 'R',
X_event_id => P_Event_Id) ;
igi_iac_det_balances_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_asset_id => P_Asset_Id ,
X_distribution_id => l_detail_balances.distribution_id ,
X_book_type_code => P_Book_Type_Code ,
X_period_counter => g_prd_rec.period_counter,
X_adjustment_cost => l_detail_balances.adjustment_cost ,
X_net_book_value => l_detail_balances.net_book_value,
X_reval_reserve_cost => l_detail_balances.reval_reserve_cost,
X_reval_reserve_backlog => l_detail_balances.reval_reserve_backlog,
X_reval_reserve_gen_fund => l_detail_balances.reval_reserve_gen_fund,
X_reval_reserve_net => l_detail_balances.reval_reserve_net,
X_operating_acct_cost => l_detail_balances.operating_acct_cost,
X_operating_acct_backlog => l_detail_balances.operating_acct_backlog,
X_operating_acct_net => l_detail_balances.operating_acct_net,
X_operating_acct_ytd => l_detail_balances.operating_acct_ytd,
X_deprn_period => l_detail_balances.deprn_period,
X_deprn_ytd => l_detail_balances.deprn_ytd,
X_deprn_reserve => l_detail_balances.deprn_reserve,
X_deprn_reserve_backlog => l_detail_balances.deprn_reserve_backlog,
X_general_fund_per => l_detail_balances.general_fund_per,
X_general_fund_acc => l_detail_balances.general_fund_acc,
X_last_reval_date => l_detail_balances.last_reval_date ,
X_current_reval_factor => l_detail_balances.current_reval_factor ,
X_cumulative_reval_factor => l_detail_balances.cumulative_reval_factor ,
X_active_flag => l_detail_balances.active_flag,
X_mode => 'R') ;
debug( g_state_level,l_path_name,'end insert det bals');
IGI_IAC_FA_DEPRN_PKG.Insert_Row(
x_rowid => l_rowid,
x_book_type_code => p_book_type_code,
x_asset_id => p_asset_id,
x_period_counter => g_prd_rec.period_counter,
x_adjustment_id => l_retirement_adjustment_id,
x_distribution_id => l_fa_deprn.distribution_id,
x_deprn_period => l_fa_deprn.deprn_period,
x_deprn_ytd => l_fa_deprn.deprn_ytd,
x_deprn_reserve => l_fa_deprn.deprn_reserve,
x_active_flag => NULL,
x_mode => 'R');
igi_iac_det_balances_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_asset_id => P_Asset_Id,
X_distribution_id => l_detail_balances.distribution_id ,
X_book_type_code => P_Book_Type_Code ,
X_period_counter => g_prd_rec.period_counter,
X_adjustment_cost => l_detail_balances.adjustment_cost ,
X_net_book_value => l_detail_balances.net_book_value,
X_reval_reserve_cost => l_detail_balances.reval_reserve_cost,
X_reval_reserve_backlog => l_detail_balances.reval_reserve_backlog,
X_reval_reserve_gen_fund => l_detail_balances.reval_reserve_gen_fund,
X_reval_reserve_net => l_detail_balances.reval_reserve_net,
X_operating_acct_cost => l_detail_balances.operating_acct_cost,
X_operating_acct_backlog => l_detail_balances.operating_acct_backlog,
X_operating_acct_net => l_detail_balances.operating_acct_net,
X_operating_acct_ytd => l_detail_balances.operating_acct_ytd,
X_deprn_period => l_detail_balances.deprn_period,
X_deprn_ytd => l_detail_balances.deprn_ytd,
X_deprn_reserve => l_detail_balances.deprn_reserve,
X_deprn_reserve_backlog => l_detail_balances.deprn_reserve_backlog,
X_general_fund_per => l_detail_balances.general_fund_per,
X_general_fund_acc => l_detail_balances.general_fund_acc,
X_last_reval_date => l_detail_balances.last_reval_date ,
X_current_reval_factor => l_detail_balances.current_reval_factor ,
X_cumulative_reval_factor => l_detail_balances.cumulative_reval_factor ,
X_active_flag => l_detail_balances.active_flag ,
X_mode => 'R') ;
IGI_IAC_FA_DEPRN_PKG.Insert_Row(
x_rowid => g_rowid,
x_book_type_code => p_book_type_code,
x_asset_id => p_asset_id,
x_period_counter => g_prd_rec.period_counter,
x_adjustment_id => l_retirement_adjustment_id,
x_distribution_id => l_fa_deprn.distribution_id,
x_deprn_period => l_fa_deprn.deprn_period,
x_deprn_ytd => l_fa_deprn.deprn_ytd,
x_deprn_reserve => l_fa_deprn.deprn_reserve,
x_active_flag => NULL,
x_mode => 'R'
);
igi_iac_trans_headers_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_transaction_header_id => g_retire_rec.detail_info.transaction_header_id_in,
X_adjustment_id_out => NULL ,
X_transaction_type_code => 'DEPRECIATION',
X_transaction_date_entered => g_fa_trx.transaction_date_entered,
X_mass_refrence_id => g_fa_trx.mass_reference_id ,
X_transaction_sub_type => 'RETIREMENT',
X_book_type_code => P_Book_Type_Code,
X_asset_id => p_asset_id ,
X_category_id => g_asset_category_id,
X_adj_deprn_start_date => NULL,
X_revaluation_type_flag => NULL,
X_adjustment_status => 'COMPLETE' ,
X_period_counter => P_Current_period,
X_mode =>'R',
X_event_id => P_Event_Id) ;
debug( g_state_level, l_path_name,'inserted trans_headers record');
igi_iac_trans_headers_pkg.update_row(l_adjustment_id_out,
l_retirement_adjustment_id,
'R') ;
debug( g_state_level,l_path_name,'updated old trans_headers record');
igi_iac_adjustments_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_book_type_code => P_Book_Type_Code ,
X_code_combination_id => l_all_prd_reval.code_combination_id,
X_set_of_books_id => g_sob_id ,
X_dr_cr_flag => 'DR',
X_amount => l_retire_amount,
X_adjustment_type => l_all_prd_reval.adjustment_type,
X_transfer_to_gl_flag => 'Y',
X_units_assigned => l_all_prd_reval.units_assigned ,
X_asset_id => p_Asset_Id ,
X_distribution_id => l_detail_balances.distribution_id ,
X_period_counter => g_prd_rec.period_counter,
X_adjustment_offset_type =>l_all_prd_reval.adjustment_offset_type,
X_report_ccid => l_all_prd_reval.report_ccid,
X_mode => 'R',
X_event_id => P_Event_Id ) ;
igi_iac_det_balances_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_asset_id => P_Asset_Id ,
X_distribution_id => l_detail_balances.distribution_id ,
X_book_type_code => P_Book_Type_Code ,
X_period_counter => g_prd_rec.period_counter,
X_adjustment_cost => l_detail_balances.adjustment_cost ,
X_net_book_value => l_detail_balances.net_book_value,
X_reval_reserve_cost => l_detail_balances.reval_reserve_cost,
X_reval_reserve_backlog => l_detail_balances.reval_reserve_backlog,
X_reval_reserve_gen_fund => l_detail_balances.reval_reserve_gen_fund,
X_reval_reserve_net => l_detail_balances.reval_reserve_net,
X_operating_acct_cost => l_detail_balances.operating_acct_cost,
X_operating_acct_backlog => l_detail_balances.operating_acct_backlog,
X_operating_acct_net => l_detail_balances.operating_acct_net,
X_operating_acct_ytd => l_detail_balances.operating_acct_ytd,
X_deprn_period => l_detail_balances.deprn_period,
X_deprn_ytd => l_detail_balances.deprn_ytd,
X_deprn_reserve => l_detail_balances.deprn_reserve,
X_deprn_reserve_backlog => l_detail_balances.deprn_reserve_backlog,
X_general_fund_per => l_detail_balances.general_fund_per,
X_general_fund_acc => l_detail_balances.general_fund_acc,
X_last_reval_date => l_detail_balances.last_reval_date ,
X_current_reval_factor => l_detail_balances.current_reval_factor ,
X_cumulative_reval_factor => l_detail_balances.cumulative_reval_factor ,
X_active_flag => l_detail_balances.active_flag,
X_mode => 'R') ;
debug( g_state_level,l_path_name,'end insert det bals');
IGI_IAC_FA_DEPRN_PKG.Insert_Row(
x_rowid => l_rowid,
x_book_type_code => p_book_type_code,
x_asset_id => p_asset_id,
x_period_counter => g_prd_rec.period_counter,
x_adjustment_id => l_retirement_adjustment_id,
x_distribution_id => l_fa_deprn.distribution_id,
x_deprn_period => l_fa_deprn.deprn_period,
x_deprn_ytd => l_fa_deprn.deprn_ytd,
x_deprn_reserve => l_fa_deprn.deprn_reserve,
x_active_flag => NULL,
x_mode => 'R'
);
igi_iac_det_balances_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_asset_id => P_Asset_Id,
X_distribution_id => l_detail_balances.distribution_id ,
X_book_type_code => P_Book_Type_Code ,
X_period_counter => g_prd_rec.period_counter,
X_adjustment_cost => l_detail_balances.adjustment_cost ,
X_net_book_value => l_detail_balances.net_book_value,
X_reval_reserve_cost => l_detail_balances.reval_reserve_cost,
X_reval_reserve_backlog => l_detail_balances.reval_reserve_backlog,
X_reval_reserve_gen_fund => l_detail_balances.reval_reserve_gen_fund,
X_reval_reserve_net => l_detail_balances.reval_reserve_net,
X_operating_acct_cost => l_detail_balances.operating_acct_cost,
X_operating_acct_backlog => l_detail_balances.operating_acct_backlog,
X_operating_acct_net => l_detail_balances.operating_acct_net,
X_operating_acct_ytd => l_detail_balances.operating_acct_ytd,
X_deprn_period => l_detail_balances.deprn_period,
X_deprn_ytd => l_detail_balances.deprn_ytd,
X_deprn_reserve => l_detail_balances.deprn_reserve,
X_deprn_reserve_backlog => l_detail_balances.deprn_reserve_backlog,
X_general_fund_per => l_detail_balances.general_fund_per,
X_general_fund_acc => l_detail_balances.general_fund_acc,
X_last_reval_date => l_detail_balances.last_reval_date ,
X_current_reval_factor => l_detail_balances.current_reval_factor ,
X_cumulative_reval_factor => l_detail_balances.cumulative_reval_factor ,
X_active_flag => l_detail_balances.active_flag ,
X_mode => 'R') ;
IGI_IAC_FA_DEPRN_PKG.Insert_Row(
x_rowid => g_rowid,
x_book_type_code => p_book_type_code,
x_asset_id => p_asset_id,
x_period_counter => g_prd_rec.period_counter,
x_adjustment_id => l_retirement_adjustment_id,
x_distribution_id => l_fa_deprn.distribution_id,
x_deprn_period => l_fa_deprn.deprn_period,
x_deprn_ytd => l_fa_deprn.deprn_ytd,
x_deprn_reserve => l_fa_deprn.deprn_reserve,
x_active_flag => NULL,
x_mode => 'R'
);
igi_iac_trans_headers_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_transaction_header_id => g_retire_rec.detail_info.transaction_header_id_in,
X_adjustment_id_out => NULL ,
X_transaction_type_code => g_ret_type_long,
X_transaction_date_entered => g_fa_trx.transaction_date_entered,
X_mass_refrence_id => g_fa_trx.mass_reference_id ,
X_transaction_sub_type => SUBSTR(g_retirement_type,1,1),
X_book_type_code => P_Book_Type_Code,
X_asset_id => p_asset_id ,
X_category_id => g_asset_category_id,
X_adj_deprn_start_date => NULL,
X_revaluation_type_flag => NULL,
X_adjustment_status => 'COMPLETE' ,
X_period_counter => P_Current_period,
X_mode =>'R',
X_event_id => P_Event_Id) ;
debug( g_state_level, l_path_name,'inserted trans_headers record');
igi_iac_trans_headers_pkg.update_row(l_adjustment_id_out,
l_retirement_adjustment_id,
'R') ;
debug( g_state_level,l_path_name,'updated old trans_headers record');
igi_iac_adjustments_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_book_type_code => P_Book_Type_Code ,
X_code_combination_id => l_nbv_retired_account_ccid,
X_set_of_books_id => g_sob_id ,
X_dr_cr_flag => 'DR' ,
X_amount => l_detail_balances.adjustment_cost-l_detail_balances.deprn_reserve,
X_adjustment_type => 'NBV RETIRED',
X_transfer_to_gl_flag => 'Y' ,
X_units_assigned => l_units_per_dist.units_assigned ,
X_asset_id => P_Asset_Id ,
X_distribution_id => l_detail_balances.distribution_id ,
X_period_counter => g_prd_rec.period_counter,
X_adjustment_offset_type => NULL,
X_report_ccid => NULL,
X_mode => 'R',
X_event_id => P_Event_Id ) ;
debug( g_state_level,l_path_name,'done nbv ret insert');
igi_iac_adjustments_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_book_type_code => P_Book_Type_Code ,
X_code_combination_id => l_nbv_retired_account_ccid,
X_set_of_books_id => g_sob_id ,
X_dr_cr_flag => 'CR' ,
X_amount => l_detail_balances.deprn_reserve_backlog,
X_adjustment_type => 'NBV RETIRED',
X_transfer_to_gl_flag => 'Y' ,
X_units_assigned => l_units_per_dist.units_assigned ,
X_asset_id => P_Asset_Id ,
X_distribution_id => l_detail_balances.distribution_id ,
X_period_counter => g_prd_rec.period_counter,
X_adjustment_offset_type => NULL,
X_report_ccid => NULL,
X_mode => 'R',
X_event_id => P_Event_Id ) ;
debug( g_state_level,l_path_name, 'done 2nd nbv ret insert');
igi_iac_adjustments_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_book_type_code => P_Book_Type_Code ,
X_code_combination_id => l_reval_rsv_ret_acct_ccid,
X_set_of_books_id => g_sob_id ,
X_dr_cr_flag => 'CR' ,
X_amount => l_detail_balances.reval_reserve_net,
X_adjustment_type => 'REVAL RSV RET',
X_transfer_to_gl_flag => 'Y' ,
X_units_assigned => l_units_per_dist.units_assigned ,
X_asset_id => P_Asset_Id ,
X_distribution_id => l_detail_balances.distribution_id ,
X_period_counter => g_prd_rec.period_counter,
X_adjustment_offset_type => NULL,
X_report_ccid => NULL,
X_mode => 'R',
X_event_id => P_Event_Id ) ;
debug( g_state_level,l_path_name,'done reval rsv ret insert');
igi_iac_adjustments_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_book_type_code => P_Book_Type_Code ,
X_code_combination_id => l_cost_account_ccid,
X_set_of_books_id => g_sob_id ,
X_dr_cr_flag => 'CR' ,
X_amount => l_detail_balances.adjustment_cost,
X_adjustment_type => 'COST',
X_transfer_to_gl_flag => 'Y' ,
X_units_assigned => l_units_per_dist.units_assigned ,
X_asset_id => P_Asset_Id ,
X_distribution_id => l_detail_balances.distribution_id ,
X_period_counter => g_prd_rec.period_counter,
X_adjustment_offset_type => NULL,
X_report_ccid => NULL,
X_mode => 'R',
X_event_id => P_Event_Id ) ;
igi_iac_adjustments_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_book_type_code => P_Book_Type_Code ,
X_code_combination_id => l_acc_deprn_account_ccid,
X_set_of_books_id => g_sob_id ,
X_dr_cr_flag => 'DR' ,
X_amount => l_detail_balances.deprn_reserve,
X_adjustment_type => 'RESERVE',
X_transfer_to_gl_flag => 'Y' ,
X_units_assigned => l_units_per_dist.units_assigned ,
X_asset_id => P_Asset_Id ,
X_distribution_id => l_detail_balances.distribution_id ,
X_period_counter => g_prd_rec.period_counter,
X_adjustment_offset_type => NULL,
X_report_ccid => NULL,
X_mode => 'R',
X_event_id => P_Event_Id ) ;
igi_iac_adjustments_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_book_type_code => P_Book_Type_Code ,
X_code_combination_id => l_backlog_account_ccid,
X_set_of_books_id => g_sob_id ,
X_dr_cr_flag => 'DR' ,
X_amount => l_detail_balances.operating_acct_backlog,
X_adjustment_type => 'BL RESERVE',
X_transfer_to_gl_flag => 'Y' ,
X_units_assigned => l_units_per_dist.units_assigned ,
X_asset_id => P_Asset_Id ,
X_distribution_id => l_detail_balances.distribution_id ,
X_period_counter => g_prd_rec.period_counter,
X_adjustment_offset_type => 'OP EXPENSE',
X_report_ccid => l_op_exp_ccid,
X_mode => 'R',
X_event_id => P_Event_Id ) ;
igi_iac_adjustments_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_book_type_code => P_Book_Type_Code ,
X_code_combination_id => l_backlog_account_ccid,
X_set_of_books_id => g_sob_id ,
X_dr_cr_flag => 'DR' ,
X_amount => l_detail_balances.reval_reserve_backlog,
X_adjustment_type => 'BL RESERVE',
X_transfer_to_gl_flag => 'Y' ,
X_units_assigned => l_units_per_dist.units_assigned ,
X_asset_id => P_Asset_Id ,
X_distribution_id => l_detail_balances.distribution_id ,
X_period_counter => g_prd_rec.period_counter,
X_adjustment_offset_type => 'REVAL RESERVE',
X_report_ccid => l_reval_rsv_account_ccid,
X_mode => 'R',
X_event_id => P_Event_Id ) ;
igi_iac_adjustments_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_book_type_code => P_Book_Type_Code ,
X_code_combination_id => l_reval_rsv_account_ccid,
X_set_of_books_id => g_sob_id ,
X_dr_cr_flag => 'DR' ,
X_amount => l_detail_balances.reval_reserve_net,
X_adjustment_type => 'REVAL RESERVE',
X_transfer_to_gl_flag => 'Y' ,
X_units_assigned => l_units_per_dist.units_assigned ,
X_asset_id => P_Asset_Id ,
X_distribution_id => l_detail_balances.distribution_id ,
X_period_counter => g_prd_rec.period_counter,
X_adjustment_offset_type => NULL,
X_report_ccid => NULL,
X_mode => 'R',
X_event_id => P_Event_Id ) ;
/* Insert new detail balance record for this distribution */
IF (g_is_first_period) THEN
l_db_op_acct_ytd := 0;
debug( g_state_level,l_path_name,'start insert det bal');
igi_iac_det_balances_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_asset_id => P_Asset_Id ,
X_distribution_id => l_detail_balances.distribution_id ,
X_book_type_code => P_Book_Type_Code ,
X_period_counter => g_prd_rec.period_counter,
X_adjustment_cost => 0,
X_net_book_value => 0,
X_reval_reserve_cost => 0,
X_reval_reserve_backlog => 0,
X_reval_reserve_gen_fund => 0,
X_reval_reserve_net => 0,
X_operating_acct_cost => 0,
X_operating_acct_backlog => 0,
X_operating_acct_net => 0,
X_operating_acct_ytd => 0,
X_deprn_period => 0,
X_deprn_ytd => l_detail_balances.deprn_ytd,
X_deprn_reserve => 0,
X_deprn_reserve_backlog => 0,
X_general_fund_per => 0,
X_general_fund_acc => 0,
X_last_reval_date => l_detail_balances.last_reval_date ,
X_current_reval_factor => l_detail_balances.current_reval_factor ,
X_cumulative_reval_factor => l_detail_balances.cumulative_reval_factor ,
X_active_flag => 'N',
X_mode => 'R') ;
debug( g_state_level,l_path_name,'end insert det bals');
IGI_IAC_FA_DEPRN_PKG.Insert_Row(
x_rowid => g_rowid,
x_book_type_code => p_book_type_code,
x_asset_id => p_asset_id,
x_period_counter => g_prd_rec.period_counter,
x_adjustment_id => l_retirement_adjustment_id,
x_distribution_id => l_fa_deprn.distribution_id,
x_deprn_period => 0,
x_deprn_ytd => l_fa_deprn.deprn_ytd,
x_deprn_reserve => 0,
x_active_flag => 'N',
x_mode => 'R');
igi_iac_adjustments_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_book_type_code => P_Book_Type_Code ,
X_code_combination_id => l_nbv_retired_account_ccid,
X_set_of_books_id => g_sob_id ,
X_dr_cr_flag => 'CR' ,
X_amount => l_detail_balances_new.adjustment_cost-l_detail_balances_new.deprn_reserve,
X_adjustment_type => 'NBV RETIRED',
X_transfer_to_gl_flag => 'Y' ,
X_units_assigned => l_units_per_dist.units_assigned ,
X_asset_id => P_Asset_Id ,
X_distribution_id => l_new_fa_dist.distribution_id ,
X_period_counter => g_prd_rec.period_counter,
X_adjustment_offset_type => NULL,
X_report_ccid => NULL,
X_mode => 'R',
X_event_id => P_Event_Id ) ;
debug( g_state_level,l_path_name,'done nbv ret insert');
igi_iac_adjustments_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_book_type_code => P_Book_Type_Code ,
X_code_combination_id => l_nbv_retired_account_ccid,
X_set_of_books_id => g_sob_id ,
X_dr_cr_flag => 'DR' ,
X_amount => l_detail_balances_new.deprn_reserve_backlog,
X_adjustment_type => 'NBV RETIRED',
X_transfer_to_gl_flag => 'Y' ,
X_units_assigned => l_units_per_dist.units_assigned ,
X_asset_id => P_Asset_Id ,
X_distribution_id => l_new_fa_dist.distribution_id ,
X_period_counter => g_prd_rec.period_counter,
X_adjustment_offset_type => NULL,
X_report_ccid => NULL,
X_mode => 'R',
X_event_id => P_Event_Id ) ;
debug( g_state_level,l_path_name, 'done 2nd nbv ret insert');
igi_iac_adjustments_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_book_type_code => P_Book_Type_Code ,
X_code_combination_id => l_reval_rsv_ret_acct_ccid,
X_set_of_books_id => g_sob_id ,
X_dr_cr_flag => 'DR' ,
X_amount => l_detail_balances_new.reval_reserve_net,
X_adjustment_type => 'REVAL RSV RET',
X_transfer_to_gl_flag => 'Y' ,
X_units_assigned => l_units_per_dist.units_assigned ,
X_asset_id => P_Asset_Id ,
X_distribution_id => l_new_fa_dist.distribution_id ,
X_period_counter => g_prd_rec.period_counter,
X_adjustment_offset_type => NULL,
X_report_ccid => NULL,
X_mode => 'R',
X_event_id => P_Event_Id ) ;
debug( g_state_level,l_path_name,'done reval rsv ret insert');
igi_iac_adjustments_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_book_type_code => P_Book_Type_Code ,
X_code_combination_id => l_cost_account_ccid,
X_set_of_books_id => g_sob_id ,
X_dr_cr_flag => 'DR' ,
X_amount => l_detail_balances_new.adjustment_cost,
X_adjustment_type => 'COST',
X_transfer_to_gl_flag => 'Y' ,
X_units_assigned => l_units_per_dist.units_assigned ,
X_asset_id => P_Asset_Id ,
X_distribution_id => l_new_fa_dist.distribution_id,
X_period_counter => g_prd_rec.period_counter,
X_adjustment_offset_type => NULL,
X_report_ccid => NULL,
X_mode => 'R',
X_event_id => P_Event_Id ) ;
igi_iac_adjustments_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_book_type_code => P_Book_Type_Code ,
X_code_combination_id => l_acc_deprn_account_ccid,
X_set_of_books_id => g_sob_id ,
X_dr_cr_flag => 'CR' ,
X_amount => l_detail_balances_new.deprn_reserve,
X_adjustment_type => 'RESERVE',
X_transfer_to_gl_flag => 'Y' ,
X_units_assigned => l_units_per_dist.units_assigned ,
X_asset_id => P_Asset_Id ,
X_distribution_id => l_new_fa_dist.distribution_id,
X_period_counter => g_prd_rec.period_counter,
X_adjustment_offset_type => NULL,
X_report_ccid => NULL,
X_mode => 'R',
X_event_id => P_Event_Id ) ;
igi_iac_adjustments_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_book_type_code => P_Book_Type_Code ,
X_code_combination_id => l_backlog_account_ccid,
X_set_of_books_id => g_sob_id ,
X_dr_cr_flag => 'CR' ,
X_amount => l_detail_balances_new.deprn_reserve_backlog,
X_adjustment_type => 'BL RESERVE',
X_transfer_to_gl_flag => 'Y' ,
X_units_assigned => l_units_per_dist.units_assigned ,
X_asset_id => P_Asset_Id ,
X_distribution_id => l_new_fa_dist.distribution_id,
X_period_counter => g_prd_rec.period_counter,
X_adjustment_offset_type => NULL,
X_report_ccid => NULL,
X_mode => 'R',
X_event_id => P_Event_Id ) ;
igi_iac_adjustments_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_book_type_code => P_Book_Type_Code ,
X_code_combination_id => l_reval_rsv_account_ccid,
X_set_of_books_id => g_sob_id ,
X_dr_cr_flag => 'CR' ,
X_amount => l_detail_balances_new.reval_reserve_net,
X_adjustment_type => 'REVAL RESERVE',
X_transfer_to_gl_flag => 'Y' ,
X_units_assigned => l_units_per_dist.units_assigned ,
X_asset_id => P_Asset_Id ,
X_distribution_id => l_new_fa_dist.distribution_id,
X_period_counter => g_prd_rec.period_counter,
X_adjustment_offset_type => NULL,
X_report_ccid => NULL,
X_mode => 'R',
X_event_id => P_Event_Id ) ;
igi_iac_det_balances_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_asset_id => P_Asset_Id ,
X_distribution_id => l_new_fa_dist.distribution_id,
X_book_type_code => P_Book_Type_Code ,
X_period_counter => g_prd_rec.period_counter,
X_adjustment_cost => l_detail_balances_new.adjustment_cost ,
X_net_book_value => l_detail_balances_new.net_book_value,
X_reval_reserve_cost => l_detail_balances_new.reval_reserve_cost,
X_reval_reserve_backlog => l_detail_balances_new.reval_reserve_backlog,
X_reval_reserve_gen_fund => l_detail_balances_new.reval_reserve_gen_fund,
X_reval_reserve_net => l_detail_balances_new.reval_reserve_net,
X_operating_acct_cost => l_detail_balances_new.operating_acct_cost,
X_operating_acct_backlog => l_detail_balances_new.operating_acct_backlog,
X_operating_acct_net => l_detail_balances_new.operating_acct_net,
X_operating_acct_ytd => l_detail_balances.operating_acct_ytd,
X_deprn_period => l_detail_balances_new.deprn_period,
X_deprn_ytd => 0,
X_deprn_reserve => l_detail_balances_new.deprn_reserve,
X_deprn_reserve_backlog => l_detail_balances_new.deprn_reserve_backlog,
X_general_fund_per => l_detail_balances_new.general_fund_per,
X_general_fund_acc => l_detail_balances_new.general_fund_acc,
X_last_reval_date => l_detail_balances.last_reval_date ,
X_current_reval_factor => l_detail_balances.current_reval_factor ,
X_cumulative_reval_factor => l_detail_balances.cumulative_reval_factor ,
X_active_flag => l_detail_balances.active_flag,
X_mode => 'R') ;
debug( g_state_level,l_path_name,'end insert det bals for new dist');
IGI_IAC_FA_DEPRN_PKG.Insert_Row(
x_rowid => l_rowid,
x_book_type_code => p_book_type_code,
x_asset_id => p_asset_id,
x_period_counter => g_prd_rec.period_counter,
x_adjustment_id => l_retirement_adjustment_id,
x_distribution_id => l_new_fa_dist.distribution_id,
x_deprn_period => l_fa_deprn.deprn_period,
x_deprn_ytd => 0,
x_deprn_reserve => l_fa_total_new_acc_deprn,
x_active_flag => NULL,
x_mode => 'R');
debug( g_state_level,l_path_name,'Non Imapcted Active distributions insertion');
igi_iac_det_balances_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_asset_id => P_Asset_Id,
X_distribution_id => l_detail_balances.distribution_id ,
X_book_type_code => P_Book_Type_Code ,
X_period_counter => g_prd_rec.period_counter,
X_adjustment_cost => l_detail_balances.adjustment_cost ,
X_net_book_value => l_detail_balances.net_book_value,
X_reval_reserve_cost => l_detail_balances.reval_reserve_cost,
X_reval_reserve_backlog => l_detail_balances.reval_reserve_backlog,
X_reval_reserve_gen_fund => l_detail_balances.reval_reserve_gen_fund,
X_reval_reserve_net => l_detail_balances.reval_reserve_net,
X_operating_acct_cost => l_detail_balances.operating_acct_cost,
X_operating_acct_backlog => l_detail_balances.operating_acct_backlog,
X_operating_acct_net => l_detail_balances.operating_acct_net,
X_operating_acct_ytd => l_detail_balances.operating_acct_ytd,
X_deprn_period => l_detail_balances.deprn_period,
X_deprn_ytd => l_detail_balances.deprn_ytd,
X_deprn_reserve => l_detail_balances.deprn_reserve,
X_deprn_reserve_backlog => l_detail_balances.deprn_reserve_backlog,
X_general_fund_per => l_detail_balances.general_fund_per,
X_general_fund_acc => l_detail_balances.general_fund_acc,
X_last_reval_date => l_detail_balances.last_reval_date ,
X_current_reval_factor => l_detail_balances.current_reval_factor ,
X_cumulative_reval_factor => l_detail_balances.cumulative_reval_factor ,
X_active_flag => l_detail_balances.active_flag ,
X_mode => 'R') ;
IGI_IAC_FA_DEPRN_PKG.Insert_Row(
x_rowid => g_rowid,
x_book_type_code => p_book_type_code,
x_asset_id => p_asset_id,
x_period_counter => g_prd_rec.period_counter,
x_adjustment_id => l_retirement_adjustment_id,
x_distribution_id => l_fa_deprn.distribution_id,
x_deprn_period => l_fa_deprn.deprn_period,
x_deprn_ytd => l_fa_deprn_ytd,
x_deprn_reserve => l_fa_deprn.deprn_reserve,
x_active_flag => l_fa_deprn.active_flag,
x_mode => 'R');
debug( g_state_level,l_path_name,'Non Imapcted InActive distributions insertion');
igi_iac_det_balances_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_asset_id => P_Asset_Id,
X_distribution_id => l_detail_balances.distribution_id ,
X_book_type_code => P_Book_Type_Code ,
X_period_counter => g_prd_rec.period_counter,
X_adjustment_cost => l_detail_balances.adjustment_cost ,
X_net_book_value => l_detail_balances.net_book_value,
X_reval_reserve_cost => l_detail_balances.reval_reserve_cost,
X_reval_reserve_backlog => l_detail_balances.reval_reserve_backlog,
X_reval_reserve_gen_fund => l_detail_balances.reval_reserve_gen_fund,
X_reval_reserve_net => l_detail_balances.reval_reserve_net,
X_operating_acct_cost => l_detail_balances.operating_acct_cost,
X_operating_acct_backlog => l_detail_balances.operating_acct_backlog,
X_operating_acct_net => l_detail_balances.operating_acct_net,
X_operating_acct_ytd => l_detail_balances.operating_acct_ytd,
X_deprn_period => l_detail_balances.deprn_period,
X_deprn_ytd => l_detail_balances.deprn_ytd,
X_deprn_reserve => l_detail_balances.deprn_reserve,
X_deprn_reserve_backlog => l_detail_balances.deprn_reserve_backlog,
X_general_fund_per => l_detail_balances.general_fund_per,
X_general_fund_acc => l_detail_balances.general_fund_acc,
X_last_reval_date => l_detail_balances.last_reval_date ,
X_current_reval_factor => l_detail_balances.current_reval_factor ,
X_cumulative_reval_factor => l_detail_balances.cumulative_reval_factor ,
X_active_flag => l_detail_balances.active_flag ,
X_mode => 'R') ;
IGI_IAC_FA_DEPRN_PKG.Insert_Row(
x_rowid => l_rowid,
x_book_type_code => p_book_type_code,
x_asset_id => p_asset_id,
x_period_counter => g_prd_rec.period_counter,
x_adjustment_id => l_retirement_adjustment_id,
x_distribution_id => l_fa_deprn.distribution_id,
x_deprn_period => l_fa_deprn.deprn_period,
x_deprn_ytd => l_fa_deprn_ytd,
x_deprn_reserve => l_fa_deprn.deprn_reserve,
x_active_flag => l_fa_deprn.active_flag,
x_mode => 'R'
);
SELECT max(period_counter)
INTO l_max_period_counter
FROM igi_iac_asset_balances
WHERE asset_id = P_Asset_Id
AND book_type_code = P_Book_Type_Code;
igi_iac_asset_balances_pkg.insert_row(
X_rowid => l_rowid ,
X_asset_id => p_asset_id,
X_book_type_code => p_book_type_code ,
X_period_counter => g_prd_rec.period_counter ,
X_net_book_value => l_asset_balances.net_book_value ,
X_adjusted_cost => l_asset_balances.adjusted_cost ,
X_operating_acct => l_asset_balances.operating_acct ,
X_reval_reserve => l_asset_balances.reval_reserve ,
X_deprn_amount => l_asset_balances.deprn_amount,
X_deprn_reserve => l_asset_balances.deprn_reserve ,
X_backlog_deprn_reserve => l_asset_balances.backlog_deprn_reserve ,
X_general_fund => l_asset_balances.general_fund ,
X_last_reval_date => l_asset_balances_rec.last_reval_date ,
X_current_reval_factor => l_asset_balances_rec.current_reval_factor,
X_cumulative_reval_factor => l_asset_balances_rec.cumulative_reval_factor,
X_mode => 'R') ;
igi_iac_asset_balances_pkg.update_row(
X_asset_id => p_asset_id,
X_book_type_code => p_book_type_code ,
X_period_counter => g_prd_rec.period_counter ,
X_net_book_value => l_asset_balances.net_book_value ,
X_adjusted_cost => l_asset_balances.adjusted_cost ,
X_operating_acct => l_asset_balances.operating_acct ,
X_reval_reserve => l_asset_balances.reval_reserve ,
X_deprn_amount => l_asset_balances.deprn_amount,
X_deprn_reserve => l_asset_balances.deprn_reserve ,
X_backlog_deprn_reserve => l_asset_balances.backlog_deprn_reserve ,
X_general_fund => l_asset_balances.general_fund ,
X_last_reval_date => l_asset_balances_rec.last_reval_date ,
X_current_reval_factor => l_asset_balances_rec.current_reval_factor,
X_cumulative_reval_factor => l_asset_balances_rec.cumulative_reval_factor,
X_mode => 'R') ;
igi_iac_trans_headers_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_transaction_header_id => g_retire_rec.detail_info.transaction_header_id_in,
X_adjustment_id_out => NULL ,
X_transaction_type_code => 'REVALUATION',
X_transaction_date_entered => g_fa_trx.transaction_date_entered,
X_mass_refrence_id => g_fa_trx.mass_reference_id ,
X_transaction_sub_type => 'RETIREMENT',
X_book_type_code => P_Book_Type_Code,
X_asset_id => p_asset_id ,
X_category_id => g_asset_category_id,
X_adj_deprn_start_date => NULL,
X_revaluation_type_flag => NULL,
X_adjustment_status => 'COMPLETE' ,
X_period_counter => P_Current_period,
X_mode =>'R',
X_event_id => P_Event_Id) ;
debug( g_state_level, l_path_name,'inserted trans_headers record');
igi_iac_trans_headers_pkg.update_row(l_adjustment_id_out,
l_retirement_adjustment_id,
'R') ;
debug( g_state_level,l_path_name,'updated old trans_headers record');
igi_iac_adjustments_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_book_type_code => P_Book_Type_Code ,
X_code_combination_id => l_all_occ_reval.code_combination_id,
X_set_of_books_id => g_sob_id ,
X_dr_cr_flag => 'DR',
X_amount => l_all_occ_reval.amount,
X_adjustment_type => l_all_occ_reval.adjustment_type,
X_transfer_to_gl_flag => 'Y',
X_units_assigned => l_all_occ_reval.units_assigned ,
X_asset_id => p_Asset_Id ,
X_distribution_id => l_detail_balances.distribution_id ,
X_period_counter => g_prd_rec.period_counter,
X_adjustment_offset_type =>l_all_occ_reval.adjustment_offset_type,
X_report_ccid => l_all_occ_reval.report_ccid,
X_mode => 'R',
X_event_id => P_Event_Id ) ;
igi_iac_adjustments_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_book_type_code => P_Book_Type_Code ,
X_code_combination_id => l_all_occ_reval.code_combination_id,
X_set_of_books_id => g_sob_id ,
X_dr_cr_flag => 'CR',
X_amount => l_retire_amount,
X_adjustment_type => l_all_occ_reval.adjustment_type,
X_transfer_to_gl_flag => 'Y',
X_units_assigned => l_new_fa_dist.units_assigned ,
X_asset_id => p_Asset_Id ,
X_distribution_id => l_new_fa_dist.distribution_id ,
X_period_counter => g_prd_rec.period_counter,
X_adjustment_offset_type =>l_all_occ_reval.adjustment_offset_type,
X_report_ccid => l_all_occ_reval.report_ccid,
X_mode => 'R',
X_event_id => P_Event_Id ) ;
igi_iac_det_balances_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_asset_id => P_Asset_Id ,
X_distribution_id => l_detail_balances.distribution_id,
X_book_type_code => P_Book_Type_Code ,
X_period_counter => g_prd_rec.period_counter,
X_adjustment_cost => l_detail_balances.adjustment_cost ,
X_net_book_value => l_detail_balances.net_book_value,
X_reval_reserve_cost => l_detail_balances.reval_reserve_cost,
X_reval_reserve_backlog => l_detail_balances.reval_reserve_backlog,
X_reval_reserve_gen_fund => l_detail_balances.reval_reserve_gen_fund,
X_reval_reserve_net => l_detail_balances.reval_reserve_net,
X_operating_acct_cost => l_detail_balances.operating_acct_cost,
X_operating_acct_backlog => l_detail_balances.operating_acct_backlog,
X_operating_acct_net => l_detail_balances.operating_acct_net,
X_operating_acct_ytd => l_detail_balances.operating_acct_ytd,
X_deprn_period => l_detail_balances.deprn_period,
X_deprn_ytd => l_detail_balances.DEPRN_YTD,
X_deprn_reserve => l_detail_balances.deprn_reserve,
X_deprn_reserve_backlog => l_detail_balances.deprn_reserve_backlog,
X_general_fund_per => l_detail_balances.general_fund_per,
X_general_fund_acc => l_detail_balances.general_fund_acc,
X_last_reval_date => l_detail_balances.last_reval_date ,
X_current_reval_factor => l_detail_balances.current_reval_factor ,
X_cumulative_reval_factor => l_detail_balances.cumulative_reval_factor ,
X_active_flag => l_detail_balances.active_flag,
X_mode => 'R') ;
debug( g_state_level,l_path_name,'end insert det bals for new dist');
IGI_IAC_FA_DEPRN_PKG.Insert_Row(
x_rowid => l_rowid,
x_book_type_code => p_book_type_code,
x_asset_id => p_asset_id,
x_period_counter => g_prd_rec.period_counter,
x_adjustment_id => l_retirement_adjustment_id,
x_distribution_id => l_detail_balances.distribution_id,
x_deprn_period => l_fa_deprn.deprn_period,
x_deprn_ytd => l_fa_deprn.deprn_ytd,
x_deprn_reserve => l_fa_deprn.deprn_reserve,
x_active_flag => NULL,
x_mode => 'R');
debug(g_state_level,l_path_name,'Inserted FA deprn record for dist'||l_detail_balances.distribution_id );
igi_iac_det_balances_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_asset_id => P_Asset_Id ,
X_distribution_id => l_detail_balances.distribution_id ,
X_book_type_code => P_Book_Type_Code ,
X_period_counter => g_prd_rec.period_counter,
X_adjustment_cost => l_detail_balances.adjustment_cost ,
X_net_book_value => l_detail_balances.net_book_value,
X_reval_reserve_cost => l_detail_balances.reval_reserve_cost,
X_reval_reserve_backlog => l_detail_balances.reval_reserve_backlog,
X_reval_reserve_gen_fund => l_detail_balances.reval_reserve_gen_fund,
X_reval_reserve_net => l_detail_balances.reval_reserve_net,
X_operating_acct_cost => l_detail_balances.operating_acct_cost,
X_operating_acct_backlog => l_detail_balances.operating_acct_backlog,
X_operating_acct_net => l_detail_balances.operating_acct_net,
X_operating_acct_ytd => l_detail_balances.operating_acct_ytd,
X_deprn_period => l_detail_balances.deprn_period,
X_deprn_ytd => l_detail_balances.deprn_ytd,
X_deprn_reserve => l_detail_balances.deprn_reserve,
X_deprn_reserve_backlog => l_detail_balances.deprn_reserve_backlog,
X_general_fund_per => l_detail_balances.general_fund_per,
X_general_fund_acc => l_detail_balances.general_fund_acc,
X_last_reval_date => l_detail_balances.last_reval_date ,
X_current_reval_factor => l_detail_balances.current_reval_factor ,
X_cumulative_reval_factor => l_detail_balances.cumulative_reval_factor ,
X_active_flag => l_detail_balances.active_flag,
X_mode => 'R') ;
debug( g_state_level,l_path_name,'end insert det bals..not impacted distribution');
IGI_IAC_FA_DEPRN_PKG.Insert_Row(
x_rowid => l_rowid,
x_book_type_code => p_book_type_code,
x_asset_id => p_asset_id,
x_period_counter => g_prd_rec.period_counter,
x_adjustment_id => l_retirement_adjustment_id,
x_distribution_id => l_fa_deprn.distribution_id,
x_deprn_period => l_fa_deprn.deprn_period,
x_deprn_ytd => l_fa_deprn.deprn_ytd,
x_deprn_reserve => l_fa_deprn.deprn_reserve,
x_active_flag => NULL,
x_mode => 'R' );
igi_iac_det_balances_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_asset_id => P_Asset_Id,
X_distribution_id => l_detail_balances.distribution_id ,
X_book_type_code => P_Book_Type_Code ,
X_period_counter => g_prd_rec.period_counter,
X_adjustment_cost => l_detail_balances.adjustment_cost ,
X_net_book_value => l_detail_balances.net_book_value,
X_reval_reserve_cost => l_detail_balances.reval_reserve_cost,
X_reval_reserve_backlog => l_detail_balances.reval_reserve_backlog,
X_reval_reserve_gen_fund => l_detail_balances.reval_reserve_gen_fund,
X_reval_reserve_net => l_detail_balances.reval_reserve_net,
X_operating_acct_cost => l_detail_balances.operating_acct_cost,
X_operating_acct_backlog => l_detail_balances.operating_acct_backlog,
X_operating_acct_net => l_detail_balances.operating_acct_net,
X_operating_acct_ytd => l_detail_balances.operating_acct_ytd,
X_deprn_period => l_detail_balances.deprn_period,
X_deprn_ytd => l_detail_balances.deprn_ytd,
X_deprn_reserve => l_detail_balances.deprn_reserve,
X_deprn_reserve_backlog => l_detail_balances.deprn_reserve_backlog,
X_general_fund_per => l_detail_balances.general_fund_per,
X_general_fund_acc => l_detail_balances.general_fund_acc,
X_last_reval_date => l_detail_balances.last_reval_date ,
X_current_reval_factor => l_detail_balances.current_reval_factor ,
X_cumulative_reval_factor => l_detail_balances.cumulative_reval_factor ,
X_active_flag => l_detail_balances.active_flag ,
X_mode => 'R') ;
IGI_IAC_FA_DEPRN_PKG.Insert_Row(
x_rowid => g_rowid,
x_book_type_code => p_book_type_code,
x_asset_id => p_asset_id,
x_period_counter => g_prd_rec.period_counter,
x_adjustment_id => l_retirement_adjustment_id,
x_distribution_id => l_fa_deprn.distribution_id,
x_deprn_period => l_fa_deprn.deprn_period,
x_deprn_ytd => l_fa_deprn.deprn_ytd,
x_deprn_reserve => l_fa_deprn.deprn_reserve,
x_active_flag => l_fa_deprn.active_flag,
x_mode => 'R');
igi_iac_trans_headers_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_transaction_header_id => g_retire_rec.detail_info.transaction_header_id_in,
X_adjustment_id_out => NULL ,
X_transaction_type_code => 'DEPRECIATION',
X_transaction_date_entered => g_fa_trx.transaction_date_entered,
X_mass_refrence_id => g_fa_trx.mass_reference_id ,
X_transaction_sub_type => 'RETIREMENT',
X_book_type_code => P_Book_Type_Code,
X_asset_id => p_asset_id ,
X_category_id => g_asset_category_id,
X_adj_deprn_start_date => NULL,
X_revaluation_type_flag => NULL,
X_adjustment_status => 'COMPLETE' ,
X_period_counter => P_Current_period,
X_mode =>'R',
X_event_id => P_Event_Id) ;
debug( g_state_level, l_path_name,'inserted trans_headers record');
igi_iac_trans_headers_pkg.update_row(l_adjustment_id_out,
l_retirement_adjustment_id,
'R') ;
debug( g_state_level,l_path_name,'updated old trans_headers record');
igi_iac_adjustments_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_book_type_code => P_Book_Type_Code ,
X_code_combination_id => l_all_prd_reval.code_combination_id,
X_set_of_books_id => g_sob_id ,
X_dr_cr_flag => 'DR',
X_amount => l_all_prd_reval.amount,
X_adjustment_type => l_all_prd_reval.adjustment_type,
X_transfer_to_gl_flag => 'Y',
X_units_assigned => l_all_prd_reval.units_assigned ,
X_asset_id => p_Asset_Id ,
X_distribution_id => l_detail_balances.distribution_id ,
X_period_counter => g_prd_rec.period_counter,
X_adjustment_offset_type =>l_all_prd_reval.adjustment_offset_type,
X_report_ccid => l_all_prd_reval.report_ccid,
X_mode => 'R',
X_event_id => P_Event_Id ) ;
igi_iac_adjustments_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_book_type_code => P_Book_Type_Code ,
X_code_combination_id => l_all_prd_reval.code_combination_id,
X_set_of_books_id => g_sob_id ,
X_dr_cr_flag => 'CR',
X_amount => l_retire_amount,
X_adjustment_type => l_all_prd_reval.adjustment_type,
X_transfer_to_gl_flag => 'Y',
X_units_assigned => l_new_fa_dist.units_assigned ,
X_asset_id => p_Asset_Id ,
X_distribution_id => l_new_fa_dist.distribution_id ,
X_period_counter => g_prd_rec.period_counter,
X_adjustment_offset_type =>l_all_prd_reval.adjustment_offset_type,
X_report_ccid => l_all_prd_reval.report_ccid,
X_mode => 'R',
X_event_id => P_Event_Id ) ;
igi_iac_det_balances_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_asset_id => P_Asset_Id ,
X_distribution_id => l_detail_balances.distribution_id,
X_book_type_code => P_Book_Type_Code ,
X_period_counter => g_prd_rec.period_counter,
X_adjustment_cost => l_detail_balances.adjustment_cost ,
X_net_book_value => l_detail_balances.net_book_value,
X_reval_reserve_cost => l_detail_balances.reval_reserve_cost,
X_reval_reserve_backlog => l_detail_balances.reval_reserve_backlog,
X_reval_reserve_gen_fund => l_detail_balances.reval_reserve_gen_fund,
X_reval_reserve_net => l_detail_balances.reval_reserve_net,
X_operating_acct_cost => l_detail_balances.operating_acct_cost,
X_operating_acct_backlog => l_detail_balances.operating_acct_backlog,
X_operating_acct_net => l_detail_balances.operating_acct_net,
X_operating_acct_ytd => l_detail_balances.operating_acct_ytd,
X_deprn_period => l_detail_balances.deprn_period,
X_deprn_ytd => l_detail_balances.DEPRN_YTD,
X_deprn_reserve => l_detail_balances.deprn_reserve,
X_deprn_reserve_backlog => l_detail_balances.deprn_reserve_backlog,
X_general_fund_per => l_detail_balances.general_fund_per,
X_general_fund_acc => l_detail_balances.general_fund_acc,
X_last_reval_date => l_detail_balances.last_reval_date ,
X_current_reval_factor => l_detail_balances.current_reval_factor ,
X_cumulative_reval_factor => l_detail_balances.cumulative_reval_factor ,
X_active_flag => l_detail_balances.active_flag,
X_mode => 'R') ;
debug( g_state_level,l_path_name,'end insert det bals for new dist');
IGI_IAC_FA_DEPRN_PKG.Insert_Row(
x_rowid => l_rowid,
x_book_type_code => p_book_type_code,
x_asset_id => p_asset_id,
x_period_counter => g_prd_rec.period_counter,
x_adjustment_id => l_retirement_adjustment_id,
x_distribution_id => l_detail_balances.distribution_id,
x_deprn_period => l_fa_deprn.deprn_period,
x_deprn_ytd => l_fa_deprn.deprn_ytd,
x_deprn_reserve => l_fa_deprn.deprn_reserve,
x_active_flag => NULL,
x_mode => 'R');
igi_iac_det_balances_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_asset_id => P_Asset_Id ,
X_distribution_id => l_detail_balances.distribution_id ,
X_book_type_code => P_Book_Type_Code ,
X_period_counter => g_prd_rec.period_counter,
X_adjustment_cost => l_detail_balances.adjustment_cost ,
X_net_book_value => l_detail_balances.net_book_value,
X_reval_reserve_cost => l_detail_balances.reval_reserve_cost,
X_reval_reserve_backlog => l_detail_balances.reval_reserve_backlog,
X_reval_reserve_gen_fund => l_detail_balances.reval_reserve_gen_fund,
X_reval_reserve_net => l_detail_balances.reval_reserve_net,
X_operating_acct_cost => l_detail_balances.operating_acct_cost,
X_operating_acct_backlog => l_detail_balances.operating_acct_backlog,
X_operating_acct_net => l_detail_balances.operating_acct_net,
X_operating_acct_ytd => l_detail_balances.operating_acct_ytd,
X_deprn_period => l_detail_balances.deprn_period,
X_deprn_ytd => l_detail_balances.deprn_ytd,
X_deprn_reserve => l_detail_balances.deprn_reserve,
X_deprn_reserve_backlog => l_detail_balances.deprn_reserve_backlog,
X_general_fund_per => l_detail_balances.general_fund_per,
X_general_fund_acc => l_detail_balances.general_fund_acc,
X_last_reval_date => l_detail_balances.last_reval_date ,
X_current_reval_factor => l_detail_balances.current_reval_factor ,
X_cumulative_reval_factor => l_detail_balances.cumulative_reval_factor ,
X_active_flag => l_detail_balances.active_flag,
X_mode => 'R') ;
debug( g_state_level,l_path_name,'end insert det bals');
IGI_IAC_FA_DEPRN_PKG.Insert_Row(
x_rowid => l_rowid,
x_book_type_code => p_book_type_code,
x_asset_id => p_asset_id,
x_period_counter => g_prd_rec.period_counter,
x_adjustment_id => l_retirement_adjustment_id,
x_distribution_id => l_fa_deprn.distribution_id,
x_deprn_period => l_fa_deprn.deprn_period,
x_deprn_ytd => l_fa_deprn.deprn_ytd,
x_deprn_reserve => l_fa_deprn.deprn_reserve,
x_active_flag => NULL,
x_mode => 'R' );
igi_iac_det_balances_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_retirement_adjustment_id ,
X_asset_id => P_Asset_Id,
X_distribution_id => l_detail_balances.distribution_id ,
X_book_type_code => P_Book_Type_Code ,
X_period_counter => g_prd_rec.period_counter,
X_adjustment_cost => l_detail_balances.adjustment_cost ,
X_net_book_value => l_detail_balances.net_book_value,
X_reval_reserve_cost => l_detail_balances.reval_reserve_cost,
X_reval_reserve_backlog => l_detail_balances.reval_reserve_backlog,
X_reval_reserve_gen_fund => l_detail_balances.reval_reserve_gen_fund,
X_reval_reserve_net => l_detail_balances.reval_reserve_net,
X_operating_acct_cost => l_detail_balances.operating_acct_cost,
X_operating_acct_backlog => l_detail_balances.operating_acct_backlog,
X_operating_acct_net => l_detail_balances.operating_acct_net,
X_operating_acct_ytd => l_detail_balances.operating_acct_ytd,
X_deprn_period => l_detail_balances.deprn_period,
X_deprn_ytd => l_detail_balances.deprn_ytd,
X_deprn_reserve => l_detail_balances.deprn_reserve,
X_deprn_reserve_backlog => l_detail_balances.deprn_reserve_backlog,
X_general_fund_per => l_detail_balances.general_fund_per,
X_general_fund_acc => l_detail_balances.general_fund_acc,
X_last_reval_date => l_detail_balances.last_reval_date ,
X_current_reval_factor => l_detail_balances.current_reval_factor ,
X_cumulative_reval_factor => l_detail_balances.cumulative_reval_factor ,
X_active_flag => l_detail_balances.active_flag ,
X_mode => 'R') ;
IGI_IAC_FA_DEPRN_PKG.Insert_Row(
x_rowid => g_rowid,
x_book_type_code => p_book_type_code,
x_asset_id => p_asset_id,
x_period_counter => g_prd_rec.period_counter,
x_adjustment_id => l_retirement_adjustment_id,
x_distribution_id => l_fa_deprn.distribution_id,
x_deprn_period => l_fa_deprn.deprn_period,
x_deprn_ytd => l_fa_deprn.deprn_ytd,
x_deprn_reserve => l_fa_deprn.deprn_reserve,
x_active_flag => l_fa_deprn.active_flag,
x_mode => 'R'
);
is select MAX(period_counter) period_counter
from igi_iac_transaction_headers
where asset_id = p_asset_id
and book_type_code = p_book_type_code
and period_counter >= p_period_counter
and not (transaction_type_code='DEPRECIATION' and transaction_sub_type is null)
and not (transaction_type_code='REVALUATION' and transaction_sub_type in ('OCCASSIONAL','PRFOESSIONAL'));
debug( g_state_level,g_path_name,'problems inserting rows into igi_iac_fa_deprn');