APPS.WSH_ITM_PKG dependencies on WSH_ITM_RESPONSE_HEADERS

Line 59: FROM WSH_ITM_RESPONSE_HEADERS RH,

55: RL.EXPORT_COMPLIANCE_DESCRIPTION COMPL_DESC,
56: RL.ERROR_CODE ERROR_CODE,
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

Line 229: from wsh_itm_response_headers

225:
226: /* delete from wsh_itm_response_lines where response_header_id IN
227: (
228: select response_header_id
229: from wsh_itm_response_headers
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;

Line 233: delete from wsh_itm_response_headers where request_control_id = p_request_control_id;

229: from wsh_itm_response_headers
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:

Line 298: from wsh_itm_response_headers

294:
295: /*delete from wsh_itm_response_lines where response_header_id IN
296: (
297: select response_header_id
298: from wsh_itm_response_headers
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;

Line 302: -- delete from wsh_itm_response_headers where request_control_id = p_request_control_id;

298: from wsh_itm_response_headers
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