eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_WV_UTILS dependencies on WSH_DELIVERY_LEGS

Line 650: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(

646: or nvl(x_net_weight, 0) <> nvl(l_net_weight, 0)
647: or nvl(x_volume, 0) <> nvl(l_volume, 0 )
648: or nvl(x_net_weight, 0) <> nvl(l_gross_weight,0)) THEN
649: l_detail_tab(1) := p_delivery_detail_id;
650: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
651: p_entity_type => 'DELIVERY_DETAIL',
652: p_entity_ids => l_detail_tab,
653: x_return_status => l_return_status);
654: IF l_debug_on THEN

Line 786: wsh_delivery_legs wdl

782: wdl.pick_up_stop_id,
783: wdl.drop_off_stop_id,
784: wdl.parent_delivery_leg_id
785: FROM wsh_trip_stops wts,
786: wsh_delivery_legs wdl
787: WHERE wdl.delivery_id = p_entity_id
788: AND wdl.pick_up_stop_id = wts.stop_id;
789:
790: CURSOR c_stops(c_trip_id IN NUMBER, c_pkup_stop_id IN NUMBER, c_dpoff_stop_id IN NUMBER) IS

Line 813: FROM wsh_delivery_legs

809: -- when updating the child wt/vol
810:
811: CURSOR c_consol_delivery(p_delivery_leg_id IN NUMBER) IS
812: SELECT delivery_id
813: FROM wsh_delivery_legs
814: WHERE delivery_leg_id = p_delivery_leg_id;
815:
816:
817: -- BugFix 3570954

Line 2122: wsh_delivery_legs wdl

2118: wdl.pick_up_stop_id,
2119: wdl.drop_off_stop_id,
2120: wdl.parent_delivery_leg_id
2121: FROM wsh_trip_stops wts,
2122: wsh_delivery_legs wdl
2123: WHERE wdl.delivery_leg_id = p_leg_id
2124: AND wdl.pick_up_stop_id = wts.stop_id
2125: AND p_leg_id is not null
2126: UNION

Line 2132: wsh_delivery_legs wdl

2128: wdl.pick_up_stop_id,
2129: wdl.drop_off_stop_id,
2130: wdl.parent_delivery_leg_id
2131: FROM wsh_trip_stops wts,
2132: wsh_delivery_legs wdl
2133: WHERE wdl.delivery_id = p_delivery_id
2134: AND wdl.pick_up_stop_id = wts.stop_id
2135: AND p_leg_id is null;
2136:

Line 2139: FROM wsh_delivery_legs wdl,

2135: AND p_leg_id is null;
2136:
2137: CURSOR C1(c_trip_id IN NUMBER) IS
2138: SELECT delivery_id
2139: FROM wsh_delivery_legs wdl,
2140: wsh_trip_stops wts
2141: WHERE wts.trip_id = c_trip_id
2142: AND wdl.pick_up_stop_id = wts.stop_id
2143: AND wdl.parent_delivery_leg_id is NULL

Line 2147: SELECT delivery_id from wsh_delivery_legs

2143: AND wdl.parent_delivery_leg_id is NULL
2144: AND wdl.delivery_id <> p_delivery_id;
2145:
2146: CURSOR c_parent_delivery (p_delivery_leg_id IN NUMBER) IS
2147: SELECT delivery_id from wsh_delivery_legs
2148: WHERE delivery_leg_id = p_delivery_leg_id;
2149:
2150: --R12 MDC
2151: CURSOR c_check_pickup(p_stop_id IN NUMBER) IS

Line 2153: FROM wsh_delivery_legs wdl

2149:
2150: --R12 MDC
2151: CURSOR c_check_pickup(p_stop_id IN NUMBER) IS
2152: SELECT delivery_leg_id
2153: FROM wsh_delivery_legs wdl
2154: WHERE wdl.delivery_id = p_delivery_id
2155: AND wdl.pick_up_stop_id = p_stop_id;
2156:
2157: CURSOR c_check_dropoff(p_stop_id IN NUMBER) IS

Line 2159: FROM wsh_delivery_legs wdl

2155: AND wdl.pick_up_stop_id = p_stop_id;
2156:
2157: CURSOR c_check_dropoff(p_stop_id IN NUMBER) IS
2158: SELECT delivery_leg_id
2159: FROM wsh_delivery_legs wdl
2160: WHERE wdl.delivery_id = p_delivery_id
2161: AND wdl.drop_off_stop_id = p_stop_id;
2162:
2163: l_stop_type VARCHAR2(100);

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

2354:
2355: l_del_tab(1) := p_delivery_id;
2356:
2357: IF l_debug_on THEN
2358: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
2359: END IF;
2360: --
2361: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
2362: p_entity_type => 'DELIVERY',

Line 2361: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(

2357: IF l_debug_on THEN
2358: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
2359: END IF;
2360: --
2361: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
2362: p_entity_type => 'DELIVERY',
2363: p_entity_ids => l_del_tab,
2364: x_return_status => l_return_status);
2365: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

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

2778:
2779: l_details_marked.delete;
2780: l_details_marked(1) := p_container_instance_id;
2781: IF l_debug_on THEN
2782: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
2783: END IF;
2784:
2785: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
2786: p_entity_type => 'DELIVERY_DETAIL',

Line 2785: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(

2781: IF l_debug_on THEN
2782: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
2783: END IF;
2784:
2785: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
2786: p_entity_type => 'DELIVERY_DETAIL',
2787: p_entity_ids => l_details_marked,
2788: x_return_status => l_return_status);
2789: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

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

3330: l_details_marked.delete;
3331: l_details_marked(1) := childInfo_rec.delivery_detail_id;
3332:
3333: IF l_debug_on THEN
3334: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
3335: END IF;
3336:
3337: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
3338: p_entity_type => 'DELIVERY_DETAIL',

Line 3337: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(

3333: IF l_debug_on THEN
3334: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
3335: END IF;
3336:
3337: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
3338: p_entity_type => 'DELIVERY_DETAIL',
3339: p_entity_ids => l_details_marked,
3340: x_return_status => l_return_status);
3341: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 5012: FROM wsh_delivery_legs l1,

5008: CURSOR c_child_deliveries(p_delivery_id IN NUMBER) IS
5009: SELECT d.weight_uom_code wt_uom,
5010: d.volume_uom_code vol_uom,
5011: d.delivery_id del_id
5012: FROM wsh_delivery_legs l1,
5013: wsh_delivery_legs l2,
5014: wsh_new_deliveries d
5015: WHERE l1.delivery_id = p_delivery_id
5016: AND l1.delivery_leg_id = l2.parent_delivery_leg_id

Line 5013: wsh_delivery_legs l2,

5009: SELECT d.weight_uom_code wt_uom,
5010: d.volume_uom_code vol_uom,
5011: d.delivery_id del_id
5012: FROM wsh_delivery_legs l1,
5013: wsh_delivery_legs l2,
5014: wsh_new_deliveries d
5015: WHERE l1.delivery_id = p_delivery_id
5016: AND l1.delivery_leg_id = l2.parent_delivery_leg_id
5017: AND l2.delivery_id = d.delivery_id;