DBA Data[Home] [Help]

APPS.WSH_TRANSACTIONS_UTIL dependencies on WSH_SHIPMENT_BATCHES

Line 1649: UPDATE wsh_shipment_batches

1645: IF ( x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
1646: raise wsh_update_history;
1647: ELSE
1648: IF p_item_type = 'WSHBATO' THEN --Fulfillment Batch XML Project
1649: UPDATE wsh_shipment_batches
1650: SET pending_request_flag = NULL
1651: WHERE batch_id = (SELECT entity_number FROM WSH_TRANSACTIONS_HISTORY WHERE event_key = p_item_key AND item_type = p_item_type)
1652: AND pending_request_flag = 'Y';
1653: END IF;