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_RETIREMENT dependencies on IGI_IAC_FA_DEPRN

Line 100: FROM igi_iac_fa_deprn ifd

96:
97: CURSOR c_fa_deprn(n_adjust_id NUMBER, n_dist_id NUMBER,n_prd_cnt NUMBER)
98: IS
99: SELECT *
100: FROM igi_iac_fa_deprn ifd
101: WHERE ifd.adjustment_id = n_adjust_id
102: AND ifd.distribution_id = n_dist_id
103: AND ifd.period_counter = n_prd_cnt;
104:

Line 282: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;

278: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
279: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
280: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
281: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;
282: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;
283: l_units_per_dist c_units_per_dist%ROWTYPE;
284: l_cost_account_ccid NUMBER ;
285: l_acc_deprn_account_ccid NUMBER ;
286: l_reval_rsv_account_ccid NUMBER ;

Line 304: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;

300: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE ;
301: l_last_active_adj_id igi_iac_transaction_headers.adjustment_id%TYPE ;
302: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
303: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
304: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
305: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
306: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
307: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
308: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

Line 305: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;

301: l_last_active_adj_id igi_iac_transaction_headers.adjustment_id%TYPE ;
302: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
303: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
304: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
305: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
306: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
307: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
308: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
309: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

Line 306: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;

302: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
303: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
304: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
305: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
306: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
307: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
308: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
309: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
310: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

Line 307: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

303: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
304: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
305: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
306: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
307: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
308: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
309: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
310: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
311: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

Line 308: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

304: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
305: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
306: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
307: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
308: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
309: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
310: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
311: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
312: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 309: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

305: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
306: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
307: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
308: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
309: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
310: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
311: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
312: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
313: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 310: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

306: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
307: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
308: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
309: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
310: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
311: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
312: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
313: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
314: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 311: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

307: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
308: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
309: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
310: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
311: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
312: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
313: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
314: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
315: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 312: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

308: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
309: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
310: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
311: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
312: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
313: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
314: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
315: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
316: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 313: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

309: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
310: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
311: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
312: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
313: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
314: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
315: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
316: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
317: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 314: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

310: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
311: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
312: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
313: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
314: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
315: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
316: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
317: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
318: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 315: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

311: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
312: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
313: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
314: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
315: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
316: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
317: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
318: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
319: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 316: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

312: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
313: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
314: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
315: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
316: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
317: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
318: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
319: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
320: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 317: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

313: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
314: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
315: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
316: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
317: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
318: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
319: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
320: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
321: l_op_exp_ccid NUMBER;

Line 318: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

314: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
315: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
316: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
317: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
318: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
319: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
320: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
321: l_op_exp_ccid NUMBER;
322: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;

Line 319: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

315: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
316: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
317: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
318: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
319: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
320: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
321: l_op_exp_ccid NUMBER;
322: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;
323: l_Transaction_Id igi_iac_transaction_headers.transaction_header_id%TYPE;

Line 320: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

316: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
317: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
318: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
319: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
320: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
321: l_op_exp_ccid NUMBER;
322: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;
323: l_Transaction_Id igi_iac_transaction_headers.transaction_header_id%TYPE;
324: l_Mass_Reference_ID igi_iac_transaction_headers.mass_reference_id%TYPE;

Line 410: -- since the equivalent row in igi_iac_fa_deprn has to handled in

406:
407:
408: FOR l_detail_balances IN c_detail_balances(l_last_active_adj_id) LOOP
409:
410: -- since the equivalent row in igi_iac_fa_deprn has to handled in
411: -- the same manner, retrieving the row for simultaneous processing
412: OPEN c_fa_deprn( l_detail_balances.adjustment_id,
413: l_detail_balances.distribution_id,
414: l_detail_balances.period_counter);

Line 1038: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id

1034: l_fa_deprn.deprn_ytd := 0;
1035: ELSE
1036: l_fa_deprn_ytd := l_fa_deprn.deprn_ytd;
1037: END IF;
1038: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
1039: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
1040: x_rowid => g_rowid,
1041: x_book_type_code => p_book_type_code,
1042: x_asset_id => p_asset_id,

Line 1039: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

1035: ELSE
1036: l_fa_deprn_ytd := l_fa_deprn.deprn_ytd;
1037: END IF;
1038: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
1039: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
1040: x_rowid => g_rowid,
1041: x_book_type_code => p_book_type_code,
1042: x_asset_id => p_asset_id,
1043: x_period_counter => g_prd_rec.period_counter,

Line 1112: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

1108: g_rowid := NULL ;
1109:
1110:
1111:
1112: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
1113: x_rowid => g_rowid,
1114: x_book_type_code => p_book_type_code,
1115: x_asset_id => p_asset_id,
1116: x_period_counter => g_prd_rec.period_counter,

Line 1236: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;

1232: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
1233: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
1234: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
1235: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;
1236: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;
1237: l_units_per_dist c_units_per_dist%ROWTYPE;
1238: l_cost_account_ccid NUMBER ;
1239: l_acc_deprn_account_ccid NUMBER ;
1240: l_reval_rsv_account_ccid NUMBER ;

Line 1258: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;

1254: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE ;
1255: l_last_active_adj_id igi_iac_transaction_headers.adjustment_id%TYPE ;
1256: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
1257: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
1258: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1259: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1260: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1261: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1262: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

Line 1259: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;

1255: l_last_active_adj_id igi_iac_transaction_headers.adjustment_id%TYPE ;
1256: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
1257: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
1258: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1259: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1260: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1261: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1262: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1263: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

Line 1260: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;

1256: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
1257: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
1258: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1259: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1260: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1261: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1262: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1263: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1264: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

Line 1261: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

1257: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
1258: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1259: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1260: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1261: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1262: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1263: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1264: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1265: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

Line 1262: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

1258: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1259: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1260: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1261: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1262: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1263: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1264: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1265: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1266: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 1263: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

1259: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1260: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1261: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1262: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1263: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1264: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1265: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1266: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1267: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 1264: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

1260: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1261: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1262: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1263: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1264: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1265: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1266: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1267: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1268: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 1265: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

1261: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1262: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1263: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1264: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1265: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1266: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1267: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1268: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1269: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 1266: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

1262: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1263: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1264: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1265: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1266: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1267: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1268: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1269: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1270: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 1267: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

1263: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1264: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1265: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1266: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1267: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1268: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1269: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1270: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1271: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 1268: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

1264: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1265: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1266: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1267: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1268: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1269: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1270: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1271: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1272: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 1269: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

1265: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1266: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1267: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1268: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1269: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1270: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1271: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1272: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1273: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 1270: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

1266: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1267: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1268: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1269: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1270: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1271: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1272: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1273: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1274: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 1271: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

1267: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1268: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1269: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1270: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1271: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1272: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1273: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1274: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1275: l_op_exp_ccid NUMBER;

Line 1272: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

1268: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1269: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1270: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1271: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1272: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1273: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1274: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1275: l_op_exp_ccid NUMBER;
1276: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;

Line 1273: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

1269: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1270: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1271: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1272: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1273: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1274: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1275: l_op_exp_ccid NUMBER;
1276: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;
1277: l_Transaction_Id igi_iac_transaction_headers.transaction_header_id%TYPE;

Line 1274: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

1270: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1271: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1272: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1273: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1274: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1275: l_op_exp_ccid NUMBER;
1276: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;
1277: l_Transaction_Id igi_iac_transaction_headers.transaction_header_id%TYPE;
1278: l_Mass_Reference_ID igi_iac_transaction_headers.mass_reference_id%TYPE;

Line 1557: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id

1553: debug( g_state_level,l_path_name,'X_cumulative_reval_factor=>'|| l_detail_balances.cumulative_reval_factor );
1554: debug( g_state_level,l_path_name,'X_active_flag =>'|| l_detail_balances.active_flag);
1555:
1556: debug( g_state_level,l_path_name,'end insert det bals');
1557: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
1558: l_rowid:=NULL;
1559: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
1560: x_rowid => l_rowid,
1561: x_book_type_code => p_book_type_code,

Line 1559: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

1555:
1556: debug( g_state_level,l_path_name,'end insert det bals');
1557: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
1558: l_rowid:=NULL;
1559: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
1560: x_rowid => l_rowid,
1561: x_book_type_code => p_book_type_code,
1562: x_asset_id => p_asset_id,
1563: x_period_counter => g_prd_rec.period_counter,

Line 1606: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

1602: X_active_flag => l_detail_balances.active_flag ,
1603: X_mode => 'R') ;
1604:
1605: l_rowid := NULL ;
1606: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
1607: x_rowid => g_rowid,
1608: x_book_type_code => p_book_type_code,
1609: x_asset_id => p_asset_id,
1610: x_period_counter => g_prd_rec.period_counter,

Line 1854: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id

1850: debug( g_state_level,l_path_name,'X_cumulative_reval_factor=>'|| l_detail_balances.cumulative_reval_factor );
1851: debug( g_state_level,l_path_name,'X_active_flag =>'|| l_detail_balances.active_flag);
1852:
1853: debug( g_state_level,l_path_name,'end insert det bals');
1854: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
1855: l_rowid:=NULL;
1856: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
1857: x_rowid => l_rowid,
1858: x_book_type_code => p_book_type_code,

Line 1856: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

1852:
1853: debug( g_state_level,l_path_name,'end insert det bals');
1854: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
1855: l_rowid:=NULL;
1856: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
1857: x_rowid => l_rowid,
1858: x_book_type_code => p_book_type_code,
1859: x_asset_id => p_asset_id,
1860: x_period_counter => g_prd_rec.period_counter,

Line 1905: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

1901: X_mode => 'R') ;
1902:
1903:
1904: l_rowid := NULL ;
1905: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
1906: x_rowid => g_rowid,
1907: x_book_type_code => p_book_type_code,
1908: x_asset_id => p_asset_id,
1909: x_period_counter => g_prd_rec.period_counter,

Line 1957: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;

1953: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
1954: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
1955: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
1956: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;
1957: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;
1958: l_units_per_dist c_units_per_dist%ROWTYPE;
1959: l_cost_account_ccid NUMBER ;
1960: l_acc_deprn_account_ccid NUMBER ;
1961: l_reval_rsv_account_ccid NUMBER ;

Line 1979: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;

1975: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE ;
1976: l_last_active_adj_id igi_iac_transaction_headers.adjustment_id%TYPE ;
1977: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
1978: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
1979: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1980: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1981: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1982: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1983: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

Line 1980: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;

1976: l_last_active_adj_id igi_iac_transaction_headers.adjustment_id%TYPE ;
1977: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
1978: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
1979: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1980: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1981: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1982: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1983: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1984: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

Line 1981: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;

1977: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
1978: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
1979: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1980: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1981: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1982: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1983: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1984: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1985: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

Line 1982: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

1978: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
1979: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1980: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1981: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1982: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1983: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1984: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1985: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1986: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

Line 1983: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

1979: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1980: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1981: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1982: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1983: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1984: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1985: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1986: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1987: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 1984: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

1980: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1981: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1982: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1983: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1984: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1985: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1986: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1987: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1988: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 1985: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

1981: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1982: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1983: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1984: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1985: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1986: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1987: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1988: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1989: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 1986: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

1982: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1983: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1984: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1985: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1986: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1987: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1988: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1989: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1990: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 1987: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

1983: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1984: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1985: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1986: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1987: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1988: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1989: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1990: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1991: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 1988: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

1984: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1985: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1986: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1987: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1988: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1989: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1990: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1991: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1992: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 1989: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

1985: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1986: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1987: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1988: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1989: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1990: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1991: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1992: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1993: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 1990: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

1986: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1987: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1988: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1989: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1990: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1991: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1992: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1993: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1994: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 1991: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

1987: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1988: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1989: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1990: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1991: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1992: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1993: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1994: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1995: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 1992: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

