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_PURGE_IAC_PKG dependencies on IGI_IMP_IAC_INTERFACE

Line 27: FROM igi_imp_iac_interface_ctrl ic

23:
24: -- Cursor to fetch the interface control record
25: CURSOR c_ctrl IS
26: SELECT *
27: FROM igi_imp_iac_interface_ctrl ic
28: WHERE ic.book_type_code = p_book_type_code
29: AND ic.category_id = nvl(p_Category_id,ic.category_id);
30:
31: -- Cursor to fetch the assets from the interface table

Line 145: from igi_imp_iac_interface I

141:
142: Delete igi_iac_adjustments a
143: Where a.book_type_code = l_corporate_book
144: and exists ( select i.asset_id
145: from igi_imp_iac_interface I
146: where i.book_type_code = p_book_type_code
147: and i.category_id = nvl(p_category_id,i.category_id)
148: and i.asset_id = a.asset_id );
149:

Line 160: from igi_imp_iac_interface I

156:
157: Delete from igi_iac_det_balances d
158: Where d.book_type_code = l_corporate_book
159: and exists ( select i.asset_id
160: from igi_imp_iac_interface I
161: where i.book_type_code = p_book_type_code
162: and i.category_id = nvl(p_category_id,i.category_id)
163: and i.asset_id = d.asset_id );
164:

Line 176: from igi_imp_iac_interface I

172:
173: Delete from igi_iac_fa_deprn d
174: Where d.book_type_code = l_corporate_book
175: and exists ( select i.asset_id
176: from igi_imp_iac_interface I
177: where i.book_type_code = p_book_type_code
178: and i.category_id = nvl(p_category_id,i.category_id)
179: and i.asset_id = d.asset_id );
180:

Line 192: from igi_imp_iac_interface I

188:
189: Delete from igi_iac_asset_balances b
190: Where b.book_type_code = l_corporate_book
191: and exists ( select i.asset_id
192: from igi_imp_iac_interface I
193: where i.book_type_code = p_book_type_code
194: and i.category_id = nvl(p_category_id,i.category_id)
195: and i.asset_id = b.asset_id );
196:

Line 209: from igi_imp_iac_interface I

205:
206: Delete from igi_iac_transaction_headers t
207: Where t.book_type_code = l_corporate_book
208: and exists ( select i.asset_id
209: from igi_imp_iac_interface I
210: where i.book_type_code = p_book_type_code
211: and i.category_id = Nvl(p_category_id,i.category_id)
212: and i.asset_id = t.asset_id );
213:

Line 261: p_string => 'Updating igi_imp_iac_interface_ctrl status to Not transferred ...');

257: p_string => SQL%rowcount || ' rows deleted.');
258:
259: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
260: p_full_path => l_path_name,
261: p_string => 'Updating igi_imp_iac_interface_ctrl status to Not transferred ...');
262: Update igi_imp_iac_interface_ctrl c
263: set c.transfer_status = 'N'
264: where c.book_type_code = p_book_type_code
265: and c.category_id = nvl(p_category_id,c.category_id) ;

Line 262: Update igi_imp_iac_interface_ctrl c

258:
259: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
260: p_full_path => l_path_name,
261: p_string => 'Updating igi_imp_iac_interface_ctrl status to Not transferred ...');
262: Update igi_imp_iac_interface_ctrl c
263: set c.transfer_status = 'N'
264: where c.book_type_code = p_book_type_code
265: and c.category_id = nvl(p_category_id,c.category_id) ;
266: IF ( SQL%rowcount = 0 ) THEN

Line 269: p_string => 'ERROR : Could not set igi_imp_iac_interface_ctrl status to NOT TRANSFERRED');

265: and c.category_id = nvl(p_category_id,c.category_id) ;
266: IF ( SQL%rowcount = 0 ) THEN
267: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
268: p_full_path => l_path_name,
269: p_string => 'ERROR : Could not set igi_imp_iac_interface_ctrl status to NOT TRANSFERRED');
270: fnd_message.set_name ('IGI','IGI_IAC_PURGE_IAC_ERROR');
271: fnd_message.set_token('ERROR', 'igi_imp_iac_interface_ctrl table does not contain anyrows for given book and category');
272: fnd_message.set_token('OPERATION', 'update transfer status to Not Transferred');
273: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,

Line 271: fnd_message.set_token('ERROR', 'igi_imp_iac_interface_ctrl table does not contain anyrows for given book and category');

267: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
268: p_full_path => l_path_name,
269: p_string => 'ERROR : Could not set igi_imp_iac_interface_ctrl status to NOT TRANSFERRED');
270: fnd_message.set_name ('IGI','IGI_IAC_PURGE_IAC_ERROR');
271: fnd_message.set_token('ERROR', 'igi_imp_iac_interface_ctrl table does not contain anyrows for given book and category');
272: fnd_message.set_token('OPERATION', 'update transfer status to Not Transferred');
273: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
274: p_full_path => l_path_name,
275: p_remove_from_stack => FALSE);

Line 286: p_string => 'Updating igi_imp_iac_interface status to Not transferred ...');

282: p_string => SQL%rowcount || ' rows updated.');
283:
284: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
285: p_full_path => l_path_name,
286: p_string => 'Updating igi_imp_iac_interface status to Not transferred ...');
287: Update igi_imp_iac_interface i
288: set i.transferred_flag = 'N'
289: where i.book_type_code = p_book_type_code
290: and i.category_id = nvl(p_category_id,i.category_id) ;

Line 287: Update igi_imp_iac_interface i

283:
284: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
285: p_full_path => l_path_name,
286: p_string => 'Updating igi_imp_iac_interface status to Not transferred ...');
287: Update igi_imp_iac_interface i
288: set i.transferred_flag = 'N'
289: where i.book_type_code = p_book_type_code
290: and i.category_id = nvl(p_category_id,i.category_id) ;
291: IF ( SQL%rowcount = 0 ) THEN

Line 294: p_string => 'ERROR : Could not set igi_imp_iac_interface status to NOT TRANSFERRED');

290: and i.category_id = nvl(p_category_id,i.category_id) ;
291: IF ( SQL%rowcount = 0 ) THEN
292: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
293: p_full_path => l_path_name,
294: p_string => 'ERROR : Could not set igi_imp_iac_interface status to NOT TRANSFERRED');
295: fnd_message.set_name ('IGI','IGI_IAC_PURGE_IAC_ERROR');
296: fnd_message.set_token('ERROR', 'igi_imp_iac_interface table does not contain anyrows for given book and category');
297: fnd_message.set_token('OPERATION', 'update transfer flag to N');
298: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,

Line 296: fnd_message.set_token('ERROR', 'igi_imp_iac_interface table does not contain anyrows for given book and category');

292: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
293: p_full_path => l_path_name,
294: p_string => 'ERROR : Could not set igi_imp_iac_interface status to NOT TRANSFERRED');
295: fnd_message.set_name ('IGI','IGI_IAC_PURGE_IAC_ERROR');
296: fnd_message.set_token('ERROR', 'igi_imp_iac_interface table does not contain anyrows for given book and category');
297: fnd_message.set_token('OPERATION', 'update transfer flag to N');
298: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
299: p_full_path => l_path_name,
300: p_remove_from_stack => FALSE);