APPS.WMS_SHIPPING_PUB dependencies on WMS_DIRECT_SHIP_TEMP

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

127: -- Moved the deletion of the temp table records from delivery
128: -- detail loop to delivery_id loop for better efficieny.
129: -- In case this API is called from direct ship page, we do
130: -- not want to delete these records since it happens in DS page
131: IF l_debug = 1 THEN debug('Ready to delete wms_direct_ship_temp '); END IF;
132:
133: DELETE FROM wms_direct_ship_temp
134: WHERE LPN_ID IN (SELECT DISTINCT outermost_lpn_id
135: FROM wms_shipping_transaction_temp

Line 133: DELETE FROM wms_direct_ship_temp

129: -- In case this API is called from direct ship page, we do
130: -- not want to delete these records since it happens in DS page
131: IF l_debug = 1 THEN debug('Ready to delete wms_direct_ship_temp '); END IF;
132:
133: DELETE FROM wms_direct_ship_temp
134: WHERE LPN_ID IN (SELECT DISTINCT outermost_lpn_id
135: FROM wms_shipping_transaction_temp
136: WHERE delivery_id = l_delivery_id);
137: IF SQL%NOTFOUND THEN

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

136: WHERE delivery_id = l_delivery_id);
137: IF SQL%NOTFOUND THEN
138: NULL;
139: IF l_debug = 1 THEN
140: debug('could not find any wms_direct_ship_temp for lpns with delivery_id = ' || l_delivery_id);
141: END IF;
142: ELSE
143: IF l_debug = 1 THEN
144: debug('sucessful deleting wms_direct_ship_temp for all lpns with delivery_id = ' || l_delivery_id);

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

140: debug('could not find any wms_direct_ship_temp for lpns with delivery_id = ' || l_delivery_id);
141: END IF;
142: ELSE
143: IF l_debug = 1 THEN
144: debug('sucessful deleting wms_direct_ship_temp for all lpns with delivery_id = ' || l_delivery_id);
145: END IF;
146: END IF ;
147:
148: IF l_debug = 1 THEN debug('Ready to delete wms_shipping_transaction_temp '); END IF;