DBA Data[Home] [Help]

APPS.WIP_DATETIMES dependencies on FND_PROFILE

Line 104: NVL(fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS'),'N') = 'Y') THEN

100:
101: BEGIN
102: l_le_tz_code := inv_le_timezone_pub.get_le_tz_code_for_inv_org(p_org_id);
103: if (l_le_tz_code IS NOT NULL AND
104: NVL(fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS'),'N') = 'Y') THEN
105: OPEN c_tz_id(l_le_tz_code);
106: FETCH c_tz_id INTO l_le_tz_id;
107: CLOSE c_tz_id;
108: --

Line 115: , p_dest_tz_id => fnd_profile.value('SERVER_TIMEZONE_ID')

111: HZ_TIMEZONE_PUB.Get_Time
112: ( p_api_version => 1.0
113: , p_init_msg_list => FND_API.G_FALSE
114: , p_source_tz_id => l_le_tz_id
115: , p_dest_tz_id => fnd_profile.value('SERVER_TIMEZONE_ID')
116: , p_source_day_time => (p_le_date + 1 - 1/24/60/60)
117: , x_dest_day_time => l_ret_date
118: , x_return_status => l_return_status
119: , x_msg_count => l_msg_count