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 135: CURSOR c_iac_asset_bal(cp_asset_id igi_iac_asset_balances.asset_id%TYPE,

131: AND date_ineffective IS NULL;
132: */
133:
134: -- cursor to get iac asset balance information
135: CURSOR c_iac_asset_bal(cp_asset_id igi_iac_asset_balances.asset_id%TYPE,
136: cp_book_type_code igi_iac_asset_balances.book_type_code%TYPE,
137: cp_period_counter igi_iac_asset_balances.period_counter%TYPE)
138: IS
139: SELECT period_counter,

Line 136: cp_book_type_code igi_iac_asset_balances.book_type_code%TYPE,

132: */
133:
134: -- cursor to get iac asset balance information
135: CURSOR c_iac_asset_bal(cp_asset_id igi_iac_asset_balances.asset_id%TYPE,
136: cp_book_type_code igi_iac_asset_balances.book_type_code%TYPE,
137: cp_period_counter igi_iac_asset_balances.period_counter%TYPE)
138: IS
139: SELECT period_counter,
140: net_book_value,

Line 137: cp_period_counter igi_iac_asset_balances.period_counter%TYPE)

133:
134: -- cursor to get iac asset balance information
135: CURSOR c_iac_asset_bal(cp_asset_id igi_iac_asset_balances.asset_id%TYPE,
136: cp_book_type_code igi_iac_asset_balances.book_type_code%TYPE,
137: cp_period_counter igi_iac_asset_balances.period_counter%TYPE)
138: IS
139: SELECT period_counter,
140: net_book_value,
141: adjusted_cost,

Line 151: FROM igi_iac_asset_balances

147: general_fund,
148: last_reval_date,
149: current_reval_factor,
150: cumulative_reval_factor
151: FROM igi_iac_asset_balances
152: WHERE asset_id = cp_asset_id
153: AND book_type_code = cp_book_type_code
154: AND period_counter = cp_period_counter;
155:

Line 259: l_iac_new_deprn_adj_amt igi_iac_asset_balances.deprn_amount%TYPE;

255: l_rsvd_pc igi_iac_transaction_headers.period_counter%TYPE;
256: l_iac_asset_bal c_iac_asset_bal%ROWTYPE;
257:
258: l_fa_deprn_adj_amount fa_deprn_detail.deprn_adjustment_amount%TYPE;
259: l_iac_new_deprn_adj_amt igi_iac_asset_balances.deprn_amount%TYPE;
260: l_iac_new_deprn_period igi_iac_asset_balances.deprn_amount%TYPE;
261: l_iac_new_deprn_reserve igi_iac_asset_balances.deprn_reserve%TYPE;
262:
263: l_iac_new_nbv igi_iac_asset_balances.net_book_value%TYPE;

Line 260: l_iac_new_deprn_period igi_iac_asset_balances.deprn_amount%TYPE;

256: l_iac_asset_bal c_iac_asset_bal%ROWTYPE;
257:
258: l_fa_deprn_adj_amount fa_deprn_detail.deprn_adjustment_amount%TYPE;
259: l_iac_new_deprn_adj_amt igi_iac_asset_balances.deprn_amount%TYPE;
260: l_iac_new_deprn_period igi_iac_asset_balances.deprn_amount%TYPE;
261: l_iac_new_deprn_reserve igi_iac_asset_balances.deprn_reserve%TYPE;
262:
263: l_iac_new_nbv igi_iac_asset_balances.net_book_value%TYPE;
264: l_iac_new_rr igi_iac_asset_balances.reval_reserve%TYPE;

Line 261: l_iac_new_deprn_reserve igi_iac_asset_balances.deprn_reserve%TYPE;

257:
258: l_fa_deprn_adj_amount fa_deprn_detail.deprn_adjustment_amount%TYPE;
259: l_iac_new_deprn_adj_amt igi_iac_asset_balances.deprn_amount%TYPE;
260: l_iac_new_deprn_period igi_iac_asset_balances.deprn_amount%TYPE;
261: l_iac_new_deprn_reserve igi_iac_asset_balances.deprn_reserve%TYPE;
262:
263: l_iac_new_nbv igi_iac_asset_balances.net_book_value%TYPE;
264: l_iac_new_rr igi_iac_asset_balances.reval_reserve%TYPE;
265: l_iac_new_gf igi_iac_asset_balances.general_fund%TYPE;

Line 263: l_iac_new_nbv igi_iac_asset_balances.net_book_value%TYPE;

259: l_iac_new_deprn_adj_amt igi_iac_asset_balances.deprn_amount%TYPE;
260: l_iac_new_deprn_period igi_iac_asset_balances.deprn_amount%TYPE;
261: l_iac_new_deprn_reserve igi_iac_asset_balances.deprn_reserve%TYPE;
262:
263: l_iac_new_nbv igi_iac_asset_balances.net_book_value%TYPE;
264: l_iac_new_rr igi_iac_asset_balances.reval_reserve%TYPE;
265: l_iac_new_gf igi_iac_asset_balances.general_fund%TYPE;
266:
267: l_fa_idx NUMBER;

