APPS.WSH_INTERFACE_COMMON_ACTIONS dependencies on WSH_TRIP_STOPS_INTERFACE

Line 3296: FROM wsh_del_legs_interface wdli, wsh_trip_stops_interface wtsi

3292: AND wdg.pick_up_stop_id = wts.stop_id;
3293:
3294: CURSOR int_del_trip_stops IS
3295: SELECT wdli.pick_up_stop_interface_id, wdli.drop_off_stop_interface_id, wtsi.trip_interface_id
3296: FROM wsh_del_legs_interface wdli, wsh_trip_stops_interface wtsi
3297: WHERE wdli.delivery_id = p_delivery_id
3298: AND wdli.pick_up_stop_interface_id = wtsi.stop_interface_id
3299: AND WDLI.INTERFACE_ACTION_CODE = '94X_INBOUND'
3300: AND WTSI.INTERFACE_ACTION_CODE = '94X_INBOUND';

Line 3305: FROM wsh_trip_stops_interface

3301:
3302:
3303: CURSOR int_pickup_stop_cur(l_stop_interface_id NUMBER) IS
3304: SELECT actual_departure_date, departure_seal_code
3305: FROM wsh_trip_stops_interface
3306: WHERE stop_interface_id = l_stop_interface_id
3307: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
3308:
3309: CURSOR int_dropoff_stop_cur(l_stop_interface_id NUMBER) IS

Line 3311: FROM wsh_trip_stops_interface

3307: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
3308:
3309: CURSOR int_dropoff_stop_cur(l_stop_interface_id NUMBER) IS
3310: SELECT actual_arrival_date
3311: FROM wsh_trip_stops_interface
3312: WHERE stop_interface_id = l_stop_interface_id
3313: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
3314:
3315: CURSOR int_trip_cur(l_trip_interface_id NUMBER) IS

Line 3633: WSH_TRIP_STOPS_INTERFACE_S.nextval,

3629: -- get delivery_leg_interface_id, stop_interface_id, trip_interface_id
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

Line 3641: WSH_TRIP_STOPS_INTERFACE_S.nextval

3637: l_trip_interface_id
3638: FROM dual;
3639:
3640: SELECT
3641: WSH_TRIP_STOPS_INTERFACE_S.nextval
3642: INTO l_dropoff_stop_interface_id
3643: FROM dual;
3644:
3645: -- insert record into wsh_del_legs_interface

Line 3668: -- insert records into wsh_trip_stops_interface

3664: SYSDATE,
3665: FND_GLOBAL.USER_ID,
3666: '94X_INBOUND');
3667:
3668: -- insert records into wsh_trip_stops_interface
3669: -- first the pickup stop
3670: INSERT INTO wsh_trip_stops_interface(
3671: STOP_INTERFACE_ID,
3672: TRIP_INTERFACE_ID,

Line 3670: INSERT INTO wsh_trip_stops_interface(

3666: '94X_INBOUND');
3667:
3668: -- insert records into wsh_trip_stops_interface
3669: -- first the pickup stop
3670: INSERT INTO wsh_trip_stops_interface(
3671: STOP_INTERFACE_ID,
3672: TRIP_INTERFACE_ID,
3673: ACTUAL_DEPARTURE_DATE,
3674: DEPARTURE_SEAL_CODE,

Line 3692: INSERT INTO wsh_trip_stops_interface(

3688: FND_GLOBAL.USER_ID,
3689: '94X_INBOUND');
3690:
3691: -- then the dropoff stop
3692: INSERT INTO wsh_trip_stops_interface(
3693: STOP_INTERFACE_ID,
3694: TRIP_INTERFACE_ID,
3695: ACTUAL_ARRIVAL_DATE,
3696: CREATION_DATE,