1185: IS
1186: Begin
1187:
1188: /* reset the timezone profiles */
1189: g_timezone_enabled := (fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' AND
1190: fnd_profile.value('CLIENT_TIMEZONE_ID') IS NOT NULL AND
1191: fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND
1192: fnd_profile.value('CLIENT_TIMEZONE_ID') <>
1193: fnd_profile.value('SERVER_TIMEZONE_ID'));
1186: Begin
1187:
1188: /* reset the timezone profiles */
1189: g_timezone_enabled := (fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' AND
1190: fnd_profile.value('CLIENT_TIMEZONE_ID') IS NOT NULL AND
1191: fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND
1192: fnd_profile.value('CLIENT_TIMEZONE_ID') <>
1193: fnd_profile.value('SERVER_TIMEZONE_ID'));
1194:
1187:
1188: /* reset the timezone profiles */
1189: g_timezone_enabled := (fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' AND
1190: fnd_profile.value('CLIENT_TIMEZONE_ID') IS NOT NULL AND
1191: fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND
1192: fnd_profile.value('CLIENT_TIMEZONE_ID') <>
1193: fnd_profile.value('SERVER_TIMEZONE_ID'));
1194:
1195:
1188: /* reset the timezone profiles */
1189: g_timezone_enabled := (fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' AND
1190: fnd_profile.value('CLIENT_TIMEZONE_ID') IS NOT NULL AND
1191: fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND
1192: fnd_profile.value('CLIENT_TIMEZONE_ID') <>
1193: fnd_profile.value('SERVER_TIMEZONE_ID'));
1194:
1195:
1196: g_client_id := fnd_profile.value('CLIENT_TIMEZONE_ID');
1189: g_timezone_enabled := (fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' AND
1190: fnd_profile.value('CLIENT_TIMEZONE_ID') IS NOT NULL AND
1191: fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND
1192: fnd_profile.value('CLIENT_TIMEZONE_ID') <>
1193: fnd_profile.value('SERVER_TIMEZONE_ID'));
1194:
1195:
1196: g_client_id := fnd_profile.value('CLIENT_TIMEZONE_ID');
1197: g_server_id := fnd_profile.value('SERVER_TIMEZONE_ID');
1192: fnd_profile.value('CLIENT_TIMEZONE_ID') <>
1193: fnd_profile.value('SERVER_TIMEZONE_ID'));
1194:
1195:
1196: g_client_id := fnd_profile.value('CLIENT_TIMEZONE_ID');
1197: g_server_id := fnd_profile.value('SERVER_TIMEZONE_ID');
1198:
1199: Exception
1200: when others then
1193: fnd_profile.value('SERVER_TIMEZONE_ID'));
1194:
1195:
1196: g_client_id := fnd_profile.value('CLIENT_TIMEZONE_ID');
1197: g_server_id := fnd_profile.value('SERVER_TIMEZONE_ID');
1198:
1199: Exception
1200: when others then
1201: null;