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.

[Home] [Help]

APPS.IGI_IAC_ADJ_AMORT_PKG dependencies on IGI_IAC_ADJUSTMENTS

Line 118: p_adj_hist igi_iac_adjustments_history%ROWTYPE,

114: -- do the Amortization Depreciation revaluation for the asset
115: -- -------------------------------------------------------------------
116: FUNCTION Do_Amort_Deprn_Reval(p_asset_iac_adj_info igi_iac_types.iac_adj_hist_asset_info,
117: p_asset_iac_dist_info igi_iac_types.iac_adj_dist_info_tab,
118: p_adj_hist igi_iac_adjustments_history%ROWTYPE,
119: p_event_id number) --R12 uptake
120: RETURN BOOLEAN
121: IS
122: -- cursors

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

215: WHERE book_type_code = cp_book_type_code
216: AND asset_id = cp_asset_id
217: AND period_counter = cp_period_counter;
218:
219: CURSOR c_get_period_first_adj(cp_asset_id igi_iac_adjustments_history.asset_id%TYPE,
220: cp_book_type_code igi_iac_adjustments_history.book_type_code%TYPE,
221: cp_period_counter igi_iac_adjustments_history.period_counter%TYPE)
222: IS
223: SELECT ah.pre_adjusted_cost, ah.pre_salvage_value

Line 220: cp_book_type_code igi_iac_adjustments_history.book_type_code%TYPE,

216: AND asset_id = cp_asset_id
217: AND period_counter = cp_period_counter;
218:
219: CURSOR c_get_period_first_adj(cp_asset_id igi_iac_adjustments_history.asset_id%TYPE,
220: cp_book_type_code igi_iac_adjustments_history.book_type_code%TYPE,
221: cp_period_counter igi_iac_adjustments_history.period_counter%TYPE)
222: IS
223: SELECT ah.pre_adjusted_cost, ah.pre_salvage_value
224: FROM igi_iac_adjustments_history ah

Line 221: cp_period_counter igi_iac_adjustments_history.period_counter%TYPE)

217: AND period_counter = cp_period_counter;
218:
219: CURSOR c_get_period_first_adj(cp_asset_id igi_iac_adjustments_history.asset_id%TYPE,
220: cp_book_type_code igi_iac_adjustments_history.book_type_code%TYPE,
221: cp_period_counter igi_iac_adjustments_history.period_counter%TYPE)
222: IS
223: SELECT ah.pre_adjusted_cost, ah.pre_salvage_value
224: FROM igi_iac_adjustments_history ah
225: WHERE ah.book_type_code = cp_book_type_code

Line 224: FROM igi_iac_adjustments_history ah

220: cp_book_type_code igi_iac_adjustments_history.book_type_code%TYPE,
221: cp_period_counter igi_iac_adjustments_history.period_counter%TYPE)
222: IS
223: SELECT ah.pre_adjusted_cost, ah.pre_salvage_value
224: FROM igi_iac_adjustments_history ah
225: WHERE ah.book_type_code = cp_book_type_code
226: AND ah.asset_id = cp_asset_id
227: AND ah.transaction_header_id_in = (SELECT min(iah.transaction_header_id_in)
228: FROM igi_iac_adjustments_history iah

Line 228: FROM igi_iac_adjustments_history iah

224: FROM igi_iac_adjustments_history ah
225: WHERE ah.book_type_code = cp_book_type_code
226: AND ah.asset_id = cp_asset_id
227: AND ah.transaction_header_id_in = (SELECT min(iah.transaction_header_id_in)
228: FROM igi_iac_adjustments_history iah
229: WHERE iah.book_type_code = cp_book_type_code
230: AND iah.asset_id = cp_asset_id
231: AND iah.period_counter = cp_period_counter);
232:

Line 273: l_units_assigned igi_iac_adjustments.units_assigned%TYPE;

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

Line 290: l_ccid igi_iac_adjustments.code_combination_id%TYPE;

286: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;
287: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;
288: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
289:
290: l_ccid igi_iac_adjustments.code_combination_id%TYPE;
291: l_reval_rsv_ccid igi_iac_adjustments.code_combination_id%TYPE;
292: l_exists NUMBER;
293: l_ret BOOLEAN;
294:

Line 291: l_reval_rsv_ccid igi_iac_adjustments.code_combination_id%TYPE;

287: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;
288: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
289:
290: l_ccid igi_iac_adjustments.code_combination_id%TYPE;
291: l_reval_rsv_ccid igi_iac_adjustments.code_combination_id%TYPE;
292: l_exists NUMBER;
293: l_ret BOOLEAN;
294:
295: l_deprn_amount fa_deprn_detail.deprn_amount%TYPE;

Line 743: -- insert into igi_iac_adjustments for EXPENSE

739: THEN
740: RAISE e_no_ccid_found;
741: END IF;
742:
743: -- insert into igi_iac_adjustments for EXPENSE
744: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
745: x_rowid => l_rowid,
746: x_adjustment_id => l_new_adj_id,
747: x_book_type_code => l_book_type_code,

Line 744: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(

740: RAISE e_no_ccid_found;
741: END IF;
742:
743: -- insert into igi_iac_adjustments for EXPENSE
744: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
745: x_rowid => l_rowid,
746: x_adjustment_id => l_new_adj_id,
747: x_book_type_code => l_book_type_code,
748: x_code_combination_id => l_ccid,

Line 778: -- insert into igi_iac_adjustments for RESERVE

774: THEN
775: RAISE e_no_ccid_found;
776: END IF;
777:
778: -- insert into igi_iac_adjustments for RESERVE
779: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
780: x_rowid => l_rowid,
781: x_adjustment_id => l_new_adj_id,
782: x_book_type_code => l_book_type_code,

Line 779: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(

775: RAISE e_no_ccid_found;
776: END IF;
777:
778: -- insert into igi_iac_adjustments for RESERVE
779: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
780: x_rowid => l_rowid,
781: x_adjustment_id => l_new_adj_id,
782: x_book_type_code => l_book_type_code,
783: x_code_combination_id => l_ccid,

Line 814: -- insert into igi_iac_adjustments for EXPENSE

810: THEN
811: RAISE e_no_ccid_found;
812: END IF;
813:
814: -- insert into igi_iac_adjustments for EXPENSE
815: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
816: x_rowid => l_rowid,
817: x_adjustment_id => l_new_adj_id,
818: x_book_type_code => l_book_type_code,

Line 815: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(

811: RAISE e_no_ccid_found;
812: END IF;
813:
814: -- insert into igi_iac_adjustments for EXPENSE
815: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
816: x_rowid => l_rowid,
817: x_adjustment_id => l_new_adj_id,
818: x_book_type_code => l_book_type_code,
819: x_code_combination_id => l_reval_rsv_ccid,

Line 849: -- insert into igi_iac_adjustments for EXPENSE

845: THEN
846: RAISE e_no_ccid_found;
847: END IF;
848:
849: -- insert into igi_iac_adjustments for EXPENSE
850: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
851: x_rowid => l_rowid,
852: x_adjustment_id => l_new_adj_id,
853: x_book_type_code => l_book_type_code,

Line 850: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(

846: RAISE e_no_ccid_found;
847: END IF;
848:
849: -- insert into igi_iac_adjustments for EXPENSE
850: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
851: x_rowid => l_rowid,
852: x_adjustment_id => l_new_adj_id,
853: x_book_type_code => l_book_type_code,
854: x_code_combination_id => l_ccid,