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_ROLLBACK_DEPRN_PKG dependencies on IGI_IAC_REVALUATION_RATES

Line 74: CURSOR c_get_revaluation_rates(p_asset_id igi_iac_revaluation_rates.asset_id%TYPE,

70: FROM igi_iac_asset_balances
71: WHERE book_type_code = p_book_type_code
72: AND asset_id = p_asset_id
73: AND period_counter = cp_period_counter;
74: CURSOR c_get_revaluation_rates(p_asset_id igi_iac_revaluation_rates.asset_id%TYPE,
75: p_revaluation_id igi_iac_revaluation_rates.revaluation_id%TYPE) IS
76: SELECT 'X'
77: FROM igi_iac_revaluation_rates
78: WHERE asset_id = p_asset_id

Line 75: p_revaluation_id igi_iac_revaluation_rates.revaluation_id%TYPE) IS

71: WHERE book_type_code = p_book_type_code
72: AND asset_id = p_asset_id
73: AND period_counter = cp_period_counter;
74: CURSOR c_get_revaluation_rates(p_asset_id igi_iac_revaluation_rates.asset_id%TYPE,
75: p_revaluation_id igi_iac_revaluation_rates.revaluation_id%TYPE) IS
76: SELECT 'X'
77: FROM igi_iac_revaluation_rates
78: WHERE asset_id = p_asset_id
79: AND book_type_code = p_book_type_code

Line 77: FROM igi_iac_revaluation_rates

73: AND period_counter = cp_period_counter;
74: CURSOR c_get_revaluation_rates(p_asset_id igi_iac_revaluation_rates.asset_id%TYPE,
75: p_revaluation_id igi_iac_revaluation_rates.revaluation_id%TYPE) IS
76: SELECT 'X'
77: FROM igi_iac_revaluation_rates
78: WHERE asset_id = p_asset_id
79: AND book_type_code = p_book_type_code
80: AND revaluation_id = p_revaluation_id;
81: CURSOR c_get_fa_distributions(cp_asset_id igi_iac_det_balances.asset_id%TYPE,

Line 211: /* Delete records from igi_iac_revaluation_rates */

207: p_full_path => l_path_name,
208: p_string => ' Deleting records from igi_iac_revaluations');
209: igi_iac_revaluations_pkg.delete_row(
210: x_revaluation_id => l_revaluation_id);
211: /* Delete records from igi_iac_revaluation_rates */
212: OPEN c_get_revaluation_rates(l_asset_info.asset_id,l_revaluation_id);
213: FETCH c_get_revaluation_rates INTO l_dummy;
214: IF c_get_revaluation_rates%FOUND THEN
215: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

Line 217: p_string => ' Deleting records from igi_iac_revaluation_rates');

213: FETCH c_get_revaluation_rates INTO l_dummy;
214: IF c_get_revaluation_rates%FOUND THEN
215: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
216: p_full_path => l_path_name,
217: p_string => ' Deleting records from igi_iac_revaluation_rates');
218: DELETE FROM igi_iac_revaluation_rates
219: WHERE asset_id = l_asset_info.asset_id
220: AND book_type_code = p_book_type_code
221: AND revaluation_id = l_revaluation_id;

Line 218: DELETE FROM igi_iac_revaluation_rates

214: IF c_get_revaluation_rates%FOUND THEN
215: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
216: p_full_path => l_path_name,
217: p_string => ' Deleting records from igi_iac_revaluation_rates');
218: DELETE FROM igi_iac_revaluation_rates
219: WHERE asset_id = l_asset_info.asset_id
220: AND book_type_code = p_book_type_code
221: AND revaluation_id = l_revaluation_id;
222: END IF;