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 FA_BOOKS

Line 147: CURSOR c_asset_non_depr(cp_asset_id fa_books.asset_id%TYPE,

143: RETURN BOOLEAN
144: IS
145: -- cursors
146: /*-- cursor to check if asset is non depreciating
147: CURSOR c_asset_non_depr(cp_asset_id fa_books.asset_id%TYPE,
148: cp_book_type_code fa_books.book_type_code%TYPE)
149: IS
150: SELECT depreciate_flag
151: FROM fa_books

Line 148: cp_book_type_code fa_books.book_type_code%TYPE)

144: IS
145: -- cursors
146: /*-- cursor to check if asset is non depreciating
147: CURSOR c_asset_non_depr(cp_asset_id fa_books.asset_id%TYPE,
148: cp_book_type_code fa_books.book_type_code%TYPE)
149: IS
150: SELECT depreciate_flag
151: FROM fa_books
152: WHERE book_type_code = cp_book_type_code

Line 151: FROM fa_books

147: CURSOR c_asset_non_depr(cp_asset_id fa_books.asset_id%TYPE,
148: cp_book_type_code fa_books.book_type_code%TYPE)
149: IS
150: SELECT depreciate_flag
151: FROM fa_books
152: WHERE book_type_code = cp_book_type_code
153: AND asset_id = cp_asset_id
154: AND date_ineffective IS NULL;
155: */

Line 181: cp_asset_id fa_books.asset_id%TYPE,

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
185: SELECT iidb.adjustment_id,

Line 182: cp_book_type_code fa_books.book_type_code%TYPE,

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
185: SELECT iidb.adjustment_id,
186: iidb.distribution_id,

Line 258: l_asset_id fa_books.asset_id%TYPE;

254: AND iah.period_counter = cp_period_counter);
255:
256:
257: -- local variables
258: l_asset_id fa_books.asset_id%TYPE;
259: l_book_type_code fa_books.book_type_code%TYPE;
260: l_last_period_counter igi_iac_transaction_headers.period_counter%TYPE;
261: l_sob_id NUMBER;
262: l_coa_id NUMBER;

Line 259: l_book_type_code fa_books.book_type_code%TYPE;

255:
256:
257: -- local variables
258: l_asset_id fa_books.asset_id%TYPE;
259: l_book_type_code fa_books.book_type_code%TYPE;
260: l_last_period_counter igi_iac_transaction_headers.period_counter%TYPE;
261: l_sob_id NUMBER;
262: l_coa_id NUMBER;
263: l_currency VARCHAR2(15);

Line 274: l_fully_rsvd_pc fa_books.period_counter_fully_reserved%TYPE;

270: l_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
271: l_latest_adj_status igi_iac_transaction_headers.adjustment_status%TYPE;
272: l_adj_id_out igi_iac_transaction_headers.adjustment_id_out%TYPE;
273:
274: l_fully_rsvd_pc fa_books.period_counter_fully_reserved%TYPE;
275: -- l_deprn_flag fa_books.depreciate_flag%TYPE;
276:
277: l_new_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
278: l_rsvd_pc igi_iac_transaction_headers.period_counter%TYPE;

Line 275: -- l_deprn_flag fa_books.depreciate_flag%TYPE;

271: l_latest_adj_status igi_iac_transaction_headers.adjustment_status%TYPE;
272: l_adj_id_out igi_iac_transaction_headers.adjustment_id_out%TYPE;
273:
274: l_fully_rsvd_pc fa_books.period_counter_fully_reserved%TYPE;
275: -- l_deprn_flag fa_books.depreciate_flag%TYPE;
276:
277: l_new_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
278: l_rsvd_pc igi_iac_transaction_headers.period_counter%TYPE;
279: l_iac_asset_bal c_iac_asset_bal%ROWTYPE;

Line 320: l_prev_cost fa_books.cost%TYPE;

316: l_ret BOOLEAN;
317:
318: l_deprn_amount fa_deprn_detail.deprn_amount%TYPE;
319: l_deprn_reserve fa_deprn_detail.deprn_reserve%TYPE;
320: l_prev_cost fa_books.cost%TYPE;
321: l_prev_salvage fa_books.salvage_value%TYPE;
322: l_curr_cost fa_books.cost%TYPE;
323: l_curr_Salvage fa_books.salvage_value%TYPE;
324: l_prev_sv_correction NUMBER;

Line 321: l_prev_salvage fa_books.salvage_value%TYPE;

317:
318: l_deprn_amount fa_deprn_detail.deprn_amount%TYPE;
319: l_deprn_reserve fa_deprn_detail.deprn_reserve%TYPE;
320: l_prev_cost fa_books.cost%TYPE;
321: l_prev_salvage fa_books.salvage_value%TYPE;
322: l_curr_cost fa_books.cost%TYPE;
323: l_curr_Salvage fa_books.salvage_value%TYPE;
324: l_prev_sv_correction NUMBER;
325: l_curr_sv_correction NUMBER;

Line 322: l_curr_cost fa_books.cost%TYPE;

318: l_deprn_amount fa_deprn_detail.deprn_amount%TYPE;
319: l_deprn_reserve fa_deprn_detail.deprn_reserve%TYPE;
320: l_prev_cost fa_books.cost%TYPE;
321: l_prev_salvage fa_books.salvage_value%TYPE;
322: l_curr_cost fa_books.cost%TYPE;
323: l_curr_Salvage fa_books.salvage_value%TYPE;
324: l_prev_sv_correction NUMBER;
325: l_curr_sv_correction NUMBER;
326: l_diff_sv_correction NUMBER;

Line 323: l_curr_Salvage fa_books.salvage_value%TYPE;

319: l_deprn_reserve fa_deprn_detail.deprn_reserve%TYPE;
320: l_prev_cost fa_books.cost%TYPE;
321: l_prev_salvage fa_books.salvage_value%TYPE;
322: l_curr_cost fa_books.cost%TYPE;
323: l_curr_Salvage fa_books.salvage_value%TYPE;
324: l_prev_sv_correction NUMBER;
325: l_curr_sv_correction NUMBER;
326: l_diff_sv_correction NUMBER;
327: l_iac_deprn_period_amount NUMBER;