APPS.WSH_INTERFACE_COMMON_ACTIONS dependencies on WSH_TRIP_STOPS

Line 3290: FROM wsh_delivery_legs wdg, wsh_trip_stops wts

3286:
3287: -- cursors
3288: CURSOR del_trip_stops IS
3289: SELECT wdg.pick_up_stop_id, wdg.drop_off_stop_id, wts.trip_id
3290: FROM wsh_delivery_legs wdg, wsh_trip_stops wts
3291: WHERE wdg.delivery_id = p_delivery_id
3292: AND wdg.pick_up_stop_id = wts.stop_id;
3293:
3294: CURSOR int_del_trip_stops IS

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 3429: UPDATE wsh_trip_stops

3425:
3426: -- update the base trip_stops
3427: IF l_pickup_stop_id IS NOT NULL THEN
3428:
3429: UPDATE wsh_trip_stops
3430: SET actual_departure_date = int_pickup_stop_rec.actual_departure_date,
3431: departure_seal_code = int_pickup_stop_rec.departure_seal_code
3432: WHERE stop_id = l_pickup_stop_id;
3433:

Line 3436: -- Updating WSH_TRIP_STOPS.

3432: WHERE stop_id = l_pickup_stop_id;
3433:
3434: --
3435: -- DBI Project
3436: -- Updating WSH_TRIP_STOPS.
3437: -- Call DBI API after the Update.
3438: -- This API will also check for DBI Installed or not
3439: IF l_debug_on THEN
3440: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Stop id -',l_pickup_stop_id);

Line 3483: UPDATE wsh_trip_stops

3479: wsh_debug_sv.log (l_module_name, 'Updating Drop off Stop Id', l_dropoff_stop_id);
3480: END IF;
3481:
3482: IF l_dropoff_stop_id IS NOT NULL THEN
3483: UPDATE wsh_trip_stops
3484: SET actual_arrival_date = int_dropoff_stop_rec.actual_arrival_date
3485: WHERE stop_id = l_dropoff_stop_id;
3486:
3487: --

Line 3489: -- Updating WSH_TRIP_STOPS.

3485: WHERE stop_id = l_dropoff_stop_id;
3486:
3487: --
3488: -- DBI Project
3489: -- Updating WSH_TRIP_STOPS.
3490: -- Call DBI API after the Update.
3491: -- This API will also check for DBI Installed or not
3492: IF l_debug_on THEN
3493: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Stop id -',l_dropoff_stop_id);

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,