eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_UTILITIES_PKG dependencies on DBMS_XMLQUERY

Line 1532: ctx DBMS_XMLQUERY.ctxType;

1528: l_drvdlocal in varchar2 default null,
1529: l_locid in varchar2 default null) return clob is
1530:
1531: query varchar2(32000);
1532: ctx DBMS_XMLQUERY.ctxType;
1533: xml clob;
1534: bindNum number:=1;
1535: type bindlist is table of varchar2(4000) index by binary_integer;
1536: bindvalues bindlist;

Line 1773: ctx:= dbms_xmlquery.newContext(query);

1769: query:='SELECT fnd_message.get_string(''PER'',''IRC_412597_RSS_CRITERIA_ERROR'') title ,
1770: fnd_message.get_string(''PER'',''IRC_412011_BAD_LOCATION'') description ,
1771: to_char(trunc(sysdate),''Dy, DD Mon YYYY'') pubDate,
1772: ''/OA_HTML/IrcVisitor.jsp'' rlink from dual';
1773: ctx:= dbms_xmlquery.newContext(query);
1774: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);
1775: dbms_xmlquery.setEncodingTag(ctx,'UTF8');
1776: xml:=dbms_xmlquery.getXML(ctx);
1777: return (xml);

Line 1774: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);

1770: fnd_message.get_string(''PER'',''IRC_412011_BAD_LOCATION'') description ,
1771: to_char(trunc(sysdate),''Dy, DD Mon YYYY'') pubDate,
1772: ''/OA_HTML/IrcVisitor.jsp'' rlink from dual';
1773: ctx:= dbms_xmlquery.newContext(query);
1774: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);
1775: dbms_xmlquery.setEncodingTag(ctx,'UTF8');
1776: xml:=dbms_xmlquery.getXML(ctx);
1777: return (xml);
1778:

Line 1775: dbms_xmlquery.setEncodingTag(ctx,'UTF8');

1771: to_char(trunc(sysdate),''Dy, DD Mon YYYY'') pubDate,
1772: ''/OA_HTML/IrcVisitor.jsp'' rlink from dual';
1773: ctx:= dbms_xmlquery.newContext(query);
1774: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);
1775: dbms_xmlquery.setEncodingTag(ctx,'UTF8');
1776: xml:=dbms_xmlquery.getXML(ctx);
1777: return (xml);
1778:
1779: elsif (l_location is not null and l_lat is not null and l_long is not null and l_distance is null) then

Line 1776: xml:=dbms_xmlquery.getXML(ctx);

1772: ''/OA_HTML/IrcVisitor.jsp'' rlink from dual';
1773: ctx:= dbms_xmlquery.newContext(query);
1774: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);
1775: dbms_xmlquery.setEncodingTag(ctx,'UTF8');
1776: xml:=dbms_xmlquery.getXML(ctx);
1777: return (xml);
1778:
1779: elsif (l_location is not null and l_lat is not null and l_long is not null and l_distance is null) then
1780: query:='SELECT fnd_message.get_string(''PER'',''IRC_412597_RSS_CRITERIA_ERROR'') title ,

Line 1784: ctx:= dbms_xmlquery.newContext(query);

1780: query:='SELECT fnd_message.get_string(''PER'',''IRC_412597_RSS_CRITERIA_ERROR'') title ,
1781: fnd_message.get_string(''PER'',''IRC_412164_NO_DISTANCE'') description ,
1782: to_char(trunc(sysdate),''Dy, DD Mon YYYY'') pubDate,
1783: ''/OA_HTML/IrcVisitor.jsp'' rlink from dual';
1784: ctx:= dbms_xmlquery.newContext(query);
1785: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);
1786: dbms_xmlquery.setEncodingTag(ctx,'UTF8');
1787: xml:=dbms_xmlquery.getXML(ctx);
1788: return (xml);

Line 1785: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);

1781: fnd_message.get_string(''PER'',''IRC_412164_NO_DISTANCE'') description ,
1782: to_char(trunc(sysdate),''Dy, DD Mon YYYY'') pubDate,
1783: ''/OA_HTML/IrcVisitor.jsp'' rlink from dual';
1784: ctx:= dbms_xmlquery.newContext(query);
1785: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);
1786: dbms_xmlquery.setEncodingTag(ctx,'UTF8');
1787: xml:=dbms_xmlquery.getXML(ctx);
1788: return (xml);
1789:

Line 1786: dbms_xmlquery.setEncodingTag(ctx,'UTF8');

1782: to_char(trunc(sysdate),''Dy, DD Mon YYYY'') pubDate,
1783: ''/OA_HTML/IrcVisitor.jsp'' rlink from dual';
1784: ctx:= dbms_xmlquery.newContext(query);
1785: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);
1786: dbms_xmlquery.setEncodingTag(ctx,'UTF8');
1787: xml:=dbms_xmlquery.getXML(ctx);
1788: return (xml);
1789:
1790: end if;

Line 1787: xml:=dbms_xmlquery.getXML(ctx);

1783: ''/OA_HTML/IrcVisitor.jsp'' rlink from dual';
1784: ctx:= dbms_xmlquery.newContext(query);
1785: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);
1786: dbms_xmlquery.setEncodingTag(ctx,'UTF8');
1787: xml:=dbms_xmlquery.getXML(ctx);
1788: return (xml);
1789:
1790: end if;
1791: elsif l_locid is not null and l_drvdlocal is null then

Line 1870: ctx:= dbms_xmlquery.newContext(query);

1866: query:='SELECT fnd_message.get_string(''PER'',''IRC_412597_RSS_CRITERIA_ERROR'') title ,
1867: fnd_message.get_string(''PER'',''PER_34296_DIAG_NO_BLANKL_QUERY'') description ,
1868: to_char(trunc(sysdate),''Dy, DD Mon YYYY'') pubDate,
1869: ''/OA_HTML/IrcVisitor.jsp'' rlink from dual';
1870: ctx:= dbms_xmlquery.newContext(query);
1871: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);
1872: dbms_xmlquery.setEncodingTag(ctx,'UTF8');
1873: xml:=dbms_xmlquery.getXML(ctx);
1874: return (xml);

Line 1871: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);

1867: fnd_message.get_string(''PER'',''PER_34296_DIAG_NO_BLANKL_QUERY'') description ,
1868: to_char(trunc(sysdate),''Dy, DD Mon YYYY'') pubDate,
1869: ''/OA_HTML/IrcVisitor.jsp'' rlink from dual';
1870: ctx:= dbms_xmlquery.newContext(query);
1871: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);
1872: dbms_xmlquery.setEncodingTag(ctx,'UTF8');
1873: xml:=dbms_xmlquery.getXML(ctx);
1874: return (xml);
1875: end if;

Line 1872: dbms_xmlquery.setEncodingTag(ctx,'UTF8');

1868: to_char(trunc(sysdate),''Dy, DD Mon YYYY'') pubDate,
1869: ''/OA_HTML/IrcVisitor.jsp'' rlink from dual';
1870: ctx:= dbms_xmlquery.newContext(query);
1871: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);
1872: dbms_xmlquery.setEncodingTag(ctx,'UTF8');
1873: xml:=dbms_xmlquery.getXML(ctx);
1874: return (xml);
1875: end if;
1876:

Line 1873: xml:=dbms_xmlquery.getXML(ctx);

1869: ''/OA_HTML/IrcVisitor.jsp'' rlink from dual';
1870: ctx:= dbms_xmlquery.newContext(query);
1871: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);
1872: dbms_xmlquery.setEncodingTag(ctx,'UTF8');
1873: xml:=dbms_xmlquery.getXML(ctx);
1874: return (xml);
1875: end if;
1876:
1877: if bindnum=1 then

Line 1883: ctx:= dbms_xmlquery.newContext(query);

1879: return (xml);
1880:
1881: end if;
1882:
1883: ctx:= dbms_xmlquery.newContext(query);
1884: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);
1885: dbms_xmlquery.setEncodingTag(ctx,'UTF8');
1886:
1887: for i in 1 .. bindvalues.count loop

Line 1884: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);

1880:
1881: end if;
1882:
1883: ctx:= dbms_xmlquery.newContext(query);
1884: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);
1885: dbms_xmlquery.setEncodingTag(ctx,'UTF8');
1886:
1887: for i in 1 .. bindvalues.count loop
1888: dbms_xmlquery.setBindValue(ctx,i,bindvalues(i));

Line 1885: dbms_xmlquery.setEncodingTag(ctx,'UTF8');

1881: end if;
1882:
1883: ctx:= dbms_xmlquery.newContext(query);
1884: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);
1885: dbms_xmlquery.setEncodingTag(ctx,'UTF8');
1886:
1887: for i in 1 .. bindvalues.count loop
1888: dbms_xmlquery.setBindValue(ctx,i,bindvalues(i));
1889: end loop;

Line 1888: dbms_xmlquery.setBindValue(ctx,i,bindvalues(i));

1884: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);
1885: dbms_xmlquery.setEncodingTag(ctx,'UTF8');
1886:
1887: for i in 1 .. bindvalues.count loop
1888: dbms_xmlquery.setBindValue(ctx,i,bindvalues(i));
1889: end loop;
1890:
1891: xml:=dbms_xmlquery.getXML(ctx);
1892:

Line 1891: xml:=dbms_xmlquery.getXML(ctx);

1887: for i in 1 .. bindvalues.count loop
1888: dbms_xmlquery.setBindValue(ctx,i,bindvalues(i));
1889: end loop;
1890:
1891: xml:=dbms_xmlquery.getXML(ctx);
1892:
1893: return (xml);
1894: end getJobSearchItems;
1895:

Line 1905: ctx DBMS_XMLQUERY.ctxType;

1901: function getJobSearchChannel(langcode in varchar2 default null,
1902: enterprise in varchar2 default null) return clob is
1903: xml clob;
1904: query varchar2(1000);
1905: ctx DBMS_XMLQUERY.ctxType;
1906: begin
1907: if enterprise is not null then
1908: hr_multi_tenancy_pkg.set_context_for_enterprise(enterprise);
1909: end if;

Line 1915: ctx:= dbms_xmlquery.newContext(query);

1911: 'SELECT fnd_message.get_string(''PER'',''IRC_412592_RSS_CHANNEL_TITLE'') title, fnd_message.get_string(''PER'',''IRC_412593_RSS_CHANNEL_DESC'') description , to_char(trunc(sysdate),''Dy, DD Mon YYYY'') pubDate,
1912: ''/OA_HTML/IrcVisitor.jsp'' rlink
1913: FROM dual';
1914:
1915: ctx:= dbms_xmlquery.newContext(query);
1916: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);
1917: dbms_xmlquery.setEncodingTag(ctx,'UTF8');
1918: xml:=dbms_xmlquery.getXML(ctx);
1919:

Line 1916: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);

1912: ''/OA_HTML/IrcVisitor.jsp'' rlink
1913: FROM dual';
1914:
1915: ctx:= dbms_xmlquery.newContext(query);
1916: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);
1917: dbms_xmlquery.setEncodingTag(ctx,'UTF8');
1918: xml:=dbms_xmlquery.getXML(ctx);
1919:
1920: return (xml);

Line 1917: dbms_xmlquery.setEncodingTag(ctx,'UTF8');

1913: FROM dual';
1914:
1915: ctx:= dbms_xmlquery.newContext(query);
1916: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);
1917: dbms_xmlquery.setEncodingTag(ctx,'UTF8');
1918: xml:=dbms_xmlquery.getXML(ctx);
1919:
1920: return (xml);
1921:

Line 1918: xml:=dbms_xmlquery.getXML(ctx);

1914:
1915: ctx:= dbms_xmlquery.newContext(query);
1916: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);
1917: dbms_xmlquery.setEncodingTag(ctx,'UTF8');
1918: xml:=dbms_xmlquery.getXML(ctx);
1919:
1920: return (xml);
1921:
1922: end getJobSearchChannel;