eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ICX_UTIL dependencies on HTF

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||''','''')',

172: -- c_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
173:
174: getPrompts(601,'ICX_LOV',c_title,c_prompts);
175: l_where_clause := icx_call.encrypt2(c_where_clause);
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||''','''')',
177: htf.img('/OA_MEDIA/FNDILOV.gif',c_image_align,icx_util.replace_alt_quotes(c_title),'','BORDER=0 WIDTH=23 HEIGHT=21'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(c_title)||''';return true"');
178: return temp;
179: end;
180:

Line 177: htf.img('/OA_MEDIA/FNDILOV.gif',c_image_align,icx_util.replace_alt_quotes(c_title),'','BORDER=0 WIDTH=23 HEIGHT=21'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(c_title)||''';return true"');

173:
174: getPrompts(601,'ICX_LOV',c_title,c_prompts);
175: l_where_clause := icx_call.encrypt2(c_where_clause);
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||''','''')',
177: htf.img('/OA_MEDIA/FNDILOV.gif',c_image_align,icx_util.replace_alt_quotes(c_title),'','BORDER=0 WIDTH=23 HEIGHT=21'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(c_title)||''';return true"');
178: return temp;
179: end;
180:
181:

Line 1019: l_attributes2 := htf.formSelectOption('','','VALUE=""');

1015: htp.formHidden('x',x);
1016:
1017: -- Build select list of query attributes.
1018: temp_text := '';
1019: l_attributes2 := htf.formSelectOption('','','VALUE=""');
1020: open lov_query_columns;
1021: num_attributes := 0;
1022: loop
1023: fetch lov_query_columns into temp_column, temp_attribute, temp_type;

Line 1027: temp_text := htf.formSelectOption(temp_attribute,'SELECTED','VALUE="'||temp_type||temp_column||'"');

1023: fetch lov_query_columns into temp_column, temp_attribute, temp_type;
1024: exit when lov_query_columns%NOTFOUND;
1025: num_attributes := num_attributes + 1;
1026: if num_attributes = 1 then
1027: temp_text := htf.formSelectOption(temp_attribute,'SELECTED','VALUE="'||temp_type||temp_column||'"');
1028: l_attributes2 := l_attributes2||htf.formSelectOption(temp_attribute,'','VALUE="'||temp_type||temp_column||'"');
1029: else
1030: temp_text := temp_text||htf.formSelectOption(temp_attribute,'','VALUE="'||temp_type||temp_column||'"');
1031: l_attributes2 := l_attributes2||htf.formSelectOption(temp_attribute,'','VALUE="'||temp_type||temp_column||'"');

Line 1028: l_attributes2 := l_attributes2||htf.formSelectOption(temp_attribute,'','VALUE="'||temp_type||temp_column||'"');

1024: exit when lov_query_columns%NOTFOUND;
1025: num_attributes := num_attributes + 1;
1026: if num_attributes = 1 then
1027: temp_text := htf.formSelectOption(temp_attribute,'SELECTED','VALUE="'||temp_type||temp_column||'"');
1028: l_attributes2 := l_attributes2||htf.formSelectOption(temp_attribute,'','VALUE="'||temp_type||temp_column||'"');
1029: else
1030: temp_text := temp_text||htf.formSelectOption(temp_attribute,'','VALUE="'||temp_type||temp_column||'"');
1031: l_attributes2 := l_attributes2||htf.formSelectOption(temp_attribute,'','VALUE="'||temp_type||temp_column||'"');
1032: end if;

Line 1030: temp_text := temp_text||htf.formSelectOption(temp_attribute,'','VALUE="'||temp_type||temp_column||'"');

1026: if num_attributes = 1 then
1027: temp_text := htf.formSelectOption(temp_attribute,'SELECTED','VALUE="'||temp_type||temp_column||'"');
1028: l_attributes2 := l_attributes2||htf.formSelectOption(temp_attribute,'','VALUE="'||temp_type||temp_column||'"');
1029: else
1030: temp_text := temp_text||htf.formSelectOption(temp_attribute,'','VALUE="'||temp_type||temp_column||'"');
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;

Line 1031: l_attributes2 := l_attributes2||htf.formSelectOption(temp_attribute,'','VALUE="'||temp_type||temp_column||'"');

1027: temp_text := htf.formSelectOption(temp_attribute,'SELECTED','VALUE="'||temp_type||temp_column||'"');
1028: l_attributes2 := l_attributes2||htf.formSelectOption(temp_attribute,'','VALUE="'||temp_type||temp_column||'"');
1029: else
1030: temp_text := temp_text||htf.formSelectOption(temp_attribute,'','VALUE="'||temp_type||temp_column||'"');
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;

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));

1042: htp.formHidden('a_1',temp_type||temp_column);
1043: htp.p('');
1044: htp.p('');
1045: htp.p('');
1046: htp.tableData(htf.nobr(temp_attribute));
1047: htp.tableClose;
1048:
1049: else
1050: htp.tableData(htf.formSelectOpen('a_1')||temp_text);
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 := '
'||
1168: ''||
1170: '';
Line 1167: l_attributes2||htf.formSelectClose||''||

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 := '
'||
1168: ''||
1170: '';
1171: htp.p(l_display_line);
Line 1168: '
'||
1168: ''||
1170: '';
1171: htp.p(l_display_line);
1172: end loop;

Line 1169: l_conditions2||htf.formSelectClose||''||

1165: for i in 2..to_number(c_lines) loop
1166: l_display_line := '
'||
1168: ''||
1170: '';
1171: htp.p(l_display_line);
1172: end loop;
1173: end if;
Line 1170: '
';
1166: l_display_line := '
'||
1168: ''||
1170: '';
1171: htp.p(l_display_line);
1172: end loop;
1173: end if;
1174:
Line 1181: htp.tableData(htf.formCheckBox('case_sensitive','','CHECKED')||LOV_prompts(12));

1177: -- add case-sensitive check box
1178: if l_matchcase_lov = 'Checked' -- 1550749
1179: then
1180: htp.tableRowOpen;
1181: htp.tableData(htf.formCheckBox('case_sensitive','','CHECKED')||LOV_prompts(12));
1182: htp.tableRowClose;
1183: htp.tableClose;
1184: end if;
1185:

Line 1193: htp.tableData(htf.italic(l_message),NULL,NULL,NULL,NULL,3,NULL);

1189: fnd_message.set_name('ICX','ICX_MATCHCASE_LOV');
1190: l_message := fnd_message.get;
1191:
1192: htp.tableRowOpen;
1193: htp.tableData(htf.italic(l_message),NULL,NULL,NULL,NULL,3,NULL);
1194: htp.tableData(htf.formHidden('case_sensitive', 'on'));
1195: htp.tableRowClose;
1196: htp.tableClose;
1197: end if;

Line 1194: htp.tableData(htf.formHidden('case_sensitive', 'on'));

1190: l_message := fnd_message.get;
1191:
1192: htp.tableRowOpen;
1193: htp.tableData(htf.italic(l_message),NULL,NULL,NULL,NULL,3,NULL);
1194: htp.tableData(htf.formHidden('case_sensitive', 'on'));
1195: htp.tableRowClose;
1196: htp.tableClose;
1197: end if;
1198:

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),

'||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 := '
'||htf.formSelectOpen('a_'||i)||
1167: l_attributes2||htf.formSelectClose||' '||htf.formSelectOpen('c_'||i)||
1169: l_conditions2||htf.formSelectClose||' '||htf.formText('i_'||i,20)||'

'||htf.formSelectOpen('a_'||i)||
1167: l_attributes2||htf.formSelectClose||' '||htf.formSelectOpen('c_'||i)||
1169: l_conditions2||htf.formSelectClose||' '||htf.formText('i_'||i,20)||'

'||htf.formSelectOpen('c_'||i)||

1164: if c_lines <> 1 then
1165: for i in 2..to_number(c_lines) loop
1166: l_display_line := '
'||htf.formSelectOpen('a_'||i)||
1167: l_attributes2||htf.formSelectClose||' '||htf.formSelectOpen('c_'||i)||
1169: l_conditions2||htf.formSelectClose||' '||htf.formText('i_'||i,20)||'
'||htf.formSelectOpen('a_'||i)||
1167: l_attributes2||htf.formSelectClose||' '||htf.formSelectOpen('c_'||i)||
1169: l_conditions2||htf.formSelectClose||' '||htf.formText('i_'||i,20)||'

'||htf.formText('i_'||i,20)||'

'||htf.formSelectOpen('a_'||i)||
1167: l_attributes2||htf.formSelectClose||' '||htf.formSelectOpen('c_'||i)||
1169: l_conditions2||htf.formSelectClose||' '||htf.formText('i_'||i,20)||'

'\|\|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 := '
'\|\|htf.formSelectOpen('a_'\|\|i)\|\| 1167: l_attributes2\|\|htf.formSelectClose\|\|'	'\|\|htf.formSelectOpen('c_'\|\|i)\|\| 1169: l_conditions2\|\|htf.formSelectClose\|\|'	'\|\|htf.formText('i_'\|\|i,20)\|\|'
'\|\|htf.formSelectOpen('a_'\|\|i)\|\| 1167: l_attributes2\|\|htf.formSelectClose\|\|'	'\|\|htf.formSelectOpen('c_'\|\|i)\|\| 1169: l_conditions2\|\|htf.formSelectClose\|\|'	'\|\|htf.formText('i_'\|\|i,20)\|\|'
'\|\|htf.formSelectOpen('c_'\|\|i)\|\| 1164: if c_lines <> 1 then 1165: for i in 2..to_number(c_lines) loop 1166: l_display_line := '
'\|\|htf.formSelectOpen('a_'\|\|i)\|\| 1167: l_attributes2\|\|htf.formSelectClose\|\|'	'\|\|htf.formSelectOpen('c_'\|\|i)\|\| 1169: l_conditions2\|\|htf.formSelectClose\|\|'	'\|\|htf.formText('i_'\|\|i,20)\|\|'
'\|\|htf.formSelectOpen('a_'\|\|i)\|\| 1167: l_attributes2\|\|htf.formSelectClose\|\|'	'\|\|htf.formSelectOpen('c_'\|\|i)\|\| 1169: l_conditions2\|\|htf.formSelectClose\|\|'	'\|\|htf.formText('i_'\|\|i,20)\|\|'
'\|\|htf.formText('i_'\|\|i,20)\|\|'
'\|\|htf.formSelectOpen('a_'\|\|i)\|\| 1167: l_attributes2\|\|htf.formSelectClose\|\|'	'\|\|htf.formSelectOpen('c_'\|\|i)\|\| 1169: l_conditions2\|\|htf.formSelectClose\|\|'	'\|\|htf.formText('i_'\|\|i,20)\|\|'