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

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

153: AND book_type_code = cp_book_type_code
154: AND period_counter = cp_period_counter;
155:
156: -- cursor to get the detail balances for a distribution
157: CURSOR c_det_bal(cp_adjust_id igi_iac_det_balances.adjustment_id%TYPE,
158: cp_asset_id fa_books.asset_id%TYPE,
159: cp_book_type_code fa_books.book_type_code%TYPE,
160: cp_dist_id igi_iac_det_balances.distribution_id%TYPE)
161: IS

Line 160: cp_dist_id igi_iac_det_balances.distribution_id%TYPE)

156: -- cursor to get the detail balances for a distribution
157: CURSOR c_det_bal(cp_adjust_id igi_iac_det_balances.adjustment_id%TYPE,
158: cp_asset_id fa_books.asset_id%TYPE,
159: cp_book_type_code fa_books.book_type_code%TYPE,
160: cp_dist_id igi_iac_det_balances.distribution_id%TYPE)
161: IS
162: SELECT iidb.adjustment_id,
163: iidb.distribution_id,
164: iidb.period_counter,

Line 185: FROM igi_iac_det_balances iidb

181: iidb.last_reval_date,
182: iidb.current_reval_factor,
183: iidb.cumulative_reval_factor,
184: iidb.active_flag
185: FROM igi_iac_det_balances iidb
186: WHERE iidb.adjustment_id = cp_adjust_id
187: AND iidb.book_type_code = cp_book_type_code
188: AND iidb.asset_id = cp_asset_id
189: AND iidb.distribution_id = cp_dist_id

Line 271: l_dist_id igi_iac_det_balances.distribution_id%TYPE;

267: l_fa_idx NUMBER;
268: l_det_bal c_det_bal%ROWTYPE;
269: l_det_table IGI_IAC_TYPES.dist_amt_tab;
270: l_dist_idx NUMBER;
271: l_dist_id igi_iac_det_balances.distribution_id%TYPE;
272: l_dep_adj_amount igi_iac_det_balances.deprn_period%TYPE;
273: l_units_assigned igi_iac_adjustments.units_assigned%TYPE;
274:
275: l_new_dist_dep_prd igi_iac_det_balances.deprn_period%TYPE;

Line 272: l_dep_adj_amount igi_iac_det_balances.deprn_period%TYPE;

268: l_det_bal c_det_bal%ROWTYPE;
269: l_det_table IGI_IAC_TYPES.dist_amt_tab;
270: l_dist_idx NUMBER;
271: l_dist_id igi_iac_det_balances.distribution_id%TYPE;
272: l_dep_adj_amount igi_iac_det_balances.deprn_period%TYPE;
273: l_units_assigned igi_iac_adjustments.units_assigned%TYPE;
274:
275: l_new_dist_dep_prd igi_iac_det_balances.deprn_period%TYPE;
276: l_new_dist_dep_rsv igi_iac_det_balances.deprn_reserve%TYPE;

Line 275: l_new_dist_dep_prd igi_iac_det_balances.deprn_period%TYPE;

271: l_dist_id igi_iac_det_balances.distribution_id%TYPE;
272: l_dep_adj_amount igi_iac_det_balances.deprn_period%TYPE;
273: l_units_assigned igi_iac_adjustments.units_assigned%TYPE;
274:
275: l_new_dist_dep_prd igi_iac_det_balances.deprn_period%TYPE;
276: l_new_dist_dep_rsv igi_iac_det_balances.deprn_reserve%TYPE;
277: l_new_dist_dep_ytd igi_iac_det_balances.deprn_ytd%TYPE;
278:
279: l_new_dist_nbv igi_iac_det_balances.net_book_value%TYPE;

Line 276: l_new_dist_dep_rsv igi_iac_det_balances.deprn_reserve%TYPE;

272: l_dep_adj_amount igi_iac_det_balances.deprn_period%TYPE;
273: l_units_assigned igi_iac_adjustments.units_assigned%TYPE;
274:
275: l_new_dist_dep_prd igi_iac_det_balances.deprn_period%TYPE;
276: l_new_dist_dep_rsv igi_iac_det_balances.deprn_reserve%TYPE;
277: l_new_dist_dep_ytd igi_iac_det_balances.deprn_ytd%TYPE;
278:
279: l_new_dist_nbv igi_iac_det_balances.net_book_value%TYPE;
280: l_new_dist_rr_gf igi_iac_det_balances.reval_reserve_gen_fund%TYPE;

Line 277: l_new_dist_dep_ytd igi_iac_det_balances.deprn_ytd%TYPE;

273: l_units_assigned igi_iac_adjustments.units_assigned%TYPE;
274:
275: l_new_dist_dep_prd igi_iac_det_balances.deprn_period%TYPE;
276: l_new_dist_dep_rsv igi_iac_det_balances.deprn_reserve%TYPE;
277: l_new_dist_dep_ytd igi_iac_det_balances.deprn_ytd%TYPE;
278:
279: l_new_dist_nbv igi_iac_det_balances.net_book_value%TYPE;
280: l_new_dist_rr_gf igi_iac_det_balances.reval_reserve_gen_fund%TYPE;
281: l_new_dist_rr_net igi_iac_det_balances.reval_reserve_net%TYPE;

Line 279: l_new_dist_nbv igi_iac_det_balances.net_book_value%TYPE;

275: l_new_dist_dep_prd igi_iac_det_balances.deprn_period%TYPE;
276: l_new_dist_dep_rsv igi_iac_det_balances.deprn_reserve%TYPE;
277: l_new_dist_dep_ytd igi_iac_det_balances.deprn_ytd%TYPE;
278:
279: l_new_dist_nbv igi_iac_det_balances.net_book_value%TYPE;
280: l_new_dist_rr_gf igi_iac_det_balances.reval_reserve_gen_fund%TYPE;
281: l_new_dist_rr_net igi_iac_det_balances.reval_reserve_net%TYPE;
282: l_new_dist_gf_per igi_iac_det_balances.general_fund_per%TYPE;
283: l_new_dist_gf_acc igi_iac_det_balances.general_fund_acc%TYPE;

Line 280: l_new_dist_rr_gf igi_iac_det_balances.reval_reserve_gen_fund%TYPE;

276: l_new_dist_dep_rsv igi_iac_det_balances.deprn_reserve%TYPE;
277: l_new_dist_dep_ytd igi_iac_det_balances.deprn_ytd%TYPE;
278:
279: l_new_dist_nbv igi_iac_det_balances.net_book_value%TYPE;
280: l_new_dist_rr_gf igi_iac_det_balances.reval_reserve_gen_fund%TYPE;
281: l_new_dist_rr_net igi_iac_det_balances.reval_reserve_net%TYPE;
282: l_new_dist_gf_per igi_iac_det_balances.general_fund_per%TYPE;
283: l_new_dist_gf_acc igi_iac_det_balances.general_fund_acc%TYPE;
284:

Line 281: l_new_dist_rr_net igi_iac_det_balances.reval_reserve_net%TYPE;

277: l_new_dist_dep_ytd igi_iac_det_balances.deprn_ytd%TYPE;
278:
279: l_new_dist_nbv igi_iac_det_balances.net_book_value%TYPE;
280: l_new_dist_rr_gf igi_iac_det_balances.reval_reserve_gen_fund%TYPE;
281: l_new_dist_rr_net igi_iac_det_balances.reval_reserve_net%TYPE;
282: l_new_dist_gf_per igi_iac_det_balances.general_fund_per%TYPE;
283: l_new_dist_gf_acc igi_iac_det_balances.general_fund_acc%TYPE;
284:
285: l_round_diff NUMBER ;

Line 282: l_new_dist_gf_per igi_iac_det_balances.general_fund_per%TYPE;

278:
279: l_new_dist_nbv igi_iac_det_balances.net_book_value%TYPE;
280: l_new_dist_rr_gf igi_iac_det_balances.reval_reserve_gen_fund%TYPE;
281: l_new_dist_rr_net igi_iac_det_balances.reval_reserve_net%TYPE;
282: l_new_dist_gf_per igi_iac_det_balances.general_fund_per%TYPE;
283: l_new_dist_gf_acc igi_iac_det_balances.general_fund_acc%TYPE;
284:
285: l_round_diff NUMBER ;
286: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;

Line 283: l_new_dist_gf_acc igi_iac_det_balances.general_fund_acc%TYPE;

279: l_new_dist_nbv igi_iac_det_balances.net_book_value%TYPE;
280: l_new_dist_rr_gf igi_iac_det_balances.reval_reserve_gen_fund%TYPE;
281: l_new_dist_rr_net igi_iac_det_balances.reval_reserve_net%TYPE;
282: l_new_dist_gf_per igi_iac_det_balances.general_fund_per%TYPE;
283: l_new_dist_gf_acc igi_iac_det_balances.general_fund_acc%TYPE;
284:
285: l_round_diff NUMBER ;
286: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;
287: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;

Line 626: -- create a new row in igi_iac_det_balances for each active distribution

622: END IF;
623:
624: l_round_diff := 0;
625:
626: -- create a new row in igi_iac_det_balances for each active distribution
627: FOR l_dist_idx IN l_det_table.FIRST..l_det_table.LAST LOOP
628: l_dist_id := l_det_table(l_dist_idx).distribution_id;
629: l_dep_adj_amount := l_det_table(l_dist_idx).amount;
630: l_units_assigned := l_det_table(l_dist_idx).units;

Line 694: -- insert the row into igi_iac_det_balances

690: -- calculate the nbv
691: -- l_new_dist_nbv := l_det_bal.net_book_value - l_dep_adj_amount;
692: l_new_dist_nbv := l_det_bal.adjustment_cost -
693: (l_new_dist_dep_rsv + l_det_bal.deprn_reserve_backlog);
694: -- insert the row into igi_iac_det_balances
695: IF p_asset_iac_adj_info.period_counter_fully_reserved IS NOT NULL THEN
696: l_iac_deprn_period_amount := 0;
697: ELSE
698: l_iac_deprn_period_amount := l_new_dist_dep_prd;

Line 701: IGI_IAC_DET_BALANCES_PKG.Insert_Row(

697: ELSE
698: l_iac_deprn_period_amount := l_new_dist_dep_prd;
699: END IF;
700:
701: IGI_IAC_DET_BALANCES_PKG.Insert_Row(
702: x_rowid => l_rowid,
703: x_adjustment_id => l_new_adj_id,
704: x_asset_id => l_asset_id,
705: x_book_type_code => l_book_type_code,