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(2000);
644: seq_stmt VARCHAR2(100);
645: x_seq_num NUMBER;

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

689:
690: EXECUTE IMMEDIATE seq_stmt INTO x_seq_num ;
691:
692: --DELETE FROM GMP_BUCKETED_XML_GTMP;
693: qryctx := dbms_xmlgen.newcontext(x_stmt);
694: result := DBMS_XMLGEN.getXML(qryCtx);
695: INSERT INTO gmp_bucketed_xml_temp(bckt_matl_xml_id, xml_file) VALUES(x_seq_num, result);
696: DBMS_XMLGEN.closeContext(qryCtx);
697: ps_generate_output(x_seq_num);

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

690: EXECUTE IMMEDIATE seq_stmt INTO x_seq_num ;
691:
692: --DELETE FROM GMP_BUCKETED_XML_GTMP;
693: qryctx := dbms_xmlgen.newcontext(x_stmt);
694: result := DBMS_XMLGEN.getXML(qryCtx);
695: INSERT INTO gmp_bucketed_xml_temp(bckt_matl_xml_id, xml_file) VALUES(x_seq_num, result);
696: DBMS_XMLGEN.closeContext(qryCtx);
697: ps_generate_output(x_seq_num);
698:

Line 696: DBMS_XMLGEN.closeContext(qryCtx);

692: --DELETE FROM GMP_BUCKETED_XML_GTMP;
693: qryctx := dbms_xmlgen.newcontext(x_stmt);
694: result := DBMS_XMLGEN.getXML(qryCtx);
695: INSERT INTO gmp_bucketed_xml_temp(bckt_matl_xml_id, xml_file) VALUES(x_seq_num, result);
696: DBMS_XMLGEN.closeContext(qryCtx);
697: ps_generate_output(x_seq_num);
698:
699: EXCEPTION
700: WHEN OTHERS THEN