137: l_client_code varchar2(50);
138: l_client_date DATE;
139: BEGIN
140: -- get the timezones code
141: l_server_code := fnd_timezones.get_server_timezone_code;
142: l_client_code := fnd_timezones.get_client_timezone_code;
143:
144: -- call adjust time zone to convert to client timezone
145: l_client_date := fnd_timezones_pvt.adjust_datetime(
138: l_client_date DATE;
139: BEGIN
140: -- get the timezones code
141: l_server_code := fnd_timezones.get_server_timezone_code;
142: l_client_code := fnd_timezones.get_client_timezone_code;
143:
144: -- call adjust time zone to convert to client timezone
145: l_client_date := fnd_timezones_pvt.adjust_datetime(
146: date_time => pServerDate
141: l_server_code := fnd_timezones.get_server_timezone_code;
142: l_client_code := fnd_timezones.get_client_timezone_code;
143:
144: -- call adjust time zone to convert to client timezone
145: l_client_date := fnd_timezones_pvt.adjust_datetime(
146: date_time => pServerDate
147: ,from_tz => l_server_code
148: ,to_tz => l_client_code
149: );