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 180: CURSOR c_det_bal(cp_adjust_id igi_iac_det_balances.adjustment_id%TYPE,

176: AND book_type_code = cp_book_type_code
177: AND period_counter = cp_period_counter;
178:
179: -- cursor to get the detail balances for a distribution
180: CURSOR c_det_bal(cp_adjust_id igi_iac_det_balances.adjustment_id%TYPE,
181: cp_asset_id fa_books.asset_id%TYPE,
182: cp_book_type_code fa_books.book_type_code%TYPE,
183: cp_dist_id igi_iac_det_balances.distribution_id%TYPE)
184: IS

Line 183: cp_dist_id igi_iac_det_balances.distribution_id%TYPE)

179: -- cursor to get the detail balances for a distribution
180: CURSOR c_det_bal(cp_adjust_id igi_iac_det_balances.adjustment_id%TYPE,
181: cp_asset_id fa_books.asset_id%TYPE,
182: cp_book_type_code fa_books.book_type_code%TYPE,
183: cp_dist_id igi_iac_det_balances.distribution_id%TYPE)
184: IS
185: SELECT iidb.adjustment_id,
186: iidb.distribution_id,
187: iidb.period_counter,

Line 208: FROM igi_iac_det_balances iidb

204: iidb.last_reval_date,
205: iidb.current_reval_factor,
206: iidb.cumulative_reval_factor,
207: iidb.active_flag
208: FROM igi_iac_det_balances iidb
209: WHERE iidb.adjustment_id = cp_adjust_id
210: AND iidb.book_type_code = cp_book_type_code
211: AND iidb.asset_id = cp_asset_id
212: AND iidb.distribution_id = cp_dist_id

Line 294: l_dist_id igi_iac_det_balances.distribution_id%TYPE;

290: l_fa_idx NUMBER;
291: l_det_bal c_det_bal%ROWTYPE;
292: l_det_table IGI_IAC_TYPES.dist_amt_tab;
293: l_dist_idx NUMBER;
294: l_dist_id igi_iac_det_balances.distribution_id%TYPE;
295: l_dep_adj_amount igi_iac_det_balances.deprn_period%TYPE;
296: l_units_assigned igi_iac_adjustments.units_assigned%TYPE;
297:
298: l_new_dist_dep_prd igi_iac_det_balances.deprn_period%TYPE;

Line 295: l_dep_adj_amount igi_iac_det_balances.deprn_period%TYPE;

291: l_det_bal c_det_bal%ROWTYPE;
292: l_det_table IGI_IAC_TYPES.dist_amt_tab;
293: l_dist_idx NUMBER;
294: l_dist_id igi_iac_det_balances.distribution_id%TYPE;
295: l_dep_adj_amount igi_iac_det_balances.deprn_period%TYPE;
296: l_units_assigned igi_iac_adjustments.units_assigned%TYPE;
297:
298: l_new_dist_dep_prd igi_iac_det_balances.deprn_period%TYPE;
299: l_new_dist_dep_rsv igi_iac_det_balances.deprn_reserve%TYPE;

Line 298: l_new_dist_dep_prd igi_iac_det_balances.deprn_period%TYPE;

294: l_dist_id igi_iac_det_balances.distribution_id%TYPE;
295: l_dep_adj_amount igi_iac_det_balances.deprn_period%TYPE;
296: l_units_assigned igi_iac_adjustments.units_assigned%TYPE;
297:
298: l_new_dist_dep_prd igi_iac_det_balances.deprn_period%TYPE;
299: l_new_dist_dep_rsv igi_iac_det_balances.deprn_reserve%TYPE;
300: l_new_dist_dep_ytd igi_iac_det_balances.deprn_ytd%TYPE;
301:
302: l_new_dist_nbv igi_iac_det_balances.net_book_value%TYPE;

Line 299: l_new_dist_dep_rsv igi_iac_det_balances.deprn_reserve%TYPE;

295: l_dep_adj_amount igi_iac_det_balances.deprn_period%TYPE;
296: l_units_assigned igi_iac_adjustments.units_assigned%TYPE;
297:
298: l_new_dist_dep_prd igi_iac_det_balances.deprn_period%TYPE;
299: l_new_dist_dep_rsv igi_iac_det_balances.deprn_reserve%TYPE;
300: l_new_dist_dep_ytd igi_iac_det_balances.deprn_ytd%TYPE;
301:
302: l_new_dist_nbv igi_iac_det_balances.net_book_value%TYPE;
303: l_new_dist_rr_gf igi_iac_det_balances.reval_reserve_gen_fund%TYPE;

Line 300: l_new_dist_dep_ytd igi_iac_det_balances.deprn_ytd%TYPE;

296: l_units_assigned igi_iac_adjustments.units_assigned%TYPE;
297:
298: l_new_dist_dep_prd igi_iac_det_balances.deprn_period%TYPE;
299: l_new_dist_dep_rsv igi_iac_det_balances.deprn_reserve%TYPE;
300: l_new_dist_dep_ytd igi_iac_det_balances.deprn_ytd%TYPE;
301:
302: l_new_dist_nbv igi_iac_det_balances.net_book_value%TYPE;
303: l_new_dist_rr_gf igi_iac_det_balances.reval_reserve_gen_fund%TYPE;
304: l_new_dist_rr_net igi_iac_det_balances.reval_reserve_net%TYPE;

