eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CST_PAC_WIP_VALUE_REPORT_PVT dependencies on DBMS_XMLGEN

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

358: AND m1.lookup_code = p_report_type;
359:
360: -- create a new context with the SQL query
361: l_stmt_num := 40;
362: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
363:
364: -- Set the row tag and rowset tag
365: l_stmt_num := 50;
366: DBMS_XMLGEN.setRowSetTag(l_ctx,'REPORTPARAMETERS');

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

362: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
363:
364: -- Set the row tag and rowset tag
365: l_stmt_num := 50;
366: DBMS_XMLGEN.setRowSetTag(l_ctx,'REPORTPARAMETERS');
367: DBMS_XMLGEN.setRowTag(l_ctx,NULL);
368:
369: -- generate XML data
370: l_stmt_num := 60;

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

363:
364: -- Set the row tag and rowset tag
365: l_stmt_num := 50;
366: DBMS_XMLGEN.setRowSetTag(l_ctx,'REPORTPARAMETERS');
367: DBMS_XMLGEN.setRowTag(l_ctx,NULL);
368:
369: -- generate XML data
370: l_stmt_num := 60;
371: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);

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

367: DBMS_XMLGEN.setRowTag(l_ctx,NULL);
368:
369: -- generate XML data
370: l_stmt_num := 60;
371: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
372:
373: l_stmt_num := 70;
374: l_offset := DBMS_LOB.instr (lob_loc => l_xml_temp,
375: pattern => '>',

Line 403: DBMS_XMLGEN.closeContext(l_ctx);

399: DBMS_LOB.append (x_xml_doc, l_xml_temp);
400:
401: -- close context and free memory
402: l_stmt_num := 120;
403: DBMS_XMLGEN.closeContext(l_ctx);
404: CLOSE l_ref_cur;
405: DBMS_LOB.FREETEMPORARY (l_xml_temp);
406:
407: IF l_plog THEN

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

999:
1000:
1001: -- create new context
1002: l_stmt_num := 150;
1003: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1004:
1005: DBMS_XMLGEN.setRowSetTag (l_ctx,'PACwipentites');
1006: DBMS_XMLGEN.setRowTag (l_ctx,'CostElements');
1007:

Line 1005: DBMS_XMLGEN.setRowSetTag (l_ctx,'PACwipentites');

1001: -- create new context
1002: l_stmt_num := 150;
1003: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1004:
1005: DBMS_XMLGEN.setRowSetTag (l_ctx,'PACwipentites');
1006: DBMS_XMLGEN.setRowTag (l_ctx,'CostElements');
1007:
1008: -- get XML
1009: l_stmt_num := 160;

Line 1006: DBMS_XMLGEN.setRowTag (l_ctx,'CostElements');

1002: l_stmt_num := 150;
1003: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1004:
1005: DBMS_XMLGEN.setRowSetTag (l_ctx,'PACwipentites');
1006: DBMS_XMLGEN.setRowTag (l_ctx,'CostElements');
1007:
1008: -- get XML
1009: l_stmt_num := 160;
1010: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);

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

1006: DBMS_XMLGEN.setRowTag (l_ctx,'CostElements');
1007:
1008: -- get XML
1009: l_stmt_num := 160;
1010: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
1011:
1012: -- Remove the header (21 characters) and append the rest to xml output
1013: l_stmt_num := 170;
1014: l_total_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);

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

1010: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
1011:
1012: -- Remove the header (21 characters) and append the rest to xml output
1013: l_stmt_num := 170;
1014: l_total_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
1015:
1016: l_stmt_num := 180;
1017: IF ( l_total_rows_processed > 0) THEN
1018: DBMS_LOB.erase (l_xml_temp, l_offset,1);

Line 1024: DBMS_XMLGEN.closeContext(l_ctx);

1020: END IF;
1021:
1022: -- close context and free memory
1023: l_stmt_num := 190;
1024: DBMS_XMLGEN.closeContext(l_ctx);
1025: CLOSE l_ref_cur;
1026: DBMS_LOB.FREETEMPORARY (l_xml_temp);
1027:
1028: l_stmt_num := 200;

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

1030:
1031: l_stmt_num := 210;
1032: -- create new context to get the total number rows processes
1033: open l_ref_cur FOR select l_total_rows_processed row_count from DUAL;
1034: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1035: DBMS_XMLGEN.setRowSetTag (l_ctx,NULL);
1036: DBMS_XMLGEN.setRowTag (l_ctx,NULL);
1037:
1038: l_stmt_num := 220;

Line 1035: DBMS_XMLGEN.setRowSetTag (l_ctx,NULL);

1031: l_stmt_num := 210;
1032: -- create new context to get the total number rows processes
1033: open l_ref_cur FOR select l_total_rows_processed row_count from DUAL;
1034: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1035: DBMS_XMLGEN.setRowSetTag (l_ctx,NULL);
1036: DBMS_XMLGEN.setRowTag (l_ctx,NULL);
1037:
1038: l_stmt_num := 220;
1039: -- get XML

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

1032: -- create new context to get the total number rows processes
1033: open l_ref_cur FOR select l_total_rows_processed row_count from DUAL;
1034: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1035: DBMS_XMLGEN.setRowSetTag (l_ctx,NULL);
1036: DBMS_XMLGEN.setRowTag (l_ctx,NULL);
1037:
1038: l_stmt_num := 220;
1039: -- get XML
1040: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);

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

1036: DBMS_XMLGEN.setRowTag (l_ctx,NULL);
1037:
1038: l_stmt_num := 220;
1039: -- get XML
1040: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
1041:
1042: -- remove the header (21 characters) and append the rest to xml output
1043: l_stmt_num := 230;
1044: l_total_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);

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

1040: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
1041:
1042: -- remove the header (21 characters) and append the rest to xml output
1043: l_stmt_num := 230;
1044: l_total_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
1045:
1046: -- Check the number of rows more than zero then add XML result
1047: l_stmt_num := 240;
1048: IF ( l_total_rows_processed > 0) THEN

Line 1055: DBMS_XMLGEN.closeContext(l_ctx);

1051: END IF;
1052:
1053: l_stmt_num := 250;
1054: -- close context and free memory
1055: DBMS_XMLGEN.closeContext(l_ctx);
1056: CLOSE l_ref_cur;
1057: DBMS_LOB.FREETEMPORARY (l_xml_temp);
1058:
1059: IF l_plog THEN