DBA Data[Home] [Help]

APPS.CST_PAC_WIP_VALUE_REPORT_PVT dependencies on DUAL

Line 1033: open l_ref_cur FOR select l_total_rows_processed row_count from DUAL;

1029: DBMS_LOB.createtemporary(l_xml_temp, TRUE);
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: