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 124: CURSOR c_asset_non_depr(cp_asset_id fa_books.asset_id%TYPE,

120: RETURN BOOLEAN
121: IS
122: -- cursors
123: /*-- cursor to check if asset is non depreciating
124: CURSOR c_asset_non_depr(cp_asset_id fa_books.asset_id%TYPE,
125: cp_book_type_code fa_books.book_type_code%TYPE)
126: IS
127: SELECT depreciate_flag
128: FROM fa_books

Line 125: cp_book_type_code fa_books.book_type_code%TYPE)

121: IS
122: -- cursors
123: /*-- cursor to check if asset is non depreciating
124: CURSOR c_asset_non_depr(cp_asset_id fa_books.asset_id%TYPE,
125: cp_book_type_code fa_books.book_type_code%TYPE)
126: IS
127: SELECT depreciate_flag
128: FROM fa_books
129: WHERE book_type_code = cp_book_type_code

Line 128: FROM fa_books

124: CURSOR c_asset_non_depr(cp_asset_id fa_books.asset_id%TYPE,
125: cp_book_type_code fa_books.book_type_code%TYPE)
126: IS
127: SELECT depreciate_flag
128: FROM fa_books
129: WHERE book_type_code = cp_book_type_code
130: AND asset_id = cp_asset_id
131: AND date_ineffective IS NULL;
132: */

Line 158: cp_asset_id fa_books.asset_id%TYPE,

154: AND period_counter = cp_period_counter;
155:
156: -- cursor to get the detail balances for a distribution
157: CURSOR c_det_bal(cp_adjust_id igi_iac_det_balances.adjustment_id%TYPE,
158: cp_asset_id fa_books.asset_id%TYPE,
159: cp_book_type_code fa_books.book_type_code%TYPE,
160: cp_dist_id igi_iac_det_balances.distribution_id%TYPE)
161: IS
162: SELECT iidb.adjustment_id,

Line 159: cp_book_type_code fa_books.book_type_code%TYPE,

155:
156: -- cursor to get the detail balances for a distribution
157: CURSOR c_det_bal(cp_adjust_id igi_iac_det_balances.adjustment_id%TYPE,
158: cp_asset_id fa_books.asset_id%TYPE,
159: cp_book_type_code fa_books.book_type_code%TYPE,
160: cp_dist_id igi_iac_det_balances.distribution_id%TYPE)
161: IS
162: SELECT iidb.adjustment_id,
163: iidb.distribution_id,

Line 235: l_asset_id fa_books.asset_id%TYPE;

231: AND iah.period_counter = cp_period_counter);
232:
233:
234: -- local variables
235: l_asset_id fa_books.asset_id%TYPE;
236: l_book_type_code fa_books.book_type_code%TYPE;
237: l_last_period_counter igi_iac_transaction_headers.period_counter%TYPE;
238: l_sob_id NUMBER;
239: l_coa_id NUMBER;

Line 236: l_book_type_code fa_books.book_type_code%TYPE;

232:
233:
234: -- local variables
235: l_asset_id fa_books.asset_id%TYPE;
236: l_book_type_code fa_books.book_type_code%TYPE;
237: l_last_period_counter igi_iac_transaction_headers.period_counter%TYPE;
238: l_sob_id NUMBER;
239: l_coa_id NUMBER;
240: l_currency VARCHAR2(15);

Line 251: l_fully_rsvd_pc fa_books.period_counter_fully_reserved%TYPE;

247: l_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
248: l_latest_adj_status igi_iac_transaction_headers.adjustment_status%TYPE;
249: l_adj_id_out igi_iac_transaction_headers.adjustment_id_out%TYPE;
250:
251: l_fully_rsvd_pc fa_books.period_counter_fully_reserved%TYPE;
252: -- l_deprn_flag fa_books.depreciate_flag%TYPE;
253:
254: l_new_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
255: l_rsvd_pc igi_iac_transaction_headers.period_counter%TYPE;

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

248: l_latest_adj_status igi_iac_transaction_headers.adjustment_status%TYPE;
249: l_adj_id_out igi_iac_transaction_headers.adjustment_id_out%TYPE;
250:
251: l_fully_rsvd_pc fa_books.period_counter_fully_reserved%TYPE;
252: -- l_deprn_flag fa_books.depreciate_flag%TYPE;
253:
254: l_new_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
255: l_rsvd_pc igi_iac_transaction_headers.period_counter%TYPE;
256: l_iac_asset_bal c_iac_asset_bal%ROWTYPE;

Line 297: l_prev_cost fa_books.cost%TYPE;

293: l_ret BOOLEAN;
294:
295: l_deprn_amount fa_deprn_detail.deprn_amount%TYPE;
296: l_deprn_reserve fa_deprn_detail.deprn_reserve%TYPE;
297: l_prev_cost fa_books.cost%TYPE;
298: l_prev_salvage fa_books.salvage_value%TYPE;
299: l_curr_cost fa_books.cost%TYPE;
300: l_curr_Salvage fa_books.salvage_value%TYPE;
301: l_prev_sv_correction NUMBER;

Line 298: l_prev_salvage fa_books.salvage_value%TYPE;

294:
295: l_deprn_amount fa_deprn_detail.deprn_amount%TYPE;
296: l_deprn_reserve fa_deprn_detail.deprn_reserve%TYPE;
297: l_prev_cost fa_books.cost%TYPE;
298: l_prev_salvage fa_books.salvage_value%TYPE;
299: l_curr_cost fa_books.cost%TYPE;
300: l_curr_Salvage fa_books.salvage_value%TYPE;
301: l_prev_sv_correction NUMBER;
302: l_curr_sv_correction NUMBER;

Line 299: l_curr_cost fa_books.cost%TYPE;

295: l_deprn_amount fa_deprn_detail.deprn_amount%TYPE;
296: l_deprn_reserve fa_deprn_detail.deprn_reserve%TYPE;
297: l_prev_cost fa_books.cost%TYPE;
298: l_prev_salvage fa_books.salvage_value%TYPE;
299: l_curr_cost fa_books.cost%TYPE;
300: l_curr_Salvage fa_books.salvage_value%TYPE;
301: l_prev_sv_correction NUMBER;
302: l_curr_sv_correction NUMBER;
303: l_diff_sv_correction NUMBER;

Line 300: l_curr_Salvage fa_books.salvage_value%TYPE;

296: l_deprn_reserve fa_deprn_detail.deprn_reserve%TYPE;
297: l_prev_cost fa_books.cost%TYPE;
298: l_prev_salvage fa_books.salvage_value%TYPE;
299: l_curr_cost fa_books.cost%TYPE;
300: l_curr_Salvage fa_books.salvage_value%TYPE;
301: l_prev_sv_correction NUMBER;
302: l_curr_sv_correction NUMBER;
303: l_diff_sv_correction NUMBER;
304: l_iac_deprn_period_amount NUMBER;