eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POA_DBI_UFR_PKG dependencies on BIS_BUCKET_PUB

Line 8: , p_bucket_rec in BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE) return VARCHAR2;

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

Line 18: , p_bucket_rec in BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE) return VARCHAR2;

14: ,p_view_by_col in VARCHAR2) return VARCHAR2;
15: FUNCTION get_age_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) return VARCHAR2;
19: FUNCTION get_status_filter_where(p_view_by IN VARCHAR2) return VARCHAR2;
20: FUNCTION get_amt_filter_where(p_view_by IN VARCHAR2) return VARCHAR2;
21: FUNCTION get_age_filter_where(p_view_by IN VARCHAR2) return VARCHAR2;
22: FUNCTION get_sum_rpt_filter_where(p_view_by IN VARCHAR2) return VARCHAR2;

Line 274: l_bucket_rec BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE;

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

Line 357: , p_bucket_rec in BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE)

353:
354: FUNCTION get_amt_sel_clause(
355: p_view_by_dim in VARCHAR2
356: , p_view_by_col in VARCHAR2
357: , p_bucket_rec in BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE)
358:
359: return VARCHAR2
360: IS
361: l_sel_clause varchar2(4000);

Line 785: l_bucket_rec BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE;

781: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;
782: l_where_clause VARCHAR2(2000);
783: l_mv VARCHAR2(30);
784: l_view_by_value varchar2(30);
785: l_bucket_rec BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE;
786: ERR_MSG VARCHAR2(100);
787: ERR_CDE NUMBER;
788: BEGIN
789: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();

Line 869: , p_bucket_rec in BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE)

865:
866: FUNCTION get_age_sel_clause(
867: p_view_by_dim in VARCHAR2
868: , p_view_by_col in VARCHAR2
869: , p_bucket_rec in BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE)
870:
871: return VARCHAR2
872: IS
873: l_sel_clause varchar2(4000);