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

Line 1856: FROM igi_iac_transaction_headers it

1852:
1853: -- Cursor to fetch the assets from the interface table
1854: CURSOR c_txns(cp_book VARCHAR2) IS
1855: SELECT 'Y'
1856: FROM igi_iac_transaction_headers it
1857: WHERE it.book_type_code = cp_book
1858: AND it.category_id = p_Category_id
1859: AND NOT ( nvl(it.transaction_sub_type,'AA') = 'IMPLEMENTATION')
1860: AND rownum = 1 ;

Line 2234: p_string => ' Creating row in igi_iac_transaction_headers for closed period...');

2230: p_string => ' ----------------> Processing Asset ID : '|| arec.asset_id ) ;
2231:
2232: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
2233: p_full_path => g_path||'transfer_data',
2234: p_string => ' Creating row in igi_iac_transaction_headers for closed period...');
2235: -- Create row in igi_iac_transaction_headers for closed period
2236: --
2237: l_prev_out_adj_id := null;
2238: l_out_adj_id := null;

Line 2235: -- Create row in igi_iac_transaction_headers for closed period

2231:
2232: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
2233: p_full_path => g_path||'transfer_data',
2234: p_string => ' Creating row in igi_iac_transaction_headers for closed period...');
2235: -- Create row in igi_iac_transaction_headers for closed period
2236: --
2237: l_prev_out_adj_id := null;
2238: l_out_adj_id := null;
2239:

Line 2259: SELECT igi_iac_transaction_headers_s.NEXTVAL

2255: x_period_counter => l_prev_prd_rec.period_counter,
2256: x_mode => 'R',
2257: x_event_id => p_event_id
2258: ) ;
2259: SELECT igi_iac_transaction_headers_s.NEXTVAL
2260: INTO l_out_adj_id
2261: FROM sys.dual;
2262:
2263: UPDATE igi_iac_transaction_headers

Line 2263: UPDATE igi_iac_transaction_headers

2259: SELECT igi_iac_transaction_headers_s.NEXTVAL
2260: INTO l_out_adj_id
2261: FROM sys.dual;
2262:
2263: UPDATE igi_iac_transaction_headers
2264: SET adjustment_id_out = l_out_adj_id
2265: WHERE asset_id = arec.asset_id
2266: AND book_type_code = l_corporate_book
2267: AND adjustment_id_out IS NULL ;

Line 2272: p_string => ' Creating row in igi_iac_transaction_headers ...');

2268:
2269:
2270: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
2271: p_full_path => g_path||'transfer_data',
2272: p_string => ' Creating row in igi_iac_transaction_headers ...');
2273: -- Create row in igi_iac_transaction_headers
2274: --
2275: igi_iac_trans_headers_pkg.insert_row (
2276: x_rowid => l_out_rowid ,

Line 2273: -- Create row in igi_iac_transaction_headers

2269:
2270: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
2271: p_full_path => g_path||'transfer_data',
2272: p_string => ' Creating row in igi_iac_transaction_headers ...');
2273: -- Create row in igi_iac_transaction_headers
2274: --
2275: igi_iac_trans_headers_pkg.insert_row (
2276: x_rowid => l_out_rowid ,
2277: x_adjustment_id => l_out_adj_id ,