APPS.WF_MAIL_UTIL dependencies on FND_TIMEZONES

Line 102: FND_TIMEZONES.timezones_enabled = 'Y' then

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

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

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

Line 145: l_tz_code FND_TIMEZONES_VL.NAME%TYPE;

141: -- l_GMT_deviation - GMT deviation in varchar2 format
142: function getGMTDeviation(pName in varchar2) return varchar2
143: is
144: l_gmt_deviation varchar2(240);
145: l_tz_code FND_TIMEZONES_VL.NAME%TYPE;
146: begin
147: SELECT TIMEZONE_CODE
148: INTO l_tz_code
149: FROM FND_TIMEZONES_VL

Line 149: FROM FND_TIMEZONES_VL

145: l_tz_code FND_TIMEZONES_VL.NAME%TYPE;
146: begin
147: SELECT TIMEZONE_CODE
148: INTO l_tz_code
149: FROM FND_TIMEZONES_VL
150: WHERE NAME=pName;
151: SELECT '(GMT ' ||rtrim(TZ_OFFSET(l_tz_code),chr(0))|| ') '|| pName
152: INTO l_gmt_deviation
153: FROM dual;