APPS.HXC_GENERIC_RETRIEVAL_UTILS dependencies on HXC_TRANSACTIONS

Line 73: hxc_transactions ht,

69: SELECT htd.time_building_block_id,
70: htd.time_building_block_ovn,
71: ht.transaction_process_id
72: FROM hxc_transaction_details htd,
73: hxc_transactions ht,
74: hxc_retrieval_processes hrp
75: WHERE htd.time_building_block_id = p_curr_bb_id
76: AND htd.transaction_id = ht.transaction_id
77: AND ht.type = 'RETRIEVAL'

Line 1596: FROM hxc_transactions tx

1592:
1593: CURSOR csr_chk_for_in_progress ( p_conc_date DATE ) IS
1594: SELECT transaction_id
1595: , TRUNC(transaction_date) transaction_date
1596: FROM hxc_transactions tx
1597: WHERE tx.transaction_process_id = p_process_id
1598: AND tx.type = 'RETRIEVAL'
1599: AND tx.status = 'IN PROGRESS'
1600: AND tx.transaction_date < p_conc_date

Line 1791: UPDATE hxc_transactions tx

1787: IF ( g_debug ) THEN
1788: hr_utility.trace('Updating tx id '||to_char(l_index));
1789: END IF;
1790:
1791: UPDATE hxc_transactions tx
1792: SET tx.status = 'RECOVERED'
1793: WHERE tx.transaction_id = l_index;
1794:
1795: l_index := l_tx_tab.NEXT(l_index);