DBA Data[Home] [Help]

APPS.BIV_DBI_TMPL_UTIL dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 724: ( p_param in bis_pmv_page_parameter_tbl )

720: return biv_dbi_tmpl_sec.get_type_sec_where_clause;
721: end get_type_sec_where_clause;
722:
723: function get_product_category
724: ( p_param in bis_pmv_page_parameter_tbl )
725: return varchar2
726: is
727: begin
728: for i in 1..p_param.count loop

Line 797: ( p_param in bis_pmv_page_parameter_tbl

793: -- PUBLIC PROCEDURES ARE HERE
794: -- ------------------------------------------------------------
795:
796: procedure process_parameters
797: ( p_param in bis_pmv_page_parameter_tbl
798: , p_report_type in varchar2 -- 'ACTIVITY','CLOSED','BACKLOG','BACKLOG_AGE'
799: , p_trend in varchar2
800: , x_view_by out nocopy varchar2
801: , x_view_by_col_name out nocopy varchar2

Line 881: ( p_param in bis_pmv_page_parameter_tbl )

877:
878: end process_parameters;
879:
880: function get_period_type
881: ( p_param in bis_pmv_page_parameter_tbl )
882: return varchar2
883: is
884: begin
885: for i in 1..p_param.count loop

Line 905: ( p_param in bis_pmv_page_parameter_tbl )

901: return null;
902: end get_period_type;
903:
904: function get_backlog_type
905: ( p_param in bis_pmv_page_parameter_tbl )
906: return varchar2
907: is
908: begin
909: for i in 1..p_param.count loop

Line 1193: ( p_param in bis_pmv_page_parameter_tbl )

1189: ' ' || p_column_alias;
1190: end rate_column;
1191:
1192: function dump_parameters
1193: ( p_param in bis_pmv_page_parameter_tbl )
1194: return varchar2
1195: is
1196: l_stmt varchar2(10000);
1197: begin

Line 1238: , p_param in bis_pmv_page_parameter_tbl

1234:
1235:
1236: procedure override_order_by
1237: ( p_view_by in varchar2
1238: , p_param in bis_pmv_page_parameter_tbl
1239: , p_stmt in out nocopy varchar2
1240: )
1241: is
1242: l_orderby varchar2(1000);

Line 1502: ( p_param in bis_pmv_page_parameter_tbl

1498:
1499: end bind_yes_no;
1500:
1501: procedure bind_low_high
1502: ( p_param in bis_pmv_page_parameter_tbl
1503: , p_short_name in varchar2
1504: , p_low in varchar2
1505: , p_high in varchar2
1506: , p_custom_output in out nocopy bis_query_attributes_tbl

Line 1597: ( p_param in bis_pmv_page_parameter_tbl

1593:
1594: end bind_low_high;
1595:
1596: procedure process_parameters
1597: ( p_param in bis_pmv_page_parameter_tbl
1598: , p_report_type in varchar2 -- 'BACKLOG_DETAIL', 'CLOSED_DETAIL', 'RESOLVED_DETAIL'
1599: , x_where_clause out nocopy varchar2
1600: , x_xtd out nocopy varchar2
1601: , x_mv out nocopy varchar2

Line 1638: ( p_param in bis_pmv_page_parameter_tbl )

1634:
1635: end process_parameters;
1636:
1637: function get_order_by
1638: ( p_param in bis_pmv_page_parameter_tbl )
1639: return varchar2
1640: is
1641:
1642: begin

Line 1652: ( p_param in bis_pmv_page_parameter_tbl

1648: return null;
1649: end get_order_by;
1650:
1651: procedure bind_age_dates
1652: ( p_param in bis_pmv_page_parameter_tbl
1653: , p_current_name in varchar2
1654: , p_prior_name in varchar2
1655: , p_custom_output in out nocopy bis_query_attributes_tbl
1656: )