APPS.WSH_INTERFACE_COMMON_ACTIONS dependencies on WSH_DEL_LEGS_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 3632: WSH_DEL_LEGS_INTERFACE_S.nextval,

3628: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
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,

Line 3645: -- insert record into wsh_del_legs_interface

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
3646:
3647: INSERT into wsh_del_legs_interface(
3648: DELIVERY_LEG_INTERFACE_ID,
3649: DELIVERY_INTERFACE_ID,

Line 3647: INSERT into wsh_del_legs_interface(

3643: FROM dual;
3644:
3645: -- insert record into wsh_del_legs_interface
3646:
3647: INSERT into wsh_del_legs_interface(
3648: DELIVERY_LEG_INTERFACE_ID,
3649: DELIVERY_INTERFACE_ID,
3650: PICK_UP_STOP_INTERFACE_ID,
3651: DROP_OFF_STOP_INTERFACE_ID,