APPS.WSH_CONTAINER_ACTIONS dependencies on WSH_DELIVERY_LEGS

Line 7789: WSH_DEBUG_SV.logmsg(l_module_name,'Calling Program Unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);

7785:
7786: --H integration : Pricing Integration
7787: IF l_del_tab.count > 0 THEN
7788: IF l_debug_on THEN
7789: WSH_DEBUG_SV.logmsg(l_module_name,'Calling Program Unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
7790: END IF;
7791: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required
7792: (p_entity_type => 'DELIVERY',
7793: p_entity_ids => l_del_tab,

Line 7791: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required

7787: IF l_del_tab.count > 0 THEN
7788: IF l_debug_on THEN
7789: WSH_DEBUG_SV.logmsg(l_module_name,'Calling Program Unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
7790: END IF;
7791: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required
7792: (p_entity_type => 'DELIVERY',
7793: p_entity_ids => l_del_tab,
7794: x_return_status => l_return_status
7795: );

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

8199: */
8200: IF l_del_rows.count > 0 THEN
8201: --
8202: IF l_debug_on THEN
8203: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
8204: END IF;
8205: --
8206: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
8207: p_entity_type => 'DELIVERY',

Line 8206: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(

8202: IF l_debug_on THEN
8203: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
8204: END IF;
8205: --
8206: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
8207: p_entity_type => 'DELIVERY',
8208: p_entity_ids => l_del_rows,
8209: x_return_status => l_return_status);
8210:

Line 8212: WSH_DEBUG_SV.log(l_module_name,'Return status from WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required -',l_return_status);

8208: p_entity_ids => l_del_rows,
8209: x_return_status => l_return_status);
8210:
8211: IF l_debug_on THEN
8212: WSH_DEBUG_SV.log(l_module_name,'Return status from WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required -',l_return_status);
8213: END IF;
8214: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR OR
8215: l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
8216: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

9766: */
9767: IF l_detail_rows.count > 0 THEN
9768: --
9769: IF l_debug_on THEN
9770: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
9771: END IF;
9772: --
9773: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
9774: p_entity_type => 'DELIVERY_DETAIL',

Line 9773: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(

9769: IF l_debug_on THEN
9770: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
9771: END IF;
9772: --
9773: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
9774: p_entity_type => 'DELIVERY_DETAIL',
9775: p_entity_ids => l_detail_rows,
9776: x_return_status => l_return_status);
9777:

Line 13423: from wsh_delivery_legs l1, wsh_delivery_legs l2,

13419: -- same trip as this delivery from the initial pickup location.
13420:
13421: cursor c_get_trip_info(p_del_id in number) is
13422: select s.trip_id, d2.delivery_id
13423: from wsh_delivery_legs l1, wsh_delivery_legs l2,
13424: wsh_new_deliveries d1, wsh_new_deliveries d2,
13425: wsh_trip_stops s
13426: where l1.delivery_id = p_del_id
13427: and l1.delivery_id = d1.delivery_id -- bug 4891897

Line 13454: FROM wsh_trip_stops s, wsh_delivery_legs l

13450: */
13451:
13452: CURSOR c_get_trip_id(p_delivery_id in number) IS
13453: SELECT trip_id
13454: FROM wsh_trip_stops s, wsh_delivery_legs l
13455: WHERE s.stop_id = l.pick_up_stop_id
13456: AND l.delivery_id = p_delivery_id;
13457:
13458: l_assign_flag VARCHAR2(1);