APPS.WMS_SHIPPING_PUB dependencies on WMS_DIRECT_SHIP_TEMP

Line 184: debug('deleting wms_direct_ship_temp ' || l_delivery_detail_id);

180: END IF; -- wms_globals.g_ship_confirm_method <> 'DIRECT' THEN
181: END LOOP;
182:
183: IF l_debug = 1 THEN
184: debug('deleting wms_direct_ship_temp ' || l_delivery_detail_id);
185: END IF;
186:
187: CLOSE get_delivery_detail_id;
188:

Line 197: IF l_debug = 1 THEN debug('Ready to delete wms_direct_ship_temp '); END IF;

193: -- not want to delete these records since it happens in DS page
194: IF (wms_globals.g_ship_confirm_method IS NULL OR
195: wms_globals.g_ship_confirm_method <> 'DIRECT') THEN
196: BEGIN
197: IF l_debug = 1 THEN debug('Ready to delete wms_direct_ship_temp '); END IF;
198:
199: DELETE FROM wms_direct_ship_temp
200: WHERE LPN_ID IN (SELECT DISTINCT outermost_lpn_id
201: FROM wms_shipping_transaction_temp

Line 199: DELETE FROM wms_direct_ship_temp

195: wms_globals.g_ship_confirm_method <> 'DIRECT') THEN
196: BEGIN
197: IF l_debug = 1 THEN debug('Ready to delete wms_direct_ship_temp '); END IF;
198:
199: DELETE FROM wms_direct_ship_temp
200: WHERE LPN_ID IN (SELECT DISTINCT outermost_lpn_id
201: FROM wms_shipping_transaction_temp
202: WHERE delivery_id = l_delivery_id);
203: IF l_debug = 1 THEN

Line 204: debug('sucessful deleting wms_direct_ship_temp for all lpns with delivery_id = ' || l_delivery_id);

200: WHERE LPN_ID IN (SELECT DISTINCT outermost_lpn_id
201: FROM wms_shipping_transaction_temp
202: WHERE delivery_id = l_delivery_id);
203: IF l_debug = 1 THEN
204: debug('sucessful deleting wms_direct_ship_temp for all lpns with delivery_id = ' || l_delivery_id);
205: END IF;
206: IF SQL%NOTFOUND THEN
207: NULL;
208: IF l_debug = 1 THEN

Line 209: debug('could not find any wms_direct_ship_temp for lpns with delivery_id = ' || l_delivery_id);

205: END IF;
206: IF SQL%NOTFOUND THEN
207: NULL;
208: IF l_debug = 1 THEN
209: debug('could not find any wms_direct_ship_temp for lpns with delivery_id = ' || l_delivery_id);
210: END IF;
211: END IF ;
212: END ;
213: BEGIN