APPS.WSH_CC_RESPONSE_PKG dependencies on WSH_CC_RESPONSE_LINES

Line 53: fetch_error_code WSH_CC_RESPONSE_LINES.ERROR_CODE%TYPE;

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:
57: CURSOR Get_Response_Header( trans_control_id NUMBER) IS

Line 54: fetch_error_type WSH_CC_RESPONSE_LINES.ERROR_TYPE%TYPE;

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:
57: CURSOR Get_Response_Header( trans_control_id NUMBER) IS
58: SELECT response_header_id, c.error_code, interpreted_value_code

Line 66: FROM WSH_CC_RESPONSE_LINES l

62:
63: CURSOR Get_Response_Line_Details( resp_header_id NUMBER) IS
64: SELECT l.error_code error_code, l.error_type error_type,
65: denied_party_flag, embargo_flag, license_required
66: FROM WSH_CC_RESPONSE_LINES l
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