eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.FND_LOG_UTIL dependencies on FND_OAM_BIZEX_SENT_NOTIF

Line 240: select count(*) into l_rows_start from FND_OAM_BIZEX_SENT_NOTIF;

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;
241: delete from FND_OAM_BIZEX_SENT_NOTIF where UNIQUE_EXCEPTION_ID not in
242: (select distinct UNIQUE_EXCEPTION_ID from FND_LOG_UNIQUE_EXCEPTIONS );
243: select count(*) into l_rows_end from FND_OAM_BIZEX_SENT_NOTIF;
244: ---dbms_output.put_line('FND_OAM_BIZEX_SENT_NOTIF: dlt rows out of sync'||(l_rows_end-l_rows_start));

Line 241: delete from FND_OAM_BIZEX_SENT_NOTIF where UNIQUE_EXCEPTION_ID not in

237: commit;
238:
239:
240: select count(*) into l_rows_start from FND_OAM_BIZEX_SENT_NOTIF;
241: delete from FND_OAM_BIZEX_SENT_NOTIF where UNIQUE_EXCEPTION_ID not in
242: (select distinct UNIQUE_EXCEPTION_ID from FND_LOG_UNIQUE_EXCEPTIONS );
243: select count(*) into l_rows_end from FND_OAM_BIZEX_SENT_NOTIF;
244: ---dbms_output.put_line('FND_OAM_BIZEX_SENT_NOTIF: dlt rows out of sync'||(l_rows_end-l_rows_start));
245: commit;

Line 243: select count(*) into l_rows_end from FND_OAM_BIZEX_SENT_NOTIF;

239:
240: select count(*) into l_rows_start from FND_OAM_BIZEX_SENT_NOTIF;
241: delete from FND_OAM_BIZEX_SENT_NOTIF where UNIQUE_EXCEPTION_ID not in
242: (select distinct UNIQUE_EXCEPTION_ID from FND_LOG_UNIQUE_EXCEPTIONS );
243: select count(*) into l_rows_end from FND_OAM_BIZEX_SENT_NOTIF;
244: ---dbms_output.put_line('FND_OAM_BIZEX_SENT_NOTIF: dlt rows out of sync'||(l_rows_end-l_rows_start));
245: commit;
246:
247:

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

240: select count(*) into l_rows_start from FND_OAM_BIZEX_SENT_NOTIF;
241: delete from FND_OAM_BIZEX_SENT_NOTIF where UNIQUE_EXCEPTION_ID not in
242: (select distinct UNIQUE_EXCEPTION_ID from FND_LOG_UNIQUE_EXCEPTIONS );
243: select count(*) into l_rows_end from FND_OAM_BIZEX_SENT_NOTIF;
244: ---dbms_output.put_line('FND_OAM_BIZEX_SENT_NOTIF: dlt rows out of sync'||(l_rows_end-l_rows_start));
245: commit;
246:
247:
248: