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 IGI_IAC_TRANSACTION_HEADERS

Line 237: CURSOR c_get_prev_adjustment(p_asset_id igi_iac_transaction_headers.asset_id%TYPE) IS

233: FROM fa_transaction_headers
234: WHERE transaction_header_id = p_transaction_id;
235:
236: /* Cursor to get Current active transaction for asset from IAC */
237: CURSOR c_get_prev_adjustment(p_asset_id igi_iac_transaction_headers.asset_id%TYPE) IS
238: SELECT adjustment_id
239: FROM igi_iac_transaction_headers
240: WHERE asset_id = p_asset_id
241: AND book_type_code = p_book_type_code

Line 239: FROM igi_iac_transaction_headers

235:
236: /* Cursor to get Current active transaction for asset from IAC */
237: CURSOR c_get_prev_adjustment(p_asset_id igi_iac_transaction_headers.asset_id%TYPE) IS
238: SELECT adjustment_id
239: FROM igi_iac_transaction_headers
240: WHERE asset_id = p_asset_id
241: AND book_type_code = p_book_type_code
242: AND adjustment_id_out is NULL ;
243:

Line 366: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;

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;
369: l_Adjustment_Status igi_iac_transaction_headers.adjustment_status%TYPE;
370: l_prev_year_inactive_dist varchar2(1);

Line 367: l_Transaction_Id igi_iac_transaction_headers.transaction_header_id%TYPE;

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;
369: l_Adjustment_Status igi_iac_transaction_headers.adjustment_status%TYPE;
370: l_prev_year_inactive_dist varchar2(1);
371: l_salvage_value Number;

Line 368: l_Mass_Reference_ID igi_iac_transaction_headers.mass_reference_id%TYPE;

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;
369: l_Adjustment_Status igi_iac_transaction_headers.adjustment_status%TYPE;
370: l_prev_year_inactive_dist varchar2(1);
371: l_salvage_value Number;
372: l_salvage_value_correction Number;

Line 369: l_Adjustment_Status igi_iac_transaction_headers.adjustment_status%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;
369: l_Adjustment_Status igi_iac_transaction_headers.adjustment_status%TYPE;
370: l_prev_year_inactive_dist varchar2(1);
371: l_salvage_value Number;
372: l_salvage_value_correction Number;
373: l_rate_adjustment_factor Number;

Line 551: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Inserting into igi_iac_transaction_headers');

547: OPEN c_get_fa_asset(l_fa_asset_id(l_loop_count));
548: FETCH c_get_fa_asset INTO l_category_id,l_asset_units;
549: CLOSE c_get_fa_asset;
550: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Units assigned for the asset :'||to_char(l_asset_units));
551: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Inserting into igi_iac_transaction_headers');
552: l_adjustment_id := NULL;
553: l_rowid := NULL;
554:
555: -- Fetching the event_id from fa_deprn_summary as in case of depreciation

Line 1135: FROM igi_iac_transaction_headers

1131: CURSOR c_get_transaction IS
1132: SELECT adjustment_id,
1133: transaction_header_id,
1134: transaction_type_code
1135: FROM igi_iac_transaction_headers
1136: WHERE book_type_code = p_book_type_code
1137: AND period_counter = p_period_counter
1138: AND transaction_type_code in ('RECLASS','ADDITION','DEPRECIATION');
1139: