APPS.WSH_ITM_PKG dependencies on WSH_ITM_REQUEST_CONTROL

Line 63: WSH_ITM_REQUEST_CONTROL REQ,

59: RL.ERROR_TEXT ERROR_TEXT,
60: WRR.INTERPRETED_VALUE_CODE INTERPRETED_VALUE
61: FROM WSH_ITM_RESPONSE_HEADERS RH,
62: WSH_ITM_RESPONSE_LINES RL,
63: WSH_ITM_REQUEST_CONTROL REQ,
64: WSH_ITM_RESPONSE_RULES WRR
65: WHERE
66: REQ.REQUEST_CONTROL_ID = p_req_ctrl_id AND
67: REQ.RESPONSE_HEADER_ID = RH.RESPONSE_HEADER_ID AND

Line 119: FROM WSH_ITM_REQUEST_CONTROL

115: -------------------------------------------------------------------------------
116:
117: -- This sub section checks if the process is completed
118: SELECT PROCESS_FLAG INTO L_PROCESS_FLAG
119: FROM WSH_ITM_REQUEST_CONTROL
120: WHERE REQUEST_CONTROL_ID = P_REQUEST_CONTROL_ID;
121:
122:
123:

Line 142: WSH_ITM_REQUEST_CONTROL IRC

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
146: AND WE.STATUS <> 'CLOSED';

Line 240: delete from wsh_itm_request_control where request_control_id = p_request_control_id; */

236: where request_control_id = p_request_control_id
237: );
238:
239: delete from wsh_itm_response_headers where request_control_id = p_request_control_id;
240: delete from wsh_itm_request_control where request_control_id = p_request_control_id; */
241:
242:
243:
244: ELSIF l_process_flag = 2 THEN

Line 265: UPDATE wsh_itm_request_control

261: --Bug 9277386:When the error code from Response XML is interpreted as 'SUCCESS',
262: -- updating process_flag to 1 and closing the existing ITM exceptions.
263: IF l_interpreted_value = 'SUCCESS' THEN
264:
265: UPDATE wsh_itm_request_control
266: SET process_flag = 1 ,
267: last_update_date= sysdate,
268: last_updated_by = fnd_global.user_id
269: WHERE request_control_id = p_request_control_id;

Line 290: -- delete from wsh_itm_request_control where request_control_id = p_request_control_id;

286: where request_control_id = p_request_control_id
287: );
288: */
289: -- delete from wsh_itm_response_headers where request_control_id = p_request_control_id;
290: -- delete from wsh_itm_request_control where request_control_id = p_request_control_id;
291:
292: ----------------------------------------------------------------------------------------
293: -- Handle Submitted For Export Screening Exception
294: ----------------------------------------------------------------------------------------