APPS.WSH_INTERFACE_COMMON_ACTIONS dependencies on WSH_TRIPS_INTERFACE

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 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,