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_COST_REVAL_PKG dependencies on IGI_IAC_TRANSACTION_HEADERS

Line 442: CURSOR c_get_period_counter(cp_latest_adj_id igi_iac_transaction_headers.ADJUSTMENT_ID%TYPE)

438: WHERE iifd.adjustment_id = cp_adjustment_id
439: AND iifd.distribution_id = cp_distribution_id
440: AND iifd.active_flag IS NULL;
441:
442: CURSOR c_get_period_counter(cp_latest_adj_id igi_iac_transaction_headers.ADJUSTMENT_ID%TYPE)
443: IS
444: SELECT period_counter
445: FROM igi_iac_transaction_headers
446: WHERE adjustment_id = cp_latest_adj_id;

Line 445: FROM igi_iac_transaction_headers

441:
442: CURSOR c_get_period_counter(cp_latest_adj_id igi_iac_transaction_headers.ADJUSTMENT_ID%TYPE)
443: IS
444: SELECT period_counter
445: FROM igi_iac_transaction_headers
446: WHERE adjustment_id = cp_latest_adj_id;
447:
448:
449: -- cursor to check if asset is non depreciating

Line 464: l_adj_id_out igi_iac_transaction_headers.adjustment_id_out%TYPE;

460: l_asset_id fa_books.asset_id%TYPE;
461: l_book_type_code fa_books.book_type_code%TYPE;
462: l_fully_rsvd_pc fa_books.period_counter_fully_reserved%TYPE;
463: -- l_deprn_flag fa_books.depreciate_flag%TYPE;
464: l_adj_id_out igi_iac_transaction_headers.adjustment_id_out%TYPE;
465:
466: l_latest_trx_type igi_iac_transaction_headers.transaction_type_code%TYPE;
467: l_latest_trx_id igi_iac_transaction_headers.transaction_header_id%TYPE;
468: l_latest_mref_id igi_iac_transaction_headers.mass_reference_id%TYPE;

Line 466: l_latest_trx_type igi_iac_transaction_headers.transaction_type_code%TYPE;

462: l_fully_rsvd_pc fa_books.period_counter_fully_reserved%TYPE;
463: -- l_deprn_flag fa_books.depreciate_flag%TYPE;
464: l_adj_id_out igi_iac_transaction_headers.adjustment_id_out%TYPE;
465:
466: l_latest_trx_type igi_iac_transaction_headers.transaction_type_code%TYPE;
467: l_latest_trx_id igi_iac_transaction_headers.transaction_header_id%TYPE;
468: l_latest_mref_id igi_iac_transaction_headers.mass_reference_id%TYPE;
469: l_latest_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
470: l_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;

Line 467: l_latest_trx_id igi_iac_transaction_headers.transaction_header_id%TYPE;

463: -- l_deprn_flag fa_books.depreciate_flag%TYPE;
464: l_adj_id_out igi_iac_transaction_headers.adjustment_id_out%TYPE;
465:
466: l_latest_trx_type igi_iac_transaction_headers.transaction_type_code%TYPE;
467: l_latest_trx_id igi_iac_transaction_headers.transaction_header_id%TYPE;
468: l_latest_mref_id igi_iac_transaction_headers.mass_reference_id%TYPE;
469: l_latest_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
470: l_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
471: l_latest_adj_status igi_iac_transaction_headers.adjustment_status%TYPE;

Line 468: l_latest_mref_id igi_iac_transaction_headers.mass_reference_id%TYPE;

464: l_adj_id_out igi_iac_transaction_headers.adjustment_id_out%TYPE;
465:
466: l_latest_trx_type igi_iac_transaction_headers.transaction_type_code%TYPE;
467: l_latest_trx_id igi_iac_transaction_headers.transaction_header_id%TYPE;
468: l_latest_mref_id igi_iac_transaction_headers.mass_reference_id%TYPE;
469: l_latest_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
470: l_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
471: l_latest_adj_status igi_iac_transaction_headers.adjustment_status%TYPE;
472: l_iac_asset_bal c_iac_asset_bal%ROWTYPE;

Line 469: l_latest_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;

465:
466: l_latest_trx_type igi_iac_transaction_headers.transaction_type_code%TYPE;
467: l_latest_trx_id igi_iac_transaction_headers.transaction_header_id%TYPE;
468: l_latest_mref_id igi_iac_transaction_headers.mass_reference_id%TYPE;
469: l_latest_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
470: l_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
471: l_latest_adj_status igi_iac_transaction_headers.adjustment_status%TYPE;
472: l_iac_asset_bal c_iac_asset_bal%ROWTYPE;
473: l_new_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;

Line 470: l_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;

