APPS.WSH_ITM_PKG dependencies on WSH_EXCEPTIONS

Line 141: FROM WSH_EXCEPTIONS WE ,

137: l_exception_id,
138: l_event_name,
139: l_old_status,
140: l_organization_id
141: FROM WSH_EXCEPTIONS WE ,
142: WSH_ITM_REQUEST_CONTROL IRC
143: WHERE WE.DELIVERY_ID = IRC.ORIGINAL_SYSTEM_REFERENCE
144: AND WE.EXCEPTION_NAME = DECODE(IRC.TRIGGERING_POINT,G_PICK_RELEASE_EVENT,G_SUB_PICK_RELEASE_EXCEPTION,G_SHIP_CONFIRM_EVENT,G_SUB_SHIP_CONFIRM_EXCEPTION)
145: AND IRC.REQUEST_CONTROL_ID = P_REQUEST_CONTROL_ID

Line 256: UPDATE wsh_exceptions

252: l_interpreted_value := l_errorRec.INTERPRETED_VALUE;
253:
254: END LOOP;
255: --Bug 9277386:Populating existing Exception's Error Message, when respose STATUS is ERROR.
256: UPDATE wsh_exceptions
257: SET error_message = l_exception_message ,
258: last_update_date = SYSDATE ,
259: last_updated_by = fnd_global.user_id
260: WHERE exception_id = l_exception_id;