APPS.WSH_ITM_RESPONSE_PKG dependencies on WSH_ITM_RESPONSE_LINES

Line 43: l_fetch_error_code WSH_ITM_RESPONSE_LINES.ERROR_CODE%TYPE;

39: )
40: IS
41:
42: l_fetch_interpreted_code WSH_ITM_RESPONSE_RULES.INTERPRETED_VALUE_CODE%TYPE;
43: l_fetch_error_code WSH_ITM_RESPONSE_LINES.ERROR_CODE%TYPE;
44: l_fetch_error_type WSH_ITM_RESPONSE_LINES.ERROR_TYPE%TYPE;
45: l_response_hdr_id NUMBER;
46: l_vendor_id NUMBER;
47: l_sql_error VARCHAR2(2000);

Line 44: l_fetch_error_type WSH_ITM_RESPONSE_LINES.ERROR_TYPE%TYPE;

40: IS
41:
42: l_fetch_interpreted_code WSH_ITM_RESPONSE_RULES.INTERPRETED_VALUE_CODE%TYPE;
43: l_fetch_error_code WSH_ITM_RESPONSE_LINES.ERROR_CODE%TYPE;
44: l_fetch_error_type WSH_ITM_RESPONSE_LINES.ERROR_TYPE%TYPE;
45: l_response_hdr_id NUMBER;
46: l_vendor_id NUMBER;
47: l_sql_error VARCHAR2(2000);
48: --AJPRABHA - Modified service_type to VARCHAR(30)

Line 79: FROM WSH_ITM_RESPONSE_LINES

75: error_type error_type,
76: denied_party_flag,
77: embargo_flag,
78: service_type_code
79: FROM WSH_ITM_RESPONSE_LINES
80: WHERE response_header_id = resp_header_id
81: ORDER BY service_type_code;
82:
83: CURSOR Get_Interpreted_code(p_error_code VARCHAR2, p_error_type VARCHAR2,

Line 256: WSH_ITM_RESPONSE_LINES wrl,

252: DISTINCT wrc.request_control_id
253: FROM
254: WSH_ITM_REQUEST_CONTROL wrc,
255: WSH_ITM_RESPONSE_HEADERS wrh,
256: WSH_ITM_RESPONSE_LINES wrl,
257: WSH_ITM_PARTIES wp
258: WHERE
259: wrc.response_header_id = wrh.response_header_id
260: AND wrh.response_header_id = wrl.response_header_id