DBA Data[Home] [Help]

APPS.FND_LOG_UTIL dependencies on ICX_TRANSACTIONS

Line 36: l_last_connect ICX_TRANSACTIONS.LAST_CONNECT%TYPE;

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:
38: BEGIN
39: fdebug('In:FND_BE_UTIL.IS_TRANSACTION_COMPLETED');
40: fdebug('trId:'||trId ||',trType:'||trType ||',sessId:'||sessId );

Line 72: from ICX_TRANSACTIONS

68: l_retu:= TRUE;
69: ELSE
70: IF (trID <> NULL) THEN
71: select LAST_CONNECT into l_last_connect
72: from ICX_TRANSACTIONS
73: where TRANSACTION_ID=sessId;
74: ELSE
75: select max(LAST_CONNECT) into l_last_connect
76: from ICX_TRANSACTIONS

Line 76: from ICX_TRANSACTIONS

72: from ICX_TRANSACTIONS
73: where TRANSACTION_ID=sessId;
74: ELSE
75: select max(LAST_CONNECT) into l_last_connect
76: from ICX_TRANSACTIONS
77: where SESSION_ID=sessId;
78: END IF;
79:
80: IF (SYSDATE > l_last_connect + 1) THEN