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_DEPRN_PKG dependencies on FA_BOOKS

Line 135: FROM fa_books bk, fa_additions ad

131: ) return BOOLEAN IS
132:
133: CURSOR c_get_non_deprn_assets IS
134: SELECT bk.asset_id, ad.asset_category_id
135: FROM fa_books bk, fa_additions ad
136: WHERE bk.book_type_code = p_book_type_code
137: AND bk.transaction_header_id_out IS NULL
138: AND bk.depreciate_flag = 'NO'
139: AND bk.adjustment_required_status = 'ADD'

Line 212: CURSOR c_fa_books(p_asset_id fa_books.asset_id%TYPE) IS

208: AND asset_id = p_asset_id
209: AND distribution_id = cp_distribution_id;
210:
211: /* Cursor to get fully reserved, fully retired info for the asset from FA */
212: CURSOR c_fa_books(p_asset_id fa_books.asset_id%TYPE) IS
213: SELECT period_counter_fully_reserved, period_counter_fully_retired,
214: life_in_months, transaction_header_id_in, depreciate_flag,salvage_value,rate_adjustment_factor,cost
215: FROM fa_books
216: WHERE book_type_code = p_book_type_code

Line 215: FROM fa_books

211: /* Cursor to get fully reserved, fully retired info for the asset from FA */
212: CURSOR c_fa_books(p_asset_id fa_books.asset_id%TYPE) IS
213: SELECT period_counter_fully_reserved, period_counter_fully_retired,
214: life_in_months, transaction_header_id_in, depreciate_flag,salvage_value,rate_adjustment_factor,cost
215: FROM fa_books
216: WHERE book_type_code = p_book_type_code
217: AND asset_id = p_asset_id
218: AND date_ineffective is NULL ;
219:

Line 221: CURSOR c_get_prev_asset_life(p_asset_id fa_books.asset_id%TYPE,

217: AND asset_id = p_asset_id
218: AND date_ineffective is NULL ;
219:
220: /* Cursor to get previous life of asset */
221: CURSOR c_get_prev_asset_life(p_asset_id fa_books.asset_id%TYPE,
222: p_transaction_id fa_books.transaction_header_id_in%TYPE) IS
223: SELECT life_in_months
224: FROM fa_books
225: WHERE book_type_code = p_book_type_code

Line 222: p_transaction_id fa_books.transaction_header_id_in%TYPE) IS

218: AND date_ineffective is NULL ;
219:
220: /* Cursor to get previous life of asset */
221: CURSOR c_get_prev_asset_life(p_asset_id fa_books.asset_id%TYPE,
222: p_transaction_id fa_books.transaction_header_id_in%TYPE) IS
223: SELECT life_in_months
224: FROM fa_books
225: WHERE book_type_code = p_book_type_code
226: AND asset_id = p_asset_id

Line 224: FROM fa_books

220: /* Cursor to get previous life of asset */
221: CURSOR c_get_prev_asset_life(p_asset_id fa_books.asset_id%TYPE,
222: p_transaction_id fa_books.transaction_header_id_in%TYPE) IS
223: SELECT life_in_months
224: FROM fa_books
225: WHERE book_type_code = p_book_type_code
226: AND asset_id = p_asset_id
227: AND transaction_header_id_out = p_transaction_id
228: AND adjustment_required_status <> 'ADD';

Line 231: CURSOR c_get_transaction_info(p_transaction_id fa_books.transaction_header_id_in%TYPE) IS

227: AND transaction_header_id_out = p_transaction_id
228: AND adjustment_required_status <> 'ADD';
229:
230: /* Cursor to get the date of the transaction */
231: CURSOR c_get_transaction_info(p_transaction_id fa_books.transaction_header_id_in%TYPE) IS
232: SELECT transaction_date_entered
233: FROM fa_transaction_headers
234: WHERE transaction_header_id = p_transaction_id;
235:

Line 322: l_fully_reserved fa_books.period_counter_fully_reserved%TYPE ;

318: AND distribution_id = cp_distribution_id
319: AND period_counter = p_period_counter - 1
320: AND nvl(active_flag,'Y') = 'N';
321:
322: l_fully_reserved fa_books.period_counter_fully_reserved%TYPE ;
323: l_fully_retired fa_books.period_counter_fully_retired%TYPE ;
324: l_life_in_months fa_books.life_in_months%TYPE ;
325: l_depreciate_flag fa_books.depreciate_flag%TYPE;
326: l_prev_life_months fa_books.life_in_months%TYPE ;

Line 323: l_fully_retired fa_books.period_counter_fully_retired%TYPE ;

