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 888: UPDATE igi_iac_transaction_headers

884: END IF;
885:
886: -- Added by Venkat Gadde
887: IF p_calling_function <> 'UPGRADE' THEN
888: UPDATE igi_iac_transaction_headers
889: SET event_id = p_event_id
890: WHERE book_type_code = p_book_type_code
891: AND asset_id = p_asset_id;
892:

Line 919: FROM igi_iac_transaction_headers

915: ) return BOOLEAN IS
916:
917: CURSOR c_get_asset_add_info IS
918: SELECT asset_id,adjustment_id,transaction_sub_type
919: FROM igi_iac_transaction_headers
920: WHERE book_type_code = p_book_type_code
921: AND period_counter = p_period_counter
922: AND transaction_type_code = 'ADDITION';
923:

Line 1080: /* Delete records from igi_iac_transaction_headers */

1076: END IF;
1077: CLOSE c_get_asset_balances; -- Bug 2417394 this cursor was not gettign closed previously
1078: END IF;
1079:
1080: /* Delete records from igi_iac_transaction_headers */
1081: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1082: p_full_path => l_path_name,
1083: p_string => ' Deleting records from igi_iac_transaction_headers');
1084: igi_iac_trans_headers_pkg.delete_row(

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

1079:
1080: /* Delete records from igi_iac_transaction_headers */
1081: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1082: p_full_path => l_path_name,
1083: p_string => ' Deleting records from igi_iac_transaction_headers');
1084: igi_iac_trans_headers_pkg.delete_row(
1085: x_adjustment_id => l_asset_info.adjustment_id);
1086:
1087: IF l_asset_info.transaction_sub_type <> 'CATCHUP' THEN