57: RL.ERROR_CODE ERROR_CODE,
58: RL.ERROR_TYPE ERROR_TYPE,
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
231:
232: /* delete from wsh_itm_response_lines where response_header_id IN
233: (
234: select response_header_id
235: from wsh_itm_response_headers
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;
235: from wsh_itm_response_headers
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:
281:
282: /*delete from wsh_itm_response_lines where response_header_id IN
283: (
284: select response_header_id
285: from wsh_itm_response_headers
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;
285: from wsh_itm_response_headers
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