319: AND period_counter = p_period_counter - 1
320: AND nvl(active_flag,'Y') = 'N';
321:
322: l_fully_reserved fa_books.period_counter_fully_reserved%TYPE ;
323: l_fully_retired fa_books.period_counter_fully_retired%TYPE ;
324: l_life_in_months fa_books.life_in_months%TYPE ;
325: l_depreciate_flag fa_books.depreciate_flag%TYPE;
326: l_prev_life_months fa_books.life_in_months%TYPE ;
327: l_asset_balance igi_iac_asset_balances%ROWTYPE;

Line 324: l_life_in_months fa_books.life_in_months%TYPE ;

320: AND nvl(active_flag,'Y') = 'N';
321:
322: l_fully_reserved fa_books.period_counter_fully_reserved%TYPE ;
323: l_fully_retired fa_books.period_counter_fully_retired%TYPE ;
324: l_life_in_months fa_books.life_in_months%TYPE ;
325: l_depreciate_flag fa_books.depreciate_flag%TYPE;
326: l_prev_life_months fa_books.life_in_months%TYPE ;
327: l_asset_balance igi_iac_asset_balances%ROWTYPE;
328: l_asset_balance_next igi_iac_asset_balances%ROWTYPE;

Line 325: l_depreciate_flag fa_books.depreciate_flag%TYPE;

321:
322: l_fully_reserved fa_books.period_counter_fully_reserved%TYPE ;
323: l_fully_retired fa_books.period_counter_fully_retired%TYPE ;
324: l_life_in_months fa_books.life_in_months%TYPE ;
325: l_depreciate_flag fa_books.depreciate_flag%TYPE;
326: l_prev_life_months fa_books.life_in_months%TYPE ;
327: l_asset_balance igi_iac_asset_balances%ROWTYPE;
328: l_asset_balance_next igi_iac_asset_balances%ROWTYPE;
329: l_asset_balance_curr igi_iac_asset_balances%ROWTYPE;

Line 326: l_prev_life_months fa_books.life_in_months%TYPE ;

322: l_fully_reserved fa_books.period_counter_fully_reserved%TYPE ;
323: l_fully_retired fa_books.period_counter_fully_retired%TYPE ;
324: l_life_in_months fa_books.life_in_months%TYPE ;
325: l_depreciate_flag fa_books.depreciate_flag%TYPE;
326: l_prev_life_months fa_books.life_in_months%TYPE ;
327: l_asset_balance igi_iac_asset_balances%ROWTYPE;
328: l_asset_balance_next igi_iac_asset_balances%ROWTYPE;
329: l_asset_balance_curr igi_iac_asset_balances%ROWTYPE;
330: l_detail_balance igi_iac_det_balances%ROWTYPE;

Line 364: l_fa_transaction_id fa_books.transaction_header_id_in%TYPE;

360: l_periods_in_year fa_calendar_types.number_per_fiscal_year%TYPE;
361: l_total_periods NUMBER;
362: l_last_period_counter NUMBER;
363: l_max_period_counter NUMBER;
364: l_fa_transaction_id fa_books.transaction_header_id_in%TYPE;
365: l_transaction_date fa_transaction_headers.transaction_date_entered%TYPE;
366: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;
367: l_Transaction_Id igi_iac_transaction_headers.transaction_header_id%TYPE;
368: l_Mass_Reference_ID igi_iac_transaction_headers.mass_reference_id%TYPE;

Line 456: OPEN c_fa_books(l_fa_asset_id(l_loop_count));

452:
453: FOR l_loop_count IN 1.. l_fa_asset_id.count
454: LOOP
455:
456: OPEN c_fa_books(l_fa_asset_id(l_loop_count));
457: FETCH c_fa_books into l_fully_reserved,
458: l_fully_retired,
459: l_life_in_months,
460: l_fa_transaction_id,

Line 457: FETCH c_fa_books into l_fully_reserved,

453: FOR l_loop_count IN 1.. l_fa_asset_id.count
454: LOOP
455:
456: OPEN c_fa_books(l_fa_asset_id(l_loop_count));
457: FETCH c_fa_books into l_fully_reserved,
458: l_fully_retired,
459: l_life_in_months,
460: l_fa_transaction_id,
461: l_depreciate_flag,

Line 465: CLOSE c_fa_books;

461: l_depreciate_flag,
462: l_salvage_value,
463: l_rate_adjustment_factor,
464: l_cost;
465: CLOSE c_fa_books;
466: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Asset_id :'||to_char(l_fa_asset_id(l_loop_count)));
467: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' FA Transaction id :'||to_char(l_fa_transaction_id));
468:
469: l_transaction_date := NULL;