APPS.WSH_ITM_ASYN_MSGMAP_ASSISTANT dependencies on WSH_ITM_REQUEST_CONTROL

Line 49: --UPDATING TABLE WSH_ITM_REQUEST_CONTROL WITH RESPECTIVE

45: WSH_DEBUG_SV.Log(l_module_name, 'p_response_header_id', p_response_header_id );
46: WSH_DEBUG_SV.Log(l_module_name, 'p_process_flag', p_process_flag );
47: END IF;
48:
49: --UPDATING TABLE WSH_ITM_REQUEST_CONTROL WITH RESPECTIVE
50: -- RESPONSE_HEADER_ID and PROCESS_FLAG
51:
52: UPDATE WSH_ITM_REQUEST_CONTROL SET
53: RESPONSE_HEADER_ID = p_response_header_id,

Line 52: UPDATE WSH_ITM_REQUEST_CONTROL SET

48:
49: --UPDATING TABLE WSH_ITM_REQUEST_CONTROL WITH RESPECTIVE
50: -- RESPONSE_HEADER_ID and PROCESS_FLAG
51:
52: UPDATE WSH_ITM_REQUEST_CONTROL SET
53: RESPONSE_HEADER_ID = p_response_header_id,
54: PROCESS_FLAG = p_process_flag
55: WHERE REQUEST_CONTROL_ID = p_request_control_id;
56: --

Line 156: UPDATE WSH_ITM_REQUEST_CONTROL SET

152: WHEN OTHERS THEN
153: NULL;
154: END;
155:
156: UPDATE WSH_ITM_REQUEST_CONTROL SET
157: PROCESS_FLAG = 2,
158: RESPONSE_HEADER_ID = l_response_header_id
159: WHERE REQUEST_CONTROL_ID=l_reqclrt_ids;
160:

Line 206: UPDATE WSH_ITM_REQUEST_CONTROL SET

202: WHEN OTHERS THEN
203: NULL;
204: END;
205:
206: UPDATE WSH_ITM_REQUEST_CONTROL SET
207: PROCESS_FLAG = 2,
208: RESPONSE_HEADER_ID = l_response_header_id
209: WHERE REQUEST_CONTROL_ID = l_reqclrt_id;
210:

Line 351: UPDATE WSH_ITM_REQUEST_CONTROL

347: loop
348: l_reqclrt_id := substr(l_reqclrt_ids, 0, (instr(l_reqclrt_ids, '-')-1));
349: IF (l_reqclrt_id IS NULL) THEN
350:
351: UPDATE WSH_ITM_REQUEST_CONTROL
352: SET PROCESS_FLAG = -4
353: WHERE REQUEST_CONTROL_ID = l_reqclrt_ids
354: AND PROCESS_FLAG IN (-2, -3);
355: EXIT;

Line 357: UPDATE WSH_ITM_REQUEST_CONTROL

353: WHERE REQUEST_CONTROL_ID = l_reqclrt_ids
354: AND PROCESS_FLAG IN (-2, -3);
355: EXIT;
356: ELSE
357: UPDATE WSH_ITM_REQUEST_CONTROL
358: SET PROCESS_FLAG = -4
359: WHERE REQUEST_CONTROL_ID = l_reqclrt_id
360: AND PROCESS_FLAG IN (-2, -3);
361: END IF;

Line 446: FROM WSH_ITM_REQUEST_CONTROL

442: --
443: BEGIN
444:
445: SELECT RESPONSE_HEADER_ID INTO x_response_header_id
446: FROM WSH_ITM_REQUEST_CONTROL
447: WHERE REQUEST_CONTROL_ID = p_request_control_id
448: AND ROWNUM < 2;
449: EXCEPTION
450: WHEN NO_DATA_FOUND THEN

Line 517: FROM WSH_ITM_REQUEST_CONTROL

513: SELECT REQUEST_SET_ID,
514: APPLICATION_ID
515: INTO l_request_set_id,
516: l_application_id
517: FROM WSH_ITM_REQUEST_CONTROL
518: WHERE REQUEST_CONTROL_ID = l_reqclrt_id;
519:
520: WSH_ITM_POST_PROCESS_HANDLER.CHECK_PENDING_CALL_API(l_reqclrt_id,
521: l_request_set_id,

Line 530: FROM WSH_ITM_REQUEST_CONTROL

526: SELECT REQUEST_SET_ID,
527: APPLICATION_ID
528: INTO l_request_set_id,
529: l_application_id
530: FROM WSH_ITM_REQUEST_CONTROL
531: WHERE REQUEST_CONTROL_ID = l_reqclrt_id;
532:
533: WSH_ITM_POST_PROCESS_HANDLER.CHECK_PENDING_CALL_API(l_reqclrt_id,
534: l_request_set_id,

Line 586: FROM WSH_ITM_REQUEST_CONTROL

582: SELECT NVL(REQUEST_SET_ID, 0),
583: APPLICATION_ID
584: INTO l_request_set_id,
585: l_application_id
586: FROM WSH_ITM_REQUEST_CONTROL
587: WHERE REQUEST_CONTROL_ID = p_reqCtrlID;
588:
589: WSH_ITM_POST_PROCESS_HANDLER.CHECK_PENDING_CALL_API(p_reqCtrlID,
590: l_request_set_id,