1988: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1989: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1990: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1991: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1992: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1993: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1994: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1995: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1996: l_impact_fa_dist c_get_impacted_dist%ROWTYPE;

Line 1993: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

1989: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1990: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1991: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1992: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1993: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1994: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1995: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1996: l_impact_fa_dist c_get_impacted_dist%ROWTYPE;
1997: l_new_fa_dist c_get_new_dist%ROWTYPE;

Line 1994: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

1990: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1991: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1992: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1993: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1994: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1995: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1996: l_impact_fa_dist c_get_impacted_dist%ROWTYPE;
1997: l_new_fa_dist c_get_new_dist%ROWTYPE;
1998: l_retirement_factor Number;

Line 1995: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

1991: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1992: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1993: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1994: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1995: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1996: l_impact_fa_dist c_get_impacted_dist%ROWTYPE;
1997: l_new_fa_dist c_get_new_dist%ROWTYPE;
1998: l_retirement_factor Number;
1999: l_op_exp_ccid Number;

Line 2092: -- since the equivalent row in igi_iac_fa_deprn has to handled in

2088:
2089:
2090: FOR l_detail_balances IN c_detail_balances(l_last_active_adj_id) LOOP
2091:
2092: -- since the equivalent row in igi_iac_fa_deprn has to handled in
2093: -- the same manner, retrieving the row for simultaneous processing
2094: OPEN c_fa_deprn( l_detail_balances.adjustment_id,
2095: l_detail_balances.distribution_id,
2096: l_detail_balances.period_counter);

Line 2712: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id

2708: l_fa_deprn.deprn_ytd := 0;
2709: ELSE
2710: l_fa_deprn_ytd := l_fa_deprn.deprn_ytd;
2711: END IF;
2712: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
2713:
2714: l_rowid := NULL ;
2715: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
2716: x_rowid => g_rowid,

Line 2715: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

2711: END IF;
2712: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
2713:
2714: l_rowid := NULL ;
2715: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
2716: x_rowid => g_rowid,
2717: x_book_type_code => p_book_type_code,
2718: x_asset_id => p_asset_id,
2719: x_period_counter => g_prd_rec.period_counter,

Line 3001: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id

2997: ELSE
2998: l_fa_deprn_ytd := l_fa_deprn.deprn_ytd;
2999: END IF;
3000:
3001: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
3002: l_rowid:=NULL;
3003: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
3004: x_rowid => l_rowid,
3005: x_book_type_code => p_book_type_code,

Line 3003: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

2999: END IF;
3000:
3001: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
3002: l_rowid:=NULL;
3003: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
3004: x_rowid => l_rowid,
3005: x_book_type_code => p_book_type_code,
3006: x_asset_id => p_asset_id,
3007: x_period_counter => g_prd_rec.period_counter,

Line 3063: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

3059: X_mode => 'R') ;
3060:
3061:
3062: l_rowid := NULL ;
3063: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
3064: x_rowid => g_rowid,
3065: x_book_type_code => p_book_type_code,
3066: x_asset_id => p_asset_id,
3067: x_period_counter => g_prd_rec.period_counter,

Line 3131: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

3127: X_mode => 'R') ;
3128:
3129:
3130: l_rowid:=NULL;
3131: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
3132: x_rowid => l_rowid,
3133: x_book_type_code => p_book_type_code,
3134: x_asset_id => p_asset_id,
3135: x_period_counter => g_prd_rec.period_counter,

Line 3251: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;

3247: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
3248: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
3249: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
3250: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;
3251: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;
3252: l_units_per_dist c_units_per_dist%ROWTYPE;
3253: l_cost_account_ccid NUMBER ;
3254: l_acc_deprn_account_ccid NUMBER ;
3255: l_reval_rsv_account_ccid NUMBER ;

Line 3273: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;

3269: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE ;
3270: l_last_active_adj_id igi_iac_transaction_headers.adjustment_id%TYPE ;
3271: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
3272: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
3273: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
3274: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
3275: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
3276: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3277: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

