APPS.POA_DBI_RET_PKG dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 11: PROCEDURE status_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL

7: FUNCTION get_trend_sel_clause return VARCHAR2;
8: FUNCTION get_status_filter_where(p_view_by IN VARCHAR2) return VARCHAR2;
9: FUNCTION get_retdist_filter_where(p_view_by IN VARCHAR2) return VARCHAR2;
10:
11: PROCEDURE status_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL
12: ,x_custom_sql OUT NOCOPY VARCHAR2
13: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
14: IS
15: l_query varchar2(32000);

Line 268: PROCEDURE rtn_rsn_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,

264: ' || poa_dbi_util_pkg.rate_clause('p_cnt_receipt_return_total','p_cnt_receipt_total') || ' POA_MEASURE19 ';
265: return l_sel_clause;
266: END;
267: --
268: PROCEDURE rtn_rsn_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
269: x_custom_sql OUT NOCOPY VARCHAR2,
270: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
271: IS
272: l_query varchar2(10000);

Line 454: PROCEDURE trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,

450: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
451:
452: END;
453:
454: PROCEDURE trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
455: x_custom_sql OUT NOCOPY VARCHAR2,
456: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
457: IS
458: l_query varchar2(10000);

Line 554: PROCEDURE kpi_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,

550: x_custom_sql := l_query;
551:
552: END;
553:
554: PROCEDURE kpi_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
555: x_custom_sql OUT NOCOPY VARCHAR2,
556: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
557: IS
558: l_query varchar2(10000);