30: FUNCTION get_doctype_filter_where return VARCHAR2;
31: FUNCTION get_doctype_sel_clause(p_view_by_col_name in VARCHAR2, p_url in VARCHAR2)
32: return VARCHAR2;
33:
34: PROCEDURE status_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
35: x_custom_sql OUT NOCOPY VARCHAR2,
36: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
37: IS
38: l_query varchar2(10000);
376: return l_sel_clause;
377: END;
378:
379:
380: PROCEDURE con_rpt_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
381: x_custom_sql OUT NOCOPY VARCHAR2,
382: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
383: IS
384: l_query varchar2(10000);
671: return l_sel_clause;
672: END;
673:
674:
675: PROCEDURE ncp_rpt_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
676: x_custom_sql OUT NOCOPY VARCHAR2,
677: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
678: IS
679: l_query varchar2(10000);
980:
981: return l_sel_clause;
982: END;
983:
984: PROCEDURE pcl_rpt_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
985: x_custom_sql OUT NOCOPY VARCHAR2,
986: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
987: IS
988: l_query varchar2(10000);
1297: return l_sel_clause;
1298: END;
1299:
1300:
1301: PROCEDURE pop_trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
1302: x_custom_sql OUT NOCOPY VARCHAR2,
1303: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1304: IS
1305: l_query varchar2(10000);
1477:
1478: return l_sel_clause;
1479: end;
1480:
1481: PROCEDURE trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
1482: x_custom_sql OUT NOCOPY VARCHAR2,
1483: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1484: IS
1485: l_query varchar2(10000);
1666: return l_sel_clause;
1667: END;
1668:
1669:
1670: PROCEDURE kpi_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
1671: x_custom_sql OUT NOCOPY VARCHAR2,
1672: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1673: IS
1674: l_query varchar2(10000);
1925: x_custom_sql := l_query;
1926: end;
1927:
1928:
1929: PROCEDURE pie_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
1930: x_custom_sql OUT NOCOPY VARCHAR2,
1931: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1932: IS
1933: l_query varchar2(10000);
2235:
2236: END;
2237:
2238:
2239: PROCEDURE doctype_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
2240: x_custom_sql OUT NOCOPY VARCHAR2,
2241: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
2242: IS
2243: l_query varchar2(10000);