APPS.HXC_GENERIC_RETRIEVAL_UTILS dependencies on HXC_TRANSACTIONS

Line 78: hxc_transactions ht,

74: SELECT htd.time_building_block_id,
75: htd.time_building_block_ovn,
76: ht.transaction_process_id
77: FROM hxc_transaction_details htd,
78: hxc_transactions ht,
79: hxc_retrieval_processes hrp
80: WHERE htd.time_building_block_id = p_curr_bb_id
81: AND htd.transaction_id = ht.transaction_id
82: AND ht.type = 'RETRIEVAL'

Line 1747: FROM hxc_transactions tx

1743:
1744: CURSOR csr_chk_for_in_progress ( p_conc_date DATE ) IS
1745: SELECT transaction_id
1746: , TRUNC(transaction_date) transaction_date
1747: FROM hxc_transactions tx
1748: WHERE tx.transaction_process_id = p_process_id
1749: AND tx.type = 'RETRIEVAL'
1750: AND tx.status = 'IN PROGRESS'
1751: AND tx.transaction_date < p_conc_date

Line 1942: UPDATE hxc_transactions tx

1938: IF ( g_debug ) THEN
1939: hr_utility.trace('Updating tx id '||to_char(l_index));
1940: END IF;
1941:
1942: UPDATE hxc_transactions tx
1943: SET tx.status = 'RECOVERED'
1944: WHERE tx.transaction_id = l_index;
1945:
1946: l_index := l_tx_tab.NEXT(l_index);