APPS.WSH_PICK_LIST dependencies on WSH_TRIPS

Line 814: FROM wsh_trips wt, wsh_trip_stops wts, wsh_delivery_assignments_v wda,

810:
811: --Cursor to get the Trip stop id associated with the PickUp Stop of delivery detail line.
812: CURSOR get_dd_pup_trip_stop(v_org_id IN NUMBER, v_dd_id NUMBER) IS
813: SELECT wts.STOP_ID
814: FROM wsh_trips wt, wsh_trip_stops wts, wsh_delivery_assignments_v wda,
815: wsh_delivery_legs wdl, wsh_delivery_details wdd
816: WHERE wdd.delivery_detail_id = v_dd_id
817: AND wdd.organization_id = v_org_id
818: AND wda.delivery_detail_id = wdd.delivery_detail_id

Line 1802: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

1798: l_cc_count_grouping_rows NUMBER;
1799: --dummy tables for calling validate_constraint_main
1800: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
1801: l_cc_det_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
1802: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
1803: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
1804: l_cc_in_ids WSH_UTIL_CORE.Id_Tab_Type;
1805: l_cc_fail_ids WSH_UTIL_CORE.Id_Tab_Type;
1806: -- deliveryMerge

Line 3720: wsh_trips wtp

3716: wst.stop_id, wst.stop_location_id
3717: FROM wsh_new_deliveries wnd,
3718: wsh_delivery_legs wlg,
3719: wsh_trip_stops wst,
3720: wsh_trips wtp
3721: WHERE wnd.delivery_id = wlg.delivery_id AND
3722: wlg.pick_up_stop_id = wst.stop_id AND
3723: wnd.status_code = 'CO' AND
3724: wnd.batch_id = c_sc_batch_id AND

Line 3742: wsh_trips wtp

3738: wst.stop_location_id
3739: FROM wsh_new_deliveries wnd,
3740: wsh_delivery_legs wlg,
3741: wsh_trip_stops wst,
3742: wsh_trips wtp
3743: WHERE wnd.delivery_id = wlg.delivery_id and
3744: wlg.pick_up_stop_id = wst.stop_id and
3745: wnd.status_code = 'CO' and
3746: wnd.batch_id = c_sc_batch_id and

Line 3761: wsh_trips wtp2

3757: wst2.stop_id, wst2.stop_location_id
3758: FROM wsh_new_deliveries wnd2,
3759: wsh_delivery_legs wlg2,
3760: wsh_trip_stops wst2,
3761: wsh_trips wtp2
3762: WHERE wnd2.delivery_id = wlg2.delivery_id and
3763: wlg2.drop_off_stop_id = wst2.stop_id and
3764: wnd2.status_code = 'CO' and
3765: wnd2.batch_id = c_sc_batch_id and

Line 6979: select status_code from wsh_trips

6975: WHERE delivery_detail_id = l_del_detail_id;
6976:
6977: --Cursor to get trip status.
6978: CURSOR check_trip(c_trip_id IN NUMBER) IS
6979: select status_code from wsh_trips
6980: where trip_id = c_trip_id;
6981:
6982: --Cursor to get stop status.
6983: CURSOR check_stop(c_stop_id IN NUMBER) IS

Line 7247: l_name := WSH_TRIPS_PVT.Get_Name(l_trip_id);

7243: l_index := p_trip_ids.FIRST;
7244: l_trip_id := p_trip_ids(l_index);
7245: l_type := 'Trip';
7246: --
7247: l_name := WSH_TRIPS_PVT.Get_Name(l_trip_id);
7248: ELSIF (p_stop_ids.COUNT > 0) THEN
7249: l_index := p_stop_ids.FIRST;
7250: l_stop_id := p_stop_ids(l_index);
7251: --

Line 7727: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

7723: l_index := p_trip_ids.NEXT(l_index);
7724: l_trip_id := p_trip_ids(l_index);
7725: --
7726: IF l_debug_on THEN
7727: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
7728: END IF;
7729: --
7730: l_name := WSH_TRIPS_PVT.Get_Name(l_trip_id);
7731: ELSIF l_stop_id IS NOT NULL THEN

Line 7730: l_name := WSH_TRIPS_PVT.Get_Name(l_trip_id);

7726: IF l_debug_on THEN
7727: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
7728: END IF;
7729: --
7730: l_name := WSH_TRIPS_PVT.Get_Name(l_trip_id);
7731: ELSIF l_stop_id IS NOT NULL THEN
7732: EXIT WHEN l_index = p_stop_ids.LAST;
7733: l_index := p_stop_ids.NEXT(l_index);
7734: l_stop_id := p_stop_ids(l_index);