eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGI_IAC_ADJ_EXPENSED_PKG dependencies on IGI_IAC_ASSET_BALANCES

Line 112: P_asset_balance IN OUT NOCOPY igi_iac_asset_balances%ROWTYPE,

108: p_string => 'deprn_adjustment_amount................'|| p_asset.deprn_adjustment_amount);
109: END debug_adj_asset;
110:
111: FUNCTION Calculate_New_Balances( p_asset_iac_adj_info IN OUT NOCOPY igi_iac_types.iac_adj_hist_asset_info,
112: P_asset_balance IN OUT NOCOPY igi_iac_asset_balances%ROWTYPE,
113: p_adj_hist IN igi_iac_adjustments_history%ROWTYPE)
114: RETURN boolean IS
115:
116: CURSOR c_period_num_for_catchup IS

Line 138: l_cumulative_backlog igi_iac_asset_balances.backlog_deprn_reserve%TYPE;

134: AND iar.adjustment_id = ith.adjustment_id
135: AND ith.adjustment_status IN ('COMPLETE','RUN'));
136:
137: l_get_curr_reval_rate igi_iac_revaluation_rates%ROWTYPE;
138: l_cumulative_backlog igi_iac_asset_balances.backlog_deprn_reserve%TYPE;
139: l_current_backlog igi_iac_asset_balances.backlog_deprn_reserve%TYPE;
140: l_Reval_rsv_backlog igi_iac_asset_balances.backlog_deprn_reserve%TYPE;
141: l_operating_acct_backlog igi_iac_asset_balances.backlog_deprn_reserve%TYPE;
142: l_dpis_period_info igi_iac_types.prd_rec;

Line 139: l_current_backlog igi_iac_asset_balances.backlog_deprn_reserve%TYPE;

135: AND ith.adjustment_status IN ('COMPLETE','RUN'));
136:
137: l_get_curr_reval_rate igi_iac_revaluation_rates%ROWTYPE;
138: l_cumulative_backlog igi_iac_asset_balances.backlog_deprn_reserve%TYPE;
139: l_current_backlog igi_iac_asset_balances.backlog_deprn_reserve%TYPE;
140: l_Reval_rsv_backlog igi_iac_asset_balances.backlog_deprn_reserve%TYPE;
141: l_operating_acct_backlog igi_iac_asset_balances.backlog_deprn_reserve%TYPE;
142: l_dpis_period_info igi_iac_types.prd_rec;
143: l_period_info igi_iac_types.prd_rec;

Line 140: l_Reval_rsv_backlog igi_iac_asset_balances.backlog_deprn_reserve%TYPE;

136:
137: l_get_curr_reval_rate igi_iac_revaluation_rates%ROWTYPE;
138: l_cumulative_backlog igi_iac_asset_balances.backlog_deprn_reserve%TYPE;
139: l_current_backlog igi_iac_asset_balances.backlog_deprn_reserve%TYPE;
140: l_Reval_rsv_backlog igi_iac_asset_balances.backlog_deprn_reserve%TYPE;
141: l_operating_acct_backlog igi_iac_asset_balances.backlog_deprn_reserve%TYPE;
142: l_dpis_period_info igi_iac_types.prd_rec;
143: l_period_info igi_iac_types.prd_rec;
144: l_latest_reval_period_info igi_iac_types.prd_rec;

Line 141: l_operating_acct_backlog igi_iac_asset_balances.backlog_deprn_reserve%TYPE;

137: l_get_curr_reval_rate igi_iac_revaluation_rates%ROWTYPE;
138: l_cumulative_backlog igi_iac_asset_balances.backlog_deprn_reserve%TYPE;
139: l_current_backlog igi_iac_asset_balances.backlog_deprn_reserve%TYPE;
140: l_Reval_rsv_backlog igi_iac_asset_balances.backlog_deprn_reserve%TYPE;
141: l_operating_acct_backlog igi_iac_asset_balances.backlog_deprn_reserve%TYPE;
142: l_dpis_period_info igi_iac_types.prd_rec;
143: l_period_info igi_iac_types.prd_rec;
144: l_latest_reval_period_info igi_iac_types.prd_rec;
145: l_dpis_price_index Number;

Line 482: CURSOR c_get_asset_balance (p_asset_id igi_iac_asset_balances.asset_id%TYPE,

478: p_event_id number) --R12 uptake
479: RETURN BOOLEAN
480: IS
481:
482: CURSOR c_get_asset_balance (p_asset_id igi_iac_asset_balances.asset_id%TYPE,
483: P_book_type_code igi_iac_asset_balances.book_type_code%TYPE
484: ) IS
485: SELECT *
486: FROM igi_iac_asset_balances

Line 483: P_book_type_code igi_iac_asset_balances.book_type_code%TYPE

479: RETURN BOOLEAN
480: IS
481:
482: CURSOR c_get_asset_balance (p_asset_id igi_iac_asset_balances.asset_id%TYPE,
483: P_book_type_code igi_iac_asset_balances.book_type_code%TYPE
484: ) IS
485: SELECT *
486: FROM igi_iac_asset_balances
487: WHERE asset_id = p_asset_id

Line 486: FROM igi_iac_asset_balances

482: CURSOR c_get_asset_balance (p_asset_id igi_iac_asset_balances.asset_id%TYPE,
483: P_book_type_code igi_iac_asset_balances.book_type_code%TYPE
484: ) IS
485: SELECT *
486: FROM igi_iac_asset_balances
487: WHERE asset_id = p_asset_id
488: AND book_type_code = p_book_type_code
489: AND period_counter = (SELECT MAX(period_counter)
490: FROM igi_iac_asset_balances

Line 490: FROM igi_iac_asset_balances

486: FROM igi_iac_asset_balances
487: WHERE asset_id = p_asset_id
488: AND book_type_code = p_book_type_code
489: AND period_counter = (SELECT MAX(period_counter)
490: FROM igi_iac_asset_balances
491: WHERE asset_id = p_asset_id
492: AND book_type_code = p_book_type_code);
493:
494: /* Cursor to get balance information for each distribution of asset */

Line 496: P_book_type_code igi_iac_asset_balances.book_type_code%TYPE,

492: AND book_type_code = p_book_type_code);
493:
494: /* Cursor to get balance information for each distribution of asset */
495: CURSOR c_get_inactive_det_balances(p_asset_id igi_iac_det_balances.asset_id%TYPE,
496: P_book_type_code igi_iac_asset_balances.book_type_code%TYPE,
497: p_prev_adjustment_id igi_iac_det_balances.adjustment_id%TYPE) IS
498: SELECT *
499: FROM igi_iac_det_balances
500: WHERE asset_id = p_asset_id

Line 505: CURSOR C_get_iac_fa_deprn(P_book_type_code igi_iac_asset_balances.book_type_code%TYPE,

501: AND book_type_code = p_book_type_code
502: AND adjustment_id = p_prev_adjustment_id
503: AND NVL(active_flag,'Y') = 'N' ;
504:
505: CURSOR C_get_iac_fa_deprn(P_book_type_code igi_iac_asset_balances.book_type_code%TYPE,
506: p_asset_id igi_iac_det_balances.asset_id%TYPE ,
507: P_distribution_id igi_iac_det_balances.distribution_id%TYPE
508: , p_prev_adjustment_id igi_iac_det_balances.adjustment_id%TYPE) IS
509:

Line 539: l_prev_asset_balance igi_iac_asset_balances%ROWTYPE;

535: AND idb.asset_id = cp_asset_id
536: AND idb.distribution_id = fdh.distribution_id
537: AND idb.adjustment_id = cp_adjustment_id;
538:
539: l_prev_asset_balance igi_iac_asset_balances%ROWTYPE;
540: l_asset_balance_mvmt igi_iac_asset_balances%ROWTYPE;
541: l_curr_asset_balance igi_iac_asset_balances%ROWTYPE;
542: l_det_balances igi_iac_det_balances%ROWTYPE;
543: l_get_iac_fa_deprn C_get_iac_fa_deprn%ROWTYPE;

Line 540: l_asset_balance_mvmt igi_iac_asset_balances%ROWTYPE;

536: AND idb.distribution_id = fdh.distribution_id
537: AND idb.adjustment_id = cp_adjustment_id;
538:
539: l_prev_asset_balance igi_iac_asset_balances%ROWTYPE;
540: l_asset_balance_mvmt igi_iac_asset_balances%ROWTYPE;
541: l_curr_asset_balance igi_iac_asset_balances%ROWTYPE;
542: l_det_balances igi_iac_det_balances%ROWTYPE;
543: l_get_iac_fa_deprn C_get_iac_fa_deprn%ROWTYPE;
544: l_adjustment_id igi_iac_adjustments.adjustment_id%TYPE;

Line 541: l_curr_asset_balance igi_iac_asset_balances%ROWTYPE;

537: AND idb.adjustment_id = cp_adjustment_id;
538:
539: l_prev_asset_balance igi_iac_asset_balances%ROWTYPE;
540: l_asset_balance_mvmt igi_iac_asset_balances%ROWTYPE;
541: l_curr_asset_balance igi_iac_asset_balances%ROWTYPE;
542: l_det_balances igi_iac_det_balances%ROWTYPE;
543: l_get_iac_fa_deprn C_get_iac_fa_deprn%ROWTYPE;
544: l_adjustment_id igi_iac_adjustments.adjustment_id%TYPE;
545: l_adjustment_id_out igi_iac_adjustments.adjustment_id%TYPE;

Line 1765: IGI_IAC_ASSET_BALANCES_PKG.update_row (

1761: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1762: p_full_path => l_path_name,
1763: p_string => ' Cumulative Reval Factor :'||TO_CHAR(l_curr_asset_balance.Cumulative_reval_factor));
1764:
1765: IGI_IAC_ASSET_BALANCES_PKG.update_row (
1766: x_asset_id => l_curr_asset_balance.asset_id,
1767: x_book_type_code => l_curr_asset_balance.book_type_code,
1768: x_period_counter => l_asset_balance_mvmt.period_counter,
1769: x_net_book_value => l_curr_asset_balance.net_book_value,