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_ASSET_BALANCES

Line 158: CURSOR c_iac_asset_bal(cp_asset_id igi_iac_asset_balances.asset_id%TYPE,

154: AND date_ineffective IS NULL;
155: */
156:
157: -- cursor to get iac asset balance information
158: CURSOR c_iac_asset_bal(cp_asset_id igi_iac_asset_balances.asset_id%TYPE,
159: cp_book_type_code igi_iac_asset_balances.book_type_code%TYPE,
160: cp_period_counter igi_iac_asset_balances.period_counter%TYPE)
161: IS
162: SELECT period_counter,

Line 159: cp_book_type_code igi_iac_asset_balances.book_type_code%TYPE,

155: */
156:
157: -- cursor to get iac asset balance information
158: CURSOR c_iac_asset_bal(cp_asset_id igi_iac_asset_balances.asset_id%TYPE,
159: cp_book_type_code igi_iac_asset_balances.book_type_code%TYPE,
160: cp_period_counter igi_iac_asset_balances.period_counter%TYPE)
161: IS
162: SELECT period_counter,
163: net_book_value,

Line 160: cp_period_counter igi_iac_asset_balances.period_counter%TYPE)

156:
157: -- cursor to get iac asset balance information
158: CURSOR c_iac_asset_bal(cp_asset_id igi_iac_asset_balances.asset_id%TYPE,
159: cp_book_type_code igi_iac_asset_balances.book_type_code%TYPE,
160: cp_period_counter igi_iac_asset_balances.period_counter%TYPE)
161: IS
162: SELECT period_counter,
163: net_book_value,
164: adjusted_cost,

Line 174: FROM igi_iac_asset_balances

170: general_fund,
171: last_reval_date,
172: current_reval_factor,
173: cumulative_reval_factor
174: FROM igi_iac_asset_balances
175: WHERE asset_id = cp_asset_id
176: AND book_type_code = cp_book_type_code
177: AND period_counter = cp_period_counter;
178:

Line 282: l_iac_new_deprn_adj_amt igi_iac_asset_balances.deprn_amount%TYPE;

278: l_rsvd_pc igi_iac_transaction_headers.period_counter%TYPE;
279: l_iac_asset_bal c_iac_asset_bal%ROWTYPE;
280:
281: l_fa_deprn_adj_amount fa_deprn_detail.deprn_adjustment_amount%TYPE;
282: l_iac_new_deprn_adj_amt igi_iac_asset_balances.deprn_amount%TYPE;
283: l_iac_new_deprn_period igi_iac_asset_balances.deprn_amount%TYPE;
284: l_iac_new_deprn_reserve igi_iac_asset_balances.deprn_reserve%TYPE;
285:
286: l_iac_new_nbv igi_iac_asset_balances.net_book_value%TYPE;

Line 283: l_iac_new_deprn_period igi_iac_asset_balances.deprn_amount%TYPE;

279: l_iac_asset_bal c_iac_asset_bal%ROWTYPE;
280:
281: l_fa_deprn_adj_amount fa_deprn_detail.deprn_adjustment_amount%TYPE;
282: l_iac_new_deprn_adj_amt igi_iac_asset_balances.deprn_amount%TYPE;
283: l_iac_new_deprn_period igi_iac_asset_balances.deprn_amount%TYPE;
284: l_iac_new_deprn_reserve igi_iac_asset_balances.deprn_reserve%TYPE;
285:
286: l_iac_new_nbv igi_iac_asset_balances.net_book_value%TYPE;
287: l_iac_new_rr igi_iac_asset_balances.reval_reserve%TYPE;

Line 284: l_iac_new_deprn_reserve igi_iac_asset_balances.deprn_reserve%TYPE;

280:
281: l_fa_deprn_adj_amount fa_deprn_detail.deprn_adjustment_amount%TYPE;
282: l_iac_new_deprn_adj_amt igi_iac_asset_balances.deprn_amount%TYPE;
283: l_iac_new_deprn_period igi_iac_asset_balances.deprn_amount%TYPE;
284: l_iac_new_deprn_reserve igi_iac_asset_balances.deprn_reserve%TYPE;
285:
286: l_iac_new_nbv igi_iac_asset_balances.net_book_value%TYPE;
287: l_iac_new_rr igi_iac_asset_balances.reval_reserve%TYPE;
288: l_iac_new_gf igi_iac_asset_balances.general_fund%TYPE;

Line 286: l_iac_new_nbv igi_iac_asset_balances.net_book_value%TYPE;

282: l_iac_new_deprn_adj_amt igi_iac_asset_balances.deprn_amount%TYPE;
283: l_iac_new_deprn_period igi_iac_asset_balances.deprn_amount%TYPE;
284: l_iac_new_deprn_reserve igi_iac_asset_balances.deprn_reserve%TYPE;
285:
286: l_iac_new_nbv igi_iac_asset_balances.net_book_value%TYPE;
287: l_iac_new_rr igi_iac_asset_balances.reval_reserve%TYPE;
288: l_iac_new_gf igi_iac_asset_balances.general_fund%TYPE;
289:
290: l_fa_idx NUMBER;

Line 287: l_iac_new_rr igi_iac_asset_balances.reval_reserve%TYPE;

