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 835: UPDATE igi_iac_revaluation_rates

831: p_string => ' Last revaluation period :'||to_char(l_last_reval_period));
832: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
833: p_full_path => l_path_name,
834: p_string => ' Revaluation Id :'||to_char(l_revaluation_id));
835: UPDATE igi_iac_revaluation_rates
836: SET period_counter = l_last_reval_period
837: WHERE revaluation_id = l_revaluation_id
838: AND asset_id = p_asset_id
839: AND book_type_code = p_book_type_code;

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

971: WHERE book_type_code = p_book_type_code
972: AND asset_id = p_asset_id
973: AND period_counter = cp_period_counter;
974:
975: CURSOR c_get_revaluation_rates(p_asset_id igi_iac_revaluation_rates.asset_id%TYPE,
976: p_revaluation_id igi_iac_revaluation_rates.revaluation_id%TYPE) IS
977: SELECT 'X'
978: FROM igi_iac_revaluation_rates
979: WHERE asset_id = p_asset_id

Line 976: p_revaluation_id igi_iac_revaluation_rates.revaluation_id%TYPE) IS

972: AND asset_id = p_asset_id
973: AND period_counter = cp_period_counter;
974:
975: CURSOR c_get_revaluation_rates(p_asset_id igi_iac_revaluation_rates.asset_id%TYPE,
976: p_revaluation_id igi_iac_revaluation_rates.revaluation_id%TYPE) IS
977: SELECT 'X'
978: FROM igi_iac_revaluation_rates
979: WHERE asset_id = p_asset_id
980: AND book_type_code = p_book_type_code

Line 978: FROM igi_iac_revaluation_rates

974:
975: CURSOR c_get_revaluation_rates(p_asset_id igi_iac_revaluation_rates.asset_id%TYPE,
976: p_revaluation_id igi_iac_revaluation_rates.revaluation_id%TYPE) IS
977: SELECT 'X'
978: FROM igi_iac_revaluation_rates
979: WHERE asset_id = p_asset_id
980: AND book_type_code = p_book_type_code
981: AND revaluation_id = p_revaluation_id;
982:

Line 1132: /* Delete records from igi_iac_revaluation_rates */

1128: p_string => ' Deleting records from igi_iac_revaluations');
1129: igi_iac_revaluations_pkg.delete_row(
1130: x_revaluation_id => l_revaluation_id);
1131:
1132: /* Delete records from igi_iac_revaluation_rates */
1133: OPEN c_get_revaluation_rates(l_asset_info.asset_id,l_revaluation_id);
1134: FETCH c_get_revaluation_rates INTO l_dummy;
1135:
1136: IF c_get_revaluation_rates%FOUND THEN

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

1135:
1136: IF c_get_revaluation_rates%FOUND THEN
1137: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1138: p_full_path => l_path_name,
1139: p_string => ' Deleting records from igi_iac_revaluation_rates');
1140: DELETE FROM igi_iac_revaluation_rates
1141: WHERE asset_id = l_asset_info.asset_id
1142: AND book_type_code = p_book_type_code
1143: AND revaluation_id = l_revaluation_id;

Line 1140: DELETE FROM igi_iac_revaluation_rates

1136: IF c_get_revaluation_rates%FOUND THEN
1137: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1138: p_full_path => l_path_name,
1139: p_string => ' Deleting records from igi_iac_revaluation_rates');
1140: DELETE FROM igi_iac_revaluation_rates
1141: WHERE asset_id = l_asset_info.asset_id
1142: AND book_type_code = p_book_type_code
1143: AND revaluation_id = l_revaluation_id;
1144: END IF;