1676:
1677: end if;
1678:
1679: -- Set page title
1680: htp.htmlOpen;
1681: htp.headOpen;
1682: htp.p('
1683: htp.title(wf_core.translate('WFGENERIC_QUEUE_TITLE'));
1684: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
1677: end if;
1678:
1679: -- Set page title
1680: htp.htmlOpen;
1681: htp.headOpen;
1682: htp.p('
1683: htp.title(wf_core.translate('WFGENERIC_QUEUE_TITLE'));
1684: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
1685: htp.headClose;
1678:
1679: -- Set page title
1680: htp.htmlOpen;
1681: htp.headOpen;
1682: htp.p('
1683: htp.title(wf_core.translate('WFGENERIC_QUEUE_TITLE'));
1684: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
1685: htp.headClose;
1686: wfa_sec.Header(FALSE, '',wf_core.translate('WFGENERIC_QUEUE_TITLE'), FALSE);
1679: -- Set page title
1680: htp.htmlOpen;
1681: htp.headOpen;
1682: htp.p('
1683: htp.title(wf_core.translate('WFGENERIC_QUEUE_TITLE'));
1684: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
1685: htp.headClose;
1686: wfa_sec.Header(FALSE, '',wf_core.translate('WFGENERIC_QUEUE_TITLE'), FALSE);
1687: htp.br;
1681: htp.headOpen;
1682: htp.p('
1683: htp.title(wf_core.translate('WFGENERIC_QUEUE_TITLE'));
1684: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
1685: htp.headClose;
1686: wfa_sec.Header(FALSE, '',wf_core.translate('WFGENERIC_QUEUE_TITLE'), FALSE);
1687: htp.br;
1688:
1689: IF (admin_mode = 'N') THEN
1683: htp.title(wf_core.translate('WFGENERIC_QUEUE_TITLE'));
1684: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
1685: htp.headClose;
1686: wfa_sec.Header(FALSE, '',wf_core.translate('WFGENERIC_QUEUE_TITLE'), FALSE);
1687: htp.br;
1688:
1689: IF (admin_mode = 'N') THEN
1690:
1691: htp.center(htf.bold(l_error_msg));
1687: htp.br;
1688:
1689: IF (admin_mode = 'N') THEN
1690:
1691: htp.center(htf.bold(l_error_msg));
1692: return;
1693:
1694: END IF;
1695:
1693:
1694: END IF;
1695:
1696: -- Column headers
1697: htp.tableOpen(cattributes=>'border=1 cellpadding=3 bgcolor=white width="100%" summary=""');
1698: htp.tableRowOpen(cattributes=>'bgcolor=#006699');
1699:
1700:
1701: htp.tableHeader(cvalue=>''||
1694: END IF;
1695:
1696: -- Column headers
1697: htp.tableOpen(cattributes=>'border=1 cellpadding=3 bgcolor=white width="100%" summary=""');
1698: htp.tableRowOpen(cattributes=>'bgcolor=#006699');
1699:
1700:
1701: htp.tableHeader(cvalue=>''||
1702: wf_core.translate('PROTOCOL')||'',
1697: htp.tableOpen(cattributes=>'border=1 cellpadding=3 bgcolor=white width="100%" summary=""');
1698: htp.tableRowOpen(cattributes=>'bgcolor=#006699');
1699:
1700:
1701: htp.tableHeader(cvalue=>''||
1702: wf_core.translate('PROTOCOL')||'',
1703: calign=>'Center',
1704: cattributes=>'id="' || wf_core.translate('PROTOCOL') || '"');
1705: htp.tableHeader(cvalue=>''||
1701: htp.tableHeader(cvalue=>''||
1702: wf_core.translate('PROTOCOL')||'',
1703: calign=>'Center',
1704: cattributes=>'id="' || wf_core.translate('PROTOCOL') || '"');
1705: htp.tableHeader(cvalue=>''||
1706: wf_core.translate('QUEUE_DESCRIPTION')||'',
1707: calign=>'Center',
1708: cattributes=>'id="' || wf_core.translate('QUEUE_DESCRIPTION') || '"');
1709: htp.tableHeader(cvalue=>''||
1705: htp.tableHeader(cvalue=>''||
1706: wf_core.translate('QUEUE_DESCRIPTION')||'',
1707: calign=>'Center',
1708: cattributes=>'id="' || wf_core.translate('QUEUE_DESCRIPTION') || '"');
1709: htp.tableHeader(cvalue=>''||
1710: wf_core.translate('INBOUND_PROMPT')||'',
1711: calign=>'Center',
1712: cattributes=>'id="' || wf_core.translate('INBOUND_PROMPT') || '"');
1713: htp.tableHeader(cvalue=>''||
1709: htp.tableHeader(cvalue=>''||
1710: wf_core.translate('INBOUND_PROMPT')||'',
1711: calign=>'Center',
1712: cattributes=>'id="' || wf_core.translate('INBOUND_PROMPT') || '"');
1713: htp.tableHeader(cvalue=>''||
1714: wf_core.translate('QUEUE_COUNT')||'',
1715: calign=>'Center',
1716: cattributes=>'id="' || wf_core.translate('QUEUE_COUNT') || '"');
1717: htp.tableHeader(cvalue=>''||
1713: htp.tableHeader(cvalue=>''||
1714: wf_core.translate('QUEUE_COUNT')||'',
1715: calign=>'Center',
1716: cattributes=>'id="' || wf_core.translate('QUEUE_COUNT') || '"');
1717: htp.tableHeader(cvalue=>''||
1718: wf_core.translate('VIEW_DETAIL')||'',
1719: calign=>'Center',
1720: cattributes=>'id="' || wf_core.translate('VIEW_DETAIL') || '"');
1721: htp.tableHeader(cvalue=>''||
1717: htp.tableHeader(cvalue=>''||
1718: wf_core.translate('VIEW_DETAIL')||'',
1719: calign=>'Center',
1720: cattributes=>'id="' || wf_core.translate('VIEW_DETAIL') || '"');
1721: htp.tableHeader(cvalue=>''||
1722: wf_core.translate('DELETE')||'',
1723: calign=>'Center',
1724: cattributes=>'id="' || wf_core.translate('DELETE') || '"');
1725:
1722: wf_core.translate('DELETE')||'',
1723: calign=>'Center',
1724: cattributes=>'id="' || wf_core.translate('DELETE') || '"');
1725:
1726: htp.tableRowClose;
1727: htp.tableRowOpen;
1728: htp.tableRowClose;
1729:
1730: -- Show all nodes
1723: calign=>'Center',
1724: cattributes=>'id="' || wf_core.translate('DELETE') || '"');
1725:
1726: htp.tableRowClose;
1727: htp.tableRowOpen;
1728: htp.tableRowClose;
1729:
1730: -- Show all nodes
1731: for queues in queues_cursor loop
1724: cattributes=>'id="' || wf_core.translate('DELETE') || '"');
1725:
1726: htp.tableRowClose;
1727: htp.tableRowOpen;
1728: htp.tableRowClose;
1729:
1730: -- Show all nodes
1731: for queues in queues_cursor loop
1732:
1729:
1730: -- Show all nodes
1731: for queues in queues_cursor loop
1732:
1733: htp.tableRowOpen(null, 'TOP');
1734:
1735:
1736: htp.tableData(htf.anchor2(
1737: curl=>wfa_html.base_url||
1732:
1733: htp.tableRowOpen(null, 'TOP');
1734:
1735:
1736: htp.tableData(htf.anchor2(
1737: curl=>wfa_html.base_url||
1738: '/wf_queue.generic_queue_edit?p_protocol='||
1739: queues.protocol||'&p_inbound_outbound='||
1740: queues.inbound_outbound,
1742: 'Left',
1743: cattributes=>'headers="' ||
1744: wf_core.translate('PROTOCOL') || '"');
1745:
1746: htp.tableData(queues.description, 'left',
1747: cattributes=>'headers="' || wf_core.translate('QUEUE_DESCRIPTION') || '"');
1748:
1749: htp.tableData(queues.inbound_outbound, 'left',
1750: cattributes=>'headers="' || wf_core.translate('INBOUND_PROMPT') || '"');
1745:
1746: htp.tableData(queues.description, 'left',
1747: cattributes=>'headers="' || wf_core.translate('QUEUE_DESCRIPTION') || '"');
1748:
1749: htp.tableData(queues.inbound_outbound, 'left',
1750: cattributes=>'headers="' || wf_core.translate('INBOUND_PROMPT') || '"');
1751:
1752: htp.tableData(queues.queue_count, 'left',
1753: cattributes=>'headers="' || wf_core.translate('QUEUE_COUNT') || '"');
1748:
1749: htp.tableData(queues.inbound_outbound, 'left',
1750: cattributes=>'headers="' || wf_core.translate('INBOUND_PROMPT') || '"');
1751:
1752: htp.tableData(queues.queue_count, 'left',
1753: cattributes=>'headers="' || wf_core.translate('QUEUE_COUNT') || '"');
1754:
1755: htp.tableData(htf.anchor2(curl=>wfa_html.base_url||
1756: '/wf_queue.Generic_Queue_View_Detail?p_protocol='||
1751:
1752: htp.tableData(queues.queue_count, 'left',
1753: cattributes=>'headers="' || wf_core.translate('QUEUE_COUNT') || '"');
1754:
1755: htp.tableData(htf.anchor2(curl=>wfa_html.base_url||
1756: '/wf_queue.Generic_Queue_View_Detail?p_protocol='||
1757: queues.protocol||'&p_inbound_outbound='||
1758: queues.inbound_outbound,
1759: ctext=>''),
1759: ctext=>''),
1760: 'center', cattributes=>'valign="MIDDLE"
1761: headers="' || wf_core.translate('VIEW_DETAIL') || '"');
1762:
1763: htp.tableData(htf.anchor2(curl=>wfa_html.base_url||
1764: '/wf_queue.generic_queue_confirm_delete?p_protocol='||
1765: queues.protocol||'&p_inbound_outbound='||
1766: queues.inbound_outbound,
1767: ctext=>''),
1770:
1771:
1772: end loop;
1773:
1774: htp.tableclose;
1775:
1776: htp.br;
1777:
1778: htp.tableopen(calign=>'CENTER',cattributes=>'summary=""');
1772: end loop;
1773:
1774: htp.tableclose;
1775:
1776: htp.br;
1777:
1778: htp.tableopen(calign=>'CENTER',cattributes=>'summary=""');
1779:
1780: --Add new node Button
1774: htp.tableclose;
1775:
1776: htp.br;
1777:
1778: htp.tableopen(calign=>'CENTER',cattributes=>'summary=""');
1779:
1780: --Add new node Button
1781: htp.tableRowOpen;
1782:
1777:
1778: htp.tableopen(calign=>'CENTER',cattributes=>'summary=""');
1779:
1780: --Add new node Button
1781: htp.tableRowOpen;
1782:
1783: l_url := wfa_html.base_url||'/wf_queue.generic_queue_edit';
1784: l_icon := 'FNDJLFOK.gif';
1785: l_text := wf_core.translate ('WFQUEUE_CREATE');
1784: l_icon := 'FNDJLFOK.gif';
1785: l_text := wf_core.translate ('WFQUEUE_CREATE');
1786: l_onmouseover := wf_core.translate ('WFQUEUE_CREATE');
1787:
1788: htp.p('
1788: htp.p('
1790: wf_pref.create_reg_button (l_url, l_onmouseover, l_media, l_icon, l_text);
1791:
1792: htp.p('');
1793:
1794: htp.tableRowClose;
1795:
1796: htp.tableclose;
1797:
1798: wfa_sec.Footer;
1792: htp.p('');
1793:
1794: htp.tableRowClose;
1795:
1796: htp.tableclose;
1797:
1798: wfa_sec.Footer;
1799: htp.htmlClose;
1800:
1795:
1796: htp.tableclose;
1797:
1798: wfa_sec.Footer;
1799: htp.htmlClose;
1800:
1801: exception
1802: when others then
1803: wf_core.context('FND_DOCUMENT_MANAGEMENT', 'Generic_Queue_Display');
1847:
1848: end if;
1849:
1850: -- Set page title
1851: htp.htmlOpen;
1852: htp.headOpen;
1853: htp.p('
1854: htp.title(wf_core.translate('WFGENERIC_QUEUE_TITLE'));
1855: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
1848: end if;
1849:
1850: -- Set page title
1851: htp.htmlOpen;
1852: htp.headOpen;
1853: htp.p('
1854: htp.title(wf_core.translate('WFGENERIC_QUEUE_TITLE'));
1855: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
1856: htp.headClose;
1849:
1850: -- Set page title
1851: htp.htmlOpen;
1852: htp.headOpen;
1853: htp.p('
1854: htp.title(wf_core.translate('WFGENERIC_QUEUE_TITLE'));
1855: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
1856: htp.headClose;
1857: wfa_sec.Header(FALSE, '',wf_core.translate('WFGENERIC_QUEUE_TITLE'), FALSE);
1850: -- Set page title
1851: htp.htmlOpen;
1852: htp.headOpen;
1853: htp.p('
1854: htp.title(wf_core.translate('WFGENERIC_QUEUE_TITLE'));
1855: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
1856: htp.headClose;
1857: wfa_sec.Header(FALSE, '',wf_core.translate('WFGENERIC_QUEUE_TITLE'), FALSE);
1858: htp.br;
1852: htp.headOpen;
1853: htp.p('
1854: htp.title(wf_core.translate('WFGENERIC_QUEUE_TITLE'));
1855: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
1856: htp.headClose;
1857: wfa_sec.Header(FALSE, '',wf_core.translate('WFGENERIC_QUEUE_TITLE'), FALSE);
1858: htp.br;
1859:
1860: IF (admin_mode = 'N') THEN
1854: htp.title(wf_core.translate('WFGENERIC_QUEUE_TITLE'));
1855: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
1856: htp.headClose;
1857: wfa_sec.Header(FALSE, '',wf_core.translate('WFGENERIC_QUEUE_TITLE'), FALSE);
1858: htp.br;
1859:
1860: IF (admin_mode = 'N') THEN
1861:
1862: htp.center(htf.bold(l_error_msg));
1858: htp.br;
1859:
1860: IF (admin_mode = 'N') THEN
1861:
1862: htp.center(htf.bold(l_error_msg));
1863: return;
1864:
1865: END IF;
1866:
1870: WHERE UPPER(p_protocol) = protocol
1871: AND p_inbound_outbound = inbound_outbound;
1872:
1873: -- Column headers
1874: htp.tableOpen(cattributes=>'border=1 cellpadding=3 bgcolor=white width="100%" summary=""');
1875: htp.tableRowOpen(cattributes=>'bgcolor=#006699');
1876:
1877: htp.tableHeader(cvalue=>''||
1878: wf_core.translate('PROTOCOL')||'',
1871: AND p_inbound_outbound = inbound_outbound;
1872:
1873: -- Column headers
1874: htp.tableOpen(cattributes=>'border=1 cellpadding=3 bgcolor=white width="100%" summary=""');
1875: htp.tableRowOpen(cattributes=>'bgcolor=#006699');
1876:
1877: htp.tableHeader(cvalue=>''||
1878: wf_core.translate('PROTOCOL')||'',
1879: calign=>'Center',
1873: -- Column headers
1874: htp.tableOpen(cattributes=>'border=1 cellpadding=3 bgcolor=white width="100%" summary=""');
1875: htp.tableRowOpen(cattributes=>'bgcolor=#006699');
1876:
1877: htp.tableHeader(cvalue=>''||
1878: wf_core.translate('PROTOCOL')||'',
1879: calign=>'Center',
1880: cattributes=>'id="' ||
1881: wf_core.translate('PROTOCOL') || '"');
1878: wf_core.translate('PROTOCOL')||'',
1879: calign=>'Center',
1880: cattributes=>'id="' ||
1881: wf_core.translate('PROTOCOL') || '"');
1882: htp.tableHeader(cvalue=>''||
1883: wf_core.translate('QUEUE_NUMBER')||'',
1884: calign=>'Center',
1885: cattributes=>'id="' ||
1886: wf_core.translate('QUEUE_NUMBER') || '"');
1883: wf_core.translate('QUEUE_NUMBER')||'',
1884: calign=>'Center',
1885: cattributes=>'id="' ||
1886: wf_core.translate('QUEUE_NUMBER') || '"');
1887: htp.tableHeader(cvalue=>''||
1888: wf_core.translate('QUEUE_NAME')||'',
1889: calign=>'Center',
1890: cattributes=>'id="' ||
1891: wf_core.translate('QUEUE_NAME') || '"');
1888: wf_core.translate('QUEUE_NAME')||'',
1889: calign=>'Center',
1890: cattributes=>'id="' ||
1891: wf_core.translate('QUEUE_NAME') || '"');
1892: htp.tableHeader(cvalue=>''||
1893: wf_core.translate('QUEUE_COUNT')||'',
1894: calign=>'Center',
1895: cattributes=>'id="' ||
1896: wf_core.translate('QUEUE_COUNT') || '"');
1893: wf_core.translate('QUEUE_COUNT')||'',
1894: calign=>'Center',
1895: cattributes=>'id="' ||
1896: wf_core.translate('QUEUE_COUNT') || '"');
1897: htp.tableHeader(cvalue=>''||
1898: wf_core.translate('VIEW_DETAIL')||'',
1899: calign=>'Center',
1900: cattributes=>'id="' ||
1901: wf_core.translate('VIEW_DETAIL') || '"');
1899: calign=>'Center',
1900: cattributes=>'id="' ||
1901: wf_core.translate('VIEW_DETAIL') || '"');
1902:
1903: htp.tableRowClose;
1904: htp.tableRowOpen;
1905: htp.tableRowClose;
1906:
1907: -- Show all queues for the given protocol
1900: cattributes=>'id="' ||
1901: wf_core.translate('VIEW_DETAIL') || '"');
1902:
1903: htp.tableRowClose;
1904: htp.tableRowOpen;
1905: htp.tableRowClose;
1906:
1907: -- Show all queues for the given protocol
1908: for ii in 1..l_count loop
1901: wf_core.translate('VIEW_DETAIL') || '"');
1902:
1903: htp.tableRowClose;
1904: htp.tableRowOpen;
1905: htp.tableRowClose;
1906:
1907: -- Show all queues for the given protocol
1908: for ii in 1..l_count loop
1909:
1906:
1907: -- Show all queues for the given protocol
1908: for ii in 1..l_count loop
1909:
1910: htp.tableRowOpen(null, 'TOP');
1911:
1912: htp.tableData(p_protocol, 'left', cattributes=>'headers="' ||
1913: wf_core.translate('PROTOCOL') || '"');
1914:
1908: for ii in 1..l_count loop
1909:
1910: htp.tableRowOpen(null, 'TOP');
1911:
1912: htp.tableData(p_protocol, 'left', cattributes=>'headers="' ||
1913: wf_core.translate('PROTOCOL') || '"');
1914:
1915: htp.tableData(to_char(ii), 'left', cattributes=>'headers="' ||
1916: wf_core.translate('QUEUE_NUMBER') || '"');
1911:
1912: htp.tableData(p_protocol, 'left', cattributes=>'headers="' ||
1913: wf_core.translate('PROTOCOL') || '"');
1914:
1915: htp.tableData(to_char(ii), 'left', cattributes=>'headers="' ||
1916: wf_core.translate('QUEUE_NUMBER') || '"');
1917:
1918: -- p_protocol and p_inbound_outbound were verified above
1919: -- ii must be a number
1917:
1918: -- p_protocol and p_inbound_outbound were verified above
1919: -- ii must be a number
1920: -- BINDVAR_SCAN_IGNORE
1921: htp.tableData(wf_core.translate('WF_SCHEMA')||'.'||'WF_'||p_protocol||'_'||substr(p_inbound_outbound, 1, 1)||'_'||to_char(ii)||'_QUEUE', 'left', cattributes=>'headers="' || wf_core.translate('QUEUE_NAME') || '"');
1922:
1923: /*
1924: ** Check to see if there are any messages in the specified queue
1925: */
1926: l_sql := 'SELECT COUNT(1) FROM WF_'||p_protocol||'_'||substr(p_inbound_outbound, 1, 1)||'_'||to_char(ii)||'_TABLE';
1927:
1928: execute immediate l_sql INTO l_count;
1929:
1930: htp.tableData(to_char(l_count), 'left', cattributes=>'headers="' ||
1931: wf_core.translate('QUEUE_COUNT') || '"');
1932:
1933: htp.tableData(htf.anchor2(curl=>wfa_html.base_url||
1934: '/wf_queue.generic_queue_display_contents?p_protocol='||
1929:
1930: htp.tableData(to_char(l_count), 'left', cattributes=>'headers="' ||
1931: wf_core.translate('QUEUE_COUNT') || '"');
1932:
1933: htp.tableData(htf.anchor2(curl=>wfa_html.base_url||
1934: '/wf_queue.generic_queue_display_contents?p_protocol='||
1935: p_protocol||'&p_inbound_outbound='||
1936: p_inbound_outbound||'&p_queue_number='||
1937: to_char(ii)||'&p_message_number=1',
1940:
1941:
1942: end loop;
1943:
1944: htp.tableclose;
1945:
1946: htp.br;
1947:
1948: wfa_sec.Footer;
1942: end loop;
1943:
1944: htp.tableclose;
1945:
1946: htp.br;
1947:
1948: wfa_sec.Footer;
1949: htp.htmlClose;
1950:
1945:
1946: htp.br;
1947:
1948: wfa_sec.Footer;
1949: htp.htmlClose;
1950:
1951: exception
1952: when others then
1953: wf_core.context('FND_DOCUMENT_MANAGEMENT', 'Generic_Queue_View_Detail');
2001:
2002: end if;
2003:
2004: -- Set page title
2005: htp.htmlOpen;
2006: htp.headOpen;
2007: htp.title(wf_core.translate('WFQUEUE_EDIT_QUEUE_TITLE'));
2008: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
2009:
2002: end if;
2003:
2004: -- Set page title
2005: htp.htmlOpen;
2006: htp.headOpen;
2007: htp.title(wf_core.translate('WFQUEUE_EDIT_QUEUE_TITLE'));
2008: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
2009:
2010: wf_lov.OpenLovWinHtml;
2003:
2004: -- Set page title
2005: htp.htmlOpen;
2006: htp.headOpen;
2007: htp.title(wf_core.translate('WFQUEUE_EDIT_QUEUE_TITLE'));
2008: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
2009:
2010: wf_lov.OpenLovWinHtml;
2011:
2008: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
2009:
2010: wf_lov.OpenLovWinHtml;
2011:
2012: htp.headClose;
2013:
2014: -- Page header
2015: wfa_sec.Header(FALSE, '', wf_core.translate('WFQUEUE_EDIT_QUEUE_TITLE'), TRUE);
2016:
2015: wfa_sec.Header(FALSE, '', wf_core.translate('WFQUEUE_EDIT_QUEUE_TITLE'), TRUE);
2016:
2017: IF (admin_mode = 'N') THEN
2018:
2019: htp.center(htf.bold(l_error_msg));
2020: return;
2021:
2022: END IF;
2023:
2020: return;
2021:
2022: END IF;
2023:
2024: htp.tableopen(calign=>'CENTER',cattributes=>'summary=""');
2025:
2026: htp.p('
2240: END IF;
2241:
2242: htp.tableopen(calign=>'CENTER',cattributes=>'summary="' || wf_core.translate('WFQUEUE_EDIT_QUEUE_TITLE') || '"');
2243:
2244: htp.p('
2246: -- Protocol Name
2247: htp.tableRowOpen;
2248: htp.tableData(cvalue=>'
2243:
2244: htp.p('
2244: htp.p('
2249: wf_core.translate('PROTOCOL') || '',
2250: calign=>'right',
2251: cattributes=>'id=""');
2252:
2253: htp.tableData(htf.formText(cname=>'p_protocol', csize=>'30',
2254: cvalue=>p_protocol, cmaxlength=>'30',
2255: cattributes=>'id="i_protocol"'),
2256: cattributes=>'id=""');
2257:
2254: cvalue=>p_protocol, cmaxlength=>'30',
2255: cattributes=>'id="i_protocol"'),
2256: cattributes=>'id=""');
2257:
2258: htp.tableRowClose;
2259:
2260: -- Inbound/outbound
2261: htp.tableRowOpen;
2262: htp.tableData(cvalue=>'
2257:
2258: htp.tableRowClose;
2259:
2260: -- Inbound/outbound
2261: htp.tableRowOpen;
2262: htp.tableData(cvalue=>'',
2264: calign=>'right',
2265: cattributes=>'id=""');
2258: htp.tableRowClose;
2259:
2260: -- Inbound/outbound
2261: htp.tableRowOpen;
2262: htp.tableData(cvalue=>'2263: wf_core.translate('INBOUND_OUTBOUND') || '',
2264: calign=>'right',
2265: cattributes=>'id=""');
2266:
2275: l_outbound_selected := 'Y';
2276:
2277: end if;
2278:
2279: htp.p('
2277: end if;
2278:
2279: htp.p('
2279: htp.p('
2283: htp.formSelectOption(cvalue=>wf_core.translate('INBOUND'),
2284: cattributes=>'value=INBOUND',
2285: cselected=>l_inbound_selected);
2286:
2287: htp.formSelectOption(cvalue=>wf_core.translate('OUTBOUND'),
2288: cattributes=>'value=OUTBOUND',
2289: cselected=>l_outbound_selected);
2290:
2291: htp.formSelectClose;
2287: htp.formSelectOption(cvalue=>wf_core.translate('OUTBOUND'),
2288: cattributes=>'value=OUTBOUND',
2289: cselected=>l_outbound_selected);
2290:
2291: htp.formSelectClose;
2292: htp.p('
2288: cattributes=>'value=OUTBOUND',
2289: cselected=>l_outbound_selected);
2290:
2291: htp.formSelectClose;
2292: htp.p('');
2293:
2294: htp.tableRowClose;
2295:
2296: -- Description
2290:
2291: htp.formSelectClose;
2292: htp.p('');
2293:
2294: htp.tableRowClose;
2295:
2296: -- Description
2297: htp.tableRowOpen;
2298: htp.tableData(cvalue=>'
2293:
2294: htp.tableRowClose;
2295:
2296: -- Description
2297: htp.tableRowOpen;
2298: htp.tableData(cvalue=>'
2294: htp.tableRowClose;
2295:
2296: -- Description
2297: htp.tableRowOpen;
2298: htp.tableData(cvalue=>'2299: wf_core.translate('DESCRIPTION') || '"',
2300: calign=>'right',
2301: cattributes=>'id=""');
2302:
2299: wf_core.translate('DESCRIPTION') || '"',
2300: calign=>'right',
2301: cattributes=>'id=""');
2302:
2303: htp.tableData(htf.formText(cname=>'p_description', csize=>'30',
2304: cvalue=>l_description, cmaxlength=>'240',
2305: cattributes=>'id="i_description"'),
2306: cattributes=>'id=""');
2307:
2304: cvalue=>l_description, cmaxlength=>'240',
2305: cattributes=>'id="i_description"'),
2306: cattributes=>'id=""');
2307:
2308: htp.tableRowClose;
2309:
2310: -- Count
2311: htp.tableRowOpen;
2312: htp.tableData(cvalue=>'
2307:
2308: htp.tableRowClose;
2309:
2310: -- Count
2311: htp.tableRowOpen;
2312: htp.tableData(cvalue=>'
2308: htp.tableRowClose;
2309:
2310: -- Count
2311: htp.tableRowOpen;
2312: htp.tableData(cvalue=>'2313: wf_core.translate('COUNT') || '"',
2314: calign=>'right',
2315: cattributes=>'id=""');
2316:
2313: wf_core.translate('COUNT') || '"',
2314: calign=>'right',
2315: cattributes=>'id=""');
2316:
2317: htp.tableData(htf.formText(cname=>'p_queue_count', csize=>'10',
2318: cvalue=>l_queue_count, cmaxlength=>'20',
2319: cattributes=>'id="i_count"'),
2320: cattributes=>'id=""');
2321:
2318: cvalue=>l_queue_count, cmaxlength=>'20',
2319: cattributes=>'id="i_count"'),
2320: cattributes=>'id=""');
2321:
2322: htp.tableRowClose;
2323:
2324: -- keep track of the original protocol and the inbound/outbound
2325: -- value in case the name changes
2326:
2323:
2324: -- keep track of the original protocol and the inbound/outbound
2325: -- value in case the name changes
2326:
2327: htp.formHidden(cname=>'p_original_protocol', cvalue=>p_protocol);
2328: htp.formHidden(cname=>'p_original_inbound', cvalue=>p_inbound_outbound);
2329:
2330: htp.tableclose;
2331:
2324: -- keep track of the original protocol and the inbound/outbound
2325: -- value in case the name changes
2326:
2327: htp.formHidden(cname=>'p_original_protocol', cvalue=>p_protocol);
2328: htp.formHidden(cname=>'p_original_inbound', cvalue=>p_inbound_outbound);
2329:
2330: htp.tableclose;
2331:
2332: htp.br;
2326:
2327: htp.formHidden(cname=>'p_original_protocol', cvalue=>p_protocol);
2328: htp.formHidden(cname=>'p_original_inbound', cvalue=>p_inbound_outbound);
2329:
2330: htp.tableclose;
2331:
2332: htp.br;
2333:
2334: htp.tableopen(calign=>'CENTER',cattributes=>'summary=""');
2328: htp.formHidden(cname=>'p_original_inbound', cvalue=>p_inbound_outbound);
2329:
2330: htp.tableclose;
2331:
2332: htp.br;
2333:
2334: htp.tableopen(calign=>'CENTER',cattributes=>'summary=""');
2335:
2336: --Submit Button
2330: htp.tableclose;
2331:
2332: htp.br;
2333:
2334: htp.tableopen(calign=>'CENTER',cattributes=>'summary=""');
2335:
2336: --Submit Button
2337:
2338: htp.tableRowOpen;
2334: htp.tableopen(calign=>'CENTER',cattributes=>'summary=""');
2335:
2336: --Submit Button
2337:
2338: htp.tableRowOpen;
2339:
2340: l_url := 'javascript:document.FND_GENERIC_QUEUE.submit()';
2341: l_icon := 'FNDJLFOK.gif';
2342: l_text := wf_core.translate ('WFMON_OK');
2341: l_icon := 'FNDJLFOK.gif';
2342: l_text := wf_core.translate ('WFMON_OK');
2343: l_onmouseover := wf_core.translate ('WFMON_OK');
2344:
2345: htp.p('
2345: htp.p('
2352: l_icon := 'FNDJLFCN.gif';
2353: l_text := wf_core.translate ('CANCEL');
2354: l_onmouseover := wf_core.translate ('CANCEL');
2355:
2356: htp.p('
2356: htp.p('
2358: wf_pref.create_reg_button (l_url, l_onmouseover, l_media, l_icon, l_text);
2359:
2360: htp.p('');
2361:
2362: htp.tableRowClose;
2363:
2364: htp.tableclose;
2365:
2366: htp.formClose;
2360: htp.p('');
2361:
2362: htp.tableRowClose;
2363:
2364: htp.tableclose;
2365:
2366: htp.formClose;
2367:
2368: wfa_sec.Footer;
2362: htp.tableRowClose;
2363:
2364: htp.tableclose;
2365:
2366: htp.formClose;
2367:
2368: wfa_sec.Footer;
2369: htp.htmlClose;
2370:
2365:
2366: htp.formClose;
2367:
2368: wfa_sec.Footer;
2369: htp.htmlClose;
2370:
2371:
2372: exception
2373: when others then
2513: end if;
2514:
2515: IF (admin_mode = 'N') THEN
2516:
2517: htp.center(htf.bold(l_error_msg));
2518: return;
2519:
2520: END IF;
2521:
2529: AND p_inbound_outbound = inbound_outbound;
2530:
2531: if (l_count > 0) then
2532:
2533: htp.p('');
2534: htp.center(htf.bold(wf_core.translate('WFQUEUE_ALREADY_EXISTS')));
2535: htp.br;
2536:
2537: htp.tableopen(calign=>'CENTER',cattributes=>'summary=""');
2530:
2531: if (l_count > 0) then
2532:
2533: htp.p('
2531: if (l_count > 0) then
2532:
2533: htp.p('
2533: htp.p('
');
2537: htp.tableopen(calign=>'CENTER',cattributes=>'summary=""');
2538:
2539: --Submit Button
2540:
2541: htp.tableRowOpen;
2542:
2543: l_url := wfa_html.base_url||
2544: '/wf_queue.generic_queue_edit';
2545: l_icon := 'FNDJLFOK.gif';
2545: l_icon := 'FNDJLFOK.gif';
2546: l_text := wf_core.translate ('WFMON_OK');
2547: l_onmouseover := wf_core.translate ('WFMON_OK');
2548:
2549: htp.p('
2549: htp.p('
2550:
2551: wf_pref.create_reg_button (l_url, l_onmouseover, l_media, l_icon, l_text);
2552:
2553: htp.p('');
2554: htp.tablerowclose;
2555: htp.tableclose;
2556: htp.p('');
2557: return;
2558:
2551: wf_pref.create_reg_button (l_url, l_onmouseover, l_media, l_icon, l_text);
2552:
2553: htp.p('');
2554: htp.tablerowclose;
2555: htp.tableclose;
2556: htp.p('');
2557: return;
2558:
2559: else
2552:
2553: htp.p('');
2554: htp.tablerowclose;
2555: htp.tableclose;
2556: htp.p('');
2557: return;
2558:
2559: else
2560: