APPS.WMS_DIRECT_SHIP_PVT dependencies on WMS_FREIGHT_COST_TEMP

Line 875: FROM WMS_FREIGHT_COST_TEMP

871: ,FREIGHT_COST_TYPE_ID
872: ,CURRENCY_CODE
873: ,FREIGHT_AMOUNT
874: ,CONVERSION_TYPE
875: FROM WMS_FREIGHT_COST_TEMP
876: WHERE delivery_id = p_delivery_id
877: AND FREIGHT_COST_ID IS NULL
878: FOR UPDATE OF FREIGHT_COST_ID;
879: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 967: UPDATE WMS_FREIGHT_COST_TEMP

963: END IF;
964: raise fnd_api.g_exc_unexpected_error;
965: END IF;
966:
967: UPDATE WMS_FREIGHT_COST_TEMP
968: SET freight_cost_id = l_freight_cost_id,
969: last_update_date= SYSDATE,
970: last_updated_by = FND_GLOBAL.USER_ID
971: WHERE rowid = l_row_id;

Line 2114: FROM WMS_FREIGHT_COST_TEMP

2110: ,FREIGHT_COST_TYPE_ID
2111: ,CURRENCY_CODE
2112: ,FREIGHT_AMOUNT
2113: ,CONVERSION_TYPE
2114: FROM WMS_FREIGHT_COST_TEMP
2115: WHERE TRIP_ID = p_trip_id
2116: AND FREIGHT_COST_ID IS NULL
2117: FOR UPDATE OF FREIGHT_COST_ID NOWAIT;
2118:

Line 2237: UPDATE WMS_FREIGHT_COST_TEMP

2233: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2234: END IF;
2235: --\Shipping API cleanup
2236:
2237: UPDATE WMS_FREIGHT_COST_TEMP
2238: SET freight_cost_id = l_freight_cost_id
2239: ,last_update_date = SYSDATE
2240: ,last_updated_by = FND_GLOBAL.USER_ID
2241: WHERE rowid = l_row_id;

Line 3581: DELETE FROM wms_freight_cost_temp

3577: --Delete the records for the LPN
3578: FOR l_lpn IN outermost_lpn_cur LOOP
3579: l_outermost_lpn_id := l_lpn.outermost_lpn_id;
3580:
3581: DELETE FROM wms_freight_cost_temp
3582: WHERE organization_id = p_org_id
3583: AND lpn_id = l_outermost_lpn_id;
3584:
3585: DELETE FROM mtl_serial_numbers_temp

Line 3600: DELETE FROM wms_freight_cost_temp

3596: END LOOP;
3597:
3598: --Delete the records for the delivery
3599: FOR l_delivery IN delivery_cur LOOP
3600: DELETE FROM wms_freight_cost_temp
3601: WHERE organization_id = p_org_id
3602: AND delivery_id = l_delivery.delivery_id;
3603: END LOOP;
3604:

Line 3606: DELETE FROM wms_freight_cost_temp

3602: AND delivery_id = l_delivery.delivery_id;
3603: END LOOP;
3604:
3605: --Delete the trip records
3606: DELETE FROM wms_freight_cost_temp
3607: WHERE organization_id = p_org_id
3608: AND trip_id = p_trip_id;
3609:
3610: DELETE FROM wms_shipping_transaction_temp

Line 3627: DELETE FROM wms_freight_cost_temp

3623: DELETE FROM wms_shipping_transaction_temp
3624: WHERE organization_id = p_org_id
3625: AND outermost_lpn_id = p_outermost_lpn_id;
3626:
3627: DELETE FROM wms_freight_cost_temp
3628: WHERE lpn_id = p_outermost_lpn_id;
3629:
3630: --Delete records from Mtl_Seral_Numbers_Temp if any
3631: BEGIN

Line 3808: FROM wms_freight_cost_temp

3804: , freight_cost_type_id
3805: , currency_code
3806: , freight_amount
3807: , conversion_type
3808: FROM wms_freight_cost_temp
3809: WHERE lpn_id = p_lpn_id
3810: AND freight_cost_id IS NULL
3811: FOR UPDATE OF freight_cost_id;
3812:

Line 3876: UPDATE wms_freight_cost_temp

3872:
3873: RAISE fnd_api.g_exc_unexpected_error;
3874: END IF;
3875:
3876: UPDATE wms_freight_cost_temp
3877: SET freight_cost_id = l_freight_cost_id
3878: , last_update_date = SYSDATE
3879: , last_updated_by = fnd_global.user_id
3880: WHERE ROWID = l_lpn_freight.ROWID;

Line 13675: DELETE wms_freight_cost_temp

13671: DELETE wms_direct_ship_temp
13672: WHERE lpn_id = l_lpn_tab(i);
13673:
13674: FORALL i IN l_lpn_tab.FIRST .. l_lpn_tab.LAST
13675: DELETE wms_freight_cost_temp
13676: WHERE lpn_id = l_lpn_tab(i);
13677:
13678: FORALL i IN l_del_tab.FIRST .. l_del_tab.LAST
13679: DELETE wms_freight_cost_temp

Line 13679: DELETE wms_freight_cost_temp

13675: DELETE wms_freight_cost_temp
13676: WHERE lpn_id = l_lpn_tab(i);
13677:
13678: FORALL i IN l_del_tab.FIRST .. l_del_tab.LAST
13679: DELETE wms_freight_cost_temp
13680: WHERE delivery_id = l_del_tab(i);
13681:
13682: FORALL i IN l_trip_tab.FIRST .. l_trip_tab.LAST
13683: DELETE wms_freight_cost_temp

Line 13683: DELETE wms_freight_cost_temp

13679: DELETE wms_freight_cost_temp
13680: WHERE delivery_id = l_del_tab(i);
13681:
13682: FORALL i IN l_trip_tab.FIRST .. l_trip_tab.LAST
13683: DELETE wms_freight_cost_temp
13684: WHERE trip_id IN l_trip_tab(i);
13685:
13686: FORALL i IN l_lpn_tab.FIRST .. l_lpn_tab.LAST
13687: DELETE wms_shipping_transaction_temp