APPS.GMI_SHIPPING_UTIL dependencies on WSH_TRIP_STOPS

Line 2284: , p_trip_stop_rec IN wsh_trip_stops%ROWTYPE

2280: */
2281:
2282: PROCEDURE create_rcv_transaction
2283: ( p_shipping_line IN wsh_delivery_details%ROWTYPE
2284: , p_trip_stop_rec IN wsh_trip_stops%ROWTYPE
2285: , p_group_id IN NUMBER
2286: , x_return_status OUT NOCOPY VARCHAR2
2287: , x_msg_count OUT NOCOPY NUMBER
2288: , x_msg_data OUT NOCOPY VARCHAR2)

Line 2316: l_trip_stop_rec wsh_trip_stops%ROWTYPE;

2312: l_transaction_id NUMBER := NULL;
2313: l_charge_account_id NUMBER;
2314: l_accrual_account_id NUMBER;
2315: l_detail_rec wsh_delivery_details%ROWTYPE;
2316: l_trip_stop_rec wsh_trip_stops%ROWTYPE;
2317: l_item_desc VARCHAR2(240) := NULL;
2318: l_unit_of_measure VARCHAR2(25);
2319: l_secondary_unit_of_measure VARCHAR2(25);
2320: l_locator_id NUMBER;

Line 2825: wsh_trip_stops st

2821: CURSOR pickup_deliveries IS
2822: SELECT dg.delivery_id , st.transaction_header_id
2823: FROM wsh_delivery_legs dg,
2824: wsh_new_deliveries dl,
2825: wsh_trip_stops st
2826: WHERE st.stop_id = dg.pick_up_stop_id AND
2827: st.stop_id = p_stop_id AND
2828: st.stop_location_id = dl.initial_pickup_location_id AND
2829: dg.delivery_id = dl.delivery_id ;

Line 2868: SELECT * FROM WSH_TRIP_STOPS

2864: and container_flag = 'N';
2865: l_detail_rec c_details_for_interface%ROWTYPE;
2866:
2867: CURSOR c_trip_stop (c_trip_stop_id NUMBER ) IS
2868: SELECT * FROM WSH_TRIP_STOPS
2869: WHERE STOP_ID = c_trip_stop_id;
2870: l_trip_stop_rec c_trip_stop%ROWTYPE;
2871:
2872: BEGIN