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 305: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;

301: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
302: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
303: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
304: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;
305: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;
306: l_units_per_dist c_units_per_dist%ROWTYPE;
307: l_cost_account_ccid NUMBER ;
308: l_acc_deprn_account_ccid NUMBER ;
309: l_reval_rsv_account_ccid NUMBER ;

Line 327: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;

323: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE ;
324: l_last_active_adj_id igi_iac_transaction_headers.adjustment_id%TYPE ;
325: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
326: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
327: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
328: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
329: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
330: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
331: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

Line 328: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;

324: l_last_active_adj_id igi_iac_transaction_headers.adjustment_id%TYPE ;
325: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
326: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
327: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
328: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
329: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
330: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
331: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
332: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

Line 329: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;

325: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
326: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
327: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
328: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
329: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
330: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
331: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
332: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
333: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

Line 330: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

326: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
327: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
328: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
329: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
330: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
331: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
332: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
333: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
334: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

Line 331: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

327: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
328: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
329: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
330: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
331: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
332: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
333: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
334: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
335: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 332: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

328: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
329: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
330: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
331: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
332: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
333: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
334: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
335: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
336: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 333: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

329: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
330: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
331: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
332: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
333: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
334: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
335: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
336: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
337: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 334: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

330: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
331: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
332: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
333: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
334: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
335: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
336: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
337: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
338: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 335: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

331: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
332: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
333: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
334: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
335: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
336: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
337: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
338: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
339: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 336: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

332: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
333: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
334: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
335: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
336: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
337: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
338: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
339: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
340: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 337: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

333: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
334: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
335: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
336: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
337: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
338: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
339: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
340: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
341: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 338: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

334: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
335: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
336: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
337: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
338: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
339: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
340: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
341: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
342: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 339: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

335: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
336: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
337: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
338: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
339: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
340: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
341: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
342: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
343: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 340: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

336: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
337: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
338: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
339: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
340: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
341: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
342: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
343: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
344: l_op_exp_ccid NUMBER;

Line 341: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

337: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
338: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
339: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
340: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
341: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
342: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
343: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
344: l_op_exp_ccid NUMBER;
345: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;

Line 342: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

338: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
339: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
340: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
341: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
342: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
343: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
344: l_op_exp_ccid NUMBER;
345: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;
346: l_Transaction_Id igi_iac_transaction_headers.transaction_header_id%TYPE;

Line 343: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

339: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
340: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
341: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
342: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
343: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
344: l_op_exp_ccid NUMBER;
345: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;
346: l_Transaction_Id igi_iac_transaction_headers.transaction_header_id%TYPE;
347: l_Mass_Reference_ID igi_iac_transaction_headers.mass_reference_id%TYPE;

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

429:
430:
431: FOR l_detail_balances IN c_detail_balances(l_last_active_adj_id) LOOP
432:
433: -- since the equivalent row in igi_iac_fa_deprn has to handled in
434: -- the same manner, retrieving the row for simultaneous processing
435: OPEN c_fa_deprn( l_detail_balances.adjustment_id,
436: l_detail_balances.distribution_id,
437: l_detail_balances.period_counter);

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

1105: l_fa_deprn.deprn_ytd := 0;
1106: ELSE
1107: l_fa_deprn_ytd := l_fa_deprn.deprn_ytd;
1108: END IF;
1109: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
1110: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
1111: x_rowid => g_rowid,
1112: x_book_type_code => p_book_type_code,
1113: x_asset_id => p_asset_id,

Line 1110: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

1106: ELSE
1107: l_fa_deprn_ytd := l_fa_deprn.deprn_ytd;
1108: END IF;
1109: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
1110: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
1111: x_rowid => g_rowid,
1112: x_book_type_code => p_book_type_code,
1113: x_asset_id => p_asset_id,
1114: x_period_counter => g_prd_rec.period_counter,

Line 1185: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

