APPS.POA_DBI_FR_PKG dependencies on BIS_BUCKET_PUB

Line 11: ,p_bucket_rec in BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE) return varchar2;

7: function get_summary_sel_clause(p_view_by_dim in varchar2
8: ,p_view_by_col in varchar2) return varchar2;
9: function get_amt_sql_sel_clause(p_view_by_dim in varchar2
10: ,p_view_by_col in varchar2
11: ,p_bucket_rec in BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE) return varchar2;
12: function get_req_age_sel_clause(p_view_by_dim in varchar2
13: ,p_view_by_col in varchar2
14: ,p_bucket_rec in BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE) return varchar2;
15: function get_trend_sel_clause return varchar2;

Line 14: ,p_bucket_rec in BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE) return varchar2;

10: ,p_view_by_col in varchar2
11: ,p_bucket_rec in BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE) return varchar2;
12: function get_req_age_sel_clause(p_view_by_dim in varchar2
13: ,p_view_by_col in varchar2
14: ,p_bucket_rec in BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE) return varchar2;
15: function get_trend_sel_clause return varchar2;
16: function get_amt_trend_sel_clause return varchar2;
17: function get_ped_trend_sel_clause return varchar2;
18: function get_status_filter_where(p_view_by in varchar2) return varchar2;

Line 566: l_bucket_rec bis_bucket_pub.bis_bucket_rec_type;

562: l_where_clause varchar2(2000);
563: l_mv varchar2(30);
564: l_view_by_value varchar2(30);
565: err_cde number;
566: l_bucket_rec bis_bucket_pub.bis_bucket_rec_type;
567: begin
568: l_comparison_type := 'Y';
569: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
570: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();

Line 646: , p_bucket_rec in BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE)

642: end;
643:
644: function get_amt_sql_sel_clause(p_view_by_dim in varchar2
645: , p_view_by_col in varchar2
646: , p_bucket_rec in BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE)
647: return varchar2 is
648: l_sel_clause varchar2(5000);
649: begin
650: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim

Line 987: l_bucket_rec bis_bucket_pub.bis_bucket_rec_type;

983: l_where_clause varchar2(2000);
984: l_mv varchar2(30);
985: l_view_by_value varchar2(30);
986: err_cde number;
987: l_bucket_rec bis_bucket_pub.bis_bucket_rec_type;
988: begin
989: l_comparison_type := 'Y';
990: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
991: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();

Line 1076: , p_bucket_rec in BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE)

1072: end;
1073:
1074: function get_req_age_sel_clause(p_view_by_dim in varchar2
1075: ,p_view_by_col in varchar2
1076: , p_bucket_rec in BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE)
1077: return varchar2 is
1078: l_sel_clause varchar2(5000);
1079: begin
1080: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim