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_TRANSACTION_DETAILS_AR

Line 479: hxc_transaction_details ar

475: transaction_detail_id,
476: transaction_id,
477: ROWIDTOCHAR(ar.ROWID)
478: FROM hxc_temp_timecard_chunks temp,
479: hxc_transaction_details ar
480: WHERE ar.time_building_block_id = temp.id
481: AND ar.time_building_block_ovn = temp.ref_ovn
482: AND thread_id = p_thread_id ;
483:

Line 707: -- hxc_transaction_details_ar.

703: -- Pick up transaction detail records for the records in hxc_temp_timecard_chunks
704: -- as of now. ( detail_id, transaction_id, detail_rowid ), and insert into
705: -- hxc_archive_temp.
706: -- Using the rowids, insert the transaction detail records into
707: -- hxc_transaction_details_ar.
708: -- Delete the records from hxc_transaction_details_ar using the ROWID.
709: -- Delete duplicate transaction ids from hxc_archive_temp.
710: -- Select all deposit transaction records from hxc_transactions table and
711: -- insert into hxc_transactions_ar table.

Line 708: -- Delete the records from hxc_transaction_details_ar using the ROWID.

704: -- as of now. ( detail_id, transaction_id, detail_rowid ), and insert into
705: -- hxc_archive_temp.
706: -- Using the rowids, insert the transaction detail records into
707: -- hxc_transaction_details_ar.
708: -- Delete the records from hxc_transaction_details_ar using the ROWID.
709: -- Delete duplicate transaction ids from hxc_archive_temp.
710: -- Select all deposit transaction records from hxc_transactions table and
711: -- insert into hxc_transactions_ar table.
712: -- Select all retrieval transaction ids and insert into hxc_ar_trans_temp

Line 723: -- Delete the records from hxc_transaction_details_ar using the ROWID.

719: -- as of now. ( usage_id, attribute_id, usage_rowid ), and insert into
720: -- hxc_archive_temp.
721: -- Using the rowids, insert the attribute usage records into
722: -- hxc_attribute_usages_ar.
723: -- Delete the records from hxc_transaction_details_ar using the ROWID.
724: -- Delete all records from hxc_archive_temp if attribute_id is
725: -- present in hxc_time_attributes_ar
726: -- Select all attribute records from hxc_time_attributes table and
727: -- insert into hxc_time_attributes_ar table.

Line 1206: INSERT INTO hxc_transaction_details_ar

1202: trans_tab(i),
1203: td_rowid_tab(i),
1204: p_thread_id );
1205:
1206: INSERT INTO hxc_transaction_details_ar
1207: (DATA_SET_ID,TRANSACTION_DETAIL_ID,TIME_BUILDING_BLOCK_ID,TRANSACTION_ID,
1208: STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,
1209: LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,TIME_BUILDING_BLOCK_OVN)
1210: SELECT /*+ LEADING(temp) USE_NL(bkuptxnd) */