APPS.IGI_IAC_ROLLBACK_DEPRN_PKG dependencies on IGI_IAC_FA_DEPRN

Line 84: FROM igi_iac_fa_deprn

80: AND revaluation_id = p_revaluation_id;
81: CURSOR c_get_fa_distributions(cp_asset_id igi_iac_det_balances.asset_id%TYPE,
82: cp_adjustment_id igi_iac_det_balances.adjustment_id%TYPE) IS
83: SELECT distribution_id
84: FROM igi_iac_fa_deprn
85: WHERE book_type_code = p_book_type_code
86: AND asset_id = cp_asset_id
87: AND adjustment_id = cp_adjustment_id;
88: l_revaluation_id igi_iac_revaluations.revaluation_id%TYPE;

Line 134: /* Delete records from igi_iac_fa_deprn */

130: x_distribution_id => l_det_balance.distribution_id,
131: x_book_type_code => p_book_type_code,
132: x_period_counter => p_period_counter);
133: END LOOP;
134: /* Delete records from igi_iac_fa_deprn */
135: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
136: p_full_path => l_path_name,
137: p_string => ' Deleting records from igi_iac_fa_deprn');
138: FOR l_iac_fa_det_balance IN c_get_fa_distributions(l_asset_info.asset_id,

Line 137: p_string => ' Deleting records from igi_iac_fa_deprn');

133: END LOOP;
134: /* Delete records from igi_iac_fa_deprn */
135: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
136: p_full_path => l_path_name,
137: p_string => ' Deleting records from igi_iac_fa_deprn');
138: FOR l_iac_fa_det_balance IN c_get_fa_distributions(l_asset_info.asset_id,
139: l_asset_info.adjustment_id) LOOP
140: igi_iac_fa_deprn_pkg.delete_row(
141: x_book_type_code => p_book_type_code,

Line 140: igi_iac_fa_deprn_pkg.delete_row(

136: p_full_path => l_path_name,
137: p_string => ' Deleting records from igi_iac_fa_deprn');
138: FOR l_iac_fa_det_balance IN c_get_fa_distributions(l_asset_info.asset_id,
139: l_asset_info.adjustment_id) LOOP
140: igi_iac_fa_deprn_pkg.delete_row(
141: x_book_type_code => p_book_type_code,
142: x_asset_id => l_asset_info.asset_id,
143: x_period_counter => p_period_counter,
144: x_adjustment_id => l_asset_info.adjustment_id,

Line 286: cp_asset_id igi_iac_fa_deprn.asset_id%TYPE) IS

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
290: AND book_type_code = p_book_type_code

Line 288: FROM igi_iac_fa_deprn

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
290: AND book_type_code = p_book_type_code
291: AND adjustment_id = cp_adjustment_id;
292:

Line 362: IGI_IAC_FA_DEPRN_PKG.delete_row(

358: );
359: End loop;
360:
361: FOR l_fa_dist IN c_fa_dist(l_trans_headers.adjustment_id,l_trans_headers.asset_id) LOOP
362: IGI_IAC_FA_DEPRN_PKG.delete_row(
363: x_adjustment_id =>l_fa_dist.adjustment_id,
364: x_asset_id =>l_fa_dist.asset_id,
365: x_distribution_id =>l_fa_dist.distribution_id,
366: x_book_type_code =>l_fa_dist.book_type_code,