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.IEX_SEND_XML_PVT dependencies on DBMS_XMLQUERY

Line 650: qryCtx DBMS_XMLQuery.ctxType;

646: l_query clob;
647: l_query_stmt varchar2(4000);
648: l_new_query clob;
649: qry_string Varchar2(4000);
650: qryCtx DBMS_XMLQuery.ctxType;
651: result CLOB;
652: xmlstr varchar2(32767);
653: line varchar2(4000);
654:

Line 850: WriteLog('GetXmlData: calling DBMS_XMLQuery api');

846: end if;
847:
848: /* end bug 4732366 - ctlee - use set bind variables 11/28/2005 */
849:
850: WriteLog('GetXmlData: calling DBMS_XMLQuery api');
851: --qryCtx := DBMS_XMLQuery.newContext(l_query);
852: qryCtx := DBMS_XMLQuery.newContext(l_new_query);
853:
854: DBMS_XMLQuery.setRowTag(qryCtx, 'COLLECTION');

Line 851: --qryCtx := DBMS_XMLQuery.newContext(l_query);

847:
848: /* end bug 4732366 - ctlee - use set bind variables 11/28/2005 */
849:
850: WriteLog('GetXmlData: calling DBMS_XMLQuery api');
851: --qryCtx := DBMS_XMLQuery.newContext(l_query);
852: qryCtx := DBMS_XMLQuery.newContext(l_new_query);
853:
854: DBMS_XMLQuery.setRowTag(qryCtx, 'COLLECTION');
855: -- set the rowset header to null

Line 852: qryCtx := DBMS_XMLQuery.newContext(l_new_query);

848: /* end bug 4732366 - ctlee - use set bind variables 11/28/2005 */
849:
850: WriteLog('GetXmlData: calling DBMS_XMLQuery api');
851: --qryCtx := DBMS_XMLQuery.newContext(l_query);
852: qryCtx := DBMS_XMLQuery.newContext(l_new_query);
853:
854: DBMS_XMLQuery.setRowTag(qryCtx, 'COLLECTION');
855: -- set the rowset header to null
856: DBMS_XMLQuery.setRowSetTag(qryCtx, 'COLLECTIONSET');

Line 854: DBMS_XMLQuery.setRowTag(qryCtx, 'COLLECTION');

850: WriteLog('GetXmlData: calling DBMS_XMLQuery api');
851: --qryCtx := DBMS_XMLQuery.newContext(l_query);
852: qryCtx := DBMS_XMLQuery.newContext(l_new_query);
853:
854: DBMS_XMLQuery.setRowTag(qryCtx, 'COLLECTION');
855: -- set the rowset header to null
856: DBMS_XMLQuery.setRowSetTag(qryCtx, 'COLLECTIONSET');
857:
858: --Begin Bug#6743267 24-Jul-2008 barathsr

Line 856: DBMS_XMLQuery.setRowSetTag(qryCtx, 'COLLECTIONSET');

852: qryCtx := DBMS_XMLQuery.newContext(l_new_query);
853:
854: DBMS_XMLQuery.setRowTag(qryCtx, 'COLLECTION');
855: -- set the rowset header to null
856: DBMS_XMLQuery.setRowSetTag(qryCtx, 'COLLECTIONSET');
857:
858: --Begin Bug#6743267 24-Jul-2008 barathsr
859: l_rowSetName := '';
860: --End Bug#6743267 24-Jul-2008 barathsr

Line 864: --DBMS_XMLQuery.setBindValue(qryCtx, 'PARTY_ID', p_party_id);

860: --End Bug#6743267 24-Jul-2008 barathsr
861:
862: /***
863: --Set bind values
864: --DBMS_XMLQuery.setBindValue(qryCtx, 'PARTY_ID', p_party_id);
865: WriteLog('GetXmlData: set bind values');
866: l_bind_cnt := l_bind_tbl.count;
867: l_cnt := 0;
868: WriteLog('GetXmlData: l_bind_cnt = '||l_bind_cnt);

Line 882: DBMS_XMLQuery.setBindValue(qryCtx, l_bind_name, l_bind_val);

878: LOOP
879: EXIT when l_bind_found = 0;
880: --
881: l_cnt := l_cnt + 1;
882: DBMS_XMLQuery.setBindValue(qryCtx, l_bind_name, l_bind_val);
883: l_bind_found := instr( l_query, l_bind_name);
884: END LOOP;
885: WriteLog('GetXmlData: set bind_name = '||l_bind_name || ' with val=' || l_bind_val ||'; cnt=' || l_cnt);
886: end loop;

Line 895: DBMS_XMLQuery.setBindValue(qryCtx, 'RESOURCE_ID', p_resource_id);

891: LOOP
892: EXIT when l_bind_found = 0;
893: --
894: l_cnt := l_cnt + 1;
895: DBMS_XMLQuery.setBindValue(qryCtx, 'RESOURCE_ID', p_resource_id);
896: l_bind_found := instr( l_query, ':RESOURCE_ID');
897: END LOOP;
898: WriteLog('GetXmlData: resource_id : l_cnt = '||l_cnt);
899: ***/

Line 921: DBMS_XMLQuery.setBindValue(qryCtx, l_bind_name||l_bind_count, l_bind_val);

917: LOOP
918: EXIT when l_bind_count = 0;
919: --
920: --l_cnt := l_cnt + 1;
921: DBMS_XMLQuery.setBindValue(qryCtx, l_bind_name||l_bind_count, l_bind_val);
922: WriteLog('GetXmlData: set bind_name = '||l_bind_name || l_bind_count || ' with val=' || l_bind_val );
923: -- l_bind_found := instr( l_query, l_bind_name);
924: l_bind_count := l_bind_count - 1;
925:

Line 946: result := DBMS_XMLQuery.getXml(qryCtx);

942: --End Bug#6743267 24-Jul-2008 barathsr
943:
944: -- now get the result
945: WriteLog('GetXmlData: getXml');
946: result := DBMS_XMLQuery.getXml(qryCtx);
947: WriteLog('GetXmlData: get result');
948: --Begin Bug#6743267 24-Jul-2008 barathsr
949: -- RowSet and Row
950: result := replace(result,l_rowSetName,l_rowSetName||''||l_dataHdr_clob);

Line 966: DBMS_XMLQuery.closeContext(qryCtx);

962: end if;
963:
964: --close context
965: WriteLog('GetXmlData: close context ');
966: DBMS_XMLQuery.closeContext(qryCtx);
967:
968:
969: WriteLog('GetXmlData: end GetXmlData()');
970: