APPS.POA_DBI_PR_PKG dependencies on BIS_BUCKET_PUB

Line 18: p_bucket_rec in BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE

14:
15: function get_amt_sel_clause(
16: p_view_by_dim in varchar2,
17: p_view_by_col in varchar2,
18: p_bucket_rec in BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE
19: ) return VARCHAR2;
20:
21: function get_age_sel_clause(
22: p_view_by_dim in varchar2,

Line 24: p_bucket_rec in BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE

20:
21: function get_age_sel_clause(
22: p_view_by_dim in varchar2,
23: p_view_by_col in varchar2,
24: p_bucket_rec in BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE
25: ) return VARCHAR2;
26:
27: function get_amt_trend_sel_clause return varchar2;
28: function get_age_trend_sel_clause return varchar2;

Line 562: l_bucket_rec BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE;

558: l_join_rec poa_dbi_util_pkg.poa_dbi_join_rec;
559: l_where_clause varchar2(2000);
560: l_mv varchar2(30);
561: l_view_by_value varchar2(30);
562: l_bucket_rec BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE;
563: err_msg varchar2(100);
564: err_cde number;
565: begin
566: l_comparison_type := 'Y';

Line 649: p_bucket_rec in BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE

645:
646: function get_amt_sel_clause(
647: p_view_by_dim in varchar2,
648: p_view_by_col in varchar2,
649: p_bucket_rec in BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE
650: )
651: return varchar2 is
652: l_sel_clause varchar2(4000);
653: begin

Line 834: l_bucket_rec BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE;

830: l_join_rec poa_dbi_util_pkg.poa_dbi_join_rec;
831: l_where_clause varchar2(2000);
832: l_mv varchar2(30);
833: l_view_by_value varchar2(30);
834: l_bucket_rec BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE;
835: err_msg varchar2(100);
836: err_cde number;
837: begin
838: l_comparison_type := 'Y';

Line 927: , p_bucket_rec in BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE)

923:
924:
925: function get_age_sel_clause(p_view_by_dim in varchar2
926: ,p_view_by_col in varchar2
927: , p_bucket_rec in BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE)
928: return varchar2 is
929: l_sel_clause varchar2(6000);
930: begin
931: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim