26: p_api_version := 1;
27: p_init_msg_list := NULL;
28: l_server_gmt_offset := -8;
29:
30: l_server_timezone_id := to_number( FND_PROFILE.VALUE('SERVER_TIMEZONE_ID') );
31:
32: BEGIN
33:
34: select TIMEZONE_CODE
120: p_api_version := 1;
121: p_init_msg_list := NULL;
122: l_server_gmt_offset := -8;
123:
124: l_server_timezone_id := to_number( FND_PROFILE.VALUE('SERVER_TIMEZONE_ID') );
125:
126: BEGIN
127:
128: select TIMEZONE_CODE
217: -- Initialize timezone_code to server timezone code
218: -- If no information exists in WSH_LOCATIONS or HZ_TIMEZONES, we will
219: -- return the server timezone code
220:
221: p_timezone_id := to_number( FND_PROFILE.VALUE('SERVER_TIMEZONE_ID') );
222:
223: BEGIN
224:
225: select TIMEZONE_CODE
307: -- Initialize timezone_code to server timezone code
308: -- If no information exists in WSH_LOCATIONS or HZ_TIMEZONES, we will
309: -- return the server timezone code
310:
311: p_timezone_id := to_number( FND_PROFILE.VALUE('SERVER_TIMEZONE_ID') );
312:
313: BEGIN
314:
315: select TIMEZONE_CODE