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_DEPRN_SUMMARY

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 896: p_period_counter fa_deprn_summary.period_counter%TYPE

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
900: WHERE book_type_code = p_book_type_code

Line 899: FROM fa_deprn_summary

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
900: WHERE book_type_code = p_book_type_code
901: AND asset_id = p_asset_id
902: AND period_counter = p_period_counter;
903:

Line 906: p_period_counter fa_deprn_summary.period_counter%TYPE

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,
910: SUM(nvl(deprn_reserve,0)) depreciation_reserve

Line 927: l_get_fa_deprn_summary c_get_fa_deprn_summary%ROWTYPE;

923: AND period_counter = p_period_counter;
924:
925:
926: l_get_fa_book_info c_get_fa_book_info%ROWTYPE;
927: l_get_fa_deprn_summary c_get_fa_deprn_summary%ROWTYPE;
928: -- p_asset_iac_adj_info igi_iac_types.iac_adj_hist_asset_info;
929: l_get_fa_deprn_detail c_get_fa_deprn_detail%ROWTYPE;
930: l_get_fa_headers_info c_get_fa_headers_info%ROWTYPE;
931: l_adj_prd_rec igi_iac_types.prd_rec;

Line 1066: p_string => 'prepare adj: fa deprn summary');

1062: RETURN FALSE;
1063: ELSE
1064: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1065: p_full_path => l_path_name,
1066: p_string => 'prepare adj: fa deprn summary');
1067: END IF;
1068: CLOSE c_get_sum_fa_deprn;
1069: p_asset_iac_adj_info.deprn_adjustment_amount:=l_get_sum_fa_deprn.depreciation_adjustment_amount;
1070: p_asset_iac_adj_info.deprn_amount := l_get_sum_fa_deprn.depreciation_amount;

Line 1097: OPEN c_get_fa_deprn_summary(p_book_type_code,p_asset_id,p_period_counter);

1093:
1094:
1095: ELSIF p_adjustment_type = 'EXPENSED' THEN
1096:
1097: OPEN c_get_fa_deprn_summary(p_book_type_code,p_asset_id,p_period_counter);
1098: FETCH c_get_fa_deprn_summary INTO l_get_fa_deprn_summary;
1099: IF c_get_fa_deprn_summary%NOTFOUND THEN
1100: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
1101: p_full_path => l_path_name,

Line 1098: FETCH c_get_fa_deprn_summary INTO l_get_fa_deprn_summary;

1094:
1095: ELSIF p_adjustment_type = 'EXPENSED' THEN
1096:
1097: OPEN c_get_fa_deprn_summary(p_book_type_code,p_asset_id,p_period_counter);
1098: FETCH c_get_fa_deprn_summary INTO l_get_fa_deprn_summary;
1099: IF c_get_fa_deprn_summary%NOTFOUND THEN
1100: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
1101: p_full_path => l_path_name,
1102: p_string => 'prepare adj:*** error cannot find record in fa_book');

Line 1099: IF c_get_fa_deprn_summary%NOTFOUND THEN

1095: ELSIF p_adjustment_type = 'EXPENSED' THEN
1096:
1097: OPEN c_get_fa_deprn_summary(p_book_type_code,p_asset_id,p_period_counter);
1098: FETCH c_get_fa_deprn_summary INTO l_get_fa_deprn_summary;
1099: IF c_get_fa_deprn_summary%NOTFOUND THEN
1100: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
1101: p_full_path => l_path_name,
1102: p_string => 'prepare adj:*** error cannot find record in fa_book');
1103: CLOSE c_get_fa_deprn_summary;

Line 1103: CLOSE c_get_fa_deprn_summary;

1099: IF c_get_fa_deprn_summary%NOTFOUND THEN
1100: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
1101: p_full_path => l_path_name,
1102: p_string => 'prepare adj:*** error cannot find record in fa_book');
1103: CLOSE c_get_fa_deprn_summary;
1104: RETURN FALSE;
1105: ELSE
1106: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1107: p_full_path => l_path_name,

Line 1108: p_string => 'prepare adj: fa deprn summary');

1104: RETURN FALSE;
1105: ELSE
1106: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1107: p_full_path => l_path_name,
1108: p_string => 'prepare adj: fa deprn summary');
1109: END IF;
1110: CLOSE c_get_fa_deprn_summary;
1111: p_asset_iac_adj_info.deprn_reserve:=l_get_fa_deprn_summary.deprn_reserve - l_get_fa_deprn_summary.system_deprn_amount;
1112: p_asset_iac_adj_info.deprn_amount:=l_get_fa_deprn_summary.system_deprn_amount;

Line 1110: CLOSE c_get_fa_deprn_summary;

1106: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1107: p_full_path => l_path_name,
1108: p_string => 'prepare adj: fa deprn summary');
1109: END IF;
1110: CLOSE c_get_fa_deprn_summary;
1111: p_asset_iac_adj_info.deprn_reserve:=l_get_fa_deprn_summary.deprn_reserve - l_get_fa_deprn_summary.system_deprn_amount;
1112: p_asset_iac_adj_info.deprn_amount:=l_get_fa_deprn_summary.system_deprn_amount;
1113: /* salvage value correction */
1114: If l_get_fa_book_info.salvage_value <> 0 Then

Line 1111: p_asset_iac_adj_info.deprn_reserve:=l_get_fa_deprn_summary.deprn_reserve - l_get_fa_deprn_summary.system_deprn_amount;

1107: p_full_path => l_path_name,
1108: p_string => 'prepare adj: fa deprn summary');
1109: END IF;
1110: CLOSE c_get_fa_deprn_summary;
1111: p_asset_iac_adj_info.deprn_reserve:=l_get_fa_deprn_summary.deprn_reserve - l_get_fa_deprn_summary.system_deprn_amount;
1112: p_asset_iac_adj_info.deprn_amount:=l_get_fa_deprn_summary.system_deprn_amount;
1113: /* salvage value correction */
1114: If l_get_fa_book_info.salvage_value <> 0 Then
1115: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

Line 1112: p_asset_iac_adj_info.deprn_amount:=l_get_fa_deprn_summary.system_deprn_amount;

1108: p_string => 'prepare adj: fa deprn summary');
1109: END IF;
1110: CLOSE c_get_fa_deprn_summary;
1111: p_asset_iac_adj_info.deprn_reserve:=l_get_fa_deprn_summary.deprn_reserve - l_get_fa_deprn_summary.system_deprn_amount;
1112: p_asset_iac_adj_info.deprn_amount:=l_get_fa_deprn_summary.system_deprn_amount;
1113: /* salvage value correction */
1114: If l_get_fa_book_info.salvage_value <> 0 Then
1115: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1116: p_full_path => l_path_name,

Line 1290: select event_id into p_event_id from fa_deprn_summary

1286: l_login_id := fnd_global.login_id;
1287:
1288: FOR l_get_asset_adj IN c_get_asset_adj
1289: LOOP
1290: select event_id into p_event_id from fa_deprn_summary
1291: where asset_id=l_get_asset_adj.asset_id
1292: and book_type_code=p_book_type_code
1293: and period_counter=p_period_counter;
1294: