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_XMLGEN

Line 858: --qryCtx DBMS_XMLQuery.ctxType; -- bug# 14172720 : To get rid of error 'In or Out parameters missing at Index...' replacing DBMS_XMLQuery with DBMS_XMLGen

854: l_query_stmt varchar2(4000);
855: l_new_query clob;
856: l_chk_query clob; -- for bind variable matching validation without affecting perform bug# 14172720
857: qry_string Varchar2(4000);
858: --qryCtx DBMS_XMLQuery.ctxType; -- bug# 14172720 : To get rid of error 'In or Out parameters missing at Index...' replacing DBMS_XMLQuery with DBMS_XMLGen
859: qryCtx DBMS_XMLGen.ctxHandle; -- bug# 14172720
860: result CLOB;
861: xmlstr varchar2(32767);
862: line varchar2(4000);

Line 859: qryCtx DBMS_XMLGen.ctxHandle; -- bug# 14172720

855: l_new_query clob;
856: l_chk_query clob; -- for bind variable matching validation without affecting perform bug# 14172720
857: qry_string Varchar2(4000);
858: --qryCtx DBMS_XMLQuery.ctxType; -- bug# 14172720 : To get rid of error 'In or Out parameters missing at Index...' replacing DBMS_XMLQuery with DBMS_XMLGen
859: qryCtx DBMS_XMLGen.ctxHandle; -- bug# 14172720
860: result CLOB;
861: xmlstr varchar2(32767);
862: line varchar2(4000);
863:

Line 959: qryCtx := DBMS_XMLGen.newContext(l_new_query); -- bug# 14172720

955: l_new_query := l_query_stmt;
956: end if;
957:
958: WriteLog('GetXmlData: calling DBMS_XMLQuery api');
959: qryCtx := DBMS_XMLGen.newContext(l_new_query); -- bug# 14172720
960: l_chk_query := l_new_query; -- bug# 14172720
961:
962:
963: dbms_xmlgen.clearbindvalues (qryCtx);

Line 963: dbms_xmlgen.clearbindvalues (qryCtx);

959: qryCtx := DBMS_XMLGen.newContext(l_new_query); -- bug# 14172720
960: l_chk_query := l_new_query; -- bug# 14172720
961:
962:
963: dbms_xmlgen.clearbindvalues (qryCtx);
964:
965: for j in 1..l_bind_cnt
966: loop
967: l_cnt := 0;

Line 988: DBMS_XMLGen.setBindValue(qryCtx,l_bind_name2,l_bind_val); -- bug# 14172720

984: WriteLog('GetXmlData:replace bind_name = '||l_bind_name || ' with val=' || l_bind_val ||'; cnt=' || l_cnt);
985:
986: if l_bind_found > 0 then
987: l_dataHeader := l_dataHeader||'XMLElement("'||upper(p_bind_tbl(j).Key_name)||'",'''||l_bind_val||''').getclobval()||';
988: DBMS_XMLGen.setBindValue(qryCtx,l_bind_name2,l_bind_val); -- bug# 14172720
989: WriteLog('GetXmlData:replace bind_name2 = '||l_bind_name2 || ' with val=' || l_bind_val ||'; cnt=' || l_cnt); -- bug# 14172720
990: end if;
991:
992: l_chk_query := replace(l_chk_query, l_bind_name, l_bind_name2); -- bug# 14172720

Line 1005: DBMS_XMLGen.setBindValue(qryCtx, 'RESOURCE_ID', p_resource_id);

1001: l_cnt := 0;
1002: l_bind_found := instr( l_new_query, ':RESOURCE_ID');
1003: if l_bind_found > 0 then
1004: --DBMS_XMLQuery.setBindValue(qryCtx, 'RESOURCE_ID', p_resource_id); -- bug# 14172720
1005: DBMS_XMLGen.setBindValue(qryCtx, 'RESOURCE_ID', p_resource_id);
1006: l_chk_query := replace(l_chk_query, ':RESOURCE_ID', 'RESOURCE_ID'); -- bug# 14172720
1007: end if;
1008:
1009: WriteLog('GetXmlData: resource_id : l_cnt = '||l_cnt || ' with ' || p_resource_id);

Line 1189: DBMS_XMLGen.setRowTag(qryCtx, 'COLLECTION'); -- bug# 14172720

1185:
1186:
1187: --End Bug#6743267 24-Jul-2008 barathsr
1188: --DBMS_XMLQuery.setRowTag(qryCtx, 'COLLECTION'); -- bug# 14172720
1189: DBMS_XMLGen.setRowTag(qryCtx, 'COLLECTION'); -- bug# 14172720
1190: -- set the rowset header to null
1191: --DBMS_XMLQuery.setRowSetTag(qryCtx, 'COLLECTIONSET'); -- bug# 14172720
1192: DBMS_XMLGen.setRowSetTag(qryCtx, 'COLLECTIONSET'); -- bug# 14172720
1193: --Begin Bug#6743267 24-Jul-2008 barathsr

Line 1192: DBMS_XMLGen.setRowSetTag(qryCtx, 'COLLECTIONSET'); -- bug# 14172720

1188: --DBMS_XMLQuery.setRowTag(qryCtx, 'COLLECTION'); -- bug# 14172720
1189: DBMS_XMLGen.setRowTag(qryCtx, 'COLLECTION'); -- bug# 14172720
1190: -- set the rowset header to null
1191: --DBMS_XMLQuery.setRowSetTag(qryCtx, 'COLLECTIONSET'); -- bug# 14172720
1192: DBMS_XMLGen.setRowSetTag(qryCtx, 'COLLECTIONSET'); -- bug# 14172720
1193: --Begin Bug#6743267 24-Jul-2008 barathsr
1194: l_rowSetName := '';
1195: --End Bug#6743267 24-Jul-2008 barathsr
1196:

Line 1202: result := DBMS_XMLGen.getXml(qryCtx); -- bug# 14172720

1198:
1199: -- now get the result
1200: WriteLog('GetXmlData: getXml');
1201: --result := DBMS_XMLQuery.getXml(qryCtx); -- bug# 14172720
1202: result := DBMS_XMLGen.getXml(qryCtx); -- bug# 14172720
1203: WriteLog('GetXmlData: get result');
1204: --Begin Bug#6743267 24-Jul-2008 barathsr
1205: -- RowSet and Row
1206: result := replace(result,l_rowSetName,l_rowSetName||''||l_dataHdr_clob);

Line 1228: dbms_xmlgen.clearbindvalues (qryCtx); -- bug# 14172720

1224:
1225: --close context
1226: WriteLog('GetXmlData: close context ');
1227: --DBMS_XMLQuery.closeContext(qryCtx); -- bug# 14172720
1228: dbms_xmlgen.clearbindvalues (qryCtx); -- bug# 14172720
1229: DBMS_XMLGen.closeContext(qryCtx); -- bug# 14172720
1230:
1231:
1232: WriteLog('GetXmlData: end GetXmlData()');

Line 1229: DBMS_XMLGen.closeContext(qryCtx); -- bug# 14172720

1225: --close context
1226: WriteLog('GetXmlData: close context ');
1227: --DBMS_XMLQuery.closeContext(qryCtx); -- bug# 14172720
1228: dbms_xmlgen.clearbindvalues (qryCtx); -- bug# 14172720
1229: DBMS_XMLGen.closeContext(qryCtx); -- bug# 14172720
1230:
1231:
1232: WriteLog('GetXmlData: end GetXmlData()');
1233: