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.FEM_TABLE_PUBLISH_PKG dependencies on DBMS_LOB

Line 311: dbms_lob.createtemporary(l_metadata_xml,TRUE);

307:
308: /*****************************************************************
309: Add header details to CLOB
310: *****************************************************************/
311: dbms_lob.createtemporary(l_metadata_xml,TRUE);
312:
313: l_xmlString := '';
314: l_xmlString := l_xmlString || '';
315: l_xmlString := l_xmlstring || ' '|| l_table_display_name || '';

Line 320: dbms_lob.writeappend(l_metadata_xml,LENGTH(l_xmlString),l_xmlString);

316: l_xmlString := l_xmlString || ' '|| l_condition_name || '';
317: l_xmlString := l_xmlString || ' '|| l_di_name || '';
318: l_xmlString := l_xmlString || ' ';
319:
320: dbms_lob.writeappend(l_metadata_xml,LENGTH(l_xmlString),l_xmlString);
321: /**********************************************************
322: Prepare the query
323: ***********************************************************/
324: dbms_lob.createtemporary(selectClause,TRUE);

Line 324: dbms_lob.createtemporary(selectClause,TRUE);

320: dbms_lob.writeappend(l_metadata_xml,LENGTH(l_xmlString),l_xmlString);
321: /**********************************************************
322: Prepare the query
323: ***********************************************************/
324: dbms_lob.createtemporary(selectClause,TRUE);
325: dbms_lob.createtemporary(l_query,TRUE);
326:
327: FOR row_record in get_required_columns_cursor LOOP
328:

Line 325: dbms_lob.createtemporary(l_query,TRUE);

321: /**********************************************************
322: Prepare the query
323: ***********************************************************/
324: dbms_lob.createtemporary(selectClause,TRUE);
325: dbms_lob.createtemporary(l_query,TRUE);
326:
327: FOR row_record in get_required_columns_cursor LOOP
328:
329:

Line 383: dbms_lob.writeappend(selectClause,LENGTH(l_queryString),l_queryString);

379: || ' ) as col , ' ;
380:
381: END IF;
382: --fnd_file.put_line(fnd_file.log,l_queryString);
383: dbms_lob.writeappend(selectClause,LENGTH(l_queryString),l_queryString);
384: dbms_lob.writeappend(l_metadata_xml,LENGTH(l_xmlString),l_xmlString);
385:
386: END LOOP;
387:

Line 384: dbms_lob.writeappend(l_metadata_xml,LENGTH(l_xmlString),l_xmlString);

380:
381: END IF;
382: --fnd_file.put_line(fnd_file.log,l_queryString);
383: dbms_lob.writeappend(selectClause,LENGTH(l_queryString),l_queryString);
384: dbms_lob.writeappend(l_metadata_xml,LENGTH(l_xmlString),l_xmlString);
385:
386: END LOOP;
387:
388: l_xmlString := ' ';

Line 390: dbms_lob.writeappend(l_metadata_xml,LENGTH(l_xmlString),l_xmlString);

386: END LOOP;
387:
388: l_xmlString := ' ';
389: l_xmlString := l_xmlString || ' ' ||l_bal_cols_present||' ';
390: dbms_lob.writeappend(l_metadata_xml,LENGTH(l_xmlString),l_xmlString);
391:
392:
393:
394: dbms_lob.erase(selectClause,l_eraseamt,dbms_lob.getlength(selectClause)-2);

Line 394: dbms_lob.erase(selectClause,l_eraseamt,dbms_lob.getlength(selectClause)-2);

390: dbms_lob.writeappend(l_metadata_xml,LENGTH(l_xmlString),l_xmlString);
391:
392:
393:
394: dbms_lob.erase(selectClause,l_eraseamt,dbms_lob.getlength(selectClause)-2);
395:
396: /**************************************************
397: Prepare the final query
398: **************************************************/

Line 408: dbms_lob.writeappend(l_query,LENGTH(l_queryString),l_queryString);

404:
405: --l_query := 'SELECT ' || selectclause || ' FROM ' || l_tablename || ' a';
406:
407: l_queryString := 'SELECT ';
408: dbms_lob.writeappend(l_query,LENGTH(l_queryString),l_queryString);
409: --fnd_file.put_line(fnd_file.log,'After appending to l_query');
410: dbms_lob.append(l_query,selectClause);
411: l_queryString := ' FROM ' || l_tablename || ' a';
412: dbms_lob.writeappend(l_query,LENGTH(l_queryString),l_queryString);