Line 264: l_iac_new_rr igi_iac_asset_balances.reval_reserve%TYPE;

260: l_iac_new_deprn_period igi_iac_asset_balances.deprn_amount%TYPE;
261: l_iac_new_deprn_reserve igi_iac_asset_balances.deprn_reserve%TYPE;
262:
263: l_iac_new_nbv igi_iac_asset_balances.net_book_value%TYPE;
264: l_iac_new_rr igi_iac_asset_balances.reval_reserve%TYPE;
265: l_iac_new_gf igi_iac_asset_balances.general_fund%TYPE;
266:
267: l_fa_idx NUMBER;
268: l_det_bal c_det_bal%ROWTYPE;

Line 265: l_iac_new_gf igi_iac_asset_balances.general_fund%TYPE;

261: l_iac_new_deprn_reserve igi_iac_asset_balances.deprn_reserve%TYPE;
262:
263: l_iac_new_nbv igi_iac_asset_balances.net_book_value%TYPE;
264: l_iac_new_rr igi_iac_asset_balances.reval_reserve%TYPE;
265: l_iac_new_gf igi_iac_asset_balances.general_fund%TYPE;
266:
267: l_fa_idx NUMBER;
268: l_det_bal c_det_bal%ROWTYPE;
269: l_det_table IGI_IAC_TYPES.dist_amt_tab;

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

446: p_string => 'asset is depreciable with life');
447: l_rsvd_pc := l_last_period_counter;
448: END IF;
449:
450: -- Fetch the latest IGI_IAC_ASSET_BALANCES for the asset regardless of type
451: -- bug 3391000, start 1
452: /* OPEN c_iac_asset_bal(l_asset_id,
453: l_book_type_code,
454: l_rsvd_pc);

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

457: RAISE NO_DATA_FOUND ;
458: END IF ;
459: CLOSE c_iac_asset_bal; */
460:
461: -- Fetch the latest IGI_IAC_ASSET_BALANCES for the asset regardless of type
462: -- if a balance row exists for the latest open period counter then retrieve
463: -- that else, retrieve the last active row
464: OPEN c_iac_asset_bal(l_asset_id,
465: l_book_type_code,

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

948: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
949: p_full_path => l_path_name,
950: p_string => 'YTD rows rolled forward');
951:
952: -- check if a row exists in igi_iac_asset_balances for l_last_period_counter
953: -- if it does then update it else insert a new row
954: SELECT count(*)
955: INTO l_exists
956: FROM igi_iac_asset_balances

Line 956: FROM igi_iac_asset_balances

952: -- check if a row exists in igi_iac_asset_balances for l_last_period_counter
953: -- if it does then update it else insert a new row
954: SELECT count(*)
955: INTO l_exists
956: FROM igi_iac_asset_balances
957: WHERE asset_id = l_asset_id
958: AND book_type_code = l_book_type_code
959: AND period_counter = l_last_period_counter;
960:

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

957: WHERE asset_id = l_asset_id
958: AND book_type_code = l_book_type_code
959: AND period_counter = l_last_period_counter;
960:
961: -- Update row in IGI_IAC_ASSET_BALANCES for the asset for the new revalued iac cost using
962: -- IGI_IAC_ASSET_BALANCES.Update_Row
963:
964: IF p_asset_iac_adj_info.period_counter_fully_reserved IS NOT NULL THEN
965: l_iac_deprn_period_amount := 0;

Line 962: -- IGI_IAC_ASSET_BALANCES.Update_Row

958: AND book_type_code = l_book_type_code
959: AND period_counter = l_last_period_counter;
960:
961: -- Update row in IGI_IAC_ASSET_BALANCES for the asset for the new revalued iac cost using
962: -- IGI_IAC_ASSET_BALANCES.Update_Row
963:
964: IF p_asset_iac_adj_info.period_counter_fully_reserved IS NOT NULL THEN
965: l_iac_deprn_period_amount := 0;
966: ELSE

Line 971: IGI_IAC_ASSET_BALANCES_PKG.Update_Row(

967: l_iac_deprn_period_amount := l_iac_new_deprn_period;
968: END IF;
969:
970: IF (l_exists > 0) THEN
971: IGI_IAC_ASSET_BALANCES_PKG.Update_Row(
972: X_asset_id => l_asset_id,
973: X_book_type_code => l_book_type_code,
974: X_period_counter => l_iac_asset_bal.period_counter,
975: X_net_book_value => l_iac_new_nbv, -- l_iac_asset_bal.net_book_value,

Line 989: IGI_IAC_ASSET_BALANCES_PKG.Insert_Row(

985: X_cumulative_reval_factor => l_iac_asset_bal.cumulative_reval_factor
986: ) ;
987: ELSE
988: -- insert a row for the last period counter
989: IGI_IAC_ASSET_BALANCES_PKG.Insert_Row(
990: X_rowid => l_rowid,
991: X_asset_id => l_asset_id,
992: X_book_type_code => l_book_type_code,
993: X_period_counter => l_last_period_counter,