APPS.CSP_SCH_INT_PVT dependencies on HZ_TIMEZONE_PUB

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

5404: END LOOP;
5405: CLOSE C2;
5406: END IF;
5407: IF l_shipto_timezone_id <> l_server_time_zone_id THEN
5408: HZ_TIMEZONE_PUB.Get_Time( p_api_version => 1.0,
5409: p_init_msg_list => FND_API.G_FALSE,
5410: p_source_tz_id => l_server_time_zone_id,
5411: p_dest_tz_id => l_shipto_timezone_id,
5412: p_source_day_time => sysdate,

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

5445: shipping_option := true;
5446: END IF;
5447: l_delivery_date := trunc(l_sysdate + l_lead_time);
5448: IF l_shipto_timezone_id <> l_server_time_zone_id THEN
5449: HZ_TIMEZONE_PUB.Get_Time( p_api_version => 1.0,
5450: p_init_msg_list => FND_API.G_FALSE,
5451: p_source_tz_id => l_shipto_timezone_id,
5452: p_dest_tz_id => l_server_time_zone_id,
5453: p_source_day_time => l_delivery_date,

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

5530: l_delivery_date := l_delivery_date + (l_saftey_zone * 1/24) ;
5531: END IF;
5532:
5533: IF l_shipto_timezone_id <> l_server_time_zone_id THEN
5534: HZ_TIMEZONE_PUB.Get_Time( p_api_version => 1.0,
5535: p_init_msg_list => FND_API.G_FALSE,
5536: p_source_tz_id => l_shipto_timezone_id,
5537: p_dest_tz_id => l_server_time_zone_id,
5538: p_source_day_time => l_delivery_date,

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

5544: l_server_delivery_date := l_delivery_date;
5545: END IF;
5546:
5547: IF l_cutoff_time is not null then
5548: HZ_TIMEZONE_PUB.Get_Time( p_api_version => 1.0,
5549: p_init_msg_list => FND_API.G_FALSE,
5550: p_source_tz_id => l_timezone_id,
5551: p_dest_tz_id => l_server_time_zone_id,
5552: p_source_day_time => l_cutoff_time,

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

6060: FETCH C3 INTO l_cost,l_relation_ship_id ,l_cutoff_time,l_timezone_id,l_shipping_methode ;
6061: EXIT WHEN C3%NOTFOUND;
6062: 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);
6063: IF p_timezone_id <> l_server_time_zone_id THEN
6064: HZ_TIMEZONE_PUB.Get_Time( p_api_version => 1.0,
6065: p_init_msg_list => FND_API.G_FALSE,
6066: p_source_tz_id => p_timezone_id,
6067: p_dest_tz_id => l_server_time_zone_id,
6068: p_source_day_time => x_delivery_date,

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

6073: ELSE
6074: l_server_delivery_date := x_delivery_date;
6075: END IF;
6076: IF l_cutoff_time is not null then
6077: HZ_TIMEZONE_PUB.Get_Time( p_api_version => 1.0,
6078: p_init_msg_list => FND_API.G_FALSE,
6079: p_source_tz_id => l_timezone_id,
6080: p_dest_tz_id => l_server_time_zone_id,
6081: p_source_day_time => l_cutoff_time,

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

7994: OPEN get_cutoff_time(p_org_id,p_ship_method);
7995: FETCH get_cutoff_time INTO l_cutoff_time , l_timezone_id;
7996: CLOSE get_cutoff_time;
7997: IF l_cutoff_time IS NOT NULL and l_server_time_zone_id IS NOT NULL THEN
7998: HZ_TIMEZONE_PUB.Get_Time( p_api_version => 1.0,
7999: p_init_msg_list => FND_API.G_FALSE,
8000: p_source_tz_id => l_timezone_id,
8001: p_dest_tz_id => l_server_time_zone_id,
8002: p_source_day_time => l_cutoff_time,