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.

SYS.STANDARD dependencies on DUAL

Line 63: -- the old 'select soundex(...) from dual;' thing. This allows us to do the

59: return VARCHAR2 CHARACTER SET ch%CHARSET;
60: pragma interface (c,pessdx);
61:
62: -- Special: if the ICD raises ICD_UNABLE_TO_COMPUTE, that means we should do
63: -- the old 'select soundex(...) from dual;' thing. This allows us to do the
64: -- SELECT from PL/SQL rather than having to do it from C (within the ICD.)
65: function SOUNDEX(ch VARCHAR2 CHARACTER SET ANY_CS)
66: return VARCHAR2 CHARACTER SET ch%CHARSET is
67: c VARCHAR2(2000) CHARACTER SET ch%CHARSET;

Line 73: select soundex(ch) into c from sys.dual;

69: c := pessdx(ch);
70: return c;
71: exception
72: when ICD_UNABLE_TO_COMPUTE then
73: select soundex(ch) into c from sys.dual;
74: return c;
75: end SOUNDEX;
76:
77: function TRANSLATE(STR1 VARCHAR2 CHARACTER SET ANY_CS,

Line 173: select uid into i from sys.dual;

169:
170: function UID return PLS_INTEGER is
171: i pls_integer;
172: begin
173: select uid into i from sys.dual;
174: return i;
175: end;
176:
177: function USER return varchar2 is

Line 180: select user into c from sys.dual;

176:
177: function USER return varchar2 is
178: c varchar2(255);
179: begin
180: select user into c from sys.dual;
181: return c;
182: end;
183:
184:

Line 189: -- the old 'select userenv(...) from dual;' thing. This allows us to do the

185: function pesuen(envstr VARCHAR2) return VARCHAR2;
186: pragma interface (c,pesuen);
187:
188: -- Special: if the ICD raises ICD_UNABLE_TO_COMPUTE, that means we should do
189: -- the old 'select userenv(...) from dual;' thing. This allows us to do the
190: -- select from PL/SQL rather than having to do it from C (within the ICD.)
191: function USERENV (envstr varchar2) return varchar2 is
192: c varchar2(255);
193: begin

Line 208: select userenv('TERMINAL') into c from sys.dual;

204: begin
205: c := pesuen(c);
206: exception
207: when ICD_UNABLE_TO_COMPUTE then
208: select userenv('TERMINAL') into c from sys.dual;
209: end;
210: elsif c = 'ENTRYID' then
211: begin
212: c := pesuen(c);

Line 215: select userenv('ENTRYID') into c from sys.dual;

211: begin
212: c := pesuen(c);
213: exception
214: when ICD_UNABLE_TO_COMPUTE then
215: select userenv('ENTRYID') into c from sys.dual;
216: end;
217: elsif c = 'SESSIONID' then
218: begin
219: c := pesuen(c);

Line 222: select userenv('SESSIONID') into c from sys.dual;

218: begin
219: c := pesuen(c);
220: exception
221: when ICD_UNABLE_TO_COMPUTE then
222: select userenv('SESSIONID') into c from sys.dual;
223: end;
224: elsif c = 'LANGUAGE' then
225: begin
226: c := pesuen(c);

Line 229: select userenv('LANGUAGE') into c from sys.dual;

225: begin
226: c := pesuen(c);
227: exception
228: when ICD_UNABLE_TO_COMPUTE then
229: select userenv('LANGUAGE') into c from sys.dual;
230: end;
231: elsif c = 'LANG' then
232: begin
233: c := pesuen(c);

Line 236: select userenv('LANG') into c from sys.dual;

232: begin
233: c := pesuen(c);
234: exception
235: when ICD_UNABLE_TO_COMPUTE then
236: select userenv('LANG') into c from sys.dual;
237: end;
238: elsif c = 'INSTANCE' then
239: begin
240: c := pesuen(c);

Line 243: select userenv('INSTANCE') into c from sys.dual;

239: begin
240: c := pesuen(c);
241: exception
242: when ICD_UNABLE_TO_COMPUTE then
243: select userenv('INSTANCE') into c from sys.dual;
244: end;
245: elsif c = 'CLIENT_INFO' then
246: begin
247: c := pesuen(c);

Line 250: select userenv('CLIENT_INFO') into c from sys.dual;

246: begin
247: c := pesuen(c);
248: exception
249: when ICD_UNABLE_TO_COMPUTE then
250: select userenv('CLIENT_INFO') into c from sys.dual;
251: end;
252: elsif c = 'ISDBA' then
253: begin
254: c := pesuen(c);

Line 257: select userenv('ISDBA') into c from sys.dual;

253: begin
254: c := pesuen(c);
255: exception
256: when ICD_UNABLE_TO_COMPUTE then
257: select userenv('ISDBA') into c from sys.dual;
258: end;
259: elsif c = 'SCHEMAID' then
260: begin
261: c := pesuen(c);

Line 264: select userenv('SCHEMAID') into c from sys.dual;

260: begin
261: c := pesuen(c);
262: exception
263: when ICD_UNABLE_TO_COMPUTE then
264: select userenv('SCHEMAID') into c from sys.dual;
265: end;
266: elsif c = 'SID' then
267: begin
268: c := pesuen(c);

Line 271: select userenv('SID') into c from sys.dual;

267: begin
268: c := pesuen(c);
269: exception
270: when ICD_UNABLE_TO_COMPUTE then
271: select userenv('SID') into c from sys.dual;
272: end;
273: elsif c = 'PID' then
274: begin
275: c := pesuen(c);

Line 278: select userenv('PID') into c from sys.dual;

274: begin
275: c := pesuen(c);
276: exception
277: when ICD_UNABLE_TO_COMPUTE then
278: select userenv('PID') into c from sys.dual;
279: end;
280: else
281: raise INVALID_USERENV_PARAMETER;
282: end if;

Line 339: select nls_charset_name(csetid) into v from sys.dual;

335: function NLS_CHARSET_NAME(csetid PLS_INTEGER)
336: return VARCHAR2 is
337: v varchar2(2000);
338: begin
339: select nls_charset_name(csetid) into v from sys.dual;
340: return v;
341: end NLS_CHARSET_NAME;
342:
343: function NLS_CHARSET_ID(csetname VARCHAR2)

Line 347: select nls_charset_id(csetname) into i from sys.dual;

343: function NLS_CHARSET_ID(csetname VARCHAR2)
344: return PLS_INTEGER is
345: i PLS_INTEGER;
346: begin
347: select nls_charset_id(csetname) into i from sys.dual;
348: return i;
349: end NLS_CHARSET_ID;
350:
351: function NLS_CHARSET_DECL_LEN(bytecnt NUMBER, csetid NUMBER)

Line 355: select nls_charset_decl_len(bytecnt, csetid) into i from sys.dual;

351: function NLS_CHARSET_DECL_LEN(bytecnt NUMBER, csetid NUMBER)
352: return PLS_INTEGER is
353: i PLS_INTEGER;
354: begin
355: select nls_charset_decl_len(bytecnt, csetid) into i from sys.dual;
356: return i;
357: end NLS_CHARSET_DECL_LEN;
358: -- end of NLS routines
359:

Line 537: -- the old 'SELECT SYSDATE FROM DUAL;' thing. This allows us to do the

533: pragma interface (c,pessdt);
534:
535: -- Bug 1287775: back to calling ICD.
536: -- Special: if the ICD raises ICD_UNABLE_TO_COMPUTE, that means we should do
537: -- the old 'SELECT SYSDATE FROM DUAL;' thing. This allows us to do the
538: -- SELECT from PL/SQL rather than having to do it from C (within the ICD.)
539: function sysdate return date is
540: d date;
541: begin

Line 546: select sysdate into d from sys.dual;

542: d := pessdt;
543: return d;
544: exception
545: when ICD_UNABLE_TO_COMPUTE then
546: select sysdate into d from sys.dual;
547: return d;
548: end;
549:
550: function pesguid return RAW;

Line 560: select sys_guid() into c from sys.dual;

556: c := pesguid;
557: return c;
558: exception
559: when ICD_UNABLE_TO_COMPUTE then
560: select sys_guid() into c from sys.dual;
561: return c;
562: end;
563:
564: function pessysctx2(namespace varchar2, attribute varchar2) return varchar2;

Line 568: -- the old 'select sys_context(...) from dual;' thing. This allows us to do

564: function pessysctx2(namespace varchar2, attribute varchar2) return varchar2;
565: pragma interface (c,pessysctx2);
566:
567: -- Special: if the ICD raises ICD_UNABLE_TO_COMPUTE, that means we should do
568: -- the old 'select sys_context(...) from dual;' thing. This allows us to do
569: -- the select from PL/SQL rather than having to do it from C (within the ICD.)
570: function SYS_CONTEXT(namespace varchar2, attribute varchar2)
571: return varchar2 is
572: c varchar2(4000);

Line 578: select sys_context(namespace,attribute) into c from sys.dual;

574: c := pessysctx2(namespace, attribute);
575: return c;
576: exception
577: when ICD_UNABLE_TO_COMPUTE then
578: select sys_context(namespace,attribute) into c from sys.dual;
579: return c;
580: end;
581:
582: -- time zone functions

Line 588: -- the old 'SELECT systimestamp FROM dual;' thing. This allows us to do the

584: function pessts return timestamp_tz_unconstrained;
585: pragma interface (c,pessts);
586:
587: -- Special: if the ICD raises ICD_UNABLE_TO_COMPUTE, that means we should do
588: -- the old 'SELECT systimestamp FROM dual;' thing. This allows us to do the
589: -- SELECT from PL/SQL rather than having to do it from C (within the ICD.)
590: FUNCTION systimestamp RETURN timestamp_tz_unconstrained
591: IS t timestamp_tz_unconstrained;
592: BEGIN

Line 597: SELECT systimestamp INTO t FROM sys.dual;

593: t := pessts;
594: RETURN t;
595: EXCEPTION
596: WHEN ICD_UNABLE_TO_COMPUTE THEN
597: SELECT systimestamp INTO t FROM sys.dual;
598: RETURN t;
599: END;
600:
601: function pesdbtz return varchar2;

Line 605: -- the old 'SELECT dbtimezone FROM dual;' thing. This allows us to do the

601: function pesdbtz return varchar2;
602: pragma interface (c,pesdbtz);
603:
604: -- Special: if the ICD raises ICD_UNABLE_TO_COMPUTE, that means we should do
605: -- the old 'SELECT dbtimezone FROM dual;' thing. This allows us to do the
606: -- SELECT from PL/SQL rather than having to do it from C (within the ICD.)
607: FUNCTION dbtimezone RETURN varchar2
608: IS t VARCHAR2(75); -- == TZNMSTRLEN [2213965]
609: BEGIN

Line 614: SELECT dbtimezone INTO t FROM sys.dual;

610: t := pesdbtz;
611: RETURN t;
612: EXCEPTION
613: WHEN ICD_UNABLE_TO_COMPUTE THEN
614: SELECT dbtimezone INTO t FROM sys.dual;
615: RETURN t;
616: END;
617:
618: FUNCTION localtimestamp RETURN timestamp_unconstrained

Line 635: -- the old 'select sys_context(...) from dual;' thing. This allows us to do

631: newoptional varchar2) return varchar2;
632: pragma interface (c,pessysctx3);
633:
634: -- Special: if the ICD raises ICD_UNABLE_TO_COMPUTE, that means we should do
635: -- the old 'select sys_context(...) from dual;' thing. This allows us to do
636: -- the select from PL/SQL rather than having to do it from C (within the ICD.)
637: function SYS_CONTEXT(namespace varchar2, attribute varchar2,
638: newoptional varchar2)
639: return varchar2 is

Line 646: select sys_context(namespace,attribute,newoptional) into c from sys.dual;

642: c := pessysctx3(namespace, attribute, newoptional);
643: return c;
644: exception
645: when ICD_UNABLE_TO_COMPUTE then
646: select sys_context(namespace,attribute,newoptional) into c from sys.dual;
647: return c;
648: end;
649:
650: function TO_NCLOB(cl CLOB CHARACTER SET ANY_CS) return NCLOB is