Line 3274: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;

3270: l_last_active_adj_id igi_iac_transaction_headers.adjustment_id%TYPE ;
3271: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
3272: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
3273: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
3274: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
3275: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
3276: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3277: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3278: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

Line 3275: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;

3271: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
3272: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
3273: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
3274: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
3275: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
3276: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3277: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3278: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3279: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

Line 3276: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

3272: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
3273: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
3274: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
3275: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
3276: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3277: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3278: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3279: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3280: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

Line 3277: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

3273: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
3274: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
3275: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
3276: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3277: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3278: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3279: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3280: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3281: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 3278: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

3274: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
3275: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
3276: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3277: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3278: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3279: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3280: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3281: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3282: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 3279: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

3275: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
3276: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3277: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3278: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3279: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3280: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3281: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3282: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3283: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 3280: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

3276: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3277: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3278: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3279: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3280: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3281: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3282: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3283: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3284: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 3281: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

3277: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3278: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3279: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3280: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3281: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3282: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3283: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3284: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
3285: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 3282: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

3278: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3279: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3280: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3281: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3282: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3283: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3284: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
3285: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3286: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 3283: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

3279: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3280: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3281: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3282: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3283: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3284: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
3285: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3286: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
3287: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 3284: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

3280: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3281: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3282: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3283: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3284: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
3285: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3286: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
3287: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3288: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 3285: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

3281: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3282: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3283: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3284: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
3285: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3286: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
3287: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3288: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
3289: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 3286: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

3282: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3283: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3284: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
3285: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3286: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
3287: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3288: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
3289: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3290: l_op_exp_ccid NUMBER;

Line 3287: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

3283: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3284: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
3285: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3286: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
3287: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3288: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
3289: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3290: l_op_exp_ccid NUMBER;
3291: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;

Line 3288: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

3284: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
3285: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3286: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
3287: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3288: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
3289: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3290: l_op_exp_ccid NUMBER;
3291: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;
3292: l_Transaction_Id igi_iac_transaction_headers.transaction_header_id%TYPE;

Line 3289: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

3285: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3286: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
3287: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3288: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
3289: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3290: l_op_exp_ccid NUMBER;
3291: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;
3292: l_Transaction_Id igi_iac_transaction_headers.transaction_header_id%TYPE;
3293: l_Mass_Reference_ID igi_iac_transaction_headers.mass_reference_id%TYPE;

Line 3626: -- insert into igi_iac_fa_deprn with the new adjustment_id

3622: debug( g_state_level,l_path_name,'X_deprn_reserve_backlog =>'|| l_detail_balances.deprn_reserve_backlog);
3623: debug( g_state_level,l_path_name,'X_general_fund_per =>'|| l_detail_balances.general_fund_per);
3624: debug( g_state_level,l_path_name,'X_general_fund_acc =>'|| l_detail_balances.general_fund_acc);
3625:
3626: -- insert into igi_iac_fa_deprn with the new adjustment_id
3627: l_rowid:=NULL;
3628: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
3629: x_rowid => l_rowid,
3630: x_book_type_code => p_book_type_code,

Line 3628: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

3624: debug( g_state_level,l_path_name,'X_general_fund_acc =>'|| l_detail_balances.general_fund_acc);
3625:
3626: -- insert into igi_iac_fa_deprn with the new adjustment_id
3627: l_rowid:=NULL;
3628: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
3629: x_rowid => l_rowid,
3630: x_book_type_code => p_book_type_code,
3631: x_asset_id => p_asset_id,
3632: x_period_counter => g_prd_rec.period_counter,

Line 3678: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id

3674:
3675:
3676:
3677: debug( g_state_level,l_path_name,'end insert det bals..not impacted distribution');
3678: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
3679: l_rowid:=NULL;
3680: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
3681: x_rowid => l_rowid,
3682: x_book_type_code => p_book_type_code,

Line 3680: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

3676:
3677: debug( g_state_level,l_path_name,'end insert det bals..not impacted distribution');
3678: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
3679: l_rowid:=NULL;
3680: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
3681: x_rowid => l_rowid,
3682: x_book_type_code => p_book_type_code,
3683: x_asset_id => p_asset_id,
3684: x_period_counter => g_prd_rec.period_counter,

Line 3729: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

3725: X_active_flag => l_detail_balances.active_flag ,
3726: X_mode => 'R') ;
3727:
3728: l_rowid := NULL ;
3729: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
3730: x_rowid => g_rowid,
3731: x_book_type_code => p_book_type_code,
3732: x_asset_id => p_asset_id,
3733: x_period_counter => g_prd_rec.period_counter,

Line 4023: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id

4019: debug( g_state_level,l_path_name,'X_current_reval_factor =>'|| l_detail_balances.current_reval_factor );
4020: debug( g_state_level,l_path_name,'X_cumulative_reval_factor=>'|| l_detail_balances.cumulative_reval_factor );
4021: debug( g_state_level,l_path_name,'X_active_flag =>'|| l_detail_balances.active_flag);
4022:
4023: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
4024: l_rowid:=NULL;
4025: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
4026: x_rowid => l_rowid,
4027: x_book_type_code => p_book_type_code,

Line 4025: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

4021: debug( g_state_level,l_path_name,'X_active_flag =>'|| l_detail_balances.active_flag);
4022:
4023: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
4024: l_rowid:=NULL;
4025: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
4026: x_rowid => l_rowid,
4027: x_book_type_code => p_book_type_code,
4028: x_asset_id => p_asset_id,
4029: x_period_counter => g_prd_rec.period_counter,

Line 4072: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id

4068:
4069:
4070:
4071: debug( g_state_level,l_path_name,'end insert det bals');
4072: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
4073: l_rowid:=NULL;
4074: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
4075: x_rowid => l_rowid,
4076: x_book_type_code => p_book_type_code,

Line 4074: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

4070:
4071: debug( g_state_level,l_path_name,'end insert det bals');
4072: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
4073: l_rowid:=NULL;
4074: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
4075: x_rowid => l_rowid,
4076: x_book_type_code => p_book_type_code,
4077: x_asset_id => p_asset_id,
4078: x_period_counter => g_prd_rec.period_counter,

Line 4123: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

4119: X_active_flag => l_detail_balances.active_flag ,
4120: X_mode => 'R') ;
4121:
4122: l_rowid := NULL ;
4123: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
4124: x_rowid => g_rowid,
4125: x_book_type_code => p_book_type_code,
4126: x_asset_id => p_asset_id,
4127: x_period_counter => g_prd_rec.period_counter,

Line 4227: debug( g_error_level,g_path_name,'Problems creating rows in igi_iac_fa_deprn');

4223: debug( g_state_level,g_path_name,'asset processed by IAC');
4224:
4225: -- if no entries exist for the book in the table
4226: IF NOT igi_iac_common_utils.populate_iac_fa_deprn_data(p_book_type_code,'RETIREMENT') THEN
4227: debug( g_error_level,g_path_name,'Problems creating rows in igi_iac_fa_deprn');
4228: RAISE e_iac_fa_deprn;
4229: END IF;
4230:
4231: IF NOT (igi_iac_common_utils.get_open_period_info(P_Book_Type_Code,g_prd_rec)) THEN

Line 4459: debug( g_state_level,g_path_name,'problems inserting rows into igi_iac_fa_deprn');

4455: FA_SRVR_MSG.add_message(Calling_Fn => g_calling_fn, Name=>'IGI_IAC_NO_IAC_EFFECT');
4456: RETURN TRUE ;
4457:
4458: WHEN e_iac_fa_deprn THEN
4459: debug( g_state_level,g_path_name,'problems inserting rows into igi_iac_fa_deprn');
4460: FA_SRVR_MSG.add_message(Calling_Fn => g_calling_fn,
4461: Name => 'IGI_IAC_FA_DEPR_CREATE_PROB',
4462: Token1 => 'BOOK',
4463: Value1 => p_book_type_code);