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_REVALUATIONS

Line 54: FROM igi_iac_revaluations r,igi_iac_reval_asset_rules a

50: /* Bug 2425914 vgadde 21/06/2002 */
51: /* Modified query to fecth records created by ADDITION only */
52: CURSOR c_get_revaluation_info(p_asset_id igi_iac_det_balances.asset_id%TYPE) IS
53: SELECT a.revaluation_id
54: FROM igi_iac_revaluations r,igi_iac_reval_asset_rules a
55: WHERE a.revaluation_id = r.revaluation_id
56: AND a.book_type_code = p_book_type_code
57: AND a.asset_id = p_asset_id
58: AND r.calling_program = 'ADDITION';

Line 88: l_revaluation_id igi_iac_revaluations.revaluation_id%TYPE;

84: FROM igi_iac_fa_deprn
85: WHERE book_type_code = p_book_type_code
86: AND asset_id = cp_asset_id
87: AND adjustment_id = cp_adjustment_id;
88: l_revaluation_id igi_iac_revaluations.revaluation_id%TYPE;
89: l_dummy VARCHAR2(1);
90: l_path_name VARCHAR2(150) := g_path||'do_rollback_addition';
91: BEGIN
92: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

Line 205: /* Delete records from igi_iac_revaluations */

201: igi_iac_reval_asset_rules_pkg.delete_row(
202: x_asset_id => l_asset_info.asset_id,
203: x_book_type_code => p_book_type_code,
204: x_revaluation_id => l_revaluation_id);
205: /* Delete records from igi_iac_revaluations */
206: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
207: p_full_path => l_path_name,
208: p_string => ' Deleting records from igi_iac_revaluations');
209: igi_iac_revaluations_pkg.delete_row(

Line 208: p_string => ' Deleting records from igi_iac_revaluations');

204: x_revaluation_id => l_revaluation_id);
205: /* Delete records from igi_iac_revaluations */
206: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
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);

Line 209: igi_iac_revaluations_pkg.delete_row(

205: /* Delete records from igi_iac_revaluations */
206: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
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;