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_PKG dependencies on FA_TRANSACTION_HEADERS

Line 66: fa_transaction_headers.book_type_code%TYPE,

62:
63:
64: -- to get fa_books previous entry before current adjustment
65: CURSOR c_get_fa_book_info(p_book_type_code
66: fa_transaction_headers.book_type_code%TYPE,
67: p_asset_id fa_transaction_headers.asset_id%TYPE,
68: p_transaction_header_id
69: fa_transaction_headers.transaction_header_id%TYPE ) IS
70: SELECT *

Line 67: p_asset_id fa_transaction_headers.asset_id%TYPE,

63:
64: -- to get fa_books previous entry before current adjustment
65: CURSOR c_get_fa_book_info(p_book_type_code
66: fa_transaction_headers.book_type_code%TYPE,
67: p_asset_id fa_transaction_headers.asset_id%TYPE,
68: p_transaction_header_id
69: fa_transaction_headers.transaction_header_id%TYPE ) IS
70: SELECT *
71: FROM fa_books

Line 69: fa_transaction_headers.transaction_header_id%TYPE ) IS

65: CURSOR c_get_fa_book_info(p_book_type_code
66: fa_transaction_headers.book_type_code%TYPE,
67: p_asset_id fa_transaction_headers.asset_id%TYPE,
68: p_transaction_header_id
69: fa_transaction_headers.transaction_header_id%TYPE ) IS
70: SELECT *
71: FROM fa_books
72: WHERE book_type_code = p_book_type_code
73: AND asset_id = p_asset_id

