DBA Data[Home] [Help]

APPS.BIS_BUSINESS_VIEWS_CATALOG dependencies on HTP

Line 32: htp.p('');

28: l_lang := ICX_SEC.getID(icx_sec.PV_LANGUAGE_CODE);
29:
30:
31: -- Begin painting the table structure for the plug
32: htp.p('

');
33:
34: htp.p(' ');
35: htp.p(' ');

30:
31: -- Begin painting the table structure for the plug
32: htp.p('

');
36: ICX_PLUG_UTILITIES.plugbanner

Line 34: htp.p('
');
33:
34: htp.p(' ');
35: htp.p('');
325: htp.p('
');
36: ICX_PLUG_UTILITIES.plugbanner
37: ( p_text => NVL(p_display_name, c_title)
38: , p_icon => 'FNDBVCAT.gif'

Line 35: htp.p('
 ');

31: -- Begin painting the table structure for the plug
32: htp.p('');
33:
34: htp.p(' ');
35: htp.p(' ');

36: ICX_PLUG_UTILITIES.plugbanner
37: ( p_text => NVL(p_display_name, c_title)
38: , p_icon => 'FNDBVCAT.gif'
39: );
40: htp.p(' ');
41: htp.p('

 ');
42:
43: htp.p(' ');
44: htp.p(' ');

37: ( p_text => NVL(p_display_name, c_title)
38: , p_icon => 'FNDBVCAT.gif'
39: );
40: htp.p(' ');
41: htp.p(' ');
42:
43: htp.p('

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

39: );
40: htp.p(' ');
41: htp.p('

 ');
42:
43: htp.p(' ');
44: htp.p(' ');
41: htp.p(' ');
42:
43: htp.p(' ');
44: htp.p(' ');

Line 45: htp.p(' ');

41: htp.p('

 ');
42:
43: htp.p(' ');
44: htp.p(' ');
49: htp.p(' ');

Line 46: htp.p('
');

42:
43: htp.p('

 ');
44: htp.p(' ');
49: htp.p(' ');
50:

Line 47: htp.p(' ');

43: htp.p('

 ');
44: htp.p(' ');
49: htp.p(' ');
50:
51: htp.p(' ');

Line 48: htp.p(' ');

44: htp.p('

 ');
49: htp.p(' ');
50:
51: htp.p(' ');
52: htp.p(' ');

45: htp.p(' ');
46: htp.p('
');
47: htp.p(' ');
48: htp.p(' ');
49: htp.p(' ');
50:
51: htp.p('

 ');
52: htp.p(' ');
328: htp.p('
');
36: ICX_PLUG_UTILITIES.plugbanner
37: ( p_text => NVL(p_display_name, c_title)
38: , p_icon => 'FNDBVCAT.gif'
39: );

Line 40: htp.p('
');

Line 41: htp.p('
');
45: htp.p(' ');

Line 43: htp.p('
');
45: htp.p(' ');
46: htp.p('
');
47: htp.p(' ');

Line 44: htp.p('
 ');

40: htp.p('

');
45: htp.p(' ');
46: htp.p('
');
47: htp.p(' ');
48: htp.p('
');
45: htp.p(' ');
46: htp.p('
');
47: htp.p(' ');
48: htp.p('
');
45: htp.p(' ');
46: htp.p('
');
47: htp.p(' ');
48: htp.p('
');
45: htp.p(' ');
46: htp.p('
');
47: htp.p(' ');
48: htp.p('
');
45: htp.p(' ');
46: htp.p('
');
47: htp.p(' ');
48: htp.p('
');

Line 49: htp.p('
');
53: htp.p('');

Line 51: htp.p('
');

47: htp.p(' ');
48: htp.p(' ');
49: htp.p('

');
50:
51: htp.p(' ');
52: htp.p('
');
53: htp.p('');
54: htp.p(' ');
55: -- ********************** OPEN FORM ************************

Line 52: htp.p('
');
49: htp.p(' ');
50:
51: htp.p(' ');
52: htp.p('');
277: htp.p('');
278:
279: END LOOP; -- End of the p_results_tbl.COUNT loop
280: htp.p('
');

48: htp.p('

');
53: htp.p('');
54: htp.p(' ');
55: -- ********************** OPEN FORM ************************
56: htp.formOpen(icx_plug_utilities.getplsqlagent||'BIS_BUSINESS_VIEWS_CATALOG.query'

Line 53: htp.p('
');

49: htp.p(' ');
50:
51: htp.p('

');
52: htp.p('
');
53: htp.p('');
54: htp.p(' ');
55: -- ********************** OPEN FORM ************************
56: htp.formOpen(icx_plug_utilities.getplsqlagent||'BIS_BUSINESS_VIEWS_CATALOG.query'
57: ,'POST','','','NAME="BVC"');

Line 54: htp.p('
');

50:
51: htp.p('

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

273: htp.p('');
274: htp.p('

');
277: htp.p('');
278:
279: END LOOP; -- End of the p_results_tbl.COUNT loop
280: htp.p('
');
53: htp.p('');
54: htp.p(' ');
55: -- ********************** OPEN FORM ************************
56: htp.formOpen(icx_plug_utilities.getplsqlagent||'BIS_BUSINESS_VIEWS_CATALOG.query'
57: ,'POST','','','NAME="BVC"');
58: htp.formHidden('p_lang',l_lang);

Line 56: htp.formOpen(icx_plug_utilities.getplsqlagent||'BIS_BUSINESS_VIEWS_CATALOG.query'

52: htp.p('

');

183: procedure insert_blank_cell
184: is
185: begin
186:
187: htp.p('

');
188:
189: end insert_blank_cell;
190:
191:

Line 212: htp.p('');

208: BEGIN
209:
210: --ICX_UTIL.getPrompts(191, 'BIS_BVC_PROMPTS, l_title, l_prompts);
211:
212: htp.p('');
213:
214: IF (p_results_tbl.COUNT = 0) THEN NULL;
215:
216: ELSE

Line 217: -- htp.p('Total Hits = '||p_results_tbl.COUNT );

213:
214: IF (p_results_tbl.COUNT = 0) THEN NULL;
215:
216: ELSE
217: -- htp.p('Total Hits = '||p_results_tbl.COUNT );
218:
219: -- Begin painting the table containing the results
220: -- ********* Paint the Headers first **************
221: htp.p('

');
53: htp.p('');
54: htp.p(' ');
55: -- ********************** OPEN FORM ************************
56: htp.formOpen(icx_plug_utilities.getplsqlagent||'BIS_BUSINESS_VIEWS_CATALOG.query'
57: ,'POST','','','NAME="BVC"');
58: htp.formHidden('p_lang',l_lang);
59:
60: htp.p(' ');
55: -- ********************** OPEN FORM ************************
56: htp.formOpen(icx_plug_utilities.getplsqlagent||'BIS_BUSINESS_VIEWS_CATALOG.query'
57: ,'POST','','','NAME="BVC"');
58: htp.formHidden('p_lang',l_lang);
59:
60: htp.p(' ');

Line 60: htp.p('
');
63:
64: insert_blank_cell;

Line 61: htp.p(' ');

57: ,'POST','','','NAME="BVC"');
58: htp.formHidden('p_lang',l_lang);
59:
60: htp.p('

');
63:
64: insert_blank_cell;
65:

Line 62: htp.p(' ');

58: htp.formHidden('p_lang',l_lang);
59:
60: htp.p('

');
63:
64: insert_blank_cell;
65:
66: htp.p(' ');
63:
64: insert_blank_cell;
65:
66: htp.p(' ');
69:
70: htp.formClose;

Line 68: htp.p(' ');

64: insert_blank_cell;
65:
66: htp.p('

 ');
69:
70: htp.formClose;
71: -- ************************ CLOSE FORM ***********************
72: htp.p(' ');

Line 70: htp.formClose;

66: htp.p('

');
69:
70: htp.formClose;
71: -- ************************ CLOSE FORM ***********************
72: htp.p(' ');
73: htp.tableClose;
74:

Line 72: htp.p(' ');

68: htp.p(' ');
69:
70: htp.formClose;
71: -- ************************ CLOSE FORM ***********************
72: htp.p(' ');
73: htp.tableClose;
74:
75: htp.p(' ');
76: htp.p(' ');

Line 73: htp.tableClose;

69:
70: htp.formClose;
71: -- ************************ CLOSE FORM ***********************
72: htp.p(' ');
73: htp.tableClose;
74:
75: htp.p(' ');
76: htp.p(' ');
77:

Line 75: htp.p(' ');

71: -- ************************ CLOSE FORM ***********************
72: htp.p(' ');
73: htp.tableClose;
74:
75: htp.p(' ');
76: htp.p(' ');
77:
78: htp.p('

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

72: htp.p(' ');
73: htp.tableClose;
74:
75: htp.p(' ');
76: htp.p(' ');
77:
78: htp.p('

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

74:
75: htp.p(' ');
76: htp.p('

');
77:
78: htp.p(' ');
79: htp.p(' ');
82: htp.p(' ');

Line 79: htp.p('
');
76: htp.p(' ');
77:
78: htp.p(' ');
79: htp.p(' ');
82: htp.p(' ');
83:

Line 80: htp.p('
');

76: htp.p(' ');
77:
78: htp.p('

 ');
79: htp.p(' ');
82: htp.p(' ');
83:
84: htp.tableClose;

Line 81: htp.p(' ');

77:
78: htp.p('

 ');
79: htp.p(' ');
82: htp.p(' ');
83:
84: htp.tableClose;
85:

Line 82: htp.p(' ');

78: htp.p('

');
79: htp.p(' ');
82: htp.p(' ');
83:
84: htp.tableClose;
85:
86: END IF;

Line 84: htp.tableClose;

80: htp.p('
');
81: htp.p(' ');
82: htp.p(' ');
83:
84: htp.tableClose;
85:
86: END IF;
87:
88: EXCEPTION

Line 90: htp.p( SQLERRM );

86: END IF;
87:
88: EXCEPTION
89: WHEN OTHERS THEN
90: htp.p( SQLERRM );
91:
92: END enter_query_page_plug;
93:
94: -- ************************************************************

Line 148: htp.p('
');
158:
159: end insert_heading_cell;
160:
161: -- ************************************************************

Line 168: htp.p('
');
177:
178: end insert_blank_heading_cell;
179:

Line 176: htp.p(' ');

172: htp.p('
');
173: htp.p(' ');
174: htp.p('

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

Line 58: htp.formHidden('p_lang',l_lang);

54: htp.p('

');
61: htp.p(' ');
62: htp.p('		 ');

56: htp.formOpen(icx_plug_utilities.getplsqlagent||'BIS_BUSINESS_VIEWS_CATALOG.query'
57: ,'POST','','','NAME="BVC"');
58: htp.formHidden('p_lang',l_lang);
59:
60: htp.p('

 ');
61: htp.p(' ');
62: htp.p('		 ');
61: htp.p(' ');
62: htp.p('		 ');
61: htp.p(' ');
62: htp.p('		 ');

Line 66: htp.p('
 ');

62: htp.p('

 ');
67: icx_plug_utilities.buttonboth (c_submit, 'javascript:document.BVC.submit()');
68: htp.p('		 ');
67: icx_plug_utilities.buttonboth (c_submit, 'javascript:document.BVC.submit()');
68: htp.p('
');
67: icx_plug_utilities.buttonboth (c_submit, 'javascript:document.BVC.submit()');
68: htp.p('
');

Line 76: htp.p('
');
80: htp.p('
');

Line 78: htp.p('
');
80: htp.p('
');
81: htp.p('
');

75: htp.p('

');
80: htp.p('
');
81: htp.p('
');
80: htp.p('
');
81: htp.p('
');
80: htp.p('
');
81: htp.p('
');
80: htp.p('
');
81: htp.p('
');

144: procedure insert_heading_cell( p_text in varchar2 )
145: is
146: begin
147:
148: htp.p('

');
149: htp.p(' ');
150: htp.p(' ');
151: htp.p(' ');
158:
159: end insert_heading_cell;
160:

Line 157: htp.p(' ');

153: htp.p( p_text );
154: htp.p(' ');
155: htp.p('

');
156: htp.p('
');
152: htp.p(' ');

Line 149: htp.p(' ');

145: is
146: begin
147:
148: htp.p('

');
155: htp.p(' ');
156: htp.p('
');
149: htp.p(' ');
150: htp.p(' ');
151: htp.p(' ');

146: begin
147:
148: htp.p('

');
158:
159: end insert_heading_cell;

Line 156: htp.p('
');
152: htp.p(' ');
153: htp.p( p_text );

Line 150: htp.p('
');
149: htp.p(' ');
150: htp.p(' ');
151: htp.p(' ');

Line 151: htp.p('
');
158:

Line 155: htp.p('
');

151: htp.p('

');
155: htp.p(' ');
156: htp.p('
');
152: htp.p(' ');
153: htp.p( p_text );
154: htp.p(' 		');

147:
148: htp.p('

');
149: htp.p(' ');
150: htp.p(' ');
151: htp.p(' ');
155: htp.p(' ');

Line 152: htp.p(' ');

148: htp.p('

 ');

Line 154: htp.p(' ');

150: htp.p('

');
151: htp.p(' ');
155: htp.p(' ');
156: htp.p('
');
152: htp.p(' ');
153: htp.p( p_text );
154: htp.p('
');
149: htp.p(' ');
150: htp.p(' ');
151: htp.p(' ');
155: htp.p(' ');
156: htp.p('
');
152: htp.p(' ');
153: htp.p( p_text );
154: htp.p('
');

Line 153: htp.p( p_text );

149: htp.p(' ');
150: htp.p(' ');
151: htp.p(' ');
155: htp.p(' ');
156: htp.p('
');
152: htp.p(' ');
153: htp.p( p_text );
154: htp.p('
');
157: htp.p('

');
152: htp.p(' ');
153: htp.p( p_text );
154: htp.p('
');
157: htp.p('
');
152: htp.p(' ');
153: htp.p( p_text );
154: htp.p('
');
157: htp.p('
');

152: htp.p(' ');
153: htp.p( p_text );
154: htp.p('

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

164: procedure insert_blank_heading_cell
165: is
166: begin
167:
168: htp.p('

');
169: htp.p(' ');
170: htp.p(' ');
171: htp.p(' ');
174: htp.p(' ');
175: htp.p('
');
172: htp.p('
');

Line 169: htp.p(' ');

165: is
166: begin
167:
168: htp.p('

');
177:
178: end insert_blank_heading_cell;

Line 175: htp.p('
');
169: htp.p(' ');
170: htp.p(' ');
171: htp.p(' ');

Line 170: htp.p('
');

166: begin
167:
168: htp.p('

');
177:

Line 174: htp.p('
');

170: htp.p('

');
171: htp.p(' ');
174: htp.p(' ');
175: htp.p('
');
172: htp.p('
');
173: htp.p('
');
169: htp.p(' ');
170: htp.p(' ');
171: htp.p(' ');
174: htp.p(' ');

Line 171: htp.p('
');

Line 173: htp.p(' ');

169: htp.p('

');
172: htp.p('
');
173: htp.p('
');

167:
168: htp.p('

');
169: htp.p(' ');
170: htp.p(' ');
171: htp.p(' ');
174: htp.p(' ');
175: htp.p('
');
172: htp.p('
');
173: htp.p('
');

Line 172: htp.p('
');

168: htp.p('

');
169: htp.p(' ');
170: htp.p(' ');
171: htp.p(' ');
174: htp.p(' ');
175: htp.p('
');
172: htp.p('
');
173: htp.p('
');
176: htp.p('
');
170: htp.p(' ');
171: htp.p(' ');
174: htp.p(' ');
175: htp.p('
');
172: htp.p('
');
173: htp.p('
');
176: htp.p('
');
172: htp.p('
');
173: htp.p('
');
176: htp.p('
');

171: htp.p('

');
172: htp.p('
');
173: htp.p('
');
176: htp.p('
');
176: htp.p(' ');
177:
178: end insert_blank_heading_cell;
179:
180: -- ************************************************************

Line 187: htp.p('
'||'&'||'nbsp '||'&'||'nbsp
');

Line 221: htp.p('
');

217: -- htp.p('Total Hits = '||p_results_tbl.COUNT );
218:
219: -- Begin painting the table containing the results
220: -- ********* Paint the Headers first **************
221: htp.p('

');
222: htp.p(' ');
223: insert_blank_heading_cell;
224: insert_heading_cell(c_folder);
225:

Line 222: htp.p('
');

218:
219: -- Begin painting the table containing the results
220: -- ********* Paint the Headers first **************
221: htp.p('

');
222: htp.p(' ');
223: insert_blank_heading_cell;
224: insert_heading_cell(c_folder);
225:
226: insert_blank_heading_cell;

Line 228: htp.p('
');
232:

Line 229: htp.p(' ');

225:
226: insert_blank_heading_cell;
227:
228: htp.p('

');
232:
233: insert_blank_heading_cell;

Line 230: htp.p(c_busarea);

226: insert_blank_heading_cell;
227:
228: htp.p('

 ');
232:
233: insert_blank_heading_cell;
234:

Line 231: htp.p(' ');

227:
228: htp.p('

 ');
232:
233: insert_blank_heading_cell;
234:
235: htp.p(' ');
232:
233: insert_blank_heading_cell;
234:
235: htp.p(' ');
239: htp.p(' ');

Line 236: htp.p(' ');

232:
233: insert_blank_heading_cell;
234:
235: htp.p('

 ');
239: htp.p(' ');
240: -- ******************** Headers end **********************

Line 237: htp.p(c_desc);

233: insert_blank_heading_cell;
234:
235: htp.p('

 ');
239: htp.p(' ');
240: -- ******************** Headers end **********************
241:

Line 238: htp.p(' ');

234:
235: htp.p('

 ');
239: htp.p(' ');
240: -- ******************** Headers end **********************
241:
242: l_eul := BIS_GNRL_SEARCH_ENGINE_PVT.get_a_index_owner

Line 239: htp.p(' ');

235: htp.p('

 ');
239: htp.p(' ');
240: -- ******************** Headers end **********************
241:
242: l_eul := BIS_GNRL_SEARCH_ENGINE_PVT.get_a_index_owner
243: ( 'BIS_BV_FOLDER_NAMES_' || p_lang );

Line 258: htp.p('
');

254: l_ba := get_a_business_area( p_folder_id => p_results_tbl(i).folder_id
255: ,p_eul => l_eul );
256:
257: -- Start the table rows
258: htp.p('

');
259: htp.p('');
262: htp.p('');
259: htp.p('');
262: htp.p('');
259: htp.p('');
262: htp.p('');

Line 261: htp.p('');

257: -- Start the table rows
258: htp.p('

');
259: htp.p('');
262: htp.p('');
265: htp.p('');
259: htp.p('');
262: htp.p('');
265: htp.p('');
262: htp.p('');
265: htp.p('');

Line 264: htp.p('');

260: htp.p('
');
261: htp.p('');
262: htp.p('

');
265: htp.p('');
268: htp.p('');
262: htp.p('');
265: htp.p('');
268: htp.p('');
265: htp.p('');
268: htp.p(' ');

Line 267: htp.p('');

263: htp.p(p_results_tbl(i).folder_name);
264: htp.p('');
265: htp.p('

');
268: htp.p(' ');
271: htp.p('');
265: htp.p('');
268: htp.p(' ');
271: htp.p('');
268: htp.p(' ');
271: htp.p('');

Line 270: htp.p(' ');

266: htp.p('
');
267: htp.p('');
268: htp.p('

 ');
271: htp.p('');
274: htp.p('');
268: htp.p(' ');
271: htp.p('');
274: htp.p(' ');
271: htp.p('');
274: htp.p('');

Line 273: htp.p('');

269: htp.p( l_ba );
270: htp.p(' ');
271: htp.p('

');
274: htp.p('');
277: htp.p('');

Line 274: htp.p('
 ');
271: htp.p('');
274: htp.p('');
277: htp.p('');
278:

Line 275: htp.p( p_results_tbl(i).folder_description );

271: htp.p('

');
274: htp.p('');
277: htp.p('');
278:
279: END LOOP; -- End of the p_results_tbl.COUNT loop

Line 276: htp.p('');

272: htp.p('
');
273: htp.p('');
274: htp.p('

');
277: htp.p('');
278:
279: END LOOP; -- End of the p_results_tbl.COUNT loop
280: htp.p('
');

224: insert_heading_cell(c_folder);
225:
226: insert_blank_heading_cell;
227:
228: htp.p('

');
229: htp.p(' ');
230: htp.p(c_busarea);
231: htp.p('		 ');
229: htp.p(' ');
230: htp.p(c_busarea);
231: htp.p('		');
229: htp.p(' ');
230: htp.p(c_busarea);
231: htp.p('		');
229: htp.p(' ');
230: htp.p(c_busarea);
231: htp.p('		');

Line 235: htp.p('
');

231: htp.p('

');
236: htp.p(' ');
237: htp.p(c_desc);
238: htp.p('
');
236: htp.p(' ');
237: htp.p(c_desc);
238: htp.p('
');
236: htp.p(' ');
237: htp.p(c_desc);
238: htp.p('
');
236: htp.p(' ');
237: htp.p(c_desc);
238: htp.p('
');
236: htp.p(' ');
237: htp.p(c_desc);
238: htp.p('
');
260: htp.p('
');
261: htp.p('		');

Line 259: htp.p('
');

255: ,p_eul => l_eul );
256:
257: -- Start the table rows
258: htp.p('

');
260: htp.p('
');
261: htp.p('		');
263: htp.p(p_results_tbl(i).folder_name);

Line 260: htp.p('
');

256:
257: -- Start the table rows
258: htp.p('

');
260: htp.p('
');
261: htp.p('		');
263: htp.p(p_results_tbl(i).folder_name);
264: htp.p('
');
260: htp.p('
');
261: htp.p('		');
263: htp.p(p_results_tbl(i).folder_name);
264: htp.p('		');

Line 262: htp.p('
');

258: htp.p('

');
260: htp.p('
');
261: htp.p('		');
263: htp.p(p_results_tbl(i).folder_name);
264: htp.p('		');
266: htp.p('
');

Line 263: htp.p(p_results_tbl(i).folder_name);

259: htp.p('

');
260: htp.p('
');
261: htp.p('		');
263: htp.p(p_results_tbl(i).folder_name);
264: htp.p('		');
266: htp.p('
');
267: htp.p('		');
263: htp.p(p_results_tbl(i).folder_name);
264: htp.p('		');
266: htp.p('
');
267: htp.p('		');

Line 265: htp.p('
');

261: htp.p('

');
263: htp.p(p_results_tbl(i).folder_name);
264: htp.p('		');
266: htp.p('
');
267: htp.p('		');
269: htp.p( l_ba );

Line 266: htp.p('
');

262: htp.p('

');
263: htp.p(p_results_tbl(i).folder_name);
264: htp.p('		');
266: htp.p('
');
267: htp.p('		');
269: htp.p( l_ba );
270: htp.p('		');
266: htp.p('
');
267: htp.p('		');
269: htp.p( l_ba );
270: htp.p('		 ');

Line 268: htp.p('
');

264: htp.p('

');
266: htp.p('
');
267: htp.p('		');
269: htp.p( l_ba );
270: htp.p('		 ');
272: htp.p('
');

Line 269: htp.p( l_ba );

265: htp.p('

');
266: htp.p('
');
267: htp.p('		');
269: htp.p( l_ba );
270: htp.p('		 ');
272: htp.p('
');
273: htp.p('		');
269: htp.p( l_ba );
270: htp.p('		 ');
272: htp.p('
');
273: htp.p('		');

Line 271: htp.p('
 ');

267: htp.p('

');
269: htp.p( l_ba );
270: htp.p('		 ');
272: htp.p('
');
273: htp.p('		');
275: htp.p( p_results_tbl(i).folder_description );

Line 272: htp.p('
');

268: htp.p('

');
269: htp.p( l_ba );
270: htp.p('		 ');
272: htp.p('
');
273: htp.p('		');
275: htp.p( p_results_tbl(i).folder_description );
276: htp.p('		 ');
272: htp.p('
');
273: htp.p('		');
275: htp.p( p_results_tbl(i).folder_description );
276: htp.p('
');

270: htp.p('

 ');
272: htp.p('
');
273: htp.p('		');
275: htp.p( p_results_tbl(i).folder_description );
276: htp.p('
');
272: htp.p('
');
273: htp.p('		');
275: htp.p( p_results_tbl(i).folder_description );
276: htp.p('
');
275: htp.p( p_results_tbl(i).folder_description );
276: htp.p('
');

Line 277: htp.p('
');
275: htp.p( p_results_tbl(i).folder_description );
276: htp.p('
');
281:

Line 280: htp.p('
');

276: htp.p('

');
281:
282: END IF; -- if p_results_tbl.COUNT is ZERO
283:
284: htp.bodyClose;

Line 284: htp.bodyClose;

280: htp.p('

');
281:
282: END IF; -- if p_results_tbl.COUNT is ZERO
283:
284: htp.bodyClose;
285: htp.htmlClose;
286: EXCEPTION
287: WHEN BIS_GNRL_SEARCH_ENGINE_PVT.e_noIndexDefined THEN RAISE;
288: WHEN OTHERS THEN htp.p(SQLERRM);

Line 285: htp.htmlClose;

281:
282: END IF; -- if p_results_tbl.COUNT is ZERO
283:
284: htp.bodyClose;
285: htp.htmlClose;
286: EXCEPTION
287: WHEN BIS_GNRL_SEARCH_ENGINE_PVT.e_noIndexDefined THEN RAISE;
288: WHEN OTHERS THEN htp.p(SQLERRM);
289:

Line 288: WHEN OTHERS THEN htp.p(SQLERRM);

284: htp.bodyClose;
285: htp.htmlClose;
286: EXCEPTION
287: WHEN BIS_GNRL_SEARCH_ENGINE_PVT.e_noIndexDefined THEN RAISE;
288: WHEN OTHERS THEN htp.p(SQLERRM);
289:
290: END results_page;
291:
292: -- *********************************************************

Line 311: htp.htmlopen;

307:
308: --ICX_UTIL.getPrompts(191, 'BIS_BVC_PROMPTS, l_title, l_prompts);
309: --l_submit := l_prompts(5);
310:
311: htp.htmlopen;
312: htp.headopen;
313: htp.title( c_title );
314: htp.headclose;
315: htp.p('');

Line 312: htp.headopen;

308: --ICX_UTIL.getPrompts(191, 'BIS_BVC_PROMPTS, l_title, l_prompts);
309: --l_submit := l_prompts(5);
310:
311: htp.htmlopen;
312: htp.headopen;
313: htp.title( c_title );
314: htp.headclose;
315: htp.p('');
316:

Line 313: htp.title( c_title );

309: --l_submit := l_prompts(5);
310:
311: htp.htmlopen;
312: htp.headopen;
313: htp.title( c_title );
314: htp.headclose;
315: htp.p('');
316:
317: htp.p('');

Line 314: htp.headclose;

310:
311: htp.htmlopen;
312: htp.headopen;
313: htp.title( c_title );
314: htp.headclose;
315: htp.p('');
316:
317: htp.p('

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

Line 315: htp.p('');

311: htp.htmlopen;
312: htp.headopen;
313: htp.title( c_title );
314: htp.headclose;
315: htp.p('');
316:
317: htp.p('

');
318: htp.p(' ');
319: ICX_PLUG_UTILITIES.toolbar (

Line 317: htp.p('
');

313: htp.title( c_title );
314: htp.headclose;
315: htp.p('');
316:
317: htp.p('

');
318: htp.p(' ');
319: ICX_PLUG_UTILITIES.toolbar (
320: p_text => c_title
321: , p_disp_mainmenu => 'Y'

Line 318: htp.p('
');

314: htp.headclose;
315: htp.p('');
316:
317: htp.p('

');
318: htp.p(' ');
319: ICX_PLUG_UTILITIES.toolbar (
320: p_text => c_title
321: , p_disp_mainmenu => 'Y'
322: , p_disp_menu => 'N'

Line 324: htp.p('
');

320: p_text => c_title
321: , p_disp_mainmenu => 'Y'
322: , p_disp_menu => 'N'
323: );
324: htp.p('');
325: htp.p('

');
326:
327: htp.p('

');

Line 325: htp.p('
');

321: , p_disp_mainmenu => 'Y'
322: , p_disp_menu => 'N'
323: );
324: htp.p('

');
326:
327: htp.p(' ');
328: htp.p(' ');
329: htp.p('
');

Line 327: htp.p(' ');

323: );
324: htp.p('');
325: htp.p(' ');
326:
327: htp.p(' ');
328: htp.p(' ');
329: htp.p('
');
330: htp.p(' ');
331: htp.p(' ');

Line 328: htp.p(' ');

324: htp.p('');
325: htp.p(' ');
326:
327: htp.p(' ');
328: htp.p(' ');
329: htp.p('
');
330: htp.p(' ');
331: htp.p(' ');
332:

Line 329: htp.p('
');

325: htp.p(' ');
326:
327: htp.p(' ');
328: htp.p(' ');
329: htp.p('
');
330: htp.p(' ');
331: htp.p(' ');
332:
333: htp.p('');

Line 330: htp.p(' ');

326:
327: htp.p('

');
328: htp.p(' ');
331: htp.p(' ');
332:
333: htp.p('
');
329: htp.p('
');
330: htp.p('
');
334:

Line 331: htp.p(' ');

327: htp.p('

');
328: htp.p(' ');
331: htp.p(' ');
332:
333: htp.p('
');
329: htp.p('
');
330: htp.p('
');
334:
335: -- ************** OPEN FORM *******************************

Line 333: htp.p('
');

329: htp.p('
');
330: htp.p(' ');
331: htp.p(' ');
332:
333: htp.p('

');
334:
335: -- ************** OPEN FORM *******************************
336: htp.formOpen('BIS_BUSINESS_VIEWS_CATALOG.query'
337: ,'POST','','','NAME="BVC"');

Line 336: htp.formOpen('BIS_BUSINESS_VIEWS_CATALOG.query'

332:
333: htp.p('

');
334:
335: -- ************** OPEN FORM *******************************
336: htp.formOpen('BIS_BUSINESS_VIEWS_CATALOG.query'
337: ,'POST','','','NAME="BVC"');
338:
339: htp.formHidden('p_lang',p_lang);
340:

Line 339: htp.formHidden('p_lang',p_lang);

335: -- ************** OPEN FORM *******************************
336: htp.formOpen('BIS_BUSINESS_VIEWS_CATALOG.query'
337: ,'POST','','','NAME="BVC"');
338:
339: htp.formHidden('p_lang',p_lang);
340:
341: htp.p('

');
342: htp.p(' ');
359: htp.p(' ');
360:
361: htp.formClose;
362: -- ****************** CLOSE FORM ******************************
363:

Line 361: htp.formClose;

357:
358: htp.p(' ');
359: htp.p(' ');
360:
361: htp.formClose;
362: -- ****************** CLOSE FORM ******************************
363:
364: htp.p('

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

360:
361: htp.formClose;
362: -- ****************** CLOSE FORM ******************************
363:
364: htp.p('

');
365: htp.p(' ');
368: htp.p(' ');

Line 365: htp.p('
');
365: htp.p(' ');
368: htp.p(' ');
369:

Line 366: htp.p('
');

362: -- ****************** CLOSE FORM ******************************
363:
364: htp.p('

 ');
365: htp.p(' ');
368: htp.p(' ');
369:
370: htp.p(' ');

Line 367: htp.p(' ');

363:
364: htp.p('

 ');
365: htp.p(' ');
368: htp.p(' ');
369:
370: htp.p(' ');
371: htp.p(' ');

364: htp.p('

');
365: htp.p(' ');
368: htp.p(' ');
369:
370: htp.p(' ');
371: htp.p(' ');

366: htp.p('
');
367: htp.p(' ');
368: htp.p('

');
369:
370: htp.p(' ');
371: htp.p(' ');
374: htp.p(' ');

Line 371: htp.p('
');
368: htp.p(' ');
369:
370: htp.p(' ');
371: htp.p(' ');
374: htp.p(' ');
375:

Line 372: htp.p('
');

368: htp.p(' ');
369:
370: htp.p('

 ');
371: htp.p(' ');
374: htp.p(' ');
375:
376: htp.p('
');
343: htp.p('');

Line 341: htp.p('
');

337: ,'POST','','','NAME="BVC"');
338:
339: htp.formHidden('p_lang',p_lang);
340:
341: htp.p('

');
342: htp.p(' ');
359: htp.p(' ');
360:
361: htp.formClose;
362: -- ****************** CLOSE FORM ******************************

Line 359: htp.p(' ');

355: htp.p(' ');
356: htp.p('

');
343: htp.p('');
344:
345: htp.p(' ');

Line 342: htp.p('
');
342: htp.p(' ');
359: htp.p(' ');
360:

Line 358: htp.p(' ');

354: htp.p(' ');
355: htp.p(' ');
356: htp.p('

');

338:
339: htp.formHidden('p_lang',p_lang);
340:
341: htp.p('

');
343: htp.p('');
344:
345: htp.p(' ');
346: htp.p(' ');
355: htp.p(' ');
356: htp.p('
');

Line 343: htp.p('');

339: htp.formHidden('p_lang',p_lang);
340:
341: htp.p('

');
342: htp.p(' ');
359: htp.p(' ');

Line 356: htp.p('
');
343: htp.p('');
344:
345: htp.p(' ');
346: htp.p(' ');

341: htp.p('

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

Line 355: htp.p('
');

351:
352: htp.p('

');
355: htp.p(' ');
356: htp.p('
');
347: htp.p('' );

Line 345: htp.p('
');
343: htp.p('');
344:
345: htp.p(' ');
346: htp.p(' ');
349:

Line 346: htp.p('
');

350: insert_blank_cell;
351:
352: htp.p('

');
355: htp.p(' ');
356: htp.p('
');
347: htp.p('' );
348: htp.p('		 ');

342: htp.p('

 ');
343: htp.p('');
344:
345: htp.p(' ');
346: htp.p(' ');
349:
350: insert_blank_cell;

Line 347: htp.p('' );

343: htp.p('

');
347: htp.p('' );
348: htp.p('
');
344:
345: htp.p(' ');
346: htp.p(' ');
349:
350: insert_blank_cell;
351:

Line 348: htp.p(' ');

344:
345: htp.p('

 ');
346: htp.p(' ');
349:
350: insert_blank_cell;
351:
352: htp.p(' ');
349:
350: insert_blank_cell;
351:
352: htp.p(' ');
355: htp.p(' ');
356: htp.p('
');
347: htp.p('' );
348: htp.p('
');
347: htp.p('' );
348: htp.p('		 ');

Line 352: htp.p('
 ');

348: htp.p('

 ');
353: icx_plug_utilities.buttonboth ( c_submit , 'javascript:document.BVC.submit()' );
354: htp.p('
');

Line 354: htp.p('
 ');
353: icx_plug_utilities.buttonboth ( c_submit , 'javascript:document.BVC.submit()' );
354: htp.p('
');
357:
358: htp.p('
');
353: icx_plug_utilities.buttonboth ( c_submit , 'javascript:document.BVC.submit()' );
354: htp.p('
');
357:
358: htp.p('
');

352: htp.p('

 ');
353: icx_plug_utilities.buttonboth ( c_submit , 'javascript:document.BVC.submit()' );
354: htp.p('
');
357:
358: htp.p('
');
357:
358: htp.p('
');
357:
358: htp.p('
');

Line 364: htp.p('
');
366: htp.p('
');
367: htp.p('
');

361: htp.formClose;
362: -- ****************** CLOSE FORM ******************************
363:
364: htp.p('

');
366: htp.p('
');
367: htp.p('
');
366: htp.p('
');
367: htp.p('
');
366: htp.p('
');
367: htp.p('
');

Line 368: htp.p('
');
366: htp.p('
');
367: htp.p('
');
372: htp.p('
');

Line 370: htp.p('
');
372: htp.p('
');
373: htp.p('
');

367: htp.p('

');
372: htp.p('
');
373: htp.p('
');
372: htp.p('
');
373: htp.p('
');

Line 373: htp.p(' ');

369:
370: htp.p(' ');
371: htp.p(' ');
372: htp.p('
');
373: htp.p(' ');
374: htp.p(' ');
375:
376: htp.p(' ');
377:

Line 374: htp.p(' ');

370: htp.p(' ');
371: htp.p(' ');
372: htp.p('
');
373: htp.p(' ');
374: htp.p(' ');
375:
376: htp.p(' ');
377:
378:

Line 376: htp.p(' ');

372: htp.p('
');
373: htp.p(' ');
374: htp.p(' ');
375:
376: htp.p(' ');
377:
378:
379: EXCEPTION
380: WHEN OTHERS THEN

Line 381: htp.p( SQLERRM );

377:
378:
379: EXCEPTION
380: WHEN OTHERS THEN
381: htp.p( SQLERRM );
382:
383: END enter_query_page;
384:
385: -- **********************************************************

Line 473: htp.p('11111111111111111111111111111111111111111'||'
');

469: IF (l_eul IS NULL) THEN RAISE BIS_GNRL_SEARCH_ENGINE_PVT.e_noIndexDefined;
470: END IF;
471:
472: /************* FOR DEBUGGING *************************
473: htp.p('11111111111111111111111111111111111111111'||'
');
474: htp.p('p_lang :'||p_lang||'
');
475: htp.p('p_keywords :'||p_keywords||'
');
476: htp.p('v_keywords :'||v_keywords||'
');
477: htp.p('l_length :'||l_length||'
');

Line 474: htp.p('p_lang :'||p_lang||'
');

470: END IF;
471:
472: /************* FOR DEBUGGING *************************
473: htp.p('11111111111111111111111111111111111111111'||'
');
474: htp.p('p_lang :'||p_lang||'
');
475: htp.p('p_keywords :'||p_keywords||'
');
476: htp.p('v_keywords :'||v_keywords||'
');
477: htp.p('l_length :'||l_length||'
');
478: htp.p('l_eul :'||l_eul||'
');

Line 475: htp.p('p_keywords :'||p_keywords||'
');

471:
472: /************* FOR DEBUGGING *************************
473: htp.p('11111111111111111111111111111111111111111'||'
');
474: htp.p('p_lang :'||p_lang||'
');
475: htp.p('p_keywords :'||p_keywords||'
');
476: htp.p('v_keywords :'||v_keywords||'
');
477: htp.p('l_length :'||l_length||'
');
478: htp.p('l_eul :'||l_eul||'
');
479: htp.p('22222222222222222222222222222222222222222222'||'
');

Line 476: htp.p('v_keywords :'||v_keywords||'
');

472: /************* FOR DEBUGGING *************************
473: htp.p('11111111111111111111111111111111111111111'||'
');
474: htp.p('p_lang :'||p_lang||'
');
475: htp.p('p_keywords :'||p_keywords||'
');
476: htp.p('v_keywords :'||v_keywords||'
');
477: htp.p('l_length :'||l_length||'
');
478: htp.p('l_eul :'||l_eul||'
');
479: htp.p('22222222222222222222222222222222222222222222'||'
');
480: htp.p('l_keywords_tbl COUNT :'||l_keywords_tbl.COUNT||'
');

Line 477: htp.p('l_length :'||l_length||'
');

473: htp.p('11111111111111111111111111111111111111111'||'
');
474: htp.p('p_lang :'||p_lang||'
');
475: htp.p('p_keywords :'||p_keywords||'
');
476: htp.p('v_keywords :'||v_keywords||'
');
477: htp.p('l_length :'||l_length||'
');
478: htp.p('l_eul :'||l_eul||'
');
479: htp.p('22222222222222222222222222222222222222222222'||'
');
480: htp.p('l_keywords_tbl COUNT :'||l_keywords_tbl.COUNT||'
');
481: for i in 1 .. l_keywords_tbl.COUNT loop

Line 478: htp.p('l_eul :'||l_eul||'
');

474: htp.p('p_lang :'||p_lang||'
');
475: htp.p('p_keywords :'||p_keywords||'
');
476: htp.p('v_keywords :'||v_keywords||'
');
477: htp.p('l_length :'||l_length||'
');
478: htp.p('l_eul :'||l_eul||'
');
479: htp.p('22222222222222222222222222222222222222222222'||'
');
480: htp.p('l_keywords_tbl COUNT :'||l_keywords_tbl.COUNT||'
');
481: for i in 1 .. l_keywords_tbl.COUNT loop
482: htp.p('l_keywords_tbl_'||i||' :'||l_keywords_tbl(i)||'
');

Line 479: htp.p('22222222222222222222222222222222222222222222'||'
');

475: htp.p('p_keywords :'||p_keywords||'
');
476: htp.p('v_keywords :'||v_keywords||'
');
477: htp.p('l_length :'||l_length||'
');
478: htp.p('l_eul :'||l_eul||'
');
479: htp.p('22222222222222222222222222222222222222222222'||'
');
480: htp.p('l_keywords_tbl COUNT :'||l_keywords_tbl.COUNT||'
');
481: for i in 1 .. l_keywords_tbl.COUNT loop
482: htp.p('l_keywords_tbl_'||i||' :'||l_keywords_tbl(i)||'
');
483: end loop;

Line 480: htp.p('l_keywords_tbl COUNT :'||l_keywords_tbl.COUNT||'
');

476: htp.p('v_keywords :'||v_keywords||'
');
477: htp.p('l_length :'||l_length||'
');
478: htp.p('l_eul :'||l_eul||'
');
479: htp.p('22222222222222222222222222222222222222222222'||'
');
480: htp.p('l_keywords_tbl COUNT :'||l_keywords_tbl.COUNT||'
');
481: for i in 1 .. l_keywords_tbl.COUNT loop
482: htp.p('l_keywords_tbl_'||i||' :'||l_keywords_tbl(i)||'
');
483: end loop;
484: htp.p('33333333333333333333333333333333333333333'||'
');

Line 482: htp.p('l_keywords_tbl_'||i||' :'||l_keywords_tbl(i)||'
');

478: htp.p('l_eul :'||l_eul||'
');
479: htp.p('22222222222222222222222222222222222222222222'||'
');
480: htp.p('l_keywords_tbl COUNT :'||l_keywords_tbl.COUNT||'
');
481: for i in 1 .. l_keywords_tbl.COUNT loop
482: htp.p('l_keywords_tbl_'||i||' :'||l_keywords_tbl(i)||'
');
483: end loop;
484: htp.p('33333333333333333333333333333333333333333'||'
');
485: ************* FOR DEBUGGING *************************/
486:

Line 484: htp.p('33333333333333333333333333333333333333333'||'
');

480: htp.p('l_keywords_tbl COUNT :'||l_keywords_tbl.COUNT||'
');
481: for i in 1 .. l_keywords_tbl.COUNT loop
482: htp.p('l_keywords_tbl_'||i||' :'||l_keywords_tbl(i)||'
');
483: end loop;
484: htp.p('33333333333333333333333333333333333333333'||'
');
485: ************* FOR DEBUGGING *************************/
486:
487: BEGIN
488: -- Now call the package to build and run the InterMedia

Line 518: htp.bodyClose;

514: -- *********************************************************
515: ELSE -- If no keywords entered in the box
516: -- Print out the keywords entry box again for future tries
517: enter_query_page( p_keywords, p_lang );
518: htp.bodyClose;
519: htp.htmlClose;
520:
521: END IF; -- endif for l_length of the keywords entered not equal to zero
522: -- *********************************************************

Line 519: htp.htmlClose;

515: ELSE -- If no keywords entered in the box
516: -- Print out the keywords entry box again for future tries
517: enter_query_page( p_keywords, p_lang );
518: htp.bodyClose;
519: htp.htmlClose;
520:
521: END IF; -- endif for l_length of the keywords entered not equal to zero
522: -- *********************************************************
523:

Line 532: htp.p('

');

528: WHEN BIS_GNRL_SEARCH_ENGINE_PVT.e_noIndexDefined THEN
529: -- The following message need not be translated since this is a propagated error
530: -- due to undefined InterMedia domain Index. The Preferences and Indexes must
531: -- be created first, for the Business Views Catalog Search region to work !!
532: htp.p('

');
533: htp.p('ERROR : InterMedia Index Not Created in Language - '||p_lang||'
');
534: htp.p('Please run BISPBVI.sql in the Discoverer eul schema with appropriate Language code as parameter.'||'
');
535: WHEN OTHERS THEN
536: htp.p( SQLERRM );

Line 533: htp.p('ERROR : InterMedia Index Not Created in Language - '||p_lang||'
');

529: -- The following message need not be translated since this is a propagated error
530: -- due to undefined InterMedia domain Index. The Preferences and Indexes must
531: -- be created first, for the Business Views Catalog Search region to work !!
532: htp.p('

');
533: htp.p('ERROR : InterMedia Index Not Created in Language - '||p_lang||'
');
534: htp.p('Please run BISPBVI.sql in the Discoverer eul schema with appropriate Language code as parameter.'||'
');
535: WHEN OTHERS THEN
536: htp.p( SQLERRM );
537: END query;

Line 534: htp.p('Please run BISPBVI.sql in the Discoverer eul schema with appropriate Language code as parameter.'||'
');

530: -- due to undefined InterMedia domain Index. The Preferences and Indexes must
531: -- be created first, for the Business Views Catalog Search region to work !!
532: htp.p('

');
533: htp.p('ERROR : InterMedia Index Not Created in Language - '||p_lang||'
');
534: htp.p('Please run BISPBVI.sql in the Discoverer eul schema with appropriate Language code as parameter.'||'
');
535: WHEN OTHERS THEN
536: htp.p( SQLERRM );
537: END query;
538:

Line 536: htp.p( SQLERRM );

532: htp.p('

');
533: htp.p('ERROR : InterMedia Index Not Created in Language - '||p_lang||'
');
534: htp.p('Please run BISPBVI.sql in the Discoverer eul schema with appropriate Language code as parameter.'||'
');
535: WHEN OTHERS THEN
536: htp.p( SQLERRM );
537: END query;
538:
539: -- ************************************************
540: -- ************************************************