DBA Data[Home] [Help]

APPS.CSFW_TIMEZONE_PUB dependencies on HZ_TIMEZONE_PUB

Line 29: HZ_TIMEZONE_PUB.GET_TIME(1.0, 'F', l_server_tz_id, l_client_tz_id, p_server_time, x_client_time, l_status, l_msg_count, l_msg_data);

25:
26: l_client_tz_id := to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID'));
27: l_server_tz_id := to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
28:
29: HZ_TIMEZONE_PUB.GET_TIME(1.0, 'F', l_server_tz_id, l_client_tz_id, p_server_time, x_client_time, l_status, l_msg_count, l_msg_data);
30:
31: return x_client_time;
32: END GET_CLIENT_TIME;
33:

Line 58: HZ_TIMEZONE_PUB.GET_TIME(1.0, 'F', l_server_tz_id, l_client_tz_id, l_sysdate_server, l_sysdate_client, l_status, l_msg_count, l_msg_data);

54: l_server_tz_id := to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
55:
56: l_sysdate_server := sysdate;
57:
58: HZ_TIMEZONE_PUB.GET_TIME(1.0, 'F', l_server_tz_id, l_client_tz_id, l_sysdate_server, l_sysdate_client, l_status, l_msg_count, l_msg_data);
59: x_time_diff := l_sysdate_server - l_sysdate_client;-- (server - client)
60:
61: return x_time_diff;
62:

Line 88: HZ_TIMEZONE_PUB.GET_TIME(1.0, 'F', l_client_tz_id,l_server_tz_id, to_date(p_client_time, p_date_format) ,x_server_time, l_status, l_msg_count, l_msg_data);

84:
85: l_client_tz_id := to_number(fnd_profile.value('CLIENT_TIMEZONE_ID'));
86: l_server_tz_id := to_number(fnd_profile.value('SERVER_TIMEZONE_ID'));
87:
88: HZ_TIMEZONE_PUB.GET_TIME(1.0, 'F', l_client_tz_id,l_server_tz_id, to_date(p_client_time, p_date_format) ,x_server_time, l_status, l_msg_count, l_msg_data);
89:
90: return to_char(x_server_time,p_date_format) ;
91: END GET_SERVER_TIME;
92: