APPS.ICX_ON_UTILITIES dependencies on HTP

Line 51: htp.htmlOpen;

47: l_region_code := p_region_code;
48:
49: end if;
50:
51: htp.htmlOpen;
52: htp.headOpen;
53:
54: icx_util.copyright;
55:

Line 52: htp.headOpen;

48:
49: end if;
50:
51: htp.htmlOpen;
52: htp.headOpen;
53:
54: icx_util.copyright;
55:
56: htp.p('');

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

62: then
63: htp.p('document.cookie = "onquery=" + self.location.href + ";"');
64: end if;
65:
66: htp.p('// -->');
67: htp.p('');
68:
69: htp.title(l_page_title);
70: htp.headClose;

Line 67: htp.p('');

63: htp.p('document.cookie = "onquery=" + self.location.href + ";"');
64: end if;
65:
66: htp.p('// -->');
67: htp.p('');
68:
69: htp.title(l_page_title);
70: htp.headClose;
71:

Line 69: htp.title(l_page_title);

65:
66: htp.p('// -->');
67: htp.p('');
68:
69: htp.title(l_page_title);
70: htp.headClose;
71:
72: icx_admin_sig.toolbar(language_code => l_language_code);
73:

Line 70: htp.headClose;

66: htp.p('// -->');
67: htp.p('');
68:
69: htp.title(l_page_title);
70: htp.headClose;
71:
72: icx_admin_sig.toolbar(language_code => l_language_code);
73:
74: findForm(p_flow_appl_id => p_flow_appl_id,

Line 92: htp.htmlClose;

88: p_help_url => p_help_url,
89: p_new_url => p_new_url);
90:
91: icx_sig.footer;
92: htp.htmlClose;
93:
94: end;
95:
96: procedure findIcons( p_submit in varchar2,

Line 111: htp.p('');

107: l_browser varchar2(400) := owa_util.get_cgi_env('HTTP_USER_AGENT');
108:
109: begin
110:
111: htp.p('');
112: icx_util.DynamicButton(P_ButtonText => p_submit,
113: P_ImageFileName => 'FNDBSBMT',
114: P_OnMouseOverText => p_submit,
115: P_HyperTextCall => 'javascript:submitFunction()',

Line 118: htp.p('');

114: P_OnMouseOverText => p_submit,
115: P_HyperTextCall => 'javascript:submitFunction()',
116: P_LanguageCode => p_language_code,
117: P_JavaScriptFlag => FALSE);
118: htp.p('');
119: if (instr(l_browser,'MSIE 3')=0) and nvl(p_clear_button,'Y') = 'Y'
120: then
121: htp.p('');
122: icx_util.DynamicButton(P_ButtonText => p_clear,

Line 121: htp.p('');

117: P_JavaScriptFlag => FALSE);
118: htp.p('');
119: if (instr(l_browser,'MSIE 3')=0) and nvl(p_clear_button,'Y') = 'Y'
120: then
121: htp.p('');
122: icx_util.DynamicButton(P_ButtonText => p_clear,
123: P_ImageFileName => 'FNDBCLR',
124: P_OnMouseOverText => p_clear,
125: P_HyperTextCall => 'javascript:resetFunction()',

Line 128: htp.p('');

124: P_OnMouseOverText => p_clear,
125: P_HyperTextCall => 'javascript:resetFunction()',
126: P_LanguageCode => p_language_code,
127: P_JavaScriptFlag => FALSE);
128: htp.p('');
129: end if;
130: if p_lines_next is not null and nvl(p_advanced_button,'Y') = 'Y'
131: then
132: htp.p('');

Line 132: htp.p('');

128: htp.p('');
129: end if;
130: if p_lines_next is not null and nvl(p_advanced_button,'Y') = 'Y'
131: then
132: htp.p('');
133: htp.p('');
134: if p_lines_next > p_lines_now
135: then
136: icx_util.DynamicButton(P_ButtonText => p_more,

Line 133: htp.p('');

129: end if;
130: if p_lines_next is not null and nvl(p_advanced_button,'Y') = 'Y'
131: then
132: htp.p('');
133: htp.p('');
134: if p_lines_next > p_lines_now
135: then
136: icx_util.DynamicButton(P_ButtonText => p_more,
137: P_ImageFileName => 'FNDBMORC',

Line 150: htp.p('');

146: P_HyperTextCall => 'javascript:history.back();',
147: P_LanguageCode => p_language_code,
148: P_JavaScriptFlag => FALSE);
149: end if;
150: htp.p('');
151: end if;
152:
153: end;
154:

Line 339: htp.p('');
574:
575: htp.p('');
576:

Line 573: htp.p('');

569: }');
570: end if;
571:
572: htp.p('// -->');
573: htp.p('');
574:
575: htp.p('');
576:
577: --add addtl hidden form to handle submit mputman

Line 575: htp.p('');

571:
572: htp.p('// -->');
573: htp.p('');
574:
575: htp.p('');
576:
577: --add addtl hidden form to handle submit mputman
578: htp.formOpen('OracleON.IC','POST','','','NAME="findForm0"');
579: htp.formHidden('a_1','""');

Line 578: htp.formOpen('OracleON.IC','POST','','','NAME="findForm0"');

574:
575: htp.p('');
576:
577: --add addtl hidden form to handle submit mputman
578: htp.formOpen('OracleON.IC','POST','','','NAME="findForm0"');
579: htp.formHidden('a_1','""');
580: htp.formHidden('c_1','""');
581: htp.formHidden('i_1','""');
582: htp.formHidden('a_2','""');

Line 579: htp.formHidden('a_1','""');

575: htp.p('');
576:
577: --add addtl hidden form to handle submit mputman
578: htp.formOpen('OracleON.IC','POST','','','NAME="findForm0"');
579: htp.formHidden('a_1','""');
580: htp.formHidden('c_1','""');
581: htp.formHidden('i_1','""');
582: htp.formHidden('a_2','""');
583: htp.formHidden('c_2','""');

Line 580: htp.formHidden('c_1','""');

576:
577: --add addtl hidden form to handle submit mputman
578: htp.formOpen('OracleON.IC','POST','','','NAME="findForm0"');
579: htp.formHidden('a_1','""');
580: htp.formHidden('c_1','""');
581: htp.formHidden('i_1','""');
582: htp.formHidden('a_2','""');
583: htp.formHidden('c_2','""');
584: htp.formHidden('i_2','""');

Line 581: htp.formHidden('i_1','""');

577: --add addtl hidden form to handle submit mputman
578: htp.formOpen('OracleON.IC','POST','','','NAME="findForm0"');
579: htp.formHidden('a_1','""');
580: htp.formHidden('c_1','""');
581: htp.formHidden('i_1','""');
582: htp.formHidden('a_2','""');
583: htp.formHidden('c_2','""');
584: htp.formHidden('i_2','""');
585: htp.formHidden('a_3','""');

Line 582: htp.formHidden('a_2','""');

578: htp.formOpen('OracleON.IC','POST','','','NAME="findForm0"');
579: htp.formHidden('a_1','""');
580: htp.formHidden('c_1','""');
581: htp.formHidden('i_1','""');
582: htp.formHidden('a_2','""');
583: htp.formHidden('c_2','""');
584: htp.formHidden('i_2','""');
585: htp.formHidden('a_3','""');
586: htp.formHidden('c_3','""');

Line 583: htp.formHidden('c_2','""');

579: htp.formHidden('a_1','""');
580: htp.formHidden('c_1','""');
581: htp.formHidden('i_1','""');
582: htp.formHidden('a_2','""');
583: htp.formHidden('c_2','""');
584: htp.formHidden('i_2','""');
585: htp.formHidden('a_3','""');
586: htp.formHidden('c_3','""');
587: htp.formHidden('i_3','""');

Line 584: htp.formHidden('i_2','""');

580: htp.formHidden('c_1','""');
581: htp.formHidden('i_1','""');
582: htp.formHidden('a_2','""');
583: htp.formHidden('c_2','""');
584: htp.formHidden('i_2','""');
585: htp.formHidden('a_3','""');
586: htp.formHidden('c_3','""');
587: htp.formHidden('i_3','""');
588: htp.formHidden('a_4','""');

Line 585: htp.formHidden('a_3','""');

581: htp.formHidden('i_1','""');
582: htp.formHidden('a_2','""');
583: htp.formHidden('c_2','""');
584: htp.formHidden('i_2','""');
585: htp.formHidden('a_3','""');
586: htp.formHidden('c_3','""');
587: htp.formHidden('i_3','""');
588: htp.formHidden('a_4','""');
589: htp.formHidden('c_4','""');

Line 586: htp.formHidden('c_3','""');

582: htp.formHidden('a_2','""');
583: htp.formHidden('c_2','""');
584: htp.formHidden('i_2','""');
585: htp.formHidden('a_3','""');
586: htp.formHidden('c_3','""');
587: htp.formHidden('i_3','""');
588: htp.formHidden('a_4','""');
589: htp.formHidden('c_4','""');
590: htp.formHidden('i_4','""');

Line 587: htp.formHidden('i_3','""');

583: htp.formHidden('c_2','""');
584: htp.formHidden('i_2','""');
585: htp.formHidden('a_3','""');
586: htp.formHidden('c_3','""');
587: htp.formHidden('i_3','""');
588: htp.formHidden('a_4','""');
589: htp.formHidden('c_4','""');
590: htp.formHidden('i_4','""');
591: htp.formHidden('a_5','""');

Line 588: htp.formHidden('a_4','""');

584: htp.formHidden('i_2','""');
585: htp.formHidden('a_3','""');
586: htp.formHidden('c_3','""');
587: htp.formHidden('i_3','""');
588: htp.formHidden('a_4','""');
589: htp.formHidden('c_4','""');
590: htp.formHidden('i_4','""');
591: htp.formHidden('a_5','""');
592: htp.formHidden('c_5','""');

Line 589: htp.formHidden('c_4','""');

585: htp.formHidden('a_3','""');
586: htp.formHidden('c_3','""');
587: htp.formHidden('i_3','""');
588: htp.formHidden('a_4','""');
589: htp.formHidden('c_4','""');
590: htp.formHidden('i_4','""');
591: htp.formHidden('a_5','""');
592: htp.formHidden('c_5','""');
593: htp.formHidden('i_5','""');

Line 590: htp.formHidden('i_4','""');

586: htp.formHidden('c_3','""');
587: htp.formHidden('i_3','""');
588: htp.formHidden('a_4','""');
589: htp.formHidden('c_4','""');
590: htp.formHidden('i_4','""');
591: htp.formHidden('a_5','""');
592: htp.formHidden('c_5','""');
593: htp.formHidden('i_5','""');
594: htp.formHidden('m','""');

Line 591: htp.formHidden('a_5','""');

587: htp.formHidden('i_3','""');
588: htp.formHidden('a_4','""');
589: htp.formHidden('c_4','""');
590: htp.formHidden('i_4','""');
591: htp.formHidden('a_5','""');
592: htp.formHidden('c_5','""');
593: htp.formHidden('i_5','""');
594: htp.formHidden('m','""');
595: if p_hidden_name is not null

Line 592: htp.formHidden('c_5','""');

588: htp.formHidden('a_4','""');
589: htp.formHidden('c_4','""');
590: htp.formHidden('i_4','""');
591: htp.formHidden('a_5','""');
592: htp.formHidden('c_5','""');
593: htp.formHidden('i_5','""');
594: htp.formHidden('m','""');
595: if p_hidden_name is not null
596: THEN

Line 593: htp.formHidden('i_5','""');

589: htp.formHidden('c_4','""');
590: htp.formHidden('i_4','""');
591: htp.formHidden('a_5','""');
592: htp.formHidden('c_5','""');
593: htp.formHidden('i_5','""');
594: htp.formHidden('m','""');
595: if p_hidden_name is not null
596: THEN
597: htp.formHidden(p_hidden_name,'""');

Line 594: htp.formHidden('m','""');

590: htp.formHidden('i_4','""');
591: htp.formHidden('a_5','""');
592: htp.formHidden('c_5','""');
593: htp.formHidden('i_5','""');
594: htp.formHidden('m','""');
595: if p_hidden_name is not null
596: THEN
597: htp.formHidden(p_hidden_name,'""');
598: END IF;

Line 597: htp.formHidden(p_hidden_name,'""');

593: htp.formHidden('i_5','""');
594: htp.formHidden('m','""');
595: if p_hidden_name is not null
596: THEN
597: htp.formHidden(p_hidden_name,'""');
598: END IF;
599: htp.formHidden('o','""');
600:
601: htp.formClose;

Line 599: htp.formHidden('o','""');

595: if p_hidden_name is not null
596: THEN
597: htp.formHidden(p_hidden_name,'""');
598: END IF;
599: htp.formHidden('o','""');
600:
601: htp.formClose;
602:
603: if p_goto_url is null

Line 601: htp.formClose;

597: htp.formHidden(p_hidden_name,'""');
598: END IF;
599: htp.formHidden('o','""');
600:
601: htp.formClose;
602:
603: if p_goto_url is null
604: then
605: htp.formOpen('javascript:submitFunction()','POST','','','NAME="findForm"');

Line 605: htp.formOpen('javascript:submitFunction()','POST','','','NAME="findForm"');

601: htp.formClose;
602:
603: if p_goto_url is null
604: then
605: htp.formOpen('javascript:submitFunction()','POST','','','NAME="findForm"');
606: else
607: htp.formOpen(p_goto_url,'POST',p_goto_target,'','NAME="findForm"');
608: end if;
609:

Line 607: htp.formOpen(p_goto_url,'POST',p_goto_target,'','NAME="findForm"');

603: if p_goto_url is null
604: then
605: htp.formOpen('javascript:submitFunction()','POST','','','NAME="findForm"');
606: else
607: htp.formOpen(p_goto_url,'POST',p_goto_target,'','NAME="findForm"');
608: end if;
609:
610: if p_default_title = 'Y'
611: then

Line 640: htp.tableOpen('BORDER=0');

636: fnd_message.set_name('ICX','ICX_FIND_NUMBER');
637: l_message := fnd_message.get;
638: end if;
639:
640: htp.tableOpen('BORDER=0');
641: htp.tableRowOpen;
642: htp.tableData(cvalue => htf.img(curl => '/OA_MEDIA/FNDIFIND.gif', calt => c_prompts(1)));
643:
644: if p_page_code is not null

Line 641: htp.tableRowOpen;

637: l_message := fnd_message.get;
638: end if;
639:
640: htp.tableOpen('BORDER=0');
641: htp.tableRowOpen;
642: htp.tableData(cvalue => htf.img(curl => '/OA_MEDIA/FNDIFIND.gif', calt => c_prompts(1)));
643:
644: if p_page_code is not null
645: then

Line 642: htp.tableData(cvalue => htf.img(curl => '/OA_MEDIA/FNDIFIND.gif', calt => c_prompts(1)));

638: end if;
639:
640: htp.tableOpen('BORDER=0');
641: htp.tableRowOpen;
642: htp.tableData(cvalue => htf.img(curl => '/OA_MEDIA/FNDIFIND.gif', calt => c_prompts(1)));
643:
644: if p_page_code is not null
645: then
646: htp.tableData(cvalue => ''||c_prompts(1)||': '||l_page_title||' '||l_page_description, cattributes => 'VALIGN="MIDDLE"');

Line 646: htp.tableData(cvalue => ''||c_prompts(1)||': '||l_page_title||' '||l_page_description, cattributes => 'VALIGN="MIDDLE"');

642: htp.tableData(cvalue => htf.img(curl => '/OA_MEDIA/FNDIFIND.gif', calt => c_prompts(1)));
643:
644: if p_page_code is not null
645: then
646: htp.tableData(cvalue => ''||c_prompts(1)||': '||l_page_title||' '||l_page_description, cattributes => 'VALIGN="MIDDLE"');
647: else
648: htp.tableData(cvalue => ''||c_prompts(1)||': '||l_region_title||'', cattributes => 'VALIGN="MIDDLE"');
649: end if;
650:

Line 648: htp.tableData(cvalue => ''||c_prompts(1)||': '||l_region_title||'', cattributes => 'VALIGN="MIDDLE"');

644: if p_page_code is not null
645: then
646: htp.tableData(cvalue => ''||c_prompts(1)||': '||l_page_title||' '||l_page_description, cattributes => 'VALIGN="MIDDLE"');
647: else
648: htp.tableData(cvalue => ''||c_prompts(1)||': '||l_region_title||'', cattributes => 'VALIGN="MIDDLE"');
649: end if;
650:
651: if p_new_url is not null
652: then

Line 653: htp.p('');

649: end if;
650:
651: if p_new_url is not null
652: then
653: htp.p('');
654: icx_util.DynamicButton(P_ButtonText => c_prompts(5),
655: P_ImageFileName => 'FNDBNEW',
656: P_OnMouseOverText => c_prompts(5),
657: P_HyperTextCall => p_new_url,

Line 660: htp.p('');

656: P_OnMouseOverText => c_prompts(5),
657: P_HyperTextCall => p_new_url,
658: P_LanguageCode => l_language_code,
659: P_JavaScriptFlag => FALSE);
660: htp.p('');
661: end if;
662:
663: htp.tableRowClose;
664: if p_page_code is not null and l_region_description is not null

Line 663: htp.tableRowClose;

659: P_JavaScriptFlag => FALSE);
660: htp.p('');
661: end if;
662:
663: htp.tableRowClose;
664: if p_page_code is not null and l_region_description is not null
665: then
666: htp.tableRowOpen;
667: htp.tableData('
');

Line 666: htp.tableRowOpen;

662:
663: htp.tableRowClose;
664: if p_page_code is not null and l_region_description is not null
665: then
666: htp.tableRowOpen;
667: htp.tableData('
');
668: htp.tableData(l_region_description);
669: htp.tableRowClose;
670: end if;

Line 667: htp.tableData('
');

663: htp.tableRowClose;
664: if p_page_code is not null and l_region_description is not null
665: then
666: htp.tableRowOpen;
667: htp.tableData('
');
668: htp.tableData(l_region_description);
669: htp.tableRowClose;
670: end if;
671: htp.tableClose;

Line 668: htp.tableData(l_region_description);

664: if p_page_code is not null and l_region_description is not null
665: then
666: htp.tableRowOpen;
667: htp.tableData('
');
668: htp.tableData(l_region_description);
669: htp.tableRowClose;
670: end if;
671: htp.tableClose;
672: htp.nl;

Line 669: htp.tableRowClose;

665: then
666: htp.tableRowOpen;
667: htp.tableData('
');
668: htp.tableData(l_region_description);
669: htp.tableRowClose;
670: end if;
671: htp.tableClose;
672: htp.nl;
673: htp.p(l_message);

Line 671: htp.tableClose;

667: htp.tableData('
');
668: htp.tableData(l_region_description);
669: htp.tableRowClose;
670: end if;
671: htp.tableClose;
672: htp.nl;
673: htp.p(l_message);
674: htp.nl;
675: htp.nl;

Line 672: htp.nl;

668: htp.tableData(l_region_description);
669: htp.tableRowClose;
670: end if;
671: htp.tableClose;
672: htp.nl;
673: htp.p(l_message);
674: htp.nl;
675: htp.nl;
676:

Line 673: htp.p(l_message);

669: htp.tableRowClose;
670: end if;
671: htp.tableClose;
672: htp.nl;
673: htp.p(l_message);
674: htp.nl;
675: htp.nl;
676:
677: end if; -- p_default_title = 'Y'

Line 674: htp.nl;

670: end if;
671: htp.tableClose;
672: htp.nl;
673: htp.p(l_message);
674: htp.nl;
675: htp.nl;
676:
677: end if; -- p_default_title = 'Y'
678:

Line 675: htp.nl;

671: htp.tableClose;
672: htp.nl;
673: htp.p(l_message);
674: htp.nl;
675: htp.nl;
676:
677: end if; -- p_default_title = 'Y'
678:
679: if p_lines_now = 1

Line 683: htp.tableOpen(cborder => 'BORDER=0',

679: if p_lines_now = 1
680: and (l_region_code = 'ICX_WEBSTORE_SEARCH_ITEMS_R'
681: or l_region_code = 'ICX_PO_SUPPL_SEARCH_ITEMS_R')
682: then
683: htp.tableOpen(cborder => 'BORDER=0',
684: cattributes => 'CELLPADDING=0 CELLSPACING=0');
685: htp.tableRowOpen;
686: htp.tableData(htf.formHidden('a_1',l_context_column));
687: htp.tableData(htf.formHidden('c_1','CCONTAIN'));

Line 685: htp.tableRowOpen;

681: or l_region_code = 'ICX_PO_SUPPL_SEARCH_ITEMS_R')
682: then
683: htp.tableOpen(cborder => 'BORDER=0',
684: cattributes => 'CELLPADDING=0 CELLSPACING=0');
685: htp.tableRowOpen;
686: htp.tableData(htf.formHidden('a_1',l_context_column));
687: htp.tableData(htf.formHidden('c_1','CCONTAIN'));
688: htp.tableData(htf.formText('i_1',20), 'LEFT');
689: htp.tableData('
');

Line 686: htp.tableData(htf.formHidden('a_1',l_context_column));

682: then
683: htp.tableOpen(cborder => 'BORDER=0',
684: cattributes => 'CELLPADDING=0 CELLSPACING=0');
685: htp.tableRowOpen;
686: htp.tableData(htf.formHidden('a_1',l_context_column));
687: htp.tableData(htf.formHidden('c_1','CCONTAIN'));
688: htp.tableData(htf.formText('i_1',20), 'LEFT');
689: htp.tableData('
');
690: htp.tableData('
');

Line 687: htp.tableData(htf.formHidden('c_1','CCONTAIN'));

683: htp.tableOpen(cborder => 'BORDER=0',
684: cattributes => 'CELLPADDING=0 CELLSPACING=0');
685: htp.tableRowOpen;
686: htp.tableData(htf.formHidden('a_1',l_context_column));
687: htp.tableData(htf.formHidden('c_1','CCONTAIN'));
688: htp.tableData(htf.formText('i_1',20), 'LEFT');
689: htp.tableData('
');
690: htp.tableData('
');
691: htp.tableData('
');

Line 688: htp.tableData(htf.formText('i_1',20), 'LEFT');

684: cattributes => 'CELLPADDING=0 CELLSPACING=0');
685: htp.tableRowOpen;
686: htp.tableData(htf.formHidden('a_1',l_context_column));
687: htp.tableData(htf.formHidden('c_1','CCONTAIN'));
688: htp.tableData(htf.formText('i_1',20), 'LEFT');
689: htp.tableData('
');
690: htp.tableData('
');
691: htp.tableData('
');
692: if p_LOV_mode = 'Y'

Line 689: htp.tableData('
');

685: htp.tableRowOpen;
686: htp.tableData(htf.formHidden('a_1',l_context_column));
687: htp.tableData(htf.formHidden('c_1','CCONTAIN'));
688: htp.tableData(htf.formText('i_1',20), 'LEFT');
689: htp.tableData('
');
690: htp.tableData('
');
691: htp.tableData('
');
692: if p_LOV_mode = 'Y'
693: then

Line 690: htp.tableData('
');

686: htp.tableData(htf.formHidden('a_1',l_context_column));
687: htp.tableData(htf.formHidden('c_1','CCONTAIN'));
688: htp.tableData(htf.formText('i_1',20), 'LEFT');
689: htp.tableData('
');
690: htp.tableData('
');
691: htp.tableData('
');
692: if p_LOV_mode = 'Y'
693: then
694: findIcons(p_submit => c_prompts(1),

Line 691: htp.tableData('
');

687: htp.tableData(htf.formHidden('c_1','CCONTAIN'));
688: htp.tableData(htf.formText('i_1',20), 'LEFT');
689: htp.tableData('
');
690: htp.tableData('
');
691: htp.tableData('
');
692: if p_LOV_mode = 'Y'
693: then
694: findIcons(p_submit => c_prompts(1),
695: p_clear => c_prompts(2),

Line 705: htp.tableRowClose;

701: p_language_code => l_language_code,
702: p_clear_button => p_clear_button,
703: p_advanced_button => p_advanced_button);
704: end if;
705: htp.tableRowClose;
706: htp.tableClose;
707: else
708:
709: if p_lines_now > 1

Line 706: htp.tableClose;

702: p_clear_button => p_clear_button,
703: p_advanced_button => p_advanced_button);
704: end if;
705: htp.tableRowClose;
706: htp.tableClose;
707: else
708:
709: if p_lines_now > 1
710: then

Line 712: htp.p(fnd_message.get);htp.nl;

708:
709: if p_lines_now > 1
710: then
711: fnd_message.set_name('ICX','ICX_FIND_AND_OR_TEXT');
712: htp.p(fnd_message.get);htp.nl;
713:
714: fnd_message.set_name('ICX','ICX_FIND_AND');
715: htp.p(htf.formRadio('o','AND','CHECKED')||fnd_message.get);htp.nl;
716:

Line 715: htp.p(htf.formRadio('o','AND','CHECKED')||fnd_message.get);htp.nl;

711: fnd_message.set_name('ICX','ICX_FIND_AND_OR_TEXT');
712: htp.p(fnd_message.get);htp.nl;
713:
714: fnd_message.set_name('ICX','ICX_FIND_AND');
715: htp.p(htf.formRadio('o','AND','CHECKED')||fnd_message.get);htp.nl;
716:
717: fnd_message.set_name('ICX','ICX_FIND_OR');
718: htp.p(htf.formRadio('o','OR')||fnd_message.get);htp.nl;
719: end if;

Line 718: htp.p(htf.formRadio('o','OR')||fnd_message.get);htp.nl;

714: fnd_message.set_name('ICX','ICX_FIND_AND');
715: htp.p(htf.formRadio('o','AND','CHECKED')||fnd_message.get);htp.nl;
716:
717: fnd_message.set_name('ICX','ICX_FIND_OR');
718: htp.p(htf.formRadio('o','OR')||fnd_message.get);htp.nl;
719: end if;
720:
721: for i in 1..p_lines_now loop
722:

Line 723: htp.tableOpen('BORDER=0');

719: end if;
720:
721: for i in 1..p_lines_now loop
722:
723: htp.tableOpen('BORDER=0');
724: htp.tableRowOpen;
725: if i = 1
726: then
727: htp.tableData(htf.formSelectOpen('a_'||i)||c_attributes(1));

Line 724: htp.tableRowOpen;

720:
721: for i in 1..p_lines_now loop
722:
723: htp.tableOpen('BORDER=0');
724: htp.tableRowOpen;
725: if i = 1
726: then
727: htp.tableData(htf.formSelectOpen('a_'||i)||c_attributes(1));
728: htp.tableData(htf.formSelectOpen('c_'||i)||c_condition(1));

Line 727: htp.tableData(htf.formSelectOpen('a_'||i)||c_attributes(1));

723: htp.tableOpen('BORDER=0');
724: htp.tableRowOpen;
725: if i = 1
726: then
727: htp.tableData(htf.formSelectOpen('a_'||i)||c_attributes(1));
728: htp.tableData(htf.formSelectOpen('c_'||i)||c_condition(1));
729: else
730: htp.tableData(htf.formSelectOpen('a_'||i)||c_attributes(0));
731: htp.tableData(htf.formSelectOpen('c_'||i)||c_condition(0));

Line 728: htp.tableData(htf.formSelectOpen('c_'||i)||c_condition(1));

724: htp.tableRowOpen;
725: if i = 1
726: then
727: htp.tableData(htf.formSelectOpen('a_'||i)||c_attributes(1));
728: htp.tableData(htf.formSelectOpen('c_'||i)||c_condition(1));
729: else
730: htp.tableData(htf.formSelectOpen('a_'||i)||c_attributes(0));
731: htp.tableData(htf.formSelectOpen('c_'||i)||c_condition(0));
732: end if;

Line 730: htp.tableData(htf.formSelectOpen('a_'||i)||c_attributes(0));

726: then
727: htp.tableData(htf.formSelectOpen('a_'||i)||c_attributes(1));
728: htp.tableData(htf.formSelectOpen('c_'||i)||c_condition(1));
729: else
730: htp.tableData(htf.formSelectOpen('a_'||i)||c_attributes(0));
731: htp.tableData(htf.formSelectOpen('c_'||i)||c_condition(0));
732: end if;
733: htp.tableData(htf.formText('i_'||i,20));
734: if i = 1 and p_LOV_mode = 'Y'

Line 731: htp.tableData(htf.formSelectOpen('c_'||i)||c_condition(0));

727: htp.tableData(htf.formSelectOpen('a_'||i)||c_attributes(1));
728: htp.tableData(htf.formSelectOpen('c_'||i)||c_condition(1));
729: else
730: htp.tableData(htf.formSelectOpen('a_'||i)||c_attributes(0));
731: htp.tableData(htf.formSelectOpen('c_'||i)||c_condition(0));
732: end if;
733: htp.tableData(htf.formText('i_'||i,20));
734: if i = 1 and p_LOV_mode = 'Y'
735: then

Line 733: htp.tableData(htf.formText('i_'||i,20));

729: else
730: htp.tableData(htf.formSelectOpen('a_'||i)||c_attributes(0));
731: htp.tableData(htf.formSelectOpen('c_'||i)||c_condition(0));
732: end if;
733: htp.tableData(htf.formText('i_'||i,20));
734: if i = 1 and p_LOV_mode = 'Y'
735: then
736: findIcons(p_submit => c_prompts(1),
737: p_clear => c_prompts(2),

Line 747: htp.tableRowClose;

743: p_language_code => l_language_code,
744: p_clear_button => p_clear_button,
745: p_advanced_button => p_advanced_button);
746: end if;
747: htp.tableRowClose;
748: htp.tableClose;
749:
750: end loop;
751:

Line 748: htp.tableClose;

744: p_clear_button => p_clear_button,
745: p_advanced_button => p_advanced_button);
746: end if;
747: htp.tableRowClose;
748: htp.tableClose;
749:
750: end loop;
751:
752: htp.nl;

Line 752: htp.nl;

748: htp.tableClose;
749:
750: end loop;
751:
752: htp.nl;
753: htp.p(htf.formCheckbox('m')||c_prompts(6));
754: htp.nl;
755:
756: end if; -- Store and Reqs

Line 753: htp.p(htf.formCheckbox('m')||c_prompts(6));

749:
750: end loop;
751:
752: htp.nl;
753: htp.p(htf.formCheckbox('m')||c_prompts(6));
754: htp.nl;
755:
756: end if; -- Store and Reqs
757:

Line 754: htp.nl;

750: end loop;
751:
752: htp.nl;
753: htp.p(htf.formCheckbox('m')||c_prompts(6));
754: htp.nl;
755:
756: end if; -- Store and Reqs
757:
758: if p_hidden_name is not null

Line 760: htp.formHidden(p_hidden_name,p_hidden_value);

756: end if; -- Store and Reqs
757:
758: if p_hidden_name is not null
759: then
760: htp.formHidden(p_hidden_name,p_hidden_value);
761: end if;
762:
763: if p_LOV_mode = 'N'
764: then

Line 765: htp.nl;

761: end if;
762:
763: if p_LOV_mode = 'N'
764: then
765: htp.nl;
766: htp.tableOpen('BORDER=0');
767: htp.tableRowOpen;
768: findIcons(p_submit => c_prompts(1),
769: p_clear => c_prompts(2),

Line 766: htp.tableOpen('BORDER=0');

762:
763: if p_LOV_mode = 'N'
764: then
765: htp.nl;
766: htp.tableOpen('BORDER=0');
767: htp.tableRowOpen;
768: findIcons(p_submit => c_prompts(1),
769: p_clear => c_prompts(2),
770: p_one => c_prompts(4),

Line 767: htp.tableRowOpen;

763: if p_LOV_mode = 'N'
764: then
765: htp.nl;
766: htp.tableOpen('BORDER=0');
767: htp.tableRowOpen;
768: findIcons(p_submit => c_prompts(1),
769: p_clear => c_prompts(2),
770: p_one => c_prompts(4),
771: p_more => c_prompts(3),

Line 778: htp.tableRowClose;

774: p_url => c_url,
775: p_language_code => l_language_code,
776: p_clear_button => p_clear_button,
777: p_advanced_button => p_advanced_button);
778: htp.tableRowClose;
779: htp.tableClose;
780: end if;
781:
782: htp.p('');

Line 779: htp.tableClose;

775: p_language_code => l_language_code,
776: p_clear_button => p_clear_button,
777: p_advanced_button => p_advanced_button);
778: htp.tableRowClose;
779: htp.tableClose;
780: end if;
781:
782: htp.p('');
783:

Line 782: htp.p('');

778: htp.tableRowClose;
779: htp.tableClose;
780: end if;
781:
782: htp.p('');
783:
784: exception
785: when others then
786: htp.p(SQLERRM);

Line 786: htp.p(SQLERRM);

782: htp.p('');
783:
784: exception
785: when others then
786: htp.p(SQLERRM);
787: end;
788:
789: procedure getRegions(p_where in varchar2) is
790: l_timer number;

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

859: order by DISPLAY_SEQUENCE;
860:
861: begin
862:
863: -- select HSECS into l_timer from v$timer;htp.p('begin getRegions @ '||l_timer);htp.nl;
864:
865: /*
866: for i in 1..22 loop
867: htp.p(i||' = '||nvl(icx_on_utilities.g_on_parameters(i),'NULL'));

Line 867: htp.p(i||' = '||nvl(icx_on_utilities.g_on_parameters(i),'NULL'));

863: -- select HSECS into l_timer from v$timer;htp.p('begin getRegions @ '||l_timer);htp.nl;
864:
865: /*
866: for i in 1..22 loop
867: htp.p(i||' = '||nvl(icx_on_utilities.g_on_parameters(i),'NULL'));
868: htp.nl;
869: end loop;
870: */
871:

Line 868: htp.nl;

864:
865: /*
866: for i in 1..22 loop
867: htp.p(i||' = '||nvl(icx_on_utilities.g_on_parameters(i),'NULL'));
868: htp.nl;
869: end loop;
870: */
871:
872: c_type := icx_on_utilities.g_on_parameters(1);

Line 1078: -- select HSECS into l_timer from v$timer;htp.p('start exec_query LOV @ '||l_timer);htp.nl;

1074: then
1075: l_end := l_start+l_query_set-1;
1076: end if;
1077:
1078: -- select HSECS into l_timer from v$timer;htp.p('start exec_query LOV @ '||l_timer);htp.nl;
1079:
1080: -- dbms_session.set_sql_trace(TRUE);
1081:
1082: unpack_whereSegment(p_where,l_where_clause,l_query_binds);

Line 1085: htp.p('p_where = '||p_where);htp.nl;

1081:
1082: unpack_whereSegment(p_where,l_where_clause,l_query_binds);
1083:
1084: /* DEBUG TRACE
1085: htp.p('p_where = '||p_where);htp.nl;
1086: htp.p('DEBUG MESSAGE ak_query_pkg.exec_query('''||l_flow_appl_id||''','''||l_flow_code||''','''||c_to_page_appl_id||''','''||c_to_page_code||''','||c_to_region_appl_id||','''||c_to_region_code
1087: ||''','''||''','''||''','''||''','''||''','''||''','''||''','''||''','''||''','''||''','''||''','''||''','''||
1088: c_to_page_appl_id||''','''||c_to_page_code||''','''||l_where_clause||''','''||''','||l_responsibility_id||','||l_user_id||',T,'||l_return_children||',F,F,'||l_range_low||','||l_range_high||')');htp.nl;
1089: if l_query_binds.COUNT > 0 then

Line 1086: htp.p('DEBUG MESSAGE ak_query_pkg.exec_query('''||l_flow_appl_id||''','''||l_flow_code||''','''||c_to_page_appl_id||''','''||c_to_page_code||''','||c_to_region_appl_id||','''||c_to_region_code

1082: unpack_whereSegment(p_where,l_where_clause,l_query_binds);
1083:
1084: /* DEBUG TRACE
1085: htp.p('p_where = '||p_where);htp.nl;
1086: htp.p('DEBUG MESSAGE ak_query_pkg.exec_query('''||l_flow_appl_id||''','''||l_flow_code||''','''||c_to_page_appl_id||''','''||c_to_page_code||''','||c_to_region_appl_id||','''||c_to_region_code
1087: ||''','''||''','''||''','''||''','''||''','''||''','''||''','''||''','''||''','''||''','''||''','''||''','''||
1088: c_to_page_appl_id||''','''||c_to_page_code||''','''||l_where_clause||''','''||''','||l_responsibility_id||','||l_user_id||',T,'||l_return_children||',F,F,'||l_range_low||','||l_range_high||')');htp.nl;
1089: if l_query_binds.COUNT > 0 then
1090: for i in l_query_binds.FIRST..l_query_binds.LAST loop

Line 1088: c_to_page_appl_id||''','''||c_to_page_code||''','''||l_where_clause||''','''||''','||l_responsibility_id||','||l_user_id||',T,'||l_return_children||',F,F,'||l_range_low||','||l_range_high||')');htp.nl;

1084: /* DEBUG TRACE
1085: htp.p('p_where = '||p_where);htp.nl;
1086: htp.p('DEBUG MESSAGE ak_query_pkg.exec_query('''||l_flow_appl_id||''','''||l_flow_code||''','''||c_to_page_appl_id||''','''||c_to_page_code||''','||c_to_region_appl_id||','''||c_to_region_code
1087: ||''','''||''','''||''','''||''','''||''','''||''','''||''','''||''','''||''','''||''','''||''','''||''','''||
1088: c_to_page_appl_id||''','''||c_to_page_code||''','''||l_where_clause||''','''||''','||l_responsibility_id||','||l_user_id||',T,'||l_return_children||',F,F,'||l_range_low||','||l_range_high||')');htp.nl;
1089: if l_query_binds.COUNT > 0 then
1090: for i in l_query_binds.FIRST..l_query_binds.LAST loop
1091: htp.p(l_query_binds(i).name||' '||l_query_binds(i).value);htp.nl;
1092: end loop;

Line 1091: htp.p(l_query_binds(i).name||' '||l_query_binds(i).value);htp.nl;

1087: ||''','''||''','''||''','''||''','''||''','''||''','''||''','''||''','''||''','''||''','''||''','''||''','''||
1088: c_to_page_appl_id||''','''||c_to_page_code||''','''||l_where_clause||''','''||''','||l_responsibility_id||','||l_user_id||',T,'||l_return_children||',F,F,'||l_range_low||','||l_range_high||')');htp.nl;
1089: if l_query_binds.COUNT > 0 then
1090: for i in l_query_binds.FIRST..l_query_binds.LAST loop
1091: htp.p(l_query_binds(i).name||' '||l_query_binds(i).value);htp.nl;
1092: end loop;
1093: end if;
1094: */
1095:

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

1121: -- icx_on_utilities2.printPLSQLtables;
1122:
1123: -- dbms_session.set_sql_trace(FALSE);
1124:
1125: -- select HSECS into l_timer from v$timer;htp.p('end exec_query LOV @ '||l_timer);htp.nl;
1126:
1127: c_table_count := 2;
1128: end if;
1129:

Line 1147: htp.p('DEBUG MESSAGE ak_query_pkg.exec_query('||l_flow_appl_id||','''||l_flow_code||''','||c_from_page_appl_id||','''||c_from_page_code||''','||c_from_region_appl_id||','''||c_from_region_code

1143: /* DEBUG
1144: set serverout on size 200000;
1145: ALTER SESSION SET SQL_TRACE TRUE;
1146: execute
1147: htp.p('DEBUG MESSAGE ak_query_pkg.exec_query('||l_flow_appl_id||','''||l_flow_code||''','||c_from_page_appl_id||','''||c_from_page_code||''','||c_from_region_appl_id||','''||c_from_region_code
1148: ||''','''||c_unique_key_name||''','''||c_keys(1)||''','''||c_keys(2)||''','''||c_keys(3)||''','''||c_keys(4)||''','''||c_keys(5)||''','''||c_keys(6)||''','''||c_keys(7)||''','''||c_keys(8)||''','''||c_keys(9)||''','''||c_keys(10)
1149: ||''','''||c_to_page_appl_id||''','''||c_to_page_code||''','''||''','''||''','||l_responsibility_id||','||l_user_id||',F,T,F,F)');
1150: ALTER SESSION SET SQL_TRACE FALSE;
1151: */

Line 1153: -- select HSECS into l_timer from v$timer;htp.p('start exec_query PK @ '||l_timer);htp.nl;

1149: ||''','''||c_to_page_appl_id||''','''||c_to_page_code||''','''||''','''||''','||l_responsibility_id||','||l_user_id||',F,T,F,F)');
1150: ALTER SESSION SET SQL_TRACE FALSE;
1151: */
1152:
1153: -- select HSECS into l_timer from v$timer;htp.p('start exec_query PK @ '||l_timer);htp.nl;
1154:
1155: -- dbms_session.set_sql_trace(TRUE);
1156:
1157: ak_query_pkg.exec_query(

Line 1187: -- select HSECS into l_timer from v$timer;htp.p('start exec_query PK @ '||l_timer);htp.nl;

1183: -- icx_on_utilities2.printPLSQLtables;
1184:
1185: -- dbms_session.set_sql_trace(FALSE);
1186:
1187: -- select HSECS into l_timer from v$timer;htp.p('start exec_query PK @ '||l_timer);htp.nl;
1188:
1189: c_table_count := 2;
1190: end if;
1191:

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

1228: l_continue boolean;
1229:
1230: begin
1231:
1232: -- select HSECS into l_timer from v$timer;htp.p('begin displayPage @ '||l_timer);htp.nl;
1233:
1234: l_flow_appl_id := ak_query_pkg.g_regions_table(ak_query_pkg.g_regions_table.FIRST).flow_application_id;
1235: l_flow_code := ak_query_pkg.g_regions_table(ak_query_pkg.g_regions_table.FIRST).flow_code;
1236: l_page_appl_id := ak_query_pkg.g_regions_table(ak_query_pkg.g_regions_table.FIRST).page_application_id;

Line 1251: htp.htmlOpen;

1247: l_cookie := owa_cookie.get('onquery');
1248:
1249: if icx_on_utilities.g_on_parameters(22) = 'Y'
1250: then
1251: htp.htmlOpen;
1252: htp.headOpen;
1253: icx_util.copyright;
1254:
1255: htp.p('');
1263:
1264: htp.title(l_page_title);
1265: htp.headClose;

Line 1262: htp.p('');

1258:
1259: icx_admin_sig.help_win_script('OracleON.IC?X='||icx_call.encrypt2(l_flow_appl_id||'*'||l_flow_code||'*'||l_page_appl_id||'*'||l_page_code||'*'||'ICX_HLP_INQUIRIES'||'**]'),l_language_code);
1260:
1261: htp.p('// -->');
1262: htp.p('');
1263:
1264: htp.title(l_page_title);
1265: htp.headClose;
1266: else

Line 1264: htp.title(l_page_title);

1260:
1261: htp.p('// -->');
1262: htp.p('');
1263:
1264: htp.title(l_page_title);
1265: htp.headClose;
1266: else
1267: htp.p('');
1263:
1264: htp.title(l_page_title);
1265: htp.headClose;
1266: else
1267: htp.p('');

Line 1268: htp.p('');
1271: htp.p('');
1272: end if;

Line 1269: htp.p('function goto_button(X) {self.location=X; };');

1265: htp.headClose;
1266: else
1267: htp.p('');
1272: end if;
1273:

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

1266: else
1267: htp.p('');
1272: end if;
1273:
1274: 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)

Line 1271: htp.p('');

1267: htp.p('');
1272: end if;
1273:
1274: 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)
1275: ||'*'||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)

Line 1291: htp.p(''||l_page_title||' '||l_page_description);

1287: icx_admin_sig.toolbar(language_code => l_language_code);
1288: end if;
1289: end if;
1290:
1291: htp.p(''||l_page_title||' '||l_page_description);
1292: htp.nl;
1293:
1294: if ak_query_pkg.g_results_table.COUNT = 0
1295: then

Line 1292: htp.nl;

1288: end if;
1289: end if;
1290:
1291: htp.p(''||l_page_title||' '||l_page_description);
1292: htp.nl;
1293:
1294: if ak_query_pkg.g_results_table.COUNT = 0
1295: then
1296: htp.p('');

Line 1296: htp.p('');

1292: htp.nl;
1293:
1294: if ak_query_pkg.g_results_table.COUNT = 0
1295: then
1296: htp.p('');
1297: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
1298: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(0).name);
1299: l_message := fnd_message.get;
1300:

Line 1301: htp.strong(l_message);htp.nl;

1297: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
1298: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(0).name);
1299: l_message := fnd_message.get;
1300:
1301: htp.strong(l_message);htp.nl;
1302:
1303: else
1304: l_continue := TRUE;
1305:

Line 1357: htp.p(l_region_description);

1353: and REGION_CODE = ak_query_pkg.g_regions_table(r).region_code;
1354:
1355: if l_region_description is not null
1356: then
1357: htp.p(l_region_description);
1358: end if;
1359:
1360: htp.p('');
1361:

Line 1360: htp.p('');

1356: then
1357: htp.p(l_region_description);
1358: end if;
1359:
1360: htp.p('');
1361:
1362: if ak_query_pkg.g_regions_table(r).total_result_count = 0
1363: then
1364: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');

Line 1368: htp.strong(l_message);htp.nl;

1364: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
1365: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(r).name);
1366: l_message := fnd_message.get;
1367:
1368: htp.strong(l_message);htp.nl;
1369:
1370: elsif ak_query_pkg.g_regions_table(r).region_style = 'FORM'
1371: and ak_query_pkg.g_regions_table(r).total_result_count > 1
1372: then

Line 1376: htp.strong(l_message);

1372: then
1373: fnd_message.set_name('ICX','ICX_LIMIT_ROWS_ONE');
1374: l_message := fnd_message.get;
1375:
1376: htp.strong(l_message);
1377: l_continue := FALSE;
1378: else
1379: icx_on_utilities2.displayRegion(ak_query_pkg.g_regions_table(r).region_rec_id);
1380: end if; -- total_result_count = 0

Line 1392: htp.htmlClose;

1388:
1389: if icx_on_utilities.g_on_parameters(22) = 'Y'
1390: then
1391: icx_sig.footer;
1392: htp.htmlClose;
1393: end if;
1394:
1395: -- select HSECS into l_timer from v$timer;htp.p('end displayPage @ '||l_timer);htp.nl;
1396:

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

1391: icx_sig.footer;
1392: htp.htmlClose;
1393: end if;
1394:
1395: -- select HSECS into l_timer from v$timer;htp.p('end displayPage @ '||l_timer);htp.nl;
1396:
1397: end;
1398:
1399: function formatText(c_text in varchar2,

Line 1918: -- htp.p('DEBUG 1 = '||l_values(i));htp.nl;

1914: then
1915: for i in l_values.FIRST..l_values.LAST loop
1916: l_values(i) := replace(l_values(i),'*','@#$@');
1917: c_where := c_where||'*'||l_values(i);
1918: -- htp.p('DEBUG 1 = '||l_values(i));htp.nl;
1919: end loop;
1920: end if;
1921: c_where := c_where||'**]';
1922: -- htp.p('DEBUG 2 = '||c_where);htp.nl;

Line 1922: -- htp.p('DEBUG 2 = '||c_where);htp.nl;

1918: -- htp.p('DEBUG 1 = '||l_values(i));htp.nl;
1919: end loop;
1920: end if;
1921: c_where := c_where||'**]';
1922: -- htp.p('DEBUG 2 = '||c_where);htp.nl;
1923:
1924: return c_where;
1925:
1926: end;