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_ARCHIVE dependencies on HXC_TRANSACTIONS

Line 313: -- to hxc_transactions_ar if they are not present already.

309: UPDATE hxc_ar_trans_temp
310: SET thread_id = 0 ;
311:
312: -- Not much processing left, just insert the records from hxc_transacitons
313: -- to hxc_transactions_ar if they are not present already.
314:
315: INSERT INTO hxc_transactions_ar
316: (DATA_SET_ID,TRANSACTION_ID,TRANSACTION_PROCESS_ID,TRANSACTION_DATE,TYPE,
317: STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,

Line 315: INSERT INTO hxc_transactions_ar

311:
312: -- Not much processing left, just insert the records from hxc_transacitons
313: -- to hxc_transactions_ar if they are not present already.
314:
315: INSERT INTO hxc_transactions_ar
316: (DATA_SET_ID,TRANSACTION_ID,TRANSACTION_PROCESS_ID,TRANSACTION_DATE,TYPE,
317: STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,
318: LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,TRANSACTION_CODE)
319: SELECT /*+ INDEX(bkuptxn hxc_transactions_pk) */

Line 319: SELECT /+ INDEX(bkuptxn hxc_transactions_pk) /

315: INSERT INTO hxc_transactions_ar
316: (DATA_SET_ID,TRANSACTION_ID,TRANSACTION_PROCESS_ID,TRANSACTION_DATE,TYPE,
317: STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,
318: LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,TRANSACTION_CODE)
319: SELECT /*+ INDEX(bkuptxn hxc_transactions_pk) */
320: p_data_set_id,bkuptxn.TRANSACTION_ID,TRANSACTION_PROCESS_ID,
321: TRANSACTION_DATE,TYPE,STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,
322: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,
323: TRANSACTION_CODE

Line 324: FROM hxc_transactions bkuptxn

320: p_data_set_id,bkuptxn.TRANSACTION_ID,TRANSACTION_PROCESS_ID,
321: TRANSACTION_DATE,TYPE,STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,
322: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,
323: TRANSACTION_CODE
324: FROM hxc_transactions bkuptxn
325: WHERE bkuptxn.transaction_id IN ( SELECT temp.transaction_id
326: FROM hxc_ar_trans_temp temp
327: WHERE thread_id = 0 )
328: AND bkuptxn.transaction_id NOT IN ( SELECT transaction_id

Line 329: FROM hxc_transactions_ar hxc

325: WHERE bkuptxn.transaction_id IN ( SELECT temp.transaction_id
326: FROM hxc_ar_trans_temp temp
327: WHERE thread_id = 0 )
328: AND bkuptxn.transaction_id NOT IN ( SELECT transaction_id
329: FROM hxc_transactions_ar hxc
330: WHERE bkuptxn.transaction_id = hxc.transaction_id)
331: ;
332:
333: -- Delete those records from hxc_transactions.

Line 333: -- Delete those records from hxc_transactions.

329: FROM hxc_transactions_ar hxc
330: WHERE bkuptxn.transaction_id = hxc.transaction_id)
331: ;
332:
333: -- Delete those records from hxc_transactions.
334:
335: DELETE FROM hxc_transactions
336: WHERE ROWID IN ( SELECT CHARTOROWID(trans_rowid)
337: FROM hxc_ar_trans_temp

Line 335: DELETE FROM hxc_transactions

331: ;
332:
333: -- Delete those records from hxc_transactions.
334:
335: DELETE FROM hxc_transactions
336: WHERE ROWID IN ( SELECT CHARTOROWID(trans_rowid)
337: FROM hxc_ar_trans_temp
338: WHERE thread_id = 0 );
339:

Line 667: -- Select all deposit transaction records from hxc_transactions table and

663: -- Using the rowids, insert the transaction detail records into
664: -- hxc_transaction_details_ar.
665: -- Delete the records from hxc_transaction_details_ar using the ROWID.
666: -- Delete duplicate transaction ids from hxc_archive_temp.
667: -- Select all deposit transaction records from hxc_transactions table and
668: -- insert into hxc_transactions_ar table.
669: -- Select all retrieval transaction ids and insert into hxc_ar_trans_temp
670: -- table for the parent thread to process.
671: -- Delete all transaction records from hxc_transactions table, if the transaction

Line 668: -- insert into hxc_transactions_ar table.

664: -- hxc_transaction_details_ar.
665: -- Delete the records from hxc_transaction_details_ar using the ROWID.
666: -- Delete duplicate transaction ids from hxc_archive_temp.
667: -- Select all deposit transaction records from hxc_transactions table and
668: -- insert into hxc_transactions_ar table.
669: -- Select all retrieval transaction ids and insert into hxc_ar_trans_temp
670: -- table for the parent thread to process.
671: -- Delete all transaction records from hxc_transactions table, if the transaction
672: -- id is present in hxc_archive_temp.

Line 671: -- Delete all transaction records from hxc_transactions table, if the transaction

667: -- Select all deposit transaction records from hxc_transactions table and
668: -- insert into hxc_transactions_ar table.
669: -- Select all retrieval transaction ids and insert into hxc_ar_trans_temp
670: -- table for the parent thread to process.
671: -- Delete all transaction records from hxc_transactions table, if the transaction
672: -- id is present in hxc_archive_temp.
673: -- Delete from hxc_archive temp for the the next iteration of this loop.
674: -- * Loop to process attribute records.
675: -- Pick up attribute usage records for the records in hxc_temp_timecard_chunks

Line 1206: FROM hxc_transactions_ar

1202: CLOSE get_dup_trans;
1203:
1204: DELETE FROM hxc_archive_temp
1205: WHERE EXISTS ( SELECT 1
1206: FROM hxc_transactions_ar
1207: WHERE transaction_id = master_id )
1208: AND thread_id = p_thread_id ;
1209:
1210: INSERT INTO hxc_transactions_ar

Line 1210: INSERT INTO hxc_transactions_ar

1206: FROM hxc_transactions_ar
1207: WHERE transaction_id = master_id )
1208: AND thread_id = p_thread_id ;
1209:
1210: INSERT INTO hxc_transactions_ar
1211: (DATA_SET_ID,TRANSACTION_ID,TRANSACTION_PROCESS_ID,TRANSACTION_DATE,TYPE,
1212: STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,
1213: LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,TRANSACTION_CODE)
1214: SELECT /*+ LEADING(temp) USE_NL(bkuptxn) */

Line 1219: FROM hxc_transactions bkuptxn,

1215: p_data_set_id,TRANSACTION_ID,TRANSACTION_PROCESS_ID,
1216: TRANSACTION_DATE,TYPE,STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,
1217: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,
1218: TRANSACTION_CODE
1219: FROM hxc_transactions bkuptxn,
1220: hxc_archive_temp temp
1221: WHERE transaction_id = master_id
1222: AND thread_id = p_thread_id
1223: AND transaction_id NOT IN ( SELECT transaction_id

Line 1224: FROM hxc_transactions_ar hxc

1220: hxc_archive_temp temp
1221: WHERE transaction_id = master_id
1222: AND thread_id = p_thread_id
1223: AND transaction_id NOT IN ( SELECT transaction_id
1224: FROM hxc_transactions_ar hxc
1225: WHERE bkuptxn.transaction_id = hxc.transaction_id)
1226: AND type <> 'RETRIEVAL'
1227: ;
1228:

Line 1232: FROM hxc_transactions bkuptxn

1228:
1229: l_trans_count := l_trans_count + SQL%ROWCOUNT;
1230:
1231: DELETE /*+ LEADING(temp) USE_NL(bkuptxn) */
1232: FROM hxc_transactions bkuptxn
1233: WHERE transaction_id IN ( SELECT master_id
1234: FROM hxc_archive_temp temp
1235: WHERE thread_id = p_thread_id)
1236: AND type <> 'RETRIEVAL';

Line 1246: FROM hxc_transactions bkuptxn,

1242: SELECT bkuptxn.transaction_id,
1243: p_data_set_id,
1244: p_thread_id,
1245: ROWIDTOCHAR(bkuptxn.ROWID)
1246: FROM hxc_transactions bkuptxn,
1247: hxc_archive_temp temp
1248: WHERE transaction_id = master_id
1249: AND thread_id = p_thread_id
1250: AND type = 'RETRIEVAL';