eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_TRIP_STOPS_ACTIONS dependencies on WSH_DELIVERY_LEGS

Line 50: from wsh_trip_stops st, wsh_delivery_legs dg, wsh_new_deliveries dl

46:
47:
48: cursor get_pickup_del is
49: select dg.delivery_id, st.stop_sequence_number,st.trip_id
50: from wsh_trip_stops st, wsh_delivery_legs dg, wsh_new_deliveries dl
51: where st.stop_id = p_stop_id
52: and dg.delivery_id = dl.delivery_id
53: and st.stop_location_id = dl.initial_pickup_location_id
54: and st.stop_id = dg.pick_up_stop_id

Line 306: FROM wsh_delivery_legs dg,

302: WHERE stop_id = l_stop_id;
303:
304: CURSOR stop_dropoffs (l_stop_id NUMBER) IS
305: SELECT dl.delivery_id
306: FROM wsh_delivery_legs dg,
307: wsh_new_deliveries dl
308: WHERE dg.delivery_id = dl.delivery_id AND
309: dg.drop_off_stop_id = l_stop_id AND
310: dl.status_code IN ('OP','PA', 'SA') -- sperera 940/945

Line 316: FROM wsh_delivery_legs dg,

312:
313: CURSOR stop_pickups (l_stop_id NUMBER) IS
314: SELECT 1 from dual
315: WHERE exists ( select 1
316: FROM wsh_delivery_legs dg,
317: wsh_new_deliveries dl
318: WHERE dg.delivery_id = dl.delivery_id
319: AND dg.pick_up_stop_id = l_stop_id
320: AND dl.status_code in ('OP','PA', 'SA') -- sperera 940/945

Line 963: FROM wsh_delivery_legs dg

959: x_return_status OUT NOCOPY VARCHAR2) IS
960:
961: CURSOR stop_dels (l_stop_id NUMBER) IS
962: SELECT dg.delivery_id
963: FROM wsh_delivery_legs dg
964: WHERE dg.pick_up_stop_id = l_stop_id;
965:
966: CURSOR get_status(l_stop_id NUMBER) IS
967: select st.status_code, tr.status_code ,

Line 1712: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.UNASSIGN_DELIVERIES',WSH_DEBUG_SV.C_PROC_LEVEL);

