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_ADDITIONS_PKG dependencies on IGI_IAC_TRANSACTION_HEADERS

Line 314: FROM igi_iac_transaction_headers ith

310:
311: /* bug 2450796 sekhar need to update the reval rates ..only one record should have staus = 'Y' for an asset */
312: Cursor C_Reval_Rates is
313: SELECT max(adjustment_id)
314: FROM igi_iac_transaction_headers ith
315: WHERE ith.book_type_code =p_book_type_code
316: AND ith.asset_id = p_asset_id
317: AND (ith.transaction_type_code = 'ADDITION' AND ith.Transaction_sub_type ='REVALUATION');
318:

Line 905: UPDATE igi_iac_transaction_headers

901: END IF;
902:
903: -- Added by Venkat Gadde
904: IF p_calling_function <> 'UPGRADE' THEN
905: UPDATE igi_iac_transaction_headers
906: SET event_id = p_event_id
907: WHERE book_type_code = p_book_type_code
908: AND asset_id = p_asset_id;
909:

Line 936: FROM igi_iac_transaction_headers

932: ) return BOOLEAN IS
933:
934: CURSOR c_get_asset_add_info IS
935: SELECT asset_id,adjustment_id,transaction_sub_type
936: FROM igi_iac_transaction_headers
937: WHERE book_type_code = p_book_type_code
938: AND period_counter = p_period_counter
939: AND transaction_type_code = 'ADDITION';
940:

Line 1097: /* Delete records from igi_iac_transaction_headers */

1093: END IF;
1094: CLOSE c_get_asset_balances; -- Bug 2417394 this cursor was not gettign closed previously
1095: END IF;
1096:
1097: /* Delete records from igi_iac_transaction_headers */
1098: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1099: p_full_path => l_path_name,
1100: p_string => ' Deleting records from igi_iac_transaction_headers');
1101: igi_iac_trans_headers_pkg.delete_row(

Line 1100: p_string => ' Deleting records from igi_iac_transaction_headers');

1096:
1097: /* Delete records from igi_iac_transaction_headers */
1098: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1099: p_full_path => l_path_name,
1100: p_string => ' Deleting records from igi_iac_transaction_headers');
1101: igi_iac_trans_headers_pkg.delete_row(
1102: x_adjustment_id => l_asset_info.adjustment_id);
1103:
1104: IF l_asset_info.transaction_sub_type <> 'CATCHUP' THEN