APPS.WSH_INTERFACE_COMMON_ACTIONS dependencies on WSH_TRIP_STOPS

Line 4374: FROM wsh_delivery_legs wdg, wsh_trip_stops wts

4370:
4371: -- cursors
4372: CURSOR del_trip_stops IS
4373: SELECT wdg.pick_up_stop_id, wdg.drop_off_stop_id, wts.trip_id
4374: FROM wsh_delivery_legs wdg, wsh_trip_stops wts
4375: WHERE wdg.delivery_id = p_delivery_id
4376: AND wdg.pick_up_stop_id = wts.stop_id;
4377:
4378: CURSOR int_del_trip_stops IS

Line 4380: FROM wsh_del_legs_interface wdli, wsh_trip_stops_interface wtsi

4376: AND wdg.pick_up_stop_id = wts.stop_id;
4377:
4378: CURSOR int_del_trip_stops IS
4379: SELECT wdli.pick_up_stop_interface_id, wdli.drop_off_stop_interface_id, wtsi.trip_interface_id
4380: FROM wsh_del_legs_interface wdli, wsh_trip_stops_interface wtsi
4381: WHERE wdli.delivery_id = p_delivery_id
4382: AND wdli.pick_up_stop_interface_id = wtsi.stop_interface_id
4383: AND WDLI.INTERFACE_ACTION_CODE = '94X_INBOUND'
4384: AND WTSI.INTERFACE_ACTION_CODE = '94X_INBOUND';

Line 4389: FROM wsh_trip_stops_interface

4385:
4386:
4387: CURSOR int_pickup_stop_cur(l_stop_interface_id NUMBER) IS
4388: SELECT actual_departure_date, departure_seal_code
4389: FROM wsh_trip_stops_interface
4390: WHERE stop_interface_id = l_stop_interface_id
4391: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
4392:
4393: CURSOR int_dropoff_stop_cur(l_stop_interface_id NUMBER) IS

Line 4395: FROM wsh_trip_stops_interface

4391: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
4392:
4393: CURSOR int_dropoff_stop_cur(l_stop_interface_id NUMBER) IS
4394: SELECT actual_arrival_date
4395: FROM wsh_trip_stops_interface
4396: WHERE stop_interface_id = l_stop_interface_id
4397: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
4398:
4399: CURSOR int_trip_cur(l_trip_interface_id NUMBER) IS

Line 4513: UPDATE wsh_trip_stops

4509:
4510: -- update the base trip_stops
4511: IF l_pickup_stop_id IS NOT NULL THEN
4512:
4513: UPDATE wsh_trip_stops
4514: SET actual_departure_date = int_pickup_stop_rec.actual_departure_date,
4515: departure_seal_code = int_pickup_stop_rec.departure_seal_code
4516: WHERE stop_id = l_pickup_stop_id;
4517:

Line 4520: -- Updating WSH_TRIP_STOPS.

4516: WHERE stop_id = l_pickup_stop_id;
4517:
4518: --
4519: -- DBI Project
4520: -- Updating WSH_TRIP_STOPS.
4521: -- Call DBI API after the Update.
4522: -- This API will also check for DBI Installed or not
4523: IF l_debug_on THEN
4524: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Stop id -',l_pickup_stop_id);

Line 4567: UPDATE wsh_trip_stops

4563: wsh_debug_sv.log (l_module_name, 'Updating Drop off Stop Id', l_dropoff_stop_id);
4564: END IF;
4565:
4566: IF l_dropoff_stop_id IS NOT NULL THEN
4567: UPDATE wsh_trip_stops
4568: SET actual_arrival_date = int_dropoff_stop_rec.actual_arrival_date
4569: WHERE stop_id = l_dropoff_stop_id;
4570:
4571: --

Line 4573: -- Updating WSH_TRIP_STOPS.

4569: WHERE stop_id = l_dropoff_stop_id;
4570:
4571: --
4572: -- DBI Project
4573: -- Updating WSH_TRIP_STOPS.
4574: -- Call DBI API after the Update.
4575: -- This API will also check for DBI Installed or not
4576: IF l_debug_on THEN
4577: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Stop id -',l_dropoff_stop_id);

Line 4717: WSH_TRIP_STOPS_INTERFACE_S.nextval,

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

Line 4725: WSH_TRIP_STOPS_INTERFACE_S.nextval

4721: l_trip_interface_id
4722: FROM dual;
4723:
4724: SELECT
4725: WSH_TRIP_STOPS_INTERFACE_S.nextval
4726: INTO l_dropoff_stop_interface_id
4727: FROM dual;
4728:
4729: -- insert record into wsh_del_legs_interface

Line 4752: -- insert records into wsh_trip_stops_interface

4748: SYSDATE,
4749: FND_GLOBAL.USER_ID,
4750: '94X_INBOUND');
4751:
4752: -- insert records into wsh_trip_stops_interface
4753: -- first the pickup stop
4754: INSERT INTO wsh_trip_stops_interface(
4755: STOP_INTERFACE_ID,
4756: TRIP_INTERFACE_ID,

Line 4754: INSERT INTO wsh_trip_stops_interface(

4750: '94X_INBOUND');
4751:
4752: -- insert records into wsh_trip_stops_interface
4753: -- first the pickup stop
4754: INSERT INTO wsh_trip_stops_interface(
4755: STOP_INTERFACE_ID,
4756: TRIP_INTERFACE_ID,
4757: ACTUAL_DEPARTURE_DATE,
4758: DEPARTURE_SEAL_CODE,

Line 4776: INSERT INTO wsh_trip_stops_interface(

4772: FND_GLOBAL.USER_ID,
4773: '94X_INBOUND');
4774:
4775: -- then the dropoff stop
4776: INSERT INTO wsh_trip_stops_interface(
4777: STOP_INTERFACE_ID,
4778: TRIP_INTERFACE_ID,
4779: ACTUAL_ARRIVAL_DATE,
4780: CREATION_DATE,