APPS.POA_DBI_UFR_PKG dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 25: PROCEDURE status_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,

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;
23:
24:
25: PROCEDURE status_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
26: x_custom_sql OUT NOCOPY VARCHAR2,
27: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
28: IS
29: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

Line 254: PROCEDURE amt_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,

250:
251: END;
252:
253:
254: PROCEDURE amt_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
255: x_custom_sql OUT NOCOPY VARCHAR2,
256: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
257: IS
258: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

Line 534: PROCEDURE sum_rpt_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,

530:
531: END;
532:
533:
534: PROCEDURE sum_rpt_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
535: x_custom_sql OUT NOCOPY VARCHAR2,
536: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
537: IS
538: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

Line 765: PROCEDURE age_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,

761: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
762:
763: END;
764:
765: PROCEDURE age_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
766: x_custom_sql OUT NOCOPY VARCHAR2,
767: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
768: IS
769: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

Line 1033: PROCEDURE dtl_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,

1029:
1030: END;
1031:
1032:
1033: PROCEDURE dtl_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
1034: x_custom_sql OUT NOCOPY VARCHAR2,
1035: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1036: IS
1037: l_query varchar2(10000);