APPS.WSH_ITM_ASYN_MSGMAP_ASSISTANT dependencies on WSH_ITM_RESPONSE_HEADERS

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 119: INSERT INTO WSH_ITM_RESPONSE_HEADERS

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,
123: VENDOR_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 169: INSERT INTO WSH_ITM_RESPONSE_HEADERS

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,
173: VENDOR_ID,

Line 464: SELECT WSH_ITM_RESPONSE_HEADERS_S.NEXTVAL INTO

460: x_response_header_id := NULL;
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;