[Home] [Help]
322: FROM hxc_temp_timecard_chunks temp
323: WHERE temp.data_set_id = p_data_set_id
324: AND temp.scope in ('TIMECARD','DAY','DETAIL'));
325:
326: UPDATE hxc_transactions
327: SET data_set_id = p_data_set_id
328: WHERE transaction_id in
329: (SELECT distinct transaction_id
330: FROM hxc_transaction_details txnd,
482: undo_define_table(p_table_name => 'HXC_TRANSACTION_DETAILS',
483: p_data_set_id => p_data_set_id,
484: p_chunk_size => l_chunk_size);
485:
486: undo_define_table(p_table_name => 'HXC_TRANSACTIONS',
487: p_data_set_id => p_data_set_id,
488: p_chunk_size => l_chunk_size);
489:
490: undo_define_table(p_table_name => 'HXC_TIMECARD_SUMMARY',
557: WHERE
558: NOT EXISTS
559: (SELECT 1
560: FROM hxc_transaction_details txnd,
561: hxc_transactions txn,
562: hxc_retrieval_processes rp
563: WHERE txn.type = 'RETRIEVAL'
564: AND txn.status = 'SUCCESS'
565: AND txnd.status = 'SUCCESS'
582: )
583: OR ( det.date_to <> hr_general.end_of_time
584: AND EXISTS (SELECT 1
585: FROM hxc_transaction_details txnd1,
586: hxc_transactions txn1,
587: hxc_retrieval_processes rp1
588: WHERE txn1.type = 'RETRIEVAL'
589: AND txn1.status = 'SUCCESS'
590: AND txnd1.status = 'SUCCESS'
637: NOT EXISTS
638: (SELECT /*+ INDEX(rp HXC_RETRIEVAL_PROCESSES_PK) */
639: 1
640: FROM hxc_transaction_details txnd,
641: hxc_transactions txn,
642: hxc_retrieval_processes rp
643: WHERE txn.type = 'RETRIEVAL'
644: AND txn.status = 'SUCCESS'
645: AND txnd.status = 'SUCCESS'
666: OR ( det.date_to <> hr_general.end_of_time
667: AND EXISTS (SELECT /*+ INDEX(rp1 HXC_RETRIEVAL_PROCESSES_PK) */
668: 1
669: FROM hxc_transaction_details txnd1,
670: hxc_transactions txn1,
671: hxc_retrieval_processes rp1
672: WHERE txn1.type = 'RETRIEVAL'
673: AND txn1.status = 'SUCCESS'
674: AND txnd1.status = 'SUCCESS'