APPS.WSH_FTE_CONSTRAINT_FRAMEWORK dependencies on WSH_CONSTRAINT_DLEG_TMP

Line 9120: wsh_constraint_dleg_tmp v -- global temporary table

9116: -- AGDUMMY Start with a leg whose pickup loc is not a dropoff stop of another leg of that delivery
9117:
9118: CURSOR c_get_dlegs(c_delivery_id IN NUMBER) IS
9119: SELECT * from
9120: wsh_constraint_dleg_tmp v -- global temporary table
9121: where v.delivery_id = c_delivery_id
9122: CONNECT BY PRIOR v.drop_off_stop_location_id = v.pick_up_stop_location_id
9123: START WITH v.pick_up_stop_location_id NOT IN (select nvl(a.physical_location_id,a.stop_location_id)
9124: from wsh_delivery_legs c,wsh_trip_stops a where

Line 9278: FROM wsh_constraint_dleg_tmp

9274:
9275: /*
9276: SELECT COUNT(*)
9277: INTO l_tmp_count
9278: FROM wsh_constraint_dleg_tmp
9279: WHERE delivery_id = p_delivery_id;
9280:
9281: IF l_debug_on THEN
9282: WSH_DEBUG_SV.logmsg(l_module_name,'Currently have :'||l_tmp_count||' rows into wsh_constraint_dleg_tmp for delivery : '||p_delivery_id);

Line 9282: WSH_DEBUG_SV.logmsg(l_module_name,'Currently have :'||l_tmp_count||' rows into wsh_constraint_dleg_tmp for delivery : '||p_delivery_id);

9278: FROM wsh_constraint_dleg_tmp
9279: WHERE delivery_id = p_delivery_id;
9280:
9281: IF l_debug_on THEN
9282: WSH_DEBUG_SV.logmsg(l_module_name,'Currently have :'||l_tmp_count||' rows into wsh_constraint_dleg_tmp for delivery : '||p_delivery_id);
9283: END IF;
9284: */
9285:
9286: OPEN c_get_dlegs(p_delivery_id);

Line 10266: WSH_DEBUG_SV.logmsg(l_module_name,'Inserting into wsh_constraint_dleg_tmp ');

10262:
10263: IF l_delivery_ids.COUNT > 0 THEN
10264:
10265: IF l_debug_on THEN
10266: WSH_DEBUG_SV.logmsg(l_module_name,'Inserting into wsh_constraint_dleg_tmp ');
10267: END IF;
10268:
10269:
10270: FORALL q in l_delivery_ids.FIRST..l_delivery_ids.LAST

Line 10271: INSERT INTO wsh_constraint_dleg_tmp (

10267: END IF;
10268:
10269:
10270: FORALL q in l_delivery_ids.FIRST..l_delivery_ids.LAST
10271: INSERT INTO wsh_constraint_dleg_tmp (
10272: SELECT wdl.delivery_leg_id,wdl.sequence_number,
10273: wdl.pick_up_stop_id, wdl.drop_off_stop_id,
10274: nvl(wts1.physical_location_id,wts1.stop_location_id) ,
10275: nvl(wts2.physical_location_id,wts2.stop_location_id) ,

Line 10288: from wsh_constraint_dleg_tmp wcdt

10284: AND wdl.pick_up_stop_id = wts1.stop_id
10285: AND wdl.drop_off_stop_id = wts2.stop_id
10286: AND wdl.delivery_leg_id NOT IN
10287: ( select wcdt.delivery_leg_id
10288: from wsh_constraint_dleg_tmp wcdt
10289: where wcdt.delivery_leg_id = wdl.delivery_leg_id)
10290: );
10291:
10292: /*

Line 10295: FROM wsh_constraint_dleg_tmp;

10291:
10292: /*
10293: SELECT COUNT(*)
10294: INTO l_tmp_count
10295: FROM wsh_constraint_dleg_tmp;
10296:
10297: IF l_debug_on THEN
10298: WSH_DEBUG_SV.logmsg(l_module_name,'Inserted :'||l_tmp_count||' rows into wsh_constraint_dleg_tmp ');
10299: END IF;

Line 10298: WSH_DEBUG_SV.logmsg(l_module_name,'Inserted :'||l_tmp_count||' rows into wsh_constraint_dleg_tmp ');

10294: INTO l_tmp_count
10295: FROM wsh_constraint_dleg_tmp;
10296:
10297: IF l_debug_on THEN
10298: WSH_DEBUG_SV.logmsg(l_module_name,'Inserted :'||l_tmp_count||' rows into wsh_constraint_dleg_tmp ');
10299: END IF;
10300: */
10301:
10302: ELSE