Line 78: CURSOR c_get_asset_adj (p_book_type_code fa_transaction_headers.book_type_code%TYPE,

74: AND transaction_header_id_out = p_transaction_header_id;
75:
76:
77: -- to verify adjustments for an asset in the same period
78: CURSOR c_get_asset_adj (p_book_type_code fa_transaction_headers.book_type_code%TYPE,
79: p_asset_id fa_transaction_headers.asset_id%TYPE,
80: p_period_counter number) IS
81: SELECT *
82: FROM igi_iac_adjustments_history

Line 79: p_asset_id fa_transaction_headers.asset_id%TYPE,

75:
76:
77: -- to verify adjustments for an asset in the same period
78: CURSOR c_get_asset_adj (p_book_type_code fa_transaction_headers.book_type_code%TYPE,
79: p_asset_id fa_transaction_headers.asset_id%TYPE,
80: p_period_counter number) IS
81: SELECT *
82: FROM igi_iac_adjustments_history
83: WHERE book_type_code = p_book_type_code

Line 875: CURSOR c_get_fa_book_info(p_book_type_code fa_transaction_headers.book_type_code%TYPE,

871: ,p_asset_adj_hist_info igi_iac_adjustments_history%ROWTYPE)
872:
873: RETURN boolean IS
874:
875: CURSOR c_get_fa_book_info(p_book_type_code fa_transaction_headers.book_type_code%TYPE,
876: p_asset_id fa_transaction_headers.asset_id%TYPE
877: ) IS
878: SELECT *
879: FROM fa_books

Line 876: p_asset_id fa_transaction_headers.asset_id%TYPE

872:
873: RETURN boolean IS
874:
875: CURSOR c_get_fa_book_info(p_book_type_code fa_transaction_headers.book_type_code%TYPE,
876: p_asset_id fa_transaction_headers.asset_id%TYPE
877: ) IS
878: SELECT *
879: FROM fa_books
880: WHERE book_type_code = p_book_type_code

Line 884: CURSOR c_get_fa_headers_info(p_book_type_code fa_transaction_headers.book_type_code%TYPE,

880: WHERE book_type_code = p_book_type_code
881: AND asset_id = p_asset_id
882: AND transaction_header_id_out IS NULL;
883:
884: CURSOR c_get_fa_headers_info(p_book_type_code fa_transaction_headers.book_type_code%TYPE,
885: p_asset_id fa_transaction_headers.asset_id%TYPE,
886: p_transaction_header_id fa_transaction_headers.transaction_header_id%TYPE
887: ) IS
888: SELECT *

Line 885: p_asset_id fa_transaction_headers.asset_id%TYPE,

881: AND asset_id = p_asset_id
882: AND transaction_header_id_out IS NULL;
883:
884: CURSOR c_get_fa_headers_info(p_book_type_code fa_transaction_headers.book_type_code%TYPE,
885: p_asset_id fa_transaction_headers.asset_id%TYPE,
886: p_transaction_header_id fa_transaction_headers.transaction_header_id%TYPE
887: ) IS
888: SELECT *
889: FROM fa_transaction_headers

Line 886: p_transaction_header_id fa_transaction_headers.transaction_header_id%TYPE

882: AND transaction_header_id_out IS NULL;
883:
884: CURSOR c_get_fa_headers_info(p_book_type_code fa_transaction_headers.book_type_code%TYPE,
885: p_asset_id fa_transaction_headers.asset_id%TYPE,
886: p_transaction_header_id fa_transaction_headers.transaction_header_id%TYPE
887: ) IS
888: SELECT *
889: FROM fa_transaction_headers
890: WHERE book_type_code = p_book_type_code

Line 889: FROM fa_transaction_headers

885: p_asset_id fa_transaction_headers.asset_id%TYPE,
886: p_transaction_header_id fa_transaction_headers.transaction_header_id%TYPE
887: ) IS
888: SELECT *
889: FROM fa_transaction_headers
890: WHERE book_type_code = p_book_type_code
891: AND asset_id = p_asset_id
892: AND transaction_header_id = p_transaction_header_id;
893:

Line 894: CURSOR c_get_fa_deprn_summary(p_book_type_code fa_transaction_headers.book_type_code%TYPE,

890: WHERE book_type_code = p_book_type_code
891: AND asset_id = p_asset_id
892: AND transaction_header_id = p_transaction_header_id;
893:
894: CURSOR c_get_fa_deprn_summary(p_book_type_code fa_transaction_headers.book_type_code%TYPE,
895: p_asset_id fa_transaction_headers.asset_id%TYPE,
896: p_period_counter fa_deprn_summary.period_counter%TYPE
897: ) IS
898: SELECT *

Line 895: p_asset_id fa_transaction_headers.asset_id%TYPE,

891: AND asset_id = p_asset_id
892: AND transaction_header_id = p_transaction_header_id;
893:
894: CURSOR c_get_fa_deprn_summary(p_book_type_code fa_transaction_headers.book_type_code%TYPE,
895: p_asset_id fa_transaction_headers.asset_id%TYPE,
896: p_period_counter fa_deprn_summary.period_counter%TYPE
897: ) IS
898: SELECT *
899: FROM fa_deprn_summary

Line 904: CURSOR c_get_sum_fa_deprn(p_book_type_code fa_transaction_headers.book_type_code%TYPE,

900: WHERE book_type_code = p_book_type_code
901: AND asset_id = p_asset_id
902: AND period_counter = p_period_counter;
903:
904: CURSOR c_get_sum_fa_deprn(p_book_type_code fa_transaction_headers.book_type_code%TYPE,
905: p_asset_id fa_transaction_headers.asset_id%TYPE,
906: p_period_counter fa_deprn_summary.period_counter%TYPE
907: ) IS
908: SELECT SUM(nvl(deprn_amount,0)) depreciation_amount,

Line 905: p_asset_id fa_transaction_headers.asset_id%TYPE,

901: AND asset_id = p_asset_id
902: AND period_counter = p_period_counter;
903:
904: CURSOR c_get_sum_fa_deprn(p_book_type_code fa_transaction_headers.book_type_code%TYPE,
905: p_asset_id fa_transaction_headers.asset_id%TYPE,
906: p_period_counter fa_deprn_summary.period_counter%TYPE
907: ) IS
908: SELECT SUM(nvl(deprn_amount,0)) depreciation_amount,
909: SUM(nvl(deprn_adjustment_amount,0)) depreciation_adjustment_amount,