DBA Data[Home] [Help]

APPS.WSH_INBOUND_SHIP_ADVICE_PKG dependencies on WSH_TRANSACTIONS_HISTORY

Line 396: UPDATE wsh_transactions_history

392: END IF;
393:
394: -- 1. Need to update the txn. history record to success
395: -- Because all data(dlvy, details, trip, stop) have been successfully moved to base tables
396: UPDATE wsh_transactions_history
397: SET transaction_status = 'SC',
398: entity_number = l_delivery_name,
399: entity_type = 'DLVY'
400: WHERE entity_type = 'DLVY_INT'