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 392: PROCEDURE find_ccid(p_book_type_code in FA_BOOKS.book_type_code%TYPE,

388:
389: -- ===============================================================================
390: -- Procedure to find the distribution ccid's for various types of accounts
391: -- ===============================================================================
392: PROCEDURE find_ccid(p_book_type_code in FA_BOOKS.book_type_code%TYPE,
393: p_asset_id in FA_BOOKS.asset_id%TYPE,
394: p_transaction_header_id in FA_DISTRIBUTION_HISTORY.transaction_header_id_in%TYPE,
395: p_dist_id in number,
396: p_reval_ccid out NOCOPY number,

Line 393: p_asset_id in FA_BOOKS.asset_id%TYPE,

389: -- ===============================================================================
390: -- Procedure to find the distribution ccid's for various types of accounts
391: -- ===============================================================================
392: PROCEDURE find_ccid(p_book_type_code in FA_BOOKS.book_type_code%TYPE,
393: p_asset_id in FA_BOOKS.asset_id%TYPE,
394: p_transaction_header_id in FA_DISTRIBUTION_HISTORY.transaction_header_id_in%TYPE,
395: p_dist_id in number,
396: p_reval_ccid out NOCOPY number,
397: p_Gen_fund_ccid out NOCOPY number,

Line 506: p_hist_cost IN fa_books.cost%TYPE,

502: p_asset_id IN igi_iac_transaction_headers.asset_id%TYPE,
503: p_book_type_code IN igi_iac_transaction_headers.book_type_code%TYPE,
504: p_curr_prd_cntr IN igi_iac_transaction_headers.period_counter%TYPE,
505: p_tfr_prd_cntr IN igi_iac_transaction_headers.period_counter%TYPE,
506: p_hist_cost IN fa_books.cost%TYPE,
507: p_salvage_value IN fa_books.salvage_value%TYPE,
508: p_trx_header_id IN igi_iac_transaction_headers.transaction_header_id%TYPE,
509: p_asset_units IN fa_distribution_history.units_assigned%TYPE,
510: p_transfer_units IN fa_distribution_history.units_assigned%TYPE,

Line 507: p_salvage_value IN fa_books.salvage_value%TYPE,

503: p_book_type_code IN igi_iac_transaction_headers.book_type_code%TYPE,
504: p_curr_prd_cntr IN igi_iac_transaction_headers.period_counter%TYPE,
505: p_tfr_prd_cntr IN igi_iac_transaction_headers.period_counter%TYPE,
506: p_hist_cost IN fa_books.cost%TYPE,
507: p_salvage_value IN fa_books.salvage_value%TYPE,
508: p_trx_header_id IN igi_iac_transaction_headers.transaction_header_id%TYPE,
509: p_asset_units IN fa_distribution_history.units_assigned%TYPE,
510: p_transfer_units IN fa_distribution_history.units_assigned%TYPE,
511: l_asset_rec OUT NOCOPY asset_rec_type,

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

952: SELECT asset_number
953: FROM fa_additions
954: WHERE asset_id=p_asset_hdr_rec.asset_id;
955:
956: -- retrieve salvage value and cost of the asset from fa_books (keep)
957: CURSOR c_get_asset_book(p_asset_id fa_books.asset_id%TYPE,
958: p_book_type_code fa_books.book_type_code%TYPE)
959: IS
960: SELECT cost,

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

953: FROM fa_additions
954: WHERE asset_id=p_asset_hdr_rec.asset_id;
955:
956: -- retrieve salvage value and cost of the asset from fa_books (keep)
957: CURSOR c_get_asset_book(p_asset_id fa_books.asset_id%TYPE,
958: p_book_type_code fa_books.book_type_code%TYPE)
959: IS
960: SELECT cost,
961: salvage_value,

Line 958: p_book_type_code fa_books.book_type_code%TYPE)

954: WHERE asset_id=p_asset_hdr_rec.asset_id;
955:
956: -- retrieve salvage value and cost of the asset from fa_books (keep)
957: CURSOR c_get_asset_book(p_asset_id fa_books.asset_id%TYPE,
958: p_book_type_code fa_books.book_type_code%TYPE)
959: IS
960: SELECT cost,
961: salvage_value,
962: period_counter_fully_reserved

Line 963: FROM fa_books

959: IS
960: SELECT cost,
961: salvage_value,
962: period_counter_fully_reserved
963: FROM fa_books
964: WHERE asset_id = p_asset_id
965: AND book_type_code = p_book_type_code
966: AND date_ineffective IS NULL
967: AND transaction_header_id_out IS NULL;

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

2390: --| catch up (deprn expense) is calculated in this function and the detail balances |
2391: --| are updated accordingly |
2392: -- ========================================================================================+
2393:
2394: FUNCTION Do_prior_transfer(p_book_type_code fa_books.book_type_code%type,
2395: p_asset_id fa_additions_b.asset_id%type,
2396: p_category_id fa_categories.category_id%type,
2397: p_transaction_header_id fa_transaction_headers.transaction_header_id%type,
2398: p_cost fa_books.cost%type,

Line 2398: p_cost fa_books.cost%type,

2394: FUNCTION Do_prior_transfer(p_book_type_code fa_books.book_type_code%type,
2395: p_asset_id fa_additions_b.asset_id%type,
2396: p_category_id fa_categories.category_id%type,
2397: p_transaction_header_id fa_transaction_headers.transaction_header_id%type,
2398: p_cost fa_books.cost%type,
2399: p_adjusted_cost fa_books.adjusted_cost%type,
2400: p_salvage_value fa_books.salvage_value%type,
2401: p_current_units fa_additions_b.current_units%type,
2402: p_life_in_months fa_books.life_in_months%type,

Line 2399: p_adjusted_cost fa_books.adjusted_cost%type,

2395: p_asset_id fa_additions_b.asset_id%type,
2396: p_category_id fa_categories.category_id%type,
2397: p_transaction_header_id fa_transaction_headers.transaction_header_id%type,
2398: p_cost fa_books.cost%type,
2399: p_adjusted_cost fa_books.adjusted_cost%type,
2400: p_salvage_value fa_books.salvage_value%type,
2401: p_current_units fa_additions_b.current_units%type,
2402: p_life_in_months fa_books.life_in_months%type,
2403: p_calling_function varchar2,

Line 2400: p_salvage_value fa_books.salvage_value%type,

2396: p_category_id fa_categories.category_id%type,
2397: p_transaction_header_id fa_transaction_headers.transaction_header_id%type,
2398: p_cost fa_books.cost%type,
2399: p_adjusted_cost fa_books.adjusted_cost%type,
2400: p_salvage_value fa_books.salvage_value%type,
2401: p_current_units fa_additions_b.current_units%type,
2402: p_life_in_months fa_books.life_in_months%type,
2403: p_calling_function varchar2,
2404: p_event_id number --R12 uptake

Line 2402: p_life_in_months fa_books.life_in_months%type,

2398: p_cost fa_books.cost%type,
2399: p_adjusted_cost fa_books.adjusted_cost%type,
2400: p_salvage_value fa_books.salvage_value%type,
2401: p_current_units fa_additions_b.current_units%type,
2402: p_life_in_months fa_books.life_in_months%type,
2403: p_calling_function varchar2,
2404: p_event_id number --R12 uptake
2405: )
2406: RETURN BOOLEAN