1181: g_rowid := NULL ;
1182:
1183:
1184:
1185: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
1186: x_rowid => g_rowid,
1187: x_book_type_code => p_book_type_code,
1188: x_asset_id => p_asset_id,
1189: x_period_counter => g_prd_rec.period_counter,

Line 1309: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;

1305: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
1306: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
1307: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
1308: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;
1309: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;
1310: l_units_per_dist c_units_per_dist%ROWTYPE;
1311: l_cost_account_ccid NUMBER ;
1312: l_acc_deprn_account_ccid NUMBER ;
1313: l_reval_rsv_account_ccid NUMBER ;

Line 1331: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;

1327: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE ;
1328: l_last_active_adj_id igi_iac_transaction_headers.adjustment_id%TYPE ;
1329: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
1330: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
1331: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1332: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1333: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1334: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1335: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

Line 1332: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;

1328: l_last_active_adj_id igi_iac_transaction_headers.adjustment_id%TYPE ;
1329: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
1330: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
1331: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1332: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1333: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1334: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1335: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1336: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

Line 1333: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;

1329: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
1330: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
1331: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1332: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1333: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1334: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1335: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1336: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1337: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

Line 1334: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

1330: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
1331: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1332: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1333: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1334: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1335: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1336: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1337: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1338: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

Line 1335: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

1331: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1332: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1333: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1334: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1335: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1336: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1337: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1338: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1339: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 1336: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

1332: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1333: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1334: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1335: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1336: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1337: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1338: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1339: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1340: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 1337: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

1333: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1334: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1335: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1336: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1337: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1338: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1339: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1340: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1341: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 1338: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

1334: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1335: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1336: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1337: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1338: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1339: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1340: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1341: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1342: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 1339: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

1335: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1336: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1337: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1338: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1339: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1340: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1341: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1342: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1343: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 1340: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

1336: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1337: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1338: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1339: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1340: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1341: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1342: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1343: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1344: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 1341: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

1337: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1338: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1339: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1340: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1341: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1342: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1343: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1344: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1345: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 1342: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

1338: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
1339: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1340: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1341: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1342: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1343: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1344: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1345: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1346: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 1343: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

1339: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1340: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1341: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1342: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1343: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1344: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1345: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1346: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1347: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 1344: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

1340: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1341: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1342: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1343: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1344: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1345: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1346: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1347: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1348: l_op_exp_ccid NUMBER;

Line 1345: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

1341: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1342: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1343: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1344: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1345: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1346: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1347: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1348: l_op_exp_ccid NUMBER;
1349: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;

Line 1346: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

1342: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1343: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1344: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1345: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1346: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1347: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1348: l_op_exp_ccid NUMBER;
1349: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;
1350: l_Transaction_Id igi_iac_transaction_headers.transaction_header_id%TYPE;

Line 1347: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

1343: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1344: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1345: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1346: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1347: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1348: l_op_exp_ccid NUMBER;
1349: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;
1350: l_Transaction_Id igi_iac_transaction_headers.transaction_header_id%TYPE;
1351: l_Mass_Reference_ID igi_iac_transaction_headers.mass_reference_id%TYPE;

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

1627: debug( g_state_level,l_path_name,'X_cumulative_reval_factor=>'|| l_detail_balances.cumulative_reval_factor );
1628: debug( g_state_level,l_path_name,'X_active_flag =>'|| l_detail_balances.active_flag);
1629:
1630: debug( g_state_level,l_path_name,'end insert det bals');
1631: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
1632: l_rowid:=NULL;
1633: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
1634: x_rowid => l_rowid,
1635: x_book_type_code => p_book_type_code,

Line 1633: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

1629:
1630: debug( g_state_level,l_path_name,'end insert det bals');
1631: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
1632: l_rowid:=NULL;
1633: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
1634: x_rowid => l_rowid,
1635: x_book_type_code => p_book_type_code,
1636: x_asset_id => p_asset_id,
1637: x_period_counter => g_prd_rec.period_counter,

