APPS.GMP_DESPATCH_LOAD_RPT_PKG dependencies on DBMS_XMLGEN

Line 175: qryCtx DBMS_XMLGEN.ctxHandle;

171: | |
172: +============================================================================*/
173: PROCEDURE gme_res_generate_xml IS
174:
175: qryCtx DBMS_XMLGEN.ctxHandle;
176: result1 CLOB;
177: x_stmt VARCHAR2(10000);
178: seq_stmt VARCHAR2(100);
179:

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

264: x_stmt := x_stmt ||' order by 1,2,4 '||
265: ' ) HEADER ' ||
266: ' FROM DUAL ';
267:
268: qryctx := dbms_xmlgen.newcontext(x_stmt);
269: result1 := DBMS_XMLGEN.getXML(qryCtx);
270:
271: INSERT INTO GMP_RESDISP_XML_TEMP (RESDISP_XML_RPT_ID,RESULT) VALUES (resdisp_rpt_id, result1);
272: DBMS_XMLGEN.closeContext(qryCtx);

Line 269: result1 := DBMS_XMLGEN.getXML(qryCtx);

265: ' ) HEADER ' ||
266: ' FROM DUAL ';
267:
268: qryctx := dbms_xmlgen.newcontext(x_stmt);
269: result1 := DBMS_XMLGEN.getXML(qryCtx);
270:
271: INSERT INTO GMP_RESDISP_XML_TEMP (RESDISP_XML_RPT_ID,RESULT) VALUES (resdisp_rpt_id, result1);
272: DBMS_XMLGEN.closeContext(qryCtx);
273:

Line 272: DBMS_XMLGEN.closeContext(qryCtx);

268: qryctx := dbms_xmlgen.newcontext(x_stmt);
269: result1 := DBMS_XMLGEN.getXML(qryCtx);
270:
271: INSERT INTO GMP_RESDISP_XML_TEMP (RESDISP_XML_RPT_ID,RESULT) VALUES (resdisp_rpt_id, result1);
272: DBMS_XMLGEN.closeContext(qryCtx);
273:
274: COMMIT;
275:
276: resdl_generate_output(resdisp_rpt_id);

Line 298: qryCtx DBMS_XMLGEN.ctxHandle;

294: | |
295: +============================================================================*/
296: PROCEDURE aps_res_generate_xml IS
297:
298: qryCtx DBMS_XMLGEN.ctxHandle;
299: result1 CLOB;
300: x_stmt1 VARCHAR2(20000);
301: seq_stmt VARCHAR2(100);
302: BEGIN

Line 437: qryctx := dbms_xmlgen.newcontext(x_stmt1);

433: x_stmt1 := x_stmt1 ||' ORDER BY 1,2,4'||
434: ' ) HEADER ' ||
435: ' FROM DUAL ';
436:
437: qryctx := dbms_xmlgen.newcontext(x_stmt1);
438: result1 := DBMS_XMLGEN.getXML(qryCtx);
439:
440: INSERT INTO GMP_RESDISP_XML_TEMP (RESDISP_XML_RPT_ID,RESULT) VALUES (resdisp_rpt_id, result1);
441: DBMS_XMLGEN.closeContext(qryCtx);

Line 438: result1 := DBMS_XMLGEN.getXML(qryCtx);

434: ' ) HEADER ' ||
435: ' FROM DUAL ';
436:
437: qryctx := dbms_xmlgen.newcontext(x_stmt1);
438: result1 := DBMS_XMLGEN.getXML(qryCtx);
439:
440: INSERT INTO GMP_RESDISP_XML_TEMP (RESDISP_XML_RPT_ID,RESULT) VALUES (resdisp_rpt_id, result1);
441: DBMS_XMLGEN.closeContext(qryCtx);
442:

Line 441: DBMS_XMLGEN.closeContext(qryCtx);

437: qryctx := dbms_xmlgen.newcontext(x_stmt1);
438: result1 := DBMS_XMLGEN.getXML(qryCtx);
439:
440: INSERT INTO GMP_RESDISP_XML_TEMP (RESDISP_XML_RPT_ID,RESULT) VALUES (resdisp_rpt_id, result1);
441: DBMS_XMLGEN.closeContext(qryCtx);
442:
443:
444: COMMIT;
445: