APPS.WF_MAIL_UTIL dependencies on FND_TIMEZONES

Line 99: FND_TIMEZONES.timezones_enabled = 'Y' then

95: timezone varchar2(240);
96:
97: begin
98: if g_install='EMBEDDED' AND
99: FND_TIMEZONES.timezones_enabled = 'Y' then
100:
101: -- bug 5043031: When Mailer sends notifications to users
102: -- with different lang preferences one after the other;
103: -- user some times gets time zone in different langauge rather than user's prefered language.

Line 105: g_timezoneName := FND_TIMEZONES.GET_NAME(FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE);

101: -- bug 5043031: When Mailer sends notifications to users
102: -- with different lang preferences one after the other;
103: -- user some times gets time zone in different langauge rather than user's prefered language.
104: --
105: g_timezoneName := FND_TIMEZONES.GET_NAME(FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE);
106: g_gmt_offset := getGMTDeviation(g_timezoneName);
107:
108: if length(g_gmt_offset) > 0 then
109: if contentType = g_ntfDocText then

Line 150: FROM FND_TIMEZONES_VL t

146: begin
147:
148: SELECT name, gmt_offset, daylight_savings_flag
149: INTO l_name, l_gmt_offset, l_daylight_flag
150: FROM FND_TIMEZONES_VL t
151: WHERE t.enabled_flag = 'Y'
152: AND t.name=pName;
153:
154: l_offset_str1 := to_char(trunc(l_gmt_offset),'S09') || ':'