[Home] [Help]
192: /*
193: Procedure :Complete_Inv_Interface
194: Description: This procedure will be called by Inventory during processing of the data from their interface
195: tables.The purpose of this procedure is to update the inventory_interfaced_flag on
196: wsh_delivery_details to 'Y' if inventory interface process has completed successfully
197: and also to update the pending_interface_flag for the corresponding trip stops to NULL.
198: */
199: PROCEDURE Complete_Inv_Interface(
200: p_api_version_number IN NUMBER,
207: x_msg_data OUT NOCOPY VARCHAR2) IS
208:
209: CURSOR detail_rec_csr IS
210: SELECT st.stop_id, wdd.delivery_detail_id
211: FROM wsh_delivery_details wdd,
212: mtl_transactions_interface mtf,
213: wsh_delivery_assignments_v da ,
214: wsh_delivery_legs dg,
215: wsh_new_deliveries dl,
249: SELECT wdd.delivery_detail_id
250: FROM wsh_trip_stops wts,
251: wsh_delivery_legs wdl,
252: wsh_delivery_assignments_v wda,
253: wsh_delivery_details wdd
254: WHERE (wdd.inv_interfaced_flag IN ('N', 'P') OR wdd.oe_interfaced_flag <> 'Y')
255: AND wts.stop_id = p_stop_id
256: AND wts.stop_location_id = wdd.ship_from_location_id
257: AND wts.stop_id = wdl.pick_up_stop_id
348: WSH_DEBUG_SV.log(l_module_name,'l_stop_id',l_stop_id);
349: END IF;
350:
351: FORALL i IN 1 ..l_row_count
352: UPDATE wsh_delivery_details
353: SET inv_interfaced_flag = 'Y'
354: WHERE delivery_detail_id = l_det_rec.delivery_detail_id(i);
355:
356: l_row_count := SQL%ROWCOUNT;