APPS.WMS_SHIPPING_PUB dependencies on WMS_SHIPPING_TRANSACTION_TEMP

Line 55: FROM wms_shipping_transaction_temp

51:
52: CURSOR get_lpn_id (l_delivery_detail_id NUMBER)
53: IS
54: SELECT DISTINCT outermost_lpn_id
55: FROM wms_shipping_transaction_temp
56: WHERE delivery_detail_id = l_delivery_detail_id ;
57: -- MRANA .. bug4287561 ..AND nvl(direct_ship_flag,'N') = 'N';
58: /* MRANA .. bug4287561 ...commented the above condition since we
59: --want to process lines loaded thru direct ship page too */

Line 135: FROM wms_shipping_transaction_temp

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
138: NULL;
139: IF l_debug = 1 THEN

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

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;
149: /* bug 13500119 */
150: IF (l_delivery_detail_id_tab.COUNT > 0 ) THEN
151: FORALL i IN l_delivery_detail_id_tab.first .. l_delivery_detail_id_tab.last
152: DELETE FROM wms_shipping_transaction_temp

Line 152: DELETE FROM wms_shipping_transaction_temp

148: IF l_debug = 1 THEN debug('Ready to delete wms_shipping_transaction_temp '); END IF;
149: /* bug 13500119 */
150: IF (l_delivery_detail_id_tab.COUNT > 0 ) THEN
151: FORALL i IN l_delivery_detail_id_tab.first .. l_delivery_detail_id_tab.last
152: DELETE FROM wms_shipping_transaction_temp
153: WHERE delivery_detail_id = l_delivery_detail_id_tab(i);
154: IF l_debug = 1 THEN
155: debug('Delete wms_shipping_transaction_temp where delivery_detail_id = ' || l_delivery_detail_id_tab(i));
156: END IF;

Line 155: debug('Delete wms_shipping_transaction_temp where delivery_detail_id = ' || l_delivery_detail_id_tab(i));

151: FORALL i IN l_delivery_detail_id_tab.first .. l_delivery_detail_id_tab.last
152: DELETE FROM wms_shipping_transaction_temp
153: WHERE delivery_detail_id = l_delivery_detail_id_tab(i);
154: IF l_debug = 1 THEN
155: debug('Delete wms_shipping_transaction_temp where delivery_detail_id = ' || l_delivery_detail_id_tab(i));
156: END IF;
157: END IF;
158: /* bug 13500119 */
159:

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

159:
160: IF SQL%NOTFOUND THEN
161: NULL;
162: IF l_debug = 1 THEN
163: debug('Could not delete wms_shipping_transaction_temp where delivery_id = ' || l_delivery_id);
164: END IF;
165: ELSE
166: IF l_debug = 1 THEN
167: debug('sucessful deleting wms_shipping_transaction_temp where delivery_id = ' || l_delivery_id);

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

163: debug('Could not delete wms_shipping_transaction_temp where delivery_id = ' || l_delivery_id);
164: END IF;
165: ELSE
166: IF l_debug = 1 THEN
167: debug('sucessful deleting wms_shipping_transaction_temp where delivery_id = ' || l_delivery_id);
168: END IF;
169: END IF ;
170: END IF; -- wms_globals.g_ship_confirm_method <> 'DIRECT' THEN
171: END LOOP;