1. 1
2. 2
3. 3
4. 4
5. 5
6. 6
7. 7
8. 8
9. 9
10. 10
11. 11
12. 12
13. 13
14. 14
15. 15
16. 16
17. 17
18. 18
19. 19
20. 20
21. 21
22. 22
23. 23
24. 24
25. 25
26. 26
27. 27
28. 28
29. 29
30. 30
31. 31
32. 32
33. 33
34. 34

/* Ask Dian for changing this enormous DECODE */
      sprintf( ranges_sort_condition,
               "DECODE(CONTRACT_ID, '%s', 1, 0) + "
               "DECODE(ISS_INST, '%s', 2, 0) + "
               "DECODE(ACQ_INST, '%s', 4, 0) + "
               "DECODE(ISS_BIN, '%s', 8, 0) + "
               "DECODE(TERM_TYPE, %d, 16, 0) + "
               "DECODE(IS_PRIMARY_CARD, %d, 32, 0), "
               "  0,  1,  64,  2,  32,  3,  16,  4,   4,  5,   8,  6,  96,  7,  80,  8,"
               " 68,  9,  72, 10,  40, 11,  24, 12,  12, 13,   2, 14,  10, 15,  48, 16,"
               " 36, 17, 104, 18,  88, 19,  76, 20,  66, 21,  74, 22, 112, 23, 100, 24,"
               " 56, 25,  44, 26,  34, 27,  42, 28,  20, 29,  28, 30,  18, 31,   6, 32,"
               " 26, 33,  14, 34,  52, 35,  60, 36, 124, 37,  50, 38,  38, 39,  22, 40,"
               "118, 41, 122, 42, 110, 43,  94, 44, 126, 45,   1, 46,  65, 47,  97, 48,"
               " 81, 49,   5, 50,  73, 51, 105, 52,  89, 53,  77, 54,  67, 55,  75, 56,"
               "113, 57, 121, 58, 101, 59, 109, 60,  99, 61, 107, 62,  85, 63,  93, 64,"
               " 83, 65,  71, 66,  91, 67,  79, 68, 117, 69, 125, 70, 115, 71, 103, 72,"
               " 87, 73, 119, 74,  59, 75,  47, 76,  95, 77,  63, 78, 127, 79, 999",
               "-1", DEFAULT_INST_ID, DEFAULT_INST_ID, "-1", TERM_TYPE_DEF, IS_PRIMARY_DEF );

      ora_sql_stmt_buff.len = sprintf( (char*)ora_sql_stmt_buff.arr, 
                                       "SELECT ACQ_INST, "
                                       "       ISS_INST, "
                                       "       ISS_BIN,  "
                                       "       TERM_TYPE, "
                                       "       MSGTYPE,  "
                                       "       TASK,     "
                                       "       REVERSAL, "
                                       "       CONTRACT_ID, "
                                       "       IS_PRIMARY_CARD, "
                                       "       TMPL_ID   "
                                       "  FROM T_TRANS_AUTH_ALG "
                                       " WHERE TRANS_TYPE = :ora_trans_type "
                                       " ORDER BY DECODE(%s)", ranges_sort_condition );