APPS.WSH_ITM_RESPONSE_PKG dependencies on WSH_ITM_RESPONSE_LINES

Line 45: l_fetch_error_code WSH_ITM_RESPONSE_LINES.ERROR_CODE%TYPE;

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

Line 46: l_fetch_error_type WSH_ITM_RESPONSE_LINES.ERROR_TYPE%TYPE;

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

Line 81: FROM WSH_ITM_RESPONSE_LINES

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

Line 265: WSH_ITM_RESPONSE_LINES wrl,

261: DISTINCT wrc.request_control_id
262: FROM
263: WSH_ITM_REQUEST_CONTROL wrc,
264: WSH_ITM_RESPONSE_HEADERS wrh,
265: WSH_ITM_RESPONSE_LINES wrl,
266: WSH_ITM_PARTIES wp
267: WHERE
268: wrc.response_header_id = wrh.response_header_id
269: AND wrh.response_header_id = wrl.response_header_id