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.

APPS.FND_CONC_STAT dependencies on FND_CONC_REQ_STAT

Line 120: INSERT INTO fnd_conc_req_stat (req_id, process_type, statistic#, value)

116: INTO p_actual_start_date
117: FROM fnd_concurrent_requests fcr
118: WHERE fcr.request_id = p_req_id;
119:
120: INSERT INTO fnd_conc_req_stat (req_id, process_type, statistic#, value)
121: VALUES (p_req_id, 'F', SYS_SEC_ID, sys_sec);
122:
123: INSERT INTO fnd_conc_req_stat (req_id, process_type, statistic#, value)
124: VALUES (p_req_id, 'F', SYS_MIC_ID, sys_mic);

Line 123: INSERT INTO fnd_conc_req_stat (req_id, process_type, statistic#, value)

119:
120: INSERT INTO fnd_conc_req_stat (req_id, process_type, statistic#, value)
121: VALUES (p_req_id, 'F', SYS_SEC_ID, sys_sec);
122:
123: INSERT INTO fnd_conc_req_stat (req_id, process_type, statistic#, value)
124: VALUES (p_req_id, 'F', SYS_MIC_ID, sys_mic);
125:
126: INSERT INTO fnd_conc_req_stat (req_id, process_type, statistic#, value)
127: VALUES (p_req_id, 'F', USR_SEC_ID, usr_sec);

Line 126: INSERT INTO fnd_conc_req_stat (req_id, process_type, statistic#, value)

122:
123: INSERT INTO fnd_conc_req_stat (req_id, process_type, statistic#, value)
124: VALUES (p_req_id, 'F', SYS_MIC_ID, sys_mic);
125:
126: INSERT INTO fnd_conc_req_stat (req_id, process_type, statistic#, value)
127: VALUES (p_req_id, 'F', USR_SEC_ID, usr_sec);
128:
129: INSERT INTO fnd_conc_req_stat (req_id, process_type, statistic#, value)
130: VALUES (p_req_id, 'F', USR_MIC_ID, usr_mic);

Line 129: INSERT INTO fnd_conc_req_stat (req_id, process_type, statistic#, value)

125:
126: INSERT INTO fnd_conc_req_stat (req_id, process_type, statistic#, value)
127: VALUES (p_req_id, 'F', USR_SEC_ID, usr_sec);
128:
129: INSERT INTO fnd_conc_req_stat (req_id, process_type, statistic#, value)
130: VALUES (p_req_id, 'F', USR_MIC_ID, usr_mic);
131:
132: INSERT INTO fnd_conc_req_stat (req_id, process_type, statistic#, value)
133: VALUES (p_req_id, 'F', REAL_SEC_ID, (SYSDATE - p_actual_start_date ) * DAYSECS );

Line 132: INSERT INTO fnd_conc_req_stat (req_id, process_type, statistic#, value)

128:
129: INSERT INTO fnd_conc_req_stat (req_id, process_type, statistic#, value)
130: VALUES (p_req_id, 'F', USR_MIC_ID, usr_mic);
131:
132: INSERT INTO fnd_conc_req_stat (req_id, process_type, statistic#, value)
133: VALUES (p_req_id, 'F', REAL_SEC_ID, (SYSDATE - p_actual_start_date ) * DAYSECS );
134: END IF;
135:
136: END put_frontend_cpu;

Line 172: INSERT INTO fnd_conc_req_stat(req_id, process_type, statistic#, value)

168: FROM v$session
169: WHERE audsid = userenv('SESSIONID');
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#

Line 179: INSERT INTO fnd_conc_req_stat(req_id, process_type, statistic#, value)

175: WHERE vstat.sid = session
176: AND slist.statistic# = vstat.statistic#
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#;

Line 185: INSERT INTO fnd_conc_req_stat(req_id, process_type, statistic#, 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)
186: SELECT p_req_id, 'S', vstat.statistic#, vstat.value
187: FROM v$sesstat vstat
188: WHERE vstat.sid = session;
189: END IF;

Line 227: INSERT INTO fnd_conc_req_stat(req_id, process_type, statistic#, value)

223: FROM v$session
224: WHERE audsid = userenv('SESSIONID');
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#

Line 234: INSERT INTO fnd_conc_req_stat(req_id, process_type, statistic#, value)

230: WHERE vstat.sid = session
231: AND slist.statistic# = vstat.statistic#
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#;

Line 240: INSERT INTO fnd_conc_req_stat(req_id, process_type, statistic#, 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)
241: SELECT - p_req_id, 'S', vstat.statistic#, vstat.value
242: FROM v$sesstat vstat
243: WHERE vstat.sid = session;
244: END IF;

Line 268: FROM fnd_conc_req_stat

264: PROCEDURE store_final IS
265:
266: CURSOR initial_values IS
267: SELECT statistic#, value
268: FROM fnd_conc_req_stat
269: WHERE req_id = - fnd_global.conc_request_id;
270:
271: curr_val NUMBER;
272: p_req_id NUMBER;

Line 293: UPDATE fnd_conc_req_stat

289: FROM v$sesstat vstat
290: WHERE vstat.sid = session
291: AND statistic# = oldstat.statistic#;
292:
293: UPDATE fnd_conc_req_stat
294: SET value = curr_val - oldstat.value, req_id = p_req_id
295: WHERE req_id = - p_req_id
296: AND statistic# = oldstat.statistic#;
297: