APPS.WSH_INV_INTEGRATION_GRP dependencies on WSH_DELIVERY_DETAILS

Line 136: wsh_delivery_details to 'Y' if inventory interface process has completed successfully

132: /*
133: Procedure :Complete_Inv_Interface
134: Description: This procedure will be called by Inventory during processing of the data from their interface
135: tables.The purpose of this procedure is to update the inventory_interfaced_flag on
136: wsh_delivery_details to 'Y' if inventory interface process has completed successfully
137: and also to update the pending_interface_flag for the corresponding trip stops to NULL.
138: */
139: PROCEDURE Complete_Inv_Interface(
140: p_api_version_number IN NUMBER,

Line 151: FROM wsh_delivery_details wdd,

147: x_msg_data OUT NOCOPY VARCHAR2) IS
148:
149: CURSOR detail_rec_csr IS
150: SELECT st.stop_id, wdd.delivery_detail_id
151: FROM wsh_delivery_details wdd,
152: mtl_transactions_interface mtf,
153: wsh_delivery_assignments_v da ,
154: wsh_delivery_legs dg,
155: wsh_new_deliveries dl,

Line 193: wsh_delivery_details wdd

189: SELECT wdd.delivery_detail_id
190: FROM wsh_trip_stops wts,
191: wsh_delivery_legs wdl,
192: wsh_delivery_assignments_v wda,
193: wsh_delivery_details wdd
194: WHERE (wdd.inv_interfaced_flag IN ('N', 'P') OR wdd.oe_interfaced_flag <> 'Y')
195: AND wts.stop_id = p_stop_id
196: AND wts.stop_location_id = wdd.ship_from_location_id
197: AND wts.stop_id = wdl.pick_up_stop_id

Line 292: UPDATE wsh_delivery_details

288: WSH_DEBUG_SV.log(l_module_name,'l_stop_id',l_stop_id);
289: END IF;
290:
291: FORALL i IN 1 ..l_row_count
292: UPDATE wsh_delivery_details
293: SET inv_interfaced_flag = 'Y'
294: WHERE delivery_detail_id = l_det_rec.delivery_detail_id(i);
295:
296: l_row_count := SQL%ROWCOUNT;