DBA Data[Home] [Help]

APPS.ISC_FS_TRV_TIM_DIS_RPT_PKG dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 13: , p_param in bis_pmv_page_parameter_tbl

9: g_trd_rep_func constant varchar2(100) := 'ISC_FS_TRV_TIM_DIS_TRD_REP';
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

Line 193: ( p_param in bis_pmv_page_parameter_tbl

189:
190: end get_fact_mv_name;
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

Line 469: ( p_param in bis_pmv_page_parameter_tbl

465:
466: -----start of detailed report ------------------------------------------
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

Line 762: ( p_param in bis_pmv_page_parameter_tbl

758: end get_dtl_sql; -- the detail query ends here
759:
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

Line 957: ( p_param in bis_pmv_page_parameter_tbl

953:
954: end get_trd_sql;
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

Line 1137: ( p_param in bis_pmv_page_parameter_tbl

1133:
1134: end get_tot_trd_sql;
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

Line 1375: ( p_param in bis_pmv_page_parameter_tbl

1371:
1372: end get_time_bucket_sql;
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