DBA Data[Home] [Help]

APPS.FEM_TABLE_PUBLISH_PKG dependencies on DBMS_XMLQUERY

Line 163: queryCtx DBMS_XMLquery.ctxType;

159: l_test1_xml CLOB;
160: dim VARCHAR2(20);
161: l_xmlresult CLOB;
162: --queryCtx DBMS_XMLGEN.ctxHandle;
163: queryCtx DBMS_XMLquery.ctxType;
164: l_tablename VARCHAR2(50);
165: l_clob_size NUMBER;
166: l_data_size NUMBER;
167: l_offset NUMBER;

Line 463: queryCtx := DBMS_XMLQuery.newContext(l_query);

459: Get the xml.
460: **************************************************/
461: fnd_file.put_line(fnd_file.log,'************************************XML******************************************************');
462:
463: queryCtx := DBMS_XMLQuery.newContext(l_query);
464: DBMS_XMLQuery.setRowsetTag(queryCtx, 'Extracted_Records');
465: DBMS_XMLQuery.setRowTag(queryCtx, 'Row');
466:
467: l_xmlResult := DBMS_XMLQuery.getXML(queryCtx);

Line 464: DBMS_XMLQuery.setRowsetTag(queryCtx, 'Extracted_Records');

460: **************************************************/
461: fnd_file.put_line(fnd_file.log,'************************************XML******************************************************');
462:
463: queryCtx := DBMS_XMLQuery.newContext(l_query);
464: DBMS_XMLQuery.setRowsetTag(queryCtx, 'Extracted_Records');
465: DBMS_XMLQuery.setRowTag(queryCtx, 'Row');
466:
467: l_xmlResult := DBMS_XMLQuery.getXML(queryCtx);
468: DBMS_XMLQuery.closeContext(queryCtx);

Line 465: DBMS_XMLQuery.setRowTag(queryCtx, 'Row');

461: fnd_file.put_line(fnd_file.log,'************************************XML******************************************************');
462:
463: queryCtx := DBMS_XMLQuery.newContext(l_query);
464: DBMS_XMLQuery.setRowsetTag(queryCtx, 'Extracted_Records');
465: DBMS_XMLQuery.setRowTag(queryCtx, 'Row');
466:
467: l_xmlResult := DBMS_XMLQuery.getXML(queryCtx);
468: DBMS_XMLQuery.closeContext(queryCtx);
469:

Line 467: l_xmlResult := DBMS_XMLQuery.getXML(queryCtx);

463: queryCtx := DBMS_XMLQuery.newContext(l_query);
464: DBMS_XMLQuery.setRowsetTag(queryCtx, 'Extracted_Records');
465: DBMS_XMLQuery.setRowTag(queryCtx, 'Row');
466:
467: l_xmlResult := DBMS_XMLQuery.getXML(queryCtx);
468: DBMS_XMLQuery.closeContext(queryCtx);
469:
470: l_data_size := dbms_lob.getlength(l_xmlResult);
471: if l_data_size > 45 then

Line 468: DBMS_XMLQuery.closeContext(queryCtx);

464: DBMS_XMLQuery.setRowsetTag(queryCtx, 'Extracted_Records');
465: DBMS_XMLQuery.setRowTag(queryCtx, 'Row');
466:
467: l_xmlResult := DBMS_XMLQuery.getXML(queryCtx);
468: DBMS_XMLQuery.closeContext(queryCtx);
469:
470: l_data_size := dbms_lob.getlength(l_xmlResult);
471: if l_data_size > 45 then
472: l_data_present := 'Yes';

Line 592: queryCtx DBMS_XMLquery.ctxType;

588: l_test1_xml CLOB;
589: dim VARCHAR2(20);
590: l_xmlresult CLOB;
591: --queryCtx DBMS_XMLGEN.ctxHandle;
592: queryCtx DBMS_XMLquery.ctxType;
593: l_tablename VARCHAR2(50);
594: l_clob_size NUMBER;
595: l_data_size NUMBER;
596: l_offset NUMBER;

Line 795: queryCtx := DBMS_XMLQuery.newContext(l_query);

791: Get the xml.
792: **************************************************/
793: fnd_file.put_line(fnd_file.log,'************************************XML******************************************************');
794:
795: queryCtx := DBMS_XMLQuery.newContext(l_query);
796: DBMS_XMLQuery.setRowsetTag(queryCtx, 'Extracted_Records');
797: DBMS_XMLQuery.setRowTag(queryCtx, 'Row');
798:
799: l_xmlResult := DBMS_XMLQuery.getXML(queryCtx);

Line 796: DBMS_XMLQuery.setRowsetTag(queryCtx, 'Extracted_Records');

792: **************************************************/
793: fnd_file.put_line(fnd_file.log,'************************************XML******************************************************');
794:
795: queryCtx := DBMS_XMLQuery.newContext(l_query);
796: DBMS_XMLQuery.setRowsetTag(queryCtx, 'Extracted_Records');
797: DBMS_XMLQuery.setRowTag(queryCtx, 'Row');
798:
799: l_xmlResult := DBMS_XMLQuery.getXML(queryCtx);
800: DBMS_XMLQuery.closeContext(queryCtx);

Line 797: DBMS_XMLQuery.setRowTag(queryCtx, 'Row');

793: fnd_file.put_line(fnd_file.log,'************************************XML******************************************************');
794:
795: queryCtx := DBMS_XMLQuery.newContext(l_query);
796: DBMS_XMLQuery.setRowsetTag(queryCtx, 'Extracted_Records');
797: DBMS_XMLQuery.setRowTag(queryCtx, 'Row');
798:
799: l_xmlResult := DBMS_XMLQuery.getXML(queryCtx);
800: DBMS_XMLQuery.closeContext(queryCtx);
801:

Line 799: l_xmlResult := DBMS_XMLQuery.getXML(queryCtx);

795: queryCtx := DBMS_XMLQuery.newContext(l_query);
796: DBMS_XMLQuery.setRowsetTag(queryCtx, 'Extracted_Records');
797: DBMS_XMLQuery.setRowTag(queryCtx, 'Row');
798:
799: l_xmlResult := DBMS_XMLQuery.getXML(queryCtx);
800: DBMS_XMLQuery.closeContext(queryCtx);
801:
802: l_clob_size := dbms_lob.getlength(l_xmlResult);
803: l_offset := 1;

Line 800: DBMS_XMLQuery.closeContext(queryCtx);

796: DBMS_XMLQuery.setRowsetTag(queryCtx, 'Extracted_Records');
797: DBMS_XMLQuery.setRowTag(queryCtx, 'Row');
798:
799: l_xmlResult := DBMS_XMLQuery.getXML(queryCtx);
800: DBMS_XMLQuery.closeContext(queryCtx);
801:
802: l_clob_size := dbms_lob.getlength(l_xmlResult);
803: l_offset := 1;
804: l_chunk_size := 3000;