1144: IS
1145: Begin
1146:
1147: /* reset the timezone profiles */
1148: g_timezone_enabled := (fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' AND
1149: fnd_profile.value('CLIENT_TIMEZONE_ID') IS NOT NULL AND
1150: fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND
1151: fnd_profile.value('CLIENT_TIMEZONE_ID') <>
1152: fnd_profile.value('SERVER_TIMEZONE_ID'));
1145: Begin
1146:
1147: /* reset the timezone profiles */
1148: g_timezone_enabled := (fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' AND
1149: fnd_profile.value('CLIENT_TIMEZONE_ID') IS NOT NULL AND
1150: fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND
1151: fnd_profile.value('CLIENT_TIMEZONE_ID') <>
1152: fnd_profile.value('SERVER_TIMEZONE_ID'));
1153:
1146:
1147: /* reset the timezone profiles */
1148: g_timezone_enabled := (fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' AND
1149: fnd_profile.value('CLIENT_TIMEZONE_ID') IS NOT NULL AND
1150: fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND
1151: fnd_profile.value('CLIENT_TIMEZONE_ID') <>
1152: fnd_profile.value('SERVER_TIMEZONE_ID'));
1153:
1154:
1147: /* reset the timezone profiles */
1148: g_timezone_enabled := (fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' AND
1149: fnd_profile.value('CLIENT_TIMEZONE_ID') IS NOT NULL AND
1150: fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND
1151: fnd_profile.value('CLIENT_TIMEZONE_ID') <>
1152: fnd_profile.value('SERVER_TIMEZONE_ID'));
1153:
1154:
1155: g_client_id := fnd_profile.value('CLIENT_TIMEZONE_ID');
1148: g_timezone_enabled := (fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' AND
1149: fnd_profile.value('CLIENT_TIMEZONE_ID') IS NOT NULL AND
1150: fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND
1151: fnd_profile.value('CLIENT_TIMEZONE_ID') <>
1152: fnd_profile.value('SERVER_TIMEZONE_ID'));
1153:
1154:
1155: g_client_id := fnd_profile.value('CLIENT_TIMEZONE_ID');
1156: g_server_id := fnd_profile.value('SERVER_TIMEZONE_ID');
1151: fnd_profile.value('CLIENT_TIMEZONE_ID') <>
1152: fnd_profile.value('SERVER_TIMEZONE_ID'));
1153:
1154:
1155: g_client_id := fnd_profile.value('CLIENT_TIMEZONE_ID');
1156: g_server_id := fnd_profile.value('SERVER_TIMEZONE_ID');
1157:
1158: Exception
1159: when others then
1152: fnd_profile.value('SERVER_TIMEZONE_ID'));
1153:
1154:
1155: g_client_id := fnd_profile.value('CLIENT_TIMEZONE_ID');
1156: g_server_id := fnd_profile.value('SERVER_TIMEZONE_ID');
1157:
1158: Exception
1159: when others then
1160: null;