APPS.HXC_GENERIC_RETRIEVAL_UTILS dependencies on HXC_RETRIEVAL_RANGES

Line 1747: LOCK TABLE hxc_retrieval_ranges IN EXCLUSIVE MODE NOWAIT;

1743: END IF;
1744:
1745: l_locking_retrieval_ranges := TRUE;
1746:
1747: LOCK TABLE hxc_retrieval_ranges IN EXCLUSIVE MODE NOWAIT;
1748:
1749: END IF;
1750:
1751: IF ( g_debug ) THEN

Line 1826: UPDATE hxc_retrieval_ranges rr

1822: -- without in progress transactions then the transactions must have
1823: -- been updated in SQL. 99.9% of the time the transaction will
1824: -- exist thus the table will be locked
1825:
1826: UPDATE hxc_retrieval_ranges rr
1827: SET rr.transaction_id = -999
1828: WHERE rr.creation_date < l_req_date
1829: AND rr.retrieval_process_id = p_process_id
1830: AND rr.transaction_id = 0;