DBA Data[Home] [Help]

APPS.ICX_UTIL dependencies on HTP

Line 38: htp.p('

34: agent in varchar2,
35: dbHost in varchar2) is
36: begin
37:
38: htp.p('
39:
40:
41: ');
42:

Line 54: htp.p('
');

50:
51: procedure preload is
52:
53: begin
54: htp.p('');
55: htp.p('');
56:
57: wf_lov.lovapplet(doc_name=>'PRELOAD',
58: column_names=>NULL,

Line 55: htp.p('');

51: procedure preload is
52:
53: begin
54: htp.p('');
55: htp.p('');
56:
57: wf_lov.lovapplet(doc_name=>'PRELOAD',
58: column_names=>NULL,
59: query_params=>null,

Line 65: htp.p('');

61: longlist=>'Y',
62: width=>'1',
63: height=>'1');
64:
65: htp.p('');
66:
67: end;
68:
69: -- returns dummy values to a lov during preload of the applet

Line 73: htp.p('TEST LOV');

69: -- returns dummy values to a lov during preload of the applet
70: procedure preload_query(p_titles_only in varchar2,
71: p_find_criteria in varchar2) is
72: begin
73: htp.p('TEST LOV');
74: htp.p('1'); -- columns
75: htp.p('1'); -- rows
76: htp.p('X'); -- header
77: htp.p('100'); -- header size

Line 74: htp.p('1'); -- columns

70: procedure preload_query(p_titles_only in varchar2,
71: p_find_criteria in varchar2) is
72: begin
73: htp.p('TEST LOV');
74: htp.p('1'); -- columns
75: htp.p('1'); -- rows
76: htp.p('X'); -- header
77: htp.p('100'); -- header size
78: if p_titles_only <> 'Y' then

Line 75: htp.p('1'); -- rows

71: p_find_criteria in varchar2) is
72: begin
73: htp.p('TEST LOV');
74: htp.p('1'); -- columns
75: htp.p('1'); -- rows
76: htp.p('X'); -- header
77: htp.p('100'); -- header size
78: if p_titles_only <> 'Y' then
79: htp.p('X');

Line 76: htp.p('X'); -- header

72: begin
73: htp.p('TEST LOV');
74: htp.p('1'); -- columns
75: htp.p('1'); -- rows
76: htp.p('X'); -- header
77: htp.p('100'); -- header size
78: if p_titles_only <> 'Y' then
79: htp.p('X');
80: end if;

Line 77: htp.p('100'); -- header size

73: htp.p('TEST LOV');
74: htp.p('1'); -- columns
75: htp.p('1'); -- rows
76: htp.p('X'); -- header
77: htp.p('100'); -- header size
78: if p_titles_only <> 'Y' then
79: htp.p('X');
80: end if;
81: end;

Line 79: htp.p('X');

75: htp.p('1'); -- rows
76: htp.p('X'); -- header
77: htp.p('100'); -- header size
78: if p_titles_only <> 'Y' then
79: htp.p('X');
80: end if;
81: end;
82: */
83:

Line 116: -- htp.p('');

1079: htp.tableData(htf.formText('i_1',20,20));
1080: if x = 1 then
1081: htp.p('');
1084: end if;
1085:
1086: htp.p('');
1087: htp.p('');

Line 1086: htp.p('');

1082: htp.p('queryText()');
1083: htp.p('');
1084: end if;
1085:
1086: htp.p('');
1087: htp.p('');
1088: htp.p('');
1089: htp.p('');
1090: htp.p('');

Line 1087: htp.p('
');
1161: htp.p('');
1162:
1163: -- Create extra query lines if necessary

Line 1160: htp.p('');

1156: htp.p('

');
1157:
1158: htp.p('');
1159: htp.p('
');

1083: htp.p('');
1084: end if;
1085:
1086: htp.p('');
1087: htp.p('

');
1088: htp.p('');
1089: htp.p('');
1090: htp.p('');
1091: htp.p('');

Line 1088: htp.p('
');

1084: end if;
1085:
1086: htp.p('');
1087: htp.p('

');
1156: htp.p('');
1157:
1158: htp.p('');
1159: htp.p('
');
1088: htp.p('');
1089: htp.p('');
1090: htp.p('');
1091: htp.p('');
1092: -- bug 1235659

Line 1089: htp.p('
');

1085:
1086: htp.p('');
1087: htp.p('

');
1161: htp.p('');
1162:

Line 1159: htp.p('
');
1088: htp.p('');
1089: htp.p('');
1090: htp.p('');
1091: htp.p('');
1092: -- bug 1235659
1093: -- htp.p('');

Line 1090: htp.p('');

1086: htp.p('');
1087: htp.p('

');

Line 1158: htp.p('
');

1154: htp.p('

');
1155: htp.p('');
1156: htp.p('');
1157:
1158: htp.p('');
1159: htp.p('
');
1088: htp.p('');
1089: htp.p('');
1090: htp.p('');
1091: htp.p('');
1092: -- bug 1235659
1093: -- htp.p('');
1094: htp.p(''); --add

Line 1091: htp.p('
');

1087: htp.p('

');

1152: -- htp.p('

');
1153: -- htp.p('');
1154: htp.p('');
1155: htp.p('');
1156: htp.p('');
1157:
1158: htp.p('');
1159: htp.p('
');
1088: htp.p('');
1089: htp.p('');
1090: htp.p('');
1091: htp.p('');
1092: -- bug 1235659
1093: -- htp.p('');
1094: htp.p(''); --add
1095: htp.p('');

Line 1093: -- htp.p('
');

1089: htp.p('

');
1090: htp.p('');
1091: htp.p('');
1092: -- bug 1235659
1093: -- htp.p('');
1094: htp.p(''); --add
1095: htp.p('');
1096: htp.p(' ');
1097: htp.p('');

Line 1094: htp.p('
'); --add

1090: htp.p('');
1091: htp.p('

');
1092: -- bug 1235659
1093: -- htp.p('');
1094: htp.p(''); --add
1095: htp.p('');
1096: htp.p(' ');
1097: htp.p('');
1098:

Line 1095: htp.p('
');

1091: htp.p('

');
1092: -- bug 1235659
1093: -- htp.p('');
1094: htp.p(''); --add
1095: htp.p('');
1096: htp.p(' ');
1097: htp.p('');
1098:
1099: if num_attributes > 1 then

Line 1096: htp.p(' ');

1092: -- bug 1235659
1093: -- htp.p('

');
1094: htp.p(''); --add
1095: htp.p('');
1096: htp.p(' ');
1097: htp.p('');
1098:
1099: if num_attributes > 1 then
1100:

Line 1097: htp.p('
');

1093: -- htp.p('

');
1094: htp.p(''); --add
1095: htp.p('');
1096: htp.p(' ');
1097: htp.p('');
1098:
1099: if num_attributes > 1 then
1100:
1101: htp.p(' ');

Line 1101: htp.p(' ');

1097: htp.p('

');
1098:
1099: if num_attributes > 1 then
1100:
1101: htp.p(' ');
1102: htp.p('');
1103: -- bug 1235659
1104: -- htp.p('');
1105: htp.p('');

Line 1102: htp.p('
');

1098:
1099: if num_attributes > 1 then
1100:
1101: htp.p(' ');
1102: htp.p('

');
1103: -- bug 1235659
1104: -- htp.p('');
1105: htp.p('');
1106: htp.p('');

Line 1104: -- htp.p('
');

1100:
1101: htp.p(' ');
1102: htp.p('

');
1103: -- bug 1235659
1104: -- htp.p('');
1105: htp.p('');
1106: htp.p('');
1107: htp.p(' ');
1108: htp.p('');

Line 1105: htp.p('
');

1101: htp.p(' ');
1102: htp.p('

');
1103: -- bug 1235659
1104: -- htp.p('');
1105: htp.p('');
1106: htp.p('');
1107: htp.p(' ');
1108: htp.p('');
1109:

Line 1106: htp.p('
');

1102: htp.p('

');
1103: -- bug 1235659
1104: -- htp.p('');
1105: htp.p('');
1106: htp.p('');
1107: htp.p(' ');
1108: htp.p('');
1109:
1110: end if;

Line 1107: htp.p(' ');

1103: -- bug 1235659
1104: -- htp.p('

');
1105: htp.p('');
1106: htp.p('');
1107: htp.p(' ');
1108: htp.p('');
1109:
1110: end if;
1111:

Line 1108: htp.p('
');

1104: -- htp.p('

');
1105: htp.p('');
1106: htp.p('');
1107: htp.p(' ');
1108: htp.p('');
1109:
1110: end if;
1111:
1112: htp.p(' ');

Line 1112: htp.p(' ');

1108: htp.p('

');
1109:
1110: end if;
1111:
1112: htp.p(' ');
1113: htp.p('');
1114: -- bug 1235659
1115: -- htp.p('');
1116: htp.p('');

Line 1113: htp.p('
');

1109:
1110: end if;
1111:
1112: htp.p(' ');
1113: htp.p('

');
1114: -- bug 1235659
1115: -- htp.p('');
1116: htp.p('');
1117: htp.p('');

Line 1115: -- htp.p('
');

1111:
1112: htp.p(' ');
1113: htp.p('

');
1114: -- bug 1235659
1115: -- htp.p('');
1116: htp.p('');
1117: htp.p('');
1118: htp.p('');
1119: htp.p('');

Line 1116: htp.p('
');

1112: htp.p(' ');
1113: htp.p('

');
1114: -- bug 1235659
1115: -- htp.p('');
1116: htp.p('');
1117: htp.p('');
1118: htp.p('');
1119: htp.p('');
1120: htp.p('');

Line 1117: htp.p('
');

1113: htp.p('

');
1114: -- bug 1235659
1115: -- htp.p('');
1116: htp.p('');
1117: htp.p('');
1118: htp.p('');
1119: htp.p('');
1120: htp.p('');
1121: htp.p('');

Line 1118: htp.p('
');

1114: -- bug 1235659
1115: -- htp.p('

');
1116: htp.p('');
1117: htp.p('');
1118: htp.p('');
1119: htp.p('');
1120: htp.p('');
1121: htp.p('');
1122: htp.p('');

Line 1119: htp.p('
');

1115: -- htp.p('

');
1116: htp.p('');
1117: htp.p('');
1118: htp.p('');
1119: htp.p('');
1120: htp.p('');
1121: htp.p('');
1122: htp.p('');
1123: htp.p('');

Line 1120: htp.p('');

1116: htp.p('

');
1117: htp.p('');
1118: htp.p('');
1119: htp.p('');
1120: htp.p('');
1121: htp.p('');
1122: htp.p('');
1123: htp.p('');
1124:

Line 1121: htp.p('
');

1117: htp.p('

');
1118: htp.p('');
1119: htp.p('');
1120: htp.p('');
1121: htp.p('');
1122: htp.p('');
1123: htp.p('');
1124:
1125: htp.p('');

Line 1122: htp.p('
');

1118: htp.p('

');
1119: htp.p('');
1120: htp.p('');
1121: htp.p('');
1122: htp.p('');
1123: htp.p('');
1124:
1125: htp.p('');
1126: htp.p('');

Line 1123: htp.p('
');

1119: htp.p('

');
1120: htp.p('');
1121: htp.p('');
1122: htp.p('');
1123: htp.p('');
1124:
1125: htp.p('');
1126: htp.p('');
1127: htp.p('');

Line 1125: htp.p('
');

1121: htp.p('

');
1122: htp.p('');
1123: htp.p('');
1124:
1125: htp.p('');
1126: htp.p('');
1127: htp.p('');
1128: htp.p('');

Line 1126: htp.p('
');

1122: htp.p('

');
1123: htp.p('');
1124:
1125: htp.p('');
1126: htp.p('');
1127: htp.p('');
1128: htp.p('');
1130: htp.p('');
1124:
1125: htp.p('');
1126: htp.p('');
1127: htp.p('');
1128: htp.p('');
1130: htp.p('');

Line 1128: htp.p('
');
1126: htp.p('');
1127: htp.p('');
1128: htp.p('');
1130: htp.p('');
1132:

Line 1129: htp.p('');

1125: htp.p('

');
1126: htp.p('');
1127: htp.p('');
1128: htp.p('');
1130: htp.p('');
1132:
1133: if num_attributes > 1 then

Line 1130: htp.p('
');
1127: htp.p('');
1128: htp.p('');
1130: htp.p('');
1132:
1133: if num_attributes > 1 then
1134: if c_lines = 1 then

Line 1131: htp.p('');

1127: htp.p('');
1128: htp.p('

');
1130: htp.p('');
1132:
1133: if num_attributes > 1 then
1134: if c_lines = 1 then
1135: htp.p('');
1132:
1133: if num_attributes > 1 then
1134: if c_lines = 1 then
1135: htp.p('');

Line 1141: htp.p('');

1137: htp.p('

');
1142: htp.p('');
1143:
1144: htp.p('');
1145: htp.p('');

Line 1142: htp.p('
');

1138: end if;
1139: end if;
1140:
1141: htp.p('');
1142: htp.p('');
1143:
1144: htp.p('

');
1145: htp.p('');
1146: htp.p('');

Line 1144: htp.p('
');

1140:
1141: htp.p('');
1142: htp.p('

');
1143:
1144: htp.p('');
1145: htp.p('');
1146: htp.p('');
1147: htp.p('');
1148: htp.p('');

Line 1145: htp.p('
');

1141: htp.p('');
1142: htp.p('

');
1143:
1144: htp.p('');
1145: htp.p('');
1146: htp.p('');
1147: htp.p('');
1148: htp.p('');
1149: htp.p('');

Line 1146: htp.p('
');

1142: htp.p('

');
1143:
1144: htp.p('');
1145: htp.p('');
1146: htp.p('');
1147: htp.p('');
1148: htp.p('');
1149: htp.p('');
1150: -- bug 1235659

Line 1147: htp.p('
');

1143:
1144: htp.p('

');
1145: htp.p('');
1146: htp.p('');
1147: htp.p('');
1148: htp.p('');
1149: htp.p('');
1150: -- bug 1235659
1151: -- htp.p('');

Line 1148: htp.p('
');

1144: htp.p('

');
1145: htp.p('');
1146: htp.p('');
1147: htp.p('');
1148: htp.p('');
1149: htp.p('');
1150: -- bug 1235659
1151: -- htp.p('');
1152: -- htp.p('');

Line 1149: htp.p('
');

1145: htp.p('

');
1146: htp.p('');
1147: htp.p('');
1148: htp.p('');
1149: htp.p('');
1150: -- bug 1235659
1151: -- htp.p('');
1152: -- htp.p('');
1153: -- htp.p('');

Line 1151: -- htp.p('
');

1147: htp.p('

');
1148: htp.p('');
1149: htp.p('');
1150: -- bug 1235659
1151: -- htp.p('');
1152: -- htp.p('');
1153: -- htp.p('');
1154: htp.p('');
1155: htp.p('');

Line 1152: -- htp.p('
');

1148: htp.p('

');
1149: htp.p('');
1150: -- bug 1235659
1151: -- htp.p('');
1152: -- htp.p('');
1153: -- htp.p('');
1154: htp.p('');
1155: htp.p('');
1156: htp.p('');

Line 1153: -- htp.p('
');

1149: htp.p('

');
1150: -- bug 1235659
1151: -- htp.p('');
1152: -- htp.p('');
1153: -- htp.p('');
1154: htp.p('');
1155: htp.p('');
1156: htp.p('');
1157:

Line 1154: htp.p('
');

1150: -- bug 1235659
1151: -- htp.p('

');
1152: -- htp.p('');
1153: -- htp.p('');
1154: htp.p('');
1155: htp.p('');
1156: htp.p('');
1157:
1158: htp.p('');

Line 1155: htp.p('
');

1151: -- htp.p('

');
1152: -- htp.p('');
1153: -- htp.p('');
1154: htp.p('');
1155: htp.p('');
1156: htp.p('');
1157:
1158: htp.p('');
1159: htp.p('
'||LOV_prompts(1));
1129: htp.p('
'||LOV_prompts(1));
1129: htp.p('		'||LOV_prompts(2));

Line 1127: htp.p('');

1123: htp.p('

'||LOV_prompts(1));
1129: htp.p('		'||LOV_prompts(2));
1131: htp.p('		 '||LOV_prompts(1));

1124:
1125: htp.p('

'||LOV_prompts(1));
1129: htp.p('		'||LOV_prompts(2));
1131: htp.p('
'||LOV_prompts(1));
1129: htp.p('		'||LOV_prompts(2));
1131: htp.p('		 '||LOV_prompts(2));

1126: htp.p('

'||LOV_prompts(1));
1129: htp.p('		 '||LOV_prompts(2));
1131: htp.p('		'||LOV_prompts(1));
1129: htp.p('		'||LOV_prompts(2));
1131: htp.p('		'||LOV_prompts(8));

Line 1135: htp.p('
'||LOV_prompts(8));

1131: htp.p('

 '||LOV_prompts(8));
1136: else
1137: htp.p('		'||LOV_prompts(9));
1138: end if;
1139: end if;

Line 1137: htp.p('
'||LOV_prompts(9));

1133: if num_attributes > 1 then
1134: if c_lines = 1 then
1135: htp.p('

'||LOV_prompts(8));
1136: else
1137: htp.p('		'||LOV_prompts(9));
1138: end if;
1139: end if;
1140:
1141: htp.p('		'||LOV_prompts(9));
1138: end if;
1139: end if;
1140:
1141: htp.p('
');

Line 1156: htp.p('
');
1160: htp.p('
');
1160: htp.p('
');

1155: htp.p('

');
1160: htp.p('
');
1160: htp.p('');
1161: htp.p('');
1162:
1163: -- Create extra query lines if necessary
1164: if c_lines <> 1 then

Line 1161: htp.p('');

1157:
1158: htp.p('');
1159: htp.p('');
1160: htp.p('');
1161: htp.p('');
1162:
1163: -- Create extra query lines if necessary
1164: if c_lines <> 1 then
1165: for i in 2..to_number(c_lines) loop

Line 1171: htp.p(l_display_line);

1167: l_attributes2||htf.formSelectClose||''||
1168: ''||htf.formSelectOpen('c_'||i)||
1169: l_conditions2||htf.formSelectClose||''||
1170: ''||htf.formText('i_'||i,20)||'';
1171: htp.p(l_display_line);
1172: end loop;
1173: end if;
1174:
1175: htp.tableRowClose;

Line 1175: htp.tableRowClose;

1171: htp.p(l_display_line);
1172: end loop;
1173: end if;
1174:
1175: htp.tableRowClose;
1176:
1177: -- add case-sensitive check box
1178: if l_matchcase_lov = 'Checked' -- 1550749
1179: then

Line 1180: htp.tableRowOpen;

1176:
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;

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 1182: htp.tableRowClose;

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:
1186: if l_matchcase_lov = 'Hidden'

Line 1183: htp.tableClose;

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:
1186: if l_matchcase_lov = 'Hidden'
1187: then

Line 1192: htp.tableRowOpen;

1188:
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;

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 1195: htp.tableRowClose;

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:
1199: if l_matchcase_lov = 'Unchecked'

Line 1196: htp.tableClose;

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:
1199: if l_matchcase_lov = 'Unchecked'
1200: then

Line 1201: htp.tableRowOpen;

1197: end if;
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;

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 1203: htp.tableRowClose;

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:
1207: --- end of 1550749

Line 1204: htp.tableClose;

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:
1207: --- end of 1550749
1208:

Line 1210: htp.p('');

1206:
1207: --- end of 1550749
1208:
1209:
1210: htp.p('');
1211: htp.formClose;
1212: htp.bodyClose;
1213:
1214: end if; -- ValidateSession

Line 1211: htp.formClose;

1207: --- end of 1550749
1208:
1209:
1210: htp.p('');
1211: htp.formClose;
1212: htp.bodyClose;
1213:
1214: end if; -- ValidateSession
1215:

Line 1212: htp.bodyClose;

1208:
1209:
1210: htp.p('');
1211: htp.formClose;
1212: htp.bodyClose;
1213:
1214: end if; -- ValidateSession
1215:
1216: exception

Line 1478: htp.htmlOpen;

1474:
1475: end if; -- Do Object Navigator query
1476:
1477:
1478: htp.htmlOpen;
1479: htp.headOpen;
1480: -- htp.p('');
1481:
1482: js.scriptOpen;

Line 1479: htp.headOpen;

1475: end if; -- Do Object Navigator query
1476:
1477:
1478: htp.htmlOpen;
1479: htp.headOpen;
1480: -- htp.p('');
1481:
1482: js.scriptOpen;
1483:

Line 1480: -- htp.p('');

1476:
1477:
1478: htp.htmlOpen;
1479: htp.headOpen;
1480: -- htp.p('');
1481:
1482: js.scriptOpen;
1483:
1484: -- If this is the initial LOV call, we need to write the autoquery

Line 1515: htp.p('function autoquery() {');

1511: where e.REGION_APPLICATION_ID = p_LOV_region_id
1512: and e.REGION_CODE = p_LOV_region);
1513:
1514: -- Write autoquery function
1515: htp.p('function autoquery() {');
1516: if c_frame_name is null then
1517: htp.p('if (parent.opener.parent.document.'||c_form_name||'.'||p_attribute_code||'.value != "") {
1518: document.LOVValues.i_1.value = parent.opener.parent.document.'||c_form_name||'.'||p_attribute_code||'.value');
1519: else

Line 1517: htp.p('if (parent.opener.parent.document.'||c_form_name||'.'||p_attribute_code||'.value != "") {

1513:
1514: -- Write autoquery function
1515: htp.p('function autoquery() {');
1516: if c_frame_name is null then
1517: htp.p('if (parent.opener.parent.document.'||c_form_name||'.'||p_attribute_code||'.value != "") {
1518: document.LOVValues.i_1.value = parent.opener.parent.document.'||c_form_name||'.'||p_attribute_code||'.value');
1519: else
1520: htp.p('if (parent.opener.parent.'||c_frame_name||'.document.'||c_form_name||'.'||p_attribute_code||'.value != "") {
1521: document.LOVValues.i_1.value = parent.opener.parent.'||c_frame_name||'.document.'||c_form_name||'.'||p_attribute_code||'.value');

Line 1520: htp.p('if (parent.opener.parent.'||c_frame_name||'.document.'||c_form_name||'.'||p_attribute_code||'.value != "") {

1516: if c_frame_name is null then
1517: htp.p('if (parent.opener.parent.document.'||c_form_name||'.'||p_attribute_code||'.value != "") {
1518: document.LOVValues.i_1.value = parent.opener.parent.document.'||c_form_name||'.'||p_attribute_code||'.value');
1519: else
1520: htp.p('if (parent.opener.parent.'||c_frame_name||'.document.'||c_form_name||'.'||p_attribute_code||'.value != "") {
1521: document.LOVValues.i_1.value = parent.opener.parent.'||c_frame_name||'.document.'||c_form_name||'.'||p_attribute_code||'.value');
1522: end if;
1523: fnd_message.set_name('ICX','ICX_LOV_HINT');
1524: htp.p('document.LOVValues.a_1.value = "'||temp_a_1||'"

Line 1524: htp.p('document.LOVValues.a_1.value = "'||temp_a_1||'"

1520: htp.p('if (parent.opener.parent.'||c_frame_name||'.document.'||c_form_name||'.'||p_attribute_code||'.value != "") {
1521: document.LOVValues.i_1.value = parent.opener.parent.'||c_frame_name||'.document.'||c_form_name||'.'||p_attribute_code||'.value');
1522: end if;
1523: fnd_message.set_name('ICX','ICX_LOV_HINT');
1524: htp.p('document.LOVValues.a_1.value = "'||temp_a_1||'"
1525: document.LOVValues.submit()
1526: } else {
1527: document.write("

")
1528: document.write("

'||icx_util.replace_quotes(fnd_message.get)||'

")

Line 1573: htp.p('function clicked('||clicked_columns||') {');

1569:
1570:
1571: -- write clicked javascript function in the html header
1572: -- first the direct out values
1573: htp.p('function clicked('||clicked_columns||') {');
1574: open lov_out_attributes;
1575: loop
1576: fetch lov_out_attributes into base_region_attr, LOV_region_attr;
1577: exit when lov_out_attributes%NOTFOUND;

Line 1579: htp.p('parent.opener.parent.'||c_frame_name||'.document.'||c_form_name||'.'||base_region_attr||'.value = l_'||LOV_region_attr);

1575: loop
1576: fetch lov_out_attributes into base_region_attr, LOV_region_attr;
1577: exit when lov_out_attributes%NOTFOUND;
1578: if c_frame_name is not null then
1579: htp.p('parent.opener.parent.'||c_frame_name||'.document.'||c_form_name||'.'||base_region_attr||'.value = l_'||LOV_region_attr);
1580: else
1581: htp.p('parent.opener.parent.document.'||c_form_name||'.'||base_region_attr||'.value = l_'||LOV_region_attr);
1582: end if;
1583: end loop;

Line 1581: htp.p('parent.opener.parent.document.'||c_form_name||'.'||base_region_attr||'.value = l_'||LOV_region_attr);

1577: exit when lov_out_attributes%NOTFOUND;
1578: if c_frame_name is not null then
1579: htp.p('parent.opener.parent.'||c_frame_name||'.document.'||c_form_name||'.'||base_region_attr||'.value = l_'||LOV_region_attr);
1580: else
1581: htp.p('parent.opener.parent.document.'||c_form_name||'.'||base_region_attr||'.value = l_'||LOV_region_attr);
1582: end if;
1583: end loop;
1584: close lov_out_attributes;
1585:

Line 1607: htp.p(l_js_proc_text);

1603: if i > 0 then
1604: l_js_proc_text := l_js_proc_text||')';
1605: end if;
1606: close js_out_attributes;
1607: htp.p(l_js_proc_text);
1608:
1609: htp.p('parent.self.close()
1610: }');
1611:

Line 1609: htp.p('parent.self.close()

1605: end if;
1606: close js_out_attributes;
1607: htp.p(l_js_proc_text);
1608:
1609: htp.p('parent.self.close()
1610: }');
1611:
1612:
1613: -- Javascript function to handle CD buttons

Line 1614: htp.p('function LOV_rows(start_num, end_num) {

1610: }');
1611:
1612:
1613: -- Javascript function to handle CD buttons
1614: htp.p('function LOV_rows(start_num, end_num) {
1615: document.LOVValues.start_row.value = start_num
1616: document.LOVValues.p_end_row.value = end_num
1617: document.LOVValues.x.value = 2
1618: document.LOVValues.submit()

Line 1625: htp.headClose;

1621:
1622: end if;
1623:
1624: js.scriptClose;
1625: htp.headClose;
1626:
1627: htp.p('');
1628:
1629: htp.formOpen(c_agent||'/icx_util.LOVValues','POST','','','NAME="LOVValues"');

Line 1627: htp.p('');

1623:
1624: js.scriptClose;
1625: htp.headClose;
1626:
1627: htp.p('');
1628:
1629: htp.formOpen(c_agent||'/icx_util.LOVValues','POST','','','NAME="LOVValues"');
1630:
1631: htp.formHidden('p_LOV_foreign_key_name',p_LOV_foreign_key_name);

Line 1629: htp.formOpen(c_agent||'/icx_util.LOVValues','POST','','','NAME="LOVValues"');

1625: htp.headClose;
1626:
1627: htp.p('');
1628:
1629: htp.formOpen(c_agent||'/icx_util.LOVValues','POST','','','NAME="LOVValues"');
1630:
1631: htp.formHidden('p_LOV_foreign_key_name',p_LOV_foreign_key_name);
1632: htp.formHidden('p_LOV_region_id',p_LOV_region_id);
1633: htp.formHidden('p_LOV_region',p_LOV_region );

Line 1631: htp.formHidden('p_LOV_foreign_key_name',p_LOV_foreign_key_name);

1627: htp.p('');
1628:
1629: htp.formOpen(c_agent||'/icx_util.LOVValues','POST','','','NAME="LOVValues"');
1630:
1631: htp.formHidden('p_LOV_foreign_key_name',p_LOV_foreign_key_name);
1632: htp.formHidden('p_LOV_region_id',p_LOV_region_id);
1633: htp.formHidden('p_LOV_region',p_LOV_region );
1634: htp.formHidden('p_attribute_app_id',p_attribute_app_id);
1635: htp.formHidden('p_attribute_code',p_attribute_code);

Line 1632: htp.formHidden('p_LOV_region_id',p_LOV_region_id);

1628:
1629: htp.formOpen(c_agent||'/icx_util.LOVValues','POST','','','NAME="LOVValues"');
1630:
1631: htp.formHidden('p_LOV_foreign_key_name',p_LOV_foreign_key_name);
1632: htp.formHidden('p_LOV_region_id',p_LOV_region_id);
1633: htp.formHidden('p_LOV_region',p_LOV_region );
1634: htp.formHidden('p_attribute_app_id',p_attribute_app_id);
1635: htp.formHidden('p_attribute_code',p_attribute_code);
1636: htp.formHidden('p_region_app_id',p_region_app_id);

Line 1633: htp.formHidden('p_LOV_region',p_LOV_region );

1629: htp.formOpen(c_agent||'/icx_util.LOVValues','POST','','','NAME="LOVValues"');
1630:
1631: htp.formHidden('p_LOV_foreign_key_name',p_LOV_foreign_key_name);
1632: htp.formHidden('p_LOV_region_id',p_LOV_region_id);
1633: htp.formHidden('p_LOV_region',p_LOV_region );
1634: htp.formHidden('p_attribute_app_id',p_attribute_app_id);
1635: htp.formHidden('p_attribute_code',p_attribute_code);
1636: htp.formHidden('p_region_app_id',p_region_app_id);
1637: htp.formHidden('p_region_code',p_region_code);

Line 1634: htp.formHidden('p_attribute_app_id',p_attribute_app_id);

1630:
1631: htp.formHidden('p_LOV_foreign_key_name',p_LOV_foreign_key_name);
1632: htp.formHidden('p_LOV_region_id',p_LOV_region_id);
1633: htp.formHidden('p_LOV_region',p_LOV_region );
1634: htp.formHidden('p_attribute_app_id',p_attribute_app_id);
1635: htp.formHidden('p_attribute_code',p_attribute_code);
1636: htp.formHidden('p_region_app_id',p_region_app_id);
1637: htp.formHidden('p_region_code',p_region_code);
1638: htp.formHidden('c_frame_name',c_frame_name);

Line 1635: htp.formHidden('p_attribute_code',p_attribute_code);

1631: htp.formHidden('p_LOV_foreign_key_name',p_LOV_foreign_key_name);
1632: htp.formHidden('p_LOV_region_id',p_LOV_region_id);
1633: htp.formHidden('p_LOV_region',p_LOV_region );
1634: htp.formHidden('p_attribute_app_id',p_attribute_app_id);
1635: htp.formHidden('p_attribute_code',p_attribute_code);
1636: htp.formHidden('p_region_app_id',p_region_app_id);
1637: htp.formHidden('p_region_code',p_region_code);
1638: htp.formHidden('c_frame_name',c_frame_name);
1639: htp.formHidden('c_form_name',c_form_name);

Line 1636: htp.formHidden('p_region_app_id',p_region_app_id);

1632: htp.formHidden('p_LOV_region_id',p_LOV_region_id);
1633: htp.formHidden('p_LOV_region',p_LOV_region );
1634: htp.formHidden('p_attribute_app_id',p_attribute_app_id);
1635: htp.formHidden('p_attribute_code',p_attribute_code);
1636: htp.formHidden('p_region_app_id',p_region_app_id);
1637: htp.formHidden('p_region_code',p_region_code);
1638: htp.formHidden('c_frame_name',c_frame_name);
1639: htp.formHidden('c_form_name',c_form_name);
1640: htp.formHidden('c_where_clause',c_where_clause);

Line 1637: htp.formHidden('p_region_code',p_region_code);

1633: htp.formHidden('p_LOV_region',p_LOV_region );
1634: htp.formHidden('p_attribute_app_id',p_attribute_app_id);
1635: htp.formHidden('p_attribute_code',p_attribute_code);
1636: htp.formHidden('p_region_app_id',p_region_app_id);
1637: htp.formHidden('p_region_code',p_region_code);
1638: htp.formHidden('c_frame_name',c_frame_name);
1639: htp.formHidden('c_form_name',c_form_name);
1640: htp.formHidden('c_where_clause',c_where_clause);
1641: htp.formHidden('x','1');

Line 1638: htp.formHidden('c_frame_name',c_frame_name);

1634: htp.formHidden('p_attribute_app_id',p_attribute_app_id);
1635: htp.formHidden('p_attribute_code',p_attribute_code);
1636: htp.formHidden('p_region_app_id',p_region_app_id);
1637: htp.formHidden('p_region_code',p_region_code);
1638: htp.formHidden('c_frame_name',c_frame_name);
1639: htp.formHidden('c_form_name',c_form_name);
1640: htp.formHidden('c_where_clause',c_where_clause);
1641: htp.formHidden('x','1');
1642: htp.formHidden('start_row',start_row);

Line 1639: htp.formHidden('c_form_name',c_form_name);

1635: htp.formHidden('p_attribute_code',p_attribute_code);
1636: htp.formHidden('p_region_app_id',p_region_app_id);
1637: htp.formHidden('p_region_code',p_region_code);
1638: htp.formHidden('c_frame_name',c_frame_name);
1639: htp.formHidden('c_form_name',c_form_name);
1640: htp.formHidden('c_where_clause',c_where_clause);
1641: htp.formHidden('x','1');
1642: htp.formHidden('start_row',start_row);
1643: htp.formHidden('p_end_row',p_end_row);

Line 1640: htp.formHidden('c_where_clause',c_where_clause);

1636: htp.formHidden('p_region_app_id',p_region_app_id);
1637: htp.formHidden('p_region_code',p_region_code);
1638: htp.formHidden('c_frame_name',c_frame_name);
1639: htp.formHidden('c_form_name',c_form_name);
1640: htp.formHidden('c_where_clause',c_where_clause);
1641: htp.formHidden('x','1');
1642: htp.formHidden('start_row',start_row);
1643: htp.formHidden('p_end_row',p_end_row);
1644: htp.formHidden('a_1',a_1);

Line 1641: htp.formHidden('x','1');

1637: htp.formHidden('p_region_code',p_region_code);
1638: htp.formHidden('c_frame_name',c_frame_name);
1639: htp.formHidden('c_form_name',c_form_name);
1640: htp.formHidden('c_where_clause',c_where_clause);
1641: htp.formHidden('x','1');
1642: htp.formHidden('start_row',start_row);
1643: htp.formHidden('p_end_row',p_end_row);
1644: htp.formHidden('a_1',a_1);
1645: htp.formHidden('c_1',c_1);

Line 1642: htp.formHidden('start_row',start_row);

1638: htp.formHidden('c_frame_name',c_frame_name);
1639: htp.formHidden('c_form_name',c_form_name);
1640: htp.formHidden('c_where_clause',c_where_clause);
1641: htp.formHidden('x','1');
1642: htp.formHidden('start_row',start_row);
1643: htp.formHidden('p_end_row',p_end_row);
1644: htp.formHidden('a_1',a_1);
1645: htp.formHidden('c_1',c_1);
1646: htp.formHidden('i_1',i_1);

Line 1643: htp.formHidden('p_end_row',p_end_row);

1639: htp.formHidden('c_form_name',c_form_name);
1640: htp.formHidden('c_where_clause',c_where_clause);
1641: htp.formHidden('x','1');
1642: htp.formHidden('start_row',start_row);
1643: htp.formHidden('p_end_row',p_end_row);
1644: htp.formHidden('a_1',a_1);
1645: htp.formHidden('c_1',c_1);
1646: htp.formHidden('i_1',i_1);
1647: htp.formHidden('a_2',a_2);

Line 1644: htp.formHidden('a_1',a_1);

1640: htp.formHidden('c_where_clause',c_where_clause);
1641: htp.formHidden('x','1');
1642: htp.formHidden('start_row',start_row);
1643: htp.formHidden('p_end_row',p_end_row);
1644: htp.formHidden('a_1',a_1);
1645: htp.formHidden('c_1',c_1);
1646: htp.formHidden('i_1',i_1);
1647: htp.formHidden('a_2',a_2);
1648: htp.formHidden('c_2',c_2);

Line 1645: htp.formHidden('c_1',c_1);

1641: htp.formHidden('x','1');
1642: htp.formHidden('start_row',start_row);
1643: htp.formHidden('p_end_row',p_end_row);
1644: htp.formHidden('a_1',a_1);
1645: htp.formHidden('c_1',c_1);
1646: htp.formHidden('i_1',i_1);
1647: htp.formHidden('a_2',a_2);
1648: htp.formHidden('c_2',c_2);
1649: htp.formHidden('i_2',i_2);

Line 1646: htp.formHidden('i_1',i_1);

1642: htp.formHidden('start_row',start_row);
1643: htp.formHidden('p_end_row',p_end_row);
1644: htp.formHidden('a_1',a_1);
1645: htp.formHidden('c_1',c_1);
1646: htp.formHidden('i_1',i_1);
1647: htp.formHidden('a_2',a_2);
1648: htp.formHidden('c_2',c_2);
1649: htp.formHidden('i_2',i_2);
1650: htp.formHidden('a_3',a_3);

Line 1647: htp.formHidden('a_2',a_2);

1643: htp.formHidden('p_end_row',p_end_row);
1644: htp.formHidden('a_1',a_1);
1645: htp.formHidden('c_1',c_1);
1646: htp.formHidden('i_1',i_1);
1647: htp.formHidden('a_2',a_2);
1648: htp.formHidden('c_2',c_2);
1649: htp.formHidden('i_2',i_2);
1650: htp.formHidden('a_3',a_3);
1651: htp.formHidden('c_3',c_3);

Line 1648: htp.formHidden('c_2',c_2);

1644: htp.formHidden('a_1',a_1);
1645: htp.formHidden('c_1',c_1);
1646: htp.formHidden('i_1',i_1);
1647: htp.formHidden('a_2',a_2);
1648: htp.formHidden('c_2',c_2);
1649: htp.formHidden('i_2',i_2);
1650: htp.formHidden('a_3',a_3);
1651: htp.formHidden('c_3',c_3);
1652: htp.formHidden('i_3',i_3);

Line 1649: htp.formHidden('i_2',i_2);

1645: htp.formHidden('c_1',c_1);
1646: htp.formHidden('i_1',i_1);
1647: htp.formHidden('a_2',a_2);
1648: htp.formHidden('c_2',c_2);
1649: htp.formHidden('i_2',i_2);
1650: htp.formHidden('a_3',a_3);
1651: htp.formHidden('c_3',c_3);
1652: htp.formHidden('i_3',i_3);
1653: htp.formHidden('a_4',a_4);

Line 1650: htp.formHidden('a_3',a_3);

1646: htp.formHidden('i_1',i_1);
1647: htp.formHidden('a_2',a_2);
1648: htp.formHidden('c_2',c_2);
1649: htp.formHidden('i_2',i_2);
1650: htp.formHidden('a_3',a_3);
1651: htp.formHidden('c_3',c_3);
1652: htp.formHidden('i_3',i_3);
1653: htp.formHidden('a_4',a_4);
1654: htp.formHidden('c_4',c_4);

Line 1651: htp.formHidden('c_3',c_3);

1647: htp.formHidden('a_2',a_2);
1648: htp.formHidden('c_2',c_2);
1649: htp.formHidden('i_2',i_2);
1650: htp.formHidden('a_3',a_3);
1651: htp.formHidden('c_3',c_3);
1652: htp.formHidden('i_3',i_3);
1653: htp.formHidden('a_4',a_4);
1654: htp.formHidden('c_4',c_4);
1655: htp.formHidden('i_4',i_4);

Line 1652: htp.formHidden('i_3',i_3);

1648: htp.formHidden('c_2',c_2);
1649: htp.formHidden('i_2',i_2);
1650: htp.formHidden('a_3',a_3);
1651: htp.formHidden('c_3',c_3);
1652: htp.formHidden('i_3',i_3);
1653: htp.formHidden('a_4',a_4);
1654: htp.formHidden('c_4',c_4);
1655: htp.formHidden('i_4',i_4);
1656: htp.formHidden('a_5',a_5);

Line 1653: htp.formHidden('a_4',a_4);

1649: htp.formHidden('i_2',i_2);
1650: htp.formHidden('a_3',a_3);
1651: htp.formHidden('c_3',c_3);
1652: htp.formHidden('i_3',i_3);
1653: htp.formHidden('a_4',a_4);
1654: htp.formHidden('c_4',c_4);
1655: htp.formHidden('i_4',i_4);
1656: htp.formHidden('a_5',a_5);
1657: htp.formHidden('c_5',c_5);

Line 1654: htp.formHidden('c_4',c_4);

1650: htp.formHidden('a_3',a_3);
1651: htp.formHidden('c_3',c_3);
1652: htp.formHidden('i_3',i_3);
1653: htp.formHidden('a_4',a_4);
1654: htp.formHidden('c_4',c_4);
1655: htp.formHidden('i_4',i_4);
1656: htp.formHidden('a_5',a_5);
1657: htp.formHidden('c_5',c_5);
1658: htp.formHidden('i_5',i_5);

Line 1655: htp.formHidden('i_4',i_4);

1651: htp.formHidden('c_3',c_3);
1652: htp.formHidden('i_3',i_3);
1653: htp.formHidden('a_4',a_4);
1654: htp.formHidden('c_4',c_4);
1655: htp.formHidden('i_4',i_4);
1656: htp.formHidden('a_5',a_5);
1657: htp.formHidden('c_5',c_5);
1658: htp.formHidden('i_5',i_5);
1659: htp.formHidden('case_sensitive',case_sensitive);

Line 1656: htp.formHidden('a_5',a_5);

1652: htp.formHidden('i_3',i_3);
1653: htp.formHidden('a_4',a_4);
1654: htp.formHidden('c_4',c_4);
1655: htp.formHidden('i_4',i_4);
1656: htp.formHidden('a_5',a_5);
1657: htp.formHidden('c_5',c_5);
1658: htp.formHidden('i_5',i_5);
1659: htp.formHidden('case_sensitive',case_sensitive);
1660: --htp.formHidden('c_where_bind_vals',c_where_bind_vals);

Line 1657: htp.formHidden('c_5',c_5);

1653: htp.formHidden('a_4',a_4);
1654: htp.formHidden('c_4',c_4);
1655: htp.formHidden('i_4',i_4);
1656: htp.formHidden('a_5',a_5);
1657: htp.formHidden('c_5',c_5);
1658: htp.formHidden('i_5',i_5);
1659: htp.formHidden('case_sensitive',case_sensitive);
1660: --htp.formHidden('c_where_bind_vals',c_where_bind_vals);
1661:

Line 1658: htp.formHidden('i_5',i_5);

1654: htp.formHidden('c_4',c_4);
1655: htp.formHidden('i_4',i_4);
1656: htp.formHidden('a_5',a_5);
1657: htp.formHidden('c_5',c_5);
1658: htp.formHidden('i_5',i_5);
1659: htp.formHidden('case_sensitive',case_sensitive);
1660: --htp.formHidden('c_where_bind_vals',c_where_bind_vals);
1661:
1662: -- check if error messages were generated by the ak query

Line 1659: htp.formHidden('case_sensitive',case_sensitive);

1655: htp.formHidden('i_4',i_4);
1656: htp.formHidden('a_5',a_5);
1657: htp.formHidden('c_5',c_5);
1658: htp.formHidden('i_5',i_5);
1659: htp.formHidden('case_sensitive',case_sensitive);
1660: --htp.formHidden('c_where_bind_vals',c_where_bind_vals);
1661:
1662: -- check if error messages were generated by the ak query
1663: if not l_error then

Line 1660: --htp.formHidden('c_where_bind_vals',c_where_bind_vals);

1656: htp.formHidden('a_5',a_5);
1657: htp.formHidden('c_5',c_5);
1658: htp.formHidden('i_5',i_5);
1659: htp.formHidden('case_sensitive',case_sensitive);
1660: --htp.formHidden('c_where_bind_vals',c_where_bind_vals);
1661:
1662: -- check if error messages were generated by the ak query
1663: if not l_error then
1664:

Line 1669: htp.p('');
1672:
1673: end if;

Line 1670: htp.p('autoquery()');

1666:
1667: -- x = 0 indicates the initial call to the LOV
1668: -- Autoquery or Display hint about selection criteria
1669: htp.p('');
1672:
1673: end if;
1674:

Line 1671: htp.p('');

1667: -- x = 0 indicates the initial call to the LOV
1668: -- Autoquery or Display hint about selection criteria
1669: htp.p('');
1672:
1673: end if;
1674:
1675:

Line 1720: htp.p('');

1716: P_LIST_COUNT => TRUE,
1717: P_OBJECT_DISP_NAME => ak_query_pkg.g_items_table(1).attribute_label_long);
1718:
1719: -- display table header of LOV
1720: htp.p('

');
1721: htp.p('
');
1722: htp.p('');
1723: htp.p('');
1724: for k in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop

Line 1721: htp.p('
');
1825: htp.p('');
1826: htp.p('
');

1717: P_OBJECT_DISP_NAME => ak_query_pkg.g_items_table(1).attribute_label_long);
1718:
1719: -- display table header of LOV
1720: htp.p('');
1721: htp.p('
');
1722: htp.p('');
1723: htp.p('');
1724: for k in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
1725: if ak_query_pkg.g_items_table(k).secured_column = 'F' and

Line 1722: htp.p('
');

1718:
1719: -- display table header of LOV
1720: htp.p('

');
1721: htp.p('');

1821: end loop; -- LOV data
1822:
1823: htp.tableClose;
1824: htp.p('');
1825: htp.p('');
1826: htp.p('

');
1722: htp.p('');
1723: htp.p('');
1724: for k in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
1725: if ak_query_pkg.g_items_table(k).secured_column = 'F' and
1726: ak_query_pkg.g_items_table(k).node_display_flag = 'Y' then

Line 1723: htp.p('
');

1719: -- display table header of LOV
1720: htp.p('

');
1721: htp.p('');

1820:
1821: end loop; -- LOV data
1822:
1823: htp.tableClose;
1824: htp.p('');
1825: htp.p('

');
1826: htp.p('
');
1722: htp.p('');
1723: htp.p('');
1724: for k in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
1725: if ak_query_pkg.g_items_table(k).secured_column = 'F' and
1726: ak_query_pkg.g_items_table(k).node_display_flag = 'Y' then
1727:

Line 1729: htp.p('
');

1794:
1795:
1796: -- display one row of data
1797: if (round(j/2) = j/2) then
1798: htp.p('

');
1799: else
1800: htp.p('');
1801: end if;
1802:

Line 1800: htp.p('
');

1796: -- display one row of data
1797: if (round(j/2) = j/2) then
1798: htp.p('

');
1799: else
1800: htp.p('');
1801: end if;
1802:
1803: l := 0;
1804: for k in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop

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

Line 1813: htp.p(icx_on_utilities.formatData(icx_on_utilities.formatText(l_result_row_table(ak_query_pkg.g_items_table(k).value_id),

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),
1814: 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));
1815: end if;
1816: end if;
1817: end loop;

Line 1819: htp.tableRowClose;

1815: end if;
1816: end if;
1817: end loop;
1818:
1819: htp.tableRowClose;
1820:
1821: end loop; -- LOV data
1822:
1823: htp.tableClose;

Line 1823: htp.tableClose;

1819: htp.tableRowClose;
1820:
1821: end loop; -- LOV data
1822:
1823: htp.tableClose;
1824: htp.p('');
1825: htp.p('

');
1826: htp.p('
'||

1725: if ak_query_pkg.g_items_table(k).secured_column = 'F' and
1726: ak_query_pkg.g_items_table(k).node_display_flag = 'Y' then
1727:
1728: /*
1729: htp.p('

'||
1730: ''||
1731: ak_query_pkg.g_items_table(k).attribute_label_long||
1732: '');
1733: */

Line 1734: htp.p('
'||

1730: ''||
1731: ak_query_pkg.g_items_table(k).attribute_label_long||
1732: '');
1733: */
1734: htp.p('

'||
1735: ''||
1736: ak_query_pkg.g_items_table(k).attribute_label_long||
1737: '');
1738:

Line 1742: htp.tableRowClose;

1738:
1739:
1740: end if;
1741: end loop;
1742: htp.tableRowClose;
1743:
1744: end if; -- CD Buttons and table header
1745:
1746: -- start bug 1853315

Line 1747: htp.tableRowOpen;

1743:
1744: end if; -- CD Buttons and table header
1745:
1746: -- start bug 1853315
1747: htp.tableRowOpen;
1748: htp.p('');
1749: htp.tableRowClose;
1750: -- end bug 1853315
1751:

Line 1748: htp.p('');

1744: end if; -- CD Buttons and table header
1745:
1746: -- start bug 1853315
1747: htp.tableRowOpen;
1748: htp.p('');
1749: htp.tableRowClose;
1750: -- end bug 1853315
1751:
1752:

Line 1749: htp.tableRowClose;

1745:
1746: -- start bug 1853315
1747: htp.tableRowOpen;
1748: htp.p('');
1749: htp.tableRowClose;
1750: -- end bug 1853315
1751:
1752:
1753: -- load data for current row into temp pl/sql table

Line 1798: htp.p('
');
1827:

Line 1824: htp.p('
');
1827:
1828:

Line 1825: htp.p('
');
1827:
1828:
1829: -- print button set if appropriate

Line 1826: htp.p('
');

1822:
1823: htp.tableClose;
1824: htp.p('

');
1827:
1828:
1829: -- print button set if appropriate
1830: if (total_rows > l_query_size) and not

Line 1865: htp.p('

'||fnd_message.get||'

');

1861: and attribute_application_id = p_attribute_app_id
1862: and attribute_code = p_attribute_code;
1863: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
1864: fnd_message.set_token('NAME_OF_REGION_TOKEN',l_attribute_name);
1865: htp.p('

'||fnd_message.get||'

');
1866: end if;
1867:
1868: end if; -- Display results
1869:

Line 1872: htp.p('
');

1868: end if; -- Display results
1869:
1870: else -- ak_query generated an error
1871: fnd_message.set_name('ICX','ICX_MAX_ROWS');
1872: htp.p('

');
1873: htp.p('

'||icx_util.replace_quotes(fnd_message.get)||'

');
1874: htp.p('
');
1875: end if; -- check if error messages were generated by the ak query
1876:

Line 1873: htp.p('

'||icx_util.replace_quotes(fnd_message.get)||'

');

1869:
1870: else -- ak_query generated an error
1871: fnd_message.set_name('ICX','ICX_MAX_ROWS');
1872: htp.p('

');
1873: htp.p('

'||icx_util.replace_quotes(fnd_message.get)||'

');
1874: htp.p('
');
1875: end if; -- check if error messages were generated by the ak query
1876:
1877: htp.formClose;

Line 1874: htp.p('');

1870: else -- ak_query generated an error
1871: fnd_message.set_name('ICX','ICX_MAX_ROWS');
1872: htp.p('

');
1873: htp.p('

'||icx_util.replace_quotes(fnd_message.get)||'

');
1874: htp.p('
');
1875: end if; -- check if error messages were generated by the ak query
1876:
1877: htp.formClose;
1878: htp.bodyClose;

Line 1877: htp.formClose;

1873: htp.p('

'||icx_util.replace_quotes(fnd_message.get)||'

');
1874: htp.p('');
1875: end if; -- check if error messages were generated by the ak query
1876:
1877: htp.formClose;
1878: htp.bodyClose;
1879: htp.htmlClose;
1880:
1881: end if; -- validateSession

Line 1878: htp.bodyClose;

1874: htp.p('');
1875: end if; -- check if error messages were generated by the ak query
1876:
1877: htp.formClose;
1878: htp.bodyClose;
1879: htp.htmlClose;
1880:
1881: end if; -- validateSession
1882:

Line 1879: htp.htmlClose;

1875: end if; -- check if error messages were generated by the ak query
1876:
1877: htp.formClose;
1878: htp.bodyClose;
1879: htp.htmlClose;
1880:
1881: end if; -- validateSession
1882:
1883: exception

Line 1899: htp.p('');

1895:
1896:
1897: procedure copyright is
1898: begin
1899: htp.p('');
1900: end copyright;
1901:
1902: procedure getPrompts( p_region_application_id in number,
1903: p_region_code in varchar2,

Line 2112: htp.htmlOpen;

2108:
2109: j BINARY_INTEGER;
2110: begin
2111:
2112: htp.htmlOpen;
2113: htp.bodyOpen(icx_admin_sig.background);
2114: FND_MESSAGE.SET_NAME('ICX', 'ICX_ERROR');
2115: htp.p('

'||FND_MESSAGE.GET || '

');
2116: htp.p('
    ');

    Line 2113: htp.bodyOpen(icx_admin_sig.background);

    2109: j BINARY_INTEGER;
    2110: begin
    2111:
    2112: htp.htmlOpen;
    2113: htp.bodyOpen(icx_admin_sig.background);
    2114: FND_MESSAGE.SET_NAME('ICX', 'ICX_ERROR');
    2115: htp.p('

    '||FND_MESSAGE.GET || '

    ');
    2116: htp.p('
      ');
      2117: for j in 1..TOTAL_ERRORS loop

      Line 2115: htp.p('

      '||FND_MESSAGE.GET || '

      ');

      2111:
      2112: htp.htmlOpen;
      2113: htp.bodyOpen(icx_admin_sig.background);
      2114: FND_MESSAGE.SET_NAME('ICX', 'ICX_ERROR');
      2115: htp.p('

      '||FND_MESSAGE.GET || '

      ');
      2116: htp.p('
        ');
        2117: for j in 1..TOTAL_ERRORS loop
        2118: htp.p('
      • '||error_table(j));
        2119: end loop;

        Line 2116: htp.p('
          ');

        2112: htp.htmlOpen;
        2113: htp.bodyOpen(icx_admin_sig.background);
        2114: FND_MESSAGE.SET_NAME('ICX', 'ICX_ERROR');
        2115: htp.p('

        '||FND_MESSAGE.GET || '

        ');
        2116: htp.p('
          ');
          2117: for j in 1..TOTAL_ERRORS loop
          2118: htp.p('
        • '||error_table(j));
          2119: end loop;
          2120: htp.p('
        ');

        Line 2118: htp.p('
      • '||error_table(j));

        • 2114: FND_MESSAGE.SET_NAME('ICX', 'ICX_ERROR');
        2115: htp.p('

        '||FND_MESSAGE.GET || '

        ');
        2116: htp.p('
          ');
          2117: for j in 1..TOTAL_ERRORS loop
          2118: htp.p('
        • '||error_table(j));
          2119: end loop;
          2120: htp.p('
        ');
        2121: htp.bodyClose;
        2122: htp.htmlClose;

        Line 2120: htp.p('
      ');

      2116: htp.p('

        ');
        2117: for j in 1..TOTAL_ERRORS loop
        2118: htp.p('
      • '||error_table(j));
        2119: end loop;
        2120: htp.p('
      ');
      2121: htp.bodyClose;
      2122: htp.htmlClose;
      2123:
      2124: end error_page_print;

      Line 2121: htp.bodyClose;

      2117: for j in 1..TOTAL_ERRORS loop
      2118: htp.p('

    • '||error_table(j));
      2119: end loop;
      2120: htp.p('
    ');
    2121: htp.bodyClose;
    2122: htp.htmlClose;
    2123:
    2124: end error_page_print;
    2125:

    Line 2122: htp.htmlClose;

    2118: htp.p('

  • '||error_table(j));
    2119: end loop;
    2120: htp.p('
');
2121: htp.bodyClose;
2122: htp.htmlClose;
2123:
2124: end error_page_print;
2125:
2126: ----------------------------------------------------------------------------

Line 2133: htp.p(FND_MESSAGE.GET);

2129:
2130: j BINARY_INTEGER;
2131: begin
2132: FND_MESSAGE.SET_NAME('ICX', 'ICX_ERROR');
2133: htp.p(FND_MESSAGE.GET);
2134: htp.p('---------------------------------------------------------');
2135: for j in 1..TOTAL_ERRORS loop
2136: htp.p(error_table(j));
2137: end loop;

Line 2134: htp.p('---------------------------------------------------------');

2130: j BINARY_INTEGER;
2131: begin
2132: FND_MESSAGE.SET_NAME('ICX', 'ICX_ERROR');
2133: htp.p(FND_MESSAGE.GET);
2134: htp.p('---------------------------------------------------------');
2135: for j in 1..TOTAL_ERRORS loop
2136: htp.p(error_table(j));
2137: end loop;
2138: end;

Line 2136: htp.p(error_table(j));

2132: FND_MESSAGE.SET_NAME('ICX', 'ICX_ERROR');
2133: htp.p(FND_MESSAGE.GET);
2134: htp.p('---------------------------------------------------------');
2135: for j in 1..TOTAL_ERRORS loop
2136: htp.p(error_table(j));
2137: end loop;
2138: end;
2139:
2140: ----------------------------------------------------------------------------

Line 2496: htp.p('document.write("'||replace(P_text,'"','\"')||'");');

2492: -- Embed HTML tags within document.write and replace quotes with
2493: -- backslash quotes if P_JavaScriptFlag = TRUE
2494: --
2495: if (P_JavaScriptFlag) then
2496: htp.p('document.write("'||replace(P_text,'"','\"')||'");');
2497: else
2498: htp.p(P_text);
2499: end if;
2500: END;

Line 2498: htp.p(P_text);

2494: --
2495: if (P_JavaScriptFlag) then
2496: htp.p('document.write("'||replace(P_text,'"','\"')||'");');
2497: else
2498: htp.p(P_text);
2499: end if;
2500: END;
2501:
2502: BEGIN

Line 2620: htp.p('');
2627:

Line 2625: htp.p('// -->');

2621: htp.p('');
2626: htp.p('');
2627:
2628: end;
2629:

Line 2626: htp.p('');

2622: -- dynamicButton(p_text,p_alt,p_over,p_language,p_image,p_url,p_flag);
2623: htp.p('dynamicButton("'||replace_alt_quotes(P_ButtonText)||'","'||replace_alt_quotes(P_OnMouseOverText)||'","'
2624: ||replace(replace_onMouseOver_quotes(P_OnMouseOverText),'\''','\\''')||'","'||P_LanguageCode||'","'||l_ImageFileName||'","'||P_HyperTextCall||'","'||l_DisabledFlag||'")');
2625: htp.p('// -->');
2626: htp.p('');
2627:
2628: end;
2629:
2630: PROCEDURE DynamicButtonIn(P_ButtonText varchar2,

Line 2650: htp.p('document.write("'||replace(P_text,'"','\"')||'");');

2646: -- backslash quotes if P_JavaScriptFlag = TRUE
2647:
2648: --
2649: if (P_JavaScriptFlag) then
2650: htp.p('document.write("'||replace(P_text,'"','\"')||'");');
2651: else
2652: htp.p(P_text);
2653: end if;
2654: END;

Line 2652: htp.p(P_text);

2648: --
2649: if (P_JavaScriptFlag) then
2650: htp.p('document.write("'||replace(P_text,'"','\"')||'");');
2651: else
2652: htp.p(P_text);
2653: end if;
2654: END;
2655:
2656: BEGIN