[Home] [Help]
2840: --
2841: -- Debug Statements
2842: --
2843: IF l_debug_on THEN
2844: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.DELETE_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
2845: END IF;
2846: --
2847: wsh_new_deliveries_pvt.delete_delivery(null, p_rows(i), cur_return_status);
2848: elsif (p_type = 'DLEG') then
2843: IF l_debug_on THEN
2844: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.DELETE_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
2845: END IF;
2846: --
2847: wsh_new_deliveries_pvt.delete_delivery(null, p_rows(i), cur_return_status);
2848: elsif (p_type = 'DLEG') then
2849:
2850: -- wsh_delivery_legs_pvt.delete_delivery_leg(null, p_rows(i), cur_return_status);
2851:
3434:
3435: CURSOR get_delivery_wms(x_delivery_id NUMBER) IS
3436: SELECT mp.wms_enabled_flag,
3437: wnd.delivery_id
3438: FROM wsh_new_deliveries wnd,
3439: mtl_parameters mp
3440: WHERE wnd.delivery_id = x_delivery_id AND
3441: mp.organization_id = wnd.organization_id AND
3442: mp.wms_enabled_flag = 'Y';
3446: SELECT dg.delivery_id,
3447: st.trip_id,
3448: dl.organization_id,
3449: mp.wms_enabled_flag
3450: FROM wsh_new_deliveries dl,
3451: wsh_delivery_legs dg,
3452: wsh_trip_stops st,
3453: mtl_parameters mp
3454: WHERE dg.delivery_id = dl.delivery_id AND
6743: p_out_entity_id := nvl(wsh_trip_stops_pvt.get_name(p_in_entity_id), p_in_entity_id);
6744: ELSIF p_in_entity_name = 'DELIVERY'
6745: THEN
6746: p_out_entity_name := 'Delivery';
6747: p_out_entity_id := nvl(wsh_new_deliveries_pvt.get_name(p_in_entity_id), p_in_entity_id);
6748: ELSIF p_in_entity_name = 'LINE'
6749: THEN
6750: p_out_entity_name := 'Line';
6751: p_out_entity_id := p_in_entity_id;
7668: --
7669: -- Entity Type => Delivery
7670: cursor c_get_delivery_status( c_delivery_id NUMBER) is
7671: select status_code
7672: from wsh_new_deliveries
7673: where delivery_id = c_delivery_id;
7674:
7675: -- Entity Type => Delivery Detail
7676: cursor c_get_detail_status( c_delivery_detail_id NUMBER) is
7674:
7675: -- Entity Type => Delivery Detail
7676: cursor c_get_detail_status( c_delivery_detail_id NUMBER) is
7677: select status_code
7678: from wsh_new_deliveries wnd,
7679: wsh_delivery_assignments_v wda
7680: where wnd.delivery_id (+) = wda.delivery_id
7681: and wda.delivery_detail_id = c_delivery_detail_id;
7682:
7683: -- Entity Type => LPN
7684: -- Modified query for bug 4990527 as per WMS requirement
7685: cursor c_get_lpn_delivery_status( c_lpn_id NUMBER) is
7686: select distinct wnd.delivery_id, wnd.status_code
7687: from wsh_new_deliveries wnd,
7688: wsh_delivery_assignments_v wda,
7689: wsh_delivery_details wdd
7690: where wnd.delivery_id (+) = wda.delivery_id
7691: and wda.delivery_detail_id = wdd.delivery_detail_id
7696: from wms_license_plate_numbers wlpn
7697: where wlpn.outermost_lpn_id = c_lpn_id );
7698: --
7699:
7700: l_delivery_id WSH_NEW_DELIVERIES.Delivery_Id%TYPE;
7701: l_status_code WSH_NEW_DELIVERIES.Status_Code%TYPE;
7702: l_error_flag BOOLEAN := FALSE;
7703:
7704: --
7697: where wlpn.outermost_lpn_id = c_lpn_id );
7698: --
7699:
7700: l_delivery_id WSH_NEW_DELIVERIES.Delivery_Id%TYPE;
7701: l_status_code WSH_NEW_DELIVERIES.Status_Code%TYPE;
7702: l_error_flag BOOLEAN := FALSE;
7703:
7704: --
7705: l_debug_on BOOLEAN;
8159: SELECT dlvy.ORGANIZATION_ID
8160: INTO l_organization_id
8161: FROM WSH_TRIP_STOPS stops,
8162: WSH_DELIVERY_LEGS leg,
8163: WSH_NEW_DELIVERIES dlvy
8164: WHERE stops.stop_id = leg.pick_up_stop_id
8165: AND leg.delivery_id = dlvy.delivery_id
8166: AND stops.stop_id = l_first_stop_id
8167: AND ROWNUM = 1;
8180: -- Bug 6633529: Adding Rownum = 1 for Trips having more than 1 delivery for the same organization
8181: SELECT dlvy.ORGANIZATION_ID
8182: INTO l_organization_id
8183: FROM WSH_TRIP_STOPS stops, WSH_DELIVERY_LEGS leg,
8184: WSH_NEW_DELIVERIES dlvy
8185: WHERE stops.stop_id = leg.pick_up_stop_id
8186: AND leg.delivery_id = dlvy.delivery_id
8187: AND stops.stop_id = l_first_stop_id
8188: AND ROWNUM = 1;