1656:
1657: end if;
1658:
1659: -- Set page title
1660: htp.htmlOpen;
1661: htp.headOpen;
1662: htp.p('
1663: htp.title(wf_core.translate('WFGENERIC_QUEUE_TITLE'));
1664: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
1657: end if;
1658:
1659: -- Set page title
1660: htp.htmlOpen;
1661: htp.headOpen;
1662: htp.p('
1663: htp.title(wf_core.translate('WFGENERIC_QUEUE_TITLE'));
1664: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
1665: htp.headClose;
1658:
1659: -- Set page title
1660: htp.htmlOpen;
1661: htp.headOpen;
1662: htp.p('
1663: htp.title(wf_core.translate('WFGENERIC_QUEUE_TITLE'));
1664: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
1665: htp.headClose;
1666: wfa_sec.Header(FALSE, '',wf_core.translate('WFGENERIC_QUEUE_TITLE'), FALSE);
1659: -- Set page title
1660: htp.htmlOpen;
1661: htp.headOpen;
1662: htp.p('
1663: htp.title(wf_core.translate('WFGENERIC_QUEUE_TITLE'));
1664: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
1665: htp.headClose;
1666: wfa_sec.Header(FALSE, '',wf_core.translate('WFGENERIC_QUEUE_TITLE'), FALSE);
1667: htp.br;
1661: htp.headOpen;
1662: htp.p('
1663: htp.title(wf_core.translate('WFGENERIC_QUEUE_TITLE'));
1664: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
1665: htp.headClose;
1666: wfa_sec.Header(FALSE, '',wf_core.translate('WFGENERIC_QUEUE_TITLE'), FALSE);
1667: htp.br;
1668:
1669: IF (admin_mode = 'N') THEN
1663: htp.title(wf_core.translate('WFGENERIC_QUEUE_TITLE'));
1664: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
1665: htp.headClose;
1666: wfa_sec.Header(FALSE, '',wf_core.translate('WFGENERIC_QUEUE_TITLE'), FALSE);
1667: htp.br;
1668:
1669: IF (admin_mode = 'N') THEN
1670:
1671: htp.center(htf.bold(l_error_msg));
1667: htp.br;
1668:
1669: IF (admin_mode = 'N') THEN
1670:
1671: htp.center(htf.bold(l_error_msg));
1672: return;
1673:
1674: END IF;
1675:
1673:
1674: END IF;
1675:
1676: -- Column headers
1677: htp.tableOpen(cattributes=>'border=1 cellpadding=3 bgcolor=white width="100%" summary=""');
1678: htp.tableRowOpen(cattributes=>'bgcolor=#006699');
1679:
1680:
1681: htp.tableHeader(cvalue=>''||
1674: END IF;
1675:
1676: -- Column headers
1677: htp.tableOpen(cattributes=>'border=1 cellpadding=3 bgcolor=white width="100%" summary=""');
1678: htp.tableRowOpen(cattributes=>'bgcolor=#006699');
1679:
1680:
1681: htp.tableHeader(cvalue=>''||
1682: wf_core.translate('PROTOCOL')||'',
1677: htp.tableOpen(cattributes=>'border=1 cellpadding=3 bgcolor=white width="100%" summary=""');
1678: htp.tableRowOpen(cattributes=>'bgcolor=#006699');
1679:
1680:
1681: htp.tableHeader(cvalue=>''||
1682: wf_core.translate('PROTOCOL')||'',
1683: calign=>'Center',
1684: cattributes=>'id="' || wf_core.translate('PROTOCOL') || '"');
1685: htp.tableHeader(cvalue=>''||
1681: htp.tableHeader(cvalue=>''||
1682: wf_core.translate('PROTOCOL')||'',
1683: calign=>'Center',
1684: cattributes=>'id="' || wf_core.translate('PROTOCOL') || '"');
1685: htp.tableHeader(cvalue=>''||
1686: wf_core.translate('QUEUE_DESCRIPTION')||'',
1687: calign=>'Center',
1688: cattributes=>'id="' || wf_core.translate('QUEUE_DESCRIPTION') || '"');
1689: htp.tableHeader(cvalue=>''||
1685: htp.tableHeader(cvalue=>''||
1686: wf_core.translate('QUEUE_DESCRIPTION')||'',
1687: calign=>'Center',
1688: cattributes=>'id="' || wf_core.translate('QUEUE_DESCRIPTION') || '"');
1689: htp.tableHeader(cvalue=>''||
1690: wf_core.translate('INBOUND_PROMPT')||'',
1691: calign=>'Center',
1692: cattributes=>'id="' || wf_core.translate('INBOUND_PROMPT') || '"');
1693: htp.tableHeader(cvalue=>''||
1689: htp.tableHeader(cvalue=>''||
1690: wf_core.translate('INBOUND_PROMPT')||'',
1691: calign=>'Center',
1692: cattributes=>'id="' || wf_core.translate('INBOUND_PROMPT') || '"');
1693: htp.tableHeader(cvalue=>''||
1694: wf_core.translate('QUEUE_COUNT')||'',
1695: calign=>'Center',
1696: cattributes=>'id="' || wf_core.translate('QUEUE_COUNT') || '"');
1697: htp.tableHeader(cvalue=>''||
1693: htp.tableHeader(cvalue=>''||
1694: wf_core.translate('QUEUE_COUNT')||'',
1695: calign=>'Center',
1696: cattributes=>'id="' || wf_core.translate('QUEUE_COUNT') || '"');
1697: htp.tableHeader(cvalue=>''||
1698: wf_core.translate('VIEW_DETAIL')||'',
1699: calign=>'Center',
1700: cattributes=>'id="' || wf_core.translate('VIEW_DETAIL') || '"');
1701: htp.tableHeader(cvalue=>''||
1697: htp.tableHeader(cvalue=>''||
1698: wf_core.translate('VIEW_DETAIL')||'',
1699: calign=>'Center',
1700: cattributes=>'id="' || wf_core.translate('VIEW_DETAIL') || '"');
1701: htp.tableHeader(cvalue=>''||
1702: wf_core.translate('DELETE')||'',
1703: calign=>'Center',
1704: cattributes=>'id="' || wf_core.translate('DELETE') || '"');
1705:
1702: wf_core.translate('DELETE')||'',
1703: calign=>'Center',
1704: cattributes=>'id="' || wf_core.translate('DELETE') || '"');
1705:
1706: htp.tableRowClose;
1707: htp.tableRowOpen;
1708: htp.tableRowClose;
1709:
1710: -- Show all nodes
1703: calign=>'Center',
1704: cattributes=>'id="' || wf_core.translate('DELETE') || '"');
1705:
1706: htp.tableRowClose;
1707: htp.tableRowOpen;
1708: htp.tableRowClose;
1709:
1710: -- Show all nodes
1711: for queues in queues_cursor loop
1704: cattributes=>'id="' || wf_core.translate('DELETE') || '"');
1705:
1706: htp.tableRowClose;
1707: htp.tableRowOpen;
1708: htp.tableRowClose;
1709:
1710: -- Show all nodes
1711: for queues in queues_cursor loop
1712:
1709:
1710: -- Show all nodes
1711: for queues in queues_cursor loop
1712:
1713: htp.tableRowOpen(null, 'TOP');
1714:
1715:
1716: htp.tableData(htf.anchor2(
1717: curl=>wfa_html.base_url||
1712:
1713: htp.tableRowOpen(null, 'TOP');
1714:
1715:
1716: htp.tableData(htf.anchor2(
1717: curl=>wfa_html.base_url||
1718: '/wf_queue.generic_queue_edit?p_protocol='||
1719: queues.protocol||'&p_inbound_outbound='||
1720: queues.inbound_outbound,
1722: 'Left',
1723: cattributes=>'headers="' ||
1724: wf_core.translate('PROTOCOL') || '"');
1725:
1726: htp.tableData(queues.description, 'left',
1727: cattributes=>'headers="' || wf_core.translate('QUEUE_DESCRIPTION') || '"');
1728:
1729: htp.tableData(queues.inbound_outbound, 'left',
1730: cattributes=>'headers="' || wf_core.translate('INBOUND_PROMPT') || '"');
1725:
1726: htp.tableData(queues.description, 'left',
1727: cattributes=>'headers="' || wf_core.translate('QUEUE_DESCRIPTION') || '"');
1728:
1729: htp.tableData(queues.inbound_outbound, 'left',
1730: cattributes=>'headers="' || wf_core.translate('INBOUND_PROMPT') || '"');
1731:
1732: htp.tableData(queues.queue_count, 'left',
1733: cattributes=>'headers="' || wf_core.translate('QUEUE_COUNT') || '"');
1728:
1729: htp.tableData(queues.inbound_outbound, 'left',
1730: cattributes=>'headers="' || wf_core.translate('INBOUND_PROMPT') || '"');
1731:
1732: htp.tableData(queues.queue_count, 'left',
1733: cattributes=>'headers="' || wf_core.translate('QUEUE_COUNT') || '"');
1734:
1735: htp.tableData(htf.anchor2(curl=>wfa_html.base_url||
1736: '/wf_queue.Generic_Queue_View_Detail?p_protocol='||
1731:
1732: htp.tableData(queues.queue_count, 'left',
1733: cattributes=>'headers="' || wf_core.translate('QUEUE_COUNT') || '"');
1734:
1735: htp.tableData(htf.anchor2(curl=>wfa_html.base_url||
1736: '/wf_queue.Generic_Queue_View_Detail?p_protocol='||
1737: queues.protocol||'&p_inbound_outbound='||
1738: queues.inbound_outbound,
1739: ctext=>''),
1739: ctext=>''),
1740: 'center', cattributes=>'valign="MIDDLE"
1741: headers="' || wf_core.translate('VIEW_DETAIL') || '"');
1742:
1743: htp.tableData(htf.anchor2(curl=>wfa_html.base_url||
1744: '/wf_queue.generic_queue_confirm_delete?p_protocol='||
1745: queues.protocol||'&p_inbound_outbound='||
1746: queues.inbound_outbound,
1747: ctext=>''),
1750:
1751:
1752: end loop;
1753:
1754: htp.tableclose;
1755:
1756: htp.br;
1757:
1758: htp.tableopen(calign=>'CENTER',cattributes=>'summary=""');
1752: end loop;
1753:
1754: htp.tableclose;
1755:
1756: htp.br;
1757:
1758: htp.tableopen(calign=>'CENTER',cattributes=>'summary=""');
1759:
1760: --Add new node Button
1754: htp.tableclose;
1755:
1756: htp.br;
1757:
1758: htp.tableopen(calign=>'CENTER',cattributes=>'summary=""');
1759:
1760: --Add new node Button
1761: htp.tableRowOpen;
1762:
1757:
1758: htp.tableopen(calign=>'CENTER',cattributes=>'summary=""');
1759:
1760: --Add new node Button
1761: htp.tableRowOpen;
1762:
1763: l_url := wfa_html.base_url||'/wf_queue.generic_queue_edit';
1764: l_icon := 'FNDJLFOK.gif';
1765: l_text := wf_core.translate ('WFQUEUE_CREATE');
1764: l_icon := 'FNDJLFOK.gif';
1765: l_text := wf_core.translate ('WFQUEUE_CREATE');
1766: l_onmouseover := wf_core.translate ('WFQUEUE_CREATE');
1767:
1768: htp.p('
1768: htp.p('
1770: wf_pref.create_reg_button (l_url, l_onmouseover, l_media, l_icon, l_text);
1771:
1772: htp.p('');
1773:
1774: htp.tableRowClose;
1775:
1776: htp.tableclose;
1777:
1778: wfa_sec.Footer;
1772: htp.p('');
1773:
1774: htp.tableRowClose;
1775:
1776: htp.tableclose;
1777:
1778: wfa_sec.Footer;
1779: htp.htmlClose;
1780:
1775:
1776: htp.tableclose;
1777:
1778: wfa_sec.Footer;
1779: htp.htmlClose;
1780:
1781: exception
1782: when others then
1783: wf_core.context('FND_DOCUMENT_MANAGEMENT', 'Generic_Queue_Display');
1827:
1828: end if;
1829:
1830: -- Set page title
1831: htp.htmlOpen;
1832: htp.headOpen;
1833: htp.p('
1834: htp.title(wf_core.translate('WFGENERIC_QUEUE_TITLE'));
1835: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
1828: end if;
1829:
1830: -- Set page title
1831: htp.htmlOpen;
1832: htp.headOpen;
1833: htp.p('
1834: htp.title(wf_core.translate('WFGENERIC_QUEUE_TITLE'));
1835: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
1836: htp.headClose;
1829:
1830: -- Set page title
1831: htp.htmlOpen;
1832: htp.headOpen;
1833: htp.p('
1834: htp.title(wf_core.translate('WFGENERIC_QUEUE_TITLE'));
1835: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
1836: htp.headClose;
1837: wfa_sec.Header(FALSE, '',wf_core.translate('WFGENERIC_QUEUE_TITLE'), FALSE);
1830: -- Set page title
1831: htp.htmlOpen;
1832: htp.headOpen;
1833: htp.p('
1834: htp.title(wf_core.translate('WFGENERIC_QUEUE_TITLE'));
1835: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
1836: htp.headClose;
1837: wfa_sec.Header(FALSE, '',wf_core.translate('WFGENERIC_QUEUE_TITLE'), FALSE);
1838: htp.br;
1832: htp.headOpen;
1833: htp.p('
1834: htp.title(wf_core.translate('WFGENERIC_QUEUE_TITLE'));
1835: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
1836: htp.headClose;
1837: wfa_sec.Header(FALSE, '',wf_core.translate('WFGENERIC_QUEUE_TITLE'), FALSE);
1838: htp.br;
1839:
1840: IF (admin_mode = 'N') THEN
1834: htp.title(wf_core.translate('WFGENERIC_QUEUE_TITLE'));
1835: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
1836: htp.headClose;
1837: wfa_sec.Header(FALSE, '',wf_core.translate('WFGENERIC_QUEUE_TITLE'), FALSE);
1838: htp.br;
1839:
1840: IF (admin_mode = 'N') THEN
1841:
1842: htp.center(htf.bold(l_error_msg));
1838: htp.br;
1839:
1840: IF (admin_mode = 'N') THEN
1841:
1842: htp.center(htf.bold(l_error_msg));
1843: return;
1844:
1845: END IF;
1846:
1850: WHERE UPPER(p_protocol) = protocol
1851: AND p_inbound_outbound = inbound_outbound;
1852:
1853: -- Column headers
1854: htp.tableOpen(cattributes=>'border=1 cellpadding=3 bgcolor=white width="100%" summary=""');
1855: htp.tableRowOpen(cattributes=>'bgcolor=#006699');
1856:
1857: htp.tableHeader(cvalue=>''||
1858: wf_core.translate('PROTOCOL')||'',
1851: AND p_inbound_outbound = inbound_outbound;
1852:
1853: -- Column headers
1854: htp.tableOpen(cattributes=>'border=1 cellpadding=3 bgcolor=white width="100%" summary=""');
1855: htp.tableRowOpen(cattributes=>'bgcolor=#006699');
1856:
1857: htp.tableHeader(cvalue=>''||
1858: wf_core.translate('PROTOCOL')||'',
1859: calign=>'Center',
1853: -- Column headers
1854: htp.tableOpen(cattributes=>'border=1 cellpadding=3 bgcolor=white width="100%" summary=""');
1855: htp.tableRowOpen(cattributes=>'bgcolor=#006699');
1856:
1857: htp.tableHeader(cvalue=>''||
1858: wf_core.translate('PROTOCOL')||'',
1859: calign=>'Center',
1860: cattributes=>'id="' ||
1861: wf_core.translate('PROTOCOL') || '"');
1858: wf_core.translate('PROTOCOL')||'',
1859: calign=>'Center',
1860: cattributes=>'id="' ||
1861: wf_core.translate('PROTOCOL') || '"');
1862: htp.tableHeader(cvalue=>''||
1863: wf_core.translate('QUEUE_NUMBER')||'',
1864: calign=>'Center',
1865: cattributes=>'id="' ||
1866: wf_core.translate('QUEUE_NUMBER') || '"');
1863: wf_core.translate('QUEUE_NUMBER')||'',
1864: calign=>'Center',
1865: cattributes=>'id="' ||
1866: wf_core.translate('QUEUE_NUMBER') || '"');
1867: htp.tableHeader(cvalue=>''||
1868: wf_core.translate('QUEUE_NAME')||'',
1869: calign=>'Center',
1870: cattributes=>'id="' ||
1871: wf_core.translate('QUEUE_NAME') || '"');
1868: wf_core.translate('QUEUE_NAME')||'',
1869: calign=>'Center',
1870: cattributes=>'id="' ||
1871: wf_core.translate('QUEUE_NAME') || '"');
1872: htp.tableHeader(cvalue=>''||
1873: wf_core.translate('QUEUE_COUNT')||'',
1874: calign=>'Center',
1875: cattributes=>'id="' ||
1876: wf_core.translate('QUEUE_COUNT') || '"');
1873: wf_core.translate('QUEUE_COUNT')||'',
1874: calign=>'Center',
1875: cattributes=>'id="' ||
1876: wf_core.translate('QUEUE_COUNT') || '"');
1877: htp.tableHeader(cvalue=>''||
1878: wf_core.translate('VIEW_DETAIL')||'',
1879: calign=>'Center',
1880: cattributes=>'id="' ||
1881: wf_core.translate('VIEW_DETAIL') || '"');
1879: calign=>'Center',
1880: cattributes=>'id="' ||
1881: wf_core.translate('VIEW_DETAIL') || '"');
1882:
1883: htp.tableRowClose;
1884: htp.tableRowOpen;
1885: htp.tableRowClose;
1886:
1887: -- Show all queues for the given protocol
1880: cattributes=>'id="' ||
1881: wf_core.translate('VIEW_DETAIL') || '"');
1882:
1883: htp.tableRowClose;
1884: htp.tableRowOpen;
1885: htp.tableRowClose;
1886:
1887: -- Show all queues for the given protocol
1888: for ii in 1..l_count loop
1881: wf_core.translate('VIEW_DETAIL') || '"');
1882:
1883: htp.tableRowClose;
1884: htp.tableRowOpen;
1885: htp.tableRowClose;
1886:
1887: -- Show all queues for the given protocol
1888: for ii in 1..l_count loop
1889:
1886:
1887: -- Show all queues for the given protocol
1888: for ii in 1..l_count loop
1889:
1890: htp.tableRowOpen(null, 'TOP');
1891:
1892: htp.tableData(p_protocol, 'left', cattributes=>'headers="' ||
1893: wf_core.translate('PROTOCOL') || '"');
1894:
1888: for ii in 1..l_count loop
1889:
1890: htp.tableRowOpen(null, 'TOP');
1891:
1892: htp.tableData(p_protocol, 'left', cattributes=>'headers="' ||
1893: wf_core.translate('PROTOCOL') || '"');
1894:
1895: htp.tableData(to_char(ii), 'left', cattributes=>'headers="' ||
1896: wf_core.translate('QUEUE_NUMBER') || '"');
1891:
1892: htp.tableData(p_protocol, 'left', cattributes=>'headers="' ||
1893: wf_core.translate('PROTOCOL') || '"');
1894:
1895: htp.tableData(to_char(ii), 'left', cattributes=>'headers="' ||
1896: wf_core.translate('QUEUE_NUMBER') || '"');
1897:
1898: -- p_protocol and p_inbound_outbound were verified above
1899: -- ii must be a number
1897:
1898: -- p_protocol and p_inbound_outbound were verified above
1899: -- ii must be a number
1900: -- BINDVAR_SCAN_IGNORE
1901: 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') || '"');
1902:
1903: /*
1904: ** Check to see if there are any messages in the specified queue
1905: */
1906: l_sql := 'SELECT COUNT(1) FROM WF_'||p_protocol||'_'||substr(p_inbound_outbound, 1, 1)||'_'||to_char(ii)||'_TABLE';
1907:
1908: execute immediate l_sql INTO l_count;
1909:
1910: htp.tableData(to_char(l_count), 'left', cattributes=>'headers="' ||
1911: wf_core.translate('QUEUE_COUNT') || '"');
1912:
1913: htp.tableData(htf.anchor2(curl=>wfa_html.base_url||
1914: '/wf_queue.generic_queue_display_contents?p_protocol='||
1909:
1910: htp.tableData(to_char(l_count), 'left', cattributes=>'headers="' ||
1911: wf_core.translate('QUEUE_COUNT') || '"');
1912:
1913: htp.tableData(htf.anchor2(curl=>wfa_html.base_url||
1914: '/wf_queue.generic_queue_display_contents?p_protocol='||
1915: p_protocol||'&p_inbound_outbound='||
1916: p_inbound_outbound||'&p_queue_number='||
1917: to_char(ii)||'&p_message_number=1',
1920:
1921:
1922: end loop;
1923:
1924: htp.tableclose;
1925:
1926: htp.br;
1927:
1928: wfa_sec.Footer;
1922: end loop;
1923:
1924: htp.tableclose;
1925:
1926: htp.br;
1927:
1928: wfa_sec.Footer;
1929: htp.htmlClose;
1930:
1925:
1926: htp.br;
1927:
1928: wfa_sec.Footer;
1929: htp.htmlClose;
1930:
1931: exception
1932: when others then
1933: wf_core.context('FND_DOCUMENT_MANAGEMENT', 'Generic_Queue_View_Detail');
1981:
1982: end if;
1983:
1984: -- Set page title
1985: htp.htmlOpen;
1986: htp.headOpen;
1987: htp.title(wf_core.translate('WFQUEUE_EDIT_QUEUE_TITLE'));
1988: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
1989:
1982: end if;
1983:
1984: -- Set page title
1985: htp.htmlOpen;
1986: htp.headOpen;
1987: htp.title(wf_core.translate('WFQUEUE_EDIT_QUEUE_TITLE'));
1988: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
1989:
1990: wf_lov.OpenLovWinHtml;
1983:
1984: -- Set page title
1985: htp.htmlOpen;
1986: htp.headOpen;
1987: htp.title(wf_core.translate('WFQUEUE_EDIT_QUEUE_TITLE'));
1988: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
1989:
1990: wf_lov.OpenLovWinHtml;
1991:
1988: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
1989:
1990: wf_lov.OpenLovWinHtml;
1991:
1992: htp.headClose;
1993:
1994: -- Page header
1995: wfa_sec.Header(FALSE, '', wf_core.translate('WFQUEUE_EDIT_QUEUE_TITLE'), TRUE);
1996:
1995: wfa_sec.Header(FALSE, '', wf_core.translate('WFQUEUE_EDIT_QUEUE_TITLE'), TRUE);
1996:
1997: IF (admin_mode = 'N') THEN
1998:
1999: htp.center(htf.bold(l_error_msg));
2000: return;
2001:
2002: END IF;
2003:
2000: return;
2001:
2002: END IF;
2003:
2004: htp.tableopen(calign=>'CENTER',cattributes=>'summary=""');
2005:
2006: htp.p('
2220: END IF;
2221:
2222: htp.tableopen(calign=>'CENTER',cattributes=>'summary="' || wf_core.translate('WFQUEUE_EDIT_QUEUE_TITLE') || '"');
2223:
2224: htp.p('
2226: -- Protocol Name
2227: htp.tableRowOpen;
2228: htp.tableData(cvalue=>'
2223:
2224: htp.p('
2224: htp.p('
2229: wf_core.translate('PROTOCOL') || '',
2230: calign=>'right',
2231: cattributes=>'id=""');
2232:
2233: htp.tableData(htf.formText(cname=>'p_protocol', csize=>'30',
2234: cvalue=>p_protocol, cmaxlength=>'30',
2235: cattributes=>'id="i_protocol"'),
2236: cattributes=>'id=""');
2237:
2234: cvalue=>p_protocol, cmaxlength=>'30',
2235: cattributes=>'id="i_protocol"'),
2236: cattributes=>'id=""');
2237:
2238: htp.tableRowClose;
2239:
2240: -- Inbound/outbound
2241: htp.tableRowOpen;
2242: htp.tableData(cvalue=>'
2237:
2238: htp.tableRowClose;
2239:
2240: -- Inbound/outbound
2241: htp.tableRowOpen;
2242: htp.tableData(cvalue=>'',
2244: calign=>'right',
2245: cattributes=>'id=""');
2238: htp.tableRowClose;
2239:
2240: -- Inbound/outbound
2241: htp.tableRowOpen;
2242: htp.tableData(cvalue=>'2243: wf_core.translate('INBOUND_OUTBOUND') || '',
2244: calign=>'right',
2245: cattributes=>'id=""');
2246:
2255: l_outbound_selected := 'Y';
2256:
2257: end if;
2258:
2259: htp.p('
2257: end if;
2258:
2259: htp.p('
2259: htp.p('
2263: htp.formSelectOption(cvalue=>wf_core.translate('INBOUND'),
2264: cattributes=>'value=INBOUND',
2265: cselected=>l_inbound_selected);
2266:
2267: htp.formSelectOption(cvalue=>wf_core.translate('OUTBOUND'),
2268: cattributes=>'value=OUTBOUND',
2269: cselected=>l_outbound_selected);
2270:
2271: htp.formSelectClose;
2267: htp.formSelectOption(cvalue=>wf_core.translate('OUTBOUND'),
2268: cattributes=>'value=OUTBOUND',
2269: cselected=>l_outbound_selected);
2270:
2271: htp.formSelectClose;
2272: htp.p('
2268: cattributes=>'value=OUTBOUND',
2269: cselected=>l_outbound_selected);
2270:
2271: htp.formSelectClose;
2272: htp.p('');
2273:
2274: htp.tableRowClose;
2275:
2276: -- Description
2270:
2271: htp.formSelectClose;
2272: htp.p('');
2273:
2274: htp.tableRowClose;
2275:
2276: -- Description
2277: htp.tableRowOpen;
2278: htp.tableData(cvalue=>'
2273:
2274: htp.tableRowClose;
2275:
2276: -- Description
2277: htp.tableRowOpen;
2278: htp.tableData(cvalue=>'
2274: htp.tableRowClose;
2275:
2276: -- Description
2277: htp.tableRowOpen;
2278: htp.tableData(cvalue=>'2279: wf_core.translate('DESCRIPTION') || '"',
2280: calign=>'right',
2281: cattributes=>'id=""');
2282:
2279: wf_core.translate('DESCRIPTION') || '"',
2280: calign=>'right',
2281: cattributes=>'id=""');
2282:
2283: htp.tableData(htf.formText(cname=>'p_description', csize=>'30',
2284: cvalue=>l_description, cmaxlength=>'240',
2285: cattributes=>'id="i_description"'),
2286: cattributes=>'id=""');
2287:
2284: cvalue=>l_description, cmaxlength=>'240',
2285: cattributes=>'id="i_description"'),
2286: cattributes=>'id=""');
2287:
2288: htp.tableRowClose;
2289:
2290: -- Count
2291: htp.tableRowOpen;
2292: htp.tableData(cvalue=>'
2287:
2288: htp.tableRowClose;
2289:
2290: -- Count
2291: htp.tableRowOpen;
2292: htp.tableData(cvalue=>'
2288: htp.tableRowClose;
2289:
2290: -- Count
2291: htp.tableRowOpen;
2292: htp.tableData(cvalue=>'2293: wf_core.translate('COUNT') || '"',
2294: calign=>'right',
2295: cattributes=>'id=""');
2296:
2293: wf_core.translate('COUNT') || '"',
2294: calign=>'right',
2295: cattributes=>'id=""');
2296:
2297: htp.tableData(htf.formText(cname=>'p_queue_count', csize=>'10',
2298: cvalue=>l_queue_count, cmaxlength=>'20',
2299: cattributes=>'id="i_count"'),
2300: cattributes=>'id=""');
2301:
2298: cvalue=>l_queue_count, cmaxlength=>'20',
2299: cattributes=>'id="i_count"'),
2300: cattributes=>'id=""');
2301:
2302: htp.tableRowClose;
2303:
2304: -- keep track of the original protocol and the inbound/outbound
2305: -- value in case the name changes
2306:
2303:
2304: -- keep track of the original protocol and the inbound/outbound
2305: -- value in case the name changes
2306:
2307: htp.formHidden(cname=>'p_original_protocol', cvalue=>p_protocol);
2308: htp.formHidden(cname=>'p_original_inbound', cvalue=>p_inbound_outbound);
2309:
2310: htp.tableclose;
2311:
2304: -- keep track of the original protocol and the inbound/outbound
2305: -- value in case the name changes
2306:
2307: htp.formHidden(cname=>'p_original_protocol', cvalue=>p_protocol);
2308: htp.formHidden(cname=>'p_original_inbound', cvalue=>p_inbound_outbound);
2309:
2310: htp.tableclose;
2311:
2312: htp.br;
2306:
2307: htp.formHidden(cname=>'p_original_protocol', cvalue=>p_protocol);
2308: htp.formHidden(cname=>'p_original_inbound', cvalue=>p_inbound_outbound);
2309:
2310: htp.tableclose;
2311:
2312: htp.br;
2313:
2314: htp.tableopen(calign=>'CENTER',cattributes=>'summary=""');
2308: htp.formHidden(cname=>'p_original_inbound', cvalue=>p_inbound_outbound);
2309:
2310: htp.tableclose;
2311:
2312: htp.br;
2313:
2314: htp.tableopen(calign=>'CENTER',cattributes=>'summary=""');
2315:
2316: --Submit Button
2310: htp.tableclose;
2311:
2312: htp.br;
2313:
2314: htp.tableopen(calign=>'CENTER',cattributes=>'summary=""');
2315:
2316: --Submit Button
2317:
2318: htp.tableRowOpen;
2314: htp.tableopen(calign=>'CENTER',cattributes=>'summary=""');
2315:
2316: --Submit Button
2317:
2318: htp.tableRowOpen;
2319:
2320: l_url := 'javascript:document.FND_GENERIC_QUEUE.submit()';
2321: l_icon := 'FNDJLFOK.gif';
2322: l_text := wf_core.translate ('WFMON_OK');
2321: l_icon := 'FNDJLFOK.gif';
2322: l_text := wf_core.translate ('WFMON_OK');
2323: l_onmouseover := wf_core.translate ('WFMON_OK');
2324:
2325: htp.p('
2325: htp.p('
2332: l_icon := 'FNDJLFCN.gif';
2333: l_text := wf_core.translate ('CANCEL');
2334: l_onmouseover := wf_core.translate ('CANCEL');
2335:
2336: htp.p('
2336: htp.p('
2338: wf_pref.create_reg_button (l_url, l_onmouseover, l_media, l_icon, l_text);
2339:
2340: htp.p('');
2341:
2342: htp.tableRowClose;
2343:
2344: htp.tableclose;
2345:
2346: htp.formClose;
2340: htp.p('');
2341:
2342: htp.tableRowClose;
2343:
2344: htp.tableclose;
2345:
2346: htp.formClose;
2347:
2348: wfa_sec.Footer;
2342: htp.tableRowClose;
2343:
2344: htp.tableclose;
2345:
2346: htp.formClose;
2347:
2348: wfa_sec.Footer;
2349: htp.htmlClose;
2350:
2345:
2346: htp.formClose;
2347:
2348: wfa_sec.Footer;
2349: htp.htmlClose;
2350:
2351:
2352: exception
2353: when others then
2493: end if;
2494:
2495: IF (admin_mode = 'N') THEN
2496:
2497: htp.center(htf.bold(l_error_msg));
2498: return;
2499:
2500: END IF;
2501:
2509: AND p_inbound_outbound = inbound_outbound;
2510:
2511: if (l_count > 0) then
2512:
2513: htp.p('');
2514: htp.center(htf.bold(wf_core.translate('WFQUEUE_ALREADY_EXISTS')));
2515: htp.br;
2516:
2517: htp.tableopen(calign=>'CENTER',cattributes=>'summary=""');
2510:
2511: if (l_count > 0) then
2512:
2513: htp.p('
2511: if (l_count > 0) then
2512:
2513: htp.p('
2513: htp.p('
');
2517: htp.tableopen(calign=>'CENTER',cattributes=>'summary=""');
2518:
2519: --Submit Button
2520:
2521: htp.tableRowOpen;
2522:
2523: l_url := wfa_html.base_url||
2524: '/wf_queue.generic_queue_edit';
2525: l_icon := 'FNDJLFOK.gif';
2525: l_icon := 'FNDJLFOK.gif';
2526: l_text := wf_core.translate ('WFMON_OK');
2527: l_onmouseover := wf_core.translate ('WFMON_OK');
2528:
2529: htp.p('
2529: htp.p('
2530:
2531: wf_pref.create_reg_button (l_url, l_onmouseover, l_media, l_icon, l_text);
2532:
2533: htp.p('');
2534: htp.tablerowclose;
2535: htp.tableclose;
2536: htp.p('');
2537: return;
2538:
2531: wf_pref.create_reg_button (l_url, l_onmouseover, l_media, l_icon, l_text);
2532:
2533: htp.p('');
2534: htp.tablerowclose;
2535: htp.tableclose;
2536: htp.p('');
2537: return;
2538:
2539: else
2532:
2533: htp.p('');
2534: htp.tablerowclose;
2535: htp.tableclose;
2536: htp.p('');
2537: return;
2538:
2539: else
2540: