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_ASSET_BALANCES

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

63: WHERE adjustment_id = p_adjustment_id
64: AND book_type_code = p_book_type_code
65: AND asset_id = p_asset_id
66: AND rownum = 1;
67: CURSOR c_get_asset_balances(p_asset_id igi_iac_asset_balances.asset_id%TYPE,
68: cp_period_counter igi_iac_asset_balances.period_counter%TYPE) IS
69: SELECT 'X'
70: FROM igi_iac_asset_balances
71: WHERE book_type_code = p_book_type_code

Line 68: cp_period_counter igi_iac_asset_balances.period_counter%TYPE) IS

64: AND book_type_code = p_book_type_code
65: AND asset_id = p_asset_id
66: AND rownum = 1;
67: CURSOR c_get_asset_balances(p_asset_id igi_iac_asset_balances.asset_id%TYPE,
68: cp_period_counter igi_iac_asset_balances.period_counter%TYPE) IS
69: SELECT 'X'
70: FROM igi_iac_asset_balances
71: WHERE book_type_code = p_book_type_code
72: AND asset_id = p_asset_id

Line 70: FROM igi_iac_asset_balances

66: AND rownum = 1;
67: CURSOR c_get_asset_balances(p_asset_id igi_iac_asset_balances.asset_id%TYPE,
68: cp_period_counter igi_iac_asset_balances.period_counter%TYPE) IS
69: SELECT 'X'
70: FROM igi_iac_asset_balances
71: WHERE book_type_code = p_book_type_code
72: AND asset_id = p_asset_id
73: AND period_counter = cp_period_counter;
74: CURSOR c_get_revaluation_rates(p_asset_id igi_iac_revaluation_rates.asset_id%TYPE,

Line 147: /* Delete records from igi_iac_asset_balances */

143: x_period_counter => p_period_counter,
144: x_adjustment_id => l_asset_info.adjustment_id,
145: x_distribution_id => l_iac_fa_det_balance.distribution_id);
146: END LOOP;
147: /* Delete records from igi_iac_asset_balances */
148: IF l_asset_info.transaction_sub_type <> 'CATCHUP' THEN
149: OPEN c_get_asset_balances(l_asset_info.asset_id,p_period_counter);
150: FETCH c_get_asset_balances INTO l_dummy;
151: IF c_get_asset_balances%FOUND THEN

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

150: FETCH c_get_asset_balances INTO l_dummy;
151: IF c_get_asset_balances%FOUND THEN
152: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
153: p_full_path => l_path_name,
154: p_string => ' Deleting records from igi_iac_asset_balances for current period');
155: igi_iac_asset_balances_pkg.delete_row(
156: x_asset_id => l_asset_info.asset_id,
157: x_book_type_code => p_book_type_code,
158: x_period_counter => p_period_counter);

Line 155: igi_iac_asset_balances_pkg.delete_row(

151: IF c_get_asset_balances%FOUND THEN
152: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
153: p_full_path => l_path_name,
154: p_string => ' Deleting records from igi_iac_asset_balances for current period');
155: igi_iac_asset_balances_pkg.delete_row(
156: x_asset_id => l_asset_info.asset_id,
157: x_book_type_code => p_book_type_code,
158: x_period_counter => p_period_counter);
159: ELSIF c_get_asset_balances%NOTFOUND THEN

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

158: x_period_counter => p_period_counter);
159: ELSIF c_get_asset_balances%NOTFOUND THEN
160: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
161: p_full_path => l_path_name,
162: p_string => ' No records found in igi_iac_asset_balances to delete');
163: END IF;
164: CLOSE c_get_asset_balances;
165: OPEN c_get_asset_balances(l_asset_info.asset_id, p_period_counter+1);
166: FETCH c_get_asset_balances INTO l_dummy;

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

166: FETCH c_get_asset_balances INTO l_dummy;
167: IF c_get_asset_balances%FOUND THEN
168: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
169: p_full_path => l_path_name,
170: p_string => ' Deleting records from igi_iac_asset_balances for next period');
171: igi_iac_asset_balances_pkg.delete_row(
172: x_asset_id => l_asset_info.asset_id,
173: x_book_type_code => p_book_type_code,
174: x_period_counter => p_period_counter+1);

Line 171: igi_iac_asset_balances_pkg.delete_row(

167: IF c_get_asset_balances%FOUND THEN
168: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
169: p_full_path => l_path_name,
170: p_string => ' Deleting records from igi_iac_asset_balances for next period');
171: igi_iac_asset_balances_pkg.delete_row(
172: x_asset_id => l_asset_info.asset_id,
173: x_book_type_code => p_book_type_code,
174: x_period_counter => p_period_counter+1);
175: ELSE

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

174: x_period_counter => p_period_counter+1);
175: ELSE
176: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
177: p_full_path => l_path_name,
178: p_string => ' No records found in igi_iac_asset_balances to delete');
179: END IF;
180: CLOSE c_get_asset_balances; -- Bug 2417394 this cursor was not gettign closed previously
181: END IF;
182: /* Delete records from igi_iac_transaction_headers */

Line 270: CURSOR c_amounts(c_period_counter in IGI_IAC_ASSET_BALANCES.period_counter%type,

266:
267: /* Cursor to find the amounts that need to be transferred to the new dist
268: created by transfer */
269:
270: CURSOR c_amounts(c_period_counter in IGI_IAC_ASSET_BALANCES.period_counter%type,
271: cp_asset_id IGI_IAC_ASSET_BALANCES.asset_id%TYPE) IS
272: SELECT *
273: FROM igi_iac_asset_balances
274: WHERE asset_id = cp_asset_id

Line 271: cp_asset_id IGI_IAC_ASSET_BALANCES.asset_id%TYPE) IS

267: /* Cursor to find the amounts that need to be transferred to the new dist
268: created by transfer */
269:
270: CURSOR c_amounts(c_period_counter in IGI_IAC_ASSET_BALANCES.period_counter%type,
271: cp_asset_id IGI_IAC_ASSET_BALANCES.asset_id%TYPE) IS
272: SELECT *
273: FROM igi_iac_asset_balances
274: WHERE asset_id = cp_asset_id
275: AND book_type_code = p_book_type_code

Line 273: FROM igi_iac_asset_balances

269:
270: CURSOR c_amounts(c_period_counter in IGI_IAC_ASSET_BALANCES.period_counter%type,
271: cp_asset_id IGI_IAC_ASSET_BALANCES.asset_id%TYPE) IS
272: SELECT *
273: FROM igi_iac_asset_balances
274: WHERE asset_id = cp_asset_id
275: AND book_type_code = p_book_type_code
276: AND period_counter = p_period_counter;
277:

Line 402: IGI_IAC_ASSET_BALANCES_PKG.update_row (

398: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
399: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Updating Asset balances ...');
400: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
401:
402: IGI_IAC_ASSET_BALANCES_PKG.update_row (
403: x_asset_id =>l_trans_headers.asset_id,
404: x_book_type_code =>p_book_type_code,
405: x_period_counter =>p_period_counter,
406: x_net_book_value =>l_amounts.net_book_value,