[Home] [Help]
2804: --
2805: -- Debug Statements
2806: --
2807: IF l_debug_on THEN
2808: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.DELETE_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
2809: END IF;
2810: --
2811: wsh_new_deliveries_pvt.delete_delivery(null, p_rows(i), cur_return_status);
2812: elsif (p_type = 'DLEG') then
2807: IF l_debug_on THEN
2808: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.DELETE_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
2809: END IF;
2810: --
2811: wsh_new_deliveries_pvt.delete_delivery(null, p_rows(i), cur_return_status);
2812: elsif (p_type = 'DLEG') then
2813:
2814: -- wsh_delivery_legs_pvt.delete_delivery_leg(null, p_rows(i), cur_return_status);
2815:
3398:
3399: CURSOR get_delivery_wms(x_delivery_id NUMBER) IS
3400: SELECT mp.wms_enabled_flag,
3401: wnd.delivery_id
3402: FROM wsh_new_deliveries wnd,
3403: mtl_parameters mp
3404: WHERE wnd.delivery_id = x_delivery_id AND
3405: mp.organization_id = wnd.organization_id AND
3406: mp.wms_enabled_flag = 'Y';
3410: SELECT dg.delivery_id,
3411: st.trip_id,
3412: dl.organization_id,
3413: mp.wms_enabled_flag
3414: FROM wsh_new_deliveries dl,
3415: wsh_delivery_legs dg,
3416: wsh_trip_stops st,
3417: mtl_parameters mp
3418: WHERE dg.delivery_id = dl.delivery_id AND
6707: p_out_entity_id := nvl(wsh_trip_stops_pvt.get_name(p_in_entity_id), p_in_entity_id);
6708: ELSIF p_in_entity_name = 'DELIVERY'
6709: THEN
6710: p_out_entity_name := 'Delivery';
6711: p_out_entity_id := nvl(wsh_new_deliveries_pvt.get_name(p_in_entity_id), p_in_entity_id);
6712: ELSIF p_in_entity_name = 'LINE'
6713: THEN
6714: p_out_entity_name := 'Line';
6715: p_out_entity_id := p_in_entity_id;
7632: --
7633: -- Entity Type => Delivery
7634: cursor c_get_delivery_status( c_delivery_id NUMBER) is
7635: select status_code
7636: from wsh_new_deliveries
7637: where delivery_id = c_delivery_id;
7638:
7639: -- Entity Type => Delivery Detail
7640: cursor c_get_detail_status( c_delivery_detail_id NUMBER) is
7638:
7639: -- Entity Type => Delivery Detail
7640: cursor c_get_detail_status( c_delivery_detail_id NUMBER) is
7641: select status_code
7642: from wsh_new_deliveries wnd,
7643: wsh_delivery_assignments_v wda
7644: where wnd.delivery_id (+) = wda.delivery_id
7645: and wda.delivery_detail_id = c_delivery_detail_id;
7646:
7647: -- Entity Type => LPN
7648: -- Modified query for bug 4990527 as per WMS requirement
7649: cursor c_get_lpn_delivery_status( c_lpn_id NUMBER) is
7650: select distinct wnd.delivery_id, wnd.status_code
7651: from wsh_new_deliveries wnd,
7652: wsh_delivery_assignments_v wda,
7653: wsh_delivery_details wdd
7654: where wnd.delivery_id (+) = wda.delivery_id
7655: and wda.delivery_detail_id = wdd.delivery_detail_id
7660: from wms_license_plate_numbers wlpn
7661: where wlpn.outermost_lpn_id = c_lpn_id );
7662: --
7663:
7664: l_delivery_id WSH_NEW_DELIVERIES.Delivery_Id%TYPE;
7665: l_status_code WSH_NEW_DELIVERIES.Status_Code%TYPE;
7666: l_error_flag BOOLEAN := FALSE;
7667:
7668: --
7661: where wlpn.outermost_lpn_id = c_lpn_id );
7662: --
7663:
7664: l_delivery_id WSH_NEW_DELIVERIES.Delivery_Id%TYPE;
7665: l_status_code WSH_NEW_DELIVERIES.Status_Code%TYPE;
7666: l_error_flag BOOLEAN := FALSE;
7667:
7668: --
7669: l_debug_on BOOLEAN;
8123: SELECT dlvy.ORGANIZATION_ID
8124: INTO l_organization_id
8125: FROM WSH_TRIP_STOPS stops,
8126: WSH_DELIVERY_LEGS leg,
8127: WSH_NEW_DELIVERIES dlvy
8128: WHERE stops.stop_id = leg.pick_up_stop_id
8129: AND leg.delivery_id = dlvy.delivery_id
8130: AND stops.stop_id = l_first_stop_id
8131: AND ROWNUM = 1;
8144: -- Bug 6633529: Adding Rownum = 1 for Trips having more than 1 delivery for the same organization
8145: SELECT dlvy.ORGANIZATION_ID
8146: INTO l_organization_id
8147: FROM WSH_TRIP_STOPS stops, WSH_DELIVERY_LEGS leg,
8148: WSH_NEW_DELIVERIES dlvy
8149: WHERE stops.stop_id = leg.pick_up_stop_id
8150: AND leg.delivery_id = dlvy.delivery_id
8151: AND stops.stop_id = l_first_stop_id
8152: AND ROWNUM = 1;