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_REVALUATIONS

Line 349: l_revaluation_id igi_iac_revaluations.revaluation_id%TYPE;

345: l_fa_asset_info igi_iac_types.iac_reval_fa_asset_info_tab;
346: l_reval_params igi_iac_types.iac_reval_params;
347: l_reval_asset igi_iac_types.iac_reval_input_asset;
348: l_reval_asset_out igi_iac_types.iac_reval_output_asset;
349: l_revaluation_id igi_iac_revaluations.revaluation_id%TYPE;
350: l_user_id NUMBER DEFAULT fnd_global.user_id;
351: l_login_id NUMBER DEFAULT fnd_global.login_id;
352: l_current_reval_factor igi_iac_asset_balances.current_reval_factor%TYPE;
353: l_cumulative_reval_factor igi_iac_asset_balances.cumulative_reval_factor%TYPE;

Line 739: p_string => ' Last Revaluation - Inserting into igi_iac_revaluations');

735: /* Last revaluation - Insert records into revaluation tables*/
736: IF (p_calling_function <> 'UPGRADE') THEN
737: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
738: p_full_path => l_path_name,
739: p_string => ' Last Revaluation - Inserting into igi_iac_revaluations');
740:
741: l_rowid := NULL;
742: l_revaluation_id := NULL;
743:

Line 744: igi_iac_revaluations_pkg.insert_row

740:
741: l_rowid := NULL;
742: l_revaluation_id := NULL;
743:
744: igi_iac_revaluations_pkg.insert_row
745: (l_rowid,
746: l_revaluation_id,
747: p_book_type_code,
748: sysdate,

Line 952: FROM igi_iac_revaluations r,igi_iac_reval_asset_rules a

948: /* Bug 2425914 vgadde 21/06/2002 */
949: /* Modified query to fecth records created by ADDITION only */
950: CURSOR c_get_revaluation_info(p_asset_id igi_iac_det_balances.asset_id%TYPE) IS
951: SELECT a.revaluation_id
952: FROM igi_iac_revaluations r,igi_iac_reval_asset_rules a
953: WHERE a.revaluation_id = r.revaluation_id
954: AND a.book_type_code = p_book_type_code
955: AND a.asset_id = p_asset_id
956: AND r.calling_program = 'ADDITION';

Line 991: l_revaluation_id igi_iac_revaluations.revaluation_id%TYPE;

987: WHERE book_type_code = p_book_type_code
988: AND asset_id = cp_asset_id
989: AND adjustment_id = cp_adjustment_id;
990:
991: l_revaluation_id igi_iac_revaluations.revaluation_id%TYPE;
992: l_dummy VARCHAR2(1);
993: l_path_name VARCHAR2(150) := g_path||'do_rollback_addition';
994:
995: BEGIN

Line 1125: /* Delete records from igi_iac_revaluations */

1121: x_asset_id => l_asset_info.asset_id,
1122: x_book_type_code => p_book_type_code,
1123: x_revaluation_id => l_revaluation_id);
1124:
1125: /* Delete records from igi_iac_revaluations */
1126: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1127: p_full_path => l_path_name,
1128: p_string => ' Deleting records from igi_iac_revaluations');
1129: igi_iac_revaluations_pkg.delete_row(

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

1124:
1125: /* Delete records from igi_iac_revaluations */
1126: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1127: p_full_path => l_path_name,
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 */

Line 1129: igi_iac_revaluations_pkg.delete_row(

1125: /* Delete records from igi_iac_revaluations */
1126: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1127: p_full_path => l_path_name,
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);