DBA Data[Home] [Help]

APPS.WF_LOV dependencies on HTP

Line 33: htp.p('');

Line 143: htp.p(' ');

139: htp.p('// end of modal lov code');
140:
141: IF (p_jscript_tag = 'Y') THEN
142:
143: htp.p(' ');
144: htp.p('');
145: END IF;
146:
147: exception

Line 144: htp.p('');

140:
141: IF (p_jscript_tag = 'Y') THEN
142:
143: htp.p(' ');
144: htp.p('');
145: END IF;
146:
147: exception
148: when others then

Line 222: htp.p('');

218: icon_name in varchar2,
219: show_text in varchar2) is
220: begin
221:
222: htp.p('

');
223:
224: htp.p(''||

Line 224: htp.p('
'||
238: '');
240:
241: htp.p('
225: onmouseover||'>'||
226: '

220: begin
221:
222: htp.p('');
223:
224: htp.p(''||
227: ''||

Line 241: htp.p('
225: onmouseover||'>'||
226: '
');

237: '

');
242:
243: exception
244: when others then
245: rollback;

Line 299: htp.htmlOpen;

295: */
296: l_window_name := SUBSTR(doc_name, 1, l_document_position-1);
297:
298:
299: htp.htmlOpen;
300: htp.headOpen;
301:
302: IF (window_title IS NOT NULL) THEN
303:

Line 300: htp.headOpen;

296: l_window_name := SUBSTR(doc_name, 1, l_document_position-1);
297:
298:
299: htp.htmlOpen;
300: htp.headOpen;
301:
302: IF (window_title IS NOT NULL) THEN
303:
304: htp.title(window_title);

Line 304: htp.title(window_title);

300: htp.headOpen;
301:
302: IF (window_title IS NOT NULL) THEN
303:
304: htp.title(window_title);
305:
306: ELSE
307:
308: htp.title(wf_core.translate('WFPREF_LOV'));

Line 308: htp.title(wf_core.translate('WFPREF_LOV'));

304: htp.title(window_title);
305:
306: ELSE
307:
308: htp.title(wf_core.translate('WFPREF_LOV'));
309:
310: END IF;
311:
312: htp.p('');

Line 421: htp.p('window.close();}');

417: htp.p(callback_str);
418:
419: htp.p(l_window_name||'.cancelModal();');
420:
421: htp.p('window.close();}');
422:
423: htp.p(' ');
424: htp.p('');
425: htp.p('');

419: htp.p(l_window_name||'.cancelModal();');
420:
421: htp.p('window.close();}');
422:
423: htp.p(' ');
424: htp.p('');
425: htp.p('');
424: htp.p('');
425: htp.p('');
424: htp.p('');
425: htp.p('');

447: window.focus();
448: }
449: }');
450:
451: htp.p(' ');
452:
453: htp.p('');
452:
453: htp.p('');
452:
453: htp.p('');

Line 472: htp.p('document.write("<\/applet>");');

468: htp.p('document.write("")');
469: htp.p('document.write("")');
470: htp.p('document.write("")');
471: htp.p('document.write("")');
472: htp.p('document.write("<\/applet>");');
473: htp.p('}');
474:
475: htp.p(' ');
476:

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

469: htp.p('document.write("")');
470: htp.p('document.write("")');
471: htp.p('document.write("")');
472: htp.p('document.write("<\/applet>");');
473: htp.p('}');
474:
475: htp.p(' ');
476:
477: htp.p('');

Line 475: htp.p(' ');

471: htp.p('document.write("")');
472: htp.p('document.write("<\/applet>");');
473: htp.p('}');
474:
475: htp.p(' ');
476:
477: htp.p('');
478:
479: htp.p(' 480: wfa_html.base_url(get_from_resources=>TRUE)||
481: '/'|| query_plsql || '">');

Line 479: htp.p(' 480: wfa_html.base_url(get_from_resources=>TRUE)||
481: '/'|| query_plsql || '">');
482:
483: htp.p('');

Line 483: htp.p('');

479: htp.p('');
482:
483: htp.p('');
484:
485: htp.headclose;
486:
487: if doc_name <> 'PRELOAD' then -- added to prevent js errors on lov preload

Line 485: htp.headclose;

481: '/'|| query_plsql || '">');
482:
483: htp.p('');
484:
485: htp.headclose;
486:
487: if doc_name <> 'PRELOAD' then -- added to prevent js errors on lov preload
488: htp.p('');

Line 488: htp.p('');
490: else
491: htp.p('');
492: end if;

Line 491: htp.p('');

487: if doc_name <> 'PRELOAD' then -- added to prevent js errors on lov preload
488: htp.p('');
490: else
491: htp.p('');
492: end if;
493:
494: htp.p('

');
495:

Line 494: htp.p('');

490: else
491: htp.p('');
492: end if;
493:
494: htp.p('');
495:
496: htp.p('');

Line 498: htp.p('helper();');

494: htp.p('');
495:
496: htp.p('');
501: htp.p('');
502:

Line 500: htp.p(' ');

496: htp.p('');
501: htp.p('');
502:
503: l_url := 'javascript:cancel_lov()';
504: l_icon := 'FNDJLFCN.gif';

Line 501: htp.p('');

497:
498: htp.p('helper();');
499:
500: htp.p(' ');
501: htp.p('');
502:
503: l_url := 'javascript:cancel_lov()';
504: l_icon := 'FNDJLFCN.gif';
505: l_text := wf_core.translate ('CANCEL');

Line 517: htp.p('');

513: l_onmouseover := wf_core.translate ('WFMON_OK');
514:
515: CreateButton (l_url, l_onmouseover, l_media, l_icon, l_text);
516:
517: htp.p('');
518: htp.p('');
519: htp.htmlclose;
520:
521:

Line 518: htp.p('');

514:
515: CreateButton (l_url, l_onmouseover, l_media, l_icon, l_text);
516:
517: htp.p('');
518: htp.p('');
519: htp.htmlclose;
520:
521:
522: exception

Line 519: htp.htmlclose;

515: CreateButton (l_url, l_onmouseover, l_media, l_icon, l_text);
516:
517: htp.p('');
518: htp.p('');
519: htp.htmlclose;
520:
521:
522: exception
523: when others then

Line 569: htp.title(l_display_name);

565: ** Check to see if the key is passed, if yes then display the variable
566: ** storing the translated value.
567: */
568: if (p_display_key='Y') then
569: htp.title(l_display_name);
570:
571: /*
572: ** Now create the summary/detail frameset
573: */

Line 574: htp.p ('');
577: else
578: htp.title(p_display_name);

Line 578: htp.title(p_display_name);

574: htp.p ('');
577: else
578: htp.title(p_display_name);
579:
580: htp.p ('');

Line 580: htp.p ('');
577: else
578: htp.title(p_display_name);
579:
580: htp.p ('');
583:
584: end if;

Line 590: htp.p ('

586: /*
587: ** Create the summary frame
588: */
589:
590: htp.p (' 591: 'SRC='||
592: owa_util.get_owa_service_path||
593: 'wf_lov.display_lov_find?p_lov_name='||
594: wfa_html.conv_special_url_chars(p_lov_name)||

Line 610: htp.p('details frame p_display_name is '||p_display_name);

606:
607: /*
608: ** Create the details frame
609: */
610: htp.p('details frame p_display_name is '||p_display_name);
611: htp.p (' 612: 'SRC='||
613: owa_util.get_owa_service_path||
614: 'wf_lov.display_lov_details?p_lov_name='||

Line 611: htp.p ('

607: /*
608: ** Create the details frame
609: */
610: htp.p('details frame p_display_name is '||p_display_name);
611: htp.p (' 612: 'SRC='||
613: owa_util.get_owa_service_path||
614: 'wf_lov.display_lov_details?p_lov_name='||
615: wfa_html.conv_special_url_chars(p_lov_name)||

Line 639: htp.p ('');

635:
636: /*
637: ** Close the summary/details frameset
638: */
639: htp.p ('');
640:
641: htp.bodyclose;
642: htp.htmlclose;
643:

Line 641: htp.bodyclose;

637: ** Close the summary/details frameset
638: */
639: htp.p ('');
640:
641: htp.bodyclose;
642: htp.htmlclose;
643:
644:
645: exception

Line 642: htp.htmlclose;

638: */
639: htp.p ('');
640:
641: htp.bodyclose;
642: htp.htmlclose;
643:
644:
645: exception
646: when others then

Line 677: htp.headopen;

673: if (p_display_key='Y') then
674: l_display_name := wf_core.translate(p_display_name);
675: end if;
676:
677: htp.headopen;
678:
679: htp.p ('');

724: {
725: fnd_launch_query();
726: }');
727:
728: htp.p('');
729:
730: htp.p('');
731:
732: htp.headclose;

Line 730: htp.p('');

726: }');
727:
728: htp.p('');
729:
730: htp.p('');
731:
732: htp.headclose;
733:
734: htp.p('');

Line 732: htp.headclose;

728: htp.p('');
729:
730: htp.p('');
731:
732: htp.headclose;
733:
734: htp.p('');
735:
736: htp.formOpen(curl=>'javascript:fnd_launch_query();',

Line 734: htp.p('');

730: htp.p('');
731:
732: htp.headclose;
733:
734: htp.p('');
735:
736: htp.formOpen(curl=>'javascript:fnd_launch_query();',
737: cmethod=>'POST', cattributes=>'NAME="WF_FIND"');
738:

Line 736: htp.formOpen(curl=>'javascript:fnd_launch_query();',

732: htp.headclose;
733:
734: htp.p('');
735:
736: htp.formOpen(curl=>'javascript:fnd_launch_query();',
737: cmethod=>'POST', cattributes=>'NAME="WF_FIND"');
738:
739: htp.tableOpen(cattributes=>'summary=""');
740:

Line 739: htp.tableOpen(cattributes=>'summary=""');

735:
736: htp.formOpen(curl=>'javascript:fnd_launch_query();',
737: cmethod=>'POST', cattributes=>'NAME="WF_FIND"');
738:
739: htp.tableOpen(cattributes=>'summary=""');
740:
741: htp.tableRowOpen;
742: htp.tableData(cvalue=>'

Line 741: htp.tableRowOpen;

737: cmethod=>'POST', cattributes=>'NAME="WF_FIND"');
738:
739: htp.tableOpen(cattributes=>'summary=""');
740:
741: htp.tableRowOpen;
742: htp.tableData(cvalue=>'',
745: calign=>'right',

Line 742: htp.tableData(cvalue=>'

738:
739: htp.tableOpen(cattributes=>'summary=""');
740:
741: htp.tableRowOpen;
742: htp.tableData(cvalue=>'743: wf_core.translate('FIND') ||
744: '',
745: calign=>'right',
746: cattributes=>'id=""');

Line 748: htp.tableData(htf.formText(cname=>'p_current_value', csize=>'30',

744: '',
745: calign=>'right',
746: cattributes=>'id=""');
747:
748: htp.tableData(htf.formText(cname=>'p_current_value', csize=>'30',
749: cmaxlength=>'4000', cvalue=>'',
750: cattributes=>'id="i_current_value"'),
751: cattributes=>'id=""');
752:

Line 753: htp.p ('');

749: cmaxlength=>'4000', cvalue=>'',
750: cattributes=>'id="i_current_value"'),
751: cattributes=>'id=""');
752:
753: htp.p ('');
754: htp.p('');
755:
756: htp.p('');
757:

Line 754: htp.p('');

750: cattributes=>'id="i_current_value"'),
751: cattributes=>'id=""');
752:
753: htp.p ('');
754: htp.p('');
755:
756: htp.p('');
757:
758: wfa_html.create_reg_button ('javascript:fnd_launch_query();',

Line 756: htp.p('');

752:
753: htp.p ('');
754: htp.p('');
755:
756: htp.p('');
757:
758: wfa_html.create_reg_button ('javascript:fnd_launch_query();',
759: wf_core.translate ('FIND'),
760: wfa_html.image_loc,

Line 764: htp.p('');

760: wfa_html.image_loc,
761: 'fndfind.gif',
762: wf_core.translate ('FIND'));
763:
764: htp.p('');
765:
766: htp.p('');
767:
768: wfa_html.create_reg_button ('javascript:document.WF_FIND.reset();',

Line 766: htp.p('');

762: wf_core.translate ('FIND'));
763:
764: htp.p('');
765:
766: htp.p('');
767:
768: wfa_html.create_reg_button ('javascript:document.WF_FIND.reset();',
769: wf_core.translate ('CLEAR'),
770: wfa_html.image_loc,

Line 774: htp.p('');

770: wfa_html.image_loc,
771: 'fndfind.gif',
772: wf_core.translate ('CLEAR'));
773:
774: htp.p('');
775:
776: htp.tableRowClose;
777: htp.tableClose;
778: htp.formClose;

Line 776: htp.tableRowClose;

772: wf_core.translate ('CLEAR'));
773:
774: htp.p('');
775:
776: htp.tableRowClose;
777: htp.tableClose;
778: htp.formClose;
779:
780:

Line 777: htp.tableClose;

773:
774: htp.p('');
775:
776: htp.tableRowClose;
777: htp.tableClose;
778: htp.formClose;
779:
780:
781: exception

Line 778: htp.formClose;

774: htp.p('');
775:
776: htp.tableRowClose;
777: htp.tableClose;
778: htp.formClose;
779:
780:
781: exception
782: when others then

Line 826: htp.headopen;

822: BEGIN
823:
824: WFA_SEC.GetSession(username);
825:
826: htp.headopen;
827:
828: htp.p ('');

914: p_dest_hidden_field||'=document.WF_LOV_FRM.h_hidden[num].value;
915: parent.self.close();
916: }');
917:
918: htp.p('');
919:
920: htp.p('');
921:
922: htp.headclose;

Line 920: htp.p('');

916: }');
917:
918: htp.p('');
919:
920: htp.p('');
921:
922: htp.headclose;
923:
924: htp.p('');

Line 922: htp.headclose;

918: htp.p('');
919:
920: htp.p('');
921:
922: htp.headclose;
923:
924: htp.p('');
925:
926: htp.formOpen(curl=>owa_util.get_owa_service_path||

Line 924: htp.p('');

920: htp.p('');
921:
922: htp.headclose;
923:
924: htp.p('');
925:
926: htp.formOpen(curl=>owa_util.get_owa_service_path||
927: 'wf_lov.display_lov_details',
928: cmethod=>'POST', cattributes=>'NAME="WF_DETAILS"');

Line 926: htp.formOpen(curl=>owa_util.get_owa_service_path||

922: htp.headclose;
923:
924: htp.p('');
925:
926: htp.formOpen(curl=>owa_util.get_owa_service_path||
927: 'wf_lov.display_lov_details',
928: cmethod=>'POST', cattributes=>'NAME="WF_DETAILS"');
929:
930: htp.formhidden('p_lov_name', p_lov_name);

Line 930: htp.formhidden('p_lov_name', p_lov_name);

926: htp.formOpen(curl=>owa_util.get_owa_service_path||
927: 'wf_lov.display_lov_details',
928: cmethod=>'POST', cattributes=>'NAME="WF_DETAILS"');
929:
930: htp.formhidden('p_lov_name', p_lov_name);
931: htp.formhidden('p_display_name', p_display_name);
932: htp.formhidden('p_validation_callback', p_validation_callback);
933: htp.formhidden('p_dest_hidden_field', p_dest_hidden_field);
934: htp.formhidden('p_dest_display_field',p_dest_display_field);

Line 931: htp.formhidden('p_display_name', p_display_name);

927: 'wf_lov.display_lov_details',
928: cmethod=>'POST', cattributes=>'NAME="WF_DETAILS"');
929:
930: htp.formhidden('p_lov_name', p_lov_name);
931: htp.formhidden('p_display_name', p_display_name);
932: htp.formhidden('p_validation_callback', p_validation_callback);
933: htp.formhidden('p_dest_hidden_field', p_dest_hidden_field);
934: htp.formhidden('p_dest_display_field',p_dest_display_field);
935: htp.formhidden('p_current_value',p_current_value);

Line 932: htp.formhidden('p_validation_callback', p_validation_callback);

928: cmethod=>'POST', cattributes=>'NAME="WF_DETAILS"');
929:
930: htp.formhidden('p_lov_name', p_lov_name);
931: htp.formhidden('p_display_name', p_display_name);
932: htp.formhidden('p_validation_callback', p_validation_callback);
933: htp.formhidden('p_dest_hidden_field', p_dest_hidden_field);
934: htp.formhidden('p_dest_display_field',p_dest_display_field);
935: htp.formhidden('p_current_value',p_current_value);
936: htp.formhidden('p_start_row',p_start_row);

Line 933: htp.formhidden('p_dest_hidden_field', p_dest_hidden_field);

929:
930: htp.formhidden('p_lov_name', p_lov_name);
931: htp.formhidden('p_display_name', p_display_name);
932: htp.formhidden('p_validation_callback', p_validation_callback);
933: htp.formhidden('p_dest_hidden_field', p_dest_hidden_field);
934: htp.formhidden('p_dest_display_field',p_dest_display_field);
935: htp.formhidden('p_current_value',p_current_value);
936: htp.formhidden('p_start_row',p_start_row);
937: htp.formhidden('p_autoquery',p_autoquery);

Line 934: htp.formhidden('p_dest_display_field',p_dest_display_field);

930: htp.formhidden('p_lov_name', p_lov_name);
931: htp.formhidden('p_display_name', p_display_name);
932: htp.formhidden('p_validation_callback', p_validation_callback);
933: htp.formhidden('p_dest_hidden_field', p_dest_hidden_field);
934: htp.formhidden('p_dest_display_field',p_dest_display_field);
935: htp.formhidden('p_current_value',p_current_value);
936: htp.formhidden('p_start_row',p_start_row);
937: htp.formhidden('p_autoquery',p_autoquery);
938: htp.formhidden('p_param1',p_param1);

Line 935: htp.formhidden('p_current_value',p_current_value);

931: htp.formhidden('p_display_name', p_display_name);
932: htp.formhidden('p_validation_callback', p_validation_callback);
933: htp.formhidden('p_dest_hidden_field', p_dest_hidden_field);
934: htp.formhidden('p_dest_display_field',p_dest_display_field);
935: htp.formhidden('p_current_value',p_current_value);
936: htp.formhidden('p_start_row',p_start_row);
937: htp.formhidden('p_autoquery',p_autoquery);
938: htp.formhidden('p_param1',p_param1);
939: htp.formhidden('p_param2',p_param2);

Line 936: htp.formhidden('p_start_row',p_start_row);

932: htp.formhidden('p_validation_callback', p_validation_callback);
933: htp.formhidden('p_dest_hidden_field', p_dest_hidden_field);
934: htp.formhidden('p_dest_display_field',p_dest_display_field);
935: htp.formhidden('p_current_value',p_current_value);
936: htp.formhidden('p_start_row',p_start_row);
937: htp.formhidden('p_autoquery',p_autoquery);
938: htp.formhidden('p_param1',p_param1);
939: htp.formhidden('p_param2',p_param2);
940: htp.formhidden('p_param3',p_param3);

Line 937: htp.formhidden('p_autoquery',p_autoquery);

933: htp.formhidden('p_dest_hidden_field', p_dest_hidden_field);
934: htp.formhidden('p_dest_display_field',p_dest_display_field);
935: htp.formhidden('p_current_value',p_current_value);
936: htp.formhidden('p_start_row',p_start_row);
937: htp.formhidden('p_autoquery',p_autoquery);
938: htp.formhidden('p_param1',p_param1);
939: htp.formhidden('p_param2',p_param2);
940: htp.formhidden('p_param3',p_param3);
941: htp.formhidden('p_param4',p_param4);

Line 938: htp.formhidden('p_param1',p_param1);

934: htp.formhidden('p_dest_display_field',p_dest_display_field);
935: htp.formhidden('p_current_value',p_current_value);
936: htp.formhidden('p_start_row',p_start_row);
937: htp.formhidden('p_autoquery',p_autoquery);
938: htp.formhidden('p_param1',p_param1);
939: htp.formhidden('p_param2',p_param2);
940: htp.formhidden('p_param3',p_param3);
941: htp.formhidden('p_param4',p_param4);
942: htp.formhidden('p_param5',p_param5);

Line 939: htp.formhidden('p_param2',p_param2);

935: htp.formhidden('p_current_value',p_current_value);
936: htp.formhidden('p_start_row',p_start_row);
937: htp.formhidden('p_autoquery',p_autoquery);
938: htp.formhidden('p_param1',p_param1);
939: htp.formhidden('p_param2',p_param2);
940: htp.formhidden('p_param3',p_param3);
941: htp.formhidden('p_param4',p_param4);
942: htp.formhidden('p_param5',p_param5);
943: htp.formhidden('p_display_key',p_display_key);

Line 940: htp.formhidden('p_param3',p_param3);

936: htp.formhidden('p_start_row',p_start_row);
937: htp.formhidden('p_autoquery',p_autoquery);
938: htp.formhidden('p_param1',p_param1);
939: htp.formhidden('p_param2',p_param2);
940: htp.formhidden('p_param3',p_param3);
941: htp.formhidden('p_param4',p_param4);
942: htp.formhidden('p_param5',p_param5);
943: htp.formhidden('p_display_key',p_display_key);
944:

Line 941: htp.formhidden('p_param4',p_param4);

937: htp.formhidden('p_autoquery',p_autoquery);
938: htp.formhidden('p_param1',p_param1);
939: htp.formhidden('p_param2',p_param2);
940: htp.formhidden('p_param3',p_param3);
941: htp.formhidden('p_param4',p_param4);
942: htp.formhidden('p_param5',p_param5);
943: htp.formhidden('p_display_key',p_display_key);
944:
945: if (p_autoquery = 'Y') then

Line 942: htp.formhidden('p_param5',p_param5);

938: htp.formhidden('p_param1',p_param1);
939: htp.formhidden('p_param2',p_param2);
940: htp.formhidden('p_param3',p_param3);
941: htp.formhidden('p_param4',p_param4);
942: htp.formhidden('p_param5',p_param5);
943: htp.formhidden('p_display_key',p_display_key);
944:
945: if (p_autoquery = 'Y') then
946:

Line 943: htp.formhidden('p_display_key',p_display_key);

939: htp.formhidden('p_param2',p_param2);
940: htp.formhidden('p_param3',p_param3);
941: htp.formhidden('p_param4',p_param4);
942: htp.formhidden('p_param5',p_param5);
943: htp.formhidden('p_display_key',p_display_key);
944:
945: if (p_autoquery = 'Y') then
946:
947: -- Autoquery or Display hint about selection criteria

Line 948: htp.p('');
951:
952: htp.p('');

Line 949: htp.p('autoquery()');

945: if (p_autoquery = 'Y') then
946:
947: -- Autoquery or Display hint about selection criteria
948: htp.p('');
951:
952: htp.p('');
953:

Line 950: htp.p('');

946:
947: -- Autoquery or Display hint about selection criteria
948: htp.p('');
951:
952: htp.p('');
953:
954: end if;

Line 952: htp.p('');

948: htp.p('');
951:
952: htp.p('');
953:
954: end if;
955:
956:

Line 1053: htp.tableOpen(cborder => 'BORDER=0', cattributes => 'WIDTH="100%" SUMMARY=""');

1049: /*
1050: ** Print out the row count for the results in the form of
1051: ** Records: 1 to 15 of 25
1052: */
1053: htp.tableOpen(cborder => 'BORDER=0', cattributes => 'WIDTH="100%" SUMMARY=""');
1054: htp.tableRowOpen;
1055:
1056: wf_core.clear;
1057: Wf_Core.Token('START_REC', p_start_row);

Line 1054: htp.tableRowOpen;

1050: ** Print out the row count for the results in the form of
1051: ** Records: 1 to 15 of 25
1052: */
1053: htp.tableOpen(cborder => 'BORDER=0', cattributes => 'WIDTH="100%" SUMMARY=""');
1054: htp.tableRowOpen;
1055:
1056: wf_core.clear;
1057: Wf_Core.Token('START_REC', p_start_row);
1058: Wf_Core.Token('END_REC', TO_CHAR(TO_NUMBER(p_start_row) + wf_lov.g_value_tbl.count - 1));

Line 1061: htp.tabledata('' || Wf_Core.Translate('RECORD_MSG') ||

1057: Wf_Core.Token('START_REC', p_start_row);
1058: Wf_Core.Token('END_REC', TO_CHAR(TO_NUMBER(p_start_row) + wf_lov.g_value_tbl.count - 1));
1059: Wf_Core.Token('TOTAL_REC', ''||TO_CHAR(wf_lov.g_define_rec.total_rows)||'');
1060:
1061: htp.tabledata('' || Wf_Core.Translate('RECORD_MSG') ||
1062: '', cattributes=>'id=""');
1063:
1064: htp.tableRowClose;
1065: htp.tableClose;

Line 1064: htp.tableRowClose;

1060:
1061: htp.tabledata('' || Wf_Core.Translate('RECORD_MSG') ||
1062: '', cattributes=>'id=""');
1063:
1064: htp.tableRowClose;
1065: htp.tableClose;
1066:
1067: -- display table header of LOV
1068: htp.p('

Line 1065: htp.tableClose;

1061: htp.tabledata('' || Wf_Core.Translate('RECORD_MSG') ||
1062: '', cattributes=>'id=""');
1063:
1064: htp.tableRowClose;
1065: htp.tableClose;
1066:
1067: -- display table header of LOV
1068: htp.p('

1069: ' cellspacing=0 border=0 summary="">');

Line 1068: htp.p('

1064: htp.tableRowClose;
1065: htp.tableClose;
1066:
1067: -- display table header of LOV
1068: htp.p('

1069: ' cellspacing=0 border=0 summary="">');
1070: htp.p('');
1222: htp.p('');
1223: htp.p('
');
1071: htp.p('');
1072:

Line 1070: htp.p('
');

1066:
1067: -- display table header of LOV
1068: htp.p(' 1069: ' cellspacing=0 border=0 summary="">');
1070: htp.p('');

1218:
1219: htp.tableClose;
1220:
1221: htp.p('');
1222: htp.p('');
1223: htp.p('

');
1071: htp.p('');
1072:
1073: /*
1074: ** Print out the header

Line 1071: htp.p('
');

1067: -- display table header of LOV
1068: htp.p('

1069: ' cellspacing=0 border=0 summary="">');
1070: htp.p('');

1217: end loop;
1218:
1219: htp.tableClose;
1220:
1221: htp.p('');
1222: htp.p('

');
1223: htp.p('
');
1071: htp.p('');
1072:
1073: /*
1074: ** Print out the header
1075: */

Line 1076: htp.p('
');

1072:
1073: /*
1074: ** Print out the header
1075: */
1076: htp.p('

');
1077:
1078: /*
1079: ** get the display name for the attribute
1080: */

Line 1082: htp.p('
');
1086: else

Line 1088: htp.p('
');
1092: end if;

Line 1095: htp.p('
');
1099:

Line 1106: htp.p('
');
1110:

Line 1117: htp.p('
');
1121:

Line 1128: htp.p('
');
1132:

Line 1139: htp.p('
');
1143:

Line 1148: htp.tablerowclose;

1144: l_ncols := l_ncols + 1;
1145:
1146: end if;
1147:
1148: htp.tablerowclose;
1149: /*
1150: ** Loop through the data
1151: */
1152: for ii in 1..wf_lov.g_value_tbl.count loop

Line 1156: htp.p('
');

1152: for ii in 1..wf_lov.g_value_tbl.count loop
1153:
1154: -- display one row of data
1155: if (round(ii/2) = ii/2) then
1156: htp.p('

');
1157: else
1158: htp.p('');
1159: end if;
1160:

Line 1158: htp.p('
');

1154: -- display one row of data
1155: if (round(ii/2) = ii/2) then
1156: htp.p('

');
1157: else
1158: htp.p('');
1159: end if;
1160:
1161: if (p_display_key='Y') then
1162: htp.tabledata (''||

Line 1162: htp.tabledata (''||

1158: htp.p('

');
1159: end if;
1160:
1161: if (p_display_key='Y') then
1162: htp.tabledata (''||
1163: wf_lov.g_value_tbl(ii).display_value||'',
1164: cattributes=>'headers="' || l_display_name || '"');
1165: else
1166: htp.tabledata (''||

Line 1166: htp.tabledata (''||

1162: htp.tabledata (''||
1163: wf_lov.g_value_tbl(ii).display_value||'',
1164: cattributes=>'headers="' || l_display_name || '"');
1165: else
1166: htp.tabledata (''||
1167: wf_lov.g_value_tbl(ii).display_value||'',
1168: cattributes=>'headers="' || p_display_name || '"');
1169: end if;
1170:

Line 1173: htp.tabledata (wf_lov.g_value_tbl(ii).add_attr1_value,

1169: end if;
1170:
1171: if (l_ncols > 0) then
1172:
1173: htp.tabledata (wf_lov.g_value_tbl(ii).add_attr1_value,
1174: cattributes=>'headers="' ||
1175: wf_lov.g_define_rec.add_attr1_title ||
1176: '"');
1177:

Line 1181: htp.tabledata (wf_lov.g_value_tbl(ii).add_attr2_value,

1177:
1178: end if;
1179: if (l_ncols > 1) then
1180:
1181: htp.tabledata (wf_lov.g_value_tbl(ii).add_attr2_value,
1182: cattributes=>'headers="' ||
1183: wf_lov.g_define_rec.add_attr2_title ||
1184: '"');
1185:

Line 1189: htp.tabledata (wf_lov.g_value_tbl(ii).add_attr3_value,

1185:
1186: end if;
1187: if (l_ncols > 2) then
1188:
1189: htp.tabledata (wf_lov.g_value_tbl(ii).add_attr3_value,
1190: cattributes=>'headers="' ||
1191: wf_lov.g_define_rec.add_attr3_title ||
1192: '"');
1193:

Line 1198: htp.tabledata (wf_lov.g_value_tbl(ii).add_attr4_value,

1194:
1195: end if;
1196: if (l_ncols > 3) then
1197:
1198: htp.tabledata (wf_lov.g_value_tbl(ii).add_attr4_value,
1199: cattributes=>'headers="' ||
1200: wf_lov.g_define_rec.add_attr4_title ||
1201: '"');
1202:

Line 1207: htp.tabledata (wf_lov.g_value_tbl(ii).add_attr5_value,

1203:
1204: end if;
1205: if (l_ncols > 4) then
1206:
1207: htp.tabledata (wf_lov.g_value_tbl(ii).add_attr5_value,
1208: cattributes=>'headers="' ||
1209: wf_lov.g_define_rec.add_attr5_title ||
1210: '"');
1211:

Line 1215: htp.tablerowclose;

1211:
1212:
1213: end if;
1214:
1215: htp.tablerowclose;
1216:
1217: end loop;
1218:
1219: htp.tableClose;

Line 1219: htp.tableClose;

1215: htp.tablerowclose;
1216:
1217: end loop;
1218:
1219: htp.tableClose;
1220:
1221: htp.p('');
1222: htp.p('

');
1223: htp.p('
'||
1084: ''||l_display_name||
1085: '		 '||
1090: ''|| p_display_name ||
1091: '		 '||
1097: ''|| wf_lov.g_define_rec.add_attr1_title ||
1098: '		 '||
1108: ''|| wf_lov.g_define_rec.add_attr2_title ||
1109: '		 '||
1119: ''|| wf_lov.g_define_rec.add_attr3_title ||
1120: '		 '||
1130: ''|| wf_lov.g_define_rec.add_attr4_title ||
1131: '		 '||
1141: ''|| wf_lov.g_define_rec.add_attr5_title ||
1142: '
');

Line 1221: htp.p('
');
1224:
1225: htp.tableOpen(calign=>'CENTER', cborder => 'BORDER=0',

Line 1222: htp.p('
');
1224:
1225: htp.tableOpen(calign=>'CENTER', cborder => 'BORDER=0',
1226: cattributes=>'summary=""');

Line 1223: htp.p('
');

1219: htp.tableClose;
1220:
1221: htp.p('

');
1224:
1225: htp.tableOpen(calign=>'CENTER', cborder => 'BORDER=0',
1226: cattributes=>'summary=""');
1227: htp.tableRowOpen;

Line 1225: htp.tableOpen(calign=>'CENTER', cborder => 'BORDER=0',

1221: htp.p('');
1222: htp.p('');
1223: htp.p('');
1224:
1225: htp.tableOpen(calign=>'CENTER', cborder => 'BORDER=0',
1226: cattributes=>'summary=""');
1227: htp.tableRowOpen;
1228:
1229: /*

Line 1227: htp.tableRowOpen;

1223: htp.p('');
1224:
1225: htp.tableOpen(calign=>'CENTER', cborder => 'BORDER=0',
1226: cattributes=>'summary=""');
1227: htp.tableRowOpen;
1228:
1229: /*
1230: ** Check to see if you should create the PREVIOUS button
1231: */

Line 1234: htp.p('');

1230: ** Check to see if you should create the PREVIOUS button
1231: */
1232: IF (TO_NUMBER(p_start_row) > 1) THEN
1233:
1234: htp.p('');
1235:
1236: /*
1237: ** Make sure that your not going to go back past the first
1238: ** record. Otherwise subtract the query set from the start

Line 1250: htp.p(' 1251: TO_CHAR(l_start_row)||
1252: ')">');
1253:
1254: htp.p('' ||<br> </p> <h5>Line 1254: htp.p('<IMG SRC= 1251: TO_CHAR(l_start_row)||
1252: ')">');
1253:
1254: htp.p('' ||<br> </b>1255: WF_CORE.Translate('PREVIOUS') || '');
1256:
1257: htp.p(''||wf_core.translate('PREVIOUS')||'');
1258:

Line 1257: htp.p(''||wf_core.translate('PREVIOUS')||'');

1253:
1254: htp.p('' ||<br> 1255: WF_CORE.Translate('PREVIOUS') || '');
1256:
1257: htp.p(''||wf_core.translate('PREVIOUS')||'');
1258:
1259: htp.p('');
1260:
1261: END IF;

Line 1259: htp.p('');

1255: WF_CORE.Translate('PREVIOUS') || '">');
1256:
1257: htp.p(''||wf_core.translate('PREVIOUS')||'');
1258:
1259: htp.p('');
1260:
1261: END IF;
1262:
1263:

Line 1272: htp.p('');

1268:
1269: l_start_row := TO_NUMBER(p_start_row) + 10;
1270: if (l_start_row <= wf_lov.g_define_rec.total_rows) then
1271:
1272: htp.p('');
1273:
1274: htp.p('');

Line 1274: htp.p('');
1273:
1274: htp.p('');
1277:
1278: htp.p('' ||<br> </p> <h5>Line 1278: htp.p('<IMG SRC= 1275: TO_CHAR(l_start_row)||
1276: ')">');
1277:
1278: htp.p('' ||<br> </b>1279: WF_CORE.Translate('NEXT') || '');
1280:
1281: htp.p(''||wf_core.translate('NEXT')||'');
1282:

Line 1281: htp.p(''||wf_core.translate('NEXT')||'');

1277:
1278: htp.p('' ||<br> 1279: WF_CORE.Translate('NEXT') || '');
1280:
1281: htp.p(''||wf_core.translate('NEXT')||'');
1282:
1283: htp.p('');
1284: end if;
1285:

Line 1283: htp.p('');

1279: WF_CORE.Translate('NEXT') || '">');
1280:
1281: htp.p(''||wf_core.translate('NEXT')||'');
1282:
1283: htp.p('');
1284: end if;
1285:
1286: END IF;
1287:

Line 1288: htp.tableRowClose;

1284: end if;
1285:
1286: END IF;
1287:
1288: htp.tableRowClose;
1289:
1290: htp.tableclose;
1291:
1292: htp.formclose;

Line 1290: htp.tableclose;

1286: END IF;
1287:
1288: htp.tableRowClose;
1289:
1290: htp.tableclose;
1291:
1292: htp.formclose;
1293:
1294: -- Form to hold the display value and hidden key for the javascript

Line 1292: htp.formclose;

1288: htp.tableRowClose;
1289:
1290: htp.tableclose;
1291:
1292: htp.formclose;
1293:
1294: -- Form to hold the display value and hidden key for the javascript
1295: -- LOV_copy(). This is to fix the problem when either display_value
1296: -- or the hidden_key contain single quotes.

Line 1297: htp.formOpen(curl=>null, cmethod=>'Post',

1293:
1294: -- Form to hold the display value and hidden key for the javascript
1295: -- LOV_copy(). This is to fix the problem when either display_value
1296: -- or the hidden_key contain single quotes.
1297: htp.formOpen(curl=>null, cmethod=>'Post',
1298: cattributes=>'NAME=WF_LOV_FRM');
1299:
1300: -- place dummy values in index 0
1301: htp.formHidden('h_display', 'xxx');

Line 1301: htp.formHidden('h_display', 'xxx');

1297: htp.formOpen(curl=>null, cmethod=>'Post',
1298: cattributes=>'NAME=WF_LOV_FRM');
1299:
1300: -- place dummy values in index 0
1301: htp.formHidden('h_display', 'xxx');
1302: htp.formHidden('h_hidden', 'xxx');
1303:
1304: for ii in 1..wf_lov.g_value_tbl.count loop
1305: htp.formHidden('h_display',wf_lov.g_value_tbl(ii).display_value);

Line 1302: htp.formHidden('h_hidden', 'xxx');

1298: cattributes=>'NAME=WF_LOV_FRM');
1299:
1300: -- place dummy values in index 0
1301: htp.formHidden('h_display', 'xxx');
1302: htp.formHidden('h_hidden', 'xxx');
1303:
1304: for ii in 1..wf_lov.g_value_tbl.count loop
1305: htp.formHidden('h_display',wf_lov.g_value_tbl(ii).display_value);
1306: -- ### does not work for double quotes

Line 1305: htp.formHidden('h_display',wf_lov.g_value_tbl(ii).display_value);

1301: htp.formHidden('h_display', 'xxx');
1302: htp.formHidden('h_hidden', 'xxx');
1303:
1304: for ii in 1..wf_lov.g_value_tbl.count loop
1305: htp.formHidden('h_display',wf_lov.g_value_tbl(ii).display_value);
1306: -- ### does not work for double quotes
1307: -- ### replace(wf_lov.g_value_tbl(ii).display_value, '"', '\"'));
1308: htp.formHidden('h_hidden',wf_lov.g_value_tbl(ii).hidden_key);
1309: -- ### replace(wf_lov.g_value_tbl(ii).hidden_key, '"', '\"'));

Line 1308: htp.formHidden('h_hidden',wf_lov.g_value_tbl(ii).hidden_key);

1304: for ii in 1..wf_lov.g_value_tbl.count loop
1305: htp.formHidden('h_display',wf_lov.g_value_tbl(ii).display_value);
1306: -- ### does not work for double quotes
1307: -- ### replace(wf_lov.g_value_tbl(ii).display_value, '"', '\"'));
1308: htp.formHidden('h_hidden',wf_lov.g_value_tbl(ii).hidden_key);
1309: -- ### replace(wf_lov.g_value_tbl(ii).hidden_key, '"', '\"'));
1310: end loop;
1311:
1312: htp.formClose;

Line 1312: htp.formClose;

1308: htp.formHidden('h_hidden',wf_lov.g_value_tbl(ii).hidden_key);
1309: -- ### replace(wf_lov.g_value_tbl(ii).hidden_key, '"', '\"'));
1310: end loop;
1311:
1312: htp.formClose;
1313:
1314: htp.bodyclose;
1315:
1316: end if;

Line 1314: htp.bodyclose;

1310: end loop;
1311:
1312: htp.formClose;
1313:
1314: htp.bodyclose;
1315:
1316: end if;
1317:
1318: exception

Line 1404: htp.title(wf_core.translate('SELECT')||'&'||'nbsp;'||p_display_name);

1400:
1401: /*
1402: ** Set the title for the window
1403: */
1404: htp.title(wf_core.translate('SELECT')||'&'||'nbsp;'||p_display_name);
1405:
1406: htp.headopen;
1407: -- hardcode to /OA_HTML/ for ssp
1408: htp.p('');

Line 1406: htp.headopen;

1402: ** Set the title for the window
1403: */
1404: htp.title(wf_core.translate('SELECT')||'&'||'nbsp;'||p_display_name);
1405:
1406: htp.headopen;
1407: -- hardcode to /OA_HTML/ for ssp
1408: htp.p('');
1409: -- htp.p('');
1410: htp.p ('');

1486:
1487: end if;
1488:
1489:
1490: htp.p('');
1491:
1492: htp.p('');
1493:
1494:

Line 1492: htp.p('');

1488:
1489:
1490: htp.p('');
1491:
1492: htp.p('');
1493:
1494:
1495: htp.headclose;
1496:

Line 1495: htp.headclose;

1491:
1492: htp.p('');
1493:
1494:
1495: htp.headclose;
1496:
1497: htp.p('');
1498: htp.p('
');
1499: htp.formOpen(curl=>'javascript:fnd_launch_query();',

Line 1497: htp.p('');

1493:
1494:
1495: htp.headclose;
1496:
1497: htp.p('');
1498: htp.p('
');
1499: htp.formOpen(curl=>'javascript:fnd_launch_query();',
1500: cmethod=>'POST', cattributes=>'NAME="WF_FIND"');
1501: htp.p('');

Line 1498: htp.p('
');

1494:
1495: htp.headclose;
1496:
1497: htp.p('');
1498: htp.p('
');
1499: htp.formOpen(curl=>'javascript:fnd_launch_query();',
1500: cmethod=>'POST', cattributes=>'NAME="WF_FIND"');
1501: htp.p('

');
1502: htp.p('');

Line 1499: htp.formOpen(curl=>'javascript:fnd_launch_query();',

1495: htp.headclose;
1496:
1497: htp.p('');
1498: htp.p('
');
1499: htp.formOpen(curl=>'javascript:fnd_launch_query();',
1500: cmethod=>'POST', cattributes=>'NAME="WF_FIND"');
1501: htp.p('

');
1502: htp.p('');
1503: htp.p('');

Line 1501: htp.p('
');

1497: htp.p('');
1498: htp.p('
');
1499: htp.formOpen(curl=>'javascript:fnd_launch_query();',
1500: cmethod=>'POST', cattributes=>'NAME="WF_FIND"');
1501: htp.p('

');
1502: htp.p('');
1503: htp.p('');
1504: htp.p('');

1498: htp.p('
');
1499: htp.formOpen(curl=>'javascript:fnd_launch_query();',
1500: cmethod=>'POST', cattributes=>'NAME="WF_FIND"');
1501: htp.p('

');
1505: htp.p(wf_core.translate('SELECT')||'&'||'nbsp;'||p_display_name);

Line 1502: htp.p('
');
1502: htp.p('');
1503: htp.p('');
1504: htp.p('');

Line 1503: htp.p('
');

1499: htp.formOpen(curl=>'javascript:fnd_launch_query();',
1500: cmethod=>'POST', cattributes=>'NAME="WF_FIND"');
1501: htp.p('

');
1505: htp.p(wf_core.translate('SELECT')||'&'||'nbsp;'||p_display_name);
1506: htp.p('
');
1502: htp.p('');
1503: htp.p('');
1504: htp.p('');
1507: htp.p('');

Line 1504: htp.p('
');
1505: htp.p(wf_core.translate('SELECT')||'&'||'nbsp;'||p_display_name);
1506: htp.p('
');

1500: cmethod=>'POST', cattributes=>'NAME="WF_FIND"');
1501: htp.p('');
1502: htp.p('');
1503: htp.p('');
1504: htp.p('');
1507: htp.p('');
1508: htp.p('');

Line 1505: htp.p(wf_core.translate('SELECT')||'&'||'nbsp;'||p_display_name);

1501: htp.p('

');
1505: htp.p(wf_core.translate('SELECT')||'&'||'nbsp;'||p_display_name);
1506: htp.p('

');
1502: htp.p('');
1503: htp.p('');
1504: htp.p('');
1507: htp.p('');
1508: htp.p('');
1509: htp.p('');

Line 1506: htp.p('');

1502: htp.p('

');
1503: htp.p('');
1504: htp.p('');
1507: htp.p('');
1508: htp.p('');
1509: htp.p('');
1510: htp.p('');

Line 1507: htp.p('
');

1503: htp.p('

');
1504: htp.p('');
1507: htp.p('');
1508: htp.p('');
1509: htp.p('');
1510: htp.p('');
1511:

Line 1508: htp.p('
');

1504: htp.p('

');
1507: htp.p('');
1508: htp.p('');
1509: htp.p('');
1510: htp.p('');
1511:
1512: htp.tableRowOpen;

Line 1509: htp.p('
');

1505: htp.p(wf_core.translate('SELECT')||'&'||'nbsp;'||p_display_name);
1506: htp.p('');
1507: htp.p('

');
1508: htp.p('');
1509: htp.p('');
1510: htp.p('');
1511:
1512: htp.tableRowOpen;
1513: htp.p('');

Line 1510: htp.p('
');

1506: htp.p('');
1507: htp.p('

');
1508: htp.p('');
1509: htp.p('');
1510: htp.p('');
1511:
1512: htp.tableRowOpen;
1513: htp.p('');
1514: htp.p('');
1919: -- htp.p('
');
1505: htp.p(wf_core.translate('SELECT')||'&'||'nbsp;'||p_display_name);
1506: htp.p('

');
1505: htp.p(wf_core.translate('SELECT')||'&'||'nbsp;'||p_display_name);
1506: htp.p('

');
1505: htp.p(wf_core.translate('SELECT')||'&'||'nbsp;'||p_display_name);
1506: htp.p('


');
1505: htp.p(wf_core.translate('SELECT')||'&'||'nbsp;'||p_display_name);
1506: htp.p('



');

Line 1512: htp.tableRowOpen;

1508: htp.p('

');
1509: htp.p('');
1510: htp.p('');
1511:
1512: htp.tableRowOpen;
1513: htp.p('');
1514: htp.p('

');
1515: htp.p('');
1516: htp.p('');

1509: htp.p('

');
1510: htp.p('');
1511:
1512: htp.tableRowOpen;
1513: htp.p('');
1514: htp.p('');
1536: htp.tableRowClose;
1537:
1538: htp.formClose;
1539: htp.formOpen(curl=>owa_util.get_owa_service_path||
1540: 'wf_lov.display_lov_no_frame',
1541: cmethod=>'POST', cattributes=>'NAME="WF_DETAILS"');
1542:
1543: htp.formhidden('p_lov_name', p_lov_name);

Line 1543: htp.formhidden('p_lov_name', p_lov_name);

1539: htp.formOpen(curl=>owa_util.get_owa_service_path||
1540: 'wf_lov.display_lov_no_frame',
1541: cmethod=>'POST', cattributes=>'NAME="WF_DETAILS"');
1542:
1543: htp.formhidden('p_lov_name', p_lov_name);
1544: htp.formhidden('p_display_name', p_display_name);
1545: htp.formhidden('p_validation_callback', p_validation_callback);
1546: htp.formhidden('p_dest_hidden_field', p_dest_hidden_field);
1547: htp.formhidden('p_dest_display_field',p_dest_display_field);

Line 1544: htp.formhidden('p_display_name', p_display_name);

1540: 'wf_lov.display_lov_no_frame',
1541: cmethod=>'POST', cattributes=>'NAME="WF_DETAILS"');
1542:
1543: htp.formhidden('p_lov_name', p_lov_name);
1544: htp.formhidden('p_display_name', p_display_name);
1545: htp.formhidden('p_validation_callback', p_validation_callback);
1546: htp.formhidden('p_dest_hidden_field', p_dest_hidden_field);
1547: htp.formhidden('p_dest_display_field',p_dest_display_field);
1548: htp.formhidden('p_current_value',p_current_value);

Line 1545: htp.formhidden('p_validation_callback', p_validation_callback);

1541: cmethod=>'POST', cattributes=>'NAME="WF_DETAILS"');
1542:
1543: htp.formhidden('p_lov_name', p_lov_name);
1544: htp.formhidden('p_display_name', p_display_name);
1545: htp.formhidden('p_validation_callback', p_validation_callback);
1546: htp.formhidden('p_dest_hidden_field', p_dest_hidden_field);
1547: htp.formhidden('p_dest_display_field',p_dest_display_field);
1548: htp.formhidden('p_current_value',p_current_value);
1549: htp.formhidden('p_start_row',p_start_row);

Line 1546: htp.formhidden('p_dest_hidden_field', p_dest_hidden_field);

1542:
1543: htp.formhidden('p_lov_name', p_lov_name);
1544: htp.formhidden('p_display_name', p_display_name);
1545: htp.formhidden('p_validation_callback', p_validation_callback);
1546: htp.formhidden('p_dest_hidden_field', p_dest_hidden_field);
1547: htp.formhidden('p_dest_display_field',p_dest_display_field);
1548: htp.formhidden('p_current_value',p_current_value);
1549: htp.formhidden('p_start_row',p_start_row);
1550: htp.formhidden('p_autoquery',p_autoquery);

Line 1547: htp.formhidden('p_dest_display_field',p_dest_display_field);

1543: htp.formhidden('p_lov_name', p_lov_name);
1544: htp.formhidden('p_display_name', p_display_name);
1545: htp.formhidden('p_validation_callback', p_validation_callback);
1546: htp.formhidden('p_dest_hidden_field', p_dest_hidden_field);
1547: htp.formhidden('p_dest_display_field',p_dest_display_field);
1548: htp.formhidden('p_current_value',p_current_value);
1549: htp.formhidden('p_start_row',p_start_row);
1550: htp.formhidden('p_autoquery',p_autoquery);
1551: htp.formhidden('p_language',p_language);

Line 1548: htp.formhidden('p_current_value',p_current_value);

1544: htp.formhidden('p_display_name', p_display_name);
1545: htp.formhidden('p_validation_callback', p_validation_callback);
1546: htp.formhidden('p_dest_hidden_field', p_dest_hidden_field);
1547: htp.formhidden('p_dest_display_field',p_dest_display_field);
1548: htp.formhidden('p_current_value',p_current_value);
1549: htp.formhidden('p_start_row',p_start_row);
1550: htp.formhidden('p_autoquery',p_autoquery);
1551: htp.formhidden('p_language',p_language);
1552:

Line 1549: htp.formhidden('p_start_row',p_start_row);

1545: htp.formhidden('p_validation_callback', p_validation_callback);
1546: htp.formhidden('p_dest_hidden_field', p_dest_hidden_field);
1547: htp.formhidden('p_dest_display_field',p_dest_display_field);
1548: htp.formhidden('p_current_value',p_current_value);
1549: htp.formhidden('p_start_row',p_start_row);
1550: htp.formhidden('p_autoquery',p_autoquery);
1551: htp.formhidden('p_language',p_language);
1552:
1553: if (p_autoquery = 'Y') then

Line 1550: htp.formhidden('p_autoquery',p_autoquery);

1546: htp.formhidden('p_dest_hidden_field', p_dest_hidden_field);
1547: htp.formhidden('p_dest_display_field',p_dest_display_field);
1548: htp.formhidden('p_current_value',p_current_value);
1549: htp.formhidden('p_start_row',p_start_row);
1550: htp.formhidden('p_autoquery',p_autoquery);
1551: htp.formhidden('p_language',p_language);
1552:
1553: if (p_autoquery = 'Y') then
1554:

Line 1551: htp.formhidden('p_language',p_language);

1547: htp.formhidden('p_dest_display_field',p_dest_display_field);
1548: htp.formhidden('p_current_value',p_current_value);
1549: htp.formhidden('p_start_row',p_start_row);
1550: htp.formhidden('p_autoquery',p_autoquery);
1551: htp.formhidden('p_language',p_language);
1552:
1553: if (p_autoquery = 'Y') then
1554:
1555: -- Autoquery or Display hint about selection criteria

Line 1556: htp.p('');
1559:
1560: htp.p('');

Line 1557: htp.p('autoquery()');

1553: if (p_autoquery = 'Y') then
1554:
1555: -- Autoquery or Display hint about selection criteria
1556: htp.p('');
1559:
1560: htp.p('');
1561:

Line 1558: htp.p('');

1554:
1555: -- Autoquery or Display hint about selection criteria
1556: htp.p('');
1559:
1560: htp.p('');
1561:
1562: end if;

Line 1560: htp.p('');

1556: htp.p('');
1559:
1560: htp.p('');
1561:
1562: end if;
1563:
1564: wf_lov.g_define_rec.total_rows := 0;

Line 1619: htp.p('
');

1615: l_result := 0;
1616:
1617: end if;
1618:
1619: htp.p('

');
1620: htp.tableRowOpen;
1621: htp.p('');
1622: if (p_autoquery='Y') then
1623: -- htp.p('');

Line 1620: htp.tableRowOpen;

1616:
1617: end if;
1618:
1619: htp.p('

');
1620: htp.tableRowOpen;
1621: htp.p('');
1622: if (p_autoquery='Y') then
1623: -- htp.p('');
1624: htp.tableRowClose;

Line 1621: htp.p('
');

1617: end if;
1618:
1619: htp.p('

');
1620: htp.tableRowOpen;
1621: htp.p('');
1622: if (p_autoquery='Y') then
1623: -- htp.p('');
1624: htp.tableRowClose;
1625: htp.p('');

Line 1623: -- htp.p('
');

1619: htp.p('

');
1620: htp.tableRowOpen;
1621: htp.p('');
1622: if (p_autoquery='Y') then
1623: -- htp.p('');
1624: htp.tableRowClose;
1625: htp.p('');
1626: htp.p('');
1627: htp.p('');

Line 1624: htp.tableRowClose;

1620: htp.tableRowOpen;
1621: htp.p('

');
1622: if (p_autoquery='Y') then
1623: -- htp.p('');
1624: htp.tableRowClose;
1625: htp.p('');
1626: htp.p('');
1627: htp.p('');
1628: htp.p('');

Line 1625: htp.p('
');

1621: htp.p('

');
1622: if (p_autoquery='Y') then
1623: -- htp.p('');
1624: htp.tableRowClose;
1625: htp.p('');
1626: htp.p('');
1627: htp.p('');
1628: htp.p('');
1629: htp.p('');

Line 1626: htp.p('
');

1622: if (p_autoquery='Y') then
1623: -- htp.p('

');
1624: htp.tableRowClose;
1625: htp.p('');
1626: htp.p('');
1627: htp.p('');
1628: htp.p('');
1629: htp.p('');
1630: htp.p('');

Line 1627: htp.p('
');

1623: -- htp.p('

');
1624: htp.tableRowClose;
1625: htp.p('');
1626: htp.p('');
1627: htp.p('');
1628: htp.p('');
1629: htp.p('');
1630: htp.p('');
1631: elsif (wf_lov.g_define_rec.total_rows=0) then

Line 1628: htp.p('
');

1624: htp.tableRowClose;
1625: htp.p('

');
1626: htp.p('');
1627: htp.p('');
1628: htp.p('');
1629: htp.p('');
1630: htp.p('');
1631: elsif (wf_lov.g_define_rec.total_rows=0) then
1632: wf_core.clear;

Line 1629: htp.p('
');

1625: htp.p('

');
1626: htp.p('');
1627: htp.p('');
1628: htp.p('');
1629: htp.p('');
1630: htp.p('');
1631: elsif (wf_lov.g_define_rec.total_rows=0) then
1632: wf_core.clear;
1633: wf_core.token('NAME', p_display_name);

Line 1630: htp.p('
');

1626: htp.p('

');
1627: htp.p('');
1628: htp.p('');
1629: htp.p('');
1630: htp.p('');
1631: elsif (wf_lov.g_define_rec.total_rows=0) then
1632: wf_core.clear;
1633: wf_core.token('NAME', p_display_name);
1634: wf_core.token('VALUE', p_current_value);

Line 1635: htp.p('
');

1631: elsif (wf_lov.g_define_rec.total_rows=0) then
1632: wf_core.clear;
1633: wf_core.token('NAME', p_display_name);
1634: wf_core.token('VALUE', p_current_value);
1635: htp.p('

');
1636: elsif (wf_lov.g_define_rec.total_rows>0) then
1637:
1638: if (l_result > 0) then
1639:

Line 1645: htp.p('
');

1641: ** Print out the row count for the results in the form of
1642: ** Records: 1 to 15 of 25
1643: */
1644:
1645: htp.p('

');
1646: htp.tableRowClose;
1647: htp.tableRowOpen;
1648: htp.p('');
1649: if (p_start_row is not null) then

Line 1646: htp.tableRowClose;

1642: ** Records: 1 to 15 of 25
1643: */
1644:
1645: htp.p('

');
1646: htp.tableRowClose;
1647: htp.tableRowOpen;
1648: htp.p('');
1649: if (p_start_row is not null) then
1650: l_temp_start_row := to_number(p_start_row);

Line 1647: htp.tableRowOpen;

1643: */
1644:
1645: htp.p('

');
1646: htp.tableRowClose;
1647: htp.tableRowOpen;
1648: htp.p('');
1649: if (p_start_row is not null) then
1650: l_temp_start_row := to_number(p_start_row);
1651: end if;

Line 1648: htp.p('
');

1644:
1645: htp.p('

');
1646: htp.tableRowClose;
1647: htp.tableRowOpen;
1648: htp.p('');
1649: if (p_start_row is not null) then
1650: l_temp_start_row := to_number(p_start_row);
1651: end if;
1652: l_from := to_char(l_temp_start_row);

Line 1662: htp.p('
');

1717:
1718: END IF;
1719:
1720: END IF;
1721: htp.p('');
1722:
1723: htp.tableRowClose;
1724:
1725:

Line 1723: htp.tableRowClose;

1719:
1720: END IF;
1721: htp.p('');
1722:
1723: htp.tableRowClose;
1724:
1725:
1726: -- display table header of LOV
1727: htp.p('

');

Line 1727: htp.p('
');

1723: htp.tableRowClose;
1724:
1725:
1726: -- display table header of LOV
1727: htp.p('

');
1728: htp.p('');
1729: htp.p('
'||wf_core.translate('WFLOV_SEARCH')||'&'||'nbsp;');

Line 1513: htp.p('
');
1515: htp.p('');
1516: htp.p('');
1527: htp.p('');
1528:
1529: -- blue separator
1530: htp.p('');
1531: htp.p('');

Line 1530: htp.p('
');

1526: htp.p('');
1527: htp.p('');
1528:
1529: -- blue separator
1530: htp.p('

');
1531: htp.p('');
1532: htp.p('');
1533: htp.p('');
1536: htp.tableRowClose;
1537:
1538: htp.formClose;
1539: htp.formOpen(curl=>owa_util.get_owa_service_path||
1540: 'wf_lov.display_lov_no_frame',
1541: cmethod=>'POST', cattributes=>'NAME="WF_DETAILS"');
1542:

Line 1539: htp.formOpen(curl=>owa_util.get_owa_service_path||

1535: htp.p('

'||wf_core.translate('WFLOV_SEARCH')||'&'||'nbsp;');
1517: htp.p ('');

Line 1514: htp.p('
');

1510: htp.p('

');
1511:
1512: htp.tableRowOpen;
1513: htp.p('');
1514: htp.p('');
1527: htp.p('');
1528:
1529: -- blue separator
1530: htp.p('');

Line 1527: htp.p('');

1523:
1524: htp.p('

');
1515: htp.p('');
1516: htp.p('');

1511:
1512: htp.tableRowOpen;
1513: htp.p('

');
1514: htp.p('');
1527: htp.p('');
1528:

Line 1526: htp.p('');

1522: -- htp.p(''||wf_core.translate('WFJSP_GO')||'');
1523:
1524: htp.p('

'||wf_core.translate('WFLOV_SEARCH')||'&'||'nbsp;');
1517: htp.p ('');
1518: htp.p('');

Line 1515: htp.p('
');
1515: htp.p('');
1516: htp.p('');
1514: htp.p('
'||wf_core.translate('WFLOV_SEARCH')||'&'||'nbsp;');
1517: htp.p ('');
1518: htp.p('');
1519:

Line 1516: htp.p('
'||wf_core.translate('WFLOV_SEARCH')||'&'||'nbsp;');

1512: htp.tableRowOpen;
1513: htp.p('

');
1515: htp.p('');
1516: htp.p('');
1514: htp.p('');

Line 1524: htp.p('
'||wf_core.translate('WFLOV_SEARCH')||'&'||'nbsp;');
1517: htp.p ('');
1518: htp.p('');
1519:
1520: htp.p(''||wf_core.translate('WFJSP_GO')||'');

Line 1517: htp.p ('');

1513: htp.p('

');
1515: htp.p('');
1516: htp.p('
'||wf_core.translate('WFLOV_SEARCH')||'&'||'nbsp;');
1517: htp.p ('');
1518: htp.p('');
1519:
1520: htp.p(''||wf_core.translate('WFJSP_GO')||'');
1521:

Line 1518: htp.p('');

1514: htp.p('

');
1515: htp.p('');
1516: htp.p('
'||wf_core.translate('WFLOV_SEARCH')||'&'||'nbsp;');
1517: htp.p ('');
1518: htp.p('');
1519:
1520: htp.p(''||wf_core.translate('WFJSP_GO')||'');
1521:
1522: -- htp.p(''||wf_core.translate('WFJSP_GO')||'');

Line 1520: htp.p(''||wf_core.translate('WFJSP_GO')||'');

1516: htp.p('

'||wf_core.translate('WFLOV_SEARCH')||'&'||'nbsp;');
1517: htp.p ('');
1518: htp.p('');
1519:
1520: htp.p(''||wf_core.translate('WFJSP_GO')||'');
1521:
1522: -- htp.p(''||wf_core.translate('WFJSP_GO')||'');
1523:
1524: htp.p('
');

Line 1522: -- htp.p(''||wf_core.translate('WFJSP_GO')||'');

1518: htp.p('');
1519:
1520: htp.p(''||wf_core.translate('WFJSP_GO')||'');
1521:
1522: -- htp.p(''||wf_core.translate('WFJSP_GO')||'');
1523:
1524: htp.p('

');
1525:
1526: htp.p('
');

1520: htp.p(''||wf_core.translate('WFJSP_GO')||'');
1521:
1522: -- htp.p(''||wf_core.translate('WFJSP_GO')||'');
1523:
1524: htp.p('

');
1525:
1526: htp.p('
');
1525:
1526: htp.p('
 
');
1525:
1526: htp.p('
 
 
 
');
1534: htp.p('');

Line 1531: htp.p('
');

1527: htp.p('

');
1528:
1529: -- blue separator
1530: htp.p('');
1531: htp.p('');
1532: htp.p('');
1533: htp.p('');

Line 1532: htp.p('
');

1528:
1529: -- blue separator
1530: htp.p('

');
1531: htp.p('');
1532: htp.p('');
1533: htp.p('');
1536: htp.tableRowClose;

Line 1533: htp.p('
');

1531: htp.p('

');
1532: htp.p('');
1533: htp.p('');
1536: htp.tableRowClose;
1537:
1538: htp.formClose;
1539: htp.formOpen(curl=>owa_util.get_owa_service_path||

Line 1536: htp.tableRowClose;

1532: htp.p('

');
1533: htp.p('');
1536: htp.tableRowClose;
1537:
1538: htp.formClose;
1539: htp.formOpen(curl=>owa_util.get_owa_service_path||
1540: 'wf_lov.display_lov_no_frame',

Line 1538: htp.formClose;

1534: htp.p('

');
1535: htp.p('
 
');
1534: htp.p('');
1535: htp.p('
 
');
1534: htp.p('');
1535: htp.p('
 ');

1529: -- blue separator
1530: htp.p('

');
1531: htp.p('');
1532: htp.p('');
1533: htp.p('');
1536: htp.tableRowClose;
1537:

Line 1534: htp.p('
');

1530: htp.p('

');
1531: htp.p('');
1532: htp.p('');
1533: htp.p('');
1536: htp.tableRowClose;
1537:
1538: htp.formClose;

Line 1535: htp.p('
 
');
1534: htp.p('');
1535: htp.p('
 
');
1534: htp.p('');
1535: htp.p('
');
1534: htp.p('');
1535: htp.p('
 ');
1534: htp.p('');
1535: htp.p('
 
 
'||wf_core.translate('WFLOV_GO')||'
 
'||wf_core.translate('WFLOV_GO')||'
 
'||wf_core.translate('WFLOV_GO')||'
 
'||wf_core.translate('WFLOV_GO')||'
 
'||wf_core.translate('WFLOV_GO')||'
 
 
 
'||wf_core.translate('WFLOV_GO')||'
 
 
 
 
 
'||wf_core.translate('WFLOV_GO')||'
 
 
 
 
 
 
'||wf_core.translate('WFLOV_GO')||'
 
 
 
 
 
 
 
'||wf_core.translate('WFLOV_GO')||'
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
'||wf_core.translate('WFLOV_NO_MATCH')||'
'||wf_core.translate('WFLOV_NO_MATCH')||'
'||wf_core.translate('WFLOV_CLICK')||' '||wf_core.translate('WFLOV_CLICK')||' '||wf_core.translate('WFLOV_CLICK')||' '||wf_core.translate('WFLOV_CLICK')||' '||wf_core.translate('WFLOV_CLICK')||' ');

1658: l_to := TO_CHAR(l_temp_start_row + wf_lov.g_value_tbl.count -1);
1659: end if;
1660:
1661:
1662: htp.p('

');
1663: /*
1664: ** Check to see if you should create the PREVIOUS button
1665: */
1666: IF (TO_NUMBER(p_start_row) > 1) THEN

Line 1683: htp.p(' alt=""');

1679: l_start_row := TO_NUMBER(p_start_row) - p_max_rows;
1680:
1681: END IF;
1682:
1683: htp.p(' alt=""');
1684:
1685: htp.p('');

Line 1685: htp.p(' alt=""');
1684:
1685: htp.p('');
1688: htp.p(wf_core.translate('PREVIOUS')||'');
1689: ELSE

Line 1688: htp.p(wf_core.translate('PREVIOUS')||'');

1684:
1685: htp.p('');
1688: htp.p(wf_core.translate('PREVIOUS')||'');
1689: ELSE
1690: htp.p('' || WF_CORE.Translate('PREVIOUS') || '&'||'nbsp;'||wf_core.translate('PREVIOUS')||'');
1691:
1692: END IF;

Line 1690: htp.p('' || WF_CORE.Translate('PREVIOUS') || '&'||'nbsp;'||wf_core.translate('PREVIOUS')||'');

1686: TO_CHAR(l_start_row)||
1687: ')">');
1688: htp.p(wf_core.translate('PREVIOUS')||'');
1689: ELSE
1690: htp.p('' || WF_CORE.Translate('PREVIOUS') || '&'||'nbsp;'||wf_core.translate('PREVIOUS')||'');
1691:
1692: END IF;
1693: Wf_Core.Clear;
1694: Wf_Core.Token('START_REC', l_from);

Line 1697: htp.p(''||Wf_Core.Translate('PAGE_MSG')||'');

1693: Wf_Core.Clear;
1694: Wf_Core.Token('START_REC', l_from);
1695: Wf_Core.Token('END_REC', l_to);
1696: Wf_Core.Token('TOTAL_REC', TO_CHAR(wf_lov.g_define_rec.total_rows));
1697: htp.p(''||Wf_Core.Translate('PAGE_MSG')||'');
1698:
1699: /*
1700: ** Check to see if you should create the Next button
1701: */

Line 1707: htp.p(' 1708: TO_CHAR(l_start_row)||
1709: ')">');
1710:
1711: htp.p(wf_core.translate('NEXT')||'');

Line 1711: htp.p(wf_core.translate('NEXT')||'');

1707: htp.p('');
1710:
1711: htp.p(wf_core.translate('NEXT')||'');
1712:
1713: htp.p('' || WF_CORE.Translate('NEXT') || '');
1714:
1715: ELSE

Line 1713: htp.p('' || WF_CORE.Translate('NEXT') || '');

1709: ')">');
1710:
1711: htp.p(wf_core.translate('NEXT')||'');
1712:
1713: htp.p('' || WF_CORE.Translate('NEXT') || '');
1714:
1715: ELSE
1716: htp.p('' || WF_CORE.Translate('NEXT') || '&'||'nbsp;'||wf_core.translate('NEXT')||'');
1717:

Line 1716: htp.p('' || WF_CORE.Translate('NEXT') || '&'||'nbsp;'||wf_core.translate('NEXT')||'');

1712:
1713: htp.p('' || WF_CORE.Translate('NEXT') || '');
1714:
1715: ELSE
1716: htp.p('' || WF_CORE.Translate('NEXT') || '&'||'nbsp;'||wf_core.translate('NEXT')||'');
1717:
1718: END IF;
1719:
1720: END IF;

Line 1721: htp.p('
');
1730: htp.p('');
1731: htp.p('');

Line 1728: htp.p('
');

1724:
1725:
1726: -- display table header of LOV
1727: htp.p('

');
1728: htp.p('');
1729: htp.p('');

1917: htp.tableRowClose;
1918: htp.p('

');
1919: -- htp.p('
');
1730: htp.p('');
1731: htp.p('');
1732:

Line 1729: htp.p('
');
1728: htp.p('');
1729: htp.p('
');

1725:
1726: -- display table header of LOV
1727: htp.p('

');
1730: htp.p('');
1731: htp.p('');
1732:
1733:

Line 1730: htp.p('
');

1726: -- display table header of LOV
1727: htp.p('

');
1728: htp.p('');
1729: htp.p('');
1917: htp.tableRowClose;
1918: htp.p('');
1919: -- htp.p('
');
1730: htp.p('');
1731: htp.p('');
1732:
1733:
1734: /*

Line 1731: htp.p('
');

1727: htp.p('

');
1728: htp.p('');
1729: htp.p('');

1916: htp.p('

');
1730: htp.p('');
1731: htp.p('');
1732:
1733:
1734: /*
1735: ** Print out the header

Line 1741: htp.p('
');

1737:
1738: /*
1739: ** get the display name for the attribute
1740: */
1741: htp.p('

');
1742:
1743: htp.p('');
1745:

Line 1743: htp.p('
');
1742:
1743: htp.p('');
1745:
1746: if (wf_lov.g_define_rec.add_attr1_title IS NOT NULL) then
1747:

Line 1748: htp.p('
');
1745:
1746: if (wf_lov.g_define_rec.add_attr1_title IS NOT NULL) then
1747:
1748: htp.p('');
1750:
1751: l_ncols := l_ncols + 1;
1752:

Line 1757: htp.p('
');
1759:
1760: l_ncols := l_ncols + 1;
1761:

Line 1766: htp.p('
');
1768:
1769: l_ncols := l_ncols + 1;
1770:

Line 1775: htp.p('
');
1777:
1778: l_ncols := l_ncols + 1;
1779:

Line 1784: htp.p('
');
1786: l_ncols := l_ncols + 1;
1787:
1788: end if;

Line 1790: htp.tablerowclose;

1786: l_ncols := l_ncols + 1;
1787:
1788: end if;
1789:
1790: htp.tablerowclose;
1791: /*
1792: ** Loop through the data
1793: */
1794: for ii in 1..wf_lov.g_value_tbl.count loop

Line 1798: htp.p('
');

1804: '''','\047')||''''||
1805: ';parent.self.close();">'||wf_core.translate('SELECT')||'

');
1806:
1807: if (l_ncols > 0) then
1808: htp.p('');
1809:
1810: end if;
1811: if (l_ncols > 1) then
1812: htp.p('');

Line 1812: htp.p('
');

1808: htp.p('

');
1809:
1810: end if;
1811: if (l_ncols > 1) then
1812: htp.p('');
1813:
1814: end if;
1815: if (l_ncols > 2) then
1816: htp.p('');

Line 1816: htp.p('
');

1812: htp.p('

');
1813:
1814: end if;
1815: if (l_ncols > 2) then
1816: htp.p('');
1817:
1818: end if;
1819:
1820: if (l_ncols > 3) then

Line 1821: htp.p('
');

1817:
1818: end if;
1819:
1820: if (l_ncols > 3) then
1821: htp.p('

');
1822: end if;
1823:
1824: if (l_ncols > 4) then
1825: htp.p('');

Line 1825: htp.p('
');

1821: htp.p('

');
1822: end if;
1823:
1824: if (l_ncols > 4) then
1825: htp.p('');
1826:
1827: end if;
1828:
1829: htp.tablerowclose;

Line 1829: htp.tablerowclose;

1825: htp.p('

');
1826:
1827: end if;
1828:
1829: htp.tablerowclose;
1830:
1831: end loop;
1832:
1833: htp.tableClose;

Line 1833: htp.tableClose;

1829: htp.tablerowclose;
1830:
1831: end loop;
1832:
1833: htp.tableClose;
1834:
1835: htp.p('');
1836: htp.p('

');
1837:

Line 1835: htp.p('');

1831: end loop;
1832:
1833: htp.tableClose;
1834:
1835: htp.p('');
1836: htp.p('');
1837:
1838: if (wf_lov.g_value_tbl.count > 5) then
1839: htp.tableRowOpen;

Line 1836: htp.p('');

1832:
1833: htp.tableClose;
1834:
1835: htp.p('');
1836: htp.p('');
1837:
1838: if (wf_lov.g_value_tbl.count > 5) then
1839: htp.tableRowOpen;
1840: htp.p('

');

Line 1839: htp.tableRowOpen;

1835: htp.p('');
1836: htp.p('

');
1837:
1838: if (wf_lov.g_value_tbl.count > 5) then
1839: htp.tableRowOpen;
1840: htp.p('');
1841: htp.p('');

1836: htp.p('

');
1837:
1838: if (wf_lov.g_value_tbl.count > 5) then
1839: htp.tableRowOpen;
1840: htp.p('');
1841: htp.p('');
1841: htp.p('');

1899: 'nbsp;'||wf_core.translate('NEXT')||'');
1900:
1901: END IF;
1902:
1903: htp.p('');
1904: htp.tableRowClose;
1905: end if;
1906: end if; -- if (wf_lov.g_define_rec.total_rows=0)
1907: -- htp.tableclose;

Line 1904: htp.tableRowClose;

1900:
1901: END IF;
1902:
1903: htp.p('');
1904: htp.tableRowClose;
1905: end if;
1906: end if; -- if (wf_lov.g_define_rec.total_rows=0)
1907: -- htp.tableclose;
1908:

Line 1907: -- htp.tableclose;

1903: htp.p('');
1904: htp.tableRowClose;
1905: end if;
1906: end if; -- if (wf_lov.g_define_rec.total_rows=0)
1907: -- htp.tableclose;
1908:
1909: -- blue separator
1910: -- htp.p('

&'||'nbsp &'||'nbsp'|| p_display_name ||
1744: '		 '|| p_display_name ||

1739: ** get the display name for the attribute
1740: */
1741: htp.p('

&'||'nbsp '|| p_display_name ||
1744: '		'|| wf_lov.g_define_rec.add_attr1_title||

1744: '

'|| wf_lov.g_define_rec.add_attr1_title||
1749: '		'|| wf_lov.g_define_rec.add_attr2_title||

1753: end if;
1754:
1755: if (wf_lov.g_define_rec.add_attr2_title IS NOT NULL) then
1756:
1757: htp.p('

'|| wf_lov.g_define_rec.add_attr2_title||
1758: '		'|| wf_lov.g_define_rec.add_attr3_title||

1762: end if;
1763:
1764: if (wf_lov.g_define_rec.add_attr3_title IS NOT NULL) then
1765:
1766: htp.p('

'|| wf_lov.g_define_rec.add_attr3_title||
1767: '		'|| wf_lov.g_define_rec.add_attr4_title||

1771: end if;
1772:
1773: if (wf_lov.g_define_rec.add_attr4_title IS NOT NULL) then
1774:
1775: htp.p('

'|| wf_lov.g_define_rec.add_attr4_title||
1776: '		'|| wf_lov.g_define_rec.add_attr5_title||

1780: end if;
1781:
1782: if (wf_lov.g_define_rec.add_attr5_title IS NOT NULL) then
1783:
1784: htp.p('

'|| wf_lov.g_define_rec.add_attr5_title||
1785: '		'||wf_lov.g_value_tbl(ii).add_attr1_value||''||wf_lov.g_value_tbl(ii).display_value||''||wf_lov.g_value_tbl(ii).add_attr1_value||''||wf_lov.g_value_tbl(ii).add_attr2_value||''||wf_lov.g_value_tbl(ii).add_attr2_value||''||wf_lov.g_value_tbl(ii).add_attr1_value||''||wf_lov.g_value_tbl(ii).add_attr2_value||''||wf_lov.g_value_tbl(ii).add_attr3_value||''||wf_lov.g_value_tbl(ii).add_attr3_value||''||wf_lov.g_value_tbl(ii).add_attr2_value||''||wf_lov.g_value_tbl(ii).add_attr3_value||''||wf_lov.g_value_tbl(ii).add_attr4_value||''||wf_lov.g_value_tbl(ii).add_attr4_value||''||wf_lov.g_value_tbl(ii).add_attr5_value||''||wf_lov.g_value_tbl(ii).add_attr5_value||''||wf_lov.g_value_tbl(ii).add_attr4_value||''||wf_lov.g_value_tbl(ii).add_attr5_value||''||wf_lov.g_value_tbl(ii).add_attr5_value||'
');
1842: /*
1843: ** Check to see if you should create the PREVIOUS button

Line 1840: htp.p('
');
1842: /*
1843: ** Check to see if you should create the PREVIOUS button
1844: */

Line 1841: htp.p('
');

1837:
1838: if (wf_lov.g_value_tbl.count > 5) then
1839: htp.tableRowOpen;
1840: htp.p('

');
1842: /*
1843: ** Check to see if you should create the PREVIOUS button
1844: */
1845: IF (TO_NUMBER(p_start_row) > 1) THEN

Line 1862: htp.p('' || WF_CORE.Translate('PREVIOUS') || '');

1858: l_start_row := TO_NUMBER(p_start_row) - p_max_rows;
1859:
1860: END IF;
1861:
1862: htp.p('' || WF_CORE.Translate('PREVIOUS') || '');
1863:
1864: htp.p('');

Line 1864: htp.p('');
1863:
1864: htp.p('');
1867:
1868: htp.p(wf_core.translate('PREVIOUS')||'');

Line 1868: htp.p(wf_core.translate('PREVIOUS')||'');

1864: htp.p('');
1867:
1868: htp.p(wf_core.translate('PREVIOUS')||'');
1869: ELSE
1870: htp.p('&'||'nbsp;'||wf_core.translate('PREVIOUS')||'');
1871:
1872: END IF;

Line 1870: htp.p('&'||'nbsp;'||wf_core.translate('PREVIOUS')||'');

1866: ')">');
1867:
1868: htp.p(wf_core.translate('PREVIOUS')||'');
1869: ELSE
1870: htp.p('&'||'nbsp;'||wf_core.translate('PREVIOUS')||'');
1871:
1872: END IF;
1873:
1874:

Line 1879: htp.p(''||Wf_Core.Translate('PAGE_MSG')||'');

1875: Wf_Core.Clear;
1876: Wf_Core.Token('START_REC', l_from);
1877: Wf_Core.Token('END_REC', l_to);
1878: Wf_Core.Token('TOTAL_REC', TO_CHAR(wf_lov.g_define_rec.total_rows));
1879: htp.p(''||Wf_Core.Translate('PAGE_MSG')||'');
1880:
1881: /*
1882: ** Check to see if you should create the Next button
1883: */

Line 1890: htp.p(' 1891: TO_CHAR(l_start_row)||
1892: ')">');
1893:
1894: htp.p(wf_core.translate('NEXT')||'');

Line 1894: htp.p(wf_core.translate('NEXT')||'');

1890: htp.p('');
1893:
1894: htp.p(wf_core.translate('NEXT')||'');
1895:
1896: htp.p('' || WF_CORE.Translate('NEXT') || '');
1897: ELSE
1898: htp.p('' || WF_CORE.Translate('NEXT') || '&'||

Line 1896: htp.p('' || WF_CORE.Translate('NEXT') || '');

1892: ')">');
1893:
1894: htp.p(wf_core.translate('NEXT')||'');
1895:
1896: htp.p('' || WF_CORE.Translate('NEXT') || '');
1897: ELSE
1898: htp.p('' || WF_CORE.Translate('NEXT') || '&'||
1899: 'nbsp;'||wf_core.translate('NEXT')||'');
1900:

Line 1898: htp.p('' || WF_CORE.Translate('NEXT') || '&'||

1894: htp.p(wf_core.translate('NEXT')||'');
1895:
1896: htp.p('' || WF_CORE.Translate('NEXT') || '');
1897: ELSE
1898: htp.p('' || WF_CORE.Translate('NEXT') || '&'||
1899: 'nbsp;'||wf_core.translate('NEXT')||'');
1900:
1901: END IF;
1902:

Line 1903: htp.p('
');
1911: htp.p('');

Line 1910: -- htp.p('
 
');

1906: end if; -- if (wf_lov.g_define_rec.total_rows=0)
1907: -- htp.tableclose;
1908:
1909: -- blue separator
1910: -- htp.p('

');
1911: htp.p('');
1912: htp.p('');
1913: htp.p('');
1914: htp.p('
 
');

Line 1911: htp.p('
');

1907: -- htp.tableclose;
1908:
1909: -- blue separator
1910: -- htp.p('

 
');
1911: htp.p('');
1912: htp.p('');
1913: htp.p('');
1914: htp.p('');
1917: htp.tableRowClose;
1918: htp.p('');
1919: -- htp.p('
 
');
1915: htp.p('');

Line 1912: htp.p('
');

1908:
1909: -- blue separator
1910: -- htp.p('

');
1911: htp.p('');
1912: htp.p('');
1913: htp.p('');
1914: htp.p('');

Line 1913: htp.p('
');

1909: -- blue separator
1910: -- htp.p('

 
');
1915: htp.p('');
1916: htp.p('
');
1911: htp.p('');
1912: htp.p('');
1913: htp.p('');
1914: htp.p('');
1917: htp.tableRowClose;

Line 1914: htp.p('
');

1912: htp.p('

');
1913: htp.p('');
1914: htp.p('');
1917: htp.tableRowClose;
1918: htp.p('');
1919: -- htp.p('
 
');
1915: htp.p('');
1916: htp.p('
 ');

1910: -- htp.p('

');
1911: htp.p('');
1912: htp.p('');
1913: htp.p('');
1914: htp.p('');
1917: htp.tableRowClose;
1918: htp.p('');

Line 1915: htp.p('
');

1911: htp.p('

');
1912: htp.p('');
1913: htp.p('');
1914: htp.p('');
1917: htp.tableRowClose;
1918: htp.p('');
1919: -- htp.p('
 
');
1915: htp.p('');
1916: htp.p('
 
 
');
1915: htp.p('');
1916: htp.p('
 
');

Line 1916: htp.p('
');
1915: htp.p('');
1916: htp.p('
 
');
1920: htp.p('');

Line 1917: htp.tableRowClose;

1913: htp.p('

');
1914: htp.p('');
1917: htp.tableRowClose;
1918: htp.p('');
1919: -- htp.p('
');
1915: htp.p('');
1916: htp.p('
 
');
1920: htp.p('');
1921: htp.p('');

Line 1918: htp.p('
');

1914: htp.p('

');
1917: htp.tableRowClose;
1918: htp.p('');
1919: -- htp.p('
 
');
1915: htp.p('');
1916: htp.p('
 
');
1920: htp.p('');
1921: htp.p('');
1922: htp.p('
'||wf_core.translate('CANCEL')||'
');

Line 1919: -- htp.p('');

1915: htp.p('

');
1916: htp.p('
 
');
1920: htp.p('');
1921: htp.p('');
1922: htp.p('
'||wf_core.translate('CANCEL')||'
');
1923: -- htp.p('		'||wf_core.translate('CANCEL')||'
');

Line 1920: htp.p('
 
');
1920: htp.p('');
1921: htp.p('');
1922: htp.p('
'||wf_core.translate('CANCEL')||'
');
1923: -- htp.p('		'||wf_core.translate('CANCEL')||'
');
1924: htp.formClose;

Line 1921: htp.p('
 
');
1920: htp.p('');
1921: htp.p('');
1922: htp.p('
'||wf_core.translate('CANCEL')||'
');
1923: -- htp.p('		'||wf_core.translate('CANCEL')||'
');
1924: htp.formClose;
1925: htp.bodyclose;

Line 1922: htp.p('
'||wf_core.translate('CANCEL')||'
');

1918: htp.p('

 
');
1920: htp.p('');
1921: htp.p('');
1922: htp.p('
'||wf_core.translate('CANCEL')||'
');
1923: -- htp.p('

'||wf_core.translate('CANCEL')||'
');
1924: htp.formClose;
1925: htp.bodyclose;
1926: htp.htmlclose;

Line 1923: -- htp.p(''||wf_core.translate('CANCEL')||'');

1919: -- htp.p('');
1920: htp.p('');
1921: htp.p('');
1922: htp.p('
'||wf_core.translate('CANCEL')||'
');
1923: -- htp.p(''||wf_core.translate('CANCEL')||'');
1924: htp.formClose;
1925: htp.bodyclose;
1926: htp.htmlclose;
1927:

Line 1924: htp.formClose;

1920: htp.p('');
1921: htp.p('');
1922: htp.p(''||wf_core.translate('CANCEL')||'');
1923: -- htp.p(''||wf_core.translate('CANCEL')||'');
1924: htp.formClose;
1925: htp.bodyclose;
1926: htp.htmlclose;
1927:
1928:

Line 1925: htp.bodyclose;

1921: htp.p('');
1922: htp.p(''||wf_core.translate('CANCEL')||'');
1923: -- htp.p(''||wf_core.translate('CANCEL')||'');
1924: htp.formClose;
1925: htp.bodyclose;
1926: htp.htmlclose;
1927:
1928:
1929: exception

Line 1926: htp.htmlclose;

1922: htp.p(''||wf_core.translate('CANCEL')||'');
1923: -- htp.p(''||wf_core.translate('CANCEL')||'');
1924: htp.formClose;
1925: htp.bodyclose;
1926: htp.htmlclose;
1927:
1928:
1929: exception
1930: when others then