eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_TIMEZONE_PUB dependencies on STANDARD

Line 59: --Standard call to check for call compatibility.

55:
56: l_msg_token VARCHAR2(2000);
57: BEGIN
58:
59: --Standard call to check for call compatibility.
60: IF NOT FND_API.Compatible_API_Call(
61: l_api_version,
62: p_api_version,
63: l_api_name,

Line 214: --Standard call to get message count and if count is 1, get message info.

210: END; --compare all
211: END IF; --if state is passed
212: END; --if postal code and country match
213:
214: --Standard call to get message count and if count is 1, get message info.
215: FND_MSG_PUB.Count_And_Get(
216: p_encoded => FND_API.G_FALSE,
217: p_count => x_msg_count,
218: p_data => x_msg_data);

Line 351: --Standard call to check for call compatibility.

347: l_tz_count number := 0;
348:
349: BEGIN
350:
351: --Standard call to check for call compatibility.
352: IF NOT FND_API.Compatible_API_Call(
353: l_api_version,
354: p_api_version,
355: l_api_name,

Line 543: --Standard call to check for call compatibility.

539: l_date_in_gmt date;
540: l_timezone_code varchar2(50);
541: BEGIN
542:
543: --Standard call to check for call compatibility.
544: IF NOT FND_API.Compatible_API_Call(
545: l_api_version,
546: p_api_version,
547: l_api_name,

Line 608: --Standard call to get message count and if count is 1, get message info.

604: x_GMT_deviation := to_char((p_date-l_date_in_gmt)*24);
605:
606: END IF;
607:
608: --Standard call to get message count and if count is 1, get message info.
609: FND_MSG_PUB.Count_And_Get(
610: p_encoded => FND_API.G_FALSE,
611: p_count => x_msg_count,
612: p_data => x_msg_data);

Line 764: --Standard call to check for call compatibility.

760: l_dest_tz_code varchar2(5);
761:
762: BEGIN
763:
764: --Standard call to check for call compatibility.
765: IF NOT FND_API.Compatible_API_Call(
766: l_api_version,
767: p_api_version,
768: l_api_name,

Line 883: l_standard_short_code varchar2(5);

879: s_msg_count number;
880: s_msg_data varchar2(2000);
881: d_GMT_deviation number;
882: d_dst_flag varchar2(1);
883: l_standard_short_code varchar2(5);
884: l_daylight_short_code varchar2(5);
885:
886: BEGIN
887:

Line 888: --Standard call to check for call compatibility.

884: l_daylight_short_code varchar2(5);
885:
886: BEGIN
887:
888: --Standard call to check for call compatibility.
889: IF NOT FND_API.Compatible_API_Call(
890: l_api_version,
891: p_api_version,
892: l_api_name,

Line 910: /* if the gmt offset for this new timezone is the standard offset then it is not dst */

906: /* convert p_source_day_time to new timezone */
907: l_dest_day_time := hz_timezone_pub.convert_datetime(p_source_tz_id, p_dest_tz_id, p_source_day_time);
908:
909: /* now figure out if this is in dst or not in order to return the correct code */
910: /* if the gmt offset for this new timezone is the standard offset then it is not dst */
911:
912: SELECT GMT_DEVIATION_HOURS,
913: STANDARD_TIME_SHORT_CODE,
914: DAYLIGHT_SAVINGS_SHORT_CODE

Line 913: STANDARD_TIME_SHORT_CODE,

909: /* now figure out if this is in dst or not in order to return the correct code */
910: /* if the gmt offset for this new timezone is the standard offset then it is not dst */
911:
912: SELECT GMT_DEVIATION_HOURS,
913: STANDARD_TIME_SHORT_CODE,
914: DAYLIGHT_SAVINGS_SHORT_CODE
915: INTO std_GMT_deviation,
916: l_standard_short_code,
917: l_daylight_short_code

Line 916: l_standard_short_code,

912: SELECT GMT_DEVIATION_HOURS,
913: STANDARD_TIME_SHORT_CODE,
914: DAYLIGHT_SAVINGS_SHORT_CODE
915: INTO std_GMT_deviation,
916: l_standard_short_code,
917: l_daylight_short_code
918: FROM HZ_TIMEZONES
919: WHERE timezone_id = p_dest_tz_id;
920:

Line 936: /* if the current offset is different than the standard offset, then it must be daylight savings */

932: FND_MSG_PUB.ADD;
933: RAISE FND_API.G_EXC_ERROR;
934: END IF;
935:
936: /* if the current offset is different than the standard offset, then it must be daylight savings */
937: IF (std_GMT_deviation <> d_GMT_deviation) THEN
938: x_dest_tz_code := l_daylight_short_code;
939: ELSE
940: x_dest_tz_code := l_standard_short_code;

Line 940: x_dest_tz_code := l_standard_short_code;

936: /* if the current offset is different than the standard offset, then it must be daylight savings */
937: IF (std_GMT_deviation <> d_GMT_deviation) THEN
938: x_dest_tz_code := l_daylight_short_code;
939: ELSE
940: x_dest_tz_code := l_standard_short_code;
941: END IF;
942:
943: x_dest_gmt_deviation := d_GMT_deviation;
944: x_dest_day_time := l_dest_day_time;

Line 946: --Standard call to get message count and if count is 1, get message info.

942:
943: x_dest_gmt_deviation := d_GMT_deviation;
944: x_dest_day_time := l_dest_day_time;
945:
946: --Standard call to get message count and if count is 1, get message info.
947: FND_MSG_PUB.Count_And_Get(
948: p_encoded => FND_API.G_FALSE,
949: p_count => x_msg_count,
950: p_data => x_msg_data);

Line 1051: --Standard call to check for call compatibility.

1047: l_api_version CONSTANT NUMBER := 1.0;
1048:
1049: BEGIN
1050:
1051: --Standard call to check for call compatibility.
1052: IF NOT FND_API.Compatible_API_Call(
1053: l_api_version,
1054: p_api_version,
1055: l_api_name,

Line 1096: --Standard call to get message count and if count is 1, get message info.

1092: RAISE FND_API.G_EXC_ERROR;
1093:
1094: END;
1095:
1096: --Standard call to get message count and if count is 1, get message info.
1097: FND_MSG_PUB.Count_And_Get(
1098: p_encoded => FND_API.G_FALSE,
1099: p_count => x_msg_count,
1100: p_data => x_msg_data);

Line 1193: l_standard_short_code varchar2(5);

1189: l_api_version CONSTANT NUMBER := 1.0;
1190: l_gmt_deviation number;
1191: l_current_GMT_deviation number;
1192: l_date_in_gmt date;
1193: l_standard_short_code varchar2(5);
1194: l_daylight_short_code varchar2(5);
1195: l_timezone_id number;
1196: l_timezone_code varchar2(50);
1197:

Line 1200: --Standard call to check for call compatibility.

1196: l_timezone_code varchar2(50);
1197:
1198: BEGIN
1199:
1200: --Standard call to check for call compatibility.
1201: IF NOT FND_API.Compatible_API_Call(
1202: l_api_version,
1203: p_api_version,
1204: l_api_name,

Line 1222: H.STANDARD_TIME_SHORT_CODE,

1218: IF (p_timezone_id is not null) THEN
1219: BEGIN
1220:
1221: SELECT F.GMT_OFFSET,
1222: H.STANDARD_TIME_SHORT_CODE,
1223: H.DAYLIGHT_SAVINGS_SHORT_CODE,
1224: F.NAME,
1225: F.TIMEZONE_CODE
1226: INTO l_gmt_deviation,

Line 1227: l_standard_short_code,

1223: H.DAYLIGHT_SAVINGS_SHORT_CODE,
1224: F.NAME,
1225: F.TIMEZONE_CODE
1226: INTO l_gmt_deviation,
1227: l_standard_short_code,
1228: l_daylight_short_code,
1229: x_name,
1230: l_timezone_code
1231: FROM HZ_TIMEZONES_VL H, FND_TIMEZONES_VL F

Line 1245: h.STANDARD_TIME_SHORT_CODE,

1241: END;
1242: ELSE
1243: BEGIN
1244: SELECT f.GMT_OFFSET,
1245: h.STANDARD_TIME_SHORT_CODE,
1246: h.DAYLIGHT_SAVINGS_SHORT_CODE,
1247: f.NAME
1248: INTO l_gmt_deviation,
1249: l_standard_short_code,

Line 1249: l_standard_short_code,

1245: h.STANDARD_TIME_SHORT_CODE,
1246: h.DAYLIGHT_SAVINGS_SHORT_CODE,
1247: f.NAME
1248: INTO l_gmt_deviation,
1249: l_standard_short_code,
1250: l_daylight_short_code,
1251: x_name
1252: FROM FND_TIMEZONES_VL f, HZ_TIMEZONES_VL h
1253: WHERE f.timezone_code = p_timezone_code

Line 1277: /* if the current offset is different than the standard offset, then it must be daylight savings */

1273: 'YYYY-MM-DD HH24:MI:SS TZR') at time zone 'GMT';
1274: l_current_GMT_deviation := to_char((p_date-l_date_in_gmt)*24);
1275:
1276:
1277: /* if the current offset is different than the standard offset, then it must be daylight savings */
1278:
1279: IF (l_GMT_deviation <> l_current_GMT_deviation) THEN
1280: x_timezone_short_code := l_daylight_short_code;
1281: ELSE

Line 1282: x_timezone_short_code := l_standard_short_code;

1278:
1279: IF (l_GMT_deviation <> l_current_GMT_deviation) THEN
1280: x_timezone_short_code := l_daylight_short_code;
1281: ELSE
1282: x_timezone_short_code := l_standard_short_code;
1283: END IF;
1284:
1285: x_gmt_deviation := l_current_GMT_deviation;
1286:

Line 1287: --Standard call to get message count and if count is 1, get message info.

1283: END IF;
1284:
1285: x_gmt_deviation := l_current_GMT_deviation;
1286:
1287: --Standard call to get message count and if count is 1, get message info.
1288: FND_MSG_PUB.Count_And_Get(
1289: p_encoded => FND_API.G_FALSE,
1290: p_count => x_msg_count,
1291: p_data => x_msg_data);