Line 1680: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

1676: X_active_flag => l_detail_balances.active_flag ,
1677: X_mode => 'R') ;
1678:
1679: l_rowid := NULL ;
1680: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
1681: x_rowid => g_rowid,
1682: x_book_type_code => p_book_type_code,
1683: x_asset_id => p_asset_id,
1684: x_period_counter => g_prd_rec.period_counter,

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

1925: debug( g_state_level,l_path_name,'X_cumulative_reval_factor=>'|| l_detail_balances.cumulative_reval_factor );
1926: debug( g_state_level,l_path_name,'X_active_flag =>'|| l_detail_balances.active_flag);
1927:
1928: debug( g_state_level,l_path_name,'end insert det bals');
1929: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
1930: l_rowid:=NULL;
1931: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
1932: x_rowid => l_rowid,
1933: x_book_type_code => p_book_type_code,

Line 1931: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

1927:
1928: debug( g_state_level,l_path_name,'end insert det bals');
1929: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
1930: l_rowid:=NULL;
1931: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
1932: x_rowid => l_rowid,
1933: x_book_type_code => p_book_type_code,
1934: x_asset_id => p_asset_id,
1935: x_period_counter => g_prd_rec.period_counter,

Line 1980: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

1976: X_mode => 'R') ;
1977:
1978:
1979: l_rowid := NULL ;
1980: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
1981: x_rowid => g_rowid,
1982: x_book_type_code => p_book_type_code,
1983: x_asset_id => p_asset_id,
1984: x_period_counter => g_prd_rec.period_counter,

Line 2032: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;

2028: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
2029: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
2030: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
2031: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;
2032: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;
2033: l_units_per_dist c_units_per_dist%ROWTYPE;
2034: l_cost_account_ccid NUMBER ;
2035: l_acc_deprn_account_ccid NUMBER ;
2036: l_reval_rsv_account_ccid NUMBER ;

Line 2054: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;

2050: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE ;
2051: l_last_active_adj_id igi_iac_transaction_headers.adjustment_id%TYPE ;
2052: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
2053: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
2054: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
2055: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
2056: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
2057: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
2058: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

Line 2055: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;

2051: l_last_active_adj_id igi_iac_transaction_headers.adjustment_id%TYPE ;
2052: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
2053: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
2054: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
2055: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
2056: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
2057: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
2058: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
2059: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

Line 2056: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;

2052: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
2053: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
2054: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
2055: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
2056: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
2057: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
2058: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
2059: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
2060: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

Line 2057: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

2053: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
2054: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
2055: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
2056: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
2057: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
2058: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
2059: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
2060: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
2061: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

Line 2058: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

2054: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
2055: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
2056: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
2057: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
2058: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
2059: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
2060: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
2061: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
2062: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 2059: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

2055: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
2056: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
2057: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
2058: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
2059: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
2060: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
2061: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
2062: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2063: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 2060: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

2056: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
2057: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
2058: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
2059: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
2060: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
2061: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
2062: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2063: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2064: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 2061: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

2057: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
2058: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
2059: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
2060: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
2061: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
2062: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2063: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2064: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2065: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 2062: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

2058: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
2059: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
2060: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
2061: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
2062: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2063: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2064: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2065: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
2066: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 2063: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

2059: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
2060: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
2061: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
2062: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2063: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2064: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2065: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
2066: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2067: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 2064: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

2060: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
2061: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
2062: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2063: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2064: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2065: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
2066: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2067: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
2068: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 2065: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

2061: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
2062: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2063: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2064: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2065: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
2066: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2067: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
2068: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2069: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 2066: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

2062: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2063: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2064: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2065: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
2066: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2067: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
2068: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2069: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
2070: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 2067: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

2063: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2064: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2065: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
2066: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2067: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
2068: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2069: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
2070: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2071: l_impact_fa_dist c_get_impacted_dist%ROWTYPE;

