DBA Data[Home] [Help]

APPS.WSH_MAP_LOCATION_REGION_PKG dependencies on MSC_ATP_PROC

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

2755: IF l_debug_on THEN
2756: WSH_DEBUG_SV.logmsg(l_module_name, 'Transit Time Not cached',WSH_DEBUG_SV.C_PROC_LEVEL);
2757: END IF;
2758:
2759: --The ship method returned by MSC_ATP_PROC.ATP_Shipping_Lead_Time could be different
2760: --from the ship method passed in. If it doesn't find the transit time, it returns
2761: --the default ship method and default ship method transit time.
2762: l_prev_ship_method := l_ship_method_code;
2763:

Line 2766: --MSC_ATP_PROC.Shiping_Lead_Time API

2762: l_prev_ship_method := l_ship_method_code;
2763:
2764:
2765: --OM Callers pass the ship_to_site_id, and get the transit time from the
2766: --MSC_ATP_PROC.Shiping_Lead_Time API
2767: IF (p_from = 'OM') THEN
2768:
2769: OPEN get_session_id;
2770: FETCH get_session_id INTO l_session_id;

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

2773: IF l_debug_on THEN
2774: WSH_DEBUG_SV.logmsg(l_module_name,'MSC_ATP session id = ' || l_session_id,WSH_DEBUG_SV.C_PROC_LEVEL);
2775: END IF;
2776:
2777: MSC_ATP_PROC.ATP_Shipping_Lead_Time(p_from_loc_id => p_ship_from_loc_id,
2778: p_to_customer_site_id => p_ship_to_site_id,
2779: p_session_id => l_session_id,
2780: x_ship_method => l_ship_method_code,
2781: x_intransit_time => l_transit_time,

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

2781: x_intransit_time => l_transit_time,
2782: x_return_status => x_return_status);
2783:
2784: IF l_debug_on THEN
2785: WSH_DEBUG_SV.logmsg(l_module_name,'MSC_ATP_PROC.ATP_Shipping_Lead_Time is ' || l_transit_time,WSH_DEBUG_SV.C_PROC_LEVEL);
2786: END IF;
2787:
2788: --FTE callers pass in the ultimate_dropoff_location_id
2789: ELSE