228: ---dbms_output.put_line('FND_LOG_UNIQUE_EXCEPTIONS: dlt rows out of sync'||(l_rows_end-l_rows_start));
229: commit;
230:
231:
232: select count(*) into l_rows_start from FND_EXCEPTION_NOTES;
233: delete from FND_EXCEPTION_NOTES where UNIQUE_EXCEPTION_ID not in
234: (select distinct UNIQUE_EXCEPTION_ID from FND_LOG_UNIQUE_EXCEPTIONS );
235: select count(*) into l_rows_end from FND_EXCEPTION_NOTES;
236: ---dbms_output.put_line('FND_EXCEPTION_NOTES: dlt rows out of sync'||(l_rows_end-l_rows_start));
229: commit;
230:
231:
232: select count(*) into l_rows_start from FND_EXCEPTION_NOTES;
233: delete from FND_EXCEPTION_NOTES where UNIQUE_EXCEPTION_ID not in
234: (select distinct UNIQUE_EXCEPTION_ID from FND_LOG_UNIQUE_EXCEPTIONS );
235: select count(*) into l_rows_end from FND_EXCEPTION_NOTES;
236: ---dbms_output.put_line('FND_EXCEPTION_NOTES: dlt rows out of sync'||(l_rows_end-l_rows_start));
237: commit;
231:
232: select count(*) into l_rows_start from FND_EXCEPTION_NOTES;
233: delete from FND_EXCEPTION_NOTES where UNIQUE_EXCEPTION_ID not in
234: (select distinct UNIQUE_EXCEPTION_ID from FND_LOG_UNIQUE_EXCEPTIONS );
235: select count(*) into l_rows_end from FND_EXCEPTION_NOTES;
236: ---dbms_output.put_line('FND_EXCEPTION_NOTES: dlt rows out of sync'||(l_rows_end-l_rows_start));
237: commit;
238:
239:
232: select count(*) into l_rows_start from FND_EXCEPTION_NOTES;
233: delete from FND_EXCEPTION_NOTES where UNIQUE_EXCEPTION_ID not in
234: (select distinct UNIQUE_EXCEPTION_ID from FND_LOG_UNIQUE_EXCEPTIONS );
235: select count(*) into l_rows_end from FND_EXCEPTION_NOTES;
236: ---dbms_output.put_line('FND_EXCEPTION_NOTES: dlt rows out of sync'||(l_rows_end-l_rows_start));
237: commit;
238:
239:
240: select count(*) into l_rows_start from FND_OAM_BIZEX_SENT_NOTIF;