466: l_latest_trx_type igi_iac_transaction_headers.transaction_type_code%TYPE;
467: l_latest_trx_id igi_iac_transaction_headers.transaction_header_id%TYPE;
468: l_latest_mref_id igi_iac_transaction_headers.mass_reference_id%TYPE;
469: l_latest_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
470: l_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
471: l_latest_adj_status igi_iac_transaction_headers.adjustment_status%TYPE;
472: l_iac_asset_bal c_iac_asset_bal%ROWTYPE;
473: l_new_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
474: l_prd_rec IGI_IAC_TYPES.prd_rec;

Line 471: l_latest_adj_status igi_iac_transaction_headers.adjustment_status%TYPE;

467: l_latest_trx_id igi_iac_transaction_headers.transaction_header_id%TYPE;
468: l_latest_mref_id igi_iac_transaction_headers.mass_reference_id%TYPE;
469: l_latest_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
470: l_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
471: l_latest_adj_status igi_iac_transaction_headers.adjustment_status%TYPE;
472: l_iac_asset_bal c_iac_asset_bal%ROWTYPE;
473: l_new_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
474: l_prd_rec IGI_IAC_TYPES.prd_rec;
475: l_iac_new_reval_cost igi_iac_asset_balances.adjusted_cost%TYPE;

Line 473: l_new_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;

469: l_latest_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
470: l_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
471: l_latest_adj_status igi_iac_transaction_headers.adjustment_status%TYPE;
472: l_iac_asset_bal c_iac_asset_bal%ROWTYPE;
473: l_new_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
474: l_prd_rec IGI_IAC_TYPES.prd_rec;
475: l_iac_new_reval_cost igi_iac_asset_balances.adjusted_cost%TYPE;
476: l_iac_new_nbv igi_iac_asset_balances.net_book_value%TYPE;
477: l_iac_new_rr igi_iac_asset_balances.reval_reserve%TYPE;

Line 509: l_last_period_counter igi_iac_transaction_headers.period_counter%TYPE;

505: l_op_exp_ccid igi_iac_adjustments.code_combination_id%TYPE;
506: l_report_ccid igi_iac_adjustments.code_combination_id%TYPE;
507: l_adjustment_offset_type VARCHAR2(50);
508: l_units_assigned igi_iac_adjustments.units_assigned%TYPE;
509: l_last_period_counter igi_iac_transaction_headers.period_counter%TYPE;
510: l_rsvd_pc igi_iac_transaction_headers.period_counter%TYPE;
511:
512: l_sob_id NUMBER;
513: l_coa_id NUMBER;

Line 510: l_rsvd_pc igi_iac_transaction_headers.period_counter%TYPE;

506: l_report_ccid igi_iac_adjustments.code_combination_id%TYPE;
507: l_adjustment_offset_type VARCHAR2(50);
508: l_units_assigned igi_iac_adjustments.units_assigned%TYPE;
509: l_last_period_counter igi_iac_transaction_headers.period_counter%TYPE;
510: l_rsvd_pc igi_iac_transaction_headers.period_counter%TYPE;
511:
512: l_sob_id NUMBER;
513: l_coa_id NUMBER;
514: l_currency VARCHAR2(15);

Line 624: FROM igi_iac_transaction_headers

620: -- get the period counter associated with the latest adjustment
621: -- for the asset
622: SELECT period_counter
623: INTO l_rsvd_pc
624: FROM igi_iac_transaction_headers
625: WHERE adjustment_id = l_latest_adj_id;
626: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
627: p_full_path => l_path_name,
628: p_string => 'Last period counter for fully reserved or non deprn asset: '||l_rsvd_pc);

Line 688: -- create a new row in igi_iac_transaction_headers with transaction type code

684: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
685: p_full_path => l_path_name,
686: p_string => 'Latest period counter: '||l_last_period_counter);
687:
688: -- create a new row in igi_iac_transaction_headers with transaction type code
689: -- ADJUSTMENT and transaction sub type as COST
690: l_new_adj_id := null;
691:
692: IGI_IAC_TRANS_HEADERS_PKG.Insert_Row(

Line 715: -- update the previous active row for the asset in igi_iac_transaction_headers

711: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
712: p_full_path => l_path_name,
713: p_string => 'New adjustment id: '||l_new_adj_id);
714:
715: -- update the previous active row for the asset in igi_iac_transaction_headers
716: -- in order to make it inactive by setting adjustment_id_out= adjustment_id of
717: -- the active row in igi_iac_transaction_headers
718: IGI_IAC_TRANS_HEADERS_PKG.Update_Row(
719: x_prev_adjustment_id => l_adj_id_out,

Line 717: -- the active row in igi_iac_transaction_headers

713: p_string => 'New adjustment id: '||l_new_adj_id);
714:
715: -- update the previous active row for the asset in igi_iac_transaction_headers
716: -- in order to make it inactive by setting adjustment_id_out= adjustment_id of
717: -- the active row in igi_iac_transaction_headers
718: IGI_IAC_TRANS_HEADERS_PKG.Update_Row(
719: x_prev_adjustment_id => l_adj_id_out,
720: x_adjustment_id => l_new_adj_id
721: );