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

Line 818: UPDATE igi_iac_revaluation_rates

814: p_string => ' Last revaluation period :'||to_char(l_last_reval_period));
815: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
816: p_full_path => l_path_name,
817: p_string => ' Revaluation Id :'||to_char(l_revaluation_id));
818: UPDATE igi_iac_revaluation_rates
819: SET period_counter = l_last_reval_period
820: WHERE revaluation_id = l_revaluation_id
821: AND asset_id = p_asset_id
822: AND book_type_code = p_book_type_code;

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

954: WHERE book_type_code = p_book_type_code
955: AND asset_id = p_asset_id
956: AND period_counter = cp_period_counter;
957:
958: CURSOR c_get_revaluation_rates(p_asset_id igi_iac_revaluation_rates.asset_id%TYPE,
959: p_revaluation_id igi_iac_revaluation_rates.revaluation_id%TYPE) IS
960: SELECT 'X'
961: FROM igi_iac_revaluation_rates
962: WHERE asset_id = p_asset_id

Line 959: p_revaluation_id igi_iac_revaluation_rates.revaluation_id%TYPE) IS

955: AND asset_id = p_asset_id
956: AND period_counter = cp_period_counter;
957:
958: CURSOR c_get_revaluation_rates(p_asset_id igi_iac_revaluation_rates.asset_id%TYPE,
959: p_revaluation_id igi_iac_revaluation_rates.revaluation_id%TYPE) IS
960: SELECT 'X'
961: FROM igi_iac_revaluation_rates
962: WHERE asset_id = p_asset_id
963: AND book_type_code = p_book_type_code

Line 961: FROM igi_iac_revaluation_rates

957:
958: CURSOR c_get_revaluation_rates(p_asset_id igi_iac_revaluation_rates.asset_id%TYPE,
959: p_revaluation_id igi_iac_revaluation_rates.revaluation_id%TYPE) IS
960: SELECT 'X'
961: FROM igi_iac_revaluation_rates
962: WHERE asset_id = p_asset_id
963: AND book_type_code = p_book_type_code
964: AND revaluation_id = p_revaluation_id;
965:

Line 1115: /* Delete records from igi_iac_revaluation_rates */

1111: p_string => ' Deleting records from igi_iac_revaluations');
1112: igi_iac_revaluations_pkg.delete_row(
1113: x_revaluation_id => l_revaluation_id);
1114:
1115: /* Delete records from igi_iac_revaluation_rates */
1116: OPEN c_get_revaluation_rates(l_asset_info.asset_id,l_revaluation_id);
1117: FETCH c_get_revaluation_rates INTO l_dummy;
1118:
1119: IF c_get_revaluation_rates%FOUND THEN

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

1118:
1119: IF c_get_revaluation_rates%FOUND THEN
1120: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1121: p_full_path => l_path_name,
1122: p_string => ' Deleting records from igi_iac_revaluation_rates');
1123: DELETE FROM igi_iac_revaluation_rates
1124: WHERE asset_id = l_asset_info.asset_id
1125: AND book_type_code = p_book_type_code
1126: AND revaluation_id = l_revaluation_id;

Line 1123: DELETE FROM igi_iac_revaluation_rates

1119: IF c_get_revaluation_rates%FOUND THEN
1120: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1121: p_full_path => l_path_name,
1122: p_string => ' Deleting records from igi_iac_revaluation_rates');
1123: DELETE FROM igi_iac_revaluation_rates
1124: WHERE asset_id = l_asset_info.asset_id
1125: AND book_type_code = p_book_type_code
1126: AND revaluation_id = l_revaluation_id;
1127: END IF;