274:
275: icx_util.getLookups('ICX_CONDITIONS',l_lookup_codes,l_lookup_meanings);
276:
277: c_count := 0;
278: c_attributes(0) := htf.formSelectOption(' ');
279: c_attributes(1) := '';
280: for i in 0..1 loop
281: for f in FindAttributes loop
282: c_count := c_count + 1;
313: else
314: c_attributes(i) := c_attributes(i)||'
316: end loop;
317: c_attributes(i) := c_attributes(i)||htf.formSelectClose;
318: end loop;
319:
320: c_condition(0) := htf.formSelectOption(' ');
321: c_condition(1) := '';
322: for x in 0..1 loop
323: for i in 1..to_number(l_lookup_codes(0)) loop
324: if x = 1 and l_data_type1 = 'V' and l_lookup_codes(i) = 'CCONTAIN'
330: else
331: c_condition(x) := c_condition(x)||'
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"');
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('
');
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('
');
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'
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;
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:
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));
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;
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'
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
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),
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: