APPS.WSH_DELIVERY_LEGS_PVT dependencies on WSH_TRIPS

Line 514: wsh_trips wt

510: wdl.delivery_id --J-IB-HEALI
511: FROM wsh_delivery_legs wdl,
512: wsh_trip_stops wts1,
513: wsh_new_deliveries wnd,
514: wsh_trips wt
515: WHERE delivery_leg_id = p_delivery_leg_id
516: AND wdl.pick_up_stop_id = wts1.stop_id
517: AND wdl.delivery_id = wnd.delivery_id
518: AND wts1.trip_id = wt.trip_id;

Line 533: wsh_trips wt

529: NVL(wt.shipments_type_flag,'O') trip_shipments_type_flag,
530: wt.status_Code trip_status_Code
531: FROM wsh_trip_stops wts1,
532: wsh_trip_stops wts2,
533: wsh_trips wt
534: WHERE wt.trip_id = p_trip_id
535: AND wts1.stop_id = p_pickup_stop_id
536: AND wts2.stop_id = p_dropoff_stop_id
537: FOR UPDATE OF wt.shipments_type_flag NOWAIT;

Line 562: l_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;

558: l_num_errors NUMBER := 0;
559: l_return_status VARCHAR2(10);
560: l_stop_rec WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE;
561: l_pub_stop_rec WSH_TRIP_STOPS_PUB.TRIP_STOP_PUB_REC_TYPE;
562: l_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;
563: --
564: l_has_mixed_deliveries VARCHAR2(10);
565: l_stop_opened VARCHAR2(10);
566: l_stop_in_rec WSH_TRIP_STOPS_VALIDATIONS.chkClose_in_rec_type;

Line 1029: UPDATE WSH_TRIPS

1025: lock_trip_rec.trip_shipments_type_flag := 'O';
1026: END IF;
1027: --
1028: --
1029: UPDATE WSH_TRIPS
1030: SET shipments_type_flag = lock_trip_rec.trip_shipments_type_flag,
1031: last_update_date = SYSDATE,
1032: last_updated_by = FND_GLOBAL.USER_ID,
1033: last_update_login = FND_GLOBAL.LOGIN_ID