DBA Data[Home] [Help]

APPS.WSH_PICK_LIST dependencies on WSH_TRIPS_PVT

Line 1863: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

1859: l_cc_count_grouping_rows NUMBER;
1860: --dummy tables for calling validate_constraint_main
1861: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
1862: l_cc_det_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
1863: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
1864: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
1865: l_cc_in_ids WSH_UTIL_CORE.Id_Tab_Type;
1866: l_cc_fail_ids WSH_UTIL_CORE.Id_Tab_Type;
1867: -- deliveryMerge

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

7386: l_index := p_trip_ids.FIRST;
7387: l_trip_id := p_trip_ids(l_index);
7388: l_type := 'Trip';
7389: --
7390: l_name := WSH_TRIPS_PVT.Get_Name(l_trip_id);
7391: ELSIF (p_stop_ids.COUNT > 0) THEN
7392: l_index := p_stop_ids.FIRST;
7393: l_stop_id := p_stop_ids(l_index);
7394: --

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

7869: l_index := p_trip_ids.NEXT(l_index);
7870: l_trip_id := p_trip_ids(l_index);
7871: --
7872: IF l_debug_on THEN
7873: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
7874: END IF;
7875: --
7876: l_name := WSH_TRIPS_PVT.Get_Name(l_trip_id);
7877: ELSIF l_stop_id IS NOT NULL THEN

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

7872: IF l_debug_on THEN
7873: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
7874: END IF;
7875: --
7876: l_name := WSH_TRIPS_PVT.Get_Name(l_trip_id);
7877: ELSIF l_stop_id IS NOT NULL THEN
7878: EXIT WHEN l_index = p_stop_ids.LAST;
7879: l_index := p_stop_ids.NEXT(l_index);
7880: l_stop_id := p_stop_ids(l_index);