Line 410: dbms_lob.append(l_query,selectClause);

406:
407: l_queryString := 'SELECT ';
408: dbms_lob.writeappend(l_query,LENGTH(l_queryString),l_queryString);
409: --fnd_file.put_line(fnd_file.log,'After appending to l_query');
410: dbms_lob.append(l_query,selectClause);
411: l_queryString := ' FROM ' || l_tablename || ' a';
412: dbms_lob.writeappend(l_query,LENGTH(l_queryString),l_queryString);
413:
414: IF whereClause IS NOT NULL THEN

Line 412: dbms_lob.writeappend(l_query,LENGTH(l_queryString),l_queryString);

408: dbms_lob.writeappend(l_query,LENGTH(l_queryString),l_queryString);
409: --fnd_file.put_line(fnd_file.log,'After appending to l_query');
410: dbms_lob.append(l_query,selectClause);
411: l_queryString := ' FROM ' || l_tablename || ' a';
412: dbms_lob.writeappend(l_query,LENGTH(l_queryString),l_queryString);
413:
414: IF whereClause IS NOT NULL THEN
415: --l_query := l_query ||' WHERE ' || whereClause;
416: l_queryString := ' WHERE ';

Line 417: dbms_lob.writeappend(l_query,LENGTH(l_queryString),l_queryString);

413:
414: IF whereClause IS NOT NULL THEN
415: --l_query := l_query ||' WHERE ' || whereClause;
416: l_queryString := ' WHERE ';
417: dbms_lob.writeappend(l_query,LENGTH(l_queryString),l_queryString);
418: dbms_lob.append(l_query,whereClause);
419: END IF;
420:
421:

Line 418: dbms_lob.append(l_query,whereClause);

414: IF whereClause IS NOT NULL THEN
415: --l_query := l_query ||' WHERE ' || whereClause;
416: l_queryString := ' WHERE ';
417: dbms_lob.writeappend(l_query,LENGTH(l_queryString),l_queryString);
418: dbms_lob.append(l_query,whereClause);
419: END IF;
420:
421:
422:

Line 450: dbms_lob.writeappend(l_query,LENGTH(l_queryString),l_queryString);

446: END LOOP;
447:
448: IF(l_order_by_added = 'Y') THEN
449: l_queryString := SUBSTR(l_queryString, 1, LENGTH(l_queryString) - 1);
450: dbms_lob.writeappend(l_query,LENGTH(l_queryString),l_queryString);
451: END IF;
452:
453: fnd_file.put_line(fnd_file.log, 'The final query : ');
454: --fnd_file.put_line(fnd_file.log,l_query);

Line 470: l_data_size := dbms_lob.getlength(l_xmlResult);

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';
473: else
474: l_data_present := 'No';

Line 478: dbms_lob.writeappend(l_metadata_xml,LENGTH(l_xmlString),l_xmlString);

474: l_data_present := 'No';
475: end if;
476:
477: l_xmlString := ' ' || l_data_present || '';
478: dbms_lob.writeappend(l_metadata_xml,LENGTH(l_xmlString),l_xmlString);
479:
480:
481: /**************************************************
482: Add result xml to metadata xml after removing the processing instruction.

Line 485: dbms_lob.erase(l_xmlResult,P_INSTN_AMT,1);

481: /**************************************************
482: Add result xml to metadata xml after removing the processing instruction.
483: metadata xml is your final clob.
484: **************************************************/
485: dbms_lob.erase(l_xmlResult,P_INSTN_AMT,1);
486: dbms_lob.write(l_xmlResult,P_INSTN_AMT,1,'');
487: dbms_lob.append(l_metadata_xml,l_xmlResult);
488:
489: --Close off. l_metadata_xml is your final clob.

Line 486: dbms_lob.write(l_xmlResult,P_INSTN_AMT,1,'');

482: Add result xml to metadata xml after removing the processing instruction.
483: metadata xml is your final clob.
484: **************************************************/
485: dbms_lob.erase(l_xmlResult,P_INSTN_AMT,1);
486: dbms_lob.write(l_xmlResult,P_INSTN_AMT,1,'');
487: dbms_lob.append(l_metadata_xml,l_xmlResult);
488:
489: --Close off. l_metadata_xml is your final clob.
490: l_xmlString := '';

Line 487: dbms_lob.append(l_metadata_xml,l_xmlResult);

483: metadata xml is your final clob.
484: **************************************************/
485: dbms_lob.erase(l_xmlResult,P_INSTN_AMT,1);
486: dbms_lob.write(l_xmlResult,P_INSTN_AMT,1,'');
487: dbms_lob.append(l_metadata_xml,l_xmlResult);
488:
489: --Close off. l_metadata_xml is your final clob.
490: l_xmlString := '';
491: dbms_lob.writeappend(l_metadata_xml,LENGTH(l_xmlString),l_xmlString);

Line 491: dbms_lob.writeappend(l_metadata_xml,LENGTH(l_xmlString),l_xmlString);

487: dbms_lob.append(l_metadata_xml,l_xmlResult);
488:
489: --Close off. l_metadata_xml is your final clob.
490: l_xmlString := '';
491: dbms_lob.writeappend(l_metadata_xml,LENGTH(l_xmlString),l_xmlString);
492:
493:
494: l_clob_size := dbms_lob.getlength(l_metadata_xml);
495: l_offset := 1;

Line 494: l_clob_size := dbms_lob.getlength(l_metadata_xml);

490: l_xmlString := '';
491: dbms_lob.writeappend(l_metadata_xml,LENGTH(l_xmlString),l_xmlString);
492:
493:
494: l_clob_size := dbms_lob.getlength(l_metadata_xml);
495: l_offset := 1;
496: l_chunk_size := 3000;
497:
498: WHILE (l_clob_size > 0) LOOP

Line 500: l_chunk := dbms_lob.substr (l_metadata_xml, l_chunk_size, l_offset);

496: l_chunk_size := 3000;
497:
498: WHILE (l_clob_size > 0) LOOP
499:
500: l_chunk := dbms_lob.substr (l_metadata_xml, l_chunk_size, l_offset);
501: --fnd_file.put_line(fnd_file.log,l_chunk);
502: fnd_file.put(
503: which => fnd_file.output,
504: buff => l_chunk);

Line 519: dbms_lob.freetemporary(selectClause);

515: p_module => g_block||'.Generate_XML()',
516: p_msg_text => 'END');
517:
518:
519: dbms_lob.freetemporary(selectClause);
520: dbms_lob.freetemporary(l_query);
521: dbms_lob.freetemporary(l_metadata_xml);
522:
523: EXCEPTION

Line 520: dbms_lob.freetemporary(l_query);

516: p_msg_text => 'END');
517:
518:
519: dbms_lob.freetemporary(selectClause);
520: dbms_lob.freetemporary(l_query);
521: dbms_lob.freetemporary(l_metadata_xml);
522:
523: EXCEPTION
524: WHEN OTHERS THEN

Line 521: dbms_lob.freetemporary(l_metadata_xml);

517:
518:
519: dbms_lob.freetemporary(selectClause);
520: dbms_lob.freetemporary(l_query);
521: dbms_lob.freetemporary(l_metadata_xml);
522:
523: EXCEPTION
524: WHEN OTHERS THEN
525: fnd_file.put_line(fnd_file.log,sqlerrm);

Line 706: dbms_lob.createtemporary(selectClause,TRUE);

702: END IF;
703:
704: fnd_file.put_line(fnd_file.log,'Condition predicate is:' || whereClause);
705:
706: dbms_lob.createtemporary(selectClause,TRUE);
707: dbms_lob.createtemporary(l_query,TRUE);
708: l_queryString := 'SELECT ';
709: dbms_lob.writeappend(selectClause,LENGTH(l_queryString),l_queryString);
710:

Line 707: dbms_lob.createtemporary(l_query,TRUE);

703:
704: fnd_file.put_line(fnd_file.log,'Condition predicate is:' || whereClause);
705:
706: dbms_lob.createtemporary(selectClause,TRUE);
707: dbms_lob.createtemporary(l_query,TRUE);
708: l_queryString := 'SELECT ';
709: dbms_lob.writeappend(selectClause,LENGTH(l_queryString),l_queryString);
710:
711: FOR row_record in get_required_columns_cursor LOOP

Line 709: dbms_lob.writeappend(selectClause,LENGTH(l_queryString),l_queryString);

705:
706: dbms_lob.createtemporary(selectClause,TRUE);
707: dbms_lob.createtemporary(l_query,TRUE);
708: l_queryString := 'SELECT ';
709: dbms_lob.writeappend(selectClause,LENGTH(l_queryString),l_queryString);
710:
711: FOR row_record in get_required_columns_cursor LOOP
712:
713: --Bug#6174477: Change the query as per view option

Line 731: dbms_lob.writeappend(selectClause,LENGTH(l_queryString),l_queryString);

727: l_queryString := row_record.COLUMN_NAME || ' , ';
728:
729: END IF;
730:
731: dbms_lob.writeappend(selectClause,LENGTH(l_queryString),l_queryString);
732:
733: END LOOP;
734:
735: dbms_lob.erase(selectClause,l_eraseamt,dbms_lob.getlength(selectClause)-2);

Line 735: dbms_lob.erase(selectClause,l_eraseamt,dbms_lob.getlength(selectClause)-2);

731: dbms_lob.writeappend(selectClause,LENGTH(l_queryString),l_queryString);
732:
733: END LOOP;
734:
735: dbms_lob.erase(selectClause,l_eraseamt,dbms_lob.getlength(selectClause)-2);
736:
737: /** Prepare the final Query**/
738:
739: dbms_lob.append(l_query,selectClause);

Line 739: dbms_lob.append(l_query,selectClause);

735: dbms_lob.erase(selectClause,l_eraseamt,dbms_lob.getlength(selectClause)-2);
736:
737: /** Prepare the final Query**/
738:
739: dbms_lob.append(l_query,selectClause);
740: l_queryString := ' FROM ' || l_tablename || ' a';
741: dbms_lob.writeappend(l_query,LENGTH(l_queryString),l_queryString);
742: /**************************************************
743: Add Condition clause.

Line 741: dbms_lob.writeappend(l_query,LENGTH(l_queryString),l_queryString);

737: /** Prepare the final Query**/
738:
739: dbms_lob.append(l_query,selectClause);
740: l_queryString := ' FROM ' || l_tablename || ' a';
741: dbms_lob.writeappend(l_query,LENGTH(l_queryString),l_queryString);
742: /**************************************************
743: Add Condition clause.
744: **************************************************/
745:

Line 748: dbms_lob.writeappend(l_query,LENGTH(l_queryString),l_queryString);

744: **************************************************/
745:
746: IF whereClause IS NOT NULL THEN
747: l_queryString := ' WHERE ';
748: dbms_lob.writeappend(l_query,LENGTH(l_queryString),l_queryString);
749: dbms_lob.append(l_query,whereClause);
750: END IF;
751:
752: /**************************************************

Line 749: dbms_lob.append(l_query,whereClause);

745:
746: IF whereClause IS NOT NULL THEN
747: l_queryString := ' WHERE ';
748: dbms_lob.writeappend(l_query,LENGTH(l_queryString),l_queryString);
749: dbms_lob.append(l_query,whereClause);
750: END IF;
751:
752: /**************************************************
753: Add Order by Clause

Line 778: dbms_lob.writeappend(l_query,LENGTH(l_queryString),l_queryString);

774: END LOOP;
775:
776: IF(l_order_by_added = 'Y') THEN
777: l_queryString := SUBSTR(l_queryString, 1, LENGTH(l_queryString) - 1);
778: dbms_lob.writeappend(l_query,LENGTH(l_queryString),l_queryString);
779: END IF;
780:
781: ELSE
782:

Line 802: l_clob_size := dbms_lob.getlength(l_xmlResult);

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;
805:
806: WHILE (l_clob_size > 0) LOOP

Line 808: l_chunk := dbms_lob.substr (l_xmlResult, l_chunk_size, l_offset);

804: l_chunk_size := 3000;
805:
806: WHILE (l_clob_size > 0) LOOP
807:
808: l_chunk := dbms_lob.substr (l_xmlResult, l_chunk_size, l_offset);
809: --fnd_file.put_line(fnd_file.log,l_chunk);
810: fnd_file.put(
811: which => fnd_file.output,
812: buff => l_chunk);

Line 826: dbms_lob.freetemporary(selectClause);

822:
823: fem_engines_pkg.tech_message (p_severity => g_log_level_1,
824: p_module => g_block||'.Generate_Cust_XML()',
825: p_msg_text => 'END');
826: dbms_lob.freetemporary(selectClause);
827: dbms_lob.freetemporary(l_query);
828:
829:
830: EXCEPTION

Line 827: dbms_lob.freetemporary(l_query);

823: fem_engines_pkg.tech_message (p_severity => g_log_level_1,
824: p_module => g_block||'.Generate_Cust_XML()',
825: p_msg_text => 'END');
826: dbms_lob.freetemporary(selectClause);
827: dbms_lob.freetemporary(l_query);
828:
829:
830: EXCEPTION
831: WHEN OTHERS THEN