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.HXC_RESTORE dependencies on HXC_TRANSACTIONS

Line 293: INSERT INTO hxc_transactions

289:
290: -- Bug 11781607
291: -- Removed Data set id condition.
292:
293: INSERT INTO hxc_transactions
294: (DATA_SET_ID,TRANSACTION_ID,TRANSACTION_PROCESS_ID,TRANSACTION_DATE,TYPE,
295: STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,
296: LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,TRANSACTION_CODE)
297: SELECT bkuptxn.DATA_SET_ID,bkuptxn.TRANSACTION_ID,TRANSACTION_PROCESS_ID,

Line 301: FROM hxc_transactions_ar bkuptxn

297: SELECT bkuptxn.DATA_SET_ID,bkuptxn.TRANSACTION_ID,TRANSACTION_PROCESS_ID,
298: TRANSACTION_DATE,TYPE,STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,
299: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,
300: TRANSACTION_CODE
301: FROM hxc_transactions_ar bkuptxn
302: WHERE bkuptxn.transaction_id IN ( SELECT temp.transaction_id
303: FROM hxc_ar_trans_temp temp
304: WHERE thread_id = 0 )
305: AND bkuptxn.transaction_id NOT IN ( SELECT transaction_id

Line 306: FROM hxc_transactions hxc

302: WHERE bkuptxn.transaction_id IN ( SELECT temp.transaction_id
303: FROM hxc_ar_trans_temp temp
304: WHERE thread_id = 0 )
305: AND bkuptxn.transaction_id NOT IN ( SELECT transaction_id
306: FROM hxc_transactions hxc
307: WHERE bkuptxn.transaction_id = hxc.transaction_id)
308: ;
309:
310: -- Bug 11781607

Line 314: DELETE FROM hxc_transactions_ar ht

310: -- Bug 11781607
311: -- Added the NOT EXISTS condtion to take care of transactions spanning
312: -- multiple data sets.
313:
314: DELETE FROM hxc_transactions_ar ht
315: WHERE ROWID IN ( SELECT CHARTOROWID(trans_rowid)
316: FROM hxc_ar_trans_temp
317: WHERE thread_id = 0 )
318: AND NOT EXISTS ( SELECT 1

Line 440: FROM hxc_transactions_ar tr

436: hxc_transaction_details_ar ar
437: WHERE ar.time_building_block_id = temp.id
438: AND ar.time_building_block_ovn = temp.ref_ovn
439: AND EXISTS ( SELECT 1
440: FROM hxc_transactions_ar tr
441: WHERE tr.transaction_id = ar.transaction_id
442: AND tr.type = 'RETRIEVAL' )
443: AND thread_id = p_thread_id;
444:

Line 447: -- transactions from hxc_dep_transactions_ar and hxc_transactions_ar

443: AND thread_id = p_thread_id;
444:
445: -- Bug 8888813
446: -- Added the following cursors to pick up DEPOSIT type
447: -- transactions from hxc_dep_transactions_ar and hxc_transactions_ar
448:
449: CURSOR get_old_transactions
450: IS SELECT /*+ LEADING(temp) */
451: transaction_detail_id,

Line 459: FROM hxc_transactions_ar tr

455: hxc_transaction_details_ar ar
456: WHERE ar.time_building_block_id = temp.id
457: AND ar.time_building_block_ovn = temp.ref_ovn
458: AND EXISTS ( SELECT 1
459: FROM hxc_transactions_ar tr
460: WHERE tr.transaction_id = ar.transaction_id
461: AND tr.type = 'DEPOSIT' )
462: AND thread_id = p_thread_id;
463:

Line 1181: FROM hxc_transactions

1177: /*
1178:
1179: DELETE FROM hxc_archive_temp
1180: WHERE EXISTS ( SELECT 1
1181: FROM hxc_transactions
1182: WHERE transaction_id = master_id )
1183: AND thread_id = p_thread_id ;
1184: */
1185:

Line 1192: INSERT INTO hxc_transactions

1188: -- construct is no longer handling DEPOSIT transactions, and
1189: -- transactions of RETRIEVAL details handled here are handled
1190: -- in the Parent process.
1191: /*
1192: INSERT INTO hxc_transactions
1193: (DATA_SET_ID,TRANSACTION_ID,TRANSACTION_PROCESS_ID,TRANSACTION_DATE,TYPE,
1194: STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,
1195: LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,TRANSACTION_CODE)
1196: SELECT /*+ LEADING(temp) USE_NL(bkuptxn) *

Line 1201: FROM hxc_transactions_ar bkuptxn,

1197: bkuptxn.DATA_SET_ID,TRANSACTION_ID,TRANSACTION_PROCESS_ID,
1198: TRANSACTION_DATE,TYPE,STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,
1199: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,
1200: TRANSACTION_CODE
1201: FROM hxc_transactions_ar bkuptxn,
1202: hxc_archive_temp temp
1203: WHERE transaction_id = master_id
1204: AND thread_id = p_thread_id
1205: AND transaction_id NOT IN ( SELECT transaction_id

Line 1206: FROM hxc_transactions hxc

1202: hxc_archive_temp temp
1203: WHERE transaction_id = master_id
1204: AND thread_id = p_thread_id
1205: AND transaction_id NOT IN ( SELECT transaction_id
1206: FROM hxc_transactions hxc
1207: WHERE bkuptxn.transaction_id = hxc.transaction_id)
1208: AND type <> 'RETRIEVAL'
1209: AND bkuptxn.data_set_id = p_data_set_id
1210: ;

Line 1216: FROM hxc_transactions_ar bkuptxn

1212:
1213: l_trans_count := l_trans_count + SQL%ROWCOUNT;
1214:
1215: DELETE /*+ LEADING(temp) USE_NL(bkuptxn) *
1216: FROM hxc_transactions_ar bkuptxn
1217: WHERE transaction_id IN ( SELECT master_id
1218: FROM hxc_archive_temp temp
1219: WHERE thread_id = p_thread_id)
1220: AND type <> 'RETRIEVAL'

Line 1237: FROM hxc_transactions_ar bkuptxn,

1233: SELECT bkuptxn.transaction_id,
1234: p_data_set_id,
1235: p_thread_id,
1236: ROWIDTOCHAR(bkuptxn.ROWID)
1237: FROM hxc_transactions_ar bkuptxn,
1238: hxc_archive_temp temp
1239: WHERE transaction_id = master_id
1240: AND thread_id = p_thread_id
1241: AND type = 'RETRIEVAL';

Line 1348: FROM hxc_transactions

1344: CLOSE get_dup_trans;
1345:
1346: DELETE FROM hxc_archive_temp
1347: WHERE EXISTS ( SELECT 1
1348: FROM hxc_transactions
1349: WHERE transaction_id = master_id )
1350: AND thread_id = p_thread_id ;
1351:
1352: INSERT INTO hxc_dep_transactions

Line 1361: FROM hxc_transactions_ar bkuptxn,

1357: bkuptxn.DATA_SET_ID,TRANSACTION_ID,TRANSACTION_PROCESS_ID,
1358: TRANSACTION_DATE,TYPE,STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,
1359: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,
1360: TRANSACTION_CODE
1361: FROM hxc_transactions_ar bkuptxn,
1362: hxc_archive_temp temp
1363: WHERE transaction_id = master_id
1364: AND thread_id = p_thread_id
1365: AND transaction_id NOT IN ( SELECT transaction_id

Line 1375: FROM hxc_transactions_ar bkuptxn

1371:
1372: l_trans_count := l_trans_count + SQL%ROWCOUNT;
1373:
1374: DELETE /*+ LEADING(temp) USE_NL(bkuptxn) */
1375: FROM hxc_transactions_ar bkuptxn
1376: WHERE transaction_id IN ( SELECT master_id
1377: FROM hxc_archive_temp temp
1378: WHERE thread_id = p_thread_id)
1379: AND type = 'DEPOSIT'

Line 1465: FROM hxc_transactions

1461: CLOSE get_dup_trans;
1462:
1463: DELETE FROM hxc_archive_temp
1464: WHERE EXISTS ( SELECT 1
1465: FROM hxc_transactions
1466: WHERE transaction_id = master_id )
1467: AND thread_id = p_thread_id ;
1468:
1469: