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_TRV_TIM_DIS_RPT_PKG dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 14: , p_custom_output in out NOCOPY bis_query_attributes_tbl

10:
11: function get_fact_mv_name
12: ( p_report_type in varchar2
13: , p_param in bis_pmv_page_parameter_tbl
14: , p_custom_output in out NOCOPY bis_query_attributes_tbl
15: )
16: return varchar2
17: is
18:

Line 195: , x_custom_output out nocopy bis_query_attributes_tbl

191:
192: procedure get_tbl_sql
193: ( p_param in bis_pmv_page_parameter_tbl
194: , x_custom_sql out nocopy varchar2
195: , x_custom_output out nocopy bis_query_attributes_tbl
196: )
197: is
198:
199: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;

Line 214: l_custom_output bis_query_attributes_tbl;

210: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
211:
212: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
213:
214: l_custom_output bis_query_attributes_tbl;
215: l_cost_element varchar2(200);
216: l_curr_suffix varchar2(2);
217: l_to_date_type varchar2(100);
218: l_viewby_select varchar2(400); -- needed to be increased from 200

Line 471: , x_custom_output out nocopy bis_query_attributes_tbl

467:
468: procedure get_dtl_sql
469: ( p_param in bis_pmv_page_parameter_tbl
470: , x_custom_sql out nocopy varchar2
471: , x_custom_output out nocopy bis_query_attributes_tbl
472: )
473: as
474:
475: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;

Line 477: l_custom_output bis_query_attributes_tbl;

473: as
474:
475: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;
476: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
477: l_custom_output bis_query_attributes_tbl;
478: l_curr_suffix varchar2(3);
479: l_where_clause varchar2(10000);
480: l_viewby_select varchar2(400); -- needed to be increased from 200
481: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

Line 764: , x_custom_output out nocopy bis_query_attributes_tbl

760: -------------------------trend query--------------------------------------------
761: procedure get_trd_sql
762: ( p_param in bis_pmv_page_parameter_tbl
763: , x_custom_sql out nocopy varchar2
764: , x_custom_output out nocopy bis_query_attributes_tbl
765: )
766: is
767:
768: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;

Line 770: l_custom_output bis_query_attributes_tbl;

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

Line 959: , x_custom_output out nocopy bis_query_attributes_tbl

955:
956: procedure get_tot_trd_sql
957: ( p_param in bis_pmv_page_parameter_tbl
958: , x_custom_sql out nocopy varchar2
959: , x_custom_output out nocopy bis_query_attributes_tbl
960: )
961: is
962:
963: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;

Line 965: l_custom_output bis_query_attributes_tbl;

961: is
962:
963: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;
964: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
965: l_custom_output bis_query_attributes_tbl;
966: l_curr_suffix varchar2(3);
967: l_where_clause varchar2(10000);
968: l_viewby_select varchar2(400); -- needed to be increased from 200
969: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

Line 1139: , x_custom_output out nocopy bis_query_attributes_tbl

1135:
1136: procedure get_time_bucket_sql
1137: ( p_param in bis_pmv_page_parameter_tbl
1138: , x_custom_sql out nocopy varchar2
1139: , x_custom_output out nocopy bis_query_attributes_tbl
1140: )
1141: is
1142:
1143: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;

Line 1145: l_custom_output bis_query_attributes_tbl;

1141: is
1142:
1143: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;
1144: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
1145: l_custom_output bis_query_attributes_tbl;
1146: l_curr_suffix varchar2(3);
1147: l_where_clause varchar2(10000);
1148: l_viewby_select varchar2(400); -- needed to be increased from 200
1149: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

Line 1377: , x_custom_output out nocopy bis_query_attributes_tbl

1373:
1374: procedure get_distance_bucket_sql
1375: ( p_param in bis_pmv_page_parameter_tbl
1376: , x_custom_sql out nocopy varchar2
1377: , x_custom_output out nocopy bis_query_attributes_tbl
1378: )
1379: is
1380:
1381: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;

Line 1383: l_custom_output bis_query_attributes_tbl;

1379: is
1380:
1381: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;
1382: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
1383: l_custom_output bis_query_attributes_tbl;
1384: l_curr_suffix varchar2(3);
1385: l_where_clause varchar2(10000);
1386: l_viewby_select varchar2(400); -- needed to be increased from 200
1387: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;