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_ADJUSTMENTS

Line 141: p_adj_hist igi_iac_adjustments_history%ROWTYPE,

137: -- do the Amortization Depreciation revaluation for the asset
138: -- -------------------------------------------------------------------
139: FUNCTION Do_Amort_Deprn_Reval(p_asset_iac_adj_info igi_iac_types.iac_adj_hist_asset_info,
140: p_asset_iac_dist_info igi_iac_types.iac_adj_dist_info_tab,
141: p_adj_hist igi_iac_adjustments_history%ROWTYPE,
142: p_event_id number) --R12 uptake
143: RETURN BOOLEAN
144: IS
145: -- cursors

Line 242: CURSOR c_get_period_first_adj(cp_asset_id igi_iac_adjustments_history.asset_id%TYPE,

238: WHERE book_type_code = cp_book_type_code
239: AND asset_id = cp_asset_id
240: AND period_counter = cp_period_counter;
241:
242: CURSOR c_get_period_first_adj(cp_asset_id igi_iac_adjustments_history.asset_id%TYPE,
243: cp_book_type_code igi_iac_adjustments_history.book_type_code%TYPE,
244: cp_period_counter igi_iac_adjustments_history.period_counter%TYPE)
245: IS
246: SELECT ah.pre_adjusted_cost, ah.pre_salvage_value

Line 243: cp_book_type_code igi_iac_adjustments_history.book_type_code%TYPE,

239: AND asset_id = cp_asset_id
240: AND period_counter = cp_period_counter;
241:
242: CURSOR c_get_period_first_adj(cp_asset_id igi_iac_adjustments_history.asset_id%TYPE,
243: cp_book_type_code igi_iac_adjustments_history.book_type_code%TYPE,
244: cp_period_counter igi_iac_adjustments_history.period_counter%TYPE)
245: IS
246: SELECT ah.pre_adjusted_cost, ah.pre_salvage_value
247: FROM igi_iac_adjustments_history ah

Line 244: cp_period_counter igi_iac_adjustments_history.period_counter%TYPE)

240: AND period_counter = cp_period_counter;
241:
242: CURSOR c_get_period_first_adj(cp_asset_id igi_iac_adjustments_history.asset_id%TYPE,
243: cp_book_type_code igi_iac_adjustments_history.book_type_code%TYPE,
244: cp_period_counter igi_iac_adjustments_history.period_counter%TYPE)
245: IS
246: SELECT ah.pre_adjusted_cost, ah.pre_salvage_value
247: FROM igi_iac_adjustments_history ah
248: WHERE ah.book_type_code = cp_book_type_code

Line 247: FROM igi_iac_adjustments_history ah

243: cp_book_type_code igi_iac_adjustments_history.book_type_code%TYPE,
244: cp_period_counter igi_iac_adjustments_history.period_counter%TYPE)
245: IS
246: SELECT ah.pre_adjusted_cost, ah.pre_salvage_value
247: FROM igi_iac_adjustments_history ah
248: WHERE ah.book_type_code = cp_book_type_code
249: AND ah.asset_id = cp_asset_id
250: AND ah.transaction_header_id_in = (SELECT min(iah.transaction_header_id_in)
251: FROM igi_iac_adjustments_history iah

Line 251: FROM igi_iac_adjustments_history iah

247: FROM igi_iac_adjustments_history ah
248: WHERE ah.book_type_code = cp_book_type_code
249: AND ah.asset_id = cp_asset_id
250: AND ah.transaction_header_id_in = (SELECT min(iah.transaction_header_id_in)
251: FROM igi_iac_adjustments_history iah
252: WHERE iah.book_type_code = cp_book_type_code
253: AND iah.asset_id = cp_asset_id
254: AND iah.period_counter = cp_period_counter);
255:

Line 296: l_units_assigned igi_iac_adjustments.units_assigned%TYPE;

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;
300: l_new_dist_dep_ytd igi_iac_det_balances.deprn_ytd%TYPE;

Line 313: l_ccid igi_iac_adjustments.code_combination_id%TYPE;

309: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;
310: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;
311: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
312:
313: l_ccid igi_iac_adjustments.code_combination_id%TYPE;
314: l_reval_rsv_ccid igi_iac_adjustments.code_combination_id%TYPE;
315: l_exists NUMBER;
316: l_ret BOOLEAN;
317:

Line 314: l_reval_rsv_ccid igi_iac_adjustments.code_combination_id%TYPE;

310: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;
311: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
312:
313: l_ccid igi_iac_adjustments.code_combination_id%TYPE;
314: l_reval_rsv_ccid igi_iac_adjustments.code_combination_id%TYPE;
315: l_exists NUMBER;
316: l_ret BOOLEAN;
317:
318: l_deprn_amount fa_deprn_detail.deprn_amount%TYPE;

Line 768: -- insert into igi_iac_adjustments for EXPENSE

764: THEN
765: RAISE e_no_ccid_found;
766: END IF;
767:
768: -- insert into igi_iac_adjustments for EXPENSE
769: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
770: x_rowid => l_rowid,
771: x_adjustment_id => l_new_adj_id,
772: x_book_type_code => l_book_type_code,

Line 769: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(

765: RAISE e_no_ccid_found;
766: END IF;
767:
768: -- insert into igi_iac_adjustments for EXPENSE
769: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
770: x_rowid => l_rowid,
771: x_adjustment_id => l_new_adj_id,
772: x_book_type_code => l_book_type_code,
773: x_code_combination_id => l_ccid,

Line 803: -- insert into igi_iac_adjustments for RESERVE

799: THEN
800: RAISE e_no_ccid_found;
801: END IF;
802:
803: -- insert into igi_iac_adjustments for RESERVE
804: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
805: x_rowid => l_rowid,
806: x_adjustment_id => l_new_adj_id,
807: x_book_type_code => l_book_type_code,

Line 804: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(

800: RAISE e_no_ccid_found;
801: END IF;
802:
803: -- insert into igi_iac_adjustments for RESERVE
804: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
805: x_rowid => l_rowid,
806: x_adjustment_id => l_new_adj_id,
807: x_book_type_code => l_book_type_code,
808: x_code_combination_id => l_ccid,

Line 839: -- insert into igi_iac_adjustments for EXPENSE

835: THEN
836: RAISE e_no_ccid_found;
837: END IF;
838:
839: -- insert into igi_iac_adjustments for EXPENSE
840: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
841: x_rowid => l_rowid,
842: x_adjustment_id => l_new_adj_id,
843: x_book_type_code => l_book_type_code,

Line 840: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(

836: RAISE e_no_ccid_found;
837: END IF;
838:
839: -- insert into igi_iac_adjustments for EXPENSE
840: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
841: x_rowid => l_rowid,
842: x_adjustment_id => l_new_adj_id,
843: x_book_type_code => l_book_type_code,
844: x_code_combination_id => l_reval_rsv_ccid,

Line 874: -- insert into igi_iac_adjustments for EXPENSE

870: THEN
871: RAISE e_no_ccid_found;
872: END IF;
873:
874: -- insert into igi_iac_adjustments for EXPENSE
875: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
876: x_rowid => l_rowid,
877: x_adjustment_id => l_new_adj_id,
878: x_book_type_code => l_book_type_code,

Line 875: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(

871: RAISE e_no_ccid_found;
872: END IF;
873:
874: -- insert into igi_iac_adjustments for EXPENSE
875: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
876: x_rowid => l_rowid,
877: x_adjustment_id => l_new_adj_id,
878: x_book_type_code => l_book_type_code,
879: x_code_combination_id => l_ccid,