DBA Data[Home] [Help]

APPS.WSH_ITM_PKG dependencies on WSH_ITM_RESPONSE_LINES

Line 62: WSH_ITM_RESPONSE_LINES RL,

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
66: REQ.REQUEST_CONTROL_ID = p_req_ctrl_id AND

Line 232: /* delete from wsh_itm_response_lines where response_header_id IN

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

Line 282: /*delete from wsh_itm_response_lines where response_header_id IN

278: ----------------------------------------------------------------------------------------
279: -- Purges the data in ITM Request and Response Tables
280: ----------------------------------------------------------------------------------------
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