1121: end if;
1122: end if;
1123:
1124: if display_text is null then
1125: display_text := htf.br;
1126: end if;
1127: if display_text = '-' then
1128: display_text := htf.br;
1129: end if;
1124: if display_text is null then
1125: display_text := htf.br;
1126: end if;
1127: if display_text = '-' then
1128: display_text := htf.br;
1129: end if;
1130: if display_text = 'null' then
1131: display_text := htf.br;
1132: end if;
1127: if display_text = '-' then
1128: display_text := htf.br;
1129: end if;
1130: if display_text = 'null' then
1131: display_text := htf.br;
1132: end if;
1133: if display_text = '-1' then
1134: display_text := htf.br;
1135: end if;
1130: if display_text = 'null' then
1131: display_text := htf.br;
1132: end if;
1133: if display_text = '-1' then
1134: display_text := htf.br;
1135: end if;
1136:
1137:
1138:
1136:
1137:
1138:
1139: if ak_query_pkg.g_items_table(i).bold = 'Y' then
1140: display_text := htf.bold(display_text);
1141: end if;
1142: --Italics
1143: if ak_query_pkg.g_items_table(i).italic = 'Y' then
1144: display_text := htf.italic(display_text);
1140: display_text := htf.bold(display_text);
1141: end if;
1142: --Italics
1143: if ak_query_pkg.g_items_table(i).italic = 'Y' then
1144: display_text := htf.italic(display_text);
1145: end if;
1146:
1147: temp_table(0) := temp_table(0) ||
1148: htf.tableData( cvalue => display_text,
1144: display_text := htf.italic(display_text);
1145: end if;
1146:
1147: temp_table(0) := temp_table(0) ||
1148: htf.tableData( cvalue => display_text,
1149: calign => ak_query_pkg.g_items_table(i).horizontal_alignment,
1150: crowspan => '2',
1151: cattributes => ' VALIGN=' || ak_query_pkg.g_items_table(i).vertical_alignment
1152: );
1153: end if;
1154: end loop; -- for i in 1 .. ak_query_pkg.g_items_table.first loop
1155:
1156: --close the table row
1157: temp_table(0) := temp_table(0) || htf.tableRowClose;
1158: if v_qty_flag then
1159: --print the down button
1160: display_text := htf.tableRowOpen( cattributes => 'BGColor="#'||icx_util.get_color('TABLE_DATA_MULTIROW')||'"');
1161: display_text := display_text || '
1156: --close the table row
1157: temp_table(0) := temp_table(0) || htf.tableRowClose;
1158: if v_qty_flag then
1159: --print the down button
1160: display_text := htf.tableRowOpen( cattributes => 'BGColor="#'||icx_util.get_color('TABLE_DATA_MULTIROW')||'"');
1161: display_text := display_text || '
1161: display_text := display_text || '