APPS.ICX_ON dependencies on HTP

Line 31: -- select HSECS into l_timer from v$timer;htp.p('begin get_page @ '||l_timer);htp.nl;

27: l_web_user_date_format varchar2(240);
28:
29: begin
30:
31: -- select HSECS into l_timer from v$timer;htp.p('begin get_page @ '||l_timer);htp.nl;
32:
33: l_type := icx_on_utilities.g_on_parameters(1);
34:
35: if l_type = 'Q1' or l_type = 'Q5'

Line 87: -- htp.p('DEBUG where => '||l_where);htp.nl;

83: else
84: l_where := icx_call.decrypt2(l_encrypted_where);
85: end if;
86:
87: -- htp.p('DEBUG where => '||l_where);htp.nl;
88:
89: icx_on_utilities.g_on_parameters(9) := l_encrypted_where;
90:
91: icx_on_utilities.getRegions(l_where);

Line 151: -- select HSECS into l_timer from v$timer;htp.p('end get_page @ '||l_timer);htp.nl;

147: end if;
148:
149: end if;
150:
151: -- select HSECS into l_timer from v$timer;htp.p('end get_page @ '||l_timer);htp.nl;
152:
153: exception
154: when VALUE_ERROR or INVALID_NUMBER then
155: fnd_message.set_name('ICX','ICX_USE_NUMBER');

Line 344: htp.p(l_message);

340: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
341: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(0).name);
342: l_message := fnd_message.get;
343:
344: htp.p(l_message);
345: else
346:
347: for r in ak_query_pkg.g_regions_table.FIRST..ak_query_pkg.g_regions_table.LAST loop
348:

Line 372: htp.p;

368: then
369:
370: if l_count1 = ak_query_pkg.g_regions_table(r).number_of_format_columns
371: then
372: htp.p;
373: l_count1 := 0;
374: end if;
375:
376: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(v),l_values_table);

Line 389: htp.prn(ak_query_pkg.g_items_table(i).attribute_label_long||c_delimiter||l_value||c_delimiter);

385: if ak_query_pkg.g_items_table(i).attribute_label_long is null and l_value is null
386: then
387: l_value := l_value;
388: else
389: htp.prn(ak_query_pkg.g_items_table(i).attribute_label_long||c_delimiter||l_value||c_delimiter);
390: l_count1 := l_count1 + 1;
391: end if;
392:
393: end if; -- region result

Line 401: htp.p('');

397: end if; -- display item
398:
399: end loop; -- items
400:
401: htp.p('');
402: htp.p('');
403:
404: else
405:

Line 402: htp.p('');

398:
399: end loop; -- items
400:
401: htp.p('');
402: htp.p('');
403:
404: else
405:
406: c_labels := '';

Line 427: htp.p(c_labels1);

423: l_dbcharset:=icx_sec.getNLS_PARAMETER('NLS_CHARACTERSET');
424:
425: c_labels1 := convert(c_labels,fnd_profile.value('FND_NATIVE_CLIENT_ENCODING'),l_dbcharset);
426:
427: htp.p(c_labels1);
428:
429: c_data1 := convert(c_data,fnd_profile.value('FND_NATIVE_CLIENT_ENCODING'),l_dbcharset);
430:
431: htp.p(c_data1);

Line 431: htp.p(c_data1);

427: htp.p(c_labels1);
428:
429: c_data1 := convert(c_data,fnd_profile.value('FND_NATIVE_CLIENT_ENCODING'),l_dbcharset);
430:
431: htp.p(c_data1);
432:
433: --- End Bug3460155
434:
435:

Line 464: --htp.p(c_data);

460: end loop; -- items
461:
462: -- Start Bug3460155
463:
464: --htp.p(c_data);
465:
466: c_data1 := convert(c_data,fnd_profile.value('FND_NATIVE_CLIENT_ENCODING'),l_dbcharset);
467:
468: htp.p(c_data1);

Line 468: htp.p(c_data1);

464: --htp.p(c_data);
465:
466: c_data1 := convert(c_data,fnd_profile.value('FND_NATIVE_CLIENT_ENCODING'),l_dbcharset);
467:
468: htp.p(c_data1);
469:
470: --- End Bug3460155
471:
472:

Line 483: htp.p(l_message);

479: else
480: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
481: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(r).name);
482: l_message := fnd_message.get;
483: htp.p(l_message);
484:
485: end if; -- no row in region
486:
487: end loop; -- regions