APPS.FND_LOG_UTIL dependencies on FND_LOG_METRICS

Line 140: FND_LOG_METRICS flm

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;
144:

Line 206: select count(*) into l_rows_start from FND_LOG_METRICS;

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;
205:
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)

Line 207: delete from FND_LOG_METRICS where

203: ---dbms_output.put_line('FND_LOG_MESSAGES:dlt rows out of sync'||(l_rows_end-l_rows_start));
204: commit;
205:
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: ;

Line 212: select count(*) into l_rows_end from FND_LOG_METRICS;

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;
215:
216: select count(*) into l_rows_start from FND_LOG_EXCEPTIONS;

Line 213: ---dbms_output.put_line('FND_LOG_METRICS:dlt rows out of sync'||(l_rows_end-l_rows_start));

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;
215:
216: select count(*) into l_rows_start from FND_LOG_EXCEPTIONS;
217: delete from FND_LOG_EXCEPTIONS where LOG_SEQUENCE not in