DBA Data[Home] [Help]

APPS.IGI_IAC_SALVAGE_PKG dependencies on FA_BOOKS

Line 20: P_cost IN Fa_books.cost%TYPE,

16: FUNCTION Correction
17: (P_asset_id IN igi_iac_asset_balances.asset_id%TYPE,
18: P_book_type_code IN igi_iac_asset_balances.book_type_code%TYPE,
19: P_value IN OUT NOCOPY Number,
20: P_cost IN Fa_books.cost%TYPE,
21: P_salvage_value IN fa_books.salvage_value%TYPE,
22: p_calling_program VARCHAR2)
23: RETURN Boolean IS
24:

Line 21: P_salvage_value IN fa_books.salvage_value%TYPE,

17: (P_asset_id IN igi_iac_asset_balances.asset_id%TYPE,
18: P_book_type_code IN igi_iac_asset_balances.book_type_code%TYPE,
19: P_value IN OUT NOCOPY Number,
20: P_cost IN Fa_books.cost%TYPE,
21: P_salvage_value IN fa_books.salvage_value%TYPE,
22: p_calling_program VARCHAR2)
23: RETURN Boolean IS
24:
25: -- to get latest cost and salvage value for an asset

Line 28: FROM FA_BOOKS

24:
25: -- to get latest cost and salvage value for an asset
26: CURSOR C_get_asset_info IS
27: SELECT cost, salvage_value
28: FROM FA_BOOKS
29: WHERE Asset_id=P_Asset_id
30: AND book_type_Code =p_book_type_code
31: AND transaction_header_id_out IS NULL;
32:

Line 33: l_cost fa_books.cost%TYPE;

29: WHERE Asset_id=P_Asset_id
30: AND book_type_Code =p_book_type_code
31: AND transaction_header_id_out IS NULL;
32:
33: l_cost fa_books.cost%TYPE;
34: l_salvage_value fa_books.salvage_value%TYPE;
35: err_asset_info EXCEPTION;
36: l_path_name VARCHAR2(150) := g_path||'correction';
37:

Line 34: l_salvage_value fa_books.salvage_value%TYPE;

30: AND book_type_Code =p_book_type_code
31: AND transaction_header_id_out IS NULL;
32:
33: l_cost fa_books.cost%TYPE;
34: l_salvage_value fa_books.salvage_value%TYPE;
35: err_asset_info EXCEPTION;
36: l_path_name VARCHAR2(150) := g_path||'correction';
37:
38: BEGIN