APPS.WSH_ITM_PKG dependencies on WSH_ITM_REQUEST_CONTROL

Line 61: WSH_ITM_REQUEST_CONTROL REQ

57: RL.ERROR_TYPE ERROR_TYPE,
58: RL.ERROR_TEXT ERROR_TEXT
59: FROM WSH_ITM_RESPONSE_HEADERS RH,
60: WSH_ITM_RESPONSE_LINES RL,
61: WSH_ITM_REQUEST_CONTROL REQ
62: WHERE
63: REQ.REQUEST_CONTROL_ID = p_req_ctrl_id AND
64: REQ.RESPONSE_HEADER_ID = RH.RESPONSE_HEADER_ID AND
65: RH.RESPONSE_HEADER_ID = RL.RESPONSE_HEADER_ID AND

Line 113: FROM WSH_ITM_REQUEST_CONTROL

109: -------------------------------------------------------------------------------
110:
111: -- This sub section checks if the process is completed
112: SELECT PROCESS_FLAG INTO L_PROCESS_FLAG
113: FROM WSH_ITM_REQUEST_CONTROL
114: WHERE REQUEST_CONTROL_ID = P_REQUEST_CONTROL_ID;
115:
116:
117:

Line 136: WSH_ITM_REQUEST_CONTROL IRC

132: l_event_name,
133: l_old_status,
134: l_organization_id
135: FROM WSH_EXCEPTIONS WE ,
136: WSH_ITM_REQUEST_CONTROL IRC
137: WHERE WE.DELIVERY_ID = IRC.ORIGINAL_SYSTEM_REFERENCE
138: 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)
139: AND IRC.REQUEST_CONTROL_ID = P_REQUEST_CONTROL_ID
140: AND WE.STATUS <> 'CLOSED';

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

230: where request_control_id = p_request_control_id
231: );
232:
233: delete from wsh_itm_response_headers where request_control_id = p_request_control_id;
234: delete from wsh_itm_request_control where request_control_id = p_request_control_id; */
235:
236:
237:
238: ELSIF l_process_flag = 2 THEN

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

299: where request_control_id = p_request_control_id
300: );
301: */
302: -- delete from wsh_itm_response_headers where request_control_id = p_request_control_id;
303: -- delete from wsh_itm_request_control where request_control_id = p_request_control_id;
304:
305: ----------------------------------------------------------------------------------------
306: -- Handle Submitted For Export Screening Exception
307: ----------------------------------------------------------------------------------------