APPS.WSH_INTERFACE_COMMON_ACTIONS dependencies on WSH_TRIP_STOPS_INTERFACE

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