1708: IF p_in_rec1.initial_pu_err_dlvy_id_tbl.COUNT > 0
1709: THEN
1710: --{
1711: IF l_debug_on THEN
1712: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.UNASSIGN_DELIVERIES',WSH_DEBUG_SV.C_PROC_LEVEL);
1713: END IF;
1714: --
1715: -- Unassign deliveries (which were idenified during check_stop_close routine)
1716: -- which cannot be set to in-transit, from the trip

Line 1718: wsh_delivery_legs_actions.unassign_deliveries

1714: --
1715: -- Unassign deliveries (which were idenified during check_stop_close routine)
1716: -- which cannot be set to in-transit, from the trip
1717: --
1718: wsh_delivery_legs_actions.unassign_deliveries
1719: (
1720: p_del_rows => p_in_rec1.initial_pu_err_dlvy_id_tbl,
1721: p_trip_id => p_in_rec1.trip_id,
1722: p_pickup_stop_id => NULL,

Line 1743: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.UNASSIGN_DELIVERIES',WSH_DEBUG_SV.C_PROC_LEVEL);

1739: IF l_err_cnt > 0
1740: THEN
1741: --{
1742: IF l_debug_on THEN
1743: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.UNASSIGN_DELIVERIES',WSH_DEBUG_SV.C_PROC_LEVEL);
1744: END IF;
1745: --
1746: --
1747: -- Unassign deliveries which cannot be set to in-transit(due to errors

Line 1750: wsh_delivery_legs_actions.unassign_deliveries

1746: --
1747: -- Unassign deliveries which cannot be set to in-transit(due to errors
1748: -- (while setting delivery to in-transit), from the trip
1749: --
1750: wsh_delivery_legs_actions.unassign_deliveries
1751: (
1752: p_del_rows => l_err_dlvy_id_tbl,
1753: p_trip_id => p_in_rec1.trip_id,
1754: p_pickup_stop_id => NULL,

Line 1780: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);

1776: --
1777: -- Debug Statements
1778: --
1779: IF l_debug_on THEN
1780: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
1781: END IF;
1782: --
1783: -- Dellvieries which could not be set to in-transit, were unassigned from trip.
1784: -- This changed trip contents and hence need to mark other deliveries on trip

Line 1787: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required (

1783: -- Dellvieries which could not be set to in-transit, were unassigned from trip.
1784: -- This changed trip contents and hence need to mark other deliveries on trip
1785: -- as reprice required
1786: --
1787: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required (
1788: p_entity_type => 'TRIP',
1789: p_entity_ids => l_trip_tab,
1790: x_return_status => l_return_status);
1791: --

Line 2370: FROM wsh_delivery_legs wdl,

2366: --
2367: CURSOR ib_dropoff_stop_csr(p_pu_stop_id IN NUMBER, p_do_stop_id IN NUMBER)
2368: IS
2369: SELECT 1
2370: FROM wsh_delivery_legs wdl,
2371: wsh_new_deliveries wnd
2372: WHERE wdl.pick_up_stop_id = p_pu_stop_id
2373: AND wdl.drop_off_stop_id = p_do_stop_id
2374: AND wdl.delivery_id = wnd.delivery_id

Line 2383: FROM wsh_delivery_legs wdl,

2379: --
2380: CURSOR ib_dlvy_csr(p_stop_id IN NUMBER)
2381: IS
2382: SELECT wnd.delivery_id, wts.stop_location_id, wnd.ultimate_dropoff_location_id
2383: FROM wsh_delivery_legs wdl,
2384: wsh_new_deliveries wnd,
2385: wsh_trip_stops wts
2386: WHERE wdl.drop_off_stop_id = p_stop_id
2387: AND wts.stop_id = p_stop_id

Line 2409: wsh_delivery_legs next_leg,

2405: wnd.ultimatE_dropoff_location_id dlvy_ultimate_doLocationId
2406: FROM wsh_trip_stops next_leg_do_stop,
2407: wsh_trip_stops next_leg_pu_stop,
2408: wsh_trip_stops curr_leg_do_stop,
2409: wsh_delivery_legs next_leg,
2410: wsh_delivery_legs curr_leg,
2411: wsh_new_deliveries wnd
2412: WHERE next_leg.drop_off_stop_id = next_leg_do_stop.stop_id
2413: --AND st1.status_code = 'OP'

Line 2410: wsh_delivery_legs curr_leg,

2406: FROM wsh_trip_stops next_leg_do_stop,
2407: wsh_trip_stops next_leg_pu_stop,
2408: wsh_trip_stops curr_leg_do_stop,
2409: wsh_delivery_legs next_leg,
2410: wsh_delivery_legs curr_leg,
2411: wsh_new_deliveries wnd
2412: WHERE next_leg.drop_off_stop_id = next_leg_do_stop.stop_id
2413: --AND st1.status_code = 'OP'
2414: AND next_leg.pick_up_stop_id = next_leg_pu_stop.stop_id

Line 3198: FROM wsh_delivery_legs wdl

3194: FROM wsh_trip_stops wts
3195: WHERE wts.trip_id = p_trip_id
3196: AND wts.status_code IN ( 'OP', 'AR')
3197: AND EXISTS ( SELECT 'c'
3198: FROM wsh_delivery_legs wdl
3199: WHERE wdl.pick_up_stop_id = wts.stop_id)
3200: ORDER BY wts.stop_sequence_number DESC)
3201: WHERE ROWNUM = 1;
3202:

Line 3208: ,wsh_delivery_legs wdl

3204: --OTM R12 Org-Specific (Reviewed by perf team)
3205: CURSOR check_eligible_for_asr_csr IS
3206: SELECT 1
3207: FROM wsh_trip_stops wts
3208: ,wsh_delivery_legs wdl
3209: ,wsh_new_deliveries wnd
3210: WHERE wts.trip_id = p_trip_id
3211: AND wts.stop_id = wdl.pick_up_stop_id
3212: AND wdl.delivery_id = wnd.delivery_id

Line 3224: ,wsh_delivery_legs wdl

3220: WHERE wnd.client_id = mcp.client_id
3221: AND mcp.otm_enabled = 'Y' AND wnd.client_ID IS NOT NULL )
3222: AND NOT EXISTS ( SELECT 1
3223: FROM wsh_trip_stops wts
3224: ,wsh_delivery_legs wdl
3225: ,wsh_new_deliveries wnd
3226: WHERE wts.trip_id = p_trip_id
3227: AND wts.stop_id = wdl.pick_up_stop_id
3228: AND wdl.delivery_id = wnd.delivery_id