DBA Data[Home] [Help]

APPS.IGI_IAC_TRANSFERS_PKG dependencies on FA_ADDITIONS

Line 953: FROM fa_additions

949: -- Find the asset number for the asset_id (for exception messages) (keep)
950: CURSOR c_asset_num
951: IS
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,

Line 1034: l_asset_num FA_ADDITIONS.asset_number%TYPE;

1030:
1031: l_ab_amounts asset_rec_type;
1032: l_iac_fa_dep_amounts iac_fa_deprn_rec_type;
1033:
1034: l_asset_num FA_ADDITIONS.asset_number%TYPE;
1035: l_units FA_DISTRIBUTION_HISTORY.units_assigned%TYPE;
1036: l_transfer_units FA_DISTRIBUTION_HISTORY.units_assigned%TYPE;
1037:
1038: l_interco_count NUMBER;

Line 2395: p_asset_id fa_additions_b.asset_id%type,

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,
2399: p_adjusted_cost fa_books.adjusted_cost%type,

Line 2401: p_current_units fa_additions_b.current_units%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
2405: )