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_ADJUSTMENTS

Line 59: CURSOR c_get_adjustments(p_asset_id igi_iac_adjustments.asset_id%TYPE,

55: WHERE a.revaluation_id = r.revaluation_id
56: AND a.book_type_code = p_book_type_code
57: AND a.asset_id = p_asset_id
58: AND r.calling_program = 'ADDITION';
59: CURSOR c_get_adjustments(p_asset_id igi_iac_adjustments.asset_id%TYPE,
60: p_adjustment_id igi_iac_adjustments.adjustment_id%TYPE) IS
61: SELECT 'X'
62: FROM igi_iac_adjustments
63: WHERE adjustment_id = p_adjustment_id

Line 60: p_adjustment_id igi_iac_adjustments.adjustment_id%TYPE) IS

56: AND a.book_type_code = p_book_type_code
57: AND a.asset_id = p_asset_id
58: AND r.calling_program = 'ADDITION';
59: CURSOR c_get_adjustments(p_asset_id igi_iac_adjustments.asset_id%TYPE,
60: p_adjustment_id igi_iac_adjustments.adjustment_id%TYPE) IS
61: SELECT 'X'
62: FROM igi_iac_adjustments
63: WHERE adjustment_id = p_adjustment_id
64: AND book_type_code = p_book_type_code

Line 62: FROM igi_iac_adjustments

58: AND r.calling_program = 'ADDITION';
59: CURSOR c_get_adjustments(p_asset_id igi_iac_adjustments.asset_id%TYPE,
60: p_adjustment_id igi_iac_adjustments.adjustment_id%TYPE) IS
61: SELECT 'X'
62: FROM igi_iac_adjustments
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;

Line 105: /* Delete records from igi_iac_adjustments */

101: p_string => ' Adjustment :'||to_char(l_asset_info.adjustment_id));
102: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
103: p_full_path => l_path_name,
104: p_string => ' Transaction :'||l_asset_info.transaction_sub_type);
105: /* Delete records from igi_iac_adjustments */
106: l_dummy := NULL;
107: OPEN c_get_adjustments(l_asset_info.asset_id,l_asset_info.adjustment_id);
108: FETCH c_get_adjustments INTO l_dummy;
109: IF c_get_adjustments%FOUND THEN

Line 112: p_string => ' Deleting records from igi_iac_adjustments');

108: FETCH c_get_adjustments INTO l_dummy;
109: IF c_get_adjustments%FOUND THEN
110: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
111: p_full_path => l_path_name,
112: p_string => ' Deleting records from igi_iac_adjustments');
113: igi_iac_adjustments_pkg.delete_row(
114: x_adjustment_id => l_asset_info.adjustment_id);
115: ELSIF c_get_adjustments%NOTFOUND THEN
116: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

Line 113: igi_iac_adjustments_pkg.delete_row(

109: IF c_get_adjustments%FOUND THEN
110: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
111: p_full_path => l_path_name,
112: p_string => ' Deleting records from igi_iac_adjustments');
113: igi_iac_adjustments_pkg.delete_row(
114: x_adjustment_id => l_asset_info.adjustment_id);
115: ELSIF c_get_adjustments%NOTFOUND THEN
116: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
117: p_full_path => l_path_name,

Line 118: p_string => ' No records found in igi_iac_adjustments for delete');

114: x_adjustment_id => l_asset_info.adjustment_id);
115: ELSIF c_get_adjustments%NOTFOUND THEN
116: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
117: p_full_path => l_path_name,
118: p_string => ' No records found in igi_iac_adjustments for delete');
119: END IF;
120: CLOSE c_get_adjustments;
121: /* Delete records from igi_iac_det_balances */
122: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

Line 280: CURSOR c_dist(c_adjustment_id igi_iac_adjustments.adjustment_id%type) IS

276: AND period_counter = p_period_counter;
277:
278: /* Cursor to select impacted distributions for roll back */
279:
280: CURSOR c_dist(c_adjustment_id igi_iac_adjustments.adjustment_id%type) IS
281: SELECT distribution_id
282: FROM igi_iac_det_balances
283: WHERE adjustment_id=c_adjustment_id;
284:

Line 285: CURSOR c_fa_dist(cp_adjustment_id igi_iac_adjustments.adjustment_id%type,

281: SELECT distribution_id
282: FROM igi_iac_det_balances
283: WHERE adjustment_id=c_adjustment_id;
284:
285: CURSOR c_fa_dist(cp_adjustment_id igi_iac_adjustments.adjustment_id%type,
286: cp_asset_id igi_iac_fa_deprn.asset_id%TYPE) IS
287: SELECT book_type_code,asset_id,period_counter,distribution_id,adjustment_id
288: FROM igi_iac_fa_deprn
289: WHERE asset_id = cp_asset_id

Line 375: /* DELETE from igi_iac_adjustments

371: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
372: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deleting From adjustments...');
373: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
374:
375: /* DELETE from igi_iac_adjustments
376: WHERE book_type_code=p_book_type_code
377: AND period_counter=p_period_counter
378: AND adjustment_id=l_trans_headers.adjustment_id; */
379:

Line 380: IGI_IAC_ADJUSTMENTS_PKG.delete_row(

376: WHERE book_type_code=p_book_type_code
377: AND period_counter=p_period_counter
378: AND adjustment_id=l_trans_headers.adjustment_id; */
379:
380: IGI_IAC_ADJUSTMENTS_PKG.delete_row(
381: x_adjustment_id =>l_trans_headers.adjustment_id
382: );
383:
384: OPEN c_prev_data(l_trans_headers.adjustment_id);