1001: display_text := y_table(ak_query_pkg.g_items_table(i).value_id);
1002: END IF;
1003:
1004: IF display_text is null THEN
1005: display_text := htf.br;
1006: END IF;
1007: IF display_text = '-' THEN
1008: display_text := htf.br;
1009: END IF;
1004: IF display_text is null THEN
1005: display_text := htf.br;
1006: END IF;
1007: IF display_text = '-' THEN
1008: display_text := htf.br;
1009: END IF;
1010: IF display_text = 'null' THEN
1011: display_text := htf.br;
1012: END IF;
1007: IF display_text = '-' THEN
1008: display_text := htf.br;
1009: END IF;
1010: IF display_text = 'null' THEN
1011: display_text := htf.br;
1012: END IF;
1013: IF display_text = '-1' THEN
1014: display_text := htf.br;
1015: END IF;
1010: IF display_text = 'null' THEN
1011: display_text := htf.br;
1012: END IF;
1013: IF display_text = '-1' THEN
1014: display_text := htf.br;
1015: END IF;
1016:
1017:
1018: -- Display item_description as a link and a tabledata
1034: END IF;
1035:
1036: -- Bold
1037: IF ak_query_pkg.g_items_table(i).bold = 'Y' THEN
1038: display_text := htf.bold(display_text);
1039: END IF;
1040:
1041: -- Italics
1042: IF ak_query_pkg.g_items_table(i).italic = 'Y' THEN
1039: END IF;
1040:
1041: -- Italics
1042: IF ak_query_pkg.g_items_table(i).italic = 'Y' THEN
1043: display_text := htf.italic(display_text);
1044: END IF;
1045:
1046: temp_table := temp_table ||
1047: htf.tableData( cvalue => display_text,
1043: display_text := htf.italic(display_text);
1044: END IF;
1045:
1046: temp_table := temp_table ||
1047: htf.tableData( cvalue => display_text,
1048: calign => ak_query_pkg.g_items_table(i).horizontal_alignment,
1049: crowspan => '2',
1050: cattributes => ' VALIGN=' || ak_query_pkg.g_items_table(i).vertical_alignment
1051: );
1052:
1053: END IF; /* if value_id is not null */
1054: END LOOP; -- for i in 1 .. ak_query_pkg.g_items_table.first loop
1055:
1056: temp_table := temp_table || htf.tableRowClose;
1057:
1058: --print the down button
1059: display_text := htf.tableRowOpen( cattributes => 'BGColor="#'||icx_util.get_color('TABLE_DATA_MULTIROW')||'"');
1060:
1055:
1056: temp_table := temp_table || htf.tableRowClose;
1057:
1058: --print the down button
1059: display_text := htf.tableRowOpen( cattributes => 'BGColor="#'||icx_util.get_color('TABLE_DATA_MULTIROW')||'"');
1060:
1061: display_text := htf.tableRowOpen( cattributes => 'BGColor="#'||icx_util.get_color('TABLE_DATA_MULTIROW')||'"');
1062:
1063:
1057:
1058: --print the down button
1059: display_text := htf.tableRowOpen( cattributes => 'BGColor="#'||icx_util.get_color('TABLE_DATA_MULTIROW')||'"');
1060:
1061: display_text := htf.tableRowOpen( cattributes => 'BGColor="#'||icx_util.get_color('TABLE_DATA_MULTIROW')||'"');
1062:
1063:
1064: display_text := display_text
1065: || '