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_ADJ_COST_REVAL_PKG dependencies on IGI_IAC_DET_BALANCES

Line 209: PROCEDURE Roll_YTD_Forward(p_asset_id igi_iac_det_balances.asset_id%TYPE,

205: -- -------------------------------------------------------------------
206: -- PROCEDURE Roll_YTD_Forward: Procedure that will roll forward any
207: -- YTD rows from the previous adjustment_id
208: -- -------------------------------------------------------------------
209: PROCEDURE Roll_YTD_Forward(p_asset_id igi_iac_det_balances.asset_id%TYPE,
210: p_book_type_code igi_iac_det_balances.book_type_code%TYPE,
211: p_prev_adj_id igi_iac_det_balances.adjustment_id%TYPE,
212: p_new_adj_id igi_iac_det_balances.adjustment_id%TYPE,
213: p_prd_counter igi_iac_det_balances.period_counter%TYPE)

Line 210: p_book_type_code igi_iac_det_balances.book_type_code%TYPE,

206: -- PROCEDURE Roll_YTD_Forward: Procedure that will roll forward any
207: -- YTD rows from the previous adjustment_id
208: -- -------------------------------------------------------------------
209: PROCEDURE Roll_YTD_Forward(p_asset_id igi_iac_det_balances.asset_id%TYPE,
210: p_book_type_code igi_iac_det_balances.book_type_code%TYPE,
211: p_prev_adj_id igi_iac_det_balances.adjustment_id%TYPE,
212: p_new_adj_id igi_iac_det_balances.adjustment_id%TYPE,
213: p_prd_counter igi_iac_det_balances.period_counter%TYPE)
214: IS

Line 211: p_prev_adj_id igi_iac_det_balances.adjustment_id%TYPE,

207: -- YTD rows from the previous adjustment_id
208: -- -------------------------------------------------------------------
209: PROCEDURE Roll_YTD_Forward(p_asset_id igi_iac_det_balances.asset_id%TYPE,
210: p_book_type_code igi_iac_det_balances.book_type_code%TYPE,
211: p_prev_adj_id igi_iac_det_balances.adjustment_id%TYPE,
212: p_new_adj_id igi_iac_det_balances.adjustment_id%TYPE,
213: p_prd_counter igi_iac_det_balances.period_counter%TYPE)
214: IS
215:

Line 212: p_new_adj_id igi_iac_det_balances.adjustment_id%TYPE,

208: -- -------------------------------------------------------------------
209: PROCEDURE Roll_YTD_Forward(p_asset_id igi_iac_det_balances.asset_id%TYPE,
210: p_book_type_code igi_iac_det_balances.book_type_code%TYPE,
211: p_prev_adj_id igi_iac_det_balances.adjustment_id%TYPE,
212: p_new_adj_id igi_iac_det_balances.adjustment_id%TYPE,
213: p_prd_counter igi_iac_det_balances.period_counter%TYPE)
214: IS
215:
216: -- cursor to retrieve the YTD row that will be rolled forward

Line 213: p_prd_counter igi_iac_det_balances.period_counter%TYPE)

209: PROCEDURE Roll_YTD_Forward(p_asset_id igi_iac_det_balances.asset_id%TYPE,
210: p_book_type_code igi_iac_det_balances.book_type_code%TYPE,
211: p_prev_adj_id igi_iac_det_balances.adjustment_id%TYPE,
212: p_new_adj_id igi_iac_det_balances.adjustment_id%TYPE,
213: p_prd_counter igi_iac_det_balances.period_counter%TYPE)
214: IS
215:
216: -- cursor to retrieve the YTD row that will be rolled forward
217: CURSOR c_get_ytd(cp_adjustment_id igi_iac_det_balances.adjustment_id%TYPE,

Line 217: CURSOR c_get_ytd(cp_adjustment_id igi_iac_det_balances.adjustment_id%TYPE,

213: p_prd_counter igi_iac_det_balances.period_counter%TYPE)
214: IS
215:
216: -- cursor to retrieve the YTD row that will be rolled forward
217: CURSOR c_get_ytd(cp_adjustment_id igi_iac_det_balances.adjustment_id%TYPE,
218: cp_asset_id igi_iac_det_balances.asset_id%TYPE,
219: cp_book_type_code igi_iac_det_balances.book_type_code%TYPE)
220: IS
221: SELECT iidb.adjustment_id,

Line 218: cp_asset_id igi_iac_det_balances.asset_id%TYPE,

214: IS
215:
216: -- cursor to retrieve the YTD row that will be rolled forward
217: CURSOR c_get_ytd(cp_adjustment_id igi_iac_det_balances.adjustment_id%TYPE,
218: cp_asset_id igi_iac_det_balances.asset_id%TYPE,
219: cp_book_type_code igi_iac_det_balances.book_type_code%TYPE)
220: IS
221: SELECT iidb.adjustment_id,
222: iidb.distribution_id,

Line 219: cp_book_type_code igi_iac_det_balances.book_type_code%TYPE)

