APPS.HXC_GENERIC_RETRIEVAL_UTILS dependencies on HXC_RETRIEVAL_RANGES

Line 1898: LOCK TABLE hxc_retrieval_ranges IN EXCLUSIVE MODE NOWAIT;

1894: END IF;
1895:
1896: l_locking_retrieval_ranges := TRUE;
1897:
1898: LOCK TABLE hxc_retrieval_ranges IN EXCLUSIVE MODE NOWAIT;
1899:
1900: END IF;
1901:
1902: IF ( g_debug ) THEN

Line 1977: UPDATE hxc_retrieval_ranges rr

1973: -- without in progress transactions then the transactions must have
1974: -- been updated in SQL. 99.9% of the time the transaction will
1975: -- exist thus the table will be locked
1976:
1977: UPDATE hxc_retrieval_ranges rr
1978: SET rr.transaction_id = -999
1979: WHERE rr.creation_date < l_req_date
1980: AND rr.retrieval_process_id = p_process_id
1981: AND rr.transaction_id = 0;