DBA Data[Home] [Help]

APPS.EAM_WORKORDERREP_PVT dependencies on FND_PROFILE

Line 1376: /*l_client_tz_id := to_number ( fnd_profile.value_specific('CLIENT_TIMEZONE_ID'));

1372: l_client_time date;
1373: l_status varchar2(100);
1374: BEGIN
1375: -- API body
1376: /*l_client_tz_id := to_number ( fnd_profile.value_specific('CLIENT_TIMEZONE_ID'));
1377: l_server_tz_id := to_number( fnd_profile.value_specific('SERVER_TIMEZONE_ID'));*/
1378: -- fix for 6415147
1379: l_client_tz_id := nvl(to_number ( fnd_profile.value_specific('CLIENT_TIMEZONE_ID')),nvl(to_number ( fnd_profile.value_specific('CLIENT_TIMEZONE_ID',fnd_global.user_id)),0));
1380: l_server_tz_id := nvl(to_number( fnd_profile.value_specific('SERVER_TIMEZONE_ID')),nvl(to_number( fnd_profile.value_specific('SERVER_TIMEZONE_ID',fnd_global.user_id)),0));

Line 1377: l_server_tz_id := to_number( fnd_profile.value_specific('SERVER_TIMEZONE_ID'));*/

1373: l_status varchar2(100);
1374: BEGIN
1375: -- API body
1376: /*l_client_tz_id := to_number ( fnd_profile.value_specific('CLIENT_TIMEZONE_ID'));
1377: l_server_tz_id := to_number( fnd_profile.value_specific('SERVER_TIMEZONE_ID'));*/
1378: -- fix for 6415147
1379: l_client_tz_id := nvl(to_number ( fnd_profile.value_specific('CLIENT_TIMEZONE_ID')),nvl(to_number ( fnd_profile.value_specific('CLIENT_TIMEZONE_ID',fnd_global.user_id)),0));
1380: l_server_tz_id := nvl(to_number( fnd_profile.value_specific('SERVER_TIMEZONE_ID')),nvl(to_number( fnd_profile.value_specific('SERVER_TIMEZONE_ID',fnd_global.user_id)),0));
1381:

Line 1379: l_client_tz_id := nvl(to_number ( fnd_profile.value_specific('CLIENT_TIMEZONE_ID')),nvl(to_number ( fnd_profile.value_specific('CLIENT_TIMEZONE_ID',fnd_global.user_id)),0));

1375: -- API body
1376: /*l_client_tz_id := to_number ( fnd_profile.value_specific('CLIENT_TIMEZONE_ID'));
1377: l_server_tz_id := to_number( fnd_profile.value_specific('SERVER_TIMEZONE_ID'));*/
1378: -- fix for 6415147
1379: l_client_tz_id := nvl(to_number ( fnd_profile.value_specific('CLIENT_TIMEZONE_ID')),nvl(to_number ( fnd_profile.value_specific('CLIENT_TIMEZONE_ID',fnd_global.user_id)),0));
1380: l_server_tz_id := nvl(to_number( fnd_profile.value_specific('SERVER_TIMEZONE_ID')),nvl(to_number( fnd_profile.value_specific('SERVER_TIMEZONE_ID',fnd_global.user_id)),0));
1381:
1382: HZ_TIMEZONE_PUB.Get_Time(1.0, 'F', l_server_tz_id, l_client_tz_id, p_server_time,
1383: l_client_time, l_status, l_msg_count, l_msg_data);

Line 1380: l_server_tz_id := nvl(to_number( fnd_profile.value_specific('SERVER_TIMEZONE_ID')),nvl(to_number( fnd_profile.value_specific('SERVER_TIMEZONE_ID',fnd_global.user_id)),0));

1376: /*l_client_tz_id := to_number ( fnd_profile.value_specific('CLIENT_TIMEZONE_ID'));
1377: l_server_tz_id := to_number( fnd_profile.value_specific('SERVER_TIMEZONE_ID'));*/
1378: -- fix for 6415147
1379: l_client_tz_id := nvl(to_number ( fnd_profile.value_specific('CLIENT_TIMEZONE_ID')),nvl(to_number ( fnd_profile.value_specific('CLIENT_TIMEZONE_ID',fnd_global.user_id)),0));
1380: l_server_tz_id := nvl(to_number( fnd_profile.value_specific('SERVER_TIMEZONE_ID')),nvl(to_number( fnd_profile.value_specific('SERVER_TIMEZONE_ID',fnd_global.user_id)),0));
1381:
1382: HZ_TIMEZONE_PUB.Get_Time(1.0, 'F', l_server_tz_id, l_client_tz_id, p_server_time,
1383: l_client_time, l_status, l_msg_count, l_msg_data);
1384: return l_client_time;