APPS.WSH_PARTY_MERGE dependencies on WSH_DELIVERY_LEGS

Line 959: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required (

955: THEN
956: -- { Mark Reprice
957: l_return_status := NULL;
958:
959: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required (
960: p_entity_type => 'DELIVERY',
961: p_entity_ids => p_delivery_id,
962: x_return_status => l_return_status);
963:

Line 969: WSH_DEBUG_SV.logmsg(l_module_name, 'Error While Calling WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required');

965: WSH_UTIL_CORE.G_RET_STS_WARNING) )
966: THEN
967: --
968: IF ( l_debug_on ) THEN
969: WSH_DEBUG_SV.logmsg(l_module_name, 'Error While Calling WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required');
970: WSH_DEBUG_SV.log(l_module_name, 'l_return_status', l_return_status);
971: END IF;
972: --
973: RAISE Weight_Volume_Exp;

Line 1610: WSH_DELIVERY_LEGS WDL,

1606: Wdd.Organization_Id, WDA.Rowid Wda_Rowid
1607: FROM WSH_DELIVERY_DETAILS WDD,
1608: WSH_DELIVERY_ASSIGNMENTS_V WDA,
1609: WSH_NEW_DELIVERIES WND,
1610: WSH_DELIVERY_LEGS WDL,
1611: WSH_TRIP_STOPS WTS,
1612: HZ_CUST_ACCT_SITES_ALL CA,
1613: HZ_CUST_SITE_USES_ALL SU
1614: WHERE SU.Cust_Acct_Site_Id = CA.Cust_Acct_Site_Id

Line 1689: Wsh_Delivery_Legs Wdl,

1685: Wnd.Net_Weight, Wnd.Gross_Weight, Wnd.Volume,
1686: Wdl.Rowid, Tmp.Rowid
1687: FROM Wsh_Trip_Stops Wts,
1688: Wsh_New_Deliveries Wnd,
1689: Wsh_Delivery_Legs Wdl,
1690: Wsh_Tmp Tmp
1691: WHERE Wnd.Ultimate_DropOff_Location_Id = p_to_location_id
1692: AND nvl(Wnd.Shipment_Direction, 'O') in ( 'O', 'IO' )
1693: AND Wnd.Delivery_Id = Wdl.Delivery_Id

Line 1700: Wsh_Delivery_Legs Legs

1696: AND Wdl.Delivery_Id = Tmp.Column1
1697: AND exists (
1698: SELECT 'x'
1699: FROM Wsh_New_Deliveries Del,
1700: Wsh_Delivery_Legs Legs
1701: WHERE Del.Ultimate_Dropoff_Location_Id <> p_to_location_id
1702: AND Del.Delivery_Id = Legs.Delivery_Id
1703: AND Legs.Drop_Off_Stop_Id = Wdl.Drop_Off_Stop_Id )
1704: FOR UPDATE OF Wdl.Delivery_Leg_Id NOWAIT;