Line 176: temp := htf.anchor('javascript:LOV('''||c_attribute_app_id||''','''||c_attribute_code||''','''||c_region_app_id||''','''||c_region_code||''','''||c_form_name||''','''||c_frame_name||''','''||l_where_clause||''','''')',
Line 1035: temp_text := temp_text||htf.formSelectClose;
1031: l_attributes2 := l_attributes2||htf.formSelectOption(temp_attribute,'','VALUE="'||temp_type||temp_column||'"');
1032: end if;
1033: end loop;
1034: close lov_query_columns; 1035: temp_text := temp_text||htf.formSelectClose; 1036: l_attributes2 := l_attributes2||htf.formSelectClose;
1037:
1038: -- if only one attribute, print as text (not pop list)
1039: if num_attributes = 1 then
Line 1036: l_attributes2 := l_attributes2||htf.formSelectClose;
1032: end if;
1033: end loop;
1034: close lov_query_columns;
1035: temp_text := temp_text||htf.formSelectClose; 1036: l_attributes2 := l_attributes2||htf.formSelectClose; 1037:
1038: -- if only one attribute, print as text (not pop list)
1039: if num_attributes = 1 then
1040:
Line 1046: htp.tableData(htf.nobr(temp_attribute));
Line 1050: htp.tableData(htf.formSelectOpen('a_1')||temp_text);
1046: htp.tableData(htf.nobr(temp_attribute));
1047: htp.tableClose;
1048:
1049: else 1050: htp.tableData(htf.formSelectOpen('a_1')||temp_text); 1051: end if;
1052: -- end of attributes select list
1053:
1054:
Line 1057: l_conditions2 := htf.formSelectOption('','SELECTED','VALUE=""');
1053:
1054:
1055: -- build select list of conditions
1056: temp_text := ''; 1057: l_conditions2 := htf.formSelectOption('','SELECTED','VALUE=""'); 1058: getLookups('ICX_CONDITIONS',l_lookup_codes, l_lookup_meanings);
1059: for i in 1..to_number(l_lookup_codes(0)) loop
1060: if l_lookup_codes(i) = 'DSTART' then
1061: temp_text := temp_text||htf.formSelectOption(l_lookup_meanings(i),'SELECTED','VALUE="'||l_lookup_codes(i)||'"');
Line 1061: temp_text := temp_text||htf.formSelectOption(l_lookup_meanings(i),'SELECTED','VALUE="'||l_lookup_codes(i)||'"');
1057: l_conditions2 := htf.formSelectOption('','SELECTED','VALUE=""');
1058: getLookups('ICX_CONDITIONS',l_lookup_codes, l_lookup_meanings);
1059: for i in 1..to_number(l_lookup_codes(0)) loop
1060: if l_lookup_codes(i) = 'DSTART' then 1061: temp_text := temp_text||htf.formSelectOption(l_lookup_meanings(i),'SELECTED','VALUE="'||l_lookup_codes(i)||'"'); 1062: l_conditions2 := l_conditions2||htf.formSelectOption(l_lookup_meanings(i),'','VALUE="'||l_lookup_codes(i)||'"');
1063: elsif instr(l_icx_custom_call,'NOCONTAIN') > 0
1064: and l_lookup_codes(i) = 'CCONTAIN'
1065: then
Line 1062: l_conditions2 := l_conditions2||htf.formSelectOption(l_lookup_meanings(i),'','VALUE="'||l_lookup_codes(i)||'"');
1058: getLookups('ICX_CONDITIONS',l_lookup_codes, l_lookup_meanings);
1059: for i in 1..to_number(l_lookup_codes(0)) loop
1060: if l_lookup_codes(i) = 'DSTART' then
1061: temp_text := temp_text||htf.formSelectOption(l_lookup_meanings(i),'SELECTED','VALUE="'||l_lookup_codes(i)||'"'); 1062: l_conditions2 := l_conditions2||htf.formSelectOption(l_lookup_meanings(i),'','VALUE="'||l_lookup_codes(i)||'"'); 1063: elsif instr(l_icx_custom_call,'NOCONTAIN') > 0
1064: and l_lookup_codes(i) = 'CCONTAIN'
1065: then
1066: temp_text := temp_text;
Line 1068: temp_text := temp_text||htf.formSelectOption(l_lookup_meanings(i),'','VALUE="'||l_lookup_codes(i)||'"');
1064: and l_lookup_codes(i) = 'CCONTAIN'
1065: then
1066: temp_text := temp_text;
1067: else 1068: temp_text := temp_text||htf.formSelectOption(l_lookup_meanings(i),'','VALUE="'||l_lookup_codes(i)||'"'); 1069: l_conditions2 := l_conditions2||htf.formSelectOption(l_lookup_meanings(i),'','VALUE="'||l_lookup_codes(i)||'"');
1070: end if;
1071: end loop;
1072: temp_text := temp_text||htf.formSelectClose;
Line 1069: l_conditions2 := l_conditions2||htf.formSelectOption(l_lookup_meanings(i),'','VALUE="'||l_lookup_codes(i)||'"');
1065: then
1066: temp_text := temp_text;
1067: else
1068: temp_text := temp_text||htf.formSelectOption(l_lookup_meanings(i),'','VALUE="'||l_lookup_codes(i)||'"'); 1069: l_conditions2 := l_conditions2||htf.formSelectOption(l_lookup_meanings(i),'','VALUE="'||l_lookup_codes(i)||'"'); 1070: end if;
1071: end loop;
1072: temp_text := temp_text||htf.formSelectClose;
1073: l_conditions2 := l_conditions2||htf.formSelectClose;
Line 1072: temp_text := temp_text||htf.formSelectClose;
1068: temp_text := temp_text||htf.formSelectOption(l_lookup_meanings(i),'','VALUE="'||l_lookup_codes(i)||'"');
1069: l_conditions2 := l_conditions2||htf.formSelectOption(l_lookup_meanings(i),'','VALUE="'||l_lookup_codes(i)||'"');
1070: end if;
1071: end loop; 1072: temp_text := temp_text||htf.formSelectClose; 1073: l_conditions2 := l_conditions2||htf.formSelectClose;
1074: htp.tableData(htf.formSelectOpen('c_1')||temp_text);
1075: -- end of conditions select list
1076:
Line 1073: l_conditions2 := l_conditions2||htf.formSelectClose;
1069: l_conditions2 := l_conditions2||htf.formSelectOption(l_lookup_meanings(i),'','VALUE="'||l_lookup_codes(i)||'"');
1070: end if;
1071: end loop;
1072: temp_text := temp_text||htf.formSelectClose; 1073: l_conditions2 := l_conditions2||htf.formSelectClose; 1074: htp.tableData(htf.formSelectOpen('c_1')||temp_text);
1075: -- end of conditions select list
1076:
1077:
Line 1074: htp.tableData(htf.formSelectOpen('c_1')||temp_text);
1070: end if;
1071: end loop;
1072: temp_text := temp_text||htf.formSelectClose;
1073: l_conditions2 := l_conditions2||htf.formSelectClose; 1074: htp.tableData(htf.formSelectOpen('c_1')||temp_text); 1075: -- end of conditions select list
1076:
1077:
1078: -- print text field
Line 1079: htp.tableData(htf.formText('i_1',20,20));
1075: -- end of conditions select list
1076:
1077:
1078: -- print text field 1079: htp.tableData(htf.formText('i_1',20,20)); 1080: if x = 1 then
1081: htp.p('');
Line 1166: l_display_line := '
'||htf.formSelectOpen('a_'||i)||
1162:
1163: -- Create extra query lines if necessary
1164: if c_lines <> 1 then
1165: for i in 2..to_number(c_lines) loop 1166: l_display_line := '
Line 1202: htp.tableData(htf.formCheckBox('case_sensitive')||LOV_prompts(12));
1198:
1199: if l_matchcase_lov = 'Unchecked'
1200: then
1201: htp.tableRowOpen; 1202: htp.tableData(htf.formCheckBox('case_sensitive')||LOV_prompts(12)); 1203: htp.tableRowClose;
1204: htp.tableClose;
1205: end if;
1206:
Line 1809: htp.p(icx_on_utilities.formatData(htf.anchor('javascript:clicked('||l_clicked_vars||')',
1805: if ak_query_pkg.g_items_table(k).secured_column = 'F' and
1806: ak_query_pkg.g_items_table(k).node_display_flag = 'Y' then
1807: l := l + 1;
1808: if l = 1 then 1809: htp.p(icx_on_utilities.formatData(htf.anchor('javascript:clicked('||l_clicked_vars||')', 1810: icx_on_utilities.formatText(l_result_row_table(ak_query_pkg.g_items_table(k).value_id),
1811: ak_query_pkg.g_items_table(k).bold,ak_query_pkg.g_items_table(k).italic)),ak_query_pkg.g_items_table(k).horizontal_alignment,ak_query_pkg.g_items_table(k).vertical_alignment));
1812: else
1813: htp.p(icx_on_utilities.formatData(icx_on_utilities.formatText(l_result_row_table(ak_query_pkg.g_items_table(k).value_id),