[Home] [Help]
628: --
629: -- Debug Statements
630: --
631: IF l_debug_on THEN
632: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
633: END IF;
634: --
635: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',
636: WSH_NEW_DELIVERIES_PVT.get_name(l_rec_wdl1(j).delivery_id));
632: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
633: END IF;
634: --
635: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',
636: WSH_NEW_DELIVERIES_PVT.get_name(l_rec_wdl1(j).delivery_id));
637: --
638: -- Debug Statements
639: --
640: IF l_debug_on THEN
663: --
664: -- Debug Statements
665: --
666: IF l_debug_on THEN
667: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
668: END IF;
669: --
670: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',
671: WSH_NEW_DELIVERIES_PVT.get_name(l_rec_wdl1(j).delivery_id));
667: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
668: END IF;
669: --
670: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',
671: WSH_NEW_DELIVERIES_PVT.get_name(l_rec_wdl1(j).delivery_id));
672: --
673: -- Debug Statements
674: --
675: IF l_debug_on THEN
908: NVL(wnd.ignore_for_planning, 'N') ignore_for_planning, --OTM R12, glog proj
909: NVL(wnd.tms_interface_flag,WSH_TRIP_STOPS_PVT.C_TMS_NOT_TO_BE_SENT) tms_interface_flag, -- OTM R12, glog proj
910: NVL(mcp.otm_enabled,wsp.otm_enabled) otm_enabled, -- LSP PROJECT : checking OTM enabled flag on client parameters.
911: wnd.client_id -- LSP PROJECT
912: from wsh_new_deliveries wnd,
913: wsh_delivery_legs wdl,
914: wsh_shipping_parameters wsp,
915: mtl_client_parameters_v mcp
916: where wnd.delivery_id = wdl.delivery_id
921:
922: cursor stop_to_det_cur( p_stop_id IN NUMBER ) is
923: select distinct 'X'
924: from wsh_delivery_details wdd,
925: wsh_new_deliveries wnd,
926: wsh_delivery_assignments_v wda,
927: wsh_delivery_legs wdl
928: where (wdl.pick_up_stop_id = p_stop_id OR wdl.drop_off_stop_id = p_stop_id)
929: and wnd.delivery_id = wdl.delivery_id
938: wnd.delivery_scpod_wf_process,
939: wnd.del_wf_intransit_attr,
940: wnd.del_wf_close_attr,
941: decode(p_stop_id,wdl.drop_off_stop_id,'D',wdl.pick_up_stop_id,'P','X') stop_type
942: from wsh_new_deliveries wnd,
943: wsh_delivery_legs wdl
944: where wnd.delivery_id = wdl.delivery_id
945: and (wdl.pick_up_stop_id = p_stop_id OR
946: wdl.drop_off_stop_id = p_stop_id );
2907: -- used as pick up.
2908: --
2909: CURSOR open_pickup_dlvy_csr (p_stop_id NUMBER) IS
2910: SELECT nvl(shipment_direction,'O') shipment_direction
2911: FROM wsh_new_deliveries wnd,
2912: wsh_delivery_legs wdl
2913: WHERE wdl.pick_up_stop_id = p_stop_id
2914: AND wnd.delivery_id = wdl.delivery_id
2915: AND wnd.status_code IN ('OP', 'PA')
2933: DECODE(wnd.ultimate_dropoff_location_id,p_stop_location_id,1,
2934: (DECODE(wnd.ultimate_dropoff_location_id,p_dummy_location_id,1, 2))
2935: ) last_stop,
2936: wdl.drop_off_stop_id drop_off_stop_id
2937: FROM wsh_new_deliveries wnd,
2938: wsh_delivery_legs wdl
2939: WHERE wdl.drop_off_stop_id IN (p_stop_id, p_dummy_stop_id)
2940: AND wnd.delivery_id = wdl.delivery_id
2941: AND (
2983: wsh_trip_stops prev_leg_pu_stop,
2984: wsh_trip_stops curr_leg_pu_stop,
2985: wsh_delivery_legs prev_leg,
2986: wsh_delivery_legs curr_leg,
2987: wsh_new_deliveries wnd,
2988: wsh_trips wt
2989: WHERE prev_leg.drop_off_stop_id = prev_leg_do_stop.stop_id
2990: --AND st1.status_code = 'OP'
2991: AND prev_leg.pick_up_stop_id = prev_leg_pu_stop.stop_id
3041: wsh_trip_stops prev_leg_pu_stop,
3042: wsh_trip_stops curr_leg_pu_stop,
3043: wsh_delivery_legs prev_leg,
3044: wsh_delivery_legs curr_leg,
3045: wsh_new_deliveries wnd,
3046: wsh_trips wt
3047: WHERE prev_leg.drop_off_stop_id = prev_leg_do_stop.stop_id
3048: --AND st1.status_code = 'OP'
3049: AND prev_leg.pick_up_stop_id = prev_leg_pu_stop.stop_id
3077: wnd.status_code delivery_statusCode,
3078: wnd.initial_pickup_location_id dlvy_initialPULocationId
3079: FROM wsh_trip_stops st1,
3080: wsh_delivery_legs dl2,
3081: wsh_new_deliveries wnd
3082: WHERE dl2.pick_up_stop_id = st1.stop_id
3083: AND st1.status_code = 'CL'
3084: AND dl2.drop_off_stop_id IN (p_stop_id, p_linked_stop_id)
3085: AND wnd.delivery_id = dl2.delivery_id
3095: dl.organization_id,
3096: DECODE(NVL(dl.shipment_direction,'O'), 'IO', dl.ultimate_dropoff_location_id, NULL) io_location_id,
3097: dl.name,
3098: dl.status_code
3099: FROM wsh_new_deliveries dl,
3100: wsh_delivery_legs dg,
3101: wsh_trip_stops st
3102: WHERE dg.delivery_id = dl.delivery_id
3103: AND st.stop_location_id = dl.initial_pickup_location_id
3118: dl.organization_id,
3119: dl.name,
3120: dl.status_code,
3121: dg.drop_off_stop_id
3122: FROM wsh_new_deliveries dl,
3123: wsh_delivery_legs dg,
3124: wsh_trip_stops st
3125: WHERE dg.delivery_id = dl.delivery_id
3126: AND st.stop_location_id = dl.ultimate_dropoff_location_id
5059: CURSOR ib_dlvy_cur (p_stop_id IN NUMBER)
5060: IS
5061: SELECT wnd.initial_pickup_date delivery_Date,
5062: DECODE(wts.stop_location_id,wnd.initial_pickup_location_id,1,3) order_seq
5063: FROM wsh_new_deliveries wnd,
5064: wsh_delivery_legs wdl,
5065: wsh_trip_stops wts
5066: WHERE wts.stop_id = p_stop_id
5067: AND wdl.pick_up_stop_id = wts.stop_id
5068: AND wdl.delivery_id = wnd.delivery_id
5069: UNION
5070: SELECT wnd.ultimate_dropoff_date delivery_Date,
5071: DECODE(wts.stop_location_id,wnd.ultimate_dropoff_location_id,2,4) order_seq
5072: FROM wsh_new_deliveries wnd,
5073: wsh_delivery_legs wdl,
5074: wsh_trip_stops wts
5075: WHERE wts.stop_id = p_stop_id
5076: AND wdl.drop_off_stop_id = wts.stop_id