Line 2068: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

2064: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2065: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
2066: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2067: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
2068: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2069: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
2070: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2071: l_impact_fa_dist c_get_impacted_dist%ROWTYPE;
2072: l_new_fa_dist c_get_new_dist%ROWTYPE;

Line 2069: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

2065: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
2066: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2067: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
2068: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2069: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
2070: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2071: l_impact_fa_dist c_get_impacted_dist%ROWTYPE;
2072: l_new_fa_dist c_get_new_dist%ROWTYPE;
2073: l_retirement_factor Number;

Line 2070: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

2066: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2067: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
2068: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2069: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
2070: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2071: l_impact_fa_dist c_get_impacted_dist%ROWTYPE;
2072: l_new_fa_dist c_get_new_dist%ROWTYPE;
2073: l_retirement_factor Number;
2074: l_op_exp_ccid Number;

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

2163:
2164:
2165: FOR l_detail_balances IN c_detail_balances(l_last_active_adj_id) LOOP
2166:
2167: -- since the equivalent row in igi_iac_fa_deprn has to handled in
2168: -- the same manner, retrieving the row for simultaneous processing
2169: OPEN c_fa_deprn( l_detail_balances.adjustment_id,
2170: l_detail_balances.distribution_id,
2171: l_detail_balances.period_counter);

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

2833: l_fa_deprn.deprn_ytd := 0;
2834: ELSE
2835: l_fa_deprn_ytd := l_fa_deprn.deprn_ytd;
2836: END IF;
2837: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
2838:
2839: l_rowid := NULL ;
2840: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
2841: x_rowid => g_rowid,

Line 2840: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

2836: END IF;
2837: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
2838:
2839: l_rowid := NULL ;
2840: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
2841: x_rowid => g_rowid,
2842: x_book_type_code => p_book_type_code,
2843: x_asset_id => p_asset_id,
2844: x_period_counter => g_prd_rec.period_counter,

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

3122: ELSE
3123: l_fa_deprn_ytd := l_fa_deprn.deprn_ytd;
3124: END IF;
3125:
3126: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
3127: l_rowid:=NULL;
3128: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
3129: x_rowid => l_rowid,
3130: x_book_type_code => p_book_type_code,

Line 3128: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

3124: END IF;
3125:
3126: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
3127: l_rowid:=NULL;
3128: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
3129: x_rowid => l_rowid,
3130: x_book_type_code => p_book_type_code,
3131: x_asset_id => p_asset_id,
3132: x_period_counter => g_prd_rec.period_counter,

Line 3188: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

3184: X_mode => 'R') ;
3185:
3186:
3187: l_rowid := NULL ;
3188: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
3189: x_rowid => g_rowid,
3190: x_book_type_code => p_book_type_code,
3191: x_asset_id => p_asset_id,
3192: x_period_counter => g_prd_rec.period_counter,

Line 3256: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

3252: X_mode => 'R') ;
3253:
3254:
3255: l_rowid:=NULL;
3256: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
3257: x_rowid => l_rowid,
3258: x_book_type_code => p_book_type_code,
3259: x_asset_id => p_asset_id,
3260: x_period_counter => g_prd_rec.period_counter,

Line 3376: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;

3372: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
3373: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
3374: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
3375: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;
3376: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;
3377: l_units_per_dist c_units_per_dist%ROWTYPE;
3378: l_cost_account_ccid NUMBER ;
3379: l_acc_deprn_account_ccid NUMBER ;
3380: l_reval_rsv_account_ccid NUMBER ;

Line 3398: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;

3394: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE ;
3395: l_last_active_adj_id igi_iac_transaction_headers.adjustment_id%TYPE ;
3396: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
3397: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
3398: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
3399: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
3400: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
3401: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3402: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

Line 3399: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;

