1 package body fnd_log_summary as
2 /* $Header: AFUTLGSB.pls 115.0 2004/03/09 02:24:54 kkapur noship $ */
3
4
5 /* This routine is used as a concurrent program. */
6 /* Nobody besides the concurrent manager should call it. */
7 procedure summarize_rows is
8 l_count number := 0;
9 begin
10 select count(*) into l_count from FND_LOG_MESSAGES;
11 fnd_conc_summarizer.insert_row('FND_LOG_MESSAGES', l_count);
12
13 select count(*) into l_count from FND_LOG_TRANSACTION_CONTEXT;
14 fnd_conc_summarizer.insert_row('FND_LOG_TRANSACTION_CONTEXT', l_count);
15
16 select count(*) into l_count from FND_LOG_ATTACHMENTS;
17 fnd_conc_summarizer.insert_row('FND_LOG_ATTACHMENTS', l_count);
18
19 select count(*) into l_count from FND_LOG_METRICS;
20 fnd_conc_summarizer.insert_row('FND_LOG_METRICS', l_count);
21
22 select count(*) into l_count from FND_LOG_EXCEPTIONS;
23 fnd_conc_summarizer.insert_row('FND_LOG_EXCEPTIONS', l_count);
24
25 select count(*) into l_count from FND_LOG_UNIQUE_EXCEPTIONS;
26 fnd_conc_summarizer.insert_row('FND_LOG_UNIQUE_EXCEPTIONS', l_count);
27
28 select count(*) into l_count from FND_EXCEPTION_NOTES;
29 fnd_conc_summarizer.insert_row('FND_EXCEPTION_NOTES', l_count);
30
31 select count(*) into l_count from FND_OAM_BIZEX_SENT_NOTIF;
32 fnd_conc_summarizer.insert_row('FND_OAM_BIZEX_SENT_NOTIF', l_count);
33 end summarize_rows;
34
35 end fnd_log_summary;