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 1237: Wsh_Delivery_Legs Wdl,

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

Line 1247: Wsh_Delivery_Legs Legs

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

Line 1259: FROM wsh_delivery_legs wdl,

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

Line 1728: DELETE FROM Wsh_Delivery_Legs

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

Line 1937: DELETE FROM WSH_DELIVERY_LEGS

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

Line 1962: FROM wsh_delivery_legs wdl

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

Line 2506: Wsh_Delivery_Legs WDL,

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