APPS.FND_LOG_UTIL dependencies on FND_CONCURRENT_REQUESTS

Line 33: l_phase_code FND_CONCURRENT_REQUESTS.PHASE_CODE%TYPE;

29: function IS_TRANSACTION_COMPLETED(trId in NUMBER, trType in VARCHAR2
30: ,sessId in NUMBER, ignoreICX in BOOLEAN) return BOOLEAN
31: IS
32: l_retu BOOLEAN;
33: l_phase_code FND_CONCURRENT_REQUESTS.PHASE_CODE%TYPE;
34: l_process_status_code FND_CONCURRENT_PROCESSES.PROCESS_STATUS_CODE%TYPE;
35: l_audsid_count NUMBER;
36: l_last_connect ICX_TRANSACTIONS.LAST_CONNECT%TYPE;
37:

Line 44: from FND_CONCURRENT_REQUESTS

40: fdebug('trId:'||trId ||',trType:'||trType ||',sessId:'||sessId );
41: l_retu := false;
42: IF (trType = 'REQUEST') THEN
43: select PHASE_CODE into l_phase_code
44: from FND_CONCURRENT_REQUESTS
45: where REQUEST_ID=trId;
46:
47: IF (l_phase_code='C') THEN
48: l_retu:= TRUE;

Line 192: ( SELECT REQUEST_ID from FND_CONCURRENT_REQUESTS where REQUEST_ID=TRANSACTION_ID);

188: BEGIN
189: --Detelet Transaction Context infor if its relevent infor NA
190: delete from FND_LOG_TRANSACTION_CONTEXT where
191: TRANSACTION_TYPE = 'REQUEST' AND TRANSACTION_ID<>
192: ( SELECT REQUEST_ID from FND_CONCURRENT_REQUESTS where REQUEST_ID=TRANSACTION_ID);
193:
194: --Deletes data for which no transaction context info is available.
195: ---dbms_output.put_line('IN:SYNC_EXP_DATA');
196: select count(*) into l_rows_start from FND_LOG_MESSAGES;