APPS.WSH_CUST_MERGE dependencies on WSH_DELIVERY_LEGS

Line 261: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required (

257: l_del_tab(i) := p_delivery_id(i);
258: END LOOP;
259: END IF;
260:
261: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required (
262: p_entity_type => 'DELIVERY',
263: p_entity_ids => l_del_tab,
264: x_return_status => l_return_status);
265:

Line 270: ARP_MESSAGE.Set_Error('API WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required returned error');

266: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
267: WSH_UTIL_CORE.G_RET_STS_WARNING) ) THEN
268: --
269: IF ( l_debug_on ) THEN
270: ARP_MESSAGE.Set_Error('API WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required returned error');
271: END IF;
272: --
273: RAISE Weight_Volume_Exp;
274: END IF;

Line 1240: Wsh_Delivery_Legs Wdl,

1236: Wdl.Delivery_Leg_Id, Wnd.Gross_Weight, Wnd.Net_Weight,
1237: Wnd.Volume, Wdl.Rowid, Tmp.Rowid,
1238: NVL(Wnd.ignore_for_planning, 'N') --OTM R12
1239: FROM Wsh_New_Deliveries Wnd,
1240: Wsh_Delivery_Legs Wdl,
1241: Wsh_Trip_Stops Wts,
1242: Wsh_Tmp Tmp
1243: WHERE Wnd.Ultimate_Dropoff_Location_Id = p_location_id
1244: AND Wts.Stop_Id = Wdl.Drop_Off_Stop_Id

Line 1250: Wsh_Delivery_Legs Legs

1246: AND Wdl.Delivery_Id = Tmp.Column1
1247: AND exists (
1248: SELECT 'x'
1249: FROM Wsh_New_Deliveries Del,
1250: Wsh_Delivery_Legs Legs
1251: WHERE Del.Ultimate_Dropoff_Location_Id <> p_location_id
1252: AND Del.Delivery_Id = Legs.Delivery_Id
1253: AND Legs.Drop_Off_Stop_Id = Wdl.Drop_Off_Stop_Id
1254: )

Line 1262: FROM wsh_delivery_legs wdl,

1258: -- getting deliveries on the trip where another delivery is unassigned
1259: -- these deliveries will be set to AW
1260: CURSOR c_get_deliveries (p_trip_id IN NUMBER,p_exclude_dlvy IN NUMBER) IS
1261: SELECT wdl.delivery_id
1262: FROM wsh_delivery_legs wdl,
1263: wsh_trip_stops wts,
1264: wsh_new_deliveries wnd
1265: WHERE wdl.pick_up_stop_id = wts.stop_id
1266: AND wts.trip_id = p_trip_id

Line 1731: DELETE FROM Wsh_Delivery_Legs

1727: END IF;
1728:
1729: IF (l_delivery_leg_count > 0 AND l_new_delivery_leg_tab.count > 0) THEN
1730: FORALL delCnt IN l_new_delivery_leg_tab.FIRST..l_new_delivery_leg_tab.LAST
1731: DELETE FROM Wsh_Delivery_Legs
1732: WHERE Rowid = l_new_delivery_leg_tab(delCnt);
1733: END IF;
1734: --END OTM R12
1735:

Line 1940: DELETE FROM WSH_DELIVERY_LEGS

1936:
1937: -- For Include for Planning Deliveries , converted to UR , Delete Legs
1938: IF l_dlvy_id_tab.count > 0 THEN
1939: FORALL delCnt IN l_dlvy_id_tab.FIRST..l_dlvy_id_tab.LAST
1940: DELETE FROM WSH_DELIVERY_LEGS
1941: WHERE DELIVERY_ID = l_dlvy_id_tab(delCnt);
1942: END IF;
1943:
1944: -- Freight Cost will get updated for scenarios where Cost was sent by

Line 1965: FROM wsh_delivery_legs wdl

1961: FORALL delCnt IN l_dlvy_id_tab.FIRST..l_dlvy_id_tab.LAST
1962: DELETE FROM Wsh_Freight_Costs
1963: WHERE Delivery_Leg_Id IN
1964: (SELECT wdl.delivery_leg_id
1965: FROM wsh_delivery_legs wdl
1966: WHERE wdl.delivery_id = l_dlvy_id_tab(delCnt))
1967: AND freight_cost_type_id = l_frcost_type_id;
1968:
1969: -- Delivery

Line 2509: Wsh_Delivery_Legs WDL,

2505: WDD.Rowid, WDA.Rowid
2506: FROM Wsh_Delivery_Details WDD,
2507: Wsh_Delivery_Assignments WDA,
2508: Wsh_New_Deliveries WND,
2509: Wsh_Delivery_Legs WDL,
2510: Wsh_Trip_Stops WTS
2511: WHERE WTS.Stop_id (+) = WDL.Drop_Off_Stop_Id
2512: AND WDL.Delivery_Id (+) = WND.Delivery_Id
2513: AND NVL(WND.Status_Code, 'OP') = 'OP'