APPS.WSH_TRIP_STOPS_GRP dependencies on WSH_DELIVERY_LEGS

Line 1278: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);

1274: IF( WSH_UTIL_CORE.FTE_Is_Installed = 'Y') THEN
1275: IF l_stop_id_tab.count > 0 THEN
1276: --
1277: IF l_debug_on THEN
1278: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
1279: END IF;
1280: --
1281: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
1282: p_entity_type => 'STOP',

Line 1281: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(

1277: IF l_debug_on THEN
1278: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
1279: END IF;
1280: --
1281: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
1282: p_entity_type => 'STOP',
1283: p_entity_ids => l_stop_id_tab,
1284: x_return_status => l_return_status
1285: );

Line 3067: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);

3063: IF( WSH_UTIL_CORE.FTE_Is_Installed = 'Y') THEN
3064: IF l_details_marked.count > 0 THEN
3065: --
3066: IF l_debug_on THEN
3067: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
3068: END IF;
3069: --
3070: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
3071: p_entity_type => 'STOP',

Line 3070: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(

3066: IF l_debug_on THEN
3067: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
3068: END IF;
3069: --
3070: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
3071: p_entity_type => 'STOP',
3072: p_entity_ids => l_details_marked,
3073: x_return_status => l_return_status);
3074:

Line 3889: FROM wsh_new_deliveries wnd, wsh_delivery_legs wdl

3885: IS
3886: --
3887: CURSOR c_pickup_deliveries(p_stop_id NUMBER, p_stop_loc_id NUMBER) IS
3888: SELECT wnd.delivery_id
3889: FROM wsh_new_deliveries wnd, wsh_delivery_legs wdl
3890: WHERE wnd.delivery_id = wdl.delivery_id
3891: AND wdl.pick_up_stop_id = p_stop_id
3892: AND wnd.initial_pickup_location_id = p_stop_loc_id;
3893: --

Line 3896: FROM wsh_new_deliveries wnd, wsh_delivery_legs wdl

3892: AND wnd.initial_pickup_location_id = p_stop_loc_id;
3893: --
3894: CURSOR c_dropoff_deliveries(p_stop_id NUMBER, p_stop_loc_id NUMBER) IS
3895: SELECT wnd.delivery_id
3896: FROM wsh_new_deliveries wnd, wsh_delivery_legs wdl
3897: WHERE wnd.delivery_id = wdl.delivery_id
3898: AND wdl.drop_off_stop_id = p_stop_id
3899: AND wnd.ultimate_dropoff_location_id = p_stop_loc_id;
3900: --