APPS.WSH_ITM_ASYN_MSGMAP_ASSISTANT dependencies on WSH_ITM_REQUEST_CONTROL

Line 50: --UPDATING TABLE WSH_ITM_REQUEST_CONTROL WITH RESPECTIVE

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

Line 53: UPDATE WSH_ITM_REQUEST_CONTROL SET

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

Line 158: UPDATE WSH_ITM_REQUEST_CONTROL SET

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

Line 208: UPDATE WSH_ITM_REQUEST_CONTROL SET

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

Line 358: UPDATE WSH_ITM_REQUEST_CONTROL

354: loop
355: l_reqclrt_id := substr(l_reqclrt_ids, 0, (instr(l_reqclrt_ids, '-')-1));
356: IF (l_reqclrt_id IS NULL) THEN
357:
358: UPDATE WSH_ITM_REQUEST_CONTROL
359: SET PROCESS_FLAG = -4
360: WHERE REQUEST_CONTROL_ID = l_reqclrt_ids
361: AND PROCESS_FLAG IN (-2, -3);
362: EXIT;

Line 364: UPDATE WSH_ITM_REQUEST_CONTROL

360: WHERE REQUEST_CONTROL_ID = l_reqclrt_ids
361: AND PROCESS_FLAG IN (-2, -3);
362: EXIT;
363: ELSE
364: UPDATE WSH_ITM_REQUEST_CONTROL
365: SET PROCESS_FLAG = -4
366: WHERE REQUEST_CONTROL_ID = l_reqclrt_id
367: AND PROCESS_FLAG IN (-2, -3);
368: END IF;

Line 455: FROM WSH_ITM_REQUEST_CONTROL

451: --
452: BEGIN
453:
454: SELECT RESPONSE_HEADER_ID INTO x_response_header_id
455: FROM WSH_ITM_REQUEST_CONTROL
456: WHERE REQUEST_CONTROL_ID = p_request_control_id
457: AND ROWNUM < 2;
458: EXCEPTION
459: WHEN NO_DATA_FOUND THEN

Line 527: FROM WSH_ITM_REQUEST_CONTROL

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

Line 540: FROM WSH_ITM_REQUEST_CONTROL

536: SELECT REQUEST_SET_ID,
537: APPLICATION_ID
538: INTO l_request_set_id,
539: l_application_id
540: FROM WSH_ITM_REQUEST_CONTROL
541: WHERE REQUEST_CONTROL_ID = l_reqclrt_id;
542:
543: WSH_ITM_POST_PROCESS_HANDLER.CHECK_PENDING_CALL_API(l_reqclrt_id,
544: l_request_set_id,

Line 597: FROM WSH_ITM_REQUEST_CONTROL

593: SELECT NVL(REQUEST_SET_ID, 0),
594: APPLICATION_ID
595: INTO l_request_set_id,
596: l_application_id
597: FROM WSH_ITM_REQUEST_CONTROL
598: WHERE REQUEST_CONTROL_ID = p_reqCtrlID;
599:
600: WSH_ITM_POST_PROCESS_HANDLER.CHECK_PENDING_CALL_API(p_reqCtrlID,
601: l_request_set_id,