3395: l_last_active_adj_id igi_iac_transaction_headers.adjustment_id%TYPE ;
3396: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
3397: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
3398: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
3399: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
3400: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
3401: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3402: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3403: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

Line 3400: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;

3396: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
3397: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
3398: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
3399: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
3400: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
3401: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3402: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3403: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3404: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

Line 3401: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

3397: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
3398: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
3399: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
3400: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
3401: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3402: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3403: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3404: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3405: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

Line 3402: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

3398: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
3399: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
3400: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
3401: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3402: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3403: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3404: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3405: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3406: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 3403: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

3399: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
3400: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
3401: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3402: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3403: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3404: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3405: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3406: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3407: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 3404: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

3400: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
3401: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3402: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3403: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3404: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3405: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3406: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3407: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3408: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 3405: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

3401: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3402: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3403: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3404: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3405: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3406: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3407: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3408: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3409: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 3406: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

3402: l_fa_retire_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3403: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3404: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3405: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3406: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3407: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3408: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3409: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
3410: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 3407: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

3403: l_fa_tot_round_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3404: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3405: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3406: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3407: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3408: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3409: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
3410: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3411: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 3408: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

3404: l_fa_unround_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3405: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3406: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3407: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3408: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3409: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
3410: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3411: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
3412: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 3409: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

3405: l_fa_total_new_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;
3406: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3407: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3408: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3409: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
3410: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3411: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
3412: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3413: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 3410: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

3406: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3407: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3408: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3409: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
3410: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3411: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
3412: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3413: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
3414: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 3411: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

3407: l_fa_tot_round_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3408: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3409: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
3410: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3411: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
3412: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3413: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
3414: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3415: l_op_exp_ccid NUMBER;

Line 3412: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

3408: l_fa_unround_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3409: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
3410: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3411: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
3412: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3413: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
3414: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3415: l_op_exp_ccid NUMBER;
3416: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;

Line 3413: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;

3409: l_fa_total_new_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
3410: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3411: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
3412: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3413: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
3414: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3415: l_op_exp_ccid NUMBER;
3416: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;
3417: l_Transaction_Id igi_iac_transaction_headers.transaction_header_id%TYPE;

Line 3414: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

3410: l_fa_total_new_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3411: l_fa_total_old_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
3412: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3413: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
3414: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3415: l_op_exp_ccid NUMBER;
3416: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;
3417: l_Transaction_Id igi_iac_transaction_headers.transaction_header_id%TYPE;
3418: l_Mass_Reference_ID igi_iac_transaction_headers.mass_reference_id%TYPE;

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

3748: debug( g_state_level,l_path_name,'X_deprn_reserve_backlog =>'|| l_detail_balances.deprn_reserve_backlog);
3749: debug( g_state_level,l_path_name,'X_general_fund_per =>'|| l_detail_balances.general_fund_per);
3750: debug( g_state_level,l_path_name,'X_general_fund_acc =>'|| l_detail_balances.general_fund_acc);
3751:
3752: -- insert into igi_iac_fa_deprn with the new adjustment_id
3753: l_rowid:=NULL;
3754: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
3755: x_rowid => l_rowid,
3756: x_book_type_code => p_book_type_code,

Line 3754: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

3750: debug( g_state_level,l_path_name,'X_general_fund_acc =>'|| l_detail_balances.general_fund_acc);
3751:
3752: -- insert into igi_iac_fa_deprn with the new adjustment_id
3753: l_rowid:=NULL;
3754: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
3755: x_rowid => l_rowid,
3756: x_book_type_code => p_book_type_code,
3757: x_asset_id => p_asset_id,
3758: x_period_counter => g_prd_rec.period_counter,

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

3800:
3801:
3802:
3803: debug( g_state_level,l_path_name,'end insert det bals..not impacted distribution');
3804: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
3805: l_rowid:=NULL;
3806: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
3807: x_rowid => l_rowid,
3808: x_book_type_code => p_book_type_code,

Line 3806: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

3802:
3803: debug( g_state_level,l_path_name,'end insert det bals..not impacted distribution');
3804: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
3805: l_rowid:=NULL;
3806: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
3807: x_rowid => l_rowid,
3808: x_book_type_code => p_book_type_code,
3809: x_asset_id => p_asset_id,
3810: x_period_counter => g_prd_rec.period_counter,

Line 3855: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

3851: X_active_flag => l_detail_balances.active_flag ,
3852: X_mode => 'R') ;
3853:
3854: l_rowid := NULL ;
3855: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
3856: x_rowid => g_rowid,
3857: x_book_type_code => p_book_type_code,
3858: x_asset_id => p_asset_id,
3859: x_period_counter => g_prd_rec.period_counter,

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

4146: debug( g_state_level,l_path_name,'X_current_reval_factor =>'|| l_detail_balances.current_reval_factor );
4147: debug( g_state_level,l_path_name,'X_cumulative_reval_factor=>'|| l_detail_balances.cumulative_reval_factor );
4148: debug( g_state_level,l_path_name,'X_active_flag =>'|| l_detail_balances.active_flag);
4149:
4150: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
4151: l_rowid:=NULL;
4152: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
4153: x_rowid => l_rowid,
4154: x_book_type_code => p_book_type_code,

Line 4152: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

4148: debug( g_state_level,l_path_name,'X_active_flag =>'|| l_detail_balances.active_flag);
4149:
4150: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
4151: l_rowid:=NULL;
4152: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
4153: x_rowid => l_rowid,
4154: x_book_type_code => p_book_type_code,
4155: x_asset_id => p_asset_id,
4156: x_period_counter => g_prd_rec.period_counter,

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

4195:
4196:
4197:
4198: debug( g_state_level,l_path_name,'end insert det bals');
4199: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
4200: l_rowid:=NULL;
4201: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
4202: x_rowid => l_rowid,
4203: x_book_type_code => p_book_type_code,

Line 4201: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

4197:
4198: debug( g_state_level,l_path_name,'end insert det bals');
4199: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
4200: l_rowid:=NULL;
4201: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
4202: x_rowid => l_rowid,
4203: x_book_type_code => p_book_type_code,
4204: x_asset_id => p_asset_id,
4205: x_period_counter => g_prd_rec.period_counter,

Line 4250: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

4246: X_active_flag => l_detail_balances.active_flag ,
4247: X_mode => 'R') ;
4248:
4249: l_rowid := NULL ;
4250: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
4251: x_rowid => g_rowid,
4252: x_book_type_code => p_book_type_code,
4253: x_asset_id => p_asset_id,
4254: x_period_counter => g_prd_rec.period_counter,

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

4350: debug( g_state_level,g_path_name,'asset processed by IAC');
4351:
4352: -- if no entries exist for the book in the table
4353: IF NOT igi_iac_common_utils.populate_iac_fa_deprn_data(p_book_type_code,'RETIREMENT') THEN
4354: debug( g_error_level,g_path_name,'Problems creating rows in igi_iac_fa_deprn');
4355: RAISE e_iac_fa_deprn;
4356: END IF;
4357:
4358: IF NOT (igi_iac_common_utils.get_open_period_info(P_Book_Type_Code,g_prd_rec)) THEN

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

4584: FA_SRVR_MSG.add_message(Calling_Fn => g_calling_fn, Name=>'IGI_IAC_NO_IAC_EFFECT');
4585: RETURN TRUE ;
4586:
4587: WHEN e_iac_fa_deprn THEN
4588: debug( g_state_level,g_path_name,'problems inserting rows into igi_iac_fa_deprn');
4589: FA_SRVR_MSG.add_message(Calling_Fn => g_calling_fn,
4590: Name => 'IGI_IAC_FA_DEPR_CREATE_PROB',
4591: Token1 => 'BOOK',
4592: Value1 => p_book_type_code);