[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT period_num_for_catchup
FROM igi_iac_book_controls
WHERE book_type_code = p_asset_iac_adj_info.book_type_code;
SELECT irr.*
FROM igi_iac_revaluation_rates irr
WHERE irr.asset_id = p_asset_iac_adj_info.asset_id
AND irr.book_type_code = p_asset_iac_adj_info.book_type_code
AND irr.latest_record = 'Y'
AND irr.revaluation_id = (SELECT max(iar.revaluation_id)
FROM igi_iac_revaluation_rates iar ,
igi_iac_transaction_headers ith
WHERE iar.asset_id = p_asset_iac_adj_info.asset_id
AND iar.book_type_code = p_asset_iac_adj_info.book_type_code
AND ith.book_type_code = p_asset_iac_adj_info.book_type_code
AND ith.asset_id = p_asset_iac_adj_info.asset_id
AND iar.adjustment_id = ith.adjustment_id
AND ith.adjustment_status IN ('COMPLETE','RUN'));
SELECT *
FROM igi_iac_asset_balances
WHERE asset_id = p_asset_id
AND book_type_code = p_book_type_code
AND period_counter = (SELECT MAX(period_counter)
FROM igi_iac_asset_balances
WHERE asset_id = p_asset_id
AND book_type_code = p_book_type_code);
SELECT *
FROM igi_iac_det_balances
WHERE asset_id = p_asset_id
AND book_type_code = p_book_type_code
AND adjustment_id = p_prev_adjustment_id
AND NVL(active_flag,'Y') = 'N' ;
SELECT *
FROM igi_iac_fa_deprn
WHERE book_type_code =P_book_type_code
AND asset_id =p_asset_id
AND adjustment_id =p_prev_adjustment_id
AND distribution_id = P_distribution_id;
SELECT asset_category_id,current_units
FROM fa_additions
WHERE asset_id = p_asset_id;
SELECT fdh.units_assigned,
idb.*
FROM fa_distribution_history fdh,
igi_iac_det_balances idb
WHERE fdh.book_type_code = cp_book_type_code
AND fdh.asset_id = cp_asset_id
AND fdh.date_ineffective IS NULL
AND idb.book_type_code = cp_book_type_code
AND idb.asset_id = cp_asset_id
AND idb.distribution_id = fdh.distribution_id
AND idb.adjustment_id = cp_adjustment_id;
igi_iac_trans_headers_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_adjustment_id ,
X_transaction_header_id => P_adj_hist.transaction_header_id_in,
X_adjustment_id_out => NULL ,
X_transaction_type_code => 'DEPRECIATION' ,
X_transaction_date_entered => SYSDATE ,
X_mass_refrence_id => NULL ,
X_transaction_sub_type => 'ADJUSTMENT',
X_book_type_code => p_asset_iac_adj_info.book_type_code,
X_asset_id => p_asset_iac_adj_info.asset_id,
X_category_id => P_adj_hist.category_id, -- p_asset_iac_adj_info.category_id ,
X_adj_deprn_start_date => NULL, --p_asset_iac_adj_info.last_period_counter ,
X_revaluation_type_flag => NULL,
X_adjustment_status => 'COMPLETE' ,
X_period_counter => p_adj_hist.period_counter,
X_event_id => p_event_id ) ;
IGI_IAC_DET_BALANCES_PKG.insert_row (
x_rowid => l_rowid,
x_adjustment_id => l_adjustment_id,
x_asset_id => l_det_balances.asset_id,
x_distribution_id => l_det_balances.distribution_id,
x_book_type_code => l_det_balances.book_type_code,
x_period_counter => l_asset_balance_mvmt.period_counter,
x_adjustment_cost => l_det_balances.adjustment_cost,
x_net_book_value => l_det_balances.net_book_value,
x_reval_reserve_cost => l_det_balances.reval_reserve_cost,
x_reval_reserve_backlog => l_det_balances.reval_reserve_backlog,
x_reval_reserve_gen_fund => l_det_balances.reval_reserve_gen_fund,
x_reval_reserve_net => l_det_balances.reval_reserve_net,
x_operating_acct_cost => l_det_balances.operating_acct_cost,
x_operating_acct_backlog => l_det_balances.operating_acct_backlog,
x_operating_acct_net => l_det_balances.operating_acct_net,
x_operating_acct_ytd => l_det_balances.operating_acct_ytd,
x_deprn_period => l_det_balances.deprn_period,
x_deprn_ytd => l_det_balances.deprn_ytd,
x_deprn_reserve => l_det_balances.deprn_reserve,
x_deprn_reserve_backlog => l_det_balances.deprn_reserve_backlog,
x_general_fund_per => l_det_balances.general_fund_per,
x_general_fund_acc => l_det_balances.general_fund_acc,
x_last_reval_date => l_det_balances.last_reval_date,
x_current_reval_factor => l_det_balances.current_reval_factor,
x_cumulative_reval_factor => l_det_balances.cumulative_reval_factor,
x_active_flag => l_det_balances.active_flag,
x_mode => 'R' );
igi_iac_fa_deprn_pkg.insert_row(
x_rowid => l_rowid,
x_book_type_code => l_det_balances.book_type_code,
x_asset_id => l_det_balances.asset_id,
x_distribution_id => l_det_balances.distribution_id,
x_period_counter => l_asset_balance_mvmt.period_counter,
x_adjustment_id => l_adjustment_id,
x_deprn_period => l_get_iac_fa_deprn.deprn_period,
x_deprn_ytd => l_get_iac_fa_deprn.deprn_ytd ,
x_deprn_reserve => l_get_iac_fa_deprn.deprn_reserve,
x_active_flag => l_get_iac_fa_deprn.active_flag,
x_mode => 'R');
igi_iac_adjustments_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_adjustment_id ,
X_book_type_code => l_det_balances.book_type_code ,
X_code_combination_id => l_deprn_exp_ccid,
X_set_of_books_id => l_sob_id ,
X_dr_cr_flag => 'DR' ,
X_amount => l_current_db.deprn_reserve,
X_adjustment_type => 'EXPENSE' ,
X_transfer_to_gl_flag => 'Y' ,
X_units_assigned => l_det_balances.units_assigned ,
X_asset_id => l_det_balances.asset_id ,
X_distribution_id => l_det_balances.distribution_id ,
X_period_counter => l_asset_balance_mvmt.period_counter,
X_adjustment_offset_type => 'RESERVE',
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_adjustment_id ,
X_book_type_code => l_det_balances.book_type_code ,
X_code_combination_id => l_deprn_rsv_ccid,
X_set_of_books_id => l_sob_id ,
X_dr_cr_flag => 'CR' ,
X_amount =>l_current_db.deprn_reserve,
X_adjustment_type => 'RESERVE' ,
X_transfer_to_gl_flag => 'Y' ,
X_units_assigned => l_det_balances.units_assigned ,
X_asset_id => l_det_balances.asset_id ,
X_distribution_id => l_det_balances.distribution_id ,
X_period_counter => l_asset_balance_mvmt.period_counter,
X_adjustment_offset_type => 'EXPENSE',
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_adjustment_id ,
X_book_type_code => l_det_balances.book_type_code ,
X_code_combination_id => l_revl_rsv_ccid,
X_set_of_books_id => l_sob_id ,
X_dr_cr_flag => 'DR' ,
X_amount => l_current_db.reval_reserve_gen_fund ,
X_adjustment_type => 'REVAL RESERVE' ,
X_transfer_to_gl_flag => 'Y' ,
X_units_assigned => l_det_balances.units_assigned ,
X_asset_id => l_det_balances.asset_id ,
X_distribution_id => l_det_balances.distribution_id ,
X_period_counter => l_asset_balance_mvmt.period_counter,
X_adjustment_offset_type => 'GENERAL FUND',
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_adjustment_id ,
X_book_type_code => l_det_balances.book_type_code ,
X_code_combination_id => l_gen_fund_ccid,
X_set_of_books_id => l_sob_id ,
X_dr_cr_flag => 'CR' ,
X_amount =>l_current_db.reval_reserve_gen_fund ,
X_adjustment_type => 'GENERAL FUND' ,
X_transfer_to_gl_flag => 'Y' ,
X_units_assigned => l_det_balances.units_assigned ,
X_asset_id => l_det_balances.asset_id ,
X_distribution_id => l_det_balances.distribution_id ,
X_period_counter => l_asset_balance_mvmt.period_counter,
X_adjustment_offset_type => 'REVAL RESERVE',
X_report_ccid => l_revl_rsv_ccid,
x_mode => 'R',
X_event_id => p_event_id
) ;
igi_iac_adjustments_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_adjustment_id ,
X_book_type_code => l_det_balances.book_type_code ,
X_code_combination_id => l_blog_rsv_ccid,
X_set_of_books_id => l_sob_id ,
X_dr_cr_flag => 'CR' ,
X_amount =>l_current_db.reval_reserve_backlog ,
X_adjustment_type => 'BL RESERVE' ,
X_transfer_to_gl_flag => 'Y' ,
X_units_assigned => l_det_balances.units_assigned ,
X_asset_id => l_det_balances.asset_id ,
X_distribution_id => l_det_balances.distribution_id ,
X_period_counter => l_asset_balance_mvmt.period_counter,
X_adjustment_offset_type => 'REVAL RESERVE',
X_report_ccid => l_revl_rsv_ccid,
x_mode => 'R',
X_event_id => p_event_id
) ;
igi_iac_adjustments_pkg.insert_row(
X_rowid => l_rowid ,
X_adjustment_id => l_adjustment_id ,
X_book_type_code => l_det_balances.book_type_code ,
X_code_combination_id => l_revl_rsv_ccid,
X_set_of_books_id => l_sob_id ,
X_dr_cr_flag => 'DR' ,
X_amount =>l_current_db.reval_reserve_backlog ,
X_adjustment_type => 'REVAL RESERVE' ,
X_transfer_to_gl_flag => 'Y' ,
X_units_assigned => l_det_balances.units_assigned ,
X_asset_id => l_det_balances.asset_id ,
X_distribution_id => l_det_balances.distribution_id ,
X_period_counter => l_asset_balance_mvmt.period_counter,
X_adjustment_offset_type => 'BL RESERVE',
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_adjustment_id ,
X_book_type_code => l_det_balances.book_type_code ,
X_code_combination_id => l_blog_rsv_ccid,
X_set_of_books_id => l_sob_id ,
X_dr_cr_flag => 'CR' ,
X_amount =>l_current_db.operating_acct_backlog ,
X_adjustment_type => 'BL RESERVE' ,
X_transfer_to_gl_flag => 'Y' ,
X_units_assigned => l_det_balances.units_assigned ,
X_asset_id => l_det_balances.asset_id ,
X_distribution_id => l_det_balances.distribution_id ,
X_period_counter => l_asset_balance_mvmt.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_adjustment_id ,
X_book_type_code => l_det_balances.book_type_code ,
X_code_combination_id => l_op_exp_ccid,
X_set_of_books_id => l_sob_id ,
X_dr_cr_flag => 'DR' ,
X_amount =>l_current_db.operating_acct_backlog ,
X_adjustment_type => 'OP EXPENSE' ,
X_transfer_to_gl_flag => 'Y' ,
X_units_assigned => l_det_balances.units_assigned ,
X_asset_id => l_det_balances.asset_id ,
X_distribution_id => l_det_balances.distribution_id ,
X_period_counter => l_asset_balance_mvmt.period_counter,
X_adjustment_offset_type => 'BL RESERVE',
X_report_ccid => Null,
x_mode => 'R',
X_event_id => p_event_id
) ;
p_string => 'IGI_IAC_DET_BALANCES_PKG.insert_row');
IGI_IAC_DET_BALANCES_PKG.insert_row (
x_rowid => l_rowid,
x_adjustment_id => l_current_db.adjustment_id,
x_asset_id => l_current_db.asset_id,
x_distribution_id => l_current_db.distribution_id,
x_book_type_code => l_current_db.book_type_code,
x_period_counter => l_current_db.period_counter,
x_adjustment_cost => l_det_balances.adjustment_cost ,
x_net_book_value => l_det_balances.net_book_value ,
x_reval_reserve_cost => l_det_balances.reval_reserve_cost ,
x_reval_reserve_backlog => l_det_balances.reval_reserve_backlog ,
x_reval_reserve_gen_fund => l_det_balances.reval_reserve_gen_fund ,
x_reval_reserve_net => l_det_balances.reval_reserve_net ,
x_operating_acct_cost => l_det_balances.operating_acct_cost ,
x_operating_acct_backlog => l_det_balances.operating_acct_backlog ,
x_operating_acct_net => l_det_balances.operating_acct_net ,
x_operating_acct_ytd => l_current_db.operating_acct_ytd,
x_deprn_period => l_current_db.deprn_period,
x_deprn_ytd => l_current_db.deprn_ytd,
x_deprn_reserve => l_det_balances.deprn_reserve ,
x_deprn_reserve_backlog => l_det_balances.deprn_reserve_backlog ,
x_general_fund_per => l_current_db.general_fund_per,
x_general_fund_acc => l_det_balances.general_fund_acc ,
x_last_reval_date => l_current_db.last_reval_date,
x_current_reval_factor => l_current_db.current_reval_factor,
x_cumulative_reval_factor => l_current_db.cumulative_reval_factor,
x_active_flag => l_current_db.active_flag,
x_mode => 'R' );
p_string => 'Before igi_iac_fa_deprn_pkg.insert_row');
igi_iac_fa_deprn_pkg.insert_row(
x_rowid => l_rowid,
x_book_type_code => l_det_balances.book_type_code,
x_asset_id => l_det_balances.asset_id,
x_distribution_id => l_det_balances.distribution_id,
x_period_counter => l_asset_balance_mvmt.period_counter,
x_adjustment_id => l_adjustment_id,
x_deprn_period => l_current_db_fa.deprn_period,
x_deprn_ytd => l_current_db_fa.deprn_ytd ,
x_deprn_reserve => l_current_db_fa.deprn_reserve,
x_active_flag => l_det_balances.active_flag,
x_mode => 'R');
p_string => 'After igi_iac_fa_deprn_pkg.insert_row');
IGI_IAC_ASSET_BALANCES_PKG.update_row (
x_asset_id => l_curr_asset_balance.asset_id,
x_book_type_code => l_curr_asset_balance.book_type_code,
x_period_counter => l_asset_balance_mvmt.period_counter,
x_net_book_value => l_curr_asset_balance.net_book_value,
x_adjusted_cost => l_curr_asset_balance.adjusted_cost,
x_operating_acct => l_curr_asset_balance.operating_acct,
x_reval_reserve => l_curr_asset_balance.reval_reserve,
x_deprn_amount => l_curr_asset_balance.deprn_amount,
x_deprn_reserve => l_curr_asset_balance.deprn_reserve,
x_backlog_deprn_reserve => l_curr_asset_balance.backlog_deprn_reserve,
x_general_fund => l_curr_asset_balance.general_fund,
x_last_reval_date => l_curr_asset_balance.last_reval_date,
x_current_reval_factor => l_curr_asset_balance.current_reval_factor,
x_cumulative_reval_factor => l_curr_asset_balance.cumulative_reval_factor,
x_mode => 'R'
);
igi_iac_trans_headers_pkg.update_row(
X_prev_adjustment_id => l_adjustment_id_out ,
X_adjustment_id => l_adjustment_id ) ;