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.ISC_FS_FTFR_RPT_PKG dependencies on POA_DBI_UTIL_PKG

Line 313: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;

309: )
310: is
311:
312: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;
313: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
314: l_custom_output bis_query_attributes_tbl;
315: l_curr_suffix varchar2(3);
316: l_where_clause varchar2(10000);
317: l_viewby_select varchar2(400); -- needed to be increased from 200

Line 318: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

314: l_custom_output bis_query_attributes_tbl;
315: l_curr_suffix varchar2(3);
316: l_where_clause varchar2(10000);
317: l_viewby_select varchar2(400); -- needed to be increased from 200
318: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
319: l_dim_bmap number;
320: l_comparison_type varchar2(200);
321: l_xtd varchar2(200);
322: l_mv varchar2(10000);

Line 323: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

319: l_dim_bmap number;
320: l_comparison_type varchar2(200);
321: l_xtd varchar2(200);
322: l_mv varchar2(10000);
323: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
324: l_view_by varchar2(200);
325: l_product varchar2(50);
326: l_stmt varchar2(32700);
327: l_to_date_type varchar2(200);

Line 380: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();

376: , l_dim_bmap
377: , l_custom_output
378: );
379:
380: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
381:
382: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
383: , p_col_name => 'ftf_count'
384: , p_alias_name => 'ftf_count'

Line 382: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl

378: );
379:
380: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
381:
382: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
383: , p_col_name => 'ftf_count'
384: , p_alias_name => 'ftf_count'
385: , p_to_date_type => l_to_date_type
386: );

Line 388: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl

384: , p_alias_name => 'ftf_count'
385: , p_to_date_type => l_to_date_type
386: );
387:
388: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
389: , p_col_name => 'non_ftf_count'
390: , p_alias_name => 'non_ftf_count'
391: , p_to_date_type => l_to_date_type
392: );

Line 394: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl

390: , p_alias_name => 'non_ftf_count'
391: , p_to_date_type => l_to_date_type
392: );
393:
394: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
395: , p_col_name => 'sr_count'
396: , p_alias_name => 'sr_count'
397: , p_to_date_type => l_to_date_type
398: );

Line 589: poa_dbi_util_pkg.get_custom_rolling_binds

585:
586: -- the next line can be used to dump the contents of the PMV parameters as comments into stmt
587: -- l_stmt := l_stmt || isc_fs_rpt_util_pkg.dump_parameters(p_param);
588:
589: poa_dbi_util_pkg.get_custom_rolling_binds
590: ( p_custom_output => l_custom_output
591: , p_xtd => l_xtd
592: );
593:

Line 608: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;

604: )
605: is
606:
607: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;
608: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
609: l_custom_output bis_query_attributes_tbl;
610: l_curr_suffix varchar2(3);
611: l_where_clause varchar2(10000);
612: l_viewby_select varchar2(400); -- needed to be increased from 200

Line 613: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

609: l_custom_output bis_query_attributes_tbl;
610: l_curr_suffix varchar2(3);
611: l_where_clause varchar2(10000);
612: l_viewby_select varchar2(400); -- needed to be increased from 200
613: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
614: l_dim_bmap number;
615: l_comparison_type varchar2(200);
616: l_xtd varchar2(200);
617: l_mv varchar2(10000);

Line 618: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

614: l_dim_bmap number;
615: l_comparison_type varchar2(200);
616: l_xtd varchar2(200);
617: l_mv varchar2(10000);
618: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
619: l_stmt varchar2(32767);
620: l_to_date_type varchar2(200);
621:
622: begin

Line 664: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();

660: , l_dim_bmap
661: , l_custom_output
662: );
663:
664: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
665:
666: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
667: , p_col_name => 'ftf_count'
668: , p_alias_name => 'ftf_count'

Line 666: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl

662: );
663:
664: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
665:
666: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
667: , p_col_name => 'ftf_count'
668: , p_alias_name => 'ftf_count'
669: , p_to_date_type => l_to_date_type
670: , p_grand_total => 'N'

Line 673: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl

669: , p_to_date_type => l_to_date_type
670: , p_grand_total => 'N'
671: );
672:
673: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
674: , p_col_name => 'sr_count'
675: , p_alias_name => 'sr_count'
676: , p_to_date_type => l_to_date_type
677: , p_grand_total => 'N'

Line 738: poa_dbi_util_pkg.get_custom_rolling_binds

734: x_custom_sql := l_stmt;
735:
736: x_custom_output := l_custom_output;
737:
738: poa_dbi_util_pkg.get_custom_rolling_binds
739: ( p_custom_output => l_custom_output
740: , p_xtd => l_xtd
741: );
742:

Line 745: poa_dbi_util_pkg.get_custom_trend_binds

741: );
742:
743: x_custom_output := l_custom_output;
744:
745: poa_dbi_util_pkg.get_custom_trend_binds
746: ( x_custom_output => l_custom_output
747: , p_xtd => l_xtd
748: , p_comparison_type => l_comparison_type
749: );

Line 768: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;

764: )
765: as
766:
767: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;
768: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
769: l_custom_output bis_query_attributes_tbl;
770: l_curr_suffix varchar2(3);
771: l_where_clause varchar2(10000);
772: l_viewby_select varchar2(400); -- needed to be increased from 200

Line 773: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

769: l_custom_output bis_query_attributes_tbl;
770: l_curr_suffix varchar2(3);
771: l_where_clause varchar2(10000);
772: l_viewby_select varchar2(400); -- needed to be increased from 200
773: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
774: l_dim_bmap number;
775: l_comparison_type varchar2(200);
776: l_xtd varchar2(200);
777: l_mv varchar2(10000);

Line 779: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

775: l_comparison_type varchar2(200);
776: l_xtd varchar2(200);
777: l_mv varchar2(10000);
778: l_cost_element varchar2(200);
779: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
780: l_stmt varchar2(32767);
781: l_rank_order varchar2(200);
782: l_detail_col_tbl isc_fs_rpt_util_pkg.t_detail_column_tbl;
783: l_order_by varchar2(200);