APPS.IBW_BI_VST_CMP_KPI_PVT dependencies on BIS_QUERY_ATTRIBUTES

Line 21: x_custom_output OUT NOCOPY bis_query_attributes_TBL )

17:
18: PROCEDURE GET_VISTR_CONV_TRND_SQL(
19: p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,
20: x_custom_sql OUT NOCOPY VARCHAR2,
21: x_custom_output OUT NOCOPY bis_query_attributes_TBL )
22: IS
23: -- Generic Variables
24:
25: l_custom_sql VARCHAR2(15000) ; --Final Sql.

Line 36: l_custom_rec BIS_QUERY_ATTRIBUTES;

32: l_view_by VARCHAR2(3200); -- View By Not required for this report
33: l_rec_id NUMBER;
34: l_table_list VARCHAR2(3200) ;
35: l_outer_where_clause VARCHAR2(3200) ;
36: l_custom_rec BIS_QUERY_ATTRIBUTES;
37: l_dimension_id NUMBER;
38: l_dimension_view VARCHAR2(3200) ;
39: l_dim_where VARCHAR2(3200);
40: l_group_by VARCHAR2(1000);

Line 298: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

294:
295: x_custom_sql := l_custom_sql;
296:
297:
298: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
299: x_custom_output.Extend(3);
300:
301: l_custom_rec.attribute_name := ':l_currency' ;
302: l_custom_rec.attribute_value:= l_currency;

Line 353: x_custom_output OUT NOCOPY bis_query_attributes_TBL )

349: */
350: PROCEDURE GET_VISIT_TREND_SQL(
351: p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,
352: x_custom_sql OUT NOCOPY VARCHAR2,
353: x_custom_output OUT NOCOPY bis_query_attributes_TBL )
354: IS
355: -- Generic Variables
356:
357: l_custom_sql VARCHAR2(15000) ; --Final Sql.

Line 369: l_custom_rec BIS_QUERY_ATTRIBUTES;

365: l_rec_id NUMBER;
366: l_table_list VARCHAR2(3200) ;
367: l_inner_where_clause VARCHAR2(3200) ;
368: l_outer_where_clause VARCHAR2(3200) ;
369: l_custom_rec BIS_QUERY_ATTRIBUTES;
370: l_dimension_id NUMBER;
371: l_dimension_view VARCHAR2(3200);
372: l_dim_where VARCHAR2(3200);
373: l_group_by VARCHAR2(1000);

Line 663: , x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL

659:
660: PROCEDURE GET_WEB_CAMPAIGN_SQL --- change name to campaign_nontrend_sql
661: ( p_param IN BIS_PMV_PAGE_PARAMETER_TBL
662: , x_custom_sql OUT NOCOPY VARCHAR2
663: , x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
664: )
665: IS
666: --Generic Variables
667: l_custom_sql VARCHAR2(15000) ; --Final Sql.

Line 680: l_custom_rec BIS_QUERY_ATTRIBUTES;

676: l_from VARCHAR2(32000) ;
677: l_where VARCHAR2(32000) ;
678: l_outer_select VARCHAR2(30000) ;
679: l_inner_select VARCHAR2(30000) ;
680: l_custom_rec BIS_QUERY_ATTRIBUTES;
681: l_dimension_id NUMBER ;
682: l_dimension_view VARCHAR2(3200) ;
683: l_dim_where VARCHAR2(3200) ;
684: l_view_by_name VARCHAR2(100) ; --Either Campaign or Site

Line 940: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

936: -- Out parameters
937:
938: x_custom_sql := l_custom_sql;
939:
940: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
941:
942:
943: l_custom_rec.attribute_name := ':l_currency' ;
944: l_custom_rec.attribute_value:= l_currency;

Line 994: x_custom_output OUT NOCOPY bis_query_attributes_TBL )

990:
991: PROCEDURE GET_KPI_SQL(
992: p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,
993: x_custom_sql OUT NOCOPY VARCHAR2,
994: x_custom_output OUT NOCOPY bis_query_attributes_TBL )
995: IS
996:
997: -- Generic Variables
998:

Line 1013: l_custom_rec BIS_QUERY_ATTRIBUTES;

1009: l_rec_id NUMBER;
1010: l_table_list VARCHAR2(3200) ;
1011: l_inner_where_clause VARCHAR2(3200) ; --??????
1012: l_outer_where_clause VARCHAR2(3200) ; --?????
1013: l_custom_rec BIS_QUERY_ATTRIBUTES;
1014: l_dimension_id NUMBER;
1015: l_dimension_view VARCHAR2(3200);
1016: l_dim_where VARCHAR2(3200);
1017: l_group_by VARCHAR2(1000);

Line 1266: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

1262: x_custom_sql := l_custom_sql1 ||l_custom_sql2;
1263:
1264:
1265:
1266: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
1267: x_custom_output.Extend(3);
1268:
1269: l_custom_rec.attribute_name := ':l_currency' ;
1270: l_custom_rec.attribute_value:= l_currency;