APPS.WMS_SHIPPING_PUB dependencies on WMS_SHIPPING_TRANSACTION_TEMP

Line 43: FROM wms_shipping_transaction_temp

39: WHERE delivery_id = l_delivery_id;
40: CURSOR get_lpn_id (l_delivery_detail_id NUMBER)
41: IS
42: SELECT DISTINCT outermost_lpn_id
43: FROM wms_shipping_transaction_temp
44: WHERE delivery_detail_id = l_delivery_detail_id ;
45: -- MRANA .. bug4287561 ..AND nvl(direct_ship_flag,'N') = 'N';
46: /* MRANA .. bug4287561 ...commented the above condition since we
47: --want to process lines loaded thru direct ship page too */

Line 201: FROM wms_shipping_transaction_temp

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
204: debug('sucessful deleting wms_direct_ship_temp for all lpns with delivery_id = ' || l_delivery_id);
205: END IF;

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

210: END IF;
211: END IF ;
212: END ;
213: BEGIN
214: IF l_debug = 1 THEN debug('Ready to delete wms_shipping_transaction_temp '); END IF;
215: DELETE FROM wms_shipping_transaction_temp
216: WHERE delivery_id = l_delivery_id ;
217: IF l_debug = 1 THEN
218: debug('sucessful deleting wms_shipping_transaction_temp where delivery_id = ' || l_delivery_id);

Line 215: DELETE FROM wms_shipping_transaction_temp

211: END IF ;
212: END ;
213: BEGIN
214: IF l_debug = 1 THEN debug('Ready to delete wms_shipping_transaction_temp '); END IF;
215: DELETE FROM wms_shipping_transaction_temp
216: WHERE delivery_id = l_delivery_id ;
217: IF l_debug = 1 THEN
218: debug('sucessful deleting wms_shipping_transaction_temp where delivery_id = ' || l_delivery_id);
219: END IF;

Line 218: debug('sucessful deleting wms_shipping_transaction_temp where delivery_id = ' || l_delivery_id);

214: IF l_debug = 1 THEN debug('Ready to delete wms_shipping_transaction_temp '); END IF;
215: DELETE FROM wms_shipping_transaction_temp
216: WHERE delivery_id = l_delivery_id ;
217: IF l_debug = 1 THEN
218: debug('sucessful deleting wms_shipping_transaction_temp where delivery_id = ' || l_delivery_id);
219: END IF;
220: IF SQL%NOTFOUND THEN
221: NULL;
222: IF l_debug = 1 THEN

Line 223: debug('Could not delete wms_shipping_transaction_temp where delivery_id = ' || l_delivery_id);

219: END IF;
220: IF SQL%NOTFOUND THEN
221: NULL;
222: IF l_debug = 1 THEN
223: debug('Could not delete wms_shipping_transaction_temp where delivery_id = ' || l_delivery_id);
224: END IF;
225: END IF ;
226: END;
227: END IF;