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_ASSET_BALANCES

Line 352: l_current_reval_factor igi_iac_asset_balances.current_reval_factor%TYPE;

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;
354: l_last_reval_period igi_iac_asset_balances.period_counter%TYPE;
355: l_rowid VARCHAR2(25);
356: l_deprn_acc fa_deprn_summary.deprn_reserve%TYPE;

Line 353: l_cumulative_reval_factor igi_iac_asset_balances.cumulative_reval_factor%TYPE;

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;
354: l_last_reval_period igi_iac_asset_balances.period_counter%TYPE;
355: l_rowid VARCHAR2(25);
356: l_deprn_acc fa_deprn_summary.deprn_reserve%TYPE;
357: l_get_latest_adjustment_id number;

Line 354: l_last_reval_period igi_iac_asset_balances.period_counter%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;
354: l_last_reval_period igi_iac_asset_balances.period_counter%TYPE;
355: l_rowid VARCHAR2(25);
356: l_deprn_acc fa_deprn_summary.deprn_reserve%TYPE;
357: l_get_latest_adjustment_id number;
358: l_asset_type fa_additions.asset_type%TYPE; -- bug 11852403

Line 967: CURSOR c_get_asset_balances(p_asset_id igi_iac_asset_balances.asset_id%TYPE,

963: AND book_type_code = p_book_type_code
964: AND asset_id = p_asset_id
965: AND rownum = 1;
966:
967: CURSOR c_get_asset_balances(p_asset_id igi_iac_asset_balances.asset_id%TYPE,
968: cp_period_counter igi_iac_asset_balances.period_counter%TYPE) IS
969: SELECT 'X'
970: FROM igi_iac_asset_balances
971: WHERE book_type_code = p_book_type_code

Line 968: cp_period_counter igi_iac_asset_balances.period_counter%TYPE) IS

964: AND asset_id = p_asset_id
965: AND rownum = 1;
966:
967: CURSOR c_get_asset_balances(p_asset_id igi_iac_asset_balances.asset_id%TYPE,
968: cp_period_counter igi_iac_asset_balances.period_counter%TYPE) IS
969: SELECT 'X'
970: FROM igi_iac_asset_balances
971: WHERE book_type_code = p_book_type_code
972: AND asset_id = p_asset_id

Line 970: FROM igi_iac_asset_balances

966:
967: CURSOR c_get_asset_balances(p_asset_id igi_iac_asset_balances.asset_id%TYPE,
968: cp_period_counter igi_iac_asset_balances.period_counter%TYPE) IS
969: SELECT 'X'
970: FROM igi_iac_asset_balances
971: WHERE book_type_code = p_book_type_code
972: AND asset_id = p_asset_id
973: AND period_counter = cp_period_counter;
974:

Line 1057: /* Delete records from igi_iac_asset_balances */

1053: x_adjustment_id => l_asset_info.adjustment_id,
1054: x_distribution_id => l_iac_fa_det_balance.distribution_id);
1055: END LOOP;
1056:
1057: /* Delete records from igi_iac_asset_balances */
1058: IF l_asset_info.transaction_sub_type <> 'CATCHUP' THEN
1059:
1060: OPEN c_get_asset_balances(l_asset_info.asset_id,p_period_counter);
1061: FETCH c_get_asset_balances INTO l_dummy;

Line 1066: p_string => ' Deleting records from igi_iac_asset_balances for current period');

1062:
1063: IF c_get_asset_balances%FOUND THEN
1064: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1065: p_full_path => l_path_name,
1066: p_string => ' Deleting records from igi_iac_asset_balances for current period');
1067: igi_iac_asset_balances_pkg.delete_row(
1068: x_asset_id => l_asset_info.asset_id,
1069: x_book_type_code => p_book_type_code,
1070: x_period_counter => p_period_counter);

Line 1067: igi_iac_asset_balances_pkg.delete_row(

1063: IF c_get_asset_balances%FOUND THEN
1064: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1065: p_full_path => l_path_name,
1066: p_string => ' Deleting records from igi_iac_asset_balances for current period');
1067: igi_iac_asset_balances_pkg.delete_row(
1068: x_asset_id => l_asset_info.asset_id,
1069: x_book_type_code => p_book_type_code,
1070: x_period_counter => p_period_counter);
1071: ELSIF c_get_asset_balances%NOTFOUND THEN

Line 1074: p_string => ' No records found in igi_iac_asset_balances to delete');

1070: x_period_counter => p_period_counter);
1071: ELSIF c_get_asset_balances%NOTFOUND THEN
1072: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1073: p_full_path => l_path_name,
1074: p_string => ' No records found in igi_iac_asset_balances to delete');
1075: END IF;
1076:
1077: CLOSE c_get_asset_balances;
1078:

Line 1084: p_string => ' Deleting records from igi_iac_asset_balances for next period');

1080: FETCH c_get_asset_balances INTO l_dummy;
1081: IF c_get_asset_balances%FOUND THEN
1082: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1083: p_full_path => l_path_name,
1084: p_string => ' Deleting records from igi_iac_asset_balances for next period');
1085: igi_iac_asset_balances_pkg.delete_row(
1086: x_asset_id => l_asset_info.asset_id,
1087: x_book_type_code => p_book_type_code,
1088: x_period_counter => p_period_counter+1);

Line 1085: igi_iac_asset_balances_pkg.delete_row(

1081: IF c_get_asset_balances%FOUND THEN
1082: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1083: p_full_path => l_path_name,
1084: p_string => ' Deleting records from igi_iac_asset_balances for next period');
1085: igi_iac_asset_balances_pkg.delete_row(
1086: x_asset_id => l_asset_info.asset_id,
1087: x_book_type_code => p_book_type_code,
1088: x_period_counter => p_period_counter+1);
1089: ELSE

Line 1092: p_string => ' No records found in igi_iac_asset_balances to delete');

1088: x_period_counter => p_period_counter+1);
1089: ELSE
1090: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1091: p_full_path => l_path_name,
1092: p_string => ' No records found in igi_iac_asset_balances to delete');
1093: END IF;
1094: CLOSE c_get_asset_balances; -- Bug 2417394 this cursor was not gettign closed previously
1095: END IF;
1096: