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 645: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(

641: or nvl(x_net_weight, 0) <> nvl(l_net_weight, 0)
642: or nvl(x_volume, 0) <> nvl(l_volume, 0 )
643: or nvl(x_net_weight, 0) <> nvl(l_gross_weight,0)) THEN
644: l_detail_tab(1) := p_delivery_detail_id;
645: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
646: p_entity_type => 'DELIVERY_DETAIL',
647: p_entity_ids => l_detail_tab,
648: x_return_status => l_return_status);
649: IF l_debug_on THEN

Line 781: wsh_delivery_legs wdl

777: wdl.pick_up_stop_id,
778: wdl.drop_off_stop_id,
779: wdl.parent_delivery_leg_id
780: FROM wsh_trip_stops wts,
781: wsh_delivery_legs wdl
782: WHERE wdl.delivery_id = p_entity_id
783: AND wdl.pick_up_stop_id = wts.stop_id;
784:
785: CURSOR c_stops(c_trip_id IN NUMBER, c_pkup_stop_id IN NUMBER, c_dpoff_stop_id IN NUMBER) IS

Line 808: FROM wsh_delivery_legs

804: -- when updating the child wt/vol
805:
806: CURSOR c_consol_delivery(p_delivery_leg_id IN NUMBER) IS
807: SELECT delivery_id
808: FROM wsh_delivery_legs
809: WHERE delivery_leg_id = p_delivery_leg_id;
810:
811:
812: -- BugFix 3570954

Line 2109: wsh_delivery_legs wdl

2105: wdl.pick_up_stop_id,
2106: wdl.drop_off_stop_id,
2107: wdl.parent_delivery_leg_id
2108: FROM wsh_trip_stops wts,
2109: wsh_delivery_legs wdl
2110: WHERE wdl.delivery_leg_id = p_leg_id
2111: AND wdl.pick_up_stop_id = wts.stop_id
2112: AND p_leg_id is not null
2113: UNION

Line 2119: wsh_delivery_legs wdl

2115: wdl.pick_up_stop_id,
2116: wdl.drop_off_stop_id,
2117: wdl.parent_delivery_leg_id
2118: FROM wsh_trip_stops wts,
2119: wsh_delivery_legs wdl
2120: WHERE wdl.delivery_id = p_delivery_id
2121: AND wdl.pick_up_stop_id = wts.stop_id
2122: AND p_leg_id is null;
2123:

Line 2126: FROM wsh_delivery_legs wdl,

2122: AND p_leg_id is null;
2123:
2124: CURSOR C1(c_trip_id IN NUMBER) IS
2125: SELECT delivery_id
2126: FROM wsh_delivery_legs wdl,
2127: wsh_trip_stops wts
2128: WHERE wts.trip_id = c_trip_id
2129: AND wdl.pick_up_stop_id = wts.stop_id
2130: AND wdl.parent_delivery_leg_id is NULL

Line 2134: SELECT delivery_id from wsh_delivery_legs

2130: AND wdl.parent_delivery_leg_id is NULL
2131: AND wdl.delivery_id <> p_delivery_id;
2132:
2133: CURSOR c_parent_delivery (p_delivery_leg_id IN NUMBER) IS
2134: SELECT delivery_id from wsh_delivery_legs
2135: WHERE delivery_leg_id = p_delivery_leg_id;
2136:
2137: --R12 MDC
2138: CURSOR c_check_pickup(p_stop_id IN NUMBER) IS

Line 2140: FROM wsh_delivery_legs wdl

2136:
2137: --R12 MDC
2138: CURSOR c_check_pickup(p_stop_id IN NUMBER) IS
2139: SELECT delivery_leg_id
2140: FROM wsh_delivery_legs wdl
2141: WHERE wdl.delivery_id = p_delivery_id
2142: AND wdl.pick_up_stop_id = p_stop_id;
2143:
2144: CURSOR c_check_dropoff(p_stop_id IN NUMBER) IS

Line 2146: FROM wsh_delivery_legs wdl

2142: AND wdl.pick_up_stop_id = p_stop_id;
2143:
2144: CURSOR c_check_dropoff(p_stop_id IN NUMBER) IS
2145: SELECT delivery_leg_id
2146: FROM wsh_delivery_legs wdl
2147: WHERE wdl.delivery_id = p_delivery_id
2148: AND wdl.drop_off_stop_id = p_stop_id;
2149:
2150: l_stop_type VARCHAR2(100);

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

2341:
2342: l_del_tab(1) := p_delivery_id;
2343:
2344: IF l_debug_on THEN
2345: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
2346: END IF;
2347: --
2348: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
2349: p_entity_type => 'DELIVERY',

Line 2348: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(

2344: IF l_debug_on THEN
2345: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
2346: END IF;
2347: --
2348: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
2349: p_entity_type => 'DELIVERY',
2350: p_entity_ids => l_del_tab,
2351: x_return_status => l_return_status);
2352: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

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

2765:
2766: l_details_marked.delete;
2767: l_details_marked(1) := p_container_instance_id;
2768: IF l_debug_on THEN
2769: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
2770: END IF;
2771:
2772: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
2773: p_entity_type => 'DELIVERY_DETAIL',

Line 2772: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(

2768: IF l_debug_on THEN
2769: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
2770: END IF;
2771:
2772: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
2773: p_entity_type => 'DELIVERY_DETAIL',
2774: p_entity_ids => l_details_marked,
2775: x_return_status => l_return_status);
2776: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

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

3317: l_details_marked.delete;
3318: l_details_marked(1) := childInfo_rec.delivery_detail_id;
3319:
3320: IF l_debug_on THEN
3321: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
3322: END IF;
3323:
3324: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
3325: p_entity_type => 'DELIVERY_DETAIL',

Line 3324: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(

3320: IF l_debug_on THEN
3321: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
3322: END IF;
3323:
3324: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
3325: p_entity_type => 'DELIVERY_DETAIL',
3326: p_entity_ids => l_details_marked,
3327: x_return_status => l_return_status);
3328: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 4999: FROM wsh_delivery_legs l1,

4995: CURSOR c_child_deliveries(p_delivery_id IN NUMBER) IS
4996: SELECT d.weight_uom_code wt_uom,
4997: d.volume_uom_code vol_uom,
4998: d.delivery_id del_id
4999: FROM wsh_delivery_legs l1,
5000: wsh_delivery_legs l2,
5001: wsh_new_deliveries d
5002: WHERE l1.delivery_id = p_delivery_id
5003: AND l1.delivery_leg_id = l2.parent_delivery_leg_id

Line 5000: wsh_delivery_legs l2,

4996: SELECT d.weight_uom_code wt_uom,
4997: d.volume_uom_code vol_uom,
4998: d.delivery_id del_id
4999: FROM wsh_delivery_legs l1,
5000: wsh_delivery_legs l2,
5001: wsh_new_deliveries d
5002: WHERE l1.delivery_id = p_delivery_id
5003: AND l1.delivery_leg_id = l2.parent_delivery_leg_id
5004: AND l2.delivery_id = d.delivery_id;