15:
16: PROCEDURE get_page_int_sql
17: ( p_param IN BIS_PMV_PAGE_PARAMETER_TBL
18: , x_custom_sql OUT NOCOPY VARCHAR2
19: , x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
20: )
21: IS
22: --Generic Variables
23: l_custom_sql VARCHAR2(15000) ; --Final Sql.
591: x_custom_sql := l_custom_sql; --This sql is returned back to the PMV.
592:
593:
594: --Build the Tokens
595: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
596:
597: l_custom_rec.attribute_name := ':l_grouping_id' ;
598: l_custom_rec.attribute_value:= l_grouping_id;
599: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
636: PROCEDURE get_page_int_trend_sql
637: (
638: p_param IN BIS_PMV_PAGE_PARAMETER_TBL
639: , x_custom_sql OUT NOCOPY VARCHAR2
640: , x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
641: ) IS
642:
643: --Generic Variables
644: l_custom_sql VARCHAR2(15000) ; --Final Sql.
990:
991: x_custom_sql := l_custom_sql;
992:
993:
994: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
995:
996: EXCEPTION
997: WHEN OTHERS THEN
998: if (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then