APPS.WSH_ITM_RESPONSE_PKG dependencies on WSH_ITM_REQUEST_CONTROL

Line 62: FROM WSH_ITM_REQUEST_CONTROL WRC,

58: wrh.error_code,
59: wrr.interpreted_value_code,
60: wrh.EXPORT_COMPLIANCE_STATUS,
61: wrh.SERVICE_TYPE_CODE
62: FROM WSH_ITM_REQUEST_CONTROL WRC,
63: WSH_ITM_RESPONSE_HEADERS WRH,
64: WSH_ITM_RESPONSE_RULES WRR
65: WHERE wrc.request_control_id = req_control_id
66: AND wrc.response_header_id = wrh.response_header_id

Line 215: UPDATE wsh_itm_request_control

211:
212: END LOOP;
213:
214: IF x_interpreted_value = SUCCESS THEN
215: UPDATE wsh_itm_request_control
216: SET process_flag = 1
217: WHERE request_control_id = p_request_control_id;
218: END IF;
219:

Line 241: WSH_ITM_REQUEST_CONTROL wrc,

237: CURSOR Get_Request_Control IS
238: SELECT
239: DISTINCT wrc.request_control_id
240: FROM
241: WSH_ITM_REQUEST_CONTROL wrc,
242: WSH_ITM_RESPONSE_HEADERS wrh,
243: WSH_ITM_PARTIES wp
244: WHERE
245: wrc.response_header_id = wrh.response_header_id

Line 254: WSH_ITM_REQUEST_CONTROL wrc,

250: UNION
251: SELECT
252: DISTINCT wrc.request_control_id
253: FROM
254: WSH_ITM_REQUEST_CONTROL wrc,
255: WSH_ITM_RESPONSE_HEADERS wrh,
256: WSH_ITM_RESPONSE_LINES wrl,
257: WSH_ITM_PARTIES wp
258: WHERE