303:
304: end loop;
305:
306: -- Render page
307: htp.htmlOpen;
308:
309: -- Set page title
310: htp.headOpen;
311:
306: -- Render page
307: htp.htmlOpen;
308:
309: -- Set page title
310: htp.headOpen;
311:
312: -- list does not get updated after editevent, so we add the
313: -- following tag to force the reload of page.
314: htp.p('');
310: htp.headOpen;
311:
312: -- list does not get updated after editevent, so we add the
313: -- following tag to force the reload of page.
314: htp.p('');
315:
316: htp.title(wf_core.translate('WFE_LIST_EVENTS_TITLE'));
317: wfa_html.create_help_function('wf/links/def.htm?'||'DEFEVT');
318: fnd_document_management.get_open_dm_display_window;
312: -- list does not get updated after editevent, so we add the
313: -- following tag to force the reload of page.
314: htp.p('');
315:
316: htp.title(wf_core.translate('WFE_LIST_EVENTS_TITLE'));
317: wfa_html.create_help_function('wf/links/def.htm?'||'DEFEVT');
318: fnd_document_management.get_open_dm_display_window;
319:
320: Wfe_Html_Util.generate_confirm;
318: fnd_document_management.get_open_dm_display_window;
319:
320: Wfe_Html_Util.generate_confirm;
321:
322: htp.headClose;
323:
324: -- Page header
325: wfa_sec.Header(FALSE,
326: owa_util.get_owa_service_path||'wf_event_html.FindEvent',
326: owa_util.get_owa_service_path||'wf_event_html.FindEvent',
327: wf_core.translate('WFE_LIST_EVENTS_TITLE'),
328: TRUE);
329:
330: htp.br; -- add some space between header and table
331:
332: -- populate the header table
333: i := 1;
334: hTab(i).def_type := 'FUNCTION';
366:
367: -- render table
368: Wfe_Html_Util.Simple_Table(hTab, dTab);
369:
370: htp.tableopen (calign=>'CENTER ', cattributes=>'summary""');
371: htp.tableRowOpen;
372: htp.p('
367: -- render table
368: Wfe_Html_Util.Simple_Table(hTab, dTab);
369:
370: htp.tableopen (calign=>'CENTER ', cattributes=>'summary""');
371: htp.tableRowOpen;
372: htp.p('
368: Wfe_Html_Util.Simple_Table(hTab, dTab);
369:
370: htp.tableopen (calign=>'CENTER ', cattributes=>'summary""');
371: htp.tableRowOpen;
372: htp.p('
374: wf_core.translate('WFE_ADD_EVENT'),
375: wfa_html.image_loc,
376: null,
377: wf_core.translate('WFE_ADD_EVENT'));
378: htp.p('
375: wfa_html.image_loc,
376: null,
377: wf_core.translate('WFE_ADD_EVENT'));
378: htp.p('
382: wf_core.translate('WFE_ADD_GROUP'),
383: wfa_html.image_loc,
384: null,
385: wf_core.translate('WFE_ADD_GROUP'));
386: htp.p('
383: wfa_html.image_loc,
384: null,
385: wf_core.translate('WFE_ADD_GROUP'));
386: htp.p('');
387: htp.tableRowClose;
388: htp.tableClose;
389:
390: wfa_sec.Footer;
391: htp.htmlClose;
384: null,
385: wf_core.translate('WFE_ADD_GROUP'));
386: htp.p('');
387: htp.tableRowClose;
388: htp.tableClose;
389:
390: wfa_sec.Footer;
391: htp.htmlClose;
392:
387: htp.tableRowClose;
388: htp.tableClose;
389:
390: wfa_sec.Footer;
391: htp.htmlClose;
392:
393: exception
394: when OTHERS then
395: rollback;
569: dTab(i).hasdetail := TRUE;
570: end if;
571: end loop;
572: -- Render page
573: htp.htmlOpen;
574:
575: -- Set page title
576: htp.headOpen;
577:
572: -- Render page
573: htp.htmlOpen;
574:
575: -- Set page title
576: htp.headOpen;
577:
578: -- list does not get updated after editevent, so we add the
579: -- following tag to force the reload of page.
580: htp.p('');
576: htp.headOpen;
577:
578: -- list does not get updated after editevent, so we add the
579: -- following tag to force the reload of page.
580: htp.p('');
581:
582: htp.title(wf_core.translate('WFE_LIST_SYSTEMS_TITLE'));
583: wfa_html.create_help_function('wf/links/def.htm?'||'DEFEVSYS');
584: fnd_document_management.get_open_dm_display_window;
578: -- list does not get updated after editevent, so we add the
579: -- following tag to force the reload of page.
580: htp.p('');
581:
582: htp.title(wf_core.translate('WFE_LIST_SYSTEMS_TITLE'));
583: wfa_html.create_help_function('wf/links/def.htm?'||'DEFEVSYS');
584: fnd_document_management.get_open_dm_display_window;
585:
586: Wfe_Html_Util.generate_confirm;
584: fnd_document_management.get_open_dm_display_window;
585:
586: Wfe_Html_Util.generate_confirm;
587:
588: htp.headClose;
589:
590: -- Page header
591: wfa_sec.Header(FALSE,
592: owa_util.get_owa_service_path||'wf_event_html.FindSystem',
592: owa_util.get_owa_service_path||'wf_event_html.FindSystem',
593: wf_core.translate('WFE_LIST_SYSTEMS_TITLE'),
594: TRUE);
595:
596: htp.br; -- add some space between header and table
597:
598: -- popluate the header table
599: i := 1;
600: hTab(i).def_type := 'FUNCTION';
631: tabattr=>'border=1 cellpadding=3 bgcolor=white width=100% summary="' ||
632: wf_core.translate('WFE_LIST_SYSTEMS_TITLE') || '"');
633:
634: -- message to indicate local system
635: htp.tableopen(calign=>'CENTER', cattributes=>'WIDTH=100%
636: summary="' || wf_core.translate('WFE_INDICATE_LOCAL_SYS') || '"');
637: htp.tableRowOpen;
638: htp.p('
633:
634: -- message to indicate local system
635: htp.tableopen(calign=>'CENTER', cattributes=>'WIDTH=100%
636: summary="' || wf_core.translate('WFE_INDICATE_LOCAL_SYS') || '"');
637: htp.tableRowOpen;
638: htp.p('
634: -- message to indicate local system
635: htp.tableopen(calign=>'CENTER', cattributes=>'WIDTH=100%
636: summary="' || wf_core.translate('WFE_INDICATE_LOCAL_SYS') || '"');
637: htp.tableRowOpen;
638: htp.p('
635: htp.tableopen(calign=>'CENTER', cattributes=>'WIDTH=100%
636: summary="' || wf_core.translate('WFE_INDICATE_LOCAL_SYS') || '"');
637: htp.tableRowOpen;
638: htp.p('
636: summary="' || wf_core.translate('WFE_INDICATE_LOCAL_SYS') || '"');
637: htp.tableRowOpen;
638: htp.p('
637: htp.tableRowOpen;
638: htp.p('
638: htp.p('
640: htp.p('
641: htp.tableRowClose;
642: htp.tableClose;
643:
644: htp.tableopen (calign=>'CENTER', cattributes=>'summary=""');
645: htp.tableRowOpen;
646: htp.p('
642: htp.tableClose;
643:
644: htp.tableopen (calign=>'CENTER', cattributes=>'summary=""');
645: htp.tableRowOpen;
646: htp.p('
648: wf_core.translate('WFE_ADD_SYSTEM'),
649: wfa_html.image_loc,
650: null,
651: wf_core.translate('WFE_ADD_SYSTEM'));
652: htp.p('
649: wfa_html.image_loc,
650: null,
651: wf_core.translate('WFE_ADD_SYSTEM'));
652: htp.p('');
653: htp.tableRowClose;
654: htp.tableClose;
655:
656: wfa_sec.Footer;
657: htp.htmlClose;
650: null,
651: wf_core.translate('WFE_ADD_SYSTEM'));
652: htp.p('');
653: htp.tableRowClose;
654: htp.tableClose;
655:
656: wfa_sec.Footer;
657: htp.htmlClose;
658:
653: htp.tableRowClose;
654: htp.tableClose;
655:
656: wfa_sec.Footer;
657: htp.htmlClose;
658:
659: exception
660: when OTHERS then
661: rollback;
867:
868: end loop;
869:
870: -- Render page
871: htp.htmlOpen;
872:
873: -- Set page title
874: htp.headOpen;
875:
870: -- Render page
871: htp.htmlOpen;
872:
873: -- Set page title
874: htp.headOpen;
875:
876: -- list does not get updated after editevent, so we add the
877: -- following tag to force the reload of page.
878: htp.p('');
874: htp.headOpen;
875:
876: -- list does not get updated after editevent, so we add the
877: -- following tag to force the reload of page.
878: htp.p('');
879:
880: htp.title(wf_core.translate('WFE_LIST_AGENTS_TITLE'));
881: wfa_html.create_help_function('wf/links/def.htm?'||'DEFEVAGT');
882: fnd_document_management.get_open_dm_display_window;
876: -- list does not get updated after editevent, so we add the
877: -- following tag to force the reload of page.
878: htp.p('');
879:
880: htp.title(wf_core.translate('WFE_LIST_AGENTS_TITLE'));
881: wfa_html.create_help_function('wf/links/def.htm?'||'DEFEVAGT');
882: fnd_document_management.get_open_dm_display_window;
883:
884: Wfe_Html_Util.generate_confirm;
882: fnd_document_management.get_open_dm_display_window;
883:
884: Wfe_Html_Util.generate_confirm;
885:
886: htp.headClose;
887:
888: -- Page header
889: wfa_sec.Header(FALSE,
890: owa_util.get_owa_service_path||'wf_event_html.FindAgent',
890: owa_util.get_owa_service_path||'wf_event_html.FindAgent',
891: wf_core.translate('WFE_LIST_AGENTS_TITLE'),
892: TRUE);
893:
894: htp.br; -- add some space between header and table
895:
896: -- popluate the header table
897: i := 1;
898: hTab(i).def_type := 'FUNCTION';
961: summary="' || wf_core.translate('WFE_LIST_AGENTS_TITLE') || '"',
962: show_1st_title=>FALSE);
963: end if;
964:
965: htp.tableopen (calign=>'CENTER', cattributes=>'summary=""');
966: htp.tableRowOpen;
967: htp.p('
962: show_1st_title=>FALSE);
963: end if;
964:
965: htp.tableopen (calign=>'CENTER', cattributes=>'summary=""');
966: htp.tableRowOpen;
967: htp.p('
963: end if;
964:
965: htp.tableopen (calign=>'CENTER', cattributes=>'summary=""');
966: htp.tableRowOpen;
967: htp.p('
969: wf_core.translate('WFE_ADD_AGENT'),
970: wfa_html.image_loc,
971: null,
972: wf_core.translate('WFE_ADD_AGENT'));
973: htp.p('
970: wfa_html.image_loc,
971: null,
972: wf_core.translate('WFE_ADD_AGENT'));
973: htp.p('');
974: htp.tableRowClose;
975: htp.tableClose;
976:
977: wfa_sec.Footer;
978: htp.htmlClose;
971: null,
972: wf_core.translate('WFE_ADD_AGENT'));
973: htp.p('');
974: htp.tableRowClose;
975: htp.tableClose;
976:
977: wfa_sec.Footer;
978: htp.htmlClose;
979:
974: htp.tableRowClose;
975: htp.tableClose;
976:
977: wfa_sec.Footer;
978: htp.htmlClose;
979:
980: exception
981: when OTHERS then
982: rollback;
1357:
1358: end loop;
1359:
1360: -- Render page
1361: htp.htmlOpen;
1362:
1363: -- Set page title
1364: htp.headOpen;
1365:
1360: -- Render page
1361: htp.htmlOpen;
1362:
1363: -- Set page title
1364: htp.headOpen;
1365:
1366: -- list does not get updated after editevent, so we add the
1367: -- following tag to force the reload of page.
1368: htp.p('');
1364: htp.headOpen;
1365:
1366: -- list does not get updated after editevent, so we add the
1367: -- following tag to force the reload of page.
1368: htp.p('');
1369:
1370: htp.title(wf_core.translate('WFE_LIST_SUBSC_TITLE'));
1371: wfa_html.create_help_function('wf/links/def.htm?'||'DEFEVSUB');
1372: fnd_document_management.get_open_dm_display_window;
1366: -- list does not get updated after editevent, so we add the
1367: -- following tag to force the reload of page.
1368: htp.p('');
1369:
1370: htp.title(wf_core.translate('WFE_LIST_SUBSC_TITLE'));
1371: wfa_html.create_help_function('wf/links/def.htm?'||'DEFEVSUB');
1372: fnd_document_management.get_open_dm_display_window;
1373:
1374: Wfe_Html_Util.generate_confirm;
1372: fnd_document_management.get_open_dm_display_window;
1373:
1374: Wfe_Html_Util.generate_confirm;
1375:
1376: htp.headClose;
1377:
1378: -- Page header
1379: wfa_sec.Header(FALSE,
1380: owa_util.get_owa_service_path||'wf_event_html.FindSubscription',
1380: owa_util.get_owa_service_path||'wf_event_html.FindSubscription',
1381: wf_core.translate('WFE_LIST_SUBSC_TITLE'),
1382: TRUE);
1383:
1384: htp.br; -- add some space between header and table
1385:
1386: -- popluate the header table
1387: i := 1;
1388: hTab(i).def_type := 'FUNCTION';
1478: wf_core.translate('WFE_LIST_SUBSC_TITLE') || '"',
1479: show_1st_title=>FALSE);
1480: end if;
1481:
1482: htp.tableopen (calign=>'CENTER', cattributes=>'summary=""');
1483: htp.tableRowOpen;
1484: htp.p('
1479: show_1st_title=>FALSE);
1480: end if;
1481:
1482: htp.tableopen (calign=>'CENTER', cattributes=>'summary=""');
1483: htp.tableRowOpen;
1484: htp.p('
1480: end if;
1481:
1482: htp.tableopen (calign=>'CENTER', cattributes=>'summary=""');
1483: htp.tableRowOpen;
1484: htp.p('
1498: wf_core.translate('WFE_ADD_SUBSCRIPTION'),
1499: wfa_html.image_loc,
1500: null,
1501: wf_core.translate('WFE_ADD_SUBSCRIPTION'));
1502: htp.p('
1499: wfa_html.image_loc,
1500: null,
1501: wf_core.translate('WFE_ADD_SUBSCRIPTION'));
1502: htp.p('');
1503: htp.tableRowClose;
1504: htp.tableClose;
1505:
1506: wfa_sec.Footer;
1507: htp.htmlClose;
1500: null,
1501: wf_core.translate('WFE_ADD_SUBSCRIPTION'));
1502: htp.p('');
1503: htp.tableRowClose;
1504: htp.tableClose;
1505:
1506: wfa_sec.Footer;
1507: htp.htmlClose;
1508:
1503: htp.tableRowClose;
1504: htp.tableClose;
1505:
1506: wfa_sec.Footer;
1507: htp.htmlClose;
1508:
1509: exception
1510: when OTHERS then
1511: rollback;
1659: l_customization_level := 'U';
1660: end if;
1661:
1662: -- Set page title
1663: htp.htmlOpen;
1664: htp.headOpen;
1665:
1666: -- list does not get updated after editevent, so we add the
1667: -- following tag to force the reload of page.
1660: end if;
1661:
1662: -- Set page title
1663: htp.htmlOpen;
1664: htp.headOpen;
1665:
1666: -- list does not get updated after editevent, so we add the
1667: -- following tag to force the reload of page.
1668: htp.p('');
1664: htp.headOpen;
1665:
1666: -- list does not get updated after editevent, so we add the
1667: -- following tag to force the reload of page.
1668: htp.p('');
1669:
1670: htp.title(wf_core.translate('WFE_EDIT_'||l_type||'_TITLE'));
1671: if (l_type <> 'EVENT') then
1672: wfa_html.create_help_function('wf/links/t_d.htm?T_DEFEVGPM');
1666: -- list does not get updated after editevent, so we add the
1667: -- following tag to force the reload of page.
1668: htp.p('');
1669:
1670: htp.title(wf_core.translate('WFE_EDIT_'||l_type||'_TITLE'));
1671: if (l_type <> 'EVENT') then
1672: wfa_html.create_help_function('wf/links/t_d.htm?T_DEFEVGPM');
1673: else
1674: wfa_html.create_help_function('wf/links/t_d.htm?T_DEFEVT');
1677: fnd_document_management.get_open_dm_display_window;
1678:
1679: Wfe_Html_Util.generate_check_all;
1680:
1681: htp.headClose;
1682:
1683: -- Page header
1684: wfa_sec.Header(FALSE,
1685: owa_util.get_owa_service_path||'wf_event_html.FindEvent',
1686: wf_core.translate('WFE_EDIT_'||l_type||'_TITLE'),
1687: TRUE);
1688:
1689: -- Form
1690: htp.formOpen(curl=>owa_util.get_owa_service_path||
1691: 'wf_event_html.SubmitEvent',
1692: cmethod=>'Get',
1693: cattributes=>'TARGET="_top" NAME="WF_EVENT_EDIT"');
1694:
1694:
1695: -- GUID
1696: -- do not display it if it is null
1697: if (h_guid is not null) then
1698: htp.p('');
1699: end if;
1700: htp.formHidden('h_guid', rawtohex(h_guid));
1701:
1702: htp.tableOpen(calign=>'CENTER', cattributes=>'border=0 summary=""');
1696: -- do not display it if it is null
1697: if (h_guid is not null) then
1698: htp.p('');
1699: end if;
1700: htp.formHidden('h_guid', rawtohex(h_guid));
1701:
1702: htp.tableOpen(calign=>'CENTER', cattributes=>'border=0 summary=""');
1703:
1704: -- Name
1698: htp.p('');
1699: end if;
1700: htp.formHidden('h_guid', rawtohex(h_guid));
1701:
1702: htp.tableOpen(calign=>'CENTER', cattributes=>'border=0 summary=""');
1703:
1704: -- Name
1705: htp.tableRowOpen;
1706: htp.tableData(cvalue=>'
1701:
1702: htp.tableOpen(calign=>'CENTER', cattributes=>'border=0 summary=""');
1703:
1704: -- Name
1705: htp.tableRowOpen;
1706: htp.tableData(cvalue=>'', calign=>'Right',
1709: cattributes=>'id=""');
1702: htp.tableOpen(calign=>'CENTER', cattributes=>'border=0 summary=""');
1703:
1704: -- Name
1705: htp.tableRowOpen;
1706: htp.tableData(cvalue=>'1707: wf_core.translate('NAME') ||
1708: '', calign=>'Right',
1709: cattributes=>'id=""');
1710: htp.tableData(cvalue=>htf.formText(cname=>'h_name', csize=>40,
1706: htp.tableData(cvalue=>'', calign=>'Right',
1709: cattributes=>'id=""');
1710: htp.tableData(cvalue=>htf.formText(cname=>'h_name', csize=>40,
1711: cmaxlength=>240,
1712: cvalue=>l_name,
1713: cattributes=>'id="i_name"'),
1714: calign=>'Left',
1713: cattributes=>'id="i_name"'),
1714: calign=>'Left',
1715: cattributes=>'id=""');
1716:
1717: htp.tableRowClose;
1718:
1719: -- Display Name
1720: htp.tableRowOpen;
1721: htp.tableData(cvalue=>'
1716:
1717: htp.tableRowClose;
1718:
1719: -- Display Name
1720: htp.tableRowOpen;
1721: htp.tableData(cvalue=>'',
1723: calign=>'Right', cattributes=>'id=""');
1724: htp.tableData(cvalue=>htf.formText(cname=>'h_display_name', csize=>60,
1717: htp.tableRowClose;
1718:
1719: -- Display Name
1720: htp.tableRowOpen;
1721: htp.tableData(cvalue=>'1722: wf_core.translate('DISPLAY_NAME') || '',
1723: calign=>'Right', cattributes=>'id=""');
1724: htp.tableData(cvalue=>htf.formText(cname=>'h_display_name', csize=>60,
1725: cmaxlength=>80,
1720: htp.tableRowOpen;
1721: htp.tableData(cvalue=>'',
1723: calign=>'Right', cattributes=>'id=""');
1724: htp.tableData(cvalue=>htf.formText(cname=>'h_display_name', csize=>60,
1725: cmaxlength=>80,
1726: cattributes=>'id="i_display_name"'),
1727: calign=>'Left',cattributes=>'id=""');
1728: htp.tableRowClose;
1724: htp.tableData(cvalue=>htf.formText(cname=>'h_display_name', csize=>60,
1725: cmaxlength=>80,
1726: cattributes=>'id="i_display_name"'),
1727: calign=>'Left',cattributes=>'id=""');
1728: htp.tableRowClose;
1729:
1730: -- Description
1731: htp.tableRowOpen;
1732: htp.tableData(cvalue=>'
1727: calign=>'Left',cattributes=>'id=""');
1728: htp.tableRowClose;
1729:
1730: -- Description
1731: htp.tableRowOpen;
1732: htp.tableData(cvalue=>'', calign=>'Right',
1734: cattributes=>'id=""');
1735: htp.tableData(cvalue=>htf.formTextareaOpen2(
1728: htp.tableRowClose;
1729:
1730: -- Description
1731: htp.tableRowOpen;
1732: htp.tableData(cvalue=>'1733: wf_core.translate('DESCRIPTION') || '', calign=>'Right',
1734: cattributes=>'id=""');
1735: htp.tableData(cvalue=>htf.formTextareaOpen2(
1736: cname=>'h_description',
1731: htp.tableRowOpen;
1732: htp.tableData(cvalue=>'', calign=>'Right',
1734: cattributes=>'id=""');
1735: htp.tableData(cvalue=>htf.formTextareaOpen2(
1736: cname=>'h_description',
1737: nrows=>2,
1738: ncolumns=>60,
1739: cwrap=>'SOFT',
1740: cattributes=>'maxlength=2000 id="i_description"')
1741: ||l_desc
1742: ||htf.formTextareaClose,
1743: calign=>'Left',cattributes=>'id=""');
1744: htp.tableRowClose;
1745:
1746: -- Type
1747: template := wf_core.translate(l_type);
1748: htp.formHidden('h_type', l_type);
1744: htp.tableRowClose;
1745:
1746: -- Type
1747: template := wf_core.translate(l_type);
1748: htp.formHidden('h_type', l_type);
1749:
1750: -- Status
1751: template := htf.formSelectOpen('h_status',cattributes=>'id="i_status"')
1752: ||wf_core.newline||
1756: htf.formSelectOption(wf_core.translate('DISABLED'),
1757: select_disable,'VALUE="DISABLED"')
1758: ||wf_core.newline||
1759: htf.formSelectClose;
1760: htp.tableRowOpen;
1761: htp.tableData(cvalue=>'',
1763: calign=>'Right',cattributes=>'id=""');
1764: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
1757: select_disable,'VALUE="DISABLED"')
1758: ||wf_core.newline||
1759: htf.formSelectClose;
1760: htp.tableRowOpen;
1761: htp.tableData(cvalue=>'1762: wf_core.translate('STATUS') || '',
1763: calign=>'Right',cattributes=>'id=""');
1764: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
1765: htp.tableRowClose;
1760: htp.tableRowOpen;
1761: htp.tableData(cvalue=>'',
1763: calign=>'Right',cattributes=>'id=""');
1764: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
1765: htp.tableRowClose;
1766:
1767: -- Generate Function
1768: -- no generate function for group
1761: htp.tableData(cvalue=>'',
1763: calign=>'Right',cattributes=>'id=""');
1764: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
1765: htp.tableRowClose;
1766:
1767: -- Generate Function
1768: -- no generate function for group
1769: if (l_type <> 'GROUP') then
1766:
1767: -- Generate Function
1768: -- no generate function for group
1769: if (l_type <> 'GROUP') then
1770: htp.tableRowOpen;
1771: htp.tableData(cvalue=>'',
1773: calign=>'Right',cattributes=>'id=""');
1774: htp.tableData(cvalue=>htf.formText(cname=>'h_generate_function', csize=>60,
1767: -- Generate Function
1768: -- no generate function for group
1769: if (l_type <> 'GROUP') then
1770: htp.tableRowOpen;
1771: htp.tableData(cvalue=>'1772: wf_core.translate('GENERATE_FUNCTION') || '',
1773: calign=>'Right',cattributes=>'id=""');
1774: htp.tableData(cvalue=>htf.formText(cname=>'h_generate_function', csize=>60,
1775: cmaxlength=>240, cvalue=>l_gfunc,
1770: htp.tableRowOpen;
1771: htp.tableData(cvalue=>'',
1773: calign=>'Right',cattributes=>'id=""');
1774: htp.tableData(cvalue=>htf.formText(cname=>'h_generate_function', csize=>60,
1775: cmaxlength=>240, cvalue=>l_gfunc,
1776: cattributes=>'id="i_generate_function"'),
1777: calign=>'Left',cattributes=>'id=""');
1778: htp.tableRowClose;
1774: htp.tableData(cvalue=>htf.formText(cname=>'h_generate_function', csize=>60,
1775: cmaxlength=>240, cvalue=>l_gfunc,
1776: cattributes=>'id="i_generate_function"'),
1777: calign=>'Left',cattributes=>'id=""');
1778: htp.tableRowClose;
1779: else
1780: htp.formHidden('h_generate_function', null);
1781: end if;
1782:
1776: cattributes=>'id="i_generate_function"'),
1777: calign=>'Left',cattributes=>'id=""');
1778: htp.tableRowClose;
1779: else
1780: htp.formHidden('h_generate_function', null);
1781: end if;
1782:
1783: -- Owner Name
1784: htp.tableRowOpen;
1780: htp.formHidden('h_generate_function', null);
1781: end if;
1782:
1783: -- Owner Name
1784: htp.tableRowOpen;
1785: htp.tableData(cvalue=>'',
1787: calign=>'Right',cattributes=>'id=""');
1788: htp.tableData(cvalue=>htf.formText(cname=>'h_owner_name', csize=>30,
1781: end if;
1782:
1783: -- Owner Name
1784: htp.tableRowOpen;
1785: htp.tableData(cvalue=>'1786: wf_core.translate('OWNER_NAME') || '',
1787: calign=>'Right',cattributes=>'id=""');
1788: htp.tableData(cvalue=>htf.formText(cname=>'h_owner_name', csize=>30,
1789: cmaxlength=>30,
1784: htp.tableRowOpen;
1785: htp.tableData(cvalue=>'',
1787: calign=>'Right',cattributes=>'id=""');
1788: htp.tableData(cvalue=>htf.formText(cname=>'h_owner_name', csize=>30,
1789: cmaxlength=>30,
1790: cattributes=>'id="i_owner_name"'),
1791: calign=>'Left',cattributes=>'id=""');
1792: htp.tableRowClose;
1788: htp.tableData(cvalue=>htf.formText(cname=>'h_owner_name', csize=>30,
1789: cmaxlength=>30,
1790: cattributes=>'id="i_owner_name"'),
1791: calign=>'Left',cattributes=>'id=""');
1792: htp.tableRowClose;
1793:
1794: -- Owner Tag
1795: htp.tableRowOpen;
1796: htp.tableData(cvalue=>'
1791: calign=>'Left',cattributes=>'id=""');
1792: htp.tableRowClose;
1793:
1794: -- Owner Tag
1795: htp.tableRowOpen;
1796: htp.tableData(cvalue=>'',
1798: calign=>'Right',cattributes=>'id=""');
1799: htp.tableData(cvalue=>htf.formText(cname=>'h_owner_tag', csize=>30,
1792: htp.tableRowClose;
1793:
1794: -- Owner Tag
1795: htp.tableRowOpen;
1796: htp.tableData(cvalue=>'1797: wf_core.translate('OWNER_TAG') || '',
1798: calign=>'Right',cattributes=>'id=""');
1799: htp.tableData(cvalue=>htf.formText(cname=>'h_owner_tag', csize=>30,
1800: cmaxlength=>30,
1795: htp.tableRowOpen;
1796: htp.tableData(cvalue=>'',
1798: calign=>'Right',cattributes=>'id=""');
1799: htp.tableData(cvalue=>htf.formText(cname=>'h_owner_tag', csize=>30,
1800: cmaxlength=>30,
1801: cattributes=>'id="i_owner_tag"'),
1802: calign=>'Left',cattributes=>'id=""');
1803: htp.tableRowClose;
1799: htp.tableData(cvalue=>htf.formText(cname=>'h_owner_tag', csize=>30,
1800: cmaxlength=>30,
1801: cattributes=>'id="i_owner_tag"'),
1802: calign=>'Left',cattributes=>'id=""');
1803: htp.tableRowClose;
1804:
1805: -- Customization Level
1806: if wf_events_pkg.g_Mode = 'FORCE' then
1807: template := htf.formSelectOpen('h_custom_level',cattributes=>'id="i_custom_level"')
1815: htf.formSelectOption(wf_core.translate('WFE_CUSTOM_LEVEL_U'),
1816: select_custom_user,'VALUE="U"')
1817: ||wf_core.newline||
1818: htf.formSelectClose;
1819: htp.tableRowOpen;
1820: htp.tableData(cvalue=>'',
1822: calign=>'Right',cattributes=>'id=""');
1823: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
1816: select_custom_user,'VALUE="U"')
1817: ||wf_core.newline||
1818: htf.formSelectClose;
1819: htp.tableRowOpen;
1820: htp.tableData(cvalue=>'1821: wf_core.translate('WFE_CUSTOM_LEVEL') || '',
1822: calign=>'Right',cattributes=>'id=""');
1823: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
1824: htp.tableRowClose;
1819: htp.tableRowOpen;
1820: htp.tableData(cvalue=>'',
1822: calign=>'Right',cattributes=>'id=""');
1823: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
1824: htp.tableRowClose;
1825:
1826: else
1827: htp.tableRowOpen;
1820: htp.tableData(cvalue=>'',
1822: calign=>'Right',cattributes=>'id=""');
1823: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
1824: htp.tableRowClose;
1825:
1826: else
1827: htp.tableRowOpen;
1828: htp.tableData(cvalue=>wf_core.translate('WFE_CUSTOM_LEVEL'),
1823: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
1824: htp.tableRowClose;
1825:
1826: else
1827: htp.tableRowOpen;
1828: htp.tableData(cvalue=>wf_core.translate('WFE_CUSTOM_LEVEL'),
1829: calign=>'Right',cattributes=>'id=""');
1830: htp.tableData(cvalue=>wf_core.translate('WFE_CUSTOM_LEVEL_'||l_customization_level), calign=>'Left',cattributes=>'id=""');
1831: htp.formHidden('h_custom_level', l_customization_level);
1824: htp.tableRowClose;
1825:
1826: else
1827: htp.tableRowOpen;
1828: htp.tableData(cvalue=>wf_core.translate('WFE_CUSTOM_LEVEL'),
1829: calign=>'Right',cattributes=>'id=""');
1830: htp.tableData(cvalue=>wf_core.translate('WFE_CUSTOM_LEVEL_'||l_customization_level), calign=>'Left',cattributes=>'id=""');
1831: htp.formHidden('h_custom_level', l_customization_level);
1832: end if;
1826: else
1827: htp.tableRowOpen;
1828: htp.tableData(cvalue=>wf_core.translate('WFE_CUSTOM_LEVEL'),
1829: calign=>'Right',cattributes=>'id=""');
1830: htp.tableData(cvalue=>wf_core.translate('WFE_CUSTOM_LEVEL_'||l_customization_level), calign=>'Left',cattributes=>'id=""');
1831: htp.formHidden('h_custom_level', l_customization_level);
1832: end if;
1833:
1834: -- URL to go back to
1827: htp.tableRowOpen;
1828: htp.tableData(cvalue=>wf_core.translate('WFE_CUSTOM_LEVEL'),
1829: calign=>'Right',cattributes=>'id=""');
1830: htp.tableData(cvalue=>wf_core.translate('WFE_CUSTOM_LEVEL_'||l_customization_level), calign=>'Left',cattributes=>'id=""');
1831: htp.formHidden('h_custom_level', l_customization_level);
1832: end if;
1833:
1834: -- URL to go back to
1835: if (h_guid is null and l_type = 'GROUP') then
1832: end if;
1833:
1834: -- URL to go back to
1835: if (h_guid is null and l_type = 'GROUP') then
1836: htp.formHidden('url', ''); -- signal the coming back to this screen
1837: else
1838: htp.formHidden('url', 'Wf_Event_Html.ListEvents');
1839: end if;
1840:
1834: -- URL to go back to
1835: if (h_guid is null and l_type = 'GROUP') then
1836: htp.formHidden('url', ''); -- signal the coming back to this screen
1837: else
1838: htp.formHidden('url', 'Wf_Event_Html.ListEvents');
1839: end if;
1840:
1841: htp.tableClose;
1842: htp.formClose;
1837: else
1838: htp.formHidden('url', 'Wf_Event_Html.ListEvents');
1839: end if;
1840:
1841: htp.tableClose;
1842: htp.formClose;
1843:
1844: -- add values that may contain double quote back through javascript
1845: if (h_guid is not null) then
1838: htp.formHidden('url', 'Wf_Event_Html.ListEvents');
1839: end if;
1840:
1841: htp.tableClose;
1842: htp.formClose;
1843:
1844: -- add values that may contain double quote back through javascript
1845: if (h_guid is not null) then
1846: htp.p('');
1843:
1844: -- add values that may contain double quote back through javascript
1845: if (h_guid is not null) then
1846: htp.p('');
1851: end if;
1844: -- add values that may contain double quote back through javascript
1845: if (h_guid is not null) then
1846: htp.p('');
1851: end if;
1852:
1845: if (h_guid is not null) then
1846: htp.p('');
1851: end if;
1852:
1853: -- if is group, display events for deletion
1846: htp.p('');
1851: end if;
1852:
1853: -- if is group, display events for deletion
1854: if (h_guid is not null and l_type = 'GROUP') then
1867: -- there is no detail.
1868: dTab(i).hasdetail := not Wf_Event_Html.isDeletable(event.guid, 'EVENT');
1869: end loop;
1870:
1871: htp.p(wf_core.translate('WFE_EVENTS_IN_GROUP'));
1872:
1873: -- Submit Form for Add/Delete
1874: htp.formOpen(curl=>owa_util.get_owa_service_path||
1875: 'Wf_Event_Html.SubmitSelectedGEvents',
1870:
1871: htp.p(wf_core.translate('WFE_EVENTS_IN_GROUP'));
1872:
1873: -- Submit Form for Add/Delete
1874: htp.formOpen(curl=>owa_util.get_owa_service_path||
1875: 'Wf_Event_Html.SubmitSelectedGEvents',
1876: cmethod=>'Post',
1877: cattributes=>'TARGET="_top" NAME="WF_GROUP_EDIT"');
1878: htp.formHidden('h_gguid', rawtohex(h_guid));
1874: htp.formOpen(curl=>owa_util.get_owa_service_path||
1875: 'Wf_Event_Html.SubmitSelectedGEvents',
1876: cmethod=>'Post',
1877: cattributes=>'TARGET="_top" NAME="WF_GROUP_EDIT"');
1878: htp.formHidden('h_gguid', rawtohex(h_guid));
1879:
1880: -- Hide the fields for which option you selected. ADD or DELETE
1881: htp.formHidden(cname=>'action', cvalue=>'');
1882:
1877: cattributes=>'TARGET="_top" NAME="WF_GROUP_EDIT"');
1878: htp.formHidden('h_gguid', rawtohex(h_guid));
1879:
1880: -- Hide the fields for which option you selected. ADD or DELETE
1881: htp.formHidden(cname=>'action', cvalue=>'');
1882:
1883: -- Url to come back to later
1884: htp.formHidden(cname=>'url',
1885: cvalue=>'Wf_Event_Html.EditEvent?h_guid='||rawtohex(h_guid));
1880: -- Hide the fields for which option you selected. ADD or DELETE
1881: htp.formHidden(cname=>'action', cvalue=>'');
1882:
1883: -- Url to come back to later
1884: htp.formHidden(cname=>'url',
1885: cvalue=>'Wf_Event_Html.EditEvent?h_guid='||rawtohex(h_guid));
1886:
1887: -- Add dummy fields to start both array-type input fields.
1888: -- These dummy values are needed so that the array parameters to
1888: -- These dummy values are needed so that the array parameters to
1889: -- the submit procedure will not be null even if there are no real
1890: -- response fields. This would cause a pl/sql error, because array
1891: -- parameters can't be defaulted.
1892: htp.formHidden('h_guids', '-1');
1893:
1894: -- popluate the header table
1895: i := 1;
1896: hTab(i).def_type := 'FUNCTION';
1924:
1925: -- render table
1926: Wfe_Html_Util.Simple_Table(hTab, dTab);
1927:
1928: htp.formClose;
1929:
1930: htp.tableOpen(cattributes=>'WIDTH=100%
1931: summary="' || wf_core.translate('WFE_EVENTS_IN_GROUP') || '"');
1932: htp.tableRowOpen;
1926: Wfe_Html_Util.Simple_Table(hTab, dTab);
1927:
1928: htp.formClose;
1929:
1930: htp.tableOpen(cattributes=>'WIDTH=100%
1931: summary="' || wf_core.translate('WFE_EVENTS_IN_GROUP') || '"');
1932: htp.tableRowOpen;
1933: htp.p('
1928: htp.formClose;
1929:
1930: htp.tableOpen(cattributes=>'WIDTH=100%
1931: summary="' || wf_core.translate('WFE_EVENTS_IN_GROUP') || '"');
1932: htp.tableRowOpen;
1933: htp.p('
1929:
1930: htp.tableOpen(cattributes=>'WIDTH=100%
1931: summary="' || wf_core.translate('WFE_EVENTS_IN_GROUP') || '"');
1932: htp.tableRowOpen;
1933: htp.p('
1931: summary="' || wf_core.translate('WFE_EVENTS_IN_GROUP') || '"');
1932: htp.tableRowOpen;
1933: htp.p('
1932: htp.tableRowOpen;
1933: htp.p('
1935: htp.tableOpen (calign=>'RIGHT', cattributes=>'summary=""');
1936: htp.tableRowOpen;
1937: -- If table is not empty, we allow check/uncheck all/delete.
1938: if (dTab.COUNT > 0) then
1939: htp.p('
1942: wf_core.translate('SELECT_ALL'),
1943: wfa_html.image_loc,
1944: null,
1945: wf_core.translate('SELECT_ALL'));
1946: htp.p('
1943: wfa_html.image_loc,
1944: null,
1945: wf_core.translate('SELECT_ALL'));
1946: htp.p('
1950: wf_core.translate('UNSELECT_ALL'),
1951: wfa_html.image_loc,
1952: null,
1953: wf_core.translate('UNSELECT_ALL'));
1954: htp.p('
1954: htp.p('
1962: wf_core.translate('DELETE'),
1963: wfa_html.image_loc,
1964: null,
1965: wf_core.translate('DELETE'));
1966: htp.p('
1964: null,
1965: wf_core.translate('DELETE'));
1966: htp.p('
1972: wf_core.translate('WFE_ADD_EVENT'),
1973: wfa_html.image_loc,
1974: null,
1975: wf_core.translate('WFE_ADD_EVENT'));
1976: htp.p('
1974: null,
1975: wf_core.translate('WFE_ADD_EVENT'));
1976: htp.p('
1975: wf_core.translate('WFE_ADD_EVENT'));
1976: htp.p('');
1977:
1978: htp.tableRowClose;
1979: htp.tableClose;
1980:
1981: htp.p('');
1982: htp.tableRowClose;
1983:
1977:
1978: htp.tableRowClose;
1979: htp.tableClose;
1980:
1981: htp.p('');
1982: htp.tableRowClose;
1983:
1984: htp.tableRowOpen;
1985: htp.p('
1978: htp.tableRowClose;
1979: htp.tableClose;
1980:
1981: htp.p('
1980:
1981: htp.p('
1981: htp.p('
1984: htp.tableRowOpen;
1985: htp.p('
1985: htp.p('
1987: -- Add submit button
1988: htp.tableopen (calign=>'RIGHT', cattributes=>'summary=""');
1989: htp.tableRowOpen;
1990:
1991: htp.p('
1993: wf_core.translate('SUBMIT'),
1994: wfa_html.image_loc,
1995: null,
1996: wf_core.translate('SUBMIT'));
1997: htp.p('
1994: wfa_html.image_loc,
1995: null,
1996: wf_core.translate('SUBMIT'));
1997: htp.p('
2000: wf_core.translate ('CANCEL'),
2001: wfa_html.image_loc,
2002: null,
2003: wf_core.translate ('CANCEL'));
2004: htp.p('
2002: null,
2003: wf_core.translate ('CANCEL'));
2004: htp.p('
2003: wf_core.translate ('CANCEL'));
2004: htp.p('');
2005:
2006: htp.tableRowClose;
2007: htp.tableClose;
2008:
2009: htp.p('');
2010: htp.tableRowClose;
2011: htp.tableClose;
2005:
2006: htp.tableRowClose;
2007: htp.tableClose;
2008:
2009: htp.p('');
2010: htp.tableRowClose;
2011: htp.tableClose;
2012: else
2013:
2006: htp.tableRowClose;
2007: htp.tableClose;
2008:
2009: htp.p('');
2010: htp.tableRowClose;
2011: htp.tableClose;
2012: else
2013:
2014: aligntext := 'CENTER';
2007: htp.tableClose;
2008:
2009: htp.p('');
2010: htp.tableRowClose;
2011: htp.tableClose;
2012: else
2013:
2014: aligntext := 'CENTER';
2015:
2013:
2014: aligntext := 'CENTER';
2015:
2016: -- Add submit button
2017: htp.tableopen (calign=>aligntext, cattributes=>'summary=""');
2018: htp.tableRowOpen;
2019:
2020: htp.p('
2014: aligntext := 'CENTER';
2015:
2016: -- Add submit button
2017: htp.tableopen (calign=>aligntext, cattributes=>'summary=""');
2018: htp.tableRowOpen;
2019:
2020: htp.p('
2016: -- Add submit button
2017: htp.tableopen (calign=>aligntext, cattributes=>'summary=""');
2018: htp.tableRowOpen;
2019:
2020: htp.p('
2024: wfa_html.image_loc,
2025: null,
2026: wf_core.translate('SUBMIT'));
2027:
2028: htp.p('
2025: null,
2026: wf_core.translate('SUBMIT'));
2027:
2028: htp.p('
2032: wfa_html.image_loc,
2033: null,
2034: wf_core.translate ('CANCEL'));
2035:
2036: htp.p('
2034: wf_core.translate ('CANCEL'));
2035:
2036: htp.p('');
2037:
2038: htp.tableRowClose;
2039: htp.tableClose;
2040: end if;
2041:
2042: wfa_sec.Footer;
2035:
2036: htp.p('');
2037:
2038: htp.tableRowClose;
2039: htp.tableClose;
2040: end if;
2041:
2042: wfa_sec.Footer;
2043: htp.htmlClose;
2039: htp.tableClose;
2040: end if;
2041:
2042: wfa_sec.Footer;
2043: htp.htmlClose;
2044:
2045: exception
2046: when others then
2047: rollback;
2118: wf_event_html.isAccessible('EVENTS');
2119:
2120:
2121: -- Render page
2122: htp.htmlOpen;
2123:
2124: -- Set page title
2125: htp.headOpen;
2126:
2121: -- Render page
2122: htp.htmlOpen;
2123:
2124: -- Set page title
2125: htp.headOpen;
2126:
2127: -- list does not get updated after edit, so we add the
2128: -- following tag to force the reload of page.
2129: htp.p('');
2125: htp.headOpen;
2126:
2127: -- list does not get updated after edit, so we add the
2128: -- following tag to force the reload of page.
2129: htp.p('');
2130:
2131: htp.title(wf_core.translate('WFE_EDIT_GROUP_TITLE'));
2132: wfa_html.create_help_function('wf/links/t_d.htm?T_DEFEVGPM');
2133: fnd_document_management.get_open_dm_display_window;
2127: -- list does not get updated after edit, so we add the
2128: -- following tag to force the reload of page.
2129: htp.p('');
2130:
2131: htp.title(wf_core.translate('WFE_EDIT_GROUP_TITLE'));
2132: wfa_html.create_help_function('wf/links/t_d.htm?T_DEFEVGPM');
2133: fnd_document_management.get_open_dm_display_window;
2134:
2135: Wfe_Html_Util.generate_check_all;
2133: fnd_document_management.get_open_dm_display_window;
2134:
2135: Wfe_Html_Util.generate_check_all;
2136:
2137: htp.headClose;
2138:
2139: -- Page header
2140: wfa_sec.Header(FALSE, null,
2141: wf_core.translate('WFE_EDIT_GROUP_TITLE'),
2155: when NO_DATA_FOUND then
2156: wf_core.raise('WFE_EVENT_NOTEXIST');
2157: end;
2158:
2159: htp.tableOpen(calign=>'CENTER',cattributes=>'WIDTH=100% summary=""');
2160:
2161: htp.tableRowOpen;
2162: wf_core.token('GROUP',''||l_name||'');
2163: htp.tableData(cvalue=>wf_core.translate('WFE_ADD_SELECTED_TO_GRP'),
2157: end;
2158:
2159: htp.tableOpen(calign=>'CENTER',cattributes=>'WIDTH=100% summary=""');
2160:
2161: htp.tableRowOpen;
2162: wf_core.token('GROUP',''||l_name||'');
2163: htp.tableData(cvalue=>wf_core.translate('WFE_ADD_SELECTED_TO_GRP'),
2164: calign=>'Left',cattributes=>'id=""');
2165: htp.tableRowClose;
2159: htp.tableOpen(calign=>'CENTER',cattributes=>'WIDTH=100% summary=""');
2160:
2161: htp.tableRowOpen;
2162: wf_core.token('GROUP',''||l_name||'');
2163: htp.tableData(cvalue=>wf_core.translate('WFE_ADD_SELECTED_TO_GRP'),
2164: calign=>'Left',cattributes=>'id=""');
2165: htp.tableRowClose;
2166:
2167: htp.tableClose;
2161: htp.tableRowOpen;
2162: wf_core.token('GROUP',''||l_name||'');
2163: htp.tableData(cvalue=>wf_core.translate('WFE_ADD_SELECTED_TO_GRP'),
2164: calign=>'Left',cattributes=>'id=""');
2165: htp.tableRowClose;
2166:
2167: htp.tableClose;
2168:
2169: -- populate the data table
2163: htp.tableData(cvalue=>wf_core.translate('WFE_ADD_SELECTED_TO_GRP'),
2164: calign=>'Left',cattributes=>'id=""');
2165: htp.tableRowClose;
2166:
2167: htp.tableClose;
2168:
2169: -- populate the data table
2170: i := 0;
2171:
2196: end loop;
2197: end if;
2198:
2199: -- Submit Form for Add/Delete
2200: htp.formOpen(curl=>owa_util.get_owa_service_path||
2201: 'Wf_Event_Html.SubmitSelectedGEvents',
2202: cmethod=>'Get',
2203: cattributes=>'TARGET="_top" NAME="WF_GROUP_EDIT"');
2204: htp.formHidden('h_gguid', rawtohex(h_guid));
2200: htp.formOpen(curl=>owa_util.get_owa_service_path||
2201: 'Wf_Event_Html.SubmitSelectedGEvents',
2202: cmethod=>'Get',
2203: cattributes=>'TARGET="_top" NAME="WF_GROUP_EDIT"');
2204: htp.formHidden('h_gguid', rawtohex(h_guid));
2205:
2206: -- Hide the fields for which option you selected. ADD or DELETE
2207: htp.formHidden(cname=>'action', cvalue=>'');
2208:
2203: cattributes=>'TARGET="_top" NAME="WF_GROUP_EDIT"');
2204: htp.formHidden('h_gguid', rawtohex(h_guid));
2205:
2206: -- Hide the fields for which option you selected. ADD or DELETE
2207: htp.formHidden(cname=>'action', cvalue=>'');
2208:
2209: -- Url to come back to later
2210: htp.formHidden(cname=>'url',
2211: cvalue=>'Wf_Event_Html.EditEvent?h_guid='||rawtohex(h_guid));
2206: -- Hide the fields for which option you selected. ADD or DELETE
2207: htp.formHidden(cname=>'action', cvalue=>'');
2208:
2209: -- Url to come back to later
2210: htp.formHidden(cname=>'url',
2211: cvalue=>'Wf_Event_Html.EditEvent?h_guid='||rawtohex(h_guid));
2212:
2213: -- Add dummy fields to start both array-type input fields.
2214: -- These dummy values are needed so that the array parameters to
2214: -- These dummy values are needed so that the array parameters to
2215: -- the submit procedure will not be null even if there are no real
2216: -- response fields. This would cause a pl/sql error, because array
2217: -- parameters can't be defaulted.
2218: htp.formHidden('h_guids', '-1');
2219:
2220: -- popluate the header table
2221: i := 1;
2222: hTab(i).def_type := 'TITLE';
2233:
2234: -- render table
2235: Wfe_Html_Util.Simple_Table(hTab, dTab);
2236:
2237: htp.formClose;
2238:
2239: -- If we generate simple table, we create this check/uncheck all.
2240: if (i > 0) then
2241: htp.tableOpen (calign=>'CENTER',cattributes=>'WIDTH=100% summary=""');
2237: htp.formClose;
2238:
2239: -- If we generate simple table, we create this check/uncheck all.
2240: if (i > 0) then
2241: htp.tableOpen (calign=>'CENTER',cattributes=>'WIDTH=100% summary=""');
2242: htp.tableRowOpen;
2243: htp.p('
2238:
2239: -- If we generate simple table, we create this check/uncheck all.
2240: if (i > 0) then
2241: htp.tableOpen (calign=>'CENTER',cattributes=>'WIDTH=100% summary=""');
2242: htp.tableRowOpen;
2243: htp.p('
2239: -- If we generate simple table, we create this check/uncheck all.
2240: if (i > 0) then
2241: htp.tableOpen (calign=>'CENTER',cattributes=>'WIDTH=100% summary=""');
2242: htp.tableRowOpen;
2243: htp.p('
2240: if (i > 0) then
2241: htp.tableOpen (calign=>'CENTER',cattributes=>'WIDTH=100% summary=""');
2242: htp.tableRowOpen;
2243: htp.p('
2242: htp.tableRowOpen;
2243: htp.p('
2244: htp.anchor('javascript:checkAll(document.WF_GROUP_EDIT.h_guids)',
2245: wf_core.translate('SELECT_ALL'), null);
2246: htp.anchor('javascript:uncheckAll(document.WF_GROUP_EDIT.h_guids)',
2247: wf_core.translate('UNSELECT_ALL'), null);
2248: htp.p('');
2249: htp.tableRowClose;
2250: htp.tableClose;
2251: end if;
2252:
2245: wf_core.translate('SELECT_ALL'), null);
2246: htp.anchor('javascript:uncheckAll(document.WF_GROUP_EDIT.h_guids)',
2247: wf_core.translate('UNSELECT_ALL'), null);
2248: htp.p('');
2249: htp.tableRowClose;
2250: htp.tableClose;
2251: end if;
2252:
2253: htp.tableOpen (calign=>'CENTER', cattributes=>'summary=""');
2246: htp.anchor('javascript:uncheckAll(document.WF_GROUP_EDIT.h_guids)',
2247: wf_core.translate('UNSELECT_ALL'), null);
2248: htp.p('');
2249: htp.tableRowClose;
2250: htp.tableClose;
2251: end if;
2252:
2253: htp.tableOpen (calign=>'CENTER', cattributes=>'summary=""');
2254: htp.tableRowOpen;
2249: htp.tableRowClose;
2250: htp.tableClose;
2251: end if;
2252:
2253: htp.tableOpen (calign=>'CENTER', cattributes=>'summary=""');
2254: htp.tableRowOpen;
2255: if (h_func = 'DELETE') then
2256:
2257: -- Delete Screen
2250: htp.tableClose;
2251: end if;
2252:
2253: htp.tableOpen (calign=>'CENTER', cattributes=>'summary=""');
2254: htp.tableRowOpen;
2255: if (h_func = 'DELETE') then
2256:
2257: -- Delete Screen
2258: -- Allow user to delete selected events
2256:
2257: -- Delete Screen
2258: -- Allow user to delete selected events
2259: -- or add some more event through the find screen.
2260: htp.p('
2264: wf_core.translate('DELETE_SELECTED'),
2265: wfa_html.image_loc,
2266: null,
2267: wf_core.translate('DELETE_SELECTED'));
2268: htp.p('');
2269: htp.p('
2265: wfa_html.image_loc,
2266: null,
2267: wf_core.translate('DELETE_SELECTED'));
2268: htp.p('
2273: wf_core.translate('ADD'),
2274: wfa_html.image_loc,
2275: null,
2276: wf_core.translate('ADD'));
2277: htp.p('
2278: else
2279:
2280: -- Add screen
2281: -- Come back from the Find, now you can add selected events to the group.
2282: htp.p('
2286: wf_core.translate('ADD_SELECTED'),
2287: wfa_html.image_loc,
2288: null,
2289: wf_core.translate('ADD_SELECTED'));
2290: htp.p('');
2291: htp.p('
2287: wfa_html.image_loc,
2288: null,
2289: wf_core.translate('ADD_SELECTED'));
2290: htp.p('
2294: wfa_html.image_loc,
2295: null,
2296: wf_core.translate ('CANCEL'));
2297:
2298: htp.p('
2296: wf_core.translate ('CANCEL'));
2297:
2298: htp.p('');
2299: end if;
2300: htp.tableRowClose;
2301: htp.tableClose;
2302:
2303: wfa_sec.Footer;
2304: htp.htmlClose;
2297:
2298: htp.p('');
2299: end if;
2300: htp.tableRowClose;
2301: htp.tableClose;
2302:
2303: wfa_sec.Footer;
2304: htp.htmlClose;
2305: exception
2300: htp.tableRowClose;
2301: htp.tableClose;
2302:
2303: wfa_sec.Footer;
2304: htp.htmlClose;
2305: exception
2306: when others then
2307: rollback;
2308: wf_core.context('WF_EVENT_HTML', 'EditGroup', rawtohex(h_guid));
2352: -- Check if Accessible
2353: wf_event_html.isAccessible('SYSTEM');
2354:
2355: -- Set page title
2356: htp.htmlOpen;
2357: htp.headOpen;
2358:
2359: htp.title(wf_core.translate('WFE_EDIT_SYSTEM_TITLE'));
2360: wfa_html.create_help_function('wf/links/t_d.htm?T_DEFEVSYS');
2353: wf_event_html.isAccessible('SYSTEM');
2354:
2355: -- Set page title
2356: htp.htmlOpen;
2357: htp.headOpen;
2358:
2359: htp.title(wf_core.translate('WFE_EDIT_SYSTEM_TITLE'));
2360: wfa_html.create_help_function('wf/links/t_d.htm?T_DEFEVSYS');
2361: fnd_document_management.get_open_dm_display_window;
2355: -- Set page title
2356: htp.htmlOpen;
2357: htp.headOpen;
2358:
2359: htp.title(wf_core.translate('WFE_EDIT_SYSTEM_TITLE'));
2360: wfa_html.create_help_function('wf/links/t_d.htm?T_DEFEVSYS');
2361: fnd_document_management.get_open_dm_display_window;
2362:
2363: htp.headClose;
2359: htp.title(wf_core.translate('WFE_EDIT_SYSTEM_TITLE'));
2360: wfa_html.create_help_function('wf/links/t_d.htm?T_DEFEVSYS');
2361: fnd_document_management.get_open_dm_display_window;
2362:
2363: htp.headClose;
2364:
2365: -- Page header
2366: wfa_sec.Header(FALSE,
2367: owa_util.get_owa_service_path||'wf_event_html.FindEvent',
2403:
2404:
2405: end if;
2406: -- Form
2407: htp.formOpen(curl=>owa_util.get_owa_service_path||
2408: 'wf_event_html.SubmitSystem',
2409: cmethod=>'Get',
2410: cattributes=>'TARGET="_top" NAME="WF_SYSTEM_EDIT"');
2411:
2411:
2412: -- GUID
2413: -- do not display it if it is null
2414: if (h_guid is not null) then
2415: htp.p('');
2416: end if;
2417: htp.formHidden('h_guid', rawtohex(h_guid));
2418:
2419: htp.tableOpen(calign=>'CENTER', cattributes=>'border=0 summary=""');
2413: -- do not display it if it is null
2414: if (h_guid is not null) then
2415: htp.p('');
2416: end if;
2417: htp.formHidden('h_guid', rawtohex(h_guid));
2418:
2419: htp.tableOpen(calign=>'CENTER', cattributes=>'border=0 summary=""');
2420:
2421: -- Name
2415: htp.p('');
2416: end if;
2417: htp.formHidden('h_guid', rawtohex(h_guid));
2418:
2419: htp.tableOpen(calign=>'CENTER', cattributes=>'border=0 summary=""');
2420:
2421: -- Name
2422: htp.tableRowOpen;
2423: htp.tableData(cvalue=>'
2418:
2419: htp.tableOpen(calign=>'CENTER', cattributes=>'border=0 summary=""');
2420:
2421: -- Name
2422: htp.tableRowOpen;
2423: htp.tableData(cvalue=>'',
2425: calign=>'Right', cattributes=>'id=""');
2426: htp.tableData(cvalue=>htf.formText(cname=>'h_name', csize=>40,
2419: htp.tableOpen(calign=>'CENTER', cattributes=>'border=0 summary=""');
2420:
2421: -- Name
2422: htp.tableRowOpen;
2423: htp.tableData(cvalue=>'2424: wf_core.translate('NAME') || '',
2425: calign=>'Right', cattributes=>'id=""');
2426: htp.tableData(cvalue=>htf.formText(cname=>'h_name', csize=>40,
2427: cmaxlength=>240, cvalue=>l_name,
2422: htp.tableRowOpen;
2423: htp.tableData(cvalue=>'',
2425: calign=>'Right', cattributes=>'id=""');
2426: htp.tableData(cvalue=>htf.formText(cname=>'h_name', csize=>40,
2427: cmaxlength=>240, cvalue=>l_name,
2428: cattributes=>'id="i_name"'),
2429: calign=>'Left',cattributes=>'id=""');
2430: htp.tableRowClose;
2426: htp.tableData(cvalue=>htf.formText(cname=>'h_name', csize=>40,
2427: cmaxlength=>240, cvalue=>l_name,
2428: cattributes=>'id="i_name"'),
2429: calign=>'Left',cattributes=>'id=""');
2430: htp.tableRowClose;
2431:
2432: -- Display Name
2433: htp.tableRowOpen;
2434: htp.tableData(cvalue=>'
2429: calign=>'Left',cattributes=>'id=""');
2430: htp.tableRowClose;
2431:
2432: -- Display Name
2433: htp.tableRowOpen;
2434: htp.tableData(cvalue=>'',
2436: calign=>'Right', cattributes=>'id=""');
2437: htp.tableData(cvalue=>htf.formText(cname=>'h_display_name', csize=>60,
2430: htp.tableRowClose;
2431:
2432: -- Display Name
2433: htp.tableRowOpen;
2434: htp.tableData(cvalue=>'2435: wf_core.translate('DISPLAY_NAME') || '',
2436: calign=>'Right', cattributes=>'id=""');
2437: htp.tableData(cvalue=>htf.formText(cname=>'h_display_name', csize=>60,
2438: cmaxlength=>80,
2433: htp.tableRowOpen;
2434: htp.tableData(cvalue=>'',
2436: calign=>'Right', cattributes=>'id=""');
2437: htp.tableData(cvalue=>htf.formText(cname=>'h_display_name', csize=>60,
2438: cmaxlength=>80,
2439: cattributes=>'id="i_display_name"'),
2440: calign=>'Left', cattributes=>'id=""');
2441: htp.tableRowClose;
2437: htp.tableData(cvalue=>htf.formText(cname=>'h_display_name', csize=>60,
2438: cmaxlength=>80,
2439: cattributes=>'id="i_display_name"'),
2440: calign=>'Left', cattributes=>'id=""');
2441: htp.tableRowClose;
2442:
2443: -- Description
2444: htp.tableRowOpen;
2445: htp.tableData(cvalue=>'
2440: calign=>'Left', cattributes=>'id=""');
2441: htp.tableRowClose;
2442:
2443: -- Description
2444: htp.tableRowOpen;
2445: htp.tableData(cvalue=>'',
2447: calign=>'Right', cattributes=>'id=""');
2448: htp.tableData(cvalue=>htf.formTextareaOpen2(
2441: htp.tableRowClose;
2442:
2443: -- Description
2444: htp.tableRowOpen;
2445: htp.tableData(cvalue=>'2446: wf_core.translate('DESCRIPTION') || '',
2447: calign=>'Right', cattributes=>'id=""');
2448: htp.tableData(cvalue=>htf.formTextareaOpen2(
2449: cname=>'h_description',
2444: htp.tableRowOpen;
2445: htp.tableData(cvalue=>'',
2447: calign=>'Right', cattributes=>'id=""');
2448: htp.tableData(cvalue=>htf.formTextareaOpen2(
2449: cname=>'h_description',
2450: nrows=>2,
2451: ncolumns=>60,
2452: cwrap=>'SOFT',
2455: ||l_desc
2456: ||htf.formTextareaClose,
2457: calign=>'Left',
2458: cattributes=>'id=""');
2459: htp.tableRowClose;
2460:
2461: -- Master GUID
2462: htp.tableRowOpen;
2463: htp.tableData(cvalue=>'
2458: cattributes=>'id=""');
2459: htp.tableRowClose;
2460:
2461: -- Master GUID
2462: htp.tableRowOpen;
2463: htp.tableData(cvalue=>'',
2465: calign=>'right',cattributes=>'id=""');
2466: htp.formHidden('h_master_guid', l_mguid);
2459: htp.tableRowClose;
2460:
2461: -- Master GUID
2462: htp.tableRowOpen;
2463: htp.tableData(cvalue=>'2464: wf_core.translate('MASTER') || '',
2465: calign=>'right',cattributes=>'id=""');
2466: htp.formHidden('h_master_guid', l_mguid);
2467: -- add LOV here:
2462: htp.tableRowOpen;
2463: htp.tableData(cvalue=>'',
2465: calign=>'right',cattributes=>'id=""');
2466: htp.formHidden('h_master_guid', l_mguid);
2467: -- add LOV here:
2468: -- Note: The REPLACE function replaces all the space characters with
2469: -- the proper escape sequence.
2470: l_url := 'javascript:fnd_open_dm_display_window('||''''||
2477: '&p_dest_display_field=top.opener.parent.document.WF_SYSTEM_EDIT.display_master.value',
2478: ' ', '%20')||''''||',500,500)';
2479:
2480: -- print everything together so there is no gap.
2481: htp.tabledata(htf.formText(cname=>'display_master', csize=>32,
2482: cmaxlength=>240,
2483: cattributes=>'id="i_master"')||
2484: ''||
2485: '',
2488: cattributes=>'id=""');
2489:
2490: htp.tableRowClose;
2491:
2492: -- URL to go back to
2493: htp.formHidden('url', 'Wf_Event_Html.ListSystems');
2494:
2489:
2490: htp.tableRowClose;
2491:
2492: -- URL to go back to
2493: htp.formHidden('url', 'Wf_Event_Html.ListSystems');
2494:
2495: htp.tableClose;
2496: htp.formClose;
2497:
2491:
2492: -- URL to go back to
2493: htp.formHidden('url', 'Wf_Event_Html.ListSystems');
2494:
2495: htp.tableClose;
2496: htp.formClose;
2497:
2498: -- add values that may contain double quote back through javascript
2499: if (h_guid is not null) then
2492: -- URL to go back to
2493: htp.formHidden('url', 'Wf_Event_Html.ListSystems');
2494:
2495: htp.tableClose;
2496: htp.formClose;
2497:
2498: -- add values that may contain double quote back through javascript
2499: if (h_guid is not null) then
2500: htp.p('');
2504: end if;
2497:
2498: -- add values that may contain double quote back through javascript
2499: if (h_guid is not null) then
2500: htp.p('');
2504: end if;
2505:
2498: -- add values that may contain double quote back through javascript
2499: if (h_guid is not null) then
2500: htp.p('');
2504: end if;
2505:
2506: -- Add submit button
2499: if (h_guid is not null) then
2500: htp.p('');
2504: end if;
2505:
2506: -- Add submit button
2507: htp.tableopen (calign=>'CENTER', cattributes=>'summary=""');
2503: htp.p('');
2504: end if;
2505:
2506: -- Add submit button
2507: htp.tableopen (calign=>'CENTER', cattributes=>'summary=""');
2508: htp.tableRowOpen;
2509:
2510: htp.p('
2504: end if;
2505:
2506: -- Add submit button
2507: htp.tableopen (calign=>'CENTER', cattributes=>'summary=""');
2508: htp.tableRowOpen;
2509:
2510: htp.p('
2506: -- Add submit button
2507: htp.tableopen (calign=>'CENTER', cattributes=>'summary=""');
2508: htp.tableRowOpen;
2509:
2510: htp.p('
2514: wfa_html.image_loc,
2515: null,
2516: wf_core.translate('SUBMIT'));
2517:
2518: htp.p('
2515: null,
2516: wf_core.translate('SUBMIT'));
2517:
2518: htp.p('
2522: wfa_html.image_loc,
2523: null,
2524: wf_core.translate ('CANCEL'));
2525:
2526: htp.p('
2524: wf_core.translate ('CANCEL'));
2525:
2526: htp.p('');
2527:
2528: htp.tableRowClose;
2529: htp.tableClose;
2530:
2531: wfa_sec.Footer;
2532: htp.htmlClose;
2525:
2526: htp.p('');
2527:
2528: htp.tableRowClose;
2529: htp.tableClose;
2530:
2531: wfa_sec.Footer;
2532: htp.htmlClose;
2533:
2528: htp.tableRowClose;
2529: htp.tableClose;
2530:
2531: wfa_sec.Footer;
2532: htp.htmlClose;
2533:
2534: exception
2535: when others then
2536: rollback;
2601: -- Check if Accessible
2602: wf_event_html.isAccessible('AGENTS');
2603:
2604: -- Set page title
2605: htp.htmlOpen;
2606: htp.headOpen;
2607:
2608: htp.title(wf_core.translate('WFE_EDIT_AGENT_TITLE'));
2609: wfa_html.create_help_function('wf/links/t_d.htm?T_DEFEVAGT');
2602: wf_event_html.isAccessible('AGENTS');
2603:
2604: -- Set page title
2605: htp.htmlOpen;
2606: htp.headOpen;
2607:
2608: htp.title(wf_core.translate('WFE_EDIT_AGENT_TITLE'));
2609: wfa_html.create_help_function('wf/links/t_d.htm?T_DEFEVAGT');
2610: fnd_document_management.get_open_dm_display_window;
2604: -- Set page title
2605: htp.htmlOpen;
2606: htp.headOpen;
2607:
2608: htp.title(wf_core.translate('WFE_EDIT_AGENT_TITLE'));
2609: wfa_html.create_help_function('wf/links/t_d.htm?T_DEFEVAGT');
2610: fnd_document_management.get_open_dm_display_window;
2611:
2612: htp.headClose;
2608: htp.title(wf_core.translate('WFE_EDIT_AGENT_TITLE'));
2609: wfa_html.create_help_function('wf/links/t_d.htm?T_DEFEVAGT');
2610: fnd_document_management.get_open_dm_display_window;
2611:
2612: htp.headClose;
2613:
2614: -- Page header
2615: wfa_sec.Header(FALSE,
2616: owa_util.get_owa_service_path||'wf_event_html.FindAgent',
2659:
2660: end if;
2661:
2662: -- Form
2663: htp.formOpen(curl=>owa_util.get_owa_service_path||
2664: 'wf_event_html.SubmitAgent',
2665: cmethod=>'Get',
2666: cattributes=>'TARGET="_top" NAME="WF_AGENT_EDIT"');
2667:
2667:
2668: -- GUID
2669: -- do not display it if it is null
2670: if (h_guid is not null) then
2671: htp.p('');
2672: end if;
2673: htp.formHidden('h_guid', rawtohex(h_guid));
2674:
2675: htp.tableOpen(calign=>'CENTER', cattributes=>'border=0 summary=""');
2669: -- do not display it if it is null
2670: if (h_guid is not null) then
2671: htp.p('');
2672: end if;
2673: htp.formHidden('h_guid', rawtohex(h_guid));
2674:
2675: htp.tableOpen(calign=>'CENTER', cattributes=>'border=0 summary=""');
2676:
2677: -- Name
2671: htp.p('');
2672: end if;
2673: htp.formHidden('h_guid', rawtohex(h_guid));
2674:
2675: htp.tableOpen(calign=>'CENTER', cattributes=>'border=0 summary=""');
2676:
2677: -- Name
2678: htp.tableRowOpen;
2679: htp.tableData(cvalue=>'
2674:
2675: htp.tableOpen(calign=>'CENTER', cattributes=>'border=0 summary=""');
2676:
2677: -- Name
2678: htp.tableRowOpen;
2679: htp.tableData(cvalue=>'',
2681: calign=>'Right',cattributes=>'id=""');
2682: htp.tableData(cvalue=>htf.formText(cname=>'h_name', csize=>60,
2675: htp.tableOpen(calign=>'CENTER', cattributes=>'border=0 summary=""');
2676:
2677: -- Name
2678: htp.tableRowOpen;
2679: htp.tableData(cvalue=>'2680: wf_core.translate('NAME') || '',
2681: calign=>'Right',cattributes=>'id=""');
2682: htp.tableData(cvalue=>htf.formText(cname=>'h_name', csize=>60,
2683: cmaxlength=>80, cvalue=>l_name,
2678: htp.tableRowOpen;
2679: htp.tableData(cvalue=>'',
2681: calign=>'Right',cattributes=>'id=""');
2682: htp.tableData(cvalue=>htf.formText(cname=>'h_name', csize=>60,
2683: cmaxlength=>80, cvalue=>l_name,
2684: cattributes=>'id="i_name"'),
2685: calign=>'Left',cattributes=>'id=""');
2686: htp.tableRowClose;
2682: htp.tableData(cvalue=>htf.formText(cname=>'h_name', csize=>60,
2683: cmaxlength=>80, cvalue=>l_name,
2684: cattributes=>'id="i_name"'),
2685: calign=>'Left',cattributes=>'id=""');
2686: htp.tableRowClose;
2687:
2688: -- Display Name
2689: htp.tableRowOpen;
2690: htp.tableData(cvalue=>'
2685: calign=>'Left',cattributes=>'id=""');
2686: htp.tableRowClose;
2687:
2688: -- Display Name
2689: htp.tableRowOpen;
2690: htp.tableData(cvalue=>'',
2692: calign=>'Right',cattributes=>'id=""');
2693: htp.tableData(cvalue=>htf.formText(cname=>'h_display_name', csize=>60,
2686: htp.tableRowClose;
2687:
2688: -- Display Name
2689: htp.tableRowOpen;
2690: htp.tableData(cvalue=>'2691: wf_core.translate('DISPLAY_NAME') || '',
2692: calign=>'Right',cattributes=>'id=""');
2693: htp.tableData(cvalue=>htf.formText(cname=>'h_display_name', csize=>60,
2694: cmaxlength=>80,
2689: htp.tableRowOpen;
2690: htp.tableData(cvalue=>'',
2692: calign=>'Right',cattributes=>'id=""');
2693: htp.tableData(cvalue=>htf.formText(cname=>'h_display_name', csize=>60,
2694: cmaxlength=>80,
2695: cattributes=>'id="i_display_name"'),
2696: calign=>'Left',cattributes=>'id=""');
2697: htp.tableRowClose;
2693: htp.tableData(cvalue=>htf.formText(cname=>'h_display_name', csize=>60,
2694: cmaxlength=>80,
2695: cattributes=>'id="i_display_name"'),
2696: calign=>'Left',cattributes=>'id=""');
2697: htp.tableRowClose;
2698:
2699: -- Description
2700: htp.tableRowOpen;
2701: htp.tableData(cvalue=>'
2696: calign=>'Left',cattributes=>'id=""');
2697: htp.tableRowClose;
2698:
2699: -- Description
2700: htp.tableRowOpen;
2701: htp.tableData(cvalue=>'',
2703: calign=>'Right', cattributes=>'id=""');
2704: htp.tableData(cvalue=>htf.formTextareaOpen2(
2697: htp.tableRowClose;
2698:
2699: -- Description
2700: htp.tableRowOpen;
2701: htp.tableData(cvalue=>'2702: wf_core.translate('DESCRIPTION') || '',
2703: calign=>'Right', cattributes=>'id=""');
2704: htp.tableData(cvalue=>htf.formTextareaOpen2(
2705: cname=>'h_description',
2700: htp.tableRowOpen;
2701: htp.tableData(cvalue=>'',
2703: calign=>'Right', cattributes=>'id=""');
2704: htp.tableData(cvalue=>htf.formTextareaOpen2(
2705: cname=>'h_description',
2706: nrows=>2,
2707: ncolumns=>60,
2708: cwrap=>'SOFT',
2709: cattributes=>'maxlength=2000 id="i_description"')
2710: ||l_desc
2711: ||htf.formTextareaClose,
2712: calign=>'Left',cattributes=>'id=""');
2713: htp.tableRowClose;
2714:
2715: -- Protocol
2716: template := htf.formSelectOpen('h_protocol',cattributes=>'id="i_protocol"')
2717: ||wf_core.newline;
2744: selected := TRUE;
2745: end if;
2746: template := template||htf.formSelectClose;
2747:
2748: htp.tableRowOpen;
2749: htp.tableData(cvalue=>'',
2751: calign=>'Right', cattributes=>'id=""');
2752: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
2745: end if;
2746: template := template||htf.formSelectClose;
2747:
2748: htp.tableRowOpen;
2749: htp.tableData(cvalue=>'2750: wf_core.translate('PROTOCOL') || '',
2751: calign=>'Right', cattributes=>'id=""');
2752: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
2753: -- htp.tableData(cvalue=>htf.formText(cname=>'h_protocol', csize=>8,
2748: htp.tableRowOpen;
2749: htp.tableData(cvalue=>'',
2751: calign=>'Right', cattributes=>'id=""');
2752: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
2753: -- htp.tableData(cvalue=>htf.formText(cname=>'h_protocol', csize=>8,
2754: -- cmaxlength=>8, cvalue=>l_protocol),
2755: -- calign=>'Left',cattributes=>'id=""');
2756: htp.tableRowClose;
2749: htp.tableData(cvalue=>'',
2751: calign=>'Right', cattributes=>'id=""');
2752: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
2753: -- htp.tableData(cvalue=>htf.formText(cname=>'h_protocol', csize=>8,
2754: -- cmaxlength=>8, cvalue=>l_protocol),
2755: -- calign=>'Left',cattributes=>'id=""');
2756: htp.tableRowClose;
2757:
2752: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
2753: -- htp.tableData(cvalue=>htf.formText(cname=>'h_protocol', csize=>8,
2754: -- cmaxlength=>8, cvalue=>l_protocol),
2755: -- calign=>'Left',cattributes=>'id=""');
2756: htp.tableRowClose;
2757:
2758: -- Address
2759: htp.tableRowOpen;
2760: htp.tableData(cvalue=>'
2755: -- calign=>'Left',cattributes=>'id=""');
2756: htp.tableRowClose;
2757:
2758: -- Address
2759: htp.tableRowOpen;
2760: htp.tableData(cvalue=>'',
2762: calign=>'Right',cattributes=>'id=""');
2763: htp.tableData(cvalue=>htf.formText(cname=>'h_address', csize=>80,
2756: htp.tableRowClose;
2757:
2758: -- Address
2759: htp.tableRowOpen;
2760: htp.tableData(cvalue=>'2761: wf_core.translate('ADDRESS') || '',
2762: calign=>'Right',cattributes=>'id=""');
2763: htp.tableData(cvalue=>htf.formText(cname=>'h_address', csize=>80,
2764: cmaxlength=>240, cvalue=>l_address,
2759: htp.tableRowOpen;
2760: htp.tableData(cvalue=>'',
2762: calign=>'Right',cattributes=>'id=""');
2763: htp.tableData(cvalue=>htf.formText(cname=>'h_address', csize=>80,
2764: cmaxlength=>240, cvalue=>l_address,
2765: cattributes=>'id="i_address"'),
2766: calign=>'Left',cattributes=>'id=""');
2767: htp.tableRowClose;
2763: htp.tableData(cvalue=>htf.formText(cname=>'h_address', csize=>80,
2764: cmaxlength=>240, cvalue=>l_address,
2765: cattributes=>'id="i_address"'),
2766: calign=>'Left',cattributes=>'id=""');
2767: htp.tableRowClose;
2768:
2769: -- System
2770: htp.tableRowOpen;
2771: htp.tableData(cvalue=>'
2766: calign=>'Left',cattributes=>'id=""');
2767: htp.tableRowClose;
2768:
2769: -- System
2770: htp.tableRowOpen;
2771: htp.tableData(cvalue=>'',
2773: calign=>'right',cattributes=>'id=""');
2774: htp.formHidden('h_system_guid', null);
2767: htp.tableRowClose;
2768:
2769: -- System
2770: htp.tableRowOpen;
2771: htp.tableData(cvalue=>'2772: wf_core.translate('SYSTEM') || '',
2773: calign=>'right',cattributes=>'id=""');
2774: htp.formHidden('h_system_guid', null);
2775: -- add LOV here:
2770: htp.tableRowOpen;
2771: htp.tableData(cvalue=>'',
2773: calign=>'right',cattributes=>'id=""');
2774: htp.formHidden('h_system_guid', null);
2775: -- add LOV here:
2776: -- Note: The REPLACE function replaces all the space characters with
2777: -- the proper escape sequence.
2778: l_url := 'javascript:fnd_open_dm_display_window('||''''||
2785: '&p_dest_display_field=top.opener.parent.document.WF_AGENT_EDIT.display_system.value',
2786: ' ', '%20')||''''||',500,500)';
2787:
2788: -- print everything together so there is no gap.
2789: htp.tabledata(htf.formText(cname=>'display_system', csize=>32,
2790: cmaxlength=>240,cattributes=>'id="i_system"')||
2791: ''||
2792: '',
2795: cattributes=>'id=""');
2796:
2797: htp.tableRowClose;
2798:
2799: -- Queue Handler
2800: htp.tableRowOpen;
2801: htp.tableData(cvalue=>'
2796:
2797: htp.tableRowClose;
2798:
2799: -- Queue Handler
2800: htp.tableRowOpen;
2801: htp.tableData(cvalue=>'',
2803: calign=>'Right',cattributes=>'id=""');
2804: htp.tableData(cvalue=>htf.formText(cname=>'h_qhandler', csize=>60,
2797: htp.tableRowClose;
2798:
2799: -- Queue Handler
2800: htp.tableRowOpen;
2801: htp.tableData(cvalue=>'2802: wf_core.translate('QUEUE_HANDLER') || '',
2803: calign=>'Right',cattributes=>'id=""');
2804: htp.tableData(cvalue=>htf.formText(cname=>'h_qhandler', csize=>60,
2805: cmaxlength=>240, cvalue=>l_qhandler,
2800: htp.tableRowOpen;
2801: htp.tableData(cvalue=>'',
2803: calign=>'Right',cattributes=>'id=""');
2804: htp.tableData(cvalue=>htf.formText(cname=>'h_qhandler', csize=>60,
2805: cmaxlength=>240, cvalue=>l_qhandler,
2806: cattributes=>'id="i_queue_handler"'),
2807: calign=>'Left',cattributes=>'id=""');
2808: htp.tableRowClose;
2804: htp.tableData(cvalue=>htf.formText(cname=>'h_qhandler', csize=>60,
2805: cmaxlength=>240, cvalue=>l_qhandler,
2806: cattributes=>'id="i_queue_handler"'),
2807: calign=>'Left',cattributes=>'id=""');
2808: htp.tableRowClose;
2809:
2810: -- Queue Name
2811: htp.tableRowOpen;
2812: htp.tableData(cvalue=>'
2807: calign=>'Left',cattributes=>'id=""');
2808: htp.tableRowClose;
2809:
2810: -- Queue Name
2811: htp.tableRowOpen;
2812: htp.tableData(cvalue=>'', calign=>'Right',
2814: cattributes=>'id=""');
2815: htp.tableData(cvalue=>htf.formText(cname=>'h_qname', csize=>60,
2808: htp.tableRowClose;
2809:
2810: -- Queue Name
2811: htp.tableRowOpen;
2812: htp.tableData(cvalue=>'2813: wf_core.translate('QUEUE_NAME') || '', calign=>'Right',
2814: cattributes=>'id=""');
2815: htp.tableData(cvalue=>htf.formText(cname=>'h_qname', csize=>60,
2816: cmaxlength=>80, cvalue=>l_qname,
2811: htp.tableRowOpen;
2812: htp.tableData(cvalue=>'', calign=>'Right',
2814: cattributes=>'id=""');
2815: htp.tableData(cvalue=>htf.formText(cname=>'h_qname', csize=>60,
2816: cmaxlength=>80, cvalue=>l_qname,
2817: cattributes=>'id="i_queue_name"'),
2818: calign=>'Left',cattributes=>'id=""');
2819: htp.tableRowClose;
2815: htp.tableData(cvalue=>htf.formText(cname=>'h_qname', csize=>60,
2816: cmaxlength=>80, cvalue=>l_qname,
2817: cattributes=>'id="i_queue_name"'),
2818: calign=>'Left',cattributes=>'id=""');
2819: htp.tableRowClose;
2820:
2821: -- Direction
2822: template := htf.formSelectOpen('h_direction', cattributes=>'id="i_direction"')||wf_core.newline||
2823: /*
2831: htf.formSelectOption(wf_core.translate('OUT'),
2832: select_out,'VALUE="OUT"')
2833: ||wf_core.newline||
2834: htf.formSelectClose;
2835: htp.tableRowOpen;
2836: htp.tableData(cvalue=>'',
2838: calign=>'Right',cattributes=>'id=""');
2839: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
2832: select_out,'VALUE="OUT"')
2833: ||wf_core.newline||
2834: htf.formSelectClose;
2835: htp.tableRowOpen;
2836: htp.tableData(cvalue=>'2837: wf_core.translate('DIRECTION') || '',
2838: calign=>'Right',cattributes=>'id=""');
2839: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
2840: htp.tableRowClose;
2835: htp.tableRowOpen;
2836: htp.tableData(cvalue=>'',
2838: calign=>'Right',cattributes=>'id=""');
2839: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
2840: htp.tableRowClose;
2841:
2842: -- Status
2843: template := htf.formSelectOpen('h_status',cattributes=>'id="i_status"')
2836: htp.tableData(cvalue=>'',
2838: calign=>'Right',cattributes=>'id=""');
2839: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
2840: htp.tableRowClose;
2841:
2842: -- Status
2843: template := htf.formSelectOpen('h_status',cattributes=>'id="i_status"')
2844: ||wf_core.newline||
2848: htf.formSelectOption(wf_core.translate('DISABLED'),
2849: select_disable,'VALUE="DISABLED"')
2850: ||wf_core.newline||
2851: htf.formSelectClose;
2852: htp.tableRowOpen;
2853: htp.tableData(cvalue=>'',
2855: calign=>'Right',cattributes=>'id=""');
2856: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
2849: select_disable,'VALUE="DISABLED"')
2850: ||wf_core.newline||
2851: htf.formSelectClose;
2852: htp.tableRowOpen;
2853: htp.tableData(cvalue=>'2854: wf_core.translate('STATUS') || '',
2855: calign=>'Right',cattributes=>'id=""');
2856: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
2857: htp.tableRowClose;
2852: htp.tableRowOpen;
2853: htp.tableData(cvalue=>'',
2855: calign=>'Right',cattributes=>'id=""');
2856: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
2857: htp.tableRowClose;
2858:
2859: -- URL to go back to
2860: htp.formHidden('url', 'Wf_Event_Html.ListAgents');
2853: htp.tableData(cvalue=>'',
2855: calign=>'Right',cattributes=>'id=""');
2856: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
2857: htp.tableRowClose;
2858:
2859: -- URL to go back to
2860: htp.formHidden('url', 'Wf_Event_Html.ListAgents');
2861:
2856: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
2857: htp.tableRowClose;
2858:
2859: -- URL to go back to
2860: htp.formHidden('url', 'Wf_Event_Html.ListAgents');
2861:
2862: htp.tableClose;
2863: htp.formClose;
2864:
2858:
2859: -- URL to go back to
2860: htp.formHidden('url', 'Wf_Event_Html.ListAgents');
2861:
2862: htp.tableClose;
2863: htp.formClose;
2864:
2865: -- add values that may contain double quote back through javascript
2866: if (h_guid is not null) then
2859: -- URL to go back to
2860: htp.formHidden('url', 'Wf_Event_Html.ListAgents');
2861:
2862: htp.tableClose;
2863: htp.formClose;
2864:
2865: -- add values that may contain double quote back through javascript
2866: if (h_guid is not null) then
2867: htp.p('');
2871: end if;
2864:
2865: -- add values that may contain double quote back through javascript
2866: if (h_guid is not null) then
2867: htp.p('');
2871: end if;
2872:
2865: -- add values that may contain double quote back through javascript
2866: if (h_guid is not null) then
2867: htp.p('');
2871: end if;
2872:
2873: -- Add submit button
2866: if (h_guid is not null) then
2867: htp.p('');
2871: end if;
2872:
2873: -- Add submit button
2874: htp.tableopen (calign=>'CENTER', cattributes=>'summary=""');
2870: htp.p('');
2871: end if;
2872:
2873: -- Add submit button
2874: htp.tableopen (calign=>'CENTER', cattributes=>'summary=""');
2875: htp.tableRowOpen;
2876:
2877: htp.p('
2871: end if;
2872:
2873: -- Add submit button
2874: htp.tableopen (calign=>'CENTER', cattributes=>'summary=""');
2875: htp.tableRowOpen;
2876:
2877: htp.p('
2873: -- Add submit button
2874: htp.tableopen (calign=>'CENTER', cattributes=>'summary=""');
2875: htp.tableRowOpen;
2876:
2877: htp.p('
2881: wfa_html.image_loc,
2882: null,
2883: wf_core.translate('SUBMIT'));
2884:
2885: htp.p('
2882: null,
2883: wf_core.translate('SUBMIT'));
2884:
2885: htp.p('
2889: wfa_html.image_loc,
2890: null,
2891: wf_core.translate ('CANCEL'));
2892:
2893: htp.p('
2891: wf_core.translate ('CANCEL'));
2892:
2893: htp.p('');
2894:
2895: htp.tableRowClose;
2896: htp.tableClose;
2897:
2898: wfa_sec.Footer;
2899: htp.htmlClose;
2892:
2893: htp.p('');
2894:
2895: htp.tableRowClose;
2896: htp.tableClose;
2897:
2898: wfa_sec.Footer;
2899: htp.htmlClose;
2900:
2895: htp.tableRowClose;
2896: htp.tableClose;
2897:
2898: wfa_sec.Footer;
2899: htp.htmlClose;
2900:
2901: exception
2902: when others then
2903: rollback;
2998: -- Check if Accessible
2999: wf_event_html.isAccessible('SUBSCRIPTIONS');
3000:
3001: -- Set page title
3002: htp.headOpen;
3003:
3004: htp.title(wf_core.translate('WFE_EDIT_SUBSC_TITLE'));
3005: wfa_html.create_help_function('wf/links/t_d.htm?'||'T_DEFEVSUB');
3006: fnd_document_management.get_open_dm_display_window;
3000:
3001: -- Set page title
3002: htp.headOpen;
3003:
3004: htp.title(wf_core.translate('WFE_EDIT_SUBSC_TITLE'));
3005: wfa_html.create_help_function('wf/links/t_d.htm?'||'T_DEFEVSUB');
3006: fnd_document_management.get_open_dm_display_window;
3007:
3008: -- JavaScript for checkagent
3019: }
3020: }'
3021: );
3022: htp.p('');
3023: htp.p('');
3024: **/
3025:
3026: htp.headClose;
3027:
3022: htp.p('');
3023: htp.p('');
3024: **/
3025:
3026: htp.headClose;
3027:
3028: -- Page header
3029: wfa_sec.Header(FALSE,
3030: owa_util.get_owa_service_path||'wf_event_html.FindSubscription',
3277:
3278: -- Hidden Form
3279: htp.p('
3278: -- Hidden Form
3279: htp.p('
3281: htp.formHidden('h_in', 'IN');
3282: htp.formClose;
3283:
3284: -- Form
3285: htp.formOpen(curl=>owa_util.get_owa_service_path||
3286: 'wf_event_html.SubmitSubscription',
3287: cmethod=>'Get',
3288: cattributes=>'TARGET="_top" NAME="WF_SUBSC_EDIT"');
3289:
3289:
3290: -- GUID
3291: -- do not display
3292: if (h_guid is not null) then
3293: htp.p('');
3294: end if;
3295: htp.formHidden('h_guid', rawtohex(h_guid));
3296:
3297: htp.tableOpen(calign=>'CENTER', cattributes=>'border=0 width=100%
3291: -- do not display
3292: if (h_guid is not null) then
3293: htp.p('');
3294: end if;
3295: htp.formHidden('h_guid', rawtohex(h_guid));
3296:
3297: htp.tableOpen(calign=>'CENTER', cattributes=>'border=0 width=100%
3298: summary=""');
3299:
3293: htp.p('');
3294: end if;
3295: htp.formHidden('h_guid', rawtohex(h_guid));
3296:
3297: htp.tableOpen(calign=>'CENTER', cattributes=>'border=0 width=100%
3298: summary=""');
3299:
3300: -- Subscriber
3301: htp.tableRowOpen;
3297: htp.tableOpen(calign=>'CENTER', cattributes=>'border=0 width=100%
3298: summary=""');
3299:
3300: -- Subscriber
3301: htp.tableRowOpen;
3302: htp.tableData(cvalue=>''||wf_core.translate('SUBSCRIBER')||'',
3303: calign=>'Left',
3304: ccolspan=>'2',
3305: cattributes=>'id=""');
3298: summary=""');
3299:
3300: -- Subscriber
3301: htp.tableRowOpen;
3302: htp.tableData(cvalue=>''||wf_core.translate('SUBSCRIBER')||'',
3303: calign=>'Left',
3304: ccolspan=>'2',
3305: cattributes=>'id=""');
3306: htp.tableRowClose;
3302: htp.tableData(cvalue=>''||wf_core.translate('SUBSCRIBER')||'',
3303: calign=>'Left',
3304: ccolspan=>'2',
3305: cattributes=>'id=""');
3306: htp.tableRowClose;
3307:
3308: -- System GUID
3309: htp.tableRowOpen;
3310: htp.tableData(cvalue=>'
3305: cattributes=>'id=""');
3306: htp.tableRowClose;
3307:
3308: -- System GUID
3309: htp.tableRowOpen;
3310: htp.tableData(cvalue=>'',
3312: calign=>'Right',cattributes=>'id=""');
3313: htp.formHidden('h_system_guid', l_sysguid);
3306: htp.tableRowClose;
3307:
3308: -- System GUID
3309: htp.tableRowOpen;
3310: htp.tableData(cvalue=>'3311: wf_core.translate('SYSTEM') || '',
3312: calign=>'Right',cattributes=>'id=""');
3313: htp.formHidden('h_system_guid', l_sysguid);
3314: -- add LOV here:
3309: htp.tableRowOpen;
3310: htp.tableData(cvalue=>'',
3312: calign=>'Right',cattributes=>'id=""');
3313: htp.formHidden('h_system_guid', l_sysguid);
3314: -- add LOV here:
3315: -- Note: The REPLACE function replaces all the space characters with
3316: -- the proper escape sequence.
3317: l_url := 'javascript:fnd_open_dm_display_window('||''''||
3324: '&p_dest_display_field=top.opener.parent.document.WF_SUBSC_EDIT.display_system.value',
3325: ' ', '%20')||''''||',500,500)';
3326:
3327: -- print everything together so there is no gap.
3328: htp.tabledata(htf.formText(cname=>'display_system', csize=>32,
3329: cmaxlength=>240,cattributes=>'id="i_system"')||
3330: ''||
3331: '',
3334: cattributes=>'id=""');
3335:
3336: htp.tableRowClose;
3337:
3338: -- Trigger
3339: htp.tableRowOpen;
3340: htp.tableData(cvalue=>''||wf_core.translate('TRIGGER')||'',
3335:
3336: htp.tableRowClose;
3337:
3338: -- Trigger
3339: htp.tableRowOpen;
3340: htp.tableData(cvalue=>''||wf_core.translate('TRIGGER')||'',
3341: calign=>'Left',
3342: ccolspan=>'2',cattributes=>'id=""');
3343: htp.tableRowClose;
3336: htp.tableRowClose;
3337:
3338: -- Trigger
3339: htp.tableRowOpen;
3340: htp.tableData(cvalue=>''||wf_core.translate('TRIGGER')||'',
3341: calign=>'Left',
3342: ccolspan=>'2',cattributes=>'id=""');
3343: htp.tableRowClose;
3344:
3339: htp.tableRowOpen;
3340: htp.tableData(cvalue=>''||wf_core.translate('TRIGGER')||'',
3341: calign=>'Left',
3342: ccolspan=>'2',cattributes=>'id=""');
3343: htp.tableRowClose;
3344:
3345: -- Source Type
3346: template := htf.formSelectOpen('h_source_type',cattributes=>'id="i_source_type"')
3347: ||wf_core.newline||
3354: htf.formSelectOption(wf_core.translate('ERROR'),
3355: select_error,'VALUE="ERROR"')
3356: ||wf_core.newline||
3357: htf.formSelectClose;
3358: htp.tableRowOpen;
3359: htp.tableData(cvalue=>'',
3361: calign=>'Right',cattributes=>'id=""');
3362: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
3355: select_error,'VALUE="ERROR"')
3356: ||wf_core.newline||
3357: htf.formSelectClose;
3358: htp.tableRowOpen;
3359: htp.tableData(cvalue=>'3360: wf_core.translate('SOURCE_TYPE') || '',
3361: calign=>'Right',cattributes=>'id=""');
3362: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
3363: htp.tableRowClose;
3358: htp.tableRowOpen;
3359: htp.tableData(cvalue=>'',
3361: calign=>'Right',cattributes=>'id=""');
3362: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
3363: htp.tableRowClose;
3364:
3365: -- Event Filter GUID
3366: htp.tableRowOpen;
3359: htp.tableData(cvalue=>'',
3361: calign=>'Right',cattributes=>'id=""');
3362: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
3363: htp.tableRowClose;
3364:
3365: -- Event Filter GUID
3366: htp.tableRowOpen;
3367: htp.tableData(cvalue=>'
3362: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
3363: htp.tableRowClose;
3364:
3365: -- Event Filter GUID
3366: htp.tableRowOpen;
3367: htp.tableData(cvalue=>'',
3369: calign=>'right',cattributes=>'id=""');
3370: htp.formHidden('h_event_guid', l_evtguid);
3363: htp.tableRowClose;
3364:
3365: -- Event Filter GUID
3366: htp.tableRowOpen;
3367: htp.tableData(cvalue=>'3368: wf_core.translate('EVENT_FILTER') || '',
3369: calign=>'right',cattributes=>'id=""');
3370: htp.formHidden('h_event_guid', l_evtguid);
3371:
3366: htp.tableRowOpen;
3367: htp.tableData(cvalue=>'',
3369: calign=>'right',cattributes=>'id=""');
3370: htp.formHidden('h_event_guid', l_evtguid);
3371:
3372: -- add LOV here:
3373: -- Note: The REPLACE function replaces all the space characters with
3374: -- the proper escape sequence.
3382: '&p_dest_display_field=top.opener.parent.document.WF_SUBSC_EDIT.display_event.value',
3383: ' ', '%20')||''''||',500,500)';
3384:
3385: -- print everything together so there is no gap.
3386: htp.tabledata(htf.formText(cname=>'display_event', csize=>60,
3387: cmaxlength=>240,cattributes=>'id="i_event"')||
3388: ''||
3389: '',
3392: cattributes=>'id=""');
3393:
3394: htp.tableRowClose;
3395:
3396: -- Source Agent GUID
3397: htp.tableRowOpen;
3398: htp.tableData(cvalue=>'
3393:
3394: htp.tableRowClose;
3395:
3396: -- Source Agent GUID
3397: htp.tableRowOpen;
3398: htp.tableData(cvalue=>'',
3400: calign=>'right',cattributes=>'id=""');
3401: htp.formHidden('h_source_agent_guid', l_srcagnguid);
3394: htp.tableRowClose;
3395:
3396: -- Source Agent GUID
3397: htp.tableRowOpen;
3398: htp.tableData(cvalue=>'3399: wf_core.translate('SOURCE_AGENT') || '',
3400: calign=>'right',cattributes=>'id=""');
3401: htp.formHidden('h_source_agent_guid', l_srcagnguid);
3402:
3397: htp.tableRowOpen;
3398: htp.tableData(cvalue=>'',
3400: calign=>'right',cattributes=>'id=""');
3401: htp.formHidden('h_source_agent_guid', l_srcagnguid);
3402:
3403: -- add LOV here:
3404: -- Note: The REPLACE function replaces all the space characters with
3405: -- the proper escape sequence.
3413: '&p_dest_display_field=top.opener.parent.document.WF_SUBSC_EDIT.display_source_agent.value',
3414: ' ', '%20')||''''||',500,500)';
3415:
3416: -- print everything together so there is no gap.
3417: htp.tabledata(htf.formText(cname=>'display_source_agent', csize=>60,
3418: cmaxlength=>240,cattributes=>'id="i_source_agent"')||
3419: ''||
3420: '',
3423: cattributes=>'id=""');
3424:
3425: htp.tableRowClose;
3426:
3427: -- Execution Control
3428: htp.tableRowOpen;
3429: htp.tableData(cvalue=>''||wf_core.translate('EXECUTION_CONTROL')||'',
3424:
3425: htp.tableRowClose;
3426:
3427: -- Execution Control
3428: htp.tableRowOpen;
3429: htp.tableData(cvalue=>''||wf_core.translate('EXECUTION_CONTROL')||'',
3430: calign=>'Left',
3431: ccolspan=>'2',cattributes=>'id=""');
3432: htp.tableRowClose;
3425: htp.tableRowClose;
3426:
3427: -- Execution Control
3428: htp.tableRowOpen;
3429: htp.tableData(cvalue=>''||wf_core.translate('EXECUTION_CONTROL')||'',
3430: calign=>'Left',
3431: ccolspan=>'2',cattributes=>'id=""');
3432: htp.tableRowClose;
3433:
3428: htp.tableRowOpen;
3429: htp.tableData(cvalue=>''||wf_core.translate('EXECUTION_CONTROL')||'',
3430: calign=>'Left',
3431: ccolspan=>'2',cattributes=>'id=""');
3432: htp.tableRowClose;
3433:
3434: -- Phase
3435: htp.tableRowOpen;
3436: htp.tableData(cvalue=>'
3431: ccolspan=>'2',cattributes=>'id=""');
3432: htp.tableRowClose;
3433:
3434: -- Phase
3435: htp.tableRowOpen;
3436: htp.tableData(cvalue=>'',
3438: calign=>'Right',cattributes=>'id=""');
3439: htp.tableData(cvalue=>htf.formText(cname=>'h_phase', csize=>16,
3432: htp.tableRowClose;
3433:
3434: -- Phase
3435: htp.tableRowOpen;
3436: htp.tableData(cvalue=>'3437: wf_core.translate('PHASE') || '',
3438: calign=>'Right',cattributes=>'id=""');
3439: htp.tableData(cvalue=>htf.formText(cname=>'h_phase', csize=>16,
3440: cmaxlength=>16, cvalue=>to_char(l_phase),
3435: htp.tableRowOpen;
3436: htp.tableData(cvalue=>'',
3438: calign=>'Right',cattributes=>'id=""');
3439: htp.tableData(cvalue=>htf.formText(cname=>'h_phase', csize=>16,
3440: cmaxlength=>16, cvalue=>to_char(l_phase),
3441: cattributes=>'id="i_phase"'),
3442: calign=>'Left',cattributes=>'id=""');
3443: htp.tableRowClose;
3439: htp.tableData(cvalue=>htf.formText(cname=>'h_phase', csize=>16,
3440: cmaxlength=>16, cvalue=>to_char(l_phase),
3441: cattributes=>'id="i_phase"'),
3442: calign=>'Left',cattributes=>'id=""');
3443: htp.tableRowClose;
3444:
3445: -- Status
3446: template := htf.formSelectOpen('h_status',cattributes=>'id="i_status"')
3447: ||wf_core.newline||
3451: htf.formSelectOption(wf_core.translate('DISABLED'),
3452: select_disable,'VALUE="DISABLED"')
3453: ||wf_core.newline||
3454: htf.formSelectClose;
3455: htp.tableRowOpen;
3456: htp.tableData(cvalue=>'',
3458: calign=>'Right',cattributes=>'id=""');
3459: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
3452: select_disable,'VALUE="DISABLED"')
3453: ||wf_core.newline||
3454: htf.formSelectClose;
3455: htp.tableRowOpen;
3456: htp.tableData(cvalue=>'3457: wf_core.translate('STATUS') || '',
3458: calign=>'Right',cattributes=>'id=""');
3459: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
3460: htp.tableRowClose;
3455: htp.tableRowOpen;
3456: htp.tableData(cvalue=>'',
3458: calign=>'Right',cattributes=>'id=""');
3459: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
3460: htp.tableRowClose;
3461:
3462: -- Rule Data
3463: template := htf.formSelectOpen('h_rule_data',cattributes=>'id="i_rule_data"')
3456: htp.tableData(cvalue=>'',
3458: calign=>'Right',cattributes=>'id=""');
3459: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
3460: htp.tableRowClose;
3461:
3462: -- Rule Data
3463: template := htf.formSelectOpen('h_rule_data',cattributes=>'id="i_rule_data"')
3464: ||wf_core.newline||
3468: htf.formSelectOption(wf_core.translate('MESSAGE'),
3469: select_message,'VALUE="MESSAGE"')
3470: ||wf_core.newline||
3471: htf.formSelectClose;
3472: htp.tableRowOpen;
3473: htp.tableData(cvalue=>'',
3475: calign=>'Right', cattributes=>'id=""');
3476: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
3469: select_message,'VALUE="MESSAGE"')
3470: ||wf_core.newline||
3471: htf.formSelectClose;
3472: htp.tableRowOpen;
3473: htp.tableData(cvalue=>'3474: wf_core.translate('RULE_DATA') || '',
3475: calign=>'Right', cattributes=>'id=""');
3476: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
3477: htp.tableRowClose;
3472: htp.tableRowOpen;
3473: htp.tableData(cvalue=>'',
3475: calign=>'Right', cattributes=>'id=""');
3476: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
3477: htp.tableRowClose;
3478:
3479: -- Action
3480: htp.tableRowOpen;
3473: htp.tableData(cvalue=>'',
3475: calign=>'Right', cattributes=>'id=""');
3476: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
3477: htp.tableRowClose;
3478:
3479: -- Action
3480: htp.tableRowOpen;
3481: htp.tableData(cvalue=>''||wf_core.translate('ACTION')||'',
3476: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
3477: htp.tableRowClose;
3478:
3479: -- Action
3480: htp.tableRowOpen;
3481: htp.tableData(cvalue=>''||wf_core.translate('ACTION')||'',
3482: calign=>'Left',
3483: ccolspan=>'2',cattributes=>'id=""');
3484: htp.tableRowClose;
3477: htp.tableRowClose;
3478:
3479: -- Action
3480: htp.tableRowOpen;
3481: htp.tableData(cvalue=>''||wf_core.translate('ACTION')||'',
3482: calign=>'Left',
3483: ccolspan=>'2',cattributes=>'id=""');
3484: htp.tableRowClose;
3485:
3480: htp.tableRowOpen;
3481: htp.tableData(cvalue=>''||wf_core.translate('ACTION')||'',
3482: calign=>'Left',
3483: ccolspan=>'2',cattributes=>'id=""');
3484: htp.tableRowClose;
3485:
3486: -- Rule Function
3487: htp.tableRowOpen;
3488: htp.tableData(cvalue=>'
3483: ccolspan=>'2',cattributes=>'id=""');
3484: htp.tableRowClose;
3485:
3486: -- Rule Function
3487: htp.tableRowOpen;
3488: htp.tableData(cvalue=>'',
3490: calign=>'Right',cattributes=>'id=""');
3491: htp.tableData(cvalue=>htf.formText(cname=>'h_rule_function', csize=>60,
3484: htp.tableRowClose;
3485:
3486: -- Rule Function
3487: htp.tableRowOpen;
3488: htp.tableData(cvalue=>'3489: wf_core.translate('RULE_FUNCTION') || '',
3490: calign=>'Right',cattributes=>'id=""');
3491: htp.tableData(cvalue=>htf.formText(cname=>'h_rule_function', csize=>60,
3492: cmaxlength=>240, cvalue=>l_rulef,
3487: htp.tableRowOpen;
3488: htp.tableData(cvalue=>'',
3490: calign=>'Right',cattributes=>'id=""');
3491: htp.tableData(cvalue=>htf.formText(cname=>'h_rule_function', csize=>60,
3492: cmaxlength=>240, cvalue=>l_rulef,
3493: cattributes=>'id="i_rule_function"' ),
3494: calign=>'Left',cattributes=>'id=""');
3495: htp.tableRowClose;
3491: htp.tableData(cvalue=>htf.formText(cname=>'h_rule_function', csize=>60,
3492: cmaxlength=>240, cvalue=>l_rulef,
3493: cattributes=>'id="i_rule_function"' ),
3494: calign=>'Left',cattributes=>'id=""');
3495: htp.tableRowClose;
3496:
3497: -- WF Process Type
3498: htp.tableRowOpen;
3499: htp.tableData(cvalue=>'
3494: calign=>'Left',cattributes=>'id=""');
3495: htp.tableRowClose;
3496:
3497: -- WF Process Type
3498: htp.tableRowOpen;
3499: htp.tableData(cvalue=>'',
3501: calign=>'Right',cattributes=>'id=""');
3502: htp.formHidden('h_wfptype_dname', l_wfptype_dname);
3495: htp.tableRowClose;
3496:
3497: -- WF Process Type
3498: htp.tableRowOpen;
3499: htp.tableData(cvalue=>'3500: wf_core.translate('WF_PROCESS_TYPE') || '',
3501: calign=>'Right',cattributes=>'id=""');
3502: htp.formHidden('h_wfptype_dname', l_wfptype_dname);
3503:
3498: htp.tableRowOpen;
3499: htp.tableData(cvalue=>'',
3501: calign=>'Right',cattributes=>'id=""');
3502: htp.formHidden('h_wfptype_dname', l_wfptype_dname);
3503:
3504: -- add LOV here:
3505: -- Note: The REPLACE function replaces all the space characters with
3506: -- the proper escape sequence.
3514: '&p_dest_display_field=top.opener.parent.document.WF_SUBSC_EDIT.h_wfptype.value',
3515: ' ', '%20')||''''||',500,500)';
3516:
3517: -- print everything together so there is no gap.
3518: htp.tableData(cvalue=>htf.formText(cname=>'h_wfptype', csize=>30,
3519: cmaxlength=>30, cvalue=>l_wfptype,
3520: cattributes=>'id="i_process_type"')||
3521: ''||
3522: '',
3525: calign=>'Left',cattributes=>'id=""');
3526: htp.tableRowClose;
3527:
3528: -- WF Process Name
3529: htp.tableRowOpen;
3530: htp.tableData(cvalue=>'
3525: calign=>'Left',cattributes=>'id=""');
3526: htp.tableRowClose;
3527:
3528: -- WF Process Name
3529: htp.tableRowOpen;
3530: htp.tableData(cvalue=>'',
3532: calign=>'Right',cattributes=>'id=""');
3533: htp.formHidden('h_wfptn'); -- holding the hidden field value
3526: htp.tableRowClose;
3527:
3528: -- WF Process Name
3529: htp.tableRowOpen;
3530: htp.tableData(cvalue=>'3531: wf_core.translate('WF_PROCESS_NAME') || '',
3532: calign=>'Right',cattributes=>'id=""');
3533: htp.formHidden('h_wfptn'); -- holding the hidden field value
3534:
3529: htp.tableRowOpen;
3530: htp.tableData(cvalue=>'',
3532: calign=>'Right',cattributes=>'id=""');
3533: htp.formHidden('h_wfptn'); -- holding the hidden field value
3534:
3535: -- add LOV here:
3536: -- Note: The REPLACE function replaces all the space characters with
3537: -- the proper escape sequence.
3546: '&p_param1=top.opener.parent.document.WF_SUBSC_EDIT.h_wfptype.value',
3547: ' ', '%20')||''''||',500,500)';
3548:
3549: -- print everything together so there is no gap.
3550: htp.tableData(cvalue=>htf.formText(cname=>'h_wfpname', csize=>30,
3551: cmaxlength=>30, cvalue=>l_wfpname,
3552: cattributes=>'id="i_process_name"')||
3553: ''||
3554: '',
3557: calign=>'Left',cattributes=>'id=""');
3558:
3559: htp.tableRowClose;
3560:
3561: -- Out Agent GUID
3562: htp.tableRowOpen;
3563: htp.tableData(cvalue=>'
3558:
3559: htp.tableRowClose;
3560:
3561: -- Out Agent GUID
3562: htp.tableRowOpen;
3563: htp.tableData(cvalue=>'',
3565: calign=>'right',cattributes=>'id=""');
3566: htp.formHidden('h_out_agent_guid', l_outagnguid);
3559: htp.tableRowClose;
3560:
3561: -- Out Agent GUID
3562: htp.tableRowOpen;
3563: htp.tableData(cvalue=>'3564: wf_core.translate('OUT_AGENT') || '',
3565: calign=>'right',cattributes=>'id=""');
3566: htp.formHidden('h_out_agent_guid', l_outagnguid);
3567:
3562: htp.tableRowOpen;
3563: htp.tableData(cvalue=>'',
3565: calign=>'right',cattributes=>'id=""');
3566: htp.formHidden('h_out_agent_guid', l_outagnguid);
3567:
3568: -- add LOV here:
3569: -- Note: The REPLACE function replaces all the space characters with
3570: -- the proper escape sequence.
3580: '&p_param2=top.opener.parent.document.WF_SUBSC_EDIT.display_system.value',
3581: ' ', '%20')||''''||',500,500)';
3582:
3583: -- print everything together so there is no gap.
3584: htp.tabledata(htf.formText(cname=>'display_out_agent', csize=>60,
3585: cmaxlength=>240,
3586: cattributes=>'id="i_out_agent"')||
3587: ''||
3588: '',
3591: cattributes=>'id=""');
3592:
3593: htp.tableRowClose;
3594:
3595: -- To Agent GUID
3596: htp.tableRowOpen;
3597: htp.tableData(cvalue=>'
3592:
3593: htp.tableRowClose;
3594:
3595: -- To Agent GUID
3596: htp.tableRowOpen;
3597: htp.tableData(cvalue=>'',
3599: calign=>'right',cattributes=>'id=""');
3600: htp.formHidden('h_to_agent_guid', l_toagnguid);
3593: htp.tableRowClose;
3594:
3595: -- To Agent GUID
3596: htp.tableRowOpen;
3597: htp.tableData(cvalue=>'3598: ||wf_core.translate('TO_AGENT') || '',
3599: calign=>'right',cattributes=>'id=""');
3600: htp.formHidden('h_to_agent_guid', l_toagnguid);
3601:
3596: htp.tableRowOpen;
3597: htp.tableData(cvalue=>'',
3599: calign=>'right',cattributes=>'id=""');
3600: htp.formHidden('h_to_agent_guid', l_toagnguid);
3601:
3602: -- add LOV here:
3603: -- Note: The REPLACE function replaces all the space characters with
3604: -- the proper escape sequence.
3613: '&p_param1=top.opener.parent.document.WF_HIDDEN.h_in.value',
3614: ' ', '%20')||''''||',500,500)';
3615:
3616: -- print everything together so there is no gap.
3617: htp.tabledata(htf.formText(cname=>'display_to_agent', csize=>60,
3618: cmaxlength=>240,
3619: cattributes=>'id="i_to_agent"')||
3620: ''||
3621: '',
3624: cattributes=>'id=""');
3625:
3626: htp.tableRowClose;
3627:
3628: -- Priority
3629: template := htf.formSelectOpen('h_priority',cattributes=>'id="i_priority"')
3630: ||wf_core.newline||
3637: htf.formSelectOption(wf_core.translate('LOW'),
3638: select_low,'VALUE='||l_low)
3639: ||wf_core.newline||
3640: htf.formSelectClose;
3641: htp.tableRowOpen;
3642: htp.tableData(cvalue=>'',
3644: calign=>'Right',cattributes=>'id=""');
3645: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
3638: select_low,'VALUE='||l_low)
3639: ||wf_core.newline||
3640: htf.formSelectClose;
3641: htp.tableRowOpen;
3642: htp.tableData(cvalue=>'3643: wf_core.translate('PRIORITY') || '',
3644: calign=>'Right',cattributes=>'id=""');
3645: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
3646: htp.tableRowClose;
3641: htp.tableRowOpen;
3642: htp.tableData(cvalue=>'',
3644: calign=>'Right',cattributes=>'id=""');
3645: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
3646: htp.tableRowClose;
3647:
3648: -- Parameters
3649: htp.tableRowOpen;
3642: htp.tableData(cvalue=>'',
3644: calign=>'Right',cattributes=>'id=""');
3645: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
3646: htp.tableRowClose;
3647:
3648: -- Parameters
3649: htp.tableRowOpen;
3650: htp.tableData(cvalue=>'
3645: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
3646: htp.tableRowClose;
3647:
3648: -- Parameters
3649: htp.tableRowOpen;
3650: htp.tableData(cvalue=>'',
3652: calign=>'Right',cattributes=>'id=""');
3653: htp.tableData(cvalue=>htf.formTextareaOpen2(
3646: htp.tableRowClose;
3647:
3648: -- Parameters
3649: htp.tableRowOpen;
3650: htp.tableData(cvalue=>'3651: wf_core.translate('PARAMETERS') || '',
3652: calign=>'Right',cattributes=>'id=""');
3653: htp.tableData(cvalue=>htf.formTextareaOpen2(
3654: cname=>'h_parameters',
3649: htp.tableRowOpen;
3650: htp.tableData(cvalue=>'',
3652: calign=>'Right',cattributes=>'id=""');
3653: htp.tableData(cvalue=>htf.formTextareaOpen2(
3654: cname=>'h_parameters',
3655: nrows=>2,
3656: ncolumns=>60,
3657: cwrap=>'SOFT',
3659: id="i_parameters"')
3660: ||l_param
3661: ||htf.formTextareaClose,
3662: calign=>'Left',cattributes=>'id=""');
3663: htp.tableRowClose;
3664:
3665: -- Documentation
3666: htp.tableRowOpen;
3667: htp.tableData(cvalue=>''||wf_core.translate('DOCUMENTATION')||'',
3662: calign=>'Left',cattributes=>'id=""');
3663: htp.tableRowClose;
3664:
3665: -- Documentation
3666: htp.tableRowOpen;
3667: htp.tableData(cvalue=>''||wf_core.translate('DOCUMENTATION')||'',
3668: calign=>'Left',
3669: ccolspan=>'2',cattributes=>'id=""');
3670: htp.tableRowClose;
3663: htp.tableRowClose;
3664:
3665: -- Documentation
3666: htp.tableRowOpen;
3667: htp.tableData(cvalue=>''||wf_core.translate('DOCUMENTATION')||'',
3668: calign=>'Left',
3669: ccolspan=>'2',cattributes=>'id=""');
3670: htp.tableRowClose;
3671:
3666: htp.tableRowOpen;
3667: htp.tableData(cvalue=>''||wf_core.translate('DOCUMENTATION')||'',
3668: calign=>'Left',
3669: ccolspan=>'2',cattributes=>'id=""');
3670: htp.tableRowClose;
3671:
3672: -- Owner Name
3673: htp.tableRowOpen;
3674: htp.tableData(cvalue=>'
3669: ccolspan=>'2',cattributes=>'id=""');
3670: htp.tableRowClose;
3671:
3672: -- Owner Name
3673: htp.tableRowOpen;
3674: htp.tableData(cvalue=>'',
3676: calign=>'Right',cattributes=>'id=""');
3677: htp.tableData(cvalue=>htf.formText(cname=>'h_owner_name', csize=>30,
3670: htp.tableRowClose;
3671:
3672: -- Owner Name
3673: htp.tableRowOpen;
3674: htp.tableData(cvalue=>'3675: wf_core.translate('OWNER_NAME') || '',
3676: calign=>'Right',cattributes=>'id=""');
3677: htp.tableData(cvalue=>htf.formText(cname=>'h_owner_name', csize=>30,
3678: cmaxlength=>30,
3673: htp.tableRowOpen;
3674: htp.tableData(cvalue=>'',
3676: calign=>'Right',cattributes=>'id=""');
3677: htp.tableData(cvalue=>htf.formText(cname=>'h_owner_name', csize=>30,
3678: cmaxlength=>30,
3679: cattributes=>'id="i_owner_name"'),
3680: calign=>'Left',cattributes=>'id=""');
3681: htp.tableRowClose;
3677: htp.tableData(cvalue=>htf.formText(cname=>'h_owner_name', csize=>30,
3678: cmaxlength=>30,
3679: cattributes=>'id="i_owner_name"'),
3680: calign=>'Left',cattributes=>'id=""');
3681: htp.tableRowClose;
3682:
3683: -- Owner Tag
3684: htp.tableRowOpen;
3685: htp.tableData(cvalue=>'
3680: calign=>'Left',cattributes=>'id=""');
3681: htp.tableRowClose;
3682:
3683: -- Owner Tag
3684: htp.tableRowOpen;
3685: htp.tableData(cvalue=>'',
3687: calign=>'Right',cattributes=>'id=""');
3688: htp.tableData(cvalue=>htf.formText(cname=>'h_owner_tag', csize=>30,
3681: htp.tableRowClose;
3682:
3683: -- Owner Tag
3684: htp.tableRowOpen;
3685: htp.tableData(cvalue=>'3686: wf_core.translate('OWNER_TAG') || '',
3687: calign=>'Right',cattributes=>'id=""');
3688: htp.tableData(cvalue=>htf.formText(cname=>'h_owner_tag', csize=>30,
3689: cmaxlength=>30,
3684: htp.tableRowOpen;
3685: htp.tableData(cvalue=>'',
3687: calign=>'Right',cattributes=>'id=""');
3688: htp.tableData(cvalue=>htf.formText(cname=>'h_owner_tag', csize=>30,
3689: cmaxlength=>30,
3690: cattributes=>'id="i_owner_tag"'),
3691: calign=>'Left',cattributes=>'id=""');
3692: htp.tableRowClose;
3688: htp.tableData(cvalue=>htf.formText(cname=>'h_owner_tag', csize=>30,
3689: cmaxlength=>30,
3690: cattributes=>'id="i_owner_tag"'),
3691: calign=>'Left',cattributes=>'id=""');
3692: htp.tableRowClose;
3693:
3694: -- Customization Level
3695: if wf_events_pkg.g_Mode = 'FORCE' then
3696: template := htf.formSelectOpen('h_custom_level',cattributes=>'id="i_custom_level"')
3704: htf.formSelectOption(wf_core.translate('WFE_CUSTOM_LEVEL_U'),
3705: select_custom_user,'VALUE="U"')
3706: ||wf_core.newline||
3707: htf.formSelectClose;
3708: htp.tableRowOpen;
3709: htp.tableData(cvalue=>'',
3711: calign=>'Right',cattributes=>'id=""');
3712: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
3705: select_custom_user,'VALUE="U"')
3706: ||wf_core.newline||
3707: htf.formSelectClose;
3708: htp.tableRowOpen;
3709: htp.tableData(cvalue=>'3710: wf_core.translate('WFE_CUSTOM_LEVEL') || '',
3711: calign=>'Right',cattributes=>'id=""');
3712: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
3713: htp.tableRowClose;
3708: htp.tableRowOpen;
3709: htp.tableData(cvalue=>'',
3711: calign=>'Right',cattributes=>'id=""');
3712: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
3713: htp.tableRowClose;
3714: else
3715: if l_customization_level='L' then -- Bug 2756800
3716: template := htf.formSelectOpen('h_custom_level',cattributes=>'id="i_custom_level"')
3709: htp.tableData(cvalue=>'',
3711: calign=>'Right',cattributes=>'id=""');
3712: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
3713: htp.tableRowClose;
3714: else
3715: if l_customization_level='L' then -- Bug 2756800
3716: template := htf.formSelectOpen('h_custom_level',cattributes=>'id="i_custom_level"')
3717: ||wf_core.newline||
3721: htf.formSelectOption(wf_core.translate('WFE_CUSTOM_LEVEL_L'),
3722: select_custom_limit,'VALUE="L"')
3723: ||wf_core.newline||
3724: htf.formSelectClose;
3725: htp.tableRowOpen;
3726: htp.tableData(cvalue=>'',
3728: calign=>'Right',cattributes=>'id=""');
3729: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
3722: select_custom_limit,'VALUE="L"')
3723: ||wf_core.newline||
3724: htf.formSelectClose;
3725: htp.tableRowOpen;
3726: htp.tableData(cvalue=>'3727: wf_core.translate('WFE_CUSTOM_LEVEL') || '',
3728: calign=>'Right',cattributes=>'id=""');
3729: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
3730: htp.tableRowClose;
3725: htp.tableRowOpen;
3726: htp.tableData(cvalue=>'',
3728: calign=>'Right',cattributes=>'id=""');
3729: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
3730: htp.tableRowClose;
3731: else
3732: htp.tableRowOpen;
3733: htp.tableData(cvalue=>wf_core.translate('WFE_CUSTOM_LEVEL'),
3726: htp.tableData(cvalue=>'',
3728: calign=>'Right',cattributes=>'id=""');
3729: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
3730: htp.tableRowClose;
3731: else
3732: htp.tableRowOpen;
3733: htp.tableData(cvalue=>wf_core.translate('WFE_CUSTOM_LEVEL'),
3734: calign=>'Right',cattributes=>'id=""');
3728: calign=>'Right',cattributes=>'id=""');
3729: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
3730: htp.tableRowClose;
3731: else
3732: htp.tableRowOpen;
3733: htp.tableData(cvalue=>wf_core.translate('WFE_CUSTOM_LEVEL'),
3734: calign=>'Right',cattributes=>'id=""');
3735: htp.tableData(cvalue=>wf_core.translate('WFE_CUSTOM_LEVEL_'||l_customization_level),
3736: calign=>'Left',cattributes=>'id=""');
3729: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
3730: htp.tableRowClose;
3731: else
3732: htp.tableRowOpen;
3733: htp.tableData(cvalue=>wf_core.translate('WFE_CUSTOM_LEVEL'),
3734: calign=>'Right',cattributes=>'id=""');
3735: htp.tableData(cvalue=>wf_core.translate('WFE_CUSTOM_LEVEL_'||l_customization_level),
3736: calign=>'Left',cattributes=>'id=""');
3737: htp.formHidden('h_custom_level', l_customization_level);
3731: else
3732: htp.tableRowOpen;
3733: htp.tableData(cvalue=>wf_core.translate('WFE_CUSTOM_LEVEL'),
3734: calign=>'Right',cattributes=>'id=""');
3735: htp.tableData(cvalue=>wf_core.translate('WFE_CUSTOM_LEVEL_'||l_customization_level),
3736: calign=>'Left',cattributes=>'id=""');
3737: htp.formHidden('h_custom_level', l_customization_level);
3738: end if; -- Bug 2756800
3739: end if;
3733: htp.tableData(cvalue=>wf_core.translate('WFE_CUSTOM_LEVEL'),
3734: calign=>'Right',cattributes=>'id=""');
3735: htp.tableData(cvalue=>wf_core.translate('WFE_CUSTOM_LEVEL_'||l_customization_level),
3736: calign=>'Left',cattributes=>'id=""');
3737: htp.formHidden('h_custom_level', l_customization_level);
3738: end if; -- Bug 2756800
3739: end if;
3740:
3741: -- Description
3738: end if; -- Bug 2756800
3739: end if;
3740:
3741: -- Description
3742: htp.tableRowOpen;
3743: htp.tableData(cvalue=>'',
3745: calign=>'Right',cattributes=>'id=""');
3746: htp.tableData(cvalue=>htf.formTextareaOpen2(
3739: end if;
3740:
3741: -- Description
3742: htp.tableRowOpen;
3743: htp.tableData(cvalue=>'3744: wf_core.translate('DESCRIPTION') || '',
3745: calign=>'Right',cattributes=>'id=""');
3746: htp.tableData(cvalue=>htf.formTextareaOpen2(
3747: cname=>'h_description',
3742: htp.tableRowOpen;
3743: htp.tableData(cvalue=>'',
3745: calign=>'Right',cattributes=>'id=""');
3746: htp.tableData(cvalue=>htf.formTextareaOpen2(
3747: cname=>'h_description',
3748: nrows=>2,
3749: ncolumns=>60,
3750: cwrap=>'SOFT',
3751: cattributes=>'maxlength=240 id="i_description"')
3752: ||l_desc
3753: ||htf.formTextareaClose,
3754: calign=>'Left',cattributes=>'id=""');
3755: htp.tableRowClose;
3756:
3757: -- URL to go back to
3758: htp.formHidden('url', 'Wf_Event_Html.ListSubscriptions');
3759:
3754: calign=>'Left',cattributes=>'id=""');
3755: htp.tableRowClose;
3756:
3757: -- URL to go back to
3758: htp.formHidden('url', 'Wf_Event_Html.ListSubscriptions');
3759:
3760: htp.tableClose;
3761: htp.formClose;
3762:
3756:
3757: -- URL to go back to
3758: htp.formHidden('url', 'Wf_Event_Html.ListSubscriptions');
3759:
3760: htp.tableClose;
3761: htp.formClose;
3762:
3763: -- add values that may contain double quote back through javascript
3764: -- ### although some of the values are now the internal name; hence,
3757: -- URL to go back to
3758: htp.formHidden('url', 'Wf_Event_Html.ListSubscriptions');
3759:
3760: htp.tableClose;
3761: htp.formClose;
3762:
3763: -- add values that may contain double quote back through javascript
3764: -- ### although some of the values are now the internal name; hence,
3765: -- ### no more double quote for them, but we left this mechanism behind
3774: htp.p(' document.WF_SUBSC_EDIT.display_source_agent.value="'||
3775: l_srcagn_dname||'"');
3776: htp.p(' document.WF_SUBSC_EDIT.display_out_agent.value="'||
3777: l_outagn_dname||'"');
3778: htp.p(' document.WF_SUBSC_EDIT.display_to_agent.value="'||
3779: l_toagn_dname||'"');
3780: htp.p('');
3781:
3782: -- Add submit button
3776: htp.p(' document.WF_SUBSC_EDIT.display_out_agent.value="'||
3777: l_outagn_dname||'"');
3778: htp.p(' document.WF_SUBSC_EDIT.display_to_agent.value="'||
3779: l_toagn_dname||'"');
3780: htp.p('');
3781:
3782: -- Add submit button
3783: htp.tableopen (calign=>'CENTER', cattributes=>'summary=""');
3784: htp.tableRowOpen;
3779: l_toagn_dname||'"');
3780: htp.p('');
3781:
3782: -- Add submit button
3783: htp.tableopen (calign=>'CENTER', cattributes=>'summary=""');
3784: htp.tableRowOpen;
3785:
3786: htp.p('
3780: htp.p('');
3781:
3782: -- Add submit button
3783: htp.tableopen (calign=>'CENTER', cattributes=>'summary=""');
3784: htp.tableRowOpen;
3785:
3786: htp.p('
3782: -- Add submit button
3783: htp.tableopen (calign=>'CENTER', cattributes=>'summary=""');
3784: htp.tableRowOpen;
3785:
3786: htp.p('
3790: wfa_html.image_loc,
3791: null,
3792: wf_core.translate('SUBMIT'));
3793:
3794: htp.p('
3791: null,
3792: wf_core.translate('SUBMIT'));
3793:
3794: htp.p('
3798: wfa_html.image_loc,
3799: null,
3800: wf_core.translate ('CANCEL'));
3801:
3802: htp.p('
3800: wf_core.translate ('CANCEL'));
3801:
3802: htp.p('');
3803:
3804: htp.tableRowClose;
3805: htp.tableClose;
3806:
3807: wfa_sec.Footer;
3808: htp.htmlClose;
3801:
3802: htp.p('');
3803:
3804: htp.tableRowClose;
3805: htp.tableClose;
3806:
3807: wfa_sec.Footer;
3808: htp.htmlClose;
3809:
3804: htp.tableRowClose;
3805: htp.tableClose;
3806:
3807: wfa_sec.Footer;
3808: htp.htmlClose;
3809:
3810: exception
3811: when OTHERS then
3812: rollback;
4372: end;
4373:
4374: -- also print a message about adding to group
4375: -- E.g. Narrow selection for adding to group
4376: -- htp.p(wf_core.translate('WFE_FIND_FOR_GROUP'));
4377:
4378: title := wf_core.translate('WFE_ADD_TO_GROUP')||': '||l_name;
4379: helptext := 'wf/links/t_d.htm?T_DEFEVGPM';
4380: else
4383: helptext := 'wf/links/t_f.htm?T_FDEVT';
4384: end if;
4385:
4386: -- Render page
4387: htp.htmlOpen;
4388:
4389: -- Set page title
4390: htp.headOpen;
4391:
4386: -- Render page
4387: htp.htmlOpen;
4388:
4389: -- Set page title
4390: htp.headOpen;
4391:
4392: -- only expire page if there is potential of having a list
4393:
4394: if (x_gguid is not null and h_guid is not null) then
4393:
4394: if (x_gguid is not null and h_guid is not null) then
4395: -- list does not get updated after edit, so we add the
4396: -- following tag to force the reload of page.
4397: htp.p('');
4398: end if;
4399:
4400: htp.title(title);
4401: wfa_html.create_help_function(helptext);
4396: -- following tag to force the reload of page.
4397: htp.p('');
4398: end if;
4399:
4400: htp.title(title);
4401: wfa_html.create_help_function(helptext);
4402: fnd_document_management.get_open_dm_display_window;
4403:
4404: Wfe_Html_Util.generate_check_all;
4402: fnd_document_management.get_open_dm_display_window;
4403:
4404: Wfe_Html_Util.generate_check_all;
4405:
4406: htp.headClose;
4407:
4408: -- Page header
4409: wfa_sec.Header(FALSE, null, title, TRUE);
4410:
4408: -- Page header
4409: wfa_sec.Header(FALSE, null, title, TRUE);
4410:
4411: -- Form
4412: htp.formOpen(curl=>owa_util.get_owa_service_path||l_url,
4413: cmethod=>'Get',
4414: cattributes=>'TARGET="_top" NAME="WF_EVENT_FIND"');
4415:
4416: htp.tableOpen(calign=>'CENTER', cattributes=>'border=0 summary=""');
4412: htp.formOpen(curl=>owa_util.get_owa_service_path||l_url,
4413: cmethod=>'Get',
4414: cattributes=>'TARGET="_top" NAME="WF_EVENT_FIND"');
4415:
4416: htp.tableOpen(calign=>'CENTER', cattributes=>'border=0 summary=""');
4417:
4418: -- hidden attribute for FindEvent
4419: if (x_gguid is not null) then
4420: htp.formHidden('x_gguid', x_gguid);
4416: htp.tableOpen(calign=>'CENTER', cattributes=>'border=0 summary=""');
4417:
4418: -- hidden attribute for FindEvent
4419: if (x_gguid is not null) then
4420: htp.formHidden('x_gguid', x_gguid);
4421: htp.formHidden('h_guid', x_gguid);
4422: end if;
4423:
4424: -- Name
4417:
4418: -- hidden attribute for FindEvent
4419: if (x_gguid is not null) then
4420: htp.formHidden('x_gguid', x_gguid);
4421: htp.formHidden('h_guid', x_gguid);
4422: end if;
4423:
4424: -- Name
4425: htp.tableRowOpen;
4421: htp.formHidden('h_guid', x_gguid);
4422: end if;
4423:
4424: -- Name
4425: htp.tableRowOpen;
4426: htp.tableData(cvalue=>'',
4428: calign=>'Right', cattributes=>'id=""');
4429: htp.tableData(cvalue=>htf.formText(cname=>'h_name', csize=>40,
4422: end if;
4423:
4424: -- Name
4425: htp.tableRowOpen;
4426: htp.tableData(cvalue=>'4427: wf_core.translate('NAME') || '',
4428: calign=>'Right', cattributes=>'id=""');
4429: htp.tableData(cvalue=>htf.formText(cname=>'h_name', csize=>40,
4430: cmaxlength=>240,
4425: htp.tableRowOpen;
4426: htp.tableData(cvalue=>'',
4428: calign=>'Right', cattributes=>'id=""');
4429: htp.tableData(cvalue=>htf.formText(cname=>'h_name', csize=>40,
4430: cmaxlength=>240,
4431: cattributes=>'id="i_name"'),
4432: calign=>'Left',cattributes=>'id=""');
4433: htp.tableRowClose;
4429: htp.tableData(cvalue=>htf.formText(cname=>'h_name', csize=>40,
4430: cmaxlength=>240,
4431: cattributes=>'id="i_name"'),
4432: calign=>'Left',cattributes=>'id=""');
4433: htp.tableRowClose;
4434:
4435: -- Display Name
4436: htp.tableRowOpen;
4437: htp.tableData(cvalue=>'
4432: calign=>'Left',cattributes=>'id=""');
4433: htp.tableRowClose;
4434:
4435: -- Display Name
4436: htp.tableRowOpen;
4437: htp.tableData(cvalue=>'',
4439: calign=>'Right',cattributes=>'id=""');
4440: htp.tableData(cvalue=>htf.formText(cname=>'h_display_name', csize=>60,
4433: htp.tableRowClose;
4434:
4435: -- Display Name
4436: htp.tableRowOpen;
4437: htp.tableData(cvalue=>'4438: wf_core.translate('DISPLAY_NAME') || '',
4439: calign=>'Right',cattributes=>'id=""');
4440: htp.tableData(cvalue=>htf.formText(cname=>'h_display_name', csize=>60,
4441: cmaxlength=>80,
4436: htp.tableRowOpen;
4437: htp.tableData(cvalue=>'',
4439: calign=>'Right',cattributes=>'id=""');
4440: htp.tableData(cvalue=>htf.formText(cname=>'h_display_name', csize=>60,
4441: cmaxlength=>80,
4442: cattributes=>'id="i_display_name"'),
4443: calign=>'Left',cattributes=>'id=""');
4444: htp.tableRowClose;
4440: htp.tableData(cvalue=>htf.formText(cname=>'h_display_name', csize=>60,
4441: cmaxlength=>80,
4442: cattributes=>'id="i_display_name"'),
4443: calign=>'Left',cattributes=>'id=""');
4444: htp.tableRowClose;
4445:
4446: -- Status
4447: template := htf.formSelectOpen('h_status',cattributes=>'id="i_status"')
4448: ||wf_core.newline;
4472: selected := TRUE;
4473: end if;
4474: template := template||wf_core.newline||htf.formSelectClose;
4475:
4476: htp.tableRowOpen;
4477: htp.tableData(cvalue=>'',
4479: calign=>'Right',cattributes=>'id=""');
4480: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
4473: end if;
4474: template := template||wf_core.newline||htf.formSelectClose;
4475:
4476: htp.tableRowOpen;
4477: htp.tableData(cvalue=>'4478: wf_core.translate('STATUS') || '',
4479: calign=>'Right',cattributes=>'id=""');
4480: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
4481: htp.tableRowClose;
4476: htp.tableRowOpen;
4477: htp.tableData(cvalue=>'',
4479: calign=>'Right',cattributes=>'id=""');
4480: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
4481: htp.tableRowClose;
4482:
4483: -- Type
4484: -- This is a regular find, allow select of type.
4477: htp.tableData(cvalue=>'',
4479: calign=>'Right',cattributes=>'id=""');
4480: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
4481: htp.tableRowClose;
4482:
4483: -- Type
4484: -- This is a regular find, allow select of type.
4485: -- Type can only be EVENT for "Add to Group".
4495: htf.formSelectOption(wf_core.translate('GROUP'),
4496: null,'VALUE="GROUP"')
4497: ||wf_core.newline||
4498: htf.formSelectClose;
4499: htp.tableRowOpen;
4500: htp.tableData(cvalue=>'',
4502: calign=>'Right',cattributes=>'id=""');
4503: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
4496: null,'VALUE="GROUP"')
4497: ||wf_core.newline||
4498: htf.formSelectClose;
4499: htp.tableRowOpen;
4500: htp.tableData(cvalue=>'4501: wf_core.translate('TYPE') || '',
4502: calign=>'Right',cattributes=>'id=""');
4503: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
4504: htp.tableRowClose;
4499: htp.tableRowOpen;
4500: htp.tableData(cvalue=>'',
4502: calign=>'Right',cattributes=>'id=""');
4503: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
4504: htp.tableRowClose;
4505: end if;
4506:
4507: htp.tableClose;
4500: htp.tableData(cvalue=>'',
4502: calign=>'Right',cattributes=>'id=""');
4503: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
4504: htp.tableRowClose;
4505: end if;
4506:
4507: htp.tableClose;
4508:
4503: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
4504: htp.tableRowClose;
4505: end if;
4506:
4507: htp.tableClose;
4508:
4509: if (x_gguid is null) then
4510: htp.formHidden('resetcookie','T');
4511: end if;
4506:
4507: htp.tableClose;
4508:
4509: if (x_gguid is null) then
4510: htp.formHidden('resetcookie','T');
4511: end if;
4512: htp.formClose;
4513:
4514: -- Add submit button
4508:
4509: if (x_gguid is null) then
4510: htp.formHidden('resetcookie','T');
4511: end if;
4512: htp.formClose;
4513:
4514: -- Add submit button
4515: htp.tableopen (calign=>'CENTER', cattributes=>'summary=""');
4516: htp.tableRowOpen;
4511: end if;
4512: htp.formClose;
4513:
4514: -- Add submit button
4515: htp.tableopen (calign=>'CENTER', cattributes=>'summary=""');
4516: htp.tableRowOpen;
4517:
4518: htp.p('
4512: htp.formClose;
4513:
4514: -- Add submit button
4515: htp.tableopen (calign=>'CENTER', cattributes=>'summary=""');
4516: htp.tableRowOpen;
4517:
4518: htp.p('
4514: -- Add submit button
4515: htp.tableopen (calign=>'CENTER', cattributes=>'summary=""');
4516: htp.tableRowOpen;
4517:
4518: htp.p('
4522: wfa_html.image_loc,
4523: null,
4524: wf_core.translate('GO'));
4525:
4526: htp.p('
4524: wf_core.translate('GO'));
4525:
4526: htp.p('');
4527:
4528: htp.tableRowClose;
4529: htp.tableClose;
4530:
4531: -- if a find condition is entered, populate the search fields and
4532: -- run the query to generate the event list.
4525:
4526: htp.p('');
4527:
4528: htp.tableRowClose;
4529: htp.tableClose;
4530:
4531: -- if a find condition is entered, populate the search fields and
4532: -- run the query to generate the event list.
4533: if (h_guid is not null) then
4532: -- run the query to generate the event list.
4533: if (h_guid is not null) then
4534: -- populate the search fields
4535: htp.p('');
4540:
4533: if (h_guid is not null) then
4534: -- populate the search fields
4535: htp.p('');
4540:
4541: -- populate the data table
4535: htp.p('');
4540:
4541: -- populate the data table
4542: i := 0;
4543: for event in aevcurs loop
4552: dTab(i).hasdetail := FALSE;
4553: end loop;
4554:
4555: -- Submit Form for Add/Delete
4556: htp.formOpen(curl=>owa_util.get_owa_service_path||
4557: 'Wf_Event_Html.SubmitSelectedGEvents',
4558: cmethod=>'Post',
4559: cattributes=>'TARGET="_top" NAME="WF_GROUP_EDIT"');
4560: htp.formHidden('h_gguid', rawtohex(h_guid));
4556: htp.formOpen(curl=>owa_util.get_owa_service_path||
4557: 'Wf_Event_Html.SubmitSelectedGEvents',
4558: cmethod=>'Post',
4559: cattributes=>'TARGET="_top" NAME="WF_GROUP_EDIT"');
4560: htp.formHidden('h_gguid', rawtohex(h_guid));
4561:
4562: -- Hide the fields for which option you selected. Must be ADD here.
4563: htp.formHidden(cname=>'action', cvalue=>'');
4564:
4559: cattributes=>'TARGET="_top" NAME="WF_GROUP_EDIT"');
4560: htp.formHidden('h_gguid', rawtohex(h_guid));
4561:
4562: -- Hide the fields for which option you selected. Must be ADD here.
4563: htp.formHidden(cname=>'action', cvalue=>'');
4564:
4565: -- Url to come back to later
4566: htp.formHidden(cname=>'url',
4567: cvalue=>'Wf_Event_Html.EditEvent?h_guid='||rawtohex(h_guid));
4562: -- Hide the fields for which option you selected. Must be ADD here.
4563: htp.formHidden(cname=>'action', cvalue=>'');
4564:
4565: -- Url to come back to later
4566: htp.formHidden(cname=>'url',
4567: cvalue=>'Wf_Event_Html.EditEvent?h_guid='||rawtohex(h_guid));
4568:
4569: -- Add dummy fields to start both array-type input fields.
4570: -- These dummy values are needed so that the array parameters to
4570: -- These dummy values are needed so that the array parameters to
4571: -- the submit procedure will not be null even if there are no real
4572: -- response fields. This would cause a pl/sql error, because array
4573: -- parameters can't be defaulted.
4574: htp.formHidden('h_guids', '-1');
4575:
4576: -- popluate the header table
4577: i := 1;
4578: hTab(i).def_type := 'TITLE';
4589:
4590: -- render table
4591: Wfe_Html_Util.Simple_Table(hTab, dTab);
4592:
4593: htp.formClose;
4594:
4595: -- Buttons Area
4596: htp.tableOpen (calign=>'RIGHT',cattributes=>'summary=""');
4597: htp.tableRowOpen;
4592:
4593: htp.formClose;
4594:
4595: -- Buttons Area
4596: htp.tableOpen (calign=>'RIGHT',cattributes=>'summary=""');
4597: htp.tableRowOpen;
4598: -- If table is not empty, we allow check/uncheck all/delete.
4599: if (dTab.COUNT > 0) then
4600: htp.p('
4593: htp.formClose;
4594:
4595: -- Buttons Area
4596: htp.tableOpen (calign=>'RIGHT',cattributes=>'summary=""');
4597: htp.tableRowOpen;
4598: -- If table is not empty, we allow check/uncheck all/delete.
4599: if (dTab.COUNT > 0) then
4600: htp.p('
4596: htp.tableOpen (calign=>'RIGHT',cattributes=>'summary=""');
4597: htp.tableRowOpen;
4598: -- If table is not empty, we allow check/uncheck all/delete.
4599: if (dTab.COUNT > 0) then
4600: htp.p('
4603: wf_core.translate('SELECT_ALL'),
4604: wfa_html.image_loc,
4605: null,
4606: wf_core.translate('SELECT_ALL'));
4607: htp.p('
4604: wfa_html.image_loc,
4605: null,
4606: wf_core.translate('SELECT_ALL'));
4607: htp.p('
4611: wf_core.translate('UNSELECT_ALL'),
4612: wfa_html.image_loc,
4613: null,
4614: wf_core.translate('UNSELECT_ALL'));
4615: htp.p('
4612: wfa_html.image_loc,
4613: null,
4614: wf_core.translate('UNSELECT_ALL'));
4615: htp.p('
4620: wf_core.translate('ADD'),
4621: wfa_html.image_loc,
4622: null,
4623: wf_core.translate('ADD'));
4624: htp.p('
4622: null,
4623: wf_core.translate('ADD'));
4624: htp.p('
4628: wf_core.translate ('CANCEL'),
4629: wfa_html.image_loc,
4630: null,
4631: wf_core.translate ('CANCEL'));
4632: htp.p('
4629: wfa_html.image_loc,
4630: null,
4631: wf_core.translate ('CANCEL'));
4632: htp.p('');
4633: htp.tableRowClose;
4634: htp.tableClose;
4635:
4636: end if; -- end generating the event list for adding to group
4637:
4630: null,
4631: wf_core.translate ('CANCEL'));
4632: htp.p('');
4633: htp.tableRowClose;
4634: htp.tableClose;
4635:
4636: end if; -- end generating the event list for adding to group
4637:
4638: wfa_sec.Footer;
4635:
4636: end if; -- end generating the event list for adding to group
4637:
4638: wfa_sec.Footer;
4639: htp.htmlClose;
4640:
4641: exception
4642: when others then
4643: rollback;
4740: end if;
4741:
4742: -- go back to ListSystems
4743: htp.p('');
4747:
4748: exception
4742: -- go back to ListSystems
4743: htp.p('');
4747:
4748: exception
4749: when others then
4750: rollback;
4768: end if;
4769:
4770: -- go back to ListAgents
4771: htp.p('');
4775:
4776: exception
4770: -- go back to ListAgents
4771: htp.p('');
4775:
4776: exception
4777: when others then
4778: rollback;
4795: end if;
4796:
4797: -- go back to ListSubscriptions
4798: htp.p('');
4802:
4803: exception
4797: -- go back to ListSubscriptions
4798: htp.p('');
4802:
4803: exception
4804: when others then
4805: rollback;
5987: else
5988: wf_core.raise('WF_NOTADMIN');
5989: end if;
5990:
5991: htp.htmlOpen;
5992: htp.headOpen;
5993: htp.title(wf_core.translate('WFE_RAISE_EVENT_SUBMITTED'));
5994: wfa_html.create_help_function('wf/links/t_r.htm?T_RAISEVNT');
5995: wfa_sec.header(background_only=>FALSE,
5988: wf_core.raise('WF_NOTADMIN');
5989: end if;
5990:
5991: htp.htmlOpen;
5992: htp.headOpen;
5993: htp.title(wf_core.translate('WFE_RAISE_EVENT_SUBMITTED'));
5994: wfa_html.create_help_function('wf/links/t_r.htm?T_RAISEVNT');
5995: wfa_sec.header(background_only=>FALSE,
5996: page_title=>wf_core.translate('WFE_RAISE_EVENT_SUBMITTED'));
5989: end if;
5990:
5991: htp.htmlOpen;
5992: htp.headOpen;
5993: htp.title(wf_core.translate('WFE_RAISE_EVENT_SUBMITTED'));
5994: wfa_html.create_help_function('wf/links/t_r.htm?T_RAISEVNT');
5995: wfa_sec.header(background_only=>FALSE,
5996: page_title=>wf_core.translate('WFE_RAISE_EVENT_SUBMITTED'));
5997: htp.headClose;
5993: htp.title(wf_core.translate('WFE_RAISE_EVENT_SUBMITTED'));
5994: wfa_html.create_help_function('wf/links/t_r.htm?T_RAISEVNT');
5995: wfa_sec.header(background_only=>FALSE,
5996: page_title=>wf_core.translate('WFE_RAISE_EVENT_SUBMITTED'));
5997: htp.headClose;
5998:
5999: htp.br;
6000: htp.br;
6001: htp.br;
5995: wfa_sec.header(background_only=>FALSE,
5996: page_title=>wf_core.translate('WFE_RAISE_EVENT_SUBMITTED'));
5997: htp.headClose;
5998:
5999: htp.br;
6000: htp.br;
6001: htp.br;
6002: htp.tableOpen(calign=>'CENTER', cattributes=>'border=0 summary=""');
6003: htp.tableRowOpen;
5996: page_title=>wf_core.translate('WFE_RAISE_EVENT_SUBMITTED'));
5997: htp.headClose;
5998:
5999: htp.br;
6000: htp.br;
6001: htp.br;
6002: htp.tableOpen(calign=>'CENTER', cattributes=>'border=0 summary=""');
6003: htp.tableRowOpen;
6004: htp.p('
5997: htp.headClose;
5998:
5999: htp.br;
6000: htp.br;
6001: htp.br;
6002: htp.tableOpen(calign=>'CENTER', cattributes=>'border=0 summary=""');
6003: htp.tableRowOpen;
6004: htp.p('
5998:
5999: htp.br;
6000: htp.br;
6001: htp.br;
6002: htp.tableOpen(calign=>'CENTER', cattributes=>'border=0 summary=""');
6003: htp.tableRowOpen;
6004: htp.p('
5999: htp.br;
6000: htp.br;
6001: htp.br;
6002: htp.tableOpen(calign=>'CENTER', cattributes=>'border=0 summary=""');
6003: htp.tableRowOpen;
6004: htp.p('
6000: htp.br;
6001: htp.br;
6002: htp.tableOpen(calign=>'CENTER', cattributes=>'border=0 summary=""');
6003: htp.tableRowOpen;
6004: htp.p('
6001: htp.br;
6002: htp.tableOpen(calign=>'CENTER', cattributes=>'border=0 summary=""');
6003: htp.tableRowOpen;
6004: htp.p('
6003: htp.tableRowOpen;
6004: htp.p('
6004: htp.p('
6005: htp.bold(wf_core.translate('WFE_RAISE_EVENT_SUBMITTED')||': '||p_event_name
6006: ||' / '||p_event_key);
6007: htp.p('');
6008: htp.tableRowClose;
6009: htp.tableClose;
6010:
6011: htp.br;
6012:
6013: htp.tableopen (cattributes =>'align=CENTER border=0 summary=""');
6007: htp.p('');
6008: htp.tableRowClose;
6009: htp.tableClose;
6010:
6011: htp.br;
6012:
6013: htp.tableopen (cattributes =>'align=CENTER border=0 summary=""');
6014: htp.tableRowOpen;
6015: htp.p('
6009: htp.tableClose;
6010:
6011: htp.br;
6012:
6013: htp.tableopen (cattributes =>'align=CENTER border=0 summary=""');
6014: htp.tableRowOpen;
6015: htp.p('
6010:
6011: htp.br;
6012:
6013: htp.tableopen (cattributes =>'align=CENTER border=0 summary=""');
6014: htp.tableRowOpen;
6015: htp.p('
6011: htp.br;
6012:
6013: htp.tableopen (cattributes =>'align=CENTER border=0 summary=""');
6014: htp.tableRowOpen;
6015: htp.p('
6020: wfa_html.image_loc,
6021: null,
6022: wf_core.translate('WFMON_OK'));
6023:
6024: htp.p('
6021: null,
6022: wf_core.translate('WFMON_OK'));
6023:
6024: htp.p('');
6025: htp.tableRowClose;
6026: htp.tableClose;
6027:
6028: wfa_sec.Footer;
6029: htp.htmlClose;
6022: wf_core.translate('WFMON_OK'));
6023:
6024: htp.p('');
6025: htp.tableRowClose;
6026: htp.tableClose;
6027:
6028: wfa_sec.Footer;
6029: htp.htmlClose;
6030: exception
6025: htp.tableRowClose;
6026: htp.tableClose;
6027:
6028: wfa_sec.Footer;
6029: htp.htmlClose;
6030: exception
6031: when OTHERS then
6032: rollback;
6033: wf_core.context('WF_EVENT_HTML', 'RaiseEventConfirm');
6100: owa_util.mime_header('text/xml', TRUE);
6101:
6102: owa_util.http_header_close;
6103:
6104: htp.p(l_dtd);
6105:
6106: exception
6107: when OTHERS then
6108: rollback;
6175: -- Check if Accessible
6176: wf_event_html.isAccessible('AGENTS');
6177:
6178: -- Set page title
6179: htp.htmlOpen;
6180: htp.headOpen;
6181: htp.p('
6182: htp.title(wf_core.translate('WFGENERIC_QUEUE_TITLE'));
6183: wfa_html.create_help_function('wf/links/t_r.htm?T_REVQUE');
6176: wf_event_html.isAccessible('AGENTS');
6177:
6178: -- Set page title
6179: htp.htmlOpen;
6180: htp.headOpen;
6181: htp.p('
6182: htp.title(wf_core.translate('WFGENERIC_QUEUE_TITLE'));
6183: wfa_html.create_help_function('wf/links/t_r.htm?T_REVQUE');
6184: htp.headClose;
6177:
6178: -- Set page title
6179: htp.htmlOpen;
6180: htp.headOpen;
6181: htp.p('
6182: htp.title(wf_core.translate('WFGENERIC_QUEUE_TITLE'));
6183: wfa_html.create_help_function('wf/links/t_r.htm?T_REVQUE');
6184: htp.headClose;
6185: wfa_sec.Header(FALSE, '',wf_core.translate('WFGENERIC_QUEUE_TITLE'), FALSE);
6178: -- Set page title
6179: htp.htmlOpen;
6180: htp.headOpen;
6181: htp.p('
6182: htp.title(wf_core.translate('WFGENERIC_QUEUE_TITLE'));
6183: wfa_html.create_help_function('wf/links/t_r.htm?T_REVQUE');
6184: htp.headClose;
6185: wfa_sec.Header(FALSE, '',wf_core.translate('WFGENERIC_QUEUE_TITLE'), FALSE);
6186: htp.br;
6180: htp.headOpen;
6181: htp.p('
6182: htp.title(wf_core.translate('WFGENERIC_QUEUE_TITLE'));
6183: wfa_html.create_help_function('wf/links/t_r.htm?T_REVQUE');
6184: htp.headClose;
6185: wfa_sec.Header(FALSE, '',wf_core.translate('WFGENERIC_QUEUE_TITLE'), FALSE);
6186: htp.br;
6187:
6188: -- This page is deprecated since Agent Activity link in Workflow Manager also shows the
6182: htp.title(wf_core.translate('WFGENERIC_QUEUE_TITLE'));
6183: wfa_html.create_help_function('wf/links/t_r.htm?T_REVQUE');
6184: htp.headClose;
6185: wfa_sec.Header(FALSE, '',wf_core.translate('WFGENERIC_QUEUE_TITLE'), FALSE);
6186: htp.br;
6187:
6188: -- This page is deprecated since Agent Activity link in Workflow Manager also shows the
6189: -- same details
6190: htp.center(Wf_Core.Translate('WFE_QUEUEPAGE_DEPRECATED'));
6186: htp.br;
6187:
6188: -- This page is deprecated since Agent Activity link in Workflow Manager also shows the
6189: -- same details
6190: htp.center(Wf_Core.Translate('WFE_QUEUEPAGE_DEPRECATED'));
6191: htp.htmlClose;
6192: return;
6193:
6194: IF (admin_mode = 'N') THEN
6187:
6188: -- This page is deprecated since Agent Activity link in Workflow Manager also shows the
6189: -- same details
6190: htp.center(Wf_Core.Translate('WFE_QUEUEPAGE_DEPRECATED'));
6191: htp.htmlClose;
6192: return;
6193:
6194: IF (admin_mode = 'N') THEN
6195:
6192: return;
6193:
6194: IF (admin_mode = 'N') THEN
6195:
6196: htp.center(htf.bold(l_error_msg));
6197: return;
6198:
6199: END IF;
6200:
6198:
6199: END IF;
6200:
6201: -- Column headers
6202: htp.tableOpen('border=1 cellpadding=3 bgcolor=white width="100%"
6203: summary="' || wf_core.translate('WFGENERIC_QUEUE_TITLE') || '"');
6204: htp.tableRowOpen(cattributes=>'bgcolor=#006699');
6205:
6206: htp.tableHeader(cvalue=>''||
6200:
6201: -- Column headers
6202: htp.tableOpen('border=1 cellpadding=3 bgcolor=white width="100%"
6203: summary="' || wf_core.translate('WFGENERIC_QUEUE_TITLE') || '"');
6204: htp.tableRowOpen(cattributes=>'bgcolor=#006699');
6205:
6206: htp.tableHeader(cvalue=>''||
6207: wf_core.translate('PROTOCOL')||'',
6208: calign=>'Center',
6202: htp.tableOpen('border=1 cellpadding=3 bgcolor=white width="100%"
6203: summary="' || wf_core.translate('WFGENERIC_QUEUE_TITLE') || '"');
6204: htp.tableRowOpen(cattributes=>'bgcolor=#006699');
6205:
6206: htp.tableHeader(cvalue=>''||
6207: wf_core.translate('PROTOCOL')||'',
6208: calign=>'Center',
6209: cattributes=>'id="' ||
6210: wf_core.translate('PROTOCOL') || '"');
6207: wf_core.translate('PROTOCOL')||'',
6208: calign=>'Center',
6209: cattributes=>'id="' ||
6210: wf_core.translate('PROTOCOL') || '"');
6211: htp.tableHeader(cvalue=>''||
6212: wf_core.translate('AGENT_NAME')||'',
6213: calign=>'Center',
6214: cattributes=>'id="' ||
6215: wf_core.translate('AGENT_NAME') || '"');
6212: wf_core.translate('AGENT_NAME')||'',
6213: calign=>'Center',
6214: cattributes=>'id="' ||
6215: wf_core.translate('AGENT_NAME') || '"');
6216: htp.tableHeader(cvalue=>''||
6217: wf_core.translate('INBOUND_PROMPT')||'',
6218: calign=>'Center',
6219: cattributes=>'id="' ||
6220: wf_core.translate('INBOUND_PROMPT') || '"');
6217: wf_core.translate('INBOUND_PROMPT')||'',
6218: calign=>'Center',
6219: cattributes=>'id="' ||
6220: wf_core.translate('INBOUND_PROMPT') || '"');
6221: htp.tableHeader(cvalue=>''||
6222: wf_core.translate('QUEUE_COUNT')||'',
6223: calign=>'Center',
6224: cattributes=>'id="' ||
6225: wf_core.translate('QUEUE_COUNT') || '"');
6222: wf_core.translate('QUEUE_COUNT')||'',
6223: calign=>'Center',
6224: cattributes=>'id="' ||
6225: wf_core.translate('QUEUE_COUNT') || '"');
6226: htp.tableHeader(cvalue=>''||
6227: wf_core.translate('VIEW_DETAIL')||'',
6228: calign=>'Center',
6229: cattributes=>'id="' ||
6230: wf_core.translate('VIEW_DETAIL') || '"');
6228: calign=>'Center',
6229: cattributes=>'id="' ||
6230: wf_core.translate('VIEW_DETAIL') || '"');
6231:
6232: htp.tableRowClose;
6233: htp.tableRowOpen;
6234: htp.tableRowClose;
6235:
6236: -- Show all nodes
6229: cattributes=>'id="' ||
6230: wf_core.translate('VIEW_DETAIL') || '"');
6231:
6232: htp.tableRowClose;
6233: htp.tableRowOpen;
6234: htp.tableRowClose;
6235:
6236: -- Show all nodes
6237: for queues in queues_cursor loop
6230: wf_core.translate('VIEW_DETAIL') || '"');
6231:
6232: htp.tableRowClose;
6233: htp.tableRowOpen;
6234: htp.tableRowClose;
6235:
6236: -- Show all nodes
6237: for queues in queues_cursor loop
6238: l_sqlstmt := 'SELECT COUNT(*) FROM '||queues.queue_table||
6239: ' WHERE Q_NAME = :b1';
6240:
6241: EXECUTE IMMEDIATE l_sqlstmt INTO l_count USING queues.queue_name;
6242:
6243: htp.tableRowOpen(null, 'TOP');
6244:
6245: htp.tableData(queues.protocol, 'center',
6246: cattributes=>'headers="' ||
6247: wf_core.translate('PROTOCOL') || '"');
6241: EXECUTE IMMEDIATE l_sqlstmt INTO l_count USING queues.queue_name;
6242:
6243: htp.tableRowOpen(null, 'TOP');
6244:
6245: htp.tableData(queues.protocol, 'center',
6246: cattributes=>'headers="' ||
6247: wf_core.translate('PROTOCOL') || '"');
6248:
6249: htp.tableData(nvl(queues.display_name,'&'||'nbsp'), 'left',
6245: htp.tableData(queues.protocol, 'center',
6246: cattributes=>'headers="' ||
6247: wf_core.translate('PROTOCOL') || '"');
6248:
6249: htp.tableData(nvl(queues.display_name,'&'||'nbsp'), 'left',
6250: cattributes=>'headers="' ||
6251: wf_core.translate('AGENT_NAME') || '"');
6252:
6253: htp.tableData(queues.direction, 'center',
6249: htp.tableData(nvl(queues.display_name,'&'||'nbsp'), 'left',
6250: cattributes=>'headers="' ||
6251: wf_core.translate('AGENT_NAME') || '"');
6252:
6253: htp.tableData(queues.direction, 'center',
6254: cattributes=>'headers="' ||
6255: wf_core.translate('INBOUND_PROMPT') || '"');
6256:
6257: htp.tableData(nvl(l_count,0), 'center',
6253: htp.tableData(queues.direction, 'center',
6254: cattributes=>'headers="' ||
6255: wf_core.translate('INBOUND_PROMPT') || '"');
6256:
6257: htp.tableData(nvl(l_count,0), 'center',
6258: cattributes=>'headers="' ||
6259: wf_core.translate('QUEUE_COUNT') || '"');
6260:
6261: --
6273: queues.schema_queue_name,
6274: '',
6275: l_rc);
6276: IF l_rc = 1 then
6277: htp.tableData(htf.anchor2(curl=>wfa_html.base_url||
6278: '/wf_event_html.FindQueueMessage?p_queue_name='||
6279: queues.queue_name||'&p_type=WF_EVENT_T',
6280: ctext=>'
6338: END IF;
6339:
6340: exception
6338: END IF;
6339:
6340: exception
6341: when others then
6342: htp.tableData(wf_core.translate('WFE_NOT_AVAILABLE'),'center',
6343: cattributes=>'id=""');
6344: end;
6345: l_knowndatatype := FALSE;
6346: end loop;
6344: end;
6345: l_knowndatatype := FALSE;
6346: end loop;
6347:
6348: htp.tableclose;
6349:
6350: htp.br;
6351:
6352: wfa_sec.Footer;
6346: end loop;
6347:
6348: htp.tableclose;
6349:
6350: htp.br;
6351:
6352: wfa_sec.Footer;
6353: htp.htmlClose;
6354:
6349:
6350: htp.br;
6351:
6352: wfa_sec.Footer;
6353: htp.htmlClose;
6354:
6355: exception
6356: when others then
6357: rollback;
6418: title := wf_core.translate('WFE_FIND_QUEUE_MESSAGES_TITLE');
6419: helptext := 'wf/links/t_f.htm?T_FDQMSG';
6420:
6421: -- Render page
6422: htp.htmlOpen;
6423:
6424: -- Set page title
6425: htp.headOpen;
6426: htp.title(title);
6421: -- Render page
6422: htp.htmlOpen;
6423:
6424: -- Set page title
6425: htp.headOpen;
6426: htp.title(title);
6427: wfa_html.create_help_function(helptext);
6428: fnd_document_management.get_open_dm_display_window;
6429: htp.headClose;
6422: htp.htmlOpen;
6423:
6424: -- Set page title
6425: htp.headOpen;
6426: htp.title(title);
6427: wfa_html.create_help_function(helptext);
6428: fnd_document_management.get_open_dm_display_window;
6429: htp.headClose;
6430:
6425: htp.headOpen;
6426: htp.title(title);
6427: wfa_html.create_help_function(helptext);
6428: fnd_document_management.get_open_dm_display_window;
6429: htp.headClose;
6430:
6431: -- Page header
6432: wfa_sec.Header(FALSE, null, title, TRUE);
6433:
6431: -- Page header
6432: wfa_sec.Header(FALSE, null, title, TRUE);
6433:
6434: -- Form
6435: htp.formOpen(curl=>l_url,
6436: cmethod=>'Post',
6437: cattributes=>'NAME="WF_QUEUE_MESSAGE_FIND"');
6438: htp.tableOpen(calign=>'CENTER', cattributes=>'border=0 summary=""');
6439:
6434: -- Form
6435: htp.formOpen(curl=>l_url,
6436: cmethod=>'Post',
6437: cattributes=>'NAME="WF_QUEUE_MESSAGE_FIND"');
6438: htp.tableOpen(calign=>'CENTER', cattributes=>'border=0 summary=""');
6439:
6440: -- Queue Name (pulldown list of Queue Names)
6441: htp.tableRowOpen;
6442: htp.tableData(cvalue=>'
6437: cattributes=>'NAME="WF_QUEUE_MESSAGE_FIND"');
6438: htp.tableOpen(calign=>'CENTER', cattributes=>'border=0 summary=""');
6439:
6440: -- Queue Name (pulldown list of Queue Names)
6441: htp.tableRowOpen;
6442: htp.tableData(cvalue=>'',
6444: calign=>'right',
6445: cattributes=>'valign=middle id=""');
6438: htp.tableOpen(calign=>'CENTER', cattributes=>'border=0 summary=""');
6439:
6440: -- Queue Name (pulldown list of Queue Names)
6441: htp.tableRowOpen;
6442: htp.tableData(cvalue=>'6443: wf_core.translate('QUEUE_NAME') || '',
6444: calign=>'right',
6445: cattributes=>'valign=middle id=""');
6446: htp.p('
6442: htp.tableData(cvalue=>'',
6444: calign=>'right',
6445: cattributes=>'valign=middle id=""');
6446: htp.p('
6443: wf_core.translate('QUEUE_NAME') || '',
6444: calign=>'right',
6445: cattributes=>'valign=middle id=""');
6446: htp.p('
6445: cattributes=>'valign=middle id=""');
6446: htp.p('
6448: for i in queues_cursor loop
6449: htp.formSelectOption(cvalue=>i.queue_name
6450: ,cattributes=>'value='||i.queue_name);
6451: end loop;
6452: htp.formSelectClose;
6453: htp.p('
6449: htp.formSelectOption(cvalue=>i.queue_name
6450: ,cattributes=>'value='||i.queue_name);
6451: end loop;
6452: htp.formSelectClose;
6453: htp.p('');
6454: htp.tableRowClose;
6455:
6456: -- Event Name
6457: htp.tableRowOpen;
6450: ,cattributes=>'value='||i.queue_name);
6451: end loop;
6452: htp.formSelectClose;
6453: htp.p('');
6454: htp.tableRowClose;
6455:
6456: -- Event Name
6457: htp.tableRowOpen;
6458: htp.tableData(cvalue=>'
6453: htp.p('');
6454: htp.tableRowClose;
6455:
6456: -- Event Name
6457: htp.tableRowOpen;
6458: htp.tableData(cvalue=>'',
6460: calign=>'Right', cattributes=>'id=""');
6461: htp.tableData(cvalue=>htf.formText(cname=>'p_event_name', csize=>40,
6454: htp.tableRowClose;
6455:
6456: -- Event Name
6457: htp.tableRowOpen;
6458: htp.tableData(cvalue=>'6459: wf_core.translate('EVENT_NAME') || '',
6460: calign=>'Right', cattributes=>'id=""');
6461: htp.tableData(cvalue=>htf.formText(cname=>'p_event_name', csize=>40,
6462: cmaxlength=>240,
6457: htp.tableRowOpen;
6458: htp.tableData(cvalue=>'',
6460: calign=>'Right', cattributes=>'id=""');
6461: htp.tableData(cvalue=>htf.formText(cname=>'p_event_name', csize=>40,
6462: cmaxlength=>240,
6463: cattributes=>'id="i_event_name"'),
6464: calign=>'Left', cattributes=>'id=""');
6465: htp.tableRowClose;
6461: htp.tableData(cvalue=>htf.formText(cname=>'p_event_name', csize=>40,
6462: cmaxlength=>240,
6463: cattributes=>'id="i_event_name"'),
6464: calign=>'Left', cattributes=>'id=""');
6465: htp.tableRowClose;
6466:
6467: -- Event Key
6468: htp.tableRowOpen;
6469: htp.tableData(cvalue=>'
6464: calign=>'Left', cattributes=>'id=""');
6465: htp.tableRowClose;
6466:
6467: -- Event Key
6468: htp.tableRowOpen;
6469: htp.tableData(cvalue=>'',
6471: calign=>'Right',cattributes=>'id=""');
6472: htp.tableData(cvalue=>htf.formText(cname=>'p_event_key', csize=>40,
6465: htp.tableRowClose;
6466:
6467: -- Event Key
6468: htp.tableRowOpen;
6469: htp.tableData(cvalue=>'6470: wf_core.translate('EVENT_KEY') || '',
6471: calign=>'Right',cattributes=>'id=""');
6472: htp.tableData(cvalue=>htf.formText(cname=>'p_event_key', csize=>40,
6473: cmaxlength=>240,
6468: htp.tableRowOpen;
6469: htp.tableData(cvalue=>'',
6471: calign=>'Right',cattributes=>'id=""');
6472: htp.tableData(cvalue=>htf.formText(cname=>'p_event_key', csize=>40,
6473: cmaxlength=>240,
6474: cattributes=>'id="i_event_key"'),
6475: calign=>'Left',cattributes=>'id=""');
6476: htp.tableRowClose;
6472: htp.tableData(cvalue=>htf.formText(cname=>'p_event_key', csize=>40,
6473: cmaxlength=>240,
6474: cattributes=>'id="i_event_key"'),
6475: calign=>'Left',cattributes=>'id=""');
6476: htp.tableRowClose;
6477:
6478: -- Message Status
6479: template := htf.formSelectOpen('p_message_status',
6480: cattributes=>'id="i_message_status"')||wf_core.newline;
6490: htf.formSelectOption(wf_core.translate('EXPIRED'),
6491: null,'VALUE="EXPIRED"');
6492: template := template||wf_core.newline||htf.formSelectClose;
6493:
6494: htp.tableRowOpen;
6495: htp.tableData(cvalue=>'',
6497: calign=>'Right',cattributes=>'id=""');
6498: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
6491: null,'VALUE="EXPIRED"');
6492: template := template||wf_core.newline||htf.formSelectClose;
6493:
6494: htp.tableRowOpen;
6495: htp.tableData(cvalue=>'6496: wf_core.translate('STATUS') || '',
6497: calign=>'Right',cattributes=>'id=""');
6498: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
6499: htp.tableRowClose;
6494: htp.tableRowOpen;
6495: htp.tableData(cvalue=>'',
6497: calign=>'Right',cattributes=>'id=""');
6498: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
6499: htp.tableRowClose;
6500:
6501: htp.tableClose;
6502: htp.formClose;
6495: htp.tableData(cvalue=>'',
6497: calign=>'Right',cattributes=>'id=""');
6498: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
6499: htp.tableRowClose;
6500:
6501: htp.tableClose;
6502: htp.formClose;
6503: -- Add submit button
6497: calign=>'Right',cattributes=>'id=""');
6498: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
6499: htp.tableRowClose;
6500:
6501: htp.tableClose;
6502: htp.formClose;
6503: -- Add submit button
6504: htp.tableopen (calign=>'CENTER', cattributes=>'summary=""');
6505: htp.tableRowOpen;
6498: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
6499: htp.tableRowClose;
6500:
6501: htp.tableClose;
6502: htp.formClose;
6503: -- Add submit button
6504: htp.tableopen (calign=>'CENTER', cattributes=>'summary=""');
6505: htp.tableRowOpen;
6506:
6500:
6501: htp.tableClose;
6502: htp.formClose;
6503: -- Add submit button
6504: htp.tableopen (calign=>'CENTER', cattributes=>'summary=""');
6505: htp.tableRowOpen;
6506:
6507: htp.p('
6501: htp.tableClose;
6502: htp.formClose;
6503: -- Add submit button
6504: htp.tableopen (calign=>'CENTER', cattributes=>'summary=""');
6505: htp.tableRowOpen;
6506:
6507: htp.p('
6503: -- Add submit button
6504: htp.tableopen (calign=>'CENTER', cattributes=>'summary=""');
6505: htp.tableRowOpen;
6506:
6507: htp.p('
6511: wfa_html.image_loc,
6512: null,
6513: wf_core.translate('GO'));
6514:
6515: htp.p('
6513: wf_core.translate('GO'));
6514:
6515: htp.p('');
6516:
6517: htp.tableRowClose;
6518: htp.tableClose;
6519:
6520: wfa_sec.Footer;
6521: htp.htmlClose;
6514:
6515: htp.p('');
6516:
6517: htp.tableRowClose;
6518: htp.tableClose;
6519:
6520: wfa_sec.Footer;
6521: htp.htmlClose;
6522:
6517: htp.tableRowClose;
6518: htp.tableClose;
6519:
6520: wfa_sec.Footer;
6521: htp.htmlClose;
6522:
6523: exception
6524: when others then
6525: rollback;
6576: title := wf_core.translate('WFE_FIND_QUEUE_MESSAGES_TITLE');
6577: helptext := 'wf/links/t_f.htm?T_FDQMSG';
6578:
6579: -- Render page
6580: htp.htmlOpen;
6581:
6582: -- Set page title
6583: htp.headOpen;
6584: htp.title(title);
6579: -- Render page
6580: htp.htmlOpen;
6581:
6582: -- Set page title
6583: htp.headOpen;
6584: htp.title(title);
6585: wfa_html.create_help_function(helptext);
6586: fnd_document_management.get_open_dm_display_window;
6587: htp.headClose;
6580: htp.htmlOpen;
6581:
6582: -- Set page title
6583: htp.headOpen;
6584: htp.title(title);
6585: wfa_html.create_help_function(helptext);
6586: fnd_document_management.get_open_dm_display_window;
6587: htp.headClose;
6588:
6583: htp.headOpen;
6584: htp.title(title);
6585: wfa_html.create_help_function(helptext);
6586: fnd_document_management.get_open_dm_display_window;
6587: htp.headClose;
6588:
6589: -- Page header
6590: wfa_sec.Header(FALSE, null, title, TRUE);
6591:
6589: -- Page header
6590: wfa_sec.Header(FALSE, null, title, TRUE);
6591:
6592: -- Form
6593: htp.formOpen(curl=>l_url,
6594: cmethod=>'Post',
6595: cattributes=>'NAME="WF_QUEUE_MESSAGE_FIND"');
6596: htp.tableOpen(calign=>'CENTER', cattributes=>'border=0 summary=""');
6597:
6592: -- Form
6593: htp.formOpen(curl=>l_url,
6594: cmethod=>'Post',
6595: cattributes=>'NAME="WF_QUEUE_MESSAGE_FIND"');
6596: htp.tableOpen(calign=>'CENTER', cattributes=>'border=0 summary=""');
6597:
6598: -- Queue Name (pulldown list of Queue Names)
6599: htp.tableRowOpen;
6600: htp.tableData(cvalue=>'
6595: cattributes=>'NAME="WF_QUEUE_MESSAGE_FIND"');
6596: htp.tableOpen(calign=>'CENTER', cattributes=>'border=0 summary=""');
6597:
6598: -- Queue Name (pulldown list of Queue Names)
6599: htp.tableRowOpen;
6600: htp.tableData(cvalue=>'',
6602: calign=>'right',
6603: cattributes=>'valign=middle id=""');
6596: htp.tableOpen(calign=>'CENTER', cattributes=>'border=0 summary=""');
6597:
6598: -- Queue Name (pulldown list of Queue Names)
6599: htp.tableRowOpen;
6600: htp.tableData(cvalue=>'6601: wf_core.translate('QUEUE_NAME') || '',
6602: calign=>'right',
6603: cattributes=>'valign=middle id=""');
6604: htp.p('
6600: htp.tableData(cvalue=>'',
6602: calign=>'right',
6603: cattributes=>'valign=middle id=""');
6604: htp.p('
6601: wf_core.translate('QUEUE_NAME') || '',
6602: calign=>'right',
6603: cattributes=>'valign=middle id=""');
6604: htp.p('
6603: cattributes=>'valign=middle id=""');
6604: htp.p('
6606: for i in queues_cursor loop
6607: htp.formSelectOption(cvalue=>i.queue_name
6608: ,cattributes=>'value='||i.queue_name);
6609: end loop;
6610: htp.formSelectClose;
6611: htp.p('
6607: htp.formSelectOption(cvalue=>i.queue_name
6608: ,cattributes=>'value='||i.queue_name);
6609: end loop;
6610: htp.formSelectClose;
6611: htp.p('');
6612: htp.tableRowClose;
6613:
6614: -- Transaction Type
6615: htp.tableRowOpen;
6608: ,cattributes=>'value='||i.queue_name);
6609: end loop;
6610: htp.formSelectClose;
6611: htp.p('');
6612: htp.tableRowClose;
6613:
6614: -- Transaction Type
6615: htp.tableRowOpen;
6616: htp.tableData(cvalue=>'
6611: htp.p('');
6612: htp.tableRowClose;
6613:
6614: -- Transaction Type
6615: htp.tableRowOpen;
6616: htp.tableData(cvalue=>'',
6618: calign=>'Right', cattributes=>'id=""');
6619: htp.tableData(cvalue=>htf.formText(cname=>'p_transaction_type', csize=>40,
6612: htp.tableRowClose;
6613:
6614: -- Transaction Type
6615: htp.tableRowOpen;
6616: htp.tableData(cvalue=>'6617: wf_core.translate('TRANSACTIONTYPE') || '',
6618: calign=>'Right', cattributes=>'id=""');
6619: htp.tableData(cvalue=>htf.formText(cname=>'p_transaction_type', csize=>40,
6620: cmaxlength=>240,
6615: htp.tableRowOpen;
6616: htp.tableData(cvalue=>'',
6618: calign=>'Right', cattributes=>'id=""');
6619: htp.tableData(cvalue=>htf.formText(cname=>'p_transaction_type', csize=>40,
6620: cmaxlength=>240,
6621: cattributes=>'id="i_transaction_type"'),
6622: calign=>'Left', cattributes=>'id=""');
6623: htp.tableRowClose;
6619: htp.tableData(cvalue=>htf.formText(cname=>'p_transaction_type', csize=>40,
6620: cmaxlength=>240,
6621: cattributes=>'id="i_transaction_type"'),
6622: calign=>'Left', cattributes=>'id=""');
6623: htp.tableRowClose;
6624:
6625: -- Document Number
6626: htp.tableRowOpen;
6627: htp.tableData(cvalue=>'
6622: calign=>'Left', cattributes=>'id=""');
6623: htp.tableRowClose;
6624:
6625: -- Document Number
6626: htp.tableRowOpen;
6627: htp.tableData(cvalue=>'',
6629: calign=>'Right',cattributes=>'id=""');
6630: htp.tableData(cvalue=>htf.formText(cname=>'p_document_number', csize=>40,
6623: htp.tableRowClose;
6624:
6625: -- Document Number
6626: htp.tableRowOpen;
6627: htp.tableData(cvalue=>'6628: wf_core.translate('DOCUMENTNUMBER') || '',
6629: calign=>'Right',cattributes=>'id=""');
6630: htp.tableData(cvalue=>htf.formText(cname=>'p_document_number', csize=>40,
6631: cmaxlength=>240,
6626: htp.tableRowOpen;
6627: htp.tableData(cvalue=>'',
6629: calign=>'Right',cattributes=>'id=""');
6630: htp.tableData(cvalue=>htf.formText(cname=>'p_document_number', csize=>40,
6631: cmaxlength=>240,
6632: cattributes=>'id="i_document_number"'),
6633: calign=>'Left',cattributes=>'id=""');
6634: htp.tableRowClose;
6630: htp.tableData(cvalue=>htf.formText(cname=>'p_document_number', csize=>40,
6631: cmaxlength=>240,
6632: cattributes=>'id="i_document_number"'),
6633: calign=>'Left',cattributes=>'id=""');
6634: htp.tableRowClose;
6635:
6636: -- Party Site ID
6637: htp.tableRowOpen;
6638: htp.tableData(cvalue=>'
6633: calign=>'Left',cattributes=>'id=""');
6634: htp.tableRowClose;
6635:
6636: -- Party Site ID
6637: htp.tableRowOpen;
6638: htp.tableData(cvalue=>'',
6640: calign=>'Right',cattributes=>'id=""');
6641: htp.tableData(cvalue=>htf.formText(cname=>'p_party_site_id', csize=>40,
6634: htp.tableRowClose;
6635:
6636: -- Party Site ID
6637: htp.tableRowOpen;
6638: htp.tableData(cvalue=>'6639: wf_core.translate('PARTYSITEID') || '',
6640: calign=>'Right',cattributes=>'id=""');
6641: htp.tableData(cvalue=>htf.formText(cname=>'p_party_site_id', csize=>40,
6642: cmaxlength=>240,
6637: htp.tableRowOpen;
6638: htp.tableData(cvalue=>'',
6640: calign=>'Right',cattributes=>'id=""');
6641: htp.tableData(cvalue=>htf.formText(cname=>'p_party_site_id', csize=>40,
6642: cmaxlength=>240,
6643: cattributes=>'id="i_party_site_id"'),
6644: calign=>'Left',cattributes=>'id=""');
6645: htp.tableRowClose;
6641: htp.tableData(cvalue=>htf.formText(cname=>'p_party_site_id', csize=>40,
6642: cmaxlength=>240,
6643: cattributes=>'id="i_party_site_id"'),
6644: calign=>'Left',cattributes=>'id=""');
6645: htp.tableRowClose;
6646:
6647: -- Message Status
6648: template := htf.formSelectOpen('p_message_status',
6649: cattributes=>'id="i_message_status"')||wf_core.newline;
6659: htf.formSelectOption(wf_core.translate('EXPIRED'),
6660: null,'VALUE="EXPIRED"');
6661: template := template||wf_core.newline||htf.formSelectClose;
6662:
6663: htp.tableRowOpen;
6664: htp.tableData(cvalue=>'',
6666: calign=>'Right',cattributes=>'id=""');
6667: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
6660: null,'VALUE="EXPIRED"');
6661: template := template||wf_core.newline||htf.formSelectClose;
6662:
6663: htp.tableRowOpen;
6664: htp.tableData(cvalue=>'6665: wf_core.translate('STATUS') || '',
6666: calign=>'Right',cattributes=>'id=""');
6667: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
6668: htp.tableRowClose;
6663: htp.tableRowOpen;
6664: htp.tableData(cvalue=>'',
6666: calign=>'Right',cattributes=>'id=""');
6667: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
6668: htp.tableRowClose;
6669:
6670: htp.tableClose;
6671: htp.formClose;
6664: htp.tableData(cvalue=>'',
6666: calign=>'Right',cattributes=>'id=""');
6667: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
6668: htp.tableRowClose;
6669:
6670: htp.tableClose;
6671: htp.formClose;
6672: -- Add submit button
6666: calign=>'Right',cattributes=>'id=""');
6667: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
6668: htp.tableRowClose;
6669:
6670: htp.tableClose;
6671: htp.formClose;
6672: -- Add submit button
6673: htp.tableopen (calign=>'CENTER', cattributes=>'summary=""');
6674: htp.tableRowOpen;
6667: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
6668: htp.tableRowClose;
6669:
6670: htp.tableClose;
6671: htp.formClose;
6672: -- Add submit button
6673: htp.tableopen (calign=>'CENTER', cattributes=>'summary=""');
6674: htp.tableRowOpen;
6675:
6669:
6670: htp.tableClose;
6671: htp.formClose;
6672: -- Add submit button
6673: htp.tableopen (calign=>'CENTER', cattributes=>'summary=""');
6674: htp.tableRowOpen;
6675:
6676: htp.p('
6670: htp.tableClose;
6671: htp.formClose;
6672: -- Add submit button
6673: htp.tableopen (calign=>'CENTER', cattributes=>'summary=""');
6674: htp.tableRowOpen;
6675:
6676: htp.p('
6672: -- Add submit button
6673: htp.tableopen (calign=>'CENTER', cattributes=>'summary=""');
6674: htp.tableRowOpen;
6675:
6676: htp.p('
6681: wfa_html.image_loc,
6682: null,
6683: wf_core.translate('GO'));
6684:
6685: htp.p('
6683: wf_core.translate('GO'));
6684:
6685: htp.p('');
6686:
6687: htp.tableRowClose;
6688: htp.tableClose;
6689: wfa_sec.Footer;
6690: htp.htmlClose;
6691:
6684:
6685: htp.p('');
6686:
6687: htp.tableRowClose;
6688: htp.tableClose;
6689: wfa_sec.Footer;
6690: htp.htmlClose;
6691:
6692: exception
6686:
6687: htp.tableRowClose;
6688: htp.tableClose;
6689: wfa_sec.Footer;
6690: htp.htmlClose;
6691:
6692: exception
6693: when others then
6694: rollback;
6745: title := wf_core.translate('WFE_FIND_QUEUE_MESSAGES_TITLE');
6746: helptext := 'wf/links/t_f.htm?T_FDQMSG';
6747:
6748: -- Render page
6749: htp.htmlOpen;
6750:
6751: -- Set page title
6752: htp.headOpen;
6753: htp.title(title);
6748: -- Render page
6749: htp.htmlOpen;
6750:
6751: -- Set page title
6752: htp.headOpen;
6753: htp.title(title);
6754: wfa_html.create_help_function(helptext);
6755: fnd_document_management.get_open_dm_display_window;
6756: htp.headClose;
6749: htp.htmlOpen;
6750:
6751: -- Set page title
6752: htp.headOpen;
6753: htp.title(title);
6754: wfa_html.create_help_function(helptext);
6755: fnd_document_management.get_open_dm_display_window;
6756: htp.headClose;
6757:
6752: htp.headOpen;
6753: htp.title(title);
6754: wfa_html.create_help_function(helptext);
6755: fnd_document_management.get_open_dm_display_window;
6756: htp.headClose;
6757:
6758: -- Page header
6759: wfa_sec.Header(FALSE, null, title, TRUE);
6760:
6758: -- Page header
6759: wfa_sec.Header(FALSE, null, title, TRUE);
6760:
6761: -- Form
6762: htp.formOpen(curl=>l_url,
6763: cmethod=>'Post',
6764: cattributes=>'NAME="WF_QUEUE_MESSAGE_FIND"');
6765: htp.tableOpen(calign=>'CENTER', cattributes=>'border=0 summary=""');
6766:
6761: -- Form
6762: htp.formOpen(curl=>l_url,
6763: cmethod=>'Post',
6764: cattributes=>'NAME="WF_QUEUE_MESSAGE_FIND"');
6765: htp.tableOpen(calign=>'CENTER', cattributes=>'border=0 summary=""');
6766:
6767: -- Queue Name (pulldown list of Queue Names)
6768: htp.tableRowOpen;
6769: htp.tableData(cvalue=>'
6764: cattributes=>'NAME="WF_QUEUE_MESSAGE_FIND"');
6765: htp.tableOpen(calign=>'CENTER', cattributes=>'border=0 summary=""');
6766:
6767: -- Queue Name (pulldown list of Queue Names)
6768: htp.tableRowOpen;
6769: htp.tableData(cvalue=>'',
6771: calign=>'right',
6772: cattributes=>'valign=middle id=""');
6765: htp.tableOpen(calign=>'CENTER', cattributes=>'border=0 summary=""');
6766:
6767: -- Queue Name (pulldown list of Queue Names)
6768: htp.tableRowOpen;
6769: htp.tableData(cvalue=>'6770: wf_core.translate('QUEUE_NAME') || '',
6771: calign=>'right',
6772: cattributes=>'valign=middle id=""');
6773: htp.p('
6769: htp.tableData(cvalue=>'',
6771: calign=>'right',
6772: cattributes=>'valign=middle id=""');
6773: htp.p('
6770: wf_core.translate('QUEUE_NAME') || '',
6771: calign=>'right',
6772: cattributes=>'valign=middle id=""');
6773: htp.p('
6772: cattributes=>'valign=middle id=""');
6773: htp.p('
6775: for i in queues_cursor loop
6776: htp.formSelectOption(cvalue=>i.queue_name
6777: ,cattributes=>'value='||i.queue_name);
6778: end loop;
6779: htp.formSelectClose;
6780: htp.p('
6776: htp.formSelectOption(cvalue=>i.queue_name
6777: ,cattributes=>'value='||i.queue_name);
6778: end loop;
6779: htp.formSelectClose;
6780: htp.p('');
6781: htp.tableRowClose;
6782:
6783: -- Message Id
6784: htp.tableRowOpen;
6777: ,cattributes=>'value='||i.queue_name);
6778: end loop;
6779: htp.formSelectClose;
6780: htp.p('');
6781: htp.tableRowClose;
6782:
6783: -- Message Id
6784: htp.tableRowOpen;
6785: htp.tableData(cvalue=>'
6780: htp.p('');
6781: htp.tableRowClose;
6782:
6783: -- Message Id
6784: htp.tableRowOpen;
6785: htp.tableData(cvalue=>'',
6787: calign=>'Right', cattributes=>'id=""');
6788: htp.tableData(cvalue=>htf.formText(cname=>'p_message_id', csize=>40,
6781: htp.tableRowClose;
6782:
6783: -- Message Id
6784: htp.tableRowOpen;
6785: htp.tableData(cvalue=>'6786: wf_core.translate('MESSAGEID') || '',
6787: calign=>'Right', cattributes=>'id=""');
6788: htp.tableData(cvalue=>htf.formText(cname=>'p_message_id', csize=>40,
6789: cmaxlength=>240,
6784: htp.tableRowOpen;
6785: htp.tableData(cvalue=>'',
6787: calign=>'Right', cattributes=>'id=""');
6788: htp.tableData(cvalue=>htf.formText(cname=>'p_message_id', csize=>40,
6789: cmaxlength=>240,
6790: cattributes=>'id="i_message_id"'),
6791: calign=>'Left', cattributes=>'id=""');
6792: htp.tableRowClose;
6788: htp.tableData(cvalue=>htf.formText(cname=>'p_message_id', csize=>40,
6789: cmaxlength=>240,
6790: cattributes=>'id="i_message_id"'),
6791: calign=>'Left', cattributes=>'id=""');
6792: htp.tableRowClose;
6793:
6794: -- Message Status
6795: template := htf.formSelectOpen('p_message_status',
6796: cattributes=>'id="i_message_status"')||wf_core.newline;
6806: htf.formSelectOption(wf_core.translate('EXPIRED'),
6807: null,'VALUE="EXPIRED"');
6808: template := template||wf_core.newline||htf.formSelectClose;
6809:
6810: htp.tableRowOpen;
6811: htp.tableData(cvalue=>'',
6813: calign=>'Right',cattributes=>'id=""');
6814: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
6807: null,'VALUE="EXPIRED"');
6808: template := template||wf_core.newline||htf.formSelectClose;
6809:
6810: htp.tableRowOpen;
6811: htp.tableData(cvalue=>'6812: wf_core.translate('STATUS') || '',
6813: calign=>'Right',cattributes=>'id=""');
6814: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
6815: htp.tableRowClose;
6810: htp.tableRowOpen;
6811: htp.tableData(cvalue=>'',
6813: calign=>'Right',cattributes=>'id=""');
6814: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
6815: htp.tableRowClose;
6816:
6817: htp.tableClose;
6818: htp.formClose;
6811: htp.tableData(cvalue=>'',
6813: calign=>'Right',cattributes=>'id=""');
6814: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
6815: htp.tableRowClose;
6816:
6817: htp.tableClose;
6818: htp.formClose;
6819: -- Add submit button
6813: calign=>'Right',cattributes=>'id=""');
6814: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
6815: htp.tableRowClose;
6816:
6817: htp.tableClose;
6818: htp.formClose;
6819: -- Add submit button
6820: htp.tableopen (calign=>'CENTER', cattributes=>'summary=""');
6821: htp.tableRowOpen;
6814: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
6815: htp.tableRowClose;
6816:
6817: htp.tableClose;
6818: htp.formClose;
6819: -- Add submit button
6820: htp.tableopen (calign=>'CENTER', cattributes=>'summary=""');
6821: htp.tableRowOpen;
6822:
6816:
6817: htp.tableClose;
6818: htp.formClose;
6819: -- Add submit button
6820: htp.tableopen (calign=>'CENTER', cattributes=>'summary=""');
6821: htp.tableRowOpen;
6822:
6823: htp.p('
6817: htp.tableClose;
6818: htp.formClose;
6819: -- Add submit button
6820: htp.tableopen (calign=>'CENTER', cattributes=>'summary=""');
6821: htp.tableRowOpen;
6822:
6823: htp.p('
6819: -- Add submit button
6820: htp.tableopen (calign=>'CENTER', cattributes=>'summary=""');
6821: htp.tableRowOpen;
6822:
6823: htp.p('
6828: wfa_html.image_loc,
6829: null,
6830: wf_core.translate('GO'));
6831:
6832: htp.p('
6830: wf_core.translate('GO'));
6831:
6832: htp.p('');
6833:
6834: htp.tableRowClose;
6835: htp.tableClose;
6836: wfa_sec.Footer;
6837: htp.htmlClose;
6838:
6831:
6832: htp.p('');
6833:
6834: htp.tableRowClose;
6835: htp.tableClose;
6836: wfa_sec.Footer;
6837: htp.htmlClose;
6838:
6839: exception
6833:
6834: htp.tableRowClose;
6835: htp.tableClose;
6836: wfa_sec.Footer;
6837: htp.htmlClose;
6838:
6839: exception
6840: when others then
6841: rollback;
6926: -- Check if Accessible
6927: wf_event_html.isAccessible('AGENTS');
6928:
6929: -- Set page title
6930: htp.htmlOpen;
6931: htp.headOpen;
6932: htp.p('
6933: htp.title(wf_core.translate('WFQUEUE_MESSAGE_TITLE'));
6934: wfa_html.create_help_function('wf/links/t_l.htm?T_LQUEM');
6927: wf_event_html.isAccessible('AGENTS');
6928:
6929: -- Set page title
6930: htp.htmlOpen;
6931: htp.headOpen;
6932: htp.p('
6933: htp.title(wf_core.translate('WFQUEUE_MESSAGE_TITLE'));
6934: wfa_html.create_help_function('wf/links/t_l.htm?T_LQUEM');
6935: htp.headClose;
6928:
6929: -- Set page title
6930: htp.htmlOpen;
6931: htp.headOpen;
6932: htp.p('
6933: htp.title(wf_core.translate('WFQUEUE_MESSAGE_TITLE'));
6934: wfa_html.create_help_function('wf/links/t_l.htm?T_LQUEM');
6935: htp.headClose;
6936: wfa_sec.Header(FALSE, owa_util.get_owa_service_path ||'wf_event_html.FindQueueMessage?p_queue_name='||p_queue_name||'&p_type=WF_EVENT_T', wf_core.translate('WFQUEUE_MESSAGE_TITLE'), TRUE);
6929: -- Set page title
6930: htp.htmlOpen;
6931: htp.headOpen;
6932: htp.p('
6933: htp.title(wf_core.translate('WFQUEUE_MESSAGE_TITLE'));
6934: wfa_html.create_help_function('wf/links/t_l.htm?T_LQUEM');
6935: htp.headClose;
6936: wfa_sec.Header(FALSE, owa_util.get_owa_service_path ||'wf_event_html.FindQueueMessage?p_queue_name='||p_queue_name||'&p_type=WF_EVENT_T', wf_core.translate('WFQUEUE_MESSAGE_TITLE'), TRUE);
6937: htp.br;
6931: htp.headOpen;
6932: htp.p('
6933: htp.title(wf_core.translate('WFQUEUE_MESSAGE_TITLE'));
6934: wfa_html.create_help_function('wf/links/t_l.htm?T_LQUEM');
6935: htp.headClose;
6936: wfa_sec.Header(FALSE, owa_util.get_owa_service_path ||'wf_event_html.FindQueueMessage?p_queue_name='||p_queue_name||'&p_type=WF_EVENT_T', wf_core.translate('WFQUEUE_MESSAGE_TITLE'), TRUE);
6937: htp.br;
6938:
6939: IF (admin_mode = 'N') THEN
6933: htp.title(wf_core.translate('WFQUEUE_MESSAGE_TITLE'));
6934: wfa_html.create_help_function('wf/links/t_l.htm?T_LQUEM');
6935: htp.headClose;
6936: wfa_sec.Header(FALSE, owa_util.get_owa_service_path ||'wf_event_html.FindQueueMessage?p_queue_name='||p_queue_name||'&p_type=WF_EVENT_T', wf_core.translate('WFQUEUE_MESSAGE_TITLE'), TRUE);
6937: htp.br;
6938:
6939: IF (admin_mode = 'N') THEN
6940: htp.center(htf.bold(l_error_msg));
6941: return;
6936: wfa_sec.Header(FALSE, owa_util.get_owa_service_path ||'wf_event_html.FindQueueMessage?p_queue_name='||p_queue_name||'&p_type=WF_EVENT_T', wf_core.translate('WFQUEUE_MESSAGE_TITLE'), TRUE);
6937: htp.br;
6938:
6939: IF (admin_mode = 'N') THEN
6940: htp.center(htf.bold(l_error_msg));
6941: return;
6942: END IF;
6943:
6944: -- Column headers
6941: return;
6942: END IF;
6943:
6944: -- Column headers
6945: htp.tableOpen('border=1 cellpadding=3 bgcolor=white width="100%"
6946: summary="' || wf_core.translate('WFQUEUE_MESSAGE_TITLE') || '"');
6947: htp.tableRowOpen(cattributes=>'bgcolor=#006699');
6948:
6949:
6943:
6944: -- Column headers
6945: htp.tableOpen('border=1 cellpadding=3 bgcolor=white width="100%"
6946: summary="' || wf_core.translate('WFQUEUE_MESSAGE_TITLE') || '"');
6947: htp.tableRowOpen(cattributes=>'bgcolor=#006699');
6948:
6949:
6950: htp.tableHeader(cvalue=>''||
6951: wf_core.translate('EVENTNAME')||'',
6946: summary="' || wf_core.translate('WFQUEUE_MESSAGE_TITLE') || '"');
6947: htp.tableRowOpen(cattributes=>'bgcolor=#006699');
6948:
6949:
6950: htp.tableHeader(cvalue=>''||
6951: wf_core.translate('EVENTNAME')||'',
6952: calign=>'Center',
6953: cattributes=>'id="' ||
6954: wf_core.translate('EVENTNAME') || '"');
6951: wf_core.translate('EVENTNAME')||'',
6952: calign=>'Center',
6953: cattributes=>'id="' ||
6954: wf_core.translate('EVENTNAME') || '"');
6955: htp.tableHeader(cvalue=>''||
6956: wf_core.translate('EVENTKEY')||'',
6957: calign=>'Center',
6958: cattributes=>'id="' ||
6959: wf_core.translate('EVENTKEY') || '"');
6956: wf_core.translate('EVENTKEY')||'',
6957: calign=>'Center',
6958: cattributes=>'id="' ||
6959: wf_core.translate('EVENTKEY') || '"');
6960: htp.tableHeader(cvalue=>''||
6961: wf_core.translate('WF_CORRELATION')||'',
6962: calign=>'Center',
6963: cattributes=>'id="' ||
6964: wf_core.translate('WF_CORRELATION') || '"');
6961: wf_core.translate('WF_CORRELATION')||'',
6962: calign=>'Center',
6963: cattributes=>'id="' ||
6964: wf_core.translate('WF_CORRELATION') || '"');
6965: htp.tableHeader(cvalue=>''||
6966: wf_core.translate('PARAMETERS')||'',
6967: calign=>'Center',
6968: cattributes=>'id="' ||
6969: wf_core.translate('PARAMETERS') || '"');
6966: wf_core.translate('PARAMETERS')||'',
6967: calign=>'Center',
6968: cattributes=>'id="' ||
6969: wf_core.translate('PARAMETERS') || '"');
6970: htp.tableHeader(cvalue=>''||
6971: wf_core.translate('FROMAGENTSYSTEM')||'',
6972: calign=>'Center',
6973: cattributes=>'id="' ||
6974: wf_core.translate('FROMAGENTSYSTEM') || '"');
6971: wf_core.translate('FROMAGENTSYSTEM')||'',
6972: calign=>'Center',
6973: cattributes=>'id="' ||
6974: wf_core.translate('FROMAGENTSYSTEM') || '"');
6975: htp.tableHeader(cvalue=>''||
6976: wf_core.translate('TOAGENTSYSTEM')||'',
6977: calign=>'Center',
6978: cattributes=>'id="' ||
6979: wf_core.translate('TOAGENTSYSTEM') || '"');
6976: wf_core.translate('TOAGENTSYSTEM')||'',
6977: calign=>'Center',
6978: cattributes=>'id="' ||
6979: wf_core.translate('TOAGENTSYSTEM') || '"');
6980: htp.tableHeader(cvalue=>''||
6981: wf_core.translate('WF_SEND_DATE')||'',
6982: calign=>'Center',
6983: cattributes=>'id="' ||
6984: wf_core.translate('WF_SEND_DATE') || '"');
6981: wf_core.translate('WF_SEND_DATE')||'',
6982: calign=>'Center',
6983: cattributes=>'id="' ||
6984: wf_core.translate('WF_SEND_DATE') || '"');
6985: htp.tableHeader(cvalue=>''||
6986: wf_core.translate('WFMON_ERROR_MESSAGE')||'',
6987: calign=>'Center',
6988: cattributes=>'id="' ||
6989: wf_core.translate('WFMON_ERROR_MESSAGE') || '"');
6986: wf_core.translate('WFMON_ERROR_MESSAGE')||'',
6987: calign=>'Center',
6988: cattributes=>'id="' ||
6989: wf_core.translate('WFMON_ERROR_MESSAGE') || '"');
6990: htp.tableHeader(cvalue=>''||
6991: wf_core.translate('WFMON_ERROR_STACK')||'',
6992: calign=>'Center',
6993: cattributes=>'id="' ||
6994: wf_core.translate('WFMON_ERROR_STACK') || '"');
6991: wf_core.translate('WFMON_ERROR_STACK')||'',
6992: calign=>'Center',
6993: cattributes=>'id="' ||
6994: wf_core.translate('WFMON_ERROR_STACK') || '"');
6995: htp.tableHeader(cvalue=>''||
6996: wf_core.translate('MESSAGESTATE')||'',
6997: calign=>'Center',
6998: cattributes=>'id="' ||
6999: wf_core.translate('MESSAGESTATE') || '"');
6996: wf_core.translate('MESSAGESTATE')||'',
6997: calign=>'Center',
6998: cattributes=>'id="' ||
6999: wf_core.translate('MESSAGESTATE') || '"');
7000: htp.tableHeader(cvalue=>''||
7001: wf_core.translate('XMLEVENTDATA')||'',
7002: calign=>'Center',
7003: cattributes=>'id="' ||
7004: wf_core.translate('XMLEVENTDATA') || '"');
7002: calign=>'Center',
7003: cattributes=>'id="' ||
7004: wf_core.translate('XMLEVENTDATA') || '"');
7005:
7006: htp.tableHeader(cvalue=>''||
7007: wf_core.translate('TXTEVENTDATA')||'',
7008: calign=>'Center',
7009: cattributes=>'id="' ||
7010: wf_core.translate('TXTEVENTDATA') || '"');
7007: wf_core.translate('TXTEVENTDATA')||'',
7008: calign=>'Center',
7009: cattributes=>'id="' ||
7010: wf_core.translate('TXTEVENTDATA') || '"');
7011: htp.tableRowClose;
7012: htp.tableRowOpen;
7013: htp.tableRowClose;
7014:
7015: -- As per review comment running the sql for
7008: calign=>'Center',
7009: cattributes=>'id="' ||
7010: wf_core.translate('TXTEVENTDATA') || '"');
7011: htp.tableRowClose;
7012: htp.tableRowOpen;
7013: htp.tableRowClose;
7014:
7015: -- As per review comment running the sql for
7016: -- wf_agent wqueues alone
7009: cattributes=>'id="' ||
7010: wf_core.translate('TXTEVENTDATA') || '"');
7011: htp.tableRowClose;
7012: htp.tableRowOpen;
7013: htp.tableRowClose;
7014:
7015: -- As per review comment running the sql for
7016: -- wf_agent wqueues alone
7017:
7104: OR l_eventname IS NULL)
7105: AND ( upper(l_eventkey) LIKE l_likeeventkey
7106: OR l_eventkey IS NULL ) THEN
7107:
7108: htp.tableRowOpen(null, 'TOP');
7109:
7110: htp.p('');
7111:
7112: IF l_EventName IS NULL THEN
7106: OR l_eventkey IS NULL ) THEN
7107:
7108: htp.tableRowOpen(null, 'TOP');
7109:
7110: htp.p('');
7111:
7112: IF l_EventName IS NULL THEN
7113: l_EventName := ' ';
7114: END IF;
7112: IF l_EventName IS NULL THEN
7113: l_EventName := ' ';
7114: END IF;
7115:
7116: htp.tableData(l_EventName, 'left', cattributes=>'headers="' ||
7117: wf_core.translate('EVENTNAME') || '"');
7118:
7119: IF l_eventkey IS NULL THEN
7120: l_eventkey := ' ';
7119: IF l_eventkey IS NULL THEN
7120: l_eventkey := ' ';
7121: END IF;
7122:
7123: htp.tableData(l_EventKey, 'left', cattributes=>'headers="' ||
7124: wf_core.translate('EVENTKEY') || '"');
7125:
7126: if l_message.Correlation_Id is not null then
7127: htp.tableData(l_message.GetCorrelationId(),'left', cattributes=>'headers="' || wf_core.translate('WF_CORRELATION') || '"');
7123: htp.tableData(l_EventKey, 'left', cattributes=>'headers="' ||
7124: wf_core.translate('EVENTKEY') || '"');
7125:
7126: if l_message.Correlation_Id is not null then
7127: htp.tableData(l_message.GetCorrelationId(),'left', cattributes=>'headers="' || wf_core.translate('WF_CORRELATION') || '"');
7128: else
7129: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
7130: end if;
7131:
7125:
7126: if l_message.Correlation_Id is not null then
7127: htp.tableData(l_message.GetCorrelationId(),'left', cattributes=>'headers="' || wf_core.translate('WF_CORRELATION') || '"');
7128: else
7129: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
7130: end if;
7131:
7132: -- Display the Parameter List
7133: l_parmlist_t := l_message.getParameterList();
7137: l_parameters := l_parameters||l_parmlist_t(i).getName()||'='||
7138: l_parmlist_t(i).getValue()||' ';
7139: i := l_parmlist_t.NEXT(i);
7140: end loop;
7141: htp.tableData(l_parameters,'left',
7142: cattributes=>'headers="' ||
7143: wf_core.translate('PARAMETERS') || '"');
7144: else
7145: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
7141: htp.tableData(l_parameters,'left',
7142: cattributes=>'headers="' ||
7143: wf_core.translate('PARAMETERS') || '"');
7144: else
7145: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
7146: end if;
7147:
7148:
7149: if l_message.From_Agent is not null then
7146: end if;
7147:
7148:
7149: if l_message.From_Agent is not null then
7150: htp.tableData(l_message.GetFromAgent().GetName()||'@'
7151: ||l_message.GetFromAgent().GetSystem(), 'left',
7152: cattributes=>'headers="' ||
7153: wf_core.translate('FROMAGENTSYSTEM') || '"');
7154: else
7151: ||l_message.GetFromAgent().GetSystem(), 'left',
7152: cattributes=>'headers="' ||
7153: wf_core.translate('FROMAGENTSYSTEM') || '"');
7154: else
7155: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
7156: end if;
7157:
7158: if l_message.To_Agent is not null then
7159: htp.tableData(l_message.GetToAgent().GetName()||'@'
7155: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
7156: end if;
7157:
7158: if l_message.To_Agent is not null then
7159: htp.tableData(l_message.GetToAgent().GetName()||'@'
7160: ||l_message.GetToAgent().GetSystem(), 'left',
7161: cattributes=>'headers="' ||
7162: wf_core.translate('TOAGENTSYSTEM') || '"');
7163: else
7160: ||l_message.GetToAgent().GetSystem(), 'left',
7161: cattributes=>'headers="' ||
7162: wf_core.translate('TOAGENTSYSTEM') || '"');
7163: else
7164: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
7165: end if;
7166:
7167: if l_message.Send_Date is not null then
7168: htp.tableData(to_char(l_message.GetSendDate(),'DD-MON-YYYY HH24:MI:SS'),'left', cattributes=>'headers="' ||
7164: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
7165: end if;
7166:
7167: if l_message.Send_Date is not null then
7168: htp.tableData(to_char(l_message.GetSendDate(),'DD-MON-YYYY HH24:MI:SS'),'left', cattributes=>'headers="' ||
7169: wf_core.translate('WF_SEND_DATE') || '"');
7170: else
7171: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
7172: end if;
7167: if l_message.Send_Date is not null then
7168: htp.tableData(to_char(l_message.GetSendDate(),'DD-MON-YYYY HH24:MI:SS'),'left', cattributes=>'headers="' ||
7169: wf_core.translate('WF_SEND_DATE') || '"');
7170: else
7171: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
7172: end if;
7173:
7174: if l_message.error_message is not null then
7175: htp.tableData(l_message.GetErrorMessage(),
7171: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
7172: end if;
7173:
7174: if l_message.error_message is not null then
7175: htp.tableData(l_message.GetErrorMessage(),
7176: 'left', cattributes=>'headers="' ||
7177: wf_core.translate('WFMON_ERROR_MESSAGE') || '"');
7178: else
7179: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
7175: htp.tableData(l_message.GetErrorMessage(),
7176: 'left', cattributes=>'headers="' ||
7177: wf_core.translate('WFMON_ERROR_MESSAGE') || '"');
7178: else
7179: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
7180: end if;
7181:
7182: if l_message.error_stack is not null then
7183: htp.tableData(l_message.GetErrorStack(),
7179: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
7180: end if;
7181:
7182: if l_message.error_stack is not null then
7183: htp.tableData(l_message.GetErrorStack(),
7184: 'left', cattributes=>'headers="' ||
7185: wf_core.translate('WFMON_ERROR_STACK') || '"');
7186: else
7187: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
7183: htp.tableData(l_message.GetErrorStack(),
7184: 'left', cattributes=>'headers="' ||
7185: wf_core.translate('WFMON_ERROR_STACK') || '"');
7186: else
7187: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
7188: end if;
7189:
7190: htp.tableData(l_charmsgstate,'center', cattributes=>'headers="' ||
7191: wf_core.translate('MESSAGESTATE') || '"');
7186: else
7187: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
7188: end if;
7189:
7190: htp.tableData(l_charmsgstate,'center', cattributes=>'headers="' ||
7191: wf_core.translate('MESSAGESTATE') || '"');
7192:
7193: l_eventdata := l_message.GetEventData();
7194:
7191: wf_core.translate('MESSAGESTATE') || '"');
7192:
7193: l_eventdata := l_message.GetEventData();
7194:
7195: htp.tableData(htf.anchor2(curl=>wfa_html.base_url||
7196: '/wf_event_html.EventDataContents?p_message_id='||l_msg_id
7197: ||'&p_queue_table='||l_qtable||'&p_mimetype=text/xml',
7198: ctext=>'
7199: BORDER=0>'),
7198: ctext=>'
7199: BORDER=0>'),
7200: 'center', cattributes=>'valign="MIDDLE"
7201: headers="' || wf_core.translate('XMLEVENTDATA') || '"');
7202: htp.tableData(htf.anchor2(curl=>wfa_html.base_url||
7203: '/wf_event_html.EventDataContents?p_message_id='||l_msg_id
7204: ||'&p_queue_table='||l_qtable||'&p_mimetype=text',
7205: ctext=>'
7206: BORDER=0>'),
7211:
7212: END LOOP;
7213: CLOSE l_qcontents;
7214:
7215: htp.tableclose;
7216:
7217: htp.br;
7218:
7219: wfa_sec.Footer;
7213: CLOSE l_qcontents;
7214:
7215: htp.tableclose;
7216:
7217: htp.br;
7218:
7219: wfa_sec.Footer;
7220:
7221: htp.htmlClose;
7217: htp.br;
7218:
7219: wfa_sec.Footer;
7220:
7221: htp.htmlClose;
7222:
7223: exception
7224: when others then
7225: rollback;
7387:
7388: l_messagedata := dbms_lob.substr(l_clob, l_amounttoread,
7389: l_beginposition);
7390:
7391: htp.p(l_messagedata);
7392:
7393: l_beginposition := l_endposition + 1;
7394:
7395: END LOOP;
7409: exception
7410: when NO_DATA_FOUND then
7411: exit;
7412: end;
7413: htp.p(l_messagedata);
7414: l_beginposition := (l_amounttoread*l_counter) + 1;
7415: END LOOP;
7416: END IF;
7417: ELSE
7414: l_beginposition := (l_amounttoread*l_counter) + 1;
7415: END LOOP;
7416: END IF;
7417: ELSE
7418: htp.p(wf_Core.translate('NO_MESSAGE_FOUND'));
7419: END IF;
7420: exception
7421: when others then
7422: rollback;
7499:
7500: l_messagedata := dbms_lob.substr(l_eventdata, l_amounttoread,
7501: l_beginposition);
7502:
7503: htp.p(l_messagedata);
7504:
7505: l_beginposition := l_endposition + 1;
7506:
7507: END LOOP;
7521: exception
7522: when NO_DATA_FOUND then
7523: exit;
7524: end;
7525: htp.p(l_messagedata);
7526: l_beginposition := (l_amounttoread*l_counter) + 1;
7527: END LOOP;
7528: END IF;
7529: ELSE
7526: l_beginposition := (l_amounttoread*l_counter) + 1;
7527: END LOOP;
7528: END IF;
7529: ELSE
7530: htp.p(wf_Core.translate('NO_MESSAGE_FOUND'));
7531: END IF;
7532:
7533: EXCEPTION
7534: WHEN OTHERS THEN