344: end loop;
345: c_condition(x) := c_condition(x)||htf.formSelectClose;
346: end loop;
347:
348: htp.p('
349:
350:
351:
352:
488: };');
489: end if;
490: END IF;-- block blinds
491:
492: htp.p('');
493: htp.p('');
494: htp.p('
489: end if;
490: END IF;-- block blinds
491:
492: htp.p('');
493: htp.p('');
494: htp.p('
490: END IF;-- block blinds
491:
492: htp.p('');
493: htp.p('');
494: htp.p('');
495:
496: icx_plug_utilities.sessionjavascript;
497:
498: htp.formOpen('javascript:submitFunction()','POST','','','NAME="findForm"');
494: htp.p('
');
524: l_message := fnd_message.get;
525: end if;
526:
527: /*
528: htp.tableOpen('BORDER=0');
529: htp.tableRowOpen;
530: htp.tableData(cvalue => htf.img(curl => '/OA_MEDIA/FNDIFIND.gif', calt => c_prompts(1)));
531:
532: if p_page_code is not null
525: end if;
526:
527: /*
528: htp.tableOpen('BORDER=0');
529: htp.tableRowOpen;
530: htp.tableData(cvalue => htf.img(curl => '/OA_MEDIA/FNDIFIND.gif', calt => c_prompts(1)));
531:
532: if p_page_code is not null
533: then
526:
527: /*
528: htp.tableOpen('BORDER=0');
529: htp.tableRowOpen;
530: htp.tableData(cvalue => htf.img(curl => '/OA_MEDIA/FNDIFIND.gif', calt => c_prompts(1)));
531:
532: if p_page_code is not null
533: then
534: htp.tableData(cvalue => ''||c_prompts(1)||': '||l_page_title||' '||l_page_description, cattributes => 'VALIGN="MIDDLE"');
530: htp.tableData(cvalue => htf.img(curl => '/OA_MEDIA/FNDIFIND.gif', calt => c_prompts(1)));
531:
532: if p_page_code is not null
533: then
534: htp.tableData(cvalue => ''||c_prompts(1)||': '||l_page_title||' '||l_page_description, cattributes => 'VALIGN="MIDDLE"');
535: else
536: htp.tableData(cvalue => ''||c_prompts(1)||': '||l_region_title||'', cattributes => 'VALIGN="MIDDLE"');
537: end if;
538:
532: if p_page_code is not null
533: then
534: htp.tableData(cvalue => ''||c_prompts(1)||': '||l_page_title||' '||l_page_description, cattributes => 'VALIGN="MIDDLE"');
535: else
536: htp.tableData(cvalue => ''||c_prompts(1)||': '||l_region_title||'', cattributes => 'VALIGN="MIDDLE"');
537: end if;
538:
539: htp.tableRowClose;
540: if p_page_code is not null and l_region_description is not null
535: else
536: htp.tableData(cvalue => ''||c_prompts(1)||': '||l_region_title||'', cattributes => 'VALIGN="MIDDLE"');
537: end if;
538:
539: htp.tableRowClose;
540: if p_page_code is not null and l_region_description is not null
541: then
542: htp.tableRowOpen;
543: htp.tableData('
');
538:
539: htp.tableRowClose;
540: if p_page_code is not null and l_region_description is not null
541: then
542: htp.tableRowOpen;
543: htp.tableData('
');
544: htp.tableData(l_region_description);
545: htp.tableRowClose;
546: end if;
539: htp.tableRowClose;
540: if p_page_code is not null and l_region_description is not null
541: then
542: htp.tableRowOpen;
543: htp.tableData('
');
544: htp.tableData(l_region_description);
545: htp.tableRowClose;
546: end if;
547: htp.tableClose;
540: if p_page_code is not null and l_region_description is not null
541: then
542: htp.tableRowOpen;
543: htp.tableData('
');
544: htp.tableData(l_region_description);
545: htp.tableRowClose;
546: end if;
547: htp.tableClose;
548: */
541: then
542: htp.tableRowOpen;
543: htp.tableData('
');
544: htp.tableData(l_region_description);
545: htp.tableRowClose;
546: end if;
547: htp.tableClose;
548: */
549:
543: htp.tableData('
');
544: htp.tableData(l_region_description);
545: htp.tableRowClose;
546: end if;
547: htp.tableClose;
548: */
549:
550: toolbar(p_title => l_search_page_title,
551: p_export => FALSE);
550: toolbar(p_title => l_search_page_title,
551: p_export => FALSE);
552:
553:
554: -- htp.nl;
555: htp.p(l_message);
556: htp.nl;
557: htp.nl;
558:
551: p_export => FALSE);
552:
553:
554: -- htp.nl;
555: htp.p(l_message);
556: htp.nl;
557: htp.nl;
558:
559: if p_lines_now > 1
552:
553:
554: -- htp.nl;
555: htp.p(l_message);
556: htp.nl;
557: htp.nl;
558:
559: if p_lines_now > 1
560: then
553:
554: -- htp.nl;
555: htp.p(l_message);
556: htp.nl;
557: htp.nl;
558:
559: if p_lines_now > 1
560: then
561: fnd_message.set_name('ICX','ICX_FIND_AND_OR_TEXT');
558:
559: if p_lines_now > 1
560: then
561: fnd_message.set_name('ICX','ICX_FIND_AND_OR_TEXT');
562: htp.p(fnd_message.get);htp.nl;
563:
564: fnd_message.set_name('ICX','ICX_FIND_AND');
565: htp.p(htf.formRadio('o','AND','CHECKED')||fnd_message.get);htp.nl;
566:
561: fnd_message.set_name('ICX','ICX_FIND_AND_OR_TEXT');
562: htp.p(fnd_message.get);htp.nl;
563:
564: fnd_message.set_name('ICX','ICX_FIND_AND');
565: htp.p(htf.formRadio('o','AND','CHECKED')||fnd_message.get);htp.nl;
566:
567: fnd_message.set_name('ICX','ICX_FIND_OR');
568: htp.p(htf.formRadio('o','OR')||fnd_message.get);htp.nl;
569: end if;
564: fnd_message.set_name('ICX','ICX_FIND_AND');
565: htp.p(htf.formRadio('o','AND','CHECKED')||fnd_message.get);htp.nl;
566:
567: fnd_message.set_name('ICX','ICX_FIND_OR');
568: htp.p(htf.formRadio('o','OR')||fnd_message.get);htp.nl;
569: end if;
570:
571: htp.p('');
572:
567: fnd_message.set_name('ICX','ICX_FIND_OR');
568: htp.p(htf.formRadio('o','OR')||fnd_message.get);htp.nl;
569: end if;
570:
571: htp.p('');
572:
573: for i in 1..p_lines_now loop
574:
575: htp.tableOpen('BORDER=0');
571: htp.p('');
572:
573: for i in 1..p_lines_now loop
574:
575: htp.tableOpen('BORDER=0');
576: htp.tableRowOpen;
577: if i = 1
578: then
579: htp.tableData(htf.formSelectOpen('a_'||i)||c_attributes(1));
572:
573: for i in 1..p_lines_now loop
574:
575: htp.tableOpen('BORDER=0');
576: htp.tableRowOpen;
577: if i = 1
578: then
579: htp.tableData(htf.formSelectOpen('a_'||i)||c_attributes(1));
580: htp.tableData(htf.formSelectOpen('c_'||i)||c_condition(1));
575: htp.tableOpen('BORDER=0');
576: htp.tableRowOpen;
577: if i = 1
578: then
579: htp.tableData(htf.formSelectOpen('a_'||i)||c_attributes(1));
580: htp.tableData(htf.formSelectOpen('c_'||i)||c_condition(1));
581: else
582: htp.tableData(htf.formSelectOpen('a_'||i)||c_attributes(0));
583: htp.tableData(htf.formSelectOpen('c_'||i)||c_condition(0));
576: htp.tableRowOpen;
577: if i = 1
578: then
579: htp.tableData(htf.formSelectOpen('a_'||i)||c_attributes(1));
580: htp.tableData(htf.formSelectOpen('c_'||i)||c_condition(1));
581: else
582: htp.tableData(htf.formSelectOpen('a_'||i)||c_attributes(0));
583: htp.tableData(htf.formSelectOpen('c_'||i)||c_condition(0));
584: end if;
578: then
579: htp.tableData(htf.formSelectOpen('a_'||i)||c_attributes(1));
580: htp.tableData(htf.formSelectOpen('c_'||i)||c_condition(1));
581: else
582: htp.tableData(htf.formSelectOpen('a_'||i)||c_attributes(0));
583: htp.tableData(htf.formSelectOpen('c_'||i)||c_condition(0));
584: end if;
585: htp.tableData(htf.formText('i_'||i,20));
586: htp.tableRowClose;
579: htp.tableData(htf.formSelectOpen('a_'||i)||c_attributes(1));
580: htp.tableData(htf.formSelectOpen('c_'||i)||c_condition(1));
581: else
582: htp.tableData(htf.formSelectOpen('a_'||i)||c_attributes(0));
583: htp.tableData(htf.formSelectOpen('c_'||i)||c_condition(0));
584: end if;
585: htp.tableData(htf.formText('i_'||i,20));
586: htp.tableRowClose;
587: htp.tableClose;
581: else
582: htp.tableData(htf.formSelectOpen('a_'||i)||c_attributes(0));
583: htp.tableData(htf.formSelectOpen('c_'||i)||c_condition(0));
584: end if;
585: htp.tableData(htf.formText('i_'||i,20));
586: htp.tableRowClose;
587: htp.tableClose;
588:
589: end loop;
582: htp.tableData(htf.formSelectOpen('a_'||i)||c_attributes(0));
583: htp.tableData(htf.formSelectOpen('c_'||i)||c_condition(0));
584: end if;
585: htp.tableData(htf.formText('i_'||i,20));
586: htp.tableRowClose;
587: htp.tableClose;
588:
589: end loop;
590:
583: htp.tableData(htf.formSelectOpen('c_'||i)||c_condition(0));
584: end if;
585: htp.tableData(htf.formText('i_'||i,20));
586: htp.tableRowClose;
587: htp.tableClose;
588:
589: end loop;
590:
591: htp.nl;
587: htp.tableClose;
588:
589: end loop;
590:
591: htp.nl;
592: if l_matchcase_view = 'Unchecked'
593: then
594: htp.p(htf.formCheckbox('m')||c_prompts(6));
595: htp.nl;
590:
591: htp.nl;
592: if l_matchcase_view = 'Unchecked'
593: then
594: htp.p(htf.formCheckbox('m')||c_prompts(6));
595: htp.nl;
596: end if;
597:
598: if l_matchcase_view = 'Checked'
591: htp.nl;
592: if l_matchcase_view = 'Unchecked'
593: then
594: htp.p(htf.formCheckbox('m')||c_prompts(6));
595: htp.nl;
596: end if;
597:
598: if l_matchcase_view = 'Checked'
599: then
596: end if;
597:
598: if l_matchcase_view = 'Checked'
599: then
600: htp.p(htf.formCheckbox('m','','CHECKED')||c_prompts(6));
601: htp.nl;
602: end if;
603:
604: if l_matchcase_view = 'Hidden'
597:
598: if l_matchcase_view = 'Checked'
599: then
600: htp.p(htf.formCheckbox('m','','CHECKED')||c_prompts(6));
601: htp.nl;
602: end if;
603:
604: if l_matchcase_view = 'Hidden'
605: then
604: if l_matchcase_view = 'Hidden'
605: then
606: fnd_message.set_name('ICX','ICX_MATCHCASE_VIEW');
607: l_message := fnd_message.get;
608: htp.p(l_message);
609: htp.p(htf.formHidden('m','CHECKED'));
610: htp.nl;
611: end if;
612:
605: then
606: fnd_message.set_name('ICX','ICX_MATCHCASE_VIEW');
607: l_message := fnd_message.get;
608: htp.p(l_message);
609: htp.p(htf.formHidden('m','CHECKED'));
610: htp.nl;
611: end if;
612:
613: if p_hidden_name is not null
606: fnd_message.set_name('ICX','ICX_MATCHCASE_VIEW');
607: l_message := fnd_message.get;
608: htp.p(l_message);
609: htp.p(htf.formHidden('m','CHECKED'));
610: htp.nl;
611: end if;
612:
613: if p_hidden_name is not null
614: then
611: end if;
612:
613: if p_hidden_name is not null
614: then
615: htp.formHidden(p_hidden_name,p_hidden_value);
616: end if;
617:
618: htp.p('');
622:
615: htp.formHidden(p_hidden_name,p_hidden_value);
616: end if;
617:
618: htp.p('');
622:
623: l_actions(0).name := 'Submit';
617:
618: htp.p('');
622:
623: l_actions(0).name := 'Submit';
624: l_actions(0).text := c_prompts(1);
625: l_actions(0).actiontype := 'function';
651: l_actions(2).gap := 'b_narrow_gap';
652:
653: icx_cabo.buttons(p_actions =>l_actions);
654:
655: htp.p('');
656: htp.p('');
657:
658: exception
659: when others then
652:
653: icx_cabo.buttons(p_actions =>l_actions);
654:
655: htp.p('');
656: htp.p('');
657:
658: exception
659: when others then
660: htp.p(SQLERRM);
656: htp.p('');
657:
658: exception
659: when others then
660: htp.p(SQLERRM);
661: end;
662:
663: procedure displayPage is
664:
692:
693: icx_cabo.g_base_href := FND_WEB_CONFIG.WEB_SERVER;
694: icx_cabo.g_plsql_agent := icx_cabo.plsqlagent;
695:
696: -- select HSECS into l_timer from v$timer;htp.p('begin displayPage @ '||l_timer);htp.nl;
697:
698: l_flow_appl_id := ak_query_pkg.g_regions_table(ak_query_pkg.g_regions_table.FIRST).flow_application_id;
699: l_flow_code := ak_query_pkg.g_regions_table(ak_query_pkg.g_regions_table.FIRST).flow_code;
700: l_page_appl_id := ak_query_pkg.g_regions_table(ak_query_pkg.g_regions_table.FIRST).page_application_id;
709: and FLOW_APPLICATION_ID = l_flow_appl_id;
710:
711: l_cookie := owa_cookie.get('onquery');
712:
713: htp.htmlOpen;
714: htp.p('
715: htp.p('');
716: htp.headOpen;
717:
710:
711: l_cookie := owa_cookie.get('onquery');
712:
713: htp.htmlOpen;
714: htp.p('
715: htp.p('');
716: htp.headOpen;
717:
718: icx_util.copyright;
711: l_cookie := owa_cookie.get('onquery');
712:
713: htp.htmlOpen;
714: htp.p('
715: htp.p('');
716: htp.headOpen;
717:
718: icx_util.copyright;
719:
712:
713: htp.htmlOpen;
714: htp.p('
715: htp.p('');
716: htp.headOpen;
717:
718: icx_util.copyright;
719:
720: htp.p('');
723: htp.p('function help_window(){
724: help_win = window.open("'||icx_cabo.g_base_href||icx_cabo.g_plsql_agent||'OracleON.IC?X='||icx_call.encrypt2(l_flow_appl_id||'*'||l_flow_code||'*'||l_page_appl_id||'*'||l_page_code||'*'||'ICX_HLP_INQUIRIES'||'**]')||'",
725: "help_win","resizable=yes,scrollbars=yes,toolbar=yes,width=600,height=500")};');
726:
727: htp.p('');
728:
729: htp.title(l_page_title);
730: htp.headClose;
731:
725: "help_win","resizable=yes,scrollbars=yes,toolbar=yes,width=600,height=500")};');
726:
727: htp.p('');
728:
729: htp.title(l_page_title);
730: htp.headClose;
731:
732: l_S := icx_on_utilities.g_on_parameters(1)||'*'||icx_on_utilities.g_on_parameters(2)||'*'||icx_on_utilities.g_on_parameters(3)||'*'||icx_on_utilities.g_on_parameters(4)||'*'||icx_on_utilities.g_on_parameters(5)
733: ||'*'||icx_on_utilities.g_on_parameters(6)||'*'||icx_on_utilities.g_on_parameters(7)||'*'||icx_on_utilities.g_on_parameters(8)||'*'||icx_on_utilities.g_on_parameters(9)||'*'||icx_on_utilities.g_on_parameters(10)
726:
727: htp.p('');
728:
729: htp.title(l_page_title);
730: htp.headClose;
731:
732: l_S := icx_on_utilities.g_on_parameters(1)||'*'||icx_on_utilities.g_on_parameters(2)||'*'||icx_on_utilities.g_on_parameters(3)||'*'||icx_on_utilities.g_on_parameters(4)||'*'||icx_on_utilities.g_on_parameters(5)
733: ||'*'||icx_on_utilities.g_on_parameters(6)||'*'||icx_on_utilities.g_on_parameters(7)||'*'||icx_on_utilities.g_on_parameters(8)||'*'||icx_on_utilities.g_on_parameters(9)||'*'||icx_on_utilities.g_on_parameters(10)
734: ||'*'||icx_on_utilities.g_on_parameters(11)||'*'||icx_on_utilities.g_on_parameters(12)||'*'||icx_on_utilities.g_on_parameters(13)||'*'||icx_on_utilities.g_on_parameters(14)||'*'||icx_on_utilities.g_on_parameters(15)
734: ||'*'||icx_on_utilities.g_on_parameters(11)||'*'||icx_on_utilities.g_on_parameters(12)||'*'||icx_on_utilities.g_on_parameters(13)||'*'||icx_on_utilities.g_on_parameters(14)||'*'||icx_on_utilities.g_on_parameters(15)
735: ||'*'||icx_on_utilities.g_on_parameters(16)||'*'||icx_on_utilities.g_on_parameters(17)||'*'||icx_on_utilities.g_on_parameters(18)||'*'||icx_on_utilities.g_on_parameters(19)||'*'||icx_on_utilities.g_on_parameters(20)
736: ||'*'||icx_on_utilities.g_on_parameters(21)||'*'||icx_on_utilities.g_on_parameters(22)||'**]';
737:
738: htp.p('');
739: -- htp.p(''||l_page_title||' '||l_page_description);
740: -- htp.nl;
741: icx_plug_utilities.sessionjavascript;
742:
735: ||'*'||icx_on_utilities.g_on_parameters(16)||'*'||icx_on_utilities.g_on_parameters(17)||'*'||icx_on_utilities.g_on_parameters(18)||'*'||icx_on_utilities.g_on_parameters(19)||'*'||icx_on_utilities.g_on_parameters(20)
736: ||'*'||icx_on_utilities.g_on_parameters(21)||'*'||icx_on_utilities.g_on_parameters(22)||'**]';
737:
738: htp.p('
740: -- htp.nl;
741: icx_plug_utilities.sessionjavascript;
742:
743: htp.p('
741: icx_plug_utilities.sessionjavascript;
742:
743: htp.p('
745: htp.p('');
746:
747: if ak_query_pkg.g_results_table.COUNT = 0
748: then
749: htp.p('');
750: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
751: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(0).name);
752: l_message := fnd_message.get;
753:
750: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
751: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(0).name);
752: l_message := fnd_message.get;
753:
754: htp.strong(l_message);htp.nl;
755:
756: else
757: l_continue := TRUE;
758:
806: and REGION_CODE = ak_query_pkg.g_regions_table(r).region_code;
807:
808: if l_region_description is not null
809: then
810: htp.p(l_region_description);
811: end if;
812:
813: htp.p('');
814:
809: then
810: htp.p(l_region_description);
811: end if;
812:
813: htp.p('');
814:
815: if ak_query_pkg.g_regions_table(r).total_result_count = 0
816: then
817: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
817: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
818: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(r).name);
819: l_message := fnd_message.get;
820:
821: htp.strong(l_message);htp.nl;
822:
823: elsif ak_query_pkg.g_regions_table(r).region_style = 'FORM'
824: and ak_query_pkg.g_regions_table(r).total_result_count > 1
825: then
825: then
826: fnd_message.set_name('ICX','ICX_LIMIT_ROWS_ONE');
827: l_message := fnd_message.get;
828:
829: htp.strong(l_message);
830: l_continue := FALSE;
831: else
832: icx_on_utilities2.displayRegion(ak_query_pkg.g_regions_table(r).region_rec_id);
833: end if; -- total_result_count = 0
851: htp.p('top.tc.currentTab = 2;
852: top.tc.modifytab(2,"text:'||l_page_title||'")
853: top.tabs.location.reload();');
854:
855: htp.p('');
856:
857: icx_cabo.buttons(p_actions =>l_actions);
858: end if;
859:
856:
857: icx_cabo.buttons(p_actions =>l_actions);
858: end if;
859:
860: htp.htmlClose;
861:
862: -- select HSECS into l_timer from v$timer;htp.p('end displayPage @ '||l_timer);htp.nl;
863:
864: end;
858: end if;
859:
860: htp.htmlClose;
861:
862: -- select HSECS into l_timer from v$timer;htp.p('end displayPage @ '||l_timer);htp.nl;
863:
864: end;
865:
866: procedure wherePage is