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_TASK_BAC_AGING_RPT_PKG dependencies on POA_DBI_UTIL_PKG

Line 450: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;

446: )
447: is
448:
449: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;
450: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
451: l_custom_output bis_query_attributes_tbl;
452: l_curr_suffix varchar2(3);
453: l_where_clause varchar2(10000);
454: l_viewby_select varchar2(400); -- needed to be increased from 200

Line 455: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

451: l_custom_output bis_query_attributes_tbl;
452: l_curr_suffix varchar2(3);
453: l_where_clause varchar2(10000);
454: l_viewby_select varchar2(400); -- needed to be increased from 200
455: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
456: l_dim_bmap number;
457: l_comparison_type varchar2(200);
458: l_xtd varchar2(200);
459: l_mv varchar2(10000);

Line 460: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

456: l_dim_bmap number;
457: l_comparison_type varchar2(200);
458: l_xtd varchar2(200);
459: l_mv varchar2(10000);
460: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
461: l_view_by varchar2(200);
462: l_product varchar2(200);
463: l_stmt varchar2(32700);
464: l_to_date_type varchar2(200);

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

511: , l_dim_bmap
512: , l_custom_output
513: );
514:
515: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
516:
517: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
518: , p_col_name => 'backlog_count'
519: , p_alias_name => 'backlog'

Line 517: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl

513: );
514:
515: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
516:
517: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
518: , p_col_name => 'backlog_count'
519: , p_alias_name => 'backlog'
520: , p_to_date_type => 'BAL'
521: );

Line 523: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl

519: , p_alias_name => 'backlog'
520: , p_to_date_type => 'BAL'
521: );
522:
523: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
524: , p_col_name => 'total_backlog_age'
525: , p_alias_name => 'backlog_age'
526: , p_to_date_type => 'BAL'
527: );

Line 529: poa_dbi_util_pkg.add_bucket_columns

525: , p_alias_name => 'backlog_age'
526: , p_to_date_type => 'BAL'
527: );
528:
529: poa_dbi_util_pkg.add_bucket_columns
530: ( p_short_name => 'BIV_FS_BACKLOG_AGING'
531: , p_col_tbl => l_col_tbl
532: , p_col_name => 'backlog_age'
533: , p_alias_name => 'backlog'

Line 534: , p_prior_code => poa_dbi_util_pkg.no_priors

530: ( p_short_name => 'BIV_FS_BACKLOG_AGING'
531: , p_col_tbl => l_col_tbl
532: , p_col_name => 'backlog_age'
533: , p_alias_name => 'backlog'
534: , p_prior_code => poa_dbi_util_pkg.no_priors
535: , p_to_date_type => 'BAL'
536: , x_bucket_rec => l_bucket_rec
537: );
538:

Line 547: ' || poa_dbi_util_pkg.get_bucket_outer_query

543: , ISC_MEASURE_3
544: , ISC_MEASURE_4
545: , ISC_MEASURE_5
546: , ISC_MEASURE_6
547: ' || poa_dbi_util_pkg.get_bucket_outer_query
548: ( p_bucket_rec => l_bucket_rec
549: , p_col_name => 'ISC_MEASURE_7'
550: , p_alias_name => 'ISC_MEASURE_7'
551: , p_prefix => null

Line 561: ' || poa_dbi_util_pkg.get_bucket_outer_query

557: , ISC_MEASURE_23
558: , ISC_MEASURE_24
559: , ISC_MEASURE_25
560: , ISC_MEASURE_26
561: ' || poa_dbi_util_pkg.get_bucket_outer_query
562: ( p_bucket_rec => l_bucket_rec
563: , p_col_name => 'ISC_MEASURE_27'
564: , p_alias_name => 'ISC_MEASURE_27'
565: , p_prefix => null

Line 627: ' || poa_dbi_util_pkg.get_bucket_outer_query

623: )
624: , 'ISC_MEASURE_6'
625: , 'N'
626: ) || '
627: ' || poa_dbi_util_pkg.get_bucket_outer_query
628: ( p_bucket_rec => l_bucket_rec
629: , p_col_name => 'backlog'
630: , p_alias_name => 'ISC_MEASURE_7'
631: , p_prefix => 'nvl(c_'

Line 669: ' || poa_dbi_util_pkg.get_bucket_outer_query

665: )
666: , 'ISC_MEASURE_26'
667: , 'N'
668: ) || '
669: ' || poa_dbi_util_pkg.get_bucket_outer_query
670: ( p_bucket_rec => l_bucket_rec
671: , p_col_name => 'backlog'
672: , p_alias_name => 'ISC_MEASURE_27'
673: , p_prefix => 'nvl(c_'

Line 690: poa_dbi_util_pkg.get_custom_balance_binds

686: , p_filter_where => '(isc_measure_1 >0 or isc_measure_2>0)) iset '
687: , p_generate_viewby => 'Y'
688: );
689:
690: poa_dbi_util_pkg.get_custom_balance_binds
691: ( p_custom_output => l_custom_output
692: , p_balance_fact => isc_fs_task_act_bac_etl_pkg.g_object_name
693: , p_xtd => l_xtd
694: );

Line 722: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;

718: )
719: is
720:
721: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;
722: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
723: l_custom_output bis_query_attributes_tbl;
724: l_curr_suffix varchar2(3);
725: l_where_clause varchar2(10000);
726: l_viewby_select varchar2(400); -- needed to be increased from 200

Line 727: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

723: l_custom_output bis_query_attributes_tbl;
724: l_curr_suffix varchar2(3);
725: l_where_clause varchar2(10000);
726: l_viewby_select varchar2(400); -- needed to be increased from 200
727: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
728: l_dim_bmap number;
729: l_comparison_type varchar2(200);
730: l_xtd varchar2(200);
731: l_mv varchar2(10000);

Line 732: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

728: l_dim_bmap number;
729: l_comparison_type varchar2(200);
730: l_xtd varchar2(200);
731: l_mv varchar2(10000);
732: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
733: l_stmt varchar2(32767);
734: l_to_date_type varchar2(200);
735:
736: begin

Line 850: , ' || poa_dbi_util_pkg.get_calendar_table

846: group by
847: n.start_date
848: , n.report_date
849: ) i
850: , ' || poa_dbi_util_pkg.get_calendar_table
851: ( period_type => l_xtd
852: , p_include_prior => 'N'
853: ) || ' n
854: where i.start_date(+) = n.start_date

Line 859: , ' || poa_dbi_util_pkg.get_calendar_table

855: and n.start_date between &ISC_FS_PREV_REPORT_START_DATE and &ISC_FS_CURRENT_ASOF_DATE
856: group by
857: n.start_date
858: ) iset
859: , ' || poa_dbi_util_pkg.get_calendar_table
860: ( period_type => l_xtd
861: , p_include_prior => 'N'
862: ) || ' cal
863: where cal.start_date between &ISC_FS_CURR_REPORT_START_DATE and &ISC_FS_CURRENT_ASOF_DATE

Line 901: poa_dbi_util_pkg.get_custom_balance_binds

897: -- l_stmt := l_stmt || isc_fs_rpt_util_pkg.dump_parameters(p_param);
898:
899: x_custom_sql := l_stmt;
900:
901: poa_dbi_util_pkg.get_custom_balance_binds
902: ( p_custom_output => l_custom_output
903: , p_balance_fact => isc_fs_task_act_bac_etl_pkg.g_object_name
904: , p_xtd => l_xtd
905: );

Line 915: poa_dbi_util_pkg.get_custom_trend_binds

911: );
912:
913: x_custom_output := l_custom_output;
914:
915: poa_dbi_util_pkg.get_custom_trend_binds
916: ( p_xtd => l_xtd
917: , p_comparison_type => l_comparison_type
918: , x_custom_output => l_custom_output
919: );

Line 938: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;

934: )
935: as
936:
937: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;
938: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
939: l_custom_output bis_query_attributes_tbl;
940: l_curr_suffix varchar2(3);
941: l_where_clause varchar2(10000);
942: l_viewby_select varchar2(400); -- needed to be increased from 200

Line 943: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

939: l_custom_output bis_query_attributes_tbl;
940: l_curr_suffix varchar2(3);
941: l_where_clause varchar2(10000);
942: l_viewby_select varchar2(400); -- needed to be increased from 200
943: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
944: l_dim_bmap number;
945: l_comparison_type varchar2(200);
946: l_xtd varchar2(200);
947: l_mv varchar2(10000);

Line 949: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

945: l_comparison_type varchar2(200);
946: l_xtd varchar2(200);
947: l_mv varchar2(10000);
948: l_cost_element varchar2(200);
949: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
950: l_stmt varchar2(32767);
951: l_rank_order varchar2(200);
952: l_detail_col_tbl isc_fs_rpt_util_pkg.t_detail_column_tbl;
953: l_order_by varchar2(200);

Line 1159: poa_dbi_util_pkg.get_custom_balance_binds

1155: , p_rank_order => l_rank_order
1156: , p_override_date_clause => 'backlog_date_to = to_date(''4712/12/31'',''yyyy/mm/dd'') and age_days between &ISC_FS_LOW and &ISC_FS_HIGH'
1157: );
1158:
1159: poa_dbi_util_pkg.get_custom_balance_binds
1160: ( p_custom_output => l_custom_output
1161: , p_balance_fact => isc_fs_task_act_bac_etl_pkg.g_object_name
1162: , p_xtd => l_xtd
1163: );