APPS.WSH_INTERFACE_COMMON_ACTIONS dependencies on WSH_TRIPS

Line 4403: FROM wsh_trips_interface

4399: CURSOR int_trip_cur(l_trip_interface_id NUMBER) IS
4400: SELECT vehicle_number, vehicle_num_prefix, route_id, routing_instructions,
4401: --Bug 3458160
4402: operator
4403: FROM wsh_trips_interface
4404: WHERE trip_interface_id = l_trip_interface_id
4405: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
4406:
4407: -- cursor records

Line 4456: wsh_trips_actions.autocreate_trip(

4452: -- trip does not exist. so do autocreate_trip
4453:
4454: l_del_rows(1) := p_delivery_id;
4455:
4456: wsh_trips_actions.autocreate_trip(
4457: p_del_rows => l_del_rows,
4458: x_trip_id => l_trip_id,
4459: x_trip_name => l_trip_name,
4460: x_return_status => l_return_status);

Line 4622: UPDATE wsh_trips

4618: END IF;
4619: -- update the base trip
4620: IF l_trip_id IS NOT NULL THEN
4621:
4622: UPDATE wsh_trips
4623: SET vehicle_num_prefix = int_trip_rec.vehicle_num_prefix,
4624: vehicle_number = int_trip_rec.vehicle_number,
4625: route_id = int_trip_rec.route_id,
4626: routing_instructions = int_trip_rec.routing_instructions,

Line 4718: WSH_TRIPS_INTERFACE_S.nextval

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,
4721: l_trip_interface_id
4722: FROM dual;

Line 4795: -- insert records into wsh_trips_interface

4791: SYSDATE,
4792: FND_GLOBAL.USER_ID,
4793: '94X_INBOUND');
4794:
4795: -- insert records into wsh_trips_interface
4796: INSERT INTO wsh_trips_interface(
4797: TRIP_INTERFACE_ID,
4798: VEHICLE_NUM_PREFIX,
4799: VEHICLE_NUMBER,

Line 4796: INSERT INTO wsh_trips_interface(

4792: FND_GLOBAL.USER_ID,
4793: '94X_INBOUND');
4794:
4795: -- insert records into wsh_trips_interface
4796: INSERT INTO wsh_trips_interface(
4797: TRIP_INTERFACE_ID,
4798: VEHICLE_NUM_PREFIX,
4799: VEHICLE_NUMBER,
4800: ROUTE_ID,