APPS.IBW_BI_PAGE_INT_PVT dependencies on BIS_QUERY_ATTRIBUTES

Line 19: , x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL

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.

Line 66: l_custom_rec BIS_QUERY_ATTRIBUTES;

62: l_where_q2 VARCHAR2(3000);
63: l_group_by_q2 VARCHAR2(3000);
64:
65:
66: l_custom_rec BIS_QUERY_ATTRIBUTES;
67: l_inner_group_by VARCHAR2(3200);
68: l_having VARCHAR2(3200);
69: l_grouping_id NUMBER;
70:

Line 595: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

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;

Line 640: , x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL

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.

Line 653: l_custom_rec BIS_QUERY_ATTRIBUTES;

649: l_view_by VARCHAR2(3200); --Either Site Area Name or Page Name
650: l_from VARCHAR2(3200) ;
651: l_where VARCHAR2(3200) ;
652: l_select_col_name VARCHAR2(100);
653: l_custom_rec BIS_QUERY_ATTRIBUTES;
654:
655:
656: --Un wanted Variables
657: l_referral VARCHAR2(3200) ; -- Referral Dimension

Line 994: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

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