APPS.CSFW_TIMEZONE_PUB dependencies on FND_PROFILE

Line 26: l_client_tz_id := to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID'));

22: IF (fnd_timezones.timezones_enabled <> 'Y') THEN
23: return p_server_time;
24: END IF;
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:

Line 27: l_server_tz_id := to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID'));

23: return p_server_time;
24: END IF;
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;

Line 53: l_client_tz_id := to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID'));

49: IF (fnd_timezones.timezones_enabled <> 'Y') THEN
50: return 0;
51: END IF;
52:
53: l_client_tz_id := to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID'));
54: l_server_tz_id := to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
55:
56: l_sysdate_server := sysdate;
57:

Line 54: l_server_tz_id := to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID'));

50: return 0;
51: END IF;
52:
53: l_client_tz_id := to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID'));
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);

Line 85: l_client_tz_id := to_number(fnd_profile.value('CLIENT_TIMEZONE_ID'));

81: return p_client_time;
82: END IF;
83:
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:

Line 86: l_server_tz_id := to_number(fnd_profile.value('SERVER_TIMEZONE_ID'));

82: END IF;
83:
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) ;