APPS.WSH_ITM_ASYN_MSGMAP_ASSISTANT dependencies on DUAL

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

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

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

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

Line 456: x_response_header_id FROM DUAL;

452: END;
453:
454: IF x_response_header_id IS NULL THEN
455: SELECT WSH_ITM_RESPONSE_HEADERS_S.NEXTVAL INTO
456: x_response_header_id FROM DUAL;
457: x_create_resp_hdr := 1;
458: ELSE
459: x_create_resp_hdr := NULL;
460: END IF;

Line 778: FROM dual;

774: --
775: SELECT Decode(InStr(p_reference_id, '-' ||p_request_ctrl_id),0, REPLACE(p_reference_id, p_request_ctrl_id||'-', ''),REPLACE(p_reference_id, '-'||p_request_ctrl_id, '') )
776: INTO
777: l_reference_id
778: FROM dual;
779:
780: IF l_debug_on THEN
781: WSH_DEBUG_SV.Log(l_module_name, 'New p_reference_id',l_reference_id);
782: WSH_DEBUG_SV.pop(l_module_name);