APPS.WSH_ITM_RESUBMIT dependencies on WSH_ITM_REQUEST_CONTROL

Line 59: FROM WSH_ITM_REQUEST_CONTROL

55:
56: cursor triggering_point(c_request_control_id number) is
57: SELECT DISTINCT
58: TRIGGERING_POINT
59: FROM WSH_ITM_REQUEST_CONTROL
60: WHERE request_control_id= c_request_control_id;
61:
62: cursor delivery_resubmit(c_request_control_id number) is
63: SELECT

Line 67: wsh_itm_request_control wrc

63: SELECT
64: exception_id,status,logged_at_location_id,exception_location_id,DELIVERY_ID,delivery_name
65: FROM
66: wsh_exceptions wex,
67: wsh_itm_request_control wrc
68: WHERE
69: wrc.original_system_reference =wex.delivery_id
70: AND wex.exception_name LIKE 'WSH_EXPORT_COMPL_FAILED' AND WEX.STATUS='OPEN'
71: AND WRC.REQUEST_CONTROL_ID = C_REQUEST_CONTROL_ID

Line 164: /* UPDATE wsh_itm_request_control

160: );
161:
162: WSH_UTIL_CORE.println('End of Call Shipping');
163:
164: /* UPDATE wsh_itm_request_control
165: SET process_flag = 0,
166: response_header_id = NULL
167: WHERE request_control_id = p_request_control_id;
168: */

Line 194: -- WSH_ITM_REQUEST_CONTROL, WSH_ITM_RESPONSE_HEADERS

190: -- Name
191: -- Resubmit_Requests
192: -- Purpose
193: -- This procedure selects all the eligible records from the tables
194: -- WSH_ITM_REQUEST_CONTROL, WSH_ITM_RESPONSE_HEADERS
195: -- and WSH_ITM_RESPONSE_LINES for Resubmit.
196: -- For every record, it first updates the process_flag in the table
197: -- WSH_ITM_REQUEST_CONTROL to 0, meaning RESUBMIT
198: --

Line 197: -- WSH_ITM_REQUEST_CONTROL to 0, meaning RESUBMIT

193: -- This procedure selects all the eligible records from the tables
194: -- WSH_ITM_REQUEST_CONTROL, WSH_ITM_RESPONSE_HEADERS
195: -- and WSH_ITM_RESPONSE_LINES for Resubmit.
196: -- For every record, it first updates the process_flag in the table
197: -- WSH_ITM_REQUEST_CONTROL to 0, meaning RESUBMIT
198: --
199: -- Arguments
200: -- ERRBUF Required by Concurrent Processing.
201: -- RETCODE Required by Concurrent Processing.

Line 262: WSH_ITM_REQUEST_CONTROL wrc,

258: CURSOR Get_Request_Control_ship IS
259: SELECT DISTINCT
260: wrc.request_control_id
261: FROM
262: WSH_ITM_REQUEST_CONTROL wrc,
263: WSH_ITM_RESPONSE_HEADERS wrh
264: WHERE
265: wrc.response_header_id = wrh.response_header_id
266: AND nvl(wrh.vendor_id,-99) = nvl(p_vendor_id, nvl(wrh.vendor_id,-99))

Line 305: 'FROM WSH_ITM_REQUEST_CONTROL wrc '||

301:
302: IF p_application_id = 660 THEN --{
303:
304: l_sql_string := 'SELECT DISTINCT wrc.request_control_id '||
305: 'FROM WSH_ITM_REQUEST_CONTROL wrc '||
306: ', WSH_ITM_RESPONSE_HEADERS wrh '||
307: ', OE_ORDER_HEADERS_ALL oh ';
308:
309: IF (p_party_type IS NOT NULL) OR (p_party_id IS NOT NULL) THEN

Line 343: ' FROM WSH_ITM_REQUEST_CONTROL wrc '||

339: END IF;
340: END IF;
341: l_sql_string := l_sql_string || ' UNION '||
342: ' SELECT DISTINCT wrc.request_control_id '||
343: ' FROM WSH_ITM_REQUEST_CONTROL wrc '||
344: ' , WSH_ITM_RESPONSE_HEADERS wrh '||
345: ' , WSH_ITM_RESPONSE_LINES wrl '||
346: ' , OE_ORDER_LINES_ALL ol ';
347: IF (p_party_type IS NOT NULL) OR (p_party_id IS NOT NULL) THEN

Line 493: UPDATE wsh_itm_request_control

489: --------------------------------
490: -- Update the Process Flag to 0
491: --------------------------------
492:
493: UPDATE wsh_itm_request_control
494: SET process_flag = 0,
495: response_header_id = NULL
496: WHERE request_control_id = l_request_control_id;
497: