DBA Data[Home] [Help]

APPS.WSH_PICK_LIST dependencies on WSH_NEW_DELIVERIES_PVT

Line 1861: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

1857: l_cc_return_status VARCHAR2(1);
1858: l_cc_count_del_rows NUMBER;
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;

Line 7401: l_name := WSH_NEW_DELIVERIES_PVT.Get_Name(l_delivery_id);

7397: ELSIF (p_delivery_ids.COUNT > 0) THEN
7398: l_index := p_delivery_ids.FIRST;
7399: l_delivery_id := p_delivery_ids(l_index);
7400: --
7401: l_name := WSH_NEW_DELIVERIES_PVT.Get_Name(l_delivery_id);
7402: l_type := 'Delivery';
7403: ELSIF (p_detail_ids.COUNT > 0) THEN
7404: l_index := p_detail_ids.FIRST;
7405: l_detail_id := p_detail_ids(l_index);

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

7889: l_index := p_delivery_ids.NEXT(l_index);
7890: l_delivery_id := p_delivery_ids(l_index);
7891: --
7892: IF l_debug_on THEN
7893: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
7894: END IF;
7895: --
7896: l_name := WSH_NEW_DELIVERIES_PVT.Get_Name(l_delivery_id);
7897: ELSE

Line 7896: l_name := WSH_NEW_DELIVERIES_PVT.Get_Name(l_delivery_id);

7892: IF l_debug_on THEN
7893: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
7894: END IF;
7895: --
7896: l_name := WSH_NEW_DELIVERIES_PVT.Get_Name(l_delivery_id);
7897: ELSE
7898: EXIT; -- Only one loop when launching pick release for delivery details.
7899: END IF;
7900: