APPS.WSH_ITM_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 53

                         SELECT RL.EXPORT_COMPLIANCE_TYPE COMPL_TYPE,
                                DECODE(RL.EXPORT_COMPLIANCE_SUCCESS, 'Y', 'COMPLIANT', 'N', 'NOT_COMPLIANT') COMPL_STATUS,
                                RL.EXPORT_COMPLIANCE_DESCRIPTION COMPL_DESC,
                                RL.ERROR_CODE ERROR_CODE,
                                RL.ERROR_TYPE ERROR_TYPE,
                                RL.ERROR_TEXT ERROR_TEXT
                         FROM   WSH_ITM_RESPONSE_HEADERS RH,
                                WSH_ITM_RESPONSE_LINES RL,
                                WSH_ITM_REQUEST_CONTROL  REQ
                         WHERE
                                REQ.REQUEST_CONTROL_ID = p_req_ctrl_id  AND
                                REQ.RESPONSE_HEADER_ID = RH.RESPONSE_HEADER_ID AND
                                RH.RESPONSE_HEADER_ID = RL.RESPONSE_HEADER_ID AND
                                UPPER(RH.EXPORT_COMPLIANCE_STATUS) = p_status;

Line: 112

                SELECT PROCESS_FLAG INTO L_PROCESS_FLAG
                FROM WSH_ITM_REQUEST_CONTROL
                WHERE REQUEST_CONTROL_ID = P_REQUEST_CONTROL_ID;

Line: 121

                        SELECT  WE.EXCEPTION_LOCATION_ID,
                                WE.DELIVERY_ID,
                                WE.DELIVERY_NAME,
                                WE.EXCEPTION_ID,
                                IRC.TRIGGERING_POINT,
                                WE.STATUS,
				IRC.ORGANIZATION_ID
                        INTO    l_location_id,
                                l_delivery_id,
                                l_delivery_name,
                                l_exception_id,
                                l_event_name,
                                l_old_status,
				l_organization_id
                        FROM    WSH_EXCEPTIONS WE ,
                                WSH_ITM_REQUEST_CONTROL IRC
                        WHERE WE.DELIVERY_ID =  IRC.ORIGINAL_SYSTEM_REFERENCE
                        AND  WE.EXCEPTION_NAME = DECODE(IRC.TRIGGERING_POINT,G_PICK_RELEASE_EVENT,G_SUB_PICK_RELEASE_EXCEPTION,G_SHIP_CONFIRM_EVENT,G_SUB_SHIP_CONFIRM_EXCEPTION)
                        AND  IRC.REQUEST_CONTROL_ID = P_REQUEST_CONTROL_ID
			AND WE.STATUS <> 'CLOSED';

Line: 226

	/*		delete from wsh_itm_response_lines where response_header_id IN
                        (
                                select response_header_id
                                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;

Line: 234

	                delete from wsh_itm_request_control  where request_control_id = p_request_control_id;    */

Line: 295

               /*delete from wsh_itm_response_lines where response_header_id IN
                        (
                                select response_header_id
                                from wsh_itm_response_headers
                                where  request_control_id   = p_request_control_id
                        );