283: l_iac_new_deprn_period igi_iac_asset_balances.deprn_amount%TYPE;
284: l_iac_new_deprn_reserve igi_iac_asset_balances.deprn_reserve%TYPE;
285:
286: l_iac_new_nbv igi_iac_asset_balances.net_book_value%TYPE;
287: l_iac_new_rr igi_iac_asset_balances.reval_reserve%TYPE;
288: l_iac_new_gf igi_iac_asset_balances.general_fund%TYPE;
289:
290: l_fa_idx NUMBER;
291: l_det_bal c_det_bal%ROWTYPE;

Line 288: l_iac_new_gf igi_iac_asset_balances.general_fund%TYPE;

284: l_iac_new_deprn_reserve igi_iac_asset_balances.deprn_reserve%TYPE;
285:
286: l_iac_new_nbv igi_iac_asset_balances.net_book_value%TYPE;
287: l_iac_new_rr igi_iac_asset_balances.reval_reserve%TYPE;
288: l_iac_new_gf igi_iac_asset_balances.general_fund%TYPE;
289:
290: l_fa_idx NUMBER;
291: l_det_bal c_det_bal%ROWTYPE;
292: l_det_table IGI_IAC_TYPES.dist_amt_tab;

Line 473: -- Fetch the latest IGI_IAC_ASSET_BALANCES for the asset regardless of type

469: p_string => 'asset is depreciable with life');
470: l_rsvd_pc := l_last_period_counter;
471: END IF;
472:
473: -- Fetch the latest IGI_IAC_ASSET_BALANCES for the asset regardless of type
474: -- bug 3391000, start 1
475: /* OPEN c_iac_asset_bal(l_asset_id,
476: l_book_type_code,
477: l_rsvd_pc);

Line 484: -- Fetch the latest IGI_IAC_ASSET_BALANCES for the asset regardless of type

480: RAISE NO_DATA_FOUND ;
481: END IF ;
482: CLOSE c_iac_asset_bal; */
483:
484: -- Fetch the latest IGI_IAC_ASSET_BALANCES for the asset regardless of type
485: -- if a balance row exists for the latest open period counter then retrieve
486: -- that else, retrieve the last active row
487: OPEN c_iac_asset_bal(l_asset_id,
488: l_book_type_code,

Line 977: -- check if a row exists in igi_iac_asset_balances for l_last_period_counter

973: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
974: p_full_path => l_path_name,
975: p_string => 'YTD rows rolled forward');
976:
977: -- check if a row exists in igi_iac_asset_balances for l_last_period_counter
978: -- if it does then update it else insert a new row
979: SELECT count(*)
980: INTO l_exists
981: FROM igi_iac_asset_balances

Line 981: FROM igi_iac_asset_balances

977: -- check if a row exists in igi_iac_asset_balances for l_last_period_counter
978: -- if it does then update it else insert a new row
979: SELECT count(*)
980: INTO l_exists
981: FROM igi_iac_asset_balances
982: WHERE asset_id = l_asset_id
983: AND book_type_code = l_book_type_code
984: AND period_counter = l_last_period_counter;
985:

Line 986: -- Update row in IGI_IAC_ASSET_BALANCES for the asset for the new revalued iac cost using

982: WHERE asset_id = l_asset_id
983: AND book_type_code = l_book_type_code
984: AND period_counter = l_last_period_counter;
985:
986: -- Update row in IGI_IAC_ASSET_BALANCES for the asset for the new revalued iac cost using
987: -- IGI_IAC_ASSET_BALANCES.Update_Row
988:
989: IF p_asset_iac_adj_info.period_counter_fully_reserved IS NOT NULL THEN
990: l_iac_deprn_period_amount := 0;

Line 987: -- IGI_IAC_ASSET_BALANCES.Update_Row

983: AND book_type_code = l_book_type_code
984: AND period_counter = l_last_period_counter;
985:
986: -- Update row in IGI_IAC_ASSET_BALANCES for the asset for the new revalued iac cost using
987: -- IGI_IAC_ASSET_BALANCES.Update_Row
988:
989: IF p_asset_iac_adj_info.period_counter_fully_reserved IS NOT NULL THEN
990: l_iac_deprn_period_amount := 0;
991: ELSE

Line 996: IGI_IAC_ASSET_BALANCES_PKG.Update_Row(

992: l_iac_deprn_period_amount := l_iac_new_deprn_period;
993: END IF;
994:
995: IF (l_exists > 0) THEN
996: IGI_IAC_ASSET_BALANCES_PKG.Update_Row(
997: X_asset_id => l_asset_id,
998: X_book_type_code => l_book_type_code,
999: X_period_counter => l_iac_asset_bal.period_counter,
1000: X_net_book_value => l_iac_new_nbv, -- l_iac_asset_bal.net_book_value,

Line 1014: IGI_IAC_ASSET_BALANCES_PKG.Insert_Row(

1010: X_cumulative_reval_factor => l_iac_asset_bal.cumulative_reval_factor
1011: ) ;
1012: ELSE
1013: -- insert a row for the last period counter
1014: IGI_IAC_ASSET_BALANCES_PKG.Insert_Row(
1015: X_rowid => l_rowid,
1016: X_asset_id => l_asset_id,
1017: X_book_type_code => l_book_type_code,
1018: X_period_counter => l_last_period_counter,