APPS.FND_CONC_STAT dependencies on FND_CONC_STAT

Line 1: PACKAGE BODY fnd_conc_stat AS

1: PACKAGE BODY fnd_conc_stat AS
2: /* $Header: AFAMRSCB.pls 115.8 2003/11/21 22:19:47 pferguso ship $ */
3:
4:
5: -- Overview of statistic collection:

Line 24: -- FND_CONC_STAT_LIST. The STATISTIC# is from V$STATNAME and the

20: -- E = Extra which includes S
21: -- A = All
22: --
23: -- The statistics corresponding to these levels are set in the table
24: -- FND_CONC_STAT_LIST. The STATISTIC# is from V$STATNAME and the
25: -- COLLECT_LEVEL is 'S' or 'E'. The level 'E' is made up of all
26: -- those in S plus any in E. So S is included in E. If the system
27: -- profile CONC_REQUEST_STAT <> 'Y', or if STAT_COLLECT is NULL or 'O'
28: -- no statistics will be collected for that program. The front-end CPU

Line 174: FROM v$sesstat vstat, fnd_conc_stat_list slist

170:
171: IF p_stat_collect = 'S' THEN
172: INSERT INTO fnd_conc_req_stat(req_id, process_type, statistic#, value)
173: SELECT p_req_id, 'S', slist.statistic#, vstat.value
174: FROM v$sesstat vstat, fnd_conc_stat_list slist
175: WHERE vstat.sid = session
176: AND slist.statistic# = vstat.statistic#
177: AND slist.collect_level = 'S';
178: ELSIF p_stat_collect = 'E' THEN

Line 181: FROM v$sesstat vstat, fnd_conc_stat_list slist

177: AND slist.collect_level = 'S';
178: ELSIF p_stat_collect = 'E' THEN
179: INSERT INTO fnd_conc_req_stat(req_id, process_type, statistic#, value)
180: SELECT p_req_id, 'S', slist.statistic#, vstat.value
181: FROM v$sesstat vstat, fnd_conc_stat_list slist
182: WHERE vstat.sid = session
183: AND slist.statistic# = vstat.statistic#;
184: ELSIF p_stat_collect = 'A' THEN
185: INSERT INTO fnd_conc_req_stat(req_id, process_type, statistic#, value)

Line 229: FROM v$sesstat vstat, fnd_conc_stat_list slist

225:
226: IF p_stat_collect = 'S' THEN
227: INSERT INTO fnd_conc_req_stat(req_id, process_type, statistic#, value)
228: SELECT - p_req_id, 'S', slist.statistic#, vstat.value
229: FROM v$sesstat vstat, fnd_conc_stat_list slist
230: WHERE vstat.sid = session
231: AND slist.statistic# = vstat.statistic#
232: AND slist.collect_level = 'S';
233: ELSIF p_stat_collect = 'E' THEN

Line 236: FROM v$sesstat vstat, fnd_conc_stat_list slist

232: AND slist.collect_level = 'S';
233: ELSIF p_stat_collect = 'E' THEN
234: INSERT INTO fnd_conc_req_stat(req_id, process_type, statistic#, value)
235: SELECT - p_req_id, 'S', slist.statistic#, vstat.value
236: FROM v$sesstat vstat, fnd_conc_stat_list slist
237: WHERE vstat.sid = session
238: AND slist.statistic# = vstat.statistic#;
239: ELSIF p_stat_collect = 'A' THEN
240: INSERT INTO fnd_conc_req_stat(req_id, process_type, statistic#, value)

Line 309: END fnd_conc_stat;

305: end if;
306:
307: END store_final;
308:
309: END fnd_conc_stat;