DBA Data[Home] [Help]

APPS.WSH_ITM_PKG dependencies on WSH_ITM_RESPONSE_LINES

Line 60: WSH_ITM_RESPONSE_LINES RL,

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
64: REQ.RESPONSE_HEADER_ID = RH.RESPONSE_HEADER_ID AND

Line 226: /* delete from wsh_itm_response_lines where response_header_id IN

222:
223: --Bug 6371639: NO AUDIT TRAIL PROVIDED FOR SHIPMENTS SCREENED BY ITM FOR SUCCESSFULLY SCREENED REQUEST.
224: -- Commenting the below Delete Statements to retain the Records in WSH_ITM tables
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

Line 295: /*delete from wsh_itm_response_lines where response_header_id IN

291: ----------------------------------------------------------------------------------------
292: -- Purges the data in ITM Request and Response Tables
293: ----------------------------------------------------------------------------------------
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