APPS.WSH_INTERFACE_COMMON_ACTIONS dependencies on WSH_TRIPS

Line 3319: FROM wsh_trips_interface

3315: CURSOR int_trip_cur(l_trip_interface_id NUMBER) IS
3316: SELECT vehicle_number, vehicle_num_prefix, route_id, routing_instructions,
3317: --Bug 3458160
3318: operator
3319: FROM wsh_trips_interface
3320: WHERE trip_interface_id = l_trip_interface_id
3321: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
3322:
3323: -- cursor records

Line 3372: wsh_trips_actions.autocreate_trip(

3368: -- trip does not exist. so do autocreate_trip
3369:
3370: l_del_rows(1) := p_delivery_id;
3371:
3372: wsh_trips_actions.autocreate_trip(
3373: p_del_rows => l_del_rows,
3374: x_trip_id => l_trip_id,
3375: x_trip_name => l_trip_name,
3376: x_return_status => l_return_status);

Line 3538: UPDATE wsh_trips

3534: END IF;
3535: -- update the base trip
3536: IF l_trip_id IS NOT NULL THEN
3537:
3538: UPDATE wsh_trips
3539: SET vehicle_num_prefix = int_trip_rec.vehicle_num_prefix,
3540: vehicle_number = int_trip_rec.vehicle_number,
3541: route_id = int_trip_rec.route_id,
3542: routing_instructions = int_trip_rec.routing_instructions,

Line 3634: WSH_TRIPS_INTERFACE_S.nextval

3630:
3631: SELECT
3632: WSH_DEL_LEGS_INTERFACE_S.nextval,
3633: WSH_TRIP_STOPS_INTERFACE_S.nextval,
3634: WSH_TRIPS_INTERFACE_S.nextval
3635: INTO l_del_leg_interface_id,
3636: l_pickup_stop_interface_id,
3637: l_trip_interface_id
3638: FROM dual;

Line 3711: -- insert records into wsh_trips_interface

3707: SYSDATE,
3708: FND_GLOBAL.USER_ID,
3709: '94X_INBOUND');
3710:
3711: -- insert records into wsh_trips_interface
3712: INSERT INTO wsh_trips_interface(
3713: TRIP_INTERFACE_ID,
3714: VEHICLE_NUM_PREFIX,
3715: VEHICLE_NUMBER,

Line 3712: INSERT INTO wsh_trips_interface(

3708: FND_GLOBAL.USER_ID,
3709: '94X_INBOUND');
3710:
3711: -- insert records into wsh_trips_interface
3712: INSERT INTO wsh_trips_interface(
3713: TRIP_INTERFACE_ID,
3714: VEHICLE_NUM_PREFIX,
3715: VEHICLE_NUMBER,
3716: ROUTE_ID,