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.
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;
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.
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.
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;
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:
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;