PROCEDURE get_call_data_record(p_originating  IN call_data_record.originating_number%TYPE,
                               p_called       IN call_data_record.called_number%TYPE,
                               p_billing_code IN call_data_record.billing_code%TYPE,
                               p_date_from    IN call_data_record.call_start_time%TYPE,
                               p_date_to      IN call_data_record.call_start_time%TYPE,
                               cur_out        OUT SYS_REFCURSOR,
                               result_code    OUT nts_result_code.code%TYPE) IS
 BEGIN
  result_code := 0;
  OPEN cur_out FOR
    SELECT * FROM call_data_record cdr
     WHERE (cdr.originating_number = p_originating OR p_originating IS NULL)
       AND (cdr.called_number = p_called OR p_called IS NULL)
       AND (cdr.billing_code = p_billing_code OR p_billing_code IS NULL)
       AND (cdr.call_start_time BETWEEN p_date_from AND p_date_to OR p_date_from IS NULL OR p_date_to IS NULL)
       AND ROWNUM < 5;

  END get_call_data_record;