DBA Data[Home] [Help]

APPS.WSH_UTIL_CORE dependencies on WSH_TRIP_STOPS

Line 2510: l_stop_rec WSH_TRIP_STOPS_PVT.trip_stop_rec_type;

2506: l_message fnd_new_messages.message_name%type;
2507: --new variable
2508: l_fte_flag VARCHAR2(1) := 'N';
2509: l_return_status VARCHAR2(30);
2510: l_stop_rec WSH_TRIP_STOPS_PVT.trip_stop_rec_type;
2511: l_trip_rec WSH_TRIPS_PVT.trip_rec_type;
2512: -- bmso
2513: l_lpn_ids WMS_Data_Type_Definitions_PUB.LPNPurgeRecordType;
2514: l_lpn_id_tab wsh_util_core.id_tab_type;

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

2715: --
2716: -- Debug Statements
2717: --
2718: IF l_debug_on THEN
2719: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_GRP.GET_STOP_DETAILS_PVT',WSH_DEBUG_SV.C_PROC_LEVEL);
2720: END IF;
2721: --
2722: wsh_trip_stops_grp.get_stop_details_pvt
2723: (p_stop_id => p_rows(i),

Line 2722: wsh_trip_stops_grp.get_stop_details_pvt

2718: IF l_debug_on THEN
2719: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_GRP.GET_STOP_DETAILS_PVT',WSH_DEBUG_SV.C_PROC_LEVEL);
2720: END IF;
2721: --
2722: wsh_trip_stops_grp.get_stop_details_pvt
2723: (p_stop_id => p_rows(i),
2724: x_stop_rec => l_stop_rec,
2725: x_return_status => l_return_status);
2726: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

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

2790: --
2791: -- Debug Statements
2792: --
2793: IF l_debug_on THEN
2794: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.DELETE_TRIP_STOP',WSH_DEBUG_SV.C_PROC_LEVEL);
2795: END IF;
2796: --
2797: --tkt
2798: wsh_trip_stops_pvt.delete_trip_stop(p_rowid => null,

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

2794: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.DELETE_TRIP_STOP',WSH_DEBUG_SV.C_PROC_LEVEL);
2795: END IF;
2796: --
2797: --tkt
2798: wsh_trip_stops_pvt.delete_trip_stop(p_rowid => null,
2799: p_stop_id => p_rows(i),
2800: x_return_status => cur_return_status,
2801: p_validate_flag => 'Y',
2802: p_caller => p_caller);

Line 3416: wsh_trip_stops st,

3412: dl.organization_id,
3413: mp.wms_enabled_flag
3414: FROM wsh_new_deliveries dl,
3415: wsh_delivery_legs dg,
3416: wsh_trip_stops st,
3417: mtl_parameters mp
3418: WHERE dg.delivery_id = dl.delivery_id AND
3419: nvl(dl.SHIPMENT_DIRECTION, 'O') IN ('O', 'IO') AND -- J Inbound Logistics jckwok
3420: st.stop_location_id = dl.initial_pickup_location_id AND

Line 3715: WSH_TRIP_STOPS TS,

3711:
3712: CURSOR c_get_trip_name IS
3713: SELECT TP.Name, DLG.reprice_required
3714: FROM WSH_DELIVERY_LEGS DLG,
3715: WSH_TRIP_STOPS TS,
3716: WSH_TRIPS TP
3717: WHERE DLG.delivery_leg_id = p_delivery_leg_id AND
3718: DLG.pick_up_stop_id = TS.stop_id AND
3719: TS.trip_id = TP.trip_id;

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

6703: p_out_entity_id := nvl(wsh_trips_pvt.get_name(p_in_entity_id), p_in_entity_id);
6704: ELSIF p_in_entity_name = 'STOP'
6705: THEN
6706: p_out_entity_name := 'Stop';
6707: p_out_entity_id := nvl(wsh_trip_stops_pvt.get_name(p_in_entity_id), p_in_entity_id);
6708: ELSIF p_in_entity_name = 'DELIVERY'
6709: THEN
6710: p_out_entity_name := 'Delivery';
6711: p_out_entity_id := nvl(wsh_new_deliveries_pvt.get_name(p_in_entity_id), p_in_entity_id);

Line 6757: from wsh_trip_stops

6753: departure_gross_weight,
6754: departure_net_weight,
6755: departure_volume,
6756: departure_fill_percent
6757: from wsh_trip_stops
6758: where stop_id = c_stop_id;
6759:
6760: l_debug_on BOOLEAN;
6761: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME ||'.' || 'PROCESS_STOPS_FOR_LOAD_TENDER';

Line 8125: FROM WSH_TRIP_STOPS stops,

8121: END IF;
8122: -- Bug 6633529: Adding Rownum = 1 for Trips having more than 1 delivery for the same organization
8123: SELECT dlvy.ORGANIZATION_ID
8124: INTO l_organization_id
8125: FROM WSH_TRIP_STOPS stops,
8126: WSH_DELIVERY_LEGS leg,
8127: WSH_NEW_DELIVERIES dlvy
8128: WHERE stops.stop_id = leg.pick_up_stop_id
8129: AND leg.delivery_id = dlvy.delivery_id

Line 8147: FROM WSH_TRIP_STOPS stops, WSH_DELIVERY_LEGS leg,

8143: THEN
8144: -- Bug 6633529: Adding Rownum = 1 for Trips having more than 1 delivery for the same organization
8145: SELECT dlvy.ORGANIZATION_ID
8146: INTO l_organization_id
8147: FROM WSH_TRIP_STOPS stops, WSH_DELIVERY_LEGS leg,
8148: WSH_NEW_DELIVERIES dlvy
8149: WHERE stops.stop_id = leg.pick_up_stop_id
8150: AND leg.delivery_id = dlvy.delivery_id
8151: AND stops.stop_id = l_first_stop_id

Line 8208: FROM wsh_trip_stops stops, wsh_trips trips

8204: /* Replaced this query to get pickup and drop off
8205: CURSOR GET_TRIP_STOPS IS
8206: SELECT stop_location_id, planned_arrival_date, planned_departure_date ,
8207: stops.stop_id
8208: FROM wsh_trip_stops stops, wsh_trips trips
8209: WHERE trips.trip_id = p_trip_id
8210: and trips.trip_id = stops.trip_id
8211: ORDER BY PLANNED_ARRIVAL_DATE,
8212: STOP_SEQUENCE_NUMBER;

Line 8219: FROM wsh_trip_stops stops,

8215: CURSOR GET_TRIP_STOPS_PICKUP
8216: IS
8217: SELECT stop_location_id, planned_arrival_date, planned_departure_date,
8218: stops.stop_id,stops.tms_interface_flag
8219: FROM wsh_trip_stops stops,
8220: wsh_trips trips,
8221: wsh_delivery_legs wdg
8222: WHERE trips.trip_id = p_trip_id
8223: and trips.trip_id = stops.trip_id

Line 8232: FROM wsh_trip_stops stops,

8228: CURSOR GET_TRIP_STOPS_DROP
8229: IS
8230: SELECT stop_location_id, planned_arrival_date, planned_departure_date,
8231: stops.stop_id,stops.tms_interface_flag
8232: FROM wsh_trip_stops stops,
8233: wsh_trips trips,
8234: wsh_delivery_legs wdg
8235: WHERE trips.trip_id = p_trip_id
8236: and trips.trip_id = stops.trip_id