APPS.FND_LOG_UTIL dependencies on FND_LOG_TRANSACTION_CONTEXT

Line 139: FND_LOG_TRANSACTION_CONTEXT fltc,

135: select
136: distinct fltc.SESSION_ID, fltc.TRANSACTION_CONTEXT_ID, fltc.TRANSACTION_TYPE
137: , fltc.TRANSACTION_ID
138: from
139: FND_LOG_TRANSACTION_CONTEXT fltc,
140: FND_LOG_METRICS flm
141: where
142: fltc.TRANSACTION_CONTEXT_ID=flm.TRANSACTION_CONTEXT_ID
143: and flm.EVENT_KEY is null;

Line 190: delete from FND_LOG_TRANSACTION_CONTEXT where

186: l_rows_start NUMBER;
187: l_rows_end NUMBER;
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.

Line 200: FND_LOG_TRANSACTION_CONTEXT)

196: select count(*) into l_rows_start from FND_LOG_MESSAGES;
197: delete from FND_LOG_MESSAGES where
198: TRANSACTION_CONTEXT_ID not in
199: (select distinct TRANSACTION_CONTEXT_ID from
200: FND_LOG_TRANSACTION_CONTEXT)
201: ;
202: select count(*) into l_rows_end from FND_LOG_MESSAGES;
203: ---dbms_output.put_line('FND_LOG_MESSAGES:dlt rows out of sync'||(l_rows_end-l_rows_start));
204: commit;

Line 210: FND_LOG_TRANSACTION_CONTEXT)

206: select count(*) into l_rows_start from FND_LOG_METRICS;
207: delete from FND_LOG_METRICS where
208: TRANSACTION_CONTEXT_ID not in
209: (select distinct TRANSACTION_CONTEXT_ID from
210: FND_LOG_TRANSACTION_CONTEXT)
211: ;
212: select count(*) into l_rows_end from FND_LOG_METRICS;
213: ---dbms_output.put_line('FND_LOG_METRICS:dlt rows out of sync'||(l_rows_end-l_rows_start));
214: commit;