APPS.HXC_UPGRADE_PKG dependencies on HXC_TRANSACTIONS

Line 38: FROM hxc_transactions

34: -- Start
35:
36: CURSOR get_dep_txn_id
37: IS SELECT transaction_id
38: FROM hxc_transactions
39: WHERE type = 'DEPOSIT'
40: ORDER BY 1 asc;
41: -- End
42:

Line 53: hxc_transactions ht

49: IS SELECT hld.time_building_block_id
50: FROM hxc_latest_details hld
51: WHERE NOT EXISTS ( SELECT 1
52: FROM hxc_transaction_details htd,
53: hxc_transactions ht
54: WHERE hld.time_building_block_id = htd.time_building_block_id
55: AND hld.object_version_number = htd.time_building_block_ovn
56: AND htd.status = 'SUCCESS'
57: AND htd.transaction_id = ht.transaction_id

Line 79: hxc_transactions ht

75: IS SELECT hld.time_building_block_id
76: FROM hxc_latest_details hld
77: WHERE NOT EXISTS ( SELECT 1
78: FROM hxc_transaction_details htd,
79: hxc_transactions ht
80: WHERE hld.time_building_block_id = htd.time_building_block_id
81: AND hld.object_version_number = htd.time_building_block_ovn
82: AND htd.status = 'SUCCESS'
83: AND htd.transaction_id = ht.transaction_id

Line 843: FROM hxc_transactions

839: -- start
840: CURSOR c_get_txns( p_start NUMBER,
841: p_end NUMBER)
842: IS SELECT transaction_id
843: FROM hxc_transactions
844: WHERE transaction_id BETWEEN p_start
845: AND p_end
846: AND type = 'DEPOSIT'
847: ORDER BY 1 asc;

Line 882: hxc_transactions ht

878: AND tc.time_building_block_id = day.parent_building_block_id
879: AND tc.object_version_number = day.parent_building_block_ovn
880: AND NOT EXISTS ( SELECT 1
881: FROM hxc_transaction_details htd,
882: hxc_transactions ht
883: WHERE htd.time_building_block_id = hld.time_building_block_id
884: AND htd.time_building_block_ovn = hld.object_version_number
885: AND htd.transaction_id = ht.transaction_id
886: AND htd.status = 'SUCCESS'

Line 934: hxc_transactions ht

930: AND tc.time_building_block_id = day.parent_building_block_id
931: AND tc.object_version_number = day.parent_building_block_ovn
932: AND NOT EXISTS ( SELECT 1
933: FROM hxc_transaction_details htd,
934: hxc_transactions ht
935: WHERE htd.time_building_block_id = hld.time_building_block_id
936: AND htd.time_building_block_ovn = hld.object_version_number
937: AND htd.transaction_id = ht.transaction_id
938: AND htd.status = 'SUCCESS'

Line 1031: hxc_transactions ht

1027: WHERE temp.thread_id = p_thread_id
1028: AND temp.detail_attribute2 = 'D'
1029: AND NOT EXISTS ( SELECT 1
1030: FROM hxc_transaction_details htd,
1031: hxc_transactions ht
1032: WHERE htd.time_building_block_id = temp.detail_id
1033: AND htd.time_building_block_ovn < temp.detail_ovn
1034: AND htd.transaction_id = ht.transaction_id
1035: AND ht.type = 'RETRIEVAL'

Line 1051: hxc_transactions ht

1047: FROM hxc_upg_details_temp temp
1048: WHERE temp.thread_id = p_thread_id
1049: AND NOT EXISTS ( SELECT 1
1050: FROM hxc_transaction_details htd,
1051: hxc_transactions ht
1052: WHERE htd.time_building_block_id = temp.detail_id
1053: AND htd.time_building_block_ovn = temp.detail_ovn
1054: AND htd.transaction_id = ht.transaction_id
1055: AND ht.type = 'RETRIEVAL'

Line 1740: FROM hxc_transactions

1736: last_updated_by,
1737: last_update_date,
1738: last_update_login,
1739: data_set_id
1740: FROM hxc_transactions
1741: WHERE transaction_id = txnidtab(i)
1742: AND type = 'DEPOSIT') ;
1743:
1744: put_log('Migrated data to HXC_DEP_TRANSACTIONS');

Line 1746: -- Delete DEPOSIT transaction records from HXC_TRANSACTIONS

1742: AND type = 'DEPOSIT') ;
1743:
1744: put_log('Migrated data to HXC_DEP_TRANSACTIONS');
1745:
1746: -- Delete DEPOSIT transaction records from HXC_TRANSACTIONS
1747: FORALL i IN txnidtab.FIRST..txnidtab.LAST
1748: DELETE
1749: FROM hxc_transactions
1750: WHERE transaction_id = txnidtab(i) ;

Line 1749: FROM hxc_transactions

1745:
1746: -- Delete DEPOSIT transaction records from HXC_TRANSACTIONS
1747: FORALL i IN txnidtab.FIRST..txnidtab.LAST
1748: DELETE
1749: FROM hxc_transactions
1750: WHERE transaction_id = txnidtab(i) ;
1751:
1752: put_log('Deleted migrated records from HXC_TRANSACTIONS');
1753:

Line 1752: put_log('Deleted migrated records from HXC_TRANSACTIONS');

1748: DELETE
1749: FROM hxc_transactions
1750: WHERE transaction_id = txnidtab(i) ;
1751:
1752: put_log('Deleted migrated records from HXC_TRANSACTIONS');
1753:
1754: -- Bug 9845460
1755: -- Insert into new table HXC_DEP_TRANSACTION_DETAILS
1756: FORALL i IN txnidtab.FIRST..txnidtab.LAST