APPS.GMPMPACT dependencies on DBMS_XMLGEN

Line 1791: qryCtx DBMS_XMLGEN.ctxHandle;

1787: *************************************************************** */
1788:
1789: PROCEDURE ps_generate_xml IS
1790:
1791: qryCtx DBMS_XMLGEN.ctxHandle;
1792: result CLOB;
1793: x_stmt VARCHAR2(25000);
1794: seq_stmt VARCHAR2(200);
1795: x_seq_num NUMBER;

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

1872: -- B7481907 Rajesh Patangya starts
1873: DBMS_LOB.createtemporary(temp_clob, TRUE);
1874: DBMS_LOB.createtemporary(result, TRUE);
1875:
1876: qryctx := dbms_xmlgen.newcontext(x_stmt);
1877:
1878: -- generate XML data
1879: DBMS_XMLGEN.getXML (qryctx, temp_clob, DBMS_XMLGEN.none);
1880: l_offset := DBMS_LOB.INSTR (lob_loc => temp_clob,

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

1875:
1876: qryctx := dbms_xmlgen.newcontext(x_stmt);
1877:
1878: -- generate XML data
1879: DBMS_XMLGEN.getXML (qryctx, temp_clob, DBMS_XMLGEN.none);
1880: l_offset := DBMS_LOB.INSTR (lob_loc => temp_clob,
1881: pattern => '>',
1882: offset => 1,
1883: nth => 1);

Line 1897: DBMS_XMLGEN.closeContext(qryctx);

1893: -- Append the rest to xml output
1894: DBMS_LOB.append (result, temp_clob);
1895:
1896: -- close context and free memory
1897: DBMS_XMLGEN.closeContext(qryctx);
1898: DBMS_LOB.FREETEMPORARY (temp_clob);
1899: -- B7481907 Rajesh Patangya Ends
1900:
1901: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';