APPS.WSH_ITM_RESPONSE_PKG dependencies on WSH_ITM_RESPONSE_RULES

Line 19: p_fetch_interpreted_code IN WSH_ITM_RESPONSE_RULES.INTERPRETED_VALUE_CODE%TYPE,

15: -- x_interpreted_code Interpreted code to be returned
16:
17: PROCEDURE INTERPRET_ERROR
18: (
19: p_fetch_interpreted_code IN WSH_ITM_RESPONSE_RULES.INTERPRETED_VALUE_CODE%TYPE,
20: x_interpreted_code IN OUT NOCOPY WSH_ITM_RESPONSE_RULES.INTERPRETED_VALUE_CODE%TYPE
21: ) IS
22:
23: BEGIN

Line 20: x_interpreted_code IN OUT NOCOPY WSH_ITM_RESPONSE_RULES.INTERPRETED_VALUE_CODE%TYPE

16:
17: PROCEDURE INTERPRET_ERROR
18: (
19: p_fetch_interpreted_code IN WSH_ITM_RESPONSE_RULES.INTERPRETED_VALUE_CODE%TYPE,
20: x_interpreted_code IN OUT NOCOPY WSH_ITM_RESPONSE_RULES.INTERPRETED_VALUE_CODE%TYPE
21: ) IS
22:
23: BEGIN
24: --Bug9277386:In response classification, an Error can be classified as 'FAILURE'.

Line 44: l_fetch_interpreted_code WSH_ITM_RESPONSE_RULES.INTERPRETED_VALUE_CODE%TYPE;

40: x_return_status OUT NOCOPY VARCHAR2
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;

Line 66: WSH_ITM_RESPONSE_RULES WRR

62: wrh.EXPORT_COMPLIANCE_STATUS,
63: wrh.SERVICE_TYPE_CODE
64: FROM WSH_ITM_REQUEST_CONTROL WRC,
65: WSH_ITM_RESPONSE_HEADERS WRH,
66: WSH_ITM_RESPONSE_RULES WRR
67: WHERE wrc.request_control_id = req_control_id
68: AND wrc.response_header_id = wrh.response_header_id
69: AND nvl(wrh.error_code,-99) = nvl(wrr.error_code,nvl(wrh.error_code,-99))
70: AND wrh.error_type = wrr.error_type(+)

Line 88: FROM WSH_ITM_RESPONSE_RULES

84:
85: CURSOR Get_Interpreted_code(p_error_code VARCHAR2, p_error_type VARCHAR2,
86: p_vendor_id NUMBER) IS
87: SELECT interpreted_value_code
88: FROM WSH_ITM_RESPONSE_RULES
89: WHERE error_type = p_error_type
90: AND nvl(error_code,-99) = nvl(p_error_code,nvl(error_code,-99))
91: AND vendor_id = p_vendor_id
92: ORDER BY error_code;