114:
115: /*
116: ** Create the link syntax
117: */
118: htp.p('function help_window(){
119: help_win = window.open("'||l_url||'", "help_win","resizable=yes,scrollbars=yes,toolbar=yes,width=600,height=500")}');
120:
121: end;
122:
157: end icx_fnd_help;
158:
159:
160: --Return the proper syntax for generating the help_win javascript function
161: --but don't pipe it out to htp. This is used by BIS in their reports.
162: function help_win_syntax (
163: defHlp in varchar2 default null,
164: language_code in varchar2 default null,
165: application_short_name in varchar2 default 'ICX') return VARCHAR2 is
321: fnd_message.set_name('ICX', 'ICX_OA_WEB');
322: v_oa_web := fnd_message.get;
323:
324: if extraOnLoad is null then
325: htp.bodyOpen(icx_admin_sig.background,'onLoad="self.defaultStatus='''||v_oa_web||'''; return true"');
326: else
327: htp.bodyOpen(icx_admin_sig.background,'onLoad="self.defaultStatus='''||v_oa_web||'''; '||extraOnLoad||'; return true"');
328: end if;
329:
323:
324: if extraOnLoad is null then
325: htp.bodyOpen(icx_admin_sig.background,'onLoad="self.defaultStatus='''||v_oa_web||'''; return true"');
326: else
327: htp.bodyOpen(icx_admin_sig.background,'onLoad="self.defaultStatus='''||v_oa_web||'''; '||extraOnLoad||'; return true"');
328: end if;
329:
330: else
331:
329:
330: else
331:
332: if extraOnLoad is null then
333: htp.bodyOpen(icx_admin_sig.background,'onLoad="self.defaultStatus='''||defStatus||'''; return true"');
334: else
335: htp.bodyOpen(icx_admin_sig.background,'onLoad="self.defaultStatus='''||defStatus||'''; '||extraOnLoad||'; return true"');
336:
337: end if;
331:
332: if extraOnLoad is null then
333: htp.bodyOpen(icx_admin_sig.background,'onLoad="self.defaultStatus='''||defStatus||'''; return true"');
334: else
335: htp.bodyOpen(icx_admin_sig.background,'onLoad="self.defaultStatus='''||defStatus||'''; '||extraOnLoad||'; return true"');
336:
337: end if;
338: end if;
339:
336:
337: end if;
338: end if;
339:
340: htp.tableOpen('','','','','CELLSPACING=0 CELLPADDING=0');
341: htp.tableRowOpen('CENTER','BOTTOM');
342: htp.tableData(htf.img(curl => '/OA_MEDIA/FNDLOGOS.gif', cattributes => 'BORDER=0'),'CENTER','','','','','VALIGN="MIDDLE"');
343: htp.p('
337: end if;
338: end if;
339:
340: htp.tableOpen('','','','','CELLSPACING=0 CELLPADDING=0');
341: htp.tableRowOpen('CENTER','BOTTOM');
342: htp.tableData(htf.img(curl => '/OA_MEDIA/FNDLOGOS.gif', cattributes => 'BORDER=0'),'CENTER','','','','','VALIGN="MIDDLE"');
343: htp.p('
338: end if;
339:
340: htp.tableOpen('','','','','CELLSPACING=0 CELLPADDING=0');
341: htp.tableRowOpen('CENTER','BOTTOM');
342: htp.tableData(htf.img(curl => '/OA_MEDIA/FNDLOGOS.gif', cattributes => 'BORDER=0'),'CENTER','','','','','VALIGN="MIDDLE"');
343: htp.p('
339:
340: htp.tableOpen('','','','','CELLSPACING=0 CELLPADDING=0');
341: htp.tableRowOpen('CENTER','BOTTOM');
342: htp.tableData(htf.img(curl => '/OA_MEDIA/FNDLOGOS.gif', cattributes => 'BORDER=0'),'CENTER','','','','','VALIGN="MIDDLE"');
343: htp.p('
361: -- v_language_code := language_code;
362: --end if;
363:
364: icx_util.getprompts(601, 'ICX_HEADER', c_title, c_prompts);
365: ---htp.p('
362: --end if;
363:
364: icx_util.getprompts(601, 'ICX_HEADER', c_title, c_prompts);
365: ---htp.p('
365: ---htp.p('
368:
369: htp.tableData(htf.anchor('icx_admin_sig.Startover', htf.img('/OA_MEDIA/FNDSLOGF.gif',
370: 'CENTER',icx_util.replace_alt_quotes(c_prompts(4)),'','BORDER=0 WIDTH=55 HEIGHT=38'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(c_prompts(4))||''';return true"'));
371:
372: htp.tableData(htf.anchor('javascript:help_window()',htf.img('/OA_MEDIA/FNDSHELP.gif',
373: 'CENTER',icx_util.replace_alt_quotes(c_prompts(5)),'','BORDER=0 WIDTH=46 HEIGHT=38'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(c_prompts(5))||''';return true"'));
374: htp.tableRowClose;
375: htp.tableClose;
376: htp.line;
370: 'CENTER',icx_util.replace_alt_quotes(c_prompts(4)),'','BORDER=0 WIDTH=55 HEIGHT=38'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(c_prompts(4))||''';return true"'));
371:
372: htp.tableData(htf.anchor('javascript:help_window()',htf.img('/OA_MEDIA/FNDSHELP.gif',
373: 'CENTER',icx_util.replace_alt_quotes(c_prompts(5)),'','BORDER=0 WIDTH=46 HEIGHT=38'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(c_prompts(5))||''';return true"'));
374: htp.tableRowClose;
375: htp.tableClose;
376: htp.line;
377: end;
378:
371:
372: htp.tableData(htf.anchor('javascript:help_window()',htf.img('/OA_MEDIA/FNDSHELP.gif',
373: 'CENTER',icx_util.replace_alt_quotes(c_prompts(5)),'','BORDER=0 WIDTH=46 HEIGHT=38'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(c_prompts(5))||''';return true"'));
374: htp.tableRowClose;
375: htp.tableClose;
376: htp.line;
377: end;
378:
379:
372: htp.tableData(htf.anchor('javascript:help_window()',htf.img('/OA_MEDIA/FNDSHELP.gif',
373: 'CENTER',icx_util.replace_alt_quotes(c_prompts(5)),'','BORDER=0 WIDTH=46 HEIGHT=38'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(c_prompts(5))||''';return true"'));
374: htp.tableRowClose;
375: htp.tableClose;
376: htp.line;
377: end;
378:
379:
380: procedure Closeheader2 (language_code in varchar2 default null) is
396: -- end if;
397:
398: icx_util.getprompts(601, 'ICX_HEADER', c_title, c_prompts);
399:
400: htp.tableData(htf.anchor('icx_admin_sig.Startover', htf.img('/OA_MEDIA/ICXTOP.gif',
401: 'CENTER',icx_util.replace_alt_quotes(c_prompts(4)),'','BORDER=0 WIDTH=55 HEIGHT=28'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(c_prompts(4))||''';return true"'));
402:
403: htp.tableData(htf.anchor('javascript:help_window()',htf.img('/OA_MEDIA/ICXHELP.gif',
404: 'CENTER',icx_util.replace_alt_quotes(c_prompts(5)),'','BORDER=0 WIDTH=46 HEIGHT=28'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(c_prompts(5))||''';return true"'));
399:
400: htp.tableData(htf.anchor('icx_admin_sig.Startover', htf.img('/OA_MEDIA/ICXTOP.gif',
401: 'CENTER',icx_util.replace_alt_quotes(c_prompts(4)),'','BORDER=0 WIDTH=55 HEIGHT=28'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(c_prompts(4))||''';return true"'));
402:
403: htp.tableData(htf.anchor('javascript:help_window()',htf.img('/OA_MEDIA/ICXHELP.gif',
404: 'CENTER',icx_util.replace_alt_quotes(c_prompts(5)),'','BORDER=0 WIDTH=46 HEIGHT=28'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(c_prompts(5))||''';return true"'));
405:
406: htp.tableData(htf.img('/OA_MEDIA/ICXRIGHT.gif','','','','BORDER=0 HEIGHT=28 WIDTH=20'),'CENTER','','','','','VALIGN="MIDDLE"');
407:
402:
403: htp.tableData(htf.anchor('javascript:help_window()',htf.img('/OA_MEDIA/ICXHELP.gif',
404: 'CENTER',icx_util.replace_alt_quotes(c_prompts(5)),'','BORDER=0 WIDTH=46 HEIGHT=28'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(c_prompts(5))||''';return true"'));
405:
406: htp.tableData(htf.img('/OA_MEDIA/ICXRIGHT.gif','','','','BORDER=0 HEIGHT=28 WIDTH=20'),'CENTER','','','','','VALIGN="MIDDLE"');
407:
408: htp.tableRowClose;
409: htp.tableClose;
410: htp.line;
404: 'CENTER',icx_util.replace_alt_quotes(c_prompts(5)),'','BORDER=0 WIDTH=46 HEIGHT=28'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(c_prompts(5))||''';return true"'));
405:
406: htp.tableData(htf.img('/OA_MEDIA/ICXRIGHT.gif','','','','BORDER=0 HEIGHT=28 WIDTH=20'),'CENTER','','','','','VALIGN="MIDDLE"');
407:
408: htp.tableRowClose;
409: htp.tableClose;
410: htp.line;
411: end;
412:
405:
406: htp.tableData(htf.img('/OA_MEDIA/ICXRIGHT.gif','','','','BORDER=0 HEIGHT=28 WIDTH=20'),'CENTER','','','','','VALIGN="MIDDLE"');
407:
408: htp.tableRowClose;
409: htp.tableClose;
410: htp.line;
411: end;
412:
413: procedure toolbar (language_code in varchar2 default null,
406: htp.tableData(htf.img('/OA_MEDIA/ICXRIGHT.gif','','','','BORDER=0 HEIGHT=28 WIDTH=20'),'CENTER','','','','','VALIGN="MIDDLE"');
407:
408: htp.tableRowClose;
409: htp.tableClose;
410: htp.line;
411: end;
412:
413: procedure toolbar (language_code in varchar2 default null,
414: disp_find in varchar2 default null,
438: -- end if;
439:
440: if substr(icx_sec.g_mode_code,1,3) = '115'
441: then
442: htp.p('');
443: icx_plug_utilities.toolbar(p_text => '',
444: p_language_code => language_code,
445: p_disp_find => disp_find,
446: p_disp_mainmenu => disp_mainmenu,
449: p_disp_export => disp_export,
450: p_disp_exit => disp_exit);
451: elsif icx_sec.g_mode_code = 'OBIS'
452: then
453: htp.p('');
454: icx_plug_utilities.toolbar(p_text => '',
455: p_language_code => language_code,
456: p_disp_find => disp_find,
457: p_disp_mainmenu => disp_mainmenu,
460: p_disp_export => disp_export,
461: p_disp_exit => disp_exit);
462: else
463:
464: htp.bodyOpen(icx_admin_sig.background);
465:
466: htp.tableOpen('','','','','CELLSPACING=0 CELLPADDING=0 BORDER=0');
467:
468: htp.tableRowOpen('CENTER','BOTTOM');
462: else
463:
464: htp.bodyOpen(icx_admin_sig.background);
465:
466: htp.tableOpen('','','','','CELLSPACING=0 CELLPADDING=0 BORDER=0');
467:
468: htp.tableRowOpen('CENTER','BOTTOM');
469: htp.tableData(htf.img(curl => '/OA_MEDIA/FNDLOGOS.gif', cattributes => 'BORDER=0'),
470: 'CENTER','','','','','VALIGN="MIDDLE"');
464: htp.bodyOpen(icx_admin_sig.background);
465:
466: htp.tableOpen('','','','','CELLSPACING=0 CELLPADDING=0 BORDER=0');
467:
468: htp.tableRowOpen('CENTER','BOTTOM');
469: htp.tableData(htf.img(curl => '/OA_MEDIA/FNDLOGOS.gif', cattributes => 'BORDER=0'),
470: 'CENTER','','','','','VALIGN="MIDDLE"');
471: htp.p('
465:
466: htp.tableOpen('','','','','CELLSPACING=0 CELLPADDING=0 BORDER=0');
467:
468: htp.tableRowOpen('CENTER','BOTTOM');
469: htp.tableData(htf.img(curl => '/OA_MEDIA/FNDLOGOS.gif', cattributes => 'BORDER=0'),
470: 'CENTER','','','','','VALIGN="MIDDLE"');
471: htp.p('
467:
468: htp.tableRowOpen('CENTER','BOTTOM');
469: htp.tableData(htf.img(curl => '/OA_MEDIA/FNDLOGOS.gif', cattributes => 'BORDER=0'),
470: 'CENTER','','','','','VALIGN="MIDDLE"');
471: htp.p('
471: htp.p('
475: htp.p('
477: ** inner table for icons
478: */
479: htp.tableOpen(cattributes => 'border=0 cellspacing=0 cellpadding=0');
480:
481: htp.tableRowOpen(calign => 'CENTER');
482:
483: if (disp_wizard = 'Y') then
484: htp.tableData(htf.anchor('javascript:doWizard()',
485: htf.img('/OA_MEDIA/FNDSWZRD.gif','CENTER',
480:
481: htp.tableRowOpen(calign => 'CENTER');
482:
483: if (disp_wizard = 'Y') then
484: htp.tableData(htf.anchor('javascript:doWizard()',
485: htf.img('/OA_MEDIA/FNDSWZRD.gif','CENTER',
486: icx_util.replace_alt_quotes(c_prompts(1)),'',
487: 'BORDER=0 '),'',
488: 'onMouseOver="window.status=''' ||
491: end if;
492:
493: if (disp_export is not null) then
494: htp.p('
492:
493: if (disp_export is not null) then
494: htp.p('
493: if (disp_export is not null) then
494: htp.p('
503: ''';return true"'));
504: end if;
505:
506: if (disp_find is not null) then
507: htp.tableData(htf.anchor(disp_find,
508: htf.img('/OA_MEDIA/FNDSFIND.gif','CENTER',
509: icx_util.replace_alt_quotes(c_prompts(2)),'',
510: 'BORDER=0 '),'',
511: 'onMouseOver="window.status=''' ||
513: ''';return true"'));
514: end if;
515:
516: if (disp_wizard = 'Y' or disp_find is not null or disp_export is not null) then
517: htp.p('
517: htp.p('
527: ||''';return true" TARGET="_top"'));
528: end if;
529:
530: if (disp_exit = 'Y' and icx_sec.g_mode_code <> 'SLAVE') then
531: htp.tableData(htf.anchor('icx_admin_sig.Startover',
532: htf.img('/OA_MEDIA/FNDSLOGF.gif','CENTER',
533: icx_util.replace_alt_quotes(c_prompts(4)),'','
534: BORDER=0 '),'','
535: onMouseOver="window.status=''' ||
537: ''';return true"'));
538: end if;
539:
540: if (disp_help = 'Y') then
541: htp.tableData(htf.anchor('javascript:help_window()',
542: htf.img('/OA_MEDIA/FNDSHELP.gif','CENTER',
543: icx_util.replace_alt_quotes(c_prompts(5)),'',
544: 'BORDER=0 '),'',
545: 'onMouseOver="window.status=''' ||
546: icx_util.replace_onMouseOver_quotes(c_prompts(5))||
547: ''';return true"'));
548: end if;
549:
550: htp.tableRowClose;
551:
552: htp.tableRowOpen(calign => 'CENTER', cvalign => 'TOP');
553:
554: if (disp_wizard = 'Y') then
548: end if;
549:
550: htp.tableRowClose;
551:
552: htp.tableRowOpen(calign => 'CENTER', cvalign => 'TOP');
553:
554: if (disp_wizard = 'Y') then
555: htp.tableData(cvalue => htf.anchor(curl => 'javascript:doWizard()',
556: ctext => ''||c_prompts(1)||'',
551:
552: htp.tableRowOpen(calign => 'CENTER', cvalign => 'TOP');
553:
554: if (disp_wizard = 'Y') then
555: htp.tableData(cvalue => htf.anchor(curl => 'javascript:doWizard()',
556: ctext => ''||c_prompts(1)||'',
557: cattributes => 'onMouseOver="window.status=''' || icx_util.replace_onMouseOver_quotes(c_prompts(1))|| ''';return true"'),
558: calign=> 'CENTER');
559: end if;
558: calign=> 'CENTER');
559: end if;
560:
561: if (disp_export is not null) then
562: htp.tableData(cvalue => htf.anchor(curl => 'javascript:document.exportON.submit()',
563: ctext => ''||c_prompts(6)||'',
564: cattributes => 'onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(c_prompts(6))||''';return true"'),
565: calign=> 'CENTER');
566: end if;
565: calign=> 'CENTER');
566: end if;
567:
568: if (disp_find is not null) then
569: htp.tableData(cvalue => htf.anchor(curl => disp_find,
570: ctext => ''||
571: c_prompts(2) ||
572: '',
573: cattributes => 'onMouseOver="window.status=''' || icx_util.replace_onMouseOver_quotes(c_prompts(2))|| ''';return true"'),
574: calign=> 'CENTER');
575: end if;
576:
577: if (disp_wizard = 'Y' or disp_find is not null or disp_export is not null) then
578: htp.p('
578: htp.p('
587: calign=> 'CENTER');
588: end if;
589:
590: if (disp_exit = 'Y' and icx_sec.g_mode_code <> 'SLAVE') then
591: htp.tableData(cvalue => htf.anchor(curl => 'icx_admin_sig.Startover',
592: ctext => ''||
593: c_prompts(4)
594: || '',
595: cattributes => 'onMouseOver="window.status=''' || icx_util.replace_onMouseOver_quotes(c_prompts(4))|| ''';return true" TARGET="_top"'),
596: calign=> 'CENTER');
597: end if;
598:
599: if (disp_help = 'Y') then
600: htp.tableData(cvalue => htf.anchor(curl => 'javascript:help_window()',
601: ctext => ''||
602: c_prompts(5)
603: || '',
604: cattributes => 'onMouseOver="window.status=''' || icx_util.replace_onMouseOver_quotes(c_prompts(5))|| ''';return true"'),
603: || '',
604: cattributes => 'onMouseOver="window.status=''' || icx_util.replace_onMouseOver_quotes(c_prompts(5))|| ''';return true"'),
605: calign=> 'CENTER');
606: end if;
607: htp.tableRowClose;
608:
609: htp.tableClose;
610: htp.p('');
611: /**
605: calign=> 'CENTER');
606: end if;
607: htp.tableRowClose;
608:
609: htp.tableClose;
610: htp.p('');
611: /**
612: ** close outer row and table
613: */
606: end if;
607: htp.tableRowClose;
608:
609: htp.tableClose;
610: htp.p('');
611: /**
612: ** close outer row and table
613: */
614: htp.tableRowClose;
610: htp.p('');
611: /**
612: ** close outer row and table
613: */
614: htp.tableRowClose;
615: htp.tableClose;
616:
617: end if; -- 'OBIS'
618:
611: /**
612: ** close outer row and table
613: */
614: htp.tableRowClose;
615: htp.tableClose;
616:
617: end if; -- 'OBIS'
618:
619: end toolbar;
706:
707: procedure footer is
708: begin
709: /*
710: htp.address('Please send any questions or comments to '
711: ||htf.mailto('[email protected]','[email protected]'));
712: */
713: htp.bodyClose;
714: htp.htmlClose;
709: /*
710: htp.address('Please send any questions or comments to '
711: ||htf.mailto('[email protected]','[email protected]'));
712: */
713: htp.bodyClose;
714: htp.htmlClose;
715: end;
716:
717:
710: htp.address('Please send any questions or comments to '
711: ||htf.mailto('[email protected]','[email protected]'));
712: */
713: htp.bodyClose;
714: htp.htmlClose;
715: end;
716:
717:
718: procedure error_screen (title varchar2,
743: else
744: v_language_code := language_code;
745: end if;
746: icx_util.getprompts(601, 'ICX_ERR_SCRN', c_title, c_prompts);
747: htp.htmlOpen;
748: htp.headOpen;
749:
750: icx_util.copyright;
751:
744: v_language_code := language_code;
745: end if;
746: icx_util.getprompts(601, 'ICX_ERR_SCRN', c_title, c_prompts);
747: htp.htmlOpen;
748: htp.headOpen;
749:
750: icx_util.copyright;
751:
752: /*
755:
756: icx_admin_sig.help_win_script('',v_language_code);
757:
758: htp.p('// -->');
759: htp.p('');
760: */
761:
762: htp.title(c_title);
763: htp.headClose;
758: htp.p('// -->');
759: htp.p('');
760: */
761:
762: htp.title(c_title);
763: htp.headClose;
764:
765: icx_admin_sig.toolbar(language_code => v_language_code,
766: disp_help => 'N');
759: htp.p('');
760: */
761:
762: htp.title(c_title);
763: htp.headClose;
764:
765: icx_admin_sig.toolbar(language_code => v_language_code,
766: disp_help => 'N');
767: icx_util.error_page_print;
764:
765: icx_admin_sig.toolbar(language_code => v_language_code,
766: disp_help => 'N');
767: icx_util.error_page_print;
768: htp.nl;
769: htp.tableOpen;
770: htp.tableRowOpen;
771: htp.tableData(htf.anchor('javascript:history.back()',htf.img('/OA_MEDIA/FNDBKFR.gif','',icx_util.replace_alt_quotes(c_prompts(1)),'',
772: 'BORDER=0 HEIGHT=30 WIDTH=30'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(c_prompts(1))||''';return true"'));
765: icx_admin_sig.toolbar(language_code => v_language_code,
766: disp_help => 'N');
767: icx_util.error_page_print;
768: htp.nl;
769: htp.tableOpen;
770: htp.tableRowOpen;
771: htp.tableData(htf.anchor('javascript:history.back()',htf.img('/OA_MEDIA/FNDBKFR.gif','',icx_util.replace_alt_quotes(c_prompts(1)),'',
772: 'BORDER=0 HEIGHT=30 WIDTH=30'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(c_prompts(1))||''';return true"'));
773: htp.tableData(htf.anchor('javascript:history.back()',icx_util.replace_alt_quotes(c_prompts(2)),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(c_prompts(2))||''';return true"'));
766: disp_help => 'N');
767: icx_util.error_page_print;
768: htp.nl;
769: htp.tableOpen;
770: htp.tableRowOpen;
771: htp.tableData(htf.anchor('javascript:history.back()',htf.img('/OA_MEDIA/FNDBKFR.gif','',icx_util.replace_alt_quotes(c_prompts(1)),'',
772: 'BORDER=0 HEIGHT=30 WIDTH=30'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(c_prompts(1))||''';return true"'));
773: htp.tableData(htf.anchor('javascript:history.back()',icx_util.replace_alt_quotes(c_prompts(2)),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(c_prompts(2))||''';return true"'));
774: htp.tableRowClose;
767: icx_util.error_page_print;
768: htp.nl;
769: htp.tableOpen;
770: htp.tableRowOpen;
771: htp.tableData(htf.anchor('javascript:history.back()',htf.img('/OA_MEDIA/FNDBKFR.gif','',icx_util.replace_alt_quotes(c_prompts(1)),'',
772: 'BORDER=0 HEIGHT=30 WIDTH=30'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(c_prompts(1))||''';return true"'));
773: htp.tableData(htf.anchor('javascript:history.back()',icx_util.replace_alt_quotes(c_prompts(2)),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(c_prompts(2))||''';return true"'));
774: htp.tableRowClose;
775: htp.tableClose;
769: htp.tableOpen;
770: htp.tableRowOpen;
771: htp.tableData(htf.anchor('javascript:history.back()',htf.img('/OA_MEDIA/FNDBKFR.gif','',icx_util.replace_alt_quotes(c_prompts(1)),'',
772: 'BORDER=0 HEIGHT=30 WIDTH=30'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(c_prompts(1))||''';return true"'));
773: htp.tableData(htf.anchor('javascript:history.back()',icx_util.replace_alt_quotes(c_prompts(2)),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(c_prompts(2))||''';return true"'));
774: htp.tableRowClose;
775: htp.tableClose;
776: htp.htmlClose;
777:
770: htp.tableRowOpen;
771: htp.tableData(htf.anchor('javascript:history.back()',htf.img('/OA_MEDIA/FNDBKFR.gif','',icx_util.replace_alt_quotes(c_prompts(1)),'',
772: 'BORDER=0 HEIGHT=30 WIDTH=30'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(c_prompts(1))||''';return true"'));
773: htp.tableData(htf.anchor('javascript:history.back()',icx_util.replace_alt_quotes(c_prompts(2)),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(c_prompts(2))||''';return true"'));
774: htp.tableRowClose;
775: htp.tableClose;
776: htp.htmlClose;
777:
778: exception
771: htp.tableData(htf.anchor('javascript:history.back()',htf.img('/OA_MEDIA/FNDBKFR.gif','',icx_util.replace_alt_quotes(c_prompts(1)),'',
772: 'BORDER=0 HEIGHT=30 WIDTH=30'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(c_prompts(1))||''';return true"'));
773: htp.tableData(htf.anchor('javascript:history.back()',icx_util.replace_alt_quotes(c_prompts(2)),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(c_prompts(2))||''';return true"'));
774: htp.tableRowClose;
775: htp.tableClose;
776: htp.htmlClose;
777:
778: exception
779: when others then
772: 'BORDER=0 HEIGHT=30 WIDTH=30'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(c_prompts(1))||''';return true"'));
773: htp.tableData(htf.anchor('javascript:history.back()',icx_util.replace_alt_quotes(c_prompts(2)),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(c_prompts(2))||''';return true"'));
774: htp.tableRowClose;
775: htp.tableClose;
776: htp.htmlClose;
777:
778: exception
779: when others then
780: htp.p(SQLERRM);
776: htp.htmlClose;
777:
778: exception
779: when others then
780: htp.p(SQLERRM);
781: end;
782:
783: procedure showTable(p_table pp_table,
784: row_count in binary_integer default 0,
805: real_counter := row_count;
806: row_num := trunc((row_count/col_num))+1;
807: remainder := mod(row_count, col_num);
808:
809: htp.tableOpen('','','','','BORDER='||p_border || 'CELLPADDING='||
810: p_cellpadding || 'CELLSPACING='||p_cellspacing);
811: row_index := 1;
812: col_index := 1;
813:
814: while row_index <= row_num loop
815:
816: col_index := 1;
817: counter := row_index;
818: htp.tableRowOpen;
819: while (counter <= row_count and col_index <= col_num and
820: real_counter <> 0) loop
821: if (p_cell_width = 0 and p_indent = 0)
822: then
819: while (counter <= row_count and col_index <= col_num and
820: real_counter <> 0) loop
821: if (p_cell_width = 0 and p_indent = 0)
822: then
823: htp.tableData(p_table(counter));
824: else htp.p('
820: real_counter <> 0) loop
821: if (p_cell_width = 0 and p_indent = 0)
822: then
823: htp.tableData(p_table(counter));
824: else htp.p('
821: if (p_cell_width = 0 and p_indent = 0)
822: then
823: htp.tableData(p_table(counter));
824: else htp.p('
823: htp.tableData(p_table(counter));
824: else htp.p('
833:
834: end if;
835: col_index := col_index+1;
836: end loop;
837: htp.tableRowClose;
838: row_index := row_index+1;
839: end loop;
840: htp.tableClose;
841: end;
836: end loop;
837: htp.tableRowClose;
838: row_index := row_index+1;
839: end loop;
840: htp.tableClose;
841: end;
842:
843:
844:
877: while row_index <= row_num loop
878:
879: col_index := 1;
880: counter := row_index;
881: htp.tableRowOpen;
882: -- htp.p('
878:
879: col_index := 1;
880: counter := row_index;
881: htp.tableRowOpen;
882: -- htp.p('
881: htp.tableRowOpen;
882: -- htp.p('
882: -- htp.p('
892:
893: end if;
894: col_index := col_index+1;
895: end loop;
896: htp.tableRowClose;
897: row_index := row_index+1;
898: end loop;
899: end;
900: end icx_admin_sig;