3322: update wsh_new_del_interface
3323: set delivery_id = x_dlvy_id
3324: where delivery_interface_id = p_delivery_interface_id;
3325:
3326: UPDATE wsh_del_legs_interface
3327: SET delivery_id = x_dlvy_id
3328: WHERE delivery_interface_id = p_delivery_interface_id;
3329: END IF;
3330: -- }
4376: AND wdg.pick_up_stop_id = wts.stop_id;
4377:
4378: CURSOR int_del_trip_stops IS
4379: SELECT wdli.pick_up_stop_interface_id, wdli.drop_off_stop_interface_id, wtsi.trip_interface_id
4380: FROM wsh_del_legs_interface wdli, wsh_trip_stops_interface wtsi
4381: WHERE wdli.delivery_id = p_delivery_id
4382: AND wdli.pick_up_stop_interface_id = wtsi.stop_interface_id
4383: AND WDLI.INTERFACE_ACTION_CODE = '94X_INBOUND'
4384: AND WTSI.INTERFACE_ACTION_CODE = '94X_INBOUND';
4712: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4713: -- get delivery_leg_interface_id, stop_interface_id, trip_interface_id
4714:
4715: SELECT
4716: WSH_DEL_LEGS_INTERFACE_S.nextval,
4717: WSH_TRIP_STOPS_INTERFACE_S.nextval,
4718: WSH_TRIPS_INTERFACE_S.nextval
4719: INTO l_del_leg_interface_id,
4720: l_pickup_stop_interface_id,
4725: WSH_TRIP_STOPS_INTERFACE_S.nextval
4726: INTO l_dropoff_stop_interface_id
4727: FROM dual;
4728:
4729: -- insert record into wsh_del_legs_interface
4730:
4731: INSERT into wsh_del_legs_interface(
4732: DELIVERY_LEG_INTERFACE_ID,
4733: DELIVERY_INTERFACE_ID,
4727: FROM dual;
4728:
4729: -- insert record into wsh_del_legs_interface
4730:
4731: INSERT into wsh_del_legs_interface(
4732: DELIVERY_LEG_INTERFACE_ID,
4733: DELIVERY_INTERFACE_ID,
4734: PICK_UP_STOP_INTERFACE_ID,
4735: DROP_OFF_STOP_INTERFACE_ID,