DBA Data[Home] [Help]

APPS.WSH_UTIL_CORE dependencies on WSH_TRIP_STOPS

Line 2546: l_stop_rec WSH_TRIP_STOPS_PVT.trip_stop_rec_type;

2542: l_message fnd_new_messages.message_name%type;
2543: --new variable
2544: l_fte_flag VARCHAR2(1) := 'N';
2545: l_return_status VARCHAR2(30);
2546: l_stop_rec WSH_TRIP_STOPS_PVT.trip_stop_rec_type;
2547: l_trip_rec WSH_TRIPS_PVT.trip_rec_type;
2548: -- bmso
2549: l_lpn_ids WMS_Data_Type_Definitions_PUB.LPNPurgeRecordType;
2550: l_lpn_id_tab wsh_util_core.id_tab_type;

Line 2755: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_GRP.GET_STOP_DETAILS_PVT',WSH_DEBUG_SV.C_PROC_LEVEL);

2751: --
2752: -- Debug Statements
2753: --
2754: IF l_debug_on THEN
2755: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_GRP.GET_STOP_DETAILS_PVT',WSH_DEBUG_SV.C_PROC_LEVEL);
2756: END IF;
2757: --
2758: wsh_trip_stops_grp.get_stop_details_pvt
2759: (p_stop_id => p_rows(i),

Line 2758: wsh_trip_stops_grp.get_stop_details_pvt

2754: IF l_debug_on THEN
2755: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_GRP.GET_STOP_DETAILS_PVT',WSH_DEBUG_SV.C_PROC_LEVEL);
2756: END IF;
2757: --
2758: wsh_trip_stops_grp.get_stop_details_pvt
2759: (p_stop_id => p_rows(i),
2760: x_stop_rec => l_stop_rec,
2761: x_return_status => l_return_status);
2762: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 2830: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.DELETE_TRIP_STOP',WSH_DEBUG_SV.C_PROC_LEVEL);

2826: --
2827: -- Debug Statements
2828: --
2829: IF l_debug_on THEN
2830: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.DELETE_TRIP_STOP',WSH_DEBUG_SV.C_PROC_LEVEL);
2831: END IF;
2832: --
2833: --tkt
2834: wsh_trip_stops_pvt.delete_trip_stop(p_rowid => null,

Line 2834: wsh_trip_stops_pvt.delete_trip_stop(p_rowid => null,

2830: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.DELETE_TRIP_STOP',WSH_DEBUG_SV.C_PROC_LEVEL);
2831: END IF;
2832: --
2833: --tkt
2834: wsh_trip_stops_pvt.delete_trip_stop(p_rowid => null,
2835: p_stop_id => p_rows(i),
2836: x_return_status => cur_return_status,
2837: p_validate_flag => 'Y',
2838: p_caller => p_caller);

Line 3452: wsh_trip_stops st,

3448: dl.organization_id,
3449: mp.wms_enabled_flag
3450: FROM wsh_new_deliveries dl,
3451: wsh_delivery_legs dg,
3452: wsh_trip_stops st,
3453: mtl_parameters mp
3454: WHERE dg.delivery_id = dl.delivery_id AND
3455: nvl(dl.SHIPMENT_DIRECTION, 'O') IN ('O', 'IO') AND -- J Inbound Logistics jckwok
3456: st.stop_location_id = dl.initial_pickup_location_id AND

Line 3751: WSH_TRIP_STOPS TS,

3747:
3748: CURSOR c_get_trip_name IS
3749: SELECT TP.Name, DLG.reprice_required
3750: FROM WSH_DELIVERY_LEGS DLG,
3751: WSH_TRIP_STOPS TS,
3752: WSH_TRIPS TP
3753: WHERE DLG.delivery_leg_id = p_delivery_leg_id AND
3754: DLG.pick_up_stop_id = TS.stop_id AND
3755: TS.trip_id = TP.trip_id;

Line 6743: p_out_entity_id := nvl(wsh_trip_stops_pvt.get_name(p_in_entity_id), p_in_entity_id);

6739: p_out_entity_id := nvl(wsh_trips_pvt.get_name(p_in_entity_id), p_in_entity_id);
6740: ELSIF p_in_entity_name = 'STOP'
6741: THEN
6742: p_out_entity_name := 'Stop';
6743: p_out_entity_id := nvl(wsh_trip_stops_pvt.get_name(p_in_entity_id), p_in_entity_id);
6744: ELSIF p_in_entity_name = 'DELIVERY'
6745: THEN
6746: p_out_entity_name := 'Delivery';
6747: p_out_entity_id := nvl(wsh_new_deliveries_pvt.get_name(p_in_entity_id), p_in_entity_id);

Line 6793: from wsh_trip_stops

6789: departure_gross_weight,
6790: departure_net_weight,
6791: departure_volume,
6792: departure_fill_percent
6793: from wsh_trip_stops
6794: where stop_id = c_stop_id;
6795:
6796: l_debug_on BOOLEAN;
6797: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME ||'.' || 'PROCESS_STOPS_FOR_LOAD_TENDER';

Line 8161: FROM WSH_TRIP_STOPS stops,

8157: END IF;
8158: -- Bug 6633529: Adding Rownum = 1 for Trips having more than 1 delivery for the same organization
8159: SELECT dlvy.ORGANIZATION_ID
8160: INTO l_organization_id
8161: FROM WSH_TRIP_STOPS stops,
8162: WSH_DELIVERY_LEGS leg,
8163: WSH_NEW_DELIVERIES dlvy
8164: WHERE stops.stop_id = leg.pick_up_stop_id
8165: AND leg.delivery_id = dlvy.delivery_id

Line 8183: FROM WSH_TRIP_STOPS stops, WSH_DELIVERY_LEGS leg,

8179: THEN
8180: -- Bug 6633529: Adding Rownum = 1 for Trips having more than 1 delivery for the same organization
8181: SELECT dlvy.ORGANIZATION_ID
8182: INTO l_organization_id
8183: FROM WSH_TRIP_STOPS stops, WSH_DELIVERY_LEGS leg,
8184: WSH_NEW_DELIVERIES dlvy
8185: WHERE stops.stop_id = leg.pick_up_stop_id
8186: AND leg.delivery_id = dlvy.delivery_id
8187: AND stops.stop_id = l_first_stop_id

Line 8244: FROM wsh_trip_stops stops, wsh_trips trips

8240: /* Replaced this query to get pickup and drop off
8241: CURSOR GET_TRIP_STOPS IS
8242: SELECT stop_location_id, planned_arrival_date, planned_departure_date ,
8243: stops.stop_id
8244: FROM wsh_trip_stops stops, wsh_trips trips
8245: WHERE trips.trip_id = p_trip_id
8246: and trips.trip_id = stops.trip_id
8247: ORDER BY PLANNED_ARRIVAL_DATE,
8248: STOP_SEQUENCE_NUMBER;

Line 8255: FROM wsh_trip_stops stops,

8251: CURSOR GET_TRIP_STOPS_PICKUP
8252: IS
8253: SELECT stop_location_id, planned_arrival_date, planned_departure_date,
8254: stops.stop_id,stops.tms_interface_flag
8255: FROM wsh_trip_stops stops,
8256: wsh_trips trips,
8257: wsh_delivery_legs wdg
8258: WHERE trips.trip_id = p_trip_id
8259: and trips.trip_id = stops.trip_id

Line 8268: FROM wsh_trip_stops stops,

8264: CURSOR GET_TRIP_STOPS_DROP
8265: IS
8266: SELECT stop_location_id, planned_arrival_date, planned_departure_date,
8267: stops.stop_id,stops.tms_interface_flag
8268: FROM wsh_trip_stops stops,
8269: wsh_trips trips,
8270: wsh_delivery_legs wdg
8271: WHERE trips.trip_id = p_trip_id
8272: and trips.trip_id = stops.trip_id