[Home] [Help]
36: p_calling_function VARCHAR2
37: ) return BOOLEAN IS
38: CURSOR c_get_asset_add_info IS
39: SELECT asset_id,adjustment_id,transaction_sub_type
40: FROM igi_iac_transaction_headers
41: WHERE book_type_code = p_book_type_code
42: AND period_counter = p_period_counter
43: AND transaction_type_code = 'ADDITION';
44: CURSOR c_get_distributions(p_asset_id igi_iac_det_balances.asset_id%TYPE,
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 */
183: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
184: p_full_path => l_path_name,
185: p_string => ' Deleting records from igi_iac_transaction_headers');
186: igi_iac_trans_headers_pkg.delete_row(
181: END IF;
182: /* Delete records from igi_iac_transaction_headers */
183: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
184: p_full_path => l_path_name,
185: p_string => ' Deleting records from igi_iac_transaction_headers');
186: igi_iac_trans_headers_pkg.delete_row(
187: x_adjustment_id => l_asset_info.adjustment_id);
188: IF l_asset_info.transaction_sub_type <> 'CATCHUP' THEN
189: l_revaluation_id := NULL;
242: /* Cursor to select data from transaction headers which need to be rolled back */
243:
244: CURSOR c_trans_headers IS
245: SELECT *
246: FROM igi_iac_transaction_headers
247: WHERE book_type_code=p_book_type_code
248: AND period_counter=p_period_counter
249: AND transaction_type_code='TRANSFER';
250:
258: AND adjustment_id = cp_adjustment_id;
259:
260: /* Cursor to select the previous data */
261:
262: CURSOR c_prev_data(c_adjustment_id igi_iac_transaction_headers.adjustment_id%type) IS
263: SELECT *
264: FROM igi_iac_transaction_headers
265: WHERE adjustment_id_out=c_adjustment_id;
266:
260: /* Cursor to select the previous data */
261:
262: CURSOR c_prev_data(c_adjustment_id igi_iac_transaction_headers.adjustment_id%type) IS
263: SELECT *
264: FROM igi_iac_transaction_headers
265: WHERE adjustment_id_out=c_adjustment_id;
266:
267: /* Cursor to find the amounts that need to be transferred to the new dist
268: created by transfer */
299: l_deprn_expense FA_DEPRN_SUMMARY.deprn_amount%type;
300: l_Expense_diff IGI_IAC_DET_BALANCES.deprn_period%type;
301: l_prior_period_counter IGI_IAC_DET_BALANCES.period_counter%type;
302: l_current_period_counter IGI_IAC_DET_BALANCES.period_counter%type;
303: l_prev_adjustment igi_iac_transaction_headers%ROWTYPE;
304:
305: l_path varchar2(150);
306: BEGIN
307: