APPS.WMS_DIRECT_SHIP_PVT dependencies on WMS_FREIGHT_COST_TEMP

Line 792: FROM WMS_FREIGHT_COST_TEMP

788: ,FREIGHT_COST_TYPE_ID
789: ,CURRENCY_CODE
790: ,FREIGHT_AMOUNT
791: ,CONVERSION_TYPE
792: FROM WMS_FREIGHT_COST_TEMP
793: WHERE delivery_id = p_delivery_id
794: AND FREIGHT_COST_ID IS NULL
795: FOR UPDATE OF FREIGHT_COST_ID;
796: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 884: UPDATE WMS_FREIGHT_COST_TEMP

880: END IF;
881: raise fnd_api.g_exc_unexpected_error;
882: END IF;
883:
884: UPDATE WMS_FREIGHT_COST_TEMP
885: SET freight_cost_id = l_freight_cost_id,
886: last_update_date= SYSDATE,
887: last_updated_by = FND_GLOBAL.USER_ID
888: WHERE rowid = l_row_id;

Line 2018: FROM WMS_FREIGHT_COST_TEMP

2014: ,FREIGHT_COST_TYPE_ID
2015: ,CURRENCY_CODE
2016: ,FREIGHT_AMOUNT
2017: ,CONVERSION_TYPE
2018: FROM WMS_FREIGHT_COST_TEMP
2019: WHERE TRIP_ID = p_trip_id
2020: AND FREIGHT_COST_ID IS NULL
2021: FOR UPDATE OF FREIGHT_COST_ID NOWAIT;
2022:

Line 2141: UPDATE WMS_FREIGHT_COST_TEMP

2137: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2138: END IF;
2139: --\Shipping API cleanup
2140:
2141: UPDATE WMS_FREIGHT_COST_TEMP
2142: SET freight_cost_id = l_freight_cost_id
2143: ,last_update_date = SYSDATE
2144: ,last_updated_by = FND_GLOBAL.USER_ID
2145: WHERE rowid = l_row_id;

Line 3391: DELETE FROM wms_freight_cost_temp

3387: --Delete the records for the LPN
3388: FOR l_lpn IN outermost_lpn_cur LOOP
3389: l_outermost_lpn_id := l_lpn.outermost_lpn_id;
3390:
3391: DELETE FROM wms_freight_cost_temp
3392: WHERE organization_id = p_org_id
3393: AND lpn_id = l_outermost_lpn_id;
3394:
3395: DELETE FROM mtl_serial_numbers_temp

Line 3410: DELETE FROM wms_freight_cost_temp

3406: END LOOP;
3407:
3408: --Delete the records for the delivery
3409: FOR l_delivery IN delivery_cur LOOP
3410: DELETE FROM wms_freight_cost_temp
3411: WHERE organization_id = p_org_id
3412: AND delivery_id = l_delivery.delivery_id;
3413: END LOOP;
3414:

Line 3416: DELETE FROM wms_freight_cost_temp

3412: AND delivery_id = l_delivery.delivery_id;
3413: END LOOP;
3414:
3415: --Delete the trip records
3416: DELETE FROM wms_freight_cost_temp
3417: WHERE organization_id = p_org_id
3418: AND trip_id = p_trip_id;
3419:
3420: DELETE FROM wms_shipping_transaction_temp

Line 3437: DELETE FROM wms_freight_cost_temp

3433: DELETE FROM wms_shipping_transaction_temp
3434: WHERE organization_id = p_org_id
3435: AND outermost_lpn_id = p_outermost_lpn_id;
3436:
3437: DELETE FROM wms_freight_cost_temp
3438: WHERE lpn_id = p_outermost_lpn_id;
3439:
3440: --Delete records from Mtl_Seral_Numbers_Temp if any
3441: BEGIN

Line 3606: FROM wms_freight_cost_temp

3602: , freight_cost_type_id
3603: , currency_code
3604: , freight_amount
3605: , conversion_type
3606: FROM wms_freight_cost_temp
3607: WHERE lpn_id = p_lpn_id
3608: AND freight_cost_id IS NULL
3609: FOR UPDATE OF freight_cost_id;
3610:

Line 3674: UPDATE wms_freight_cost_temp

3670:
3671: RAISE fnd_api.g_exc_unexpected_error;
3672: END IF;
3673:
3674: UPDATE wms_freight_cost_temp
3675: SET freight_cost_id = l_freight_cost_id
3676: , last_update_date = SYSDATE
3677: , last_updated_by = fnd_global.user_id
3678: WHERE ROWID = l_lpn_freight.ROWID;

Line 11690: DELETE wms_freight_cost_temp

11686:
11687: DELETE wms_direct_ship_temp
11688: WHERE lpn_id = l_lpn_cur.lpn_id;
11689:
11690: DELETE wms_freight_cost_temp
11691: WHERE lpn_id = l_lpn_cur.lpn_id;
11692:
11693: DELETE wms_freight_cost_temp
11694: WHERE delivery_id = l_closed_del.delivery_id;

Line 11693: DELETE wms_freight_cost_temp

11689:
11690: DELETE wms_freight_cost_temp
11691: WHERE lpn_id = l_lpn_cur.lpn_id;
11692:
11693: DELETE wms_freight_cost_temp
11694: WHERE delivery_id = l_closed_del.delivery_id;
11695:
11696: DELETE wms_freight_cost_temp
11697: WHERE trip_id IN(SELECT DISTINCT trip_id

Line 11696: DELETE wms_freight_cost_temp

11692:
11693: DELETE wms_freight_cost_temp
11694: WHERE delivery_id = l_closed_del.delivery_id;
11695:
11696: DELETE wms_freight_cost_temp
11697: WHERE trip_id IN(SELECT DISTINCT trip_id
11698: FROM wms_shipping_transaction_temp
11699: WHERE outermost_lpn_id = l_lpn_cur.lpn_id);
11700: