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.EDR_PSIG dependencies on DBMS_XMLGEN

Line 2565: qryCtx DBMS_XMLGEN.ctxHandle;

2561:
2562: is
2563:
2564: --This holds the query context.
2565: qryCtx DBMS_XMLGEN.ctxHandle;
2566:
2567: --This would hold the resultant CLOB.
2568: l_result XMLType;
2569:

Line 2573: qryCtx := dbms_xmlgen.newContext('select xmltype(psig_xml) as ERECORD_XML from edr_psig_documents where document_id = ' || p_document_id);

2569:
2570: BEGIN
2571:
2572: --Create the query context based on the SQL QUERY.
2573: qryCtx := dbms_xmlgen.newContext('select xmltype(psig_xml) as ERECORD_XML from edr_psig_documents where document_id = ' || p_document_id);
2574:
2575: --We want the "" tag to be null
2576: dbms_xmlgen.setRowTag(qryCtx,null);
2577:

Line 2576: dbms_xmlgen.setRowTag(qryCtx,null);

2572: --Create the query context based on the SQL QUERY.
2573: qryCtx := dbms_xmlgen.newContext('select xmltype(psig_xml) as ERECORD_XML from edr_psig_documents where document_id = ' || p_document_id);
2574:
2575: --We want the "" tag to be null
2576: dbms_xmlgen.setRowTag(qryCtx,null);
2577:
2578: --We want the "ROWSET" tag to be null
2579: dbms_xmlgen.setRowSetTag(qryCtx,null);
2580:

Line 2579: dbms_xmlgen.setRowSetTag(qryCtx,null);

2575: --We want the "" tag to be null
2576: dbms_xmlgen.setRowTag(qryCtx,null);
2577:
2578: --We want the "ROWSET" tag to be null
2579: dbms_xmlgen.setRowSetTag(qryCtx,null);
2580:
2581: --We don't want any conversion of special characters.
2582: --This will ensure that the '<' and '> symbols in the base psig_xml are retained.
2583: dbms_xmlgen.setConvertSpecialChars(qryCtx,false);

Line 2583: dbms_xmlgen.setConvertSpecialChars(qryCtx,false);

2579: dbms_xmlgen.setRowSetTag(qryCtx,null);
2580:
2581: --We don't want any conversion of special characters.
2582: --This will ensure that the '<' and '> symbols in the base psig_xml are retained.
2583: dbms_xmlgen.setConvertSpecialChars(qryCtx,false);
2584:
2585: --This would give us the required XML without any standard comments.
2586: select extract(dbms_xmlgen.getXMLType(qryCtx),'/ERECORD_XML/*')
2587: into l_result

Line 2586: select extract(dbms_xmlgen.getXMLType(qryCtx),'/ERECORD_XML/*')

2582: --This will ensure that the '<' and '> symbols in the base psig_xml are retained.
2583: dbms_xmlgen.setConvertSpecialChars(qryCtx,false);
2584:
2585: --This would give us the required XML without any standard comments.
2586: select extract(dbms_xmlgen.getXMLType(qryCtx),'/ERECORD_XML/*')
2587: into l_result
2588: from dual;
2589:
2590: SELECT xmlelement("ERECORD_XML",l_result)