APPS.CSP_SCH_INT_PVT dependencies on HZ_TIMEZONE_PUB

Line 3014: HZ_TIMEZONE_PUB.Get_Time( p_api_version => 1.0,

3010: END LOOP;
3011: CLOSE C2;
3012: END IF;
3013: IF l_shipto_timezone_id <> l_server_time_zone_id THEN
3014: HZ_TIMEZONE_PUB.Get_Time( p_api_version => 1.0,
3015: p_init_msg_list => FND_API.G_FALSE,
3016: p_source_tz_id => l_server_time_zone_id,
3017: p_dest_tz_id => l_shipto_timezone_id,
3018: p_source_day_time => sysdate,

Line 3055: HZ_TIMEZONE_PUB.Get_Time( p_api_version => 1.0,

3051: shipping_option := true;
3052: END IF;
3053: l_delivery_date := trunc(l_sysdate + l_lead_time);
3054: IF l_shipto_timezone_id <> l_server_time_zone_id THEN
3055: HZ_TIMEZONE_PUB.Get_Time( p_api_version => 1.0,
3056: p_init_msg_list => FND_API.G_FALSE,
3057: p_source_tz_id => l_shipto_timezone_id,
3058: p_dest_tz_id => l_server_time_zone_id,
3059: p_source_day_time => l_delivery_date,

Line 3140: HZ_TIMEZONE_PUB.Get_Time( p_api_version => 1.0,

3136: l_delivery_date := l_delivery_date + (l_saftey_zone * 1/24) ;
3137: END IF;
3138:
3139: IF l_shipto_timezone_id <> l_server_time_zone_id THEN
3140: HZ_TIMEZONE_PUB.Get_Time( p_api_version => 1.0,
3141: p_init_msg_list => FND_API.G_FALSE,
3142: p_source_tz_id => l_shipto_timezone_id,
3143: p_dest_tz_id => l_server_time_zone_id,
3144: p_source_day_time => l_delivery_date,

Line 3154: HZ_TIMEZONE_PUB.Get_Time( p_api_version => 1.0,

3150: l_server_delivery_date := l_delivery_date;
3151: END IF;
3152:
3153: IF l_cutoff_time is not null then
3154: HZ_TIMEZONE_PUB.Get_Time( p_api_version => 1.0,
3155: p_init_msg_list => FND_API.G_FALSE,
3156: p_source_tz_id => l_timezone_id,
3157: p_dest_tz_id => l_server_time_zone_id,
3158: p_source_day_time => l_cutoff_time,

Line 3639: HZ_TIMEZONE_PUB.Get_Time( p_api_version => 1.0,

3635: FETCH C3 INTO l_cost,l_relation_ship_id ,l_cutoff_time,l_timezone_id,l_shipping_methode ;
3636: EXIT WHEN C3%NOTFOUND;
3637: CSP_SCH_INT_PVT.GET_DELIVERY_DATE(l_relation_ship_id, x_delivery_date,x_shipping_option,x_return_status,x_msg_data,x_msg_count);
3638: IF p_timezone_id <> l_server_time_zone_id THEN
3639: HZ_TIMEZONE_PUB.Get_Time( p_api_version => 1.0,
3640: p_init_msg_list => FND_API.G_FALSE,
3641: p_source_tz_id => p_timezone_id,
3642: p_dest_tz_id => l_server_time_zone_id,
3643: p_source_day_time => x_delivery_date,

Line 3652: HZ_TIMEZONE_PUB.Get_Time( p_api_version => 1.0,

3648: ELSE
3649: l_server_delivery_date := x_delivery_date;
3650: END IF;
3651: IF l_cutoff_time is not null then
3652: HZ_TIMEZONE_PUB.Get_Time( p_api_version => 1.0,
3653: p_init_msg_list => FND_API.G_FALSE,
3654: p_source_tz_id => l_timezone_id,
3655: p_dest_tz_id => l_server_time_zone_id,
3656: p_source_day_time => l_cutoff_time,

Line 5456: HZ_TIMEZONE_PUB.Get_Time( p_api_version => 1.0,

5452: OPEN get_cutoff_time(p_org_id,p_ship_method);
5453: FETCH get_cutoff_time INTO l_cutoff_time , l_timezone_id;
5454: CLOSE get_cutoff_time;
5455: IF l_cutoff_time IS NOT NULL and l_server_time_zone_id IS NOT NULL THEN
5456: HZ_TIMEZONE_PUB.Get_Time( p_api_version => 1.0,
5457: p_init_msg_list => FND_API.G_FALSE,
5458: p_source_tz_id => l_timezone_id,
5459: p_dest_tz_id => l_server_time_zone_id,
5460: p_source_day_time => l_cutoff_time,