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.MTH_TZ_UTIL dependencies on V$TIMEZONE_NAMES

Line 25: SELECT tzname INTO from_tz_name FROM V$TIMEZONE_NAMES WHERE tzabbrev = from_tz AND ROWNUM = 1;

21: from_tz_name varchar2(64);
22: to_tz_name varchar2(64);
23: BEGIN
24: t_date := date_time;
25: SELECT tzname INTO from_tz_name FROM V$TIMEZONE_NAMES WHERE tzabbrev = from_tz AND ROWNUM = 1;
26: SELECT tzname INTO to_tz_name FROM V$TIMEZONE_NAMES WHERE tzabbrev = to_tz AND ROWNUM = 1;
27:
28: IF date_time IS NOT null AND from_tz IS NOT null AND to_tz IS not null
29: AND from_tz_name IS NOT NULL AND to_tz_name IS NOT NULL THEN

Line 26: SELECT tzname INTO to_tz_name FROM V$TIMEZONE_NAMES WHERE tzabbrev = to_tz AND ROWNUM = 1;

22: to_tz_name varchar2(64);
23: BEGIN
24: t_date := date_time;
25: SELECT tzname INTO from_tz_name FROM V$TIMEZONE_NAMES WHERE tzabbrev = from_tz AND ROWNUM = 1;
26: SELECT tzname INTO to_tz_name FROM V$TIMEZONE_NAMES WHERE tzabbrev = to_tz AND ROWNUM = 1;
27:
28: IF date_time IS NOT null AND from_tz IS NOT null AND to_tz IS not null
29: AND from_tz_name IS NOT NULL AND to_tz_name IS NOT NULL THEN
30: BEGIN

Line 62: SELECT tzname INTO from_tz_name FROM V$TIMEZONE_NAMES WHERE tzabbrev = from_tz AND ROWNUM = 1;

58: t_date date;
59: from_tz_name varchar2(64);
60: BEGIN
61: t_date := date_time;
62: SELECT tzname INTO from_tz_name FROM V$TIMEZONE_NAMES WHERE tzabbrev = from_tz AND ROWNUM = 1;
63:
64: IF date_time IS NOT NULL AND from_tz IS NOT NULL AND from_tz_name IS NOT NULL THEN
65: BEGIN
66: return_date := to_timestamp_tz(to_char(t_date,'YYYY-MM-DD HH24:MI:SS') || ' ' || from_tz_name, 'YYYY-MM-DD HH24:MI:SS TZR') at time zone 'GMT';

Line 97: SELECT tzname INTO to_tz_name FROM V$TIMEZONE_NAMES WHERE tzabbrev = to_tz AND ROWNUM = 1;

93: t_date date;
94: to_tz_name varchar2(64);
95: BEGIN
96: t_date := date_time;
97: SELECT tzname INTO to_tz_name FROM V$TIMEZONE_NAMES WHERE tzabbrev = to_tz AND ROWNUM = 1;
98:
99: IF date_time IS NOT NULL AND to_tz IS NOT NULL THEN
100: BEGIN
101: return_date := to_timestamp_tz(to_char(t_date,'YYYY-MM-DD HH24:MI:SS') || ' ' || 'GMT', 'YYYY-MM-DD HH24:MI:SS TZR') at time zone to_tz_name;