DBA Data[Home] [Help]

APPS.ORACLEMYPAGE dependencies on V$TIMER

Line 7: select HSECS into l_hsecs from V$TIMER;

3:
4: procedure timer(message VARCHAR2) is --defaulted to NULL, removed for GSCC
5: l_hsecs pls_integer;
6: begin
7: select HSECS into l_hsecs from V$TIMER;
8: htp.p('DEBUG ('||l_hsecs||') '||message);htp.nl;
9: htp.p('Debug');
10: end;
11:

Line 122: select HSECS into l_start from V$TIMER;

118: order by b.DISPLAY_SEQUENCE;
119:
120: begin
121:
122: select HSECS into l_start from V$TIMER;
123: l_hsecs := l_start;
124:
125: if (icx_sec.validateSession)
126: then

Line 217: select HSECS into l_timer from V$TIMER;

213: cattributes => 'NAME="functionwindowfocus"');
214: htp.formHidden('X','FALSE');
215: htp.formClose;
216:
217: select HSECS into l_timer from V$TIMER;
218: l_timer := (l_timer-l_hsecs)/100;
219: htp.p('

Startup took '||l_timer||' seconds

');
220:
221: htp.p('');

Line 228: select HSECS into l_hsecs from V$TIMER;

224:
225: for l in left loop
226: htp.p('

');

Line 251: select HSECS into l_hsecs from V$TIMER;

247:
248: for r in right loop
249: htp.p('

');

Line 271: select HSECS into l_timer from V$TIMER;

267: htp.p('

');
227:
228: select HSECS into l_hsecs from V$TIMER;
229:
230: l_stmt_str := 'begin '||l.web_html_call||
231: '(p_session_id => '||icx_sec.g_session_id||
232: ',p_plug_id => '||l.plug_id||

Line 237: select HSECS into l_timer from V$TIMER;

233: ',p_display_name => '''||replace(l.prompt,'''','''''')||''');'||
234: ' end;';
235: execute immediate l_stmt_str;
236:
237: select HSECS into l_timer from V$TIMER;
238: l_timer := (l_timer-l_hsecs)/100;
239: htp.p('

Region took '||l_timer||' seconds

');
240:
241: htp.p('
');
250:
251: select HSECS into l_hsecs from V$TIMER;
252:
253: l_stmt_str := 'begin '||r.web_html_call||
254: '(p_session_id => '||icx_sec.g_session_id||
255: ',p_plug_id => '||r.plug_id||

Line 260: select HSECS into l_timer from V$TIMER;

256: ',p_display_name => '''||replace(r.prompt,'''','''''')||''');'||
257: ' end;';
258: execute immediate l_stmt_str;
259:
260: select HSECS into l_timer from V$TIMER;
261: l_timer := (l_timer-l_hsecs)/100;
262: htp.p('

Region took '||l_timer||' seconds

');
263:
264: htp.p('
');
268: htp.p('');
269: htp.p('');
270:
271: select HSECS into l_timer from V$TIMER;
272: l_timer := (l_timer-l_start)/100;
273: htp.p('

Whole page took '||l_timer||' seconds

');
274:
275: htp.p('');

Line 1026: select HSECS into l_start from V$TIMER;

1022:
1023:
1024:
1025:
1026: select HSECS into l_start from V$TIMER;
1027: l_hsecs := l_start;
1028:
1029: if validate_flag = 'Y' then
1030: if (icx_sec.validatesession) then