DBA Data[Home] [Help]

APPS.WSH_MAP_LOCATION_REGION_PKG dependencies on MSC_ATP_PROC

Line 2743: --The ship method returned by MSC_ATP_PROC.ATP_Shipping_Lead_Time could be different

2739: IF l_debug_on THEN
2740: WSH_DEBUG_SV.logmsg(l_module_name, 'Transit Time Not cached',WSH_DEBUG_SV.C_PROC_LEVEL);
2741: END IF;
2742:
2743: --The ship method returned by MSC_ATP_PROC.ATP_Shipping_Lead_Time could be different
2744: --from the ship method passed in. If it doesn't find the transit time, it returns
2745: --the default ship method and default ship method transit time.
2746: l_prev_ship_method := l_ship_method_code;
2747:

Line 2750: --MSC_ATP_PROC.Shiping_Lead_Time API

2746: l_prev_ship_method := l_ship_method_code;
2747:
2748:
2749: --OM Callers pass the ship_to_site_id, and get the transit time from the
2750: --MSC_ATP_PROC.Shiping_Lead_Time API
2751: IF (p_from = 'OM') THEN
2752:
2753: OPEN get_session_id;
2754: FETCH get_session_id INTO l_session_id;

Line 2761: MSC_ATP_PROC.ATP_Shipping_Lead_Time(p_from_loc_id => p_ship_from_loc_id,

2757: IF l_debug_on THEN
2758: WSH_DEBUG_SV.logmsg(l_module_name,'MSC_ATP session id = ' || l_session_id,WSH_DEBUG_SV.C_PROC_LEVEL);
2759: END IF;
2760:
2761: MSC_ATP_PROC.ATP_Shipping_Lead_Time(p_from_loc_id => p_ship_from_loc_id,
2762: p_to_customer_site_id => p_ship_to_site_id,
2763: p_session_id => l_session_id,
2764: x_ship_method => l_ship_method_code,
2765: x_intransit_time => l_transit_time,

Line 2769: WSH_DEBUG_SV.logmsg(l_module_name,'MSC_ATP_PROC.ATP_Shipping_Lead_Time is ' || l_transit_time,WSH_DEBUG_SV.C_PROC_LEVEL);

2765: x_intransit_time => l_transit_time,
2766: x_return_status => x_return_status);
2767:
2768: IF l_debug_on THEN
2769: WSH_DEBUG_SV.logmsg(l_module_name,'MSC_ATP_PROC.ATP_Shipping_Lead_Time is ' || l_transit_time,WSH_DEBUG_SV.C_PROC_LEVEL);
2770: END IF;
2771:
2772: --FTE callers pass in the ultimate_dropoff_location_id
2773: ELSE