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

Line 462: PROCEDURE find_ccid(p_book_type_code in FA_BOOKS.book_type_code%TYPE,

458:
459: -- ===============================================================================
460: -- Procedure to find the distribution ccid's for various types of accounts
461: -- ===============================================================================
462: PROCEDURE find_ccid(p_book_type_code in FA_BOOKS.book_type_code%TYPE,
463: p_asset_id in FA_BOOKS.asset_id%TYPE,
464: p_transaction_header_id in FA_DISTRIBUTION_HISTORY.transaction_header_id_in%TYPE,
465: p_dist_id in number,
466: p_reval_ccid out NOCOPY number,

Line 463: p_asset_id in FA_BOOKS.asset_id%TYPE,

459: -- ===============================================================================
460: -- Procedure to find the distribution ccid's for various types of accounts
461: -- ===============================================================================
462: PROCEDURE find_ccid(p_book_type_code in FA_BOOKS.book_type_code%TYPE,
463: p_asset_id in FA_BOOKS.asset_id%TYPE,
464: p_transaction_header_id in FA_DISTRIBUTION_HISTORY.transaction_header_id_in%TYPE,
465: p_dist_id in number,
466: p_reval_ccid out NOCOPY number,
467: p_Gen_fund_ccid out NOCOPY number,

Line 576: p_hist_cost IN fa_books.cost%TYPE,

572: p_asset_id IN igi_iac_transaction_headers.asset_id%TYPE,
573: p_book_type_code IN igi_iac_transaction_headers.book_type_code%TYPE,
574: p_curr_prd_cntr IN igi_iac_transaction_headers.period_counter%TYPE,
575: p_tfr_prd_cntr IN igi_iac_transaction_headers.period_counter%TYPE,
576: p_hist_cost IN fa_books.cost%TYPE,
577: p_salvage_value IN fa_books.salvage_value%TYPE,
578: p_trx_header_id IN igi_iac_transaction_headers.transaction_header_id%TYPE,
579: p_asset_units IN fa_distribution_history.units_assigned%TYPE,
580: p_transfer_units IN fa_distribution_history.units_assigned%TYPE,

Line 577: p_salvage_value IN fa_books.salvage_value%TYPE,

573: p_book_type_code IN igi_iac_transaction_headers.book_type_code%TYPE,
574: p_curr_prd_cntr IN igi_iac_transaction_headers.period_counter%TYPE,
575: p_tfr_prd_cntr IN igi_iac_transaction_headers.period_counter%TYPE,
576: p_hist_cost IN fa_books.cost%TYPE,
577: p_salvage_value IN fa_books.salvage_value%TYPE,
578: p_trx_header_id IN igi_iac_transaction_headers.transaction_header_id%TYPE,
579: p_asset_units IN fa_distribution_history.units_assigned%TYPE,
580: p_transfer_units IN fa_distribution_history.units_assigned%TYPE,
581: l_asset_rec OUT NOCOPY asset_rec_type,

Line 1047: -- retrieve salvage value and cost of the asset from fa_books (keep)

1043: SELECT asset_number
1044: FROM fa_additions
1045: WHERE asset_id=p_asset_hdr_rec.asset_id;
1046:
1047: -- retrieve salvage value and cost of the asset from fa_books (keep)
1048: CURSOR c_get_asset_book(p_asset_id fa_books.asset_id%TYPE,
1049: p_book_type_code fa_books.book_type_code%TYPE)
1050: IS
1051: SELECT cost,

Line 1048: CURSOR c_get_asset_book(p_asset_id fa_books.asset_id%TYPE,

1044: FROM fa_additions
1045: WHERE asset_id=p_asset_hdr_rec.asset_id;
1046:
1047: -- retrieve salvage value and cost of the asset from fa_books (keep)
1048: CURSOR c_get_asset_book(p_asset_id fa_books.asset_id%TYPE,
1049: p_book_type_code fa_books.book_type_code%TYPE)
1050: IS
1051: SELECT cost,
1052: salvage_value,

Line 1049: p_book_type_code fa_books.book_type_code%TYPE)

1045: WHERE asset_id=p_asset_hdr_rec.asset_id;
1046:
1047: -- retrieve salvage value and cost of the asset from fa_books (keep)
1048: CURSOR c_get_asset_book(p_asset_id fa_books.asset_id%TYPE,
1049: p_book_type_code fa_books.book_type_code%TYPE)
1050: IS
1051: SELECT cost,
1052: salvage_value,
1053: period_counter_fully_reserved

Line 1054: FROM fa_books

1050: IS
1051: SELECT cost,
1052: salvage_value,
1053: period_counter_fully_reserved
1054: FROM fa_books
1055: WHERE asset_id = p_asset_id
1056: AND book_type_code = p_book_type_code
1057: AND date_ineffective IS NULL
1058: AND transaction_header_id_out IS NULL;

Line 2633: FUNCTION Do_prior_transfer(p_book_type_code fa_books.book_type_code%type,

2629: --| catch up (deprn expense) is calculated in this function and the detail balances |
2630: --| are updated accordingly |
2631: -- ========================================================================================+
2632:
2633: FUNCTION Do_prior_transfer(p_book_type_code fa_books.book_type_code%type,
2634: p_asset_id fa_additions_b.asset_id%type,
2635: p_category_id fa_categories.category_id%type,
2636: p_transaction_header_id fa_transaction_headers.transaction_header_id%type,
2637: p_cost fa_books.cost%type,

Line 2637: p_cost fa_books.cost%type,

2633: FUNCTION Do_prior_transfer(p_book_type_code fa_books.book_type_code%type,
2634: p_asset_id fa_additions_b.asset_id%type,
2635: p_category_id fa_categories.category_id%type,
2636: p_transaction_header_id fa_transaction_headers.transaction_header_id%type,
2637: p_cost fa_books.cost%type,
2638: p_adjusted_cost fa_books.adjusted_cost%type,
2639: p_salvage_value fa_books.salvage_value%type,
2640: p_current_units fa_additions_b.current_units%type,
2641: p_life_in_months fa_books.life_in_months%type,

Line 2638: p_adjusted_cost fa_books.adjusted_cost%type,

2634: p_asset_id fa_additions_b.asset_id%type,
2635: p_category_id fa_categories.category_id%type,
2636: p_transaction_header_id fa_transaction_headers.transaction_header_id%type,
2637: p_cost fa_books.cost%type,
2638: p_adjusted_cost fa_books.adjusted_cost%type,
2639: p_salvage_value fa_books.salvage_value%type,
2640: p_current_units fa_additions_b.current_units%type,
2641: p_life_in_months fa_books.life_in_months%type,
2642: p_calling_function varchar2,

Line 2639: p_salvage_value fa_books.salvage_value%type,

2635: p_category_id fa_categories.category_id%type,
2636: p_transaction_header_id fa_transaction_headers.transaction_header_id%type,
2637: p_cost fa_books.cost%type,
2638: p_adjusted_cost fa_books.adjusted_cost%type,
2639: p_salvage_value fa_books.salvage_value%type,
2640: p_current_units fa_additions_b.current_units%type,
2641: p_life_in_months fa_books.life_in_months%type,
2642: p_calling_function varchar2,
2643: p_event_id number --R12 uptake

Line 2641: p_life_in_months fa_books.life_in_months%type,

2637: p_cost fa_books.cost%type,
2638: p_adjusted_cost fa_books.adjusted_cost%type,
2639: p_salvage_value fa_books.salvage_value%type,
2640: p_current_units fa_additions_b.current_units%type,
2641: p_life_in_months fa_books.life_in_months%type,
2642: p_calling_function varchar2,
2643: p_event_id number --R12 uptake
2644: )
2645: RETURN BOOLEAN