DBA Data[Home] [Help]

APPS.POA_DBI_UPR_PKG dependencies on BIS_BUCKET_PUB

Line 9: , p_bucket_rec in BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE)

5: FUNCTION get_status_sel_clause(p_view_by_dim in VARCHAR2
6: ,p_view_by_col in VARCHAR2) return VARCHAR2;
7: FUNCTION get_amt_sel_clause(p_view_by_dim in VARCHAR2
8: ,p_view_by_col in VARCHAR2
9: , p_bucket_rec in BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE)
10: return VARCHAR2;
11:
12: FUNCTION get_sum_sel_clause(p_view_by_dim in VARCHAR2
13: ,p_view_by_col in VARCHAR2) return VARCHAR2;

Line 16: ,p_bucket_rec in BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE)

12: FUNCTION get_sum_sel_clause(p_view_by_dim in VARCHAR2
13: ,p_view_by_col in VARCHAR2) return VARCHAR2;
14: FUNCTION get_age_sel_clause( p_view_by_dim in VARCHAR2
15: ,p_view_by_col in VARCHAR2
16: ,p_bucket_rec in BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE)
17: return VARCHAR2;
18: FUNCTION get_status_filter_where(p_view_by IN VARCHAR2) return VARCHAR2;
19: FUNCTION get_amt_filter_where(p_view_by IN VARCHAR2) return VARCHAR2;
20: FUNCTION get_age_filter_where(p_view_by IN VARCHAR2) return VARCHAR2;

Line 276: l_bucket_rec BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE;

272: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;
273: l_where_clause VARCHAR2(2000);
274: l_mv VARCHAR2(30);
275: l_view_by_value varchar2(30);
276: l_bucket_rec BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE;
277: ERR_MSG VARCHAR2(100);
278: ERR_CDE NUMBER;
279:
280: BEGIN

Line 387: , p_bucket_rec in BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE)

383: end;
384:
385: FUNCTION get_amt_sel_clause(p_view_by_dim in VARCHAR2
386: ,p_view_by_col in VARCHAR2
387: , p_bucket_rec in BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE)
388: return VARCHAR2
389: IS
390: l_sel_clause varchar2(8000);
391:

Line 603: l_bucket_rec BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE;

599: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;
600: l_where_clause VARCHAR2(2000);
601: l_mv VARCHAR2(30);
602: l_view_by_value varchar2(30);
603: l_bucket_rec BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE;
604: ERR_MSG VARCHAR2(100);
605: ERR_CDE NUMBER;
606:
607: BEGIN

Line 693: , p_bucket_rec in BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE)

689:
690:
691: FUNCTION get_age_sel_clause(p_view_by_dim in VARCHAR2
692: ,p_view_by_col in VARCHAR2
693: , p_bucket_rec in BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE)
694: return VARCHAR2
695: IS
696: l_sel_clause varchar2(4000);
697: