APPS.GMPMPACT dependencies on DBMS_XMLGEN

Line 1773: qryCtx DBMS_XMLGEN.ctxHandle;

1769: *************************************************************** */
1770:
1771: PROCEDURE ps_generate_xml IS
1772:
1773: qryCtx DBMS_XMLGEN.ctxHandle;
1774: result CLOB;
1775: x_stmt VARCHAR2(2000);
1776: seq_stmt VARCHAR2(100);
1777: x_seq_num NUMBER;

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

1835: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
1836:
1837: EXECUTE IMMEDIATE seq_stmt INTO x_seq_num ;
1838:
1839: qryctx := dbms_xmlgen.newcontext(x_stmt);
1840: result := DBMS_XMLGEN.getXML(qryCtx);
1841: INSERT INTO gmp_unbucketed_xml_temp(ubckt_matl_xml_id, xml_file) VALUES(x_seq_num, result);
1842: DBMS_XMLGEN.closeContext(qryCtx);
1843: ps_generate_output(x_seq_num);

Line 1840: result := DBMS_XMLGEN.getXML(qryCtx);

1836:
1837: EXECUTE IMMEDIATE seq_stmt INTO x_seq_num ;
1838:
1839: qryctx := dbms_xmlgen.newcontext(x_stmt);
1840: result := DBMS_XMLGEN.getXML(qryCtx);
1841: INSERT INTO gmp_unbucketed_xml_temp(ubckt_matl_xml_id, xml_file) VALUES(x_seq_num, result);
1842: DBMS_XMLGEN.closeContext(qryCtx);
1843: ps_generate_output(x_seq_num);
1844:

Line 1842: DBMS_XMLGEN.closeContext(qryCtx);

1838:
1839: qryctx := dbms_xmlgen.newcontext(x_stmt);
1840: result := DBMS_XMLGEN.getXML(qryCtx);
1841: INSERT INTO gmp_unbucketed_xml_temp(ubckt_matl_xml_id, xml_file) VALUES(x_seq_num, result);
1842: DBMS_XMLGEN.closeContext(qryCtx);
1843: ps_generate_output(x_seq_num);
1844:
1845: EXCEPTION
1846: WHEN OTHERS THEN