215:
216: -- cursor to retrieve the YTD row that will be rolled forward
217: CURSOR c_get_ytd(cp_adjustment_id igi_iac_det_balances.adjustment_id%TYPE,
218: cp_asset_id igi_iac_det_balances.asset_id%TYPE,
219: cp_book_type_code igi_iac_det_balances.book_type_code%TYPE)
220: IS
221: SELECT iidb.adjustment_id,
222: iidb.distribution_id,
223: iidb.adjustment_cost,

Line 243: FROM igi_iac_det_balances iidb

239: iidb.active_flag,
240: iidb.last_reval_date,
241: iidb.current_reval_factor,
242: iidb.cumulative_reval_factor
243: FROM igi_iac_det_balances iidb
244: WHERE iidb.adjustment_id = cp_adjustment_id
245: AND iidb.asset_id = cp_asset_id
246: AND iidb.book_type_code = cp_book_type_code
247: AND iidb.active_flag = 'N';

Line 287: -- insert into igi_iac_det_balances with reinstatement adjustment_id

283:
284: BEGIN
285:
286: FOR l_get_ytd IN c_get_ytd(p_prev_adj_id,p_asset_id, p_book_type_code) LOOP
287: -- insert into igi_iac_det_balances with reinstatement adjustment_id
288:
289: IGI_IAC_DET_BALANCES_PKG.Insert_Row(
290: x_rowid => l_rowid,
291: x_adjustment_id => p_new_adj_id,

Line 289: IGI_IAC_DET_BALANCES_PKG.Insert_Row(

285:
286: FOR l_get_ytd IN c_get_ytd(p_prev_adj_id,p_asset_id, p_book_type_code) LOOP
287: -- insert into igi_iac_det_balances with reinstatement adjustment_id
288:
289: IGI_IAC_DET_BALANCES_PKG.Insert_Row(
290: x_rowid => l_rowid,
291: x_adjustment_id => p_new_adj_id,
292: x_asset_id => p_asset_id,
293: x_book_type_code => p_book_type_code,

Line 393: CURSOR c_det_bal(cp_adjust_id igi_iac_det_balances.adjustment_id%TYPE,

389: AND book_type_code = cp_book_type_code
390: AND period_counter = cp_period_counter;
391:
392: -- cursor to get the detail balances for a distribution
393: CURSOR c_det_bal(cp_adjust_id igi_iac_det_balances.adjustment_id%TYPE,
394: cp_asset_id fa_books.asset_id%TYPE,
395: cp_book_type_code fa_books.book_type_code%TYPE,
396: cp_dist_id igi_iac_det_balances.distribution_id%TYPE)
397: IS

Line 396: cp_dist_id igi_iac_det_balances.distribution_id%TYPE)

392: -- cursor to get the detail balances for a distribution
393: CURSOR c_det_bal(cp_adjust_id igi_iac_det_balances.adjustment_id%TYPE,
394: cp_asset_id fa_books.asset_id%TYPE,
395: cp_book_type_code fa_books.book_type_code%TYPE,
396: cp_dist_id igi_iac_det_balances.distribution_id%TYPE)
397: IS
398: SELECT iidb.adjustment_id,
399: iidb.distribution_id,
400: iidb.period_counter,

Line 421: FROM igi_iac_det_balances iidb

417: iidb.last_reval_date,
418: iidb.current_reval_factor,
419: iidb.cumulative_reval_factor,
420: iidb.active_flag
421: FROM igi_iac_det_balances iidb
422: WHERE iidb.adjustment_id = cp_adjust_id
423: AND iidb.book_type_code = cp_book_type_code
424: AND iidb.asset_id = cp_asset_id
425: AND iidb.distribution_id = cp_dist_id

Line 486: l_add_cost igi_iac_det_balances.adjustment_cost%TYPE;

482: l_det_table IGI_IAC_TYPES.dist_amt_tab;
483: l_det_bal c_det_bal%ROWTYPE;
484:
485: l_dist_idx NUMBER;
486: l_add_cost igi_iac_det_balances.adjustment_cost%TYPE;
487: l_dist_id igi_iac_det_balances.distribution_id%TYPE;
488: l_new_dist_cost igi_iac_det_balances.adjustment_cost%TYPE;
489: l_new_dist_nbv igi_iac_det_balances.net_book_value%TYPE;
490: l_new_dist_rr_cost igi_iac_det_balances.reval_reserve_cost%TYPE;

Line 487: l_dist_id igi_iac_det_balances.distribution_id%TYPE;

483: l_det_bal c_det_bal%ROWTYPE;
484:
485: l_dist_idx NUMBER;
486: l_add_cost igi_iac_det_balances.adjustment_cost%TYPE;
487: l_dist_id igi_iac_det_balances.distribution_id%TYPE;
488: l_new_dist_cost igi_iac_det_balances.adjustment_cost%TYPE;
489: l_new_dist_nbv igi_iac_det_balances.net_book_value%TYPE;
490: l_new_dist_rr_cost igi_iac_det_balances.reval_reserve_cost%TYPE;
491: l_new_dist_rr_net igi_iac_det_balances.reval_reserve_net%TYPE;

Line 488: l_new_dist_cost igi_iac_det_balances.adjustment_cost%TYPE;

484:
485: l_dist_idx NUMBER;
486: l_add_cost igi_iac_det_balances.adjustment_cost%TYPE;
487: l_dist_id igi_iac_det_balances.distribution_id%TYPE;
488: l_new_dist_cost igi_iac_det_balances.adjustment_cost%TYPE;
489: l_new_dist_nbv igi_iac_det_balances.net_book_value%TYPE;
490: l_new_dist_rr_cost igi_iac_det_balances.reval_reserve_cost%TYPE;
491: l_new_dist_rr_net igi_iac_det_balances.reval_reserve_net%TYPE;
492: l_new_dist_op_cost igi_iac_det_balances.operating_acct_cost%TYPE;

Line 489: l_new_dist_nbv igi_iac_det_balances.net_book_value%TYPE;

485: l_dist_idx NUMBER;
486: l_add_cost igi_iac_det_balances.adjustment_cost%TYPE;
487: l_dist_id igi_iac_det_balances.distribution_id%TYPE;
488: l_new_dist_cost igi_iac_det_balances.adjustment_cost%TYPE;
489: l_new_dist_nbv igi_iac_det_balances.net_book_value%TYPE;
490: l_new_dist_rr_cost igi_iac_det_balances.reval_reserve_cost%TYPE;
491: l_new_dist_rr_net igi_iac_det_balances.reval_reserve_net%TYPE;
492: l_new_dist_op_cost igi_iac_det_balances.operating_acct_cost%TYPE;
493: l_new_dist_op_net igi_iac_det_balances.operating_acct_net%TYPE;

Line 490: l_new_dist_rr_cost igi_iac_det_balances.reval_reserve_cost%TYPE;

486: l_add_cost igi_iac_det_balances.adjustment_cost%TYPE;
487: l_dist_id igi_iac_det_balances.distribution_id%TYPE;
488: l_new_dist_cost igi_iac_det_balances.adjustment_cost%TYPE;
489: l_new_dist_nbv igi_iac_det_balances.net_book_value%TYPE;
490: l_new_dist_rr_cost igi_iac_det_balances.reval_reserve_cost%TYPE;
491: l_new_dist_rr_net igi_iac_det_balances.reval_reserve_net%TYPE;
492: l_new_dist_op_cost igi_iac_det_balances.operating_acct_cost%TYPE;
493: l_new_dist_op_net igi_iac_det_balances.operating_acct_net%TYPE;
494:

Line 491: l_new_dist_rr_net igi_iac_det_balances.reval_reserve_net%TYPE;

487: l_dist_id igi_iac_det_balances.distribution_id%TYPE;
488: l_new_dist_cost igi_iac_det_balances.adjustment_cost%TYPE;
489: l_new_dist_nbv igi_iac_det_balances.net_book_value%TYPE;
490: l_new_dist_rr_cost igi_iac_det_balances.reval_reserve_cost%TYPE;
491: l_new_dist_rr_net igi_iac_det_balances.reval_reserve_net%TYPE;
492: l_new_dist_op_cost igi_iac_det_balances.operating_acct_cost%TYPE;
493: l_new_dist_op_net igi_iac_det_balances.operating_acct_net%TYPE;
494:
495: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;

Line 492: l_new_dist_op_cost igi_iac_det_balances.operating_acct_cost%TYPE;

488: l_new_dist_cost igi_iac_det_balances.adjustment_cost%TYPE;
489: l_new_dist_nbv igi_iac_det_balances.net_book_value%TYPE;
490: l_new_dist_rr_cost igi_iac_det_balances.reval_reserve_cost%TYPE;
491: l_new_dist_rr_net igi_iac_det_balances.reval_reserve_net%TYPE;
492: l_new_dist_op_cost igi_iac_det_balances.operating_acct_cost%TYPE;
493: l_new_dist_op_net igi_iac_det_balances.operating_acct_net%TYPE;
494:
495: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;
496: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;

Line 493: l_new_dist_op_net igi_iac_det_balances.operating_acct_net%TYPE;

489: l_new_dist_nbv igi_iac_det_balances.net_book_value%TYPE;
490: l_new_dist_rr_cost igi_iac_det_balances.reval_reserve_cost%TYPE;
491: l_new_dist_rr_net igi_iac_det_balances.reval_reserve_net%TYPE;
492: l_new_dist_op_cost igi_iac_det_balances.operating_acct_cost%TYPE;
493: l_new_dist_op_net igi_iac_det_balances.operating_acct_net%TYPE;
494:
495: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;
496: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;
497: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 764: -- create a new row in igi_iac_det_balances for each active distribution where only the cost

760: THEN
761: RAISE e_no_proration;
762: END IF;
763:
764: -- create a new row in igi_iac_det_balances for each active distribution where only the cost
765: -- will change and the other amounts will be same as those for the previous active adjustment
766: FOR l_dist_idx IN l_det_table.FIRST..l_det_table.LAST LOOP
767:
768: l_dist_id := l_det_table(l_dist_idx).distribution_id;

Line 838: -- insert the row into igi_iac_det_balances

834:
835: l_new_dist_nbv := l_new_dist_nbv + (l_iac_new_nbv - l_round_diff_nbv);
836: END IF;
837:
838: -- insert the row into igi_iac_det_balances
839: IGI_IAC_DET_BALANCES_PKG.Insert_Row(
840: x_rowid => l_rowid,
841: x_adjustment_id => l_new_adj_id,
842: x_asset_id => l_asset_id,

Line 839: IGI_IAC_DET_BALANCES_PKG.Insert_Row(

835: l_new_dist_nbv := l_new_dist_nbv + (l_iac_new_nbv - l_round_diff_nbv);
836: END IF;
837:
838: -- insert the row into igi_iac_det_balances
839: IGI_IAC_DET_BALANCES_PKG.Insert_Row(
840: x_rowid => l_rowid,
841: x_adjustment_id => l_new_adj_id,
842: x_asset_id => l_asset_id,
843: x_book_type_code => l_book_type_code,