DBA Data[Home] [Help]

APPS.ICX_REQ_SEARCH dependencies on HTP

Line 18: htp.p('function submitFunction() {

14: l_message := icx_util.replace_quotes(fnd_message.get);
15:
16: if p_lines_now = 1
17: then
18: htp.p('function submitFunction() {
19: if (document.findForm.i_1.value == "") {
20: if (confirm("'||l_message||'")) {
21: document.findForm.submit();
22: }

Line 28: htp.p('function submitFunction() {

24: document.findForm.submit();
25: }
26: }');
27: else
28: htp.p('function submitFunction() {
29: if (document.findForm.i_1.value == ""
30: '||'&'||'&'||' document.findForm.i_2.value == ""
31: '||'&'||'&'||' document.findForm.i_3.value == ""
32: '||'&'||'&'||' document.findForm.i_4.value == ""

Line 43: htp.p('function resetFunction() {

39: }
40: };');
41: end if;
42:
43: htp.p('function resetFunction() {
44: document.findForm.reset();
45: document.findForm.i_1.value = "";');
46: if p_lines_now > 1
47: then

Line 48: htp.p('document.findForm.i_2.value = "";

44: document.findForm.reset();
45: document.findForm.i_1.value = "";');
46: if p_lines_now > 1
47: then
48: htp.p('document.findForm.i_2.value = "";
49: document.findForm.i_3.value = "";
50: document.findForm.i_4.value = "";
51: document.findForm.i_5.value = "";');
52: end if;

Line 53: htp.p('};');

49: document.findForm.i_3.value = "";
50: document.findForm.i_4.value = "";
51: document.findForm.i_5.value = "";');
52: end if;
53: htp.p('};');
54:
55:
56: end;
57:

Line 105: htp.p('');

101: l_browser varchar2(400) := owa_util.get_cgi_env('HTTP_USER_AGENT');
102:
103: begin
104:
105: htp.p('');
106: icx_util.DynamicButton(P_ButtonText => p_submit,
107: P_ImageFileName => 'FNDBSBMT',
108: P_OnMouseOverText => p_submit,
109: P_HyperTextCall => 'javascript:submitFunction()',

Line 112: htp.p('');

108: P_OnMouseOverText => p_submit,
109: P_HyperTextCall => 'javascript:submitFunction()',
110: P_LanguageCode => p_language_code,
111: P_JavaScriptFlag => FALSE);
112: htp.p('');
113: if (instr(l_browser,'MSIE')=0)
114: then
115: htp.p('');
116: icx_util.DynamicButton(P_ButtonText => p_clear,

Line 115: htp.p('');

111: P_JavaScriptFlag => FALSE);
112: htp.p('');
113: if (instr(l_browser,'MSIE')=0)
114: then
115: htp.p('');
116: icx_util.DynamicButton(P_ButtonText => p_clear,
117: P_ImageFileName => 'FNDBCLR',
118: P_OnMouseOverText => p_clear,
119: P_HyperTextCall => 'javascript:resetFunction()',

Line 122: htp.p('');

118: P_OnMouseOverText => p_clear,
119: P_HyperTextCall => 'javascript:resetFunction()',
120: P_LanguageCode => p_language_code,
121: P_JavaScriptFlag => FALSE);
122: htp.p('');
123: end if;
124: if p_lines_next is not null
125: then
126: htp.p('');

Line 126: htp.p('');

122: htp.p('');
123: end if;
124: if p_lines_next is not null
125: then
126: htp.p('');
127: if p_lines_next > p_lines_now
128: then
129: icx_util.DynamicButton(P_ButtonText => p_more,
130: P_ImageFileName => 'FNDBMORC',

Line 143: htp.p('');

139: P_HyperTextCall => p_url,
140: P_LanguageCode => p_language_code,
141: P_JavaScriptFlag => FALSE);
142: end if;
143: htp.p('');
144: end if;
145:
146: exception
147: when others then

Line 148: htp.p(SQLERRM);

144: end if;
145:
146: exception
147: when others then
148: htp.p(SQLERRM);
149: end;
150:
151: -------------------------------------------------------------------
152: procedure findForm(p_region_appl_id in number,

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

309: end loop;
310:
311: if p_goto_url is null
312: then
313: htp.formOpen('OracleON.IC','POST','','','NAME="findForm"');
314: else
315: htp.formOpen(p_goto_url,'POST',p_goto_target,'','NAME="findForm"');
316: end if;
317:

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

311: if p_goto_url is null
312: then
313: htp.formOpen('OracleON.IC','POST','','','NAME="findForm"');
314: else
315: htp.formOpen(p_goto_url,'POST',p_goto_target,'','NAME="findForm"');
316: end if;
317:
318: if p_default_title = 'Y'
319: then

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

327: fnd_message.set_name('ICX','ICX_FIND_TEXT');
328: fnd_message.set_token('REGION_TOKEN',l_page_title);
329: l_message := fnd_message.get;
330:
331: htp.tableOpen('BORDER=0');
332: htp.tableRowOpen;
333:
334: htp.tableData(cvalue => ''||l_message||'', cattributes => 'VALIGN="MIDDLE"');
335:

Line 332: htp.tableRowOpen;

328: fnd_message.set_token('REGION_TOKEN',l_page_title);
329: l_message := fnd_message.get;
330:
331: htp.tableOpen('BORDER=0');
332: htp.tableRowOpen;
333:
334: htp.tableData(cvalue => ''||l_message||'', cattributes => 'VALIGN="MIDDLE"');
335:
336: if p_new_url is not null

Line 334: htp.tableData(cvalue => ''||l_message||'', cattributes => 'VALIGN="MIDDLE"');

330:
331: htp.tableOpen('BORDER=0');
332: htp.tableRowOpen;
333:
334: htp.tableData(cvalue => ''||l_message||'', cattributes => 'VALIGN="MIDDLE"');
335:
336: if p_new_url is not null
337: then
338: htp.p('');

Line 338: htp.p('');

334: htp.tableData(cvalue => ''||l_message||'', cattributes => 'VALIGN="MIDDLE"');
335:
336: if p_new_url is not null
337: then
338: htp.p('');
339: icx_util.DynamicButton(P_ButtonText => c_prompts(5),
340: P_ImageFileName => 'FNDBNEW',
341: P_OnMouseOverText => c_prompts(5),
342: P_HyperTextCall => p_new_url,

Line 345: htp.p('');

341: P_OnMouseOverText => c_prompts(5),
342: P_HyperTextCall => p_new_url,
343: P_LanguageCode => l_language_code,
344: P_JavaScriptFlag => FALSE);
345: htp.p('');
346: end if;
347:
348: htp.tableRowClose;
349: htp.tableClose;

Line 348: htp.tableRowClose;

344: P_JavaScriptFlag => FALSE);
345: htp.p('');
346: end if;
347:
348: htp.tableRowClose;
349: htp.tableClose;
350: htp.nl;
351:
352: end if; -- p_default_title = 'Y'

Line 349: htp.tableClose;

345: htp.p('');
346: end if;
347:
348: htp.tableRowClose;
349: htp.tableClose;
350: htp.nl;
351:
352: end if; -- p_default_title = 'Y'
353:

Line 350: htp.nl;

346: end if;
347:
348: htp.tableRowClose;
349: htp.tableClose;
350: htp.nl;
351:
352: end if; -- p_default_title = 'Y'
353:
354: if 175 = 178 then

Line 381: htp.p('Item Category is');

377: l_category_name := ak_query_pkg.g_items_table(i).value_id;
378: end if;
379: end loop;
380:
381: htp.p('Item Category is');
382: l_categories := htf.formSelectOpen('p_cat');
383: if l_parameters(16) is null then
384: l_categories := l_categories||'

Line 397: htp.p(l_categories);

393: l_categories := l_categories||'

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

399: end if; -- 175
400:
401: for i in 1..p_lines_now loop
402:
403: htp.tableOpen('BORDER=0');
404: htp.tableRowOpen;
405: htp.tableData(htf.formSelectOpen('a_'||i)||c_attributes(i));
406: htp.tableData(htf.formSelectOpen('c_'||i)||c_condition(i));
407: htp.tableData(htf.formText('i_'||i,20,80,c_input(i)));

Line 404: htp.tableRowOpen;

400:
401: for i in 1..p_lines_now loop
402:
403: htp.tableOpen('BORDER=0');
404: htp.tableRowOpen;
405: htp.tableData(htf.formSelectOpen('a_'||i)||c_attributes(i));
406: htp.tableData(htf.formSelectOpen('c_'||i)||c_condition(i));
407: htp.tableData(htf.formText('i_'||i,20,80,c_input(i)));
408: htp.tableRowClose;

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

401: for i in 1..p_lines_now loop
402:
403: htp.tableOpen('BORDER=0');
404: htp.tableRowOpen;
405: htp.tableData(htf.formSelectOpen('a_'||i)||c_attributes(i));
406: htp.tableData(htf.formSelectOpen('c_'||i)||c_condition(i));
407: htp.tableData(htf.formText('i_'||i,20,80,c_input(i)));
408: htp.tableRowClose;
409: htp.tableClose;

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

402:
403: htp.tableOpen('BORDER=0');
404: htp.tableRowOpen;
405: htp.tableData(htf.formSelectOpen('a_'||i)||c_attributes(i));
406: htp.tableData(htf.formSelectOpen('c_'||i)||c_condition(i));
407: htp.tableData(htf.formText('i_'||i,20,80,c_input(i)));
408: htp.tableRowClose;
409: htp.tableClose;
410:

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

403: htp.tableOpen('BORDER=0');
404: htp.tableRowOpen;
405: htp.tableData(htf.formSelectOpen('a_'||i)||c_attributes(i));
406: htp.tableData(htf.formSelectOpen('c_'||i)||c_condition(i));
407: htp.tableData(htf.formText('i_'||i,20,80,c_input(i)));
408: htp.tableRowClose;
409: htp.tableClose;
410:
411: end loop;

Line 408: htp.tableRowClose;

404: htp.tableRowOpen;
405: htp.tableData(htf.formSelectOpen('a_'||i)||c_attributes(i));
406: htp.tableData(htf.formSelectOpen('c_'||i)||c_condition(i));
407: htp.tableData(htf.formText('i_'||i,20,80,c_input(i)));
408: htp.tableRowClose;
409: htp.tableClose;
410:
411: end loop;
412:

Line 409: htp.tableClose;

405: htp.tableData(htf.formSelectOpen('a_'||i)||c_attributes(i));
406: htp.tableData(htf.formSelectOpen('c_'||i)||c_condition(i));
407: htp.tableData(htf.formText('i_'||i,20,80,c_input(i)));
408: htp.tableRowClose;
409: htp.tableClose;
410:
411: end loop;
412:
413: if p_hidden_name is not null

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

411: end loop;
412:
413: if p_hidden_name is not null
414: then
415: htp.formHidden(p_hidden_name,p_hidden_value);
416: end if;
417:
418: if p_LOV_mode = 'N'
419: then

Line 420: htp.nl;

416: end if;
417:
418: if p_LOV_mode = 'N'
419: then
420: htp.nl;
421: htp.tableOpen('BORDER=0');
422: htp.tableRowOpen;
423: findIcons(c_prompts(1),c_prompts(2),c_prompts(4),c_prompts(3),p_lines_next,p_lines_now,c_url,l_language_code);
424: htp.tableRowClose;

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

417:
418: if p_LOV_mode = 'N'
419: then
420: htp.nl;
421: htp.tableOpen('BORDER=0');
422: htp.tableRowOpen;
423: findIcons(c_prompts(1),c_prompts(2),c_prompts(4),c_prompts(3),p_lines_next,p_lines_now,c_url,l_language_code);
424: htp.tableRowClose;
425: htp.tableClose;

Line 422: htp.tableRowOpen;

418: if p_LOV_mode = 'N'
419: then
420: htp.nl;
421: htp.tableOpen('BORDER=0');
422: htp.tableRowOpen;
423: findIcons(c_prompts(1),c_prompts(2),c_prompts(4),c_prompts(3),p_lines_next,p_lines_now,c_url,l_language_code);
424: htp.tableRowClose;
425: htp.tableClose;
426: end if;

Line 424: htp.tableRowClose;

420: htp.nl;
421: htp.tableOpen('BORDER=0');
422: htp.tableRowOpen;
423: findIcons(c_prompts(1),c_prompts(2),c_prompts(4),c_prompts(3),p_lines_next,p_lines_now,c_url,l_language_code);
424: htp.tableRowClose;
425: htp.tableClose;
426: end if;
427:
428: htp.p('');

Line 425: htp.tableClose;

421: htp.tableOpen('BORDER=0');
422: htp.tableRowOpen;
423: findIcons(c_prompts(1),c_prompts(2),c_prompts(4),c_prompts(3),p_lines_next,p_lines_now,c_url,l_language_code);
424: htp.tableRowClose;
425: htp.tableClose;
426: end if;
427:
428: htp.p('');
429:

Line 428: htp.p('');

424: htp.tableRowClose;
425: htp.tableClose;
426: end if;
427:
428: htp.p('');
429:
430: exception
431: when others then
432: htp.p(SQLERRM);

Line 432: htp.p(SQLERRM);

428: htp.p('');
429:
430: exception
431: when others then
432: htp.p(SQLERRM);
433: end;
434:
435: -------------------------------------------------------------------
436: procedure itemsearch( n_org number) is

Line 454: htp.p('function openButWin(start_row, end_row, total_row, where, context) {

450:
451: -- We need to split into 2 frames
452:
453: js.scriptOpen;
454: htp.p('function openButWin(start_row, end_row, total_row, where, context) {
455:
456: var result = "' || v_dcdName ||
457: '/ICX_REQ_SEARCH.itemsearch_buttons?p_start_row=" + start_row + "&p_end_row=" + end_row + "&p_total_rows=" +
458: total_row + "&p_where=" + where + "&p_context=" + context;

Line 465: htp.p('');

461: ');
462:
463: js.scriptClose;
464:
465: htp.p('');
466: htp.p('

462:
463: js.scriptClose;
464:
465: htp.p('');
466: htp.p('');

Line 472: htp.p('');
471:
472: htp.p('');
474: htp.p('');
475:
476: exception

Line 474: htp.p('');

470: '" NAME="data" FRAMEBORDER=NO MARGINWIDTH=10 MARGINHEIGHT=0 NORESIZE>');
471:
472: htp.p('');
474: htp.p('');
475:
476: exception
477: when others then
478: htp.p(SQLERRM);

Line 478: htp.p(SQLERRM);

474: htp.p('');
475:
476: exception
477: when others then
478: htp.p(SQLERRM);
479:
480: end;
481:
482: -------------------------------------------------------------------

Line 498: htp.p('');

494:
495: SELECT QUERY_SET INTO c_query_size FROM ICX_PARAMETERS;
496:
497: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
498: htp.p('');
499:
500: htp.p('');
501: htp.p('
');
502:

Line 500: htp.p('');

496:
497: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
498: htp.p('');
499:
500: htp.p('

');
501: htp.p('
');
502:
503: if (p_context = 'N') then
504: icx_on_utilities2.displaySetIcons(p_language_code => v_lang,

Line 501: htp.p('
');

497: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
498: htp.p('');
499:
500: htp.p('');
501: htp.p('');
526: htp.p('');

521: p_row_count => p_total_rows);
522: end if;
523:
524: -- htp.p('Debug 0');
525: htp.p('');
526: htp.p('

');
526: htp.p('
');
502:
503: if (p_context = 'N') then
504: icx_on_utilities2.displaySetIcons(p_language_code => v_lang,
505: p_packproc => 'ICX_REQ_SEARCH.displayItem',

Line 524: -- htp.p('Debug 0');

520: p_target => 'parent.frames[0]',
521: p_row_count => p_total_rows);
522: end if;
523:
524: -- htp.p('Debug 0');
525: htp.p('

');
527: FND_MESSAGE.SET_NAME('ICX','ICX_ADD_TO_ORDER');
528: icx_util.DynamicButton(P_ButtonText => FND_MESSAGE.GET,

Line 525: htp.p('
');
527: FND_MESSAGE.SET_NAME('ICX','ICX_ADD_TO_ORDER');
528: icx_util.DynamicButton(P_ButtonText => FND_MESSAGE.GET,
529: P_ImageFileName => 'FNDBNEW.gif',

Line 526: htp.p('
');

522: end if;
523:
524: -- htp.p('Debug 0');
525: htp.p('

');
527: FND_MESSAGE.SET_NAME('ICX','ICX_ADD_TO_ORDER');
528: icx_util.DynamicButton(P_ButtonText => FND_MESSAGE.GET,
529: P_ImageFileName => 'FNDBNEW.gif',
530: P_OnMouseOverText => FND_MESSAGE.GET,

Line 535: htp.p('
');

531: P_HyperTextCall => 'javascript:parent.frames[0].submit()',
532: P_LanguageCode => v_lang,
533: P_JavaScriptFlag => FALSE);
534:
535: htp.p('

');
536: htp.p('');
537:
538: exception
539: when others then

Line 536: htp.p('');

532: P_LanguageCode => v_lang,
533: P_JavaScriptFlag => FALSE);
534:
535: htp.p('

');
536: htp.p('');
537:
538: exception
539: when others then
540: htp.p(SQLERRM);

Line 540: htp.p(SQLERRM);

536: htp.p('');
537:
538: exception
539: when others then
540: htp.p(SQLERRM);
541:
542:
543: end;
544:

Line 591: htp.htmlOpen;

587: v_lines_now := l_search(5); -- p_lines_next
588: v_lines_next := l_search(8); -- p_lines_now
589: l_paramX := l_search(10); -- p_hidden_value
590: end if;
591: htp.htmlOpen;
592: htp.headOpen;
593: icx_util.copyright;
594: js.scriptOpen;
595: find_form_head_region(v_lines_now);

Line 592: htp.headOpen;

588: v_lines_next := l_search(8); -- p_lines_now
589: l_paramX := l_search(10); -- p_hidden_value
590: end if;
591: htp.htmlOpen;
592: htp.headOpen;
593: icx_util.copyright;
594: js.scriptOpen;
595: find_form_head_region(v_lines_now);
596: js.scriptClose;

Line 597: htp.headClose;

593: icx_util.copyright;
594: js.scriptOpen;
595: find_form_head_region(v_lines_now);
596: js.scriptClose;
597: htp.headClose;
598: htp.bodyOpen('', 'BGCOLOR="#CCCCFF" onLoad="parent.parent.winOpen(''nav'', ''item_search''); open(''/OA_HTML/' || l_language || '/ICXBLUE.htm'', ''k_buttons'')"' );
599:
600: fnd_message.set_name('ICX','ICX_REQS_FIND');
601: htp.p(htf.bold(FND_MESSAGE.GET));

Line 598: htp.bodyOpen('', 'BGCOLOR="#CCCCFF" onLoad="parent.parent.winOpen(''nav'', ''item_search''); open(''/OA_HTML/' || l_language || '/ICXBLUE.htm'', ''k_buttons'')"' );

594: js.scriptOpen;
595: find_form_head_region(v_lines_now);
596: js.scriptClose;
597: htp.headClose;
598: htp.bodyOpen('', 'BGCOLOR="#CCCCFF" onLoad="parent.parent.winOpen(''nav'', ''item_search''); open(''/OA_HTML/' || l_language || '/ICXBLUE.htm'', ''k_buttons'')"' );
599:
600: fnd_message.set_name('ICX','ICX_REQS_FIND');
601: htp.p(htf.bold(FND_MESSAGE.GET));
602: icx_on_utilities.findForm(p_region_appl_id => 601,

Line 601: htp.p(htf.bold(FND_MESSAGE.GET));

597: htp.headClose;
598: htp.bodyOpen('', 'BGCOLOR="#CCCCFF" onLoad="parent.parent.winOpen(''nav'', ''item_search''); open(''/OA_HTML/' || l_language || '/ICXBLUE.htm'', ''k_buttons'')"' );
599:
600: fnd_message.set_name('ICX','ICX_REQS_FIND');
601: htp.p(htf.bold(FND_MESSAGE.GET));
602: icx_on_utilities.findForm(p_region_appl_id => 601,
603: p_region_code => 'ICX_PO_SUPPL_SEARCH_ITEMS_R',
604: p_goto_url => 'ICX_REQ_SEARCH.displayItem',
605: p_goto_target => 'data',

Line 614: htp.bodyClose;

610: p_hidden_name => 'p_values',
611: p_hidden_value => paramX,
612: p_default_title => 'N');
613: -- p_values => l_paramX );
614: htp.bodyClose;
615: htp.htmlClose;
616: end if;
617:
618: -- dbms_session.set_sql_trace(FALSE);

Line 615: htp.htmlClose;

611: p_hidden_value => paramX,
612: p_default_title => 'N');
613: -- p_values => l_paramX );
614: htp.bodyClose;
615: htp.htmlClose;
616: end if;
617:
618: -- dbms_session.set_sql_trace(FALSE);
619:

Line 623: htp.p('searchX = ' || searchX || '
');

619:
620:
621: exception
622: when OTHERS then
623: htp.p('searchX = ' || searchX || '
');
624: htp.p('paramX = ' || paramX || '
');
625: htp.p(SQLERRM);
626: end;
627:

Line 624: htp.p('paramX = ' || paramX || '
');

620:
621: exception
622: when OTHERS then
623: htp.p('searchX = ' || searchX || '
');
624: htp.p('paramX = ' || paramX || '
');
625: htp.p(SQLERRM);
626: end;
627:
628:

Line 625: htp.p(SQLERRM);

621: exception
622: when OTHERS then
623: htp.p('searchX = ' || searchX || '
');
624: htp.p('paramX = ' || paramX || '
');
625: htp.p(SQLERRM);
626: end;
627:
628:
629: -------------------------------------------------------------------

Line 750: htp.bodyOpen('', 'BGCOLOR="#CCCCFF" onLoad="parent.parent.winOpen(''nav'', ''item_search'')" target="data"' );

746: end if;
747:
748: ICX_REQ_SEARCH.itemsearch_display;
749:
750: htp.bodyOpen('', 'BGCOLOR="#CCCCFF" onLoad="parent.parent.winOpen(''nav'', ''item_search'')" target="data"' );
751: htp.br;
752: htp.p('

'|| l_message ||'

');
753: htp.bodyclose;
754: end;

Line 751: htp.br;

747:
748: ICX_REQ_SEARCH.itemsearch_display;
749:
750: htp.bodyOpen('', 'BGCOLOR="#CCCCFF" onLoad="parent.parent.winOpen(''nav'', ''item_search'')" target="data"' );
751: htp.br;
752: htp.p('

'|| l_message ||'

');
753: htp.bodyclose;
754: end;
755:

Line 752: htp.p('

'|| l_message ||'

');

748: ICX_REQ_SEARCH.itemsearch_display;
749:
750: htp.bodyOpen('', 'BGCOLOR="#CCCCFF" onLoad="parent.parent.winOpen(''nav'', ''item_search'')" target="data"' );
751: htp.br;
752: htp.p('

'|| l_message ||'

');
753: htp.bodyclose;
754: end;
755:
756: --------------------------------------------------------------

Line 753: htp.bodyclose;

749:
750: htp.bodyOpen('', 'BGCOLOR="#CCCCFF" onLoad="parent.parent.winOpen(''nav'', ''item_search'')" target="data"' );
751: htp.br;
752: htp.p('

'|| l_message ||'

');
753: htp.bodyclose;
754: end;
755:
756: --------------------------------------------------------------
757: procedure submit_items (cartId IN NUMBER,

Line 1155: htp.htmlOpen;

1151: v_lines_next := 1;
1152: end if;
1153:
1154:
1155: htp.htmlOpen;
1156: htp.headOpen;
1157: icx_util.copyright;
1158: js.scriptOpen;
1159: find_form_head_region(v_lines_now);

Line 1156: htp.headOpen;

1152: end if;
1153:
1154:
1155: htp.htmlOpen;
1156: htp.headOpen;
1157: icx_util.copyright;
1158: js.scriptOpen;
1159: find_form_head_region(v_lines_now);
1160:

Line 1229: htp.p( 'tr=' || total_rows);

1225: total_rows := ak_query_pkg.g_regions_table(g_reg_ind).total_result_count;
1226: if end_row > total_rows then
1227: end_row := total_rows;
1228: end if;
1229: htp.p( 'tr=' || total_rows);
1230:
1231: if ak_query_pkg.g_results_table.COUNT = 0 then
1232: js.scriptClose;
1233: htp.bodyOpen('', 'BGCOLOR="#CCCCFF" onLoad="parent.parent.winOpen(''nav'', ''item_search''); open(''/OA_HTML/'

Line 1233: htp.bodyOpen('', 'BGCOLOR="#CCCCFF" onLoad="parent.parent.winOpen(''nav'', ''item_search''); open(''/OA_HTML/'

1229: htp.p( 'tr=' || total_rows);
1230:
1231: if ak_query_pkg.g_results_table.COUNT = 0 then
1232: js.scriptClose;
1233: htp.bodyOpen('', 'BGCOLOR="#CCCCFF" onLoad="parent.parent.winOpen(''nav'', ''item_search''); open(''/OA_HTML/'
1234: || c_language || '/ICXBLUE.htm'', ''k_buttons'')" target="data"' );
1235:
1236: fnd_message.set_name('ICX','ICX_REQS_FIND');
1237: htp.p(htf.bold(FND_MESSAGE.GET));

Line 1237: htp.p(htf.bold(FND_MESSAGE.GET));

1233: htp.bodyOpen('', 'BGCOLOR="#CCCCFF" onLoad="parent.parent.winOpen(''nav'', ''item_search''); open(''/OA_HTML/'
1234: || c_language || '/ICXBLUE.htm'', ''k_buttons'')" target="data"' );
1235:
1236: fnd_message.set_name('ICX','ICX_REQS_FIND');
1237: htp.p(htf.bold(FND_MESSAGE.GET));
1238: -- htp.p('Debug findForm');
1239: icx_on_utilities.findForm(p_region_appl_id => 601,
1240: p_region_code => 'ICX_PO_SUPPL_SEARCH_ITEMS_R',
1241: p_goto_url => 'ICX_REQ_SEARCH.displayItem',

Line 1238: -- htp.p('Debug findForm');

1234: || c_language || '/ICXBLUE.htm'', ''k_buttons'')" target="data"' );
1235:
1236: fnd_message.set_name('ICX','ICX_REQS_FIND');
1237: htp.p(htf.bold(FND_MESSAGE.GET));
1238: -- htp.p('Debug findForm');
1239: icx_on_utilities.findForm(p_region_appl_id => 601,
1240: p_region_code => 'ICX_PO_SUPPL_SEARCH_ITEMS_R',
1241: p_goto_url => 'ICX_REQ_SEARCH.displayItem',
1242: p_goto_target => 'data',

Line 1251: htp.br;

1247: p_hidden_name => 'p_values',
1248: p_hidden_value => parameters_pass,
1249: p_default_title => 'N');
1250: -- p_values => parameters_pass);
1251: htp.br;
1252: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
1253: fnd_message.set_token('NAME_OF_REGION_TOKEN',c_title);
1254: htp.p('

'||fnd_message.get||'

');
1255: --parent.frames[1].src = ''/OA_HTML/'

Line 1254: htp.p('

'||fnd_message.get||'

');

1250: -- p_values => parameters_pass);
1251: htp.br;
1252: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
1253: fnd_message.set_token('NAME_OF_REGION_TOKEN',c_title);
1254: htp.p('

'||fnd_message.get||'

');
1255: --parent.frames[1].src = ''/OA_HTML/'
1256: -- || c_language || '/ICXBLUE.htm'' htp.bodyclose;
1257: return;
1258: end if;

Line 1256: -- || c_language || '/ICXBLUE.htm'' htp.bodyclose;

1252: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
1253: fnd_message.set_token('NAME_OF_REGION_TOKEN',c_title);
1254: htp.p('

'||fnd_message.get||'

');
1255: --parent.frames[1].src = ''/OA_HTML/'
1256: -- || c_language || '/ICXBLUE.htm'' htp.bodyclose;
1257: return;
1258: end if;
1259:
1260: icx_admin_sig.help_win_script;

Line 1261: htp.p('function submit() {

1257: return;
1258: end if;
1259:
1260: icx_admin_sig.help_win_script;
1261: htp.p('function submit() {
1262: open("/OA_HTML/' || c_language ||
1263: '/ICXBLUE.htm", "k_buttons");
1264: document.catalog_items.cartId.value = parent.parent.cartId;
1265: document.catalog_items.p_emergency.value = parent.parent.emergency;

Line 1269: htp.p ('function get_parent_values(cartid,emerg) {

1265: document.catalog_items.p_emergency.value = parent.parent.emergency;
1266: document.catalog_items.submit();
1267: }');
1268:
1269: htp.p ('function get_parent_values(cartid,emerg) {
1270: cartid.value=parent.parent.cartId;
1271: emerg.value=parent.parent.emergency;
1272: }');
1273:

Line 1275: htp.p('function item_rows(start_num, end_num, param_id) {

1271: emerg.value=parent.parent.emergency;
1272: }');
1273:
1274:
1275: htp.p('function item_rows(start_num, end_num, param_id) {
1276: document.DISPLAY_ITEM.start_row.value = start_num
1277: document.DISPLAY_ITEM.c_end_row.value = end_num
1278: document.DISPLAY_ITEM.parameters_id.value = param_id
1279: document.DISPLAY_ITEM.submit()

Line 1289: htp.headClose;

1285: counter := 1;
1286:
1287:
1288: js.scriptClose;
1289: htp.headClose;
1290:
1291: htp.bodyOpen('', 'BGCOLOR="#CCCCFF" onLoad="parent.parent.winOpen(''nav'', ''item_search'');parent.openButWin(' || p_start_row || ',' ||
1292: end_row || ',' || total_rows || ',' || parameters_pass || ',''' || v_use_context_search || ''')"');
1293:

Line 1291: htp.bodyOpen('', 'BGCOLOR="#CCCCFF" onLoad="parent.parent.winOpen(''nav'', ''item_search'');parent.openButWin(' || p_start_row || ',' ||

1287:
1288: js.scriptClose;
1289: htp.headClose;
1290:
1291: htp.bodyOpen('', 'BGCOLOR="#CCCCFF" onLoad="parent.parent.winOpen(''nav'', ''item_search'');parent.openButWin(' || p_start_row || ',' ||
1292: end_row || ',' || total_rows || ',' || parameters_pass || ',''' || v_use_context_search || ''')"');
1293:
1294: fnd_message.set_name('ICX','ICX_REQS_FIND');
1295: htp.p(htf.bold(FND_MESSAGE.GET));

Line 1295: htp.p(htf.bold(FND_MESSAGE.GET));

1291: htp.bodyOpen('', 'BGCOLOR="#CCCCFF" onLoad="parent.parent.winOpen(''nav'', ''item_search'');parent.openButWin(' || p_start_row || ',' ||
1292: end_row || ',' || total_rows || ',' || parameters_pass || ',''' || v_use_context_search || ''')"');
1293:
1294: fnd_message.set_name('ICX','ICX_REQS_FIND');
1295: htp.p(htf.bold(FND_MESSAGE.GET));
1296:
1297: icx_on_utilities.findForm(p_region_appl_id => 601,
1298: p_region_code => 'ICX_PO_SUPPL_SEARCH_ITEMS_R',
1299: p_goto_url => 'ICX_REQ_SEARCH.displayItem',

Line 1309: htp.br;

1305: p_hidden_name => 'p_values',
1306: p_hidden_value => parameters_pass,
1307: p_default_title => 'N');
1308: -- p_values => parameters_pass);
1309: htp.br;
1310: v_qty_flag := true;
1311:
1312: -- counter := 0;
1313: counter := 1;

Line 1315: htp.p('
');

1311:
1312: -- counter := 0;
1313: counter := 1;
1314:
1315: htp.p('');
1316:
1317: htp.formHidden('cartId','');
1318: htp.formHidden('p_emergency','');
1319: js.scriptOpen;

Line 1317: htp.formHidden('cartId','');

1313: counter := 1;
1314:
1315: htp.p('');
1316:
1317: htp.formHidden('cartId','');
1318: htp.formHidden('p_emergency','');
1319: js.scriptOpen;
1320: htp.p('get_parent_values(document.catalog_items.cartId,document.catalog_items.p_emergency)');
1321: js.scriptClose;

Line 1318: htp.formHidden('p_emergency','');

1314:
1315: htp.p('');
1316:
1317: htp.formHidden('cartId','');
1318: htp.formHidden('p_emergency','');
1319: js.scriptOpen;
1320: htp.p('get_parent_values(document.catalog_items.cartId,document.catalog_items.p_emergency)');
1321: js.scriptClose;
1322:

Line 1320: htp.p('get_parent_values(document.catalog_items.cartId,document.catalog_items.p_emergency)');

1316:
1317: htp.formHidden('cartId','');
1318: htp.formHidden('p_emergency','');
1319: js.scriptOpen;
1320: htp.p('get_parent_values(document.catalog_items.cartId,document.catalog_items.p_emergency)');
1321: js.scriptClose;
1322:
1323: htp.formHidden('a_1',a_1, 'cols="60" rows="10"');
1324: htp.formHidden('c_1',c_1, 'cols="60" rows="10"');

Line 1323: htp.formHidden('a_1',a_1, 'cols="60" rows="10"');

1319: js.scriptOpen;
1320: htp.p('get_parent_values(document.catalog_items.cartId,document.catalog_items.p_emergency)');
1321: js.scriptClose;
1322:
1323: htp.formHidden('a_1',a_1, 'cols="60" rows="10"');
1324: htp.formHidden('c_1',c_1, 'cols="60" rows="10"');
1325: htp.formHidden('i_1',i_1, 'cols="60" rows="10"');
1326: htp.formHidden('a_2',a_2, 'cols="60" rows="10"');
1327: htp.formHidden('c_2',c_2, 'cols="60" rows="10"');

Line 1324: htp.formHidden('c_1',c_1, 'cols="60" rows="10"');

1320: htp.p('get_parent_values(document.catalog_items.cartId,document.catalog_items.p_emergency)');
1321: js.scriptClose;
1322:
1323: htp.formHidden('a_1',a_1, 'cols="60" rows="10"');
1324: htp.formHidden('c_1',c_1, 'cols="60" rows="10"');
1325: htp.formHidden('i_1',i_1, 'cols="60" rows="10"');
1326: htp.formHidden('a_2',a_2, 'cols="60" rows="10"');
1327: htp.formHidden('c_2',c_2, 'cols="60" rows="10"');
1328: htp.formHidden('i_2',i_2, 'cols="60" rows="10"');

Line 1325: htp.formHidden('i_1',i_1, 'cols="60" rows="10"');

1321: js.scriptClose;
1322:
1323: htp.formHidden('a_1',a_1, 'cols="60" rows="10"');
1324: htp.formHidden('c_1',c_1, 'cols="60" rows="10"');
1325: htp.formHidden('i_1',i_1, 'cols="60" rows="10"');
1326: htp.formHidden('a_2',a_2, 'cols="60" rows="10"');
1327: htp.formHidden('c_2',c_2, 'cols="60" rows="10"');
1328: htp.formHidden('i_2',i_2, 'cols="60" rows="10"');
1329: htp.formHidden('a_3',a_3, 'cols="60" rows="10"');

Line 1326: htp.formHidden('a_2',a_2, 'cols="60" rows="10"');

1322:
1323: htp.formHidden('a_1',a_1, 'cols="60" rows="10"');
1324: htp.formHidden('c_1',c_1, 'cols="60" rows="10"');
1325: htp.formHidden('i_1',i_1, 'cols="60" rows="10"');
1326: htp.formHidden('a_2',a_2, 'cols="60" rows="10"');
1327: htp.formHidden('c_2',c_2, 'cols="60" rows="10"');
1328: htp.formHidden('i_2',i_2, 'cols="60" rows="10"');
1329: htp.formHidden('a_3',a_3, 'cols="60" rows="10"');
1330: htp.formHidden('c_3',c_3, 'cols="60" rows="10"');

Line 1327: htp.formHidden('c_2',c_2, 'cols="60" rows="10"');

1323: htp.formHidden('a_1',a_1, 'cols="60" rows="10"');
1324: htp.formHidden('c_1',c_1, 'cols="60" rows="10"');
1325: htp.formHidden('i_1',i_1, 'cols="60" rows="10"');
1326: htp.formHidden('a_2',a_2, 'cols="60" rows="10"');
1327: htp.formHidden('c_2',c_2, 'cols="60" rows="10"');
1328: htp.formHidden('i_2',i_2, 'cols="60" rows="10"');
1329: htp.formHidden('a_3',a_3, 'cols="60" rows="10"');
1330: htp.formHidden('c_3',c_3, 'cols="60" rows="10"');
1331: htp.formHidden('i_3',i_3, 'cols="60" rows="10"');

Line 1328: htp.formHidden('i_2',i_2, 'cols="60" rows="10"');

1324: htp.formHidden('c_1',c_1, 'cols="60" rows="10"');
1325: htp.formHidden('i_1',i_1, 'cols="60" rows="10"');
1326: htp.formHidden('a_2',a_2, 'cols="60" rows="10"');
1327: htp.formHidden('c_2',c_2, 'cols="60" rows="10"');
1328: htp.formHidden('i_2',i_2, 'cols="60" rows="10"');
1329: htp.formHidden('a_3',a_3, 'cols="60" rows="10"');
1330: htp.formHidden('c_3',c_3, 'cols="60" rows="10"');
1331: htp.formHidden('i_3',i_3, 'cols="60" rows="10"');
1332: htp.formHidden('a_4',a_4, 'cols="60" rows="10"');

Line 1329: htp.formHidden('a_3',a_3, 'cols="60" rows="10"');

1325: htp.formHidden('i_1',i_1, 'cols="60" rows="10"');
1326: htp.formHidden('a_2',a_2, 'cols="60" rows="10"');
1327: htp.formHidden('c_2',c_2, 'cols="60" rows="10"');
1328: htp.formHidden('i_2',i_2, 'cols="60" rows="10"');
1329: htp.formHidden('a_3',a_3, 'cols="60" rows="10"');
1330: htp.formHidden('c_3',c_3, 'cols="60" rows="10"');
1331: htp.formHidden('i_3',i_3, 'cols="60" rows="10"');
1332: htp.formHidden('a_4',a_4, 'cols="60" rows="10"');
1333: htp.formHidden('c_4',c_4, 'cols="60" rows="10"');

Line 1330: htp.formHidden('c_3',c_3, 'cols="60" rows="10"');

1326: htp.formHidden('a_2',a_2, 'cols="60" rows="10"');
1327: htp.formHidden('c_2',c_2, 'cols="60" rows="10"');
1328: htp.formHidden('i_2',i_2, 'cols="60" rows="10"');
1329: htp.formHidden('a_3',a_3, 'cols="60" rows="10"');
1330: htp.formHidden('c_3',c_3, 'cols="60" rows="10"');
1331: htp.formHidden('i_3',i_3, 'cols="60" rows="10"');
1332: htp.formHidden('a_4',a_4, 'cols="60" rows="10"');
1333: htp.formHidden('c_4',c_4, 'cols="60" rows="10"');
1334: htp.formHidden('i_4',i_4, 'cols="60" rows="10"');

Line 1331: htp.formHidden('i_3',i_3, 'cols="60" rows="10"');

1327: htp.formHidden('c_2',c_2, 'cols="60" rows="10"');
1328: htp.formHidden('i_2',i_2, 'cols="60" rows="10"');
1329: htp.formHidden('a_3',a_3, 'cols="60" rows="10"');
1330: htp.formHidden('c_3',c_3, 'cols="60" rows="10"');
1331: htp.formHidden('i_3',i_3, 'cols="60" rows="10"');
1332: htp.formHidden('a_4',a_4, 'cols="60" rows="10"');
1333: htp.formHidden('c_4',c_4, 'cols="60" rows="10"');
1334: htp.formHidden('i_4',i_4, 'cols="60" rows="10"');
1335: htp.formHidden('a_5',a_5, 'cols="60" rows="10"');

Line 1332: htp.formHidden('a_4',a_4, 'cols="60" rows="10"');

1328: htp.formHidden('i_2',i_2, 'cols="60" rows="10"');
1329: htp.formHidden('a_3',a_3, 'cols="60" rows="10"');
1330: htp.formHidden('c_3',c_3, 'cols="60" rows="10"');
1331: htp.formHidden('i_3',i_3, 'cols="60" rows="10"');
1332: htp.formHidden('a_4',a_4, 'cols="60" rows="10"');
1333: htp.formHidden('c_4',c_4, 'cols="60" rows="10"');
1334: htp.formHidden('i_4',i_4, 'cols="60" rows="10"');
1335: htp.formHidden('a_5',a_5, 'cols="60" rows="10"');
1336: htp.formHidden('c_5',c_5, 'cols="60" rows="10"');

Line 1333: htp.formHidden('c_4',c_4, 'cols="60" rows="10"');

1329: htp.formHidden('a_3',a_3, 'cols="60" rows="10"');
1330: htp.formHidden('c_3',c_3, 'cols="60" rows="10"');
1331: htp.formHidden('i_3',i_3, 'cols="60" rows="10"');
1332: htp.formHidden('a_4',a_4, 'cols="60" rows="10"');
1333: htp.formHidden('c_4',c_4, 'cols="60" rows="10"');
1334: htp.formHidden('i_4',i_4, 'cols="60" rows="10"');
1335: htp.formHidden('a_5',a_5, 'cols="60" rows="10"');
1336: htp.formHidden('c_5',c_5, 'cols="60" rows="10"');
1337: htp.formHidden('i_5',i_5, 'cols="60" rows="10"');

Line 1334: htp.formHidden('i_4',i_4, 'cols="60" rows="10"');

1330: htp.formHidden('c_3',c_3, 'cols="60" rows="10"');
1331: htp.formHidden('i_3',i_3, 'cols="60" rows="10"');
1332: htp.formHidden('a_4',a_4, 'cols="60" rows="10"');
1333: htp.formHidden('c_4',c_4, 'cols="60" rows="10"');
1334: htp.formHidden('i_4',i_4, 'cols="60" rows="10"');
1335: htp.formHidden('a_5',a_5, 'cols="60" rows="10"');
1336: htp.formHidden('c_5',c_5, 'cols="60" rows="10"');
1337: htp.formHidden('i_5',i_5, 'cols="60" rows="10"');
1338: htp.formHidden('p_start_row',p_start_row,'cols="60" rows = "10"');

Line 1335: htp.formHidden('a_5',a_5, 'cols="60" rows="10"');

1331: htp.formHidden('i_3',i_3, 'cols="60" rows="10"');
1332: htp.formHidden('a_4',a_4, 'cols="60" rows="10"');
1333: htp.formHidden('c_4',c_4, 'cols="60" rows="10"');
1334: htp.formHidden('i_4',i_4, 'cols="60" rows="10"');
1335: htp.formHidden('a_5',a_5, 'cols="60" rows="10"');
1336: htp.formHidden('c_5',c_5, 'cols="60" rows="10"');
1337: htp.formHidden('i_5',i_5, 'cols="60" rows="10"');
1338: htp.formHidden('p_start_row',p_start_row,'cols="60" rows = "10"');
1339: htp.formHidden('p_end_row',p_end_row,'cols="60" rows ="10"');

Line 1336: htp.formHidden('c_5',c_5, 'cols="60" rows="10"');

1332: htp.formHidden('a_4',a_4, 'cols="60" rows="10"');
1333: htp.formHidden('c_4',c_4, 'cols="60" rows="10"');
1334: htp.formHidden('i_4',i_4, 'cols="60" rows="10"');
1335: htp.formHidden('a_5',a_5, 'cols="60" rows="10"');
1336: htp.formHidden('c_5',c_5, 'cols="60" rows="10"');
1337: htp.formHidden('i_5',i_5, 'cols="60" rows="10"');
1338: htp.formHidden('p_start_row',p_start_row,'cols="60" rows = "10"');
1339: htp.formHidden('p_end_row',p_end_row,'cols="60" rows ="10"');
1340: htp.formHidden('p_where',p_where,'cols="60" rows = "10"');

Line 1337: htp.formHidden('i_5',i_5, 'cols="60" rows="10"');

1333: htp.formHidden('c_4',c_4, 'cols="60" rows="10"');
1334: htp.formHidden('i_4',i_4, 'cols="60" rows="10"');
1335: htp.formHidden('a_5',a_5, 'cols="60" rows="10"');
1336: htp.formHidden('c_5',c_5, 'cols="60" rows="10"');
1337: htp.formHidden('i_5',i_5, 'cols="60" rows="10"');
1338: htp.formHidden('p_start_row',p_start_row,'cols="60" rows = "10"');
1339: htp.formHidden('p_end_row',p_end_row,'cols="60" rows ="10"');
1340: htp.formHidden('p_where',p_where,'cols="60" rows = "10"');
1341: htp.formHidden('end_row',end_row,'cols="60" rows ="10"');

Line 1338: htp.formHidden('p_start_row',p_start_row,'cols="60" rows = "10"');

1334: htp.formHidden('i_4',i_4, 'cols="60" rows="10"');
1335: htp.formHidden('a_5',a_5, 'cols="60" rows="10"');
1336: htp.formHidden('c_5',c_5, 'cols="60" rows="10"');
1337: htp.formHidden('i_5',i_5, 'cols="60" rows="10"');
1338: htp.formHidden('p_start_row',p_start_row,'cols="60" rows = "10"');
1339: htp.formHidden('p_end_row',p_end_row,'cols="60" rows ="10"');
1340: htp.formHidden('p_where',p_where,'cols="60" rows = "10"');
1341: htp.formHidden('end_row',end_row,'cols="60" rows ="10"');
1342: htp.formHidden('p_query_set',c_query_size,'cols="60" rows = "10"');

Line 1339: htp.formHidden('p_end_row',p_end_row,'cols="60" rows ="10"');

1335: htp.formHidden('a_5',a_5, 'cols="60" rows="10"');
1336: htp.formHidden('c_5',c_5, 'cols="60" rows="10"');
1337: htp.formHidden('i_5',i_5, 'cols="60" rows="10"');
1338: htp.formHidden('p_start_row',p_start_row,'cols="60" rows = "10"');
1339: htp.formHidden('p_end_row',p_end_row,'cols="60" rows ="10"');
1340: htp.formHidden('p_where',p_where,'cols="60" rows = "10"');
1341: htp.formHidden('end_row',end_row,'cols="60" rows ="10"');
1342: htp.formHidden('p_query_set',c_query_size,'cols="60" rows = "10"');
1343: htp.formHidden('p_row_count',total_rows,'cols="60" rows="10"');

Line 1340: htp.formHidden('p_where',p_where,'cols="60" rows = "10"');

1336: htp.formHidden('c_5',c_5, 'cols="60" rows="10"');
1337: htp.formHidden('i_5',i_5, 'cols="60" rows="10"');
1338: htp.formHidden('p_start_row',p_start_row,'cols="60" rows = "10"');
1339: htp.formHidden('p_end_row',p_end_row,'cols="60" rows ="10"');
1340: htp.formHidden('p_where',p_where,'cols="60" rows = "10"');
1341: htp.formHidden('end_row',end_row,'cols="60" rows ="10"');
1342: htp.formHidden('p_query_set',c_query_size,'cols="60" rows = "10"');
1343: htp.formHidden('p_row_count',total_rows,'cols="60" rows="10"');
1344:

Line 1341: htp.formHidden('end_row',end_row,'cols="60" rows ="10"');

1337: htp.formHidden('i_5',i_5, 'cols="60" rows="10"');
1338: htp.formHidden('p_start_row',p_start_row,'cols="60" rows = "10"');
1339: htp.formHidden('p_end_row',p_end_row,'cols="60" rows ="10"');
1340: htp.formHidden('p_where',p_where,'cols="60" rows = "10"');
1341: htp.formHidden('end_row',end_row,'cols="60" rows ="10"');
1342: htp.formHidden('p_query_set',c_query_size,'cols="60" rows = "10"');
1343: htp.formHidden('p_row_count',total_rows,'cols="60" rows="10"');
1344:
1345: if (v_use_context_search = 'N') then

Line 1342: htp.formHidden('p_query_set',c_query_size,'cols="60" rows = "10"');

1338: htp.formHidden('p_start_row',p_start_row,'cols="60" rows = "10"');
1339: htp.formHidden('p_end_row',p_end_row,'cols="60" rows ="10"');
1340: htp.formHidden('p_where',p_where,'cols="60" rows = "10"');
1341: htp.formHidden('end_row',end_row,'cols="60" rows ="10"');
1342: htp.formHidden('p_query_set',c_query_size,'cols="60" rows = "10"');
1343: htp.formHidden('p_row_count',total_rows,'cols="60" rows="10"');
1344:
1345: if (v_use_context_search = 'N') then
1346: htp.formHidden('p_hidden', 'N', 'cols="60" rows="10"');

Line 1343: htp.formHidden('p_row_count',total_rows,'cols="60" rows="10"');

1339: htp.formHidden('p_end_row',p_end_row,'cols="60" rows ="10"');
1340: htp.formHidden('p_where',p_where,'cols="60" rows = "10"');
1341: htp.formHidden('end_row',end_row,'cols="60" rows ="10"');
1342: htp.formHidden('p_query_set',c_query_size,'cols="60" rows = "10"');
1343: htp.formHidden('p_row_count',total_rows,'cols="60" rows="10"');
1344:
1345: if (v_use_context_search = 'N') then
1346: htp.formHidden('p_hidden', 'N', 'cols="60" rows="10"');
1347: else

Line 1346: htp.formHidden('p_hidden', 'N', 'cols="60" rows="10"');

1342: htp.formHidden('p_query_set',c_query_size,'cols="60" rows = "10"');
1343: htp.formHidden('p_row_count',total_rows,'cols="60" rows="10"');
1344:
1345: if (v_use_context_search = 'N') then
1346: htp.formHidden('p_hidden', 'N', 'cols="60" rows="10"');
1347: else
1348: htp.formHidden('p_hidden', null, 'cols="60" rows="10"');
1349: end if;
1350:

Line 1348: htp.formHidden('p_hidden', null, 'cols="60" rows="10"');

1344:
1345: if (v_use_context_search = 'N') then
1346: htp.formHidden('p_hidden', 'N', 'cols="60" rows="10"');
1347: else
1348: htp.formHidden('p_hidden', null, 'cols="60" rows="10"');
1349: end if;
1350:
1351: l_pos := l_pos + 24;
1352:

Line 1353: htp.tableOpen('BORDER');

1349: end if;
1350:
1351: l_pos := l_pos + 24;
1352:
1353: htp.tableOpen('BORDER');
1354: htp.p('');
1355:
1356: --Print the column headings
1357: for i in ak_query_pkg.g_items_table.FIRST .. ak_query_pkg.g_items_table.LAST loop

Line 1354: htp.p('');

1350:
1351: l_pos := l_pos + 24;
1352:
1353: htp.tableOpen('BORDER');
1354: htp.p('');
1355:
1356: --Print the column headings
1357: for i in ak_query_pkg.g_items_table.FIRST .. ak_query_pkg.g_items_table.LAST loop
1358:

Line 1366: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'CENTER','','','','2');

1362: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' then
1363:
1364: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' then
1365: --print quantity heading WITH COLSPAN=2
1366: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'CENTER','','','','2');
1367: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' then
1368: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long || ' (' || c_currency || ')',
1369: 'CENTER','','','','width=80');
1370: else

Line 1368: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long || ' (' || c_currency || ')',

1364: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' then
1365: --print quantity heading WITH COLSPAN=2
1366: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'CENTER','','','','2');
1367: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' then
1368: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long || ' (' || c_currency || ')',
1369: 'CENTER','','','','width=80');
1370: else
1371: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'CENTER');
1372: end if;

Line 1371: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'CENTER');

1367: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' then
1368: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long || ' (' || c_currency || ')',
1369: 'CENTER','','','','width=80');
1370: else
1371: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'CENTER');
1372: end if;
1373: end if;
1374:
1375: -- find line id, urls value id

Line 1396: htp.tableData('');

1392: end if;
1393:
1394: end loop;
1395:
1396: htp.tableData('');
1397: htp.tableRowClose;
1398:
1399: -- for j in p_start_row-1 .. end_row-1 loop
1400: for j in ak_query_pkg.g_results_table.FIRST .. ak_query_pkg.g_results_table.LAST loop

Line 1397: htp.tableRowClose;

1393:
1394: end loop;
1395:
1396: htp.tableData('');
1397: htp.tableRowClose;
1398:
1399: -- for j in p_start_row-1 .. end_row-1 loop
1400: for j in ak_query_pkg.g_results_table.FIRST .. ak_query_pkg.g_results_table.LAST loop
1401:

Line 1506: htp.p(temp_table(0));

1502:
1503: display_text := display_text || htf.tableRowClose;
1504: temp_table(0) := temp_table(0) || display_text;
1505: end if;
1506: htp.p(temp_table(0));
1507: counter := counter + 1;
1508: end loop; -- for j in p_start_row-1 .. end_row-1 loop
1509:
1510:

Line 1511: htp.tableClose;

1507: counter := counter + 1;
1508: end loop; -- for j in p_start_row-1 .. end_row-1 loop
1509:
1510:
1511: htp.tableClose;
1512: htp.p('');
1513:
1514: htp.formOpen('ICX_REQ_SEARCH.displayItem','POST','','','NAME="DISPLAY_ITEM"');
1515: htp.formHidden('start_row',p_start_row);

Line 1512: htp.p('');

1508: end loop; -- for j in p_start_row-1 .. end_row-1 loop
1509:
1510:
1511: htp.tableClose;
1512: htp.p('');
1513:
1514: htp.formOpen('ICX_REQ_SEARCH.displayItem','POST','','','NAME="DISPLAY_ITEM"');
1515: htp.formHidden('start_row',p_start_row);
1516: htp.formHidden('c_end_row',p_end_row);

Line 1514: htp.formOpen('ICX_REQ_SEARCH.displayItem','POST','','','NAME="DISPLAY_ITEM"');

1510:
1511: htp.tableClose;
1512: htp.p('');
1513:
1514: htp.formOpen('ICX_REQ_SEARCH.displayItem','POST','','','NAME="DISPLAY_ITEM"');
1515: htp.formHidden('start_row',p_start_row);
1516: htp.formHidden('c_end_row',p_end_row);
1517: htp.formHidden('parameters_id',parameters_pass);
1518: htp.formClose;

Line 1515: htp.formHidden('start_row',p_start_row);

1511: htp.tableClose;
1512: htp.p('');
1513:
1514: htp.formOpen('ICX_REQ_SEARCH.displayItem','POST','','','NAME="DISPLAY_ITEM"');
1515: htp.formHidden('start_row',p_start_row);
1516: htp.formHidden('c_end_row',p_end_row);
1517: htp.formHidden('parameters_id',parameters_pass);
1518: htp.formClose;
1519:

Line 1516: htp.formHidden('c_end_row',p_end_row);

1512: htp.p('');
1513:
1514: htp.formOpen('ICX_REQ_SEARCH.displayItem','POST','','','NAME="DISPLAY_ITEM"');
1515: htp.formHidden('start_row',p_start_row);
1516: htp.formHidden('c_end_row',p_end_row);
1517: htp.formHidden('parameters_id',parameters_pass);
1518: htp.formClose;
1519:
1520: icx_admin_sig.footer;

Line 1517: htp.formHidden('parameters_id',parameters_pass);

1513:
1514: htp.formOpen('ICX_REQ_SEARCH.displayItem','POST','','','NAME="DISPLAY_ITEM"');
1515: htp.formHidden('start_row',p_start_row);
1516: htp.formHidden('c_end_row',p_end_row);
1517: htp.formHidden('parameters_id',parameters_pass);
1518: htp.formClose;
1519:
1520: icx_admin_sig.footer;
1521:

Line 1518: htp.formClose;

1514: htp.formOpen('ICX_REQ_SEARCH.displayItem','POST','','','NAME="DISPLAY_ITEM"');
1515: htp.formHidden('start_row',p_start_row);
1516: htp.formHidden('c_end_row',p_end_row);
1517: htp.formHidden('parameters_id',parameters_pass);
1518: htp.formClose;
1519:
1520: icx_admin_sig.footer;
1521:
1522: end if;

Line 1527: htp.p('In display item');

1523:
1524: -- dbms_session.set_sql_trace(FALSE);
1525: exception
1526: when others then
1527: htp.p('In display item');
1528:
1529: htp.p(SQLERRM);
1530:
1531: end displayItem;

Line 1529: htp.p(SQLERRM);

1525: exception
1526: when others then
1527: htp.p('In display item');
1528:
1529: htp.p(SQLERRM);
1530:
1531: end displayItem;
1532:
1533: