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.FA_XML_REPORT_PKG dependencies on DBMS_XMLGEN

Line 138: l_qryCtx DBMS_XMLGEN.ctxHandle;

134: p_cash_gen_unit_id IN NUMBER, -- opt
135: p_request_id IN NUMBER, -- opt, not displayed
136: p_status IN VARCHAR2 ) IS -- opt, not displayed
137:
138: l_qryCtx DBMS_XMLGEN.ctxHandle;
139: l_result_clob CLOB;
140: l_calling_fn varchar2(200);
141: l_debug_info varchar2(200);
142:

Line 433: l_qryCtx := DBMS_XMLGEN.newContext(

429: r_CGU_id := r_CASH_GENERATING_UNIT_id;
430: end if;
431: -- Bug#6666666 SORP Start
432: /*Bug# 9182681 - Modified query to group by CGU*/
433: l_qryCtx := DBMS_XMLGEN.newContext(
434: 'SELECT AD.ASSET_NUMBER
435: ,ITF.COST
436: ,(ITF.NET_BOOK_VALUE - (ITF.IMPAIRMENT_AMOUNT + nvl(ITF.REVAL_RESERVE_ADJ_AMOUNT,0))) NEW_NBV
437: ,ITF.NET_BOOK_VALUE OLD_NBV

Line 476: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'ASSET_SET');

472: AND IMP.STATUS = nvl( '''||p_status||''', ''POSTED''))
473: ORDER BY AD.ASSET_NUMBER'
474: );
475: -- Bug#6666666 SORP END
476: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'ASSET_SET');
477: DBMS_XMLGEN.setRowTag(l_qryCtx, 'ASSET_RECORD');
478: -- setBindValue doesn't work for 11i
479: --
480: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);

Line 477: DBMS_XMLGEN.setRowTag(l_qryCtx, 'ASSET_RECORD');

473: ORDER BY AD.ASSET_NUMBER'
474: );
475: -- Bug#6666666 SORP END
476: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'ASSET_SET');
477: DBMS_XMLGEN.setRowTag(l_qryCtx, 'ASSET_RECORD');
478: -- setBindValue doesn't work for 11i
479: --
480: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
481: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);

Line 480: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);

476: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'ASSET_SET');
477: DBMS_XMLGEN.setRowTag(l_qryCtx, 'ASSET_RECORD');
478: -- setBindValue doesn't work for 11i
479: --
480: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
481: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
482: l_temp_asset_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);
483: l_asset_count := l_asset_count + l_temp_asset_count;
484: DBMS_XMLGEN.closeContext(l_qryCtx);

Line 482: l_temp_asset_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);

478: -- setBindValue doesn't work for 11i
479: --
480: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
481: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
482: l_temp_asset_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);
483: l_asset_count := l_asset_count + l_temp_asset_count;
484: DBMS_XMLGEN.closeContext(l_qryCtx);
485: clob_to_file(l_result_clob);
486:

Line 484: DBMS_XMLGEN.closeContext(l_qryCtx);

480: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
481: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
482: l_temp_asset_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);
483: l_asset_count := l_asset_count + l_temp_asset_count;
484: DBMS_XMLGEN.closeContext(l_qryCtx);
485: clob_to_file(l_result_clob);
486:
487: put_endtag('IMPAIRMENT_RECORD');
488:

Line 561: l_qryCtx DBMS_XMLGEN.ctxHandle;

557: p_set_of_books_id IN NUMBER,
558: p_cash_gen_unit_id IN NUMBER,
559: p_asset_id IN NUMBER ) IS
560:
561: l_qryCtx DBMS_XMLGEN.ctxHandle;
562: l_result_clob CLOB;
563: l_calling_fn varchar2(200);
564: l_debug_info varchar2(200);
565:

Line 728: l_qryCtx := DBMS_XMLGEN.newContext(

724: else
725: r_asset_id_text := to_char(p_asset_id);
726: end if;
727:
728: l_qryCtx := DBMS_XMLGEN.newContext(
729: 'select ad.asset_number as asset_number
730: ,bk.cost as cost
731: ,bk.cost - ds.deprn_reserve - ds.impairment_reserve as net_book_value
732: ,ds.impairment_reserve as accumulated_impairment

Line 753: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'ASSET_SET');

749: )
750: order by ad.asset_number'
751: );
752:
753: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'ASSET_SET');
754: DBMS_XMLGEN.setRowTag(l_qryCtx, 'ASSET_RECORD');
755: -- fyi: setBindValue doesn't work for 11i
756: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
757: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);

Line 754: DBMS_XMLGEN.setRowTag(l_qryCtx, 'ASSET_RECORD');

750: order by ad.asset_number'
751: );
752:
753: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'ASSET_SET');
754: DBMS_XMLGEN.setRowTag(l_qryCtx, 'ASSET_RECORD');
755: -- fyi: setBindValue doesn't work for 11i
756: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
757: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
758: l_temp_asset_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);

Line 756: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);

752:
753: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'ASSET_SET');
754: DBMS_XMLGEN.setRowTag(l_qryCtx, 'ASSET_RECORD');
755: -- fyi: setBindValue doesn't work for 11i
756: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
757: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
758: l_temp_asset_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);
759: l_asset_count := l_asset_count + l_temp_asset_count;
760: DBMS_XMLGEN.closeContext(l_qryCtx);

Line 758: l_temp_asset_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);

754: DBMS_XMLGEN.setRowTag(l_qryCtx, 'ASSET_RECORD');
755: -- fyi: setBindValue doesn't work for 11i
756: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
757: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
758: l_temp_asset_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);
759: l_asset_count := l_asset_count + l_temp_asset_count;
760: DBMS_XMLGEN.closeContext(l_qryCtx);
761: clob_to_file(l_result_clob);
762:

Line 760: DBMS_XMLGEN.closeContext(l_qryCtx);

756: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
757: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
758: l_temp_asset_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);
759: l_asset_count := l_asset_count + l_temp_asset_count;
760: DBMS_XMLGEN.closeContext(l_qryCtx);
761: clob_to_file(l_result_clob);
762:
763: put_endtag('CASH_GEN_UNIT_RECORD');
764: