APPS.WSH_ITM_ASYN_MSGMAP_ASSISTANT dependencies on DUAL

Line 118: SELECT WSH_ITM_RESPONSE_HEADERS_S.NEXTVAL INTO l_response_header_id FROM DUAL;

114: IF (l_reqclrt_id IS NULL) THEN
115:
116:
117: BEGIN
118: SELECT WSH_ITM_RESPONSE_HEADERS_S.NEXTVAL INTO l_response_header_id FROM DUAL;
119: INSERT INTO WSH_ITM_RESPONSE_HEADERS
120: (
121: RESPONSE_HEADER_ID,
122: REQUEST_CONTROL_ID,

Line 168: SELECT WSH_ITM_RESPONSE_HEADERS_S.NEXTVAL INTO l_response_header_id FROM DUAL;

164: ELSE
165:
166: BEGIN
167:
168: SELECT WSH_ITM_RESPONSE_HEADERS_S.NEXTVAL INTO l_response_header_id FROM DUAL;
169: INSERT INTO WSH_ITM_RESPONSE_HEADERS
170: (
171: RESPONSE_HEADER_ID,
172: REQUEST_CONTROL_ID,

Line 465: x_response_header_id FROM DUAL;

461: END;
462:
463: IF x_response_header_id IS NULL THEN
464: SELECT WSH_ITM_RESPONSE_HEADERS_S.NEXTVAL INTO
465: x_response_header_id FROM DUAL;
466: x_create_resp_hdr := 1;
467: ELSE
468: x_create_resp_hdr := NULL;
469: END IF;