Line 302: l_new_dist_nbv igi_iac_det_balances.net_book_value%TYPE;

298: l_new_dist_dep_prd igi_iac_det_balances.deprn_period%TYPE;
299: l_new_dist_dep_rsv igi_iac_det_balances.deprn_reserve%TYPE;
300: l_new_dist_dep_ytd igi_iac_det_balances.deprn_ytd%TYPE;
301:
302: l_new_dist_nbv igi_iac_det_balances.net_book_value%TYPE;
303: l_new_dist_rr_gf igi_iac_det_balances.reval_reserve_gen_fund%TYPE;
304: l_new_dist_rr_net igi_iac_det_balances.reval_reserve_net%TYPE;
305: l_new_dist_gf_per igi_iac_det_balances.general_fund_per%TYPE;
306: l_new_dist_gf_acc igi_iac_det_balances.general_fund_acc%TYPE;

Line 303: l_new_dist_rr_gf igi_iac_det_balances.reval_reserve_gen_fund%TYPE;

299: l_new_dist_dep_rsv igi_iac_det_balances.deprn_reserve%TYPE;
300: l_new_dist_dep_ytd igi_iac_det_balances.deprn_ytd%TYPE;
301:
302: l_new_dist_nbv igi_iac_det_balances.net_book_value%TYPE;
303: l_new_dist_rr_gf igi_iac_det_balances.reval_reserve_gen_fund%TYPE;
304: l_new_dist_rr_net igi_iac_det_balances.reval_reserve_net%TYPE;
305: l_new_dist_gf_per igi_iac_det_balances.general_fund_per%TYPE;
306: l_new_dist_gf_acc igi_iac_det_balances.general_fund_acc%TYPE;
307:

Line 304: l_new_dist_rr_net igi_iac_det_balances.reval_reserve_net%TYPE;

300: l_new_dist_dep_ytd igi_iac_det_balances.deprn_ytd%TYPE;
301:
302: l_new_dist_nbv igi_iac_det_balances.net_book_value%TYPE;
303: l_new_dist_rr_gf igi_iac_det_balances.reval_reserve_gen_fund%TYPE;
304: l_new_dist_rr_net igi_iac_det_balances.reval_reserve_net%TYPE;
305: l_new_dist_gf_per igi_iac_det_balances.general_fund_per%TYPE;
306: l_new_dist_gf_acc igi_iac_det_balances.general_fund_acc%TYPE;
307:
308: l_round_diff NUMBER ;

Line 305: l_new_dist_gf_per igi_iac_det_balances.general_fund_per%TYPE;

301:
302: l_new_dist_nbv igi_iac_det_balances.net_book_value%TYPE;
303: l_new_dist_rr_gf igi_iac_det_balances.reval_reserve_gen_fund%TYPE;
304: l_new_dist_rr_net igi_iac_det_balances.reval_reserve_net%TYPE;
305: l_new_dist_gf_per igi_iac_det_balances.general_fund_per%TYPE;
306: l_new_dist_gf_acc igi_iac_det_balances.general_fund_acc%TYPE;
307:
308: l_round_diff NUMBER ;
309: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;

Line 306: l_new_dist_gf_acc igi_iac_det_balances.general_fund_acc%TYPE;

302: l_new_dist_nbv igi_iac_det_balances.net_book_value%TYPE;
303: l_new_dist_rr_gf igi_iac_det_balances.reval_reserve_gen_fund%TYPE;
304: l_new_dist_rr_net igi_iac_det_balances.reval_reserve_net%TYPE;
305: l_new_dist_gf_per igi_iac_det_balances.general_fund_per%TYPE;
306: l_new_dist_gf_acc igi_iac_det_balances.general_fund_acc%TYPE;
307:
308: l_round_diff NUMBER ;
309: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;
310: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;

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

647: END IF;
648:
649: l_round_diff := 0;
650:
651: -- create a new row in igi_iac_det_balances for each active distribution
652: FOR l_dist_idx IN l_det_table.FIRST..l_det_table.LAST LOOP
653: l_dist_id := l_det_table(l_dist_idx).distribution_id;
654: l_dep_adj_amount := l_det_table(l_dist_idx).amount;
655: l_units_assigned := l_det_table(l_dist_idx).units;

Line 719: -- insert the row into igi_iac_det_balances

715: -- calculate the nbv
716: -- l_new_dist_nbv := l_det_bal.net_book_value - l_dep_adj_amount;
717: l_new_dist_nbv := l_det_bal.adjustment_cost -
718: (l_new_dist_dep_rsv + l_det_bal.deprn_reserve_backlog);
719: -- insert the row into igi_iac_det_balances
720: IF p_asset_iac_adj_info.period_counter_fully_reserved IS NOT NULL THEN
721: l_iac_deprn_period_amount := 0;
722: ELSE
723: l_iac_deprn_period_amount := l_new_dist_dep_prd;

Line 726: IGI_IAC_DET_BALANCES_PKG.Insert_Row(

722: ELSE
723: l_iac_deprn_period_amount := l_new_dist_dep_prd;
724: END IF;
725:
726: IGI_IAC_DET_BALANCES_PKG.Insert_Row(
727: x_rowid => l_rowid,
728: x_adjustment_id => l_new_adj_id,
729: x_asset_id => l_asset_id,
730: x_book_type_code => l_book_type_code,