APPS.GMPPSRP dependencies on DBMS_XMLGEN

Line 641: qryCtx DBMS_XMLGEN.ctxHandle;

637: *************************************************************** */
638:
639: PROCEDURE ps_generate_xml IS
640:
641: qryCtx DBMS_XMLGEN.ctxHandle;
642: result CLOB;
643: x_stmt VARCHAR2(25000);
644: seq_stmt VARCHAR2(200);
645: x_seq_num NUMBER;

Line 709: qryctx := dbms_xmlgen.newcontext(x_stmt);

705: -- B7481907 Rajesh Patangya starts
706: DBMS_LOB.createtemporary(temp_clob, TRUE);
707: DBMS_LOB.createtemporary(result, TRUE);
708:
709: qryctx := dbms_xmlgen.newcontext(x_stmt);
710:
711: -- generate XML data
712: DBMS_XMLGEN.getXML (qryctx, temp_clob, DBMS_XMLGEN.none);
713: l_offset := DBMS_LOB.INSTR (lob_loc => temp_clob,

Line 712: DBMS_XMLGEN.getXML (qryctx, temp_clob, DBMS_XMLGEN.none);

708:
709: qryctx := dbms_xmlgen.newcontext(x_stmt);
710:
711: -- generate XML data
712: DBMS_XMLGEN.getXML (qryctx, temp_clob, DBMS_XMLGEN.none);
713: l_offset := DBMS_LOB.INSTR (lob_loc => temp_clob,
714: pattern => '>',
715: offset => 1,
716: nth => 1);

Line 730: DBMS_XMLGEN.closeContext(qryctx);

726: -- Append the rest to xml output
727: DBMS_LOB.append (result, temp_clob);
728:
729: -- close context and free memory
730: DBMS_XMLGEN.closeContext(qryctx);
731: DBMS_LOB.FREETEMPORARY (temp_clob);
732: -- B7481907 Rajesh Patangya Ends
733:
734: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';