APPS.PSP_XMLGEN dependencies on DBMS_XMLQUERY

Line 566: qryCtx2 dbms_xmlquery.ctxType;

562: p_emp_primary_org_id IN NUMBER,
563: p_currency_code IN VARCHAR2
564: ) RETURN CLOB IS
565: qryCtx1 dbms_xmlgen.ctxType;
566: qryCtx2 dbms_xmlquery.ctxType;
567: query1 VARCHAR2(8000);
568: xmlresult1 CLOB;
569: l_xml CLOB;
570: l_resultOffset INT;

Line 735: qryCtx2 := dbms_xmlquery.newContext(query1);

731: || ' psp_eff_report_details perd2 '
732: || ' WHERE pera2.effort_report_detail_id = perd2.effort_report_detail_id '
733: || ' AND perd2.effort_report_id = perd.effort_report_id) ';
734:
735: qryCtx2 := dbms_xmlquery.newContext(query1);
736: dbms_xmlquery.setRowTag(qryCtx2, NULL);
737: dbms_xmlquery.setRowSetTag(qryCtx2, 'EMP_DFF');
738: xmlresult1 := dbms_xmlquery.getXML(qryCtx2, dbms_xmlgen.NONE);
739: dbms_xmlquery.closecontext(qryctx2);

Line 736: dbms_xmlquery.setRowTag(qryCtx2, NULL);

732: || ' WHERE pera2.effort_report_detail_id = perd2.effort_report_detail_id '
733: || ' AND perd2.effort_report_id = perd.effort_report_id) ';
734:
735: qryCtx2 := dbms_xmlquery.newContext(query1);
736: dbms_xmlquery.setRowTag(qryCtx2, NULL);
737: dbms_xmlquery.setRowSetTag(qryCtx2, 'EMP_DFF');
738: xmlresult1 := dbms_xmlquery.getXML(qryCtx2, dbms_xmlgen.NONE);
739: dbms_xmlquery.closecontext(qryctx2);
740: l_xml := xmlresult1;

Line 737: dbms_xmlquery.setRowSetTag(qryCtx2, 'EMP_DFF');

733: || ' AND perd2.effort_report_id = perd.effort_report_id) ';
734:
735: qryCtx2 := dbms_xmlquery.newContext(query1);
736: dbms_xmlquery.setRowTag(qryCtx2, NULL);
737: dbms_xmlquery.setRowSetTag(qryCtx2, 'EMP_DFF');
738: xmlresult1 := dbms_xmlquery.getXML(qryCtx2, dbms_xmlgen.NONE);
739: dbms_xmlquery.closecontext(qryctx2);
740: l_xml := xmlresult1;
741: dbms_lob.write(l_xml, length(l_employee_info), 1, l_employee_info);

Line 738: xmlresult1 := dbms_xmlquery.getXML(qryCtx2, dbms_xmlgen.NONE);

734:
735: qryCtx2 := dbms_xmlquery.newContext(query1);
736: dbms_xmlquery.setRowTag(qryCtx2, NULL);
737: dbms_xmlquery.setRowSetTag(qryCtx2, 'EMP_DFF');
738: xmlresult1 := dbms_xmlquery.getXML(qryCtx2, dbms_xmlgen.NONE);
739: dbms_xmlquery.closecontext(qryctx2);
740: l_xml := xmlresult1;
741: dbms_lob.write(l_xml, length(l_employee_info), 1, l_employee_info);
742: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');

Line 739: dbms_xmlquery.closecontext(qryctx2);

735: qryCtx2 := dbms_xmlquery.newContext(query1);
736: dbms_xmlquery.setRowTag(qryCtx2, NULL);
737: dbms_xmlquery.setRowSetTag(qryCtx2, 'EMP_DFF');
738: xmlresult1 := dbms_xmlquery.getXML(qryCtx2, dbms_xmlgen.NONE);
739: dbms_xmlquery.closecontext(qryctx2);
740: l_xml := xmlresult1;
741: dbms_lob.write(l_xml, length(l_employee_info), 1, l_employee_info);
742: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
743: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, length(l_employee_info), l_resultOffset +1);