APPS.WSH_PICK_LIST dependencies on WSH_TRIPS_PVT

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 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);