APPS.ARCM_EXTRACT_XML_CF dependencies on DBMS_XMLGEN

Line 281: qryCtx DBMS_XMLGEN.ctxHandle;

277: No_Rows EXCEPTION;
278: l_rows_processed NUMBER;
279: l_errMsg VARCHAR2(200);
280: queryCtx DBMS_XMLquery.ctxType;
281: qryCtx DBMS_XMLGEN.ctxHandle;
282: l_xml_query VARCHAR2(32767);
283:
284: BEGIN
285: IF pg_debug = 'Y'

Line 322: qryCtx := DBMS_XMLGEN.newContext(l_xml_query);

318: RETCODE :=1;
319: return;
320: END IF;
321:
322: qryCtx := DBMS_XMLGEN.newContext(l_xml_query);
323:
324: -- set the row set tag to Data Points
325: dbms_xmlgen.setRowSetTag(qryCtx,'CASE_FOLDER_DETAILS');
326:

Line 325: dbms_xmlgen.setRowSetTag(qryCtx,'CASE_FOLDER_DETAILS');

321:
322: qryCtx := DBMS_XMLGEN.newContext(l_xml_query);
323:
324: -- set the row set tag to Data Points
325: dbms_xmlgen.setRowSetTag(qryCtx,'CASE_FOLDER_DETAILS');
326:
327: -- set the row tag to CF Dtls
328: dbms_xmlgen.setRowTag(qryCtx,'DATA_POINT_DETAIL');
329: l_result := DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE);

Line 328: dbms_xmlgen.setRowTag(qryCtx,'DATA_POINT_DETAIL');

324: -- set the row set tag to Data Points
325: dbms_xmlgen.setRowSetTag(qryCtx,'CASE_FOLDER_DETAILS');
326:
327: -- set the row tag to CF Dtls
328: dbms_xmlgen.setRowTag(qryCtx,'DATA_POINT_DETAIL');
329: l_result := DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE);
330: l_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(qryCtx);
331: DBMS_XMLGEN.closeContext(qryCtx);
332:

Line 329: l_result := DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE);

325: dbms_xmlgen.setRowSetTag(qryCtx,'CASE_FOLDER_DETAILS');
326:
327: -- set the row tag to CF Dtls
328: dbms_xmlgen.setRowTag(qryCtx,'DATA_POINT_DETAIL');
329: l_result := DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE);
330: l_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(qryCtx);
331: DBMS_XMLGEN.closeContext(qryCtx);
332:
333:

Line 330: l_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(qryCtx);

326:
327: -- set the row tag to CF Dtls
328: dbms_xmlgen.setRowTag(qryCtx,'DATA_POINT_DETAIL');
329: l_result := DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE);
330: l_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(qryCtx);
331: DBMS_XMLGEN.closeContext(qryCtx);
332:
333:
334: IF l_rows_processed >0

Line 331: DBMS_XMLGEN.closeContext(qryCtx);

327: -- set the row tag to CF Dtls
328: dbms_xmlgen.setRowTag(qryCtx,'DATA_POINT_DETAIL');
329: l_result := DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE);
330: l_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(qryCtx);
331: DBMS_XMLGEN.closeContext(qryCtx);
332:
333:
334: IF l_rows_processed >0
335: THEN