60: wrh.error_code,
61: wrr.interpreted_value_code,
62: wrh.EXPORT_COMPLIANCE_STATUS,
63: wrh.SERVICE_TYPE_CODE
64: FROM WSH_ITM_REQUEST_CONTROL WRC,
65: WSH_ITM_RESPONSE_HEADERS WRH,
66: WSH_ITM_RESPONSE_RULES WRR
67: WHERE wrc.request_control_id = req_control_id
68: AND wrc.response_header_id = wrh.response_header_id
220:
221: END LOOP;
222:
223: IF x_interpreted_value = SUCCESS THEN
224: UPDATE wsh_itm_request_control
225: SET process_flag = 1
226: WHERE request_control_id = p_request_control_id;
227: END IF;
228:
246: CURSOR Get_Request_Control IS
247: SELECT
248: DISTINCT wrc.request_control_id
249: FROM
250: WSH_ITM_REQUEST_CONTROL wrc,
251: WSH_ITM_RESPONSE_HEADERS wrh,
252: WSH_ITM_PARTIES wp
253: WHERE
254: wrc.response_header_id = wrh.response_header_id
259: UNION
260: SELECT
261: DISTINCT wrc.request_control_id
262: FROM
263: WSH_ITM_REQUEST_CONTROL wrc,
264: WSH_ITM_RESPONSE_HEADERS wrh,
265: WSH_ITM_RESPONSE_LINES wrl,
266: WSH_ITM_PARTIES wp
267: WHERE