DBA Data[Home] [Help]

APPS.CST_EAM_WORKORDERS_PVT dependencies on DBMS_XMLGEN

Line 314: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);

310: p_from_workorder, p_to_workorder, l_wip_entity_name, p_range;
311:
312: -- create a new context with the SQL query
313: l_stmt_num := 50;
314: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
315: DBMS_XMLGEN.setRowSetTag (l_ctx,'REPORTPARAMETERS');
316: DBMS_XMLGEN.setRowTag (l_ctx,NULL);
317:
318: -- generate XML data

Line 315: DBMS_XMLGEN.setRowSetTag (l_ctx,'REPORTPARAMETERS');

311:
312: -- create a new context with the SQL query
313: l_stmt_num := 50;
314: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
315: DBMS_XMLGEN.setRowSetTag (l_ctx,'REPORTPARAMETERS');
316: DBMS_XMLGEN.setRowTag (l_ctx,NULL);
317:
318: -- generate XML data
319: l_stmt_num := 70;

Line 316: DBMS_XMLGEN.setRowTag (l_ctx,NULL);

312: -- create a new context with the SQL query
313: l_stmt_num := 50;
314: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
315: DBMS_XMLGEN.setRowSetTag (l_ctx,'REPORTPARAMETERS');
316: DBMS_XMLGEN.setRowTag (l_ctx,NULL);
317:
318: -- generate XML data
319: l_stmt_num := 70;
320: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);

Line 320: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);

316: DBMS_XMLGEN.setRowTag (l_ctx,NULL);
317:
318: -- generate XML data
319: l_stmt_num := 70;
320: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
321:
322: l_stmt_num := 80;
323: l_offset := DBMS_LOB.instr (lob_loc => l_xml_temp,
324: pattern => '>',

Line 353: DBMS_XMLGEN.closeContext(l_ctx);

349: DBMS_LOB.append (x_xml_doc, l_xml_temp);
350:
351: /* close context and free memory */
352: l_stmt_num := 130;
353: DBMS_XMLGEN.closeContext(l_ctx);
354: CLOSE l_ref_cur;
355: DBMS_LOB.FREETEMPORARY (l_xml_temp);
356:
357: IF l_plog THEN

Line 597: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);

593: END IF;
594:
595: -- create a new context with the SQL query
596: l_stmt_num := 60;
597: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
598:
599: -- Set the row tag and rowset tag
600: l_stmt_num := 70;
601: DBMS_XMLGEN.setRowSetTag (l_ctx,'eAMWorkOrders');

Line 601: DBMS_XMLGEN.setRowSetTag (l_ctx,'eAMWorkOrders');

597: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
598:
599: -- Set the row tag and rowset tag
600: l_stmt_num := 70;
601: DBMS_XMLGEN.setRowSetTag (l_ctx,'eAMWorkOrders');
602: DBMS_XMLGEN.setRowTag (l_ctx,'eAMWorkOrderopSeq');
603:
604: -- generate XML data
605: l_stmt_num := 80;

Line 602: DBMS_XMLGEN.setRowTag (l_ctx,'eAMWorkOrderopSeq');

598:
599: -- Set the row tag and rowset tag
600: l_stmt_num := 70;
601: DBMS_XMLGEN.setRowSetTag (l_ctx,'eAMWorkOrders');
602: DBMS_XMLGEN.setRowTag (l_ctx,'eAMWorkOrderopSeq');
603:
604: -- generate XML data
605: l_stmt_num := 80;
606: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);

Line 606: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);

602: DBMS_XMLGEN.setRowTag (l_ctx,'eAMWorkOrderopSeq');
603:
604: -- generate XML data
605: l_stmt_num := 80;
606: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
607:
608: -- remove the header (21 characters) and append the rest to xml output
609: l_stmt_num := 90;
610: l_total_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);

Line 610: l_total_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);

606: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
607:
608: -- remove the header (21 characters) and append the rest to xml output
609: l_stmt_num := 90;
610: l_total_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
611: IF ( l_total_rows_processed > 0) THEN
612: DBMS_LOB.erase (l_xml_temp, l_offset,1);
613: DBMS_LOB.append (x_xml_doc, l_xml_temp);
614: END IF;

Line 618: DBMS_XMLGEN.closeContext(l_ctx);

614: END IF;
615:
616: -- close context and free memory
617: l_stmt_num := 100;
618: DBMS_XMLGEN.closeContext(l_ctx);
619: CLOSE l_ref_cur;
620: DBMS_LOB.FREETEMPORARY (l_xml_temp);
621:
622: