APPS.HXC_ARCHIVE dependencies on HXC_TRANSACTION_DETAILS

Line 472: hxc_transaction_details ar

468: transaction_detail_id,
469: transaction_id,
470: ROWIDTOCHAR(ar.ROWID)
471: FROM hxc_temp_timecard_chunks temp,
472: hxc_transaction_details ar
473: WHERE ar.time_building_block_id = temp.id
474: AND ar.time_building_block_ovn = temp.ref_ovn
475: AND thread_id = p_thread_id ;
476:

Line 664: -- hxc_transaction_details_ar.

660: -- Pick up transaction detail records for the records in hxc_temp_timecard_chunks
661: -- as of now. ( detail_id, transaction_id, detail_rowid ), and insert into
662: -- hxc_archive_temp.
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.

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

661: -- as of now. ( detail_id, transaction_id, detail_rowid ), and insert into
662: -- hxc_archive_temp.
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

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

676: -- as of now. ( usage_id, attribute_id, usage_rowid ), and insert into
677: -- hxc_archive_temp.
678: -- Using the rowids, insert the attribute usage records into
679: -- hxc_attribute_usages_ar.
680: -- Delete the records from hxc_transaction_details_ar using the ROWID.
681: -- Delete all records from hxc_archive_temp if attribute_id is
682: -- present in hxc_time_attributes_ar
683: -- Select all attribute records from hxc_time_attributes table and
684: -- insert into hxc_time_attributes_ar table.

Line 1163: INSERT INTO hxc_transaction_details_ar

1159: trans_tab(i),
1160: td_rowid_tab(i),
1161: p_thread_id );
1162:
1163: INSERT INTO hxc_transaction_details_ar
1164: (DATA_SET_ID,TRANSACTION_DETAIL_ID,TIME_BUILDING_BLOCK_ID,TRANSACTION_ID,
1165: STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,
1166: LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,TIME_BUILDING_BLOCK_OVN)
1167: SELECT /*+ LEADING(temp) USE_NL(bkuptxnd) */

Line 1172: hxc_transaction_details bkuptxnd

1168: p_data_set_id,TRANSACTION_DETAIL_ID,TIME_BUILDING_BLOCK_ID,TRANSACTION_ID,
1169: STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,
1170: LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,TIME_BUILDING_BLOCK_OVN
1171: FROM hxc_archive_temp temp,
1172: hxc_transaction_details bkuptxnd
1173: WHERE CHARTOROWID(temp.ref_rowid) = bkuptxnd.ROWID
1174: AND thread_id = p_thread_id ;
1175:
1176: l_td_count := l_td_count + SQL%ROWCOUNT;

Line 1179: DELETE FROM hxc_transaction_details

1175:
1176: l_td_count := l_td_count + SQL%ROWCOUNT;
1177:
1178: FORALL i IN td_rowid_tab.FIRST..td_rowid_tab.LAST
1179: DELETE FROM hxc_transaction_details
1180: WHERE ROWID = CHARTOROWID(td_rowid_tab(i));
1181:
1182: l_td_del_count := l_td_del_count + SQL%ROWCOUNT;
1183: