APPS.WSH_CC_RESPONSE_PKG dependencies on WSH_GTC_RESPONSE_RULES

Line 20: fetch_interpreted_code IN WSH_GTC_RESPONSE_RULES.INTERPRETED_VALUE_CODE%TYPE,

16: -- fetch_interpreted_code Interpreted code got from the rule
17: -- interpreted_code Interpreted code to be returned
18:
19: PROCEDURE INTERPRET_ERROR (
20: fetch_interpreted_code IN WSH_GTC_RESPONSE_RULES.INTERPRETED_VALUE_CODE%TYPE,
21: interpreted_code IN OUT WSH_GTC_RESPONSE_RULES.INTERPRETED_VALUE_CODE%TYPE)
22: IS
23: interpreted_string VARCHAR2(30);
24: BEGIN

Line 21: interpreted_code IN OUT WSH_GTC_RESPONSE_RULES.INTERPRETED_VALUE_CODE%TYPE)

17: -- interpreted_code Interpreted code to be returned
18:
19: PROCEDURE INTERPRET_ERROR (
20: fetch_interpreted_code IN WSH_GTC_RESPONSE_RULES.INTERPRETED_VALUE_CODE%TYPE,
21: interpreted_code IN OUT WSH_GTC_RESPONSE_RULES.INTERPRETED_VALUE_CODE%TYPE)
22: IS
23: interpreted_string VARCHAR2(30);
24: BEGIN
25: IF(fetch_interpreted_code = SYSTEM_ERROR) THEN

Line 52: fetch_interpreted_code WSH_GTC_RESPONSE_RULES.INTERPRETED_VALUE_CODE%TYPE;

48: response_header_id IN NUMBER,
49: result_status OUT t_result_status_rec)
50: IS
51:
52: fetch_interpreted_code WSH_GTC_RESPONSE_RULES.INTERPRETED_VALUE_CODE%TYPE;
53: fetch_error_code WSH_CC_RESPONSE_LINES.ERROR_CODE%TYPE;
54: fetch_error_type WSH_CC_RESPONSE_LINES.ERROR_TYPE%TYPE;
55: response_hdr_id NUMBER;
56:

Line 59: FROM WSH_CC_TRANS_CONTROL c, WSH_GTC_RESPONSE_RULES r

55: response_hdr_id NUMBER;
56:
57: CURSOR Get_Response_Header( trans_control_id NUMBER) IS
58: SELECT response_header_id, c.error_code, interpreted_value_code
59: FROM WSH_CC_TRANS_CONTROL c, WSH_GTC_RESPONSE_RULES r
60: WHERE transaction_control_id = trans_control_id and c.error_code = r.error_code(+) ;
61:
62:
63: CURSOR Get_Response_Line_Details( resp_header_id NUMBER) IS

Line 71: FROM WSH_GTC_RESPONSE_RULES

67: WHERE response_header_id = resp_header_id;
68:
69: CURSOR Get_Interpreted_code(p_error_code VARCHAR2, p_error_type VARCHAR2) IS
70: SELECT interpreted_value_code
71: FROM WSH_GTC_RESPONSE_RULES
72: WHERE error_type = p_error_type and nvl(error_code,p_error_code) = p_error_code
73: ORDER BY error_code;
74:
75: BEGIN